[00:39:34.433] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [00:39:34.770] dumping /tmp/cores/postgres.9563.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:39:34.904] [New LWP 101859] [00:39:34.988] Core was generated by `postgres: old_node: postgres regression [local] SELECT'. [00:39:34.988] Program terminated with signal SIGABRT, Aborted. [00:39:34.988] Sent by thr_kill() from pid 9563 and user 1003. [00:39:34.988] #0 0x000000082b58adca in thr_kill () from /lib/libc.so.7 [00:39:35.123] [00:39:35.123] Thread 1 (LWP 101859): [00:39:35.123] #0 0x000000082b58adca in thr_kill () from /lib/libc.so.7 [00:39:35.123] No symbol table info available. [00:39:35.123] #1 0x000000082b5036f4 in raise () from /lib/libc.so.7 [00:39:35.123] No symbol table info available. [00:39:35.123] #2 0x000000082b5b4bc9 in abort () from /lib/libc.so.7 [00:39:35.123] No symbol table info available. [00:39:35.123] #3 0x0000000000a42a57 in ExceptionalCondition (conditionName=, fileName=0x2db649 "../src/include/storage/bufmgr.h", lineNumber=lineNumber@entry=364) at ../src/backend/utils/error/assert.c:66 [00:39:35.123] No locals. [00:39:35.123] #4 0x00000000005c44c4 in heapam_scan_bitmap_next_tuple (scan=0x841f1e058, slot=0x834362ce0, recheck=0x8343626c0, lossy_pages=0x8343626a8, exact_pages=0x8343626a0) at ../src/backend/access/heap/heapam_handler.c:2249 [00:39:35.123] targoffset = [00:39:35.123] page = [00:39:35.123] hscan = [00:39:35.123] lp = [00:39:35.123] #5 0x000000000073bf02 in table_scan_bitmap_next_tuple (scan=0x841f1e058, slot=0x834362ce0, recheck=0x8343626c0, lossy_pages=0x82b58adaa , exact_pages=0x0) at ../src/include/access/tableam.h:1987 [00:39:35.123] __error = [00:39:35.123] #6 BitmapHeapNext (node=node@entry=0x8343625b0) at ../src/backend/executor/nodeBitmapHeapscan.c:197 [00:39:35.123] econtext = 0x8343627c0 [00:39:35.123] dsa = [00:39:35.123] slot = 0x834362ce0 [00:39:35.123] scan = 0x841f1e058 [00:39:35.123] tbm = [00:39:35.123] #7 0x000000000072b433 in ExecScanFetch (node=node@entry=0x8343625b0, accessMtd=accessMtd@entry=0x73bc60 , recheckMtd=recheckMtd@entry=0x73c0d0 ) at ../src/backend/executor/execScan.c:131 [00:39:35.123] estate = [00:39:35.123] #8 0x000000000072b248 in ExecScan (node=0x8343625b0, accessMtd=0x6, recheckMtd=0x73c0d0 ) at ../src/backend/executor/execScan.c:197 [00:39:35.123] slot = [00:39:35.123] qual = 0x83452a718 [00:39:35.123] econtext = 0x8343627c0 [00:39:35.123] projInfo = 0x0 [00:39:35.123] #9 0x000000000073baf4 in ExecBitmapHeapScan (pstate=0x18de3) at ../src/backend/executor/nodeBitmapHeapscan.c:274 [00:39:35.123] node = 0x18de3 [00:39:35.123] #10 0x000000000072885b in ExecProcNodeFirst (node=0x8343625b0) at ../src/backend/executor/execProcnode.c:464 [00:39:35.123] No locals. [00:39:35.123] #11 0x00000000007451dd in ExecProcNode (node=0x8343625b0) at ../src/include/executor/executor.h:274 [00:39:35.123] No locals. [00:39:35.123] #12 ExecHashJoinImpl (pstate=0x834362310, parallel=false) at ../src/backend/executor/nodeHashjoin.c:317 [00:39:35.123] node = 0x834362310 [00:39:35.123] joinqual = 0x0 [00:39:35.123] otherqual = 0x0 [00:39:35.123] outerNode = 0x8343625b0 [00:39:35.123] hashNode = 0x834362df0 [00:39:35.123] hashtable = 0x0 [00:39:35.123] econtext = 0x834362520 [00:39:35.123] parallel_state = 0x0 [00:39:35.123] hashvalue = [00:39:35.123] outerTupleSlot = [00:39:35.123] batchno = [00:39:35.123] build_barrier = [00:39:35.123] build_barrier = [00:39:35.123] shouldFree = [00:39:35.123] mintuple = [00:39:35.123] __error = [00:39:35.123] #13 ExecHashJoin (pstate=0x834362310) at ../src/backend/executor/nodeHashjoin.c:683 [00:39:35.123] No locals. [00:39:35.123] #14 0x000000000072885b in ExecProcNodeFirst (node=0x834362310) at ../src/backend/executor/execProcnode.c:464 [00:39:35.123] No locals. [00:39:35.123] #15 0x000000000075763d in ExecProcNode (node=0x834362310) at ../src/include/executor/executor.h:274 [00:39:35.123] No locals. [00:39:35.123] #16 ExecNestLoop (pstate=0x8343620e0) at ../src/backend/executor/nodeNestloop.c:108 [00:39:35.123] node = 0x8343620e0 [00:39:35.123] nl = 0x8455c0508 [00:39:35.123] otherqual = 0x0 [00:39:35.123] joinqual = 0x841eff498 [00:39:35.123] outerPlan = 0x834362310 [00:39:35.123] innerPlan = 0x841ea69a8 [00:39:35.123] econtext = 0x8343621f0 [00:39:35.123] innerTupleSlot = [00:39:35.123] outerTupleSlot = [00:39:35.123] lc = [00:39:35.123] #17 0x000000000072885b in ExecProcNodeFirst (node=0x8343620e0) at ../src/backend/executor/execProcnode.c:464 [00:39:35.123] No locals. [00:39:35.123] #18 0x000000000075763d in ExecProcNode (node=0x8343620e0) at ../src/include/executor/executor.h:274 [00:39:35.123] No locals. [00:39:35.123] #19 ExecNestLoop (pstate=0x834361f40) at ../src/backend/executor/nodeNestloop.c:108 [00:39:35.123] node = 0x834361f40 [00:39:35.123] nl = 0x8455bffd8 [00:39:35.123] otherqual = 0x0 [00:39:35.123] joinqual = 0x0 [00:39:35.123] outerPlan = 0x8343620e0 [00:39:35.123] innerPlan = 0x841effa78 [00:39:35.123] econtext = 0x834362050 [00:39:35.123] innerTupleSlot = [00:39:35.123] outerTupleSlot = [00:39:35.123] lc = [00:39:35.123] #20 0x000000000072885b in ExecProcNodeFirst (node=0x834361f40) at ../src/backend/executor/execProcnode.c:464 [00:39:35.123] No locals. [00:39:35.123] #21 0x000000000075763d in ExecProcNode (node=0x834361f40) at ../src/include/executor/executor.h:274 [00:39:35.123] No locals. [00:39:35.123] #22 ExecNestLoop (pstate=0x834361da0) at ../src/backend/executor/nodeNestloop.c:108 [00:39:35.123] node = 0x834361da0 [00:39:35.123] nl = 0x8455bfaa8 [00:39:35.123] otherqual = 0x0 [00:39:35.123] joinqual = 0x0 [00:39:35.123] outerPlan = 0x834361f40 [00:39:35.123] innerPlan = 0x841f01518 [00:39:35.123] econtext = 0x834361eb0 [00:39:35.123] innerTupleSlot = [00:39:35.123] outerTupleSlot = [00:39:35.123] lc = [00:39:35.123] #23 0x000000000072885b in ExecProcNodeFirst (node=0x834361da0) at ../src/backend/executor/execProcnode.c:464 [00:39:35.123] No locals. [00:39:35.123] #24 0x000000000075763d in ExecProcNode (node=0x834361da0) at ../src/include/executor/executor.h:274 [00:39:35.123] No locals. [00:39:35.123] #25 ExecNestLoop (pstate=0x834361c00) at ../src/backend/executor/nodeNestloop.c:108 [00:39:35.123] node = 0x834361c00 [00:39:35.123] nl = 0x8455bed98 [00:39:35.123] otherqual = 0x0 [00:39:35.123] joinqual = 0x0 [00:39:35.123] outerPlan = 0x834361da0 [00:39:35.123] innerPlan = 0x841f039d0 [00:39:35.123] econtext = 0x834361d10 [00:39:35.123] innerTupleSlot = [00:39:35.123] outerTupleSlot = [00:39:35.123] lc = [00:39:35.123] #26 0x000000000072885b in ExecProcNodeFirst (node=0x834361c00) at ../src/backend/executor/execProcnode.c:464 [00:39:35.123] No locals. [00:39:35.123] #27 0x000000000075a079 in ExecProcNode (node=0x834361c00) at ../src/include/executor/executor.h:274 [00:39:35.123] No locals. [00:39:35.123] #28 ExecSort (pstate=0x8343619f0) at ../src/backend/executor/nodeSort.c:149 [00:39:35.123] plannode = [00:39:35.123] tuplesortopts = [00:39:35.123] outerNode = 0x834361c00 [00:39:35.123] tupDesc = [00:39:35.123] node = 0x8343619f0 [00:39:35.123] estate = 0x834361100 [00:39:35.123] tuplesortstate = 0x841ee7100 [00:39:35.123] dir = ForwardScanDirection [00:39:35.123] slot = [00:39:35.123] #29 0x000000000072885b in ExecProcNodeFirst (node=0x8343619f0) at ../src/backend/executor/execProcnode.c:464 [00:39:35.123] No locals. [00:39:35.123] #30 0x000000000075e5fe in ExecProcNode (node=0x8343619f0) at ../src/include/executor/executor.h:274 [00:39:35.123] No locals. [00:39:35.123] #31 ExecUnique (pstate=0x8343618e0) at ../src/backend/executor/nodeUnique.c:72 [00:39:35.123] node = 0x8343618e0 [00:39:35.123] econtext = 0x8343617c0 [00:39:35.123] outerPlan = 0x8343619f0 [00:39:35.123] resultTupleSlot = 0x841f1c538 [00:39:35.123] slot = [00:39:35.123] #32 0x000000000072885b in ExecProcNodeFirst (node=0x8343618e0) at ../src/backend/executor/execProcnode.c:464 [00:39:35.123] No locals. [00:39:35.123] #33 0x000000000075c6f2 in ExecProcNode (node=0x8343618e0) at ../src/include/executor/executor.h:274 [00:39:35.123] No locals. [00:39:35.123] #34 SubqueryNext (node=node@entry=0x834361620) at ../src/backend/executor/nodeSubqueryscan.c:53 [00:39:35.123] slot = [00:39:35.123] #35 0x000000000072b433 in ExecScanFetch (node=node@entry=0x834361620, accessMtd=accessMtd@entry=0x75c6d0 , recheckMtd=recheckMtd@entry=0x75c700 ) at ../src/backend/executor/execScan.c:131 [00:39:35.123] estate = [00:39:35.123] #36 0x000000000072b248 in ExecScan (node=0x834361620, accessMtd=0x6, recheckMtd=0x75c700 ) at ../src/backend/executor/execScan.c:197 [00:39:35.123] slot = [00:39:35.123] qual = 0x0 [00:39:35.123] econtext = 0x834361730 [00:39:35.123] projInfo = 0x841f1d628 [00:39:35.123] #37 0x000000000075c654 in ExecSubqueryScan (pstate=0x18de3) at ../src/backend/executor/nodeSubqueryscan.c:87 [00:39:35.123] node = 0x18de3 [00:39:35.123] #38 0x000000000072885b in ExecProcNodeFirst (node=0x834361620) at ../src/backend/executor/execProcnode.c:464 [00:39:35.123] No locals. [00:39:35.123] #39 0x000000000075a079 in ExecProcNode (node=0x834361620) at ../src/include/executor/executor.h:274 [00:39:35.123] No locals. [00:39:35.123] #40 ExecSort (pstate=0x834361410) at ../src/backend/executor/nodeSort.c:149 [00:39:35.123] plannode = [00:39:35.123] tuplesortopts = [00:39:35.123] outerNode = 0x834361620 [00:39:35.123] tupDesc = [00:39:35.123] node = 0x834361410 [00:39:35.123] estate = 0x834361100 [00:39:35.123] tuplesortstate = 0x841ee3100 [00:39:35.123] dir = ForwardScanDirection [00:39:35.123] slot = [00:39:35.123] #41 0x000000000072885b in ExecProcNodeFirst (node=0x834361410) at ../src/backend/executor/execProcnode.c:464 [00:39:35.123] No locals. [00:39:35.123] #42 0x0000000000720c0a in ExecProcNode (node=0x834361410) at ../src/include/executor/executor.h:274 [00:39:35.123] No locals. [00:39:35.123] #43 ExecutePlan (estate=0x834361100, planstate=0x834361410, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x8455ca390, execute_once=false) at ../src/backend/executor/execMain.c:1644 [00:39:35.123] current_tuple_count = [00:39:35.123] slot = [00:39:35.123] #44 standard_ExecutorRun (queryDesc=0x83438c100, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [00:39:35.123] estate = 0x834361100 [00:39:35.123] oldcontext = 0x83438c000 [00:39:35.123] operation = CMD_SELECT [00:39:35.123] dest = 0x8455ca390 [00:39:35.123] sendTuples = true [00:39:35.123] #45 0x0000000000720abf in ExecutorRun (queryDesc=0x18de3, queryDesc@entry=0x83438c100, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [00:39:35.123] No locals. [00:39:35.123] #46 0x00000000008f1be7 in PortalRunSelect (portal=portal@entry=0x8343ee100, forward=, count=0, count@entry=9223372036854775807, dest=dest@entry=0x8455ca390) at ../src/backend/tcop/pquery.c:924 [00:39:35.123] queryDesc = 0x83438c100 [00:39:35.123] direction = ForwardScanDirection [00:39:35.123] nprocessed = [00:39:35.123] #47 0x00000000008f1760 in PortalRun (portal=portal@entry=0x8343ee100, count=0, count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82b58adaa , dest@entry=0x8455ca390, altdest=altdest@entry=0x8455ca390, qc=0x821503980) at ../src/backend/tcop/pquery.c:768 [00:39:35.123] _local_sigjmp_buf = {{_sjb = {9377455, 35236610392, 34918643832, 34918644064, 34918643840, 12034536, 12002320, 35236274432, 7112098687, 35236282624, 3563986, 34359738368}}} [00:39:35.123] _save_exception_stack = 0x821503a50 [00:39:35.123] _save_context_stack = 0x0 [00:39:35.123] _do_rethrow = false [00:39:35.123] saveTopTransactionResourceOwner = 0x834440158 [00:39:35.123] saveTopTransactionContext = 0x8343a4000 [00:39:35.123] saveActivePortal = 0x0 [00:39:35.123] saveResourceOwner = 0x834440158 [00:39:35.123] savePortalContext = 0x0 [00:39:35.123] saveMemoryContext = 0x8343a4000 [00:39:35.123] result = [00:39:35.123] nprocessed = [00:39:35.123] #48 0x00000000008f061b in exec_simple_query (query_string=query_string@entry=0x834355100 "SELECT routine_name, table_name, column_name FROM information_schema.routine_column_usage\n WHERE routine_schema = 'temp_func_test'\n ORDER BY 1, 2;") at ../src/backend/tcop/postgres.c:1274 [00:39:35.123] cmdtaglen = [00:39:35.123] snapshot_set = [00:39:35.123] per_parsetree_context = 0x0 [00:39:35.123] plantree_list = [00:39:35.123] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:39:35.123] parsetree = 0x8344adc58 [00:39:35.123] commandTag = CMDTAG_SELECT [00:39:35.123] cmdtagname = [00:39:35.123] querytree_list = [00:39:35.123] portal = 0x8343ee100 [00:39:35.123] format = 0 [00:39:35.123] receiver = 0x8455ca390 [00:39:35.123] parsetree_item__state = {l = 0x8344ae440, i = 0} [00:39:35.123] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [00:39:35.123] dest = DestRemote [00:39:35.123] was_logged = [00:39:35.123] oldcontext = 0x8343a4000 [00:39:35.123] parsetree_list = 0x8344ae440 [00:39:35.123] use_implicit_block = false [00:39:35.123] parsetree_item = 0x8344ae458 [00:39:35.123] save_log_statement_stats = [00:39:35.123] #49 0x00000000008ee404 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [00:39:35.123] query_string = 0x834355100 "SELECT routine_name, table_name, column_name FROM information_schema.routine_column_usage\n WHERE routine_schema = 'temp_func_test'\n ORDER BY 1, 2;" [00:39:35.123] input_message = {data = 0x834355100 "SELECT routine_name, table_name, column_name FROM information_schema.routine_column_usage\n WHERE routine_schema = 'temp_func_test'\n ORDER BY 1, 2;", len = 149, maxlen = 1024, cursor = 149} [00:39:35.123] firstchar = [00:39:35.123] local_sigjmp_buf = {{_sjb = {9361616, 34918644304, 34918644264, 34918644864, 12043272, 11989744, 8192, 8388608, 72057628956558207, 0, 0, 34359738369}}} [00:39:35.123] send_ready_for_query = false [00:39:35.123] idle_in_transaction_timeout_enabled = false [00:39:35.123] idle_session_timeout_enabled = false [00:39:35.123] #50 0x00000000008e9169 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [00:39:35.123] bsdata = [00:39:35.123] #51 0x0000000000844e72 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821504790 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8215046d8) at ../src/backend/postmaster/launch_backend.c:265 [00:39:35.123] pid = [00:39:35.123] #52 0x0000000000849691 in BackendStartup (client_sock=0x8215046d8) at ../src/backend/postmaster/postmaster.c:3593 [00:39:35.123] startup_data = {canAcceptConnections = CAC_OK} [00:39:35.123] bn = 0x834361588 [00:39:35.123] pid = [00:39:35.123] __error = [00:39:35.123] __error = [00:39:35.123] save_errno = [00:39:35.123] __error = [00:39:35.123] __error = [00:39:35.123] #53 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [00:39:35.123] 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 = '\000' , "0GP!\b\000\000\000\330\205l(\b\000\000\000\v\000\000\000\000\000\000\000\016\006m(\b", '\000' , "pGP!\b\000\000\000DL\204\000\000\000\000\000\200GP!\b", '\000' }, salen = 16}} [00:39:35.123] i = 0 [00:39:35.123] now = [00:39:35.123] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 726088804, events = 8, fd = 558906656, user_data = 0x821503eb0}, {pos = 563713032, events = 8, fd = 32, user_data = 0x821503ea0}, {pos = -173245804, events = 14050, fd = 563683336, user_data = 0x821992408}, {pos = 563685384, events = 8, fd = 563686408, user_data = 0x821996008}, {pos = 563700744, events = 8, fd = 563701768, user_data = 0x821996c08}, {pos = 563703816, events = 8, fd = 563704840, user_data = 0x821997808}, {pos = 563706888, events = 8, fd = 563707912, user_data = 0x821998408}, {pos = 563709960, events = 8, fd = 563710984, user_data = 0x821999008}, {pos = 563713032, events = 8, fd = 563732616, user_data = 0x821504028}, {pos = 558906960, events = 8, fd = -173220445, user_data = 0x0}, {pos = 2568150, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 563736632, events = 8, fd = 1, user_data = 0x821999408}, {pos = 725996712, events = 8, fd = 558907688, user_data = 0x821999408}, {pos = 558906944, events = 0, fd = 726104420, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 563739192, user_data = 0x1}, {pos = 563713032, events = 8, fd = 726018264, user_data = 0x821503f68}, {pos = 558906656, events = 8, fd = 32, user_data = 0x82b473c64}, {pos = 563713032, events = 8, fd = 563739192, user_data = 0x0}, {pos = 2625, events = 0, fd = 558907216, user_data = 0x36e2f5ac7645}, {pos = 726104420, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 563739192, events = 8, fd = 1, user_data = 0x821999408}, {pos = 875843584, events = 8, fd = 1, user_data = 0x834345194}, {pos = 0, events = 0, fd = 558907168, user_data = 0x8286cfc0c}, {pos = 1, events = 0, fd = 875843584, user_data = 0x821503f50}, {pos = 678227636, events = 8, fd = 727830880, user_data = 0x82b61d160 }, {pos = 726200512, events = 8, fd = 563713032, user_data = 0x821504030}, {pos = -173247444, events = 14050, fd = 563712008, user_data = 0x800000001}, {pos = -173247826, events = 14050, fd = 12240, user_data = 0x821503f58}, {pos = 558907440, events = 8, fd = 876640232, user_data = 0x8215045a0}, {pos = -173166960, events = 14050, fd = 563713032, user_data = 0x82150037f}, {pos = 727487666, events = 8, fd = 563683336, user_data = 0x0}, {pos = 563713032, events = 8, fd = 12240, user_data = 0x82b453000}, {pos = 1964368, events = 0, fd = 727830880, user_data = 0x82b473c64}, {pos = 15616, events = 0, fd = 558908624, user_data = 0x8215040a0}, {pos = 726761870, events = 8, fd = 727869496, user_data = 0x821504064}, {pos = 876295642, events = 8, fd = 558908624, user_data = 0x8215040a0}, {pos = 726853125, events = 8, fd = 558907490, user_data = 0x8215044d0}, {pos = 558908624, events = 8, fd = 0, user_data = 0x4f02236304ccb4d8}, {pos = 558908624, events = 8, fd = 876295640, user_data = 0x8215045a0}, {pos = 727869496, events = 8, fd = 0, user_data = 0x821504510}, {pos = 726853389, events = 8, fd = 0, user_data = 0x0}, {pos = 558908992, events = 8, fd = 876295640, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -173218807, events = 14050, fd = 558907896, user_data = 0x82b473c64}, {pos = 2503, events = 0, fd = -173218807, user_data = 0x821504218}, {pos = 726088804, events = 8, fd = 2758, user_data = 0x82b46d120}, {pos = 558907800, events = 8, fd = 563713032, user_data = 0x821504218}, {pos = 726061344, events = 8, fd = 558907904, user_data = 0x36e2f5ac9465}, {pos = 0, events = 0, fd = 0, user_data = 0x82b63f0f0}, {pos = 726021456, events = 8, fd = 0, user_data = 0x0}, {pos = 727898544, events = 8, fd = -173218807, user_data = 0x8215042a8}, {pos = 726088804, events = 8, fd = 2924, user_data = 0x82b46d3b8}, {pos = 558907944, events = 8, fd = 563713032, user_data = 0x8215042a8}, {pos = 726062008, events = 8, fd = 558908048, user_data = 0x36e2f5ac9465}, {pos = 563736632, events = 8, fd = 2671342, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 563713032, events = 8, fd = 726021456, user_data = 0x821504568}, {pos = 563713032, events = 8, fd = 558908488, user_data = 0x1e}, {pos = 726025440, events = 8, fd = 558908216, user_data = 0x82199e248}, {pos = 558908664, events = 8, fd = 558908192, user_data = 0x36e2f5acdda3}, {pos = 563736632, events = 8, fd = 2694724, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 563736632, user_data = 0x1}} [00:39:35.123] last_touch_time = 1711154194 [00:39:35.123] last_lockfile_recheck_time = 1711154194 [00:39:35.123] nevents = 1 [00:39:35.123] #54 0x0000000000846f66 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821504cd0) at ../src/backend/postmaster/postmaster.c:1372 [00:39:35.123] userDoption = [00:39:35.123] listen_addr_saved = false [00:39:35.123] output_config_variable = [00:39:35.123] opt = [00:39:35.123] status = [00:39:35.123] #55 0x0000000000783205 in main (argc=4, argv=0x821504cd0) at ../src/backend/main/main.c:197 [00:39:35.123] do_check_root = [00:39:35.132] [00:39:35.132] [00:39:35.132] [00:39:35.194] dumping /tmp/cores/postgres.10662.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:39:35.317] [New LWP 101803] [00:39:35.384] Core was generated by `postgres: postgres regression [local] SELECT'. [00:39:35.384] Program terminated with signal SIGABRT, Aborted. [00:39:35.384] Sent by thr_kill() from pid 10662 and user 1003. [00:39:35.384] #0 0x000000082b9dedca in thr_kill () from /lib/libc.so.7 [00:39:35.499] [00:39:35.499] Thread 1 (LWP 101803): [00:39:35.499] #0 0x000000082b9dedca in thr_kill () from /lib/libc.so.7 [00:39:35.499] No symbol table info available. [00:39:35.499] #1 0x000000082b9576f4 in raise () from /lib/libc.so.7 [00:39:35.499] No symbol table info available. [00:39:35.499] #2 0x000000082ba08bc9 in abort () from /lib/libc.so.7 [00:39:35.499] No symbol table info available. [00:39:35.499] #3 0x0000000000a42a57 in ExceptionalCondition (conditionName=, fileName=0x2db649 "../src/include/storage/bufmgr.h", lineNumber=lineNumber@entry=364) at ../src/backend/utils/error/assert.c:66 [00:39:35.499] No locals. [00:39:35.499] #4 0x00000000005c44c4 in heapam_scan_bitmap_next_tuple (scan=0x841bc5f70, slot=0x841aab6c8, recheck=0x835770d80, lossy_pages=0x835770d68, exact_pages=0x835770d60) at ../src/backend/access/heap/heapam_handler.c:2249 [00:39:35.499] targoffset = [00:39:35.499] page = [00:39:35.499] hscan = [00:39:35.499] lp = [00:39:35.499] #5 0x000000000073bf02 in table_scan_bitmap_next_tuple (scan=0x841bc5f70, slot=0x841aab6c8, recheck=0x835770d80, lossy_pages=0x82b9dedaa , exact_pages=0x0) at ../src/include/access/tableam.h:1987 [00:39:35.499] __error = [00:39:35.499] #6 BitmapHeapNext (node=node@entry=0x835770c70) at ../src/backend/executor/nodeBitmapHeapscan.c:197 [00:39:35.499] econtext = 0x8358ba8f0 [00:39:35.499] dsa = [00:39:35.499] slot = 0x841aab6c8 [00:39:35.499] scan = 0x841bc5f70 [00:39:35.499] tbm = [00:39:35.499] #7 0x000000000072b433 in ExecScanFetch (node=node@entry=0x835770c70, accessMtd=accessMtd@entry=0x73bc60 , recheckMtd=recheckMtd@entry=0x73c0d0 ) at ../src/backend/executor/execScan.c:131 [00:39:35.499] estate = [00:39:35.499] #8 0x000000000072b1f6 in ExecScan (node=0x835770c70, accessMtd=0x6, recheckMtd=0x73c0d0 ) at ../src/backend/executor/execScan.c:180 [00:39:35.499] qual = 0x0 [00:39:35.499] econtext = 0x8358ba8f0 [00:39:35.499] projInfo = 0x0 [00:39:35.499] #9 0x000000000073baf4 in ExecBitmapHeapScan (pstate=0x18dab) at ../src/backend/executor/nodeBitmapHeapscan.c:274 [00:39:35.499] node = 0x18dab [00:39:35.499] #10 0x000000000072885b in ExecProcNodeFirst (node=0x835770c70) at ../src/backend/executor/execProcnode.c:464 [00:39:35.499] No locals. [00:39:35.499] #11 0x0000000000757778 in ExecProcNode (node=0x835770c70) at ../src/include/executor/executor.h:274 [00:39:35.499] No locals. [00:39:35.499] #12 ExecNestLoop (pstate=0x83576f9b0) at ../src/backend/executor/nodeNestloop.c:159 [00:39:35.499] node = 0x83576f9b0 [00:39:35.499] nl = 0x84405fff0 [00:39:35.499] otherqual = 0x0 [00:39:35.499] joinqual = 0x0 [00:39:35.499] outerPlan = 0x83576fb50 [00:39:35.499] innerPlan = 0x835770c70 [00:39:35.499] econtext = 0x83576fac0 [00:39:35.499] innerTupleSlot = [00:39:35.499] outerTupleSlot = [00:39:35.499] lc = [00:39:35.499] #13 0x000000000072885b in ExecProcNodeFirst (node=0x83576f9b0) at ../src/backend/executor/execProcnode.c:464 [00:39:35.499] No locals. [00:39:35.499] #14 0x000000000075763d in ExecProcNode (node=0x83576f9b0) at ../src/include/executor/executor.h:274 [00:39:35.499] No locals. [00:39:35.499] #15 ExecNestLoop (pstate=0x83576f810) at ../src/backend/executor/nodeNestloop.c:108 [00:39:35.499] node = 0x83576f810 [00:39:35.499] nl = 0x84405fa98 [00:39:35.499] otherqual = 0x0 [00:39:35.499] joinqual = 0x841bc2aa0 [00:39:35.499] outerPlan = 0x83576f9b0 [00:39:35.499] innerPlan = 0x841aad838 [00:39:35.499] econtext = 0x83576f920 [00:39:35.499] innerTupleSlot = [00:39:35.499] outerTupleSlot = [00:39:35.499] lc = [00:39:35.499] #16 0x000000000072885b in ExecProcNodeFirst (node=0x83576f810) at ../src/backend/executor/execProcnode.c:464 [00:39:35.499] No locals. [00:39:35.499] #17 0x000000000075c6f2 in ExecProcNode (node=0x83576f810) at ../src/include/executor/executor.h:274 [00:39:35.499] No locals. [00:39:35.499] #18 SubqueryNext (node=node@entry=0x83576f620) at ../src/backend/executor/nodeSubqueryscan.c:53 [00:39:35.499] slot = [00:39:35.499] #19 0x000000000072b433 in ExecScanFetch (node=node@entry=0x83576f620, accessMtd=accessMtd@entry=0x75c6d0 , recheckMtd=recheckMtd@entry=0x75c700 ) at ../src/backend/executor/execScan.c:131 [00:39:35.499] estate = [00:39:35.499] #20 0x000000000072b248 in ExecScan (node=0x83576f620, accessMtd=0x6, recheckMtd=0x75c700 ) at ../src/backend/executor/execScan.c:197 [00:39:35.499] slot = [00:39:35.499] qual = 0x0 [00:39:35.499] econtext = 0x83576f730 [00:39:35.499] projInfo = 0x841bc3040 [00:39:35.499] #21 0x000000000075c654 in ExecSubqueryScan (pstate=0x18dab) at ../src/backend/executor/nodeSubqueryscan.c:87 [00:39:35.499] node = 0x18dab [00:39:35.499] #22 0x000000000072885b in ExecProcNodeFirst (node=0x83576f620) at ../src/backend/executor/execProcnode.c:464 [00:39:35.499] No locals. [00:39:35.499] #23 0x000000000075a079 in ExecProcNode (node=0x83576f620) at ../src/include/executor/executor.h:274 [00:39:35.499] No locals. [00:39:35.499] #24 ExecSort (pstate=0x83576f410) at ../src/backend/executor/nodeSort.c:149 [00:39:35.499] plannode = [00:39:35.499] tuplesortopts = [00:39:35.499] outerNode = 0x83576f620 [00:39:35.499] tupDesc = [00:39:35.499] node = 0x83576f410 [00:39:35.499] estate = 0x83576f100 [00:39:35.499] tuplesortstate = 0x841ca9100 [00:39:35.499] dir = ForwardScanDirection [00:39:35.499] slot = [00:39:35.499] #25 0x000000000072885b in ExecProcNodeFirst (node=0x83576f410) at ../src/backend/executor/execProcnode.c:464 [00:39:35.499] No locals. [00:39:35.499] #26 0x0000000000720c0a in ExecProcNode (node=0x83576f410) at ../src/include/executor/executor.h:274 [00:39:35.499] No locals. [00:39:35.499] #27 ExecutePlan (estate=0x83576f100, planstate=0x83576f410, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x84406d168, execute_once=false) at ../src/backend/executor/execMain.c:1644 [00:39:35.499] current_tuple_count = [00:39:35.499] slot = [00:39:35.499] #28 standard_ExecutorRun (queryDesc=0x8358f9d00, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [00:39:35.499] estate = 0x83576f100 [00:39:35.499] oldcontext = 0x8358f9c00 [00:39:35.499] operation = CMD_SELECT [00:39:35.499] dest = 0x84406d168 [00:39:35.499] sendTuples = true [00:39:35.499] #29 0x0000000000720abf in ExecutorRun (queryDesc=0x18dab, queryDesc@entry=0x8358f9d00, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [00:39:35.499] No locals. [00:39:35.499] #30 0x00000000008f1be7 in PortalRunSelect (portal=portal@entry=0x835839210, forward=, count=0, count@entry=9223372036854775807, dest=dest@entry=0x84406d168) at ../src/backend/tcop/pquery.c:924 [00:39:35.499] queryDesc = 0x8358f9d00 [00:39:35.499] direction = ForwardScanDirection [00:39:35.499] nprocessed = [00:39:35.499] #31 0x00000000008f1760 in PortalRun (portal=portal@entry=0x835839210, count=0, count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82b9dedaa , dest@entry=0x84406d168, altdest=altdest@entry=0x84406d168, qc=0x8216c4eb0) at ../src/backend/tcop/pquery.c:768 [00:39:35.499] _local_sigjmp_buf = {{_sjb = {9377455, 35257624728, 34920484264, 34920484496, 34920484272, 12034536, 12002320, 35257553424, 7112098687, 35257561344, 3563986, 34359738368}}} [00:39:35.499] _save_exception_stack = 0x8216c4f80 [00:39:35.499] _save_context_stack = 0x0 [00:39:35.499] _do_rethrow = false [00:39:35.499] saveTopTransactionResourceOwner = 0x83584a898 [00:39:35.499] saveTopTransactionContext = 0x835937000 [00:39:35.499] saveActivePortal = 0x0 [00:39:35.499] saveResourceOwner = 0x83584a898 [00:39:35.499] savePortalContext = 0x0 [00:39:35.499] saveMemoryContext = 0x835937000 [00:39:35.499] result = [00:39:35.499] nprocessed = [00:39:35.499] #32 0x00000000008f061b in exec_simple_query (query_string=query_string@entry=0x835763100 "SELECT attname, most_common_vals FROM pg_stats\n WHERE tablename = 'current_check'\n ORDER BY 1;") at ../src/backend/tcop/postgres.c:1274 [00:39:35.499] cmdtaglen = [00:39:35.499] snapshot_set = [00:39:35.499] per_parsetree_context = 0x0 [00:39:35.499] plantree_list = [00:39:35.499] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:39:35.499] parsetree = 0x835764e40 [00:39:35.499] commandTag = CMDTAG_SELECT [00:39:35.499] cmdtagname = [00:39:35.499] querytree_list = [00:39:35.499] portal = 0x835839210 [00:39:35.499] format = 0 [00:39:35.499] receiver = 0x84406d168 [00:39:35.499] parsetree_item__state = {l = 0x8358015e0, i = 0} [00:39:35.499] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [00:39:35.499] dest = DestRemote [00:39:35.499] was_logged = [00:39:35.499] oldcontext = 0x835937000 [00:39:35.499] parsetree_list = 0x8358015e0 [00:39:35.499] use_implicit_block = false [00:39:35.499] parsetree_item = 0x8358015f8 [00:39:35.499] save_log_statement_stats = [00:39:35.499] #33 0x00000000008ee404 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [00:39:35.499] query_string = 0x835763100 "SELECT attname, most_common_vals FROM pg_stats\n WHERE tablename = 'current_check'\n ORDER BY 1;" [00:39:35.499] input_message = {data = 0x835763100 "SELECT attname, most_common_vals FROM pg_stats\n WHERE tablename = 'current_check'\n ORDER BY 1;", len = 97, maxlen = 1024, cursor = 97} [00:39:35.499] firstchar = [00:39:35.499] local_sigjmp_buf = {{_sjb = {9361616, 34920484736, 34920484696, 34920485296, 12043272, 11989744, 8192, 8388608, 72057628958393215, 0, 0, 34359738369}}} [00:39:35.499] send_ready_for_query = false [00:39:35.499] idle_in_transaction_timeout_enabled = false [00:39:35.499] idle_session_timeout_enabled = false [00:39:35.499] #34 0x00000000008e9169 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [00:39:35.499] bsdata = [00:39:35.499] #35 0x0000000000844e72 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8216c5cc0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8216c5c08) at ../src/backend/postmaster/launch_backend.c:265 [00:39:35.499] pid = [00:39:35.499] #36 0x0000000000849691 in BackendStartup (client_sock=0x8216c5c08) at ../src/backend/postmaster/postmaster.c:3593 [00:39:35.499] startup_data = {canAcceptConnections = CAC_OK} [00:39:35.499] bn = 0x83576f5d8 [00:39:35.499] pid = [00:39:35.499] __error = [00:39:35.499] __error = [00:39:35.499] save_errno = [00:39:35.499] __error = [00:39:35.499] __error = [00:39:35.499] #37 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [00:39:35.499] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "`\\l!\b\000\000\000\330\305\r+\b\000\000\000\v\000\000\000\000\000\000\000\016F\016+\b", '\000' , "\240\\l!\b\000\000\000DL\204\000\000\000\000\000\260\\l!\b", '\000' }, salen = 16}} [00:39:35.499] i = 0 [00:39:35.499] now = [00:39:35.499] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 730627172, events = 8, fd = 560747088, user_data = 0x8216c53e0}, {pos = 567780360, events = 8, fd = 32, user_data = 0x8216c53d0}, {pos = 1139395220, events = 1542, fd = 567750664, user_data = 0x821d73408}, {pos = 567752712, events = 8, fd = 567753736, user_data = 0x821d77008}, {pos = 567768072, events = 8, fd = 567769096, user_data = 0x821d77c08}, {pos = 567771144, events = 8, fd = 567772168, user_data = 0x821d78808}, {pos = 567774216, events = 8, fd = 567775240, user_data = 0x821d79408}, {pos = 567777288, events = 8, fd = 567778312, user_data = 0x821d7a008}, {pos = 567780360, events = 8, fd = -1, user_data = 0x82ba9f2e0}, {pos = 560747328, events = 8, fd = 732217769, user_data = 0x0}, {pos = 4096, events = 0, fd = -1716381966, user_data = 0x82ba9f7e8}, {pos = 880843744, events = 8, fd = 160, user_data = 0x0}, {pos = 859386000, events = 8, fd = 560747536, user_data = 0x82ba2a92c}, {pos = 4096, events = 0, fd = 730642788, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 567806520, user_data = 0x800000001}, {pos = 567780360, events = 8, fd = 730556632, user_data = 0x8216c5498}, {pos = 560747088, events = 8, fd = 32, user_data = 0x82b8c7c64}, {pos = 567780360, events = 8, fd = 567806520, user_data = 0x0}, {pos = 2625, events = 0, fd = 560747648, user_data = 0x60643e9c645}, {pos = 730642788, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 567806520, events = 8, fd = 1, user_data = 0x821d7a408}, {pos = 896872448, events = 8, fd = 1, user_data = 0x835753194}, {pos = 0, events = 0, fd = 560747600, user_data = 0x82b0e3c0c}, {pos = 1, events = 0, fd = 896872448, user_data = 0x8216c5480}, {pos = 722349748, events = 8, fd = 732369248, user_data = 0x82ba71160 }, {pos = 730738880, events = 8, fd = 567780360, user_data = 0x8216c5560}, {pos = 1139393580, events = 1542, fd = 859386000, user_data = 0x800000001}, {pos = 1139393198, events = 1542, fd = 12240, user_data = 0x8216c5488}, {pos = 560747872, events = 8, fd = 897578984, user_data = 0x8216c5ad0}, {pos = 1139474064, events = 1542, fd = 567780360, user_data = 0x8216c037f}, {pos = 732026268, events = 8, fd = 567750664, user_data = 0x0}, {pos = 567780360, events = 8, fd = 12240, user_data = 0x82b8a7000}, {pos = 1964368, events = 0, fd = 732369248, user_data = 0x82b8c7c64}, {pos = 15616, events = 0, fd = 560749056, user_data = 0x8216c55d0}, {pos = 731300238, events = 8, fd = 732407864, user_data = 0x8216c5594}, {pos = 897316314, events = 8, fd = 560749056, user_data = 0x8216c55d0}, {pos = 731391493, events = 8, fd = 560747922, user_data = 0x8216c5a00}, {pos = 560749056, events = 8, fd = 0, user_data = 0x8be2a3499b216f2}, {pos = 560749056, events = 8, fd = 897316312, user_data = 0x8216c5ad0}, {pos = 732407864, events = 8, fd = 0, user_data = 0x8216c5a40}, {pos = 731391757, events = 8, fd = 0, user_data = 0x0}, {pos = 560749424, events = 8, fd = 897316312, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1139422217, events = 1542, fd = 560748328, user_data = 0x82b8c7c64}, {pos = 2503, events = 0, fd = 1139422217, user_data = 0x8216c5748}, {pos = 730627172, events = 8, fd = 2758, user_data = 0x82b8c1120}, {pos = 560748232, events = 8, fd = 567780360, user_data = 0x8216c5748}, {pos = 730599712, events = 8, fd = 560748336, user_data = 0x60643e9e465}, {pos = 0, events = 0, fd = 0, user_data = 0x82ba930f0}, {pos = 730559824, events = 8, fd = 0, user_data = 0x0}, {pos = 732436912, events = 8, fd = 1139422217, user_data = 0x8216c57d8}, {pos = 730627172, events = 8, fd = 2924, user_data = 0x82b8c13b8}, {pos = 560748376, events = 8, fd = 567780360, user_data = 0x8216c57d8}, {pos = 730600376, events = 8, fd = 560748480, user_data = 0x60643e9e465}, {pos = 567803960, events = 8, fd = 2671342, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 567780360, events = 8, fd = 730559824, user_data = 0x8216c5a98}, {pos = 567780360, events = 8, fd = 560748920, user_data = 0x1e}, {pos = 730563808, events = 8, fd = 560748648, user_data = 0x821d7f248}, {pos = 560749096, events = 8, fd = 560748624, user_data = 0x60643ea2da3}, {pos = 567803960, events = 8, fd = 2694724, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 567803960, user_data = 0x1}} [00:39:35.499] last_touch_time = 1711154192 [00:39:35.499] last_lockfile_recheck_time = 1711154192 [00:39:35.499] nevents = 1 [00:39:35.499] #38 0x0000000000846f66 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8216c6208) at ../src/backend/postmaster/postmaster.c:1372 [00:39:35.499] userDoption = [00:39:35.499] listen_addr_saved = false [00:39:35.499] output_config_variable = [00:39:35.499] opt = [00:39:35.499] status = [00:39:35.499] #39 0x0000000000783205 in main (argc=8, argv=0x8216c6208) at ../src/backend/main/main.c:197 [00:39:35.499] do_check_root = [00:39:35.508] [00:39:35.508] [00:39:35.508] [00:39:35.565] dumping /tmp/cores/postgres.11840.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:39:35.688] [New LWP 101771] [00:39:35.752] Core was generated by `postgres: postgres regression [local] SELECT'. [00:39:35.752] Program terminated with signal SIGABRT, Aborted. [00:39:35.752] Sent by thr_kill() from pid 11840 and user 1003. [00:39:35.752] #0 0x000000082b9dedca in thr_kill () from /lib/libc.so.7 [00:39:35.865] [00:39:35.865] Thread 1 (LWP 101771): [00:39:35.865] #0 0x000000082b9dedca in thr_kill () from /lib/libc.so.7 [00:39:35.865] No symbol table info available. [00:39:35.865] #1 0x000000082b9576f4 in raise () from /lib/libc.so.7 [00:39:35.865] No symbol table info available. [00:39:35.865] #2 0x000000082ba08bc9 in abort () from /lib/libc.so.7 [00:39:35.865] No symbol table info available. [00:39:35.865] #3 0x0000000000a42a57 in ExceptionalCondition (conditionName=, fileName=0x2db649 "../src/include/storage/bufmgr.h", lineNumber=lineNumber@entry=364) at ../src/backend/utils/error/assert.c:66 [00:39:35.865] No locals. [00:39:35.865] #4 0x00000000005c44c4 in heapam_scan_bitmap_next_tuple (scan=0x843c83678, slot=0x83591ded0, recheck=0x83591d870, lossy_pages=0x83591d858, exact_pages=0x83591d850) at ../src/backend/access/heap/heapam_handler.c:2249 [00:39:35.865] targoffset = [00:39:35.865] page = [00:39:35.865] hscan = [00:39:35.865] lp = [00:39:35.865] #5 0x000000000073bf02 in table_scan_bitmap_next_tuple (scan=0x843c83678, slot=0x83591ded0, recheck=0x83591d870, lossy_pages=0x82b9dedaa , exact_pages=0x0) at ../src/include/access/tableam.h:1987 [00:39:35.865] __error = [00:39:35.865] #6 BitmapHeapNext (node=node@entry=0x83591d760) at ../src/backend/executor/nodeBitmapHeapscan.c:197 [00:39:35.865] econtext = 0x83591d970 [00:39:35.865] dsa = [00:39:35.865] slot = 0x83591ded0 [00:39:35.865] scan = 0x843c83678 [00:39:35.865] tbm = [00:39:35.865] #7 0x000000000072b433 in ExecScanFetch (node=node@entry=0x83591d760, accessMtd=accessMtd@entry=0x73bc60 , recheckMtd=recheckMtd@entry=0x73c0d0 ) at ../src/backend/executor/execScan.c:131 [00:39:35.865] estate = [00:39:35.865] #8 0x000000000072b1f6 in ExecScan (node=0x83591d760, accessMtd=0x6, recheckMtd=0x73c0d0 ) at ../src/backend/executor/execScan.c:180 [00:39:35.865] qual = 0x0 [00:39:35.865] econtext = 0x83591d970 [00:39:35.865] projInfo = 0x0 [00:39:35.865] #9 0x000000000073baf4 in ExecBitmapHeapScan (pstate=0x18d8b) at ../src/backend/executor/nodeBitmapHeapscan.c:274 [00:39:35.865] node = 0x18d8b [00:39:35.865] #10 0x000000000072885b in ExecProcNodeFirst (node=0x83591d760) at ../src/backend/executor/execProcnode.c:464 [00:39:35.865] No locals. [00:39:35.865] #11 0x000000000075763d in ExecProcNode (node=0x83591d760) at ../src/include/executor/executor.h:274 [00:39:35.865] No locals. [00:39:35.865] #12 ExecNestLoop (pstate=0x83591d570) at ../src/backend/executor/nodeNestloop.c:108 [00:39:35.865] node = 0x83591d570 [00:39:35.865] nl = 0x84178e520 [00:39:35.865] otherqual = 0x0 [00:39:35.865] joinqual = 0x835918ed8 [00:39:35.865] outerPlan = 0x83591d760 [00:39:35.865] innerPlan = 0x83591dfe0 [00:39:35.865] econtext = 0x83591d680 [00:39:35.865] innerTupleSlot = [00:39:35.865] outerTupleSlot = [00:39:35.865] lc = [00:39:35.865] #13 0x000000000072885b in ExecProcNodeFirst (node=0x83591d570) at ../src/backend/executor/execProcnode.c:464 [00:39:35.865] No locals. [00:39:35.865] #14 0x000000000075a079 in ExecProcNode (node=0x83591d570) at ../src/include/executor/executor.h:274 [00:39:35.865] No locals. [00:39:35.865] #15 ExecSort (pstate=0x83591d360) at ../src/backend/executor/nodeSort.c:149 [00:39:35.865] plannode = [00:39:35.865] tuplesortopts = [00:39:35.865] outerNode = 0x83591d570 [00:39:35.865] tupDesc = [00:39:35.865] node = 0x83591d360 [00:39:35.865] estate = 0x83591d100 [00:39:35.865] tuplesortstate = 0x841772100 [00:39:35.865] dir = ForwardScanDirection [00:39:35.865] slot = [00:39:35.865] #16 0x000000000072885b in ExecProcNodeFirst (node=0x83591d360) at ../src/backend/executor/execProcnode.c:464 [00:39:35.865] No locals. [00:39:35.865] #17 0x0000000000720c0a in ExecProcNode (node=0x83591d360) at ../src/include/executor/executor.h:274 [00:39:35.865] No locals. [00:39:35.865] #18 ExecutePlan (estate=0x83591d100, planstate=0x83591d360, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x841792e50, execute_once=false) at ../src/backend/executor/execMain.c:1644 [00:39:35.865] current_tuple_count = [00:39:35.865] slot = [00:39:35.865] #19 standard_ExecutorRun (queryDesc=0x835771500, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [00:39:35.865] estate = 0x83591d100 [00:39:35.865] oldcontext = 0x835771400 [00:39:35.865] operation = CMD_SELECT [00:39:35.865] dest = 0x841792e50 [00:39:35.865] sendTuples = true [00:39:35.865] #20 0x0000000000720abf in ExecutorRun (queryDesc=0x18d8b, queryDesc@entry=0x835771500, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [00:39:35.865] No locals. [00:39:35.865] #21 0x00000000008f1be7 in PortalRunSelect (portal=portal@entry=0x835839100, forward=, count=0, count@entry=9223372036854775807, dest=dest@entry=0x841792e50) at ../src/backend/tcop/pquery.c:924 [00:39:35.865] queryDesc = 0x835771500 [00:39:35.865] direction = ForwardScanDirection [00:39:35.865] nprocessed = [00:39:35.865] #22 0x00000000008f1760 in PortalRun (portal=portal@entry=0x835839100, count=0, count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82b9dedaa , dest@entry=0x841792e50, altdest=altdest@entry=0x841792e50, qc=0x8216c4eb0) at ../src/backend/tcop/pquery.c:768 [00:39:35.865] _local_sigjmp_buf = {{_sjb = {9377455, 35257615104, 34920484264, 34920484496, 34920484272, 12034536, 12002320, 35257553152, 7112098687, 35257561344, 3563986, 34359738368}}} [00:39:35.865] _save_exception_stack = 0x8216c4f80 [00:39:35.865] _save_context_stack = 0x0 [00:39:35.865] _do_rethrow = false [00:39:35.865] saveTopTransactionResourceOwner = 0x835848300 [00:39:35.865] saveTopTransactionContext = 0x83576f000 [00:39:35.865] saveActivePortal = 0x0 [00:39:35.865] saveResourceOwner = 0x835848300 [00:39:35.865] savePortalContext = 0x0 [00:39:35.865] saveMemoryContext = 0x83576f000 [00:39:35.865] result = [00:39:35.865] nprocessed = [00:39:35.865] #23 0x00000000008f061b in exec_simple_query (query_string=query_string@entry=0x835763100 "select unique1, unique2 from tenk1\nwhere (unique1, unique2) < any (select ten, ten from tenk1 where hundred < 3)\n and unique1 <= 20\norder by 1;") at ../src/backend/tcop/postgres.c:1274 [00:39:35.865] cmdtaglen = [00:39:35.865] snapshot_set = [00:39:35.865] per_parsetree_context = 0x0 [00:39:35.865] plantree_list = [00:39:35.865] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:39:35.865] parsetree = 0x83582d908 [00:39:35.865] commandTag = CMDTAG_SELECT [00:39:35.865] cmdtagname = [00:39:35.865] querytree_list = [00:39:35.865] portal = 0x835839100 [00:39:35.865] format = 0 [00:39:35.865] receiver = 0x841792e50 [00:39:35.865] parsetree_item__state = {l = 0x84177cc78, i = 0} [00:39:35.865] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [00:39:35.865] dest = DestRemote [00:39:35.865] was_logged = [00:39:35.865] oldcontext = 0x83576f000 [00:39:35.865] parsetree_list = 0x84177cc78 [00:39:35.865] use_implicit_block = false [00:39:35.865] parsetree_item = 0x84177cc90 [00:39:35.865] save_log_statement_stats = [00:39:35.865] #24 0x00000000008ee404 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [00:39:35.865] query_string = 0x835763100 "select unique1, unique2 from tenk1\nwhere (unique1, unique2) < any (select ten, ten from tenk1 where hundred < 3)\n and unique1 <= 20\norder by 1;" [00:39:35.865] input_message = {data = 0x835763100 "select unique1, unique2 from tenk1\nwhere (unique1, unique2) < any (select ten, ten from tenk1 where hundred < 3)\n and unique1 <= 20\norder by 1;", len = 149, maxlen = 1024, cursor = 149} [00:39:35.865] firstchar = [00:39:35.865] local_sigjmp_buf = {{_sjb = {9361616, 34920484736, 34920484696, 34920485296, 12043272, 11989744, 8192, 8388608, 72057628958393215, 0, 0, 34359738369}}} [00:39:35.865] send_ready_for_query = false [00:39:35.865] idle_in_transaction_timeout_enabled = false [00:39:35.865] idle_session_timeout_enabled = false [00:39:35.865] #25 0x00000000008e9169 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [00:39:35.865] bsdata = [00:39:35.865] #26 0x0000000000844e72 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8216c5cc0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8216c5c08) at ../src/backend/postmaster/launch_backend.c:265 [00:39:35.865] pid = [00:39:35.865] #27 0x0000000000849691 in BackendStartup (client_sock=0x8216c5c08) at ../src/backend/postmaster/postmaster.c:3593 [00:39:35.865] startup_data = {canAcceptConnections = CAC_OK} [00:39:35.865] bn = 0x83576f0d8 [00:39:35.865] pid = [00:39:35.865] __error = [00:39:35.865] __error = [00:39:35.865] save_errno = [00:39:35.865] __error = [00:39:35.865] __error = [00:39:35.865] #28 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [00:39:35.865] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "`\\l!\b\000\000\000\330\305\r+\b\000\000\000\v\000\000\000\000\000\000\000\016F\016+\b", '\000' , "\240\\l!\b\000\000\000DL\204\000\000\000\000\000\260\\l!\b", '\000' }, salen = 16}} [00:39:35.865] i = 0 [00:39:35.865] now = [00:39:35.865] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 560747088, user_data = 0x0}, {pos = 567780360, events = 8, fd = 32, user_data = 0x8216c53d0}, {pos = 1139395220, events = 1542, fd = 567750664, user_data = 0x821d73408}, {pos = 567752712, events = 8, fd = 567753736, user_data = 0x821d77008}, {pos = 567768072, events = 8, fd = 567769096, user_data = 0x821d77c08}, {pos = 567771144, events = 8, fd = 567772168, user_data = 0x821d78808}, {pos = 567774216, events = 8, fd = 567775240, user_data = 0x821d79408}, {pos = 567777288, events = 8, fd = 567778312, user_data = 0x821d7a008}, {pos = 567780360, events = 8, fd = -1, user_data = 0x82ba9f2e0}, {pos = 560747328, events = 8, fd = 732217769, user_data = 0x0}, {pos = 4096, events = 0, fd = -1716381966, user_data = 0x82ba9f7e8}, {pos = 880843744, events = 8, fd = 160, user_data = 0x0}, {pos = 859386000, events = 8, fd = 560747536, user_data = 0x82ba2a92c}, {pos = 4096, events = 0, fd = 730642788, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 567806520, user_data = 0x800000001}, {pos = 567780360, events = 8, fd = 730556632, user_data = 0x8216c5498}, {pos = 560747088, events = 8, fd = 32, user_data = 0x82b8c7c64}, {pos = 567780360, events = 8, fd = 567806520, user_data = 0x0}, {pos = 2625, events = 0, fd = 560747648, user_data = 0x60643e9c645}, {pos = 730642788, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 567806520, events = 8, fd = 1, user_data = 0x821d7a408}, {pos = 896872448, events = 8, fd = 1, user_data = 0x835753194}, {pos = 0, events = 0, fd = 560747600, user_data = 0x82b0e3c0c}, {pos = 1, events = 0, fd = 896872448, user_data = 0x8216c5480}, {pos = 722349748, events = 8, fd = 732369248, user_data = 0x82ba71160 }, {pos = 730738880, events = 8, fd = 567780360, user_data = 0x8216c5560}, {pos = 1139393580, events = 1542, fd = 859386000, user_data = 0x800000001}, {pos = 1139393198, events = 1542, fd = 12240, user_data = 0x8216c5488}, {pos = 560747872, events = 8, fd = 897578984, user_data = 0x8216c5ad0}, {pos = 1139474064, events = 1542, fd = 567780360, user_data = 0x8216c037f}, {pos = 732026268, events = 8, fd = 567750664, user_data = 0x0}, {pos = 567780360, events = 8, fd = 12240, user_data = 0x82b8a7000}, {pos = 1964368, events = 0, fd = 732369248, user_data = 0x82b8c7c64}, {pos = 15616, events = 0, fd = 560749056, user_data = 0x8216c55d0}, {pos = 731300238, events = 8, fd = 732407864, user_data = 0x8216c5594}, {pos = 897316314, events = 8, fd = 560749056, user_data = 0x8216c55d0}, {pos = 731391493, events = 8, fd = 560747922, user_data = 0x8216c5a00}, {pos = 560749056, events = 8, fd = 0, user_data = 0x8be2a3499b216f2}, {pos = 560749056, events = 8, fd = 897316312, user_data = 0x8216c5ad0}, {pos = 732407864, events = 8, fd = 0, user_data = 0x8216c5a40}, {pos = 731391757, events = 8, fd = 0, user_data = 0x0}, {pos = 560749424, events = 8, fd = 897316312, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1139422217, events = 1542, fd = 560748328, user_data = 0x82b8c7c64}, {pos = 2503, events = 0, fd = 1139422217, user_data = 0x8216c5748}, {pos = 730627172, events = 8, fd = 2758, user_data = 0x82b8c1120}, {pos = 560748232, events = 8, fd = 567780360, user_data = 0x8216c5748}, {pos = 730599712, events = 8, fd = 560748336, user_data = 0x60643e9e465}, {pos = 0, events = 0, fd = 0, user_data = 0x82ba930f0}, {pos = 730559824, events = 8, fd = 0, user_data = 0x0}, {pos = 732436912, events = 8, fd = 1139422217, user_data = 0x8216c57d8}, {pos = 730627172, events = 8, fd = 2924, user_data = 0x82b8c13b8}, {pos = 560748376, events = 8, fd = 567780360, user_data = 0x8216c57d8}, {pos = 730600376, events = 8, fd = 560748480, user_data = 0x60643e9e465}, {pos = 567803960, events = 8, fd = 2671342, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 567780360, events = 8, fd = 730559824, user_data = 0x8216c5a98}, {pos = 567780360, events = 8, fd = 560748920, user_data = 0x1e}, {pos = 730563808, events = 8, fd = 560748648, user_data = 0x821d7f248}, {pos = 560749096, events = 8, fd = 560748624, user_data = 0x60643ea2da3}, {pos = 567803960, events = 8, fd = 2694724, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 567803960, user_data = 0x1}} [00:39:35.865] last_touch_time = 1711154192 [00:39:35.865] last_lockfile_recheck_time = 1711154192 [00:39:35.865] nevents = 1 [00:39:35.865] #29 0x0000000000846f66 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8216c6208) at ../src/backend/postmaster/postmaster.c:1372 [00:39:35.865] userDoption = [00:39:35.865] listen_addr_saved = false [00:39:35.865] output_config_variable = [00:39:35.865] opt = [00:39:35.865] status = [00:39:35.865] #30 0x0000000000783205 in main (argc=8, argv=0x8216c6208) at ../src/backend/main/main.c:197 [00:39:35.865] do_check_root = [00:39:35.876] [00:39:35.876] [00:39:35.876] [00:39:35.931] dumping /tmp/cores/postgres.19675.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:39:36.059] [New LWP 100160] [00:39:36.124] Core was generated by `postgres: primary: postgres regression [local] SELECT'. [00:39:36.124] Program terminated with signal SIGABRT, Aborted. [00:39:36.124] Sent by thr_kill() from pid 19675 and user 1003. [00:39:36.124] #0 0x000000082a61ddca in thr_kill () from /lib/libc.so.7 [00:39:36.248] [00:39:36.248] Thread 1 (LWP 100160): [00:39:36.248] #0 0x000000082a61ddca in thr_kill () from /lib/libc.so.7 [00:39:36.248] No symbol table info available. [00:39:36.248] #1 0x000000082a5966f4 in raise () from /lib/libc.so.7 [00:39:36.248] No symbol table info available. [00:39:36.248] #2 0x000000082a647bc9 in abort () from /lib/libc.so.7 [00:39:36.248] No symbol table info available. [00:39:36.248] #3 0x0000000000a42a57 in ExceptionalCondition (conditionName=, fileName=0x2db649 "../src/include/storage/bufmgr.h", lineNumber=lineNumber@entry=364) at ../src/backend/utils/error/assert.c:66 [00:39:36.248] No locals. [00:39:36.248] #4 0x00000000005c44c4 in heapam_scan_bitmap_next_tuple (scan=0x83b29c940, slot=0x83b1aa588, recheck=0x83b1a9e58, lossy_pages=0x83b1a9e40, exact_pages=0x83b1a9e38) at ../src/backend/access/heap/heapam_handler.c:2249 [00:39:36.248] targoffset = [00:39:36.248] page = [00:39:36.248] hscan = [00:39:36.248] lp = [00:39:36.248] #5 0x000000000073bf02 in table_scan_bitmap_next_tuple (scan=0x83b29c940, slot=0x83b1aa588, recheck=0x83b1a9e58, lossy_pages=0x82a61ddaa , exact_pages=0x0) at ../src/include/access/tableam.h:1987 [00:39:36.248] __error = [00:39:36.248] #6 BitmapHeapNext (node=node@entry=0x83b1a9d48) at ../src/backend/executor/nodeBitmapHeapscan.c:197 [00:39:36.248] econtext = 0x83b1a9f58 [00:39:36.248] dsa = [00:39:36.248] slot = 0x83b1aa588 [00:39:36.248] scan = 0x83b29c940 [00:39:36.248] tbm = [00:39:36.248] #7 0x000000000072b433 in ExecScanFetch (node=node@entry=0x83b1a9d48, accessMtd=accessMtd@entry=0x73bc60 , recheckMtd=recheckMtd@entry=0x73c0d0 ) at ../src/backend/executor/execScan.c:131 [00:39:36.248] estate = [00:39:36.248] #8 0x000000000072b1f6 in ExecScan (node=0x83b1a9d48, accessMtd=0x6, recheckMtd=0x73c0d0 ) at ../src/backend/executor/execScan.c:180 [00:39:36.248] qual = 0x0 [00:39:36.248] econtext = 0x83b1a9f58 [00:39:36.248] projInfo = 0x0 [00:39:36.248] #9 0x000000000073baf4 in ExecBitmapHeapScan (pstate=0x18740) at ../src/backend/executor/nodeBitmapHeapscan.c:274 [00:39:36.248] node = 0x18740 [00:39:36.248] #10 0x000000000072885b in ExecProcNodeFirst (node=0x83b1a9d48) at ../src/backend/executor/execProcnode.c:464 [00:39:36.248] No locals. [00:39:36.248] #11 0x000000000075763d in ExecProcNode (node=0x83b1a9d48) at ../src/include/executor/executor.h:274 [00:39:36.248] No locals. [00:39:36.248] #12 ExecNestLoop (pstate=0x83b1a9ba8) at ../src/backend/executor/nodeNestloop.c:108 [00:39:36.248] node = 0x83b1a9ba8 [00:39:36.248] nl = 0x83cfb2bc8 [00:39:36.248] otherqual = 0x0 [00:39:36.248] joinqual = 0x0 [00:39:36.248] outerPlan = 0x83b1a9d48 [00:39:36.248] innerPlan = 0x83b1abce8 [00:39:36.248] econtext = 0x83b1a9cb8 [00:39:36.248] innerTupleSlot = [00:39:36.248] outerTupleSlot = [00:39:36.248] lc = [00:39:36.248] #13 0x000000000072885b in ExecProcNodeFirst (node=0x83b1a9ba8) at ../src/backend/executor/execProcnode.c:464 [00:39:36.248] No locals. [00:39:36.248] #14 0x000000000075763d in ExecProcNode (node=0x83b1a9ba8) at ../src/include/executor/executor.h:274 [00:39:36.248] No locals. [00:39:36.248] #15 ExecNestLoop (pstate=0x83b1a9a08) at ../src/backend/executor/nodeNestloop.c:108 [00:39:36.248] node = 0x83b1a9a08 [00:39:36.248] nl = 0x83cfb2a48 [00:39:36.248] otherqual = 0x0 [00:39:36.248] joinqual = 0x0 [00:39:36.248] outerPlan = 0x83b1a9ba8 [00:39:36.248] innerPlan = 0x83b1ad9c8 [00:39:36.248] econtext = 0x83b1a9b18 [00:39:36.248] innerTupleSlot = [00:39:36.248] outerTupleSlot = [00:39:36.248] lc = [00:39:36.248] #16 0x000000000072885b in ExecProcNodeFirst (node=0x83b1a9a08) at ../src/backend/executor/execProcnode.c:464 [00:39:36.248] No locals. [00:39:36.248] #17 0x00000000007587e5 in ExecProcNode (node=0x83b1a9a08) at ../src/include/executor/executor.h:274 [00:39:36.248] No locals. [00:39:36.248] #18 ExecResult (pstate=0x83b1435b0) at ../src/backend/executor/nodeResult.c:114 [00:39:36.248] node = 0x83b1435b0 [00:39:36.248] econtext = 0x83b1a9978 [00:39:36.248] outerPlan = 0x83b1a9a08 [00:39:36.248] outerTupleSlot = [00:39:36.248] #19 0x000000000072885b in ExecProcNodeFirst (node=0x83b1435b0) at ../src/backend/executor/execProcnode.c:464 [00:39:36.248] No locals. [00:39:36.248] #20 0x000000000075c6f2 in ExecProcNode (node=0x83b1435b0) at ../src/include/executor/executor.h:274 [00:39:36.248] No locals. [00:39:36.248] #21 SubqueryNext (node=node@entry=0x83b143410) at ../src/backend/executor/nodeSubqueryscan.c:53 [00:39:36.248] slot = [00:39:36.248] #22 0x000000000072b433 in ExecScanFetch (node=node@entry=0x83b143410, accessMtd=accessMtd@entry=0x75c6d0 , recheckMtd=recheckMtd@entry=0x75c700 ) at ../src/backend/executor/execScan.c:131 [00:39:36.248] estate = [00:39:36.248] #23 0x000000000072b248 in ExecScan (node=0x83b143410, accessMtd=0x6, recheckMtd=0x75c700 ) at ../src/backend/executor/execScan.c:197 [00:39:36.248] slot = [00:39:36.248] qual = 0x0 [00:39:36.248] econtext = 0x83b143520 [00:39:36.248] projInfo = 0x83b1b0a10 [00:39:36.248] #24 0x000000000075c654 in ExecSubqueryScan (pstate=0x18740) at ../src/backend/executor/nodeSubqueryscan.c:87 [00:39:36.248] node = 0x18740 [00:39:36.248] #25 0x000000000072885b in ExecProcNodeFirst (node=0x83b143410) at ../src/backend/executor/execProcnode.c:464 [00:39:36.248] No locals. [00:39:36.248] #26 0x000000000073a61d in ExecProcNode (node=0x83b143410) at ../src/include/executor/executor.h:274 [00:39:36.248] No locals. [00:39:36.248] #27 ExecAppend (pstate=0x83b142f10) at ../src/backend/executor/nodeAppend.c:351 [00:39:36.248] subnode = 0x83b143410 [00:39:36.248] node = 0x83b142f10 [00:39:36.248] result = [00:39:36.248] #28 0x000000000072885b in ExecProcNodeFirst (node=0x83b142f10) at ../src/backend/executor/execProcnode.c:464 [00:39:36.248] No locals. [00:39:36.248] #29 0x000000000073826d in ExecProcNode (node=0x83b142f10) at ../src/include/executor/executor.h:274 [00:39:36.248] No locals. [00:39:36.248] #30 fetch_input_tuple (aggstate=aggstate@entry=0x83b1428a8) at ../src/backend/executor/nodeAgg.c:561 [00:39:36.248] slot = [00:39:36.248] #31 0x0000000000735b64 in agg_fill_hash_table (aggstate=0x83b1428a8) at ../src/backend/executor/nodeAgg.c:2551 [00:39:36.248] tmpcontext = 0x83b142cd0 [00:39:36.248] outerslot = [00:39:36.248] #32 ExecAgg (pstate=0x83b1428a8) at ../src/backend/executor/nodeAgg.c:2172 [00:39:36.248] node = 0x83b1428a8 [00:39:36.248] result = 0x0 [00:39:36.248] #33 0x000000000072885b in ExecProcNodeFirst (node=0x83b1428a8) at ../src/backend/executor/execProcnode.c:464 [00:39:36.248] No locals. [00:39:36.248] #34 0x000000000075a079 in ExecProcNode (node=0x83b1428a8) at ../src/include/executor/executor.h:274 [00:39:36.248] No locals. [00:39:36.248] #35 ExecSort (pstate=0x83b142698) at ../src/backend/executor/nodeSort.c:149 [00:39:36.248] plannode = [00:39:36.248] tuplesortopts = [00:39:36.248] outerNode = 0x83b1428a8 [00:39:36.248] tupDesc = [00:39:36.248] node = 0x83b142698 [00:39:36.248] estate = 0x835d0b100 [00:39:36.248] tuplesortstate = 0x83b10e100 [00:39:36.248] dir = ForwardScanDirection [00:39:36.248] slot = [00:39:36.248] #36 0x000000000072885b in ExecProcNodeFirst (node=0x83b142698) at ../src/backend/executor/execProcnode.c:464 [00:39:36.248] No locals. [00:39:36.248] #37 0x0000000000720c0a in ExecProcNode (node=0x83b142698) at ../src/include/executor/executor.h:274 [00:39:36.248] No locals. [00:39:36.248] #38 ExecutePlan (estate=0x835d0b100, planstate=0x83b142698, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x83cfc3b68, execute_once=false) at ../src/backend/executor/execMain.c:1644 [00:39:36.248] current_tuple_count = [00:39:36.248] slot = [00:39:36.248] #39 standard_ExecutorRun (queryDesc=0x835b59900, direction=, count=count@entry=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [00:39:36.248] estate = 0x835d0b100 [00:39:36.248] oldcontext = 0x835b59800 [00:39:36.248] operation = CMD_SELECT [00:39:36.248] dest = 0x83cfc3b68 [00:39:36.248] sendTuples = true [00:39:36.248] #40 0x0000000837c33963 in pgss_ExecutorRun (queryDesc=0x835b59900, direction=ForwardScanDirection, count=0, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [00:39:36.248] _local_sigjmp_buf = {{_sjb = {35295279410, 12034536, 34915577912, 34915578080, 35260832000, 34915577920, 1, 1, 34915550079, 10953427, 34915578064, 0}}} [00:39:36.248] _save_exception_stack = 0x821217140 [00:39:36.248] _save_context_stack = 0x0 [00:39:36.248] _do_rethrow = false [00:39:36.248] #41 0x0000000000720ab8 in ExecutorRun (queryDesc=0x18740, queryDesc@entry=0x835b59900, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:302 [00:39:36.248] No locals. [00:39:36.248] #42 0x00000000008f1be7 in PortalRunSelect (portal=portal@entry=0x835be6100, forward=, count=0, count@entry=9223372036854775807, dest=dest@entry=0x83cfc3b68) at ../src/backend/tcop/pquery.c:924 [00:39:36.248] queryDesc = 0x835b59900 [00:39:36.248] direction = ForwardScanDirection [00:39:36.248] nprocessed = [00:39:36.248] #43 0x00000000008f1760 in PortalRun (portal=portal@entry=0x835be6100, count=0, count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82a61ddaa , dest@entry=0x83cfc3b68, altdest=altdest@entry=0x83cfc3b68, qc=0x821217240) at ../src/backend/tcop/pquery.c:768 [00:39:36.248] _local_sigjmp_buf = {{_sjb = {9377455, 35261743064, 34915578168, 34915578400, 34915578176, 12034536, 12002320, 35261407488, 7112098687, 35261415680, 3563986, 34359738368}}} [00:39:36.248] _save_exception_stack = 0x821217310 [00:39:36.248] _save_context_stack = 0x0 [00:39:36.248] _do_rethrow = false [00:39:36.248] saveTopTransactionResourceOwner = 0x835c37fd8 [00:39:36.248] saveTopTransactionContext = 0x835b57000 [00:39:36.248] saveActivePortal = 0x0 [00:39:36.248] saveResourceOwner = 0x835c37fd8 [00:39:36.248] savePortalContext = 0x0 [00:39:36.248] saveMemoryContext = 0x835b57000 [00:39:36.248] result = [00:39:36.248] nprocessed = [00:39:36.248] #44 0x00000000008f061b in exec_simple_query (query_string=query_string@entry=0x835b4b100 "SELECT pubname\n , NULL\n , NULL\nFROM pg_catalog.pg_publication p\n JOIN pg_catalog.pg_publication_namespace pn ON p.oid = pn.pnpubid\n JOIN pg_catalog.pg_class pc ON pc.relnamespace = pn."...) at ../src/backend/tcop/postgres.c:1274 [00:39:36.248] cmdtaglen = [00:39:36.248] snapshot_set = [00:39:36.248] per_parsetree_context = 0x0 [00:39:36.248] plantree_list = [00:39:36.248] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:39:36.248] parsetree = 0x83b1a5780 [00:39:36.248] commandTag = CMDTAG_SELECT [00:39:36.248] cmdtagname = [00:39:36.248] querytree_list = [00:39:36.248] portal = 0x835be6100 [00:39:36.248] format = 0 [00:39:36.248] receiver = 0x83cfc3b68 [00:39:36.248] parsetree_item__state = {l = 0x83b200d80, i = 0} [00:39:36.248] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [00:39:36.248] dest = DestRemote [00:39:36.248] was_logged = [00:39:36.248] oldcontext = 0x835b57000 [00:39:36.248] parsetree_list = 0x83b200d80 [00:39:36.248] use_implicit_block = false [00:39:36.248] parsetree_item = 0x83b200d98 [00:39:36.248] save_log_statement_stats = [00:39:36.248] #45 0x00000000008ee404 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [00:39:36.248] query_string = 0x835b4b100 "SELECT pubname\n , NULL\n , NULL\nFROM pg_catalog.pg_publication p\n JOIN pg_catalog.pg_publication_namespace pn ON p.oid = pn.pnpubid\n JOIN pg_catalog.pg_class pc ON pc.relnamespace = pn."... [00:39:36.248] input_message = {data = 0x835b4b100 "SELECT pubname\n , NULL\n , NULL\nFROM pg_catalog.pg_publication p\n JOIN pg_catalog.pg_publication_namespace pn ON p.oid = pn.pnpubid\n JOIN pg_catalog.pg_class pc ON pc.relnamespace = pn."..., len = 1002, maxlen = 1024, cursor = 1002} [00:39:36.248] firstchar = [00:39:36.248] local_sigjmp_buf = {{_sjb = {9361616, 34915578640, 34915578600, 34915579200, 12043272, 11989744, 8192, 8388608, 72057628953478015, 0, 0, 1}}} [00:39:36.248] send_ready_for_query = false [00:39:36.248] idle_in_transaction_timeout_enabled = false [00:39:36.248] idle_session_timeout_enabled = false [00:39:36.248] #46 0x00000000008e9169 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [00:39:36.248] bsdata = [00:39:36.248] #47 0x0000000000844e72 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821218050 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821217f98) at ../src/backend/postmaster/launch_backend.c:265 [00:39:36.248] pid = [00:39:36.248] #48 0x0000000000849691 in BackendStartup (client_sock=0x821217f98) at ../src/backend/postmaster/postmaster.c:3593 [00:39:36.248] startup_data = {canAcceptConnections = CAC_OK} [00:39:36.248] bn = 0x835b573f8 [00:39:36.248] pid = [00:39:36.248] __error = [00:39:36.248] __error = [00:39:36.248] save_errno = [00:39:36.248] __error = [00:39:36.248] __error = [00:39:36.248] #49 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [00:39:36.248] 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 = '\000' , "\360\177!!\b\000\000\000\330U\022(\b\000\000\000\v\000\000\000\000\000\000\000\016\326\022(\b", '\000' , "0\200!!\b\000\000\000DL\204\000\000\000\000\000@\200!!\b", '\000' }, salen = 16}} [00:39:36.248] i = 0 [00:39:36.248] now = [00:39:36.248] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 555841392, events = 8, fd = 569816072, user_data = 0x21}, {pos = 555841376, events = 8, fd = -1679930732, user_data = 0x821f64008}, {pos = 569787400, events = 8, fd = 569788424, user_data = 0x821f64c08}, {pos = 569802760, events = 8, fd = 569803784, user_data = 0x821f68808}, {pos = 569805832, events = 8, fd = 569806856, user_data = 0x821f69408}, {pos = 569808904, events = 8, fd = 569809928, user_data = 0x821f6a008}, {pos = 569811976, events = 8, fd = 569813000, user_data = 0x821f6ac08}, {pos = 569815048, events = 8, fd = 569816072, user_data = 0x821f70088}, {pos = 555841768, events = 8, fd = 555841280, user_data = 0x7e69bdeada3}, {pos = 569816072, events = 8, fd = 2568150, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 569839672, user_data = 0x1}, {pos = 569816072, events = 8, fd = 709821608, user_data = 0x8212179e8}, {pos = 569816072, events = 8, fd = 555841248, user_data = 0x272f20}, {pos = 555841840, events = 8, fd = 709929316, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 569842232, user_data = 0x7e600000001}, {pos = 569816072, events = 8, fd = 709843160, user_data = 0x821217828}, {pos = 555840976, events = 8, fd = 33, user_data = 0x82a506c64}, {pos = 569816072, events = 8, fd = 569842232, user_data = 0x0}, {pos = 2625, events = 0, fd = 555841552, user_data = 0x7e69bde4645}, {pos = 709929316, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 569842232, events = 8, fd = 1, user_data = 0x821f6b408}, {pos = 900968448, events = 8, fd = 1, user_data = 0x835b3b194}, {pos = 0, events = 0, fd = 555841504, user_data = 0x82812cc0c}, {pos = 1, events = 0, fd = 900968448, user_data = 0x821217810}, {pos = 672317108, events = 8, fd = 711655776, user_data = 0x82a6b0160 }, {pos = 710025408, events = 8, fd = 569816072, user_data = 0x8212178f0}, {pos = -1679932372, events = 2022, fd = 80627796, user_data = 0x1}, {pos = -1679932754, events = 2022, fd = 12240, user_data = 0x821217818}, {pos = 555841776, events = 8, fd = 901765096, user_data = 0x821217e60}, {pos = -1679851888, events = 2022, fd = 569816072, user_data = 0x82121037f}, {pos = 711312562, events = 8, fd = 555842080, user_data = 0x7e600000000}, {pos = 569816072, events = 8, fd = 12240, user_data = 0x82a4e6000}, {pos = 1964368, events = 0, fd = 711655776, user_data = 0x82a506c64}, {pos = 15616, events = 0, fd = 555842960, user_data = 0x821217960}, {pos = 710586766, events = 8, fd = 711694392, user_data = 0x821217924}, {pos = 901420506, events = 8, fd = 555842960, user_data = 0x821217960}, {pos = 710678021, events = 8, fd = 555841826, user_data = 0x821217d90}, {pos = 555842960, events = 8, fd = 0, user_data = 0xc8ce7cb848b6cf02}, {pos = 555842960, events = 8, fd = 901420504, user_data = 0x821217e60}, {pos = 711694392, events = 8, fd = 0, user_data = 0x821217dd0}, {pos = 710678285, events = 8, fd = 0, user_data = 0x0}, {pos = 555843328, events = 8, fd = 901420504, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1679903735, user_data = 0x821217aa8}, {pos = 709913700, events = 8, fd = 2503, user_data = 0x7e69bdeb409}, {pos = 555842248, events = 8, fd = 709913700, user_data = 0xac6}, {pos = 709886240, events = 8, fd = 555842120, user_data = 0x821f6b408}, {pos = 555842248, events = 8, fd = 709886240, user_data = 0x821217ab0}, {pos = -1679924123, events = 2022, fd = 0, user_data = 0x800000000}, {pos = 555842208, events = 8, fd = 709846352, user_data = 0x0}, {pos = 0, events = 0, fd = 555842176, user_data = 0x7e69bdeb409}, {pos = 555842392, events = 8, fd = 709913700, user_data = 0xb6c}, {pos = 709886904, events = 8, fd = 555842264, user_data = 0x821f6b408}, {pos = 555842392, events = 8, fd = 709886904, user_data = 0x821217b40}, {pos = -1679924123, events = 2022, fd = 569839672, user_data = 0x28c2ee}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 569816072, user_data = 0x82a4f6550}, {pos = 555843112, events = 8, fd = 569816072, user_data = 0x21217d08}, {pos = 31, events = 0, fd = 0, user_data = 0x821217be8}, {pos = 569837448, events = 8, fd = 555843000, user_data = 0x821217bd0}, {pos = -1679905373, events = 2022, fd = 569839672, user_data = 0x291e44}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821f71038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [00:39:36.249] last_touch_time = 1711154214 [00:39:36.249] last_lockfile_recheck_time = 1711154214 [00:39:36.249] nevents = 1 [00:39:36.249] #50 0x0000000000846f66 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821218590) at ../src/backend/postmaster/postmaster.c:1372 [00:39:36.249] userDoption = [00:39:36.249] listen_addr_saved = false [00:39:36.249] output_config_variable = [00:39:36.249] opt = [00:39:36.249] status = [00:39:36.249] #51 0x0000000000783205 in main (argc=4, argv=0x821218590) at ../src/backend/main/main.c:197 [00:39:36.249] do_check_root =