[00:16:02.296] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [00:16:02.633] dumping /tmp/cores/postgres.10967.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:16:02.773] [New LWP 100163] [00:16:02.860] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [00:16:02.860] Program terminated with signal SIGABRT, Aborted. [00:16:02.860] Sent by thr_kill() from pid 10967 and user 1003. [00:16:02.860] #0 0x000000082da8341a in thr_kill () from /lib/libc.so.7 [00:16:02.921] [00:16:02.921] Thread 1 (LWP 100163): [00:16:02.921] #0 0x000000082da8341a in thr_kill () from /lib/libc.so.7 [00:16:02.921] No symbol table info available. [00:16:02.921] #1 0x000000082d9fce64 in raise () from /lib/libc.so.7 [00:16:02.921] No symbol table info available. [00:16:02.921] #2 0x000000082daad6f9 in abort () from /lib/libc.so.7 [00:16:02.921] No symbol table info available. [00:16:02.921] #3 0x0000000000aa2ab5 in ExceptionalCondition (conditionName=0x2ed290 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [00:16:02.921] No locals. [00:16:02.921] #4 0x0000000000769ae9 in standard_ExecutorStart (queryDesc=0x837ad0bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [00:16:02.921] estate = 0x83aac8100 [00:16:02.921] oldcontext = 0x837ab6800 [00:16:02.921] #5 0x00000000006fdcdf in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [00:16:02.921] copied_query = [00:16:02.921] rewritten = [00:16:02.921] plan = 0x837ad0778 [00:16:02.921] queryDesc = 0x837ad0bd0 [00:16:02.921] processed = [00:16:02.921] __error = [00:16:02.921] #6 RefreshMatViewByOid (matviewOid=28514, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [00:16:02.921] dest = [00:16:02.921] save_userid = 10 [00:16:02.921] save_sec_context = 0 [00:16:02.921] processed = 0 [00:16:02.921] matviewRel = 0x83ab53b88 [00:16:02.921] relowner = 10 [00:16:02.921] save_nestlevel = 2 [00:16:02.921] rule = [00:16:02.921] actions = [00:16:02.921] dataQuery = [00:16:02.921] tableSpace = [00:16:02.921] relpersistence = [00:16:02.921] OIDNewHeap = 28535 [00:16:02.921] address = [00:16:02.921] #7 0x00000000006fd8b6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:16:02.921] lockmode = [00:16:02.921] matviewOid = 0 [00:16:02.921] #8 0x00000000006d48ac in ExecCreateTableAs (pstate=pstate@entry=0x837ab6900, stmt=stmt@entry=0x837ac7fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82155a050) at ../src/backend/commands/createas.c:351 [00:16:02.921] refresh = 0x0 [00:16:02.921] query = 0x837b86d18 [00:16:02.921] into = 0x837b87060 [00:16:02.921] jstate = 0x0 [00:16:02.921] do_refresh = false [00:16:02.921] address = [00:16:02.921] dest = [00:16:02.921] is_matview = [00:16:02.921] #9 0x000000000094a23b in ProcessUtilitySlow (pstate=pstate@entry=0x837ab6900, pstmt=pstmt@entry=0x837a09a68, queryString=queryString@entry=0x837a08100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x82155a050) at ../src/backend/tcop/utility.c:1678 [00:16:02.921] _local_sigjmp_buf = {{_sjb = {9738857, 0, 34918997112, 34918997488, 34918997120, 12563528, 0, 35293718784, 12452735, 1, 4294967295, 34359738368}}} [00:16:02.921] _save_exception_stack = 0x821559f50 [00:16:02.921] _save_context_stack = 0x0 [00:16:02.921] _do_rethrow = false [00:16:02.921] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:16:02.921] parsetree = 0x837ac7fd0 [00:16:02.921] commandCollected = false [00:16:02.921] needCleanup = false [00:16:02.921] address = [00:16:02.921] isTopLevel = [00:16:02.921] isCompleteQuery = [00:16:02.921] #10 0x0000000000948bb8 in standard_ProcessUtility (pstmt=0x837a09a68, queryString=0x837a08100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837b87548, qc=0x82155a050) at ../src/backend/tcop/utility.c:1033 [00:16:02.921] isAtomicContext = false [00:16:02.921] parsetree = 0x837ac7fd0 [00:16:02.921] readonly_flags = [00:16:02.921] pstate = 0x837ab6900 [00:16:02.921] isTopLevel = [00:16:02.921] #11 0x0000000000948648 in ProcessUtility (pstmt=0x18743, queryString=0x6 , readOnlyTree=, context=765998074, params=0x0, queryEnv=0x0, dest=0x837b87548, qc=0x82155a050) at ../src/backend/tcop/utility.c:523 [00:16:02.921] No locals. [00:16:02.921] #12 0x0000000000948183 in PortalRunUtility (portal=0x837adf100, pstmt=0x837a09a68, isTopLevel=, setHoldSnapshot=, dest=0x837b87548, qc=0x82155a050) at ../src/backend/tcop/pquery.c:1152 [00:16:02.921] No locals. [00:16:02.921] #13 0x0000000000947844 in PortalRunMulti (portal=portal@entry=0x837adf100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x837b87548, altdest=altdest@entry=0x837b87548, qc=qc@entry=0x82155a050) at ../src/backend/tcop/pquery.c:1316 [00:16:02.921] pstmt = 0x837a09a68 [00:16:02.921] stmtlist_item__state = {l = 0x837b874f8, i = 0} [00:16:02.921] active_snapshot_set = false [00:16:02.921] stmtlist_item = 0x837b87510 [00:16:02.921] #14 0x000000000094712b in PortalRun (portal=portal@entry=0x837adf100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x837b87548, altdest=altdest@entry=0x837b87548, qc=qc@entry=0x82155a050) at ../src/backend/tcop/pquery.c:787 [00:16:02.921] _local_sigjmp_buf = {{_sjb = {9728165, 35293884672, 34918997832, 34918998080, 34918997840, 12563528, 34918998096, 12517960, 12518271, 0, 35293889407, 34359738368}}} [00:16:02.921] _save_exception_stack = 0x82155a100 [00:16:02.921] _save_context_stack = 0x0 [00:16:02.921] _do_rethrow = false [00:16:02.921] saveTopTransactionResourceOwner = 0x837aee048 [00:16:02.921] saveTopTransactionContext = 0x837ae3000 [00:16:02.921] saveActivePortal = 0x0 [00:16:02.921] saveResourceOwner = 0x837aee048 [00:16:02.921] savePortalContext = 0x0 [00:16:02.921] saveMemoryContext = 0x837ae3000 [00:16:02.921] result = [00:16:02.921] nprocessed = [00:16:02.921] #15 0x0000000000945fb9 in exec_simple_query (query_string=query_string@entry=0x837a08100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [00:16:02.921] cmdtaglen = 24 [00:16:02.921] snapshot_set = [00:16:02.921] per_parsetree_context = 0x0 [00:16:02.921] plantree_list = [00:16:02.921] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:16:02.921] format = 0 [00:16:02.921] parsetree = 0x837a096a8 [00:16:02.921] commandTag = [00:16:02.921] cmdtagname = [00:16:02.921] querytree_list = [00:16:02.921] portal = 0x837adf100 [00:16:02.921] receiver = 0x837b87548 [00:16:02.921] parsetree_item__state = {l = 0x837a09a18, i = 0} [00:16:02.921] msec_str = "\000\000\000\000\b", '\000' , "nÚg\000\000\000\000\345\314\373q\317\320", [00:16:02.921] dest = DestRemote [00:16:02.921] was_logged = [00:16:02.921] oldcontext = 0x837ae3000 [00:16:02.921] parsetree_list = 0x837a09a18 [00:16:02.921] use_implicit_block = false [00:16:02.921] parsetree_item = 0x837a09a30 [00:16:02.921] save_log_statement_stats = [00:16:02.921] #16 0x0000000000943c23 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [00:16:02.921] query_string = 0x837a08100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:16:02.921] input_message = {data = 0x837a08100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:16:02.921] firstchar = [00:16:02.921] local_sigjmp_buf = {{_sjb = {9711830, 34918998272, 34918998264, 34918998816, 12572280, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [00:16:02.921] send_ready_for_query = false [00:16:02.921] idle_in_transaction_timeout_enabled = false [00:16:02.921] idle_session_timeout_enabled = false [00:16:02.921] #17 0x000000000093e5c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:16:02.921] bsdata = [00:16:02.921] #18 0x0000000000895e05 in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x82155ae30 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82155ad80) at ../src/backend/postmaster/launch_backend.c:274 [00:16:02.921] pid = [00:16:02.921] #19 0x000000000089a1ab in BackendStartup (client_sock=0x82155ad80) at ../src/backend/postmaster/postmaster.c:3519 [00:16:02.921] startup_data = {canAcceptConnections = CAC_OK} [00:16:02.921] bn = 0x837aab0c8 [00:16:02.921] cac = CAC_OK [00:16:02.921] pid = [00:16:02.921] __error = [00:16:02.921] save_errno = [00:16:02.921] __error = [00:16:02.921] __error = [00:16:02.921] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [00:16:02.921] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\f", '\000' , "\340\255U!\b\000\000\000h%\370+\b\000\000\000\372\000\000\000\000\000\000\000^\257\370+\b", '\000' , " \256U!\b\000\000\000\224[\211\000\000\000\000\0000\256U!\b", '\000' }, salen = 16}} [00:16:02.921] i = 0 [00:16:02.921] now = [00:16:02.921] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 933643736, events = 8, fd = 559262656, user_data = 0x82155a920}, {pos = 8192, events = 0, fd = 8192, user_data = 0x837ad7000}, {pos = 559261992, events = 8, fd = 0, user_data = 0x835abf090}, {pos = 1, events = 0, fd = 559261792, user_data = 0x82daf29c9}, {pos = 764769160, events = 8, fd = 764861816, user_data = 0x82155a878}, {pos = 559261936, events = 8, fd = 559261984, user_data = 0x82155a918}, {pos = 900460688, events = 8, fd = 920652160, user_data = 0x20}, {pos = 4096, events = 0, fd = 559262432, user_data = 0x82daeda7c}, {pos = 559261976, events = 8, fd = 1258074890, user_data = 0x82d94f858}, {pos = 764861816, events = 8, fd = 559261928, user_data = 0x82155a960}, {pos = 559261928, events = 8, fd = 764824844, user_data = 0x82254f408}, {pos = 764824844, events = 8, fd = 559262032, user_data = 0xeb84afc643a}, {pos = 900460736, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 920662584, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x822554288}, {pos = 764737624, events = 8, fd = 575992840, user_data = 0x82155a9e8}, {pos = 559262632, events = 8, fd = 559262160, user_data = 0xeb84afcaca2}, {pos = 2722358, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 576016440, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 559262888, user_data = 0x2254f408}, {pos = 559262704, events = 8, fd = 559262304, user_data = 0x1}, {pos = 559262632, events = 8, fd = 32, user_data = 0x82155aa50}, {pos = 1258072691, events = 3768, fd = 559262576, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x822555038}, {pos = 1, events = 8, fd = 575992840, user_data = 0x82d94f858}, {pos = 559262888, events = 8, fd = 559262704, user_data = 0x82155aa60}, {pos = 0, events = 0, fd = 575963144, user_data = 0x20}, {pos = 559262688, events = 8, fd = 1258048231, user_data = 0x822548008}, {pos = 575964168, events = 8, fd = 575965192, user_data = 0x822548c08}, {pos = 575979528, events = 8, fd = 575980552, user_data = 0x82254c808}, {pos = 575982600, events = 8, fd = 575983624, user_data = 0x82254d408}, {pos = 575985672, events = 8, fd = 575986696, user_data = 0x82254e008}, {pos = 575988744, events = 8, fd = 575989768, user_data = 0x82254ec08}, {pos = 575991816, events = 8, fd = 575992840, user_data = 0x82254f808}, {pos = 575994888, events = 8, fd = 575995912, user_data = 0x822550408}, {pos = 575997960, events = 8, fd = 575998984, user_data = 0x822551008}, {pos = 576001032, events = 8, fd = 576002056, user_data = 0x822551c08}, {pos = 576008200, events = 8, fd = 576009224, user_data = 0x822553808}, {pos = 576011272, events = 8, fd = 575963144, user_data = 0x298a36}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822555038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 559262888, events = 8, fd = 559262304, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 576016440, user_data = 0x1}, {pos = 575963144, events = 8, fd = 298, user_data = 0x82155ac90}, {pos = 1258046959, events = 3768, fd = 2722358, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 576016440, user_data = 0x1}, {pos = 575992840, events = 8, fd = 933199872, user_data = 0x1}, {pos = 933200276, events = 8, fd = 0, user_data = 0x82155ac60}, {pos = 737715564, events = 8, fd = 1, user_data = 0x8379f8000}, {pos = 559262864, events = 8, fd = 737711874, user_data = 0x82da81170 }, {pos = 12480368, events = 0, fd = 765989232, user_data = 0x82254f408}, {pos = 559263088, events = 8, fd = 1258046430, user_data = 0x837a16800}, {pos = 1, events = 8, fd = 1258046046, user_data = 0x822548008}, {pos = 559262872, events = 8, fd = 559263088, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1258125712, user_data = 0x0}, {pos = 559219583, events = 8, fd = 8134871, user_data = 0x82155ad20}, {pos = 737674256, events = 8, fd = 766652464, user_data = 0x82db25310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82155ad50}, {pos = 737717149, events = 8, fd = 933199872, user_data = 0x1e12}, {pos = 559263152, events = 8, fd = 737683706, user_data = 0x0}, {pos = 0, events = 0, fd = -1940737325, user_data = 0x0}} [00:16:02.921] last_touch_time = 1738195799 [00:16:02.921] last_lockfile_recheck_time = 1738195799 [00:16:02.921] nevents = 1 [00:16:02.921] #21 0x00000000008985e4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82155b3a8) at ../src/backend/postmaster/postmaster.c:1386 [00:16:02.921] userDoption = [00:16:02.921] listen_addr_saved = false [00:16:02.921] output_config_variable = [00:16:02.921] opt = [00:16:02.921] status = [00:16:02.921] #22 0x00000000007cedb0 in main (argc=8, argv=0x82155b3a8) at ../src/backend/main/main.c:230 [00:16:02.921] do_check_root = [00:16:02.921] dispatch_option = DISPATCH_POSTMASTER [00:16:02.931] [00:16:02.931] [00:16:02.931] [00:16:02.994] dumping /tmp/cores/postgres.11356.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:16:03.123] [New LWP 101932] [00:16:03.188] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [00:16:03.188] Program terminated with signal SIGABRT, Aborted. [00:16:03.188] Sent by thr_kill() from pid 11356 and user 1003. [00:16:03.188] #0 0x000000082d3a841a in thr_kill () from /lib/libc.so.7 [00:16:03.223] [00:16:03.223] Thread 1 (LWP 101932): [00:16:03.223] #0 0x000000082d3a841a in thr_kill () from /lib/libc.so.7 [00:16:03.223] No symbol table info available. [00:16:03.223] #1 0x000000082d321e64 in raise () from /lib/libc.so.7 [00:16:03.223] No symbol table info available. [00:16:03.223] #2 0x000000082d3d26f9 in abort () from /lib/libc.so.7 [00:16:03.223] No symbol table info available. [00:16:03.223] #3 0x0000000000aa2ab5 in ExceptionalCondition (conditionName=0x2ed290 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [00:16:03.223] No locals. [00:16:03.223] #4 0x0000000000769ae9 in standard_ExecutorStart (queryDesc=0x835d15bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [00:16:03.223] estate = 0x835d4f100 [00:16:03.223] oldcontext = 0x835c4d800 [00:16:03.223] #5 0x00000000006fdcdf in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [00:16:03.223] copied_query = [00:16:03.223] rewritten = [00:16:03.223] plan = 0x835d15778 [00:16:03.223] queryDesc = 0x835d15bd0 [00:16:03.223] processed = [00:16:03.223] __error = [00:16:03.223] #6 RefreshMatViewByOid (matviewOid=28539, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [00:16:03.223] dest = [00:16:03.223] save_userid = 10 [00:16:03.223] save_sec_context = 0 [00:16:03.223] processed = 0 [00:16:03.223] matviewRel = 0x841397c18 [00:16:03.223] relowner = 10 [00:16:03.223] save_nestlevel = 2 [00:16:03.223] rule = [00:16:03.223] actions = [00:16:03.223] dataQuery = [00:16:03.223] tableSpace = [00:16:03.223] relpersistence = [00:16:03.223] OIDNewHeap = 28552 [00:16:03.223] address = [00:16:03.223] #7 0x00000000006fd8b6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:16:03.223] lockmode = [00:16:03.223] matviewOid = 0 [00:16:03.223] #8 0x00000000006d48ac in ExecCreateTableAs (pstate=pstate@entry=0x835c4d900, stmt=stmt@entry=0x835bfafd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8217a1ce0) at ../src/backend/commands/createas.c:351 [00:16:03.223] refresh = 0x0 [00:16:03.223] query = 0x835c69558 [00:16:03.223] into = 0x835c698a0 [00:16:03.223] jstate = 0x0 [00:16:03.223] do_refresh = false [00:16:03.223] address = [00:16:03.223] dest = [00:16:03.223] is_matview = [00:16:03.223] #9 0x000000000094a23b in ProcessUtilitySlow (pstate=pstate@entry=0x835c4d900, pstmt=pstmt@entry=0x835b82a68, queryString=queryString@entry=0x835b81100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x8217a1ce0) at ../src/backend/tcop/utility.c:1678 [00:16:03.223] _local_sigjmp_buf = {{_sjb = {9738857, 0, 34921388296, 34921388672, 34921388304, 12563528, 0, 35261831424, 12452735, 1, 4294967295, 34359738368}}} [00:16:03.223] _save_exception_stack = 0x8217a1be0 [00:16:03.223] _save_context_stack = 0x0 [00:16:03.223] _do_rethrow = false [00:16:03.223] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:16:03.223] parsetree = 0x835bfafd0 [00:16:03.223] commandCollected = false [00:16:03.223] needCleanup = false [00:16:03.223] address = [00:16:03.223] isTopLevel = [00:16:03.223] isCompleteQuery = [00:16:03.223] #10 0x0000000000948bb8 in standard_ProcessUtility (pstmt=0x835b82a68, queryString=0x835b81100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835c69d88, qc=0x8217a1ce0) at ../src/backend/tcop/utility.c:1033 [00:16:03.223] isAtomicContext = false [00:16:03.223] parsetree = 0x835bfafd0 [00:16:03.223] readonly_flags = [00:16:03.223] pstate = 0x835c4d900 [00:16:03.223] isTopLevel = [00:16:03.223] #11 0x0000000000948648 in ProcessUtility (pstmt=0x18e2c, queryString=0x6 , readOnlyTree=, context=758809594, params=0x0, queryEnv=0x0, dest=0x835c69d88, qc=0x8217a1ce0) at ../src/backend/tcop/utility.c:523 [00:16:03.223] No locals. [00:16:03.223] #12 0x0000000000948183 in PortalRunUtility (portal=0x835c27100, pstmt=0x835b82a68, isTopLevel=, setHoldSnapshot=, dest=0x835c69d88, qc=0x8217a1ce0) at ../src/backend/tcop/pquery.c:1152 [00:16:03.223] No locals. [00:16:03.223] #13 0x0000000000947844 in PortalRunMulti (portal=portal@entry=0x835c27100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835c69d88, altdest=altdest@entry=0x835c69d88, qc=qc@entry=0x8217a1ce0) at ../src/backend/tcop/pquery.c:1316 [00:16:03.223] pstmt = 0x835b82a68 [00:16:03.223] stmtlist_item__state = {l = 0x835c69d38, i = 0} [00:16:03.223] active_snapshot_set = false [00:16:03.223] stmtlist_item = 0x835c69d50 [00:16:03.223] #14 0x000000000094712b in PortalRun (portal=portal@entry=0x835c27100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x835c69d88, altdest=altdest@entry=0x835c69d88, qc=qc@entry=0x8217a1ce0) at ../src/backend/tcop/pquery.c:787 [00:16:03.223] _local_sigjmp_buf = {{_sjb = {9728165, 35261673728, 34921389016, 34921389264, 34921389024, 12563528, 34921389280, 12517960, 12518271, 0, 35261645695, 34359738368}}} [00:16:03.223] _save_exception_stack = 0x8217a1d90 [00:16:03.223] _save_context_stack = 0x0 [00:16:03.223] _do_rethrow = false [00:16:03.223] saveTopTransactionResourceOwner = 0x835c76e58 [00:16:03.223] saveTopTransactionContext = 0x835c2b000 [00:16:03.223] saveActivePortal = 0x0 [00:16:03.223] saveResourceOwner = 0x835c76e58 [00:16:03.223] savePortalContext = 0x0 [00:16:03.223] saveMemoryContext = 0x835c2b000 [00:16:03.223] result = [00:16:03.223] nprocessed = [00:16:03.223] #15 0x0000000000945fb9 in exec_simple_query (query_string=query_string@entry=0x835b81100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [00:16:03.223] cmdtaglen = 24 [00:16:03.223] snapshot_set = [00:16:03.223] per_parsetree_context = 0x0 [00:16:03.223] plantree_list = [00:16:03.223] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:16:03.223] format = 0 [00:16:03.223] parsetree = 0x835b826a8 [00:16:03.223] commandTag = [00:16:03.223] cmdtagname = [00:16:03.223] querytree_list = [00:16:03.223] portal = 0x835c27100 [00:16:03.223] receiver = 0x835c69d88 [00:16:03.223] parsetree_item__state = {l = 0x835b82a18, i = 0} [00:16:03.223] msec_str = "\000\000\000\000\b", '\000' , "qÚg\000\000\000\0005\347\305\345\256&\300\177" [00:16:03.223] dest = DestRemote [00:16:03.223] was_logged = [00:16:03.223] oldcontext = 0x835c2b000 [00:16:03.223] parsetree_list = 0x835b82a18 [00:16:03.223] use_implicit_block = false [00:16:03.223] parsetree_item = 0x835b82a30 [00:16:03.223] save_log_statement_stats = [00:16:03.223] #16 0x0000000000943c23 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [00:16:03.223] query_string = 0x835b81100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:16:03.223] input_message = {data = 0x835b81100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:16:03.223] firstchar = [00:16:03.223] local_sigjmp_buf = {{_sjb = {9711830, 34921389456, 34921389448, 34921390000, 12572280, 1, 8192, 8388608, 34921382783, 0, 0, 1}}} [00:16:03.223] send_ready_for_query = false [00:16:03.223] idle_in_transaction_timeout_enabled = false [00:16:03.223] idle_session_timeout_enabled = false [00:16:03.223] #17 0x000000000093e5c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:16:03.223] bsdata = [00:16:03.223] #18 0x0000000000895e05 in postmaster_child_launch (child_type=B_BACKEND, child_slot=16, startup_data=startup_data@entry=0x8217a2ac0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8217a2a10) at ../src/backend/postmaster/launch_backend.c:274 [00:16:03.223] pid = [00:16:03.223] #19 0x000000000089a1ab in BackendStartup (client_sock=0x8217a2a10) at ../src/backend/postmaster/postmaster.c:3519 [00:16:03.223] startup_data = {canAcceptConnections = CAC_OK} [00:16:03.223] bn = 0x835c45308 [00:16:03.223] cac = CAC_OK [00:16:03.223] pid = [00:16:03.223] __error = [00:16:03.223] save_errno = [00:16:03.223] __error = [00:16:03.223] __error = [00:16:03.223] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [00:16:03.223] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\f", '\000' , "p*z!\b\000\000\000h\325\376)\b\000\000\000\346\000\000\000\000\000\000\000^_\377)\b", '\000' , "\260*z!\b\000\000\000\224[\211\000\000\000\000\000\300*z!\b", '\000' }, salen = 16}} [00:16:03.223] i = 0 [00:16:03.223] now = [00:16:03.223] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 901690840, events = 8, fd = 561653840, user_data = 0x0}, {pos = 0, events = 0, fd = 1551757396, user_data = 0x1089c86ef30a}, {pos = 757602208, events = 8, fd = 757673336, user_data = 0x8217a24d8}, {pos = 561653072, events = 8, fd = 561652952, user_data = 0x1089c86ef30a}, {pos = 757580680, events = 8, fd = 757673336, user_data = 0x8217a2508}, {pos = 561653120, events = 8, fd = 561653000, user_data = 0x82d28b194}, {pos = 568165384, events = 8, fd = 757641620, user_data = 0x8217a2570}, {pos = -932273094, events = 4233, fd = 759463984, user_data = 0x1}, {pos = 561653152, events = 8, fd = -932252918, user_data = 0x82d274858}, {pos = 757673336, events = 8, fd = 561653112, user_data = 0x8217a25f0}, {pos = 561653112, events = 8, fd = 757636364, user_data = 0x821dd8408}, {pos = 757636364, events = 8, fd = 561653216, user_data = 0x1089c86ea43a}, {pos = 561653256, events = 8, fd = 561653704, user_data = 0x8217a25f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2506605446, fd = 568188984, user_data = 0x800000001}, {pos = 568165384, events = 8, fd = 757580680, user_data = 0x821ddd288}, {pos = 757549144, events = 8, fd = 568165384, user_data = 0x8217a2678}, {pos = 561653816, events = 8, fd = 561653344, user_data = 0x1089c86eeca2}, {pos = 2722358, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 568188984, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 561654072, user_data = 0x21dd8408}, {pos = 561653888, events = 8, fd = 561653488, user_data = 0x1}, {pos = 561653816, events = 8, fd = 32, user_data = 0x8217a26e0}, {pos = -932255117, events = 4233, fd = 561653760, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821dde038}, {pos = 1, events = 8, fd = 568165384, user_data = 0x82d274858}, {pos = 561654072, events = 8, fd = 561653888, user_data = 0x8217a26f0}, {pos = 0, events = 0, fd = 568135688, user_data = 0x20}, {pos = 561653872, events = 8, fd = -932279577, user_data = 0x821dd1008}, {pos = 568136712, events = 8, fd = 568137736, user_data = 0x821dd1c08}, {pos = 568152072, events = 8, fd = 568153096, user_data = 0x821dd5808}, {pos = 568155144, events = 8, fd = 568156168, user_data = 0x821dd6408}, {pos = 568158216, events = 8, fd = 568159240, user_data = 0x821dd7008}, {pos = 568161288, events = 8, fd = 568162312, user_data = 0x821dd7c08}, {pos = 568164360, events = 8, fd = 568165384, user_data = 0x821dd8808}, {pos = 568167432, events = 8, fd = 568168456, user_data = 0x821dd9408}, {pos = 568170504, events = 8, fd = 568171528, user_data = 0x821dda008}, {pos = 568173576, events = 8, fd = 568174600, user_data = 0x821ddac08}, {pos = 568180744, events = 8, fd = 568181768, user_data = 0x821ddc808}, {pos = 568183816, events = 8, fd = 568135688, user_data = 0x298a36}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821dde038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 561654072, events = 8, fd = 561653488, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 568188984, user_data = 0x1}, {pos = 568135688, events = 8, fd = 298, user_data = 0x8217a2920}, {pos = -932280849, events = 4233, fd = 2722358, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 568188984, user_data = 0x1}, {pos = 568165384, events = 8, fd = 901189632, user_data = 0x1}, {pos = 901190036, events = 8, fd = 0, user_data = 0x8217a28f0}, {pos = 704599404, events = 8, fd = 1, user_data = 0x835b71000}, {pos = 561654048, events = 8, fd = 704595714, user_data = 0x82d3a6170 }, {pos = 12480368, events = 0, fd = 758800752, user_data = 0x821dd8408}, {pos = 561654272, events = 8, fd = -932281378, user_data = 0x835b8f800}, {pos = 1, events = 8, fd = -932281762, user_data = 0x821dd1008}, {pos = 561654056, events = 8, fd = 561654272, user_data = 0x1ab8}, {pos = 11, events = 0, fd = -932202096, user_data = 0x0}, {pos = 561644415, events = 8, fd = 8134871, user_data = 0x8217a29b0}, {pos = 704558096, events = 8, fd = 759463984, user_data = 0x82d44a310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8217a29e0}, {pos = 704600989, events = 8, fd = 901189632, user_data = 0x1e2f}, {pos = 561654336, events = 8, fd = 704567546, user_data = 0x0}, {pos = 0, events = 0, fd = 1551757396, user_data = 0x0}} [00:16:03.223] last_touch_time = 1738195800 [00:16:03.223] last_lockfile_recheck_time = 1738195800 [00:16:03.223] nevents = 1 [00:16:03.223] #21 0x00000000008985e4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8217a3038) at ../src/backend/postmaster/postmaster.c:1386 [00:16:03.223] userDoption = [00:16:03.223] listen_addr_saved = false [00:16:03.223] output_config_variable = [00:16:03.223] opt = [00:16:03.223] status = [00:16:03.223] #22 0x00000000007cedb0 in main (argc=4, argv=0x8217a3038) at ../src/backend/main/main.c:230 [00:16:03.223] do_check_root = [00:16:03.223] dispatch_option = DISPATCH_POSTMASTER [00:16:03.233] [00:16:03.233] [00:16:03.233] [00:16:03.299] dumping /tmp/cores/postgres.17821.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:16:03.430] [New LWP 101866] [00:16:03.496] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [00:16:03.496] Program terminated with signal SIGABRT, Aborted. [00:16:03.496] Sent by thr_kill() from pid 17821 and user 1003. [00:16:03.496] #0 0x000000082b2f541a in thr_kill () from /lib/libc.so.7 [00:16:03.540] [00:16:03.540] Thread 1 (LWP 101866): [00:16:03.540] #0 0x000000082b2f541a in thr_kill () from /lib/libc.so.7 [00:16:03.540] No symbol table info available. [00:16:03.540] #1 0x000000082b26ee64 in raise () from /lib/libc.so.7 [00:16:03.540] No symbol table info available. [00:16:03.540] #2 0x000000082b31f6f9 in abort () from /lib/libc.so.7 [00:16:03.540] No symbol table info available. [00:16:03.540] #3 0x0000000000aa2ab5 in ExceptionalCondition (conditionName=0x2ed290 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=193) at ../src/backend/utils/error/assert.c:66 [00:16:03.540] No locals. [00:16:03.540] #4 0x0000000000769ae9 in standard_ExecutorStart (queryDesc=0x834a58bd0, eflags=0) at ../src/backend/executor/execMain.c:193 [00:16:03.540] estate = 0x8369dc100 [00:16:03.540] oldcontext = 0x834a5f800 [00:16:03.540] #5 0x00000008363e79c2 in pgss_ExecutorStart (queryDesc=0x834a58bd0, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [00:16:03.540] No locals. [00:16:03.540] #6 0x00000000006fdcdf in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [00:16:03.540] copied_query = [00:16:03.540] rewritten = [00:16:03.540] plan = 0x834a58778 [00:16:03.540] queryDesc = 0x834a58bd0 [00:16:03.540] processed = [00:16:03.540] __error = [00:16:03.540] #7 RefreshMatViewByOid (matviewOid=28489, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [00:16:03.540] dest = [00:16:03.540] save_userid = 10 [00:16:03.540] save_sec_context = 0 [00:16:03.540] processed = 0 [00:16:03.540] matviewRel = 0x836a63988 [00:16:03.540] relowner = 10 [00:16:03.540] save_nestlevel = 2 [00:16:03.540] rule = [00:16:03.540] actions = [00:16:03.540] dataQuery = [00:16:03.540] tableSpace = [00:16:03.540] relpersistence = [00:16:03.540] OIDNewHeap = 28496 [00:16:03.540] address = [00:16:03.540] #8 0x00000000006fd8b6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [00:16:03.540] lockmode = [00:16:03.540] matviewOid = 0 [00:16:03.540] #9 0x00000000006d48ac in ExecCreateTableAs (pstate=pstate@entry=0x834a5f900, stmt=stmt@entry=0x834adbfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x82173f4e0) at ../src/backend/commands/createas.c:351 [00:16:03.540] refresh = 0x0 [00:16:03.540] query = 0x834a66c48 [00:16:03.540] into = 0x834adbf40 [00:16:03.540] jstate = 0x0 [00:16:03.540] do_refresh = false [00:16:03.540] address = [00:16:03.540] dest = [00:16:03.540] is_matview = [00:16:03.540] #10 0x000000000094a23b in ProcessUtilitySlow (pstate=pstate@entry=0x834a5f900, pstmt=pstmt@entry=0x834adbe30, queryString=queryString@entry=0x83497e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x82173f4e0) at ../src/backend/tcop/utility.c:1678 [00:16:03.540] _local_sigjmp_buf = {{_sjb = {9738857, 0, 34920984392, 34920984768, 34920984400, 12563528, 0, 35243030784, 895, 1, 34920984524, 0}}} [00:16:03.540] _save_exception_stack = 0x82173f1d0 [00:16:03.540] _save_context_stack = 0x0 [00:16:03.540] _do_rethrow = false [00:16:03.540] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [00:16:03.540] parsetree = 0x834adbfd0 [00:16:03.540] commandCollected = false [00:16:03.540] needCleanup = false [00:16:03.540] address = [00:16:03.540] isTopLevel = [00:16:03.540] isCompleteQuery = [00:16:03.540] #11 0x0000000000948bb8 in standard_ProcessUtility (pstmt=0x834adbe30, queryString=queryString@entry=0x83497e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834a673e8, qc=0x82173f4e0) at ../src/backend/tcop/utility.c:1033 [00:16:03.540] isAtomicContext = false [00:16:03.540] parsetree = 0x834adbfd0 [00:16:03.540] readonly_flags = [00:16:03.540] pstate = 0x834a5f900 [00:16:03.540] isTopLevel = [00:16:03.540] #12 0x00000008363e7f6d in pgss_ProcessUtility (pstmt=0x834adbe30, queryString=0x83497e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834a673e8, qc=0x82173f4e0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [00:16:03.540] _local_sigjmp_buf = {{_sjb = {35269803686, 34920985040, 34920984904, 34920985360, 35243540016, 0, 12563528, 34920985568, 895, 1, 34920985156, 34359738368}}} [00:16:03.540] _save_exception_stack = 0x82173f3e0 [00:16:03.540] _save_context_stack = 0x0 [00:16:03.540] _do_rethrow = false [00:16:03.540] bufusage = {shared_blks_hit = 35269803686, shared_blks_read = 34920985040, shared_blks_dirtied = 34920984904, shared_blks_written = 34920985360, local_blks_hit = 35243540016, local_blks_read = 0, local_blks_dirtied = 12563528, local_blks_written = 34920985568, temp_blks_read = 895, temp_blks_written = 1, shared_blk_read_time = {ticks = 34920985156}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 4003398807777602048}, local_blk_write_time = {ticks = 12572456}, temp_blk_read_time = {ticks = 35296066688}, temp_blk_write_time = {ticks = 12513920}} [00:16:03.540] walusage_start = {wal_records = 8954, wal_fpi = 136, wal_bytes = 1239935} [00:16:03.540] duration = [00:16:03.540] bufusage_start = {shared_blks_hit = 153358, shared_blks_read = 9203, shared_blks_dirtied = 2754, shared_blks_written = 2547, local_blks_hit = 45, local_blks_read = 0, local_blks_dirtied = 10, local_blks_written = 17, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [00:16:03.540] walusage = {wal_records = 0, wal_fpi = 549755813888, wal_bytes = 12232107839984380388} [00:16:03.540] start = {ticks = -188945238316} [00:16:03.540] rows = [00:16:03.540] saved_queryId = 7267788456574341698 [00:16:03.540] parsetree = [00:16:03.540] saved_stmt_location = 0 [00:16:03.540] saved_stmt_len = 69 [00:16:03.540] enabled = [00:16:03.540] #13 0x0000000000948183 in PortalRunUtility (portal=0x834a24100, pstmt=0x834adbe30, isTopLevel=, setHoldSnapshot=, dest=0x834a673e8, qc=0x82173f4e0) at ../src/backend/tcop/pquery.c:1152 [00:16:03.540] No locals. [00:16:03.540] #14 0x0000000000947844 in PortalRunMulti (portal=portal@entry=0x834a24100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x834a673e8, altdest=altdest@entry=0x834a673e8, qc=qc@entry=0x82173f4e0) at ../src/backend/tcop/pquery.c:1316 [00:16:03.540] pstmt = 0x834adbe30 [00:16:03.540] stmtlist_item__state = {l = 0x834a67398, i = 0} [00:16:03.540] active_snapshot_set = false [00:16:03.540] stmtlist_item = 0x834a673b0 [00:16:03.540] #15 0x000000000094712b in PortalRun (portal=portal@entry=0x834a24100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x834a673e8, altdest=altdest@entry=0x834a673e8, qc=qc@entry=0x82173f4e0) at ../src/backend/tcop/pquery.c:787 [00:16:03.540] _local_sigjmp_buf = {{_sjb = {9728165, 35242787072, 34920985560, 34920985808, 34920985568, 12563528, 34920985824, 12517960, 12518271, 0, 35242771327, 34359738368}}} [00:16:03.540] _save_exception_stack = 0x82173f590 [00:16:03.540] _save_context_stack = 0x0 [00:16:03.540] _do_rethrow = false [00:16:03.540] saveTopTransactionResourceOwner = 0x834a79758 [00:16:03.540] saveTopTransactionContext = 0x834a28000 [00:16:03.540] saveActivePortal = 0x0 [00:16:03.540] saveResourceOwner = 0x834a79758 [00:16:03.540] savePortalContext = 0x0 [00:16:03.540] saveMemoryContext = 0x834a28000 [00:16:03.540] result = [00:16:03.540] nprocessed = [00:16:03.540] #16 0x0000000000945fb9 in exec_simple_query (query_string=query_string@entry=0x83497e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [00:16:03.540] cmdtaglen = 24 [00:16:03.540] snapshot_set = [00:16:03.540] per_parsetree_context = 0x0 [00:16:03.540] plantree_list = [00:16:03.540] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:16:03.540] format = 0 [00:16:03.540] parsetree = 0x83497f6a8 [00:16:03.540] commandTag = [00:16:03.540] cmdtagname = [00:16:03.540] querytree_list = [00:16:03.540] portal = 0x834a24100 [00:16:03.540] receiver = 0x834a673e8 [00:16:03.540] parsetree_item__state = {l = 0x83497fa18, i = 0} [00:16:03.540] msec_str = "\000\000\000\000\b", '\000' , "\226Úg\000\000\000\000of(\272d", [00:16:03.540] dest = DestRemote [00:16:03.540] was_logged = [00:16:03.540] oldcontext = 0x834a28000 [00:16:03.540] parsetree_list = 0x83497fa18 [00:16:03.540] use_implicit_block = false [00:16:03.540] parsetree_item = 0x83497fa30 [00:16:03.540] save_log_statement_stats = [00:16:03.540] #17 0x0000000000943c23 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [00:16:03.540] query_string = 0x83497e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [00:16:03.540] input_message = {data = 0x83497e100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [00:16:03.540] firstchar = [00:16:03.540] local_sigjmp_buf = {{_sjb = {9711830, 34920986000, 34920985992, 34920986544, 12572280, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [00:16:03.540] send_ready_for_query = false [00:16:03.540] idle_in_transaction_timeout_enabled = false [00:16:03.540] idle_session_timeout_enabled = false [00:16:03.540] #18 0x000000000093e5c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [00:16:03.540] bsdata = [00:16:03.540] #19 0x0000000000895e05 in postmaster_child_launch (child_type=B_BACKEND, child_slot=18, startup_data=startup_data@entry=0x8217402c0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821740210) at ../src/backend/postmaster/launch_backend.c:274 [00:16:03.540] pid = [00:16:03.540] #20 0x000000000089a1ab in BackendStartup (client_sock=0x821740210) at ../src/backend/postmaster/postmaster.c:3519 [00:16:03.540] startup_data = {canAcceptConnections = CAC_OK} [00:16:03.540] bn = 0x834a65f68 [00:16:03.540] cac = CAC_OK [00:16:03.540] pid = [00:16:03.540] __error = [00:16:03.540] save_errno = [00:16:03.540] __error = [00:16:03.540] __error = [00:16:03.540] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [00:16:03.540] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\f", '\000' , "p\002t!\b\000\000\000h\205\277+\b\000\000\000W\000\000\000\000\000\000\000^\017\300+\b", '\000' , "\260\002t!\b\000\000\000\224[\211\000\000\000\000\000\300\002t!\b", '\000' }, salen = 16}} [00:16:03.540] i = 0 [00:16:03.540] now = [00:16:03.540] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 882775512, events = 8, fd = 561250384, user_data = 0x0}, {pos = 1705870090, events = 6579, fd = 723314592, user_data = 0x82b1dfd78}, {pos = 561249480, events = 8, fd = 561249600, user_data = 0x82173fcc8}, {pos = 1705870090, events = 6579, fd = 723293064, user_data = 0x82b1dfd78}, {pos = 561249528, events = 8, fd = 561249648, user_data = 0x82173fcf8}, {pos = 723354004, events = 8, fd = 561517576, user_data = 0x82b1d8194}, {pos = 561249632, events = 8, fd = 1705849914, user_data = 0x82173fd00}, {pos = 733963280, events = 8, fd = 725176368, user_data = 0x19b365ad830a}, {pos = 723261528, events = 8, fd = 723385720, user_data = 0x82173fd68}, {pos = 561249760, events = 8, fd = 561249640, user_data = 0x82b1d6d0c}, {pos = 561517576, events = 8, fd = 723348748, user_data = 0x82173fdd0}, {pos = 1705849914, events = 6579, fd = 561249784, user_data = 0x82173ffc8}, {pos = 561249760, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821787038}, {pos = 1, events = 2848009541, fd = 561517576, user_data = 0x82b1c9388}, {pos = 561539016, events = 8, fd = 0, user_data = 0x0}, {pos = 561249896, events = 8, fd = 561250360, user_data = 0x82173fe50}, {pos = 1705868450, events = 6579, fd = 2722358, user_data = 0x6d68b}, {pos = 2090263927, events = 2848009541, fd = 561541176, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821740138}, {pos = 561517576, events = 3, fd = 561250432, user_data = 0x821786828}, {pos = 656, events = 0, fd = 561250360, user_data = 0x82173fe68}, {pos = 561250000, events = 8, fd = 1705868059, user_data = 0x821740000}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 561541176, events = 8, fd = 1, user_data = 0x821781408}, {pos = 723261528, events = 8, fd = 561250616, user_data = 0x821740080}, {pos = 561250016, events = 8, fd = 0, user_data = 0x82177a008}, {pos = 33, events = 0, fd = 561250416, user_data = 0x19b365ad1ae7}, {pos = 561487880, events = 8, fd = 561488904, user_data = 0x82177a808}, {pos = 561490952, events = 8, fd = 561504264, user_data = 0x82177e408}, {pos = 561506312, events = 8, fd = 561507336, user_data = 0x82177f008}, {pos = 561509384, events = 8, fd = 561510408, user_data = 0x82177fc08}, {pos = 561512456, events = 8, fd = 561513480, user_data = 0x821780808}, {pos = 561515528, events = 8, fd = 561516552, user_data = 0x821781408}, {pos = 561518600, events = 8, fd = 561519624, user_data = 0x821782008}, {pos = 561521672, events = 8, fd = 561522696, user_data = 0x821782c08}, {pos = 561524744, events = 8, fd = 561525768, user_data = 0x821783808}, {pos = 561527816, events = 8, fd = 561532936, user_data = 0x821785408}, {pos = 561534984, events = 8, fd = 561536008, user_data = 0x821788408}, {pos = 558772000, events = 0, fd = 561487880, user_data = 0x298a36}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821787038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 561250616, events = 8, fd = 561250016, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 561541176, user_data = 0x1}, {pos = 561487880, events = 8, fd = 298, user_data = 0x821740120}, {pos = 1705842159, events = 6579, fd = 2722358, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 561541176, user_data = 0x1}, {pos = 561517576, events = 8, fd = 882302976, user_data = 0x1}, {pos = 882303380, events = 8, fd = 0, user_data = 0x8217400f0}, {pos = 734004588, events = 8, fd = 1, user_data = 0x83496e000}, {pos = 561250592, events = 8, fd = 734000898, user_data = 0x82b2f3170 }, {pos = 12480368, events = 0, fd = 724513136, user_data = 0x821781408}, {pos = 561250816, events = 8, fd = 1705841630, user_data = 0x83498c800}, {pos = 1, events = 8, fd = 1705841246, user_data = 0x82177a008}, {pos = 561250600, events = 8, fd = 561250816, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1705920912, user_data = 0x0}, {pos = 561251199, events = 8, fd = 8134871, user_data = 0x8217401b0}, {pos = 733963280, events = 8, fd = 725176368, user_data = 0x82b397310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8217401e0}, {pos = 734006173, events = 8, fd = 882302976, user_data = 0x3678}, {pos = 561250880, events = 8, fd = 733972730, user_data = 0x0}, {pos = 0, events = 0, fd = -1601558044, user_data = 0x0}} [00:16:03.540] last_touch_time = 1738195837 [00:16:03.540] last_lockfile_recheck_time = 1738195837 [00:16:03.540] nevents = 1 [00:16:03.540] #22 0x00000000008985e4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821740830) at ../src/backend/postmaster/postmaster.c:1386 [00:16:03.540] userDoption = [00:16:03.540] listen_addr_saved = false [00:16:03.540] output_config_variable = [00:16:03.540] opt = [00:16:03.540] status = [00:16:03.540] #23 0x00000000007cedb0 in main (argc=4, argv=0x821740830) at ../src/backend/main/main.c:230 [00:16:03.540] do_check_root = [00:16:03.540] dispatch_option = DISPATCH_POSTMASTER