Hi Thomas, Thanks for taking a look at this promptly.
On Wed, 7 Apr 2021 at 16:17, Thomas Munro <thomas.mu...@gmail.com> wrote: > On Wed, Apr 7, 2021 at 5:44 PM Robins Tharakan <thara...@gmail.com> wrote: > > It is interesting that that commit's a month old and probably no other client has complained since, but diving in, I can see that it's been unable to even start regression tests after that commit went in. > > Oh, well at least it's easily reproducible then, that's something! Correct. This is easily reproducible on this test-instance, so let me know if you want me to test a patch. > > That's actually the client. I guess there is also a backend process > stuck somewhere in epoll_wait()? You're right (and yes my bad, I was looking at the client). The server process is stuck in epoll_wait(). Let me know if you need me to give any other info that may be helpful. root@WSLv1:~# gdb -batch -ex bt -p 29887 [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". 0x00007fa087741a07 in epoll_wait (epfd=10, events=0x7fffcbcc5748, maxevents=maxevents@entry=1, timeout=timeout@entry=-1) at ../sysdeps/unix/sysv/linux/epoll_wait.c:30 30 ../sysdeps/unix/sysv/linux/epoll_wait.c: No such file or directory. #0 0x00007fa087741a07 in epoll_wait (epfd=10, events=0x7fffcbcc5748, maxevents=maxevents@entry=1, timeout=timeout@entry=-1) at ../sysdeps/unix/sysv/linux/epoll_wait.c:30 #1 0x00007fa088c355dc in WaitEventSetWaitBlock (nevents=1, occurred_events=0x7fffd2d4c090, cur_timeout=-1, set=0x7fffcbcc56e8) at latch.c:1428 #2 WaitEventSetWait (set=0x7fffcbcc56e8, timeout=timeout@entry=-1, occurred_events=occurred_events@entry=0x7fffd2d4c090, nevents=nevents@entry=1, wait_event_info=wait_ev #3 0x00007fa088c35a14 in WaitLatch (latch=<optimized out>, wakeEvents=wakeEvents@entry=33, timeout=timeout@entry=-1, wait_event_info=wait_event_info@entry=134217733) at #4 0x00007fa088c43ed8 in ConditionVariableTimedSleep (cv=0x7fa0873cc498, timeout=-1, wait_event_info=134217733) at condition_variable.c:163 #5 0x00007fa088bba8bc in RequestCheckpoint (flags=flags@entry=44) at checkpointer.c:1017 #6 0x00007fa088a46315 in createdb (pstate=pstate@entry=0x7fffcbcebbc0, stmt=stmt@entry=0x7fffcbcca558) at dbcommands.c:711 . . . - robins
