Re: Why is parula failing? - Mailing list pgsql-hackers
From | Robins Tharakan |
---|---|
Subject | Re: Why is parula failing? |
Date | |
Msg-id | CAEP4nAxQhdUM4qF4o_5sfP_TyTq09enzo5KCs4W2t7-VmDYnUQ@mail.gmail.com Whole thread Raw |
In response to | Re: Why is parula failing? (Robins Tharakan <tharakan@gmail.com>) |
Responses |
Re: Why is parula failing?
|
List | pgsql-hackers |
On Mon, 8 Apr 2024 at 21:25, Robins Tharakan <tharakan@gmail.com> wrote:
>
>
> I'll keep an eye on this instance more often for the next few days.
> (Let me know if I could capture more if a run gets stuck again)
HEAD is stuck again on pg_sleep(), no CPU for the past hour or so.
Stack trace seems to be similar to last time.
$ pstack 24930
#0 0x0000ffffb8280954 in epoll_pwait () from /lib64/libc.so.6
#1 0x0000000000843408 in WaitEventSetWaitBlock (nevents=1, occurred_events=<optimized out>, cur_timeout=600000, set=0x3b38dac0) at latch.c:1570
#2 WaitEventSetWait (set=0x3b38dac0, timeout=timeout@entry=600000, occurred_events=occurred_events@entry=0xfffffd1d66c8, nevents=nevents@entry=1, wait_event_info=wait_event_info@entry=150994946) at latch.c:1516
#3 0x00000000008437c4 in WaitLatch (latch=<optimized out>, wakeEvents=wakeEvents@entry=41, timeout=600000, wait_event_info=wait_event_info@entry=150994946) at latch.c:538
#4 0x000000000090c384 in pg_sleep (fcinfo=<optimized out>) at misc.c:406
#5 0x0000000000699350 in ExecInterpExpr (state=0x3b5a41a0, econtext=0x3b5a3f98, isnull=<optimized out>) at execExprInterp.c:764
#6 0x00000000006d1668 in ExecEvalExprSwitchContext (isNull=0xfffffd1d683f, econtext=0x3b5a3f98, state=<optimized out>) at ../../../src/include/executor/executor.h:356
#7 ExecProject (projInfo=<optimized out>) at ../../../src/include/executor/executor.h:390
#8 ExecResult (pstate=<optimized out>) at nodeResult.c:135
#9 0x00000000006ba26c in ExecProcNode (node=0x3b5a3e88) at ../../../src/include/executor/executor.h:274
#10 gather_getnext (gatherstate=0x3b5a3c98) at nodeGather.c:287
#11 ExecGather (pstate=0x3b5a3c98) at nodeGather.c:222
#12 0x000000000069d28c in ExecProcNode (node=0x3b5a3c98) at ../../../src/include/executor/executor.h:274
#13 ExecutePlan (execute_once=<optimized out>, dest=0x3b5ae8e0, direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>, operation=CMD_SELECT, use_parallel_mode=<optimized out>, planstate=0x3b5a3c98, estate=0x3b5a3a70) at execMain.c:1646
#14 standard_ExecutorRun (queryDesc=0x3b59c250, direction=<optimized out>, count=0, execute_once=<optimized out>) at execMain.c:363
#15 0x00000000008720e4 in PortalRunSelect (portal=portal@entry=0x3b410fb0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x3b5ae8e0) at pquery.c:924
#16 0x0000000000873900 in PortalRun (portal=portal@entry=0x3b410fb0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x3b5ae8e0, altdest=altdest@entry=0x3b5ae8e0, qc=qc@entry=0xfffffd1d6bf0) at pquery.c:768
#17 0x000000000086f5d4 in exec_simple_query (query_string=query_string@entry=0x3b391c90 "SELECT pg_sleep(0.1);") at postgres.c:1274
#18 0x0000000000870110 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4680
#19 0x000000000086b6a0 in BackendMain (startup_data=<optimized out>, startup_data_len=<optimized out>) at backend_startup.c:105
#20 0x00000000007c6268 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0xfffffd1d70b8 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0xfffffd1d70c0) at launch_backend.c:265
#21 0x00000000007c9c50 in BackendStartup (client_sock=0xfffffd1d70c0) at postmaster.c:3593
#22 ServerLoop () at postmaster.c:1674
#23 0x00000000007cb8f8 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x3b38d320) at postmaster.c:1372
#24 0x0000000000496e18 in main (argc=8, argv=0x3b38d320) at main.c:197
CPU% MEM% TIME+ Command
.
.
0.0 0.0 0:00.00 │ └─ /bin/sh -c cd /opt/postgres/build-farm-14 && PATH=/opt/gcc/home/ec2-user/proj/gcc/target/bin/
0.0 0.1 0:00.07 │ └─ /usr/bin/perl ./run_build.pl --config=build-farm.conf HEAD --verbose
0.0 0.0 0:00.00 │ └─ sh -c { cd pgsql.build/src/test/regress && make NO_LOCALE=1 check; echo $? > /opt/postg
0.0 0.0 0:00.00 │ └─ make NO_LOCALE=1 check
0.0 0.0 0:00.00 │ └─ /bin/sh -c echo "# +++ regress check in src/test/regress +++" && PATH="/opt/postg
0.0 0.0 0:00.10 │ └─ ../../../src/test/regress/pg_regress --temp-instance=./tmp_check --inputdir=.
0.0 0.0 0:00.01 │ ├─ psql -X -a -q -d regression -v HIDE_TABLEAM=on -v HIDE_TOAST_COMPRESSION=on
0.0 0.1 0:02.64 │ └─ postgres -D /opt/postgres/build-farm-14/buildroot/HEAD/pgsql.build/src/test
0.0 0.2 0:00.05 │ ├─ postgres: postgres regression [local] SELECT
0.0 0.0 0:00.06 │ ├─ postgres: logical replication launcher
0.0 0.1 0:00.36 │ ├─ postgres: autovacuum launcher
0.0 0.1 0:00.34 │ ├─ postgres: walwriter
0.0 0.0 0:00.32 │ ├─ postgres: background writer
0.0 0.3 0:00.05 │ └─ postgres: checkpointer
-
robins
pgsql-hackers by date: