Re: buildfarm instance bichir stuck

Hi Thomas,

Thanks for taking a look at this promptly.

On Wed, 7 Apr 2021 at 16:17, Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> On Wed, Apr 7, 2021 at 5:44 PM Robins Tharakan <tharakan(at)gmail(dot)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(at)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(at)entry=1, timeout=timeout(at)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(at)entry=1, timeout=timeout(at)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(at)entry=-1,
occurred_events=occurred_events(at)entry=0x7fffd2d4c090, nevents=nevents(at)entry=1,
wait_event_info=wait_ev
#3 0x00007fa088c35a14 in WaitLatch (latch=<optimized out>,
wakeEvents=wakeEvents(at)entry=33, timeout=timeout(at)entry=-1,
wait_event_info=wait_event_info(at)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(at)entry=44) at
checkpointer.c:1017
#6 0x00007fa088a46315 in createdb (pstate=pstate(at)entry=0x7fffcbcebbc0,
stmt=stmt(at)entry=0x7fffcbcca558) at dbcommands.c:711
.
.
.

-
robins