[02:08:49.929] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [02:08:50.221] dumping /tmp/cores/postgres.85344.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:50.398] [New LWP 102105] [02:08:50.483] Core was generated by `postgres: parallel worker for PID 85169 '. [02:08:50.483] Program terminated with signal SIGABRT, Aborted. [02:08:50.483] Sent by thr_kill() from pid 85344 and user 1002. [02:08:50.483] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:50.545] [02:08:50.545] Thread 1 (LWP 102105): [02:08:50.545] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:50.545] No symbol table info available. [02:08:50.545] #1 0x000000082b96ea64 in raise () from /lib/libc.so.7 [02:08:50.545] No symbol table info available. [02:08:50.545] #2 0x000000082ba22a59 in abort () from /lib/libc.so.7 [02:08:50.545] No symbol table info available. [02:08:50.545] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:50.545] No locals. [02:08:50.545] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:50.545] s = [02:08:50.545] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x2fae5d42a500, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:50.545] t = [02:08:50.545] shtabstats = 0x83e9b2200 [02:08:50.545] dboid = 0 [02:08:50.545] lstats = 0x2fae5d42a100 [02:08:50.545] tabentry = 0x83e9b2218 [02:08:50.545] dbentry = [02:08:50.545] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:50.545] entry_ref = 0x2fae5d42a500 [02:08:50.545] kind = [02:08:50.545] kind_info = [02:08:50.545] iter = [02:08:50.545] entry_ref = [02:08:50.545] kind = [02:08:50.545] kind_info = [02:08:50.545] #7 0x0000000830fd607b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_13, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:50.545] qbuffer_size = 0 [02:08:50.545] hstat = {hash_table = 0x19, curbucket = 0, nbuckets = 196612, curitem = 0x3b600000000, pnextitem = 6066880889422204023, curpartition = 2104, exclusive = false} [02:08:50.545] rsinfo = 0x82144d450 [02:08:50.545] userid = 10 [02:08:50.545] is_allowed_role = [02:08:50.545] qbuffer = 0x2fae5dc02100 "~" [02:08:50.545] extent = 0 [02:08:50.545] gc_count = 1 [02:08:50.545] p = [02:08:50.545] #8 0x0000000830fd5dc8 in pg_stat_statements_1_13 (fcinfo=0x18ed9) at ../contrib/pg_stat_statements/pg_stat_statements.c:1515 [02:08:50.545] showtext = false [02:08:50.545] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x2fae5dc00730, econtext=0x2fae5dc00620, argContext=, expectedDesc=0x2fae5dcb04f8, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:50.545] result = 0 [02:08:50.545] fcusage = {fs = 0x0, save_f_total_time = {ticks = 108947468288}, save_total = {ticks = 13230976}, start = {ticks = 52425937374008}} [02:08:50.545] tmptup = {t_len = 1566559008, t_self = {ip_blkid = {bi_hi = 12206, bi_lo = 0}, ip_posid = 28672}, t_tableOid = 12206, t_data = 0x82144d478} [02:08:50.545] first_time = true [02:08:50.545] rsinfo = {type = T_ReturnSetInfo, econtext = 0x2fae5dc00620, expectedDesc = 0x2fae5dcb04f8, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x2fae5dc6d0b8, setDesc = 0x2fae5dcb5520} [02:08:50.545] tupstore = 0x0 [02:08:50.545] tupdesc = 0x0 [02:08:50.545] returnsSet = true [02:08:50.545] callerContext = 0x2fae5dc00000 [02:08:50.545] funcrettype = 2249 [02:08:50.545] fcinfo = 0x2fae5dc0c100 [02:08:50.545] returnsTuple = [02:08:50.545] #10 0x00000000007ef6c5 in FunctionNext (node=0x2fae5dc008c0) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:50.545] tstore = 0x0 [02:08:50.545] estate = [02:08:50.545] scanslot = 0x2fae5dc07bc8 [02:08:50.545] direction = ForwardScanDirection [02:08:50.545] oldpos = [02:08:50.545] att = [02:08:50.545] alldone = [02:08:50.545] funcno = [02:08:50.545] #11 0x00000000007dacfa in ExecScanFetch (node=0x2fae5dc008c0, epqstate=0x0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/include/executor/execScan.h:135 [02:08:50.545] No locals. [02:08:50.545] #12 ExecScanExtended (node=0x2fae5dc008c0, epqstate=0x0, qual=0x0, projInfo=0x2fae5dc6ec10, accessMtd=, recheckMtd=) at ../src/include/executor/execScan.h:196 [02:08:50.545] slot = [02:08:50.545] econtext = 0x2fae5dc00620 [02:08:50.545] slot = [02:08:50.545] #13 ExecScan (node=0x2fae5dc008c0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/backend/executor/execScan.c:59 [02:08:50.545] qual = 0x0 [02:08:50.545] epqstate = 0x0 [02:08:50.545] projInfo = 0x2fae5dc6ec10 [02:08:50.545] #14 0x000000000080f116 in ExecProcNode (node=0x2fae5dc008c0) at ../src/include/executor/executor.h:327 [02:08:50.545] No locals. [02:08:50.545] #15 ExecSort (pstate=0x2fae5dc00380) at ../src/backend/executor/nodeSort.c:149 [02:08:50.545] plannode = [02:08:50.545] tuplesortopts = [02:08:50.545] outerNode = 0x2fae5dc008c0 [02:08:50.545] tupDesc = [02:08:50.545] node = 0x2fae5dc00380 [02:08:50.545] estate = 0x2fae5dc00100 [02:08:50.545] tuplesortstate = 0x2fae5dc67100 [02:08:50.545] dir = ForwardScanDirection [02:08:50.545] slot = [02:08:50.545] #16 0x00000000007cee7b in ExecProcNode (node=0x2fae5dc00380) at ../src/include/executor/executor.h:327 [02:08:50.545] No locals. [02:08:50.545] #17 ExecutePlan (queryDesc=0x2fae5d5fcd58, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x2fae5d57a1c0) at ../src/backend/executor/execMain.c:1736 [02:08:50.545] estate = 0x2fae5dc00100 [02:08:50.545] planstate = 0x2fae5dc00380 [02:08:50.545] current_tuple_count = 0 [02:08:50.545] use_parallel_mode = [02:08:50.545] slot = [02:08:50.545] #18 standard_ExecutorRun (queryDesc=0x2fae5d5fcd58, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:50.545] estate = 0x2fae5dc00100 [02:08:50.545] oldcontext = 0x2fae5d57a000 [02:08:50.545] operation = CMD_SELECT [02:08:50.545] dest = 0x2fae5d57a1c0 [02:08:50.545] sendTuples = true [02:08:50.545] #19 0x0000000830fd4d74 in pgss_ExecutorRun (queryDesc=0x2fae5d5fcd58, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:50.545] _local_sigjmp_buf = {{_sjb = {35181645134, 0, 34917897864, 34917898032, 34917897872, 13222088, 1, 52425937374552, 8192895, 52425943679745, 34917898032, 0}}} [02:08:50.545] _save_exception_stack = 0x82144d810 [02:08:50.545] _save_context_stack = 0x0 [02:08:50.545] _do_rethrow = false [02:08:50.545] #20 0x00000000007d3ec8 in ParallelQueryMain (seg=0x2fae5d5828d8, toc=0x83e746000) at ../src/backend/executor/execParallel.c:1583 [02:08:50.545] pwcxt = {seg = 0x2fae5d5828d8, toc = 0x83e746000} [02:08:50.545] instrument_options = [02:08:50.545] fpes = 0x83e759d20 [02:08:50.545] receiver = 0x2fae5d57a1c0 [02:08:50.545] instrumentation = 0x0 [02:08:50.545] jit_instrumentation = 0x0 [02:08:50.545] queryDesc = 0x2fae5d5fcd58 [02:08:50.545] area_space = [02:08:50.545] area = 0x2fae5dc5a178 [02:08:50.545] buffer_usage = [02:08:50.545] wal_usage = [02:08:50.545] #21 0x00000000006977f1 in ParallelWorkerMain (main_arg=) at ../src/backend/access/transam/parallel.c:1571 [02:08:50.545] seg = 0x2fae5d5828d8 [02:08:50.545] toc = 0x83e746000 [02:08:50.545] fps = 0x83e75efc0 [02:08:50.545] error_queue_space = [02:08:50.545] mq = [02:08:50.545] mqh = [02:08:50.545] entrypointstate = [02:08:50.545] library_name = [02:08:50.545] function_name = [02:08:50.545] entrypt = 0x7d3c40 [02:08:50.545] libraryspace = [02:08:50.545] tstatespace = [02:08:50.545] pendingsyncsspace = [02:08:50.545] relmapperspace = [02:08:50.545] reindexspace = [02:08:50.545] combocidspace = [02:08:50.545] session_dsm_handle_space = [02:08:50.545] asnapspace = [02:08:50.545] tsnapspace = [02:08:50.545] asnapshot = 0x2fae5d57a100 [02:08:50.545] tsnapshot = [02:08:50.545] gucspace = [02:08:50.545] uncommittedenumsspace = [02:08:50.545] clientconninfospace = [02:08:50.545] #22 0x00000000009107ec in BackgroundWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/bgworker.c:865 [02:08:50.545] local_sigjmp_buf = {{_sjb = {9504693, 52425936777272, 34917898248, 34917898400, 10342416, 10175840, 52425936777272, 34917898256, 206158431103, -2147815357, -1, 1}}} [02:08:50.545] worker = 0x2fae5d56b038 [02:08:50.545] entrypt = 0x0 [02:08:50.545] #23 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_BG_WORKER, child_slot=239, startup_data=startup_data@entry=0x2fae5d4272d8, startup_data_len=startup_data_len@entry=1472, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:50.545] pid = [02:08:50.545] #24 0x0000000000918457 in StartBackgroundWorker (rw=0x2fae5d4272d8) at ../src/backend/postmaster/postmaster.c:4207 [02:08:50.545] bn = 0x2fae5d548cd8 [02:08:50.545] worker_pid = [02:08:50.545] __error = [02:08:50.545] __error = [02:08:50.545] __error = [02:08:50.545] #25 maybe_start_bgworkers () at ../src/backend/postmaster/postmaster.c:4372 [02:08:50.545] rw = 0x2fae5d4272d8 [02:08:50.545] num_launched = 0 [02:08:50.545] now = 0 [02:08:50.545] iter = {cur = 0x2fae5d4278b0, next = , end = } [02:08:50.545] #26 0x000000000091a1d5 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3437 [02:08:50.545] No locals. [02:08:50.545] #27 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:50.545] now = [02:08:50.545] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 1565062616, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e160}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5431e406749dcc77}, {pos = 732597312, events = 8, fd = 558161664, user_data = 0x43}, {pos = 1956498551, events = 1412555782, fd = 32, user_data = 0x1000}, {pos = 1, events = 0, fd = 558161720, user_data = 0x2000}, {pos = 558161520, events = 8, fd = 732331702, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 558161536, events = 8, fd = 684059333, user_data = 0x82144df38}, {pos = 558161704, events = 8, fd = 558161560, user_data = 0x82144df10}, {pos = 730683604, events = 8, fd = 730683604, user_data = 0x2fae5d00a408}, {pos = 3, events = 0, fd = 558161664, user_data = 0x2ad628c59b2b}, {pos = 558161704, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 558162160, user_data = 0x82ba62ad4}, {pos = 558161728, events = 8, fd = 12288, user_data = 0x2000}, {pos = 1560344136, events = 12206, fd = 0, user_data = 0x0}, {pos = 558161816, events = 8, fd = 558162264, user_data = 0x82144df80}, {pos = 684057650, events = 10966, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 1560346704, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e248}, {pos = 1564542304, events = 3, fd = 558162336, user_data = 0x2fae5d00f6a8}, {pos = 656, events = 0, fd = 558162264, user_data = 0x82144df98}, {pos = 558161920, events = 8, fd = 684057291, user_data = 0x82144e208}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x2fae5d00a408}, {pos = 730607240, events = 8, fd = 558162504, user_data = 0x82144e1a0}, {pos = 31, events = 0, fd = 0, user_data = 0x2fae5d003008}, {pos = 558161936, events = 8, fd = 558162320, user_data = 0x2ad628c580c7}, {pos = 1560293384, events = 12206, fd = 1560294408, user_data = 0x2fae5d003808}, {pos = 1560296456, events = 12206, fd = 1560309768, user_data = 0x2fae5d007408}, {pos = 1560311816, events = 12206, fd = 1560312840, user_data = 0x2fae5d008008}, {pos = 1560314888, events = 12206, fd = 1560315912, user_data = 0x2fae5d008c08}, {pos = 1560317960, events = 12206, fd = 1560318984, user_data = 0x2fae5d009808}, {pos = 1560321032, events = 12206, fd = 1560322056, user_data = 0x2fae5d00a408}, {pos = 1560324104, events = 12206, fd = 1560325128, user_data = 0x2fae5d00b008}, {pos = 1560327176, events = 12206, fd = 1560328200, user_data = 0x2fae5d00bc08}, {pos = 1560330248, events = 12206, fd = 1560331272, user_data = 0x2fae5d00c808}, {pos = 1560333320, events = 12206, fd = 1560338440, user_data = 0x2fae5d00e408}, {pos = 1560341512, events = 12206, fd = 269670000, user_data = 0x2fae5d003008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558162504, user_data = 0x82144e010}, {pos = 31, events = 31, fd = 1560293384, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x2fae5d010050}, {pos = 558162480, events = 8, fd = 684030908, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x2fae5d010050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82b9f3d70 }, {pos = 1560293384, events = 12206, fd = 2859976, user_data = 0x829a4b549}, {pos = 1, events = 0, fd = 1561010184, user_data = 0x82144e230}, {pos = 698656485, events = 8, fd = 731856240, user_data = 0xc7f098 }, {pos = 731856240, events = 8, fd = 1560323080, user_data = 0x82144e310}, {pos = 684030388, events = 10966, fd = 16, user_data = 0x2fae00000001}, {pos = 684029998, events = 10966, fd = 1560293384, user_data = 0x82144e238}, {pos = 558162704, events = 8, fd = 7176, user_data = 0xc}, {pos = 684112704, events = 10966, fd = 0, user_data = 0x82144037f}, {pos = 11979292, events = 0, fd = 558162624, user_data = 0x829a415d0 <__pthread_cleanup_pop_imp+48>}, {pos = 732525312, events = 8, fd = 732534256, user_data = 0x0}, {pos = 8128, events = 0, fd = 558162672, user_data = 0x829a4bb9d}, {pos = 558162688, events = 8, fd = 698619344, user_data = 0x82ba97300 <__thr_jtable>}, {pos = 732534256, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 558162736, events = 8, fd = 698661789, user_data = 0x2fae5d0b2008}, {pos = 85133, events = 0, fd = 558162832, user_data = 0x829a43a7d}} [02:08:50.545] last_touch_time = 1778896893 [02:08:50.545] last_lockfile_recheck_time = 1778896893 [02:08:50.545] nevents = [02:08:50.545] #28 0x0000000000917a36 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82144e9e8) at ../src/backend/postmaster/postmaster.c:1415 [02:08:50.545] optctx = {nargc = 8, nargv = 0x82144e9e8, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x82144f09c "/tmp/pg_regress-6LUnOo", optind = 8, optopt = 107, place = 0x2f17c5 ""} [02:08:50.545] userDoption = [02:08:50.545] listen_addr_saved = false [02:08:50.545] output_config_variable = [02:08:50.545] opt = [02:08:50.545] status = [02:08:50.545] #29 0x000000000083c50d in main (argc=8, argv=0x82144e9e8) at ../src/backend/main/main.c:231 [02:08:50.545] do_check_root = [02:08:50.545] dispatch_option = DISPATCH_POSTMASTER [02:08:50.552] [02:08:50.552] [02:08:50.552] [02:08:50.609] dumping /tmp/cores/postgres.86242.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:50.745] [New LWP 102188] [02:08:50.812] Core was generated by `postgres: parallel worker for PID 86223 '. [02:08:50.812] Program terminated with signal SIGABRT, Aborted. [02:08:50.812] Sent by thr_kill() from pid 86242 and user 1002. [02:08:50.812] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:50.855] [02:08:50.855] Thread 1 (LWP 102188): [02:08:50.855] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:50.855] No symbol table info available. [02:08:50.855] #1 0x000000082b96ea64 in raise () from /lib/libc.so.7 [02:08:50.855] No symbol table info available. [02:08:50.855] #2 0x000000082ba22a59 in abort () from /lib/libc.so.7 [02:08:50.855] No symbol table info available. [02:08:50.855] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:50.855] No locals. [02:08:50.855] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:50.855] s = [02:08:50.855] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x2fae5d42a500, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:50.855] t = [02:08:50.855] shtabstats = 0x83e31f800 [02:08:50.855] dboid = 0 [02:08:50.855] lstats = 0x2fae5d42a100 [02:08:50.855] tabentry = 0x83e31f818 [02:08:50.855] dbentry = [02:08:50.855] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:50.855] entry_ref = 0x2fae5d42a500 [02:08:50.855] kind = [02:08:50.855] kind_info = [02:08:50.855] iter = [02:08:50.855] entry_ref = [02:08:50.855] kind = [02:08:50.855] kind_info = [02:08:50.855] #7 0x0000000830fd607b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_13, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:50.855] qbuffer_size = 0 [02:08:50.855] hstat = {hash_table = 0x19, curbucket = 0, nbuckets = 196612, curitem = 0x3b600000000, pnextitem = 6066880889422204023, curpartition = 2104, exclusive = false} [02:08:50.855] rsinfo = 0x82144d450 [02:08:50.855] userid = 10 [02:08:50.855] is_allowed_role = [02:08:50.855] qbuffer = 0x2fae5dc04100 "~" [02:08:50.855] extent = 0 [02:08:50.855] gc_count = 1 [02:08:50.855] p = [02:08:50.855] #8 0x0000000830fd5dc8 in pg_stat_statements_1_13 (fcinfo=0x18f2c) at ../contrib/pg_stat_statements/pg_stat_statements.c:1515 [02:08:50.855] showtext = false [02:08:50.855] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x2fae5dc02730, econtext=0x2fae5dc02620, argContext=, expectedDesc=0x2fae5dcb03f8, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:50.855] result = 0 [02:08:50.855] fcusage = {fs = 0x0, save_f_total_time = {ticks = 108947804160}, save_total = {ticks = 13230976}, start = {ticks = 52425943682888}} [02:08:50.855] tmptup = {t_len = 1572867888, t_self = {ip_blkid = {bi_hi = 12206, bi_lo = 0}, ip_posid = 36864}, t_tableOid = 12206, t_data = 0x82144d478} [02:08:50.855] first_time = true [02:08:50.855] rsinfo = {type = T_ReturnSetInfo, econtext = 0x2fae5dc02620, expectedDesc = 0x2fae5dcb03f8, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x2fae5dc6ccf8, setDesc = 0x2fae5dcb5420} [02:08:50.855] tupstore = 0x0 [02:08:50.855] tupdesc = 0x0 [02:08:50.855] returnsSet = true [02:08:50.855] callerContext = 0x2fae5dc02000 [02:08:50.855] funcrettype = 2249 [02:08:50.855] fcinfo = 0x2fae5dc67100 [02:08:50.855] returnsTuple = [02:08:50.855] #10 0x00000000007ef6c5 in FunctionNext (node=0x2fae5dc028c0) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:50.855] tstore = 0x0 [02:08:50.855] estate = [02:08:50.855] scanslot = 0x2fae5dc09bc8 [02:08:50.855] direction = ForwardScanDirection [02:08:50.855] oldpos = [02:08:50.855] att = [02:08:50.855] alldone = [02:08:50.855] funcno = [02:08:50.855] #11 0x00000000007dacfa in ExecScanFetch (node=0x2fae5dc028c0, epqstate=0x0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/include/executor/execScan.h:135 [02:08:50.855] No locals. [02:08:50.855] #12 ExecScanExtended (node=0x2fae5dc028c0, epqstate=0x0, qual=0x0, projInfo=0x2fae5dc6e850, accessMtd=, recheckMtd=) at ../src/include/executor/execScan.h:196 [02:08:50.855] slot = [02:08:50.855] econtext = 0x2fae5dc02620 [02:08:50.855] slot = [02:08:50.855] #13 ExecScan (node=0x2fae5dc028c0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/backend/executor/execScan.c:59 [02:08:50.855] qual = 0x0 [02:08:50.855] epqstate = 0x0 [02:08:50.855] projInfo = 0x2fae5dc6e850 [02:08:50.855] #14 0x000000000080f116 in ExecProcNode (node=0x2fae5dc028c0) at ../src/include/executor/executor.h:327 [02:08:50.855] No locals. [02:08:50.855] #15 ExecSort (pstate=0x2fae5dc02380) at ../src/backend/executor/nodeSort.c:149 [02:08:50.855] plannode = [02:08:50.855] tuplesortopts = [02:08:50.855] outerNode = 0x2fae5dc028c0 [02:08:50.855] tupDesc = [02:08:50.855] node = 0x2fae5dc02380 [02:08:50.855] estate = 0x2fae5dc02100 [02:08:50.855] tuplesortstate = 0x2fae5dcb9100 [02:08:50.855] dir = ForwardScanDirection [02:08:50.855] slot = [02:08:50.855] #16 0x00000000007cee7b in ExecProcNode (node=0x2fae5dc02380) at ../src/include/executor/executor.h:327 [02:08:50.855] No locals. [02:08:50.855] #17 ExecutePlan (queryDesc=0x2fae5d57bf78, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x2fae5d57a5d0) at ../src/backend/executor/execMain.c:1736 [02:08:50.855] estate = 0x2fae5dc02100 [02:08:50.855] planstate = 0x2fae5dc02380 [02:08:50.855] current_tuple_count = 0 [02:08:50.855] use_parallel_mode = [02:08:50.855] slot = [02:08:50.855] #18 standard_ExecutorRun (queryDesc=0x2fae5d57bf78, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:50.855] estate = 0x2fae5dc02100 [02:08:50.855] oldcontext = 0x2fae5d57a000 [02:08:50.855] operation = CMD_SELECT [02:08:50.855] dest = 0x2fae5d57a5d0 [02:08:50.855] sendTuples = true [02:08:50.855] #19 0x0000000830fd4d74 in pgss_ExecutorRun (queryDesc=0x2fae5d57bf78, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:50.855] _local_sigjmp_buf = {{_sjb = {35181645134, 0, 34917897864, 34917898032, 34917897872, 13222088, 1, 52425936846712, 8192895, 52425943687937, 34917898032, 0}}} [02:08:50.855] _save_exception_stack = 0x82144d810 [02:08:50.855] _save_context_stack = 0x0 [02:08:50.855] _do_rethrow = false [02:08:50.855] #20 0x00000000007d3ec8 in ParallelQueryMain (seg=0x2fae5d582318, toc=0x83df03000) at ../src/backend/executor/execParallel.c:1583 [02:08:50.855] pwcxt = {seg = 0x2fae5d582318, toc = 0x83df03000} [02:08:50.855] instrument_options = [02:08:50.855] fpes = 0x83df16de0 [02:08:50.855] receiver = 0x2fae5d57a5d0 [02:08:50.855] instrumentation = 0x0 [02:08:50.855] jit_instrumentation = 0x0 [02:08:50.855] queryDesc = 0x2fae5d57bf78 [02:08:50.855] area_space = [02:08:50.855] area = 0x2fae5dc5adb8 [02:08:50.855] buffer_usage = [02:08:50.855] wal_usage = [02:08:50.855] #21 0x00000000006977f1 in ParallelWorkerMain (main_arg=) at ../src/backend/access/transam/parallel.c:1571 [02:08:50.855] seg = 0x2fae5d582318 [02:08:50.855] toc = 0x83df03000 [02:08:50.855] fps = 0x83df1c060 [02:08:50.855] error_queue_space = [02:08:50.855] mq = [02:08:50.855] mqh = [02:08:50.855] entrypointstate = [02:08:50.855] library_name = [02:08:50.855] function_name = [02:08:50.855] entrypt = 0x7d3c40 [02:08:50.855] libraryspace = [02:08:50.855] tstatespace = [02:08:50.855] pendingsyncsspace = [02:08:50.855] relmapperspace = [02:08:50.855] reindexspace = [02:08:50.855] combocidspace = [02:08:50.855] session_dsm_handle_space = [02:08:50.855] asnapspace = [02:08:50.855] tsnapspace = [02:08:50.855] asnapshot = 0x2fae5d57a510 [02:08:50.855] tsnapshot = [02:08:50.855] gucspace = [02:08:50.855] uncommittedenumsspace = [02:08:50.855] clientconninfospace = [02:08:50.855] #22 0x00000000009107ec in BackgroundWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/bgworker.c:865 [02:08:50.855] local_sigjmp_buf = {{_sjb = {9504693, 52425936777832, 34917898248, 34917898400, 10342416, 10175840, 52425936777832, 34917898256, 206158431103, -2147815357, -1, 1}}} [02:08:50.855] worker = 0x2fae5d56b268 [02:08:50.855] entrypt = 0x0 [02:08:50.855] #23 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_BG_WORKER, child_slot=239, startup_data=startup_data@entry=0x2fae5d4272d8, startup_data_len=startup_data_len@entry=1472, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:50.855] pid = [02:08:50.855] #24 0x0000000000918457 in StartBackgroundWorker (rw=0x2fae5d4272d8) at ../src/backend/postmaster/postmaster.c:4207 [02:08:50.855] bn = 0x2fae5d548cd8 [02:08:50.855] worker_pid = [02:08:50.855] __error = [02:08:50.855] __error = [02:08:50.855] __error = [02:08:50.855] #25 maybe_start_bgworkers () at ../src/backend/postmaster/postmaster.c:4372 [02:08:50.855] rw = 0x2fae5d4272d8 [02:08:50.855] num_launched = 0 [02:08:50.855] now = 0 [02:08:50.855] iter = {cur = 0x2fae5d4278b0, next = , end = } [02:08:50.855] #26 0x000000000091a1d5 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3437 [02:08:50.855] No locals. [02:08:50.855] #27 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:50.855] now = [02:08:50.855] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 1565062616, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e160}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5431e406749dcc77}, {pos = 732597312, events = 8, fd = 558161664, user_data = 0x43}, {pos = 1956498551, events = 1412555782, fd = 32, user_data = 0x1000}, {pos = 1, events = 0, fd = 558161720, user_data = 0x2000}, {pos = 558161520, events = 8, fd = 732331702, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 558161536, events = 8, fd = 684059333, user_data = 0x82144df38}, {pos = 558161704, events = 8, fd = 558161560, user_data = 0x82144df10}, {pos = 730683604, events = 8, fd = 730683604, user_data = 0x2fae5d00a408}, {pos = 3, events = 0, fd = 558161664, user_data = 0x2ad628c59b2b}, {pos = 558161704, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 558162160, user_data = 0x82ba62ad4}, {pos = 558161728, events = 8, fd = 12288, user_data = 0x2000}, {pos = 1560344136, events = 12206, fd = 0, user_data = 0x0}, {pos = 558161816, events = 8, fd = 558162264, user_data = 0x82144df80}, {pos = 684057650, events = 10966, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 1560346704, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e248}, {pos = 1564542304, events = 3, fd = 558162336, user_data = 0x2fae5d00f6a8}, {pos = 656, events = 0, fd = 558162264, user_data = 0x82144df98}, {pos = 558161920, events = 8, fd = 684057291, user_data = 0x82144e208}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x2fae5d00a408}, {pos = 730607240, events = 8, fd = 558162504, user_data = 0x82144e1a0}, {pos = 31, events = 0, fd = 0, user_data = 0x2fae5d003008}, {pos = 558161936, events = 8, fd = 558162320, user_data = 0x2ad628c580c7}, {pos = 1560293384, events = 12206, fd = 1560294408, user_data = 0x2fae5d003808}, {pos = 1560296456, events = 12206, fd = 1560309768, user_data = 0x2fae5d007408}, {pos = 1560311816, events = 12206, fd = 1560312840, user_data = 0x2fae5d008008}, {pos = 1560314888, events = 12206, fd = 1560315912, user_data = 0x2fae5d008c08}, {pos = 1560317960, events = 12206, fd = 1560318984, user_data = 0x2fae5d009808}, {pos = 1560321032, events = 12206, fd = 1560322056, user_data = 0x2fae5d00a408}, {pos = 1560324104, events = 12206, fd = 1560325128, user_data = 0x2fae5d00b008}, {pos = 1560327176, events = 12206, fd = 1560328200, user_data = 0x2fae5d00bc08}, {pos = 1560330248, events = 12206, fd = 1560331272, user_data = 0x2fae5d00c808}, {pos = 1560333320, events = 12206, fd = 1560338440, user_data = 0x2fae5d00e408}, {pos = 1560341512, events = 12206, fd = 269670000, user_data = 0x2fae5d003008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558162504, user_data = 0x82144e010}, {pos = 31, events = 31, fd = 1560293384, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x2fae5d010050}, {pos = 558162480, events = 8, fd = 684030908, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x2fae5d010050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82b9f3d70 }, {pos = 1560293384, events = 12206, fd = 2859976, user_data = 0x829a4b549}, {pos = 1, events = 0, fd = 1561010184, user_data = 0x82144e230}, {pos = 698656485, events = 8, fd = 731856240, user_data = 0xc7f098 }, {pos = 731856240, events = 8, fd = 1560323080, user_data = 0x82144e310}, {pos = 684030388, events = 10966, fd = 16, user_data = 0x2fae00000001}, {pos = 684029998, events = 10966, fd = 1560293384, user_data = 0x82144e238}, {pos = 558162704, events = 8, fd = 7176, user_data = 0xc}, {pos = 684112704, events = 10966, fd = 0, user_data = 0x82144037f}, {pos = 11979292, events = 0, fd = 558162624, user_data = 0x829a415d0 <__pthread_cleanup_pop_imp+48>}, {pos = 732525312, events = 8, fd = 732534256, user_data = 0x0}, {pos = 8128, events = 0, fd = 558162672, user_data = 0x829a4bb9d}, {pos = 558162688, events = 8, fd = 698619344, user_data = 0x82ba97300 <__thr_jtable>}, {pos = 732534256, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 558162736, events = 8, fd = 698661789, user_data = 0x2fae5d0b2008}, {pos = 85133, events = 0, fd = 558162832, user_data = 0x829a43a7d}} [02:08:50.855] last_touch_time = 1778896893 [02:08:50.855] last_lockfile_recheck_time = 1778896893 [02:08:50.855] nevents = [02:08:50.855] #28 0x0000000000917a36 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82144e9e8) at ../src/backend/postmaster/postmaster.c:1415 [02:08:50.855] optctx = {nargc = 8, nargv = 0x82144e9e8, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x82144f09c "/tmp/pg_regress-6LUnOo", optind = 8, optopt = 107, place = 0x2f17c5 ""} [02:08:50.855] userDoption = [02:08:50.855] listen_addr_saved = false [02:08:50.855] output_config_variable = [02:08:50.855] opt = [02:08:50.855] status = [02:08:50.855] #29 0x000000000083c50d in main (argc=8, argv=0x82144e9e8) at ../src/backend/main/main.c:231 [02:08:50.855] do_check_root = [02:08:50.855] dispatch_option = DISPATCH_POSTMASTER [02:08:50.864] [02:08:50.864] [02:08:50.864] [02:08:50.921] dumping /tmp/cores/postgres.87146.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:51.053] [New LWP 100098] [02:08:51.117] Core was generated by `postgres: parallel worker for PID 87078 '. [02:08:51.117] Program terminated with signal SIGABRT, Aborted. [02:08:51.117] Sent by thr_kill() from pid 87146 and user 1002. [02:08:51.117] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:51.162] [02:08:51.162] Thread 1 (LWP 100098): [02:08:51.162] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:51.162] No symbol table info available. [02:08:51.162] #1 0x000000082b96ea64 in raise () from /lib/libc.so.7 [02:08:51.162] No symbol table info available. [02:08:51.162] #2 0x000000082ba22a59 in abort () from /lib/libc.so.7 [02:08:51.162] No symbol table info available. [02:08:51.162] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:51.162] No locals. [02:08:51.162] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:51.162] s = [02:08:51.162] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x2fae5d42a500, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:51.162] t = [02:08:51.162] shtabstats = 0x83dd7c800 [02:08:51.162] dboid = 0 [02:08:51.162] lstats = 0x2fae5d42a100 [02:08:51.162] tabentry = 0x83dd7c818 [02:08:51.162] dbentry = [02:08:51.162] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:51.162] entry_ref = 0x2fae5d42a500 [02:08:51.162] kind = [02:08:51.162] kind_info = [02:08:51.162] iter = [02:08:51.162] entry_ref = [02:08:51.162] kind = [02:08:51.162] kind_info = [02:08:51.162] #7 0x0000000830fd607b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_13, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:51.162] qbuffer_size = 0 [02:08:51.162] hstat = {hash_table = 0x19, curbucket = 0, nbuckets = 196612, curitem = 0x3b600000000, pnextitem = 6066880889422204023, curpartition = 2104, exclusive = false} [02:08:51.162] rsinfo = 0x82144d450 [02:08:51.162] userid = 10 [02:08:51.162] is_allowed_role = [02:08:51.162] qbuffer = 0x2fae5dc02100 "~" [02:08:51.162] extent = 0 [02:08:51.162] gc_count = 1 [02:08:51.162] p = [02:08:51.162] #8 0x0000000830fd5dc8 in pg_stat_statements_1_13 (fcinfo=0x18702) at ../contrib/pg_stat_statements/pg_stat_statements.c:1515 [02:08:51.162] showtext = false [02:08:51.162] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x2fae5dc00730, econtext=0x2fae5dc00620, argContext=, expectedDesc=0x2fae5dcb0bf8, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:51.162] result = 0 [02:08:51.162] fcusage = {fs = 0x0, save_f_total_time = {ticks = 108947468288}, save_total = {ticks = 13230976}, start = {ticks = 52425937374808}} [02:08:51.162] tmptup = {t_len = 1566559808, t_self = {ip_blkid = {bi_hi = 12206, bi_lo = 0}, ip_posid = 28672}, t_tableOid = 12206, t_data = 0x82144d478} [02:08:51.162] first_time = true [02:08:51.162] rsinfo = {type = T_ReturnSetInfo, econtext = 0x2fae5dc00620, expectedDesc = 0x2fae5dcb0bf8, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x2fae5dc6c7f8, setDesc = 0x2fae5dcb6560} [02:08:51.162] tupstore = 0x0 [02:08:51.162] tupdesc = 0x0 [02:08:51.162] returnsSet = true [02:08:51.162] callerContext = 0x2fae5dc00000 [02:08:51.162] funcrettype = 2249 [02:08:51.162] fcinfo = 0x2fae5dc0c100 [02:08:51.162] returnsTuple = [02:08:51.162] #10 0x00000000007ef6c5 in FunctionNext (node=0x2fae5dc008c0) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:51.162] tstore = 0x0 [02:08:51.162] estate = [02:08:51.162] scanslot = 0x2fae5dc07bc8 [02:08:51.162] direction = ForwardScanDirection [02:08:51.162] oldpos = [02:08:51.162] att = [02:08:51.162] alldone = [02:08:51.162] funcno = [02:08:51.162] #11 0x00000000007dacfa in ExecScanFetch (node=0x2fae5dc008c0, epqstate=0x0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/include/executor/execScan.h:135 [02:08:51.162] No locals. [02:08:51.162] #12 ExecScanExtended (node=0x2fae5dc008c0, epqstate=0x0, qual=0x2fae5dc00590, projInfo=0x2fae5dc6e350, accessMtd=, recheckMtd=) at ../src/include/executor/execScan.h:196 [02:08:51.162] slot = [02:08:51.162] econtext = 0x2fae5dc00620 [02:08:51.162] slot = [02:08:51.162] #13 ExecScan (node=0x2fae5dc008c0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/backend/executor/execScan.c:59 [02:08:51.162] qual = 0x2fae5dc00590 [02:08:51.162] epqstate = 0x0 [02:08:51.162] projInfo = 0x2fae5dc6e350 [02:08:51.162] #14 0x000000000080f116 in ExecProcNode (node=0x2fae5dc008c0) at ../src/include/executor/executor.h:327 [02:08:51.162] No locals. [02:08:51.162] #15 ExecSort (pstate=0x2fae5dc00380) at ../src/backend/executor/nodeSort.c:149 [02:08:51.162] plannode = [02:08:51.162] tuplesortopts = [02:08:51.162] outerNode = 0x2fae5dc008c0 [02:08:51.162] tupDesc = [02:08:51.162] node = 0x2fae5dc00380 [02:08:51.162] estate = 0x2fae5dc00100 [02:08:51.162] tuplesortstate = 0x2fae5dc67100 [02:08:51.162] dir = ForwardScanDirection [02:08:51.162] slot = [02:08:51.162] #16 0x00000000007cee7b in ExecProcNode (node=0x2fae5dc00380) at ../src/include/executor/executor.h:327 [02:08:51.162] No locals. [02:08:51.162] #17 ExecutePlan (queryDesc=0x2fae5d57bb68, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x2fae5d57a1c0) at ../src/backend/executor/execMain.c:1736 [02:08:51.162] estate = 0x2fae5dc00100 [02:08:51.162] planstate = 0x2fae5dc00380 [02:08:51.162] current_tuple_count = 0 [02:08:51.162] use_parallel_mode = [02:08:51.162] slot = [02:08:51.162] #18 standard_ExecutorRun (queryDesc=0x2fae5d57bb68, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:51.162] estate = 0x2fae5dc00100 [02:08:51.162] oldcontext = 0x2fae5d57a000 [02:08:51.162] operation = CMD_SELECT [02:08:51.162] dest = 0x2fae5d57a1c0 [02:08:51.162] sendTuples = true [02:08:51.162] #19 0x0000000830fd4d74 in pgss_ExecutorRun (queryDesc=0x2fae5d57bb68, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:51.162] _local_sigjmp_buf = {{_sjb = {35181645134, 0, 34917897864, 34917898032, 34917897872, 13222088, 1, 52425936845672, 8192895, 52425943679745, 34917898032, 0}}} [02:08:51.162] _save_exception_stack = 0x82144d810 [02:08:51.162] _save_context_stack = 0x0 [02:08:51.162] _do_rethrow = false [02:08:51.162] #20 0x00000000007d3ec8 in ParallelQueryMain (seg=0x2fae5d415fc0, toc=0x83cb50000) at ../src/backend/executor/execParallel.c:1583 [02:08:51.162] pwcxt = {seg = 0x2fae5d415fc0, toc = 0x83cb50000} [02:08:51.162] instrument_options = [02:08:51.162] fpes = 0x83cb64120 [02:08:51.162] receiver = 0x2fae5d57a1c0 [02:08:51.162] instrumentation = 0x0 [02:08:51.162] jit_instrumentation = 0x0 [02:08:51.162] queryDesc = 0x2fae5d57bb68 [02:08:51.162] area_space = [02:08:51.162] area = 0x2fae5dc5a9f8 [02:08:51.162] buffer_usage = [02:08:51.162] wal_usage = [02:08:51.162] #21 0x00000000006977f1 in ParallelWorkerMain (main_arg=) at ../src/backend/access/transam/parallel.c:1571 [02:08:51.162] seg = 0x2fae5d415fc0 [02:08:51.162] toc = 0x83cb50000 [02:08:51.162] fps = 0x83cb69380 [02:08:51.162] error_queue_space = [02:08:51.162] mq = [02:08:51.162] mqh = [02:08:51.162] entrypointstate = [02:08:51.162] library_name = [02:08:51.162] function_name = [02:08:51.162] entrypt = 0x7d3c40 [02:08:51.162] libraryspace = [02:08:51.162] tstatespace = [02:08:51.162] pendingsyncsspace = [02:08:51.162] relmapperspace = [02:08:51.162] reindexspace = [02:08:51.162] combocidspace = [02:08:51.162] session_dsm_handle_space = [02:08:51.162] asnapspace = [02:08:51.162] tsnapspace = [02:08:51.162] asnapshot = 0x2fae5d57a100 [02:08:51.162] tsnapshot = [02:08:51.162] gucspace = [02:08:51.162] uncommittedenumsspace = [02:08:51.162] clientconninfospace = [02:08:51.162] #22 0x00000000009107ec in BackgroundWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/bgworker.c:865 [02:08:51.162] local_sigjmp_buf = {{_sjb = {9504693, 52425936779256, 34917898248, 34917898400, 10342416, 10175840, 52425936779256, 34917898256, 206158431103, -2147815357, -1, 1}}} [02:08:51.162] worker = 0x2fae5d56b7f8 [02:08:51.162] entrypt = 0x0 [02:08:51.162] #23 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_BG_WORKER, child_slot=239, startup_data=startup_data@entry=0x2fae5d4272d8, startup_data_len=startup_data_len@entry=1472, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:51.162] pid = [02:08:51.162] #24 0x0000000000918457 in StartBackgroundWorker (rw=0x2fae5d4272d8) at ../src/backend/postmaster/postmaster.c:4207 [02:08:51.162] bn = 0x2fae5d548cd8 [02:08:51.162] worker_pid = [02:08:51.162] __error = [02:08:51.162] __error = [02:08:51.162] __error = [02:08:51.162] #25 maybe_start_bgworkers () at ../src/backend/postmaster/postmaster.c:4372 [02:08:51.162] rw = 0x2fae5d4272d8 [02:08:51.162] num_launched = 0 [02:08:51.162] now = 0 [02:08:51.162] iter = {cur = 0x2fae5d4278b0, next = , end = } [02:08:51.162] #26 0x000000000091a1d5 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3437 [02:08:51.162] No locals. [02:08:51.162] #27 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:51.162] now = [02:08:51.162] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 1565062616, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e160}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5431e406749dcc77}, {pos = 732597312, events = 8, fd = 558161664, user_data = 0x43}, {pos = 1956498551, events = 1412555782, fd = 32, user_data = 0x1000}, {pos = 1, events = 0, fd = 558161720, user_data = 0x2000}, {pos = 558161520, events = 8, fd = 732331702, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 558161536, events = 8, fd = 684059333, user_data = 0x82144df38}, {pos = 558161704, events = 8, fd = 558161560, user_data = 0x82144df10}, {pos = 730683604, events = 8, fd = 730683604, user_data = 0x2fae5d00a408}, {pos = 3, events = 0, fd = 558161664, user_data = 0x2ad628c59b2b}, {pos = 558161704, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 558162160, user_data = 0x82ba62ad4}, {pos = 558161728, events = 8, fd = 12288, user_data = 0x2000}, {pos = 1560344136, events = 12206, fd = 0, user_data = 0x0}, {pos = 558161816, events = 8, fd = 558162264, user_data = 0x82144df80}, {pos = 684057650, events = 10966, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 1560346704, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e248}, {pos = 1564542304, events = 3, fd = 558162336, user_data = 0x2fae5d00f6a8}, {pos = 656, events = 0, fd = 558162264, user_data = 0x82144df98}, {pos = 558161920, events = 8, fd = 684057291, user_data = 0x82144e208}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x2fae5d00a408}, {pos = 730607240, events = 8, fd = 558162504, user_data = 0x82144e1a0}, {pos = 31, events = 0, fd = 0, user_data = 0x2fae5d003008}, {pos = 558161936, events = 8, fd = 558162320, user_data = 0x2ad628c580c7}, {pos = 1560293384, events = 12206, fd = 1560294408, user_data = 0x2fae5d003808}, {pos = 1560296456, events = 12206, fd = 1560309768, user_data = 0x2fae5d007408}, {pos = 1560311816, events = 12206, fd = 1560312840, user_data = 0x2fae5d008008}, {pos = 1560314888, events = 12206, fd = 1560315912, user_data = 0x2fae5d008c08}, {pos = 1560317960, events = 12206, fd = 1560318984, user_data = 0x2fae5d009808}, {pos = 1560321032, events = 12206, fd = 1560322056, user_data = 0x2fae5d00a408}, {pos = 1560324104, events = 12206, fd = 1560325128, user_data = 0x2fae5d00b008}, {pos = 1560327176, events = 12206, fd = 1560328200, user_data = 0x2fae5d00bc08}, {pos = 1560330248, events = 12206, fd = 1560331272, user_data = 0x2fae5d00c808}, {pos = 1560333320, events = 12206, fd = 1560338440, user_data = 0x2fae5d00e408}, {pos = 1560341512, events = 12206, fd = 269670000, user_data = 0x2fae5d003008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558162504, user_data = 0x82144e010}, {pos = 31, events = 31, fd = 1560293384, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x2fae5d010050}, {pos = 558162480, events = 8, fd = 684030908, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x2fae5d010050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82b9f3d70 }, {pos = 1560293384, events = 12206, fd = 2859976, user_data = 0x829a4b549}, {pos = 1, events = 0, fd = 1561010184, user_data = 0x82144e230}, {pos = 698656485, events = 8, fd = 731856240, user_data = 0xc7f098 }, {pos = 731856240, events = 8, fd = 1560323080, user_data = 0x82144e310}, {pos = 684030388, events = 10966, fd = 16, user_data = 0x2fae00000001}, {pos = 684029998, events = 10966, fd = 1560293384, user_data = 0x82144e238}, {pos = 558162704, events = 8, fd = 7176, user_data = 0xc}, {pos = 684112704, events = 10966, fd = 0, user_data = 0x82144037f}, {pos = 11979292, events = 0, fd = 558162624, user_data = 0x829a415d0 <__pthread_cleanup_pop_imp+48>}, {pos = 732525312, events = 8, fd = 732534256, user_data = 0x0}, {pos = 8128, events = 0, fd = 558162672, user_data = 0x829a4bb9d}, {pos = 558162688, events = 8, fd = 698619344, user_data = 0x82ba97300 <__thr_jtable>}, {pos = 732534256, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 558162736, events = 8, fd = 698661789, user_data = 0x2fae5d0b2008}, {pos = 85133, events = 0, fd = 558162832, user_data = 0x829a43a7d}} [02:08:51.162] last_touch_time = 1778896893 [02:08:51.162] last_lockfile_recheck_time = 1778896893 [02:08:51.162] nevents = [02:08:51.162] #28 0x0000000000917a36 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82144e9e8) at ../src/backend/postmaster/postmaster.c:1415 [02:08:51.162] optctx = {nargc = 8, nargv = 0x82144e9e8, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x82144f09c "/tmp/pg_regress-6LUnOo", optind = 8, optopt = 107, place = 0x2f17c5 ""} [02:08:51.162] userDoption = [02:08:51.162] listen_addr_saved = false [02:08:51.162] output_config_variable = [02:08:51.162] opt = [02:08:51.162] status = [02:08:51.162] #29 0x000000000083c50d in main (argc=8, argv=0x82144e9e8) at ../src/backend/main/main.c:231 [02:08:51.162] do_check_root = [02:08:51.162] dispatch_option = DISPATCH_POSTMASTER [02:08:51.170] [02:08:51.170] [02:08:51.170] [02:08:51.227] dumping /tmp/cores/postgres.87828.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:51.360] [New LWP 102126] [02:08:51.427] Core was generated by `postgres: parallel worker for PID 87820 '. [02:08:51.427] Program terminated with signal SIGABRT, Aborted. [02:08:51.427] Sent by thr_kill() from pid 87828 and user 1002. [02:08:51.427] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:51.471] [02:08:51.471] Thread 1 (LWP 102126): [02:08:51.471] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:51.471] No symbol table info available. [02:08:51.471] #1 0x000000082b96ea64 in raise () from /lib/libc.so.7 [02:08:51.471] No symbol table info available. [02:08:51.471] #2 0x000000082ba22a59 in abort () from /lib/libc.so.7 [02:08:51.471] No symbol table info available. [02:08:51.471] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:51.471] No locals. [02:08:51.471] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:51.471] s = [02:08:51.471] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x2fae5d42a500, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:51.471] t = [02:08:51.471] shtabstats = 0x83f413100 [02:08:51.471] dboid = 0 [02:08:51.471] lstats = 0x2fae5d42a100 [02:08:51.471] tabentry = 0x83f413118 [02:08:51.471] dbentry = [02:08:51.471] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:51.471] entry_ref = 0x2fae5d42a500 [02:08:51.471] kind = [02:08:51.471] kind_info = [02:08:51.471] iter = [02:08:51.471] entry_ref = [02:08:51.471] kind = [02:08:51.471] kind_info = [02:08:51.471] #7 0x0000000830fd607b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_13, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:51.471] qbuffer_size = 0 [02:08:51.471] hstat = {hash_table = 0x19, curbucket = 0, nbuckets = 196612, curitem = 0x3b600000000, pnextitem = 6066880889422204023, curpartition = 2104, exclusive = false} [02:08:51.471] rsinfo = 0x82144d450 [02:08:51.471] userid = 10 [02:08:51.471] is_allowed_role = [02:08:51.471] qbuffer = 0x0 [02:08:51.471] extent = 0 [02:08:51.471] gc_count = 0 [02:08:51.471] p = [02:08:51.471] #8 0x0000000830fd5dc8 in pg_stat_statements_1_13 (fcinfo=0x18eee) at ../contrib/pg_stat_statements/pg_stat_statements.c:1515 [02:08:51.471] showtext = false [02:08:51.471] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x2fae5dc00730, econtext=0x2fae5dc00620, argContext=, expectedDesc=0x2fae5dcb0bf8, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:51.471] result = 0 [02:08:51.471] fcusage = {fs = 0x0, save_f_total_time = {ticks = 108947468288}, save_total = {ticks = 13230976}, start = {ticks = 52425937376096}} [02:08:51.471] tmptup = {t_len = 1566561096, t_self = {ip_blkid = {bi_hi = 12206, bi_lo = 0}, ip_posid = 28672}, t_tableOid = 12206, t_data = 0x82144d478} [02:08:51.471] first_time = true [02:08:51.471] rsinfo = {type = T_ReturnSetInfo, econtext = 0x2fae5dc00620, expectedDesc = 0x2fae5dcb0bf8, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x2fae5dc01740, setDesc = 0x2fae5dcb5da0} [02:08:51.471] tupstore = 0x0 [02:08:51.471] tupdesc = 0x0 [02:08:51.471] returnsSet = true [02:08:51.471] callerContext = 0x2fae5dc00000 [02:08:51.471] funcrettype = 2249 [02:08:51.471] fcinfo = 0x2fae5dc0c100 [02:08:51.471] returnsTuple = [02:08:51.471] #10 0x00000000007ef6c5 in FunctionNext (node=0x2fae5dc008c0) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:51.471] tstore = 0x0 [02:08:51.471] estate = [02:08:51.471] scanslot = 0x2fae5dc07bc8 [02:08:51.471] direction = ForwardScanDirection [02:08:51.471] oldpos = [02:08:51.471] att = [02:08:51.471] alldone = [02:08:51.471] funcno = [02:08:51.471] #11 0x00000000007dacfa in ExecScanFetch (node=0x2fae5dc008c0, epqstate=0x0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/include/executor/execScan.h:135 [02:08:51.471] No locals. [02:08:51.471] #12 ExecScanExtended (node=0x2fae5dc008c0, epqstate=0x0, qual=0x0, projInfo=0x2fae5dc01520, accessMtd=, recheckMtd=) at ../src/include/executor/execScan.h:196 [02:08:51.471] slot = [02:08:51.471] econtext = 0x2fae5dc00620 [02:08:51.471] slot = [02:08:51.471] #13 ExecScan (node=0x2fae5dc008c0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/backend/executor/execScan.c:59 [02:08:51.471] qual = 0x0 [02:08:51.471] epqstate = 0x0 [02:08:51.471] projInfo = 0x2fae5dc01520 [02:08:51.471] #14 0x000000000080f116 in ExecProcNode (node=0x2fae5dc008c0) at ../src/include/executor/executor.h:327 [02:08:51.471] No locals. [02:08:51.471] #15 ExecSort (pstate=0x2fae5dc00380) at ../src/backend/executor/nodeSort.c:149 [02:08:51.471] plannode = [02:08:51.471] tuplesortopts = [02:08:51.471] outerNode = 0x2fae5dc008c0 [02:08:51.471] tupDesc = [02:08:51.471] node = 0x2fae5dc00380 [02:08:51.471] estate = 0x2fae5dc00100 [02:08:51.471] tuplesortstate = 0x2fae5dc67100 [02:08:51.471] dir = ForwardScanDirection [02:08:51.471] slot = [02:08:51.471] #16 0x00000000007cee7b in ExecProcNode (node=0x2fae5dc00380) at ../src/include/executor/executor.h:327 [02:08:51.471] No locals. [02:08:51.471] #17 ExecutePlan (queryDesc=0x2fae5d5fd5b0, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x2fae5d57a1c0) at ../src/backend/executor/execMain.c:1736 [02:08:51.471] estate = 0x2fae5dc00100 [02:08:51.471] planstate = 0x2fae5dc00380 [02:08:51.471] current_tuple_count = 0 [02:08:51.471] use_parallel_mode = [02:08:51.471] slot = [02:08:51.471] #18 standard_ExecutorRun (queryDesc=0x2fae5d5fd5b0, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:51.471] estate = 0x2fae5dc00100 [02:08:51.471] oldcontext = 0x2fae5d57a000 [02:08:51.471] operation = CMD_SELECT [02:08:51.471] dest = 0x2fae5d57a1c0 [02:08:51.471] sendTuples = true [02:08:51.471] #19 0x0000000830fd4d74 in pgss_ExecutorRun (queryDesc=0x2fae5d5fd5b0, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:51.471] _local_sigjmp_buf = {{_sjb = {35181645134, 0, 34917897864, 34917898032, 34917897872, 13222088, 1, 52425937376688, 8192895, 52425943679745, 34917898032, 0}}} [02:08:51.471] _save_exception_stack = 0x82144d810 [02:08:51.471] _save_context_stack = 0x0 [02:08:51.471] _do_rethrow = false [02:08:51.471] #20 0x00000000007d3ec8 in ParallelQueryMain (seg=0x2fae5d415fc0, toc=0x83e3f4000) at ../src/backend/executor/execParallel.c:1583 [02:08:51.471] pwcxt = {seg = 0x2fae5d415fc0, toc = 0x83e3f4000} [02:08:51.471] instrument_options = [02:08:51.471] fpes = 0x83e408760 [02:08:51.471] receiver = 0x2fae5d57a1c0 [02:08:51.471] instrumentation = 0x0 [02:08:51.471] jit_instrumentation = 0x0 [02:08:51.471] queryDesc = 0x2fae5d5fd5b0 [02:08:51.471] area_space = [02:08:51.471] area = 0x2fae5dc5a4f8 [02:08:51.471] buffer_usage = [02:08:51.471] wal_usage = [02:08:51.471] #21 0x00000000006977f1 in ParallelWorkerMain (main_arg=) at ../src/backend/access/transam/parallel.c:1571 [02:08:51.471] seg = 0x2fae5d415fc0 [02:08:51.471] toc = 0x83e3f4000 [02:08:51.471] fps = 0x83e40d9c0 [02:08:51.471] error_queue_space = [02:08:51.471] mq = [02:08:51.471] mqh = [02:08:51.471] entrypointstate = [02:08:51.471] library_name = [02:08:51.471] function_name = [02:08:51.471] entrypt = 0x7d3c40 [02:08:51.471] libraryspace = [02:08:51.471] tstatespace = [02:08:51.471] pendingsyncsspace = [02:08:51.471] relmapperspace = [02:08:51.471] reindexspace = [02:08:51.471] combocidspace = [02:08:51.471] session_dsm_handle_space = [02:08:51.471] asnapspace = [02:08:51.471] tsnapspace = [02:08:51.471] asnapshot = 0x2fae5d57a100 [02:08:51.471] tsnapshot = [02:08:51.471] gucspace = [02:08:51.471] uncommittedenumsspace = [02:08:51.471] clientconninfospace = [02:08:51.471] #22 0x00000000009107ec in BackgroundWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/bgworker.c:865 [02:08:51.471] local_sigjmp_buf = {{_sjb = {9504693, 52425936780680, 34917898248, 34917898400, 10342416, 10175840, 52425936780680, 34917898256, 206158431103, -2147815357, -1, 1}}} [02:08:51.471] worker = 0x2fae5d56bd88 [02:08:51.471] entrypt = 0x0 [02:08:51.471] #23 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_BG_WORKER, child_slot=239, startup_data=startup_data@entry=0x2fae5d4272d8, startup_data_len=startup_data_len@entry=1472, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:51.471] pid = [02:08:51.471] #24 0x0000000000918457 in StartBackgroundWorker (rw=0x2fae5d4272d8) at ../src/backend/postmaster/postmaster.c:4207 [02:08:51.471] bn = 0x2fae5d548cd8 [02:08:51.471] worker_pid = [02:08:51.471] __error = [02:08:51.471] __error = [02:08:51.471] __error = [02:08:51.471] #25 maybe_start_bgworkers () at ../src/backend/postmaster/postmaster.c:4372 [02:08:51.471] rw = 0x2fae5d4272d8 [02:08:51.471] num_launched = 0 [02:08:51.471] now = 0 [02:08:51.471] iter = {cur = 0x2fae5d4278b0, next = , end = } [02:08:51.471] #26 0x000000000091a1d5 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3437 [02:08:51.471] No locals. [02:08:51.471] #27 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:51.471] now = [02:08:51.471] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e160}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5431e406749dcc77}, {pos = 732597312, events = 8, fd = 558161664, user_data = 0x43}, {pos = 1956498551, events = 1412555782, fd = 32, user_data = 0x1000}, {pos = 1, events = 0, fd = 558161720, user_data = 0x2000}, {pos = 558161520, events = 8, fd = 732331702, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 558161536, events = 8, fd = 684059333, user_data = 0x82144df38}, {pos = 558161704, events = 8, fd = 558161560, user_data = 0x82144df10}, {pos = 730683604, events = 8, fd = 730683604, user_data = 0x2fae5d00a408}, {pos = 3, events = 0, fd = 558161664, user_data = 0x2ad628c59b2b}, {pos = 558161704, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 558162160, user_data = 0x82ba62ad4}, {pos = 558161728, events = 8, fd = 12288, user_data = 0x2000}, {pos = 1560344136, events = 12206, fd = 0, user_data = 0x0}, {pos = 558161816, events = 8, fd = 558162264, user_data = 0x82144df80}, {pos = 684057650, events = 10966, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 1560346704, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e248}, {pos = 1564542304, events = 3, fd = 558162336, user_data = 0x2fae5d00f6a8}, {pos = 656, events = 0, fd = 558162264, user_data = 0x82144df98}, {pos = 558161920, events = 8, fd = 684057291, user_data = 0x82144e208}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x2fae5d00a408}, {pos = 730607240, events = 8, fd = 558162504, user_data = 0x82144e1a0}, {pos = 31, events = 0, fd = 0, user_data = 0x2fae5d003008}, {pos = 558161936, events = 8, fd = 558162320, user_data = 0x2ad628c580c7}, {pos = 1560293384, events = 12206, fd = 1560294408, user_data = 0x2fae5d003808}, {pos = 1560296456, events = 12206, fd = 1560309768, user_data = 0x2fae5d007408}, {pos = 1560311816, events = 12206, fd = 1560312840, user_data = 0x2fae5d008008}, {pos = 1560314888, events = 12206, fd = 1560315912, user_data = 0x2fae5d008c08}, {pos = 1560317960, events = 12206, fd = 1560318984, user_data = 0x2fae5d009808}, {pos = 1560321032, events = 12206, fd = 1560322056, user_data = 0x2fae5d00a408}, {pos = 1560324104, events = 12206, fd = 1560325128, user_data = 0x2fae5d00b008}, {pos = 1560327176, events = 12206, fd = 1560328200, user_data = 0x2fae5d00bc08}, {pos = 1560330248, events = 12206, fd = 1560331272, user_data = 0x2fae5d00c808}, {pos = 1560333320, events = 12206, fd = 1560338440, user_data = 0x2fae5d00e408}, {pos = 1560341512, events = 12206, fd = 269670000, user_data = 0x2fae5d003008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558162504, user_data = 0x82144e010}, {pos = 31, events = 31, fd = 1560293384, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x2fae5d010050}, {pos = 558162480, events = 8, fd = 684030908, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x2fae5d010050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82b9f3d70 }, {pos = 1560293384, events = 12206, fd = 2859976, user_data = 0x829a4b549}, {pos = 1, events = 0, fd = 1561010184, user_data = 0x82144e230}, {pos = 698656485, events = 8, fd = 731856240, user_data = 0xc7f098 }, {pos = 731856240, events = 8, fd = 1560323080, user_data = 0x82144e310}, {pos = 684030388, events = 10966, fd = 16, user_data = 0x2fae00000001}, {pos = 684029998, events = 10966, fd = 1560293384, user_data = 0x82144e238}, {pos = 558162704, events = 8, fd = 7176, user_data = 0xc}, {pos = 684112704, events = 10966, fd = 0, user_data = 0x82144037f}, {pos = 11979292, events = 0, fd = 558162624, user_data = 0x829a415d0 <__pthread_cleanup_pop_imp+48>}, {pos = 732525312, events = 8, fd = 732534256, user_data = 0x0}, {pos = 8128, events = 0, fd = 558162672, user_data = 0x829a4bb9d}, {pos = 558162688, events = 8, fd = 698619344, user_data = 0x82ba97300 <__thr_jtable>}, {pos = 732534256, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 558162736, events = 8, fd = 698661789, user_data = 0x2fae5d0b2008}, {pos = 85133, events = 0, fd = 558162832, user_data = 0x829a43a7d}} [02:08:51.471] last_touch_time = 1778896893 [02:08:51.471] last_lockfile_recheck_time = 1778896893 [02:08:51.471] nevents = [02:08:51.471] #28 0x0000000000917a36 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82144e9e8) at ../src/backend/postmaster/postmaster.c:1415 [02:08:51.471] optctx = {nargc = 8, nargv = 0x82144e9e8, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x82144f09c "/tmp/pg_regress-6LUnOo", optind = 8, optopt = 107, place = 0x2f17c5 ""} [02:08:51.471] userDoption = [02:08:51.471] listen_addr_saved = false [02:08:51.471] output_config_variable = [02:08:51.471] opt = [02:08:51.471] status = [02:08:51.471] #29 0x000000000083c50d in main (argc=8, argv=0x82144e9e8) at ../src/backend/main/main.c:231 [02:08:51.471] do_check_root = [02:08:51.471] dispatch_option = DISPATCH_POSTMASTER [02:08:51.479] [02:08:51.479] [02:08:51.479] [02:08:51.537] dumping /tmp/cores/postgres.88267.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:51.666] [New LWP 102128] [02:08:51.730] Core was generated by `postgres: parallel worker for PID 88255 '. [02:08:51.730] Program terminated with signal SIGABRT, Aborted. [02:08:51.730] Sent by thr_kill() from pid 88267 and user 1002. [02:08:51.730] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:51.780] [02:08:51.780] Thread 1 (LWP 102128): [02:08:51.780] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:51.780] No symbol table info available. [02:08:51.780] #1 0x000000082b96ea64 in raise () from /lib/libc.so.7 [02:08:51.780] No symbol table info available. [02:08:51.780] #2 0x000000082ba22a59 in abort () from /lib/libc.so.7 [02:08:51.780] No symbol table info available. [02:08:51.780] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:51.780] No locals. [02:08:51.780] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:51.780] s = [02:08:51.780] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x2fae5d42a500, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:51.780] t = [02:08:51.780] shtabstats = 0x8401c5300 [02:08:51.780] dboid = 0 [02:08:51.780] lstats = 0x2fae5d42a100 [02:08:51.780] tabentry = 0x8401c5318 [02:08:51.780] dbentry = [02:08:51.780] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:51.780] entry_ref = 0x2fae5d42a500 [02:08:51.780] kind = [02:08:51.780] kind_info = [02:08:51.780] iter = [02:08:51.780] entry_ref = [02:08:51.780] kind = [02:08:51.780] kind_info = [02:08:51.780] #7 0x0000000830fd607b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_13, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:51.780] qbuffer_size = 0 [02:08:51.780] hstat = {hash_table = 0x2fae5d56d000, curbucket = 0, nbuckets = 0, curitem = 0x10, pnextitem = 844442110001152, curpartition = 0, exclusive = 182} [02:08:51.780] rsinfo = 0x82144d390 [02:08:51.780] userid = 10 [02:08:51.780] is_allowed_role = [02:08:51.780] qbuffer = 0x0 [02:08:51.780] extent = 0 [02:08:51.780] gc_count = 0 [02:08:51.780] p = [02:08:51.780] #8 0x0000000830fd5dc8 in pg_stat_statements_1_13 (fcinfo=0x18ef0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1515 [02:08:51.780] showtext = false [02:08:51.780] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x2fae5dc00730, econtext=0x2fae5dc010f8, argContext=, expectedDesc=0x2fae5dcc2438, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:51.780] result = 424 [02:08:51.780] fcusage = {fs = 0x0, save_f_total_time = {ticks = 16}, save_total = {ticks = 52425936803032}, start = {ticks = 0}} [02:08:51.780] tmptup = {t_len = 4, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 54304}, t_tableOid = 8, t_data = 0xb1e6d9 } [02:08:51.780] first_time = true [02:08:51.780] rsinfo = {type = T_ReturnSetInfo, econtext = 0x2fae5dc010f8, expectedDesc = 0x2fae5dcc2438, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x2fae5dcc77f0, setDesc = 0x2fae5dcd3838} [02:08:51.780] tupstore = 0x0 [02:08:51.780] tupdesc = 0x0 [02:08:51.780] returnsSet = true [02:08:51.780] callerContext = 0x2fae5dc00000 [02:08:51.780] funcrettype = 2249 [02:08:51.780] fcinfo = 0x2fae5dcb2100 [02:08:51.780] returnsTuple = [02:08:51.780] #10 0x00000000007ef6c5 in FunctionNext (node=0x2fae5dc00ee8) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:51.780] tstore = 0x0 [02:08:51.780] estate = [02:08:51.780] scanslot = 0x2fae5dc0bb78 [02:08:51.780] direction = ForwardScanDirection [02:08:51.780] oldpos = [02:08:51.780] att = [02:08:51.780] alldone = [02:08:51.780] funcno = [02:08:51.780] #11 0x00000000007dacfa in ExecScanFetch (node=0x2fae5dc00ee8, epqstate=0x0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/include/executor/execScan.h:135 [02:08:51.780] No locals. [02:08:51.780] #12 ExecScanExtended (node=0x2fae5dc00ee8, epqstate=0x0, qual=0x2fae5dc6ce18, projInfo=0x2fae5dc01c88, accessMtd=, recheckMtd=) at ../src/include/executor/execScan.h:196 [02:08:51.780] slot = [02:08:51.780] econtext = 0x2fae5dc010f8 [02:08:51.780] slot = [02:08:51.780] #13 ExecScan (node=0x2fae5dc00ee8, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/backend/executor/execScan.c:59 [02:08:51.780] qual = 0x2fae5dc6ce18 [02:08:51.780] epqstate = 0x0 [02:08:51.780] projInfo = 0x2fae5dc01c88 [02:08:51.780] #14 0x000000000080f16c in ExecProcNode (node=0x2fae5dc00ee8) at ../src/include/executor/executor.h:327 [02:08:51.780] No locals. [02:08:51.780] #15 ExecSort (pstate=0x2fae5dc00380) at ../src/backend/executor/nodeSort.c:135 [02:08:51.780] plannode = [02:08:51.780] tuplesortopts = [02:08:51.780] outerNode = 0x2fae5dc00ee8 [02:08:51.780] tupDesc = [02:08:51.780] node = 0x2fae5dc00380 [02:08:51.780] estate = 0x2fae5dc00100 [02:08:51.780] tuplesortstate = 0x2fae5dcb4100 [02:08:51.780] dir = ForwardScanDirection [02:08:51.780] slot = [02:08:51.780] #16 0x00000000007e929d in ExecProcNode (node=0x2fae5dc00380) at ../src/include/executor/executor.h:327 [02:08:51.780] No locals. [02:08:51.780] #17 fetch_input_tuple (aggstate=aggstate@entry=0x2fae5dc008a0) at ../src/backend/executor/nodeAgg.c:564 [02:08:51.780] slot = [02:08:51.780] #18 0x00000000007e7249 in agg_retrieve_direct (aggstate=0x2fae5dc008a0) at ../src/backend/executor/nodeAgg.c:2453 [02:08:51.780] node = 0x2fae5d57a2f0 [02:08:51.780] numGroupingSets = 1 [02:08:51.780] econtext = 0x2fae5dc00dd8 [02:08:51.780] firstSlot = 0x2fae5dc01d98 [02:08:51.780] tmpcontext = 0x2fae5dc00620 [02:08:51.780] peragg = 0x2fae5dcc75c0 [02:08:51.780] pergroups = 0x2fae5dcc8110 [02:08:51.780] numReset = 1 [02:08:51.780] i = [02:08:51.780] nextSetSize = 0 [02:08:51.780] outerslot = [02:08:51.780] currentSet = [02:08:51.780] result = [02:08:51.780] hasGroupingSets = [02:08:51.780] #19 ExecAgg (pstate=0x2fae5dc008a0) at ../src/backend/executor/nodeAgg.c:2268 [02:08:51.780] node = 0x2fae5dc008a0 [02:08:51.780] result = 0x0 [02:08:51.780] #20 0x00000000007cee7b in ExecProcNode (node=0x2fae5dc008a0) at ../src/include/executor/executor.h:327 [02:08:51.780] No locals. [02:08:51.780] #21 ExecutePlan (queryDesc=0x2fae5d5fcd18, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x2fae5d57a1c0) at ../src/backend/executor/execMain.c:1736 [02:08:51.780] estate = 0x2fae5dc00100 [02:08:51.780] planstate = 0x2fae5dc008a0 [02:08:51.780] current_tuple_count = 0 [02:08:51.780] use_parallel_mode = [02:08:51.780] slot = [02:08:51.780] #22 standard_ExecutorRun (queryDesc=0x2fae5d5fcd18, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:51.780] estate = 0x2fae5dc00100 [02:08:51.780] oldcontext = 0x2fae5d57a000 [02:08:51.780] operation = CMD_SELECT [02:08:51.780] dest = 0x2fae5d57a1c0 [02:08:51.780] sendTuples = true [02:08:51.780] #23 0x0000000830fd4d74 in pgss_ExecutorRun (queryDesc=0x2fae5d5fcd18, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:51.780] _local_sigjmp_buf = {{_sjb = {35181645134, 0, 34917897864, 34917898032, 34917897872, 13222088, 1, 52425937374488, 8192895, 52425943681025, 34917898032, 0}}} [02:08:51.780] _save_exception_stack = 0x82144d810 [02:08:51.780] _save_context_stack = 0x0 [02:08:51.780] _do_rethrow = false [02:08:51.780] #24 0x00000000007d3ec8 in ParallelQueryMain (seg=0x2fae5d415fc0, toc=0x83efa9000) at ../src/backend/executor/execParallel.c:1583 [02:08:51.780] pwcxt = {seg = 0x2fae5d415fc0, toc = 0x83efa9000} [02:08:51.780] instrument_options = [02:08:51.780] fpes = 0x83efbcf00 [02:08:51.780] receiver = 0x2fae5d57a1c0 [02:08:51.780] instrumentation = 0x0 [02:08:51.780] jit_instrumentation = 0x0 [02:08:51.780] queryDesc = 0x2fae5d5fcd18 [02:08:51.780] area_space = [02:08:51.780] area = 0x2fae5dc5a3f8 [02:08:51.780] buffer_usage = [02:08:51.780] wal_usage = [02:08:51.780] #25 0x00000000006977f1 in ParallelWorkerMain (main_arg=) at ../src/backend/access/transam/parallel.c:1571 [02:08:51.780] seg = 0x2fae5d415fc0 [02:08:51.780] toc = 0x83efa9000 [02:08:51.780] fps = 0x83efc2160 [02:08:51.780] error_queue_space = [02:08:51.780] mq = [02:08:51.780] mqh = [02:08:51.780] entrypointstate = [02:08:51.780] library_name = [02:08:51.780] function_name = [02:08:51.780] entrypt = 0x7d3c40 [02:08:51.780] libraryspace = [02:08:51.780] tstatespace = [02:08:51.780] pendingsyncsspace = [02:08:51.780] relmapperspace = [02:08:51.780] reindexspace = [02:08:51.780] combocidspace = [02:08:51.780] session_dsm_handle_space = [02:08:51.780] asnapspace = [02:08:51.780] tsnapspace = [02:08:51.780] asnapshot = 0x2fae5d57a100 [02:08:51.780] tsnapshot = [02:08:51.780] gucspace = [02:08:51.780] uncommittedenumsspace = [02:08:51.780] clientconninfospace = [02:08:51.780] #26 0x00000000009107ec in BackgroundWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/bgworker.c:865 [02:08:51.780] local_sigjmp_buf = {{_sjb = {9504693, 52425936782104, 34917898248, 34917898400, 10342416, 10175840, 52425936782104, 34917898256, 206158431103, -2147815357, -1, 1}}} [02:08:51.780] worker = 0x2fae5d56c318 [02:08:51.780] entrypt = 0x0 [02:08:51.780] #27 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_BG_WORKER, child_slot=239, startup_data=startup_data@entry=0x2fae5d4272d8, startup_data_len=startup_data_len@entry=1472, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:51.780] pid = [02:08:51.780] #28 0x0000000000918457 in StartBackgroundWorker (rw=0x2fae5d4272d8) at ../src/backend/postmaster/postmaster.c:4207 [02:08:51.780] bn = 0x2fae5d548cd8 [02:08:51.780] worker_pid = [02:08:51.780] __error = [02:08:51.780] __error = [02:08:51.780] __error = [02:08:51.780] #29 maybe_start_bgworkers () at ../src/backend/postmaster/postmaster.c:4372 [02:08:51.780] rw = 0x2fae5d4272d8 [02:08:51.780] num_launched = 0 [02:08:51.780] now = 0 [02:08:51.780] iter = {cur = 0x2fae5d4278b0, next = , end = } [02:08:51.780] #30 0x000000000091a1d5 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3437 [02:08:51.780] No locals. [02:08:51.780] #31 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:51.780] now = [02:08:51.780] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e160}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5431e406749dcc77}, {pos = 732597312, events = 8, fd = 558161664, user_data = 0x43}, {pos = 1956498551, events = 1412555782, fd = 32, user_data = 0x1000}, {pos = 1, events = 0, fd = 558161720, user_data = 0x2000}, {pos = 558161520, events = 8, fd = 732331702, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 558161536, events = 8, fd = 684059333, user_data = 0x82144df38}, {pos = 558161704, events = 8, fd = 558161560, user_data = 0x82144df10}, {pos = 730683604, events = 8, fd = 730683604, user_data = 0x2fae5d00a408}, {pos = 3, events = 0, fd = 558161664, user_data = 0x2ad628c59b2b}, {pos = 558161704, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 558162160, user_data = 0x82ba62ad4}, {pos = 558161728, events = 8, fd = 12288, user_data = 0x2000}, {pos = 1560344136, events = 12206, fd = 0, user_data = 0x0}, {pos = 558161816, events = 8, fd = 558162264, user_data = 0x82144df80}, {pos = 684057650, events = 10966, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 1560346704, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e248}, {pos = 1564542304, events = 3, fd = 558162336, user_data = 0x2fae5d00f6a8}, {pos = 656, events = 0, fd = 558162264, user_data = 0x82144df98}, {pos = 558161920, events = 8, fd = 684057291, user_data = 0x82144e208}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x2fae5d00a408}, {pos = 730607240, events = 8, fd = 558162504, user_data = 0x82144e1a0}, {pos = 31, events = 0, fd = 0, user_data = 0x2fae5d003008}, {pos = 558161936, events = 8, fd = 558162320, user_data = 0x2ad628c580c7}, {pos = 1560293384, events = 12206, fd = 1560294408, user_data = 0x2fae5d003808}, {pos = 1560296456, events = 12206, fd = 1560309768, user_data = 0x2fae5d007408}, {pos = 1560311816, events = 12206, fd = 1560312840, user_data = 0x2fae5d008008}, {pos = 1560314888, events = 12206, fd = 1560315912, user_data = 0x2fae5d008c08}, {pos = 1560317960, events = 12206, fd = 1560318984, user_data = 0x2fae5d009808}, {pos = 1560321032, events = 12206, fd = 1560322056, user_data = 0x2fae5d00a408}, {pos = 1560324104, events = 12206, fd = 1560325128, user_data = 0x2fae5d00b008}, {pos = 1560327176, events = 12206, fd = 1560328200, user_data = 0x2fae5d00bc08}, {pos = 1560330248, events = 12206, fd = 1560331272, user_data = 0x2fae5d00c808}, {pos = 1560333320, events = 12206, fd = 1560338440, user_data = 0x2fae5d00e408}, {pos = 1560341512, events = 12206, fd = 269670000, user_data = 0x2fae5d003008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558162504, user_data = 0x82144e010}, {pos = 31, events = 31, fd = 1560293384, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x2fae5d010050}, {pos = 558162480, events = 8, fd = 684030908, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x2fae5d010050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82b9f3d70 }, {pos = 1560293384, events = 12206, fd = 2859976, user_data = 0x829a4b549}, {pos = 1, events = 0, fd = 1561010184, user_data = 0x82144e230}, {pos = 698656485, events = 8, fd = 731856240, user_data = 0xc7f098 }, {pos = 731856240, events = 8, fd = 1560323080, user_data = 0x82144e310}, {pos = 684030388, events = 10966, fd = 16, user_data = 0x2fae00000001}, {pos = 684029998, events = 10966, fd = 1560293384, user_data = 0x82144e238}, {pos = 558162704, events = 8, fd = 7176, user_data = 0xc}, {pos = 684112704, events = 10966, fd = 0, user_data = 0x82144037f}, {pos = 11979292, events = 0, fd = 558162624, user_data = 0x829a415d0 <__pthread_cleanup_pop_imp+48>}, {pos = 732525312, events = 8, fd = 732534256, user_data = 0x0}, {pos = 8128, events = 0, fd = 558162672, user_data = 0x829a4bb9d}, {pos = 558162688, events = 8, fd = 698619344, user_data = 0x82ba97300 <__thr_jtable>}, {pos = 732534256, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 558162736, events = 8, fd = 698661789, user_data = 0x2fae5d0b2008}, {pos = 85133, events = 0, fd = 558162832, user_data = 0x829a43a7d}} [02:08:51.780] last_touch_time = 1778896893 [02:08:51.780] last_lockfile_recheck_time = 1778896893 [02:08:51.780] nevents = [02:08:51.780] #32 0x0000000000917a36 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82144e9e8) at ../src/backend/postmaster/postmaster.c:1415 [02:08:51.780] optctx = {nargc = 8, nargv = 0x82144e9e8, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x82144f09c "/tmp/pg_regress-6LUnOo", optind = 8, optopt = 107, place = 0x2f17c5 ""} [02:08:51.780] userDoption = [02:08:51.780] listen_addr_saved = false [02:08:51.780] output_config_variable = [02:08:51.780] opt = [02:08:51.780] status = [02:08:51.780] #33 0x000000000083c50d in main (argc=8, argv=0x82144e9e8) at ../src/backend/main/main.c:231 [02:08:51.780] do_check_root = [02:08:51.780] dispatch_option = DISPATCH_POSTMASTER [02:08:51.789] [02:08:51.789] [02:08:51.789] [02:08:51.847] dumping /tmp/cores/postgres.88770.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:51.977] [New LWP 102216] [02:08:52.044] Core was generated by `postgres: parallel worker for PID 88719 '. [02:08:52.044] Program terminated with signal SIGABRT, Aborted. [02:08:52.044] Sent by thr_kill() from pid 88770 and user 1002. [02:08:52.044] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:52.094] [02:08:52.094] Thread 1 (LWP 102216): [02:08:52.094] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:52.094] No symbol table info available. [02:08:52.094] #1 0x000000082b96ea64 in raise () from /lib/libc.so.7 [02:08:52.094] No symbol table info available. [02:08:52.094] #2 0x000000082ba22a59 in abort () from /lib/libc.so.7 [02:08:52.094] No symbol table info available. [02:08:52.094] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:52.094] No locals. [02:08:52.094] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:52.094] s = [02:08:52.094] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x2fae5d42a500, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:52.094] t = [02:08:52.094] shtabstats = 0x83f1f5200 [02:08:52.094] dboid = 0 [02:08:52.094] lstats = 0x2fae5d42a100 [02:08:52.094] tabentry = 0x83f1f5218 [02:08:52.094] dbentry = [02:08:52.094] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:52.094] entry_ref = 0x2fae5d42a500 [02:08:52.094] kind = [02:08:52.094] kind_info = [02:08:52.094] iter = [02:08:52.094] entry_ref = [02:08:52.094] kind = [02:08:52.094] kind_info = [02:08:52.094] #7 0x0000000830fd607b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_13, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:52.094] qbuffer_size = 0 [02:08:52.094] hstat = {hash_table = 0xa971a0 , curbucket = 184, nbuckets = 65538, curitem = 0x2, pnextitem = 0, curpartition = 1565970432, exclusive = 174} [02:08:52.094] rsinfo = 0x82144d420 [02:08:52.094] userid = 49152 [02:08:52.094] is_allowed_role = [02:08:52.094] qbuffer = 0x2fae5dc04100 "~" [02:08:52.094] extent = 0 [02:08:52.094] gc_count = 1 [02:08:52.094] p = [02:08:52.094] #8 0x0000000830fd5dc8 in pg_stat_statements_1_13 (fcinfo=0x18f48) at ../contrib/pg_stat_statements/pg_stat_statements.c:1515 [02:08:52.094] showtext = false [02:08:52.094] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x2fae5dc007c0, econtext=0x2fae5dc00620, argContext=, expectedDesc=0x2fae5dcb8838, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:52.094] result = 34917897456 [02:08:52.094] fcusage = {fs = 0x0, save_f_total_time = {ticks = 52425944485888}, save_total = {ticks = 1}, start = {ticks = 8319092743133462534}} [02:08:52.094] tmptup = {t_len = 1565986944, t_self = {ip_blkid = {bi_hi = 12206, bi_lo = 0}, ip_posid = 54320}, t_tableOid = 8, t_data = 0xb1ea78 } [02:08:52.094] first_time = true [02:08:52.094] rsinfo = {type = T_ReturnSetInfo, econtext = 0x2fae5dc00620, expectedDesc = 0x2fae5dcb8838, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x2fae5dcc0018, setDesc = 0x2fae5dcd5c20} [02:08:52.094] tupstore = 0x0 [02:08:52.094] tupdesc = 0x0 [02:08:52.094] returnsSet = true [02:08:52.094] callerContext = 0x2fae5dc00000 [02:08:52.094] funcrettype = 2249 [02:08:52.094] fcinfo = 0x2fae5dc68100 [02:08:52.094] returnsTuple = [02:08:52.094] #10 0x00000000007ef6c5 in FunctionNext (node=0x2fae5dc00c10) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:52.094] tstore = 0x0 [02:08:52.094] estate = [02:08:52.094] scanslot = 0x2fae5dc66fd0 [02:08:52.094] direction = ForwardScanDirection [02:08:52.094] oldpos = [02:08:52.094] att = [02:08:52.094] alldone = [02:08:52.094] funcno = [02:08:52.094] #11 0x00000000007f68fc in ExecProcNode (node=0x2fae5dc00c10) at ../src/include/executor/executor.h:327 [02:08:52.094] No locals. [02:08:52.094] #12 ExecHashJoinImpl (pstate=0x2fae5dc009b0, parallel=false) at ../src/backend/executor/nodeHashjoin.c:322 [02:08:52.094] hashvalue = 12206 [02:08:52.094] batchno = 12206 [02:08:52.094] node = 0x2fae5dc009b0 [02:08:52.094] joinqual = 0x0 [02:08:52.094] otherqual = 0x0 [02:08:52.094] outerNode = 0x2fae5dc00c10 [02:08:52.094] hashNode = 0x2fae5dc65448 [02:08:52.094] hashtable = 0x0 [02:08:52.094] econtext = 0x2fae5dc00880 [02:08:52.094] parallel_state = 0x0 [02:08:52.094] outerTupleSlot = [02:08:52.094] build_barrier = [02:08:52.094] build_barrier = [02:08:52.094] shouldFree = [02:08:52.094] mintuple = [02:08:52.094] __error = [02:08:52.094] #13 ExecHashJoin (pstate=0x2fae5dc009b0) at ../src/backend/executor/nodeHashjoin.c:808 [02:08:52.094] No locals. [02:08:52.094] #14 0x000000000080f116 in ExecProcNode (node=0x2fae5dc009b0) at ../src/include/executor/executor.h:327 [02:08:52.094] No locals. [02:08:52.094] #15 ExecSort (pstate=0x2fae5dc00380) at ../src/backend/executor/nodeSort.c:149 [02:08:52.094] plannode = [02:08:52.094] tuplesortopts = [02:08:52.094] outerNode = 0x2fae5dc009b0 [02:08:52.094] tupDesc = [02:08:52.094] node = 0x2fae5dc00380 [02:08:52.094] estate = 0x2fae5dc00100 [02:08:52.094] tuplesortstate = 0x2fae5dcc5100 [02:08:52.094] dir = ForwardScanDirection [02:08:52.094] slot = [02:08:52.094] #16 0x00000000007cee7b in ExecProcNode (node=0x2fae5dc00380) at ../src/include/executor/executor.h:327 [02:08:52.094] No locals. [02:08:52.094] #17 ExecutePlan (queryDesc=0x2fae5dc5d390, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x2fae5d57a1c0) at ../src/backend/executor/execMain.c:1736 [02:08:52.094] estate = 0x2fae5dc00100 [02:08:52.094] planstate = 0x2fae5dc00380 [02:08:52.094] current_tuple_count = 0 [02:08:52.094] use_parallel_mode = [02:08:52.094] slot = [02:08:52.094] #18 standard_ExecutorRun (queryDesc=0x2fae5dc5d390, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:52.094] estate = 0x2fae5dc00100 [02:08:52.094] oldcontext = 0x2fae5d57a000 [02:08:52.094] operation = CMD_SELECT [02:08:52.094] dest = 0x2fae5d57a1c0 [02:08:52.094] sendTuples = true [02:08:52.094] #19 0x0000000830fd4d74 in pgss_ExecutorRun (queryDesc=0x2fae5dc5d390, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:52.094] _local_sigjmp_buf = {{_sjb = {35181645134, 0, 34917897864, 34917898032, 34917897872, 13222088, 1, 52425944060816, 8192895, 52425943679745, 34917898032, 0}}} [02:08:52.094] _save_exception_stack = 0x82144d810 [02:08:52.094] _save_context_stack = 0x0 [02:08:52.094] _do_rethrow = false [02:08:52.094] #20 0x00000000007d3ec8 in ParallelQueryMain (seg=0x2fae5d4a9808, toc=0x83f1d4000) at ../src/backend/executor/execParallel.c:1583 [02:08:52.094] pwcxt = {seg = 0x2fae5d4a9808, toc = 0x83f1d4000} [02:08:52.094] instrument_options = [02:08:52.094] fpes = 0x83f1ed520 [02:08:52.094] receiver = 0x2fae5d57a1c0 [02:08:52.094] instrumentation = 0x0 [02:08:52.094] jit_instrumentation = 0x0 [02:08:52.094] queryDesc = 0x2fae5dc5d390 [02:08:52.094] area_space = [02:08:52.094] area = 0x2fae5dc6abf8 [02:08:52.094] buffer_usage = [02:08:52.094] wal_usage = [02:08:52.094] #21 0x00000000006977f1 in ParallelWorkerMain (main_arg=) at ../src/backend/access/transam/parallel.c:1571 [02:08:52.094] seg = 0x2fae5d4a9808 [02:08:52.094] toc = 0x83f1d4000 [02:08:52.094] fps = 0x83f1f27a0 [02:08:52.094] error_queue_space = [02:08:52.094] mq = [02:08:52.094] mqh = [02:08:52.094] entrypointstate = [02:08:52.094] library_name = [02:08:52.094] function_name = [02:08:52.094] entrypt = 0x7d3c40 [02:08:52.094] libraryspace = [02:08:52.094] tstatespace = [02:08:52.094] pendingsyncsspace = [02:08:52.094] relmapperspace = [02:08:52.094] reindexspace = [02:08:52.094] combocidspace = [02:08:52.094] session_dsm_handle_space = [02:08:52.094] asnapspace = [02:08:52.094] tsnapspace = [02:08:52.094] asnapshot = 0x2fae5d57a100 [02:08:52.094] tsnapshot = [02:08:52.094] gucspace = [02:08:52.094] uncommittedenumsspace = [02:08:52.094] clientconninfospace = [02:08:52.094] #22 0x00000000009107ec in BackgroundWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/bgworker.c:865 [02:08:52.094] local_sigjmp_buf = {{_sjb = {9504693, 52425936856248, 34917898248, 34917898400, 10342416, 10175840, 52425936856248, 34917898256, 206158431103, -2147815357, -1, 1}}} [02:08:52.094] worker = 0x2fae5d57e4b8 [02:08:52.094] entrypt = 0x0 [02:08:52.094] #23 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_BG_WORKER, child_slot=239, startup_data=startup_data@entry=0x2fae5d4272d8, startup_data_len=startup_data_len@entry=1472, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:52.094] pid = [02:08:52.094] #24 0x0000000000918457 in StartBackgroundWorker (rw=0x2fae5d4272d8) at ../src/backend/postmaster/postmaster.c:4207 [02:08:52.094] bn = 0x2fae5d548cd8 [02:08:52.094] worker_pid = [02:08:52.094] __error = [02:08:52.094] __error = [02:08:52.094] __error = [02:08:52.094] #25 maybe_start_bgworkers () at ../src/backend/postmaster/postmaster.c:4372 [02:08:52.094] rw = 0x2fae5d4272d8 [02:08:52.094] num_launched = 0 [02:08:52.094] now = 0 [02:08:52.094] iter = {cur = 0x2fae5d4278b0, next = , end = } [02:08:52.094] #26 0x000000000091a1d5 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3437 [02:08:52.094] No locals. [02:08:52.094] #27 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:52.094] now = [02:08:52.094] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e160}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5431e406749dcc77}, {pos = 732597312, events = 8, fd = 558161664, user_data = 0x43}, {pos = 1956498551, events = 1412555782, fd = 32, user_data = 0x1000}, {pos = 1, events = 0, fd = 558161720, user_data = 0x2000}, {pos = 558161520, events = 8, fd = 732331702, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 558161536, events = 8, fd = 684059333, user_data = 0x82144df38}, {pos = 558161704, events = 8, fd = 558161560, user_data = 0x82144df10}, {pos = 730683604, events = 8, fd = 730683604, user_data = 0x2fae5d00a408}, {pos = 3, events = 0, fd = 558161664, user_data = 0x2ad628c59b2b}, {pos = 558161704, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 558162160, user_data = 0x82ba62ad4}, {pos = 558161728, events = 8, fd = 12288, user_data = 0x2000}, {pos = 1560344136, events = 12206, fd = 0, user_data = 0x0}, {pos = 558161816, events = 8, fd = 558162264, user_data = 0x82144df80}, {pos = 684057650, events = 10966, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 1560346704, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e248}, {pos = 1564542304, events = 3, fd = 558162336, user_data = 0x2fae5d00f6a8}, {pos = 656, events = 0, fd = 558162264, user_data = 0x82144df98}, {pos = 558161920, events = 8, fd = 684057291, user_data = 0x82144e208}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x2fae5d00a408}, {pos = 730607240, events = 8, fd = 558162504, user_data = 0x82144e1a0}, {pos = 31, events = 0, fd = 0, user_data = 0x2fae5d003008}, {pos = 558161936, events = 8, fd = 558162320, user_data = 0x2ad628c580c7}, {pos = 1560293384, events = 12206, fd = 1560294408, user_data = 0x2fae5d003808}, {pos = 1560296456, events = 12206, fd = 1560309768, user_data = 0x2fae5d007408}, {pos = 1560311816, events = 12206, fd = 1560312840, user_data = 0x2fae5d008008}, {pos = 1560314888, events = 12206, fd = 1560315912, user_data = 0x2fae5d008c08}, {pos = 1560317960, events = 12206, fd = 1560318984, user_data = 0x2fae5d009808}, {pos = 1560321032, events = 12206, fd = 1560322056, user_data = 0x2fae5d00a408}, {pos = 1560324104, events = 12206, fd = 1560325128, user_data = 0x2fae5d00b008}, {pos = 1560327176, events = 12206, fd = 1560328200, user_data = 0x2fae5d00bc08}, {pos = 1560330248, events = 12206, fd = 1560331272, user_data = 0x2fae5d00c808}, {pos = 1560333320, events = 12206, fd = 1560338440, user_data = 0x2fae5d00e408}, {pos = 1560341512, events = 12206, fd = 269670000, user_data = 0x2fae5d003008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558162504, user_data = 0x82144e010}, {pos = 31, events = 31, fd = 1560293384, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x2fae5d010050}, {pos = 558162480, events = 8, fd = 684030908, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x2fae5d010050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82b9f3d70 }, {pos = 1560293384, events = 12206, fd = 2859976, user_data = 0x829a4b549}, {pos = 1, events = 0, fd = 1561010184, user_data = 0x82144e230}, {pos = 698656485, events = 8, fd = 731856240, user_data = 0xc7f098 }, {pos = 731856240, events = 8, fd = 1560323080, user_data = 0x82144e310}, {pos = 684030388, events = 10966, fd = 16, user_data = 0x2fae00000001}, {pos = 684029998, events = 10966, fd = 1560293384, user_data = 0x82144e238}, {pos = 558162704, events = 8, fd = 7176, user_data = 0xc}, {pos = 684112704, events = 10966, fd = 0, user_data = 0x82144037f}, {pos = 11979292, events = 0, fd = 558162624, user_data = 0x829a415d0 <__pthread_cleanup_pop_imp+48>}, {pos = 732525312, events = 8, fd = 732534256, user_data = 0x0}, {pos = 8128, events = 0, fd = 558162672, user_data = 0x829a4bb9d}, {pos = 558162688, events = 8, fd = 698619344, user_data = 0x82ba97300 <__thr_jtable>}, {pos = 732534256, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 558162736, events = 8, fd = 698661789, user_data = 0x2fae5d0b2008}, {pos = 85133, events = 0, fd = 558162832, user_data = 0x829a43a7d}} [02:08:52.094] last_touch_time = 1778896893 [02:08:52.094] last_lockfile_recheck_time = 1778896893 [02:08:52.094] nevents = [02:08:52.094] #28 0x0000000000917a36 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82144e9e8) at ../src/backend/postmaster/postmaster.c:1415 [02:08:52.094] optctx = {nargc = 8, nargv = 0x82144e9e8, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x82144f09c "/tmp/pg_regress-6LUnOo", optind = 8, optopt = 107, place = 0x2f17c5 ""} [02:08:52.094] userDoption = [02:08:52.094] listen_addr_saved = false [02:08:52.094] output_config_variable = [02:08:52.094] opt = [02:08:52.094] status = [02:08:52.094] #29 0x000000000083c50d in main (argc=8, argv=0x82144e9e8) at ../src/backend/main/main.c:231 [02:08:52.094] do_check_root = [02:08:52.094] dispatch_option = DISPATCH_POSTMASTER [02:08:52.102] [02:08:52.102] [02:08:52.102] [02:08:52.160] dumping /tmp/cores/postgres.89234.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:52.290] [New LWP 102121] [02:08:52.355] Core was generated by `postgres: parallel worker for PID 89202 '. [02:08:52.355] Program terminated with signal SIGABRT, Aborted. [02:08:52.355] Sent by thr_kill() from pid 89234 and user 1002. [02:08:52.355] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:52.400] [02:08:52.400] Thread 1 (LWP 102121): [02:08:52.400] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:52.400] No symbol table info available. [02:08:52.400] #1 0x000000082b96ea64 in raise () from /lib/libc.so.7 [02:08:52.400] No symbol table info available. [02:08:52.400] #2 0x000000082ba22a59 in abort () from /lib/libc.so.7 [02:08:52.400] No symbol table info available. [02:08:52.400] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:52.400] No locals. [02:08:52.400] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:52.400] s = [02:08:52.400] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x2fae5d42a500, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:52.400] t = [02:08:52.400] shtabstats = 0x83e633300 [02:08:52.400] dboid = 0 [02:08:52.400] lstats = 0x2fae5d42a100 [02:08:52.400] tabentry = 0x83e633318 [02:08:52.400] dbentry = [02:08:52.400] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:52.400] entry_ref = 0x2fae5d42a500 [02:08:52.400] kind = [02:08:52.400] kind_info = [02:08:52.400] iter = [02:08:52.400] entry_ref = [02:08:52.400] kind = [02:08:52.400] kind_info = [02:08:52.400] #7 0x0000000830fd607b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_13, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:52.400] qbuffer_size = 0 [02:08:52.400] hstat = {hash_table = 0x19, curbucket = 0, nbuckets = 196612, curitem = 0x3b600000000, pnextitem = 6066880889422204023, curpartition = 2104, exclusive = false} [02:08:52.400] rsinfo = 0x82144d450 [02:08:52.400] userid = 10 [02:08:52.400] is_allowed_role = [02:08:52.400] qbuffer = 0x2fae5dc02100 "~" [02:08:52.400] extent = 0 [02:08:52.400] gc_count = 1 [02:08:52.400] p = [02:08:52.400] #8 0x0000000830fd5dc8 in pg_stat_statements_1_13 (fcinfo=0x18ee9) at ../contrib/pg_stat_statements/pg_stat_statements.c:1515 [02:08:52.400] showtext = false [02:08:52.400] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x2fae5dc00730, econtext=0x2fae5dc00620, argContext=, expectedDesc=0x2fae5dcb0838, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:52.400] result = 0 [02:08:52.400] fcusage = {fs = 0x0, save_f_total_time = {ticks = 108947468288}, save_total = {ticks = 13230976}, start = {ticks = 52425937375400}} [02:08:52.400] tmptup = {t_len = 1566560400, t_self = {ip_blkid = {bi_hi = 12206, bi_lo = 0}, ip_posid = 28672}, t_tableOid = 12206, t_data = 0x82144d478} [02:08:52.400] first_time = true [02:08:52.400] rsinfo = {type = T_ReturnSetInfo, econtext = 0x2fae5dc00620, expectedDesc = 0x2fae5dcb0838, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x2fae5dc6c738, setDesc = 0x2fae5dcb5ee0} [02:08:52.400] tupstore = 0x0 [02:08:52.400] tupdesc = 0x0 [02:08:52.400] returnsSet = true [02:08:52.400] callerContext = 0x2fae5dc00000 [02:08:52.400] funcrettype = 2249 [02:08:52.400] fcinfo = 0x2fae5dc0c100 [02:08:52.400] returnsTuple = [02:08:52.400] #10 0x00000000007ef6c5 in FunctionNext (node=0x2fae5dc008c0) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:52.400] tstore = 0x0 [02:08:52.400] estate = [02:08:52.400] scanslot = 0x2fae5dc07bc8 [02:08:52.400] direction = ForwardScanDirection [02:08:52.400] oldpos = [02:08:52.400] att = [02:08:52.400] alldone = [02:08:52.400] funcno = [02:08:52.400] #11 0x00000000007dacfa in ExecScanFetch (node=0x2fae5dc008c0, epqstate=0x0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/include/executor/execScan.h:135 [02:08:52.400] No locals. [02:08:52.400] #12 ExecScanExtended (node=0x2fae5dc008c0, epqstate=0x0, qual=0x2fae5dc00590, projInfo=0x2fae5dc6e290, accessMtd=, recheckMtd=) at ../src/include/executor/execScan.h:196 [02:08:52.400] slot = [02:08:52.400] econtext = 0x2fae5dc00620 [02:08:52.400] slot = [02:08:52.400] #13 ExecScan (node=0x2fae5dc008c0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/backend/executor/execScan.c:59 [02:08:52.400] qual = 0x2fae5dc00590 [02:08:52.400] epqstate = 0x0 [02:08:52.400] projInfo = 0x2fae5dc6e290 [02:08:52.400] #14 0x000000000080f116 in ExecProcNode (node=0x2fae5dc008c0) at ../src/include/executor/executor.h:327 [02:08:52.400] No locals. [02:08:52.400] #15 ExecSort (pstate=0x2fae5dc00380) at ../src/backend/executor/nodeSort.c:149 [02:08:52.400] plannode = [02:08:52.400] tuplesortopts = [02:08:52.400] outerNode = 0x2fae5dc008c0 [02:08:52.400] tupDesc = [02:08:52.400] node = 0x2fae5dc00380 [02:08:52.400] estate = 0x2fae5dc00100 [02:08:52.400] tuplesortstate = 0x2fae5dc67100 [02:08:52.400] dir = ForwardScanDirection [02:08:52.400] slot = [02:08:52.400] #16 0x00000000007cee7b in ExecProcNode (node=0x2fae5dc00380) at ../src/include/executor/executor.h:327 [02:08:52.400] No locals. [02:08:52.400] #17 ExecutePlan (queryDesc=0x2fae5d5fd2f8, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x2fae5d57a1c0) at ../src/backend/executor/execMain.c:1736 [02:08:52.400] estate = 0x2fae5dc00100 [02:08:52.400] planstate = 0x2fae5dc00380 [02:08:52.400] current_tuple_count = 0 [02:08:52.400] use_parallel_mode = [02:08:52.400] slot = [02:08:52.400] #18 standard_ExecutorRun (queryDesc=0x2fae5d5fd2f8, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:52.400] estate = 0x2fae5dc00100 [02:08:52.400] oldcontext = 0x2fae5d57a000 [02:08:52.400] operation = CMD_SELECT [02:08:52.400] dest = 0x2fae5d57a1c0 [02:08:52.400] sendTuples = true [02:08:52.400] #19 0x0000000830fd4d74 in pgss_ExecutorRun (queryDesc=0x2fae5d5fd2f8, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:52.400] _local_sigjmp_buf = {{_sjb = {35181645134, 0, 34917897864, 34917898032, 34917897872, 13222088, 1, 52425937375992, 8192895, 52425943679745, 34917898032, 0}}} [02:08:52.400] _save_exception_stack = 0x82144d810 [02:08:52.400] _save_context_stack = 0x0 [02:08:52.400] _do_rethrow = false [02:08:52.400] #20 0x00000000007d3ec8 in ParallelQueryMain (seg=0x2fae5d4aa018, toc=0x83e006000) at ../src/backend/executor/execParallel.c:1583 [02:08:52.400] pwcxt = {seg = 0x2fae5d4aa018, toc = 0x83e006000} [02:08:52.400] instrument_options = [02:08:52.400] fpes = 0x83e01a180 [02:08:52.400] receiver = 0x2fae5d57a1c0 [02:08:52.400] instrumentation = 0x0 [02:08:52.400] jit_instrumentation = 0x0 [02:08:52.400] queryDesc = 0x2fae5d5fd2f8 [02:08:52.400] area_space = [02:08:52.400] area = 0x2fae5dc5abf8 [02:08:52.400] buffer_usage = [02:08:52.400] wal_usage = [02:08:52.400] #21 0x00000000006977f1 in ParallelWorkerMain (main_arg=) at ../src/backend/access/transam/parallel.c:1571 [02:08:52.400] seg = 0x2fae5d4aa018 [02:08:52.400] toc = 0x83e006000 [02:08:52.400] fps = 0x83e01f4c0 [02:08:52.400] error_queue_space = [02:08:52.400] mq = [02:08:52.400] mqh = [02:08:52.400] entrypointstate = [02:08:52.400] library_name = [02:08:52.400] function_name = [02:08:52.400] entrypt = 0x7d3c40 [02:08:52.400] libraryspace = [02:08:52.400] tstatespace = [02:08:52.400] pendingsyncsspace = [02:08:52.400] relmapperspace = [02:08:52.400] reindexspace = [02:08:52.400] combocidspace = [02:08:52.400] session_dsm_handle_space = [02:08:52.400] asnapspace = [02:08:52.400] tsnapspace = [02:08:52.400] asnapshot = 0x2fae5d57a100 [02:08:52.400] tsnapshot = [02:08:52.400] gucspace = [02:08:52.400] uncommittedenumsspace = [02:08:52.400] clientconninfospace = [02:08:52.400] #22 0x00000000009107ec in BackgroundWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/bgworker.c:865 [02:08:52.400] local_sigjmp_buf = {{_sjb = {9504693, 52425936877112, 34917898248, 34917898400, 10342416, 10175840, 52425936877112, 34917898256, 206158431103, -2147815357, -1, 1}}} [02:08:52.400] worker = 0x2fae5d583638 [02:08:52.400] entrypt = 0x0 [02:08:52.400] #23 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_BG_WORKER, child_slot=240, startup_data=startup_data@entry=0x2fae5d57e3f8, startup_data_len=startup_data_len@entry=1472, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:52.400] pid = [02:08:52.400] #24 0x0000000000918457 in StartBackgroundWorker (rw=0x2fae5d57e3f8) at ../src/backend/postmaster/postmaster.c:4207 [02:08:52.400] bn = 0x2fae5d548d08 [02:08:52.400] worker_pid = [02:08:52.400] __error = [02:08:52.400] __error = [02:08:52.400] __error = [02:08:52.400] #25 maybe_start_bgworkers () at ../src/backend/postmaster/postmaster.c:4372 [02:08:52.400] rw = 0x2fae5d57e3f8 [02:08:52.400] num_launched = 0 [02:08:52.400] now = 0 [02:08:52.400] iter = {cur = 0x2fae5d57e9d0, next = , end = } [02:08:52.400] #26 0x000000000091a1d5 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3437 [02:08:52.400] No locals. [02:08:52.400] #27 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:52.400] now = [02:08:52.400] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e160}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5431e406749dcc77}, {pos = 732597312, events = 8, fd = 558161664, user_data = 0x43}, {pos = 1956498551, events = 1412555782, fd = 32, user_data = 0x1000}, {pos = 1, events = 0, fd = 558161720, user_data = 0x2000}, {pos = 558161520, events = 8, fd = 732331702, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 558161536, events = 8, fd = 684059333, user_data = 0x82144df38}, {pos = 558161704, events = 8, fd = 558161560, user_data = 0x82144df10}, {pos = 730683604, events = 8, fd = 730683604, user_data = 0x2fae5d00a408}, {pos = 3, events = 0, fd = 558161664, user_data = 0x2ad628c59b2b}, {pos = 558161704, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 558162160, user_data = 0x82ba62ad4}, {pos = 558161728, events = 8, fd = 12288, user_data = 0x2000}, {pos = 1560344136, events = 12206, fd = 0, user_data = 0x0}, {pos = 558161816, events = 8, fd = 558162264, user_data = 0x82144df80}, {pos = 684057650, events = 10966, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 1560346704, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e248}, {pos = 1564542304, events = 3, fd = 558162336, user_data = 0x2fae5d00f6a8}, {pos = 656, events = 0, fd = 558162264, user_data = 0x82144df98}, {pos = 558161920, events = 8, fd = 684057291, user_data = 0x82144e208}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x2fae5d00a408}, {pos = 730607240, events = 8, fd = 558162504, user_data = 0x82144e1a0}, {pos = 31, events = 0, fd = 0, user_data = 0x2fae5d003008}, {pos = 558161936, events = 8, fd = 558162320, user_data = 0x2ad628c580c7}, {pos = 1560293384, events = 12206, fd = 1560294408, user_data = 0x2fae5d003808}, {pos = 1560296456, events = 12206, fd = 1560309768, user_data = 0x2fae5d007408}, {pos = 1560311816, events = 12206, fd = 1560312840, user_data = 0x2fae5d008008}, {pos = 1560314888, events = 12206, fd = 1560315912, user_data = 0x2fae5d008c08}, {pos = 1560317960, events = 12206, fd = 1560318984, user_data = 0x2fae5d009808}, {pos = 1560321032, events = 12206, fd = 1560322056, user_data = 0x2fae5d00a408}, {pos = 1560324104, events = 12206, fd = 1560325128, user_data = 0x2fae5d00b008}, {pos = 1560327176, events = 12206, fd = 1560328200, user_data = 0x2fae5d00bc08}, {pos = 1560330248, events = 12206, fd = 1560331272, user_data = 0x2fae5d00c808}, {pos = 1560333320, events = 12206, fd = 1560338440, user_data = 0x2fae5d00e408}, {pos = 1560341512, events = 12206, fd = 269670000, user_data = 0x2fae5d003008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558162504, user_data = 0x82144e010}, {pos = 31, events = 31, fd = 1560293384, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x2fae5d010050}, {pos = 558162480, events = 8, fd = 684030908, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x2fae5d010050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82b9f3d70 }, {pos = 1560293384, events = 12206, fd = 2859976, user_data = 0x829a4b549}, {pos = 1, events = 0, fd = 1561010184, user_data = 0x82144e230}, {pos = 698656485, events = 8, fd = 731856240, user_data = 0xc7f098 }, {pos = 731856240, events = 8, fd = 1560323080, user_data = 0x82144e310}, {pos = 684030388, events = 10966, fd = 16, user_data = 0x2fae00000001}, {pos = 684029998, events = 10966, fd = 1560293384, user_data = 0x82144e238}, {pos = 558162704, events = 8, fd = 7176, user_data = 0xc}, {pos = 684112704, events = 10966, fd = 0, user_data = 0x82144037f}, {pos = 11979292, events = 0, fd = 558162624, user_data = 0x829a415d0 <__pthread_cleanup_pop_imp+48>}, {pos = 732525312, events = 8, fd = 732534256, user_data = 0x0}, {pos = 8128, events = 0, fd = 558162672, user_data = 0x829a4bb9d}, {pos = 558162688, events = 8, fd = 698619344, user_data = 0x82ba97300 <__thr_jtable>}, {pos = 732534256, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 558162736, events = 8, fd = 698661789, user_data = 0x2fae5d0b2008}, {pos = 85133, events = 0, fd = 558162832, user_data = 0x829a43a7d}} [02:08:52.400] last_touch_time = 1778896893 [02:08:52.400] last_lockfile_recheck_time = 1778896893 [02:08:52.400] nevents = [02:08:52.400] #28 0x0000000000917a36 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82144e9e8) at ../src/backend/postmaster/postmaster.c:1415 [02:08:52.400] optctx = {nargc = 8, nargv = 0x82144e9e8, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x82144f09c "/tmp/pg_regress-6LUnOo", optind = 8, optopt = 107, place = 0x2f17c5 ""} [02:08:52.400] userDoption = [02:08:52.400] listen_addr_saved = false [02:08:52.400] output_config_variable = [02:08:52.400] opt = [02:08:52.400] status = [02:08:52.400] #29 0x000000000083c50d in main (argc=8, argv=0x82144e9e8) at ../src/backend/main/main.c:231 [02:08:52.400] do_check_root = [02:08:52.400] dispatch_option = DISPATCH_POSTMASTER [02:08:52.408] [02:08:52.408] [02:08:52.408] [02:08:52.464] dumping /tmp/cores/postgres.90133.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:52.594] [New LWP 102141] [02:08:52.664] Core was generated by `postgres: parallel worker for PID 90127 '. [02:08:52.664] Program terminated with signal SIGABRT, Aborted. [02:08:52.664] Sent by thr_kill() from pid 90133 and user 1002. [02:08:52.664] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:52.708] [02:08:52.708] Thread 1 (LWP 102141): [02:08:52.708] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:52.708] No symbol table info available. [02:08:52.708] #1 0x000000082b96ea64 in raise () from /lib/libc.so.7 [02:08:52.708] No symbol table info available. [02:08:52.708] #2 0x000000082ba22a59 in abort () from /lib/libc.so.7 [02:08:52.708] No symbol table info available. [02:08:52.708] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:52.708] No locals. [02:08:52.708] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:52.708] s = [02:08:52.708] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x2fae5d42a500, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:52.708] t = [02:08:52.708] shtabstats = 0x83f633300 [02:08:52.708] dboid = 0 [02:08:52.708] lstats = 0x2fae5d42a100 [02:08:52.708] tabentry = 0x83f633318 [02:08:52.708] dbentry = [02:08:52.708] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:52.708] entry_ref = 0x2fae5d42a500 [02:08:52.708] kind = [02:08:52.708] kind_info = [02:08:52.708] iter = [02:08:52.708] entry_ref = [02:08:52.708] kind = [02:08:52.708] kind_info = [02:08:52.708] #7 0x0000000830fd607b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_13, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:52.708] qbuffer_size = 0 [02:08:52.708] hstat = {hash_table = 0x19, curbucket = 0, nbuckets = 196612, curitem = 0x3b600000000, pnextitem = 6066880889422204023, curpartition = 2104, exclusive = false} [02:08:52.708] rsinfo = 0x82144d450 [02:08:52.708] userid = 10 [02:08:52.708] is_allowed_role = [02:08:52.708] qbuffer = 0x2fae5dc04100 "~" [02:08:52.708] extent = 0 [02:08:52.708] gc_count = 1 [02:08:52.708] p = [02:08:52.708] #8 0x0000000830fd5dc8 in pg_stat_statements_1_13 (fcinfo=0x18efd) at ../contrib/pg_stat_statements/pg_stat_statements.c:1515 [02:08:52.708] showtext = false [02:08:52.708] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x2fae5dc02730, econtext=0x2fae5dc02620, argContext=, expectedDesc=0x2fae5dcb0638, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:52.708] result = 0 [02:08:52.708] fcusage = {fs = 0x0, save_f_total_time = {ticks = 108947804160}, save_total = {ticks = 13230976}, start = {ticks = 52425943682264}} [02:08:52.708] tmptup = {t_len = 1572867264, t_self = {ip_blkid = {bi_hi = 12206, bi_lo = 0}, ip_posid = 36864}, t_tableOid = 12206, t_data = 0x82144d478} [02:08:52.708] first_time = true [02:08:52.708] rsinfo = {type = T_ReturnSetInfo, econtext = 0x2fae5dc02620, expectedDesc = 0x2fae5dcb0638, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x2fae5dc69b38, setDesc = 0x2fae5dcb5a60} [02:08:52.708] tupstore = 0x0 [02:08:52.708] tupdesc = 0x0 [02:08:52.708] returnsSet = true [02:08:52.708] callerContext = 0x2fae5dc02000 [02:08:52.708] funcrettype = 2249 [02:08:52.708] fcinfo = 0x2fae5dc6c100 [02:08:52.708] returnsTuple = [02:08:52.708] #10 0x00000000007ef6c5 in FunctionNext (node=0x2fae5dc028c0) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:52.708] tstore = 0x0 [02:08:52.708] estate = [02:08:52.708] scanslot = 0x2fae5dc09bc8 [02:08:52.708] direction = ForwardScanDirection [02:08:52.708] oldpos = [02:08:52.708] att = [02:08:52.708] alldone = [02:08:52.708] funcno = [02:08:52.708] #11 0x00000000007dacfa in ExecScanFetch (node=0x2fae5dc028c0, epqstate=0x0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/include/executor/execScan.h:135 [02:08:52.708] No locals. [02:08:52.708] #12 ExecScanExtended (node=0x2fae5dc028c0, epqstate=0x0, qual=0x0, projInfo=0x2fae5dc6b690, accessMtd=, recheckMtd=) at ../src/include/executor/execScan.h:196 [02:08:52.708] slot = [02:08:52.708] econtext = 0x2fae5dc02620 [02:08:52.708] slot = [02:08:52.708] #13 ExecScan (node=0x2fae5dc028c0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/backend/executor/execScan.c:59 [02:08:52.708] qual = 0x0 [02:08:52.708] epqstate = 0x0 [02:08:52.708] projInfo = 0x2fae5dc6b690 [02:08:52.708] #14 0x000000000080f116 in ExecProcNode (node=0x2fae5dc028c0) at ../src/include/executor/executor.h:327 [02:08:52.708] No locals. [02:08:52.708] #15 ExecSort (pstate=0x2fae5dc02380) at ../src/backend/executor/nodeSort.c:149 [02:08:52.708] plannode = [02:08:52.708] tuplesortopts = [02:08:52.708] outerNode = 0x2fae5dc028c0 [02:08:52.708] tupDesc = [02:08:52.708] node = 0x2fae5dc02380 [02:08:52.708] estate = 0x2fae5dc02100 [02:08:52.708] tuplesortstate = 0x2fae5dcb9100 [02:08:52.708] dir = ForwardScanDirection [02:08:52.708] slot = [02:08:52.708] #16 0x00000000007cee7b in ExecProcNode (node=0x2fae5dc02380) at ../src/include/executor/executor.h:327 [02:08:52.708] No locals. [02:08:52.708] #17 ExecutePlan (queryDesc=0x2fae5d57bb68, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x2fae5d57a1c0) at ../src/backend/executor/execMain.c:1736 [02:08:52.708] estate = 0x2fae5dc02100 [02:08:52.708] planstate = 0x2fae5dc02380 [02:08:52.708] current_tuple_count = 0 [02:08:52.708] use_parallel_mode = [02:08:52.708] slot = [02:08:52.708] #18 standard_ExecutorRun (queryDesc=0x2fae5d57bb68, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:52.708] estate = 0x2fae5dc02100 [02:08:52.708] oldcontext = 0x2fae5d57a000 [02:08:52.708] operation = CMD_SELECT [02:08:52.708] dest = 0x2fae5d57a1c0 [02:08:52.708] sendTuples = true [02:08:52.708] #19 0x0000000830fd4d74 in pgss_ExecutorRun (queryDesc=0x2fae5d57bb68, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:52.708] _local_sigjmp_buf = {{_sjb = {35181645134, 0, 34917897864, 34917898032, 34917897872, 13222088, 1, 52425936845672, 8192895, 52425943687937, 34917898032, 0}}} [02:08:52.708] _save_exception_stack = 0x82144d810 [02:08:52.708] _save_context_stack = 0x0 [02:08:52.708] _do_rethrow = false [02:08:52.708] #20 0x00000000007d3ec8 in ParallelQueryMain (seg=0x2fae5d415fc0, toc=0x83e206000) at ../src/backend/executor/execParallel.c:1583 [02:08:52.708] pwcxt = {seg = 0x2fae5d415fc0, toc = 0x83e206000} [02:08:52.708] instrument_options = [02:08:52.708] fpes = 0x83e219f80 [02:08:52.708] receiver = 0x2fae5d57a1c0 [02:08:52.708] instrumentation = 0x0 [02:08:52.708] jit_instrumentation = 0x0 [02:08:52.708] queryDesc = 0x2fae5d57bb68 [02:08:52.708] area_space = [02:08:52.708] area = 0x2fae5dc5a9b8 [02:08:52.708] buffer_usage = [02:08:52.708] wal_usage = [02:08:52.708] #21 0x00000000006977f1 in ParallelWorkerMain (main_arg=) at ../src/backend/access/transam/parallel.c:1571 [02:08:52.708] seg = 0x2fae5d415fc0 [02:08:52.708] toc = 0x83e206000 [02:08:52.708] fps = 0x83e21f220 [02:08:52.708] error_queue_space = [02:08:52.708] mq = [02:08:52.708] mqh = [02:08:52.708] entrypointstate = [02:08:52.708] library_name = [02:08:52.708] function_name = [02:08:52.708] entrypt = 0x7d3c40 [02:08:52.708] libraryspace = [02:08:52.708] tstatespace = [02:08:52.708] pendingsyncsspace = [02:08:52.708] relmapperspace = [02:08:52.708] reindexspace = [02:08:52.708] combocidspace = [02:08:52.708] session_dsm_handle_space = [02:08:52.708] asnapspace = [02:08:52.708] tsnapspace = [02:08:52.708] asnapshot = 0x2fae5d57a100 [02:08:52.708] tsnapshot = [02:08:52.708] gucspace = [02:08:52.708] uncommittedenumsspace = [02:08:52.708] clientconninfospace = [02:08:52.708] #22 0x00000000009107ec in BackgroundWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/bgworker.c:865 [02:08:52.708] local_sigjmp_buf = {{_sjb = {9504693, 52425936878104, 34917898248, 34917898400, 10342416, 10175840, 52425936878104, 34917898256, 206158431103, -2147815357, -1, 1}}} [02:08:52.708] worker = 0x2fae5d583a18 [02:08:52.708] entrypt = 0x0 [02:08:52.708] #23 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_BG_WORKER, child_slot=240, startup_data=startup_data@entry=0x2fae5d57e3f8, startup_data_len=startup_data_len@entry=1472, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:52.708] pid = [02:08:52.708] #24 0x0000000000918457 in StartBackgroundWorker (rw=0x2fae5d57e3f8) at ../src/backend/postmaster/postmaster.c:4207 [02:08:52.708] bn = 0x2fae5d548d08 [02:08:52.708] worker_pid = [02:08:52.708] __error = [02:08:52.708] __error = [02:08:52.708] __error = [02:08:52.708] #25 maybe_start_bgworkers () at ../src/backend/postmaster/postmaster.c:4372 [02:08:52.708] rw = 0x2fae5d57e3f8 [02:08:52.708] num_launched = 0 [02:08:52.708] now = 0 [02:08:52.708] iter = {cur = 0x2fae5d57e9d0, next = , end = } [02:08:52.708] #26 0x000000000091a1d5 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3437 [02:08:52.708] No locals. [02:08:52.708] #27 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:52.708] now = [02:08:52.708] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e160}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5431e406749dcc77}, {pos = 732597312, events = 8, fd = 558161664, user_data = 0x43}, {pos = 1956498551, events = 1412555782, fd = 32, user_data = 0x1000}, {pos = 1, events = 0, fd = 558161720, user_data = 0x2000}, {pos = 558161520, events = 8, fd = 732331702, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 558161536, events = 8, fd = 684059333, user_data = 0x82144df38}, {pos = 558161704, events = 8, fd = 558161560, user_data = 0x82144df10}, {pos = 730683604, events = 8, fd = 730683604, user_data = 0x2fae5d00a408}, {pos = 3, events = 0, fd = 558161664, user_data = 0x2ad628c59b2b}, {pos = 558161704, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 558162160, user_data = 0x82ba62ad4}, {pos = 558161728, events = 8, fd = 12288, user_data = 0x2000}, {pos = 1560344136, events = 12206, fd = 0, user_data = 0x0}, {pos = 558161816, events = 8, fd = 558162264, user_data = 0x82144df80}, {pos = 684057650, events = 10966, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 1560346704, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e248}, {pos = 1564542304, events = 3, fd = 558162336, user_data = 0x2fae5d00f6a8}, {pos = 656, events = 0, fd = 558162264, user_data = 0x82144df98}, {pos = 558161920, events = 8, fd = 684057291, user_data = 0x82144e208}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x2fae5d00a408}, {pos = 730607240, events = 8, fd = 558162504, user_data = 0x82144e1a0}, {pos = 31, events = 0, fd = 0, user_data = 0x2fae5d003008}, {pos = 558161936, events = 8, fd = 558162320, user_data = 0x2ad628c580c7}, {pos = 1560293384, events = 12206, fd = 1560294408, user_data = 0x2fae5d003808}, {pos = 1560296456, events = 12206, fd = 1560309768, user_data = 0x2fae5d007408}, {pos = 1560311816, events = 12206, fd = 1560312840, user_data = 0x2fae5d008008}, {pos = 1560314888, events = 12206, fd = 1560315912, user_data = 0x2fae5d008c08}, {pos = 1560317960, events = 12206, fd = 1560318984, user_data = 0x2fae5d009808}, {pos = 1560321032, events = 12206, fd = 1560322056, user_data = 0x2fae5d00a408}, {pos = 1560324104, events = 12206, fd = 1560325128, user_data = 0x2fae5d00b008}, {pos = 1560327176, events = 12206, fd = 1560328200, user_data = 0x2fae5d00bc08}, {pos = 1560330248, events = 12206, fd = 1560331272, user_data = 0x2fae5d00c808}, {pos = 1560333320, events = 12206, fd = 1560338440, user_data = 0x2fae5d00e408}, {pos = 1560341512, events = 12206, fd = 269670000, user_data = 0x2fae5d003008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558162504, user_data = 0x82144e010}, {pos = 31, events = 31, fd = 1560293384, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x2fae5d010050}, {pos = 558162480, events = 8, fd = 684030908, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x2fae5d010050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82b9f3d70 }, {pos = 1560293384, events = 12206, fd = 2859976, user_data = 0x829a4b549}, {pos = 1, events = 0, fd = 1561010184, user_data = 0x82144e230}, {pos = 698656485, events = 8, fd = 731856240, user_data = 0xc7f098 }, {pos = 731856240, events = 8, fd = 1560323080, user_data = 0x82144e310}, {pos = 684030388, events = 10966, fd = 16, user_data = 0x2fae00000001}, {pos = 684029998, events = 10966, fd = 1560293384, user_data = 0x82144e238}, {pos = 558162704, events = 8, fd = 7176, user_data = 0xc}, {pos = 684112704, events = 10966, fd = 0, user_data = 0x82144037f}, {pos = 11979292, events = 0, fd = 558162624, user_data = 0x829a415d0 <__pthread_cleanup_pop_imp+48>}, {pos = 732525312, events = 8, fd = 732534256, user_data = 0x0}, {pos = 8128, events = 0, fd = 558162672, user_data = 0x829a4bb9d}, {pos = 558162688, events = 8, fd = 698619344, user_data = 0x82ba97300 <__thr_jtable>}, {pos = 732534256, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 558162736, events = 8, fd = 698661789, user_data = 0x2fae5d0b2008}, {pos = 85133, events = 0, fd = 558162832, user_data = 0x829a43a7d}} [02:08:52.708] last_touch_time = 1778896893 [02:08:52.708] last_lockfile_recheck_time = 1778896893 [02:08:52.708] nevents = [02:08:52.708] #28 0x0000000000917a36 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82144e9e8) at ../src/backend/postmaster/postmaster.c:1415 [02:08:52.708] optctx = {nargc = 8, nargv = 0x82144e9e8, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x82144f09c "/tmp/pg_regress-6LUnOo", optind = 8, optopt = 107, place = 0x2f17c5 ""} [02:08:52.708] userDoption = [02:08:52.708] listen_addr_saved = false [02:08:52.708] output_config_variable = [02:08:52.708] opt = [02:08:52.708] status = [02:08:52.708] #29 0x000000000083c50d in main (argc=8, argv=0x82144e9e8) at ../src/backend/main/main.c:231 [02:08:52.708] do_check_root = [02:08:52.708] dispatch_option = DISPATCH_POSTMASTER [02:08:52.716] [02:08:52.716] [02:08:52.716] [02:08:52.774] dumping /tmp/cores/postgres.90562.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:52.904] [New LWP 102223] [02:08:52.970] Core was generated by `postgres: parallel worker for PID 90512 '. [02:08:52.970] Program terminated with signal SIGABRT, Aborted. [02:08:52.970] Sent by thr_kill() from pid 90562 and user 1002. [02:08:52.970] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:53.013] [02:08:53.013] Thread 1 (LWP 102223): [02:08:53.013] #0 0x000000082b9f601a in thr_kill () from /lib/libc.so.7 [02:08:53.013] No symbol table info available. [02:08:53.013] #1 0x000000082b96ea64 in raise () from /lib/libc.so.7 [02:08:53.013] No symbol table info available. [02:08:53.013] #2 0x000000082ba22a59 in abort () from /lib/libc.so.7 [02:08:53.013] No symbol table info available. [02:08:53.013] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:53.013] No locals. [02:08:53.013] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:53.013] s = [02:08:53.013] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x2fae5d42a500, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:53.013] t = [02:08:53.013] shtabstats = 0x83d643100 [02:08:53.013] dboid = 0 [02:08:53.013] lstats = 0x2fae5d42a100 [02:08:53.013] tabentry = 0x83d643118 [02:08:53.013] dbentry = [02:08:53.013] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:53.013] entry_ref = 0x2fae5d42a500 [02:08:53.013] kind = [02:08:53.013] kind_info = [02:08:53.013] iter = [02:08:53.013] entry_ref = [02:08:53.013] kind = [02:08:53.013] kind_info = [02:08:53.013] #7 0x0000000830fd607b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_3, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:53.013] qbuffer_size = 0 [02:08:53.013] hstat = {hash_table = 0x100000000, curbucket = 1572866240, nbuckets = 12206, curitem = 0x2fae5dcc18d8, pnextitem = 52425944471765, curpartition = 1573656784, exclusive = 174} [02:08:53.013] rsinfo = 0x82144d450 [02:08:53.013] userid = 10 [02:08:53.013] is_allowed_role = [02:08:53.013] qbuffer = 0x2fae5dc08100 "~" [02:08:53.013] extent = 0 [02:08:53.013] gc_count = 1 [02:08:53.013] p = [02:08:53.013] #8 0x0000000830fd6cf8 in pg_stat_statements_1_3 (fcinfo=0x18f4f) at ../contrib/pg_stat_statements/pg_stat_statements.c:1575 [02:08:53.013] showtext = false [02:08:53.013] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x2fae5dc00730, econtext=0x2fae5dc00f08, argContext=, expectedDesc=0x2fae5dcbdd38, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:53.013] result = 52425937102336 [02:08:53.013] fcusage = {fs = 0x0, save_f_total_time = {ticks = 52425935452920}, save_total = {ticks = 1}, start = {ticks = 1}} [02:08:53.013] tmptup = {t_len = 1, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 54448}, t_tableOid = 8, t_data = 0x0} [02:08:53.013] first_time = true [02:08:53.013] rsinfo = {type = T_ReturnSetInfo, econtext = 0x2fae5dc00f08, expectedDesc = 0x2fae5dcbdd38, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x2fae5dcc1a70, setDesc = 0x2fae5dcc2d60} [02:08:53.013] tupstore = 0x0 [02:08:53.013] tupdesc = 0x0 [02:08:53.013] returnsSet = true [02:08:53.013] callerContext = 0x2fae5dc00000 [02:08:53.013] funcrettype = 2249 [02:08:53.013] fcinfo = 0x2fae5dcad100 [02:08:53.013] returnsTuple = [02:08:53.013] #10 0x00000000007ef6c5 in FunctionNext (node=0x2fae5dc00380) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:53.013] tstore = 0x0 [02:08:53.013] estate = [02:08:53.013] scanslot = 0x2fae5dc01518 [02:08:53.013] direction = ForwardScanDirection [02:08:53.013] oldpos = [02:08:53.013] att = [02:08:53.013] alldone = [02:08:53.013] funcno = [02:08:53.013] #11 0x00000000007e929d in ExecProcNode (node=0x2fae5dc00380) at ../src/include/executor/executor.h:327 [02:08:53.013] No locals. [02:08:53.013] #12 fetch_input_tuple (aggstate=aggstate@entry=0x2fae5dc008c0) at ../src/backend/executor/nodeAgg.c:564 [02:08:53.013] slot = [02:08:53.013] #13 0x00000000007e7249 in agg_retrieve_direct (aggstate=0x2fae5dc008c0) at ../src/backend/executor/nodeAgg.c:2453 [02:08:53.013] node = 0x2fae5d57a2f0 [02:08:53.013] numGroupingSets = 1 [02:08:53.013] econtext = 0x2fae5dc00df8 [02:08:53.013] firstSlot = 0x2fae5dcc0d68 [02:08:53.013] tmpcontext = 0x2fae5dc00620 [02:08:53.013] peragg = 0x2fae5dc0df18 [02:08:53.013] pergroups = 0x2fae5dcc1638 [02:08:53.013] numReset = 1 [02:08:53.013] i = [02:08:53.013] nextSetSize = 0 [02:08:53.013] outerslot = [02:08:53.013] currentSet = [02:08:53.013] result = [02:08:53.013] hasGroupingSets = [02:08:53.013] #14 ExecAgg (pstate=0x2fae5dc008c0) at ../src/backend/executor/nodeAgg.c:2268 [02:08:53.013] node = 0x2fae5dc008c0 [02:08:53.013] result = 0x0 [02:08:53.013] #15 0x00000000007cee7b in ExecProcNode (node=0x2fae5dc008c0) at ../src/include/executor/executor.h:327 [02:08:53.013] No locals. [02:08:53.013] #16 ExecutePlan (queryDesc=0x2fae5d57bb68, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x2fae5d57a1c0) at ../src/backend/executor/execMain.c:1736 [02:08:53.013] estate = 0x2fae5dc00100 [02:08:53.013] planstate = 0x2fae5dc008c0 [02:08:53.013] current_tuple_count = 0 [02:08:53.013] use_parallel_mode = [02:08:53.013] slot = [02:08:53.013] #17 standard_ExecutorRun (queryDesc=0x2fae5d57bb68, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:53.013] estate = 0x2fae5dc00100 [02:08:53.013] oldcontext = 0x2fae5d57a000 [02:08:53.013] operation = CMD_SELECT [02:08:53.013] dest = 0x2fae5d57a1c0 [02:08:53.013] sendTuples = true [02:08:53.013] #18 0x0000000830fd4d74 in pgss_ExecutorRun (queryDesc=0x2fae5d57bb68, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:53.013] _local_sigjmp_buf = {{_sjb = {35181645134, 0, 34917897864, 34917898032, 34917897872, 13222088, 1, 52425936845672, 8192895, 52425943681025, 34917898032, 0}}} [02:08:53.013] _save_exception_stack = 0x82144d810 [02:08:53.013] _save_context_stack = 0x0 [02:08:53.013] _do_rethrow = false [02:08:53.013] #19 0x00000000007d3ec8 in ParallelQueryMain (seg=0x2fae5d415fc0, toc=0x83d625000) at ../src/backend/executor/execParallel.c:1583 [02:08:53.013] pwcxt = {seg = 0x2fae5d415fc0, toc = 0x83d625000} [02:08:53.013] instrument_options = [02:08:53.013] fpes = 0x83d6399e0 [02:08:53.013] receiver = 0x2fae5d57a1c0 [02:08:53.013] instrumentation = 0x0 [02:08:53.013] jit_instrumentation = 0x0 [02:08:53.013] queryDesc = 0x2fae5d57bb68 [02:08:53.013] area_space = [02:08:53.013] area = 0x2fae5dc5a9b8 [02:08:53.013] buffer_usage = [02:08:53.013] wal_usage = [02:08:53.013] #20 0x00000000006977f1 in ParallelWorkerMain (main_arg=) at ../src/backend/access/transam/parallel.c:1571 [02:08:53.013] seg = 0x2fae5d415fc0 [02:08:53.013] toc = 0x83d625000 [02:08:53.013] fps = 0x83d63ec20 [02:08:53.013] error_queue_space = [02:08:53.013] mq = [02:08:53.013] mqh = [02:08:53.013] entrypointstate = [02:08:53.013] library_name = [02:08:53.013] function_name = [02:08:53.013] entrypt = 0x7d3c40 [02:08:53.013] libraryspace = [02:08:53.013] tstatespace = [02:08:53.013] pendingsyncsspace = [02:08:53.013] relmapperspace = [02:08:53.013] reindexspace = [02:08:53.013] combocidspace = [02:08:53.013] session_dsm_handle_space = [02:08:53.013] asnapspace = [02:08:53.013] tsnapspace = [02:08:53.013] asnapshot = 0x2fae5d57a100 [02:08:53.013] tsnapshot = [02:08:53.013] gucspace = [02:08:53.013] uncommittedenumsspace = [02:08:53.013] clientconninfospace = [02:08:53.013] #21 0x00000000009107ec in BackgroundWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/bgworker.c:865 [02:08:53.013] local_sigjmp_buf = {{_sjb = {9504693, 52425936879528, 34917898248, 34917898400, 10342416, 10175840, 52425936879528, 34917898256, 206158431103, -2147815357, -1, 1}}} [02:08:53.013] worker = 0x2fae5d583fa8 [02:08:53.013] entrypt = 0x0 [02:08:53.013] #22 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_BG_WORKER, child_slot=240, startup_data=startup_data@entry=0x2fae5d57e3f8, startup_data_len=startup_data_len@entry=1472, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:53.013] pid = [02:08:53.013] #23 0x0000000000918457 in StartBackgroundWorker (rw=0x2fae5d57e3f8) at ../src/backend/postmaster/postmaster.c:4207 [02:08:53.013] bn = 0x2fae5d548d08 [02:08:53.013] worker_pid = [02:08:53.013] __error = [02:08:53.013] __error = [02:08:53.013] __error = [02:08:53.013] #24 maybe_start_bgworkers () at ../src/backend/postmaster/postmaster.c:4372 [02:08:53.013] rw = 0x2fae5d57e3f8 [02:08:53.013] num_launched = 0 [02:08:53.013] now = 0 [02:08:53.013] iter = {cur = 0x2fae5d57e9d0, next = , end = } [02:08:53.013] #25 0x000000000091a1d5 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3437 [02:08:53.013] No locals. [02:08:53.013] #26 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:53.013] now = [02:08:53.013] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e160}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5431e406749dcc77}, {pos = 732597312, events = 8, fd = 558161664, user_data = 0x43}, {pos = 1956498551, events = 1412555782, fd = 32, user_data = 0x1000}, {pos = 1, events = 0, fd = 558161720, user_data = 0x2000}, {pos = 558161520, events = 8, fd = 732331702, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 558161536, events = 8, fd = 684059333, user_data = 0x82144df38}, {pos = 558161704, events = 8, fd = 558161560, user_data = 0x82144df10}, {pos = 730683604, events = 8, fd = 730683604, user_data = 0x2fae5d00a408}, {pos = 3, events = 0, fd = 558161664, user_data = 0x2ad628c59b2b}, {pos = 558161704, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 558162160, user_data = 0x82ba62ad4}, {pos = 558161728, events = 8, fd = 12288, user_data = 0x2000}, {pos = 1560344136, events = 12206, fd = 0, user_data = 0x0}, {pos = 558161816, events = 8, fd = 558162264, user_data = 0x82144df80}, {pos = 684057650, events = 10966, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 1560346704, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82144e248}, {pos = 1564542304, events = 3, fd = 558162336, user_data = 0x2fae5d00f6a8}, {pos = 656, events = 0, fd = 558162264, user_data = 0x82144df98}, {pos = 558161920, events = 8, fd = 684057291, user_data = 0x82144e208}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x2fae5d00a408}, {pos = 730607240, events = 8, fd = 558162504, user_data = 0x82144e1a0}, {pos = 31, events = 0, fd = 0, user_data = 0x2fae5d003008}, {pos = 558161936, events = 8, fd = 558162320, user_data = 0x2ad628c580c7}, {pos = 1560293384, events = 12206, fd = 1560294408, user_data = 0x2fae5d003808}, {pos = 1560296456, events = 12206, fd = 1560309768, user_data = 0x2fae5d007408}, {pos = 1560311816, events = 12206, fd = 1560312840, user_data = 0x2fae5d008008}, {pos = 1560314888, events = 12206, fd = 1560315912, user_data = 0x2fae5d008c08}, {pos = 1560317960, events = 12206, fd = 1560318984, user_data = 0x2fae5d009808}, {pos = 1560321032, events = 12206, fd = 1560322056, user_data = 0x2fae5d00a408}, {pos = 1560324104, events = 12206, fd = 1560325128, user_data = 0x2fae5d00b008}, {pos = 1560327176, events = 12206, fd = 1560328200, user_data = 0x2fae5d00bc08}, {pos = 1560330248, events = 12206, fd = 1560331272, user_data = 0x2fae5d00c808}, {pos = 1560333320, events = 12206, fd = 1560338440, user_data = 0x2fae5d00e408}, {pos = 1560341512, events = 12206, fd = 269670000, user_data = 0x2fae5d003008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1560346704, events = 12206, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558162504, user_data = 0x82144e010}, {pos = 31, events = 31, fd = 1560293384, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x2fae5d010050}, {pos = 558162480, events = 8, fd = 684030908, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x2fae5d010050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82b9f3d70 }, {pos = 1560293384, events = 12206, fd = 2859976, user_data = 0x829a4b549}, {pos = 1, events = 0, fd = 1561010184, user_data = 0x82144e230}, {pos = 698656485, events = 8, fd = 731856240, user_data = 0xc7f098 }, {pos = 731856240, events = 8, fd = 1560323080, user_data = 0x82144e310}, {pos = 684030388, events = 10966, fd = 16, user_data = 0x2fae00000001}, {pos = 684029998, events = 10966, fd = 1560293384, user_data = 0x82144e238}, {pos = 558162704, events = 8, fd = 7176, user_data = 0xc}, {pos = 684112704, events = 10966, fd = 0, user_data = 0x82144037f}, {pos = 11979292, events = 0, fd = 558162624, user_data = 0x829a415d0 <__pthread_cleanup_pop_imp+48>}, {pos = 732525312, events = 8, fd = 732534256, user_data = 0x0}, {pos = 8128, events = 0, fd = 558162672, user_data = 0x829a4bb9d}, {pos = 558162688, events = 8, fd = 698619344, user_data = 0x82ba97300 <__thr_jtable>}, {pos = 732534256, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 558162736, events = 8, fd = 698661789, user_data = 0x2fae5d0b2008}, {pos = 85133, events = 0, fd = 558162832, user_data = 0x829a43a7d}} [02:08:53.013] last_touch_time = 1778896893 [02:08:53.013] last_lockfile_recheck_time = 1778896893 [02:08:53.013] nevents = [02:08:53.013] #27 0x0000000000917a36 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82144e9e8) at ../src/backend/postmaster/postmaster.c:1415 [02:08:53.013] optctx = {nargc = 8, nargv = 0x82144e9e8, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x82144f09c "/tmp/pg_regress-6LUnOo", optind = 8, optopt = 107, place = 0x2f17c5 ""} [02:08:53.013] userDoption = [02:08:53.013] listen_addr_saved = false [02:08:53.013] output_config_variable = [02:08:53.013] opt = [02:08:53.013] status = [02:08:53.013] #28 0x000000000083c50d in main (argc=8, argv=0x82144e9e8) at ../src/backend/main/main.c:231 [02:08:53.013] do_check_root = [02:08:53.013] dispatch_option = DISPATCH_POSTMASTER [02:08:53.021] [02:08:53.021] [02:08:53.021] [02:08:53.074] dumping /tmp/cores/postgres.21020.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:08:53.205] [New LWP 100869] [02:08:53.271] Core was generated by `postgres: primary: archiver archiving 000000010000000000000003'. [02:08:53.271] Program terminated with signal SIGQUIT, Quit. [02:08:53.271] Sent by thr_kill() from pid 21020 and user 1002. [02:08:53.271] #0 0x000000082b3955da in _sigprocmask () from /lib/libc.so.7 [02:08:53.284] [02:08:53.284] Thread 1 (LWP 100869): [02:08:53.284] #0 0x000000082b3955da in _sigprocmask () from /lib/libc.so.7 [02:08:53.284] No symbol table info available. [02:08:53.284] #1 0x000000082b3d2a3c in _system () from /lib/libc.so.7 [02:08:53.284] No symbol table info available. [02:08:53.284] #2 0x0000000829d48953 in ?? () from /lib/libthr.so.3 [02:08:53.284] No symbol table info available. [02:08:53.284] #3 0x00000000006c5bdb in shell_archive_file (state=, file=0x8216525e0 "00000001", '0' , "3", path=) at ../src/backend/archive/shell_archive.c:81 [02:08:53.284] nativePath = [02:08:53.284] xlogarchcmd = 0x37d6d891d130 "cp \"pg_wal/00000001", '0' , "3\" \"/tmp/cirrus-ci-build/build/testrun/pg_combinebackup/009_no_full_file/data/t_009_no_full_file_primary_data/archives/00000001", '0' , "3\"" [02:08:53.284] rc = [02:08:53.284] #4 0x000000000091625c in pgarch_archiveXlog (xlog=xlog@entry=0x8216525e0 "00000001", '0' , "3") at ../src/backend/postmaster/pgarch.c:605 [02:08:53.284] local_sigjmp_buf = {{_sjb = {9527712, 34920015328, 34920010760, 34920012016, 61395894878208, 34920015328, 34920011792, 13230976, 61395894928255, 0, 0, 1}}} [02:08:53.284] pathname = "pg_wal/00000001", '0' , "3\00000000028.backup\000\320\032e!\b\000\000\000*@;\000\000\000\000\000\360\031e!\b\000\000\000\210\361@\330\3267\000\000 \326&+\b\000\000\000\b\244@\330\3267\000\000\030\025e!\b\000\000\000\310\026e!\b\000\000\000\000\025e!\b\000\000\0002\224,\26666\000\000\027\006*\000\000\000\000\0005H\214\a\000\000\000\000\035\304,\031\3267\000\000P\000A\330\3267\000\000\001", '\000' , "\270\027e!\b\000\000\000\260\024e!\003\000\000\000"... [02:08:53.284] activitymsg = "archiving 00000001", '0' , "3\000\000\000\000\000\000\000\035e!\b\000\000\000 \000\000\0000\000\000\000\000\031e!\b\000\000\000\360\027e!\b\000\000\000\000\000\000\000\000\000\000" [02:08:53.284] oldcontext = 0x37d6d8814000 [02:08:53.284] ret = [02:08:53.284] #5 0x0000000000915cb4 in pgarch_ArchiverCopyLoop () at ../src/backend/postmaster/pgarch.c:478 [02:08:53.284] stat_buf = {st_dev = 18446744071679573761, st_ino = 628850, st_nlink = 1, st_mode = 33152, st_bsdflags = 0, st_uid = 1002, st_gid = 1003, st_padding1 = 0, st_rdev = 18446744073709551615, st_atim = {tv_sec = 1778896993, tv_nsec = 876714000}, st_mtim = {tv_sec = 1778896993, tv_nsec = 876714000}, st_ctim = {tv_sec = 1778896993, tv_nsec = 876714000}, st_birthtim = {tv_sec = 1778896992, tv_nsec = 414400000}, st_size = 16777216, st_blocks = 32768, st_blksize = 4096, st_flags = 0, st_gen = 0, st_filerev = 0, st_spare = {0, 0, 0, 0, 0, 0, 0, 0, 0}} [02:08:53.284] pathname = "pg_wal/00000001", '0' , "3\00000000028.backup\000\000\000\000\000\000\000\000\000\025\270\270\000\000\000\000\000x e!\b\000\000\000\376\377\377\377\000\000\000\000\004\032e!\b\000\000\000\377\377\377\377\000\000\000\000\310 e!\b", '\000' , "\260\031e!\b\000\000\000V\273\270\000\000\000\000\000\b\000\000\0000\000\000\000 &e!\b\000\000\000 %e!\b\000\000\000\376\377\377\377\000\000\000\000\002", '\000' , "X#e!\b\000\000\000\310\031e!\b", '\000' ... [02:08:53.284] failures = 0 [02:08:53.284] failures_orphan = 0 [02:08:53.284] xlog = "00000001", '0' , "3\00000000028.backup" [02:08:53.284] failures = [02:08:53.284] failures_orphan = [02:08:53.284] stat_buf = [02:08:53.284] pathname = [02:08:53.284] __error = [02:08:53.284] xlogready = [02:08:53.284] __error = [02:08:53.284] __error = [02:08:53.284] __error = [02:08:53.284] #6 pgarch_MainLoop () at ../src/backend/postmaster/pgarch.c:352 [02:08:53.284] time_to_stop = false [02:08:53.284] #7 0x0000000000915580 in PgArchiverMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/pgarch.c:274 [02:08:53.284] No locals. [02:08:53.284] #8 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_ARCHIVER, child_slot=54, startup_data=startup_data@entry=0x0, startup_data_len=startup_data_len@entry=0, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:53.284] pid = [02:08:53.284] #9 0x0000000000918187 in StartChildProcess (type=type@entry=B_ARCHIVER) at ../src/backend/postmaster/postmaster.c:4030 [02:08:53.284] pmchild = 0x0 [02:08:53.284] pid = [02:08:53.284] #10 0x000000000091a38c in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3388 [02:08:53.284] No locals. [02:08:53.284] #11 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:53.284] now = [02:08:53.284] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = -662084136, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82f469e6aa02a5e4}, {pos = 725904448, events = 8, fd = 560278672, user_data = 0x43}, {pos = 1, events = 0, fd = 725904448, user_data = 0x821652bc0}, {pos = -1238590779, events = 13878, fd = 8, user_data = 0x82b446c40}, {pos = 560278496, events = 8, fd = -1238590779, user_data = 0x82b2747a4}, {pos = 723994532, events = 8, fd = 560278520, user_data = 0x821652c70}, {pos = 723994824, events = 8, fd = 723994824, user_data = 0x821652c20}, {pos = -1238590779, events = 13878, fd = 560278624, user_data = 0x3636b62c4b2b}, {pos = 560278584, events = 8, fd = 560278704, user_data = 0x82b2738d4}, {pos = 723990740, events = 8, fd = -666852344, user_data = 0x3}, {pos = 560278688, events = 8, fd = -1238611157, user_data = 0x821652cd8}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 560278776, events = 8, fd = 560279208, user_data = 0x821652ce0}, {pos = -1238592462, events = 13878, fd = 2728065, user_data = 0x37d6d840f188}, {pos = 723914376, events = 8, fd = -666852344, user_data = 0x821652d38}, {pos = 560279272, events = 8, fd = 560278816, user_data = 0x3636b62c9432}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -666828720, events = 14294, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 560279512, user_data = 0x321652d20}, {pos = 560279344, events = 8, fd = -666830520, user_data = 0x290}, {pos = 560279272, events = 8, fd = 560278840, user_data = 0x821652da0}, {pos = -1238592821, events = 13878, fd = 560279448, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x37d6d8410050}, {pos = 1, events = 8, fd = -666852344, user_data = 0x82b260e88}, {pos = 560279512, events = 8, fd = 560279344, user_data = 0x1e}, {pos = 0, events = 0, fd = -666882040, user_data = 0x821652db0}, {pos = 560279328, events = 8, fd = -1238617913, user_data = 0x37d6d8403008}, {pos = -666881016, events = 14294, fd = -666879992, user_data = 0x37d6d8403c08}, {pos = -666865656, events = 14294, fd = -666864632, user_data = 0x37d6d8407808}, {pos = -666862584, events = 14294, fd = -666861560, user_data = 0x37d6d8408408}, {pos = -666859512, events = 14294, fd = -666858488, user_data = 0x37d6d8409008}, {pos = -666856440, events = 14294, fd = -666855416, user_data = 0x37d6d8409c08}, {pos = -666853368, events = 14294, fd = -666852344, user_data = 0x37d6d840a808}, {pos = -666850296, events = 14294, fd = -666849272, user_data = 0x37d6d840b408}, {pos = -666847224, events = 14294, fd = -666846200, user_data = 0x37d6d840c008}, {pos = -666844152, events = 14294, fd = -666843128, user_data = 0x37d6d840cc08}, {pos = -666836984, events = 14294, fd = -666835960, user_data = 0x37d6d8403008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -666828720, events = 14294, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 560279512, user_data = 0x821652db0}, {pos = 30, events = 30, fd = -666882040, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x37d6d8410050}, {pos = 560279488, events = 8, fd = -1238619204, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x37d6d8410050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82b391d70 }, {pos = -666882040, events = 14294, fd = 2859976, user_data = 0x829d45549}, {pos = 1, events = 0, fd = -666165240, user_data = 0x821652fc0}, {pos = 701777637, events = 8, fd = 725163376, user_data = 0xc7f098 }, {pos = 725163376, events = 8, fd = -666852344, user_data = 0x8216530a0}, {pos = -1238619724, events = 13878, fd = 16, user_data = 0x37d600000001}, {pos = -1238620114, events = 13878, fd = -666882040, user_data = 0x821652fc8}, {pos = 560279712, events = 8, fd = 7176, user_data = 0xc}, {pos = -1238537408, events = 13878, fd = 0, user_data = 0x82165037f}, {pos = 11979292, events = 0, fd = 560279632, user_data = 0x829d3b5d0 <__pthread_cleanup_pop_imp+48>}, {pos = 725832448, events = 8, fd = 725841392, user_data = 0x0}, {pos = 8128, events = 0, fd = 560279680, user_data = 0x829d45b9d}, {pos = 560279696, events = 8, fd = 701740496, user_data = 0x82b435300 <__thr_jtable>}, {pos = 725841392, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 560279744, events = 8, fd = 701782941, user_data = 0x37d6d84b2008}, {pos = 20939, events = 0, fd = 560279840, user_data = 0x829d3da7d}} [02:08:53.284] last_touch_time = 1778896993 [02:08:53.284] last_lockfile_recheck_time = 1778896993 [02:08:53.284] nevents = [02:08:53.284] #12 0x0000000000917a36 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821653778) at ../src/backend/postmaster/postmaster.c:1415 [02:08:53.284] optctx = {nargc = 4, nargv = 0x821653778, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x821653e4a "cluster-name=primary", optind = 4, optopt = 45, place = 0x2f17c5 ""} [02:08:53.284] userDoption = [02:08:53.284] listen_addr_saved = false [02:08:53.284] output_config_variable = [02:08:53.284] opt = [02:08:53.284] status = [02:08:53.284] #13 0x000000000083c50d in main (argc=4, argv=0x821653778) at ../src/backend/main/main.c:231 [02:08:53.284] do_check_root = [02:08:53.284] dispatch_option = DISPATCH_POSTMASTER [02:08:53.292] [02:08:53.292] [02:08:53.292] [02:08:53.350] dumping /tmp/cores/postgres.47279.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:08:53.483] [New LWP 102188] [02:08:53.549] Core was generated by `postgres: main: parallel worker for PID 47275 '. [02:08:53.549] Program terminated with signal SIGABRT, Aborted. [02:08:53.549] Sent by thr_kill() from pid 47279 and user 1002. [02:08:53.549] #0 0x000000082baa301a in thr_kill () from /lib/libc.so.7 [02:08:53.593] [02:08:53.593] Thread 1 (LWP 102188): [02:08:53.593] #0 0x000000082baa301a in thr_kill () from /lib/libc.so.7 [02:08:53.593] No symbol table info available. [02:08:53.593] #1 0x000000082ba1ba64 in raise () from /lib/libc.so.7 [02:08:53.593] No symbol table info available. [02:08:53.593] #2 0x000000082bacfa59 in abort () from /lib/libc.so.7 [02:08:53.593] No symbol table info available. [02:08:53.593] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:53.593] No locals. [02:08:53.593] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:53.593] s = [02:08:53.593] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x385c36e2a500, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:53.593] t = [02:08:53.593] shtabstats = 0x842fce200 [02:08:53.593] dboid = 0 [02:08:53.593] lstats = 0x385c36e2a100 [02:08:53.593] tabentry = 0x842fce218 [02:08:53.593] dbentry = [02:08:53.593] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:53.593] entry_ref = 0x385c36e2a500 [02:08:53.593] kind = [02:08:53.593] kind_info = [02:08:53.593] iter = [02:08:53.593] entry_ref = [02:08:53.593] kind = [02:08:53.593] kind_info = [02:08:53.593] #7 0x00000008354e707b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_13, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:53.593] qbuffer_size = 0 [02:08:53.593] hstat = {hash_table = 0x385c36f1a000, curbucket = 0, nbuckets = 0, curitem = 0x19, pnextitem = 844442110001152, curpartition = 0, exclusive = 182} [02:08:53.593] rsinfo = 0x82131bce0 [02:08:53.593] userid = 10 [02:08:53.593] is_allowed_role = [02:08:53.593] qbuffer = 0x385c37600100 "~" [02:08:53.593] extent = 0 [02:08:53.593] gc_count = 0 [02:08:53.593] p = [02:08:53.593] #8 0x00000008354e6dc8 in pg_stat_statements_1_13 (fcinfo=0x18f2c) at ../contrib/pg_stat_statements/pg_stat_statements.c:1515 [02:08:53.593] showtext = false [02:08:53.593] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x385c36ffe730, econtext=0x385c36ffe620, argContext=, expectedDesc=0x385c376a4fb8, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:53.593] result = 281479271681207 [02:08:53.593] fcusage = {fs = 0x0, save_f_total_time = {ticks = 34916646112}, save_total = {ticks = 11584738}, start = {ticks = 108303929344}} [02:08:53.593] tmptup = {t_len = 13230976, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 0}, t_tableOid = 0, t_data = 0x0} [02:08:53.593] first_time = true [02:08:53.593] rsinfo = {type = T_ReturnSetInfo, econtext = 0x385c36ffe620, expectedDesc = 0x385c376a4fb8, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x385c36fff740, setDesc = 0x385c376aa100} [02:08:53.593] tupstore = 0x0 [02:08:53.593] tupdesc = 0x0 [02:08:53.593] returnsSet = true [02:08:53.593] callerContext = 0x385c36ffe000 [02:08:53.593] funcrettype = 2249 [02:08:53.593] fcinfo = 0x385c37608100 [02:08:53.593] returnsTuple = [02:08:53.593] #10 0x00000000007ef6c5 in FunctionNext (node=0x385c36ffe8c0) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:53.593] tstore = 0x0 [02:08:53.593] estate = [02:08:53.593] scanslot = 0x385c37605bc8 [02:08:53.593] direction = ForwardScanDirection [02:08:53.593] oldpos = [02:08:53.593] att = [02:08:53.593] alldone = [02:08:53.593] funcno = [02:08:53.593] #11 0x00000000007dacfa in ExecScanFetch (node=0x385c36ffe8c0, epqstate=0x0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/include/executor/execScan.h:135 [02:08:53.593] No locals. [02:08:53.593] #12 ExecScanExtended (node=0x385c36ffe8c0, epqstate=0x0, qual=0x385c36ffe590, projInfo=0x385c36fff520, accessMtd=, recheckMtd=) at ../src/include/executor/execScan.h:196 [02:08:53.593] slot = [02:08:53.593] econtext = 0x385c36ffe620 [02:08:53.593] slot = [02:08:53.593] #13 ExecScan (node=0x385c36ffe8c0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/backend/executor/execScan.c:59 [02:08:53.593] qual = 0x385c36ffe590 [02:08:53.593] epqstate = 0x0 [02:08:53.593] projInfo = 0x385c36fff520 [02:08:53.593] #14 0x000000000080f16c in ExecProcNode (node=0x385c36ffe8c0) at ../src/include/executor/executor.h:327 [02:08:53.593] No locals. [02:08:53.593] #15 ExecSort (pstate=0x385c36ffe380) at ../src/backend/executor/nodeSort.c:135 [02:08:53.593] plannode = [02:08:53.593] tuplesortopts = [02:08:53.593] outerNode = 0x385c36ffe8c0 [02:08:53.593] tupDesc = [02:08:53.593] node = 0x385c36ffe380 [02:08:53.593] estate = 0x385c36ffe100 [02:08:53.593] tuplesortstate = 0x385c376ad100 [02:08:53.593] dir = ForwardScanDirection [02:08:53.593] slot = [02:08:53.593] #16 0x00000000007cee7b in ExecProcNode (node=0x385c36ffe380) at ../src/include/executor/executor.h:327 [02:08:53.593] No locals. [02:08:53.593] #17 ExecutePlan (queryDesc=0x385c36f26ac8, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x385c36f261c0) at ../src/backend/executor/execMain.c:1736 [02:08:53.593] estate = 0x385c36ffe100 [02:08:53.593] planstate = 0x385c36ffe380 [02:08:53.593] current_tuple_count = 0 [02:08:53.593] use_parallel_mode = [02:08:53.593] slot = [02:08:53.593] #18 standard_ExecutorRun (queryDesc=0x385c36f26ac8, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:53.593] estate = 0x385c36ffe100 [02:08:53.593] oldcontext = 0x385c36f26000 [02:08:53.593] operation = CMD_SELECT [02:08:53.593] dest = 0x385c36f261c0 [02:08:53.593] sendTuples = true [02:08:53.593] #19 0x00000008354e5d74 in pgss_ExecutorRun (queryDesc=0x385c36f26ac8, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:53.593] _local_sigjmp_buf = {{_sjb = {35254066510, 0, 34916646680, 34916646848, 34916646688, 13222088, 1, 61968710003400, 8192895, 61968710886145, 34916646848, 0}}} [02:08:53.593] _save_exception_stack = 0x82131c0a0 [02:08:53.593] _save_context_stack = 0x0 [02:08:53.593] _do_rethrow = false [02:08:53.593] #20 0x00000000007d3ec8 in ParallelQueryMain (seg=0x385c36f81078, toc=0x841562000) at ../src/backend/executor/execParallel.c:1583 [02:08:53.593] pwcxt = {seg = 0x385c36f81078, toc = 0x841562000} [02:08:53.593] instrument_options = [02:08:53.593] fpes = 0x841575840 [02:08:53.593] receiver = 0x385c36f261c0 [02:08:53.593] instrumentation = 0x0 [02:08:53.593] jit_instrumentation = 0x0 [02:08:53.593] queryDesc = 0x385c36f26ac8 [02:08:53.593] area_space = [02:08:53.593] area = 0x385c37651578 [02:08:53.593] buffer_usage = [02:08:53.593] wal_usage = [02:08:53.593] #21 0x00000000006977f1 in ParallelWorkerMain (main_arg=) at ../src/backend/access/transam/parallel.c:1571 [02:08:53.593] seg = 0x385c36f81078 [02:08:53.593] toc = 0x841562000 [02:08:53.593] fps = 0x84157afc0 [02:08:53.593] error_queue_space = [02:08:53.593] mq = [02:08:53.593] mqh = [02:08:53.593] entrypointstate = [02:08:53.593] library_name = [02:08:53.593] function_name = [02:08:53.593] entrypt = 0x7d3c40 [02:08:53.593] libraryspace = [02:08:53.593] tstatespace = [02:08:53.593] pendingsyncsspace = [02:08:53.593] relmapperspace = [02:08:53.593] reindexspace = [02:08:53.593] combocidspace = [02:08:53.593] session_dsm_handle_space = [02:08:53.593] asnapspace = [02:08:53.593] tsnapspace = [02:08:53.593] asnapshot = 0x385c36f26100 [02:08:53.593] tsnapshot = [02:08:53.593] gucspace = [02:08:53.593] uncommittedenumsspace = [02:08:53.593] clientconninfospace = [02:08:53.593] #22 0x00000000009107ec in BackgroundWorkerMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/bgworker.c:865 [02:08:53.593] local_sigjmp_buf = {{_sjb = {9504693, 61968709943352, 34916647064, 34916647216, 10342416, 10175840, 61968709943352, 34916647072, 206158431103, -2147815357, -1, 1}}} [02:08:53.593] worker = 0x385c36f18038 [02:08:53.593] entrypt = 0x0 [02:08:53.593] #23 0x0000000000915305 in postmaster_child_launch (child_type=child_type@entry=B_BG_WORKER, child_slot=219, startup_data=startup_data@entry=0x385c36e27288, startup_data_len=startup_data_len@entry=1472, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:268 [02:08:53.593] pid = [02:08:53.593] #24 0x0000000000918457 in StartBackgroundWorker (rw=0x385c36e27288) at ../src/backend/postmaster/postmaster.c:4207 [02:08:53.593] bn = 0x385c36f5d918 [02:08:53.593] worker_pid = [02:08:53.593] __error = [02:08:53.593] __error = [02:08:53.593] __error = [02:08:53.593] #25 maybe_start_bgworkers () at ../src/backend/postmaster/postmaster.c:4372 [02:08:53.593] rw = 0x385c36e27288 [02:08:53.593] num_launched = 0 [02:08:53.593] now = 0 [02:08:53.593] iter = {cur = 0x385c36e27860, next = , end = } [02:08:53.593] #26 0x000000000091a1d5 in LaunchMissingBackgroundProcesses () at ../src/backend/postmaster/postmaster.c:3437 [02:08:53.593] No locals. [02:08:53.593] #27 ServerLoop () at ../src/backend/postmaster/postmaster.c:1743 [02:08:53.593] now = [02:08:53.593] events = {{pos = 0, events = 1, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 921294296, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x214ecf7a893c52b3}, {pos = 733305920, events = 8, fd = 556910480, user_data = 0x43}, {pos = 556910256, events = 8, fd = -1240548667, user_data = 0x82131c690}, {pos = 732517157, events = 8, fd = 556910288, user_data = 0x39b6b60ebac5}, {pos = 731396004, events = 8, fd = 731396004, user_data = 0x82131c6e8}, {pos = 556910432, events = 8, fd = 731396296, user_data = 0x82b9838c8}, {pos = 556910352, events = 8, fd = -1240548667, user_data = 0x82131c750}, {pos = -1240569045, events = 14774, fd = 556910376, user_data = 0x82131c7a0}, {pos = 731392212, events = 8, fd = 731392212, user_data = 0x385c36a0a408}, {pos = 3, events = 0, fd = 556910480, user_data = 0x39b6b60e6b2b}, {pos = 556910536, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 556910568, user_data = 0x82131c9a8}, {pos = 556910544, events = 8, fd = -1240550350, user_data = 0x29a081}, {pos = 916518472, events = 14428, fd = 0, user_data = 0x0}, {pos = 556910632, events = 8, fd = 556911080, user_data = 0x82131c810}, {pos = -1240550350, events = 14774, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 916521040, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x82131cad8}, {pos = 920716928, events = 3, fd = 556911152, user_data = 0x385c36a0f6a8}, {pos = 656, events = 0, fd = 556911080, user_data = 0x82131c828}, {pos = 556910736, events = 8, fd = -1240550709, user_data = 0x82131ca98}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 916521040, events = 14428, fd = 1, user_data = 0x385c36a0a408}, {pos = 731315848, events = 8, fd = 556911320, user_data = 0x82131ca30}, {pos = 31, events = 0, fd = 0, user_data = 0x385c36a03008}, {pos = 556910752, events = 8, fd = 556911136, user_data = 0x39b6b60e50c7}, {pos = 916467720, events = 14428, fd = 916468744, user_data = 0x385c36a03808}, {pos = 916470792, events = 14428, fd = 916484104, user_data = 0x385c36a07408}, {pos = 916486152, events = 14428, fd = 916487176, user_data = 0x385c36a08008}, {pos = 916489224, events = 14428, fd = 916490248, user_data = 0x385c36a08c08}, {pos = 916492296, events = 14428, fd = 916493320, user_data = 0x385c36a09808}, {pos = 916495368, events = 14428, fd = 916496392, user_data = 0x385c36a0a408}, {pos = 916498440, events = 14428, fd = 916499464, user_data = 0x385c36a0b008}, {pos = 916501512, events = 14428, fd = 916502536, user_data = 0x385c36a0bc08}, {pos = 916504584, events = 14428, fd = 916505608, user_data = 0x385c36a0c808}, {pos = 916507656, events = 14428, fd = 916512776, user_data = 0x385c36a0e408}, {pos = 916515848, events = 14428, fd = 915485000, user_data = 0x385c36a03008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 916521040, events = 14428, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 556911320, user_data = 0x82131c8a0}, {pos = 31, events = 31, fd = 916467720, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x385c36a10050}, {pos = 556911296, events = 8, fd = -1240577092, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x385c36a10050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82baa0d70 }, {pos = 916467720, events = 14428, fd = 2859976, user_data = 0x82cbc6549}, {pos = 1, events = 0, fd = 917184520, user_data = 0x82131cac0}, {pos = 750540517, events = 8, fd = 732564848, user_data = 0xc7f098 }, {pos = 732564848, events = 8, fd = 916497416, user_data = 0x82131cba0}, {pos = -1240577612, events = 14774, fd = 16, user_data = 0x385c00000001}, {pos = -1240578002, events = 14774, fd = 916467720, user_data = 0x82131cac8}, {pos = 556911520, events = 8, fd = 7176, user_data = 0xc}, {pos = -1240495296, events = 14774, fd = 0, user_data = 0x82131037f}, {pos = 11979292, events = 0, fd = 556911440, user_data = 0x82cbbc5d0 <__pthread_cleanup_pop_imp+48>}, {pos = 733233920, events = 8, fd = 733242864, user_data = 0x0}, {pos = 8128, events = 0, fd = 556911488, user_data = 0x82cbc6b9d}, {pos = 556911504, events = 8, fd = 750503376, user_data = 0x82bb44300 <__thr_jtable>}, {pos = 733242864, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 556911552, events = 8, fd = 750545821, user_data = 0x385c36ab2008}, {pos = 47162, events = 0, fd = 556911648, user_data = 0x82cbbea7d}} [02:08:53.593] last_touch_time = 1778897067 [02:08:53.593] last_lockfile_recheck_time = 1778897067 [02:08:53.593] nevents = [02:08:53.593] #28 0x0000000000917a36 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82131d278) at ../src/backend/postmaster/postmaster.c:1415 [02:08:53.593] optctx = {nargc = 4, nargv = 0x82131d278, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x82131d93f "cluster-name=main", optind = 4, optopt = 45, place = 0x2f17c5 ""} [02:08:53.593] userDoption = [02:08:53.593] listen_addr_saved = false [02:08:53.593] output_config_variable = [02:08:53.593] opt = [02:08:53.593] status = [02:08:53.593] #29 0x000000000083c50d in main (argc=4, argv=0x82131d278) at ../src/backend/main/main.c:231 [02:08:53.593] do_check_root = [02:08:53.593] dispatch_option = DISPATCH_POSTMASTER [02:08:53.601] [02:08:53.601] [02:08:53.601] [02:08:53.660] dumping /tmp/cores/postgres.66274.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:08:53.794] [New LWP 100148] [02:08:53.860] Core was generated by `postgres: primary: postgres postgres [local] SELECT'. [02:08:53.860] Program terminated with signal SIGABRT, Aborted. [02:08:53.860] Sent by thr_kill() from pid 66274 and user 1002. [02:08:53.860] #0 0x000000082aa0701a in thr_kill () from /lib/libc.so.7 [02:08:53.909] [02:08:53.909] Thread 1 (LWP 100148): [02:08:53.909] #0 0x000000082aa0701a in thr_kill () from /lib/libc.so.7 [02:08:53.909] No symbol table info available. [02:08:53.909] #1 0x000000082a97fa64 in raise () from /lib/libc.so.7 [02:08:53.909] No symbol table info available. [02:08:53.909] #2 0x000000082aa33a59 in abort () from /lib/libc.so.7 [02:08:53.909] No symbol table info available. [02:08:53.909] #3 0x0000000000b3b00f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=901) at ../src/backend/utils/error/assert.c:65 [02:08:53.909] No locals. [02:08:53.909] #4 0x00000000006a1c61 in GetCurrentTransactionStopTimestamp () at ../src/backend/access/transam/xact.c:898 [02:08:53.909] s = [02:08:53.909] #5 0x00000000009fea2f in pgstat_relation_flush_cb (entry_ref=0x353828e2af30, nowait=) at ../src/backend/utils/activity/pgstat_relation.c:846 [02:08:53.909] t = [02:08:53.909] shtabstats = 0x83c83a200 [02:08:53.909] dboid = 5 [02:08:53.909] lstats = 0x353828e94588 [02:08:53.909] tabentry = 0x83c83a218 [02:08:53.909] dbentry = [02:08:53.909] #6 0x00000000009f8f86 in pgstat_flush_pending () at ../src/backend/utils/activity/pgstat.c:873 [02:08:53.909] entry_ref = 0x353828e2af30 [02:08:53.909] kind = [02:08:53.909] kind_info = [02:08:53.909] iter = [02:08:53.909] entry_ref = [02:08:53.909] kind = [02:08:53.909] kind_info = [02:08:53.909] #7 0x000000083588907b in pg_stat_statements_internal (fcinfo=, api_version=, api_version@entry=PGSS_V1_13, showtext=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1731 [02:08:53.909] qbuffer_size = 0 [02:08:53.909] hstat = {hash_table = 0x0, curbucket = 1994, nbuckets = 0, curitem = 0x3000300000000, pnextitem = 4080218931200, curpartition = 11104672, exclusive = false} [02:08:53.909] rsinfo = 0x8210b8760 [02:08:53.909] userid = 10 [02:08:53.909] is_allowed_role = [02:08:53.909] qbuffer = 0x35382969a100 "~", '\177' ... [02:08:53.909] extent = 0 [02:08:53.909] gc_count = 0 [02:08:53.909] p = [02:08:53.909] #8 0x0000000835888dc8 in pg_stat_statements_1_13 (fcinfo=0x18734) at ../contrib/pg_stat_statements/pg_stat_statements.c:1515 [02:08:53.909] showtext = false [02:08:53.909] #9 0x00000000007d9f96 in ExecMakeTableFunctionResult (setexpr=0x353828fe4980, econtext=0x353828fe47d0, argContext=, expectedDesc=0x3538296c4738, randomAccess=) at ../src/backend/executor/execSRF.c:235 [02:08:53.909] result = 34914142144 [02:08:53.909] fcusage = {fs = 0x0, save_f_total_time = {ticks = 1994}, save_total = {ticks = 25}, start = {ticks = 25}} [02:08:53.909] tmptup = {t_len = 695158056, t_self = {ip_blkid = {bi_hi = 13624, bi_lo = 0}, ip_posid = 17704}, t_tableOid = 13624, t_data = 0x0} [02:08:53.909] first_time = true [02:08:53.909] rsinfo = {type = T_ReturnSetInfo, econtext = 0x353828fe47d0, expectedDesc = 0x3538296c4738, allowedModes = 11, returnMode = SFRM_Materialize, isDone = ExprSingleResult, setResult = 0x3538296f3c58, setDesc = 0x353829708d38} [02:08:53.909] tupstore = 0x0 [02:08:53.909] tupdesc = 0x0 [02:08:53.909] returnsSet = true [02:08:53.909] callerContext = 0x353828fe4000 [02:08:53.909] funcrettype = 2249 [02:08:53.909] fcinfo = 0x3538296a0100 [02:08:53.909] returnsTuple = [02:08:53.909] #10 0x00000000007ef6c5 in FunctionNext (node=0x353828fe45c0) at ../src/backend/executor/nodeFunctionscan.c:95 [02:08:53.909] tstore = 0x0 [02:08:53.909] estate = [02:08:53.909] scanslot = 0x3538296c7f68 [02:08:53.909] direction = ForwardScanDirection [02:08:53.909] oldpos = [02:08:53.909] att = [02:08:53.909] alldone = [02:08:53.909] funcno = [02:08:53.909] #11 0x00000000007dacfa in ExecScanFetch (node=0x353828fe45c0, epqstate=0x0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/include/executor/execScan.h:135 [02:08:53.909] No locals. [02:08:53.909] #12 ExecScanExtended (node=0x353828fe45c0, epqstate=0x0, qual=0x353828fe5f80, projInfo=0x3538296c21c8, accessMtd=, recheckMtd=) at ../src/include/executor/execScan.h:196 [02:08:53.909] slot = [02:08:53.909] econtext = 0x353828fe47d0 [02:08:53.909] slot = [02:08:53.909] #13 ExecScan (node=0x353828fe45c0, accessMtd=0x7ef660 , recheckMtd=0x7ef960 ) at ../src/backend/executor/execScan.c:59 [02:08:53.909] qual = 0x353828fe5f80 [02:08:53.909] epqstate = 0x0 [02:08:53.909] projInfo = 0x3538296c21c8 [02:08:53.909] #14 0x00000000007ee233 in ExecProcNode (node=0x353828fe45c0) at ../src/include/executor/executor.h:327 [02:08:53.909] No locals. [02:08:53.909] #15 CteScanNext (node=0x3538296c1c58) at ../src/backend/executor/nodeCtescan.c:104 [02:08:53.909] cteslot = [02:08:53.909] estate = [02:08:53.909] dir = ForwardScanDirection [02:08:53.909] tuplestorestate = 0x3538296c20b8 [02:08:53.909] slot = 0x3538296eeee8 [02:08:53.909] eof_tuplestore = [02:08:53.909] forward = [02:08:53.909] #16 0x000000000080f16c in ExecProcNode (node=0x3538296c1c58) at ../src/include/executor/executor.h:327 [02:08:53.909] No locals. [02:08:53.909] #17 ExecSort (pstate=0x3538296c8378) at ../src/backend/executor/nodeSort.c:135 [02:08:53.909] plannode = [02:08:53.909] tuplesortopts = [02:08:53.909] outerNode = 0x3538296c1c58 [02:08:53.909] tupDesc = [02:08:53.909] node = 0x3538296c8378 [02:08:53.909] estate = 0x353828fe4100 [02:08:53.909] tuplesortstate = 0x3538296f4100 [02:08:53.909] dir = ForwardScanDirection [02:08:53.909] slot = [02:08:53.909] #18 0x00000000007e929d in ExecProcNode (node=0x3538296c8378) at ../src/include/executor/executor.h:327 [02:08:53.909] No locals. [02:08:53.909] #19 fetch_input_tuple (aggstate=aggstate@entry=0x3538296ee8b8) at ../src/backend/executor/nodeAgg.c:564 [02:08:53.909] slot = [02:08:53.909] #20 0x00000000007e7249 in agg_retrieve_direct (aggstate=0x3538296ee8b8) at ../src/backend/executor/nodeAgg.c:2453 [02:08:53.909] node = 0x3538296e3b50 [02:08:53.909] numGroupingSets = 1 [02:08:53.909] econtext = 0x3538296c1fa8 [02:08:53.909] firstSlot = 0x3538296ef3b8 [02:08:53.909] tmpcontext = 0x353828fe5e70 [02:08:53.909] peragg = 0x3538296f0408 [02:08:53.909] pergroups = 0x3538296f06a8 [02:08:53.909] numReset = 1 [02:08:53.909] i = [02:08:53.909] nextSetSize = 0 [02:08:53.909] outerslot = [02:08:53.909] currentSet = [02:08:53.909] result = [02:08:53.909] hasGroupingSets = [02:08:53.909] #21 ExecAgg (pstate=0x3538296ee8b8) at ../src/backend/executor/nodeAgg.c:2268 [02:08:53.909] node = 0x3538296ee8b8 [02:08:53.909] result = 0x0 [02:08:53.909] #22 0x00000000007cee7b in ExecProcNode (node=0x3538296ee8b8) at ../src/include/executor/executor.h:327 [02:08:53.909] No locals. [02:08:53.909] #23 ExecutePlan (queryDesc=0x353828e28d00, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x3538296e7d70) at ../src/backend/executor/execMain.c:1736 [02:08:53.909] estate = 0x353828fe4100 [02:08:53.909] planstate = 0x3538296ee8b8 [02:08:53.909] current_tuple_count = 0 [02:08:53.909] use_parallel_mode = [02:08:53.909] slot = [02:08:53.909] #24 standard_ExecutorRun (queryDesc=0x353828e28d00, direction=, count=0) at ../src/backend/executor/execMain.c:377 [02:08:53.909] estate = 0x353828fe4100 [02:08:53.909] oldcontext = 0x353828e28c00 [02:08:53.909] operation = CMD_SELECT [02:08:53.909] dest = 0x3538296e7d70 [02:08:53.909] sendTuples = true [02:08:53.909] #25 0x0000000835887d74 in pgss_ExecutorRun (queryDesc=0x353828e28d00, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:903 [02:08:53.909] _local_sigjmp_buf = {{_sjb = {35257875790, 0, 34914142872, 34914143040, 34914142880, 13222088, 1, 58515320376576, 34914108287, 8222592, 1, 0}}} [02:08:53.909] _save_exception_stack = 0x8210b8b90 [02:08:53.909] _save_context_stack = 0x0 [02:08:53.909] _do_rethrow = false [02:08:53.909] #26 0x00000000009e29a6 in PortalRunSelect (portal=portal@entry=0x353828f20100, forward=, count=0, count@entry=9223372036854775807, dest=dest@entry=0x3538296e7d70) at ../src/backend/tcop/pquery.c:917 [02:08:53.909] queryDesc = 0x353828e28d00 [02:08:53.909] direction = ForwardScanDirection [02:08:53.909] nprocessed = [02:08:53.909] #27 0x00000000009e2570 in PortalRun (portal=portal@entry=0x353828f20100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x3538296e7d70, altdest=altdest@entry=0x3538296e7d70, qc=qc@entry=0x8210b8c90) at ../src/backend/tcop/pquery.c:761 [02:08:53.909] _local_sigjmp_buf = {{_sjb = {10364101, 58515321389312, 34914143112, 34914143360, 34914143120, 13222088, 34914143376, 13142488, 13108095, 0, 895, 58514634440704}}} [02:08:53.909] _save_exception_stack = 0x8210b8d40 [02:08:53.909] _save_context_stack = 0x0 [02:08:53.909] _do_rethrow = false [02:08:53.909] saveTopTransactionResourceOwner = 0x353828f64758 [02:08:53.909] saveTopTransactionContext = 0x353828f26000 [02:08:53.909] saveActivePortal = 0x0 [02:08:53.909] saveResourceOwner = 0x353828f64758 [02:08:53.909] savePortalContext = 0x0 [02:08:53.909] saveMemoryContext = 0x353828f26000 [02:08:53.909] result = [02:08:53.909] nprocessed = [02:08:53.909] #28 0x00000000009e1247 in exec_simple_query (query_string=query_string@entry=0x353828e1a100 "WITH select_stats AS\n (SELECT upper(substr(query, 1, 6)) AS select_query\n FROM pg_stat_statements\n WHERE upper(substr(query, 1, 6)) IN ('SELECT', 'UPDATE',\n", ' ' ...) at ../src/backend/tcop/postgres.c:1290 [02:08:53.909] cmdtaglen = 6 [02:08:53.909] snapshot_set = [02:08:53.909] per_parsetree_context = 0x0 [02:08:53.909] plantree_list = [02:08:53.909] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:53.909] format = 0 [02:08:53.909] parsetree = 0x353828f5ca18 [02:08:53.909] commandTag = [02:08:53.909] cmdtagname = [02:08:53.909] querytree_list = [02:08:53.909] portal = 0x353828f20100 [02:08:53.909] receiver = 0x3538296e7d70 [02:08:53.909] parsetree_item__state = {l = , i = 0} [02:08:53.909] msec_str = "\000\000\000\000\b", '\000' , "\340\214\v!\b\000\000\000\2208\240*\b\000\000" [02:08:53.909] dest = DestRemote [02:08:53.909] save_log_statement_stats = false [02:08:53.909] was_logged = [02:08:53.909] oldcontext = 0x353828f26000 [02:08:53.909] parsetree_list = 0x353828f5dfd8 [02:08:53.909] use_implicit_block = [02:08:53.909] parsetree_item = 0x353828f5dff0 [02:08:53.909] #29 0x00000000009dec1b in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4855 [02:08:53.909] query_string = 0x353828e1a100 "WITH select_stats AS\n (SELECT upper(substr(query, 1, 6)) AS select_query\n FROM pg_stat_statements\n WHERE upper(substr(query, 1, 6)) IN ('SELECT', 'UPDATE',\n", ' ' ... [02:08:53.909] input_message = {data = 0x353828e1a100 "WITH select_stats AS\n (SELECT upper(substr(query, 1, 6)) AS select_query\n FROM pg_stat_statements\n WHERE upper(substr(query, 1, 6)) IN ('SELECT', 'UPDATE',\n", ' ' ..., len = 411, maxlen = 1024, cursor = 411} [02:08:53.909] firstchar = [02:08:53.909] local_sigjmp_buf = {{_sjb = {10346682, 34914143552, 34914143544, 34914144160, 13007356, 13007024, 13230984, 13224820, 895, 0, 0, 58514634440705}}} [02:08:53.909] send_ready_for_query = false [02:08:53.909] idle_in_transaction_timeout_enabled = false [02:08:53.909] idle_session_timeout_enabled = false [02:08:53.909] #30 0x00000000009d9039 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [02:08:53.909] bsdata = [02:08:53.909] #31 0x0000000000915305 in postmaster_child_launch (child_type=, child_slot=1, startup_data=startup_data@entry=0x8210b9a08, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x8210b9a20) at ../src/backend/postmaster/launch_backend.c:268 [02:08:53.909] pid = [02:08:53.909] #32 0x0000000000919e15 in BackendStartup (client_sock=0x8210b9a20) at ../src/backend/postmaster/postmaster.c:3627 [02:08:53.909] startup_data = {canAcceptConnections = CAC_OK, socket_created = 832212322092951, fork_started = } [02:08:53.909] bn = 0x353828f5b1f8 [02:08:53.909] cac = CAC_OK [02:08:53.909] pid = [02:08:53.909] __error = [02:08:53.909] save_errno = [02:08:53.909] __error = [02:08:53.909] __error = [02:08:53.909] #33 ServerLoop () at ../src/backend/postmaster/postmaster.c:1728 [02:08:53.909] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\r", '\000' , "\200\232\v!\b\000\000\000\350ƌ+\b\000\000\000w\000\000\000\000\000\000\000TO\215+\b", '\000' , "\300\232\v!\b\000\000\000DP\221\000\000\000\000\000H\302\365(85", '\000' }, salen = 16}} [02:08:53.909] i = 0 [02:08:53.909] now = [02:08:53.909] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 686384600, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xae341d7b45ea0297}, {pos = 715889728, events = 8, fd = 554407360, user_data = 0x43}, {pos = 554407136, events = 8, fd = -635557179, user_data = 0x8210b94c0}, {pos = 715100965, events = 8, fd = 554407168, user_data = 0x271fda1e2ac5}, {pos = 713979812, events = 8, fd = 713979812, user_data = 0x8210b9518}, {pos = 554407312, events = 8, fd = 713980104, user_data = 0x82a8e78c8}, {pos = 554407232, events = 8, fd = -635557179, user_data = 0x8210b9580}, {pos = -635577557, events = 10015, fd = 554407256, user_data = 0x8210b95d0}, {pos = 713976020, events = 8, fd = 713976020, user_data = 0x353828a0a408}, {pos = 3, events = 0, fd = 554407360, user_data = 0x271fda1ddb2b}, {pos = 554407416, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 554407448, user_data = 0x8210b97d8}, {pos = 554407424, events = 8, fd = -635558862, user_data = 0x29a081}, {pos = 681637448, events = 13624, fd = 0, user_data = 0x0}, {pos = 554407512, events = 8, fd = 554407960, user_data = 0x8210b9640}, {pos = -635558862, events = 10015, fd = 2753676, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 681640016, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x8210b9908}, {pos = 685835712, events = 3, fd = 554408032, user_data = 0x353828a0f6a8}, {pos = 656, events = 0, fd = 554407960, user_data = 0x8210b9658}, {pos = 554407616, events = 8, fd = -635559221, user_data = 0x8210b98c8}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 681640016, events = 13624, fd = 1, user_data = 0x353828a0a408}, {pos = 713899656, events = 8, fd = 554408200, user_data = 0x8210b9860}, {pos = 31, events = 0, fd = 0, user_data = 0x353828a03008}, {pos = 554407632, events = 8, fd = 554408016, user_data = 0x271fda1dc0c7}, {pos = 681586696, events = 13624, fd = 681587720, user_data = 0x353828a03808}, {pos = 681589768, events = 13624, fd = 681603080, user_data = 0x353828a07408}, {pos = 681605128, events = 13624, fd = 681606152, user_data = 0x353828a08008}, {pos = 681608200, events = 13624, fd = 681609224, user_data = 0x353828a08c08}, {pos = 681611272, events = 13624, fd = 681612296, user_data = 0x353828a09808}, {pos = 681614344, events = 13624, fd = 681615368, user_data = 0x353828a0a408}, {pos = 681617416, events = 13624, fd = 681618440, user_data = 0x353828a0b008}, {pos = 681620488, events = 13624, fd = 681621512, user_data = 0x353828a0bc08}, {pos = 681623560, events = 13624, fd = 681624584, user_data = 0x353828a0c808}, {pos = 681626632, events = 13624, fd = 681631752, user_data = 0x353828a0e408}, {pos = 681634824, events = 13624, fd = 727864000, user_data = 0x353828a03008}, {pos = 2753676, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 681640016, events = 13624, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554408200, user_data = 0x8210b96d0}, {pos = 31, events = 31, fd = 681586696, user_data = 0x1}, {pos = 2615992, events = 0, fd = 309, user_data = 0x353828a10050}, {pos = 554408176, events = 8, fd = -635585604, user_data = 0x2a048c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x353828a10050}, {pos = 1, events = 0, fd = 13103256, user_data = 0x82aa04d70 }, {pos = 681586696, events = 13624, fd = 2859976, user_data = 0x82b8d4549}, {pos = 1, events = 0, fd = 682303496, user_data = 0x8210b98f0}, {pos = 730674917, events = 8, fd = 715148656, user_data = 0xc7f098 }, {pos = 715148656, events = 8, fd = 681616392, user_data = 0x8210b99d0}, {pos = -635586124, events = 10015, fd = 16, user_data = 0x353800000001}, {pos = -635586514, events = 10015, fd = 681586696, user_data = 0x8210b98f8}, {pos = 554408400, events = 8, fd = 7176, user_data = 0xc}, {pos = -635503808, events = 10015, fd = 0, user_data = 0x8210b037f}, {pos = 11979292, events = 0, fd = 554408320, user_data = 0x82b8ca5d0 <__pthread_cleanup_pop_imp+48>}, {pos = 715817728, events = 8, fd = 715826672, user_data = 0x0}, {pos = 8128, events = 0, fd = 554408368, user_data = 0x82b8d4b9d}, {pos = 554408384, events = 8, fd = 730637776, user_data = 0x82aaa8300 <__thr_jtable>}, {pos = 715826672, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 554408432, events = 8, fd = 730680221, user_data = 0x353828ab2008}, {pos = 40489, events = 0, fd = 554408528, user_data = 0x82b8cca7d}} [02:08:53.910] last_touch_time = 1778897049 [02:08:53.910] last_lockfile_recheck_time = 1778897122 [02:08:53.910] nevents = 1 [02:08:53.910] #34 0x0000000000917a36 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8210ba0a8) at ../src/backend/postmaster/postmaster.c:1415 [02:08:53.910] optctx = {nargc = 4, nargv = 0x8210ba0a8, ostr = 0x36bb3c "B:bC:c:D:d:EeFf:h:ijk:lN:OPp:r:S:sTt:W:-:", opterr = 1, optarg = 0x8210ba77e "cluster-name=primary", optind = 4, optopt = 45, place = 0x2f17c5 ""} [02:08:53.910] userDoption = [02:08:53.910] listen_addr_saved = false [02:08:53.910] output_config_variable = [02:08:53.910] opt = [02:08:53.910] status = [02:08:53.910] #35 0x000000000083c50d in main (argc=4, argv=0x8210ba0a8) at ../src/backend/main/main.c:231 [02:08:53.910] do_check_root = [02:08:53.910] dispatch_option = DISPATCH_POSTMASTER