[09:16:32.984] src/tools/ci/cores_backtrace.sh linux /tmp/cores [09:16:33.199] dumping /tmp/cores/postgres-6-35276.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:16:33.471] [New LWP 35276] [09:16:33.471] [09:16:33.471] This GDB supports auto-downloading debuginfo from the following URLs: [09:16:33.471] [09:16:33.471] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:16:33.471] Debuginfod has been disabled. [09:16:33.471] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:16:33.585] [Thread debugging using libthread_db enabled] [09:16:33.585] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:16:33.585] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [09:16:33.585] Program terminated with signal SIGABRT, Aborted. [09:16:33.585] #0 0x00007f2c42ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:33.678] [09:16:33.678] Thread 1 (Thread 0x7f2c40e1ca80 (LWP 35276)): [09:16:33.678] #0 0x00007f2c42ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:33.678] No symbol table info available. [09:16:33.678] #1 0x00007f2c42e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:33.678] No symbol table info available. [09:16:33.678] #2 0x00007f2c42e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:33.678] No symbol table info available. [09:16:33.678] #3 0x00007f2c4301e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:16:33.678] No locals. [09:16:33.678] #4 0x00007f2c4302aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:16:33.678] No locals. [09:16:33.678] #5 0x00007f2c4300dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x56219db11e00, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [09:16:33.678] bp = 140724551711760 [09:16:33.678] pc = [09:16:33.678] Opts = {FromUnrecoverableHandler = true, pc = 94702364719334, bp = 18446744073709551615} [09:16:33.678] #6 0x000056219ccef8e6 in get_notnull_info (winobj=winobj@entry=0x5621aba26458, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3464 [09:16:33.678] mb = [09:16:33.678] bpos = 0 [09:16:33.678] #7 0x000056219ccfa482 in WinGetFuncArgInPartition (winobj=winobj@entry=0x5621aba26458, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7ffcfcea7cbf, isout=0x7ffcfcea7cbe) at ../src/backend/executor/nodeWindowAgg.c:3742 [09:16:33.678] winstate = [09:16:33.678] abs_pos = -1 [09:16:33.678] datum = 0 [09:16:33.678] null_treatment = true [09:16:33.678] notnull_offset = 0 [09:16:33.678] notnull_relpos = 1 [09:16:33.678] forward = -1 [09:16:33.678] __func__ = "WinGetFuncArgInPartition" [09:16:33.678] #8 0x000056219d2be253 in leadlag_common (fcinfo=0x7ffcfcea7d00, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [09:16:33.678] winobj = 0x5621aba26458 [09:16:33.678] offset = [09:16:33.678] const_offset = [09:16:33.678] result = [09:16:33.678] isnull = true [09:16:33.678] isout = true [09:16:33.678] #9 0x000056219d2bf04b in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [09:16:33.678] No locals. [09:16:33.678] #10 0x000056219ccf0456 in eval_windowfunction (winstate=winstate@entry=0x5621ab9d1db8, perfuncstate=0x5621aba261e8, result=0x5621ab9d3a38, isnull=0x5621aba13402) at ../src/backend/executor/nodeWindowAgg.c:1088 [09:16:33.678] fcinfodata = {fcinfo = {flinfo = 0x5621aba26200, context = 0x5621aba26458, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7ffcfcea7d20}, fcinfo_data = "\000b\242\253!V\000\000Xd\242\253!V", '\000' , "V\001\000\000\000\000\000\000\000\000\000\001\036\221\253!V\000\000\270\301\0037 \000\000\000 \000\000\000\001\000\000\000H\n\217\253!V\000\000\363\331\002\235\343\327Cd\230\002", '\000' , "\034\356,\235!V\000\000\350\345\3776,\177\000\000\350\345\3776,\177\000\000\360\345\3776 \000\000\000 \000\000\000!V\000\000Ɨ\327*\000\000\000\000\334B-\235!V\000\000\001\000\000\000!V\000\000\365\363,\235!V\000\000\350\204\374\235!V\000\000\034\356,\235!V\000\000\240\215\3556,\177\000\000x"...} [09:16:33.678] fcinfo = 0x7ffcfcea7d00 [09:16:33.678] oldContext = 0x5621ab9d1a50 [09:16:33.678] #11 0x000056219ccf95f7 in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [09:16:33.678] perfuncstate = [09:16:33.678] winstate = 0x5621ab9d1db8 [09:16:33.678] slot = [09:16:33.678] econtext = 0x5621ab9d2328 [09:16:33.678] i = 2 [09:16:33.678] numfuncs = 3 [09:16:33.678] __func__ = "ExecWindowAgg" [09:16:33.678] #12 0x000056219cc6316a in ExecProcNodeFirst (node=0x5621ab9d1db8) at ../src/backend/executor/execProcnode.c:469 [09:16:33.678] No locals. [09:16:33.678] #13 0x000056219cc4d53d in ExecProcNode (node=node@entry=0x5621ab9d1db8) at ../src/include/executor/executor.h:313 [09:16:33.678] No locals. [09:16:33.678] #14 0x000056219cc4def7 in ExecutePlan (queryDesc=queryDesc@entry=0x5621ab97f470, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x5621aba394b0) at ../src/backend/executor/execMain.c:1679 [09:16:33.678] estate = 0x5621ab9d1b50 [09:16:33.678] planstate = 0x5621ab9d1db8 [09:16:33.678] use_parallel_mode = false [09:16:33.678] slot = [09:16:33.678] current_tuple_count = 0 [09:16:33.678] #15 0x000056219cc4f687 in standard_ExecutorRun (queryDesc=0x5621ab97f470, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:367 [09:16:33.678] estate = 0x5621ab9d1b50 [09:16:33.678] operation = CMD_SELECT [09:16:33.678] dest = 0x5621aba394b0 [09:16:33.678] sendTuples = [09:16:33.678] oldcontext = 0x5621ab97f370 [09:16:33.678] #16 0x000056219cc4f6e7 in ExecutorRun (queryDesc=queryDesc@entry=0x5621ab97f470, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:304 [09:16:33.678] No locals. [09:16:33.678] #17 0x000056219d06f2e8 in PortalRunSelect (portal=portal@entry=0x5621ab932fe0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x5621aba394b0) at ../src/backend/tcop/pquery.c:921 [09:16:33.678] queryDesc = 0x5621ab97f470 [09:16:33.678] direction = [09:16:33.678] nprocessed = [09:16:33.678] __func__ = "PortalRunSelect" [09:16:33.678] #18 0x000056219d0726e0 in PortalRun (portal=portal@entry=0x5621ab932fe0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5621aba394b0, altdest=altdest@entry=0x5621aba394b0, qc=qc@entry=0x7ffcfcea8650) at ../src/backend/tcop/pquery.c:765 [09:16:33.678] _save_exception_stack = 0x7ffcfcea8700 [09:16:33.678] _save_context_stack = 0x0 [09:16:33.678] _local_sigjmp_buf = {{__jmpbuf = {0, 6589483917842098942, 94702612459488, 94702611921736, 94702611921712, 94702611921664, 632793302046911230, 6589577679685593854}, __mask_was_saved = 0, __saved_mask = {__val = {94702371421269, 4243228127, 4, 94702611921664, 112, 179, 94702612459488, 94702611921736, 94702611921712, 94702611921664, 94702371508994, 1, 2, 179, 94702360505411, 0}}}} [09:16:33.678] _do_rethrow = [09:16:33.678] result = [09:16:33.678] nprocessed = [09:16:33.678] saveTopTransactionResourceOwner = 0x5621ab8efa98 [09:16:33.678] saveTopTransactionContext = 0x5621ab940f20 [09:16:33.678] saveActivePortal = 0x0 [09:16:33.678] saveResourceOwner = 0x5621ab8efa98 [09:16:33.678] savePortalContext = 0x0 [09:16:33.678] saveMemoryContext = 0x5621ab940f20 [09:16:33.678] __func__ = "PortalRun" [09:16:33.678] #19 0x000056219d06b4c0 in exec_simple_query (query_string=query_string@entry=0x5621ab8ae050 "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 [09:16:33.678] cmdtaglen = 6 [09:16:33.678] snapshot_set = [09:16:33.678] per_parsetree_context = 0x0 [09:16:33.678] plantree_list = 0x5621aba39c40 [09:16:33.678] parsetree = 0x5621ab8afb00 [09:16:33.678] commandTag = [09:16:33.678] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:16:33.678] querytree_list = [09:16:33.678] portal = 0x5621ab932fe0 [09:16:33.678] receiver = 0x5621aba394b0 [09:16:33.678] format = 0 [09:16:33.678] cmdtagname = [09:16:33.678] parsetree_item__state = [09:16:33.678] dest = DestRemote [09:16:33.678] oldcontext = 0x5621ab940f20 [09:16:33.678] parsetree_list = 0x5621ab8afb30 [09:16:33.678] parsetree_item = 0x5621ab8afb48 [09:16:33.678] save_log_statement_stats = false [09:16:33.678] was_logged = false [09:16:33.678] use_implicit_block = false [09:16:33.678] msec_str = "\000\363͝!V\000\000\224W3\235!V\000\000\340\206\352\374\374\177\000\000\322\000\000\000\000\000\000" [09:16:33.678] __func__ = "exec_simple_query" [09:16:33.678] #20 0x000056219d06e709 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [09:16:33.678] query_string = 0x5621ab8ae050 "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"... [09:16:33.678] firstchar = [09:16:33.678] input_message = {data = 0x5621ab8ae050 "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} [09:16:33.678] local_sigjmp_buf = {{__jmpbuf = {94702384490552, 6589575544956824318, 4, 94702381429504, 24, 14, 632793302114020094, 6589577691740154622}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94702611645712, 16128, 94702384484576, 94702612179536, 24, 94702371421185, 0, 9, 2, 94702384490560, 94702611645712, 94702384484576, 94702381429504, 24, 14}}}} [09:16:33.678] send_ready_for_query = false [09:16:33.678] idle_in_transaction_timeout_enabled = false [09:16:33.678] idle_session_timeout_enabled = false [09:16:33.678] __func__ = "PostgresMain" [09:16:33.678] #21 0x000056219d064021 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [09:16:33.678] bsdata = [09:16:33.678] #22 0x000056219cf01c0e in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x7ffcfcea8860, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffcfcea88d0) at ../src/backend/postmaster/launch_backend.c:290 [09:16:33.678] pid = [09:16:33.678] #23 0x000056219cf071d2 in BackendStartup (client_sock=client_sock@entry=0x7ffcfcea88d0) at ../src/backend/postmaster/postmaster.c:3580 [09:16:33.678] bn = 0x5621ab8d67b8 [09:16:33.678] pid = [09:16:33.678] startup_data = {canAcceptConnections = CAC_OK, socket_created = 803812141897088, fork_started = 803812141897094} [09:16:33.678] cac = [09:16:33.678] __func__ = "BackendStartup" [09:16:33.678] #24 0x000056219cf096fe in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [09:16:33.678] s = {sock = 140, raddr = {addr = {ss_family = 1, __ss_padding = "\343B,\177\000\000\020Z5D,\177\000\000x\211\352\374\374\177\000\000t\211\352\374\374\177", '\000' , "\365T\003\234!V\000\000\330\034\377\233!V\000\000@\212\352\374\374\177\000\0008\212\352\374\374\177\000\000\225[\362\001\000\000\000\000p\272cC,\177\000\000-", '\000' , "!V\000\000\003T\003\234!V\000", __ss_align = 139828103951976}, salen = 2}} [09:16:33.678] i = 0 [09:16:33.678] now = [09:16:33.678] last_lockfile_recheck_time = 1750496882 [09:16:33.678] last_touch_time = 1750496882 [09:16:33.678] events = {{pos = 1, events = 2, fd = 138, user_data = 0x0}, {pos = 0, events = 0, fd = 138, user_data = 0x0}, {pos = 1148663400, events = 32556, fd = 1130609680, user_data = 0x7f2c447732e0}, {pos = 2090263927, events = 0, fd = -51737920, user_data = 0x7f2c44748a48}, {pos = 17, events = 0, fd = 1130609680, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f2c447732e0}, {pos = -51738056, events = 32764, fd = -51738048, user_data = 0x7f2c44773668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8b}, {pos = -1416954624, events = 22049, fd = 1, user_data = 0x7ffcfcea8f63}, {pos = -1, events = 0, fd = 1122164768, user_data = 0x7f2c44355a10}, {pos = -1417241096, events = 22049, fd = -1417241384, user_data = 0x5621ab8db811}, {pos = 1148513982, events = 32556, fd = 1, user_data = 0x7f2c447732e0}, {pos = 436, events = 0, fd = -1651671648, user_data = 0x0}, {pos = 0, events = 0, fd = 229, user_data = 0x7f2c4474eebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f2c42e2e020}, {pos = 1122971264, events = 32556, fd = 16, user_data = 0x7ffcfcea8e80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1148523194, events = 32556, fd = 0, user_data = 0x7f2c42eaedd4 }, {pos = 0, events = 0, fd = -1644491072, user_data = 0x2}, {pos = 0, events = 0, fd = -1417242512, user_data = 0x56219cfff6d7 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -1416961944, user_data = 0x7f2c4474eebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f2c42e364c8}, {pos = 1122726045, events = 32556, fd = -1644394752, user_data = 0x5621ab8e09f0}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 1124015200, events = 32556, fd = 255, user_data = 0xfffffffffffffee8}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffff0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, 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 = 0x7f2c42eb58ee}, {pos = 1123998176, events = 32556, fd = 1122636142, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1416775632, user_data = 0x196e4bab56e3fb00}, {pos = 1124001248, events = 32556, fd = -336, user_data = 0x0}, {pos = -1417241704, events = 22049, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 3, events = 0, fd = 0, user_data = 0x6af1}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x106}, {pos = 1122971795, events = 32556, fd = -1417241904, user_data = 0x1}, {pos = -1417241704, events = 22049, fd = 1024, user_data = 0x7ffcfcea8f58}, {pos = -1657376255, events = 22049, fd = -1644386320, user_data = 0x56219d355cb5 }, {pos = -1417241904, events = 22049, fd = -1416962224, user_data = 0x5621ab869ad0}, {pos = 1122719982, events = 32556, fd = 0, user_data = 0x56219d367928 }, {pos = -1417241904, events = 1, fd = -1657374095, user_data = 0x5621ab8adf50}, {pos = 1122642609, events = 32556, fd = 1122637040, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1457781504, events = 426658731, fd = -1417242512, user_data = 0x196e4bab56e3fb00}, {pos = 13, events = 0, fd = 1457781504, user_data = 0x0}, {pos = 1122349625, events = 32556, fd = 0, user_data = 0x56219cf018f4 }, {pos = 4194304, events = 0, fd = -1417128320, user_data = 0x1}, {pos = 0, events = 0, fd = -1417242512, user_data = 0x56219d355b49 }, {pos = -1417128320, events = 22049, fd = -1416962224, user_data = 0x5621ab885680}, {pos = 1, events = 0, fd = 0, user_data = 0x56219d313d88 }, {pos = 13, events = 0, fd = -1416784296, user_data = 0x5621ab8d9638}, {pos = -1644489640, events = 22049, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -1661986130, user_data = 0x5621ab8adf50}, {pos = -1661969222, events = 22049, fd = -1648185168, user_data = 0x5621ab8ae8f8}} [09:16:33.678] nevents = 1 [09:16:33.678] __func__ = "ServerLoop" [09:16:33.678] #25 0x000056219cf0af62 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5621ab86c420) at ../src/backend/postmaster/postmaster.c:1400 [09:16:33.678] opt = [09:16:33.678] status = [09:16:33.678] userDoption = [09:16:33.678] listen_addr_saved = false [09:16:33.678] output_config_variable = [09:16:33.678] __func__ = "PostmasterMain" [09:16:33.678] #26 0x000056219cd37264 in main (argc=4, argv=0x5621ab86c420) at ../src/backend/main/main.c:227 [09:16:33.678] do_check_root = [09:16:33.678] dispatch_option = [09:16:33.700] -e [09:16:33.700] [09:16:33.700] [09:16:33.770] dumping /tmp/cores/postgres-6-35030.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:16:34.047] [New LWP 35030] [09:16:34.047] [09:16:34.047] This GDB supports auto-downloading debuginfo from the following URLs: [09:16:34.047] [09:16:34.047] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:16:34.047] Debuginfod has been disabled. [09:16:34.047] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:16:34.159] [Thread debugging using libthread_db enabled] [09:16:34.159] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:16:34.159] Core was generated by `postgres: postgres regression [local] SELECT '. [09:16:34.159] Program terminated with signal SIGABRT, Aborted. [09:16:34.159] #0 0x00007f0891ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:34.223] [09:16:34.223] Thread 1 (Thread 0x7f0892632a80 (LWP 35030)): [09:16:34.223] #0 0x00007f0891ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:34.223] No symbol table info available. [09:16:34.223] #1 0x00007f0891e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:34.223] No symbol table info available. [09:16:34.223] #2 0x00007f0891e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:34.223] No symbol table info available. [09:16:34.223] #3 0x00007f089201e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:16:34.223] No locals. [09:16:34.223] #4 0x00007f089202aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:16:34.223] No locals. [09:16:34.223] #5 0x00007f089200dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x55c8fecaee00, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [09:16:34.223] bp = 140733555843680 [09:16:34.223] pc = [09:16:34.223] Opts = {FromUnrecoverableHandler = true, pc = 94321741711590, bp = 18446744073709551615} [09:16:34.223] #6 0x000055c8fde8c8e6 in get_notnull_info (winobj=winobj@entry=0x55c904781318, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3464 [09:16:34.223] mb = [09:16:34.223] bpos = 0 [09:16:34.223] #7 0x000055c8fde97482 in WinGetFuncArgInPartition (winobj=winobj@entry=0x55c904781318, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7fff159aa30f, isout=0x7fff159aa30e) at ../src/backend/executor/nodeWindowAgg.c:3742 [09:16:34.223] winstate = [09:16:34.223] abs_pos = -1 [09:16:34.223] datum = 0 [09:16:34.223] null_treatment = true [09:16:34.223] notnull_offset = 0 [09:16:34.223] notnull_relpos = 1 [09:16:34.223] forward = -1 [09:16:34.223] __func__ = "WinGetFuncArgInPartition" [09:16:34.223] #8 0x000055c8fe45b253 in leadlag_common (fcinfo=0x7fff159aa350, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [09:16:34.223] winobj = 0x55c904781318 [09:16:34.223] offset = [09:16:34.223] const_offset = [09:16:34.223] result = [09:16:34.223] isnull = true [09:16:34.223] isout = true [09:16:34.223] #9 0x000055c8fe45c04b in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [09:16:34.223] No locals. [09:16:34.223] #10 0x000055c8fde8d456 in eval_windowfunction (winstate=winstate@entry=0x55c9046d7a68, perfuncstate=0x55c9047810a8, result=0x55c9046d96e8, isnull=0x55c904748b02) at ../src/backend/executor/nodeWindowAgg.c:1088 [09:16:34.223] fcinfodata = {fcinfo = {flinfo = 0x55c9047810c0, context = 0x55c904781318, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7fff159aa370}, fcinfo_data = "\300\020x\004\311U\000\000\030\023x\004\311U", '\000' , "\377\001\000\000\000\000\000\000\000\000\000\001^_\004\311U\000\000\000\000\000\000\311U\000\000\037\2058\376\310U\000\000\377\377\377\377\377\377\377\377\300=n\004\311U\000\000\000\000\000\000\000\000\000\000\310^_\004\311U\000\000\320An\004\311U\000\000\000\244\232\025\377\177\000\000", '\377' , "\000\000\000\000\000\000\000\000\310^_\004\311U\000\000\320An\004\311U\000\000\037\2058\376\310U\000\000\001\000\000\000\311U\000\000\300=n\004\311U\000\000\350T\026\377\310U\000\000\034\276F\376\310U\000\000`/ۅ\b\177\000\0008"...} [09:16:34.223] fcinfo = 0x7fff159aa350 [09:16:34.223] oldContext = 0x55c9046d7700 [09:16:34.223] #11 0x000055c8fde965f7 in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [09:16:34.223] perfuncstate = [09:16:34.223] winstate = 0x55c9046d7a68 [09:16:34.223] slot = [09:16:34.223] econtext = 0x55c9046d7fd8 [09:16:34.223] i = 2 [09:16:34.223] numfuncs = 3 [09:16:34.223] __func__ = "ExecWindowAgg" [09:16:34.223] #12 0x000055c8fde0016a in ExecProcNodeFirst (node=0x55c9046d7a68) at ../src/backend/executor/execProcnode.c:469 [09:16:34.223] No locals. [09:16:34.223] #13 0x000055c8fddea53d in ExecProcNode (node=node@entry=0x55c9046d7a68) at ../src/include/executor/executor.h:313 [09:16:34.223] No locals. [09:16:34.223] #14 0x000055c8fddeaef7 in ExecutePlan (queryDesc=queryDesc@entry=0x55c904730150, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55c904744640) at ../src/backend/executor/execMain.c:1679 [09:16:34.223] estate = 0x55c9046d7800 [09:16:34.223] planstate = 0x55c9046d7a68 [09:16:34.223] use_parallel_mode = false [09:16:34.223] slot = [09:16:34.223] current_tuple_count = 0 [09:16:34.223] #15 0x000055c8fddec687 in standard_ExecutorRun (queryDesc=0x55c904730150, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:367 [09:16:34.223] estate = 0x55c9046d7800 [09:16:34.223] operation = CMD_SELECT [09:16:34.223] dest = 0x55c904744640 [09:16:34.223] sendTuples = [09:16:34.223] oldcontext = 0x55c904730050 [09:16:34.223] #16 0x000055c8fddec6e7 in ExecutorRun (queryDesc=queryDesc@entry=0x55c904730150, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:304 [09:16:34.223] No locals. [09:16:34.223] #17 0x000055c8fe20c2e8 in PortalRunSelect (portal=portal@entry=0x55c90463a990, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55c904744640) at ../src/backend/tcop/pquery.c:921 [09:16:34.223] queryDesc = 0x55c904730150 [09:16:34.223] direction = [09:16:34.223] nprocessed = [09:16:34.223] __func__ = "PortalRunSelect" [09:16:34.223] #18 0x000055c8fe20f6e0 in PortalRun (portal=portal@entry=0x55c90463a990, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55c904744640, altdest=altdest@entry=0x55c904744640, qc=qc@entry=0x7fff159aaca0) at ../src/backend/tcop/pquery.c:765 [09:16:34.223] _save_exception_stack = 0x7fff159aad50 [09:16:34.223] _save_context_stack = 0x0 [09:16:34.223] _local_sigjmp_buf = {{__jmpbuf = {0, 6909984076628867320, 94321850427792, 94321849888632, 94321849888608, 94321849888560, 831215628989872376, 6910427562675124472}, __mask_was_saved = 0, __saved_mask = {__val = {94321748413525, 362458159, 4, 94321849888560, 112, 179, 94321850427792, 94321849888632, 94321849888608, 94321849888560, 94321748501250, 1, 2, 179, 94321737497667, 0}}}} [09:16:34.223] _do_rethrow = [09:16:34.223] result = [09:16:34.223] nprocessed = [09:16:34.223] saveTopTransactionResourceOwner = 0x55c9045f8758 [09:16:34.223] saveTopTransactionContext = 0x55c90464f640 [09:16:34.223] saveActivePortal = 0x0 [09:16:34.223] saveResourceOwner = 0x55c9045f8758 [09:16:34.223] savePortalContext = 0x0 [09:16:34.223] saveMemoryContext = 0x55c90464f640 [09:16:34.223] __func__ = "PortalRun" [09:16:34.223] #19 0x000055c8fe2084c0 in exec_simple_query (query_string=query_string@entry=0x55c9045b5480 "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 [09:16:34.223] cmdtaglen = 6 [09:16:34.223] snapshot_set = [09:16:34.223] per_parsetree_context = 0x0 [09:16:34.223] plantree_list = 0x55c904744dd0 [09:16:34.223] parsetree = 0x55c9045b6f30 [09:16:34.223] commandTag = [09:16:34.223] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:16:34.223] querytree_list = [09:16:34.223] portal = 0x55c90463a990 [09:16:34.223] receiver = 0x55c904744640 [09:16:34.223] format = 0 [09:16:34.223] cmdtagname = [09:16:34.223] parsetree_item__state = [09:16:34.223] dest = DestRemote [09:16:34.223] oldcontext = 0x55c90464f640 [09:16:34.223] parsetree_list = 0x55c9045b6f60 [09:16:34.223] parsetree_item = 0x55c9045b6f78 [09:16:34.223] save_log_statement_stats = false [09:16:34.223] was_logged = false [09:16:34.223] use_implicit_block = false [09:16:34.223] msec_str = "\000\303\347\376\310U\000\000\224'M\376\310U\000\0000\255\232\025\377\177\000\000\322\000\000\000\000\000\000" [09:16:34.223] __func__ = "exec_simple_query" [09:16:34.223] #20 0x000055c8fe20b709 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [09:16:34.223] query_string = 0x55c9045b5480 "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"... [09:16:34.223] firstchar = [09:16:34.223] input_message = {data = 0x55c9045b5480 "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} [09:16:34.223] local_sigjmp_buf = {{__jmpbuf = {94321761482808, 6910429671365654776, 4, 94321758421760, 24, 2, 831215628922763512, 6910427565082786040}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94321849611600, 17408, 94321761476832, 94321850146560, 24, 94321748413441, 0, 10, 2, 94321761482816, 94321849611600, 94321761476832, 94321758421760, 24, 2}}}} [09:16:34.223] send_ready_for_query = false [09:16:34.223] idle_in_transaction_timeout_enabled = false [09:16:34.223] idle_session_timeout_enabled = false [09:16:34.223] __func__ = "PostgresMain" [09:16:34.223] #21 0x000055c8fe201021 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [09:16:34.223] bsdata = [09:16:34.223] #22 0x000055c8fe09ec0e in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7fff159aaeb0, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7fff159aaf20) at ../src/backend/postmaster/launch_backend.c:290 [09:16:34.223] pid = [09:16:34.223] #23 0x000055c8fe0a41d2 in BackendStartup (client_sock=client_sock@entry=0x7fff159aaf20) at ../src/backend/postmaster/postmaster.c:3580 [09:16:34.223] bn = 0x55c9045dda28 [09:16:34.223] pid = [09:16:34.223] startup_data = {canAcceptConnections = CAC_OK, socket_created = 803812139814983, fork_started = 803812139814986} [09:16:34.223] cac = [09:16:34.223] __func__ = "BackendStartup" [09:16:34.223] #24 0x000055c8fe0a66fe in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [09:16:34.223] s = {sock = 151, raddr = {addr = {ss_family = 1, __ss_padding = "\232\025\377\177\000\000\264\257\232\025\377\177", '\000' , "\365$\035\375\310U\000\000\330\354\030\375\310U\000\000\200\260\232\025\377\177\000\000x\260\232\025\377\177\000\000\225[\362\001\000\000\000\000p\312f\222\b\177\000\000-", '\000' , "\003$\035\375\310U\000\000hf\207\223\b\177\000\000\020\314f\222\b\177\000", __ss_align = 139674811589344}, salen = 2}} [09:16:34.223] i = 0 [09:16:34.223] now = [09:16:34.223] last_lockfile_recheck_time = 1750496882 [09:16:34.223] last_touch_time = 1750496882 [09:16:34.223] events = {{pos = 1, events = 2, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = 2090263927, user_data = 0x0}, {pos = -1820018104, events = 32520, fd = 17, user_data = 0x7f089266cc10}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1819843872, events = 32520, fd = 362459256, user_data = 0x7fff159ab080}, {pos = -1819842968, events = 32520, fd = 0, user_data = 0x55c9045b5540}, {pos = -28048669, events = 21960, fd = 32768, user_data = 0x1}, {pos = 73101680, events = 21961, fd = -1, user_data = 0x7f0891e2e020}, {pos = -1824851440, events = 32520, fd = 72814072, user_data = 0x55c904570cd8}, {pos = 73281665, events = 21961, fd = -1819992386, user_data = 0x1}, {pos = -1819843872, events = 32520, fd = 436, user_data = 0x55c8fea74da0 }, {pos = 0, events = 0, fd = 0, user_data = 0xf9}, {pos = -1819992386, events = 32520, fd = 1, user_data = 0x0}, {pos = -1847402464, events = 32520, fd = -1846595968, user_data = 0x10}, {pos = 362460368, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1819983174, user_data = 0x0}, {pos = -1846874668, events = 32520, fd = 0, user_data = 0x55c8ff14dec0 }, {pos = 2, events = 0, fd = 0, user_data = 0x55c904570870}, {pos = -31881033, events = 21960, fd = 73301755, user_data = 0x55c8fe19c6d7 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55c9045b5540}, {pos = -1819992386, events = 32520, fd = 1, user_data = 0x0}, {pos = -1847368504, events = 32520, fd = -1846949760, user_data = 0x44e}, {pos = -1846841187, events = 32520, fd = 2, user_data = 0x55c9045e7ea0}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -1845552032, events = 32520, 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 = 0x366f63712d737365}, {pos = 168447541, events = 538976288, fd = 822763892, user_data = 0x30340a3238383639}, {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 = 0x55c904570ad0}, {pos = -28375804, events = 21960, fd = 1024, user_data = 0x7f0891eb58ee}, {pos = -1845569056, events = 32520, fd = -1846931090, user_data = 0x100000400}, {pos = 7, events = 0, fd = 73281696, user_data = 0x3d35e24647b0a800}, {pos = -1845565984, events = 32520, 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 = 0x6ac2}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x11a}, {pos = -1846595437, events = 32520, fd = 72813264, user_data = 0x1}, {pos = 72813464, events = 21961, fd = 1024, user_data = 0x7fff159ab5a8}, {pos = -28294655, events = 21960, fd = -15304720, user_data = 0x55c8fe4f2cb5 }, {pos = 72813264, events = 21961, fd = 73094016, user_data = 0x55c904570ad0}, {pos = -1846847250, events = 32520, fd = 0, user_data = 0x55c8fe504928 }, {pos = 72813264, events = 1, fd = -28292495, user_data = 0x55c9045b5380}, {pos = -1846924623, events = 32520, fd = -1846930192, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1202759680, events = 1026941510, fd = 72812656, user_data = 0x3d35e24647b0a800}, {pos = 13, events = 0, fd = 1202759680, user_data = 0x0}, {pos = -1847217607, events = 32520, fd = 0, user_data = 0x55c8fe09e8f4 }, {pos = 4194304, events = 0, fd = 72927920, user_data = 0x1}, {pos = 0, events = 0, fd = 72812656, user_data = 0x55c8fe4f2b49 }, {pos = 72927920, events = 21961, fd = 73094016, user_data = 0x55c90458cab0}, {pos = 1, events = 0, fd = 0, user_data = 0x55c8fe4b0d88 }, {pos = 13, events = 0, fd = 73273032, user_data = 0x55c9045e0ea8}, {pos = -15408040, events = 21960, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -32904530, user_data = 0x55c9045b5380}, {pos = -32887622, events = 21960, fd = -19103568, user_data = 0x55c9045b5d58}} [09:16:34.223] nevents = 1 [09:16:34.223] __func__ = "ServerLoop" [09:16:34.223] #25 0x000055c8fe0a7f62 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55c9045734b0) at ../src/backend/postmaster/postmaster.c:1400 [09:16:34.223] opt = [09:16:34.223] status = [09:16:34.223] userDoption = [09:16:34.223] listen_addr_saved = false [09:16:34.223] output_config_variable = [09:16:34.223] __func__ = "PostmasterMain" [09:16:34.223] #26 0x000055c8fded4264 in main (argc=8, argv=0x55c9045734b0) at ../src/backend/main/main.c:227 [09:16:34.223] do_check_root = [09:16:34.223] dispatch_option = [09:16:34.245] -e [09:16:34.245] [09:16:34.245] [09:16:34.345] dumping /tmp/cores/postgres-6-46812.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:16:34.606] [New LWP 46812] [09:16:34.606] [09:16:34.606] This GDB supports auto-downloading debuginfo from the following URLs: [09:16:34.606] [09:16:34.606] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:16:34.606] Debuginfod has been disabled. [09:16:34.606] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:16:34.714] [Thread debugging using libthread_db enabled] [09:16:34.714] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:16:34.714] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [09:16:34.714] Program terminated with signal SIGABRT, Aborted. [09:16:34.714] #0 0x00007f6288ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:34.791] [09:16:34.791] Thread 1 (Thread 0x7f628963fa80 (LWP 46812)): [09:16:34.791] #0 0x00007f6288ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:34.791] No symbol table info available. [09:16:34.791] #1 0x00007f6288e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:34.791] No symbol table info available. [09:16:34.791] #2 0x00007f6288e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:16:34.791] No symbol table info available. [09:16:34.791] #3 0x00007f628901e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:16:34.791] No locals. [09:16:34.791] #4 0x00007f628902aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:16:34.791] No locals. [09:16:34.791] #5 0x00007f628900dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x5634b773be00, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [09:16:34.791] bp = 140726601529296 [09:16:34.791] pc = [09:16:34.791] Opts = {FromUnrecoverableHandler = true, pc = 94784401283302, bp = 18446744073709551615} [09:16:34.791] #6 0x00005634b69198e6 in get_notnull_info (winobj=winobj@entry=0x5634bb160e68, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3464 [09:16:34.791] mb = [09:16:34.791] bpos = 0 [09:16:34.791] #7 0x00005634b6924482 in WinGetFuncArgInPartition (winobj=winobj@entry=0x5634bb160e68, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7ffd7718387f, isout=0x7ffd7718387e) at ../src/backend/executor/nodeWindowAgg.c:3742 [09:16:34.791] winstate = [09:16:34.791] abs_pos = -1 [09:16:34.791] datum = 0 [09:16:34.791] null_treatment = true [09:16:34.791] notnull_offset = 0 [09:16:34.791] notnull_relpos = 1 [09:16:34.791] forward = -1 [09:16:34.791] __func__ = "WinGetFuncArgInPartition" [09:16:34.791] #8 0x00005634b6ee8253 in leadlag_common (fcinfo=0x7ffd771838c0, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [09:16:34.791] winobj = 0x5634bb160e68 [09:16:34.791] offset = [09:16:34.791] const_offset = [09:16:34.791] result = [09:16:34.791] isnull = true [09:16:34.791] isout = true [09:16:34.791] #9 0x00005634b6ee904b in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [09:16:34.791] No locals. [09:16:34.791] #10 0x00005634b691a456 in eval_windowfunction (winstate=winstate@entry=0x5634bb0d0e28, perfuncstate=0x5634bb160bf8, result=0x5634bb0d2aa8, isnull=0x5634bb0f1b82) at ../src/backend/executor/nodeWindowAgg.c:1088 [09:16:34.791] fcinfodata = {fcinfo = {flinfo = 0x5634bb160c10, context = 0x5634bb160e68, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7ffd771838e0}, fcinfo_data = "\020\f\026\2734V\000\000h\016\026\2734V", '\000' , "\377\001\000\000\000\000\000\000\000\000\000\001$\377\2724V\000\000\000\000\000\0004V\000\000\037U\341\2664V\000\000\377\377\377\377\377\377\377\377\200\321\r\2734V\000\000\000\000\000\000\000\000\000\000x$\377\2724V\000\000\220\325\r\2734V\000\000p9\030w\375\177\000\000", '\377' , "\000\000\000\000\000\000\000\000x$\377\2724V\000\000\220\325\r\2734V\000\000\037U\341\2664V\000\000\000\000\000\000\000\000i@\200\321\r\2734V", '\000' , "\220\212@@z\r\2734V\000\000"...} [09:16:34.791] fcinfo = 0x7ffd771838c0 [09:16:34.791] oldContext = 0x5634bb0d0ac0 [09:16:34.791] #11 0x00005634b69235f7 in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [09:16:34.791] perfuncstate = [09:16:34.791] winstate = 0x5634bb0d0e28 [09:16:34.791] slot = [09:16:34.791] econtext = 0x5634bb0d1398 [09:16:34.791] i = 2 [09:16:34.791] numfuncs = 3 [09:16:34.791] __func__ = "ExecWindowAgg" [09:16:34.791] #12 0x00005634b688d16a in ExecProcNodeFirst (node=0x5634bb0d0e28) at ../src/backend/executor/execProcnode.c:469 [09:16:34.791] No locals. [09:16:34.791] #13 0x00005634b687753d in ExecProcNode (node=node@entry=0x5634bb0d0e28) at ../src/include/executor/executor.h:313 [09:16:34.791] No locals. [09:16:34.791] #14 0x00005634b6877ef7 in ExecutePlan (queryDesc=queryDesc@entry=0x5634bb11a200, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x5634bb0d8550) at ../src/backend/executor/execMain.c:1679 [09:16:34.791] estate = 0x5634bb0d0bc0 [09:16:34.791] planstate = 0x5634bb0d0e28 [09:16:34.791] use_parallel_mode = false [09:16:34.791] slot = [09:16:34.791] current_tuple_count = 0 [09:16:34.791] #15 0x00005634b6879687 in standard_ExecutorRun (queryDesc=queryDesc@entry=0x5634bb11a200, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:367 [09:16:34.791] estate = 0x5634bb0d0bc0 [09:16:34.791] operation = CMD_SELECT [09:16:34.791] dest = 0x5634bb0d8550 [09:16:34.791] sendTuples = [09:16:34.791] oldcontext = 0x5634bb11a100 [09:16:34.791] #16 0x00007f6286e31805 in pgss_ExecutorRun (queryDesc=0x5634bb11a200, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1035 [09:16:34.791] _save_exception_stack = 0x7ffd77184200 [09:16:34.791] _save_context_stack = 0x0 [09:16:34.791] _local_sigjmp_buf = {{__jmpbuf = {94784475826928, 3738968899028954873, 0, 1, 94784475306832, 94784475306784, 6949305414456094457, 7011831400694853369}, __mask_was_saved = 0, __saved_mask = {__val = {94784407980706, 3075348224, 94784407985237, 3138219304, 2, 0, 94784475884384, 94784475884384, 1, 1, 94784475306832, 94784475306784, 94784408070775, 0, 94784408226088, 94784475884384}}}} [09:16:34.791] _do_rethrow = false [09:16:34.791] #17 0x00005634b68796dd in ExecutorRun (queryDesc=queryDesc@entry=0x5634bb11a200, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:302 [09:16:34.791] No locals. [09:16:34.791] #18 0x00005634b6c992e8 in PortalRunSelect (portal=portal@entry=0x5634bb030af0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x5634bb0d8550) at ../src/backend/tcop/pquery.c:921 [09:16:34.791] queryDesc = 0x5634bb11a200 [09:16:34.791] direction = [09:16:34.791] nprocessed = [09:16:34.791] __func__ = "PortalRunSelect" [09:16:34.791] #19 0x00005634b6c9c6e0 in PortalRun (portal=portal@entry=0x5634bb030af0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5634bb0d8550, altdest=altdest@entry=0x5634bb0d8550, qc=qc@entry=0x7ffd77184320) at ../src/backend/tcop/pquery.c:765 [09:16:34.791] _save_exception_stack = 0x7ffd771843d0 [09:16:34.791] _save_context_stack = 0x0 [09:16:34.791] _local_sigjmp_buf = {{__jmpbuf = {0, 3738968863421411065, 94784475826928, 94784475306856, 94784475306832, 94784475306784, 6949305414516911865, 3738946291180941049}, __mask_was_saved = 0, __saved_mask = {__val = {94784407985237, 1998078639, 4, 94784475306784, 112, 179, 94784475826928, 94784475306856, 94784475306832, 94784475306784, 94784408072962, 1, 2, 179, 94784397069379, 0}}}} [09:16:34.791] _do_rethrow = [09:16:34.791] result = [09:16:34.791] nprocessed = [09:16:34.791] saveTopTransactionResourceOwner = 0x5634baff4508 [09:16:34.791] saveTopTransactionContext = 0x5634bb03ea30 [09:16:34.791] saveActivePortal = 0x0 [09:16:34.791] saveResourceOwner = 0x5634baff4508 [09:16:34.791] savePortalContext = 0x0 [09:16:34.791] saveMemoryContext = 0x5634bb03ea30 [09:16:34.791] __func__ = "PortalRun" [09:16:34.791] #20 0x00005634b6c954c0 in exec_simple_query (query_string=query_string@entry=0x5634bafb0070 "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 [09:16:34.791] cmdtaglen = 6 [09:16:34.791] snapshot_set = [09:16:34.791] per_parsetree_context = 0x0 [09:16:34.791] plantree_list = 0x5634bb0d8ce0 [09:16:34.791] parsetree = 0x5634bafb1b20 [09:16:34.791] commandTag = [09:16:34.791] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:16:34.791] querytree_list = [09:16:34.791] portal = 0x5634bb030af0 [09:16:34.791] receiver = 0x5634bb0d8550 [09:16:34.791] format = 0 [09:16:34.791] cmdtagname = [09:16:34.791] parsetree_item__state = [09:16:34.791] dest = DestRemote [09:16:34.791] oldcontext = 0x5634bb03ea30 [09:16:34.791] parsetree_list = 0x5634bafb1b50 [09:16:34.791] parsetree_item = 0x5634bafb1b68 [09:16:34.791] save_log_statement_stats = false [09:16:34.791] was_logged = true [09:16:34.791] use_implicit_block = false [09:16:34.791] msec_str = "\000\223\220\2674V\000\000\224\367\365\2664V\000\000\260C\030w\375\177\000\000\322\000\000\000\000\000\000" [09:16:34.791] __func__ = "exec_simple_query" [09:16:34.791] #21 0x00005634b6c98709 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [09:16:34.791] query_string = 0x5634bafb0070 "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"... [09:16:34.791] firstchar = [09:16:34.791] input_message = {data = 0x5634bafb0070 "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} [09:16:34.791] local_sigjmp_buf = {{__jmpbuf = {94784421054520, 3738943417717796601, 4, 94784417993472, 24, 21, 6949305414584020729, 3738946288253185785}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94784475554992, 0, 168, 94784407985707, 0, 10, 2, 94784421054528, 94784475030864, 94784421048544, 94784417993472, 24, 21}}}} [09:16:34.791] send_ready_for_query = false [09:16:34.791] idle_in_transaction_timeout_enabled = false [09:16:34.791] idle_session_timeout_enabled = false [09:16:34.791] __func__ = "PostgresMain" [09:16:34.791] #22 0x00005634b6c8e021 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [09:16:34.791] bsdata = [09:16:34.791] #23 0x00005634b6b2bc0e in postmaster_child_launch (child_type=B_BACKEND, child_slot=21, startup_data=startup_data@entry=0x7ffd77184530, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffd771845a0) at ../src/backend/postmaster/launch_backend.c:290 [09:16:34.791] pid = [09:16:34.791] #24 0x00005634b6b311d2 in BackendStartup (client_sock=client_sock@entry=0x7ffd771845a0) at ../src/backend/postmaster/postmaster.c:3580 [09:16:34.791] bn = 0x5634bafdbb08 [09:16:34.791] pid = [09:16:34.791] startup_data = {canAcceptConnections = CAC_OK, socket_created = 803812216822839, fork_started = 803812216822847} [09:16:34.791] cac = [09:16:34.791] __func__ = "BackendStartup" [09:16:34.791] #25 0x00005634b6b336fe in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [09:16:34.791] s = {sock = 62, raddr = {addr = {ss_family = 1, __ss_padding = "\030w\375\177\000\0004F\030w\375\177", '\000' , "\365\364ŵ4V\000\000ؼ\301\2654V\000\000\000G\030w\375\177\000\000\370F\030w\375\177\000\000\225[\362\001\000\000\000\000@\254\375\2724V\000\000.", '\000' , "\003\364ŵ4V\000\000h\206\206\212b\177\000\000\020\214ȉb\177\000", __ss_align = 140061207593696}, salen = 2}} [09:16:34.791] i = 0 [09:16:34.791] now = [09:16:34.791] last_lockfile_recheck_time = 1750497015 [09:16:34.791] last_touch_time = 1750496954 [09:16:34.791] events = {{pos = 1, events = 2, fd = 60, user_data = 0x0}, {pos = 0, events = 0, fd = -1970895256, user_data = 0x0}, {pos = -1970896160, events = 32610, fd = 2090263927, user_data = 0x7ffd77184780}, {pos = -1971070392, events = 32610, fd = 17, user_data = 0x7f6289c88c10}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1970896160, events = 32610, fd = 1998079736, user_data = 0x7ffd77184700}, {pos = -1970895256, events = 32610, fd = 0, user_data = 0x5634bafdd758}, {pos = -1224944925, events = 22068, fd = 32768, user_data = 0x1}, {pos = -1157952624, events = 22068, fd = -1, user_data = 0x7f6288e2e020}, {pos = -1975903728, events = 32610, fd = -1158234632, user_data = 0x5634baf6bcd8}, {pos = -1157758543, events = 22068, fd = -1971044674, user_data = 0x1}, {pos = -1970896160, events = 32610, fd = 436, user_data = 0x5634b7501da0 }, {pos = 0, events = 0, fd = 0, user_data = 0x56}, {pos = -1971044674, events = 32610, fd = 1, user_data = 0x0}, {pos = -1998397408, events = 32610, fd = -1997590912, user_data = 0x10}, {pos = 1998080848, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1971035462, user_data = 0x0}, {pos = -1997869612, events = 32610, fd = 0, user_data = 0x5634b7bdaec0 }, {pos = 2, events = 0, fd = 0, user_data = 0x5634baf6b870}, {pos = -1228777289, events = 22068, fd = -1157739637, user_data = 0x5634b6c296d7 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5634bafdd758}, {pos = -1971044674, events = 32610, fd = 1, user_data = 0x0}, {pos = -1998363448, events = 32610, fd = -1997944704, user_data = 0x44e}, {pos = -1997836489, events = 32610, fd = 2, user_data = 0x1010}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -1996546976, events = 32610, fd = 255, user_data = 0xfffffffffffffee8}, {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 = 0xa67}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = -1983341952, user_data = 0x7f6289c89fc0}, {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 = 0x5634baf6bad0}, {pos = -1225272060, events = 22068, fd = 1024, user_data = 0x7f6288eb58ee}, {pos = -1996564000, events = 32610, fd = -1997926034, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1157739728, user_data = 0xaeaef190b1aef700}, {pos = -1996560928, events = 32610, 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 = 0x93c7}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x77}, {pos = -1997590381, events = 32610, fd = -1158235440, user_data = 0x1}, {pos = -1158235240, events = 22068, fd = 1024, user_data = 0x7ffd77184c28}, {pos = -1225190911, events = 22068, fd = -1212200976, user_data = 0x5634b6f7fcb5 }, {pos = -1158235440, events = 22068, fd = -1157955728, user_data = 0x5634baf6bad0}, {pos = -1997842533, events = 32610, fd = 0, user_data = 0x5634b6f91928 }, {pos = -1158235440, events = 1, fd = -1225188751, user_data = 0x5634bafaff70}, {pos = -1997919567, events = 32610, fd = -1997925136, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1313933568, events = 2930700688, fd = -1158236048, user_data = 0xaeaef190b1aef700}, {pos = 13, events = 0, fd = -1313933568, user_data = 0x0}, {pos = -1998212551, events = 32610, fd = 0, user_data = 0x5634b6b2b8f4 }, {pos = 4194304, events = 0, fd = -1158121824, user_data = 0x1}, {pos = 0, events = 0, fd = -1158236048, user_data = 0x5634b6f7fb49 }, {pos = -1158121824, events = 22068, fd = -1157955728, user_data = 0x5634baf876a0}, {pos = 1, events = 0, fd = 0, user_data = 0x5634b6f3dd88 }, {pos = 13, events = 0, fd = -1157771896, user_data = 0x5634bafdcd68}, {pos = -1212304296, events = 22068, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -1229800786, user_data = 0x5634bafaff70}, {pos = -1229783878, events = 22068, fd = -1215999824, user_data = 0x5634bafb0928}} [09:16:34.792] nevents = 1 [09:16:34.792] __func__ = "ServerLoop" [09:16:34.792] #26 0x00005634b6b34f62 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5634baf6e450) at ../src/backend/postmaster/postmaster.c:1400 [09:16:34.792] opt = [09:16:34.792] status = [09:16:34.792] userDoption = [09:16:34.792] listen_addr_saved = false [09:16:34.792] output_config_variable = [09:16:34.792] __func__ = "PostmasterMain" [09:16:34.792] #27 0x00005634b6961264 in main (argc=4, argv=0x5634baf6e450) at ../src/backend/main/main.c:227 [09:16:34.792] do_check_root = [09:16:34.792] dispatch_option =