> On Jul 14, 2025, at 10:42, Arnt Gulbrandsen <[email protected]> wrote: > > Hi, > > what happens to such a query? If you log in via the postgres console and > issue something like "begin; select mailbox_messages for update;" and then > wait for a minute or two, most of aox' queries should time out. Is anything > logged? Can you try? > > Arnt >
set it to 500ms to test On the console it shows: archiveopteryx=> select * from bodyparts where data LIKE '%foobaazzzr%'; ERROR: canceling statement due to statement timeout In the logs it shows: [14-2] 2025-07-14 17:53:02.936 UTC [77665] STATEMENT: select * from bodyparts where data LIKE '%foobaazzzr%';" [14-1] 2025-07-14 17:53:02.937 UTC [70678] LOG: background worker \"parallel worker\" (PID 77368) exited with exit code 1" [15-1] 2025-07-14 17:53:02.938 UTC [70678] LOG: background worker \"parallel worker\" (PID 77164) exited with exit code 1" [16-1] 2025-07-14 17:53:02.947 UTC [70678] LOG: background worker \"parallel worker\" (PID 77665) exited with exit code 1" Mark
