When I hit a query timeout in Lucee (lucee-light@5...
# luceem
mjclemente
06/05/2023, 2:37 PMWhen I hit a query timeout in Lucee (lucee-light@5.3.10+120), I'm seeing the following in the logs:
Copy code
ERROR: canceling statement due to user request;lucee.runtime.exp.DatabaseExceptionmjclemente
06/05/2023, 2:37 PMis there a way I get can the query timeout to include more information?
mjclemente
06/05/2023, 2:39 PM(we've got FR hooked, up, so I know I can track it down that way, but I'm generally monitoring the logs on a daily basis, so if there were more info to point me in the right direction, that would be helpful)
c
ChaseCabrera
06/05/2023, 2:41 PMWe set out page timeout (60 seconds) to below our query timeout (30 seconds) so we can get dump for this specific issue. But would be interested in another approach.
m
mjclemente
06/05/2023, 2:43 PM(to make sure I understand what you're saying) so you lower the page time out to, for example, 28, so it's triggered before the query timeout (30), in order to get more information about what's running slow?
c
ChaseCabrera
06/05/2023, 3:18 PMCorrect
z
zackster
06/05/2023, 3:19 PManything at the bottom of the stacktrace in caused by?
c
ChaseCabrera
06/05/2023, 3:19 PMSorry for the delayed response! coffee refill haha
m
mjclemente
06/05/2023, 3:23 PMno stack here - it's bubbling up to the application onError handler, which is logging the error message, type, and exception.rootcause.message
z
zackster
06/05/2023, 3:26 PMcould be this https://luceeserver.atlassian.net/browse/LDEV-4311
m
mjclemente
06/05/2023, 3:27 PMinteresting! I'll take a look at that - thanks @zackster!
2 Views