[16:33:58.980] src/tools/ci/cores_backtrace.sh linux /tmp/cores [16:33:59.178] dumping /tmp/cores/postgres-6-33856.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [16:33:59.444] [New LWP 33856] [16:33:59.444] [16:33:59.444] This GDB supports auto-downloading debuginfo from the following URLs: [16:33:59.444] [16:33:59.444] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [16:33:59.444] Debuginfod has been disabled. [16:33:59.444] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [16:33:59.560] [Thread debugging using libthread_db enabled] [16:33:59.560] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [16:33:59.560] Core was generated by `postgres: postgres regression [local] SELECT '. [16:33:59.560] Program terminated with signal SIGABRT, Aborted. [16:33:59.560] #0 0x00007f7208ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:33:59.653] [16:33:59.653] Thread 1 (Thread 0x7f7208beda80 (LWP 33856)): [16:33:59.653] #0 0x00007f7208ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:33:59.653] No symbol table info available. [16:33:59.653] #1 0x00007f7208e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [16:33:59.653] No symbol table info available. [16:33:59.653] #2 0x00007f7208e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [16:33:59.653] No symbol table info available. [16:33:59.653] #3 0x00007f720901e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [16:33:59.653] No locals. [16:33:59.653] #4 0x00007f720902aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [16:33:59.653] No locals. [16:33:59.653] #5 0x00007f720900dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x55791eb7be60, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [16:33:59.653] bp = 140724699557184 [16:33:59.653] pc = [16:33:59.653] Opts = {FromUnrecoverableHandler = true, pc = 93978679942273, bp = 18446744073709551615} [16:33:59.653] #6 0x000055791dd59c81 in get_notnull_info (winobj=winobj@entry=0x55793a23d668, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3498 [16:33:59.653] mb = [16:33:59.653] bpos = 0 [16:33:59.653] #7 0x000055791dd64898 in WinGetFuncArgInPartition (winobj=winobj@entry=0x55793a23d668, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7ffd05ba6def, isout=0x7ffd05ba6dee) at ../src/backend/executor/nodeWindowAgg.c:3776 [16:33:59.653] winstate = [16:33:59.653] abs_pos = -1 [16:33:59.653] datum = 0 [16:33:59.653] null_treatment = true [16:33:59.653] notnull_offset = 0 [16:33:59.653] notnull_relpos = 1 [16:33:59.653] forward = -1 [16:33:59.653] __func__ = "WinGetFuncArgInPartition" [16:33:59.653] #8 0x000055791e3289d6 in leadlag_common (fcinfo=0x7ffd05ba6e30, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [16:33:59.653] winobj = 0x55793a23d668 [16:33:59.653] offset = [16:33:59.653] const_offset = [16:33:59.653] result = [16:33:59.653] isnull = true [16:33:59.653] isout = true [16:33:59.653] #9 0x000055791e3297ce in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [16:33:59.653] No locals. [16:33:59.653] #10 0x000055791dd5a7f1 in eval_windowfunction (winstate=winstate@entry=0x55793a1c8a68, perfuncstate=0x55793a23d3f8, result=0x55793a1ca6e8, isnull=0x55793a232e82) at ../src/backend/executor/nodeWindowAgg.c:1088 [16:33:59.653] fcinfodata = {fcinfo = {flinfo = 0x55793a23d410, context = 0x55793a23d668, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7ffd05ba6e50}, fcinfo_data = "\020\324#:yU\000\000h\326#:yU", '\000' , "\377\001\000\000\000\000\000\000\000\000\000\001n\016:yU\000\000\000\000\000\000yU\000\000\242\\%\036yU\000\000\377\377\377\377\377\377\377\377\300M\035:yU\000\000\000\000\000\000\000\000\000\000\310n\016:yU\000\000\320Q\035:yU\000\000\340n\272\005\375\177\000\000", '\377' , "\000\000\000\000\000\000\000\000\310n\016:yU\000\000\320Q\035:yU\000\000\242\\%\036yU\000\000\001\000\000\000yU\000\000\300M\035:yU\000\000\b(\003\037yU\000\000\237\2253\036yU\000\000`O\302\374q\177\000\000"...} [16:33:59.653] fcinfo = 0x7ffd05ba6e30 [16:33:59.653] oldContext = 0x55793a1c8700 [16:33:59.653] #11 0x000055791dd63992 in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [16:33:59.653] perfuncstate = [16:33:59.653] winstate = 0x55793a1c8a68 [16:33:59.653] slot = [16:33:59.653] econtext = 0x55793a1c8fd8 [16:33:59.653] i = 2 [16:33:59.653] numfuncs = 3 [16:33:59.653] __func__ = "ExecWindowAgg" [16:33:59.653] #12 0x000055791dccd505 in ExecProcNodeFirst (node=0x55793a1c8a68) at ../src/backend/executor/execProcnode.c:469 [16:33:59.653] No locals. [16:33:59.653] #13 0x000055791dcb78d8 in ExecProcNode (node=node@entry=0x55793a1c8a68) at ../src/include/executor/executor.h:313 [16:33:59.653] No locals. [16:33:59.653] #14 0x000055791dcb8292 in ExecutePlan (queryDesc=queryDesc@entry=0x55793a14b790, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55793a221110) at ../src/backend/executor/execMain.c:1679 [16:33:59.653] estate = 0x55793a1c8800 [16:33:59.653] planstate = 0x55793a1c8a68 [16:33:59.653] use_parallel_mode = false [16:33:59.653] slot = [16:33:59.653] current_tuple_count = 0 [16:33:59.653] #15 0x000055791dcb9a22 in standard_ExecutorRun (queryDesc=0x55793a14b790, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:367 [16:33:59.653] estate = 0x55793a1c8800 [16:33:59.653] operation = CMD_SELECT [16:33:59.653] dest = 0x55793a221110 [16:33:59.653] sendTuples = [16:33:59.653] oldcontext = 0x55793a14b690 [16:33:59.653] #16 0x000055791dcb9a82 in ExecutorRun (queryDesc=queryDesc@entry=0x55793a14b790, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:304 [16:33:59.653] No locals. [16:33:59.653] #17 0x000055791e0d9a6b in PortalRunSelect (portal=portal@entry=0x55793a12b990, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55793a221110) at ../src/backend/tcop/pquery.c:921 [16:33:59.653] queryDesc = 0x55793a14b790 [16:33:59.653] direction = [16:33:59.653] nprocessed = [16:33:59.653] __func__ = "PortalRunSelect" [16:33:59.653] #18 0x000055791e0dce63 in PortalRun (portal=portal@entry=0x55793a12b990, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55793a221110, altdest=altdest@entry=0x55793a221110, qc=qc@entry=0x7ffd05ba7780) at ../src/backend/tcop/pquery.c:765 [16:33:59.653] _save_exception_stack = 0x7ffd05ba7830 [16:33:59.653] _save_context_stack = 0x0 [16:33:59.653] _local_sigjmp_buf = {{__jmpbuf = {0, -7913662879676379791, 93979153709456, 93979153170296, 93979153170272, 93979153170224, -4096733343092978319, -7913583390222725775}, __mask_was_saved = 0, __saved_mask = {__val = {93978686645208, 96106255, 4, 93979153170224, 112, 179, 93979153709456, 93979153170296, 93979153170272, 93979153170224, 93978686732933, 1, 2, 179, 93978675727427, 0}}}} [16:33:59.653] _do_rethrow = [16:33:59.653] result = [16:33:59.653] nprocessed = [16:33:59.653] saveTopTransactionResourceOwner = 0x55793a0e9758 [16:33:59.653] saveTopTransactionContext = 0x55793a140640 [16:33:59.653] saveActivePortal = 0x0 [16:33:59.653] saveResourceOwner = 0x55793a0e9758 [16:33:59.653] savePortalContext = 0x0 [16:33:59.653] saveMemoryContext = 0x55793a140640 [16:33:59.653] __func__ = "PortalRun" [16:33:59.653] #19 0x000055791e0d5c43 in exec_simple_query (query_string=query_string@entry=0x55793a0a6480 "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 [16:33:59.653] cmdtaglen = 6 [16:33:59.653] snapshot_set = [16:33:59.653] per_parsetree_context = 0x0 [16:33:59.653] plantree_list = 0x55793a2218a0 [16:33:59.653] parsetree = 0x55793a0a7f30 [16:33:59.653] commandTag = [16:33:59.653] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:33:59.653] querytree_list = [16:33:59.653] portal = 0x55793a12b990 [16:33:59.653] receiver = 0x55793a221110 [16:33:59.653] format = 0 [16:33:59.653] cmdtagname = [16:33:59.653] parsetree_item__state = [16:33:59.653] dest = DestRemote [16:33:59.653] oldcontext = 0x55793a140640 [16:33:59.653] parsetree_list = 0x55793a0a7f60 [16:33:59.653] parsetree_item = 0x55793a0a7f78 [16:33:59.653] save_log_statement_stats = false [16:33:59.653] was_logged = false [16:33:59.653] use_implicit_block = false [16:33:59.653] msec_str = "@\225\324\036yU\000\000\027\3779\036yU\000\000\020x\272\005\375\177\000\000\322\000\000\000\000\000\000" [16:33:59.653] __func__ = "exec_simple_query" [16:33:59.653] #20 0x000055791e0d8e8c in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [16:33:59.653] query_string = 0x55793a0a6480 "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"... [16:33:59.653] firstchar = [16:33:59.653] input_message = {data = 0x55793a0a6480 "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} [16:33:59.653] local_sigjmp_buf = {{__jmpbuf = {93978699713368, -7913581247051215503, 4, 93978696652096, 24, 9, -4096733343025869455, -7913583392009368207}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93979152893264, 17408, 93978699707392, 93979153428224, 24, 93978686645124, 0, 10, 2, 93978699713376, 93979152893264, 93978699707392, 93978696652096, 24, 9}}}} [16:33:59.653] send_ready_for_query = false [16:33:59.653] idle_in_transaction_timeout_enabled = false [16:33:59.653] idle_session_timeout_enabled = false [16:33:59.653] __func__ = "PostgresMain" [16:33:59.653] #21 0x000055791e0ce7a4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [16:33:59.653] bsdata = [16:33:59.653] #22 0x000055791df6c33c in postmaster_child_launch (child_type=B_BACKEND, child_slot=9, startup_data=startup_data@entry=0x7ffd05ba7990, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffd05ba7a00) at ../src/backend/postmaster/launch_backend.c:290 [16:33:59.653] pid = [16:33:59.653] #23 0x000055791df71900 in BackendStartup (client_sock=client_sock@entry=0x7ffd05ba7a00) at ../src/backend/postmaster/postmaster.c:3580 [16:33:59.653] bn = 0x55793a0ceb78 [16:33:59.653] pid = [16:33:59.653] startup_data = {canAcceptConnections = CAC_OK, socket_created = 804270403924785, fork_started = 804270403924795} [16:33:59.653] cac = [16:33:59.653] __func__ = "BackendStartup" [16:33:59.653] #24 0x000055791df73e2c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [16:33:59.653] s = {sock = 151, raddr = {addr = {ss_family = 1, __ss_padding = "\t\035yU\000\000ج\005\035yU\000\000@{\272\005\375\177\000\0008{\272\005\375\177\000\000\225[\362\001\000\000\000\000p\212\310\tr\177\000\000-", '\000' , "`z\272\005\375\177\000\000\000\004\000\000\000\000\000\000x{\272\005\375\177\000\000\000\3215\205r]\333\371p\030\006:", '\000' , __ss_align = 67}, salen = 2}} [16:33:59.653] i = 0 [16:33:59.653] now = [16:33:59.653] last_lockfile_recheck_time = 1750955146 [16:33:59.653] last_touch_time = 1750955146 [16:33:59.653] events = {{pos = 1, events = 2, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = 96107456, user_data = 0x0}, {pos = 17, events = 0, fd = 164138000, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f720a6e82e0}, {pos = 96107320, events = 32765, fd = 96107328, user_data = 0x7f720a6e8668}, {pos = 0, events = 0, fd = 1, user_data = 0x1}, {pos = 973759808, events = 21881, fd = 1, user_data = 0x55793a0a6540}, {pos = -1, events = 0, fd = 149086240, user_data = 0x7f7209d4ba10}, {pos = 973767024, events = 21881, fd = 149876133, user_data = 0x7ffd05ba8093}, {pos = 150, events = 0, fd = 96107392, user_data = 0x7f720a6e82e0}, {pos = 436, events = 0, fd = 513023392, user_data = 0x0}, {pos = 0, events = 0, fd = 249, user_data = 0x7f720a6c3ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f7208e2e020}, {pos = 149892736, events = 32626, fd = 575566490, user_data = 0x7ffd05ba7fb0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 174875322, events = 32626, fd = 0, user_data = 0x7f7208eaedd4 }, {pos = 0, events = 0, fd = 520204768, user_data = 0x2}, {pos = 0, events = 0, fd = 973478000, user_data = 0x7f7208eeeedd }, {pos = 973767568, events = 21881, fd = 503730533, user_data = 0x55793a0d8ea0}, {pos = 8096, events = 196607, fd = 973967099, user_data = 0x55791e069e5a }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x168}, {pos = 513022784, events = 21881, fd = 8, user_data = 0x1}, {pos = 973759808, events = 21881, fd = 174866110, user_data = 0x1}, {pos = 149647517, events = 32626, fd = 149120200, user_data = 0x55793a0d8ea0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x202020200a0a6575}, {pos = 822763892, events = 959460663, fd = 875640117, 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 = 973971104, user_data = 0x55791e3bd407 }, {pos = 973942912, events = 21881, fd = 1080, user_data = 0x55793a061ad0}, {pos = 507239559, events = 21881, fd = 1024, user_data = 0x7f7208eb58ee}, {pos = 150919648, events = 32626, fd = 149557614, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 96108680, events = 32765, fd = 149651279, user_data = 0x55793a061ad0}, {pos = 3, events = 0, fd = 0, user_data = 0x6503}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x11a}, {pos = 149893267, events = 32626, fd = 973478608, user_data = 0x1}, {pos = 973478808, events = 21881, fd = 1024, user_data = 0x7ffd05ba8088}, {pos = 507320708, events = 21881, fd = 520309520, user_data = 0x55791e3c0438 }, {pos = 973478608, events = 21881, fd = 973759360, user_data = 0x55793a061ad0}, {pos = 149641454, events = 32626, fd = 0, user_data = 0x55791e3d20ab }, {pos = 973478608, events = 1, fd = 507322868, user_data = 0x55793a0a6380}, {pos = 149564081, events = 32626, fd = 149558512, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -2060070656, events = 4191903090, fd = 973478000, user_data = 0xf9db5d728535d100}, {pos = 13, events = 0, fd = -2060070656, user_data = 0x0}, {pos = 149271097, events = 32626, fd = 0, user_data = 0x55791df6c022 }, {pos = 4194304, events = 0, fd = 973593264, user_data = 0x1}, {pos = 0, events = 0, fd = 973478000, user_data = 0x55791e3c02cc }, {pos = 973593264, events = 21881, fd = 973759360, user_data = 0x55793a07dab0}, {pos = 1, events = 0, fd = 0, user_data = 0x55791e37e50b }, {pos = 13, events = 0, fd = 973938376, user_data = 0x55793a0d1ea8}, {pos = 520206200, events = 21881, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 502710748, user_data = 0x55793a0a6380}, {pos = 502727656, events = 21881, fd = 516510448, user_data = 0x55793a0a6d58}} [16:33:59.653] nevents = 1 [16:33:59.653] __func__ = "ServerLoop" [16:33:59.653] #25 0x000055791df75690 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55793a0644b0) at ../src/backend/postmaster/postmaster.c:1400 [16:33:59.653] opt = [16:33:59.653] status = [16:33:59.653] userDoption = [16:33:59.653] listen_addr_saved = false [16:33:59.653] output_config_variable = [16:33:59.653] __func__ = "PostmasterMain" [16:33:59.653] #26 0x000055791dda167a in main (argc=8, argv=0x55793a0644b0) at ../src/backend/main/main.c:227 [16:33:59.653] do_check_root = [16:33:59.653] dispatch_option = [16:33:59.672] -e [16:33:59.672] [16:33:59.672] [16:33:59.749] dumping /tmp/cores/postgres-6-45025.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [16:34:00.012] [New LWP 45025] [16:34:00.012] [16:34:00.012] This GDB supports auto-downloading debuginfo from the following URLs: [16:34:00.012] [16:34:00.012] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [16:34:00.012] Debuginfod has been disabled. [16:34:00.012] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [16:34:00.117] [Thread debugging using libthread_db enabled] [16:34:00.117] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [16:34:00.117] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [16:34:00.117] Program terminated with signal SIGABRT, Aborted. [16:34:00.117] #0 0x00007f93e9ca9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:34:00.192] [16:34:00.192] Thread 1 (Thread 0x7f93e781da80 (LWP 45025)): [16:34:00.192] #0 0x00007f93e9ca9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:34:00.192] No symbol table info available. [16:34:00.192] #1 0x00007f93e9c5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [16:34:00.192] No symbol table info available. [16:34:00.192] #2 0x00007f93e9c45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [16:34:00.192] No symbol table info available. [16:34:00.192] #3 0x00007f93e9e1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [16:34:00.192] No locals. [16:34:00.192] #4 0x00007f93e9e2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [16:34:00.192] No locals. [16:34:00.192] #5 0x00007f93e9e0dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x55bb3c9d9e60, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [16:34:00.192] bp = 140735094011552 [16:34:00.192] pc = [16:34:00.192] Opts = {FromUnrecoverableHandler = true, pc = 94262649388161, bp = 18446744073709551615} [16:34:00.192] #6 0x000055bb3bbb7c81 in get_notnull_info (winobj=winobj@entry=0x55bb53780ef8, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3498 [16:34:00.192] mb = [16:34:00.192] bpos = 0 [16:34:00.192] #7 0x000055bb3bbc2898 in WinGetFuncArgInPartition (winobj=winobj@entry=0x55bb53780ef8, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7fff7149374f, isout=0x7fff7149374e) at ../src/backend/executor/nodeWindowAgg.c:3776 [16:34:00.192] winstate = [16:34:00.192] abs_pos = -1 [16:34:00.192] datum = 0 [16:34:00.192] null_treatment = true [16:34:00.192] notnull_offset = 0 [16:34:00.192] notnull_relpos = 1 [16:34:00.192] forward = -1 [16:34:00.192] __func__ = "WinGetFuncArgInPartition" [16:34:00.192] #8 0x000055bb3c1869d6 in leadlag_common (fcinfo=0x7fff71493790, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [16:34:00.192] winobj = 0x55bb53780ef8 [16:34:00.192] offset = [16:34:00.192] const_offset = [16:34:00.192] result = [16:34:00.192] isnull = true [16:34:00.192] isout = true [16:34:00.192] #9 0x000055bb3c1877ce in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [16:34:00.192] No locals. [16:34:00.192] #10 0x000055bb3bbb87f1 in eval_windowfunction (winstate=winstate@entry=0x55bb536d45b8, perfuncstate=0x55bb53780c88, result=0x55bb536d6238, isnull=0x55bb53775ae2) at ../src/backend/executor/nodeWindowAgg.c:1088 [16:34:00.192] fcinfodata = {fcinfo = {flinfo = 0x55bb53780ca0, context = 0x55bb53780ef8, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7fff714937b0}, fcinfo_data = "\240\fxS\273U\000\000\370\016xS\273U", '\000' , "\377\001\000\000\000\000\000\000\000\000\000\001D_S\273U\000\000\000\000\000\000\273U\000\000\242<\v<\273U\000\000\377\377\377\377\377\377\377\377\020\tnS\273U\000\000\000\000\000\000\000\000\000\000xD_S\273U\000\000 \rnS\273U\000\000@8Iq\377\177\000\000", '\377' , "\000\000\000\000\000\000\000\000xD_S\273U\000\000 \rnS\273U\000\000\242<\v<\273U\000\000\000\000\000\000\000\000i@\020\tnS\273U", '\000' , "\220\212@`\vrS\273U\000\000"...} [16:34:00.192] fcinfo = 0x7fff71493790 [16:34:00.192] oldContext = 0x55bb536d4250 [16:34:00.192] #11 0x000055bb3bbc1992 in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [16:34:00.192] perfuncstate = [16:34:00.192] winstate = 0x55bb536d45b8 [16:34:00.192] slot = [16:34:00.192] econtext = 0x55bb536d4b28 [16:34:00.192] i = 2 [16:34:00.192] numfuncs = 3 [16:34:00.192] __func__ = "ExecWindowAgg" [16:34:00.192] #12 0x000055bb3bb2b505 in ExecProcNodeFirst (node=0x55bb536d45b8) at ../src/backend/executor/execProcnode.c:469 [16:34:00.192] No locals. [16:34:00.192] #13 0x000055bb3bb158d8 in ExecProcNode (node=node@entry=0x55bb536d45b8) at ../src/include/executor/executor.h:313 [16:34:00.192] No locals. [16:34:00.192] #14 0x000055bb3bb16292 in ExecutePlan (queryDesc=queryDesc@entry=0x55bb53713de0, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55bb53721670) at ../src/backend/executor/execMain.c:1679 [16:34:00.192] estate = 0x55bb536d4350 [16:34:00.192] planstate = 0x55bb536d45b8 [16:34:00.192] use_parallel_mode = false [16:34:00.192] slot = [16:34:00.192] current_tuple_count = 0 [16:34:00.192] #15 0x000055bb3bb17a22 in standard_ExecutorRun (queryDesc=queryDesc@entry=0x55bb53713de0, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:367 [16:34:00.192] estate = 0x55bb536d4350 [16:34:00.192] operation = CMD_SELECT [16:34:00.192] dest = 0x55bb53721670 [16:34:00.192] sendTuples = [16:34:00.192] oldcontext = 0x55bb53713ce0 [16:34:00.192] #16 0x00007f93e72ed805 in pgss_ExecutorRun (queryDesc=0x55bb53713de0, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1035 [16:34:00.192] _save_exception_stack = 0x7fff714940d0 [16:34:00.192] _save_context_stack = 0x0 [16:34:00.192] _local_sigjmp_buf = {{__jmpbuf = {94263046253296, 7134116345003237484, 0, 1, 94263045733200, 94263045733152, 4001797314600099948, 3985705166530404460}, __mask_was_saved = 0, __saved_mask = {__val = {94262656086565, 1014494976, 94262656091096, 1399979592, 2, 0, 94263046346000, 94263046346000, 1, 1, 94263045733200, 94263045733152, 94262656176634, 0, 94262656331947, 94263046346000}}}} [16:34:00.192] _do_rethrow = false [16:34:00.192] #17 0x000055bb3bb17a78 in ExecutorRun (queryDesc=queryDesc@entry=0x55bb53713de0, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:302 [16:34:00.192] No locals. [16:34:00.192] #18 0x000055bb3bf37a6b in PortalRunSelect (portal=portal@entry=0x55bb53632af0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55bb53721670) at ../src/backend/tcop/pquery.c:921 [16:34:00.192] queryDesc = 0x55bb53713de0 [16:34:00.192] direction = [16:34:00.192] nprocessed = [16:34:00.192] __func__ = "PortalRunSelect" [16:34:00.192] #19 0x000055bb3bf3ae63 in PortalRun (portal=portal@entry=0x55bb53632af0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55bb53721670, altdest=altdest@entry=0x55bb53721670, qc=qc@entry=0x7fff714941f0) at ../src/backend/tcop/pquery.c:765 [16:34:00.192] _save_exception_stack = 0x7fff714942a0 [16:34:00.192] _save_context_stack = 0x0 [16:34:00.192] _local_sigjmp_buf = {{__jmpbuf = {0, 7134116337803714668, 94263046253296, 94263045733224, 94263045733200, 94263045733152, 4001797314354733164, 7134168009903431788}, __mask_was_saved = 0, __saved_mask = {__val = {94262656091096, 1900626303, 4, 94263045733152, 112, 179, 94263046253296, 94263045733224, 94263045733200, 94263045733152, 94262656178821, 1, 2, 179, 94262645173315, 0}}}} [16:34:00.192] _do_rethrow = [16:34:00.192] result = [16:34:00.192] nprocessed = [16:34:00.192] saveTopTransactionResourceOwner = 0x55bb535f6508 [16:34:00.192] saveTopTransactionContext = 0x55bb536493e0 [16:34:00.192] saveActivePortal = 0x0 [16:34:00.192] saveResourceOwner = 0x55bb535f6508 [16:34:00.192] savePortalContext = 0x0 [16:34:00.192] saveMemoryContext = 0x55bb536493e0 [16:34:00.192] __func__ = "PortalRun" [16:34:00.192] #20 0x000055bb3bf33c43 in exec_simple_query (query_string=query_string@entry=0x55bb535b2070 "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 [16:34:00.192] cmdtaglen = 6 [16:34:00.192] snapshot_set = [16:34:00.192] per_parsetree_context = 0x0 [16:34:00.192] plantree_list = 0x55bb53721e00 [16:34:00.192] parsetree = 0x55bb535b3b20 [16:34:00.192] commandTag = [16:34:00.192] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:34:00.192] querytree_list = [16:34:00.192] portal = 0x55bb53632af0 [16:34:00.192] receiver = 0x55bb53721670 [16:34:00.192] format = 0 [16:34:00.192] cmdtagname = [16:34:00.192] parsetree_item__state = [16:34:00.192] dest = DestRemote [16:34:00.192] oldcontext = 0x55bb536493e0 [16:34:00.192] parsetree_list = 0x55bb535b3b50 [16:34:00.192] parsetree_item = 0x55bb535b3b68 [16:34:00.192] save_log_statement_stats = false [16:34:00.192] was_logged = true [16:34:00.192] use_implicit_block = false [16:34:00.192] msec_str = "@u\272<\273U\000\000\027\337\037<\273U\000\000\200BIq\377\177\000\000\322\000\000\000\000\000\000" [16:34:00.192] __func__ = "exec_simple_query" [16:34:00.192] #21 0x000055bb3bf36e8c in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [16:34:00.192] query_string = 0x55bb535b2070 "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"... [16:34:00.192] firstchar = [16:34:00.192] input_message = {data = 0x55bb535b2070 "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} [16:34:00.192] local_sigjmp_buf = {{__jmpbuf = {94262669159256, 7134166029939892332, 4, 94262666097984, 24, 4, 4001797314421842028, 7134168003518783596}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94263045981360, 0, 168, 94262656091566, 0, 10, 2, 94262669159264, 94263045457232, 94262669153280, 94262666097984, 24, 4}}}} [16:34:00.192] send_ready_for_query = false [16:34:00.192] idle_in_transaction_timeout_enabled = false [16:34:00.192] idle_session_timeout_enabled = false [16:34:00.192] __func__ = "PostgresMain" [16:34:00.192] #22 0x000055bb3bf2c7a4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [16:34:00.192] bsdata = [16:34:00.192] #23 0x000055bb3bdca33c in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x7fff71494400, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7fff71494470) at ../src/backend/postmaster/launch_backend.c:290 [16:34:00.192] pid = [16:34:00.192] #24 0x000055bb3bdcf900 in BackendStartup (client_sock=client_sock@entry=0x7fff71494470) at ../src/backend/postmaster/postmaster.c:3580 [16:34:00.192] bn = 0x55bb535dd7d8 [16:34:00.192] pid = [16:34:00.192] startup_data = {canAcceptConnections = CAC_OK, socket_created = 804270473644502, fork_started = 804270473644505} [16:34:00.192] cac = [16:34:00.192] __func__ = "BackendStartup" [16:34:00.192] #25 0x000055bb3bdd1e2c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [16:34:00.192] s = {sock = 62, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\365\304\357:\273U\000\000،\353:\273U\000\000\300EIq\377\177\000\000\270EIq\377\177\000\000\225[\362\001\000\000\000\000@\314]S\273U\000\000.", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\366P\353\223\177\000\000\020\354\301\347\223\177\000\000\340\362P\353\223\177\000\000\316)fR\000\000\000", __ss_align = 1900627456}, salen = 2}} [16:34:00.192] i = 0 [16:34:00.192] now = [16:34:00.192] last_lockfile_recheck_time = 1750955216 [16:34:00.192] last_touch_time = 1750955216 [16:34:00.192] events = {{pos = 1, events = 2, fd = 60, user_data = 0x0}, {pos = 0, events = 0, fd = -347016480, user_data = 0x0}, {pos = 1900627520, events = 32767, fd = -347190712, user_data = 0x11}, {pos = -406721520, events = 32659, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -347016480, user_data = 0x7fff714945b8}, {pos = 1900627392, events = 32767, fd = -347015576, user_data = 0x0}, {pos = 1398667096, events = 21947, fd = -372540742, user_data = 0x55bb535df758}, {pos = 1, events = 21947, fd = 32768, user_data = 0xffffffff}, {pos = -373104608, events = 32659, fd = -357094896, user_data = 0x55bb5356ddf8}, {pos = 1398201560, events = 21947, fd = 1398677937, user_data = 0x7f93eb4eaebe}, {pos = 1, events = 0, fd = -347016480, user_data = 0x1b4}, {pos = 1014627744, events = 21947, fd = 0, user_data = 0x0}, {pos = 86, events = 0, fd = -347164994, user_data = 0x1}, {pos = 0, events = 0, fd = -373104608, user_data = 0x7f93e9cf2e80 }, {pos = 16, events = 0, fd = 1900628512, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f93eb4ed2ba}, {pos = 0, events = 0, fd = -372576812, user_data = 0x0}, {pos = 1021809120, events = 21947, fd = 2, user_data = 0x0}, {pos = 1398200432, events = 21947, fd = 1005334885, user_data = 0x55bb535e6b30}, {pos = 1005338682, events = 21947, fd = 1398696843, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -373070648, user_data = 0x7f93e9c9c880 }, {pos = -410920656, events = 32659, fd = 1900628720, user_data = 0x100007f00000002}, {pos = -372543689, events = 32659, fd = 2, user_data = 0x1010}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -371254176, events = 32659, 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 = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f93ea432a80}, {pos = -364695616, events = 32659, 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 = 1398704976, events = 21947, fd = 1080, user_data = 0x55bb5356dad0}, {pos = 1008843911, events = 21947, fd = 1024, user_data = 0x7f93e9cb58ee}, {pos = -371271200, events = 32659, fd = -372633234, user_data = 0x100000400}, {pos = 7, events = 0, fd = 1398696752, user_data = 0xab1e502e0ff1fc00}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55bb5356dad0}, {pos = 3, events = 0, fd = 0, user_data = 0x8dc0}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x77}, {pos = -372297581, events = 32659, fd = 1398201040, user_data = 0x1}, {pos = 1398201240, events = 21947, fd = 1024, user_data = 0x7fff71494af8}, {pos = 1008925060, events = 21947, fd = 1021913872, user_data = 0x55bb3c21e438 }, {pos = 1398201040, events = 21947, fd = 1398480752, user_data = 0x55bb5356dad0}, {pos = -372549733, events = 32659, fd = 0, user_data = 0x55bb3c2300ab }, {pos = 1398201040, events = 1, fd = 1008927220, user_data = 0x55bb535b1f70}, {pos = -372626767, events = 32659, fd = -372632336, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 267516928, events = 2870890542, fd = 1398200432, user_data = 0xab1e502e0ff1fc00}, {pos = 13, events = 0, fd = 267516928, user_data = 0x0}, {pos = -372919751, events = 32659, fd = 0, user_data = 0x55bb3bdca022 }, {pos = 4194304, events = 0, fd = 1398314656, user_data = 0x1}, {pos = 0, events = 0, fd = 1398200432, user_data = 0x55bb3c21e2cc }, {pos = 1398314656, events = 21947, fd = 1398480752, user_data = 0x55bb535896a0}, {pos = 1, events = 0, fd = 0, user_data = 0x55bb3c1dc50b }, {pos = 13, events = 0, fd = 1398664584, user_data = 0x55bb535ded68}, {pos = 1021810552, events = 21947, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 1004315100, user_data = 0x55bb535b1f70}, {pos = 1004332008, events = 21947, fd = 1018114800, user_data = 0x55bb535b2928}} [16:34:00.192] nevents = 1 [16:34:00.192] __func__ = "ServerLoop" [16:34:00.192] #26 0x000055bb3bdd3690 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55bb53570450) at ../src/backend/postmaster/postmaster.c:1400 [16:34:00.192] opt = [16:34:00.192] status = [16:34:00.192] userDoption = [16:34:00.192] listen_addr_saved = false [16:34:00.192] output_config_variable = [16:34:00.192] __func__ = "PostmasterMain" [16:34:00.192] #27 0x000055bb3bbff67a in main (argc=4, argv=0x55bb53570450) at ../src/backend/main/main.c:227 [16:34:00.192] do_check_root = [16:34:00.192] dispatch_option = [16:34:00.213] -e [16:34:00.213] [16:34:00.213] [16:34:00.284] dumping /tmp/cores/postgres-6-33976.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [16:34:00.544] [New LWP 33976] [16:34:00.544] [16:34:00.544] This GDB supports auto-downloading debuginfo from the following URLs: [16:34:00.544] [16:34:00.544] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [16:34:00.544] Debuginfod has been disabled. [16:34:00.544] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [16:34:00.646] [Thread debugging using libthread_db enabled] [16:34:00.646] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [16:34:00.646] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [16:34:00.646] Program terminated with signal SIGABRT, Aborted. [16:34:00.646] #0 0x00007f53652a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:34:00.704] [16:34:00.704] Thread 1 (Thread 0x7f5364fe1a80 (LWP 33976)): [16:34:00.704] #0 0x00007f53652a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [16:34:00.704] No symbol table info available. [16:34:00.704] #1 0x00007f536525afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [16:34:00.704] No symbol table info available. [16:34:00.704] #2 0x00007f5365245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [16:34:00.704] No symbol table info available. [16:34:00.704] #3 0x00007f536541e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [16:34:00.704] No locals. [16:34:00.704] #4 0x00007f536542aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [16:34:00.704] No locals. [16:34:00.704] #5 0x00007f536540dad8 in __ubsan::__ubsan_handle_shift_out_of_bounds_abort (Data=Data@entry=0x55e7812d9e60, LHS=, RHS=RHS@entry=18446744073709551614) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:378 [16:34:00.704] bp = 140727253751728 [16:34:00.704] pc = [16:34:00.704] Opts = {FromUnrecoverableHandler = true, pc = 94452778237057, bp = 18446744073709551615} [16:34:00.704] #6 0x000055e7804b7c81 in get_notnull_info (winobj=winobj@entry=0x55e78bf26a48, pos=pos@entry=-1) at ../src/backend/executor/nodeWindowAgg.c:3498 [16:34:00.704] mb = [16:34:00.704] bpos = 0 [16:34:00.704] #7 0x000055e7804c2898 in WinGetFuncArgInPartition (winobj=winobj@entry=0x55e78bf26a48, argno=argno@entry=0, relpos=relpos@entry=-1, seektype=seektype@entry=0, set_mark=, isnull=isnull@entry=0x7ffd9df8585f, isout=0x7ffd9df8585e) at ../src/backend/executor/nodeWindowAgg.c:3776 [16:34:00.704] winstate = [16:34:00.704] abs_pos = -1 [16:34:00.704] datum = 0 [16:34:00.704] null_treatment = true [16:34:00.704] notnull_offset = 0 [16:34:00.704] notnull_relpos = 1 [16:34:00.704] forward = -1 [16:34:00.704] __func__ = "WinGetFuncArgInPartition" [16:34:00.704] #8 0x000055e780a869d6 in leadlag_common (fcinfo=0x7ffd9df858a0, forward=forward@entry=false, withoffset=withoffset@entry=false, withdefault=withdefault@entry=false) at ../src/backend/utils/adt/windowfuncs.c:558 [16:34:00.704] winobj = 0x55e78bf26a48 [16:34:00.704] offset = [16:34:00.704] const_offset = [16:34:00.704] result = [16:34:00.704] isnull = true [16:34:00.704] isout = true [16:34:00.704] #9 0x000055e780a877ce in window_lag (fcinfo=) at ../src/backend/utils/adt/windowfuncs.c:589 [16:34:00.704] No locals. [16:34:00.704] #10 0x000055e7804b87f1 in eval_windowfunction (winstate=winstate@entry=0x55e78beb9eb8, perfuncstate=0x55e78bf267d8, result=0x55e78bebbb38, isnull=0x55e78bf1c262) at ../src/backend/executor/nodeWindowAgg.c:1088 [16:34:00.704] fcinfodata = {fcinfo = {flinfo = 0x55e78bf267f0, context = 0x55e78bf26a48, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x7ffd9df858c0}, fcinfo_data = "\360g\362\213\347U\000\000Hj\362\213\347U", '\000' , "U\001\000\000\000\000\000\000\000\000\000\001\276ߋ\347U\000\000\370\3245Y \000\000\000 \000\000\000\001\000\000\000\340\240\335\213\347U\000\000va\177\200\343\327Cd\230\002", '\000' , "\237u\251\200\347U\000\000\210\3301YS\177\000\000\210\3301YS\177\000\000\220\3301Y \000\000\000 \000\000\000\347U\000\000Ɨ\327*\000\000\000\000_ʩ\200\347U\000\000\001\000\000\000\347U\000\000x{\251\200\347U\000\000\b\by\201\347U\000\000\237u\251\200\347U\000\000p\3179YS\177\000\000H\3179Y"...} [16:34:00.704] fcinfo = 0x7ffd9df858a0 [16:34:00.704] oldContext = 0x55e78beb9b50 [16:34:00.704] #11 0x000055e7804c1992 in ExecWindowAgg (pstate=) at ../src/backend/executor/nodeWindowAgg.c:2327 [16:34:00.704] perfuncstate = [16:34:00.704] winstate = 0x55e78beb9eb8 [16:34:00.704] slot = [16:34:00.704] econtext = 0x55e78beba428 [16:34:00.704] i = 2 [16:34:00.704] numfuncs = 3 [16:34:00.704] __func__ = "ExecWindowAgg" [16:34:00.704] #12 0x000055e78042b505 in ExecProcNodeFirst (node=0x55e78beb9eb8) at ../src/backend/executor/execProcnode.c:469 [16:34:00.704] No locals. [16:34:00.704] #13 0x000055e7804158d8 in ExecProcNode (node=node@entry=0x55e78beb9eb8) at ../src/include/executor/executor.h:313 [16:34:00.704] No locals. [16:34:00.704] #14 0x000055e780416292 in ExecutePlan (queryDesc=queryDesc@entry=0x55e78bee53d0, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55e78bf0a4f0) at ../src/backend/executor/execMain.c:1679 [16:34:00.704] estate = 0x55e78beb9c50 [16:34:00.704] planstate = 0x55e78beb9eb8 [16:34:00.704] use_parallel_mode = false [16:34:00.704] slot = [16:34:00.704] current_tuple_count = 0 [16:34:00.704] #15 0x000055e780417a22 in standard_ExecutorRun (queryDesc=0x55e78bee53d0, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:367 [16:34:00.704] estate = 0x55e78beb9c50 [16:34:00.704] operation = CMD_SELECT [16:34:00.704] dest = 0x55e78bf0a4f0 [16:34:00.704] sendTuples = [16:34:00.704] oldcontext = 0x55e78bee52d0 [16:34:00.704] #16 0x000055e780417a82 in ExecutorRun (queryDesc=queryDesc@entry=0x55e78bee53d0, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:304 [16:34:00.704] No locals. [16:34:00.704] #17 0x000055e780837a6b in PortalRunSelect (portal=portal@entry=0x55e78be1cfe0, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55e78bf0a4f0) at ../src/backend/tcop/pquery.c:921 [16:34:00.704] queryDesc = 0x55e78bee53d0 [16:34:00.704] direction = [16:34:00.704] nprocessed = [16:34:00.704] __func__ = "PortalRunSelect" [16:34:00.704] #18 0x000055e78083ae63 in PortalRun (portal=portal@entry=0x55e78be1cfe0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55e78bf0a4f0, altdest=altdest@entry=0x55e78bf0a4f0, qc=qc@entry=0x7ffd9df861f0) at ../src/backend/tcop/pquery.c:765 [16:34:00.704] _save_exception_stack = 0x7ffd9df862a0 [16:34:00.704] _save_context_stack = 0x0 [16:34:00.704] _local_sigjmp_buf = {{__jmpbuf = {0, -7930544950142265583, 94452972638176, 94452972100424, 94452972100400, 94452972100352, -4195904102101641455, -7930525013270685935}, __mask_was_saved = 0, __saved_mask = {__val = {94452784939992, 2650300799, 4, 94452972100352, 112, 179, 94452972638176, 94452972100424, 94452972100400, 94452972100352, 94452785027717, 1, 2, 179, 94452774022211, 0}}}} [16:34:00.704] _do_rethrow = [16:34:00.704] result = [16:34:00.704] nprocessed = [16:34:00.704] saveTopTransactionResourceOwner = 0x55e78bdd9a98 [16:34:00.704] saveTopTransactionContext = 0x55e78be31880 [16:34:00.704] saveActivePortal = 0x0 [16:34:00.704] saveResourceOwner = 0x55e78bdd9a98 [16:34:00.704] savePortalContext = 0x0 [16:34:00.704] saveMemoryContext = 0x55e78be31880 [16:34:00.704] __func__ = "PortalRun" [16:34:00.704] #19 0x000055e780833c43 in exec_simple_query (query_string=query_string@entry=0x55e78bd98050 "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 [16:34:00.704] cmdtaglen = 6 [16:34:00.704] snapshot_set = [16:34:00.704] per_parsetree_context = 0x0 [16:34:00.704] plantree_list = 0x55e78bf0ac80 [16:34:00.704] parsetree = 0x55e78bd99b00 [16:34:00.704] commandTag = [16:34:00.704] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [16:34:00.704] querytree_list = [16:34:00.704] portal = 0x55e78be1cfe0 [16:34:00.704] receiver = 0x55e78bf0a4f0 [16:34:00.704] format = 0 [16:34:00.704] cmdtagname = [16:34:00.704] parsetree_item__state = [16:34:00.704] dest = DestRemote [16:34:00.704] oldcontext = 0x55e78be31880 [16:34:00.704] parsetree_list = 0x55e78bd99b30 [16:34:00.704] parsetree_item = 0x55e78bd99b48 [16:34:00.704] save_log_statement_stats = false [16:34:00.704] was_logged = false [16:34:00.704] use_implicit_block = false [16:34:00.704] msec_str = "@uJ\201\347U\000\000\027߯\200\347U\000\000\200b\370\235\375\177\000\000\322\000\000\000\000\000\000" [16:34:00.704] __func__ = "exec_simple_query" [16:34:00.704] #20 0x000055e780836e8c in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4766 [16:34:00.704] query_string = 0x55e78bd98050 "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"... [16:34:00.704] firstchar = [16:34:00.704] input_message = {data = 0x55e78bd98050 "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} [16:34:00.704] local_sigjmp_buf = {{__jmpbuf = {94452798008152, -7930523995380607215, 4, 94452794946880, 24, 8, -4195904102034532591, -7930525010779138287}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94452971824400, 16128, 94452798002176, 94452972358224, 24, 94452784939908, 0, 9, 2, 94452798008160, 94452971824400, 94452798002176, 94452794946880, 24, 8}}}} [16:34:00.704] send_ready_for_query = false [16:34:00.704] idle_in_transaction_timeout_enabled = false [16:34:00.704] idle_session_timeout_enabled = false [16:34:00.704] __func__ = "PostgresMain" [16:34:00.704] #21 0x000055e78082c7a4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [16:34:00.704] bsdata = [16:34:00.704] #22 0x000055e7806ca33c in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x7ffd9df86400, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffd9df86470) at ../src/backend/postmaster/launch_backend.c:290 [16:34:00.704] pid = [16:34:00.704] #23 0x000055e7806cf900 in BackendStartup (client_sock=client_sock@entry=0x7ffd9df86470) at ../src/backend/postmaster/postmaster.c:3580 [16:34:00.704] bn = 0x55e78bdc0698 [16:34:00.704] pid = [16:34:00.704] startup_data = {canAcceptConnections = CAC_OK, socket_created = 804270405175954, fork_started = 804270405175957} [16:34:00.704] cac = [16:34:00.704] __func__ = "BackendStartup" [16:34:00.704] #24 0x000055e7806d1e2c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [16:34:00.704] s = {sock = 140, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\365\304\177\177\347U\000\000،{\177\347U\000\000\300e\370\235\375\177\000\000\270e\370\235\375\177\000\000\225[\362\001\000\000\000\000p\212\bfS\177\000\000-", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h֭fS\177\000\000\020\214\bfS\177\000\000\340ҭfS\177\000\000\316)fR\000\000\000", __ss_align = 2650301952}, salen = 2}} [16:34:00.704] i = 0 [16:34:00.704] now = [16:34:00.704] last_lockfile_recheck_time = 1750955147 [16:34:00.704] last_touch_time = 1750955147 [16:34:00.704] events = {{pos = 1, events = 2, fd = 138, user_data = 0x0}, {pos = 0, events = 0, fd = 138, user_data = 0x0}, {pos = -1644665280, events = 32765, fd = 1722493512, user_data = 0x11}, {pos = 1711836176, events = 32595, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1722667744, user_data = 0x7ffd9df865b8}, {pos = -1644665408, events = 32765, fd = 1722668648, user_data = 0x0}, {pos = -1948680088, events = 21991, fd = 1697348282, user_data = 0x55e78bd98068}, {pos = 1, events = 21991, fd = 32768, user_data = 0xffffffff}, {pos = 1696784416, events = 32595, fd = 1718815248, user_data = 0x55e78bd53df8}, {pos = -1948959528, events = 21991, fd = -1948493807, user_data = 0x7f5366ab8ebe}, {pos = 1, events = 0, fd = 1722667744, user_data = 0x1b4}, {pos = -2130051680, events = 21991, fd = 0, user_data = 0x0}, {pos = 229, events = 0, fd = 1722519230, user_data = 0x1}, {pos = 0, events = 0, fd = 1696784416, user_data = 0x7f53652f2e80 }, {pos = 16, events = 0, fd = -1644664288, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f5366abb2ba}, {pos = 0, events = 0, fd = 1697312212, user_data = 0x0}, {pos = -2122870304, events = 21991, fd = 2, user_data = 0x0}, {pos = -1948960656, events = 21991, fd = -2139344539, user_data = 0x55e78bdca9f0}, {pos = -2139340742, events = 21991, fd = -1948472757, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = 1696818376, user_data = 0x7f536529c880 }, {pos = 1694374192, events = 32595, fd = -1644664080, user_data = 0x100007f00000002}, {pos = 1697345693, events = 32595, fd = 2, user_data = 0x55e78bdca9f0}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = 1698634848, events = 32595, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 21760, 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 = -1948497904, events = 21991, fd = 1080, user_data = 0x55e78bd53ad0}, {pos = -2135835513, events = 21991, fd = 1024, user_data = 0x7f53652b58ee}, {pos = 1698617824, events = 32595, fd = 1697255790, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1948493776, user_data = 0x6583a200aeea7d00}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55e78bd53ad0}, {pos = 3, events = 0, fd = 0, user_data = 0x653f}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x106}, {pos = 1697591443, events = 32595, fd = -1948960048, user_data = 0x1}, {pos = -1948959848, events = 21991, fd = 1024, user_data = 0x7ffd9df86af8}, {pos = -2135754364, events = 21991, fd = -2122765552, user_data = 0x55e780b1e438 }, {pos = -1948960048, events = 21991, fd = -1948680368, user_data = 0x55e78bd53ad0}, {pos = 1697339630, events = 32595, fd = 0, user_data = 0x55e780b300ab }, {pos = -1948960048, events = 1, fd = -2135752204, user_data = 0x55e78bd97f50}, {pos = 1697262257, events = 32595, fd = 1697256688, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1360364288, events = 1703125504, fd = -1948960656, user_data = 0x6583a200aeea7d00}, {pos = 13, events = 0, fd = -1360364288, user_data = 0x0}, {pos = 1696969273, events = 32595, fd = 0, user_data = 0x55e7806ca022 }, {pos = 4194304, events = 0, fd = -1948846464, user_data = 0x1}, {pos = 0, events = 0, fd = -1948960656, user_data = 0x55e780b1e2cc }, {pos = -1948846464, events = 21991, fd = -1948680368, user_data = 0x55e78bd6f680}, {pos = 1, events = 0, fd = 0, user_data = 0x55e780adc50b }, {pos = 13, events = 0, fd = -1948502440, user_data = 0x55e78bdc3638}, {pos = -2122868872, events = 21991, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -2140364324, user_data = 0x55e78bd97f50}, {pos = -2140347416, events = 21991, fd = -2126564624, user_data = 0x55e78bd988f8}} [16:34:00.705] nevents = 1 [16:34:00.705] __func__ = "ServerLoop" [16:34:00.705] #25 0x000055e7806d3690 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55e78bd56420) at ../src/backend/postmaster/postmaster.c:1400 [16:34:00.705] opt = [16:34:00.705] status = [16:34:00.705] userDoption = [16:34:00.705] listen_addr_saved = false [16:34:00.705] output_config_variable = [16:34:00.705] __func__ = "PostmasterMain" [16:34:00.705] #26 0x000055e7804ff67a in main (argc=4, argv=0x55e78bd56420) at ../src/backend/main/main.c:227 [16:34:00.705] do_check_root = [16:34:00.705] dispatch_option =