Re: buildfarm instance bichir stuck - Mailing list pgsql-hackers

From Robins Tharakan
Subject Re: buildfarm instance bichir stuck
Date
Msg-id CAEP4nAxT4hTd8_JmEE_j1udR58xoXVvOWu-jSTUmrz=CMRfUjA@mail.gmail.com
Whole thread Raw
In response to Re: buildfarm instance bichir stuck  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: buildfarm instance bichir stuck  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-hackers
Hi Thomas,

Thanks for taking a look at this promptly.


On Wed, 7 Apr 2021 at 16:17, Thomas Munro <thomas.munro@gmail.com> wrote:
> On Wed, Apr 7, 2021 at 5:44 PM Robins Tharakan <tharakan@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

pgsql-hackers by date:

Previous
From: Amul Sul
Date:
Subject: Re: [Patch] ALTER SYSTEM READ ONLY
Next
From: Ajin Cherian
Date:
Subject: missing documentation for streaming in-progress transactions