[06:59:27.629] src/tools/ci/cores_backtrace.sh linux /tmp/cores [06:59:27.872] dumping /tmp/cores/postgres-6-45744.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:59:28.124] [New LWP 45744] [06:59:28.124] [06:59:28.124] This GDB supports auto-downloading debuginfo from the following URLs: [06:59:28.124] [06:59:28.124] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [06:59:28.124] Debuginfod has been disabled. [06:59:28.124] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [06:59:28.237] [Thread debugging using libthread_db enabled] [06:59:28.237] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [06:59:28.237] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [06:59:28.237] Program terminated with signal SIGABRT, Aborted. [06:59:28.237] #0 0x00007f30326a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:28.346] [06:59:28.346] Thread 1 (Thread 0x7f302fd92a80 (LWP 45744)): [06:59:28.346] #0 0x00007f30326a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:28.346] No symbol table info available. [06:59:28.346] #1 0x00007f303265afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:28.346] No symbol table info available. [06:59:28.346] #2 0x00007f3032645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:28.346] No symbol table info available. [06:59:28.346] #3 0x00007f303281e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [06:59:28.346] No locals. [06:59:28.346] #4 0x00007f303282aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [06:59:28.346] No locals. [06:59:28.346] #5 0x00007f303280dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x559064c17e00, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [06:59:28.346] bp = 140721297246640 [06:59:28.346] pc = [06:59:28.346] Opts = {FromUnrecoverableHandler = true, pc = 94078639233068, bp = 18446744073709551615} [06:59:28.346] #6 0x0000559063df582c in get_notnull_info (winobj=winobj@entry=0x55906bdb0fb8, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3464 [06:59:28.346] mb = [06:59:28.346] bpos = 0 [06:59:28.346] #7 0x0000559063e003c8 in WinGetFuncArgInPartition (winobj=winobj@entry=0x55906bdb0fb8, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7ffc3aef4a5f, isout=0x7ffc3aef4a5e) at ../src/backend/executor/nodeWindowAgg.c:3742 [06:59:28.346] winstate = [06:59:28.346] abs_pos = -1 [06:59:28.346] datum = 0 [06:59:28.346] null_treatment = true [06:59:28.346] notnull_offset = 0 [06:59:28.346] notnull_relpos = 1 [06:59:28.346] forward = -1 [06:59:28.346] __func__ = "WinGetFuncArgInPartition" [06:59:28.346] #8 0x00005590643c403f in leadlag_common (fcinfo=0x7ffc3aef4aa0, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [06:59:28.346] winobj = 0x55906bdb0fb8 [06:59:28.346] offset = [06:59:28.346] const_offset = [06:59:28.346] result = [06:59:28.346] isnull = true [06:59:28.346] isout = true [06:59:28.346] #9 0x00005590643c4e37 in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [06:59:28.346] No locals. [06:59:28.346] #10 0x0000559063df639c in eval_windowfunction (winstate=winstate@entry=0x55906bd0c2f8, perfuncstate=0x55906bdb0d48, result=0x55906bd0df78, isnull=0x55906bd13932) at ../src/backend/executor/nodeWindowAgg.c:1088 [06:59:28.346] fcinfodata = {fcinfo = {flinfo = 0x55906bdb0d60, context = 0x55906bdb0fb8, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7ffc3aef4ac0}, fcinfo_data = "`\r\333k\220U\000\000\270\017\333k\220U", '\000' , "\377\001\000\000\000\000\000\000\000\000\000\001\324\302k\220U\000\000\000\000\000\000\220U\000\000\v\023/d\220U\000\000\377\377\377\377\377\377\377\377P\206\321k\220U\000\000\000\000\000\000\000\000\000\000x\324\302k\220U\000\000`\212\321k\220U\000\000PK\357:\374\177\000\000", '\377' , "\000\000\000\000\000\000\000\000x\324\302k\220U\000\000`\212\321k\220U\000\000\v\023/d\220U\000\000\000\000\000\000\000\000i@P\206\321k\220U", '\000' , "\220\212@\340\367\324k\220U\000\000"...} [06:59:28.346] fcinfo = 0x7ffc3aef4aa0 [06:59:28.346] oldContext = 0x55906bd0bf90 [06:59:28.346] #11 0x0000559063dff53d in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [06:59:28.346] perfuncstate = [06:59:28.346] winstate = 0x55906bd0c2f8 [06:59:28.346] slot = [06:59:28.346] econtext = 0x55906bd0c868 [06:59:28.346] i = 2 [06:59:28.346] numfuncs = 3 [06:59:28.346] __func__ = "ExecWindowAgg" [06:59:28.346] #12 0x0000559063d690b0 in ExecProcNodeFirst (node=0x55906bd0c2f8) at ../src/backend/executor/execProcnode.c:469 [06:59:28.346] No locals. [06:59:28.346] #13 0x0000559063d53483 in ExecProcNode (node=node@entry=0x55906bd0c2f8) at ../src/include/executor/executor.h:313 [06:59:28.346] No locals. [06:59:28.346] #14 0x0000559063d53e3d in ExecutePlan (queryDesc=queryDesc@entry=0x55906bd1c510, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55906bd502f0) at ../src/backend/executor/execMain.c:1679 [06:59:28.346] estate = 0x55906bd0c090 [06:59:28.346] planstate = 0x55906bd0c2f8 [06:59:28.346] use_parallel_mode = false [06:59:28.346] slot = [06:59:28.346] current_tuple_count = 0 [06:59:28.346] #15 0x0000559063d555cd in standard_ExecutorRun (queryDesc=queryDesc@entry=0x55906bd1c510, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:367 [06:59:28.346] estate = 0x55906bd0c090 [06:59:28.346] operation = CMD_SELECT [06:59:28.346] dest = 0x55906bd502f0 [06:59:28.346] sendTuples = [06:59:28.346] oldcontext = 0x55906bd1c410 [06:59:28.346] #16 0x00007f302fd29805 in pgss_ExecutorRun (queryDesc=0x55906bd1c510, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1035 [06:59:28.346] _save_exception_stack = 0x7ffc3aef53e0 [06:59:28.346] _save_context_stack = 0x0 [06:59:28.346] _local_sigjmp_buf = {{__jmpbuf = {94078771837680, -1851478991342185911, 0, 1, 94078771317584, 94078771317536, -5578099738222046647, -5544298738445364663}, __mask_was_saved = 0, __saved_mask = {__val = {94078645930126, 1687934720, 94078645934657, 1809115848, 2, 0, 94078771930384, 94078771930384, 1, 1, 94078771317584, 94078771317536, 94078646020195, 0, 94078646175508, 94078771930384}}}} [06:59:28.346] _do_rethrow = false [06:59:28.346] #17 0x0000559063d55623 in ExecutorRun (queryDesc=queryDesc@entry=0x55906bd1c510, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:302 [06:59:28.346] No locals. [06:59:28.346] #18 0x00005590641750d4 in PortalRunSelect (portal=portal@entry=0x55906bc6baf0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55906bd502f0) at ../src/backend/tcop/pquery.c:921 [06:59:28.346] queryDesc = 0x55906bd1c510 [06:59:28.346] direction = [06:59:28.346] nprocessed = [06:59:28.346] __func__ = "PortalRunSelect" [06:59:28.346] #19 0x00005590641784cc in PortalRun (portal=portal@entry=0x55906bc6baf0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55906bd502f0, altdest=altdest@entry=0x55906bd502f0, qc=qc@entry=0x7ffc3aef5500) at ../src/backend/tcop/pquery.c:765 [06:59:28.346] _save_exception_stack = 0x7ffc3aef55b0 [06:59:28.346] _save_context_stack = 0x0 [06:59:28.346] _local_sigjmp_buf = {{__jmpbuf = {0, -1851479023684464055, 94078771837680, 94078771317608, 94078771317584, 94078771317536, -5578099738194783671, -1851500451257953719}, __mask_was_saved = 0, __saved_mask = {__val = {94078645934657, 988763279, 4, 94078771317536, 112, 179, 94078771837680, 94078771317608, 94078771317584, 94078771317536, 94078646022382, 1, 2, 179, 94078635019331, 0}}}} [06:59:28.346] _do_rethrow = [06:59:28.346] result = [06:59:28.346] nprocessed = [06:59:28.346] saveTopTransactionResourceOwner = 0x55906bc2f508 [06:59:28.346] saveTopTransactionContext = 0x55906bc823e0 [06:59:28.346] saveActivePortal = 0x0 [06:59:28.346] saveResourceOwner = 0x55906bc2f508 [06:59:28.346] savePortalContext = 0x0 [06:59:28.346] saveMemoryContext = 0x55906bc823e0 [06:59:28.346] __func__ = "PortalRun" [06:59:28.346] #20 0x00005590641712ac in exec_simple_query (query_string=query_string@entry=0x55906bbeb070 "SELECT name,\n orbit,\n lag(orbit) OVER w AS lag,\n lag(orbit) RESPECT NULLS OVER w AS lag_respect,\n lag(orbit) IGNORE NULLS OVER w AS lag_ignore\nFROM planets\nWINDOW w AS (ORDER B"...) at ../src/backend/tcop/postgres.c:1273 [06:59:28.346] cmdtaglen = 6 [06:59:28.346] snapshot_set = [06:59:28.346] per_parsetree_context = 0x0 [06:59:28.346] plantree_list = 0x55906bd50a80 [06:59:28.346] parsetree = 0x55906bbecb20 [06:59:28.346] commandTag = [06:59:28.346] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:59:28.346] querytree_list = [06:59:28.346] portal = 0x55906bc6baf0 [06:59:28.346] receiver = 0x55906bd502f0 [06:59:28.346] format = 0 [06:59:28.346] cmdtagname = [06:59:28.346] parsetree_item__state = [06:59:28.346] dest = DestRemote [06:59:28.346] oldcontext = 0x55906bc823e0 [06:59:28.346] parsetree_list = 0x55906bbecb50 [06:59:28.346] parsetree_item = 0x55906bbecb68 [06:59:28.346] save_log_statement_stats = false [06:59:28.346] was_logged = true [06:59:28.346] use_implicit_block = false [06:59:28.346] msec_str = "\300Q\336d\220U\000\000\200\265Cd\220U\000\000\220U\357:\374\177\000\000\322\000\000\000\000\000\000" [06:59:28.346] __func__ = "exec_simple_query" [06:59:28.346] #21 0x00005590641744f5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [06:59:28.346] query_string = 0x55906bbeb070 "SELECT name,\n orbit,\n lag(orbit) OVER w AS lag,\n lag(orbit) RESPECT NULLS OVER w AS lag_respect,\n lag(orbit) IGNORE NULLS OVER w AS lag_ignore\nFROM planets\nWINDOW w AS (ORDER B"... [06:59:28.346] firstchar = [06:59:28.346] input_message = {data = 0x55906bbeb070 "SELECT name,\n orbit,\n lag(orbit) OVER w AS lag,\n lag(orbit) RESPECT NULLS OVER w AS lag_respect,\n lag(orbit) IGNORE NULLS OVER w AS lag_ignore\nFROM planets\nWINDOW w AS (ORDER B"..., len = 210, maxlen = 1024, cursor = 210} [06:59:28.346] local_sigjmp_buf = {{__jmpbuf = {94078659004152, -1851502731708902839, 4, 94078655943104, 24, 6, -5578099738127674807, -1851500446703070647}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94078771565744, 0, 168, 94078645935127, 0, 10, 2, 94078659004160, 94078771041616, 94078658998176, 94078655943104, 24, 6}}}} [06:59:28.346] send_ready_for_query = false [06:59:28.346] idle_in_transaction_timeout_enabled = false [06:59:28.346] idle_session_timeout_enabled = false [06:59:28.346] __func__ = "PostgresMain" [06:59:28.346] #22 0x0000559064169e0d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [06:59:28.346] bsdata = [06:59:28.346] #23 0x00005590640079fa in postmaster_child_launch (child_type=B_BACKEND, child_slot=6, startup_data=startup_data@entry=0x7ffc3aef5710, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffc3aef5780) at ../src/backend/postmaster/launch_backend.c:290 [06:59:28.346] pid = [06:59:28.346] #24 0x000055906400cfbe in BackendStartup (client_sock=client_sock@entry=0x7ffc3aef5780) at ../src/backend/postmaster/postmaster.c:3580 [06:59:28.346] bn = 0x55906bc16838 [06:59:28.346] pid = [06:59:28.346] startup_data = {canAcceptConnections = CAC_OK, socket_created = 803631191131859, fork_started = 803631191131865} [06:59:28.346] cac = [06:59:28.346] __func__ = "BackendStartup" [06:59:28.346] #25 0x000055906400f4ea in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [06:59:28.346] s = {sock = 62, raddr = {addr = {ss_family = 1, __ss_padding = "\023c\220U\000\000\340|\017c\220U\000\000\300X\357:\374\177\000\000\270X\357:\374\177\000\000\225[\362\001\000\000\000\000@\\\301k\220U\000\000.", '\000' , "\340W\357:\374\177\000\000\000\004\000\000\000\000\000\000\370X\357:\374\177\000\000\000\200l\304e\213R\371ph\272k", '\000' , __ss_align = 67}, salen = 2}} [06:59:28.346] i = 0 [06:59:28.346] now = [06:59:28.346] last_lockfile_recheck_time = 1750315933 [06:59:28.346] last_touch_time = 1750315933 [06:59:28.346] events = {{pos = 1, events = 2, fd = 60, user_data = 0x0}, {pos = 0, events = 0, fd = 988764480, user_data = 0x0}, {pos = 17, events = 0, fd = 811760656, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f3033f4c2e0}, {pos = 988764344, events = 32764, fd = 988764352, user_data = 0x7f3033f4c668}, {pos = 0, events = 0, fd = 1, user_data = 0x1}, {pos = 1807845208, events = 21904, fd = 1, user_data = 0x55906bc18758}, {pos = -1, events = 0, fd = 845340704, user_data = 0x7f3033b2ea10}, {pos = 1807661968, events = 21904, fd = 846130597, user_data = 0x7ffc3aef5e13}, {pos = 61, events = 0, fd = 988764416, user_data = 0x7f3033f4c2e0}, {pos = 436, events = 0, fd = 1688067488, user_data = 0x0}, {pos = 0, events = 0, fd = 86, user_data = 0x7f3033f27ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f303262e020}, {pos = 846147200, events = 32560, fd = 601995807, user_data = 0x7ffc3aef5d30}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 871539386, events = 32560, fd = 0, user_data = 0x7f30326aedd4 }, {pos = 0, events = 0, fd = 1695247744, user_data = 0x2}, {pos = 0, events = 0, fd = 1807378544, user_data = 0x7f30326eeedd }, {pos = 1807667072, events = 21904, fd = 1678772174, user_data = 0x55906bc1fb30}, {pos = 8096, events = 196607, fd = 1807874955, user_data = 0x5590641054c3 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x168}, {pos = 1688066880, events = 21904, fd = 4, user_data = 0x1}, {pos = 1807845208, events = 21904, fd = 871530174, user_data = 0x1}, {pos = 845901623, events = 32560, fd = 845374664, user_data = 0x1010}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffff0000}, {pos = -1, events = 4294967295, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = 844970624, events = 32560, fd = 844971968, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1807885136, user_data = 0x559064458a70 }, {pos = 1807883088, events = 21904, fd = 1080, user_data = 0x55906bba6ad0}, {pos = 1682281200, events = 21904, fd = 1024, user_data = 0x7f30326b58ee}, {pos = 847174112, events = 32560, fd = 845812078, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 988765704, events = 32764, fd = 845905743, user_data = 0x55906bba6ad0}, {pos = 3, events = 0, fd = 0, user_data = 0x9262}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x77}, {pos = 846147731, events = 32560, fd = 1807379152, user_data = 0x1}, {pos = 1807379352, events = 21904, fd = 1024, user_data = 0x7ffc3aef5e08}, {pos = 1682362349, events = 21904, fd = 1695352496, user_data = 0x55906445baa1 }, {pos = 1807379152, events = 21904, fd = 1807658864, user_data = 0x55906bba6ad0}, {pos = 845895579, events = 32560, fd = 0, user_data = 0x55906446d714 }, {pos = 1807379152, events = 1, fd = 1682364509, user_data = 0x55906bbeaf70}, {pos = 845818545, events = 32560, fd = 845812976, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -999522304, events = 4182936421, fd = 1807378544, user_data = 0xf9528b65c46c8000}, {pos = 13, events = 0, fd = -999522304, user_data = 0x0}, {pos = 845525561, events = 32560, fd = 0, user_data = 0x5590640076e0 }, {pos = 4194304, events = 0, fd = 1807492768, user_data = 0x1}, {pos = 0, events = 0, fd = 1807378544, user_data = 0x55906445b935 }, {pos = 1807492768, events = 21904, fd = 1807658864, user_data = 0x55906bbc26a0}, {pos = 1, events = 0, fd = 0, user_data = 0x559064419b74 }, {pos = 13, events = 0, fd = 1807842696, user_data = 0x55906bc17d68}, {pos = 1695249176, events = 21904, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 1677752474, user_data = 0x55906bbeaf70}, {pos = 1677769382, events = 21904, fd = 1691553648, user_data = 0x55906bbeb928}} [06:59:28.346] nevents = 1 [06:59:28.346] __func__ = "ServerLoop" [06:59:28.346] #26 0x0000559064010d4e in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55906bba9450) at ../src/backend/postmaster/postmaster.c:1400 [06:59:28.346] opt = [06:59:28.346] status = [06:59:28.346] userDoption = [06:59:28.346] listen_addr_saved = false [06:59:28.346] output_config_variable = [06:59:28.346] __func__ = "PostmasterMain" [06:59:28.346] #27 0x0000559063e3d1aa in main (argc=4, argv=0x55906bba9450) at ../src/backend/main/main.c:227 [06:59:28.346] do_check_root = [06:59:28.346] dispatch_option = [06:59:28.367] -e [06:59:28.367] [06:59:28.367] [06:59:28.436] dumping /tmp/cores/postgres-6-35035.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [06:59:28.688] [New LWP 35035] [06:59:28.688] [06:59:28.688] This GDB supports auto-downloading debuginfo from the following URLs: [06:59:28.688] [06:59:28.688] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [06:59:28.688] Debuginfod has been disabled. [06:59:28.688] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [06:59:28.790] [Thread debugging using libthread_db enabled] [06:59:28.790] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [06:59:28.790] Core was generated by `postgres: postgres regression [local] SELECT '. [06:59:28.790] Program terminated with signal SIGABRT, Aborted. [06:59:28.790] #0 0x00007fd6ebaa9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:28.851] [06:59:28.851] Thread 1 (Thread 0x7fd6eb9d2a80 (LWP 35035)): [06:59:28.851] #0 0x00007fd6ebaa9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:28.851] No symbol table info available. [06:59:28.851] #1 0x00007fd6eba5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:28.851] No symbol table info available. [06:59:28.851] #2 0x00007fd6eba45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:28.851] No symbol table info available. [06:59:28.851] #3 0x00007fd6ebc1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [06:59:28.851] No locals. [06:59:28.851] #4 0x00007fd6ebc2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [06:59:28.851] No locals. [06:59:28.851] #5 0x00007fd6ebc0dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x55b9fc8ace00, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [06:59:28.851] bp = 140728346976288 [06:59:28.851] pc = [06:59:28.851] Opts = {FromUnrecoverableHandler = true, pc = 94257279445036, bp = 18446744073709551615} [06:59:28.851] #6 0x000055b9fba8a82c in get_notnull_info (winobj=winobj@entry=0x55ba051ba688, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3464 [06:59:28.851] mb = [06:59:28.851] bpos = 0 [06:59:28.851] #7 0x000055b9fba953c8 in WinGetFuncArgInPartition (winobj=winobj@entry=0x55ba051ba688, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7ffddf21a0cf, isout=0x7ffddf21a0ce) at ../src/backend/executor/nodeWindowAgg.c:3742 [06:59:28.851] winstate = [06:59:28.851] abs_pos = -1 [06:59:28.851] datum = 0 [06:59:28.851] null_treatment = true [06:59:28.851] notnull_offset = 0 [06:59:28.851] notnull_relpos = 1 [06:59:28.851] forward = -1 [06:59:28.851] __func__ = "WinGetFuncArgInPartition" [06:59:28.851] #8 0x000055b9fc05903f in leadlag_common (fcinfo=0x7ffddf21a110, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [06:59:28.851] winobj = 0x55ba051ba688 [06:59:28.851] offset = [06:59:28.851] const_offset = [06:59:28.851] result = [06:59:28.851] isnull = true [06:59:28.851] isout = true [06:59:28.851] #9 0x000055b9fc059e37 in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [06:59:28.851] No locals. [06:59:28.851] #10 0x000055b9fba8b39c in eval_windowfunction (winstate=winstate@entry=0x55ba05145a68, perfuncstate=0x55ba051ba418, result=0x55ba051476e8, isnull=0x55ba051afea2) at ../src/backend/executor/nodeWindowAgg.c:1088 [06:59:28.851] fcinfodata = {fcinfo = {flinfo = 0x55ba051ba430, context = 0x55ba051ba688, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7ffddf21a130}, fcinfo_data = "0\244\033\005\272U\000\000\210\246\033\005\272U", '\000' , "\377\001\000\000\000\000\000\000\000\000\000\001>\006\005\272U\000\000\000\000\000\000\272U\000\000\vc\370\373\271U\000\000\377\377\377\377\377\377\377\377\300\035\025\005\272U\000\000\000\000\000\000\000\000\000\000\310>\006\005\272U\000\000\320!\025\005\272U\000\000\300\241!\337\375\177\000\000", '\377' , "\000\000\000\000\000\000\000\000\310>\006\005\272U\000\000\320!\025\005\272U\000\000\vc\370\373\271U\000\000\001\000\000\000\272U\000\000\300\035\025\005\272U\000\000\2503\326\374\271U\000\000\b\234\006\374\271U\000\000p\037\206\337\326\177\000\000"...} [06:59:28.851] fcinfo = 0x7ffddf21a110 [06:59:28.851] oldContext = 0x55ba05145700 [06:59:28.851] #11 0x000055b9fba9453d in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [06:59:28.851] perfuncstate = [06:59:28.851] winstate = 0x55ba05145a68 [06:59:28.851] slot = [06:59:28.851] econtext = 0x55ba05145fd8 [06:59:28.851] i = 2 [06:59:28.851] numfuncs = 3 [06:59:28.851] __func__ = "ExecWindowAgg" [06:59:28.851] #12 0x000055b9fb9fe0b0 in ExecProcNodeFirst (node=0x55ba05145a68) at ../src/backend/executor/execProcnode.c:469 [06:59:28.851] No locals. [06:59:28.851] #13 0x000055b9fb9e8483 in ExecProcNode (node=node@entry=0x55ba05145a68) at ../src/include/executor/executor.h:313 [06:59:28.851] No locals. [06:59:28.851] #14 0x000055b9fb9e8e3d in ExecutePlan (queryDesc=queryDesc@entry=0x55ba050c8790, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55ba0519e130) at ../src/backend/executor/execMain.c:1679 [06:59:28.851] estate = 0x55ba05145800 [06:59:28.851] planstate = 0x55ba05145a68 [06:59:28.851] use_parallel_mode = false [06:59:28.851] slot = [06:59:28.851] current_tuple_count = 0 [06:59:28.851] #15 0x000055b9fb9ea5cd in standard_ExecutorRun (queryDesc=0x55ba050c8790, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:367 [06:59:28.851] estate = 0x55ba05145800 [06:59:28.851] operation = CMD_SELECT [06:59:28.851] dest = 0x55ba0519e130 [06:59:28.851] sendTuples = [06:59:28.851] oldcontext = 0x55ba050c8690 [06:59:28.851] #16 0x000055b9fb9ea62d in ExecutorRun (queryDesc=queryDesc@entry=0x55ba050c8790, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:304 [06:59:28.851] No locals. [06:59:28.851] #17 0x000055b9fbe0a0d4 in PortalRunSelect (portal=portal@entry=0x55ba050a8990, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55ba0519e130) at ../src/backend/tcop/pquery.c:921 [06:59:28.851] queryDesc = 0x55ba050c8790 [06:59:28.851] direction = [06:59:28.851] nprocessed = [06:59:28.851] __func__ = "PortalRunSelect" [06:59:28.851] #18 0x000055b9fbe0d4cc in PortalRun (portal=portal@entry=0x55ba050a8990, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55ba0519e130, altdest=altdest@entry=0x55ba0519e130, qc=qc@entry=0x7ffddf21aa60) at ../src/backend/tcop/pquery.c:765 [06:59:28.851] _save_exception_stack = 0x7ffddf21ab10 [06:59:28.851] _save_context_stack = 0x0 [06:59:28.851] _local_sigjmp_buf = {{__jmpbuf = {0, -7254266057188681282, 94257436854672, 94257436315512, 94257436315488, 94257436315440, -3468863509988091458, -7254077962807387714}, __mask_was_saved = 0, __saved_mask = {__val = {94257286146625, 3743525359, 4, 94257436315440, 112, 179, 94257436854672, 94257436315512, 94257436315488, 94257436315440, 94257286234350, 1, 2, 179, 94257275231299, 0}}}} [06:59:28.851] _do_rethrow = [06:59:28.851] result = [06:59:28.851] nprocessed = [06:59:28.851] saveTopTransactionResourceOwner = 0x55ba05066758 [06:59:28.851] saveTopTransactionContext = 0x55ba050bd640 [06:59:28.851] saveActivePortal = 0x0 [06:59:28.851] saveResourceOwner = 0x55ba05066758 [06:59:28.851] savePortalContext = 0x0 [06:59:28.851] saveMemoryContext = 0x55ba050bd640 [06:59:28.851] __func__ = "PortalRun" [06:59:28.851] #19 0x000055b9fbe062ac in exec_simple_query (query_string=query_string@entry=0x55ba05023480 "SELECT name,\n orbit,\n lag(orbit) OVER w AS lag,\n lag(orbit) RESPECT NULLS OVER w AS lag_respect,\n lag(orbit) IGNORE NULLS OVER w AS lag_ignore\nFROM planets\nWINDOW w AS (ORDER B"...) at ../src/backend/tcop/postgres.c:1273 [06:59:28.851] cmdtaglen = 6 [06:59:28.851] snapshot_set = [06:59:28.851] per_parsetree_context = 0x0 [06:59:28.851] plantree_list = 0x55ba0519e8c0 [06:59:28.851] parsetree = 0x55ba05024f30 [06:59:28.851] commandTag = [06:59:28.851] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:59:28.851] querytree_list = [06:59:28.851] portal = 0x55ba050a8990 [06:59:28.851] receiver = 0x55ba0519e130 [06:59:28.851] format = 0 [06:59:28.851] cmdtagname = [06:59:28.851] parsetree_item__state = [06:59:28.851] dest = DestRemote [06:59:28.851] oldcontext = 0x55ba050bd640 [06:59:28.851] parsetree_list = 0x55ba05024f60 [06:59:28.851] parsetree_item = 0x55ba05024f78 [06:59:28.851] save_log_statement_stats = false [06:59:28.851] was_logged = false [06:59:28.851] use_implicit_block = false [06:59:28.851] msec_str = "\300\241\247\374\271U\000\000\200\005\r\374\271U\000\000\360\252!\337\375\177\000\000\322\000\000\000\000\000\000" [06:59:28.851] __func__ = "exec_simple_query" [06:59:28.851] #20 0x000055b9fbe094f5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [06:59:28.851] query_string = 0x55ba05023480 "SELECT name,\n orbit,\n lag(orbit) OVER w AS lag,\n lag(orbit) RESPECT NULLS OVER w AS lag_respect,\n lag(orbit) IGNORE NULLS OVER w AS lag_ignore\nFROM planets\nWINDOW w AS (ORDER B"... [06:59:28.851] firstchar = [06:59:28.851] input_message = {data = 0x55ba05023480 "SELECT name,\n orbit,\n lag(orbit) OVER w AS lag,\n lag(orbit) RESPECT NULLS OVER w AS lag_respect,\n lag(orbit) IGNORE NULLS OVER w AS lag_ignore\nFROM planets\nWINDOW w AS (ORDER B"..., len = 210, maxlen = 1024, cursor = 210} [06:59:28.851] local_sigjmp_buf = {{__jmpbuf = {94257299216120, -7254075330099914306, 4, 94257296155072, 24, 18, -3468863509920982594, -7254077964174599746}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94257436038480, 17408, 94257299210144, 94257436573440, 24, 94257286146541, 0, 10, 2, 94257299216128, 94257436038480, 94257299210144, 94257296155072, 24, 18}}}} [06:59:28.851] send_ready_for_query = false [06:59:28.851] idle_in_transaction_timeout_enabled = false [06:59:28.851] idle_session_timeout_enabled = false [06:59:28.851] __func__ = "PostgresMain" [06:59:28.851] #21 0x000055b9fbdfee0d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [06:59:28.851] bsdata = [06:59:28.851] #22 0x000055b9fbc9c9fa in postmaster_child_launch (child_type=B_BACKEND, child_slot=18, startup_data=startup_data@entry=0x7ffddf21ac70, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffddf21ace0) at ../src/backend/postmaster/launch_backend.c:290 [06:59:28.851] pid = [06:59:28.851] #23 0x000055b9fbca1fbe in BackendStartup (client_sock=client_sock@entry=0x7ffddf21ace0) at ../src/backend/postmaster/postmaster.c:3580 [06:59:28.851] bn = 0x55ba0504bd28 [06:59:28.851] pid = [06:59:28.851] startup_data = {canAcceptConnections = CAC_OK, socket_created = 803631120812724, fork_started = 803631120812727} [06:59:28.851] cac = [06:59:28.851] __func__ = "BackendStartup" [06:59:28.851] #24 0x000055b9fbca44ea in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [06:59:28.851] s = {sock = 151, raddr = {addr = {ss_family = 1, __ss_padding = "!\337\375\177\000\000t\255!\337\375\177", '\000' , "\025\005\335\372\271U\000\000\340\314\330\372\271U\000\000@\256!\337\375\177\000\0008\256!\337\375\177\000\000\225[\362\001\000\000\000\000p\232\210\354\326\177\000\000-", '\000' , "#\004\335\372\271U\000\000hV2\355\326\177\000\000\020\234\210\354\326\177\000", __ss_align = 140561079227104}, salen = 2}} [06:59:28.851] i = 0 [06:59:28.851] now = [06:59:28.851] last_lockfile_recheck_time = 1750315864 [06:59:28.851] last_touch_time = 1750315864 [06:59:28.851] events = {{pos = 1, events = 2, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = 149, user_data = 0x0}, {pos = -315469088, events = 32726, fd = 2090263927, user_data = 0x7ffddf21aec0}, {pos = -315643320, events = 32726, fd = 17, user_data = 0x7fd6ec889c10}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -315469088, events = 32726, fd = -551440840, user_data = 0x7ffddf21ae40}, {pos = -315468184, events = 32726, fd = 0, user_data = 0x55ba05023540}, {pos = -65806129, events = 21945, fd = 32768, user_data = 0x1}, {pos = 84038000, events = 21946, fd = -1, user_data = 0x7fd6eba2e020}, {pos = -319628784, events = 32726, fd = 83750392, user_data = 0x55ba04fdecd8}, {pos = 84217985, events = 21946, fd = -315617602, user_data = 0x1}, {pos = -315469088, events = 32726, fd = 436, user_data = 0x55b9fc672da0 }, {pos = 0, events = 0, fd = 0, user_data = 0xf9}, {pos = -315617602, events = 32726, fd = 1, user_data = 0x0}, {pos = -341647328, events = 32726, fd = -340840832, user_data = 0x10}, {pos = -551439728, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -315608390, user_data = 0x0}, {pos = -341119532, events = 32726, fd = 0, user_data = 0x55b9fcd4bd80 }, {pos = 2, events = 0, fd = 0, user_data = 0x55ba04fde870}, {pos = -69638493, events = 21945, fd = 84238075, user_data = 0x55b9fbd9a4c3 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55ba05023540}, {pos = -315617602, events = 32726, fd = 1, user_data = 0x0}, {pos = -341613368, events = 32726, fd = -341194624, user_data = 0x44e}, {pos = -341086051, events = 32726, fd = 2, user_data = 0x55ba05055ea0}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -339796896, events = 32726, fd = 255, user_data = 0xfffffffffffffee8}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x377a54482d737365}, {pos = 168446026, events = 538976288, fd = 822763892, user_data = 0x30340a3336383531}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55ba04fdead0}, {pos = -66133264, events = 21945, fd = 1024, user_data = 0x7fd6ebab58ee}, {pos = -339813920, events = 32726, fd = -341175954, user_data = 0x100000400}, {pos = 7, events = 0, fd = 84218016, user_data = 0x8154de7f8b435400}, {pos = -339810848, events = 32726, fd = -336, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 3, events = 0, fd = 0, user_data = 0x69b1}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x11a}, {pos = -340840301, events = 32726, fd = 83749584, user_data = 0x1}, {pos = 83749784, events = 21946, fd = 1024, user_data = 0x7ffddf21b368}, {pos = -66052115, events = 21945, fd = -53061968, user_data = 0x55b9fc0f0aa1 }, {pos = 83749584, events = 21946, fd = 84030336, user_data = 0x55ba04fdead0}, {pos = -341092114, events = 32726, fd = 0, user_data = 0x55b9fc102714 }, {pos = 83749584, events = 1, fd = -66049955, user_data = 0x55ba05023380}, {pos = -341169487, events = 32726, fd = -341175056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1958521856, events = 2169822847, fd = 83748976, user_data = 0x8154de7f8b435400}, {pos = 13, events = 0, fd = -1958521856, user_data = 0x0}, {pos = -341462471, events = 32726, fd = 0, user_data = 0x55b9fbc9c6e0 }, {pos = 4194304, events = 0, fd = 83864240, user_data = 0x1}, {pos = 0, events = 0, fd = 83748976, user_data = 0x55b9fc0f0935 }, {pos = 83864240, events = 21946, fd = 84030336, user_data = 0x55ba04ffaab0}, {pos = 1, events = 0, fd = 0, user_data = 0x55b9fc0aeb74 }, {pos = 13, events = 0, fd = 84209352, user_data = 0x55ba0504eea8}, {pos = -53165288, events = 21945, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -70661990, user_data = 0x55ba05023380}, {pos = -70645082, events = 21945, fd = -56860816, user_data = 0x55ba05023d58}} [06:59:28.851] nevents = 1 [06:59:28.851] __func__ = "ServerLoop" [06:59:28.851] #25 0x000055b9fbca5d4e in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55ba04fe14b0) at ../src/backend/postmaster/postmaster.c:1400 [06:59:28.851] opt = [06:59:28.851] status = [06:59:28.851] userDoption = [06:59:28.851] listen_addr_saved = false [06:59:28.851] output_config_variable = [06:59:28.851] __func__ = "PostmasterMain" [06:59:28.851] #26 0x000055b9fbad21aa in main (argc=8, argv=0x55ba04fe14b0) at ../src/backend/main/main.c:227 [06:59:28.851] do_check_root = [06:59:28.851] dispatch_option = [06:59:28.870] -e [06:59:28.870] [06:59:28.870] [06:59:28.939] dumping /tmp/cores/postgres-6-35838.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:59:29.204] [New LWP 35838] [06:59:29.204] [06:59:29.204] This GDB supports auto-downloading debuginfo from the following URLs: [06:59:29.204] [06:59:29.204] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [06:59:29.204] Debuginfod has been disabled. [06:59:29.204] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [06:59:29.308] [Thread debugging using libthread_db enabled] [06:59:29.308] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [06:59:29.308] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [06:59:29.308] Program terminated with signal SIGABRT, Aborted. [06:59:29.308] #0 0x00007fcba2ca9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:29.370] [06:59:29.370] Thread 1 (Thread 0x7fcba0a22a80 (LWP 35838)): [06:59:29.370] #0 0x00007fcba2ca9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:29.370] No symbol table info available. [06:59:29.370] #1 0x00007fcba2c5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:29.370] No symbol table info available. [06:59:29.370] #2 0x00007fcba2c45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [06:59:29.370] No symbol table info available. [06:59:29.370] #3 0x00007fcba2e1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [06:59:29.370] No locals. [06:59:29.370] #4 0x00007fcba2e2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [06:59:29.370] No locals. [06:59:29.370] #5 0x00007fcba2e0dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x55f9ea42ce00, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [06:59:29.370] bp = 140732452357504 [06:59:29.370] pc = [06:59:29.370] Opts = {FromUnrecoverableHandler = true, pc = 94531850643500, bp = 18446744073709551615} [06:59:29.370] #6 0x000055f9e960a82c in get_notnull_info (winobj=winobj@entry=0x55fa21d06888, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3464 [06:59:29.370] mb = [06:59:29.370] bpos = 0 [06:59:29.370] #7 0x000055f9e96153c8 in WinGetFuncArgInPartition (winobj=winobj@entry=0x55fa21d06888, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7ffed3d4c62f, isout=0x7ffed3d4c62e) at ../src/backend/executor/nodeWindowAgg.c:3742 [06:59:29.370] winstate = [06:59:29.370] abs_pos = -1 [06:59:29.370] datum = 0 [06:59:29.370] null_treatment = true [06:59:29.370] notnull_offset = 0 [06:59:29.370] notnull_relpos = 1 [06:59:29.370] forward = -1 [06:59:29.370] __func__ = "WinGetFuncArgInPartition" [06:59:29.370] #8 0x000055f9e9bd903f in leadlag_common (fcinfo=0x7ffed3d4c670, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [06:59:29.370] winobj = 0x55fa21d06888 [06:59:29.370] offset = [06:59:29.370] const_offset = [06:59:29.370] result = [06:59:29.370] isnull = true [06:59:29.370] isout = true [06:59:29.370] #9 0x000055f9e9bd9e37 in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [06:59:29.370] No locals. [06:59:29.370] #10 0x000055f9e960b39c in eval_windowfunction (winstate=winstate@entry=0x55fa21cacda8, perfuncstate=0x55fa21d06618, result=0x55fa21caea28, isnull=0x55fa21d1a5a2) at ../src/backend/executor/nodeWindowAgg.c:1088 [06:59:29.370] fcinfodata = {fcinfo = {flinfo = 0x55fa21d06630, context = 0x55fa21d06888, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7ffed3d4c690}, fcinfo_data = "0f\320!\372U\000\000\210h\320!\372U", '\000' , "U\001\000\000\000\000\000\000\000\000\000\001ξ!\372U\000\000(\217ۖ \000\000\000 \000\000\000\001\000\000\000X\274\274!\372U\000\000߇\224\351\343\327Cd\230\002", '\000' , "\b\234\276\351\371U\000\000\250\372֖\313\177\000\000\250\372֖\313\177\000\000\260\372֖ \000\000\000 \000\000\000\371U\000\000Ɨ\327*\000\000\000\000\310\360\276\351\371U\000\000\001\000\000\000\372U\000\000\341\241\276\351\371U\000\000\2503\216\352\371U\000\000\b\234\276\351\371U\000\000@8Ŗ\313\177\000\000\0308Ŗ\313\177\000\000\330s\300"...} [06:59:29.370] fcinfo = 0x7ffed3d4c670 [06:59:29.370] oldContext = 0x55fa21caca40 [06:59:29.370] #11 0x000055f9e961453d in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [06:59:29.370] perfuncstate = [06:59:29.370] winstate = 0x55fa21cacda8 [06:59:29.370] slot = [06:59:29.370] econtext = 0x55fa21cad318 [06:59:29.370] i = 2 [06:59:29.370] numfuncs = 3 [06:59:29.370] __func__ = "ExecWindowAgg" [06:59:29.370] #12 0x000055f9e957e0b0 in ExecProcNodeFirst (node=0x55fa21cacda8) at ../src/backend/executor/execProcnode.c:469 [06:59:29.370] No locals. [06:59:29.370] #13 0x000055f9e9568483 in ExecProcNode (node=node@entry=0x55fa21cacda8) at ../src/include/executor/executor.h:313 [06:59:29.370] No locals. [06:59:29.370] #14 0x000055f9e9568e3d in ExecutePlan (queryDesc=queryDesc@entry=0x55fa21bb6540, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55fa21d8e8e0) at ../src/backend/executor/execMain.c:1679 [06:59:29.370] estate = 0x55fa21cacb40 [06:59:29.370] planstate = 0x55fa21cacda8 [06:59:29.370] use_parallel_mode = false [06:59:29.370] slot = [06:59:29.370] current_tuple_count = 0 [06:59:29.370] #15 0x000055f9e956a5cd in standard_ExecutorRun (queryDesc=0x55fa21bb6540, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:367 [06:59:29.370] estate = 0x55fa21cacb40 [06:59:29.370] operation = CMD_SELECT [06:59:29.370] dest = 0x55fa21d8e8e0 [06:59:29.370] sendTuples = [06:59:29.370] oldcontext = 0x55fa21bb6440 [06:59:29.370] #16 0x000055f9e956a62d in ExecutorRun (queryDesc=queryDesc@entry=0x55fa21bb6540, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:304 [06:59:29.370] No locals. [06:59:29.370] #17 0x000055f9e998a0d4 in PortalRunSelect (portal=portal@entry=0x55fa21c0dfe0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55fa21d8e8e0) at ../src/backend/tcop/pquery.c:921 [06:59:29.370] queryDesc = 0x55fa21bb6540 [06:59:29.370] direction = [06:59:29.370] nprocessed = [06:59:29.370] __func__ = "PortalRunSelect" [06:59:29.370] #18 0x000055f9e998d4cc in PortalRun (portal=portal@entry=0x55fa21c0dfe0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55fa21d8e8e0, altdest=altdest@entry=0x55fa21d8e8e0, qc=qc@entry=0x7ffed3d4cfc0) at ../src/backend/tcop/pquery.c:765 [06:59:29.370] _save_exception_stack = 0x7ffed3d4d070 [06:59:29.370] _save_context_stack = 0x0 [06:59:29.370] _local_sigjmp_buf = {{__jmpbuf = {0, 8052106245250660628, 94532796473312, 94532795935560, 94532795935536, 94532795935488, 4302969471103842580, 8050539990176151828}, __mask_was_saved = 0, __saved_mask = {__val = {94531857345089, 3553939279, 4, 94532795935488, 112, 179, 94532796473312, 94532795935560, 94532795935536, 94532795935488, 94531857432814, 1, 2, 179, 94531846429763, 0}}}} [06:59:29.370] _do_rethrow = [06:59:29.370] result = [06:59:29.370] nprocessed = [06:59:29.370] saveTopTransactionResourceOwner = 0x55fa21bcaa98 [06:59:29.370] saveTopTransactionContext = 0x55fa21c1bf20 [06:59:29.370] saveActivePortal = 0x0 [06:59:29.370] saveResourceOwner = 0x55fa21bcaa98 [06:59:29.370] savePortalContext = 0x0 [06:59:29.370] saveMemoryContext = 0x55fa21c1bf20 [06:59:29.370] __func__ = "PortalRun" [06:59:29.370] #19 0x000055f9e99862ac in exec_simple_query (query_string=query_string@entry=0x55fa21b89050 "SELECT name,\n orbit,\n lag(orbit) OVER w AS lag,\n lag(orbit) RESPECT NULLS OVER w AS lag_respect,\n lag(orbit) IGNORE NULLS OVER w AS lag_ignore\nFROM planets\nWINDOW w AS (ORDER B"...) at ../src/backend/tcop/postgres.c:1273 [06:59:29.370] cmdtaglen = 6 [06:59:29.370] snapshot_set = [06:59:29.370] per_parsetree_context = 0x0 [06:59:29.370] plantree_list = 0x55fa21d8f070 [06:59:29.370] parsetree = 0x55fa21b8ab00 [06:59:29.370] commandTag = [06:59:29.370] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:59:29.370] querytree_list = [06:59:29.370] portal = 0x55fa21c0dfe0 [06:59:29.370] receiver = 0x55fa21d8e8e0 [06:59:29.370] format = 0 [06:59:29.370] cmdtagname = [06:59:29.370] parsetree_item__state = [06:59:29.370] dest = DestRemote [06:59:29.370] oldcontext = 0x55fa21c1bf20 [06:59:29.370] parsetree_list = 0x55fa21b8ab30 [06:59:29.370] parsetree_item = 0x55fa21b8ab48 [06:59:29.370] save_log_statement_stats = false [06:59:29.370] was_logged = false [06:59:29.370] use_implicit_block = false [06:59:29.370] msec_str = "\300\241_\352\371U\000\000\200\005\305\351\371U\000\000P\320\324\323\376\177\000\000\322\000\000\000\000\000\000" [06:59:29.370] __func__ = "exec_simple_query" [06:59:29.370] #20 0x000055f9e99894f5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [06:59:29.370] query_string = 0x55fa21b89050 "SELECT name,\n orbit,\n lag(orbit) OVER w AS lag,\n lag(orbit) RESPECT NULLS OVER w AS lag_respect,\n lag(orbit) IGNORE NULLS OVER w AS lag_ignore\nFROM planets\nWINDOW w AS (ORDER B"... [06:59:29.370] firstchar = [06:59:29.370] input_message = {data = 0x55fa21b89050 "SELECT name,\n orbit,\n lag(orbit) OVER w AS lag,\n lag(orbit) RESPECT NULLS OVER w AS lag_respect,\n lag(orbit) IGNORE NULLS OVER w AS lag_ignore\nFROM planets\nWINDOW w AS (ORDER B"..., len = 210, maxlen = 1024, cursor = 210} [06:59:29.370] local_sigjmp_buf = {{__jmpbuf = {94531870414584, 8050542064537876756, 4, 94531867353536, 24, 5, 4302969471439386900, 8050539987768490260}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94532795659536, 16128, 94531870408608, 94532796193360, 24, 94531857345005, 0, 9, 2, 94531870414592, 94532795659536, 94531870408608, 94531867353536, 24, 5}}}} [06:59:29.370] send_ready_for_query = false [06:59:29.370] idle_in_transaction_timeout_enabled = false [06:59:29.370] idle_session_timeout_enabled = false [06:59:29.370] __func__ = "PostgresMain" [06:59:29.370] #21 0x000055f9e997ee0d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [06:59:29.370] bsdata = [06:59:29.370] #22 0x000055f9e981c9fa in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7ffed3d4d1d0, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffed3d4d240) at ../src/backend/postmaster/launch_backend.c:290 [06:59:29.370] pid = [06:59:29.370] #23 0x000055f9e9821fbe in BackendStartup (client_sock=client_sock@entry=0x7ffed3d4d240) at ../src/backend/postmaster/postmaster.c:3580 [06:59:29.370] bn = 0x55fa21bb1608 [06:59:29.370] pid = [06:59:29.370] startup_data = {canAcceptConnections = CAC_OK, socket_created = 803631125030325, fork_started = 803631125030328} [06:59:29.370] cac = [06:59:29.370] __func__ = "BackendStartup" [06:59:29.370] #24 0x000055f9e98244ea in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [06:59:29.370] s = {sock = 140, raddr = {addr = {ss_family = 1, __ss_padding = "\225\350\371U\000\000\340̐\350\371U\000\000\200\323\324\323\376\177\000\000x\323\324\323\376\177\000\000\225[\362\001\000\000\000\000pz\250\243\313\177\000\000-", '\000' , "\240\322\324\323\376\177\000\000\000\004\000\000\000\000\000\000\270\323\324\323\376\177\000\000\000\367\206\346\366\233\345SpH\264!", '\000' , __ss_align = 67}, salen = 2}} [06:59:29.370] i = 0 [06:59:29.370] now = [06:59:29.370] last_lockfile_recheck_time = 1750315924 [06:59:29.370] last_touch_time = 1750315864 [06:59:29.370] events = {{pos = 1, events = 2, fd = 138, user_data = 0x0}, {pos = 0, events = 0, fd = -741026816, user_data = 0x0}, {pos = 17, events = 0, fd = -1549239280, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fcba44ef2e0}, {pos = -741026952, events = 32766, fd = -741026944, user_data = 0x7fcba44ef668}, {pos = 0, events = 0, fd = 1, user_data = 0x1}, {pos = 565743720, events = 22010, fd = 1, user_data = 0x55fa21b89068}, {pos = -1, events = 0, fd = -1564286944, user_data = 0x7fcba4130a10}, {pos = 565751040, events = 22010, fd = -1563497051, user_data = 0x7ffed3d4d8d3}, {pos = 139, events = 0, fd = -741026880, user_data = 0x7fcba44ef2e0}, {pos = 436, events = 0, fd = -367055456, user_data = 0x0}, {pos = 0, events = 0, fd = 229, user_data = 0x7fcba44caebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fcba2c2e020}, {pos = -1563480448, events = 32715, fd = 46034513, user_data = 0x7ffed3d4d7f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1538469190, events = 32715, fd = 0, user_data = 0x7fcba2caedd4 }, {pos = 0, events = 0, fd = -359875200, user_data = 0x2}, {pos = 0, events = 0, fd = 565463152, user_data = 0x7fcba2ceeedd }, {pos = 565751648, events = 22010, fd = -376350770, user_data = 0x55fa21bbb9f0}, {pos = 8096, events = 196607, fd = 565951051, user_data = 0x55f9e991a4c3 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x168}, {pos = -367056064, events = 22009, fd = 4, user_data = 0x1}, {pos = 565743720, events = 22010, fd = -1538478402, user_data = 0x1}, {pos = -1563725667, events = 32715, fd = -1564252984, user_data = 0x55fa21bbb9f0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 538976288, user_data = 0x200a20202020200a}, {pos = 0, events = 0, fd = 0, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 565955056, user_data = 0x55f9e9c6da70 }, {pos = 565925904, events = 22010, fd = 1080, user_data = 0x55fa21b44ad0}, {pos = -372841744, events = 22009, fd = 1024, user_data = 0x7fcba2cb58ee}, {pos = -1562453536, events = 32715, fd = -1563815570, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -741025592, events = 32766, fd = -1563721905, user_data = 0x55fa21b44ad0}, {pos = 3, events = 0, fd = 0, user_data = 0x69d1}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x106}, {pos = -1563479917, events = 32715, fd = 565463760, user_data = 0x1}, {pos = 565463960, events = 22010, fd = 1024, user_data = 0x7ffed3d4d8c8}, {pos = -372760595, events = 22009, fd = -359770448, user_data = 0x55f9e9c70aa1 }, {pos = 565463760, events = 22010, fd = 565743440, user_data = 0x55fa21b44ad0}, {pos = -1563731730, events = 32715, fd = 0, user_data = 0x55f9e9c82714 }, {pos = 565463760, events = 1, fd = -372758435, user_data = 0x55fa21b88f50}, {pos = -1563809103, events = 32715, fd = -1563814672, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -427362560, events = 1407556598, fd = 565463152, user_data = 0x53e59bf6e686f700}, {pos = 13, events = 0, fd = -427362560, user_data = 0x0}, {pos = -1564102087, events = 32715, fd = 0, user_data = 0x55f9e981c6e0 }, {pos = 4194304, events = 0, fd = 565577344, user_data = 0x1}, {pos = 0, events = 0, fd = 565463152, user_data = 0x55f9e9c70935 }, {pos = 565577344, events = 22010, fd = 565743440, user_data = 0x55fa21b60680}, {pos = 1, events = 0, fd = 0, user_data = 0x55f9e9c2eb74 }, {pos = 13, events = 0, fd = 565921368, user_data = 0x55fa21bb4638}, {pos = -359873768, events = 22009, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -377370470, user_data = 0x55fa21b88f50}, {pos = -377353562, events = 22009, fd = -363569296, user_data = 0x55fa21b898f8}} [06:59:29.370] nevents = 1 [06:59:29.370] __func__ = "ServerLoop" [06:59:29.370] #25 0x000055f9e9825d4e in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55fa21b47420) at ../src/backend/postmaster/postmaster.c:1400 [06:59:29.370] opt = [06:59:29.370] status = [06:59:29.370] userDoption = [06:59:29.370] listen_addr_saved = false [06:59:29.370] output_config_variable = [06:59:29.370] __func__ = "PostmasterMain" [06:59:29.370] #26 0x000055f9e96521aa in main (argc=4, argv=0x55fa21b47420) at ../src/backend/main/main.c:227 [06:59:29.370] do_check_root = [06:59:29.370] dispatch_option =