On Sun, 14 Apr 2024 at 00:12, Tom Lane <t...@sss.pgh.pa.us> wrote: > If we were only supposed to sleep 0.1 seconds, how is it waiting > for 600000 ms (and, presumably, repeating that)? The logic in > pg_sleep is pretty simple, and it's hard to think of anything except > the system clock jumping (far) backwards that would make this > happen. Any chance of extracting the local variables from the > pg_sleep stack frame?
- I now have 2 separate runs stuck on pg_sleep() - HEAD / REL_16_STABLE - I'll keep them (stuck) for this week, in case there's more we can get from them (and to see how long they take) - Attached are 'bt full' outputs for both (b.txt - HEAD / a.txt - REL_16_STABLE) A few things to add: - To reiterate, this instance has gcc v13.2 compiled without any flags (my first time ever TBH) IIRC 'make -k check' came out okay, so at this point I don't think I did something obviously wrong when building gcc from git. - I installed gcc v14.0.1 experimental on massasauga (also an aarch64 and built from git) and despite multiple runs, it seems to be doing okay [1]. - Next week (if I'm still scratching my head - and unless someone advises otherwise), I'll upgrade parula to gcc 14 experimental to see if this is about gcc maturity on graviton (for some reason). I don't expect much to come out of it though (given Tomas testing on rpi5, but doesn't hurt) Ref: 1. https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=massasauga&br=REL_12_STABLE - robins
[postgres@ip-172-31-18-25 ~]$ pstack 26147 #0 0x0000ffffadeda954 in epoll_pwait () from /lib64/libc.so.6 #1 0x0000000000842888 in WaitEventSetWaitBlock (nevents=1, occurred_events=<optimized out>, cur_timeout=600000, set=0x3148fac0) at latch.c:1570 #2 WaitEventSetWait (set=0x3148fac0, timeout=timeout@entry=600000, occurred_events=occurred_events@entry=0xffffd1194748, nevents=nevents@entry=1, wait_event_info=wait_event_info@entry=150994946) at latch.c:1516 #3 0x0000000000842c44 in WaitLatch (latch=<optimized out>, wakeEvents=wakeEvents@entry=41, timeout=600000, wait_event_info=wait_event_info@entry=150994946) at latch.c:538 #4 0x000000000090b7b4 in pg_sleep (fcinfo=<optimized out>) at misc.c:406 #5 0x0000000000698430 in ExecInterpExpr (state=0x316a6040, econtext=0x316a5e38, isnull=<optimized out>) at execExprInterp.c:764 #6 0x00000000006d0898 in ExecEvalExprSwitchContext (isNull=0xffffd11948bf, econtext=0x316a5e38, 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 0x00000000006b92ec in ExecProcNode (node=0x316a5d28) at ../../../src/include/executor/executor.h:274 #10 gather_getnext (gatherstate=0x316a5b38) at nodeGather.c:287 #11 ExecGather (pstate=0x316a5b38) at nodeGather.c:222 #12 0x000000000069c36c in ExecProcNode (node=0x316a5b38) at ../../../src/include/executor/executor.h:274 #13 ExecutePlan (execute_once=<optimized out>, dest=0x31641e90, direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>, operation=CMD_SELECT, use_parallel_mode=<optimized out>, planstate=0x316a5b38, estate=0x316a5910) at execMain.c:1646 #14 standard_ExecutorRun (queryDesc=0x316459c0, direction=<optimized out>, count=0, execute_once=<optimized out>) at execMain.c:363 #15 0x0000000000871564 in PortalRunSelect (portal=portal@entry=0x31512fb0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x31641e90) at pquery.c:924 #16 0x0000000000872d80 in PortalRun (portal=portal@entry=0x31512fb0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x31641e90, altdest=altdest@entry=0x31641e90, qc=qc@entry=0xffffd1194c70) at pquery.c:768 #17 0x000000000086ea54 in exec_simple_query (query_string=query_string@entry=0x31493c90 "SELECT pg_sleep(0.1);") at postgres.c:1274 #18 0x000000000086f590 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4680 #19 0x000000000086ab20 in BackendMain (startup_data=<optimized out>, startup_data_len=<optimized out>) at backend_startup.c:105 #20 0x00000000007c54d8 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0xffffd1195138 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0xffffd1195140) at launch_backend.c:265 #21 0x00000000007c8ec0 in BackendStartup (client_sock=0xffffd1195140) at postmaster.c:3593 #22 ServerLoop () at postmaster.c:1674 #23 0x00000000007cab68 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x3148f320) at postmaster.c:1372 #24 0x0000000000496cb8 in main (argc=8, argv=0x3148f320) at main.c:197 [postgres@ip-172-31-18-25 ~]$ 2072 root 20 0 117M 4376 3192 S 0.0 0.0 0:00.00 â ââ /usr/sbin/CROND -n 2087 postgres 20 0 20988 6496 5504 S 0.0 0.0 0:00.00 â ââ /usr/sbin/sendmail -FCronDaemon -i -odi -oem -oi -t -f postgres 2092 postgres 20 0 20960 6328 5336 S 0.0 0.0 0:00.00 â â ââ /usr/sbin/postdrop -r 2074 postgres 20 0 111M 2660 2488 S 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/:$PATH:/usr/local/bin PERL5LIB=/home/postgres/perl5/lib/perl5 ./run_build.pl --config=build-farm.conf HEAD --verbose 2075 postgres 20 0 128M 18128 3940 S 0.0 0.1 0:00.08 â ââ /usr/bin/perl ./run_build.pl --config=build-farm.conf HEAD --verbose 8751 postgres 20 0 111M 2660 2480 S 0.0 0.0 0:00.00 â ââ sh -c { cd pgsql.build/src/test/regress && make NO_LOCALE=1 check; echo $? > /opt/postgres/build-farm-14/buildroot/HEAD/parula.lastrun-logs/laststatus; } > /opt/postgres/build-farm-14/buildroot/HEAD/parula.lastrun-logs/lastcommand.log 2>&1; read st < /opt/postgres/buil 8752 postgres 20 0 110M 2084 1712 S 0.0 0.0 0:00.00 â ââ make NO_LOCALE=1 check 9947 postgres 20 0 111M 2836 2640 S 0.0 0.0 0:00.00 â ââ /bin/sh -c echo "# +++ regress check in src/test/regress +++" && PATH="/opt/postgres/build-farm-14/buildroot/HEAD/pgsql.build/tmp_install/opt/postgres/build-farm-14/buildroot/HEAD/inst/bin:/opt/postgres/build-farm-14/buildroot/HEAD/pgsql.build/src/test/regress:$P 9948 postgres 20 0 121M 5540 4716 S 0.0 0.0 0:00.08 â ââ ../../../src/test/regress/pg_regress --temp-instance=./tmp_check --inputdir=. --bindir= --temp-config=/tmp/buildfarm-RoyKTG/bfextra.conf --no-locale --port=5678 --dlpath=. --max-concurrent-tests=20 --port=5678 --schedule=./parallel_schedule 26137 postgres 20 0 15448 5636 4816 S 0.0 0.0 0:00.01 â ââ psql -X -a -q -d regression -v HIDE_TABLEAM=on -v HIDE_TOAST_COMPRESSION=on 9960 postgres 20 0 167M 20704 19564 S 0.0 0.1 0:04.08 â ââ postgres -D /opt/postgres/build-farm-14/buildroot/HEAD/pgsql.build/src/test/regress/tmp_check/data -F -c listen_addresses= -k /tmp/pg_regress-wqlrdh 26147 postgres 20 0 172M 41980 37516 S 0.0 0.3 0:00.06 â ââ postgres: postgres regression [local] SELECT 9966 postgres 20 0 170M 8684 7256 S 0.0 0.1 0:00.02 â ââ postgres: logical replication launcher 9965 postgres 20 0 169M 8548 7124 S 0.0 0.1 0:00.20 â ââ postgres: autovacuum launcher 9964 postgres 20 0 167M 10044 8876 S 0.0 0.1 0:00.07 â ââ postgres: walwriter 9962 postgres 20 0 167M 5388 4232 S 0.0 0.0 0:00.05 â ââ postgres: background writer 9961 postgres 20 0 168M 114M 112M S 0.0 0.7 0:00.15 â ââ postgres: checkpointer #0 0x0000ffffadeda954 in epoll_pwait () from /lib64/libc.so.6 No symbol table info available. #1 0x0000000000842888 in WaitEventSetWaitBlock (nevents=1, occurred_events=<optimized out>, cur_timeout=600000, set=0x3148fac0) at latch.c:1570 returned_events = 0 rc = <optimized out> cur_event = <optimized out> cur_epoll_event = <optimized out> __func__ = "WaitEventSetWaitBlock" #2 WaitEventSetWait (set=0x3148fac0, timeout=timeout@entry=600000, occurred_events=occurred_events@entry=0xffffd1194748, nevents=nevents@entry=1, wait_event_info=wait_event_info@entry=150994946) at latch.c:1516 rc = <optimized out> returned_events = 0 start_time = <optimized out> cur_time = <optimized out> cur_timeout = 600000 #3 0x0000000000842c44 in WaitLatch (latch=<optimized out>, wakeEvents=wakeEvents@entry=41, timeout=600000, wait_event_info=wait_event_info@entry=150994946) at latch.c:538 event = {pos = 9484124, events = 0, fd = 1713148331, user_data = 0x44f0b} #4 0x000000000090b7b4 in pg_sleep (fcinfo=<optimized out>) at misc.c:406 delay = <optimized out> delay_ms = <optimized out> endtime = 0 #5 0x0000000000698430 in ExecInterpExpr (state=0x316a6040, econtext=0x316a5e38, isnull=<optimized out>) at execExprInterp.c:764 fcinfo = 0x316a6198 args = 0x316a61b8 nargs = <optimized out> d = <optimized out> op = <optimized out> resultslot = 0x316a5f58 innerslot = 0x0 outerslot = 0x0 scanslot = 0x0 dispatch_table = {0x697590 <ExecInterpExpr+2044>, 0x69728c <ExecInterpExpr+1272>, 0x697268 <ExecInterpExpr+1236>, 0x697244 <ExecInterpExpr+1200>, 0x697208 <ExecInterpExpr+1140>, 0x6978cc <ExecInterpExpr+2872>, 0x697890 <ExecInterpExpr+2812>, 0x697874 <ExecInterpExpr+2784>, 0x697858 <ExecInterpExpr+2756>, 0x69783c <ExecInterpExpr+2728>, 0x697824 <ExecInterpExpr+2704>, 0x6977d4 <ExecInterpExpr+2624>, 0x697784 <ExecInterpExpr+2544>, 0x697734 <ExecInterpExpr+2464>, 0x6976fc <ExecInterpExpr+2408>, 0x6976b4 <ExecInterpExpr+2336>, 0x697694 <ExecInterpExpr+2304>, 0x697664 <ExecInterpExpr+2256>, 0x697620 <ExecInterpExpr+2188>, 0x6975d4 <ExecInterpExpr+2112>, 0x6975bc <ExecInterpExpr+2088>, 0x696dd8 <ExecInterpExpr+68>, 0x696de0 <ExecInterpExpr+76>, 0x697d7c <ExecInterpExpr+4072>, 0x696e00 <ExecInterpExpr+108>, 0x696e08 <ExecInterpExpr+116>, 0x697dc0 <ExecInterpExpr+4140>, 0x697d60 <ExecInterpExpr+4044>, 0x697d1c <ExecInterpExpr+3976>, 0x697d04 <ExecInterpExpr+3952>, 0x697ce0 <ExecInterpExpr+3916>, 0x697cbc <ExecInterpExpr+3880>, 0x697c84 <ExecInterpExpr+3824>, 0x697c68 <ExecInterpExpr+3796>, 0x697c48 <ExecInterpExpr+3764>, 0x697c34 <ExecInterpExpr+3744>, 0x697c20 <ExecInterpExpr+3724>, 0x697bfc <ExecInterpExpr+3688>, 0x697bd4 <ExecInterpExpr+3648>, 0x697bb0 <ExecInterpExpr+3612>, 0x697b88 <ExecInterpExpr+3572>, 0x697b70 <ExecInterpExpr+3548>, 0x697b58 <ExecInterpExpr+3524>, 0x697b3c <ExecInterpExpr+3496>, 0x697b10 <ExecInterpExpr+3452>, 0x697ac8 <ExecInterpExpr+3380>, 0x697a1c <ExecInterpExpr+3208>, 0x697a08 <ExecInterpExpr+3188>, 0x6979dc <ExecInterpExpr+3144>, 0x6979ac <ExecInterpExpr+3096>, 0x697944 <ExecInterpExpr+2992>, 0x697930 <ExecInterpExpr+2972>, 0x698990 <ExecInterpExpr+7164>, 0x69791c <ExecInterpExpr+2952>, 0x697908 <ExecInterpExpr+2932>, 0x698018 <ExecInterpExpr+4740>, 0x697fec <ExecInterpExpr+4696>, 0x697f68 <ExecInterpExpr+4564>, 0x697f24 <ExecInterpExpr+4496>, 0x697f10 <ExecInterpExpr+4476>, 0x697ef8 <ExecInterpExpr+4452>, 0x697ee0 <ExecInterpExpr+4428>, 0x697ec8 <ExecInterpExpr+4404>, 0x697ea8 <ExecInterpExpr+4372>, 0x697e8c <ExecInterpExpr+4344>, 0x697e70 <ExecInterpExpr+4316>, 0x697e54 <ExecInterpExpr+4288>, 0x697ae4 <ExecInterpExpr+3408>, 0x697dfc <ExecInterpExpr+4200>, 0x698128 <ExecInterpExpr+5012>, 0x697e3c <ExecInterpExpr+4264>, 0x697e28 <ExecInterpExpr+4244>, 0x697e10 <ExecInterpExpr+4220>, 0x698114 <ExecInterpExpr+4992>, 0x6980fc <ExecInterpExpr+4968>, 0x6980e8 <ExecInterpExpr+4948>, 0x6980c4 <ExecInterpExpr+4912>, 0x698098 <ExecInterpExpr+4868>, 0x698080 <ExecInterpExpr+4844>, 0x698050 <ExecInterpExpr+4796>, 0x6981b0 <ExecInterpExpr+5148>, 0x698178 <ExecInterpExpr+5092>, 0x698160 <ExecInterpExpr+5068>, 0x69813c <ExecInterpExpr+5032>, 0x696e28 <ExecInterpExpr+148>, 0x696e34 <ExecInterpExpr+160>, 0x697548 <ExecInterpExpr+1972>, 0x697504 <ExecInterpExpr+1904>, 0x6974d8 <ExecInterpExpr+1860>, 0x697418 <ExecInterpExpr+1668>, 0x697360 <ExecInterpExpr+1484>, 0x6972b0 <ExecInterpExpr+1308>, 0x697108 <ExecInterpExpr+884>, 0x697014 <ExecInterpExpr+640>, 0x696f00 <ExecInterpExpr+364>, 0x696fec <ExecInterpExpr+600>, 0x696ed8 <ExecInterpExpr+324>, 0x696eb0 <ExecInterpExpr+284>, 0x696e98 <ExecInterpExpr+260>, 0x698734 <ExecInterpExpr+6560>} #6 0x00000000006d0898 in ExecEvalExprSwitchContext (isNull=0xffffd11948bf, econtext=0x316a5e38, state=<optimized out>) at ../../../src/include/executor/executor.h:356 oldContext = 0x316a5810 #7 ExecProject (projInfo=<optimized out>) at ../../../src/include/executor/executor.h:390 econtext = 0x316a5e38 state = <optimized out> slot = 0x316a5f58 isnull = false #8 ExecResult (pstate=<optimized out>) at nodeResult.c:135 node = <optimized out> outerTupleSlot = <optimized out> outerPlan = <optimized out> econtext = <optimized out> #9 0x00000000006b92ec in ExecProcNode (node=0x316a5d28) at ../../../src/include/executor/executor.h:274 No locals. #10 gather_getnext (gatherstate=0x316a5b38) at nodeGather.c:287 estate = 0x316a5910 outerPlan = 0x316a5d28 outerTupleSlot = <optimized out> fslot = 0x316a6688 tup = <optimized out> #11 ExecGather (pstate=0x316a5b38) at nodeGather.c:222 node = 0x316a5b38 slot = <optimized out> econtext = 0x316a5c48 #12 0x000000000069c36c in ExecProcNode (node=0x316a5b38) at ../../../src/include/executor/executor.h:274 No locals. #13 ExecutePlan (execute_once=<optimized out>, dest=0x31641e90, direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>, operation=CMD_SELECT, use_parallel_mode=<optimized out>, planstate=0x316a5b38, estate=0x316a5910) at execMain.c:1646 slot = <optimized out> current_tuple_count = 0 #14 standard_ExecutorRun (queryDesc=0x316459c0, direction=<optimized out>, count=0, execute_once=<optimized out>) at execMain.c:363 estate = 0x316a5910 operation = CMD_SELECT dest = 0x31641e90 sendTuples = 252 oldcontext = 0x316458c0 __func__ = "standard_ExecutorRun" #15 0x0000000000871564 in PortalRunSelect (portal=portal@entry=0x31512fb0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x31641e90) at pquery.c:924 queryDesc = 0x316459c0 direction = <optimized out> nprocessed = <optimized out> __func__ = "PortalRunSelect" #16 0x0000000000872d80 in PortalRun (portal=portal@entry=0x31512fb0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x31641e90, altdest=altdest@entry=0x31641e90, qc=qc@entry=0xffffd1194c70) at pquery.c:768 _save_exception_stack = 0xffffd1194f28 _save_context_stack = 0x0 _local_sigjmp_buf = {{__jmpbuf = {1, 827404208, 826886624, 826886672, 0, 828645008, 0, 2, 14136744, 826886704, 281474189838832, 7012751731486407017, 0, 7012864883735583905, 0, 13830554455654793216, 0, 0, 0, 0, 0, 0}, __mask_was_saved = 0, __saved_mask = {__val = {14136744, 826886704, 1, 12271232, 14135296, 14136808, 281474189839232, 10405572, 281474189839264, 4891912, 2, 827404208, 281474189839296, 8841760, 826886696, 8841696}}}} result = <optimized out> nprocessed = <optimized out> saveTopTransactionResourceOwner = 0x314d1e28 saveTopTransactionContext = 0x314bb5c0 saveActivePortal = 0x0 saveResourceOwner = 0x314d1e28 savePortalContext = 0x0 saveMemoryContext = 0x314bb5c0 __func__ = "PortalRun" #17 0x000000000086ea54 in exec_simple_query (query_string=query_string@entry=0x31493c90 "SELECT pg_sleep(0.1);") at postgres.c:1274 cmdtaglen = 6 snapshot_set = <optimized out> per_parsetree_context = 0x0 plantree_list = 0x31641e40 parsetree = <error reading variable parsetree (dwarf2_find_location_expression: Corrupted DWARF expression.)> commandTag = <optimized out> qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} querytree_list = <error reading variable querytree_list (dwarf2_find_location_expression: Corrupted DWARF expression.)> portal = 0x31512fb0 receiver = 0x31641e90 format = 0 cmdtagname = <error reading variable cmdtagname (dwarf2_find_location_expression: Corrupted DWARF expression.)> parsetree_item__state = {l = 0x31494a10, i = 0} dest = DestRemote oldcontext = 0x314bb5c0 parsetree_list = 0x31494a10 parsetree_item = 0x31494a28 save_log_statement_stats = <optimized out> was_logged = true use_implicit_block = false msec_str = "\000\000\000\000\377\377\000\000\000\000\000\000\000\000\000\000`\024\327\000\000\000\000\000Q\000\000\000\000\000\000" __func__ = "exec_simple_query" #18 0x000000000086f590 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4680 query_string = <error reading variable query_string (dwarf2_find_location_expression: Corrupted DWARF expression.)> firstchar = <optimized out> input_message = {data = 0x31493c90 "SELECT pg_sleep(0.1);", len = 22, maxlen = 1024, cursor = 22} local_sigjmp_buf = {{__jmpbuf = {14135296, 14135296, 8833856, 1, 281474189841896, 11850784, 826883984, 13979648, 0, 14080304, 281474189839520, 7012751731486456521, 15680, 7012864883735583169, 4631952216750555136, 0, 0, 0, 0, 0, 0, 0}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14127104, 14135296, 24, 826864816, 10405400, 281474189840416, 8724296, 281474189840480, 8825600, 281474189840704, 4, 281474189840696, 1, 281474189841896, 1}}}} send_ready_for_query = false idle_in_transaction_timeout_enabled = false idle_session_timeout_enabled = false __func__ = "PostgresMain" #19 0x000000000086ab20 in BackendMain (startup_data=<optimized out>, startup_data_len=<optimized out>) at backend_startup.c:105 bsdata = <optimized out> #20 0x00000000007c54d8 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0xffffd1195138 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0xffffd1195140) at launch_backend.c:265 pid = <optimized out> #21 0x00000000007c8ec0 in BackendStartup (client_sock=0xffffd1195140) at postmaster.c:3593 bn = 0x314cafc8 pid = <optimized out> startup_data = {canAcceptConnections = CAC_OK} __func__ = "BackendStartup" #22 ServerLoop () at postmaster.c:1674 s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\000\000\000\000\000\000pEI1\000\000\000\000\250Q\031\321\377\377\000\000\262Q\031\321\377\377\000\000\000\340\367\255\377\377\000\000\000\367`\256\377\377\000\000 \000\000\000\000\000\000\000\260Q\031\321\377\377\000\000\000\000\000\000\000\000\000\000\060R\031\321\377\377\000\000(R\031\321\377\377\000\000(\363K1\000\000\000\000i-L1", '\000' <repeats 13 times>, "f\023\243hh\223\231", __ss_align = 281474189840960}, salen = 2}} i = 0 now = <optimized out> last_lockfile_recheck_time = 1713117687 last_touch_time = 1713117687 events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 32768, events = 0, fd = 8, user_data = 0x1}, {pos = 10739224, events = 0, fd = -786868688, user_data = 0x400}, {pos = -786868496, events = 65535, fd = -1377151316, user_data = 0xffffadf7e000 <argp_default_argp+16>}, { pos = 8, events = 0, fd = -786868632, user_data = 0x0}, {pos = -786868384, events = 65535, fd = 66305, user_data = 0xb808831}, {pos = 16832, events = 2, fd = 1001, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x1000}, {pos = 0, events = 0, fd = -786868368, user_data = 0xffffade7ca0c <malloc+156>}, {pos = -786868352, events = 65535, fd = -1377318388, user_data = 0xffffadf7fa88 <main_arena>}, {pos = 4096, events = 0, fd = -1369376944, user_data = 0xffffae60f700}, {pos = 80, events = 0, fd = 827061624, user_data = 0x0}, {pos = 1, events = 0, fd = 0, user_data = 0xb20310}, {pos = -1377763712, events = 65535, fd = 1867, user_data = 0x1}, { pos = -1377818740, events = 65535, fd = -786868320, user_data = 0xffffae5f3cbc <do_lookup_x+556>}, {pos = -1374700376, events = 65535, fd = 173, user_data = 0x1}, {pos = -1374708840, events = 65535, fd = -1369314960, user_data = 0x5}, {pos = -1369314960, events = 65535, fd = -786868120, user_data = 0xffffd1195864}, { pos = 826860128, events = 0, fd = -786868080, user_data = 0xffffae5f4644 <_dl_lookup_symbol_x+260>}, {pos = 2090263927, events = 0, fd = -1369258712, user_data = 0x455fee}, {pos = -786867736, events = 65535, fd = -1369359776, user_data = 0x1}, {pos = -1369259616, events = 65535, fd = 1, user_data = 0xffffd1195930}, {pos = 0, events = 0, fd = 32, user_data = 0x0}, {pos = 6, events = 0, fd = -1369360088, user_data = 0x0}, {pos = -786867920, events = 65535, fd = -786867904, user_data = 0x43fec0}, {pos = 4546542, events = 0, fd = -786868120, user_data = 0xffffd1195864}, {pos = 32660373, events = 0, fd = 826860128, user_data = 0x0}, {pos = 1, events = 0, fd = 0, user_data = 0xffff00000001}, {pos = -1369259616, events = 65535, fd = -786867808, user_data = 0xffffae5f8820 <_dl_fixup+192>}, {pos = 0, events = 0, fd = 13961616, user_data = 0xffffae60ef00}, {pos = -1369377024, events = 65535, fd = 14077952, user_data = 0xd6d930 <NumListenSockets>}, {pos = 826860128, events = 0, fd = 10766128, user_data = 0xb0fe70}, {pos = 11666192, events = 0, fd = 827059992, user_data = 0x99936868a3136600}, {pos = -786867872, events = 65535, fd = 10371416, user_data = 0x314bef18}, {pos = 0, events = 0, fd = -1369258712, user_data = 0xffffd1195940}, {pos = 448139, events = 0, fd = -786867256, user_data = 0xffffae0fae38}, { pos = -1369314960, events = 65535, fd = 0, user_data = 0x314bef18}, {pos = -786867808, events = 65535, fd = 10401956, user_data = 0x314bee50}, {pos = 827059792, events = 0, fd = 827059992, user_data = 0x1}, {pos = 827060816, events = 0, fd = 11733408, user_data = 0xffffd1195ad0}, {pos = -1369445388, events = 65535, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 10, user_data = 0xd6d000 <PqRecvBuffer+7072>}, {pos = 827059792, events = 0, fd = 14136736, user_data = 0xffffae0fae38}, {pos = 135, events = 0, fd = -40, user_data = 0xffffd1195a70}, {pos = -1377343468, events = 65535, fd = -1376250456, user_data = 0xffffadf81590 <dealloc_buffers>}, { pos = 1, events = 0, fd = -1369378800, user_data = 0x1}, {pos = 0, events = 0, fd = 10, user_data = 0xffffade75100 <flush_cleanup>}, {pos = -1376246672, events = 65535, fd = 0, user_data = 0x0}, {pos = -1559009792, events = 2576574568, fd = -786867504, user_data = 0x99936868a3136600}, {pos = -786867504, events = 65535, fd = 8147532, user_data = 0x0}, {pos = -1559009792, events = 2576574568, fd = -786867504, user_data = 0x7c529c <fork_process+124>}, {pos = 9963, events = 0, fd = 0, user_data = 0x0}, {pos = 11, events = 0, fd = -786867328, user_data = 0x7c542c <postmaster_child_launch+60>}, {pos = 0, events = 0, fd = 0, user_data = 0x400}, { pos = 826861016, events = 0, fd = 4194304, user_data = 0x9ebb9c <MemoryContextDelete+168>}, {pos = 826882960, events = 0, fd = 826860816, user_data = 0xd7b5a0 <TopMemoryContext>}, {pos = 826860816, events = 0, fd = 14135296, user_data = 0xd6d930 <NumListenSockets>}, {pos = -786867344, events = 65535, fd = 7280632, user_data = 0xffffd1195bd0}, {pos = 8170340, events = 0, fd = 14131200, user_data = 0x8}, {pos = 8, events = 0, fd = 14131200, user_data = 0xd6d000 <PqRecvBuffer+7072>}, {pos = 14080304, events = 0, fd = 826860128, user_data = 0xa44730}, {pos = 11599472, events = 0, fd = 14131200, user_data = 0xffffd1195bd0}, {pos = 0, events = 0, fd = 0, user_data = 0x31494570}} nevents = <optimized out> __func__ = "ServerLoop" #23 0x00000000007cab68 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x3148f320) at postmaster.c:1372 opt = <optimized out> status = <optimized out> userDoption = <optimized out> listen_addr_saved = false output_config_variable = <optimized out> __func__ = "PostmasterMain" #24 0x0000000000496cb8 in main (argc=8, argv=0x3148f320) at main.c:197 do_check_root = <optimized out> (gdb)
[postgres@ip-172-31-18-25 ~]$ pstack 8098 #0 0x0000ffff8a9c9954 in epoll_pwait () from /lib64/libc.so.6 #1 0x000000000081aa40 in WaitEventSetWaitBlock (nevents=1, occurred_events=<optimized out>, cur_timeout=600000, set=0x108d59b8) at latch.c:1535 #2 WaitEventSetWait (set=0x108d59b8, timeout=timeout@entry=600000, occurred_events=occurred_events@entry=0xfffff9c83678, nevents=nevents@entry=1, wait_event_info=wait_event_info@entry=150994946) at latch.c:1481 #3 0x000000000081ae04 in WaitLatch (latch=<optimized out>, wakeEvents=wakeEvents@entry=41, timeout=600000, wait_event_info=wait_event_info@entry=150994946) at latch.c:513 #4 0x00000000008dd9b4 in pg_sleep (fcinfo=<optimized out>) at misc.c:406 #5 0x000000000067f5dc in ExecInterpExpr (state=0x10ad7ae8, econtext=0x10ad7810, isnull=<optimized out>) at execExprInterp.c:758 #6 0x00000000006b7808 in ExecEvalExprSwitchContext (isNull=0xfffff9c837ef, econtext=0x10ad7810, state=<optimized out>) at ../../../src/include/executor/executor.h:355 #7 ExecProject (projInfo=<optimized out>) at ../../../src/include/executor/executor.h:389 #8 ExecResult (pstate=<optimized out>) at nodeResult.c:136 #9 0x00000000006833cc in ExecProcNode (node=0x10ad7700) at ../../../src/include/executor/executor.h:273 #10 ExecutePlan (execute_once=<optimized out>, dest=0x109f2a50, direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>, operation=CMD_SELECT, use_parallel_mode=<optimized out>, planstate=0x10ad7700, estate=0x10ad74d8) at execMain.c:1670 #11 standard_ExecutorRun (queryDesc=0x10adb4f8, direction=<optimized out>, count=0, execute_once=<optimized out>) at execMain.c:365 #12 0x0000000000847b44 in PortalRunSelect (portal=portal@entry=0x10952f48, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x109f2a50) at pquery.c:924 #13 0x0000000000849360 in PortalRun (portal=portal@entry=0x10952f48, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x109f2a50, altdest=altdest@entry=0x109f2a50, qc=qc@entry=0xfffff9c83b30) at pquery.c:768 #14 0x0000000000845044 in exec_simple_query (query_string=query_string@entry=0x108d9c88 "SELECT pg_sleep(0.1);") at postgres.c:1274 #15 0x0000000000845b68 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4637 #16 0x00000000007ab284 in BackendRun (port=0x109050b0) at postmaster.c:4464 #17 BackendStartup (port=0x109050b0) at postmaster.c:4192 #18 ServerLoop () at postmaster.c:1782 #19 0x00000000007ac3a4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x108d5310) at postmaster.c:1466 #20 0x0000000000493260 in main (argc=8, argv=0x108d5310) at main.c:198 [postgres@ip-172-31-18-25 ~]$ 31292 root 20 0 117M 4320 3136 S 0.0 0.0 0:00.00 â ââ /usr/sbin/CROND -n 31298 postgres 20 0 20988 6312 5320 S 0.0 0.0 0:00.00 â â ââ /usr/sbin/sendmail -FCronDaemon -i -odi -oem -oi -t -f postgres 31307 postgres 20 0 20960 6144 5152 S 0.0 0.0 0:00.00 â â â ââ /usr/sbin/postdrop -r 31293 postgres 20 0 111M 2616 2440 S 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/:$PATH:/usr/local/bin PERL5LIB=/home/postgres/perl5/lib/perl5 ./run_build.pl --config=build-farm.conf REL_16_STABLE --verbose 31295 postgres 20 0 128M 17988 3928 S 0.0 0.1 0:00.08 â â ââ /usr/bin/perl ./run_build.pl --config=build-farm.conf REL_16_STABLE --verbose 5657 postgres 20 0 111M 2628 2448 S 0.0 0.0 0:00.00 â â ââ sh -c { cd pgsql.build/src/test/regress && make NO_LOCALE=1 check; echo $? > /opt/postgres/build-farm-14/buildroot/REL_16_STABLE/parula.lastrun-logs/laststatus; } > /opt/postgres/build-farm-14/buildroot/REL_16_STABLE/parula.lastrun-logs/lastcommand.log 2>&1; read st < 5658 postgres 20 0 110M 2084 1712 S 0.0 0.0 0:00.00 â â ââ make NO_LOCALE=1 check 6834 postgres 20 0 111M 2676 2480 S 0.0 0.0 0:00.00 â â ââ /bin/sh -c echo "# +++ regress check in src/test/regress +++" && PATH="/opt/postgres/build-farm-14/buildroot/REL_16_STABLE/pgsql.build/tmp_install/opt/postgres/build-farm-14/buildroot/REL_16_STABLE/inst/bin:/opt/postgres/build-farm-14/buildroot/REL_16_STABLE/pgsq 6835 postgres 20 0 110M 1960 1800 S 0.0 0.0 0:00.03 â â ââ ../../../src/test/regress/pg_regress --temp-instance=./tmp_check --inputdir=. --bindir= --temp-config=/tmp/buildfarm-w4K7O0/bfextra.conf --no-locale --port=5768 --dlpath=. --max-concurrent-tests=20 --port=5768 --schedule=./parallel_schedule 8090 postgres 20 0 15448 5536 4708 S 0.0 0.0 0:00.00 â â ââ psql -X -a -q -d regression -v HIDE_TABLEAM=on -v HIDE_TOAST_COMPRESSION=on 6849 postgres 20 0 166M 20544 19404 S 0.0 0.1 0:00.33 â â ââ postgres -D /opt/postgres/build-farm-14/buildroot/REL_16_STABLE/pgsql.build/src/test/regress/tmp_check/data -F -c listen_addresses= -k /tmp/pg_regress-Frl3F3 8098 postgres 20 0 171M 41404 37216 S 0.0 0.3 0:00.05 â â ââ postgres: postgres regression [local] SELECT 6857 postgres 20 0 169M 8752 7344 S 0.0 0.1 0:00.01 â â ââ postgres: logical replication launcher 6856 postgres 20 0 168M 8484 7032 S 0.0 0.1 0:00.08 â â ââ postgres: autovacuum launcher 6855 postgres 20 0 166M 10040 8868 S 0.0 0.1 0:00.06 â â ââ postgres: walwriter 6853 postgres 20 0 166M 5400 4244 S 0.0 0.0 0:00.02 â â ââ postgres: background writer 6852 postgres 20 0 168M 111M 109M S 0.0 0.7 0:00.12 â â ââ postgres: checkpointer #0 0x0000ffff8a9c9954 in epoll_pwait () from /lib64/libc.so.6 No symbol table info available. #1 0x000000000081aa40 in WaitEventSetWaitBlock (nevents=1, occurred_events=<optimized out>, cur_timeout=335257, set=0x108d59b8) at latch.c:1535 returned_events = 0 rc = <optimized out> cur_event = <optimized out> cur_epoll_event = <optimized out> __func__ = "WaitEventSetWaitBlock" #2 WaitEventSetWait (set=0x108d59b8, timeout=timeout@entry=600000, occurred_events=occurred_events@entry=0xfffff9c83678, nevents=nevents@entry=1, wait_event_info=wait_event_info@entry=150994946) at latch.c:1481 rc = <optimized out> returned_events = 0 start_time = <optimized out> cur_time = <optimized out> cur_timeout = 335257 #3 0x000000000081ae04 in WaitLatch (latch=<optimized out>, wakeEvents=wakeEvents@entry=41, timeout=600000, wait_event_info=wait_event_info@entry=150994946) at latch.c:513 event = {pos = 9296220, events = 0, fd = 1713147409, user_data = 0xbc95e} #4 0x00000000008dd9b4 in pg_sleep (fcinfo=<optimized out>) at misc.c:406 delay = <optimized out> delay_ms = <optimized out> endtime = 0 #5 0x000000000067f5dc in ExecInterpExpr (state=0x10ad7ae8, econtext=0x10ad7810, isnull=<optimized out>) at execExprInterp.c:758 fcinfo = 0x10ad7bc0 args = 0x10ad7be0 nargs = <optimized out> d = <optimized out> op = <optimized out> resultslot = 0x10ad7a00 innerslot = 0x0 outerslot = 0x0 scanslot = 0x0 dispatch_table = {0x67e6f0 <ExecInterpExpr+1840>, 0x67e104 <ExecInterpExpr+324>, 0x67e938 <ExecInterpExpr+2424>, 0x67e914 <ExecInterpExpr+2388>, 0x67e8d8 <ExecInterpExpr+2328>, 0x67e89c <ExecInterpExpr+2268>, 0x67e860 <ExecInterpExpr+2208>, 0x67e844 <ExecInterpExpr+2180>, 0x67e828 <ExecInterpExpr+2152>, 0x67e80c <ExecInterpExpr+2124>, 0x67eb1c <ExecInterpExpr+2908>, 0x67eacc <ExecInterpExpr+2828>, 0x67ea7c <ExecInterpExpr+2748>, 0x67ea2c <ExecInterpExpr+2668>, 0x67e9f4 <ExecInterpExpr+2612>, 0x67e9ac <ExecInterpExpr+2540>, 0x67e98c <ExecInterpExpr+2508>, 0x67e95c <ExecInterpExpr+2460>, 0x67e7c8 <ExecInterpExpr+2056>, 0x67e77c <ExecInterpExpr+1980>, 0x67e764 <ExecInterpExpr+1956>, 0x67e004 <ExecInterpExpr+68>, 0x67e00c <ExecInterpExpr+76>, 0x67efcc <ExecInterpExpr+4108>, 0x67e02c <ExecInterpExpr+108>, 0x67e034 <ExecInterpExpr+116>, 0x67f010 <ExecInterpExpr+4176>, 0x67efb0 <ExecInterpExpr+4080>, 0x67ef6c <ExecInterpExpr+4012>, 0x67ef54 <ExecInterpExpr+3988>, 0x67ef30 <ExecInterpExpr+3952>, 0x67ef0c <ExecInterpExpr+3916>, 0x67eed4 <ExecInterpExpr+3860>, 0x67eeb8 <ExecInterpExpr+3832>, 0x67ee98 <ExecInterpExpr+3800>, 0x67ee84 <ExecInterpExpr+3780>, 0x67ee70 <ExecInterpExpr+3760>, 0x67ee4c <ExecInterpExpr+3724>, 0x67ee24 <ExecInterpExpr+3684>, 0x67ee00 <ExecInterpExpr+3648>, 0x67edd8 <ExecInterpExpr+3608>, 0x67edc0 <ExecInterpExpr+3584>, 0x67eda8 <ExecInterpExpr+3560>, 0x67ed8c <ExecInterpExpr+3532>, 0x67ed60 <ExecInterpExpr+3488>, 0x67ed18 <ExecInterpExpr+3416>, 0x67ec6c <ExecInterpExpr+3244>, 0x67ec40 <ExecInterpExpr+3200>, 0x67ec10 <ExecInterpExpr+3152>, 0x67eba8 <ExecInterpExpr+3048>, 0x67eb94 <ExecInterpExpr+3028>, 0x67fb08 <ExecInterpExpr+6984>, 0x67eb80 <ExecInterpExpr+3008>, 0x67eb6c <ExecInterpExpr+2988>, 0x67eb34 <ExecInterpExpr+2932>, 0x67f33c <ExecInterpExpr+4988>, 0x67f2b8 <ExecInterpExpr+4856>, 0x67f274 <ExecInterpExpr+4788>, 0x67f260 <ExecInterpExpr+4768>, 0x67f248 <ExecInterpExpr+4744>, 0x67f230 <ExecInterpExpr+4720>, 0x67f218 <ExecInterpExpr+4696>, 0x67f1f8 <ExecInterpExpr+4664>, 0x67f0fc <ExecInterpExpr+4412>, 0x67f0e0 <ExecInterpExpr+4384>, 0x67f0c4 <ExecInterpExpr+4356>, 0x67ed34 <ExecInterpExpr+3444>, 0x67f06c <ExecInterpExpr+4268>, 0x67f04c <ExecInterpExpr+4236>, 0x67f0ac <ExecInterpExpr+4332>, 0x67f098 <ExecInterpExpr+4312>, 0x67f080 <ExecInterpExpr+4288>, 0x67f1e4 <ExecInterpExpr+4644>, 0x67f1cc <ExecInterpExpr+4620>, 0x67f1b8 <ExecInterpExpr+4600>, 0x67f188 <ExecInterpExpr+4552>, 0x67f174 <ExecInterpExpr+4532>, 0x67f13c <ExecInterpExpr+4476>, 0x67f118 <ExecInterpExpr+4440>, 0x67e054 <ExecInterpExpr+148>, 0x67e060 <ExecInterpExpr+160>, 0x67e71c <ExecInterpExpr+1884>, 0x67e6ac <ExecInterpExpr+1772>, 0x67e680 <ExecInterpExpr+1728>, 0x67e5c0 <ExecInterpExpr+1536>, 0x67e508 <ExecInterpExpr+1352>, 0x67e358 <ExecInterpExpr+920>, 0x67e408 <ExecInterpExpr+1096>, 0x67e264 <ExecInterpExpr+676>, 0x67e178 <ExecInterpExpr+440>, 0x67e150 <ExecInterpExpr+400>, 0x67e128 <ExecInterpExpr+360>, 0x67e0dc <ExecInterpExpr+284>, 0x67e0c4 <ExecInterpExpr+260>, 0x67f89c <ExecInterpExpr+6364>} #6 0x00000000006b7808 in ExecEvalExprSwitchContext (isNull=0xfffff9c837ef, econtext=0x10ad7810, state=<optimized out>) at ../../../src/include/executor/executor.h:355 oldContext = 0x10ad73c0 #7 ExecProject (projInfo=<optimized out>) at ../../../src/include/executor/executor.h:389 econtext = 0x10ad7810 state = <optimized out> slot = 0x10ad7a00 isnull = 33 #8 ExecResult (pstate=<optimized out>) at nodeResult.c:136 node = <optimized out> outerTupleSlot = <optimized out> outerPlan = <optimized out> econtext = <optimized out> #9 0x00000000006833cc in ExecProcNode (node=0x10ad7700) at ../../../src/include/executor/executor.h:273 No locals. #10 ExecutePlan (execute_once=<optimized out>, dest=0x109f2a50, direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>, operation=CMD_SELECT, use_parallel_mode=<optimized out>, planstate=0x10ad7700, estate=0x10ad74d8) at execMain.c:1670 slot = <optimized out> current_tuple_count = 0 #11 standard_ExecutorRun (queryDesc=0x10adb4f8, direction=<optimized out>, count=0, execute_once=<optimized out>) at execMain.c:365 estate = 0x10ad74d8 operation = CMD_SELECT dest = 0x109f2a50 sendTuples = 252 oldcontext = 0x10adb3e0 __func__ = "standard_ExecutorRun" #12 0x0000000000847b44 in PortalRunSelect (portal=portal@entry=0x10952f48, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x109f2a50) at pquery.c:924 queryDesc = 0x10adb4f8 direction = <optimized out> nprocessed = <optimized out> __func__ = "PortalRunSelect" #13 0x0000000000849360 in PortalRun (portal=portal@entry=0x10952f48, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x109f2a50, altdest=altdest@entry=0x109f2a50, qc=qc@entry=0xfffff9c83b30) at pquery.c:768 _save_exception_stack = 0xfffff9c83de8 _save_context_stack = 0x0 _local_sigjmp_buf = {{__jmpbuf = {1, 278212424, 277719512, 277719560, 0, 278866512, 0, 2, 13605592, 277719592, 281474872391856, 2455851481445542082, 277697712, 2455605387221598826, 4631952216750555136, 0, 0, 0, 0, 0, 0, 0}, __mask_was_saved = 0, __saved_mask = {__val = {112, 277715824, 277719512, 13602816, 281474872392256, 8686156, 281474872392288, 4874408, 2, 278212424, 277719512, 277719560, 281474872392320, 8671248, 277719584, 8671184}}}} result = <optimized out> nprocessed = <optimized out> saveTopTransactionResourceOwner = 0x109673a8 saveTopTransactionContext = 0x1090cd40 saveActivePortal = 0x0 saveResourceOwner = 0x109673a8 savePortalContext = 0x0 saveMemoryContext = 0x1090cd40 __func__ = "PortalRun" #14 0x0000000000845044 in exec_simple_query (query_string=query_string@entry=0x108d9c88 "SELECT pg_sleep(0.1);") at postgres.c:1274 cmdtaglen = 6 snapshot_set = <optimized out> per_parsetree_context = 0x0 plantree_list = 0x109f2a00 parsetree = <error reading variable parsetree (dwarf2_find_location_expression: Corrupted DWARF expression.)> commandTag = <optimized out> qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} querytree_list = <error reading variable querytree_list (dwarf2_find_location_expression: Corrupted DWARF expression.)> portal = 0x10952f48 receiver = 0x109f2a50 format = 0 cmdtagname = <error reading variable cmdtagname (dwarf2_find_location_expression: Corrupted DWARF expression.)> parsetree_item__state = {l = 0x108daa08, i = 0} dest = DestRemote oldcontext = 0x1090cd40 parsetree_list = 0x108daa08 parsetree_item = 0x108daa20 save_log_statement_stats = <optimized out> was_logged = true use_implicit_block = false msec_str = "\000\000\000\000\377\377\000\000\000\000\000\000\000\000\000\000X\002\317\000\000\000\000\000Q\000\000\000\000\000\000" __func__ = "exec_simple_query" #15 0x0000000000845b68 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4637 query_string = <error reading variable query_string (dwarf2_find_location_expression: Corrupted DWARF expression.)> firstchar = <optimized out> input_message = {data = 0x108d9c88 "SELECT pg_sleep(0.1);", len = 22, maxlen = 1024, cursor = 22} local_sigjmp_buf = {{__jmpbuf = {13602816, 13602816, 8662912, 281474872393704, 277894208, 281474872394760, 277888464, 13455360, 0, 13551280, 281474872392544, 2455851481445527378, 15624, 2455605387221598602, 4631952216750555136, 0, 0, 0, 0, 0, 0, 0}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 7834284, 281474872393440, 8561608, 13562696, 13598720, 13602816, 8625692, 281474872393504, 8041068, 281474872393648, 277893296, 11145024, 281474872393704, 277894208, 277893296}}}} send_ready_for_query = false idle_in_transaction_timeout_enabled = false idle_session_timeout_enabled = false __func__ = "PostgresMain" #16 0x00000000007ab284 in BackendRun (port=0x109050b0) at postmaster.c:4464 No locals. #17 BackendStartup (port=0x109050b0) at postmaster.c:4192 bn = 0x10905440 pid = <optimized out> __func__ = "BackendStartup" #18 ServerLoop () at postmaster.c:1782 port = 0x109050b0 i = <optimized out> now = <optimized out> last_lockfile_recheck_time = 1713135987 last_touch_time = 1713135987 events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 32816, events = 0, fd = -104315824, user_data = 0xffff8a9945a8 <__alloc_dir+72>}, {pos = 32768, events = 0, fd = 8, user_data = 0x1}, {pos = 10502040, events = 0, fd = -104315824, user_data = 0x400}, {pos = -104315632, events = 65535, fd = -1969666388, user_data = 0xffff8aa6d000 <argp_default_argp+16>}, {pos = 8, events = 0, fd = -104315768, user_data = 0x0}, {pos = -104315520, events = 65535, fd = 66305, user_data = 0x1a81d3c4}, {pos = 16832, events = 2, fd = 1001, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x1000}, {pos = 0, events = 0, fd = -104315504, user_data = 0xffff8a96ba0c <malloc+156>}, {pos = -104315488, events = 65535, fd = -1969833460, user_data = 0xffff8aa6ea88 <main_arena>}, {pos = 4096, events = 0, fd = -1961892016, user_data = 0xffff8b0fe700}, {pos = 80, events = 0, fd = 277883320, user_data = 0x0}, {pos = 1, events = 0, fd = 0, user_data = 0xadaa98}, { pos = -1970278784, events = 65535, fd = 1867, user_data = 0x1}, {pos = -1970333812, events = 65535, fd = -1961839552, user_data = 0x0}, {pos = 119, events = 124, fd = 1, user_data = 0x630000006f}, {pos = 0, events = 0, fd = -104315408, user_data = 0xffff8b0e2cbc <do_lookup_x+556>}, {pos = -1967215448, events = 65535, fd = 173, user_data = 0x1}, {pos = -1967223912, events = 65535, fd = -1961797040, user_data = 0x5}, {pos = -1961797040, events = 65535, fd = -104315208, user_data = 0xfffff9c846b4}, {pos = 66305, events = 0, fd = -104315168, user_data = 0xffff8b0e3644 <_dl_lookup_symbol_x+260>}, {pos = 2090263927, events = 0, fd = -1961773784, user_data = 0x4540dd}, {pos = -104314824, events = 65535, fd = -1961874848, user_data = 0x1}, {pos = -1961774688, events = 65535, fd = 1, user_data = 0xfffff9c84780}, {pos = 0, events = 0, fd = 32, user_data = 0x0}, {pos = 6, events = 0, fd = -1961875160, user_data = 0xffff00000000}, {pos = -104315008, events = 65535, fd = -104314992, user_data = 0x43e740}, {pos = 4538589, events = 0, fd = -104315208, user_data = 0xfffff9c846b4}, {pos = 32660373, events = 0, fd = -104315168, user_data = 0x0}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1961774688, events = 65535, fd = -104314896, user_data = 0xffff8b0e7820 <_dl_fixup+192>}, {pos = 0, events = 0, fd = 13437312, user_data = 0xffff8b0fdf00}, {pos = -1961892096, events = 65535, fd = 13549568, user_data = 0xcec6b0 <ListenSocket>}, {pos = 277693024, events = 0, fd = 10528136, user_data = 0xacaed8}, {pos = 11381400, events = 0, fd = -104314944, user_data = 0x9b00b8 <AllocSetReset+40>}, {pos = 277882224, events = 0, fd = 1343407616, user_data = 0xfffff9c847c0}, {pos = 0, events = 0, fd = -1961773784, user_data = 0xfffff9c84790}, {pos = 448139, events = 0, fd = 1024, user_data = 0xffff8abe9e38}, {pos = -1961797040, events = 65535, fd = 277883321, user_data = 0x108d9b70}, {pos = 0, events = 0, fd = 5120, user_data = 0xfffff9c847f0}, { pos = 10185012, events = 0, fd = 277882224, user_data = 0x10902570}, {pos = 277882224, events = 0, fd = 277883248, user_data = 0xfffff9c84920}, {pos = -1961960460, events = 65535, fd = 3, user_data = 0x8}, {pos = 8, events = 0, fd = 13602816, user_data = 0xcec000 <PqRecvBuffer+7712>}, {pos = 277693024, events = 0, fd = 277882224, user_data = 0xffff8abe9e38}, {pos = 135, events = 0, fd = -40, user_data = 0xfffff9c848c0}, {pos = -1969858540, events = 65535, fd = -1968765528, user_data = 0xffff8aa70590 <dealloc_buffers>}, {pos = 1, events = 0, fd = -1961893872, user_data = 0x1}, {pos = 0, events = 0, fd = 1635021578, user_data = 0xffff8a964100 <flush_cleanup>}, {pos = -1968761744, events = 65535, fd = 0, user_data = 0x0}, {pos = 1343407616, events = 3428591778, fd = -104314592, user_data = 0xcc5c28a25012c600}, {pos = -104314592, events = 65535, fd = 8019644, user_data = 0x0}, {pos = 1343407616, events = 3428591778, fd = -104314592, user_data = 0x7a5f0c <fork_process+124>}, {pos = 6854, events = 0, fd = 8, user_data = 0x8}, {pos = 13602816, events = 0, fd = -104314416, user_data = 0x7a8d64 <StartChildProcess+20>}, {pos = 0, events = 0, fd = 8, user_data = 0x108d4510}, {pos = 1024, events = 0, fd = 4194304, user_data = 0x6d8e78 <load_ident+388>}, { pos = 13541376, events = 0, fd = 0, user_data = 0xfffff9c849f0}, {pos = 8045472, events = 0, fd = 13602816, user_data = 0x8}, {pos = 8, events = 0, fd = 13602816, user_data = 0xcec000 <PqRecvBuffer+7712>}, {pos = 13551280, events = 0, fd = 277693024, user_data = 0xa0a588}, {pos = 11316952, events = 0, fd = 8, user_data = 0xfffff9c849f0}, {pos = 0, events = 0, fd = 0, user_data = 0x10904010}} nevents = <optimized out> __func__ = "ServerLoop" #19 0x00000000007ac3a4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x108d5310) at postmaster.c:1466 opt = <optimized out> status = <optimized out> userDoption = <optimized out> listen_addr_saved = false i = <optimized out> output_config_variable = <optimized out> __func__ = "PostmasterMain" #20 0x0000000000493260 in main (argc=8, argv=0x108d5310) at main.c:198 do_check_root = <optimized out> (gdb)