If request timeout is lower than query execution time. Request execution won't finish.
And sometimes, query will be executed several times.
Why I can’t change issue type? Change it to Bug please.
I've checked this ticket and confirmed the issue happened on lucee latest version 126.96.36.199-SNAPSHOT also. But there are no duplicates created while running the query, only long execution time only.
Sorry, wrong example, I checked with MSSQL profiler - “SELECT“ request will be sent several times (4 times), Maybe we should check if it is not reproduced with other query types. (update, select into, …)