[12:26:24.528] src/tools/ci/cores_backtrace.sh linux /tmp/cores [12:26:24.731] dumping /tmp/cores/postgres-6-34307.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:26:24.989] [New LWP 34307] [12:26:24.989] [12:26:24.989] This GDB supports auto-downloading debuginfo from the following URLs: [12:26:24.989] [12:26:24.989] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:26:24.989] Debuginfod has been disabled. [12:26:24.989] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:26:25.106] [Thread debugging using libthread_db enabled] [12:26:25.106] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:26:25.106] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [12:26:25.106] Program terminated with signal SIGABRT, Aborted. [12:26:25.106] #0 0x00007f93194a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:25.198] [12:26:25.198] Thread 1 (Thread 0x7f931741fa80 (LWP 34307)): [12:26:25.198] #0 0x00007f93194a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:25.198] No symbol table info available. [12:26:25.198] #1 0x00007f931945afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:25.198] No symbol table info available. [12:26:25.198] #2 0x00007f9319445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:25.198] No symbol table info available. [12:26:25.198] #3 0x00007f931961e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:26:25.198] No locals. [12:26:25.198] #4 0x00007f931962aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:26:25.198] No locals. [12:26:25.198] #5 0x00007f931960dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x55fe6e225e40, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [12:26:25.198] bp = 140729739466064 [12:26:25.198] pc = [12:26:25.198] Opts = {FromUnrecoverableHandler = true, pc = 94551242980288, bp = 18446744073709551615} [12:26:25.198] #6 0x000055fe6d403bc0 in get_notnull_info (winobj=winobj@entry=0x55fe75382758, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3498 [12:26:25.198] mb = [12:26:25.198] bpos = 0 [12:26:25.198] #7 0x000055fe6d40e7d7 in WinGetFuncArgInPartition (winobj=winobj@entry=0x55fe75382758, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7ffe322155ff, isout=0x7ffe322155fe) at ../src/backend/executor/nodeWindowAgg.c:3776 [12:26:25.198] winstate = [12:26:25.198] abs_pos = -1 [12:26:25.198] datum = 0 [12:26:25.198] null_treatment = true [12:26:25.198] notnull_offset = 0 [12:26:25.198] notnull_relpos = 1 [12:26:25.198] forward = -1 [12:26:25.198] __func__ = "WinGetFuncArgInPartition" [12:26:25.198] #8 0x000055fe6d9d2982 in leadlag_common (fcinfo=0x7ffe32215640, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [12:26:25.198] winobj = 0x55fe75382758 [12:26:25.198] offset = [12:26:25.198] const_offset = [12:26:25.198] result = [12:26:25.198] isnull = true [12:26:25.198] isout = true [12:26:25.198] #9 0x000055fe6d9d377a in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [12:26:25.198] No locals. [12:26:25.198] #10 0x000055fe6d404730 in eval_windowfunction (winstate=winstate@entry=0x55fe752e0eb8, perfuncstate=0x55fe753824e8, result=0x55fe752e2b38, isnull=0x55fe75349f42) at ../src/backend/executor/nodeWindowAgg.c:1088 [12:26:25.198] fcinfodata = {fcinfo = {flinfo = 0x55fe75382500, context = 0x55fe75382758, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7ffe32215660}, fcinfo_data = "\000%8u\376U\000\000X'8u\376U", '\000' , "U\001\000\000\000\000\000\000\000\000\000\001.\"u\376U\000\000\350\375h\r \000\000\000 \000\000\000\001\000\000\0008\017 u\376U\000\000\"!tm\343\327Cd\230\002", '\000' , "K5\236m\376U\000\000\b\021f\r\223\177\000\000\b\021f\r\223\177\000\000\020\021f\r \000\000\000 \000\000\000\376U\000\000Ɨ\327*\000\000\000\000\v\212\236m\376U\000\000\001\000\000\000\376U\000\000$;\236m\376U\000\000\b\310mn\376U\000\000K5\236m\376U\000\000`\357l\r\223\177\000\0008"...} [12:26:25.198] fcinfo = 0x7ffe32215640 [12:26:25.198] oldContext = 0x55fe752e0b50 [12:26:25.198] #11 0x000055fe6d40d8d1 in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [12:26:25.198] perfuncstate = [12:26:25.198] winstate = 0x55fe752e0eb8 [12:26:25.198] slot = [12:26:25.198] econtext = 0x55fe752e1428 [12:26:25.198] i = 2 [12:26:25.198] numfuncs = 3 [12:26:25.198] __func__ = "ExecWindowAgg" [12:26:25.198] #12 0x000055fe6d377444 in ExecProcNodeFirst (node=0x55fe752e0eb8) at ../src/backend/executor/execProcnode.c:469 [12:26:25.198] No locals. [12:26:25.198] #13 0x000055fe6d361817 in ExecProcNode (node=node@entry=0x55fe752e0eb8) at ../src/include/executor/executor.h:313 [12:26:25.198] No locals. [12:26:25.198] #14 0x000055fe6d3621d1 in ExecutePlan (queryDesc=queryDesc@entry=0x55fe75331590, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55fe75345a80) at ../src/backend/executor/execMain.c:1679 [12:26:25.198] estate = 0x55fe752e0c50 [12:26:25.198] planstate = 0x55fe752e0eb8 [12:26:25.198] use_parallel_mode = false [12:26:25.198] slot = [12:26:25.198] current_tuple_count = 0 [12:26:25.198] #15 0x000055fe6d363961 in standard_ExecutorRun (queryDesc=0x55fe75331590, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:367 [12:26:25.198] estate = 0x55fe752e0c50 [12:26:25.198] operation = CMD_SELECT [12:26:25.198] dest = 0x55fe75345a80 [12:26:25.198] sendTuples = [12:26:25.198] oldcontext = 0x55fe75331490 [12:26:25.198] #16 0x000055fe6d3639c1 in ExecutorRun (queryDesc=queryDesc@entry=0x55fe75331590, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:304 [12:26:25.198] No locals. [12:26:25.198] #17 0x000055fe6d783a17 in PortalRunSelect (portal=portal@entry=0x55fe75243fe0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55fe75345a80) at ../src/backend/tcop/pquery.c:921 [12:26:25.198] queryDesc = 0x55fe75331590 [12:26:25.198] direction = [12:26:25.198] nprocessed = [12:26:25.198] __func__ = "PortalRunSelect" [12:26:25.198] #18 0x000055fe6d786e0f in PortalRun (portal=portal@entry=0x55fe75243fe0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55fe75345a80, altdest=altdest@entry=0x55fe75345a80, qc=qc@entry=0x7ffe32215f90) at ../src/backend/tcop/pquery.c:765 [12:26:25.198] _save_exception_stack = 0x7ffe32216040 [12:26:25.198] _save_context_stack = 0x0 [12:26:25.198] _local_sigjmp_buf = {{__jmpbuf = {0, -4208071152920751719, 94551375364064, 94551374826312, 94551374826288, 94551374826240, -7955217595226451559, -4208089330800324199}, __mask_was_saved = 0, __saved_mask = {__val = {94551249683332, 841047839, 4, 94551374826240, 112, 179, 94551375364064, 94551374826312, 94551374826288, 94551374826240, 94551249771057, 1, 2, 179, 94551238765635, 0}}}} [12:26:25.198] _do_rethrow = [12:26:25.198] result = [12:26:25.198] nprocessed = [12:26:25.198] saveTopTransactionResourceOwner = 0x55fe75200a98 [12:26:25.198] saveTopTransactionContext = 0x55fe75258880 [12:26:25.198] saveActivePortal = 0x0 [12:26:25.198] saveResourceOwner = 0x55fe75200a98 [12:26:25.198] savePortalContext = 0x0 [12:26:25.198] saveMemoryContext = 0x55fe75258880 [12:26:25.198] __func__ = "PortalRun" [12:26:25.198] #19 0x000055fe6d77fbef in exec_simple_query (query_string=query_string@entry=0x55fe751bf050 "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 [12:26:25.198] cmdtaglen = 6 [12:26:25.198] snapshot_set = [12:26:25.198] per_parsetree_context = 0x0 [12:26:25.198] plantree_list = 0x55fe75346210 [12:26:25.198] parsetree = 0x55fe751c0b00 [12:26:25.198] commandTag = [12:26:25.198] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:26:25.198] querytree_list = [12:26:25.198] portal = 0x55fe75243fe0 [12:26:25.198] receiver = 0x55fe75345a80 [12:26:25.198] format = 0 [12:26:25.198] cmdtagname = [12:26:25.198] parsetree_item__state = [12:26:25.198] dest = DestRemote [12:26:25.198] oldcontext = 0x55fe75258880 [12:26:25.198] parsetree_list = 0x55fe751c0b30 [12:26:25.198] parsetree_item = 0x55fe751c0b48 [12:26:25.198] save_log_statement_stats = false [12:26:25.198] was_logged = false [12:26:25.198] use_implicit_block = false [12:26:25.198] msec_str = "@5?n\376U\000\000Þ\244m\376U\000\000 `!2\376\177\000\000\322\000\000\000\000\000\000" [12:26:25.198] __func__ = "exec_simple_query" [12:26:25.198] #20 0x000055fe6d782e38 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [12:26:25.198] query_string = 0x55fe751bf050 "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"... [12:26:25.198] firstchar = [12:26:25.198] input_message = {data = 0x55fe751bf050 "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} [12:26:25.198] local_sigjmp_buf = {{__jmpbuf = {94551262751576, -4208091413845962343, 4, 94551259690304, 24, 7, -7955217596501519975, -4208089332684746343}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94551374550288, 16128, 94551262745600, 94551375084112, 24, 94551249683248, 0, 9, 2, 94551262751584, 94551374550288, 94551262745600, 94551259690304, 24, 7}}}} [12:26:25.198] send_ready_for_query = false [12:26:25.198] idle_in_transaction_timeout_enabled = false [12:26:25.198] idle_session_timeout_enabled = false [12:26:25.198] __func__ = "PostgresMain" [12:26:25.198] #21 0x000055fe6d778750 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [12:26:25.198] bsdata = [12:26:25.198] #22 0x000055fe6d61627b in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x7ffe322161a0, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffe32216210) at ../src/backend/postmaster/launch_backend.c:290 [12:26:25.198] pid = [12:26:25.198] #23 0x000055fe6d61b83f in BackendStartup (client_sock=client_sock@entry=0x7ffe32216210) at ../src/backend/postmaster/postmaster.c:3580 [12:26:25.198] bn = 0x55fe751e7668 [12:26:25.198] pid = [12:26:25.198] startup_data = {canAcceptConnections = CAC_OK, socket_created = 804428357832717, fork_started = 804428357832720} [12:26:25.198] cac = [12:26:25.198] __func__ = "BackendStartup" [12:26:25.198] #24 0x000055fe6d61dd6b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [12:26:25.198] s = {sock = 140, raddr = {addr = {ss_family = 1, __ss_padding = "C\031\223\177\000\000\020\212\224\032\223\177\000\000\270b!2\376\177\000\000\264b!2\376\177", '\000' , "\365\204tl\376U\000\000\330Lpl\376U\000\000\200c!2\376\177\000\000xc!2\376\177\000\000\225[\362\001\000\000\000\000p\212(\032\223\177\000\000-", '\000' , "\376U\000\000\003\204tl\376U\000", __ss_align = 140269787870824}, salen = 2}} [12:26:25.198] i = 0 [12:26:25.198] now = [12:26:25.198] last_lockfile_recheck_time = 1751113102 [12:26:25.198] last_touch_time = 1751113102 [12:26:25.198] events = {{pos = 1, events = 2, fd = 138, user_data = 0x0}, {pos = 0, events = 0, fd = 17, user_data = 0x0}, {pos = 450950760, events = 32659, fd = 438864912, user_data = 0x7f931ae0f2e0}, {pos = 2090263927, events = 0, fd = 841049088, user_data = 0x7f931ade4a48}, {pos = 17, events = 0, fd = 438864912, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f931ae0f2e0}, {pos = 841048952, events = 32766, fd = 841048960, user_data = 0x7f931ae0f668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8b}, {pos = 1964772608, events = 22014, fd = 1, user_data = 0x7ffe322168a3}, {pos = -1, events = 0, fd = 423813152, user_data = 0x7f931a948a10}, {pos = 1964486136, events = 22014, fd = 1964485848, user_data = 0x55fe751ec811}, {pos = 450801342, events = 32659, fd = 1, user_data = 0x7f931ae0f2e0}, {pos = 436, events = 0, fd = 1845411232, user_data = 0x0}, {pos = 0, events = 0, fd = 229, user_data = 0x7f931adeaebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f931942e020}, {pos = 424619648, events = 32659, fd = 16, user_data = 0x7ffe322167c0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 450810554, events = 32659, fd = 0, user_data = 0x7f93194aedd4 }, {pos = 0, events = 0, fd = 1852592608, user_data = 0x2}, {pos = 0, events = 0, fd = 1964484720, user_data = 0x55fe6d713e06 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 1964765288, user_data = 0x7f931adeaebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f93194364c8}, {pos = 424374429, events = 32659, fd = 1852688928, user_data = 0x55fe751f19f0}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 425663584, events = 32659, fd = 255, user_data = 0xfffffffffffffee8}, {pos = 1023, 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 = 4294967040, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, 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 = 1024, user_data = 0x7f93194b58ee}, {pos = 425646560, events = 32659, fd = 424284526, user_data = 0x100000400}, {pos = 7, events = 0, fd = 1964951600, user_data = 0x54092bb7d0df6500}, {pos = 425649632, events = 32659, fd = -336, user_data = 0x0}, {pos = 1964485528, events = 22014, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 3, events = 0, fd = 0, user_data = 0x672f}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x106}, {pos = 424620179, events = 32659, fd = 1964485328, user_data = 0x1}, {pos = 1964485528, events = 22014, fd = 1024, user_data = 0x7ffe32216898}, {pos = 1839708464, events = 22014, fd = 1852697360, user_data = 0x55fe6da6a3e4 }, {pos = 1964485328, events = 22014, fd = 1964765008, user_data = 0x55fe7517aad0}, {pos = 424368366, events = 32659, fd = 0, user_data = 0x55fe6da7c057 }, {pos = 1964485328, events = 1, fd = 1839710624, user_data = 0x55fe751bef50}, {pos = 424290993, events = 32659, fd = 424285424, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -790665984, events = 1409887159, fd = 1964484720, user_data = 0x54092bb7d0df6500}, {pos = 13, events = 0, fd = -790665984, user_data = 0x0}, {pos = 423998009, events = 32659, fd = 0, user_data = 0x55fe6d615f61 }, {pos = 4194304, events = 0, fd = 1964598912, user_data = 0x1}, {pos = 0, events = 0, fd = 1964484720, user_data = 0x55fe6da6a278 }, {pos = 1964598912, events = 22014, fd = 1964765008, user_data = 0x55fe75196680}, {pos = 1, events = 0, fd = 0, user_data = 0x55fe6da284b7 }, {pos = 13, events = 0, fd = 1964942936, user_data = 0x55fe751ea638}, {pos = 1852594040, events = 22014, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 1835098395, user_data = 0x55fe751bef50}, {pos = 1835115303, events = 22014, fd = 1848898256, user_data = 0x55fe751bf8f8}} [12:26:25.198] nevents = 1 [12:26:25.198] __func__ = "ServerLoop" [12:26:25.198] #25 0x000055fe6d61f5cf in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55fe7517d420) at ../src/backend/postmaster/postmaster.c:1400 [12:26:25.198] opt = [12:26:25.198] status = [12:26:25.198] userDoption = [12:26:25.198] listen_addr_saved = false [12:26:25.198] output_config_variable = [12:26:25.198] __func__ = "PostmasterMain" [12:26:25.198] #26 0x000055fe6d44b5b9 in main (argc=4, argv=0x55fe7517d420) at ../src/backend/main/main.c:227 [12:26:25.198] do_check_root = [12:26:25.198] dispatch_option = [12:26:25.218] -e [12:26:25.218] [12:26:25.218] [12:26:25.306] dumping /tmp/cores/postgres-6-45348.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:26:25.561] [New LWP 45348] [12:26:25.561] [12:26:25.561] This GDB supports auto-downloading debuginfo from the following URLs: [12:26:25.561] [12:26:25.561] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:26:25.561] Debuginfod has been disabled. [12:26:25.561] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:26:25.667] [Thread debugging using libthread_db enabled] [12:26:25.667] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:26:25.667] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [12:26:25.667] Program terminated with signal SIGABRT, Aborted. [12:26:25.667] #0 0x00007fc428ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:25.740] [12:26:25.740] Thread 1 (Thread 0x7fc429633a80 (LWP 45348)): [12:26:25.740] #0 0x00007fc428ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:25.740] No symbol table info available. [12:26:25.740] #1 0x00007fc428e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:25.740] No symbol table info available. [12:26:25.740] #2 0x00007fc428e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:25.740] No symbol table info available. [12:26:25.740] #3 0x00007fc42901e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:26:25.740] No locals. [12:26:25.740] #4 0x00007fc42902aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:26:25.740] No locals. [12:26:25.740] #5 0x00007fc42900dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x55e046839e40, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [12:26:25.740] bp = 140735782586128 [12:26:25.740] pc = [12:26:25.740] Opts = {FromUnrecoverableHandler = true, pc = 94421729246144, bp = 18446744073709551615} [12:26:25.740] #6 0x000055e045a17bc0 in get_notnull_info (winobj=winobj@entry=0x55e062860fb8, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3498 [12:26:25.740] mb = [12:26:25.740] bpos = 0 [12:26:25.740] #7 0x000055e045a227d7 in WinGetFuncArgInPartition (winobj=winobj@entry=0x55e062860fb8, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7fff9a5407bf, isout=0x7fff9a5407be) at ../src/backend/executor/nodeWindowAgg.c:3776 [12:26:25.740] winstate = [12:26:25.740] abs_pos = -1 [12:26:25.740] datum = 0 [12:26:25.740] null_treatment = true [12:26:25.740] notnull_offset = 0 [12:26:25.740] notnull_relpos = 1 [12:26:25.740] forward = -1 [12:26:25.740] __func__ = "WinGetFuncArgInPartition" [12:26:25.740] #8 0x000055e045fe6982 in leadlag_common (fcinfo=0x7fff9a540800, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [12:26:25.740] winobj = 0x55e062860fb8 [12:26:25.740] offset = [12:26:25.740] const_offset = [12:26:25.740] result = [12:26:25.740] isnull = true [12:26:25.740] isout = true [12:26:25.740] #9 0x000055e045fe777a in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [12:26:25.740] No locals. [12:26:25.740] #10 0x000055e045a18730 in eval_windowfunction (winstate=winstate@entry=0x55e0627d8f18, perfuncstate=0x55e062860d48, result=0x55e0627dab98, isnull=0x55e06286c812) at ../src/backend/executor/nodeWindowAgg.c:1088 [12:26:25.740] fcinfodata = {fcinfo = {flinfo = 0x55e062860d60, context = 0x55e062860fb8, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7fff9a540820}, fcinfo_data = "`\r\206b\340U\000\000\270\017\206b\340U", '\000' , "\377\001\000\000\000\000\000\000\000\000\000\001\264ob\340U\000\000\000\000\000\000\340U\000\000N<\361E\340U\000\000\377\377\377\377\377\377\377\377pR~b\340U\000\000\000\000\000\000\000\000\000\000x\264ob\340U\000\000\200V~b\340U\000\000\260\bT\232\377\177\000\000", '\377' , "\000\000\000\000\000\000\000\000x\264ob\340U\000\000\200V~b\340U\000\000N<\361E\340U\000\000\000\000\000\000\000\000i@pR~b\340U", '\000' , "\220\212@\340\236\207b\340U\000\000"...} [12:26:25.740] fcinfo = 0x7fff9a540800 [12:26:25.740] oldContext = 0x55e0627d8bb0 [12:26:25.740] #11 0x000055e045a218d1 in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [12:26:25.740] perfuncstate = [12:26:25.740] winstate = 0x55e0627d8f18 [12:26:25.740] slot = [12:26:25.740] econtext = 0x55e0627d9488 [12:26:25.740] i = 2 [12:26:25.740] numfuncs = 3 [12:26:25.740] __func__ = "ExecWindowAgg" [12:26:25.740] #12 0x000055e04598b444 in ExecProcNodeFirst (node=0x55e0627d8f18) at ../src/backend/executor/execProcnode.c:469 [12:26:25.740] No locals. [12:26:25.740] #13 0x000055e045975817 in ExecProcNode (node=node@entry=0x55e0627d8f18) at ../src/include/executor/executor.h:313 [12:26:25.740] No locals. [12:26:25.740] #14 0x000055e0459761d1 in ExecutePlan (queryDesc=queryDesc@entry=0x55e0628176e0, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55e06287a9f0) at ../src/backend/executor/execMain.c:1679 [12:26:25.740] estate = 0x55e0627d8cb0 [12:26:25.740] planstate = 0x55e0627d8f18 [12:26:25.740] use_parallel_mode = false [12:26:25.740] slot = [12:26:25.740] current_tuple_count = 0 [12:26:25.740] #15 0x000055e045977961 in standard_ExecutorRun (queryDesc=queryDesc@entry=0x55e0628176e0, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:367 [12:26:25.740] estate = 0x55e0627d8cb0 [12:26:25.740] operation = CMD_SELECT [12:26:25.740] dest = 0x55e06287a9f0 [12:26:25.740] sendTuples = [12:26:25.740] oldcontext = 0x55e0628175e0 [12:26:25.740] #16 0x00007fc4265d5805 in pgss_ExecutorRun (queryDesc=0x55e0628176e0, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1035 [12:26:25.740] _save_exception_stack = 0x7fff9a541140 [12:26:25.740] _save_context_stack = 0x0 [12:26:25.740] _local_sigjmp_buf = {{__jmpbuf = {94422212778736, -5276319930152178078, 0, 1, 94422212258640, 94422212258592, -2091553344853692830, -2121697614419906974}, __mask_was_saved = 0, __saved_mask = {__val = {94421735944657, 1180563200, 94421735949188, 1653051848, 2, 0, 94422212871440, 94422212871440, 1, 1, 94422212258640, 94422212258592, 94421736034726, 0, 94421736190039, 94422212871440}}}} [12:26:25.740] _do_rethrow = false [12:26:25.740] #17 0x000055e0459779b7 in ExecutorRun (queryDesc=queryDesc@entry=0x55e0628176e0, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:302 [12:26:25.740] No locals. [12:26:25.740] #18 0x000055e045d97a17 in PortalRunSelect (portal=portal@entry=0x55e062739af0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55e06287a9f0) at ../src/backend/tcop/pquery.c:921 [12:26:25.740] queryDesc = 0x55e0628176e0 [12:26:25.740] direction = [12:26:25.740] nprocessed = [12:26:25.740] __func__ = "PortalRunSelect" [12:26:25.740] #19 0x000055e045d9ae0f in PortalRun (portal=portal@entry=0x55e062739af0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55e06287a9f0, altdest=altdest@entry=0x55e06287a9f0, qc=qc@entry=0x7fff9a541260) at ../src/backend/tcop/pquery.c:765 [12:26:25.740] _save_exception_stack = 0x7fff9a541310 [12:26:25.740] _save_context_stack = 0x0 [12:26:25.740] _local_sigjmp_buf = {{__jmpbuf = {0, -5276319944414908830, 94422212778736, 94422212258664, 94422212258640, 94422212258592, -2091553345753371038, -5276265707646407070}, __mask_was_saved = 0, __saved_mask = {__val = {94421735949188, 2589200879, 4, 94422212258592, 112, 179, 94422212778736, 94422212258664, 94422212258640, 94422212258592, 94421736036913, 1, 2, 179, 94421725031491, 0}}}} [12:26:25.740] _do_rethrow = [12:26:25.740] result = [12:26:25.740] nprocessed = [12:26:25.740] saveTopTransactionResourceOwner = 0x55e0626fd508 [12:26:25.740] saveTopTransactionContext = 0x55e0627503e0 [12:26:25.740] saveActivePortal = 0x0 [12:26:25.740] saveResourceOwner = 0x55e0626fd508 [12:26:25.740] savePortalContext = 0x0 [12:26:25.740] saveMemoryContext = 0x55e0627503e0 [12:26:25.740] __func__ = "PortalRun" [12:26:25.740] #20 0x000055e045d93bef in exec_simple_query (query_string=query_string@entry=0x55e0626b9070 "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 [12:26:25.740] cmdtaglen = 6 [12:26:25.740] snapshot_set = [12:26:25.740] per_parsetree_context = 0x0 [12:26:25.740] plantree_list = 0x55e06287b180 [12:26:25.740] parsetree = 0x55e0626bab20 [12:26:25.740] commandTag = [12:26:25.740] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:26:25.740] querytree_list = [12:26:25.740] portal = 0x55e062739af0 [12:26:25.740] receiver = 0x55e06287a9f0 [12:26:25.740] format = 0 [12:26:25.740] cmdtagname = [12:26:25.740] parsetree_item__state = [12:26:25.740] dest = DestRemote [12:26:25.740] oldcontext = 0x55e0627503e0 [12:26:25.740] parsetree_list = 0x55e0626bab50 [12:26:25.740] parsetree_item = 0x55e0626bab68 [12:26:25.740] save_log_statement_stats = false [12:26:25.740] was_logged = true [12:26:25.740] use_implicit_block = false [12:26:25.740] msec_str = "@u\240F\340U\000\000\303\336\005F\340U\000\000\360\022T\232\377\177\000\000\322\000\000\000\000\000\000" [12:26:25.740] __func__ = "exec_simple_query" [12:26:25.740] #21 0x000055e045d96e38 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [12:26:25.740] query_string = 0x55e0626b9070 "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"... [12:26:25.740] firstchar = [12:26:25.740] input_message = {data = 0x55e0626b9070 "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} [12:26:25.740] local_sigjmp_buf = {{__jmpbuf = {94421749017432, -5276258994615800222, 4, 94421745956160, 24, 7, -2091553345820479902, -5276265710055117214}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94422212506800, 0, 168, 94421735949658, 0, 10, 2, 94421749017440, 94422211982672, 94421749011456, 94421745956160, 24, 7}}}} [12:26:25.740] send_ready_for_query = false [12:26:25.740] idle_in_transaction_timeout_enabled = false [12:26:25.740] idle_session_timeout_enabled = false [12:26:25.740] __func__ = "PostgresMain" [12:26:25.740] #22 0x000055e045d8c750 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [12:26:25.740] bsdata = [12:26:25.740] #23 0x000055e045c2a27b in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x7fff9a541470, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7fff9a5414e0) at ../src/backend/postmaster/launch_backend.c:290 [12:26:25.740] pid = [12:26:25.740] #24 0x000055e045c2f83f in BackendStartup (client_sock=client_sock@entry=0x7fff9a5414e0) at ../src/backend/postmaster/postmaster.c:3580 [12:26:25.740] bn = 0x55e0626e4868 [12:26:25.740] pid = [12:26:25.740] startup_data = {canAcceptConnections = CAC_OK, socket_created = 804428423861376, fork_started = 804428423861378} [12:26:25.740] cac = [12:26:25.740] __func__ = "BackendStartup" [12:26:25.740] #25 0x000055e045c31d6b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [12:26:25.740] s = {sock = 62, raddr = {addr = {ss_family = 1, __ss_padding = "T\232\377\177\000\000t\025T\232\377\177", '\000' , "\365\304\325D\340U\000\000،\321D\340U\000\000@\026T\232\377\177\000\0008\026T\232\377\177\000\000\225[\362\001\000\000\000\000@, "\003\304\325D\340U\000\000h\246\200*\304\177\000\000\020\\d)\304\177\000", __ss_align = 140480503390944}, salen = 2}} [12:26:25.740] i = 0 [12:26:25.740] now = [12:26:25.740] last_lockfile_recheck_time = 1751113168 [12:26:25.740] last_touch_time = 1751113168 [12:26:25.740] events = {{pos = 1, events = 2, fd = 60, user_data = 0x0}, {pos = 0, events = 0, fd = 713074280, user_data = 0x0}, {pos = 713073376, events = 32708, fd = 2090263927, user_data = 0x7fff9a5416c0}, {pos = 712899144, events = 32708, fd = 17, user_data = 0x7fc429645c10}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 713073376, events = 32708, fd = -1705765320, user_data = 0x7fff9a541640}, {pos = 713074280, events = 32708, fd = 0, user_data = 0x55e0626e6758}, {pos = 1175239186, events = 21984, fd = 32768, user_data = 0x1}, {pos = 1651219344, events = 21984, fd = -1, user_data = 0x7fc428e2e020}, {pos = 708065808, events = 32708, fd = 1650937336, user_data = 0x55e062674cd8}, {pos = 1651413425, events = 21984, fd = 712924862, user_data = 0x1}, {pos = 713073376, events = 32708, fd = 436, user_data = 0x55e0465ffda0 }, {pos = 0, events = 0, fd = 0, user_data = 0x56}, {pos = 712924862, events = 32708, fd = 1, user_data = 0x0}, {pos = 685957152, events = 32708, fd = 686763648, user_data = 0x10}, {pos = -1705764208, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 712934074, user_data = 0x0}, {pos = 686484948, events = 32708, fd = 0, user_data = 0x55e046cd91e0 }, {pos = 2, events = 0, fd = 0, user_data = 0x55e062674870}, {pos = 1171406822, events = 21984, fd = 1651432331, user_data = 0x55e045d27e06 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55e0626e6758}, {pos = 712924862, events = 32708, fd = 1, user_data = 0x0}, {pos = 685991112, events = 32708, fd = 686409856, user_data = 0x44e}, {pos = 686518071, events = 32708, fd = 2, user_data = 0x1010}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 687807584, events = 32708, fd = 255, user_data = 0xfffffffffffffee8}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 694446720, user_data = 0x7fc429646fc0}, {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 = 0x55e062674ad0}, {pos = 1174912051, events = 21984, fd = 1024, user_data = 0x7fc428eb58ee}, {pos = 687790560, events = 32708, fd = 686428526, user_data = 0x100000400}, {pos = 7, events = 0, fd = 1651432240, user_data = 0x866f4f4fc92a9a00}, {pos = 687793632, events = 32708, 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 = 0x8eff}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x77}, {pos = 686764179, events = 32708, fd = 1650936528, user_data = 0x1}, {pos = 1650936728, events = 21984, fd = 1024, user_data = 0x7fff9a541b68}, {pos = 1174993200, events = 21984, fd = 1187982096, user_data = 0x55e04607e3e4 }, {pos = 1650936528, events = 21984, fd = 1651216240, user_data = 0x55e062674ad0}, {pos = 686512027, events = 32708, fd = 0, user_data = 0x55e046090057 }, {pos = 1650936528, events = 1, fd = 1174995360, user_data = 0x55e0626b8f70}, {pos = 686434993, events = 32708, fd = 686429424, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -919954944, events = 2255441743, fd = 1650935920, user_data = 0x866f4f4fc92a9a00}, {pos = 13, events = 0, fd = -919954944, user_data = 0x0}, {pos = 686142009, events = 32708, fd = 0, user_data = 0x55e045c29f61 }, {pos = 4194304, events = 0, fd = 1651050144, user_data = 0x1}, {pos = 0, events = 0, fd = 1650935920, user_data = 0x55e04607e278 }, {pos = 1651050144, events = 21984, fd = 1651216240, user_data = 0x55e0626906a0}, {pos = 1, events = 0, fd = 0, user_data = 0x55e04603c4b7 }, {pos = 13, events = 0, fd = 1651400072, user_data = 0x55e0626e5d68}, {pos = 1187878776, events = 21984, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 1170383131, user_data = 0x55e0626b8f70}, {pos = 1170400039, events = 21984, fd = 1184182992, user_data = 0x55e0626b9928}} [12:26:25.740] nevents = 1 [12:26:25.740] __func__ = "ServerLoop" [12:26:25.740] #26 0x000055e045c335cf in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55e062677450) at ../src/backend/postmaster/postmaster.c:1400 [12:26:25.740] opt = [12:26:25.740] status = [12:26:25.740] userDoption = [12:26:25.740] listen_addr_saved = false [12:26:25.740] output_config_variable = [12:26:25.740] __func__ = "PostmasterMain" [12:26:25.740] #27 0x000055e045a5f5b9 in main (argc=4, argv=0x55e062677450) at ../src/backend/main/main.c:227 [12:26:25.740] do_check_root = [12:26:25.740] dispatch_option = [12:26:25.760] -e [12:26:25.760] [12:26:25.760] [12:26:25.828] dumping /tmp/cores/postgres-6-34031.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [12:26:26.093] [New LWP 34031] [12:26:26.093] [12:26:26.093] This GDB supports auto-downloading debuginfo from the following URLs: [12:26:26.093] [12:26:26.093] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:26:26.093] Debuginfod has been disabled. [12:26:26.093] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:26:26.202] [Thread debugging using libthread_db enabled] [12:26:26.202] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:26:26.202] Core was generated by `postgres: postgres regression [local] SELECT '. [12:26:26.202] Program terminated with signal SIGABRT, Aborted. [12:26:26.202] #0 0x00007ff2b30a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:26.261] [12:26:26.261] Thread 1 (Thread 0x7ff2b0c2ca80 (LWP 34031)): [12:26:26.261] #0 0x00007ff2b30a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:26.261] No symbol table info available. [12:26:26.261] #1 0x00007ff2b305afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:26.261] No symbol table info available. [12:26:26.261] #2 0x00007ff2b3045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:26:26.261] No symbol table info available. [12:26:26.261] #3 0x00007ff2b321e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:26:26.261] No locals. [12:26:26.261] #4 0x00007ff2b322aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:26:26.261] No locals. [12:26:26.261] #5 0x00007ff2b320dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x55dc49aece40, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [12:26:26.261] bp = 140727004235664 [12:26:26.261] pc = [12:26:26.261] Opts = {FromUnrecoverableHandler = true, pc = 94404602538944, bp = 18446744073709551615} [12:26:26.261] #6 0x000055dc48ccabc0 in get_notnull_info (winobj=winobj@entry=0x55dc84929668, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3498 [12:26:26.261] mb = [12:26:26.261] bpos = 0 [12:26:26.261] #7 0x000055dc48cd57d7 in WinGetFuncArgInPartition (winobj=winobj@entry=0x55dc84929668, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7ffd8f19083f, isout=0x7ffd8f19083e) at ../src/backend/executor/nodeWindowAgg.c:3776 [12:26:26.261] winstate = [12:26:26.261] abs_pos = -1 [12:26:26.261] datum = 0 [12:26:26.261] null_treatment = true [12:26:26.261] notnull_offset = 0 [12:26:26.261] notnull_relpos = 1 [12:26:26.261] forward = -1 [12:26:26.261] __func__ = "WinGetFuncArgInPartition" [12:26:26.261] #8 0x000055dc49299982 in leadlag_common (fcinfo=0x7ffd8f190880, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [12:26:26.261] winobj = 0x55dc84929668 [12:26:26.261] offset = [12:26:26.261] const_offset = [12:26:26.261] result = [12:26:26.261] isnull = true [12:26:26.261] isout = true [12:26:26.261] #9 0x000055dc4929a77a in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [12:26:26.261] No locals. [12:26:26.261] #10 0x000055dc48ccb730 in eval_windowfunction (winstate=winstate@entry=0x55dc848b4a68, perfuncstate=0x55dc849293f8, result=0x55dc848b66e8, isnull=0x55dc8491ee82) at ../src/backend/executor/nodeWindowAgg.c:1088 [12:26:26.261] fcinfodata = {fcinfo = {flinfo = 0x55dc84929410, context = 0x55dc84929668, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7ffd8f1908a0}, fcinfo_data = "\020\224\222\204\334U\000\000h\226\222\204\334U", '\000' , "\377\001\000\000\000\000\000\000\000\000\000\001.}\204\334U\000\000\000\000\000\000\334U\000\000Nl\034I\334U\000\000\377\377\377\377\377\377\377\377\300\r\214\204\334U\000\000\000\000\000\000\000\000\000\000\310.}\204\334U\000\000\320\021\214\204\334U\000\0000\t\031\217\375\177\000\000", '\377' , "\000\000\000\000\000\000\000\000\310.}\204\334U\000\000\320\021\214\204\334U\000\000Nl\034I\334U\000\000\001\000\000\000\334U\000\000\300\r\214\204\334U\000\000\b8\372I\334U\000\000K\245*I\334U\000\000`_\352\246\362\177\000\000"...} [12:26:26.261] fcinfo = 0x7ffd8f190880 [12:26:26.261] oldContext = 0x55dc848b4700 [12:26:26.261] #11 0x000055dc48cd48d1 in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [12:26:26.261] perfuncstate = [12:26:26.261] winstate = 0x55dc848b4a68 [12:26:26.261] slot = [12:26:26.261] econtext = 0x55dc848b4fd8 [12:26:26.261] i = 2 [12:26:26.261] numfuncs = 3 [12:26:26.261] __func__ = "ExecWindowAgg" [12:26:26.261] #12 0x000055dc48c3e444 in ExecProcNodeFirst (node=0x55dc848b4a68) at ../src/backend/executor/execProcnode.c:469 [12:26:26.261] No locals. [12:26:26.261] #13 0x000055dc48c28817 in ExecProcNode (node=node@entry=0x55dc848b4a68) at ../src/include/executor/executor.h:313 [12:26:26.261] No locals. [12:26:26.261] #14 0x000055dc48c291d1 in ExecutePlan (queryDesc=queryDesc@entry=0x55dc848f3c30, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55dc8490d110) at ../src/backend/executor/execMain.c:1679 [12:26:26.261] estate = 0x55dc848b4800 [12:26:26.261] planstate = 0x55dc848b4a68 [12:26:26.261] use_parallel_mode = false [12:26:26.261] slot = [12:26:26.261] current_tuple_count = 0 [12:26:26.261] #15 0x000055dc48c2a961 in standard_ExecutorRun (queryDesc=0x55dc848f3c30, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:367 [12:26:26.261] estate = 0x55dc848b4800 [12:26:26.261] operation = CMD_SELECT [12:26:26.261] dest = 0x55dc8490d110 [12:26:26.261] sendTuples = [12:26:26.261] oldcontext = 0x55dc848f3b30 [12:26:26.261] #16 0x000055dc48c2a9c1 in ExecutorRun (queryDesc=queryDesc@entry=0x55dc848f3c30, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:304 [12:26:26.261] No locals. [12:26:26.261] #17 0x000055dc4904aa17 in PortalRunSelect (portal=portal@entry=0x55dc84817990, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55dc8490d110) at ../src/backend/tcop/pquery.c:921 [12:26:26.261] queryDesc = 0x55dc848f3c30 [12:26:26.261] direction = [12:26:26.261] nprocessed = [12:26:26.261] __func__ = "PortalRunSelect" [12:26:26.261] #18 0x000055dc4904de0f in PortalRun (portal=portal@entry=0x55dc84817990, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55dc8490d110, altdest=altdest@entry=0x55dc8490d110, qc=qc@entry=0x7ffd8f1911d0) at ../src/backend/tcop/pquery.c:765 [12:26:26.261] _save_exception_stack = 0x7ffd8f191280 [12:26:26.261] _save_context_stack = 0x0 [12:26:26.261] _local_sigjmp_buf = {{__jmpbuf = {0, -961106345666631280, 94405604243856, 94405603704696, 94405603704672, 94405603704624, -6418929309019625072, -961256875363096176}, __mask_was_saved = 0, __saved_mask = {__val = {94404609241988, 2400784735, 4, 94405603704624, 112, 179, 94405604243856, 94405603704696, 94405603704672, 94405603704624, 94404609329713, 1, 2, 179, 94404598324291, 0}}}} [12:26:26.261] _do_rethrow = [12:26:26.261] result = [12:26:26.261] nprocessed = [12:26:26.261] saveTopTransactionResourceOwner = 0x55dc847d5758 [12:26:26.261] saveTopTransactionContext = 0x55dc8482c640 [12:26:26.261] saveActivePortal = 0x0 [12:26:26.261] saveResourceOwner = 0x55dc847d5758 [12:26:26.261] savePortalContext = 0x0 [12:26:26.261] saveMemoryContext = 0x55dc8482c640 [12:26:26.261] __func__ = "PortalRun" [12:26:26.261] #19 0x000055dc49046bef in exec_simple_query (query_string=query_string@entry=0x55dc84792480 "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 [12:26:26.261] cmdtaglen = 6 [12:26:26.261] snapshot_set = [12:26:26.261] per_parsetree_context = 0x0 [12:26:26.261] plantree_list = 0x55dc8490d8a0 [12:26:26.261] parsetree = 0x55dc84793f30 [12:26:26.261] commandTag = [12:26:26.261] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:26:26.261] querytree_list = [12:26:26.261] portal = 0x55dc84817990 [12:26:26.261] receiver = 0x55dc8490d110 [12:26:26.261] format = 0 [12:26:26.261] cmdtagname = [12:26:26.261] parsetree_item__state = [12:26:26.261] dest = DestRemote [12:26:26.261] oldcontext = 0x55dc8482c640 [12:26:26.261] parsetree_list = 0x55dc84793f60 [12:26:26.261] parsetree_item = 0x55dc84793f78 [12:26:26.261] save_log_statement_stats = false [12:26:26.261] was_logged = false [12:26:26.261] use_implicit_block = false [12:26:26.261] msec_str = "@\245\313I\334U\000\000\303\0161I\334U\000\000`\022\031\217\375\177\000\000\322\000\000\000\000\000\000" [12:26:26.261] __func__ = "exec_simple_query" [12:26:26.261] #20 0x000055dc49049e38 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [12:26:26.261] query_string = 0x55dc84792480 "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"... [12:26:26.261] firstchar = [12:26:26.261] input_message = {data = 0x55dc84792480 "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} [12:26:26.261] local_sigjmp_buf = {{__jmpbuf = {94404622310232, -961258984163333744, 4, 94404619248960, 24, 20, -6418929308952516208, -961256877769184880}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94405603427664, 17408, 94404622304256, 94405603962624, 24, 94404609241904, 0, 10, 2, 94404622310240, 94405603427664, 94404622304256, 94404619248960, 24, 20}}}} [12:26:26.261] send_ready_for_query = false [12:26:26.261] idle_in_transaction_timeout_enabled = false [12:26:26.261] idle_session_timeout_enabled = false [12:26:26.261] __func__ = "PostgresMain" [12:26:26.261] #21 0x000055dc4903f750 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [12:26:26.261] bsdata = [12:26:26.261] #22 0x000055dc48edd27b in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x7ffd8f1913e0, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffd8f191450) at ../src/backend/postmaster/launch_backend.c:290 [12:26:26.261] pid = [12:26:26.261] #23 0x000055dc48ee283f in BackendStartup (client_sock=client_sock@entry=0x7ffd8f191450) at ../src/backend/postmaster/postmaster.c:3580 [12:26:26.261] bn = 0x55dc847bad88 [12:26:26.261] pid = [12:26:26.261] startup_data = {canAcceptConnections = CAC_OK, socket_created = 804428355095987, fork_started = 804428355095992} [12:26:26.261] cac = [12:26:26.261] __func__ = "BackendStartup" [12:26:26.261] #24 0x000055dc48ee4d6b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [12:26:26.261] s = {sock = 151, raddr = {addr = {ss_family = 1, __ss_padding = "\003\263\362\177\000\000\020\272T\264\362\177\000\000\370\024\031\217\375\177\000\000\364\024\031\217\375\177", '\000' , "\365\364\000H\334U\000\000ؼ\374G\334U\000\000\300\025\031\217\375\177\000\000\270\025\031\217\375\177\000\000\225[\362\001\000\000\000\000p\n\003\261\362\177\000\000-", '\000' , "\334U\000\000\003\364\000H\334U\000", __ss_align = 140680388580968}, salen = 2}} [12:26:26.261] i = 0 [12:26:26.261] now = [12:26:26.261] last_lockfile_recheck_time = 1751113101 [12:26:26.261] last_touch_time = 1751113101 [12:26:26.261] events = {{pos = 1, events = 2, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = 17, user_data = 0x0}, {pos = -1265199512, events = 32754, fd = -1325200368, user_data = 0x7ff2b49692e0}, {pos = 2090263927, events = 0, fd = -1894181312, user_data = 0x7ff2b493ea48}, {pos = 17, events = 0, fd = -1325200368, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7ff2b49692e0}, {pos = -1894181448, events = 32765, fd = -1894181440, user_data = 0x7ff2b4969668}, {pos = 0, events = 0, fd = 32768, user_data = 0x96}, {pos = -2072428176, events = 21980, fd = 1, user_data = 0x7ffd8f191ae3}, {pos = -1, events = 0, fd = -1291657184, user_data = 0x7ff2b454ba10}, {pos = -2072715784, events = 21980, fd = -2072716072, user_data = 0x55dc847c0081}, {pos = -1265348930, events = 32754, fd = 1, user_data = 0x7ff2b49692e0}, {pos = 436, events = 0, fd = 1233857952, user_data = 0x0}, {pos = 0, events = 0, fd = 249, user_data = 0x7ff2b4944ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7ff2b302e020}, {pos = -1290850688, events = 32754, fd = 16, user_data = 0x7ffd8f191a00}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1265339718, events = 32754, fd = 0, user_data = 0x7ff2b30aedd4 }, {pos = 0, events = 0, fd = 1241039328, user_data = 0x2}, {pos = 0, events = 0, fd = -2072717200, user_data = 0x55dc48fdae06 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = -2072435392, user_data = 0x7ff2b4944ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7ff2b30364c8}, {pos = -1291095907, events = 32754, fd = 1241135648, user_data = 0x55dc847c4ea0}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -1289806752, events = 32754, fd = 255, user_data = 0xfffffffffffffee8}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x202020200a0a7837}, {pos = 822763892, events = 825308471, fd = 808530737, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {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 = 1024, user_data = 0x7ff2b30b58ee}, {pos = -1289823776, events = 32754, fd = -1291185810, user_data = 0x100000400}, {pos = 7, events = 0, fd = -2072248160, user_data = 0xadc882a5d2cb0000}, {pos = -1289820704, events = 32754, fd = -336, user_data = 0x0}, {pos = -2072716392, events = 21980, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 3, events = 0, fd = 0, user_data = 0x671d}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x11a}, {pos = -1290850157, events = 32754, fd = -2072716592, user_data = 0x1}, {pos = -2072716392, events = 21980, fd = 1024, user_data = 0x7ffd8f191ad8}, {pos = 1228155184, events = 21980, fd = 1241144080, user_data = 0x55dc493313e4 }, {pos = -2072716592, events = 21980, fd = -2072435840, user_data = 0x55dc8474dad0}, {pos = -1291101970, events = 32754, fd = 0, user_data = 0x55dc49343057 }, {pos = -2072716592, events = 1, fd = 1228157344, user_data = 0x55dc84792380}, {pos = -1291179343, events = 32754, fd = -1291184912, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -758448128, events = 2915599013, fd = -2072717200, user_data = 0xadc882a5d2cb0000}, {pos = 13, events = 0, fd = -758448128, user_data = 0x0}, {pos = -1291472327, events = 32754, fd = 0, user_data = 0x55dc48edcf61 }, {pos = 4194304, events = 0, fd = -2072601936, user_data = 0x1}, {pos = 0, events = 0, fd = -2072717200, user_data = 0x55dc49331278 }, {pos = -2072601936, events = 21980, fd = -2072435840, user_data = 0x55dc84769ab0}, {pos = 1, events = 0, fd = 0, user_data = 0x55dc492ef4b7 }, {pos = 13, events = 0, fd = -2072256824, user_data = 0x55dc847bdea8}, {pos = 1241040760, events = 21980, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 1223545115, user_data = 0x55dc84792380}, {pos = 1223562023, events = 21980, fd = 1237344976, user_data = 0x55dc84792d58}} [12:26:26.262] nevents = 1 [12:26:26.262] __func__ = "ServerLoop" [12:26:26.262] #25 0x000055dc48ee65cf in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55dc847504b0) at ../src/backend/postmaster/postmaster.c:1400 [12:26:26.262] opt = [12:26:26.262] status = [12:26:26.262] userDoption = [12:26:26.262] listen_addr_saved = false [12:26:26.262] output_config_variable = [12:26:26.262] __func__ = "PostmasterMain" [12:26:26.262] #26 0x000055dc48d125b9 in main (argc=8, argv=0x55dc847504b0) at ../src/backend/main/main.c:227 [12:26:26.262] do_check_root = [12:26:26.262] dispatch_option =