[03:28:15.182] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [03:28:15.521] dumping /tmp/cores/postgres.10825.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:28:15.653] [New LWP 101901] [03:28:15.742] Core was generated by `postgres: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:28:15.742] Program terminated with signal SIGABRT, Aborted. [03:28:15.742] Sent by thr_kill() from pid 10825 and user 1003. [03:28:15.742] #0 0x000000082be3641a in thr_kill () from /lib/libc.so.7 [03:28:15.800] [03:28:15.800] Thread 1 (LWP 101901): [03:28:15.800] #0 0x000000082be3641a in thr_kill () from /lib/libc.so.7 [03:28:15.800] No symbol table info available. [03:28:15.800] #1 0x000000082bdafe64 in raise () from /lib/libc.so.7 [03:28:15.800] No symbol table info available. [03:28:15.800] #2 0x000000082be606f9 in abort () from /lib/libc.so.7 [03:28:15.800] No symbol table info available. [03:28:15.800] #3 0x0000000000aa3435 in ExceptionalCondition (conditionName=0x2ed36c "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:28:15.800] No locals. [03:28:15.800] #4 0x0000000000769bb9 in standard_ExecutorStart (queryDesc=0x834196bd0, eflags=0) at ../src/backend/executor/execMain.c:194 [03:28:15.800] estate = 0x835e23100 [03:28:15.800] oldcontext = 0x8341d4800 [03:28:15.800] #5 0x00000000006fdd5f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:28:15.800] copied_query = [03:28:15.800] rewritten = [03:28:15.800] plan = 0x834196778 [03:28:15.800] queryDesc = 0x834196bd0 [03:28:15.800] processed = [03:28:15.800] __error = [03:28:15.800] #6 RefreshMatViewByOid (matviewOid=28582, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:28:15.800] dest = [03:28:15.800] save_userid = 10 [03:28:15.800] save_sec_context = 0 [03:28:15.800] processed = 0 [03:28:15.800] matviewRel = 0x835ed4ec8 [03:28:15.800] relowner = 10 [03:28:15.800] save_nestlevel = 2 [03:28:15.800] rule = [03:28:15.800] actions = [03:28:15.800] dataQuery = [03:28:15.800] tableSpace = [03:28:15.800] relpersistence = [03:28:15.800] OIDNewHeap = 28589 [03:28:15.800] address = [03:28:15.800] #7 0x00000000006fd936 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:28:15.800] lockmode = [03:28:15.800] matviewOid = 0 [03:28:15.800] #8 0x00000000006d492c in ExecCreateTableAs (pstate=pstate@entry=0x8341d4900, stmt=stmt@entry=0x83418efd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820f296a0) at ../src/backend/commands/createas.c:351 [03:28:15.800] refresh = 0x0 [03:28:15.800] query = 0x835e1f498 [03:28:15.800] into = 0x835e1f7e0 [03:28:15.800] jstate = 0x0 [03:28:15.800] do_refresh = false [03:28:15.800] address = [03:28:15.800] dest = [03:28:15.800] is_matview = [03:28:15.800] #9 0x000000000094a9de in ProcessUtilitySlow (pstate=pstate@entry=0x8341d4900, pstmt=pstmt@entry=0x8340d0a68, queryString=queryString@entry=0x8340cf100 "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=0x820f296a0) at ../src/backend/tcop/utility.c:1678 [03:28:15.800] _local_sigjmp_buf = {{_sjb = {9740812, 0, 34912506568, 34912506944, 34912506576, 12566200, 0, 35234072832, 12452735, 1, 4294967295, 34359738368}}} [03:28:15.800] _save_exception_stack = 0x820f295a0 [03:28:15.800] _save_context_stack = 0x0 [03:28:15.800] _do_rethrow = false [03:28:15.800] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:28:15.800] parsetree = 0x83418efd0 [03:28:15.800] commandCollected = false [03:28:15.800] needCleanup = false [03:28:15.800] address = [03:28:15.800] isTopLevel = [03:28:15.800] isCompleteQuery = [03:28:15.800] #10 0x000000000094935b in standard_ProcessUtility (pstmt=0x8340d0a68, queryString=0x8340cf100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835e1fcc8, qc=0x820f296a0) at ../src/backend/tcop/utility.c:1033 [03:28:15.800] isAtomicContext = false [03:28:15.800] parsetree = 0x83418efd0 [03:28:15.800] readonly_flags = [03:28:15.800] pstate = 0x8341d4900 [03:28:15.800] isTopLevel = [03:28:15.800] #11 0x0000000000948de8 in ProcessUtility (pstmt=0x18e0d, queryString=0x6 , readOnlyTree=, context=736322554, params=0x0, queryEnv=0x0, dest=0x835e1fcc8, qc=0x820f296a0) at ../src/backend/tcop/utility.c:523 [03:28:15.800] No locals. [03:28:15.800] #12 0x0000000000948923 in PortalRunUtility (portal=0x8341a6100, pstmt=0x8340d0a68, isTopLevel=, setHoldSnapshot=, dest=0x835e1fcc8, qc=0x820f296a0) at ../src/backend/tcop/pquery.c:1152 [03:28:15.800] No locals. [03:28:15.800] #13 0x0000000000947fd4 in PortalRunMulti (portal=portal@entry=0x8341a6100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x835e1fcc8, altdest=altdest@entry=0x835e1fcc8, qc=qc@entry=0x820f296a0) at ../src/backend/tcop/pquery.c:1316 [03:28:15.800] pstmt = 0x8340d0a68 [03:28:15.800] stmtlist_item__state = {l = 0x835e1fc78, i = 0} [03:28:15.800] active_snapshot_set = false [03:28:15.800] stmtlist_item = 0x835e1fc90 [03:28:15.800] #14 0x00000000009478bb in PortalRun (portal=portal@entry=0x8341a6100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x835e1fcc8, altdest=altdest@entry=0x835e1fcc8, qc=qc@entry=0x820f296a0) at ../src/backend/tcop/pquery.c:787 [03:28:15.800] _local_sigjmp_buf = {{_sjb = {9730101, 35233882368, 34912507288, 34912507536, 34912507296, 12566200, 34912507552, 12520632, 12518271, 0, 35233858431, 34359738368}}} [03:28:15.800] _save_exception_stack = 0x820f29750 [03:28:15.800] _save_context_stack = 0x0 [03:28:15.800] _do_rethrow = false [03:28:15.800] saveTopTransactionResourceOwner = 0x8341b5ac8 [03:28:15.800] saveTopTransactionContext = 0x8341aa000 [03:28:15.800] saveActivePortal = 0x0 [03:28:15.800] saveResourceOwner = 0x8341b5ac8 [03:28:15.800] savePortalContext = 0x0 [03:28:15.800] saveMemoryContext = 0x8341aa000 [03:28:15.800] result = [03:28:15.800] nprocessed = [03:28:15.800] #15 0x0000000000946739 in exec_simple_query (query_string=query_string@entry=0x8340cf100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [03:28:15.800] cmdtaglen = 24 [03:28:15.800] snapshot_set = [03:28:15.800] per_parsetree_context = 0x0 [03:28:15.800] plantree_list = [03:28:15.800] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:28:15.800] format = 0 [03:28:15.800] parsetree = 0x8340d06a8 [03:28:15.800] commandTag = [03:28:15.800] cmdtagname = [03:28:15.800] querytree_list = [03:28:15.800] portal = 0x8341a6100 [03:28:15.800] receiver = 0x835e1fcc8 [03:28:15.800] parsetree_item__state = {l = 0x8340d0a18, i = 0} [03:28:15.800] msec_str = "\000\000\000\000\b", '\000' , "x\223\235g\000\000\000\000C\343k\300[\355g!" [03:28:15.800] dest = DestRemote [03:28:15.800] was_logged = [03:28:15.800] oldcontext = 0x8341aa000 [03:28:15.800] parsetree_list = 0x8340d0a18 [03:28:15.800] use_implicit_block = false [03:28:15.800] parsetree_item = 0x8340d0a30 [03:28:15.800] save_log_statement_stats = [03:28:15.800] #16 0x00000000009443a3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [03:28:15.800] query_string = 0x8340cf100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:28:15.800] input_message = {data = 0x8340cf100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:28:15.800] firstchar = [03:28:15.800] local_sigjmp_buf = {{_sjb = {9713734, 34912507728, 34912507720, 34912508272, 12574952, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [03:28:15.800] send_ready_for_query = false [03:28:15.800] idle_in_transaction_timeout_enabled = false [03:28:15.800] idle_session_timeout_enabled = false [03:28:15.800] #17 0x000000000093ed39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:28:15.800] bsdata = [03:28:15.800] #18 0x00000000008965d5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x820f2a480 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f2a3d0) at ../src/backend/postmaster/launch_backend.c:274 [03:28:15.800] pid = [03:28:15.800] #19 0x000000000089a97b in BackendStartup (client_sock=0x820f2a3d0) at ../src/backend/postmaster/postmaster.c:3519 [03:28:15.800] startup_data = {canAcceptConnections = CAC_OK} [03:28:15.800] bn = 0x834172278 [03:28:15.800] cac = CAC_OK [03:28:15.800] pid = [03:28:15.800] __error = [03:28:15.800] save_errno = [03:28:15.800] __error = [03:28:15.800] __error = [03:28:15.800] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:28:15.800] 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' , "0\244\362 \b\000\000\000h\245s*\b\000\000\000\372\000\000\000\000\000\000\000^/t*\b", '\000' , "p\244\362 \b\000\000\000dc\211\000\000\000\000\000\200\244\362 \b", '\000' }, salen = 16}} [03:28:15.800] i = 0 [03:28:15.800] now = [03:28:15.800] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 873641432, events = 8, fd = 552772112, user_data = 0x820f29f70}, {pos = 8192, events = 0, fd = 8192, user_data = 0x83419e000}, {pos = 552771448, events = 8, fd = 0, user_data = 0x83286a090}, {pos = 1, events = 0, fd = 552771248, user_data = 0x82bea59c9}, {pos = 735093640, events = 8, fd = 735186296, user_data = 0x820f29ec8}, {pos = 552771392, events = 8, fd = 552771440, user_data = 0x820f29f68}, {pos = 847683728, events = 8, fd = 861931904, user_data = 0x20}, {pos = 4096, events = 0, fd = 552771888, user_data = 0x82bea0a7c}, {pos = 552771432, events = 8, fd = 1010668298, user_data = 0x82bd02858}, {pos = 735186296, events = 8, fd = 552771384, user_data = 0x820f29fb0}, {pos = 552771384, events = 8, fd = 735149324, user_data = 0x8212a0408}, {pos = 735149324, events = 8, fd = 552771488, user_data = 0xe9e3c3d443a}, {pos = 847683776, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 861942328, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8212a5288}, {pos = 735062104, events = 8, fd = 556401672, user_data = 0x820f2a038}, {pos = 552772088, events = 8, fd = 552771616, user_data = 0xe9e3c3d8ca2}, {pos = 2722467, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 556425272, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 552772344, user_data = 0x212a0408}, {pos = 552772160, events = 8, fd = 552771760, user_data = 0x1}, {pos = 552772088, events = 8, fd = 32, user_data = 0x820f2a0a0}, {pos = 1010666099, events = 3742, fd = 552772032, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8212a6038}, {pos = 1, events = 8, fd = 556401672, user_data = 0x82bd02858}, {pos = 552772344, events = 8, fd = 552772160, user_data = 0x820f2a0b0}, {pos = 0, events = 0, fd = 556371976, user_data = 0x20}, {pos = 552772144, events = 8, fd = 1010641639, user_data = 0x821299008}, {pos = 556373000, events = 8, fd = 556374024, user_data = 0x821299c08}, {pos = 556388360, events = 8, fd = 556389384, user_data = 0x82129d808}, {pos = 556391432, events = 8, fd = 556392456, user_data = 0x82129e408}, {pos = 556394504, events = 8, fd = 556395528, user_data = 0x82129f008}, {pos = 556397576, events = 8, fd = 556398600, user_data = 0x82129fc08}, {pos = 556400648, events = 8, fd = 556401672, user_data = 0x8212a0808}, {pos = 556403720, events = 8, fd = 556404744, user_data = 0x8212a1408}, {pos = 556406792, events = 8, fd = 556407816, user_data = 0x8212a2008}, {pos = 556409864, events = 8, fd = 556410888, user_data = 0x8212a2c08}, {pos = 556417032, events = 8, fd = 556418056, user_data = 0x8212a4808}, {pos = 556420104, events = 8, fd = 556371976, user_data = 0x298aa3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8212a6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 552772344, events = 8, fd = 552771760, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 556425272, user_data = 0x1}, {pos = 556371976, events = 8, fd = 298, user_data = 0x820f2a2e0}, {pos = 1010640367, events = 3742, fd = 2722467, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 556425272, user_data = 0x1}, {pos = 556401672, events = 8, fd = 873197568, user_data = 0x1}, {pos = 873197972, events = 8, fd = 0, user_data = 0x820f2a2b0}, {pos = 712254828, events = 8, fd = 1, user_data = 0x8340bf000}, {pos = 552772320, events = 8, fd = 712251138, user_data = 0x82be34170 }, {pos = 12483008, events = 0, fd = 736313712, user_data = 0x8212a0408}, {pos = 552772544, events = 8, fd = 1010639838, user_data = 0x8340dd800}, {pos = 1, events = 8, fd = 1010639454, user_data = 0x821299008}, {pos = 552772328, events = 8, fd = 552772544, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1010719120, user_data = 0x0}, {pos = 552731519, events = 8, fd = 8136711, user_data = 0x820f2a370}, {pos = 712213520, events = 8, fd = 736976944, user_data = 0x82bed8310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820f2a3a0}, {pos = 712256413, events = 8, fd = 873197568, user_data = 0x1dd9}, {pos = 552772608, events = 8, fd = 712222970, user_data = 0x0}, {pos = 0, events = 0, fd = -2098655894, user_data = 0x0}} [03:28:15.800] last_touch_time = 1738380129 [03:28:15.800] last_lockfile_recheck_time = 1738380129 [03:28:15.800] nevents = 1 [03:28:15.800] #21 0x0000000000898db4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820f2a9f0) at ../src/backend/postmaster/postmaster.c:1386 [03:28:15.800] userDoption = [03:28:15.800] listen_addr_saved = false [03:28:15.800] output_config_variable = [03:28:15.800] opt = [03:28:15.800] status = [03:28:15.800] #22 0x00000000007cf4e0 in main (argc=8, argv=0x820f2a9f0) at ../src/backend/main/main.c:230 [03:28:15.800] do_check_root = [03:28:15.800] dispatch_option = DISPATCH_POSTMASTER [03:28:15.809] [03:28:15.809] [03:28:15.809] [03:28:15.869] dumping /tmp/cores/postgres.11465.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:28:15.995] [New LWP 100121] [03:28:16.061] Core was generated by `postgres: old_node: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:28:16.061] Program terminated with signal SIGABRT, Aborted. [03:28:16.061] Sent by thr_kill() from pid 11465 and user 1003. [03:28:16.061] #0 0x000000082dbaa41a in thr_kill () from /lib/libc.so.7 [03:28:16.095] [03:28:16.095] Thread 1 (LWP 100121): [03:28:16.095] #0 0x000000082dbaa41a in thr_kill () from /lib/libc.so.7 [03:28:16.095] No symbol table info available. [03:28:16.095] #1 0x000000082db23e64 in raise () from /lib/libc.so.7 [03:28:16.095] No symbol table info available. [03:28:16.095] #2 0x000000082dbd46f9 in abort () from /lib/libc.so.7 [03:28:16.095] No symbol table info available. [03:28:16.095] #3 0x0000000000aa3435 in ExceptionalCondition (conditionName=0x2ed36c "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:28:16.095] No locals. [03:28:16.095] #4 0x0000000000769bb9 in standard_ExecutorStart (queryDesc=0x8373b3bd0, eflags=0) at ../src/backend/executor/execMain.c:194 [03:28:16.095] estate = 0x83749e100 [03:28:16.095] oldcontext = 0x8373a2800 [03:28:16.095] #5 0x00000000006fdd5f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:28:16.095] copied_query = [03:28:16.095] rewritten = [03:28:16.095] plan = 0x8373b3778 [03:28:16.095] queryDesc = 0x8373b3bd0 [03:28:16.095] processed = [03:28:16.095] __error = [03:28:16.095] #6 RefreshMatViewByOid (matviewOid=28458, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:28:16.095] dest = [03:28:16.095] save_userid = 10 [03:28:16.095] save_sec_context = 0 [03:28:16.095] processed = 0 [03:28:16.095] matviewRel = 0x844682648 [03:28:16.095] relowner = 10 [03:28:16.095] save_nestlevel = 2 [03:28:16.095] rule = [03:28:16.095] actions = [03:28:16.095] dataQuery = [03:28:16.095] tableSpace = [03:28:16.095] relpersistence = [03:28:16.095] OIDNewHeap = 28465 [03:28:16.095] address = [03:28:16.095] #7 0x00000000006fd936 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:28:16.095] lockmode = [03:28:16.095] matviewOid = 0 [03:28:16.095] #8 0x00000000006d492c in ExecCreateTableAs (pstate=pstate@entry=0x8373a2900, stmt=stmt@entry=0x837398fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x820e307b0) at ../src/backend/commands/createas.c:351 [03:28:16.095] refresh = 0x0 [03:28:16.095] query = 0x8373bb918 [03:28:16.095] into = 0x8373bbc60 [03:28:16.095] jstate = 0x0 [03:28:16.095] do_refresh = false [03:28:16.095] address = [03:28:16.095] dest = [03:28:16.095] is_matview = [03:28:16.095] #9 0x000000000094a9de in ProcessUtilitySlow (pstate=pstate@entry=0x8373a2900, pstmt=pstmt@entry=0x8372d4a68, queryString=queryString@entry=0x8372d3100 "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=0x820e307b0) at ../src/backend/tcop/utility.c:1678 [03:28:16.095] _local_sigjmp_buf = {{_sjb = {9740812, 0, 34911486936, 34911487312, 34911486944, 12566200, 0, 35286296832, 12452735, 1, 4294967295, 34359738368}}} [03:28:16.095] _save_exception_stack = 0x820e306b0 [03:28:16.095] _save_context_stack = 0x0 [03:28:16.095] _do_rethrow = false [03:28:16.095] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:28:16.095] parsetree = 0x837398fd0 [03:28:16.095] commandCollected = false [03:28:16.095] needCleanup = false [03:28:16.095] address = [03:28:16.095] isTopLevel = [03:28:16.095] isCompleteQuery = [03:28:16.095] #10 0x000000000094935b in standard_ProcessUtility (pstmt=0x8372d4a68, queryString=0x8372d3100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8373bc148, qc=0x820e307b0) at ../src/backend/tcop/utility.c:1033 [03:28:16.095] isAtomicContext = false [03:28:16.095] parsetree = 0x837398fd0 [03:28:16.095] readonly_flags = [03:28:16.095] pstate = 0x8373a2900 [03:28:16.095] isTopLevel = [03:28:16.095] #11 0x0000000000948de8 in ProcessUtility (pstmt=0x18719, queryString=0x6 , readOnlyTree=, context=767206394, params=0x0, queryEnv=0x0, dest=0x8373bc148, qc=0x820e307b0) at ../src/backend/tcop/utility.c:523 [03:28:16.095] No locals. [03:28:16.095] #12 0x0000000000948923 in PortalRunUtility (portal=0x837379100, pstmt=0x8372d4a68, isTopLevel=, setHoldSnapshot=, dest=0x8373bc148, qc=0x820e307b0) at ../src/backend/tcop/pquery.c:1152 [03:28:16.095] No locals. [03:28:16.095] #13 0x0000000000947fd4 in PortalRunMulti (portal=portal@entry=0x837379100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8373bc148, altdest=altdest@entry=0x8373bc148, qc=qc@entry=0x820e307b0) at ../src/backend/tcop/pquery.c:1316 [03:28:16.095] pstmt = 0x8372d4a68 [03:28:16.095] stmtlist_item__state = {l = 0x8373bc0f8, i = 0} [03:28:16.095] active_snapshot_set = false [03:28:16.095] stmtlist_item = 0x8373bc110 [03:28:16.095] #14 0x00000000009478bb in PortalRun (portal=portal@entry=0x837379100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8373bc148, altdest=altdest@entry=0x8373bc148, qc=qc@entry=0x820e307b0) at ../src/backend/tcop/pquery.c:787 [03:28:16.095] _local_sigjmp_buf = {{_sjb = {9730101, 35286126848, 34911487656, 34911487904, 34911487664, 12566200, 34911487920, 12520632, 12518271, 0, 35286090623, 34359738368}}} [03:28:16.095] _save_exception_stack = 0x820e30860 [03:28:16.095] _save_context_stack = 0x0 [03:28:16.095] _do_rethrow = false [03:28:16.095] saveTopTransactionResourceOwner = 0x8373c8258 [03:28:16.095] saveTopTransactionContext = 0x83737d000 [03:28:16.095] saveActivePortal = 0x0 [03:28:16.095] saveResourceOwner = 0x8373c8258 [03:28:16.095] savePortalContext = 0x0 [03:28:16.095] saveMemoryContext = 0x83737d000 [03:28:16.095] result = [03:28:16.095] nprocessed = [03:28:16.095] #15 0x0000000000946739 in exec_simple_query (query_string=query_string@entry=0x8372d3100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [03:28:16.095] cmdtaglen = 24 [03:28:16.095] snapshot_set = [03:28:16.095] per_parsetree_context = 0x0 [03:28:16.095] plantree_list = [03:28:16.095] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:28:16.095] format = 0 [03:28:16.095] parsetree = 0x8372d46a8 [03:28:16.095] commandTag = [03:28:16.095] cmdtagname = [03:28:16.095] querytree_list = [03:28:16.095] portal = 0x837379100 [03:28:16.095] receiver = 0x8373bc148 [03:28:16.095] parsetree_item__state = {l = 0x8372d4a18, i = 0} [03:28:16.095] msec_str = "\000\000\000\000\b", '\000' , "{\223\235g\000\000\000\000\261\253s%\r\210n\372" [03:28:16.095] dest = DestRemote [03:28:16.095] was_logged = [03:28:16.095] oldcontext = 0x83737d000 [03:28:16.095] parsetree_list = 0x8372d4a18 [03:28:16.095] use_implicit_block = false [03:28:16.095] parsetree_item = 0x8372d4a30 [03:28:16.095] save_log_statement_stats = [03:28:16.095] #16 0x00000000009443a3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [03:28:16.095] query_string = 0x8372d3100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:28:16.095] input_message = {data = 0x8372d3100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:28:16.095] firstchar = [03:28:16.095] local_sigjmp_buf = {{_sjb = {9713734, 34911488096, 34911488088, 34911488640, 12574952, 1, 8192, 8388608, 34911486847, 0, 0, 1}}} [03:28:16.095] send_ready_for_query = false [03:28:16.095] idle_in_transaction_timeout_enabled = false [03:28:16.095] idle_session_timeout_enabled = false [03:28:16.095] #17 0x000000000093ed39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:28:16.095] bsdata = [03:28:16.095] #18 0x00000000008965d5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x820e31590 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820e314e0) at ../src/backend/postmaster/launch_backend.c:274 [03:28:16.095] pid = [03:28:16.095] #19 0x000000000089a97b in BackendStartup (client_sock=0x820e314e0) at ../src/backend/postmaster/postmaster.c:3519 [03:28:16.095] startup_data = {canAcceptConnections = CAC_OK} [03:28:16.095] bn = 0x8373972a8 [03:28:16.095] cac = CAC_OK [03:28:16.095] pid = [03:28:16.095] __error = [03:28:16.095] save_errno = [03:28:16.095] __error = [03:28:16.095] __error = [03:28:16.095] #20 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:28:16.095] 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' , "@\025\343 \b\000\000\000h\025&,\b\000\000\000\346\000\000\000\000\000\000\000^\237&,\b", '\000' , "\200\025\343 \b\000\000\000dc\211\000\000\000\000\000\220\025\343 \b", '\000' }, salen = 16}} [03:28:16.095] i = 0 [03:28:16.095] now = [03:28:16.095] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 926143960, events = 8, fd = 551752480, user_data = 0x0}, {pos = 0, events = 0, fd = -83015026, user_data = 0x37c26aac830a}, {pos = 765999008, events = 8, fd = 766070136, user_data = 0x820e30fa8}, {pos = 551751712, events = 8, fd = 551751592, user_data = 0x37c26aac830a}, {pos = 765977480, events = 8, fd = 766070136, user_data = 0x820e30fd8}, {pos = 551751760, events = 8, fd = 551751640, user_data = 0x82da8d194}, {pos = 560071688, events = 8, fd = 766038420, user_data = 0x820e31040}, {pos = 1789670458, events = 14274, fd = 767860784, user_data = 0x1}, {pos = 551751792, events = 8, fd = 1789690634, user_data = 0x82da76858}, {pos = 766070136, events = 8, fd = 551751752, user_data = 0x820e310c0}, {pos = 551751752, events = 8, fd = 766033164, user_data = 0x821620408}, {pos = 766033164, events = 8, fd = 551751856, user_data = 0x37c26aac343a}, {pos = 551751896, events = 8, fd = 551752344, user_data = 0x820e310c0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3078139140, fd = 560095288, user_data = 0x800000001}, {pos = 560071688, events = 8, fd = 765977480, user_data = 0x821625288}, {pos = 765945944, events = 8, fd = 560071688, user_data = 0x820e31148}, {pos = 551752456, events = 8, fd = 551751984, user_data = 0x37c26aac7ca2}, {pos = 2722467, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 560095288, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 551752712, user_data = 0x21620408}, {pos = 551752528, events = 8, fd = 551752128, user_data = 0x1}, {pos = 551752456, events = 8, fd = 32, user_data = 0x820e311b0}, {pos = 1789688435, events = 14274, fd = 551752400, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821626038}, {pos = 1, events = 8, fd = 560071688, user_data = 0x82da76858}, {pos = 551752712, events = 8, fd = 551752528, user_data = 0x820e311c0}, {pos = 0, events = 0, fd = 560041992, user_data = 0x20}, {pos = 551752512, events = 8, fd = 1789663975, user_data = 0x821619008}, {pos = 560043016, events = 8, fd = 560044040, user_data = 0x821619c08}, {pos = 560058376, events = 8, fd = 560059400, user_data = 0x82161d808}, {pos = 560061448, events = 8, fd = 560062472, user_data = 0x82161e408}, {pos = 560064520, events = 8, fd = 560065544, user_data = 0x82161f008}, {pos = 560067592, events = 8, fd = 560068616, user_data = 0x82161fc08}, {pos = 560070664, events = 8, fd = 560071688, user_data = 0x821620808}, {pos = 560073736, events = 8, fd = 560074760, user_data = 0x821621408}, {pos = 560076808, events = 8, fd = 560077832, user_data = 0x821622008}, {pos = 560079880, events = 8, fd = 560080904, user_data = 0x821622c08}, {pos = 560087048, events = 8, fd = 560088072, user_data = 0x821624808}, {pos = 560090120, events = 8, fd = 560041992, user_data = 0x298aa3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821626038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 551752712, events = 8, fd = 551752128, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 560095288, user_data = 0x1}, {pos = 560041992, events = 8, fd = 298, user_data = 0x820e313f0}, {pos = 1789662703, events = 14274, fd = 2722467, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 560095288, user_data = 0x1}, {pos = 560071688, events = 8, fd = 925642752, user_data = 0x1}, {pos = 925643156, events = 8, fd = 0, user_data = 0x820e313c0}, {pos = 740726124, events = 8, fd = 1, user_data = 0x8372c3000}, {pos = 551752688, events = 8, fd = 740722434, user_data = 0x82dba8170 }, {pos = 12483008, events = 0, fd = 767197552, user_data = 0x821620408}, {pos = 551752912, events = 8, fd = 1789662174, user_data = 0x8372e1800}, {pos = 1, events = 8, fd = 1789661790, user_data = 0x821619008}, {pos = 551752696, events = 8, fd = 551752912, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1789741456, user_data = 0x0}, {pos = 551748479, events = 8, fd = 8136711, user_data = 0x820e31480}, {pos = 740684816, events = 8, fd = 767860784, user_data = 0x82dc4c310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820e314b0}, {pos = 740727709, events = 8, fd = 925642752, user_data = 0x1e02}, {pos = 551752976, events = 8, fd = 740694266, user_data = 0x0}, {pos = 0, events = 0, fd = -83015026, user_data = 0x0}} [03:28:16.095] last_touch_time = 1738380129 [03:28:16.095] last_lockfile_recheck_time = 1738380129 [03:28:16.095] nevents = 1 [03:28:16.095] #21 0x0000000000898db4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820e31b08) at ../src/backend/postmaster/postmaster.c:1386 [03:28:16.095] userDoption = [03:28:16.095] listen_addr_saved = false [03:28:16.095] output_config_variable = [03:28:16.095] opt = [03:28:16.095] status = [03:28:16.095] #22 0x00000000007cf4e0 in main (argc=4, argv=0x820e31b08) at ../src/backend/main/main.c:230 [03:28:16.095] do_check_root = [03:28:16.095] dispatch_option = DISPATCH_POSTMASTER [03:28:16.104] [03:28:16.104] [03:28:16.104] [03:28:16.167] dumping /tmp/cores/postgres.18148.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:28:16.292] [New LWP 101849] [03:28:16.359] Core was generated by `postgres: primary: postgres regression [local] CREATE MATERIALIZED VIEW'. [03:28:16.359] Program terminated with signal SIGABRT, Aborted. [03:28:16.359] Sent by thr_kill() from pid 18148 and user 1003. [03:28:16.359] #0 0x000000082abed41a in thr_kill () from /lib/libc.so.7 [03:28:16.402] [03:28:16.402] Thread 1 (LWP 101849): [03:28:16.402] #0 0x000000082abed41a in thr_kill () from /lib/libc.so.7 [03:28:16.402] No symbol table info available. [03:28:16.402] #1 0x000000082ab66e64 in raise () from /lib/libc.so.7 [03:28:16.402] No symbol table info available. [03:28:16.402] #2 0x000000082ac176f9 in abort () from /lib/libc.so.7 [03:28:16.402] No symbol table info available. [03:28:16.402] #3 0x0000000000aa3435 in ExceptionalCondition (conditionName=0x2ed36c "queryDesc->sourceText != NULL", fileName=, lineNumber=lineNumber@entry=194) at ../src/backend/utils/error/assert.c:66 [03:28:16.402] No locals. [03:28:16.402] #4 0x0000000000769bb9 in standard_ExecutorStart (queryDesc=0x836d7ebd0, eflags=0) at ../src/backend/executor/execMain.c:194 [03:28:16.402] estate = 0x83c06b100 [03:28:16.402] oldcontext = 0x836e3a800 [03:28:16.402] #5 0x000000083a0ac9c2 in pgss_ExecutorStart (queryDesc=0x836d7ebd0, eflags=6) at ../contrib/pg_stat_statements/pg_stat_statements.c:995 [03:28:16.402] No locals. [03:28:16.402] #6 0x00000000006fdd5f in refresh_matview_datafill (dest=, query=, queryString=0x0, is_create=false) at ../src/backend/commands/matview.c:446 [03:28:16.402] copied_query = [03:28:16.402] rewritten = [03:28:16.402] plan = 0x836d7e778 [03:28:16.402] queryDesc = 0x836d7ebd0 [03:28:16.402] processed = [03:28:16.402] __error = [03:28:16.402] #7 RefreshMatViewByOid (matviewOid=28580, is_create=, skipData=, concurrent=, queryString=0x0, qc=0x0) at ../src/backend/commands/matview.c:330 [03:28:16.402] dest = [03:28:16.402] save_userid = 10 [03:28:16.402] save_sec_context = 0 [03:28:16.402] processed = 0 [03:28:16.402] matviewRel = 0x83c1b3368 [03:28:16.402] relowner = 10 [03:28:16.402] save_nestlevel = 2 [03:28:16.402] rule = [03:28:16.402] actions = [03:28:16.402] dataQuery = [03:28:16.402] tableSpace = [03:28:16.402] relpersistence = [03:28:16.402] OIDNewHeap = 28587 [03:28:16.402] address = [03:28:16.402] #8 0x00000000006fd936 in ExecRefreshMatView (stmt=, queryString=queryString@entry=0x0, qc=qc@entry=0x0) at ../src/backend/commands/matview.c:138 [03:28:16.402] lockmode = [03:28:16.402] matviewOid = 0 [03:28:16.402] #9 0x00000000006d492c in ExecCreateTableAs (pstate=pstate@entry=0x836e3a900, stmt=stmt@entry=0x836e01fd0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821102160) at ../src/backend/commands/createas.c:351 [03:28:16.402] refresh = 0x0 [03:28:16.402] query = 0x83c0ffdc8 [03:28:16.402] into = 0x836e01f40 [03:28:16.402] jstate = 0x0 [03:28:16.402] do_refresh = false [03:28:16.402] address = [03:28:16.402] dest = [03:28:16.402] is_matview = [03:28:16.402] #10 0x000000000094a9de in ProcessUtilitySlow (pstate=pstate@entry=0x836e3a900, pstmt=pstmt@entry=0x836e01e30, queryString=queryString@entry=0x836ca4100 "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=0x821102160) at ../src/backend/tcop/utility.c:1678 [03:28:16.402] _local_sigjmp_buf = {{_sjb = {9740812, 0, 34914442184, 34914442560, 34914442192, 12566200, 0, 35280627968, 895, 1, 34914442316, 0}}} [03:28:16.402] _save_exception_stack = 0x821101e50 [03:28:16.402] _save_context_stack = 0x0 [03:28:16.402] _do_rethrow = false [03:28:16.402] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:28:16.402] parsetree = 0x836e01fd0 [03:28:16.402] commandCollected = false [03:28:16.402] needCleanup = false [03:28:16.402] address = [03:28:16.402] isTopLevel = [03:28:16.402] isCompleteQuery = [03:28:16.402] #11 0x000000000094935b in standard_ProcessUtility (pstmt=0x836e01e30, queryString=queryString@entry=0x836ca4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83c100568, qc=0x821102160) at ../src/backend/tcop/utility.c:1033 [03:28:16.402] isAtomicContext = false [03:28:16.402] parsetree = 0x836e01fd0 [03:28:16.402] readonly_flags = [03:28:16.402] pstate = 0x836e3a900 [03:28:16.402] isTopLevel = [03:28:16.402] #12 0x000000083a0acf70 in pgss_ProcessUtility (pstmt=0x836e01e30, queryString=0x836ca4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83c100568, qc=0x821102160) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [03:28:16.402] _local_sigjmp_buf = {{_sjb = {35333525161, 34914442832, 34914442696, 34914443152, 35280395824, 0, 12566200, 34914443360, 895, 1, 34914442948, 34359738368}}} [03:28:16.402] _save_exception_stack = 0x821102060 [03:28:16.402] _save_context_stack = 0x0 [03:28:16.402] _do_rethrow = false [03:28:16.402] bufusage = {shared_blks_hit = 35333525161, shared_blks_read = 34914442832, shared_blks_dirtied = 34914442696, shared_blks_written = 34914443152, local_blks_hit = 35280395824, local_blks_read = 0, local_blks_dirtied = 12566200, local_blks_written = 34914443360, temp_blks_read = 895, temp_blks_written = 1, shared_blk_read_time = {ticks = 34914442948}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 4196666563706554880}, local_blk_write_time = {ticks = 12575128}, temp_blk_read_time = {ticks = 35341065344}, temp_blk_write_time = {ticks = 12516592}} [03:28:16.402] walusage_start = {wal_records = 8979, wal_fpi = 172, wal_bytes = 1463578} [03:28:16.402] duration = [03:28:16.402] bufusage_start = {shared_blks_hit = 153321, shared_blks_read = 9824, shared_blks_dirtied = 2918, shared_blks_written = 2551, 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}} [03:28:16.402] walusage = {wal_records = 0, wal_fpi = 549755813888, wal_bytes = 1642811004855461850} [03:28:16.402] start = {ticks = -198329205352} [03:28:16.402] rows = [03:28:16.402] saved_queryId = 7267788456574341698 [03:28:16.402] parsetree = [03:28:16.402] saved_stmt_location = 0 [03:28:16.402] saved_stmt_len = 69 [03:28:16.402] enabled = [03:28:16.402] #13 0x0000000000948923 in PortalRunUtility (portal=0x836d4a100, pstmt=0x836e01e30, isTopLevel=, setHoldSnapshot=, dest=0x83c100568, qc=0x821102160) at ../src/backend/tcop/pquery.c:1152 [03:28:16.402] No locals. [03:28:16.402] #14 0x0000000000947fd4 in PortalRunMulti (portal=portal@entry=0x836d4a100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83c100568, altdest=altdest@entry=0x83c100568, qc=qc@entry=0x821102160) at ../src/backend/tcop/pquery.c:1316 [03:28:16.402] pstmt = 0x836e01e30 [03:28:16.402] stmtlist_item__state = {l = 0x83c100518, i = 0} [03:28:16.402] active_snapshot_set = false [03:28:16.402] stmtlist_item = 0x83c100530 [03:28:16.402] #15 0x00000000009478bb in PortalRun (portal=portal@entry=0x836d4a100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x83c100568, altdest=altdest@entry=0x83c100568, qc=qc@entry=0x821102160) at ../src/backend/tcop/pquery.c:787 [03:28:16.402] _local_sigjmp_buf = {{_sjb = {9730101, 35279642880, 34914443352, 34914443600, 34914443360, 12566200, 34914443616, 12520632, 12518271, 0, 35279602559, 34359738368}}} [03:28:16.402] _save_exception_stack = 0x821102210 [03:28:16.402] _save_context_stack = 0x0 [03:28:16.402] _do_rethrow = false [03:28:16.402] saveTopTransactionResourceOwner = 0x836d9fed8 [03:28:16.402] saveTopTransactionContext = 0x836d4e000 [03:28:16.402] saveActivePortal = 0x0 [03:28:16.402] saveResourceOwner = 0x836d9fed8 [03:28:16.402] savePortalContext = 0x0 [03:28:16.402] saveMemoryContext = 0x836d4e000 [03:28:16.402] result = [03:28:16.402] nprocessed = [03:28:16.402] #16 0x0000000000946739 in exec_simple_query (query_string=query_string@entry=0x836ca4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;") at ../src/backend/tcop/postgres.c:1271 [03:28:16.402] cmdtaglen = 24 [03:28:16.402] snapshot_set = [03:28:16.402] per_parsetree_context = 0x0 [03:28:16.402] plantree_list = [03:28:16.402] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:28:16.402] format = 0 [03:28:16.402] parsetree = 0x836ca56a8 [03:28:16.402] commandTag = [03:28:16.402] cmdtagname = [03:28:16.402] querytree_list = [03:28:16.402] portal = 0x836d4a100 [03:28:16.402] receiver = 0x83c100568 [03:28:16.402] parsetree_item__state = {l = 0x836ca5a18, i = 0} [03:28:16.402] msec_str = "\000\000\000\000\b", '\000' , "\244\223\235g\000\000\000\000\217D\032L", [03:28:16.402] dest = DestRemote [03:28:16.402] was_logged = [03:28:16.402] oldcontext = 0x836d4e000 [03:28:16.402] parsetree_list = 0x836ca5a18 [03:28:16.402] use_implicit_block = false [03:28:16.402] parsetree_item = 0x836ca5a30 [03:28:16.402] save_log_statement_stats = [03:28:16.402] #17 0x00000000009443a3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [03:28:16.402] query_string = 0x836ca4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;" [03:28:16.402] input_message = {data = 0x836ca4100 "CREATE OR REPLACE MATERIALIZED VIEW mvtest_replace AS\n SELECT 2 AS a;", len = 71, maxlen = 1024, cursor = 71} [03:28:16.402] firstchar = [03:28:16.402] local_sigjmp_buf = {{_sjb = {9713734, 34914443792, 34914443784, 34914444336, 12574952, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [03:28:16.402] send_ready_for_query = false [03:28:16.402] idle_in_transaction_timeout_enabled = false [03:28:16.402] idle_session_timeout_enabled = false [03:28:16.402] #18 0x000000000093ed39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:28:16.402] bsdata = [03:28:16.402] #19 0x00000000008965d5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=9, startup_data=startup_data@entry=0x821102f40 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821102e90) at ../src/backend/postmaster/launch_backend.c:274 [03:28:16.402] pid = [03:28:16.402] #20 0x000000000089a97b in BackendStartup (client_sock=0x821102e90) at ../src/backend/postmaster/postmaster.c:3519 [03:28:16.402] startup_data = {canAcceptConnections = CAC_OK} [03:28:16.402] bn = 0x836d8b7f8 [03:28:16.402] cac = CAC_OK [03:28:16.402] pid = [03:28:16.402] __error = [03:28:16.402] save_errno = [03:28:16.402] __error = [03:28:16.402] __error = [03:28:16.402] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [03:28:16.402] 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' , "\360.\020!\b\000\000\000h\245\333)\b\000\000\000W\000\000\000\000\000\000\000^/\334)\b", '\000' , "0/\020!\b\000\000\000dc\211\000\000\000\000\000@/\020!\b", '\000' }, salen = 16}} [03:28:16.402] i = 0 [03:28:16.402] now = [03:28:16.402] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 919631320, events = 8, fd = 554708176, user_data = 0x0}, {pos = 257438474, events = 11404, fd = 715941792, user_data = 0x82aad7d78}, {pos = 554707272, events = 8, fd = 554707392, user_data = 0x821102948}, {pos = 257438474, events = 11404, fd = 715920264, user_data = 0x82aad7d78}, {pos = 554707320, events = 8, fd = 554707440, user_data = 0x821102978}, {pos = 715981204, events = 8, fd = 559105032, user_data = 0x82aad0194}, {pos = 554707424, events = 8, fd = 257418298, user_data = 0x821102980}, {pos = 702252048, events = 8, fd = 717803568, user_data = 0x2c8c0f58330a}, {pos = 715888728, events = 8, fd = 716012920, user_data = 0x8211029e8}, {pos = 554707552, events = 8, fd = 554707432, user_data = 0x82aaced0c}, {pos = 559105032, events = 8, fd = 715975948, user_data = 0x821102a50}, {pos = 257418298, events = 11404, fd = 554707576, user_data = 0x821102c48}, {pos = 554707552, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x82153a038}, {pos = 1, events = 382496743, fd = 559105032, user_data = 0x82aac1388}, {pos = 559126472, events = 8, fd = 0, user_data = 0x0}, {pos = 554707688, events = 8, fd = 554708152, user_data = 0x821102ad0}, {pos = 257436834, events = 11404, fd = 2722467, user_data = 0x6d68b}, {pos = 2090263927, events = 382496743, fd = 559128632, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821102db8}, {pos = 559105032, events = 3, fd = 554708224, user_data = 0x821539828}, {pos = 656, events = 0, fd = 554708152, user_data = 0x821102ae8}, {pos = 554707792, events = 8, fd = 257436443, user_data = 0x821102c80}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 559128632, events = 8, fd = 1, user_data = 0x821534408}, {pos = 715888728, events = 8, fd = 554708408, user_data = 0x821102d00}, {pos = 554707808, events = 8, fd = 0, user_data = 0x82152d008}, {pos = 33, events = 0, fd = 554708208, user_data = 0x2c8c0f57cae7}, {pos = 559075336, events = 8, fd = 559076360, user_data = 0x82152d808}, {pos = 559078408, events = 8, fd = 559091720, user_data = 0x821531408}, {pos = 559093768, events = 8, fd = 559094792, user_data = 0x821532008}, {pos = 559096840, events = 8, fd = 559097864, user_data = 0x821532c08}, {pos = 559099912, events = 8, fd = 559100936, user_data = 0x821533808}, {pos = 559102984, events = 8, fd = 559104008, user_data = 0x821534408}, {pos = 559106056, events = 8, fd = 559107080, user_data = 0x821535008}, {pos = 559109128, events = 8, fd = 559110152, user_data = 0x821535c08}, {pos = 559112200, events = 8, fd = 559113224, user_data = 0x821536808}, {pos = 559115272, events = 8, fd = 559120392, user_data = 0x821538408}, {pos = 559122440, events = 8, fd = 559123464, user_data = 0x82153b408}, {pos = 138374000, events = 0, fd = 559075336, user_data = 0x298aa3}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82153a038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554708408, events = 8, fd = 554707808, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 559128632, user_data = 0x1}, {pos = 559075336, events = 8, fd = 298, user_data = 0x821102da0}, {pos = 257410543, events = 11404, fd = 2722467, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 559128632, user_data = 0x1}, {pos = 559105032, events = 8, fd = 919158784, user_data = 0x1}, {pos = 919159188, events = 8, fd = 0, user_data = 0x821102d70}, {pos = 702293356, events = 8, fd = 1, user_data = 0x836c94000}, {pos = 554708384, events = 8, fd = 702289666, user_data = 0x82abeb170 }, {pos = 12483008, events = 0, fd = 717140336, user_data = 0x821534408}, {pos = 554708608, events = 8, fd = 257410014, user_data = 0x836cb2800}, {pos = 1, events = 8, fd = 257409630, user_data = 0x82152d008}, {pos = 554708392, events = 8, fd = 554708608, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 257489296, user_data = 0x0}, {pos = 554697599, events = 8, fd = 8136711, user_data = 0x821102e30}, {pos = 702252048, events = 8, fd = 717803568, user_data = 0x82ac8f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821102e60}, {pos = 702294941, events = 8, fd = 919158784, user_data = 0x3684}, {pos = 554708672, events = 8, fd = 702261498, user_data = 0x0}, {pos = 0, events = 0, fd = -1451022374, user_data = 0x0}} [03:28:16.402] last_touch_time = 1738380166 [03:28:16.402] last_lockfile_recheck_time = 1738380166 [03:28:16.402] nevents = 1 [03:28:16.402] #22 0x0000000000898db4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8211034b8) at ../src/backend/postmaster/postmaster.c:1386 [03:28:16.402] userDoption = [03:28:16.402] listen_addr_saved = false [03:28:16.402] output_config_variable = [03:28:16.402] opt = [03:28:16.402] status = [03:28:16.402] #23 0x00000000007cf4e0 in main (argc=4, argv=0x8211034b8) at ../src/backend/main/main.c:230 [03:28:16.402] do_check_root = [03:28:16.402] dispatch_option = DISPATCH_POSTMASTER