[14:48:46.249] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [14:48:46.608] dumping /tmp/cores/postgres.10706.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [14:48:46.744] [New LWP 101959] [14:48:46.835] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [14:48:46.835] Program terminated with signal SIGABRT, Aborted. [14:48:46.835] Sent by thr_kill() from pid 10706 and user 1003. [14:48:46.835] #0 0x000000082c94a41a in thr_kill () from /lib/libc.so.7 [14:48:46.896] [14:48:46.896] Thread 1 (LWP 101959): [14:48:46.896] #0 0x000000082c94a41a in thr_kill () from /lib/libc.so.7 [14:48:46.896] No symbol table info available. [14:48:46.896] #1 0x000000082c8c3e64 in raise () from /lib/libc.so.7 [14:48:46.896] No symbol table info available. [14:48:46.896] #2 0x000000082c9746f9 in abort () from /lib/libc.so.7 [14:48:46.896] No symbol table info available. [14:48:46.896] #3 0x0000000000aa1665 in ExceptionalCondition (conditionName=0x2ecf40 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [14:48:46.896] No locals. [14:48:46.896] #4 0x000000000076f379 in standard_ExecutorStart (queryDesc=0x837606b40, eflags=0) at ../src/backend/executor/execMain.c:195 [14:48:46.896] estate = 0x839b02100 [14:48:46.896] oldcontext = 0x837697800 [14:48:46.896] #5 0x0000000000704d15 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [14:48:46.896] copied_query = [14:48:46.896] rewritten = [14:48:46.896] plan = 0x8376066e8 [14:48:46.896] queryDesc = 0x837606b40 [14:48:46.896] processed = [14:48:46.896] __error = [14:48:46.896] #6 RefreshMatViewByOid (matviewOid=28341, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [14:48:46.896] dest = [14:48:46.896] save_userid = 10 [14:48:46.896] save_sec_context = 0 [14:48:46.896] processed = 0 [14:48:46.896] matviewRel = 0x839b8dd68 [14:48:46.896] relowner = 10 [14:48:46.896] save_nestlevel = 2 [14:48:46.896] rule = [14:48:46.896] actions = [14:48:46.896] dataQuery = [14:48:46.896] tableSpace = [14:48:46.896] relpersistence = [14:48:46.896] OIDNewHeap = 28351 [14:48:46.896] address = [14:48:46.896] #7 0x00000000007048f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [14:48:46.896] lockmode = [14:48:46.896] matviewOid = 0 [14:48:46.896] #8 0x00000000006db9ec in ExecCreateTableAs (pstate=pstate@entry=0x837697900, stmt=stmt@entry=0x83764bfd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8219bce50) at ../src/backend/commands/createas.c:351 [14:48:46.896] refresh = 0x0 [14:48:46.896] query = 0x839c3fc58 [14:48:46.896] into = 0x839c3ffa0 [14:48:46.896] jstate = 0x0 [14:48:46.896] do_refresh = false [14:48:46.896] address = [14:48:46.896] dest = [14:48:46.896] is_matview = [14:48:46.896] #9 0x000000000094c1d8 in ProcessUtilitySlow (pstate=pstate@entry=0x837697900, pstmt=pstmt@entry=0x837599a68, queryString=queryString@entry=0x837598100 "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=0x8219bce50) at ../src/backend/tcop/utility.c:1678 [14:48:46.896] _local_sigjmp_buf = {{_sjb = {9746953, 0, 34923596408, 34923596784, 34923596416, 12441752, 0, 35289397504, 4294902655, 34923596524, 34923596560, 0}}} [14:48:46.896] _save_exception_stack = 0x8219bcd50 [14:48:46.896] _save_context_stack = 0x0 [14:48:46.896] _do_rethrow = false [14:48:46.896] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [14:48:46.896] parsetree = 0x83764bfd0 [14:48:46.896] commandCollected = false [14:48:46.896] needCleanup = false [14:48:46.896] address = [14:48:46.896] isTopLevel = [14:48:46.896] isCompleteQuery = [14:48:46.896] #10 0x000000000094ab58 in standard_ProcessUtility (pstmt=0x837599a68, queryString=0x837598100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x839c40488, qc=0x8219bce50) at ../src/backend/tcop/utility.c:1033 [14:48:46.896] isAtomicContext = false [14:48:46.896] parsetree = 0x83764bfd0 [14:48:46.896] readonly_flags = [14:48:46.896] pstate = 0x837697900 [14:48:46.896] isTopLevel = [14:48:46.896] #11 0x000000000094a5e8 in ProcessUtility (pstmt=0x18e47, queryString=0x6 , readOnlyTree=, context=747938810, params=0x0, queryEnv=0x0, dest=0x839c40488, qc=0x8219bce50) at ../src/backend/tcop/utility.c:523 [14:48:46.896] No locals. [14:48:46.896] #12 0x000000000094a123 in PortalRunUtility (portal=0x83766f100, pstmt=0x837599a68, isTopLevel=, setHoldSnapshot=, dest=0x839c40488, qc=0x8219bce50) at ../src/backend/tcop/pquery.c:1158 [14:48:46.896] No locals. [14:48:46.896] #13 0x00000000009497b4 in PortalRunMulti (portal=portal@entry=0x83766f100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x839c40488, altdest=altdest@entry=0x839c40488, qc=0x8219bce50) at ../src/backend/tcop/pquery.c:1322 [14:48:46.896] pstmt = 0x837599a68 [14:48:46.896] stmtlist_item__state = {l = 0x839c40438, i = 0} [14:48:46.896] active_snapshot_set = false [14:48:46.896] stmtlist_item = 0x839c40450 [14:48:46.896] #14 0x0000000000949083 in PortalRun (portal=portal@entry=0x83766f100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x839c40488, altdest=altdest@entry=0x839c40488, qc=0x8219bce50) at ../src/backend/tcop/pquery.c:791 [14:48:46.896] _local_sigjmp_buf = {{_sjb = {9736189, 35289231616, 34923597128, 34923597360, 34923597136, 35289247744, 12407352, 12441752, 35289236351, 35289081232, 4294967984, 0}}} [14:48:46.896] _save_exception_stack = 0x8219bcf20 [14:48:46.896] _save_context_stack = 0x0 [14:48:46.896] _do_rethrow = false [14:48:46.896] saveTopTransactionResourceOwner = 0x8376807d8 [14:48:46.896] saveTopTransactionContext = 0x837673000 [14:48:46.896] saveActivePortal = 0x0 [14:48:46.896] saveResourceOwner = 0x8376807d8 [14:48:46.896] savePortalContext = 0x0 [14:48:46.896] saveMemoryContext = 0x837673000 [14:48:46.896] result = [14:48:46.896] nprocessed = [14:48:46.896] #15 0x0000000000947f02 in exec_simple_query (query_string=query_string@entry=0x837598100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [14:48:46.896] cmdtaglen = 24 [14:48:46.896] snapshot_set = [14:48:46.896] per_parsetree_context = 0x0 [14:48:46.896] plantree_list = [14:48:46.896] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:48:46.896] format = 0 [14:48:46.896] parsetree = 0x8375996a8 [14:48:46.896] commandTag = [14:48:46.896] cmdtagname = [14:48:46.896] querytree_list = [14:48:46.896] portal = 0x83766f100 [14:48:46.896] receiver = 0x839c40488 [14:48:46.896] parsetree_item__state = {l = 0x837599a18, i = 0} [14:48:46.896] msec_str = "\000\000\000\000\b", '\000' , "\276^Tg\000\000\000\000\214p}e\026T\033\036" [14:48:46.896] dest = DestRemote [14:48:46.896] was_logged = [14:48:46.896] oldcontext = 0x837673000 [14:48:46.896] parsetree_list = 0x837599a18 [14:48:46.896] use_implicit_block = false [14:48:46.896] parsetree_item = 0x837599a30 [14:48:46.896] save_log_statement_stats = [14:48:46.896] #16 0x0000000000945b73 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4818 [14:48:46.896] query_string = 0x837598100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [14:48:46.896] input_message = {data = 0x837598100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [14:48:46.896] firstchar = [14:48:46.896] local_sigjmp_buf = {{_sjb = {9719846, 34923597600, 34923597560, 34923598144, 12450488, 1, 8192, 8388608, 34923545471, 0, 0, 1}}} [14:48:46.896] send_ready_for_query = false [14:48:46.896] idle_in_transaction_timeout_enabled = false [14:48:46.896] idle_session_timeout_enabled = false [14:48:46.896] #17 0x0000000000940309 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [14:48:46.896] bsdata = [14:48:46.896] #18 0x0000000000898435 in postmaster_child_launch (child_type=B_BACKEND, child_slot=18, startup_data=startup_data@entry=0x8219bdc58 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8219bdba0) at ../src/backend/postmaster/launch_backend.c:274 [14:48:46.896] pid = [14:48:46.896] #19 0x000000000089c618 in BackendStartup (client_sock=0x8219bdba0) at ../src/backend/postmaster/postmaster.c:3390 [14:48:46.896] startup_data = {canAcceptConnections = CAC_OK} [14:48:46.896] bn = 0x83763b368 [14:48:46.896] cac = CAC_OK [14:48:46.896] pid = [14:48:46.896] __error = [14:48:46.896] save_errno = [14:48:46.896] __error = [14:48:46.896] __error = [14:48:46.896] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [14:48:46.896] 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' , "ܛ!\b\000\000\000hE\300*\b\000\000\000\355\000\000\000\000\000\000\000^\317\300*\b", '\000' , "@ܛ!\b\000\000\000ԁ\211\000\000\000\000\000Pܛ!\b", '\000' }, salen = 16}} [14:48:46.896] i = 0 [14:48:46.896] now = [14:48:46.896] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 746818243, events = 8, fd = 128686702, user_data = 0x3bd21c93dacf}, {pos = 573495864, events = 8, fd = 1, user_data = 0x8222e7408}, {pos = 746688872, events = 8, fd = -552366732, user_data = 0x8219bd368}, {pos = 563860320, events = 8, fd = 8192, user_data = 0x101000}, {pos = 929509376, events = 8, fd = 563860128, user_data = 0x82c9b9a47}, {pos = 1, events = 0, fd = 1052672, user_data = 0xe8}, {pos = 0, events = 0, fd = 573456392, user_data = 0x8222e4408}, {pos = 573458440, events = 8, fd = 573459464, user_data = 0x8219bd360}, {pos = 563860312, events = 8, fd = 896852112, user_data = 0x836600980}, {pos = 32, events = 0, fd = 4096, user_data = 0x8219bd520}, {pos = 748374652, events = 8, fd = 563860192, user_data = 0x82c9b9b22}, {pos = 563860312, events = 8, fd = 896852112, user_data = 0x20}, {pos = 4096, events = 0, fd = 563860768, user_data = 0x82c9b5098}, {pos = 912261328, events = 8, fd = 896852112, user_data = 0x3000}, {pos = 8192, events = 0, fd = 896852160, user_data = 0x1000}, {pos = 4097, events = 0, fd = 8192, user_data = 0x836600980}, {pos = 563861904, events = 8, fd = 912283864, user_data = 0x0}, {pos = 0, events = 0, fd = 912312448, user_data = 0x0}, {pos = 912312320, events = 8, fd = 232, user_data = 0x1}, {pos = 912263552, events = 8, fd = 563861904, user_data = 0x20}, {pos = 8388608, events = 0, fd = 8192, user_data = 0x83660c580}, {pos = 939242512, events = 8, fd = 939242504, user_data = 0x837fbb400}, {pos = 939242488, events = 8, fd = 8417280, user_data = 0x837667000}, {pos = 8193, events = 0, fd = 563860432, user_data = 0x8219bd3d0}, {pos = 1, events = 0, fd = 928547220, user_data = 0x0}, {pos = 563860528, events = 8, fd = 717276524, user_data = 0x1}, {pos = 928546816, events = 8, fd = 563860576, user_data = 0x82ac0b702}, {pos = 748525904, events = 8, fd = 748614008, user_data = 0x82c9d9950 }, {pos = 573469704, events = 8, fd = 563860800, user_data = 0x3bd221e543de}, {pos = 573460488, events = 8, fd = 1, user_data = 0x3bd221e5425e}, {pos = 573469704, events = 8, fd = 563860584, user_data = 0x8219bd540}, {pos = 12264, events = 0, fd = 0, user_data = 0x3bd221e67990}, {pos = 563862192, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = -552366732, events = 2228156090, fd = 0, user_data = 0x8222e7408}, {pos = 12264, events = 0, fd = -552366732, user_data = 0x83574e090}, {pos = 1, events = 0, fd = 912283864, user_data = 0x836600980}, {pos = 0, events = 0, fd = 563860912, user_data = 0x82c8d8915 }, {pos = 0, events = 0, fd = 563860848, user_data = 0x8219bd9e0}, {pos = 0, events = 0, fd = 563860912, user_data = 0x82c8eeb61}, {pos = 1, events = 0, fd = 563861984, user_data = 0x8219bd9e0}, {pos = 0, events = 16777216, fd = -552366732, user_data = 0x82c9fd6a0 <__stack_chk_guard>}, {pos = 928990680, events = 8, fd = 0, user_data = 0x82c9e2e38}, {pos = 563862192, events = 8, fd = 563862048, user_data = 0x82c8eec82}, {pos = 0, events = 0, fd = 563862352, user_data = 0x8375f45d8}, {pos = 563861984, events = 8, fd = 563861312, user_data = 0x2000}, {pos = 8192, events = 0, fd = 929460224, user_data = 0x8219bd748}, {pos = 0, events = 0, fd = 896852112, user_data = 0x1}, {pos = 563861120, events = 8, fd = 748394953, user_data = 0x82c81e388}, {pos = 746802552, events = 8, fd = 563861144, user_data = 0x8219bd710}, {pos = 563861312, events = 8, fd = 563861304, user_data = 0x83574e090}, {pos = 912263552, events = 8, fd = 32, user_data = 0x1000}, {pos = 563861760, events = 8, fd = 748374652, user_data = 0x8219bd738}, {pos = 568701706, events = 15314, fd = 746678360, user_data = 0x82c834d78}, {pos = 563861256, events = 8, fd = 563861376, user_data = 0x8219bd708}, {pos = 746765580, events = 8, fd = 573469704, user_data = 0x82c82bd0c}, {pos = 563861360, events = 8, fd = 568681530, user_data = 0x83574e0c0}, {pos = 4096, events = 0, fd = 4097, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x836603238}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 573489800, user_data = 0x82c816858}, {pos = 573469704, events = 8, fd = 563861512, user_data = 0x8219bd9c8}, {pos = 563861488, events = 8, fd = 568700066, user_data = 0x2981b4}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8222ed038}} [14:48:46.896] last_touch_time = 1733582505 [14:48:46.896] last_lockfile_recheck_time = 1733582505 [14:48:46.896] nevents = 1 [14:48:46.896] #21 0x000000000089ac19 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8219be1c8) at ../src/backend/postmaster/postmaster.c:1374 [14:48:46.896] userDoption = [14:48:46.896] listen_addr_saved = false [14:48:46.896] output_config_variable = [14:48:46.896] opt = [14:48:46.896] status = [14:48:46.896] #22 0x00000000007d292d in main (argc=8, argv=0x8219be1c8) at ../src/backend/main/main.c:222 [14:48:46.896] do_check_root = [14:48:46.896] dispatch_option = DISPATCH_POSTMASTER [14:48:46.907] [14:48:46.907] [14:48:46.907] [14:48:46.969] dumping /tmp/cores/postgres.11257.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [14:48:47.090] [New LWP 101854] [14:48:47.160] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [14:48:47.160] Program terminated with signal SIGABRT, Aborted. [14:48:47.160] Sent by thr_kill() from pid 11257 and user 1003. [14:48:47.160] #0 0x000000082d5aa41a in thr_kill () from /lib/libc.so.7 [14:48:47.192] [14:48:47.192] Thread 1 (LWP 101854): [14:48:47.192] #0 0x000000082d5aa41a in thr_kill () from /lib/libc.so.7 [14:48:47.192] No symbol table info available. [14:48:47.192] #1 0x000000082d523e64 in raise () from /lib/libc.so.7 [14:48:47.192] No symbol table info available. [14:48:47.192] #2 0x000000082d5d46f9 in abort () from /lib/libc.so.7 [14:48:47.192] No symbol table info available. [14:48:47.192] #3 0x0000000000aa1665 in ExceptionalCondition (conditionName=0x2ecf40 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [14:48:47.192] No locals. [14:48:47.192] #4 0x000000000076f379 in standard_ExecutorStart (queryDesc=0x83596bb40, eflags=0) at ../src/backend/executor/execMain.c:195 [14:48:47.192] estate = 0x835a5c100 [14:48:47.192] oldcontext = 0x83598a800 [14:48:47.192] #5 0x0000000000704d15 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [14:48:47.192] copied_query = [14:48:47.192] rewritten = [14:48:47.192] plan = 0x83596b6e8 [14:48:47.192] queryDesc = 0x83596bb40 [14:48:47.192] processed = [14:48:47.192] __error = [14:48:47.192] #6 RefreshMatViewByOid (matviewOid=28425, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [14:48:47.192] dest = [14:48:47.192] save_userid = 10 [14:48:47.192] save_sec_context = 0 [14:48:47.192] processed = 0 [14:48:47.192] matviewRel = 0x838482938 [14:48:47.192] relowner = 10 [14:48:47.192] save_nestlevel = 2 [14:48:47.192] rule = [14:48:47.192] actions = [14:48:47.192] dataQuery = [14:48:47.192] tableSpace = [14:48:47.192] relpersistence = [14:48:47.192] OIDNewHeap = 28433 [14:48:47.192] address = [14:48:47.192] #7 0x00000000007048f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [14:48:47.192] lockmode = [14:48:47.192] matviewOid = 0 [14:48:47.192] #8 0x00000000006db9ec in ExecCreateTableAs (pstate=pstate@entry=0x83598a900, stmt=stmt@entry=0x838363fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x8216e64c0) at ../src/backend/commands/createas.c:351 [14:48:47.192] refresh = 0x0 [14:48:47.192] query = 0x838525d98 [14:48:47.192] into = 0x8385260e0 [14:48:47.192] jstate = 0x0 [14:48:47.192] do_refresh = false [14:48:47.192] address = [14:48:47.192] dest = [14:48:47.192] is_matview = [14:48:47.192] #9 0x000000000094c1d8 in ProcessUtilitySlow (pstate=pstate@entry=0x83598a900, pstmt=pstmt@entry=0x835898a68, queryString=queryString@entry=0x835897100 "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=0x8216e64c0) at ../src/backend/tcop/utility.c:1678 [14:48:47.192] _local_sigjmp_buf = {{_sjb = {9746953, 0, 34920620264, 34920620640, 34920620272, 12441752, 0, 35258935552, 4294902655, 34920620380, 34920620416, 0}}} [14:48:47.192] _save_exception_stack = 0x8216e63c0 [14:48:47.192] _save_context_stack = 0x0 [14:48:47.192] _do_rethrow = false [14:48:47.192] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [14:48:47.192] parsetree = 0x838363fd0 [14:48:47.192] commandCollected = false [14:48:47.192] needCleanup = false [14:48:47.192] address = [14:48:47.192] isTopLevel = [14:48:47.192] isCompleteQuery = [14:48:47.192] #10 0x000000000094ab58 in standard_ProcessUtility (pstmt=0x835898a68, queryString=0x835897100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8385265c8, qc=0x8216e64c0) at ../src/backend/tcop/utility.c:1033 [14:48:47.192] isAtomicContext = false [14:48:47.192] parsetree = 0x838363fd0 [14:48:47.192] readonly_flags = [14:48:47.192] pstate = 0x83598a900 [14:48:47.192] isTopLevel = [14:48:47.192] #11 0x000000000094a5e8 in ProcessUtility (pstmt=0x18dde, queryString=0x6 , readOnlyTree=, context=760914938, params=0x0, queryEnv=0x0, dest=0x8385265c8, qc=0x8216e64c0) at ../src/backend/tcop/utility.c:523 [14:48:47.192] No locals. [14:48:47.192] #12 0x000000000094a123 in PortalRunUtility (portal=0x83593d100, pstmt=0x835898a68, isTopLevel=, setHoldSnapshot=, dest=0x8385265c8, qc=0x8216e64c0) at ../src/backend/tcop/pquery.c:1158 [14:48:47.192] No locals. [14:48:47.192] #13 0x00000000009497b4 in PortalRunMulti (portal=portal@entry=0x83593d100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8385265c8, altdest=altdest@entry=0x8385265c8, qc=0x8216e64c0) at ../src/backend/tcop/pquery.c:1322 [14:48:47.192] pstmt = 0x835898a68 [14:48:47.192] stmtlist_item__state = {l = 0x838526578, i = 0} [14:48:47.192] active_snapshot_set = false [14:48:47.192] stmtlist_item = 0x838526590 [14:48:47.192] #14 0x0000000000949083 in PortalRun (portal=portal@entry=0x83593d100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x8385265c8, altdest=altdest@entry=0x8385265c8, qc=0x8216e64c0) at ../src/backend/tcop/pquery.c:791 [14:48:47.192] _local_sigjmp_buf = {{_sjb = {9736189, 35258618112, 34920620984, 34920621216, 34920620992, 35258634240, 12407352, 12441752, 35258565503, 35302811024, 4294967984, 0}}} [14:48:47.192] _save_exception_stack = 0x8216e6590 [14:48:47.192] _save_context_stack = 0x0 [14:48:47.192] _do_rethrow = false [14:48:47.192] saveTopTransactionResourceOwner = 0x83598c118 [14:48:47.192] saveTopTransactionContext = 0x835941000 [14:48:47.192] saveActivePortal = 0x0 [14:48:47.192] saveResourceOwner = 0x83598c118 [14:48:47.192] savePortalContext = 0x0 [14:48:47.192] saveMemoryContext = 0x835941000 [14:48:47.192] result = [14:48:47.192] nprocessed = [14:48:47.192] #15 0x0000000000947f02 in exec_simple_query (query_string=query_string@entry=0x835897100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [14:48:47.192] cmdtaglen = 24 [14:48:47.192] snapshot_set = [14:48:47.192] per_parsetree_context = 0x0 [14:48:47.192] plantree_list = [14:48:47.192] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:48:47.192] format = 0 [14:48:47.192] parsetree = 0x8358986a8 [14:48:47.192] commandTag = [14:48:47.192] cmdtagname = [14:48:47.192] querytree_list = [14:48:47.192] portal = 0x83593d100 [14:48:47.192] receiver = 0x8385265c8 [14:48:47.192] parsetree_item__state = {l = 0x835898a18, i = 0} [14:48:47.192] msec_str = "\000\000\000\000\b", '\000' , "\301^Tg\000\000\000\000d\215)a\025\006", [14:48:47.192] dest = DestRemote [14:48:47.192] was_logged = [14:48:47.192] oldcontext = 0x835941000 [14:48:47.192] parsetree_list = 0x835898a18 [14:48:47.192] use_implicit_block = false [14:48:47.192] parsetree_item = 0x835898a30 [14:48:47.192] save_log_statement_stats = [14:48:47.192] #16 0x0000000000945b73 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4818 [14:48:47.192] query_string = 0x835897100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [14:48:47.192] input_message = {data = 0x835897100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [14:48:47.192] firstchar = [14:48:47.192] local_sigjmp_buf = {{_sjb = {9719846, 34920621456, 34920621416, 34920622000, 12450488, 1, 8192, 8388608, 34920596351, 0, 0, 1}}} [14:48:47.192] send_ready_for_query = false [14:48:47.192] idle_in_transaction_timeout_enabled = false [14:48:47.192] idle_session_timeout_enabled = false [14:48:47.192] #17 0x0000000000940309 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [14:48:47.192] bsdata = [14:48:47.192] #18 0x0000000000898435 in postmaster_child_launch (child_type=B_BACKEND, child_slot=18, startup_data=startup_data@entry=0x8216e72c8 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8216e7210) at ../src/backend/postmaster/launch_backend.c:274 [14:48:47.192] pid = [14:48:47.192] #19 0x000000000089c618 in BackendStartup (client_sock=0x8216e7210) at ../src/backend/postmaster/postmaster.c:3390 [14:48:47.192] startup_data = {canAcceptConnections = CAC_OK} [14:48:47.192] bn = 0x83595b368 [14:48:47.192] cac = CAC_OK [14:48:47.192] pid = [14:48:47.192] __error = [14:48:47.192] save_errno = [14:48:47.192] __error = [14:48:47.192] __error = [14:48:47.192] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [14:48:47.192] 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' , "prn!\b\000\000\000h\005\331+\b\000\000\000\331\000\000\000\000\000\000\000^\217\331+\b", '\000' , "\260rn!\b\000\000\000ԁ\211\000\000\000\000\000\300rn!\b", '\000' }, salen = 16}} [14:48:47.192] i = 0 [14:48:47.192] now = [14:48:47.192] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 759794371, events = 8, fd = 128686702, user_data = 0x1f8f1c93dacf}, {pos = 572619320, events = 8, fd = 1, user_data = 0x822211408}, {pos = 759665000, events = 8, fd = 560884456, user_data = 0x8216e6a30}, {pos = 560883872, events = 8, fd = 1, user_data = 0x822211408}, {pos = 32, events = 0, fd = 560884256, user_data = 0x1f8f5cb90a1a}, {pos = 572563464, events = 8, fd = 572564488, user_data = 0x82220a808}, {pos = 572566536, events = 8, fd = 572579848, user_data = 0x82220e408}, {pos = 572581896, events = 8, fd = 572582920, user_data = 0x82220f008}, {pos = 572584968, events = 8, fd = 572585992, user_data = 0x82220fc08}, {pos = 572588040, events = 8, fd = 572589064, user_data = 0x822210808}, {pos = 572591112, events = 8, fd = 572592136, user_data = 0x822211408}, {pos = -25761258, events = 8, fd = 572616760, user_data = 0x1}, {pos = 572593160, events = 8, fd = 759686264, user_data = 0x8216e6c68}, {pos = 2841949, events = 0, fd = 560884656, user_data = 0x8216e6a20}, {pos = 1, events = 0, fd = 560884584, user_data = 0x20}, {pos = 560884240, events = 8, fd = 1555655283, user_data = 0x822211408}, {pos = 759794371, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 572619320, events = 8, fd = 1, user_data = 0x822211408}, {pos = 759665000, events = 8, fd = 560884456, user_data = 0x8216e68a0}, {pos = 32, events = 18, fd = 0, user_data = 0x822217a38}, {pos = 1, events = 0, fd = 572593160, user_data = 0x347}, {pos = 560884432, events = 8, fd = 1555629551, user_data = 0x82d498ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822217a38}, {pos = 1, events = 0, fd = 572593160, user_data = 0x835887000}, {pos = 1, events = 0, fd = 898134420, user_data = 0x0}, {pos = 560884384, events = 8, fd = 735675756, user_data = 0x1}, {pos = 898134016, events = 8, fd = 560884432, user_data = 0x82bd97702}, {pos = 761502032, events = 8, fd = 761590136, user_data = 0x82d639950 }, {pos = 572593160, events = 8, fd = 560884656, user_data = 0x1f8f5cb903de}, {pos = 572583944, events = 8, fd = 1, user_data = 0x1f8f5cb9025e}, {pos = 572593160, events = 8, fd = 560884440, user_data = 0x8216e6bb0}, {pos = 12264, events = 0, fd = 0, user_data = 0x1f8f5cba3990}, {pos = 560886048, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = -1703934390, events = 3987749821, fd = 0, user_data = 0x822211408}, {pos = 12264, events = 0, fd = 759644160, user_data = 0x1db178}, {pos = 761502032, events = 8, fd = 759778680, user_data = 0x3d4b}, {pos = 761648800, events = 8, fd = 560884768, user_data = 0x82d538915 }, {pos = 761540152, events = 8, fd = 560884704, user_data = 0x8216e7050}, {pos = 0, events = 0, fd = 560884768, user_data = 0x82d54eb61}, {pos = 1, events = 0, fd = 560885840, user_data = 0x8216e7050}, {pos = 0, events = 16777216, fd = -1703934390, user_data = 0x82d65d6a0 <__stack_chk_guard>}, {pos = 898635224, events = 8, fd = 0, user_data = 0x82d642e38}, {pos = 560886048, events = 8, fd = 560885904, user_data = 0x82d54ec82}, {pos = 0, events = 0, fd = 560886208, user_data = 0x8359015d8}, {pos = 560885840, events = 8, fd = 0, user_data = 0x0}, {pos = -1703934390, events = 3987749821, fd = 1555657482, user_data = 0x82d4837a0}, {pos = 759778680, events = 8, fd = 560884952, user_data = 0x8216e6d50}, {pos = 560884952, events = 8, fd = 1555657482, user_data = 0x82d47e388}, {pos = 759778680, events = 8, fd = 560885000, user_data = 0x8216e6d80}, {pos = 560885000, events = 8, fd = 759746964, user_data = 0x822211408}, {pos = 759746964, events = 8, fd = 560885104, user_data = 0x1f8f5cb9243a}, {pos = 761569328, events = 8, fd = 1, user_data = 0x8216e6da0}, {pos = 1555657482, events = 8079, fd = 759654488, user_data = 0x82d494d78}, {pos = 560885112, events = 8, fd = 560885232, user_data = 0x8216e6d78}, {pos = 759741708, events = 8, fd = 572593160, user_data = 0x82d48bd0c}, {pos = 560885216, events = 8, fd = 1555637306, user_data = 0x8216e6e08}, {pos = 560885704, events = 8, fd = 560885232, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xedb03bbd526629ce}, {pos = 572616760, events = 8, fd = 1, user_data = 0x822211408}, {pos = 759686024, events = 8, fd = 572613256, user_data = 0x82d476858}, {pos = 572593160, events = 8, fd = 560885368, user_data = 0x8216e7038}, {pos = 560885344, events = 8, fd = 1555655842, user_data = 0x2981b4}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822217038}} [14:48:47.193] last_touch_time = 1733582505 [14:48:47.193] last_lockfile_recheck_time = 1733582505 [14:48:47.193] nevents = 1 [14:48:47.193] #21 0x000000000089ac19 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8216e7838) at ../src/backend/postmaster/postmaster.c:1374 [14:48:47.193] userDoption = [14:48:47.193] listen_addr_saved = false [14:48:47.193] output_config_variable = [14:48:47.193] opt = [14:48:47.193] status = [14:48:47.193] #22 0x00000000007d292d in main (argc=4, argv=0x8216e7838) at ../src/backend/main/main.c:222 [14:48:47.193] do_check_root = [14:48:47.193] dispatch_option = DISPATCH_POSTMASTER [14:48:47.202] [14:48:47.202] [14:48:47.202] [14:48:47.266] dumping /tmp/cores/postgres.17954.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [14:48:47.391] [New LWP 101934] [14:48:47.455] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [14:48:47.455] Program terminated with signal SIGABRT, Aborted. [14:48:47.455] Sent by thr_kill() from pid 17954 and user 1003. [14:48:47.455] #0 0x000000082b82641a in thr_kill () from /lib/libc.so.7 [14:48:47.497] [14:48:47.497] Thread 1 (LWP 101934): [14:48:47.497] #0 0x000000082b82641a in thr_kill () from /lib/libc.so.7 [14:48:47.497] No symbol table info available. [14:48:47.497] #1 0x000000082b79fe64 in raise () from /lib/libc.so.7 [14:48:47.497] No symbol table info available. [14:48:47.497] #2 0x000000082b8506f9 in abort () from /lib/libc.so.7 [14:48:47.497] No symbol table info available. [14:48:47.497] #3 0x0000000000aa1665 in ExceptionalCondition (conditionName=0x2ecf40 "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=195) at ../src/backend/utils/error/assert.c:66 [14:48:47.497] No locals. [14:48:47.497] #4 0x000000000076f379 in standard_ExecutorStart (queryDesc=0x8350a2b40, eflags=0) at ../src/backend/executor/execMain.c:195 [14:48:47.497] estate = 0x83b613100 [14:48:47.497] oldcontext = 0x83507d800 [14:48:47.497] #5 0x000000083943b9c2 in pgss_ExecutorStart (queryDesc=0x8350a2b40, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [14:48:47.497] No locals. [14:48:47.497] #6 0x0000000000704d15 in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [14:48:47.497] copied_query = [14:48:47.497] rewritten = [14:48:47.497] plan = 0x8350a26e8 [14:48:47.497] queryDesc = 0x8350a2b40 [14:48:47.497] processed = [14:48:47.497] __error = [14:48:47.497] #7 RefreshMatViewByOid (matviewOid=28203, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [14:48:47.497] dest = [14:48:47.497] save_userid = 10 [14:48:47.497] save_sec_context = 0 [14:48:47.497] processed = 0 [14:48:47.497] matviewRel = 0x83b692548 [14:48:47.497] relowner = 10 [14:48:47.497] save_nestlevel = 2 [14:48:47.497] rule = [14:48:47.497] actions = [14:48:47.497] dataQuery = [14:48:47.497] tableSpace = [14:48:47.497] relpersistence = [14:48:47.497] OIDNewHeap = 28215 [14:48:47.497] address = [14:48:47.497] #8 0x00000000007048f6 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [14:48:47.497] lockmode = [14:48:47.497] matviewOid = 0 [14:48:47.497] #9 0x00000000006db9ec in ExecCreateTableAs (pstate=pstate@entry=0x83507d900, stmt=stmt@entry=0x835050fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821646e30) at ../src/backend/commands/createas.c:351 [14:48:47.497] refresh = 0x0 [14:48:47.497] query = 0x835097708 [14:48:47.497] into = 0x835050f40 [14:48:47.497] jstate = 0x0 [14:48:47.497] do_refresh = false [14:48:47.497] address = [14:48:47.497] dest = [14:48:47.497] is_matview = [14:48:47.497] #10 0x000000000094c1d8 in ProcessUtilitySlow (pstate=pstate@entry=0x83507d900, pstmt=pstmt@entry=0x835050e30, queryString=queryString@entry=0x834ef3100 "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=0x821646e30) at ../src/backend/tcop/utility.c:1678 [14:48:47.497] _local_sigjmp_buf = {{_sjb = {9746953, 0, 34919966872, 34919967248, 34919966880, 12441752, 0, 35249445120, 34919940991, 7, 34919967024, 0}}} [14:48:47.497] _save_exception_stack = 0x821646b20 [14:48:47.497] _save_context_stack = 0x0 [14:48:47.497] _do_rethrow = false [14:48:47.497] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [14:48:47.497] parsetree = 0x835050fd0 [14:48:47.497] commandCollected = false [14:48:47.497] needCleanup = false [14:48:47.497] address = [14:48:47.497] isTopLevel = [14:48:47.497] isCompleteQuery = [14:48:47.497] #11 0x000000000094ab58 in standard_ProcessUtility (pstmt=0x835050e30, queryString=queryString@entry=0x834ef3100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835097ea8, qc=0x821646e30) at ../src/backend/tcop/utility.c:1033 [14:48:47.497] isAtomicContext = false [14:48:47.497] parsetree = 0x835050fd0 [14:48:47.497] readonly_flags = [14:48:47.497] pstate = 0x83507d900 [14:48:47.497] isTopLevel = [14:48:47.497] #12 0x000000083943bf7e in pgss_ProcessUtility (pstmt=0x835050e30, queryString=0x834ef3100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835097ea8, qc=0x821646e30) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [14:48:47.497] _local_sigjmp_buf = {{_sjb = {35320479415, 34919967520, 34919967384, 34919967840, 35249262128, 0, 12441752, 34919968048, 34919940991, 34919967620, 34919967648, 0}}} [14:48:47.497] _save_exception_stack = 0x821646d30 [14:48:47.497] _save_context_stack = 0x0 [14:48:47.497] _do_rethrow = false [14:48:47.497] bufusage = {shared_blks_hit = 35320479415, shared_blks_read = 34919967520, shared_blks_dirtied = 34919967384, shared_blks_written = 34919967840, local_blks_hit = 35249262128, local_blks_read = 0, local_blks_dirtied = 12441752, local_blks_written = 34919968048, temp_blks_read = 34919940991, temp_blks_written = 34919967620, shared_blk_read_time = {ticks = 34919967648}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4139614004839573632}, local_blk_write_time = {ticks = 12450792}, temp_blk_read_time = {ticks = 35327752192}, temp_blk_write_time = {ticks = 12403296}} [14:48:47.497] walusage_start = {wal_records = 8975, wal_fpi = 121, wal_bytes = 1216425} [14:48:47.497] duration = [14:48:47.497] bufusage_start = {shared_blks_hit = 153672, shared_blks_read = 8976, shared_blks_dirtied = 2713, shared_blks_written = 2432, 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}} [14:48:47.497] walusage = {wal_records = -2081675047382134190, wal_fpi = 35249262544, wal_bytes = 123} [14:48:47.497] start = {ticks = -184274649031} [14:48:47.497] rows = [14:48:47.497] saved_queryId = 6041762721901209185 [14:48:47.497] parsetree = [14:48:47.497] saved_stmt_location = 0 [14:48:47.497] saved_stmt_len = 69 [14:48:47.497] enabled = [14:48:47.497] #13 0x000000000094a123 in PortalRunUtility (portal=0x834f99100, pstmt=0x835050e30, isTopLevel=, setHoldSnapshot=, dest=0x835097ea8, qc=0x821646e30) at ../src/backend/tcop/pquery.c:1158 [14:48:47.497] No locals. [14:48:47.497] #14 0x00000000009497b4 in PortalRunMulti (portal=portal@entry=0x834f99100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835097ea8, altdest=altdest@entry=0x835097ea8, qc=0x821646e30) at ../src/backend/tcop/pquery.c:1322 [14:48:47.497] pstmt = 0x835050e30 [14:48:47.497] stmtlist_item__state = {l = 0x835097e58, i = 0} [14:48:47.497] active_snapshot_set = false [14:48:47.497] stmtlist_item = 0x835097e70 [14:48:47.497] #15 0x0000000000949083 in PortalRun (portal=portal@entry=0x834f99100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835097ea8, altdest=altdest@entry=0x835097ea8, qc=0x821646e30) at ../src/backend/tcop/pquery.c:791 [14:48:47.497] _local_sigjmp_buf = {{_sjb = {9736189, 35248509184, 34919968040, 34919968272, 34919968048, 35248525312, 12407352, 12441752, 35248472959, 35249255904, 4294967984, 0}}} [14:48:47.497] _save_exception_stack = 0x821646f00 [14:48:47.497] _save_context_stack = 0x0 [14:48:47.497] _do_rethrow = false [14:48:47.497] saveTopTransactionResourceOwner = 0x834fee1d8 [14:48:47.497] saveTopTransactionContext = 0x834f9d000 [14:48:47.497] saveActivePortal = 0x0 [14:48:47.497] saveResourceOwner = 0x834fee1d8 [14:48:47.497] savePortalContext = 0x0 [14:48:47.497] saveMemoryContext = 0x834f9d000 [14:48:47.497] result = [14:48:47.497] nprocessed = [14:48:47.497] #16 0x0000000000947f02 in exec_simple_query (query_string=query_string@entry=0x834ef3100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1283 [14:48:47.497] cmdtaglen = 24 [14:48:47.497] snapshot_set = [14:48:47.497] per_parsetree_context = 0x0 [14:48:47.497] plantree_list = [14:48:47.497] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:48:47.497] format = 0 [14:48:47.497] parsetree = 0x834ef46a8 [14:48:47.497] commandTag = [14:48:47.497] cmdtagname = [14:48:47.497] querytree_list = [14:48:47.497] portal = 0x834f99100 [14:48:47.497] receiver = 0x835097ea8 [14:48:47.497] parsetree_item__state = {l = 0x834ef4a18, i = 0} [14:48:47.497] msec_str = "\000\000\000\000\b", '\000' , "\347^Tg\000\000\000\000\204\362\006\370\347{\331$" [14:48:47.497] dest = DestRemote [14:48:47.497] was_logged = [14:48:47.497] oldcontext = 0x834f9d000 [14:48:47.497] parsetree_list = 0x834ef4a18 [14:48:47.497] use_implicit_block = false [14:48:47.497] parsetree_item = 0x834ef4a30 [14:48:47.497] save_log_statement_stats = [14:48:47.497] #17 0x0000000000945b73 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4818 [14:48:47.497] query_string = 0x834ef3100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [14:48:47.497] input_message = {data = 0x834ef3100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [14:48:47.497] firstchar = [14:48:47.497] local_sigjmp_buf = {{_sjb = {9719846, 34919968512, 34919968472, 34919969056, 12450488, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [14:48:47.497] send_ready_for_query = false [14:48:47.497] idle_in_transaction_timeout_enabled = false [14:48:47.497] idle_session_timeout_enabled = false [14:48:47.497] #18 0x0000000000940309 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [14:48:47.497] bsdata = [14:48:47.497] #19 0x0000000000898435 in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x821647c38 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821647b80) at ../src/backend/postmaster/launch_backend.c:274 [14:48:47.497] pid = [14:48:47.497] #20 0x000000000089c618 in BackendStartup (client_sock=0x821647b80) at ../src/backend/postmaster/postmaster.c:3390 [14:48:47.497] startup_data = {canAcceptConnections = CAC_OK} [14:48:47.497] bn = 0x834fda0d8 [14:48:47.497] cac = CAC_OK [14:48:47.497] pid = [14:48:47.497] __error = [14:48:47.497] save_errno = [14:48:47.497] __error = [14:48:47.497] __error = [14:48:47.497] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [14:48:47.497] 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' , "\340{d!\b\000\000\000hU\267*\b\000\000\000W\000\000\000\000\000\000\000^߷*\b", '\000' , " |d!\b\000\000\000ԁ\211\000\000\000\000\0000|d!\b", '\000' }, salen = 16}} [14:48:47.497] i = 0 [14:48:47.497] now = [14:48:47.497] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 479451855, events = 5489, fd = 562379320, user_data = 0x800000001}, {pos = 562353160, events = 8, fd = 728715624, user_data = 0x821647458}, {pos = 560231328, events = 8, fd = 560230912, user_data = 0x1}, {pos = 562353160, events = 8, fd = 33, user_data = 0x821647390}, {pos = 614726170, events = 5489, fd = 562323464, user_data = 0x821846408}, {pos = 562325512, events = 8, fd = 562326536, user_data = 0x82184a008}, {pos = 562340872, events = 8, fd = 562341896, user_data = 0x82184ac08}, {pos = 562343944, events = 8, fd = 562344968, user_data = 0x82184b808}, {pos = 562347016, events = 8, fd = 562348040, user_data = 0x82184c408}, {pos = 562350088, events = 8, fd = 562351112, user_data = 0x82184d008}, {pos = 562353160, events = 8, fd = -25761258, user_data = 0x821853038}, {pos = 1, events = 8, fd = 562353160, user_data = 0x82b6fa478}, {pos = 560231896, events = 8, fd = 15, user_data = 0x821647520}, {pos = 560231296, events = 8, fd = 1, user_data = 0x8216474d8}, {pos = 33, events = 0, fd = 560231280, user_data = 0x157124a45a73}, {pos = 560231248, events = 8, fd = 2591802, user_data = 0x82184d408}, {pos = 728844995, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 562379320, events = 8, fd = 1, user_data = 0x82184d408}, {pos = 728715624, events = 8, fd = 560231512, user_data = 0x821647200}, {pos = 33, events = 18, fd = 0, user_data = 0x821853a38}, {pos = 1, events = 0, fd = 562353160, user_data = 0x347}, {pos = 560231488, events = 8, fd = 614725103, user_data = 0x82b714ac3}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821853a38}, {pos = 1, events = 0, fd = 562353160, user_data = 0x834ee3000}, {pos = 1, events = 0, fd = 888025492, user_data = 0x0}, {pos = 560231440, events = 8, fd = 716690796, user_data = 0x1}, {pos = 888025088, events = 8, fd = 560231488, user_data = 0x82ab7c702}, {pos = 730552656, events = 8, fd = 730640760, user_data = 0x82b8b5950 }, {pos = 562353160, events = 8, fd = 560231712, user_data = 0x157124a3f3de}, {pos = 560232168, events = 8, fd = 1, user_data = 0x157124a3f25e}, {pos = 562353160, events = 8, fd = 560231496, user_data = 0x821647520}, {pos = 12264, events = 0, fd = 0, user_data = 0x157124a52990}, {pos = 560233104, events = 8, fd = 115213183, user_data = 0x8fe76ea16}, {pos = -687975854, events = 3810289554, fd = 0, user_data = 0x82184d408}, {pos = 12264, events = 0, fd = 728694784, user_data = 0x1db178}, {pos = 730552656, events = 8, fd = 728829304, user_data = 0x3d4b}, {pos = 730699424, events = 8, fd = 560231824, user_data = 0x82b7b4915 }, {pos = 730590776, events = 8, fd = 560231760, user_data = 0x8216479c0}, {pos = 0, events = 0, fd = 560231824, user_data = 0x82b7cab61}, {pos = 1, events = 0, fd = 560232896, user_data = 0x8216479c0}, {pos = 0, events = 16777216, fd = -687975854, user_data = 0x82b8d96a0 <__stack_chk_guard>}, {pos = 888497624, events = 8, fd = 0, user_data = 0x82b8bee38}, {pos = 560233104, events = 8, fd = 560232960, user_data = 0x82b7cac82}, {pos = 0, events = 0, fd = 560233264, user_data = 0x834f565d8}, {pos = 560232896, events = 8, fd = 0, user_data = 0x157124a4630a}, {pos = 728758176, events = 8, fd = 728829304, user_data = 0x821647638}, {pos = 560232112, events = 8, fd = 560231992, user_data = 0x157124a4630a}, {pos = 728736648, events = 8, fd = 728829304, user_data = 0x821647668}, {pos = 560232160, events = 8, fd = 560232040, user_data = 0x82b709194}, {pos = 562353160, events = 8, fd = 728797588, user_data = 0x8216476d0}, {pos = 614732858, events = 5489, fd = 560232048, user_data = 0x82ab73410 <__pthread_cleanup_pop_imp+48>}, {pos = 730619952, events = 8, fd = 614753034, user_data = 0x82b6f2858}, {pos = 728829304, events = 8, fd = 560232152, user_data = 0x821647750}, {pos = 560232152, events = 8, fd = 728792332, user_data = 0x82184d408}, {pos = 728792332, events = 8, fd = 560232256, user_data = 0x157124a4143a}, {pos = 560232296, events = 8, fd = 560232760, user_data = 0x821647750}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 562376760, user_data = 0xe31c679200000001}, {pos = 562353160, events = 8, fd = 728736648, user_data = 0x8218527c8}, {pos = 0, events = 0, fd = 0, user_data = 0x8216477d8}, {pos = 560232872, events = 8, fd = 560232384, user_data = 0x157124a45ca2}, {pos = 2720180, events = 0, fd = 448139, user_data = 0xe31c67927c96e577}, {pos = 562376760, events = 8, fd = 1, user_data = 0x0}} [14:48:47.497] last_touch_time = 1733582540 [14:48:47.497] last_lockfile_recheck_time = 1733582540 [14:48:47.497] nevents = 1 [14:48:47.497] #22 0x000000000089ac19 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8216481a8) at ../src/backend/postmaster/postmaster.c:1374 [14:48:47.497] userDoption = [14:48:47.497] listen_addr_saved = false [14:48:47.497] output_config_variable = [14:48:47.497] opt = [14:48:47.497] status = [14:48:47.497] #23 0x00000000007d292d in main (argc=4, argv=0x8216481a8) at ../src/backend/main/main.c:222 [14:48:47.497] do_check_root = [14:48:47.497] dispatch_option = DISPATCH_POSTMASTER