[16:28:09.969] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [16:28:10.488] dumping /tmp/cores/postgres.41491.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [16:28:12.980] [New LWP 101783] [16:28:13.144] Core was generated by `postgres: postgres regression [local] SELECT'. [16:28:13.144] Program terminated with signal SIGABRT, Aborted. [16:28:13.144] Sent by thr_kill() from pid 41491 and user 1003. [16:28:13.144] #0 0x000000082905adca in thr_kill () from /lib/libc.so.7 [16:28:13.420] [16:28:13.420] Thread 1 (LWP 101783): [16:28:13.420] #0 0x000000082905adca in thr_kill () from /lib/libc.so.7 [16:28:13.420] No symbol table info available. [16:28:13.420] #1 0x0000000828fd36f4 in raise () from /lib/libc.so.7 [16:28:13.420] No symbol table info available. [16:28:13.420] #2 0x0000000829084bc9 in abort () from /lib/libc.so.7 [16:28:13.420] No symbol table info available. [16:28:13.420] #3 0x0000000000a49ec7 in ExceptionalCondition (conditionName=, fileName=0x37afe4 "../src/backend/access/heap/heapam_handler.c", lineNumber=lineNumber@entry=2248) at ../src/backend/utils/error/assert.c:66 [16:28:13.420] No locals. [16:28:13.420] #4 0x00000000005c7c54 in heapam_scan_bitmap_next_block (scan=0x8336cb5a8, recheck=0x8336ac668, lossy_pages=0x8336ac650, exact_pages=0x8336ac648) at ../src/backend/access/heap/heapam_handler.c:2248 [16:28:13.420] hscan = 0x8336cb5a8 [16:28:13.420] per_buffer_data = 0x8335bef68 [16:28:13.420] tbmres = 0x8335bef68 [16:28:13.420] block = [16:28:13.420] buffer = [16:28:13.420] ntup = [16:28:13.420] snapshot = [16:28:13.420] curslot = [16:28:13.420] tid = [16:28:13.420] heapTuple = [16:28:13.420] offnum = [16:28:13.420] page = [16:28:13.420] offnum = [16:28:13.420] maxoff = [16:28:13.420] loctup = [16:28:13.420] lp = [16:28:13.420] valid = [16:28:13.420] #5 heapam_scan_bitmap_next_tuple (scan=0x8336cb5a8, slot=0x8336acd18, recheck=0x8336ac668, lossy_pages=0x8336ac650, exact_pages=0x8336ac648) at ../src/backend/access/heap/heapam_handler.c:2386 [16:28:13.420] targoffset = [16:28:13.420] page = [16:28:13.420] hscan = [16:28:13.420] lp = [16:28:13.420] #6 0x0000000000740b12 in table_scan_bitmap_next_tuple (scan=0x8336cb5a8, slot=0x8336acd18, recheck=0x8336ac668, lossy_pages=0x82905adaa , exact_pages=0x0) at ../src/include/access/tableam.h:2012 [16:28:13.420] __error = [16:28:13.420] #7 BitmapHeapNext (node=node@entry=0x8336ac558) at ../src/backend/executor/nodeBitmapHeapscan.c:202 [16:28:13.420] econtext = 0x8336ac768 [16:28:13.420] dsa = [16:28:13.420] slot = 0x8336acd18 [16:28:13.420] scan = 0x8336cb5a8 [16:28:13.420] tbm = [16:28:13.420] #8 0x0000000000730013 in ExecScanFetch (node=node@entry=0x8336ac558, accessMtd=accessMtd@entry=0x740860 , recheckMtd=recheckMtd@entry=0x740ce0 ) at ../src/backend/executor/execScan.c:131 [16:28:13.420] estate = [16:28:13.420] #9 0x000000000072fe28 in ExecScan (node=0x8336ac558, accessMtd=0x6, recheckMtd=0x740ce0 ) at ../src/backend/executor/execScan.c:197 [16:28:13.420] slot = [16:28:13.420] qual = 0x0 [16:28:13.420] econtext = 0x8336ac768 [16:28:13.420] projInfo = 0x8336acf38 [16:28:13.420] #10 0x00000000007406f4 in ExecBitmapHeapScan (pstate=0x18d97) at ../src/backend/executor/nodeBitmapHeapscan.c:277 [16:28:13.420] node = 0x18d97 [16:28:13.420] #11 0x000000000075ec89 in ExecProcNode (node=0x8336ac558) at ../src/include/executor/executor.h:274 [16:28:13.420] No locals. [16:28:13.420] #12 ExecSort (pstate=0x8336ac348) at ../src/backend/executor/nodeSort.c:149 [16:28:13.420] plannode = [16:28:13.420] tuplesortopts = [16:28:13.420] outerNode = 0x8336ac558 [16:28:13.420] tupDesc = [16:28:13.420] node = 0x8336ac348 [16:28:13.420] estate = 0x8336ac100 [16:28:13.420] tuplesortstate = 0x8360a3100 [16:28:13.420] dir = ForwardScanDirection [16:28:13.420] slot = [16:28:13.420] #13 0x000000000072d3db in ExecProcNodeFirst (node=0x8336ac348) at ../src/backend/executor/execProcnode.c:464 [16:28:13.420] No locals. [16:28:13.420] #14 0x00000000007256ca in ExecProcNode (node=0x8336ac348) at ../src/include/executor/executor.h:274 [16:28:13.420] No locals. [16:28:13.420] #15 ExecutePlan (estate=0x8336ac100, planstate=0x8336ac348, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x8336df898, execute_once=false) at ../src/backend/executor/execMain.c:1646 [16:28:13.420] current_tuple_count = [16:28:13.420] slot = [16:28:13.420] #16 standard_ExecutorRun (queryDesc=0x833511500, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [16:28:13.420] estate = 0x8336ac100 [16:28:13.420] oldcontext = 0x833511400 [16:28:13.420] operation = CMD_SELECT [16:28:13.420] dest = 0x8336df898 [16:28:13.420] sendTuples = true [16:28:13.420] #17 0x000000000072557f in ExecutorRun (queryDesc=0x18d97, queryDesc@entry=0x833511500, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [16:28:13.420] No locals. [16:28:13.420] #18 0x00000000008f7f07 in PortalRunSelect (portal=portal@entry=0x833623100, forward=, count=0, count@entry=9223372036854775807, dest=dest@entry=0x8336df898) at ../src/backend/tcop/pquery.c:924 [16:28:13.420] queryDesc = 0x833511500 [16:28:13.420] direction = ForwardScanDirection [16:28:13.420] nprocessed = [16:28:13.420] #19 0x00000000008f7a80 in PortalRun (portal=portal@entry=0x833623100, count=0, count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82905adaa , dest@entry=0x8336df898, altdest=altdest@entry=0x8336df898, qc=0x8211cbeb0) at ../src/backend/tcop/pquery.c:768 [16:28:13.420] _local_sigjmp_buf = {{_sjb = {9402831, 35221673176, 34915270056, 34915270288, 34915270064, 12066376, 12034160, 35221811456, 7112098687, 35221819648, 3566694, 34359738368}}} [16:28:13.420] _save_exception_stack = 0x8211cbf80 [16:28:13.420] _save_context_stack = 0x0 [16:28:13.420] _do_rethrow = false [16:28:13.420] saveTopTransactionResourceOwner = 0x8336014d8 [16:28:13.420] saveTopTransactionContext = 0x83350d000 [16:28:13.420] saveActivePortal = 0x0 [16:28:13.420] saveResourceOwner = 0x8336014d8 [16:28:13.420] savePortalContext = 0x0 [16:28:13.420] saveMemoryContext = 0x83350d000 [16:28:13.420] result = [16:28:13.420] nprocessed = [16:28:13.420] #20 0x00000000008f693b in exec_simple_query (query_string=query_string@entry=0x833501100 "SELECT onek.unique1, onek.stringu1 FROM onek\n WHERE onek.unique1 < 20\n ORDER BY unique1 using >;") at ../src/backend/tcop/postgres.c:1274 [16:28:13.420] cmdtaglen = [16:28:13.420] snapshot_set = [16:28:13.420] per_parsetree_context = 0x0 [16:28:13.420] plantree_list = [16:28:13.420] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:28:13.420] parsetree = 0x83350f448 [16:28:13.420] commandTag = CMDTAG_SELECT [16:28:13.420] cmdtagname = [16:28:13.420] querytree_list = [16:28:13.420] portal = 0x833623100 [16:28:13.420] format = 0 [16:28:13.420] receiver = 0x8336df898 [16:28:13.420] parsetree_item__state = {l = 0x83350fca0, i = 0} [16:28:13.420] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [16:28:13.420] dest = DestRemote [16:28:13.420] was_logged = [16:28:13.420] oldcontext = 0x83350d000 [16:28:13.420] parsetree_list = 0x83350fca0 [16:28:13.420] use_implicit_block = false [16:28:13.420] parsetree_item = 0x83350fcb8 [16:28:13.420] save_log_statement_stats = [16:28:13.420] #21 0x00000000008f4724 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [16:28:13.420] query_string = 0x833501100 "SELECT onek.unique1, onek.stringu1 FROM onek\n WHERE onek.unique1 < 20\n ORDER BY unique1 using >;" [16:28:13.420] input_message = {data = 0x833501100 "SELECT onek.unique1, onek.stringu1 FROM onek\n WHERE onek.unique1 < 20\n ORDER BY unique1 using >;", len = 101, maxlen = 1024, cursor = 101} [16:28:13.420] firstchar = [16:28:13.420] local_sigjmp_buf = {{_sjb = {9386992, 34915270528, 34915270488, 34915271088, 12075112, 12021584, 8192, 8388608, 72057628953150335, 0, 0, 34359738369}}} [16:28:13.420] send_ready_for_query = false [16:28:13.420] idle_in_transaction_timeout_enabled = false [16:28:13.420] idle_session_timeout_enabled = false [16:28:13.420] #22 0x00000000008ef489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [16:28:13.420] bsdata = [16:28:13.420] #23 0x000000000084ac72 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8211cccc0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8211ccc08) at ../src/backend/postmaster/launch_backend.c:265 [16:28:13.420] pid = [16:28:13.420] #24 0x000000000084f491 in BackendStartup (client_sock=0x8211ccc08) at ../src/backend/postmaster/postmaster.c:3593 [16:28:13.420] startup_data = {canAcceptConnections = CAC_OK} [16:28:13.420] bn = 0x83350d268 [16:28:13.420] pid = [16:28:13.420] __error = [16:28:13.420] __error = [16:28:13.420] save_errno = [16:28:13.420] __error = [16:28:13.420] __error = [16:28:13.420] #25 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [16:28:13.420] s = {sock = 9, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "`\314\034!\b\000\000\000ؕ\311(\b\000\000\000\v\000\000\000\000\000\000\000\016\026\312(\b", '\000' , "\240\314\034!\b\000\000\000D\252\204\000\000\000\000\000\260\314\034!\b", '\000' }, salen = 16}} [16:28:13.420] i = 0 [16:28:13.420] now = [16:28:13.420] events = {{pos = 3, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 555533064, user_data = 0x0}, {pos = 1727, events = 0, fd = 687063300, user_data = 0x8211cc288}, {pos = 564270088, events = 8, fd = 555533064, user_data = 0x828f3c104}, {pos = 555533040, events = 8, fd = 385328229, user_data = 0x8211cc280}, {pos = 10985227, events = 0, fd = 555533248, user_data = 0x828f2d4a8}, {pos = 0, events = 0, fd = 0, user_data = 0x829103a10 }, {pos = 12075120, events = 0, fd = 0, user_data = 0x0}, {pos = 385400464, events = 13268, fd = 16, user_data = 0x0}, {pos = 555533208, events = 8, fd = 564289672, user_data = 0x8211cc558}, {pos = 555533184, events = 8, fd = 385346979, user_data = 0x0}, {pos = 2569058, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 564293688, events = 8, fd = 1, user_data = 0x821a21408}, {pos = 687002792, events = 8, fd = 555533912, user_data = 0x821a21408}, {pos = 555533168, events = 0, fd = 2568876, user_data = 0x8211cc5a0}, {pos = 555533728, events = 8, fd = 555533656, user_data = 0x20}, {pos = 555533312, events = 8, fd = 385346435, user_data = 0xb81e70 }, {pos = 2569058, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 564293688, events = 8, fd = 1, user_data = 0x821a21408}, {pos = 687002792, events = 8, fd = 555533912, user_data = 0x2732ac}, {pos = 555533328, events = 8, fd = 555533728, user_data = 0x821a1a008}, {pos = 32, events = 0, fd = 555533712, user_data = 0x33d416f78a94}, {pos = 564240392, events = 8, fd = 564241416, user_data = 0x821a1a808}, {pos = 564243464, events = 8, fd = 564256776, user_data = 0x821a1e408}, {pos = 564258824, events = 8, fd = 564259848, user_data = 0x821a1f008}, {pos = 564261896, events = 8, fd = 564262920, user_data = 0x821a1fc08}, {pos = 564264968, events = 8, fd = 564265992, user_data = 0x821a20808}, {pos = 564268040, events = 8, fd = 564269064, user_data = 0x821a21408}, {pos = -854304876, events = 2879574344, fd = 555533680, user_data = 0x8211cc560}, {pos = 688224921, events = 8, fd = 564260872, user_data = 0x824afea68}, {pos = 555534168, events = 8, fd = 2568876, user_data = 0x8211cc560}, {pos = 688493746, events = 8, fd = 564240392, user_data = 0x20}, {pos = 555533968, events = 8, fd = 385321620, user_data = 0x821a1a008}, {pos = 2569058, events = 0, fd = 115249317, user_data = 0x8fe76ea16}, {pos = -854304876, events = 2879574344, fd = 688976112, user_data = 0x8211cc5d0}, {pos = 687767950, events = 8, fd = 688983536, user_data = 0x8211cc594}, {pos = 861624314, events = 8, fd = 555534848, user_data = 0x8211cc5d0}, {pos = 687859205, events = 8, fd = 555533714, user_data = 0x8211cca00}, {pos = 555534848, events = 8, fd = 0, user_data = 0xaba2d148cd145794}, {pos = 555534848, events = 8, fd = 861624312, user_data = 0x8211ccad0}, {pos = 688875576, events = 8, fd = 0, user_data = 0x8211cca40}, {pos = 687859469, events = 8, fd = 0, user_data = 0x0}, {pos = 555535216, events = 8, fd = 861624312, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 385348617, events = 13268, fd = 555534120, user_data = 0x828f43c64}, {pos = 2763, events = 0, fd = 687067444, user_data = 0x8211cc6a8}, {pos = 564270088, events = 8, fd = 555534120, user_data = 0x828f3d134}, {pos = 555534096, events = 8, fd = 385328229, user_data = 0x8}, {pos = 688976112, events = 8, fd = 555534064, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82910f0f0}, {pos = 12, events = 0, fd = 555534064, user_data = 0x28c97490}, {pos = 688904624, events = 8, fd = 385348617, user_data = 0x8211cc7d8}, {pos = 687094884, events = 8, fd = 2924, user_data = 0x828f3d3b8}, {pos = 555534168, events = 8, fd = 564270088, user_data = 0x8211cc7d8}, {pos = 687068088, events = 8, fd = 555534272, user_data = 0x33d416f7a465}, {pos = 564296440, events = 8, fd = 555534480, user_data = 0xb761e0 }, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -854304876, events = 2879574344, fd = 8, user_data = 0x8211cc7e0}, {pos = 688227025, events = 8, fd = 555534712, user_data = 0x1e}, {pos = 687031520, events = 8, fd = 555534440, user_data = 0x821a26248}, {pos = 555534888, events = 8, fd = 555534416, user_data = 0x33d416f7eda3}, {pos = 2973372, events = 0, fd = 2695949, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564293688, user_data = 0x800000001}} [16:28:13.420] last_touch_time = 1711901419 [16:28:13.420] last_lockfile_recheck_time = 1711901419 [16:28:13.420] nevents = 1 [16:28:13.420] #26 0x000000000084cd66 in PostmasterMain (argc=argc@entry=5, argv=argv@entry=0x8211cd208) at ../src/backend/postmaster/postmaster.c:1372 [16:28:13.420] userDoption = [16:28:13.420] listen_addr_saved = true [16:28:13.420] output_config_variable = [16:28:13.420] opt = [16:28:13.420] status = [16:28:13.420] #27 0x0000000000787de5 in main (argc=5, argv=0x8211cd208) at ../src/backend/main/main.c:197 [16:28:13.420] do_check_root = [16:28:13.430] [16:28:13.430] [16:28:13.430] [16:28:13.484] dumping /tmp/cores/postgres.41498.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [16:28:13.611] [New LWP 101789] [16:28:13.673] Core was generated by `postgres: postgres regression [local] SELECT'. [16:28:13.673] Program terminated with signal SIGABRT, Aborted. [16:28:13.673] Sent by thr_kill() from pid 41498 and user 1003. [16:28:13.673] #0 0x000000082905adca in thr_kill () from /lib/libc.so.7 [16:28:13.811] [16:28:13.811] Thread 1 (LWP 101789): [16:28:13.811] #0 0x000000082905adca in thr_kill () from /lib/libc.so.7 [16:28:13.811] No symbol table info available. [16:28:13.811] #1 0x0000000828fd36f4 in raise () from /lib/libc.so.7 [16:28:13.811] No symbol table info available. [16:28:13.811] #2 0x0000000829084bc9 in abort () from /lib/libc.so.7 [16:28:13.811] No symbol table info available. [16:28:13.811] #3 0x0000000000a49ec7 in ExceptionalCondition (conditionName=, fileName=0x37afe4 "../src/backend/access/heap/heapam_handler.c", lineNumber=lineNumber@entry=2248) at ../src/backend/utils/error/assert.c:66 [16:28:13.811] No locals. [16:28:13.811] #4 0x00000000005c7c54 in heapam_scan_bitmap_next_block (scan=0x835f05698, recheck=0x83350e5c0, lossy_pages=0x83350e5a8, exact_pages=0x83350e5a0) at ../src/backend/access/heap/heapam_handler.c:2248 [16:28:13.811] hscan = 0x835f05698 [16:28:13.811] per_buffer_data = 0x8335bd158 [16:28:13.811] tbmres = 0x8335bd158 [16:28:13.811] block = [16:28:13.811] buffer = [16:28:13.811] ntup = [16:28:13.811] snapshot = [16:28:13.811] curslot = [16:28:13.811] tid = [16:28:13.811] heapTuple = [16:28:13.811] offnum = [16:28:13.811] page = [16:28:13.811] offnum = [16:28:13.811] maxoff = [16:28:13.811] loctup = [16:28:13.811] lp = [16:28:13.811] valid = [16:28:13.811] #5 heapam_scan_bitmap_next_tuple (scan=0x835f05698, slot=0x83350ebe0, recheck=0x83350e5c0, lossy_pages=0x83350e5a8, exact_pages=0x83350e5a0) at ../src/backend/access/heap/heapam_handler.c:2386 [16:28:13.811] targoffset = [16:28:13.811] page = [16:28:13.811] hscan = [16:28:13.811] lp = [16:28:13.811] #6 0x0000000000740b12 in table_scan_bitmap_next_tuple (scan=0x835f05698, slot=0x83350ebe0, recheck=0x83350e5c0, lossy_pages=0x82905adaa , exact_pages=0x0) at ../src/include/access/tableam.h:2012 [16:28:13.811] __error = [16:28:13.811] #7 BitmapHeapNext (node=node@entry=0x83350e4b0) at ../src/backend/executor/nodeBitmapHeapscan.c:202 [16:28:13.811] econtext = 0x83350e6c0 [16:28:13.811] dsa = [16:28:13.811] slot = 0x83350ebe0 [16:28:13.811] scan = 0x835f05698 [16:28:13.811] tbm = [16:28:13.811] #8 0x0000000000730013 in ExecScanFetch (node=node@entry=0x83350e4b0, accessMtd=accessMtd@entry=0x740860 , recheckMtd=recheckMtd@entry=0x740ce0 ) at ../src/backend/executor/execScan.c:131 [16:28:13.811] estate = [16:28:13.811] #9 0x000000000072fe28 in ExecScan (node=0x83350e4b0, accessMtd=0x6, recheckMtd=0x740ce0 ) at ../src/backend/executor/execScan.c:197 [16:28:13.811] slot = [16:28:13.811] qual = 0x835d49688 [16:28:13.811] econtext = 0x83350e6c0 [16:28:13.811] projInfo = 0x0 [16:28:13.811] #10 0x00000000007406f4 in ExecBitmapHeapScan (pstate=0x18d9d) at ../src/backend/executor/nodeBitmapHeapscan.c:277 [16:28:13.811] node = 0x18d9d [16:28:13.811] #11 0x000000000072d3db in ExecProcNodeFirst (node=0x83350e4b0) at ../src/backend/executor/execProcnode.c:464 [16:28:13.811] No locals. [16:28:13.811] #12 0x000000000075c24d in ExecProcNode (node=0x83350e4b0) at ../src/include/executor/executor.h:274 [16:28:13.811] No locals. [16:28:13.811] #13 ExecNestLoop (pstate=0x83350e310) at ../src/backend/executor/nodeNestloop.c:108 [16:28:13.811] node = 0x83350e310 [16:28:13.811] nl = 0x840f0b380 [16:28:13.811] otherqual = 0x0 [16:28:13.811] joinqual = 0x0 [16:28:13.811] outerPlan = 0x83350e4b0 [16:28:13.811] innerPlan = 0x835d49038 [16:28:13.811] econtext = 0x83350e420 [16:28:13.811] innerTupleSlot = [16:28:13.811] outerTupleSlot = [16:28:13.811] lc = [16:28:13.811] #14 0x000000000072d3db in ExecProcNodeFirst (node=0x83350e310) at ../src/backend/executor/execProcnode.c:464 [16:28:13.811] No locals. [16:28:13.811] #15 0x000000000075c24d in ExecProcNode (node=0x83350e310) at ../src/include/executor/executor.h:274 [16:28:13.811] No locals. [16:28:13.811] #16 ExecNestLoop (pstate=0x83350e0e0) at ../src/backend/executor/nodeNestloop.c:108 [16:28:13.811] node = 0x83350e0e0 [16:28:13.811] nl = 0x840f0b020 [16:28:13.811] otherqual = 0x0 [16:28:13.811] joinqual = 0x835d9d098 [16:28:13.811] outerPlan = 0x83350e310 [16:28:13.811] innerPlan = 0x835d4ac08 [16:28:13.811] econtext = 0x83350e1f0 [16:28:13.811] innerTupleSlot = [16:28:13.811] outerTupleSlot = [16:28:13.811] lc = [16:28:13.811] #17 0x000000000072d3db in ExecProcNodeFirst (node=0x83350e0e0) at ../src/backend/executor/execProcnode.c:464 [16:28:13.811] No locals. [16:28:13.811] #18 0x000000000075c24d in ExecProcNode (node=0x83350e0e0) at ../src/include/executor/executor.h:274 [16:28:13.811] No locals. [16:28:13.811] #19 ExecNestLoop (pstate=0x83350df40) at ../src/backend/executor/nodeNestloop.c:108 [16:28:13.811] node = 0x83350df40 [16:28:13.811] nl = 0x840f0aaf0 [16:28:13.811] otherqual = 0x0 [16:28:13.811] joinqual = 0x0 [16:28:13.811] outerPlan = 0x83350e0e0 [16:28:13.811] innerPlan = 0x835d9d678 [16:28:13.811] econtext = 0x83350e050 [16:28:13.811] innerTupleSlot = [16:28:13.811] outerTupleSlot = [16:28:13.811] lc = [16:28:13.811] #20 0x000000000072d3db in ExecProcNodeFirst (node=0x83350df40) at ../src/backend/executor/execProcnode.c:464 [16:28:13.811] No locals. [16:28:13.811] #21 0x000000000075c24d in ExecProcNode (node=0x83350df40) at ../src/include/executor/executor.h:274 [16:28:13.811] No locals. [16:28:13.811] #22 ExecNestLoop (pstate=0x83350dda0) at ../src/backend/executor/nodeNestloop.c:108 [16:28:13.811] node = 0x83350dda0 [16:28:13.811] nl = 0x840f0a5c0 [16:28:13.811] otherqual = 0x0 [16:28:13.811] joinqual = 0x835da1830 [16:28:13.811] outerPlan = 0x83350df40 [16:28:13.811] innerPlan = 0x835d9f6f8 [16:28:13.811] econtext = 0x83350deb0 [16:28:13.811] innerTupleSlot = [16:28:13.811] outerTupleSlot = [16:28:13.811] lc = [16:28:13.811] #23 0x000000000072d3db in ExecProcNodeFirst (node=0x83350dda0) at ../src/backend/executor/execProcnode.c:464 [16:28:13.811] No locals. [16:28:13.811] #24 0x000000000075c24d in ExecProcNode (node=0x83350dda0) at ../src/include/executor/executor.h:274 [16:28:13.811] No locals. [16:28:13.811] #25 ExecNestLoop (pstate=0x83350dc00) at ../src/backend/executor/nodeNestloop.c:108 [16:28:13.811] node = 0x83350dc00 [16:28:13.811] nl = 0x840f098b0 [16:28:13.811] otherqual = 0x0 [16:28:13.811] joinqual = 0x835da3090 [16:28:13.811] outerPlan = 0x83350dda0 [16:28:13.811] innerPlan = 0x835da0940 [16:28:13.811] econtext = 0x83350dd10 [16:28:13.811] innerTupleSlot = [16:28:13.811] outerTupleSlot = [16:28:13.811] lc = [16:28:13.811] #26 0x000000000072d3db in ExecProcNodeFirst (node=0x83350dc00) at ../src/backend/executor/execProcnode.c:464 [16:28:13.811] No locals. [16:28:13.811] #27 0x000000000075ec89 in ExecProcNode (node=0x83350dc00) at ../src/include/executor/executor.h:274 [16:28:13.811] No locals. [16:28:13.811] #28 ExecSort (pstate=0x83350d9f0) at ../src/backend/executor/nodeSort.c:149 [16:28:13.811] plannode = [16:28:13.811] tuplesortopts = [16:28:13.811] outerNode = 0x83350dc00 [16:28:13.811] tupDesc = [16:28:13.811] node = 0x83350d9f0 [16:28:13.811] estate = 0x83350d100 [16:28:13.811] tuplesortstate = 0x835d7f100 [16:28:13.811] dir = ForwardScanDirection [16:28:13.811] slot = [16:28:13.811] #29 0x000000000072d3db in ExecProcNodeFirst (node=0x83350d9f0) at ../src/backend/executor/execProcnode.c:464 [16:28:13.811] No locals. [16:28:13.811] #30 0x000000000076320e in ExecProcNode (node=0x83350d9f0) at ../src/include/executor/executor.h:274 [16:28:13.811] No locals. [16:28:13.811] #31 ExecUnique (pstate=0x83350d8e0) at ../src/backend/executor/nodeUnique.c:72 [16:28:13.811] node = 0x83350d8e0 [16:28:13.811] econtext = 0x83350d7c0 [16:28:13.811] outerPlan = 0x83350d9f0 [16:28:13.811] resultTupleSlot = 0x835f03a88 [16:28:13.811] slot = [16:28:13.811] #32 0x000000000072d3db in ExecProcNodeFirst (node=0x83350d8e0) at ../src/backend/executor/execProcnode.c:464 [16:28:13.811] No locals. [16:28:13.811] #33 0x0000000000761302 in ExecProcNode (node=0x83350d8e0) at ../src/include/executor/executor.h:274 [16:28:13.811] No locals. [16:28:13.811] #34 SubqueryNext (node=node@entry=0x83350d620) at ../src/backend/executor/nodeSubqueryscan.c:53 [16:28:13.811] slot = [16:28:13.811] #35 0x0000000000730013 in ExecScanFetch (node=node@entry=0x83350d620, accessMtd=accessMtd@entry=0x7612e0 , recheckMtd=recheckMtd@entry=0x761310 ) at ../src/backend/executor/execScan.c:131 [16:28:13.811] estate = [16:28:13.811] #36 0x000000000072fe28 in ExecScan (node=0x83350d620, accessMtd=0x6, recheckMtd=0x761310 ) at ../src/backend/executor/execScan.c:197 [16:28:13.811] slot = [16:28:13.811] qual = 0x0 [16:28:13.811] econtext = 0x83350d730 [16:28:13.811] projInfo = 0x835f04b58 [16:28:13.811] #37 0x0000000000761264 in ExecSubqueryScan (pstate=0x18d9d) at ../src/backend/executor/nodeSubqueryscan.c:87 [16:28:13.811] node = 0x18d9d [16:28:13.811] #38 0x000000000072d3db in ExecProcNodeFirst (node=0x83350d620) at ../src/backend/executor/execProcnode.c:464 [16:28:13.811] No locals. [16:28:13.811] #39 0x000000000075ec89 in ExecProcNode (node=0x83350d620) at ../src/include/executor/executor.h:274 [16:28:13.811] No locals. [16:28:13.811] #40 ExecSort (pstate=0x83350d410) at ../src/backend/executor/nodeSort.c:149 [16:28:13.811] plannode = [16:28:13.811] tuplesortopts = [16:28:13.811] outerNode = 0x83350d620 [16:28:13.811] tupDesc = [16:28:13.811] node = 0x83350d410 [16:28:13.811] estate = 0x83350d100 [16:28:13.811] tuplesortstate = 0x835d4f100 [16:28:13.811] dir = ForwardScanDirection [16:28:13.811] slot = [16:28:13.811] #41 0x000000000072d3db in ExecProcNodeFirst (node=0x83350d410) at ../src/backend/executor/execProcnode.c:464 [16:28:13.811] No locals. [16:28:13.811] #42 0x00000000007256ca in ExecProcNode (node=0x83350d410) at ../src/include/executor/executor.h:274 [16:28:13.811] No locals. [16:28:13.811] #43 ExecutePlan (estate=0x83350d100, planstate=0x83350d410, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=, dest=0x840f15b88, execute_once=false) at ../src/backend/executor/execMain.c:1646 [16:28:13.811] current_tuple_count = [16:28:13.811] slot = [16:28:13.811] #44 standard_ExecutorRun (queryDesc=0x8336ba100, direction=, count=0, execute_once=false) at ../src/backend/executor/execMain.c:363 [16:28:13.811] estate = 0x83350d100 [16:28:13.811] oldcontext = 0x8336ba000 [16:28:13.811] operation = CMD_SELECT [16:28:13.811] dest = 0x840f15b88 [16:28:13.811] sendTuples = true [16:28:13.811] #45 0x000000000072557f in ExecutorRun (queryDesc=0x18d9d, queryDesc@entry=0x8336ba100, direction=6, direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:304 [16:28:13.811] No locals. [16:28:13.811] #46 0x00000000008f7f07 in PortalRunSelect (portal=portal@entry=0x833623100, forward=, count=0, count@entry=9223372036854775807, dest=dest@entry=0x840f15b88) at ../src/backend/tcop/pquery.c:924 [16:28:13.811] queryDesc = 0x8336ba100 [16:28:13.811] direction = ForwardScanDirection [16:28:13.811] nprocessed = [16:28:13.811] #47 0x00000000008f7a80 in PortalRun (portal=portal@entry=0x833623100, count=0, count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=0x82905adaa , dest@entry=0x840f15b88, altdest=altdest@entry=0x840f15b88, qc=0x8211cbeb0) at ../src/backend/tcop/pquery.c:768 [16:28:13.811] _local_sigjmp_buf = {{_sjb = {9402831, 35221673176, 34915270056, 34915270288, 34915270064, 12066376, 12034160, 35221811456, 7112098687, 35221819648, 3566694, 34359738368}}} [16:28:13.811] _save_exception_stack = 0x8211cbf80 [16:28:13.811] _save_context_stack = 0x0 [16:28:13.811] _do_rethrow = false [16:28:13.811] saveTopTransactionResourceOwner = 0x8336014d8 [16:28:13.811] saveTopTransactionContext = 0x8336cb000 [16:28:13.811] saveActivePortal = 0x0 [16:28:13.811] saveResourceOwner = 0x8336014d8 [16:28:13.811] savePortalContext = 0x0 [16:28:13.811] saveMemoryContext = 0x8336cb000 [16:28:13.811] result = [16:28:13.811] nprocessed = [16:28:13.811] #48 0x00000000008f693b in exec_simple_query (query_string=query_string@entry=0x833501100 "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 [16:28:13.811] cmdtaglen = [16:28:13.811] snapshot_set = [16:28:13.811] per_parsetree_context = 0x0 [16:28:13.811] plantree_list = [16:28:13.811] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:28:13.811] parsetree = 0x8336a6c58 [16:28:13.811] commandTag = CMDTAG_SELECT [16:28:13.811] cmdtagname = [16:28:13.811] querytree_list = [16:28:13.811] portal = 0x833623100 [16:28:13.811] format = 0 [16:28:13.811] receiver = 0x840f15b88 [16:28:13.811] parsetree_item__state = {l = 0x8336a7440, i = 0} [16:28:13.811] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [16:28:13.811] dest = DestRemote [16:28:13.811] was_logged = [16:28:13.811] oldcontext = 0x8336cb000 [16:28:13.811] parsetree_list = 0x8336a7440 [16:28:13.811] use_implicit_block = false [16:28:13.811] parsetree_item = 0x8336a7458 [16:28:13.811] save_log_statement_stats = [16:28:13.811] #49 0x00000000008f4724 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [16:28:13.811] query_string = 0x833501100 "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;" [16:28:13.811] input_message = {data = 0x833501100 "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} [16:28:13.811] firstchar = [16:28:13.811] local_sigjmp_buf = {{_sjb = {9386992, 34915270528, 34915270488, 34915271088, 12075112, 12021584, 8192, 8388608, 72057628953150335, 0, 0, 34359738369}}} [16:28:13.811] send_ready_for_query = false [16:28:13.811] idle_in_transaction_timeout_enabled = false [16:28:13.811] idle_session_timeout_enabled = false [16:28:13.811] #50 0x00000000008ef489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [16:28:13.811] bsdata = [16:28:13.811] #51 0x000000000084ac72 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8211cccc0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8211ccc08) at ../src/backend/postmaster/launch_backend.c:265 [16:28:13.811] pid = [16:28:13.811] #52 0x000000000084f491 in BackendStartup (client_sock=0x8211ccc08) at ../src/backend/postmaster/postmaster.c:3593 [16:28:13.811] startup_data = {canAcceptConnections = CAC_OK} [16:28:13.811] bn = 0x83350d768 [16:28:13.811] pid = [16:28:13.811] __error = [16:28:13.811] __error = [16:28:13.811] save_errno = [16:28:13.811] __error = [16:28:13.811] __error = [16:28:13.811] #53 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [16:28:13.811] s = {sock = 9, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "`\314\034!\b\000\000\000ؕ\311(\b\000\000\000\v\000\000\000\000\000\000\000\016\026\312(\b", '\000' , "\240\314\034!\b\000\000\000D\252\204\000\000\000\000\000\260\314\034!\b", '\000' }, salen = 16}} [16:28:13.811] i = 0 [16:28:13.811] now = [16:28:13.811] events = {{pos = 3, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 555533064, user_data = 0x0}, {pos = 1727, events = 0, fd = 687063300, user_data = 0x8211cc288}, {pos = 564270088, events = 8, fd = 555533064, user_data = 0x828f3c104}, {pos = 555533040, events = 8, fd = 385328229, user_data = 0x8211cc280}, {pos = 10985227, events = 0, fd = 555533248, user_data = 0x828f2d4a8}, {pos = 0, events = 0, fd = 0, user_data = 0x829103a10 }, {pos = 12075120, events = 0, fd = 0, user_data = 0x0}, {pos = 385400464, events = 13268, fd = 16, user_data = 0x0}, {pos = 555533208, events = 8, fd = 564289672, user_data = 0x8211cc558}, {pos = 555533184, events = 8, fd = 385346979, user_data = 0x0}, {pos = 2569058, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 564293688, events = 8, fd = 1, user_data = 0x821a21408}, {pos = 687002792, events = 8, fd = 555533912, user_data = 0x821a21408}, {pos = 555533168, events = 0, fd = 2568876, user_data = 0x8211cc5a0}, {pos = 555533728, events = 8, fd = 555533656, user_data = 0x20}, {pos = 555533312, events = 8, fd = 385346435, user_data = 0xb81e70 }, {pos = 2569058, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 564293688, events = 8, fd = 1, user_data = 0x821a21408}, {pos = 687002792, events = 8, fd = 555533912, user_data = 0x2732ac}, {pos = 555533328, events = 8, fd = 555533728, user_data = 0x821a1a008}, {pos = 32, events = 0, fd = 555533712, user_data = 0x33d416f78a94}, {pos = 564240392, events = 8, fd = 564241416, user_data = 0x821a1a808}, {pos = 564243464, events = 8, fd = 564256776, user_data = 0x821a1e408}, {pos = 564258824, events = 8, fd = 564259848, user_data = 0x821a1f008}, {pos = 564261896, events = 8, fd = 564262920, user_data = 0x821a1fc08}, {pos = 564264968, events = 8, fd = 564265992, user_data = 0x821a20808}, {pos = 564268040, events = 8, fd = 564269064, user_data = 0x821a21408}, {pos = -854304876, events = 2879574344, fd = 555533680, user_data = 0x8211cc560}, {pos = 688224921, events = 8, fd = 564260872, user_data = 0x824afea68}, {pos = 555534168, events = 8, fd = 2568876, user_data = 0x8211cc560}, {pos = 688493746, events = 8, fd = 564240392, user_data = 0x20}, {pos = 555533968, events = 8, fd = 385321620, user_data = 0x821a1a008}, {pos = 2569058, events = 0, fd = 115249317, user_data = 0x8fe76ea16}, {pos = -854304876, events = 2879574344, fd = 688976112, user_data = 0x8211cc5d0}, {pos = 687767950, events = 8, fd = 688983536, user_data = 0x8211cc594}, {pos = 861624314, events = 8, fd = 555534848, user_data = 0x8211cc5d0}, {pos = 687859205, events = 8, fd = 555533714, user_data = 0x8211cca00}, {pos = 555534848, events = 8, fd = 0, user_data = 0xaba2d148cd145794}, {pos = 555534848, events = 8, fd = 861624312, user_data = 0x8211ccad0}, {pos = 688875576, events = 8, fd = 0, user_data = 0x8211cca40}, {pos = 687859469, events = 8, fd = 0, user_data = 0x0}, {pos = 555535216, events = 8, fd = 861624312, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 385348617, events = 13268, fd = 555534120, user_data = 0x828f43c64}, {pos = 2763, events = 0, fd = 687067444, user_data = 0x8211cc6a8}, {pos = 564270088, events = 8, fd = 555534120, user_data = 0x828f3d134}, {pos = 555534096, events = 8, fd = 385328229, user_data = 0x8}, {pos = 688976112, events = 8, fd = 555534064, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82910f0f0}, {pos = 12, events = 0, fd = 555534064, user_data = 0x28c97490}, {pos = 688904624, events = 8, fd = 385348617, user_data = 0x8211cc7d8}, {pos = 687094884, events = 8, fd = 2924, user_data = 0x828f3d3b8}, {pos = 555534168, events = 8, fd = 564270088, user_data = 0x8211cc7d8}, {pos = 687068088, events = 8, fd = 555534272, user_data = 0x33d416f7a465}, {pos = 564296440, events = 8, fd = 555534480, user_data = 0xb761e0 }, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -854304876, events = 2879574344, fd = 8, user_data = 0x8211cc7e0}, {pos = 688227025, events = 8, fd = 555534712, user_data = 0x1e}, {pos = 687031520, events = 8, fd = 555534440, user_data = 0x821a26248}, {pos = 555534888, events = 8, fd = 555534416, user_data = 0x33d416f7eda3}, {pos = 2973372, events = 0, fd = 2695949, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564293688, user_data = 0x800000001}} [16:28:13.811] last_touch_time = 1711901419 [16:28:13.811] last_lockfile_recheck_time = 1711901419 [16:28:13.811] nevents = 1 [16:28:13.811] #54 0x000000000084cd66 in PostmasterMain (argc=argc@entry=5, argv=argv@entry=0x8211cd208) at ../src/backend/postmaster/postmaster.c:1372 [16:28:13.811] userDoption = [16:28:13.811] listen_addr_saved = true [16:28:13.811] output_config_variable = [16:28:13.811] opt = [16:28:13.811] status = [16:28:13.811] #55 0x0000000000787de5 in main (argc=5, argv=0x8211cd208) at ../src/backend/main/main.c:197 [16:28:13.811] do_check_root =