[08:56:37.875] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [08:56:38.187] dumping /tmp/cores/postgres.8981.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:56:38.324] [New LWP 101905] [08:56:38.399] Core was generated by `postgres: postgres regression [local] CREATE INDEX'. [08:56:38.399] Program terminated with signal SIGBUS, Bus error. [08:56:38.399] Object-specific hardware error. [08:56:38.399] #0 0x00000000006f962c in DefineIndex (tableId=tableId@entry=20058, stmt=stmt@entry=0x8435c6b28, indexRelationId=20061, indexRelationId@entry=0, parentIndexId=parentIndexId@entry=0, parentConstraintId=parentConstraintId@entry=0, total_parts=total_parts@entry=-1, is_alter_table=, check_rights=, check_not_in_use=, skip_build=, quiet=, verbose=) at ../src/backend/commands/indexcmds.c:1612 [08:56:38.399] 1612 ereport(INFO, [08:56:38.439] [08:56:38.439] Thread 1 (LWP 101905): [08:56:38.439] #0 0x00000000006f962c in DefineIndex (tableId=tableId@entry=20058, stmt=stmt@entry=0x8435c6b28, indexRelationId=20061, indexRelationId@entry=0, parentIndexId=parentIndexId@entry=0, parentConstraintId=parentConstraintId@entry=0, total_parts=total_parts@entry=-1, is_alter_table=, check_rights=, check_not_in_use=, skip_build=, quiet=, verbose=) at ../src/backend/commands/indexcmds.c:1612 [08:56:38.439] __error = [08:56:38.439] createdConstraintId = 0 [08:56:38.439] heaprelid = {relId = 16, dbId = 0} [08:56:38.439] root_save_userid = 10 [08:56:38.439] root_save_sec_context = 0 [08:56:38.439] root_save_nestlevel = 2 [08:56:38.439] ru0 = {tv = {tv_sec = 1738313457, tv_usec = 102808}, ru = {ru_utime = {tv_sec = 0, tv_usec = 333121}, ru_stime = {tv_sec = 0, tv_usec = 10094}, ru_maxrss = 81240, ru_ixrss = 207264, ru_idrss = 11696, ru_isrss = 4352, ru_minflt = 1946, ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 84, ru_msgsnd = 313, ru_msgrcv = 298, ru_nsignals = 0, ru_nvcsw = 153, ru_nivcsw = 582}} [08:56:38.439] concurrent = [08:56:38.439] numberOfKeyAttributes = [08:56:38.439] allIndexParams = [08:56:38.439] numberOfAttributes = [08:56:38.439] lockmode = 5 [08:56:38.439] rel = 0x845441c70 [08:56:38.439] namespaceId = [08:56:38.439] exclusion = false [08:56:38.439] tablespaceId = 0 [08:56:38.439] indexColNames = [08:56:38.439] indexRelationName = [08:56:38.439] accessMethodName = 0x8435c6c48 "btree" [08:56:38.439] tuple = [08:56:38.439] accessMethodId = 403 [08:56:38.439] amRoutine = [08:56:38.439] amoptions = [08:56:38.439] reloptions = 0 [08:56:38.439] indexInfo = 0x8338da838 [08:56:38.439] typeIds = [08:56:38.439] collationIds = 0x83390f068 [08:56:38.439] opclassIds = 0x83390f080 [08:56:38.439] opclassOptions = 0x83390f098 [08:56:38.439] coloptions = 0x83390f0b0 [08:56:38.439] safe_index = true [08:56:38.439] constr_flags = [08:56:38.439] flags = [08:56:38.439] address = {classId = 1259, objectId = 20061, objectSubId = 0} [08:56:38.439] heaplocktag = [08:56:38.439] snapshot = [08:56:38.439] limitXmin = [08:56:38.439] accessMethodForm = [08:56:38.439] amcanorder = [08:56:38.439] amissummarizing = [08:56:38.439] partitioned = [08:56:38.439] #1 0x000000000094ae65 in ProcessUtilitySlow (pstate=pstate@entry=0x83392f500, pstmt=pstmt@entry=0x833874858, queryString=queryString@entry=0x833873100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x821a311d0) at ../src/backend/tcop/utility.c:1561 [08:56:38.439] stmt = 0x8435c6b28 [08:56:38.439] nparts = -1 [08:56:38.439] lockmode = [08:56:38.439] is_alter_table = [08:56:38.439] verbose = [08:56:38.439] lc = [08:56:38.439] relid = 20058 [08:56:38.439] _local_sigjmp_buf = {{_sjb = {9740506, 35489868584, 34924072440, 34924072816, 34924072448, 12565336, 0, 0, 34924069759, 35079512039, 35489866856, 0}}} [08:56:38.439] _save_exception_stack = 0x821a310d0 [08:56:38.439] _save_context_stack = 0x0 [08:56:38.439] _do_rethrow = false [08:56:38.439] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:56:38.439] parsetree = 0x8435c6b28 [08:56:38.439] commandCollected = false [08:56:38.439] needCleanup = false [08:56:38.439] address = [08:56:38.439] isTopLevel = [08:56:38.439] isCompleteQuery = [08:56:38.439] #2 0x000000000094922b in standard_ProcessUtility (pstmt=0x833874858, queryString=0x833873100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8435c6e70, qc=0x821a311d0) at ../src/backend/tcop/utility.c:1033 [08:56:38.439] isAtomicContext = false [08:56:38.439] parsetree = 0x8435c6b28 [08:56:38.439] readonly_flags = [08:56:38.439] pstate = 0x83392f500 [08:56:38.439] isTopLevel = [08:56:38.439] #3 0x0000000000948cb8 in ProcessUtility (pstmt=0x83386f000, queryString=0x0, readOnlyTree=, context=12574096, params=0x7f, queryEnv=0x845441c70, dest=0x8435c6e70, qc=0x821a311d0) at ../src/backend/tcop/utility.c:523 [08:56:38.439] No locals. [08:56:38.439] #4 0x00000000009487f3 in PortalRunUtility (portal=0x833948100, pstmt=0x833874858, isTopLevel=, setHoldSnapshot=, dest=0x8435c6e70, qc=0x821a311d0) at ../src/backend/tcop/pquery.c:1152 [08:56:38.439] No locals. [08:56:38.439] #5 0x0000000000947ea4 in PortalRunMulti (portal=portal@entry=0x833948100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8435c6e70, altdest=altdest@entry=0x8435c6e70, qc=qc@entry=0x821a311d0) at ../src/backend/tcop/pquery.c:1316 [08:56:38.439] pstmt = 0x833874858 [08:56:38.439] stmtlist_item__state = {l = 0x8435c6e20, i = 0} [08:56:38.439] active_snapshot_set = false [08:56:38.439] stmtlist_item = 0x8435c6e38 [08:56:38.439] #6 0x000000000094778b in PortalRun (portal=portal@entry=0x833948100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8435c6e70, altdest=altdest@entry=0x8435c6e70, qc=qc@entry=0x821a311d0) at ../src/backend/tcop/pquery.c:787 [08:56:38.439] _local_sigjmp_buf = {{_sjb = {9729797, 35225108736, 34924073160, 34924073408, 34924073168, 12565336, 34924073424, 12519768, 12518271, 0, 35225076607, 34359738368}}} [08:56:38.439] _save_exception_stack = 0x821a31280 [08:56:38.439] _save_context_stack = 0x0 [08:56:38.439] _do_rethrow = false [08:56:38.439] saveTopTransactionResourceOwner = 0x833958788 [08:56:38.439] saveTopTransactionContext = 0x83394d000 [08:56:38.439] saveActivePortal = 0x0 [08:56:38.439] saveResourceOwner = 0x833958788 [08:56:38.439] savePortalContext = 0x0 [08:56:38.439] saveMemoryContext = 0x83394d000 [08:56:38.439] result = [08:56:38.439] nprocessed = [08:56:38.439] #7 0x0000000000946609 in exec_simple_query (query_string=query_string@entry=0x833873100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);") at ../src/backend/tcop/postgres.c:1271 [08:56:38.439] cmdtaglen = 12 [08:56:38.439] snapshot_set = [08:56:38.439] per_parsetree_context = 0x0 [08:56:38.439] plantree_list = [08:56:38.439] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:56:38.439] format = 0 [08:56:38.439] parsetree = 0x833874530 [08:56:38.439] commandTag = [08:56:38.439] cmdtagname = [08:56:38.439] querytree_list = [08:56:38.439] portal = 0x833948100 [08:56:38.439] receiver = 0x8435c6e70 [08:56:38.439] parsetree_item__state = {l = 0x833874808, i = 0} [08:56:38.439] msec_str = "\000\000\000\000\b", '\000' , "\361\216\234g\000\000\000\000@\243\v\027}{W\026" [08:56:38.439] dest = DestRemote [08:56:38.439] was_logged = [08:56:38.439] oldcontext = 0x83394d000 [08:56:38.439] parsetree_list = 0x833874808 [08:56:38.439] use_implicit_block = false [08:56:38.439] parsetree_item = 0x833874820 [08:56:38.439] save_log_statement_stats = [08:56:38.439] #8 0x0000000000944273 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [08:56:38.439] query_string = 0x833873100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);" [08:56:38.439] input_message = {data = 0x833873100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);", len = 60, maxlen = 1024, cursor = 60} [08:56:38.439] firstchar = [08:56:38.439] local_sigjmp_buf = {{_sjb = {9713430, 34924073600, 34924073592, 34924074144, 12574088, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [08:56:38.439] send_ready_for_query = false [08:56:38.439] idle_in_transaction_timeout_enabled = false [08:56:38.439] idle_session_timeout_enabled = false [08:56:38.439] #9 0x000000000093ec09 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:56:38.439] bsdata = [08:56:38.439] #10 0x00000000008964a5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=11, startup_data=startup_data@entry=0x821a31fb0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a31f00) at ../src/backend/postmaster/launch_backend.c:274 [08:56:38.439] pid = [08:56:38.439] #11 0x000000000089a84b in BackendStartup (client_sock=0x821a31f00) at ../src/backend/postmaster/postmaster.c:3519 [08:56:38.439] startup_data = {canAcceptConnections = CAC_OK} [08:56:38.439] bn = 0x83391b218 [08:56:38.439] cac = CAC_OK [08:56:38.439] pid = [08:56:38.439] __error = [08:56:38.439] save_errno = [08:56:38.439] __error = [08:56:38.439] __error = [08:56:38.439] #12 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [08:56:38.439] 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' , "`\037\243!\b\000\000\000h\005I)\b\000\000\000\372\000\000\000\000\000\000\000^\217I)\b", '\000' , "\240\037\243!\b\000\000\0004b\211\000\000\000\000\000\260\037\243!\b", '\000' }, salen = 16}} [08:56:38.439] i = 0 [08:56:38.439] now = [08:56:38.439] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 864896472, events = 8, fd = 564337984, user_data = 0x821a31aa0}, {pos = 8192, events = 0, fd = 4096, user_data = 0x833948000}, {pos = 564337120, events = 8, fd = 719993415, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 718308232, events = 8, fd = 718400888, user_data = 0x821a319f8}, {pos = 564337264, events = 8, fd = 564337312, user_data = 0x821a31a98}, {pos = 846356624, events = 8, fd = 857737600, user_data = 0x20}, {pos = 4096, events = 0, fd = 564337760, user_data = 0x82ae9ea7c}, {pos = 564337184, events = 8, fd = 78119690, user_data = 0x82ad00858}, {pos = 718400888, events = 8, fd = 564337256, user_data = 0x821a31ae0}, {pos = 564337256, events = 8, fd = 718363916, user_data = 0x821ff7408}, {pos = 718363916, events = 8, fd = 564337360, user_data = 0x3d3404a7b43a}, {pos = 846356672, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 857748024, events = 8, fd = 0, user_data = 0x0}, {pos = 857786368, events = 8, fd = 0, user_data = 0x821ffc288}, {pos = 718276696, events = 8, fd = 570389512, user_data = 0x821a31b68}, {pos = 564337960, events = 8, fd = 564337488, user_data = 0x3d3404a7fca2}, {pos = 2722414, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 570413112, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 564338216, user_data = 0x21ff7408}, {pos = 564338032, events = 8, fd = 564337632, user_data = 0x1}, {pos = 564337960, events = 8, fd = 32, user_data = 0x821a31bd0}, {pos = 78117491, events = 15668, fd = 564337904, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821ffd038}, {pos = 1, events = 8, fd = 570389512, user_data = 0x82ad00858}, {pos = 564338216, events = 8, fd = 564338032, user_data = 0x821a31be0}, {pos = 0, events = 0, fd = 570359816, user_data = 0x20}, {pos = 564338016, events = 8, fd = 78093031, user_data = 0x821ff0008}, {pos = 570360840, events = 8, fd = 570361864, user_data = 0x821ff0c08}, {pos = 570376200, events = 8, fd = 570377224, user_data = 0x821ff4808}, {pos = 570379272, events = 8, fd = 570380296, user_data = 0x821ff5408}, {pos = 570382344, events = 8, fd = 570383368, user_data = 0x821ff6008}, {pos = 570385416, events = 8, fd = 570386440, user_data = 0x821ff6c08}, {pos = 570388488, events = 8, fd = 570389512, user_data = 0x821ff7808}, {pos = 570391560, events = 8, fd = 570392584, user_data = 0x821ff8408}, {pos = 570394632, events = 8, fd = 570395656, user_data = 0x821ff9008}, {pos = 570397704, events = 8, fd = 570398728, user_data = 0x821ff9c08}, {pos = 570404872, events = 8, fd = 570405896, user_data = 0x821ffb808}, {pos = 570407944, events = 8, fd = 570359816, user_data = 0x298a6e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821ffd038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564338216, events = 8, fd = 564337632, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 570413112, user_data = 0x1}, {pos = 570359816, events = 8, fd = 298, user_data = 0x821a31e10}, {pos = 78091759, events = 15668, fd = 2722414, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 570413112, user_data = 0x1}, {pos = 570389512, events = 8, fd = 864432128, user_data = 0x1}, {pos = 864432532, events = 8, fd = 0, user_data = 0x821a31de0}, {pos = 692684140, events = 8, fd = 1, user_data = 0x833863000}, {pos = 564338192, events = 8, fd = 692680450, user_data = 0x82ae32170 }, {pos = 12482144, events = 0, fd = 719528304, user_data = 0x821ff7408}, {pos = 564338416, events = 8, fd = 78091230, user_data = 0x833881800}, {pos = 1, events = 8, fd = 78090846, user_data = 0x821ff0008}, {pos = 564338200, events = 8, fd = 564338416, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 78170512, user_data = 0x0}, {pos = 564331391, events = 8, fd = 8136439, user_data = 0x821a31ea0}, {pos = 692642832, events = 8, fd = 720191536, user_data = 0x82aed6310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a31ed0}, {pos = 692685725, events = 8, fd = 864432128, user_data = 0x1d91}, {pos = 564338480, events = 8, fd = 692652282, user_data = 0x0}, {pos = 0, events = 0, fd = -2107389872, user_data = 0x0}} [08:56:38.439] last_touch_time = 1738313448 [08:56:38.439] last_lockfile_recheck_time = 1738313448 [08:56:38.439] nevents = 1 [08:56:38.439] #13 0x0000000000898c84 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821a32528) at ../src/backend/postmaster/postmaster.c:1386 [08:56:38.439] userDoption = [08:56:38.439] listen_addr_saved = false [08:56:38.439] output_config_variable = [08:56:38.439] opt = [08:56:38.439] status = [08:56:38.439] #14 0x00000000007cf3d0 in main (argc=8, argv=0x821a32528) at ../src/backend/main/main.c:230 [08:56:38.439] do_check_root = [08:56:38.439] dispatch_option = DISPATCH_POSTMASTER [08:56:38.450] [08:56:38.450] [08:56:38.450] [08:56:38.514] dumping /tmp/cores/postgres.9442.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:56:38.639] [New LWP 101869] [08:56:38.712] Core was generated by `postgres: old_node: postgres regression [local] CREATE INDEX'. [08:56:38.712] Program terminated with signal SIGBUS, Bus error. [08:56:38.712] Object-specific hardware error. [08:56:38.712] #0 0x00000000006f962c in DefineIndex (tableId=tableId@entry=19875, stmt=stmt@entry=0x8363c0b28, indexRelationId=19881, indexRelationId@entry=0, parentIndexId=parentIndexId@entry=0, parentConstraintId=parentConstraintId@entry=0, total_parts=total_parts@entry=-1, is_alter_table=, check_rights=, check_not_in_use=, skip_build=, quiet=, verbose=) at ../src/backend/commands/indexcmds.c:1612 [08:56:38.712] 1612 ereport(INFO, [08:56:38.735] [08:56:38.735] Thread 1 (LWP 101869): [08:56:38.735] #0 0x00000000006f962c in DefineIndex (tableId=tableId@entry=19875, stmt=stmt@entry=0x8363c0b28, indexRelationId=19881, indexRelationId@entry=0, parentIndexId=parentIndexId@entry=0, parentConstraintId=parentConstraintId@entry=0, total_parts=total_parts@entry=-1, is_alter_table=, check_rights=, check_not_in_use=, skip_build=, quiet=, verbose=) at ../src/backend/commands/indexcmds.c:1612 [08:56:38.735] __error = [08:56:38.735] createdConstraintId = 0 [08:56:38.735] heaprelid = {relId = 16, dbId = 0} [08:56:38.735] root_save_userid = 10 [08:56:38.735] root_save_sec_context = 0 [08:56:38.735] root_save_nestlevel = 2 [08:56:38.735] ru0 = {tv = {tv_sec = 1738313459, tv_usec = 552796}, ru = {ru_utime = {tv_sec = 0, tv_usec = 314527}, ru_stime = {tv_sec = 0, tv_usec = 22466}, ru_maxrss = 81680, ru_ixrss = 182880, ru_idrss = 10320, ru_isrss = 3840, ru_minflt = 2257, ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 96, ru_msgsnd = 314, ru_msgrcv = 298, ru_nsignals = 0, ru_nvcsw = 263, ru_nivcsw = 353}} [08:56:38.735] concurrent = [08:56:38.735] numberOfKeyAttributes = [08:56:38.735] allIndexParams = [08:56:38.735] numberOfAttributes = [08:56:38.735] lockmode = 5 [08:56:38.735] rel = 0x8449f15c8 [08:56:38.735] namespaceId = [08:56:38.735] exclusion = false [08:56:38.735] tablespaceId = 0 [08:56:38.735] indexColNames = [08:56:38.735] indexRelationName = [08:56:38.735] accessMethodName = 0x8363c0c48 "btree" [08:56:38.735] tuple = [08:56:38.735] accessMethodId = 403 [08:56:38.735] amRoutine = [08:56:38.735] amoptions = [08:56:38.735] reloptions = 0 [08:56:38.735] indexInfo = 0x8363b9038 [08:56:38.735] typeIds = [08:56:38.735] collationIds = 0x8363b8068 [08:56:38.735] opclassIds = 0x8363b8080 [08:56:38.735] opclassOptions = 0x8363b8098 [08:56:38.735] coloptions = 0x8363b80b0 [08:56:38.735] safe_index = true [08:56:38.735] constr_flags = [08:56:38.735] flags = [08:56:38.735] address = {classId = 1259, objectId = 19881, objectSubId = 0} [08:56:38.735] heaplocktag = [08:56:38.735] snapshot = [08:56:38.735] limitXmin = [08:56:38.735] accessMethodForm = [08:56:38.735] amcanorder = [08:56:38.735] amissummarizing = [08:56:38.735] partitioned = [08:56:38.735] #1 0x000000000094ae65 in ProcessUtilitySlow (pstate=pstate@entry=0x836423500, pstmt=pstmt@entry=0x83634b858, queryString=queryString@entry=0x83634a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x820d5e680) at ../src/backend/tcop/utility.c:1561 [08:56:38.735] stmt = 0x8363c0b28 [08:56:38.735] nparts = -1 [08:56:38.735] lockmode = [08:56:38.735] is_alter_table = [08:56:38.735] verbose = [08:56:38.735] lc = [08:56:38.735] relid = 19875 [08:56:38.735] _local_sigjmp_buf = {{_sjb = {9740506, 35269643048, 34910626472, 34910626848, 34910626480, 12565336, 0, 0, 34910569343, 35078107111, 35269641320, 0}}} [08:56:38.735] _save_exception_stack = 0x820d5e580 [08:56:38.735] _save_context_stack = 0x0 [08:56:38.735] _do_rethrow = false [08:56:38.735] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:56:38.735] parsetree = 0x8363c0b28 [08:56:38.735] commandCollected = false [08:56:38.735] needCleanup = false [08:56:38.735] address = [08:56:38.735] isTopLevel = [08:56:38.735] isCompleteQuery = [08:56:38.735] #2 0x000000000094922b in standard_ProcessUtility (pstmt=0x83634b858, queryString=0x83634a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8363c0e70, qc=0x820d5e680) at ../src/backend/tcop/utility.c:1033 [08:56:38.735] isAtomicContext = false [08:56:38.735] parsetree = 0x8363c0b28 [08:56:38.735] readonly_flags = [08:56:38.735] pstate = 0x836423500 [08:56:38.735] isTopLevel = [08:56:38.735] #3 0x0000000000948cb8 in ProcessUtility (pstmt=0x836346000, queryString=0x0, readOnlyTree=, context=12574096, params=0xfffffffffffffff8, queryEnv=0x8449f15c8, dest=0x8363c0e70, qc=0x820d5e680) at ../src/backend/tcop/utility.c:523 [08:56:38.735] No locals. [08:56:38.735] #4 0x00000000009487f3 in PortalRunUtility (portal=0x8363ee100, pstmt=0x83634b858, isTopLevel=, setHoldSnapshot=, dest=0x8363c0e70, qc=0x820d5e680) at ../src/backend/tcop/pquery.c:1152 [08:56:38.735] No locals. [08:56:38.735] #5 0x0000000000947ea4 in PortalRunMulti (portal=portal@entry=0x8363ee100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8363c0e70, altdest=altdest@entry=0x8363c0e70, qc=qc@entry=0x820d5e680) at ../src/backend/tcop/pquery.c:1316 [08:56:38.735] pstmt = 0x83634b858 [08:56:38.735] stmtlist_item__state = {l = 0x8363c0e20, i = 0} [08:56:38.735] active_snapshot_set = false [08:56:38.735] stmtlist_item = 0x8363c0e38 [08:56:38.735] #6 0x000000000094778b in PortalRun (portal=portal@entry=0x8363ee100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8363c0e70, altdest=altdest@entry=0x8363c0e70, qc=qc@entry=0x820d5e680) at ../src/backend/tcop/pquery.c:787 [08:56:38.735] _local_sigjmp_buf = {{_sjb = {9729797, 35269828864, 34910627192, 34910627440, 34910627200, 12565336, 34910627456, 12519768, 12518271, 0, 35269837695, 34359738368}}} [08:56:38.735] _save_exception_stack = 0x820d5e730 [08:56:38.735] _save_context_stack = 0x0 [08:56:38.735] _do_rethrow = false [08:56:38.735] saveTopTransactionResourceOwner = 0x836435f18 [08:56:38.735] saveTopTransactionContext = 0x8363f2000 [08:56:38.735] saveActivePortal = 0x0 [08:56:38.735] saveResourceOwner = 0x836435f18 [08:56:38.735] savePortalContext = 0x0 [08:56:38.735] saveMemoryContext = 0x8363f2000 [08:56:38.735] result = [08:56:38.735] nprocessed = [08:56:38.735] #7 0x0000000000946609 in exec_simple_query (query_string=query_string@entry=0x83634a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);") at ../src/backend/tcop/postgres.c:1271 [08:56:38.735] cmdtaglen = 12 [08:56:38.735] snapshot_set = [08:56:38.735] per_parsetree_context = 0x0 [08:56:38.735] plantree_list = [08:56:38.735] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:56:38.735] format = 0 [08:56:38.735] parsetree = 0x83634b530 [08:56:38.735] commandTag = [08:56:38.735] cmdtagname = [08:56:38.735] querytree_list = [08:56:38.735] portal = 0x8363ee100 [08:56:38.735] receiver = 0x8363c0e70 [08:56:38.735] parsetree_item__state = {l = 0x83634b808, i = 0} [08:56:38.735] msec_str = "\000\000\000\000\b", '\000' , "\363\216\234g\000\000\000\000\316\322\0261i\221z\215" [08:56:38.735] dest = DestRemote [08:56:38.735] was_logged = [08:56:38.735] oldcontext = 0x8363f2000 [08:56:38.735] parsetree_list = 0x83634b808 [08:56:38.735] use_implicit_block = false [08:56:38.735] parsetree_item = 0x83634b820 [08:56:38.735] save_log_statement_stats = [08:56:38.735] #8 0x0000000000944273 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [08:56:38.735] query_string = 0x83634a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);" [08:56:38.735] input_message = {data = 0x83634a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);", len = 60, maxlen = 1024, cursor = 60} [08:56:38.735] firstchar = [08:56:38.735] local_sigjmp_buf = {{_sjb = {9713430, 34910627632, 34910627624, 34910628176, 12574088, 1, 8192, 8388608, 34910569343, 0, 0, 1}}} [08:56:38.735] send_ready_for_query = false [08:56:38.735] idle_in_transaction_timeout_enabled = false [08:56:38.735] idle_session_timeout_enabled = false [08:56:38.735] #9 0x000000000093ec09 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:56:38.735] bsdata = [08:56:38.735] #10 0x00000000008964a5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=10, startup_data=startup_data@entry=0x820d5f460 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d5f3b0) at ../src/backend/postmaster/launch_backend.c:274 [08:56:38.735] pid = [08:56:38.735] #11 0x000000000089a84b in BackendStartup (client_sock=0x820d5f3b0) at ../src/backend/postmaster/postmaster.c:3519 [08:56:38.735] startup_data = {canAcceptConnections = CAC_OK} [08:56:38.735] bn = 0x83640c1e8 [08:56:38.735] cac = CAC_OK [08:56:38.735] pid = [08:56:38.735] __error = [08:56:38.735] save_errno = [08:56:38.735] __error = [08:56:38.735] __error = [08:56:38.735] #12 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [08:56:38.735] 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' , "\020\364\325 \b\000\000\000he8,\b\000\000\000\346\000\000\000\000\000\000\000^\3578,\b", '\000' , "P\364\325 \b\000\000\0004b\211\000\000\000\000\000`\364\325 \b", '\000' }, salen = 16}} [08:56:38.735] i = 0 [08:56:38.735] now = [08:56:38.735] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 909845976, events = 8, fd = 550892016, user_data = 0x0}, {pos = 0, events = 0, fd = -868207705, user_data = 0x234df48530a}, {pos = 716924832, events = 8, fd = 716995960, user_data = 0x820d5ee78}, {pos = 550891248, events = 8, fd = 550891128, user_data = 0x234df48530a}, {pos = 716903304, events = 8, fd = 716995960, user_data = 0x820d5eea8}, {pos = 550891296, events = 8, fd = 550891176, user_data = 0x82abc0194}, {pos = 563213320, events = 8, fd = 716964244, user_data = 0x820d5ef10}, {pos = -548928454, events = 564, fd = 718786608, user_data = 0x1}, {pos = 550891328, events = 8, fd = -548908278, user_data = 0x82aba9858}, {pos = 716995960, events = 8, fd = 550891288, user_data = 0x820d5ef90}, {pos = 550891288, events = 8, fd = 716958988, user_data = 0x82191f408}, {pos = 716958988, events = 8, fd = 550891392, user_data = 0x234df48043a}, {pos = 550891432, events = 8, fd = 550891880, user_data = 0x820d5ef90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3879563965, fd = 563236920, user_data = 0x800000001}, {pos = 563213320, events = 8, fd = 716903304, user_data = 0x821924288}, {pos = 716871768, events = 8, fd = 563213320, user_data = 0x820d5f018}, {pos = 550891992, events = 8, fd = 550891520, user_data = 0x234df484ca2}, {pos = 2722414, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 563236920, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550892248, user_data = 0x2191f408}, {pos = 550892064, events = 8, fd = 550891664, user_data = 0x1}, {pos = 550891992, events = 8, fd = 32, user_data = 0x820d5f080}, {pos = -548910477, events = 564, fd = 550891936, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821925038}, {pos = 1, events = 8, fd = 563213320, user_data = 0x82aba9858}, {pos = 550892248, events = 8, fd = 550892064, user_data = 0x820d5f090}, {pos = 0, events = 0, fd = 563183624, user_data = 0x20}, {pos = 550892048, events = 8, fd = -548934937, user_data = 0x821918008}, {pos = 563184648, events = 8, fd = 563185672, user_data = 0x821918c08}, {pos = 563200008, events = 8, fd = 563201032, user_data = 0x82191c808}, {pos = 563203080, events = 8, fd = 563204104, user_data = 0x82191d408}, {pos = 563206152, events = 8, fd = 563207176, user_data = 0x82191e008}, {pos = 563209224, events = 8, fd = 563210248, user_data = 0x82191ec08}, {pos = 563212296, events = 8, fd = 563213320, user_data = 0x82191f808}, {pos = 563215368, events = 8, fd = 563216392, user_data = 0x821920408}, {pos = 563218440, events = 8, fd = 563219464, user_data = 0x821921008}, {pos = 563221512, events = 8, fd = 563222536, user_data = 0x821921c08}, {pos = 563228680, events = 8, fd = 563229704, user_data = 0x821923808}, {pos = 563231752, events = 8, fd = 563183624, user_data = 0x298a6e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821925038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550892248, events = 8, fd = 550891664, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 563236920, user_data = 0x1}, {pos = 563183624, events = 8, fd = 298, user_data = 0x820d5f2c0}, {pos = -548936209, events = 564, fd = 2722414, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 563236920, user_data = 0x1}, {pos = 563213320, events = 8, fd = 909352960, user_data = 0x1}, {pos = 909353364, events = 8, fd = 0, user_data = 0x820d5f290}, {pos = 741926252, events = 8, fd = 1, user_data = 0x83633a000}, {pos = 550892224, events = 8, fd = 741922562, user_data = 0x82acdb170 }, {pos = 12482144, events = 0, fd = 718123376, user_data = 0x82191f408}, {pos = 550892448, events = 8, fd = -548936738, user_data = 0x836358800}, {pos = 1, events = 8, fd = -548937122, user_data = 0x821918008}, {pos = 550892232, events = 8, fd = 550892448, user_data = 0x1ab8}, {pos = 11, events = 0, fd = -548857456, user_data = 0x0}, {pos = 550830975, events = 8, fd = 8136439, user_data = 0x820d5f350}, {pos = 741884944, events = 8, fd = 718786608, user_data = 0x82ad7f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d5f380}, {pos = 741927837, events = 8, fd = 909352960, user_data = 0x1dd6}, {pos = 550892512, events = 8, fd = 741894394, user_data = 0x0}, {pos = 0, events = 0, fd = -868207705, user_data = 0x0}} [08:56:38.735] last_touch_time = 1738313448 [08:56:38.735] last_lockfile_recheck_time = 1738313448 [08:56:38.735] nevents = 1 [08:56:38.735] #13 0x0000000000898c84 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820d5f9d8) at ../src/backend/postmaster/postmaster.c:1386 [08:56:38.735] userDoption = [08:56:38.735] listen_addr_saved = false [08:56:38.735] output_config_variable = [08:56:38.735] opt = [08:56:38.735] status = [08:56:38.735] #14 0x00000000007cf3d0 in main (argc=4, argv=0x820d5f9d8) at ../src/backend/main/main.c:230 [08:56:38.735] do_check_root = [08:56:38.735] dispatch_option = DISPATCH_POSTMASTER [08:56:38.744] [08:56:38.744] [08:56:38.744] [08:56:38.806] dumping /tmp/cores/postgres.13476.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:56:38.935] [New LWP 100097] [08:56:39.019] Core was generated by `postgres: standby: startup waiting for 000000010000000000000005'. [08:56:39.019] Program terminated with signal SIGQUIT, Quit. [08:56:39.019] Sent by thr_kill() from pid 13476 and user 1003. [08:56:39.019] #0 0x000000082d0338fa in _sigprocmask () from /lib/libc.so.7 [08:56:39.043] [08:56:39.043] Thread 1 (LWP 100097): [08:56:39.043] #0 0x000000082d0338fa in _sigprocmask () from /lib/libc.so.7 [08:56:39.043] No symbol table info available. [08:56:39.043] #1 0x000000082d06cf91 in _system () from /lib/libc.so.7 [08:56:39.043] No symbol table info available. [08:56:39.043] #2 0x000000082c0bb9d3 in ?? () from /lib/libthr.so.3 [08:56:39.043] No symbol table info available. [08:56:39.043] #3 0x0000000000669ce5 in RestoreArchivedFile (path=path@entry=0x821ba21d0 "pg_wal/0\244\2047", xlogfname=xlogfname@entry=0x821ba2620 "00000001", '0' , "5", recovername=, expectedSize=16777216, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [08:56:39.043] xlogpath = "pg_wal/RECOVERYXLOG\000RY", '\000' , "0000001", '0' , "\0004\0009\000\000\000\000\000\000\000\000\000\344\000\000\000\000\000\000\020\n\000\000\000\000\000\000\315\0005\b\000\000\000\230\306\3325\b\000\000\000\260\305\3325\b\000\000\000\250\305\3325\b\000\000\000\250\300\3325\b\000\000\000\000\340\344\000\000\000\000\000\000\320\1775\b\000\000\000\213\035\n\000\000\000\000\000 \035\272!\b\000\000\000 \035\272!\b", '\000' , "\350\036\272!\b\000\000\000h\035\272!\b\000\000\000\b\000\000\0000\000\000\000"... [08:56:39.043] lastRestartPointFname = "00000001", '0' , "2\000\241f\000\000\000\000\000pg_wal/00000001", '0' , "2", '\000' , "5*\257\000\000\000\000\000\300\031\272!\b\000\000\0000\000\000\000\000\000\000\000\210 \272!\b", '\000' , "p\031\272!\b\000\000\000\203-\257", '\000' , "5*\257\000\000\000\000\000\210 \272!\b\000\000\000\376\377\377\377\000\000\000\000\002", '\000' ... [08:56:39.043] stat_buf = {st_dev = 34925585872, st_ino = 34925585952, st_nlink = 12396448, st_mode = 1, st_padding0 = 0, st_uid = 0, st_gid = 565846464, st_padding1 = 8, st_rdev = 35114378727, st_atim = {tv_sec = 35256116479, tv_nsec = 12572560}, st_mtim = {tv_sec = 892350512, tv_nsec = 5}, st_ctim = {tv_sec = -72340172838076673, tv_nsec = -9187201950435737472}, st_birthtim = {tv_sec = 206158430224, tv_nsec = 34925585920}, st_size = 34925584944, st_blocks = 11538371, st_blksize = 738918467, st_flags = 8, st_gen = 34959363195, st_spare = {3353916, 35256066048, 4294967292, 9259542123273814144, 34925584688, 0, 11, 35098681840, 206158430240, 34925584848}} [08:56:39.043] restartRedoPtr = 33563712 [08:56:39.043] restartTli = 1 [08:56:39.043] restartSegNo = [08:56:39.043] xlogRestoreCmd = 0x8357e13f8 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/020_archive_status/data/t_020_archive_status_primary_data/archives/00000001", '0' , "5\" \"pg_wal/RECOVERYXLOG\"" [08:56:39.043] rc = [08:56:39.043] #4 0x000000000067536e in XLogFileRead (segno=segno@entry=5, tli=tli@entry=1, source=source@entry=XLOG_FROM_ARCHIVE, notfoundOk=true) at ../src/backend/access/transam/xlogrecovery.c:4211 [08:56:39.043] xlogfname = "00000001", '0' , "5\000&\272!\b\000\000\000p&\272!\b\000\000\000\365\351\002-\b\000\000\00042\000\000\000\000\000\000\354\001\000\000\000\000\000" [08:56:39.043] activitymsg = "waiting for 00000001", '0' , "5\000\000\000\000\240V\016-\b\000\000\000@&\272!\b\000\000\000\257\352\002-\b\000\000\000\005\217\234g\000\000\000\000\200n?\3640\377<\244" [08:56:39.043] path = "pg_wal/0\244\2047\000\000\000\000\000\030\000\000\0000\000\000\000@\"\272!\b\000\000\000 !\272!\b\000\000\000\211\260\254\000\000\000\000\000\360\000\000\000\000\000\000\000d\000\000\000\000\000\000\000\000\240m5\b", '\000' , "\200\273\277\000\000\000\000\000\200ݿ\000\000\000\000\000@&\272!\b\000\000\000\331U\252\000\000\000\000\000\b\260\252\"\b\000\000\000 \000\000\000\000\000\000\000\340#\272!\b\000\000\000纮t\212\"\000\000\b\260\252\"\b\000\000\000\b\264\252\"\b\000\000\000\b\270\252\"\b\000\000\000\b\274\252\"\b\000\000\000\b\360\252\"\b\000\000\000\b\364\252\"\b\000\000\000\b\370\252\"\b\000\000\000\b\374\252"... [08:56:39.043] fd = [08:56:39.043] #5 0x00000000006710ac in XLogFileReadAnyTLI (segno=5, source=XLOG_FROM_ANY) at ../src/backend/access/transam/xlogrecovery.c:4339 [08:56:39.043] hent = [08:56:39.043] tli = 1 [08:56:39.043] cell__state = {l = 0x8357f2fd8, i = 0} [08:56:39.043] path = "pg_wal/00000001", '0' , "5", '\000' , "\001\213ML\263\204E\310?\220\220\r4\b\000\000\0009\000\000\000\000\000\000\000\000\000\n\000\000\000\000\000@\000\b\000\000\000\000\000\240V\016-\b\000\000\000\220'\272!\b\000\000\000\353\354\006-\b", '\000' , "\002\000\000\000\000\000\000\000\002\000\000\000\001\000\000\000\000\000\000\000\230\000\000\000\000\000\000\002\000\000\000\000\005\000\000\000\000\000\000\000\230\000\000\002", '\000' , "\213ML\263\204E\310?\000\200m5\b\000\000\000@\000\b\000\000\000\000\000"... [08:56:39.043] tles = 0x8357f2fd8 [08:56:39.043] cell = [08:56:39.043] fd = [08:56:39.043] cell__state = [08:56:39.043] hent = [08:56:39.043] tli = [08:56:39.043] beginseg = [08:56:39.043] __error = [08:56:39.043] __error = [08:56:39.043] #6 WaitForWALToBecomeAvailable (RecPtr=83886104, tliRecPtr=83886080, replayTLI=1, replayLSN=83886080, randAccess=, fetching_ckpt=, nonblocking=) at ../src/backend/access/transam/xlogrecovery.c:3773 [08:56:39.043] startWalReceiver = [08:56:39.043] streaming_reply_sent = false [08:56:39.043] now = [08:56:39.043] startWalReceiver = [08:56:39.043] oldSource = [08:56:39.043] wait_time = [08:56:39.043] __error = [08:56:39.043] __error = [08:56:39.043] __error = [08:56:39.043] havedata = [08:56:39.043] ptr = [08:56:39.043] tli = [08:56:39.043] __error = [08:56:39.043] latestChunkStart = [08:56:39.043] __error = [08:56:39.043] #7 XLogPageRead (xlogreader=0x8356d9130, targetPagePtr=83886080, reqLen=24, targetRecPtr=83886080, readBuf=0x8357ddab8 "\030\321\002") at ../src/backend/access/transam/xlogrecovery.c:3353 [08:56:39.043] private = 0x8356d9110 [08:56:39.043] emode = 15 [08:56:39.043] targetSegNo = 5 [08:56:39.043] targetPageOff = 0 [08:56:39.043] r = [08:56:39.043] #8 0x0000000000678052 in ReadPageInternal (state=state@entry=0x8356d9130, pageptr=83886080, reqLen=24) at ../src/backend/access/transam/xlogreader.c:1060 [08:56:39.043] targetSegNo = 5 [08:56:39.043] targetPageOff = 0 [08:56:39.043] readLen = [08:56:39.043] hdr = [08:56:39.043] err = [08:56:39.043] #9 0x0000000000676ec2 in XLogDecodeNextRecord (state=0x8356d9130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:597 [08:56:39.043] errormsg = 0xbfc5e8 "" [08:56:39.043] randAccess = [08:56:39.043] decoded = 0x0 [08:56:39.043] RecPtr = 83886080 [08:56:39.043] assembled = false [08:56:39.043] targetPagePtr = 34925582272 [08:56:39.043] readOff = [08:56:39.043] record = [08:56:39.043] gotheader = [08:56:39.043] targetRecOff = 0 [08:56:39.043] pageHeaderSize = [08:56:39.043] len = [08:56:39.043] total_len = [08:56:39.043] buffer = [08:56:39.043] gotlen = [08:56:39.043] pageHeader = [08:56:39.043] contdata = [08:56:39.043] save_copy = [08:56:39.043] #10 XLogReadAhead (state=0x8356d9130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:973 [08:56:39.043] result = [08:56:39.043] #11 0x000000000066e608 in XLogPrefetcherNextBlock (pgsr_private=35257187016, lsn=0x8357f29a8) at ../src/backend/access/transam/xlogprefetcher.c:490 [08:56:39.043] nonblocking = false [08:56:39.043] record = 0x0 [08:56:39.043] prefetcher = 0x8357dfac8 [08:56:39.043] reader = 0x8356d9130 [08:56:39.043] replaying_lsn = 67109152 [08:56:39.043] #12 0x000000000066e272 in lrq_prefetch (lrq=0x8357f28a8) at ../src/backend/access/transam/xlogprefetcher.c:252 [08:56:39.043] No locals. [08:56:39.043] #13 lrq_complete_lsn (lrq=0x8357f28a8, lsn=) at ../src/backend/access/transam/xlogprefetcher.c:290 [08:56:39.043] No locals. [08:56:39.043] #14 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x8357dfac8, errmsg=errmsg@entry=0x821ba6d60) at ../src/backend/access/transam/xlogprefetcher.c:1035 [08:56:39.043] replayed_up_to = [08:56:39.043] record = [08:56:39.043] #15 0x0000000000671daa in ReadRecord (xlogprefetcher=0x8357dfac8, emode=emode@entry=15, fetching_ckpt=false, replayTLI=replayTLI@entry=1) at ../src/backend/access/transam/xlogrecovery.c:3153 [08:56:39.043] errormsg = 0x0 [08:56:39.043] xlogreader = 0x8356d9130 [08:56:39.043] private = [08:56:39.043] record = [08:56:39.043] #16 0x0000000000672689 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1832 [08:56:39.043] ru0 = {tv = {tv_sec = 1738313474, tv_usec = 26568}, ru = {ru_utime = {tv_sec = 0, tv_usec = 0}, ru_stime = {tv_sec = 0, tv_usec = 766}, ru_maxrss = 0, ru_ixrss = 0, ru_idrss = 0, ru_isrss = 0, ru_minflt = 150, ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 0, ru_msgsnd = 0, ru_msgrcv = 0, ru_nsignals = 0, ru_nvcsw = 3, ru_nivcsw = 1}} [08:56:39.043] xtime = [08:56:39.043] reachedRecoveryTarget = false [08:56:39.043] replayTLI = 1 [08:56:39.043] record = [08:56:39.043] #17 0x0000000000663013 in StartupXLOG () at ../src/backend/access/transam/xlog.c:5848 [08:56:39.043] wasShutdown = false [08:56:39.043] haveTblspcMap = false [08:56:39.043] haveBackupLabel = false [08:56:39.043] promoted = false [08:56:39.043] didCrash = [08:56:39.043] checkPoint = {redo = 33554472, ThisTimeLineID = 1, PrevTimeLineID = , fullPageWrites = true, wal_level = , nextXid = {value = }, nextOid = , nextMulti = , nextMultiOffset = , oldestXid = , oldestXidDB = 1, oldestMulti = , oldestMultiDB = , time = , oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 744} [08:56:39.043] oldestActiveXID = [08:56:39.043] performedWalRecovery = [08:56:39.043] endOfRecoveryInfo = [08:56:39.043] EndOfLog = [08:56:39.043] EndOfLogTLI = [08:56:39.043] abortedRecPtr = [08:56:39.043] missingContrecPtr = [08:56:39.043] newTLI = [08:56:39.043] Insert = [08:56:39.043] #18 0x000000000089c10b in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [08:56:39.043] No locals. [08:56:39.043] #19 0x00000000008964a5 in postmaster_child_launch (child_type=child_type@entry=B_STARTUP, child_slot=57, startup_data=startup_data@entry=0x0, startup_data_len=startup_data_len@entry=0, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:274 [08:56:39.043] pid = [08:56:39.043] #20 0x00000000008990a7 in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3905 [08:56:39.043] pmchild = 0x0 [08:56:39.043] pid = [08:56:39.043] #21 0x0000000000898c42 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821babae0) at ../src/backend/postmaster/postmaster.c:1378 [08:56:39.043] userDoption = [08:56:39.043] listen_addr_saved = false [08:56:39.043] output_config_variable = [08:56:39.043] opt = [08:56:39.043] status = [08:56:39.043] #22 0x00000000007cf3d0 in main (argc=4, argv=0x821babae0) at ../src/backend/main/main.c:230 [08:56:39.043] do_check_root = [08:56:39.043] dispatch_option = DISPATCH_POSTMASTER [08:56:39.052] [08:56:39.052] [08:56:39.052] [08:56:39.114] dumping /tmp/cores/postgres.15566.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:56:39.238] [New LWP 100164] [08:56:39.314] Core was generated by `postgres: primary: postgres regression [local] CREATE INDEX'. [08:56:39.314] Program terminated with signal SIGBUS, Bus error. [08:56:39.314] Object-specific hardware error. [08:56:39.314] #0 0x00000000006f962c in DefineIndex (tableId=tableId@entry=19946, stmt=stmt@entry=0x8388c50c0, indexRelationId=19949, indexRelationId@entry=0, parentIndexId=parentIndexId@entry=0, parentConstraintId=parentConstraintId@entry=0, total_parts=total_parts@entry=-1, is_alter_table=, check_rights=, check_not_in_use=, skip_build=, quiet=, verbose=) at ../src/backend/commands/indexcmds.c:1612 [08:56:39.314] 1612 ereport(INFO, [08:56:39.346] [08:56:39.346] Thread 1 (LWP 100164): [08:56:39.346] #0 0x00000000006f962c in DefineIndex (tableId=tableId@entry=19946, stmt=stmt@entry=0x8388c50c0, indexRelationId=19949, indexRelationId@entry=0, parentIndexId=parentIndexId@entry=0, parentConstraintId=parentConstraintId@entry=0, total_parts=total_parts@entry=-1, is_alter_table=, check_rights=, check_not_in_use=, skip_build=, quiet=, verbose=) at ../src/backend/commands/indexcmds.c:1612 [08:56:39.346] __error = [08:56:39.346] createdConstraintId = 0 [08:56:39.346] heaprelid = {relId = 16, dbId = 0} [08:56:39.346] root_save_userid = 10 [08:56:39.346] root_save_sec_context = 0 [08:56:39.346] root_save_nestlevel = 2 [08:56:39.346] ru0 = {tv = {tv_sec = 1738313492, tv_usec = 675236}, ru = {ru_utime = {tv_sec = 0, tv_usec = 340181}, ru_stime = {tv_sec = 0, tv_usec = 45357}, ru_maxrss = 57024, ru_ixrss = 310896, ru_idrss = 17544, ru_isrss = 6528, ru_minflt = 1985, ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 94, ru_msgsnd = 313, ru_msgrcv = 298, ru_nsignals = 0, ru_nvcsw = 143, ru_nivcsw = 865}} [08:56:39.346] concurrent = [08:56:39.346] numberOfKeyAttributes = [08:56:39.346] allIndexParams = [08:56:39.346] numberOfAttributes = [08:56:39.346] lockmode = 5 [08:56:39.346] rel = 0x83e3478a8 [08:56:39.346] namespaceId = [08:56:39.346] exclusion = false [08:56:39.346] tablespaceId = 0 [08:56:39.346] indexColNames = [08:56:39.346] indexRelationName = [08:56:39.346] accessMethodName = 0x8388c51e0 "btree" [08:56:39.346] tuple = [08:56:39.346] accessMethodId = 403 [08:56:39.346] amRoutine = [08:56:39.346] amoptions = [08:56:39.346] reloptions = 0 [08:56:39.346] indexInfo = 0x83882e838 [08:56:39.346] typeIds = [08:56:39.346] collationIds = 0x838823068 [08:56:39.346] opclassIds = 0x838823080 [08:56:39.346] opclassOptions = 0x838823098 [08:56:39.346] coloptions = 0x8388230b0 [08:56:39.346] safe_index = true [08:56:39.346] constr_flags = [08:56:39.346] flags = [08:56:39.346] address = {classId = 1259, objectId = 19949, objectSubId = 0} [08:56:39.346] heaplocktag = [08:56:39.346] snapshot = [08:56:39.346] limitXmin = [08:56:39.346] accessMethodForm = [08:56:39.346] amcanorder = [08:56:39.346] amissummarizing = [08:56:39.346] partitioned = [08:56:39.346] #1 0x000000000094ae65 in ProcessUtilitySlow (pstate=pstate@entry=0x838846500, pstmt=pstmt@entry=0x83876b858, queryString=queryString@entry=0x83876a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x820f4b020) at ../src/backend/tcop/utility.c:1561 [08:56:39.346] stmt = 0x8388c50c0 [08:56:39.346] nparts = -1 [08:56:39.346] lockmode = [08:56:39.346] is_alter_table = [08:56:39.346] verbose = [08:56:39.346] lc = [08:56:39.346] relid = 19946 [08:56:39.346] _local_sigjmp_buf = {{_sjb = {9740506, 35308458176, 34912643720, 34912644096, 34912643728, 12565336, 0, 0, 34912600959, 0, 206158430232, 34359738368}}} [08:56:39.346] _save_exception_stack = 0x820f4ad10 [08:56:39.346] _save_context_stack = 0x0 [08:56:39.346] _do_rethrow = false [08:56:39.346] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [08:56:39.346] parsetree = 0x8388c50c0 [08:56:39.346] commandCollected = false [08:56:39.346] needCleanup = false [08:56:39.346] address = [08:56:39.346] isTopLevel = [08:56:39.346] isCompleteQuery = [08:56:39.346] #2 0x000000000094922b in standard_ProcessUtility (pstmt=0x83876b858, queryString=queryString@entry=0x83876a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8388c5408, qc=0x820f4b020) at ../src/backend/tcop/utility.c:1033 [08:56:39.346] isAtomicContext = false [08:56:39.346] parsetree = 0x8388c50c0 [08:56:39.346] readonly_flags = [08:56:39.346] pstate = 0x838846500 [08:56:39.346] isTopLevel = [08:56:39.346] #3 0x000000083a4b5f70 in pgss_ProcessUtility (pstmt=0x83876b858, queryString=0x83876a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x8388c5408, qc=0x820f4b020) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [08:56:39.346] _local_sigjmp_buf = {{_sjb = {35337756329, 34912644368, 34912644232, 34912644688, 35307042904, 0, 12565336, 34912644896, 34912600959, 8242738, 35308458672, 34359738368}}} [08:56:39.346] _save_exception_stack = 0x820f4af20 [08:56:39.346] _save_context_stack = 0x0 [08:56:39.346] _do_rethrow = false [08:56:39.346] bufusage = {shared_blks_hit = 35337756329, shared_blks_read = 34912644368, shared_blks_dirtied = 34912644232, shared_blks_written = 34912644688, local_blks_hit = 35307042904, local_blks_read = 0, local_blks_dirtied = 12565336, local_blks_written = 34912644896, temp_blks_read = 34912600959, temp_blks_written = 8242738, shared_blk_read_time = {ticks = 35308458672}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 4313232388463995392}, local_blk_write_time = {ticks = 12574264}, temp_blk_read_time = {ticks = 34912644512}, temp_blk_write_time = {ticks = 6645967}} [08:56:39.346] walusage_start = {wal_records = 26014, wal_fpi = 642, wal_bytes = 4275945} [08:56:39.346] duration = [08:56:39.346] bufusage_start = {shared_blks_hit = 119305, shared_blks_read = 6574, shared_blks_dirtied = 1330, shared_blks_written = 1682, local_blks_hit = 13637, local_blks_read = 1, local_blks_dirtied = 133, local_blks_written = 155, 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}} [08:56:39.346] walusage = {wal_records = 2755, wal_fpi = 550704531345, wal_bytes = 3496} [08:56:39.346] start = {ticks = -171244122394} [08:56:39.346] rows = [08:56:39.346] saved_queryId = 8863146406394301129 [08:56:39.346] parsetree = [08:56:39.346] saved_stmt_location = 0 [08:56:39.346] saved_stmt_len = 58 [08:56:39.346] enabled = [08:56:39.346] #4 0x00000000009487f3 in PortalRunUtility (portal=0x83880e100, pstmt=0x83876b858, isTopLevel=, setHoldSnapshot=, dest=0x8388c5408, qc=0x820f4b020) at ../src/backend/tcop/pquery.c:1152 [08:56:39.346] No locals. [08:56:39.346] #5 0x0000000000947ea4 in PortalRunMulti (portal=portal@entry=0x83880e100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x8388c5408, altdest=altdest@entry=0x8388c5408, qc=qc@entry=0x820f4b020) at ../src/backend/tcop/pquery.c:1316 [08:56:39.346] pstmt = 0x83876b858 [08:56:39.346] stmtlist_item__state = {l = 0x8388c53b8, i = 0} [08:56:39.346] active_snapshot_set = false [08:56:39.346] stmtlist_item = 0x8388c53d0 [08:56:39.346] #6 0x000000000094778b in PortalRun (portal=portal@entry=0x83880e100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8388c5408, altdest=altdest@entry=0x8388c5408, qc=qc@entry=0x820f4b020) at ../src/backend/tcop/pquery.c:787 [08:56:39.346] _local_sigjmp_buf = {{_sjb = {9729797, 35307708672, 34912644888, 34912645136, 34912644896, 12565336, 34912645152, 12519768, 12518271, 0, 35307717503, 34359738368}}} [08:56:39.346] _save_exception_stack = 0x820f4b0d0 [08:56:39.346] _save_context_stack = 0x0 [08:56:39.346] _do_rethrow = false [08:56:39.346] saveTopTransactionResourceOwner = 0x838863bd8 [08:56:39.346] saveTopTransactionContext = 0x838812000 [08:56:39.346] saveActivePortal = 0x0 [08:56:39.346] saveResourceOwner = 0x838863bd8 [08:56:39.346] savePortalContext = 0x0 [08:56:39.346] saveMemoryContext = 0x838812000 [08:56:39.346] result = [08:56:39.346] nprocessed = [08:56:39.346] #7 0x0000000000946609 in exec_simple_query (query_string=query_string@entry=0x83876a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);") at ../src/backend/tcop/postgres.c:1271 [08:56:39.346] cmdtaglen = 12 [08:56:39.346] snapshot_set = [08:56:39.346] per_parsetree_context = 0x0 [08:56:39.346] plantree_list = [08:56:39.346] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:56:39.346] format = 0 [08:56:39.346] parsetree = 0x83876b530 [08:56:39.346] commandTag = [08:56:39.346] cmdtagname = [08:56:39.346] querytree_list = [08:56:39.346] portal = 0x83880e100 [08:56:39.346] receiver = 0x8388c5408 [08:56:39.346] parsetree_item__state = {l = 0x83876b808, i = 0} [08:56:39.346] msec_str = "\000\000\000\000\b", '\000' , "\024\217\234g\000\000\000\000\026\0039\006\306", [08:56:39.346] dest = DestRemote [08:56:39.346] was_logged = [08:56:39.346] oldcontext = 0x838812000 [08:56:39.346] parsetree_list = 0x83876b808 [08:56:39.346] use_implicit_block = false [08:56:39.346] parsetree_item = 0x83876b820 [08:56:39.346] save_log_statement_stats = [08:56:39.346] #8 0x0000000000944273 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [08:56:39.346] query_string = 0x83876a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);" [08:56:39.346] input_message = {data = 0x83876a100 "CREATE INDEX (VERBOSE) verbose_test_id ON verbose_test(id);", len = 60, maxlen = 1024, cursor = 60} [08:56:39.346] firstchar = [08:56:39.346] local_sigjmp_buf = {{_sjb = {9713430, 34912645328, 34912645320, 34912645872, 12574088, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [08:56:39.346] send_ready_for_query = false [08:56:39.346] idle_in_transaction_timeout_enabled = false [08:56:39.346] idle_session_timeout_enabled = false [08:56:39.346] #9 0x000000000093ec09 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [08:56:39.346] bsdata = [08:56:39.346] #10 0x00000000008964a5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=21, startup_data=startup_data@entry=0x820f4be00 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820f4bd50) at ../src/backend/postmaster/launch_backend.c:274 [08:56:39.346] pid = [08:56:39.346] #11 0x000000000089a84b in BackendStartup (client_sock=0x820f4bd50) at ../src/backend/postmaster/postmaster.c:3519 [08:56:39.346] startup_data = {canAcceptConnections = CAC_OK} [08:56:39.346] bn = 0x83884f638 [08:56:39.346] cac = CAC_OK [08:56:39.346] pid = [08:56:39.346] __error = [08:56:39.346] save_errno = [08:56:39.346] __error = [08:56:39.346] __error = [08:56:39.346] #12 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [08:56:39.346] 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' , "\260\275\364 \b\000\000\000h\265\324+\b\000\000\000W\000\000\000\000\000\000\000^?\325+\b", '\000' , "\360\275\364 \b\000\000\0004b\211\000\000\000\000\000\000\276\364 \b", '\000' }, salen = 16}} [08:56:39.346] i = 0 [08:56:39.346] now = [08:56:39.346] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 947725784, events = 8, fd = 552909712, user_data = 0x0}, {pos = -2005982454, events = 412, fd = 716490656, user_data = 0x82ab5dd78}, {pos = 552908808, events = 8, fd = 552908928, user_data = 0x820f4b808}, {pos = -2005982454, events = 412, fd = 716469128, user_data = 0x82ab5dd78}, {pos = 552908856, events = 8, fd = 552908976, user_data = 0x820f4b838}, {pos = 716530068, events = 8, fd = 564995080, user_data = 0x82ab56194}, {pos = 552908960, events = 8, fd = -2006002630, user_data = 0x820f4b840}, {pos = 735351824, events = 8, fd = 718352432, user_data = 0x19c886f230a}, {pos = 716437592, events = 8, fd = 716561784, user_data = 0x820f4b8a8}, {pos = 552909088, events = 8, fd = 552908968, user_data = 0x82ab54d0c}, {pos = 564995080, events = 8, fd = 716524812, user_data = 0x820f4b910}, {pos = -2006002630, events = 412, fd = 552909112, user_data = 0x820f4bb08}, {pos = 552909088, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821ad8038}, {pos = 1, events = 927473171, fd = 564995080, user_data = 0x82ab47388}, {pos = 565016520, events = 8, fd = 0, user_data = 0x0}, {pos = 552909224, events = 8, fd = 552909688, user_data = 0x820f4b990}, {pos = -2005984094, events = 412, fd = 2722414, user_data = 0x6d68b}, {pos = 2090263927, events = 927473171, fd = 565018680, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820f4bc78}, {pos = 564995080, events = 3, fd = 552909760, user_data = 0x821ad7828}, {pos = 656, events = 0, fd = 552909688, user_data = 0x820f4b9a8}, {pos = 552909328, events = 8, fd = -2005984485, user_data = 0x820f4bb40}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 565018680, events = 8, fd = 1, user_data = 0x821ad2408}, {pos = 716437592, events = 8, fd = 552909944, user_data = 0x820f4bbc0}, {pos = 552909344, events = 8, fd = 0, user_data = 0x821acb008}, {pos = 33, events = 0, fd = 552909744, user_data = 0x19c886ebae7}, {pos = 564965384, events = 8, fd = 564966408, user_data = 0x821acb808}, {pos = 564968456, events = 8, fd = 564981768, user_data = 0x821acf408}, {pos = 564983816, events = 8, fd = 564984840, user_data = 0x821ad0008}, {pos = 564986888, events = 8, fd = 564987912, user_data = 0x821ad0c08}, {pos = 564989960, events = 8, fd = 564990984, user_data = 0x821ad1808}, {pos = 564993032, events = 8, fd = 564994056, user_data = 0x821ad2408}, {pos = 564996104, events = 8, fd = 564997128, user_data = 0x821ad3008}, {pos = 564999176, events = 8, fd = 565000200, user_data = 0x821ad3c08}, {pos = 565002248, events = 8, fd = 565003272, user_data = 0x821ad4808}, {pos = 565005320, events = 8, fd = 565010440, user_data = 0x821ad6408}, {pos = 565012488, events = 8, fd = 565013512, user_data = 0x821ad9408}, {pos = 234658000, events = 0, fd = 564965384, user_data = 0x298a6e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821ad8038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 552909944, events = 8, fd = 552909344, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 565018680, user_data = 0x1}, {pos = 564965384, events = 8, fd = 298, user_data = 0x820f4bc60}, {pos = -2006010385, events = 412, fd = 2722414, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565018680, user_data = 0x1}, {pos = 564995080, events = 8, fd = 947232768, user_data = 0x1}, {pos = 947233172, events = 8, fd = 0, user_data = 0x820f4bc30}, {pos = 735393132, events = 8, fd = 1, user_data = 0x83875a000}, {pos = 552909920, events = 8, fd = 735389442, user_data = 0x82ac71170 }, {pos = 12482144, events = 0, fd = 717689200, user_data = 0x821ad2408}, {pos = 552910144, events = 8, fd = -2006010914, user_data = 0x838778800}, {pos = 1, events = 8, fd = -2006011298, user_data = 0x821acb008}, {pos = 552909928, events = 8, fd = 552910144, user_data = 0x1ab8}, {pos = 11, events = 0, fd = -2005931632, user_data = 0x0}, {pos = 552862591, events = 8, fd = 8136439, user_data = 0x820f4bcf0}, {pos = 735351824, events = 8, fd = 718352432, user_data = 0x82ad15310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820f4bd20}, {pos = 735394717, events = 8, fd = 947232768, user_data = 0x368b}, {pos = 552910208, events = 8, fd = 735361274, user_data = 0x0}, {pos = 0, events = 0, fd = -1328132088, user_data = 0x0}} [08:56:39.346] last_touch_time = 1738313481 [08:56:39.346] last_lockfile_recheck_time = 1738313481 [08:56:39.346] nevents = 1 [08:56:39.346] #13 0x0000000000898c84 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820f4c378) at ../src/backend/postmaster/postmaster.c:1386 [08:56:39.346] userDoption = [08:56:39.346] listen_addr_saved = false [08:56:39.346] output_config_variable = [08:56:39.346] opt = [08:56:39.346] status = [08:56:39.346] #14 0x00000000007cf3d0 in main (argc=4, argv=0x820f4c378) at ../src/backend/main/main.c:230 [08:56:39.346] do_check_root = [08:56:39.346] dispatch_option = DISPATCH_POSTMASTER