[22:29:31.568] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [22:29:31.882] dumping /tmp/cores/postgres.12543.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:29:32.015] [New LWP 101878] [22:29:32.094] Core was generated by `postgres: postgres regression [local] CREATE TABLE AS'. [22:29:32.094] Program terminated with signal SIGSEGV, Segmentation fault. [22:29:32.094] Address not mapped to object. [22:29:32.094] #0 0x0000000000632d30 in fetch_att (T=0x833f04ffc, attbyval=, attlen=) at ../src/include/access/tupmacs.h:86 [22:29:32.094] 86 return *((const Datum *) T) & fetch_mask[attlen]; [22:29:32.162] [22:29:32.162] Thread 1 (LWP 101878): [22:29:32.162] #0 0x0000000000632d30 in fetch_att (T=0x833f04ffc, attbyval=, attlen=) at ../src/include/access/tupmacs.h:86 [22:29:32.162] No locals. [22:29:32.162] #1 index_getattr (tup=0x833f04ff0, attnum=2, tupleDesc=0x833e52838, isnull=) at ../src/include/access/itup.h:131 [22:29:32.162] attr = 0x833e52860 [22:29:32.162] attr = [22:29:32.162] #2 _bt_mkscankey (rel=rel@entry=0x833e52628, itup=itup@entry=0x833f04ff0) at ../src/backend/access/nbtree/nbtutils.c:138 [22:29:32.162] procinfo = 0x833ea1928 [22:29:32.162] null = false [22:29:32.162] arg = [22:29:32.162] flags = [22:29:32.162] itupdesc = 0x833e52838 [22:29:32.162] indnkeyatts = 2 [22:29:32.162] indoption = 0x833ea16d8 [22:29:32.162] tupnatts = [22:29:32.162] key = 0x8404e99f8 [22:29:32.162] skey = [22:29:32.162] i = 1 [22:29:32.162] #3 0x000000000061cadf in _bt_doinsert (rel=0x833e52838, rel@entry=0x833e52628, itup=itup@entry=0x833f04ff0, checkUnique=3765216, checkUnique@entry=UNIQUE_CHECK_YES, indexUnchanged=false, heapRel=heapRel@entry=0x833e57fc8) at ../src/backend/access/nbtree/nbtinsert.c:113 [22:29:32.162] insertstate = {itup = 0x82160ff90, itemsz = 35231125488, itup_key = 0x2, buf = 16, bounds_valid = false, low = 0, stricthigh = 65424, postingoff = 8} [22:29:32.162] is_unique = false [22:29:32.162] itup_key = [22:29:32.162] checkingunique = [22:29:32.162] stack = [22:29:32.162] #4 0x00000000006297ab in btinsert (rel=0x833e52628, values=, isnull=, ht_ctid=0x833f04754, heapRel=0x833e57fc8, checkUnique=UNIQUE_CHECK_YES, indexUnchanged=, indexInfo=) at ../src/backend/access/nbtree/nbtree.c:195 [22:29:32.162] itup = 0x833f04ff0 [22:29:32.162] result = [22:29:32.162] #5 0x00000000006a332d in CatalogIndexInsert (indstate=indstate@entry=0x833ed8550, heapTuple=heapTuple@entry=0x833f04750, updateIndexes=updateIndexes@entry=TU_All) at ../src/backend/catalog/indexing.c:170 [22:29:32.162] indexInfo = 0x833f04970 [22:29:32.162] index = 0x833e52628 [22:29:32.162] values = {31924, 1, 1642484347906875979, 35195027600, 64, 16384, 35225864576, 0, 34919743264, 35098287635, 1, 72057629267941520, 1642484347906875979, 35195027600, 36, 16384, 18431, 35195028096, 34919743392, 35098074706, 34919743344, 35230471696, 0, 8168, 4294967291, 5, 5, 35231120120, 3928023627, 0, 75923456, 35361390592} [22:29:32.162] isnull = {false, false, false, false, false, false, false, false, 160, 79, 240, 51, 8, false, false, false, 5, false, false, false, false, false, false, false, 51, 28, 173, false, false, false, false, false} [22:29:32.162] heapRelation = 0x833e57fc8 [22:29:32.162] relationDescs = 0x833f03ee8 [22:29:32.162] indexInfoArray = 0x833f044f0 [22:29:32.162] slot = 0x8404e97e8 [22:29:32.162] i = 1 [22:29:32.162] numIndexes = [22:29:32.162] onlySummarized = [22:29:32.162] #6 0x00000000006a35d9 in CatalogTuplesMultiInsertWithInfo (heapRel=heapRel@entry=0x833e57fc8, slot=slot@entry=0x833f03af8, ntuples=ntuples@entry=5, indstate=0x833ed8550) at ../src/backend/catalog/indexing.c:294 [22:29:32.162] should_free = false [22:29:32.162] tuple = 0x833f04750 [22:29:32.162] i = 0 [22:29:32.162] #7 0x000000000069dc60 in InsertPgAttributeTuples (pg_attribute_rel=0x833e57fc8, tupdesc=0x833e490f8, new_rel_oid=31924, tupdesc_extra=0x0, indstate=0x833ed8550) at ../src/backend/catalog/heap.c:790 [22:29:32.162] attrs_extra = 0x0 [22:29:32.162] attrs = [22:29:32.162] natts = 4 [22:29:32.162] slotCount = 5 [22:29:32.162] close_index = false [22:29:32.162] td = [22:29:32.162] nslots = 5 [22:29:32.162] slot = 0x833f03af8 [22:29:32.162] #8 0x0000000000699cae in AddNewAttributeTuples (new_rel_oid=31924, tupdesc=0x833e490f8, relkind=) at ../src/backend/catalog/heap.c:830 [22:29:32.162] myself = {classId = 8, objectId = 11069472, objectSubId = 0} [22:29:32.162] referenced = {classId = 0, objectId = 0, objectSubId = 0} [22:29:32.162] natts = 5 [22:29:32.162] rel = 0x833e57fc8 [22:29:32.162] indstate = 0x833ed8550 [22:29:32.162] i = [22:29:32.162] attr = [22:29:32.162] td = [22:29:32.162] #9 heap_create_with_catalog (relname=relname@entry=0x821610200 "ctv_data", relnamespace=relnamespace@entry=2200, reltablespace=reltablespace@entry=0, relid=31924, relid@entry=0, reltypeid=, reltypeid@entry=0, reloftypeid=reloftypeid@entry=0, ownerid=10, accessmtd=2, tupdesc=0x833f03038, cooked_constraints=0x0, relkind=114 'r', relpersistence=112 'p', shared_relation=, mapped_relation=, oncommit=ONCOMMIT_NOOP, reloptions=0, use_user_acl=, allow_system_table_mods=, is_internal=, relrewrite=0, typaddress=0x0) at ../src/backend/catalog/heap.c:1418 [22:29:32.162] relfrozenxid = 11646 [22:29:32.162] relminmxid = 1 [22:29:32.162] relfilenumber = [22:29:32.162] pg_class_desc = 0x833e561e8 [22:29:32.162] existing_relid = [22:29:32.162] old_type_oid = [22:29:32.162] relacl = 0x0 [22:29:32.162] new_rel_desc = 0x833e5a488 [22:29:32.162] new_type_oid = [22:29:32.162] #10 0x000000000071fa54 in DefineRelation (stmt=stmt@entry=0x833ed8470, relkind=114 'r', ownerId=10, ownerId@entry=0, typaddress=typaddress@entry=0x0, queryString=queryString@entry=0x0) at ../src/backend/commands/tablecmds.c:1015 [22:29:32.162] relname = "ctv_data\000\000\000\000\000\000\000\0008Z\026\"\b\000\000\000\001\000\000\000\000\000\000\000\b\364\025\"\b\000\000\000\002\a\000\000\000\000\000\000\340\002a!\b\000\000\000\3575\322\345\260\027\000" [22:29:32.162] validnsps = {0x37afa0 "toast", 0x0} [22:29:32.162] accessMethodId = 2 [22:29:32.162] namespaceId = 2200 [22:29:32.162] parentLockmode = [22:29:32.162] inheritOids = 0x0 [22:29:32.162] listptr = [22:29:32.162] tablespaceId = 0 [22:29:32.162] reloptions = 0 [22:29:32.162] ofTypeId = 0 [22:29:32.162] old_constraints = 0x0 [22:29:32.162] old_notnulls = 0x0 [22:29:32.162] descriptor = 0x833f03038 [22:29:32.162] rawDefaults = 0x0 [22:29:32.162] cookedDefaults = 0x0 [22:29:32.162] attnum = [22:29:32.162] relationId = [22:29:32.162] rel = [22:29:32.162] nncols = [22:29:32.162] address = [22:29:32.162] partitioned = [22:29:32.162] #11 0x00000000006df016 in create_ctas_internal (attrList=attrList@entry=0x833ed8040, into=into@entry=0x833e05518) at ../src/backend/commands/createas.c:112 [22:29:32.162] validnsps = {0x37afa0 "toast", 0x0} [22:29:32.162] create = 0x833ed8470 [22:29:32.162] is_matview = true [22:29:32.162] intoRelationAddr = [22:29:32.162] toast_options = [22:29:32.162] relkind = [22:29:32.162] #12 0x00000000006ded81 in intorel_startup (self=0x833d35770, operation=, typeinfo=) at ../src/backend/commands/createas.c:526 [22:29:32.162] myState = 0x833d35770 [22:29:32.162] into = 0x833e05518 [22:29:32.162] attrList = [22:29:32.162] lc = 0x0 [22:29:32.162] attnum = [22:29:32.162] intoRelationAddr = [22:29:32.162] intoRelationDesc = [22:29:32.162] is_matview = [22:29:32.162] #13 0x0000000000773762 in standard_ExecutorRun (queryDesc=0x833e7cf10, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:348 [22:29:32.162] estate = 0x833ed7100 [22:29:32.162] oldcontext = 0x833d35400 [22:29:32.162] operation = CMD_SELECT [22:29:32.162] dest = 0x833d35770 [22:29:32.162] sendTuples = true [22:29:32.162] #14 0x00000000006de6ce in ExecCreateTableAs (pstate=pstate@entry=0x833d35500, stmt=stmt@entry=0x833efe3d0, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=qc@entry=0x821610a60) at ../src/backend/commands/createas.c:343 [22:29:32.162] rewritten = [22:29:32.162] plan = 0x833d72948 [22:29:32.162] queryDesc = 0x833e7cf10 [22:29:32.162] query = [22:29:32.162] into = 0x833e05518 [22:29:32.162] jstate = [22:29:32.162] do_refresh = [22:29:32.162] dest = 0x833d35770 [22:29:32.162] address = [22:29:32.162] is_matview = [22:29:32.162] #15 0x0000000000952d6b in ProcessUtilitySlow (pstate=pstate@entry=0x833d35500, pstmt=pstmt@entry=0x833e05918, queryString=queryString@entry=0x833d27100 "CREATE TABLE ctv_data (v, h, c, i, d) AS\nVALUES\n ('v1','h2','foo', 3, '2015-04-01'::date),\n ('v2','h1','bar', 3, '2015-01-02'),\n ('v1','h0','baz', NULL, '2015-07-12'),\n ('v0','h4','qux', 4, '2"..., context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x821610a60) at ../src/backend/tcop/utility.c:1678 [22:29:32.162] _local_sigjmp_buf = {{_sjb = {9774489, 0, 34919745160, 34919745536, 34919745168, 12491112, 0, 35229226240, 34919744383, 11383914, 35231104632, 0}}} [22:29:32.162] _save_exception_stack = 0x821610960 [22:29:32.162] _save_context_stack = 0x0 [22:29:32.162] _do_rethrow = false [22:29:32.162] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:29:32.162] parsetree = 0x833efe3d0 [22:29:32.162] commandCollected = false [22:29:32.162] needCleanup = false [22:29:32.162] address = [22:29:32.162] isTopLevel = [22:29:32.162] isCompleteQuery = [22:29:32.162] #16 0x00000000009516e8 in standard_ProcessUtility (pstmt=0x833e05918, queryString=0x833d27100 "CREATE TABLE ctv_data (v, h, c, i, d) AS\nVALUES\n ('v1','h2','foo', 3, '2015-04-01'::date),\n ('v2','h1','bar', 3, '2015-01-02'),\n ('v1','h0','baz', NULL, '2015-07-12'),\n ('v0','h4','qux', 4, '2"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x833e05488, qc=0x821610a60) at ../src/backend/tcop/utility.c:1033 [22:29:32.162] isAtomicContext = false [22:29:32.162] parsetree = 0x833efe3d0 [22:29:32.162] readonly_flags = [22:29:32.162] pstate = 0x833d35500 [22:29:32.162] isTopLevel = [22:29:32.162] #17 0x0000000000951178 in ProcessUtility (pstmt=0x833e52838, queryString=0x1 , readOnlyTree=, context=871387132, params=0x0, queryEnv=0x0, dest=0x833e05488, qc=0x821610a60) at ../src/backend/tcop/utility.c:523 [22:29:32.162] No locals. [22:29:32.162] #18 0x0000000000950cb3 in PortalRunUtility (portal=0x833dfc100, pstmt=0x833e05918, isTopLevel=, setHoldSnapshot=, dest=0x833e05488, qc=0x821610a60) at ../src/backend/tcop/pquery.c:1152 [22:29:32.162] No locals. [22:29:32.162] #19 0x0000000000950374 in PortalRunMulti (portal=portal@entry=0x833dfc100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x833e05488, altdest=altdest@entry=0x833e05488, qc=qc@entry=0x821610a60) at ../src/backend/tcop/pquery.c:1316 [22:29:32.162] pstmt = 0x833e05918 [22:29:32.162] stmtlist_item__state = {l = 0x833efff00, i = 0} [22:29:32.162] active_snapshot_set = false [22:29:32.162] stmtlist_item = 0x833efff18 [22:29:32.162] #20 0x000000000094fc5b in PortalRun (portal=portal@entry=0x833dfc100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x833e05488, altdest=altdest@entry=0x833e05488, qc=qc@entry=0x821610a60) at ../src/backend/tcop/pquery.c:787 [22:29:32.162] _local_sigjmp_buf = {{_sjb = {9763797, 35230040320, 34919745880, 34919746128, 34919745888, 12491112, 34919746144, 12447480, 12387199, 0, 35229991807, 34359738368}}} [22:29:32.162] _save_exception_stack = 0x821610b10 [22:29:32.162] _save_context_stack = 0x0 [22:29:32.162] _do_rethrow = false [22:29:32.162] saveTopTransactionResourceOwner = 0x833e0b808 [22:29:32.162] saveTopTransactionContext = 0x833e00000 [22:29:32.162] saveActivePortal = 0x0 [22:29:32.162] saveResourceOwner = 0x833e0b808 [22:29:32.162] savePortalContext = 0x0 [22:29:32.162] saveMemoryContext = 0x833e00000 [22:29:32.162] result = [22:29:32.162] nprocessed = [22:29:32.162] #21 0x000000000094eae9 in exec_simple_query (query_string=query_string@entry=0x833d27100 "CREATE TABLE ctv_data (v, h, c, i, d) AS\nVALUES\n ('v1','h2','foo', 3, '2015-04-01'::date),\n ('v2','h1','bar', 3, '2015-01-02'),\n ('v1','h0','baz', NULL, '2015-07-12'),\n ('v0','h4','qux', 4, '2"...) at ../src/backend/tcop/postgres.c:1271 [22:29:32.162] cmdtaglen = 15 [22:29:32.162] snapshot_set = [22:29:32.162] per_parsetree_context = 0x0 [22:29:32.162] plantree_list = [22:29:32.162] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:29:32.162] format = 0 [22:29:32.162] parsetree = 0x833d93fd0 [22:29:32.162] commandTag = [22:29:32.162] cmdtagname = [22:29:32.162] querytree_list = [22:29:32.162] portal = 0x833dfc100 [22:29:32.162] receiver = 0x833e05488 [22:29:32.162] parsetree_item__state = {l = 0x833e04b88, i = 0} [22:29:32.162] msec_str = "\000\000\000\000\b", '\000' , "\2075\210g\000\000\000\000\035\275\214\003D\257[\250" [22:29:32.162] dest = DestRemote [22:29:32.162] was_logged = [22:29:32.162] oldcontext = 0x833e00000 [22:29:32.162] parsetree_list = 0x833e04b88 [22:29:32.162] use_implicit_block = false [22:29:32.162] parsetree_item = 0x833e04ba0 [22:29:32.162] save_log_statement_stats = [22:29:32.162] #22 0x000000000094c753 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [22:29:32.162] query_string = 0x833d27100 "CREATE TABLE ctv_data (v, h, c, i, d) AS\nVALUES\n ('v1','h2','foo', 3, '2015-04-01'::date),\n ('v2','h1','bar', 3, '2015-01-02'),\n ('v1','h0','baz', NULL, '2015-07-12'),\n ('v0','h4','qux', 4, '2"... [22:29:32.162] input_message = {data = 0x833d27100 "CREATE TABLE ctv_data (v, h, c, i, d) AS\nVALUES\n ('v1','h2','foo', 3, '2015-04-01'::date),\n ('v2','h1','bar', 3, '2015-01-02'),\n ('v1','h0','baz', NULL, '2015-07-12'),\n ('v0','h4','qux', 4, '2"..., len = 331, maxlen = 1024, cursor = 331} [22:29:32.162] firstchar = [22:29:32.162] local_sigjmp_buf = {{_sjb = {9747462, 34919746320, 34919746312, 34919746864, 12499864, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [22:29:32.162] send_ready_for_query = false [22:29:32.162] idle_in_transaction_timeout_enabled = false [22:29:32.162] idle_session_timeout_enabled = false [22:29:32.162] #23 0x00000000009470f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:29:32.162] bsdata = [22:29:32.162] #24 0x000000000089e6c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x821611840 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821611790) at ../src/backend/postmaster/launch_backend.c:274 [22:29:32.162] pid = [22:29:32.162] #25 0x00000000008a2c16 in BackendStartup (client_sock=0x821611790) at ../src/backend/postmaster/postmaster.c:3466 [22:29:32.162] startup_data = {canAcceptConnections = CAC_OK} [22:29:32.162] bn = 0x833dc83c8 [22:29:32.162] cac = CAC_OK [22:29:32.162] pid = [22:29:32.162] __error = [22:29:32.162] save_errno = [22:29:32.162] __error = [22:29:32.162] __error = [22:29:32.162] #26 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:29:32.162] 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' , "\360\027a!\b\000\000\000h% *\b\000\000\000\372\000\000\000\000\000\000\000^\257 *\b", '\000' , "0\030a!\b\000\000\000T\344\211\000\000\000\000\000@\030a!\b", '\000' }, salen = 16}} [22:29:32.162] i = 0 [22:29:32.162] now = [22:29:32.162] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 869799384, events = 8, fd = 560010704, user_data = 0x821611330}, {pos = 8192, events = 0, fd = 8192, user_data = 0x833df4000}, {pos = 560010040, events = 8, fd = 0, user_data = 0x831c98090}, {pos = 1, events = 0, fd = 560009840, user_data = 0x82c0549c9}, {pos = 736859016, events = 8, fd = 736951672, user_data = 0x821611288}, {pos = 560009984, events = 8, fd = 560010032, user_data = 0x821611328}, {pos = 835289232, events = 8, fd = 866126208, user_data = 0x20}, {pos = 4096, events = 0, fd = 560010480, user_data = 0x82c04fa7c}, {pos = 560010024, events = 8, fd = -439180534, user_data = 0x82beb1858}, {pos = 736951672, events = 8, fd = 560009976, user_data = 0x821611370}, {pos = 560009976, events = 8, fd = 736914700, user_data = 0x82215f408}, {pos = 736914700, events = 8, fd = 560010080, user_data = 0x17b0e5d2543a}, {pos = 835289280, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 866136632, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x822164288}, {pos = 736827480, events = 8, fd = 571864072, user_data = 0x8216113f8}, {pos = 560010680, events = 8, fd = 560010208, user_data = 0x17b0e5d29ca2}, {pos = 2721378, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 571887672, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 560010936, user_data = 0x2215f408}, {pos = 560010752, events = 8, fd = 560010352, user_data = 0x1}, {pos = 560010680, events = 8, fd = 32, user_data = 0x821611460}, {pos = -439182733, events = 6064, fd = 560010624, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x822165038}, {pos = 1, events = 8, fd = 571864072, user_data = 0x82beb1858}, {pos = 560010936, events = 8, fd = 560010752, user_data = 0x821611470}, {pos = 0, events = 0, fd = 571834376, user_data = 0x20}, {pos = 560010736, events = 8, fd = -439207193, user_data = 0x822158008}, {pos = 571835400, events = 8, fd = 571836424, user_data = 0x822158c08}, {pos = 571850760, events = 8, fd = 571851784, user_data = 0x82215c808}, {pos = 571853832, events = 8, fd = 571854856, user_data = 0x82215d408}, {pos = 571856904, events = 8, fd = 571857928, user_data = 0x82215e008}, {pos = 571859976, events = 8, fd = 571861000, user_data = 0x82215ec08}, {pos = 571863048, events = 8, fd = 571864072, user_data = 0x82215f808}, {pos = 571866120, events = 8, fd = 571867144, user_data = 0x822160408}, {pos = 571869192, events = 8, fd = 571870216, user_data = 0x822161008}, {pos = 571872264, events = 8, fd = 571873288, user_data = 0x822161c08}, {pos = 571879432, events = 8, fd = 571880456, user_data = 0x822163808}, {pos = 571882504, events = 8, fd = 571834376, user_data = 0x298662}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822165038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 560010936, events = 8, fd = 560010352, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 571887672, user_data = 0x1}, {pos = 571834376, events = 8, fd = 298, user_data = 0x8216116a0}, {pos = -439208465, events = 6064, fd = 2721378, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 571887672, user_data = 0x1}, {pos = 571864072, events = 8, fd = 869363712, user_data = 0x1}, {pos = 869364116, events = 8, fd = 0, user_data = 0x821611670}, {pos = 706782572, events = 8, fd = 1, user_data = 0x833d17000}, {pos = 560010912, events = 8, fd = 706778882, user_data = 0x82bfe3170 }, {pos = 12410032, events = 0, fd = 738079088, user_data = 0x82215f408}, {pos = 560011136, events = 8, fd = -439208994, user_data = 0x833d35800}, {pos = 1, events = 0, fd = -439209378, user_data = 0x822158008}, {pos = 560010920, events = 8, fd = 560011136, user_data = 0x1ab8}, {pos = 11, events = 0, fd = -439129712, user_data = 0x0}, {pos = 560006015, events = 8, fd = 8172999, user_data = 0x821611730}, {pos = 706741264, events = 8, fd = 738742320, user_data = 0x82c087310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821611760}, {pos = 706784157, events = 8, fd = 869363712, user_data = 0x1d2b}, {pos = 560011200, events = 8, fd = 706750714, user_data = 0x0}, {pos = 0, events = 0, fd = -366943669, user_data = 0x0}} [22:29:32.162] last_touch_time = 1736979816 [22:29:32.162] last_lockfile_recheck_time = 1736979816 [22:29:32.162] nevents = 1 [22:29:32.162] #27 0x00000000008a0ea4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821611db8) at ../src/backend/postmaster/postmaster.c:1377 [22:29:32.162] userDoption = [22:29:32.162] listen_addr_saved = false [22:29:32.162] output_config_variable = [22:29:32.162] opt = [22:29:32.162] status = [22:29:32.162] #28 0x00000000007d82a0 in main (argc=8, argv=0x821611db8) at ../src/backend/main/main.c:230 [22:29:32.162] do_check_root = [22:29:32.162] dispatch_option = DISPATCH_POSTMASTER [22:29:32.171] [22:29:32.171] [22:29:32.171] [22:29:32.231] dumping /tmp/cores/postgres.13737.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:29:32.354] [New LWP 101912] [22:29:32.434] Core was generated by `postgres: cascade: startup recovering 000000020000000000000004'. [22:29:32.434] Program terminated with signal SIGQUIT, Quit. [22:29:32.434] Sent by thr_kill() from pid 13737 and user 1003. [22:29:32.434] #0 0x000000082bd288fa in _sigprocmask () from /lib/libc.so.7 [22:29:32.457] [22:29:32.457] Thread 1 (LWP 101912): [22:29:32.457] #0 0x000000082bd288fa in _sigprocmask () from /lib/libc.so.7 [22:29:32.457] No symbol table info available. [22:29:32.457] #1 0x000000082bd61f91 in _system () from /lib/libc.so.7 [22:29:32.457] No symbol table info available. [22:29:32.457] #2 0x000000082ab829d3 in ?? () from /lib/libthr.so.3 [22:29:32.457] No symbol table info available. [22:29:32.457] #3 0x00000000006734f5 in RestoreArchivedFile (path=path@entry=0x82117b1d0 "pg_wal/00000002", '0' , "4", xlogfname=xlogfname@entry=0x82117b5d0 "00000003.history", recovername=, expectedSize=expectedSize@entry=0, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [22:29:32.457] xlogpath = "pg_wal/RECOVERYHISTORY", '\000' , "\200\t\3005\b\000\000\000\210\266\027!\b\000\000\0009\000\000\000\000\000\000\000\000\000\344\000\000\000\000\000\000\020\n\000\000\000\000\000\200\315\3005\b\000\000\000\310o\2737\b\000\000\000\350n\2737\b\000\000\000\340n\2737\b\000\000\000\340i\2737\b\000\000\000\000\340\344\000\000\000\000\000\000@\3226\b\000\000\000\000\020\n\000\000\000\000\000 \255\027!\b\000\000\000 \255\027!\b", '\000' , "\350\256\027!\b\000\000\000h\255\027!\b\000\000\000\b\000\000\0000\000\000\000"... [22:29:32.457] lastRestartPointFname = '0' , "\000\000\000\000\000\000\000\000\030\000\000\0000\000\000\000\260\254\027!\b\000\000\000`\252\027!\b", '\000' , "\240\246\335+\b", '\000' , "U\232\257\000\000\000\000\000\300\251\027!\b\000\000\0000\000\000\000\000\000\000\000\210\260\027!\b", '\000' , "p\251\027!\b\000\000\000\243\235\257", '\000' , "U\232\257\000\000\000\000\000\210\260\027!\b\000\000\000\376\377\377\377\000\000\000\000\002", '\000' ... [22:29:32.457] stat_buf = {st_dev = 98304, st_ino = 2, st_nlink = 34914939328, st_mode = 38115, st_padding0 = 175, st_uid = 0, st_gid = 555200960, st_padding1 = 8, st_rdev = 35094410727, st_atim = {tv_sec = 14539, tv_nsec = 3}, st_mtim = {tv_sec = 35331149956, tv_nsec = 28560}, st_ctim = {tv_sec = -72340172838076673, tv_nsec = -9187201950435737472}, st_birthtim = {tv_sec = -6926398477426208512, tv_nsec = 34914939312}, st_size = 6, st_blocks = 0, st_blksize = 78, st_flags = 0, st_gen = 35095684768, st_spare = {34914939248, 35094936239, 1736979854, 16778392990643526207, 11520345596283343104, 2, 0, 34914939312, 206158430240, 34914939344}} [22:29:32.457] restartRedoPtr = 34914939072 [22:29:32.457] restartTli = 8 [22:29:32.457] restartSegNo = [22:29:32.457] xlogRestoreCmd = 0x836ced6b8 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/data/t_025_stuck_on_old_timeline_primary_data/archives/00000003.history\" \"pg_wal/RECOVERYHISTORY\"" [22:29:32.457] rc = [22:29:32.457] #4 0x000000000065a718 in existsTimeLineHistory (probeTLI=probeTLI@entry=3) at ../src/backend/access/transam/timeline.c:235 [22:29:32.457] path = "pg_wal/00000002", '0' , "4", '\000' , "8p\321!\b\000\000\000\001\000\000\000\000\000\000\000\b\024\321!\b\000\000\0008\262\277+\b\000\000\000\250\264\027!\b\000\000\000\360\263\027!\b\000\000\000`\262\027!\b", '\000' , "\b\240\320!\b\000\000\000 \000\000\000\000\000\000\000\340\263\027!\b\000\000\000\347\372\002\204\323\a\000\000\b\240\320!\b\000\000\000\b\244\320!\b\000\000\000\b\250\320!\b\000\000\000\b\254\320!\b\000\000\000\b\340\320!\b\000\000\000\b\344\320!\b\000\000\000\b\350\320!\b\000\000\000"... [22:29:32.457] histfname = "00000003.history\000\266\027!\b\000\000\000\337ܑ\000\000\000\000\000\377\377\377\377\377\377\377\377\000\000\000\000\000\000\000\000\000Q4LH}\340\237\000\000\000\000\000\000\000" [22:29:32.457] fd = [22:29:32.457] #5 0x000000000065a7d8 in findNewestTimeLine (startTLI=startTLI@entry=2) at ../src/backend/access/transam/timeline.c:277 [22:29:32.457] newestTLI = 2 [22:29:32.457] probeTLI = 3 [22:29:32.457] #6 0x000000000067e90b in rescanLatestTimeLine (replayTLI=replayTLI@entry=2, replayLSN=replayLSN@entry=67210792) at ../src/backend/access/transam/xlogrecovery.c:4114 [22:29:32.457] oldtarget = 2 [22:29:32.457] currentTle = 0x0 [22:29:32.457] newtarget = [22:29:32.457] newExpectedTLEs = [22:29:32.457] found = [22:29:32.457] cell = [22:29:32.457] #7 0x000000000067ab63 in WaitForWALToBecomeAvailable (RecPtr=67210816, tliRecPtr=67210792, replayTLI=2, replayLSN=67210792, randAccess=, fetching_ckpt=, nonblocking=) at ../src/backend/access/transam/xlogrecovery.c:3676 [22:29:32.457] startWalReceiver = false [22:29:32.457] streaming_reply_sent = true [22:29:32.457] now = [22:29:32.457] startWalReceiver = [22:29:32.457] oldSource = [22:29:32.457] wait_time = [22:29:32.457] __error = [22:29:32.457] __error = [22:29:32.457] __error = [22:29:32.457] havedata = [22:29:32.457] ptr = [22:29:32.457] tli = [22:29:32.457] __error = [22:29:32.457] latestChunkStart = [22:29:32.457] __error = [22:29:32.457] #8 XLogPageRead (xlogreader=0x836bff130, targetPagePtr=67207168, reqLen=3648, targetRecPtr=67210792, readBuf=0x836ce9d78 "\030\321\006") at ../src/backend/access/transam/xlogrecovery.c:3353 [22:29:32.457] private = 0x836bff110 [22:29:32.457] emode = 15 [22:29:32.457] targetSegNo = 4 [22:29:32.457] targetPageOff = 98304 [22:29:32.457] r = [22:29:32.457] #9 0x0000000000681852 in ReadPageInternal (state=state@entry=0x836bff130, pageptr=67207168, reqLen=3648) at ../src/backend/access/transam/xlogreader.c:1060 [22:29:32.457] targetSegNo = 4 [22:29:32.457] targetPageOff = 98304 [22:29:32.457] readLen = [22:29:32.457] hdr = [22:29:32.457] err = [22:29:32.457] #10 0x00000000006806c2 in XLogDecodeNextRecord (state=0x836bff130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:597 [22:29:32.457] errormsg = 0x82117fc98 "" [22:29:32.457] randAccess = [22:29:32.457] decoded = 0x0 [22:29:32.457] RecPtr = 67210792 [22:29:32.457] assembled = false [22:29:32.457] targetPagePtr = 34914936768 [22:29:32.457] readOff = [22:29:32.457] record = [22:29:32.457] gotheader = [22:29:32.457] targetRecOff = 3624 [22:29:32.457] pageHeaderSize = [22:29:32.457] len = [22:29:32.457] total_len = [22:29:32.457] buffer = [22:29:32.457] gotlen = [22:29:32.457] pageHeader = [22:29:32.457] contdata = [22:29:32.457] save_copy = [22:29:32.457] #11 XLogReadAhead (state=0x836bff130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:973 [22:29:32.457] result = [22:29:32.457] #12 0x0000000000677e18 in XLogPrefetcherNextBlock (pgsr_private=35279256968, lsn=0x836d19f48) at ../src/backend/access/transam/xlogprefetcher.c:490 [22:29:32.457] nonblocking = false [22:29:32.457] record = 0x0 [22:29:32.457] prefetcher = 0x836cebd88 [22:29:32.457] reader = 0x836bff130 [22:29:32.457] replaying_lsn = 67210384 [22:29:32.457] #13 0x0000000000677a82 in lrq_prefetch (lrq=0x836d19ca8) at ../src/backend/access/transam/xlogprefetcher.c:252 [22:29:32.457] No locals. [22:29:32.457] #14 lrq_complete_lsn (lrq=0x836d19ca8, lsn=) at ../src/backend/access/transam/xlogprefetcher.c:290 [22:29:32.457] No locals. [22:29:32.457] #15 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x836cebd88, errmsg=errmsg@entry=0x82117fd60) at ../src/backend/access/transam/xlogprefetcher.c:1035 [22:29:32.457] replayed_up_to = [22:29:32.457] record = [22:29:32.457] #16 0x000000000067b5aa in ReadRecord (xlogprefetcher=0x836cebd88, emode=emode@entry=15, fetching_ckpt=false, replayTLI=replayTLI@entry=2) at ../src/backend/access/transam/xlogrecovery.c:3153 [22:29:32.457] errormsg = 0x836bff940 "" [22:29:32.457] xlogreader = 0x836bff130 [22:29:32.457] private = [22:29:32.457] record = [22:29:32.457] #17 0x000000000067be89 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1832 [22:29:32.457] ru0 = {tv = {tv_sec = 1736979854, tv_usec = 253716}, ru = {ru_utime = {tv_sec = 0, tv_usec = 0}, ru_stime = {tv_sec = 0, tv_usec = 1146}, ru_maxrss = 0, ru_ixrss = 0, ru_idrss = 0, ru_isrss = 0, ru_minflt = 148, ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 0, ru_msgsnd = 0, ru_msgrcv = 0, ru_nsignals = 0, ru_nvcsw = 12, ru_nivcsw = 2}} [22:29:32.457] xtime = [22:29:32.457] reachedRecoveryTarget = false [22:29:32.457] replayTLI = 2 [22:29:32.457] record = [22:29:32.457] #18 0x000000000066c823 in StartupXLOG () at ../src/backend/access/transam/xlog.c:5848 [22:29:32.458] wasShutdown = false [22:29:32.458] haveTblspcMap = false [22:29:32.458] haveBackupLabel = true [22:29:32.458] promoted = false [22:29:32.458] didCrash = [22:29:32.458] 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 = 743} [22:29:32.458] oldestActiveXID = [22:29:32.458] performedWalRecovery = [22:29:32.458] endOfRecoveryInfo = [22:29:32.458] EndOfLog = [22:29:32.458] EndOfLogTLI = [22:29:32.458] abortedRecPtr = [22:29:32.458] missingContrecPtr = [22:29:32.458] newTLI = [22:29:32.458] Insert = [22:29:32.458] #19 0x00000000008a481b in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [22:29:32.458] No locals. [22:29:32.458] #20 0x000000000089e6c5 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 [22:29:32.458] pid = [22:29:32.458] #21 0x00000000008a12c7 in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3791 [22:29:32.458] pmchild = 0x0 [22:29:32.458] pid = [22:29:32.458] #22 0x00000000008a0e62 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821184710) at ../src/backend/postmaster/postmaster.c:1369 [22:29:32.458] userDoption = [22:29:32.458] listen_addr_saved = false [22:29:32.458] output_config_variable = [22:29:32.458] opt = [22:29:32.458] status = [22:29:32.458] #23 0x00000000007d82a0 in main (argc=4, argv=0x821184710) at ../src/backend/main/main.c:230 [22:29:32.458] do_check_root = [22:29:32.458] dispatch_option = DISPATCH_POSTMASTER [22:29:32.467] [22:29:32.467] [22:29:32.467] [22:29:32.524] dumping /tmp/cores/postgres.15827.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:29:32.645] [New LWP 101848] [22:29:32.711] Core was generated by `postgres: primary: postgres regression [local] CREATE TABLE'. [22:29:32.711] Program terminated with signal SIGSEGV, Segmentation fault. [22:29:32.711] Address not mapped to object. [22:29:32.711] #0 0x0000000000632d30 in fetch_att (T=0x837af8ffc, attbyval=, attlen=) at ../src/include/access/tupmacs.h:86 [22:29:32.711] 86 return *((const Datum *) T) & fetch_mask[attlen]; [22:29:32.762] [22:29:32.762] Thread 1 (LWP 101848): [22:29:32.762] #0 0x0000000000632d30 in fetch_att (T=0x837af8ffc, attbyval=, attlen=) at ../src/include/access/tupmacs.h:86 [22:29:32.762] No locals. [22:29:32.762] #1 index_getattr (tup=0x837af8ff0, attnum=2, tupleDesc=0x837a58538, isnull=) at ../src/include/access/itup.h:131 [22:29:32.762] attr = 0x837a58560 [22:29:32.762] attr = [22:29:32.762] #2 _bt_mkscankey (rel=rel@entry=0x837a58328, itup=itup@entry=0x837af8ff0) at ../src/backend/access/nbtree/nbtutils.c:138 [22:29:32.762] procinfo = 0x837a11928 [22:29:32.762] null = false [22:29:32.762] arg = [22:29:32.762] flags = [22:29:32.762] itupdesc = 0x837a58538 [22:29:32.762] indnkeyatts = 2 [22:29:32.762] indoption = 0x837a116d8 [22:29:32.762] tupnatts = [22:29:32.762] key = 0x83d71b468 [22:29:32.762] skey = [22:29:32.762] i = 1 [22:29:32.762] #3 0x000000000061cadf in _bt_doinsert (rel=0x837a58538, rel@entry=0x837a58328, itup=itup@entry=0x837af8ff0, checkUnique=3765216, checkUnique@entry=UNIQUE_CHECK_YES, indexUnchanged=false, heapRel=heapRel@entry=0x837a5dcc8) at ../src/backend/access/nbtree/nbtinsert.c:113 [22:29:32.762] insertstate = {itup = 0x8212144a0, itemsz = 35293990896, itup_key = 0x2, buf = 16, bounds_valid = false, low = 0, stricthigh = 17568, postingoff = 8} [22:29:32.762] is_unique = false [22:29:32.762] itup_key = [22:29:32.762] checkingunique = [22:29:32.762] stack = [22:29:32.762] #4 0x00000000006297ab in btinsert (rel=0x837a58328, values=, isnull=, ht_ctid=0x837af8e04, heapRel=0x837a5dcc8, checkUnique=UNIQUE_CHECK_YES, indexUnchanged=, indexInfo=) at ../src/backend/access/nbtree/nbtree.c:195 [22:29:32.762] itup = 0x837af8ff0 [22:29:32.762] result = [22:29:32.762] #5 0x00000000006a332d in CatalogIndexInsert (indstate=indstate@entry=0x837af82c0, heapTuple=heapTuple@entry=0x837af8e00, updateIndexes=updateIndexes@entry=TU_All) at ../src/backend/catalog/indexing.c:170 [22:29:32.762] indexInfo = 0x837af76f0 [22:29:32.762] index = 0x837a58328 [22:29:32.762] values = {20453, 65535, 4080218931200, 10232288, 281483566645394, 9636354, 0, 35292091392, 0, 11245513, 35292672256, 6393545, 2, 35292678112, 11201274724352, 0, 35292672256, 35363035272, 8589934592, 0, 1999466950287163392, 35292672400, 0, 8168, 4294967290, 6, 6, 35292434320, 555828400, 0, 442368, 35360350208} [22:29:32.762] isnull = {false, false, false, false, false, false, false, false, 160, 143, 175, 55, 8, false, false, false, 6, false, false, false, false, false, false, false, 136, 28, 147, false, false, false, false, false} [22:29:32.762] heapRelation = 0x837a5dcc8 [22:29:32.762] relationDescs = 0x837af8930 [22:29:32.762] indexInfoArray = 0x837af8a90 [22:29:32.762] slot = 0x83d71b258 [22:29:32.762] i = 1 [22:29:32.762] numIndexes = [22:29:32.762] onlySummarized = [22:29:32.762] #6 0x00000000006a35d9 in CatalogTuplesMultiInsertWithInfo (heapRel=heapRel@entry=0x837a5dcc8, slot=slot@entry=0x83797cf90, ntuples=ntuples@entry=6, indstate=0x837af82c0) at ../src/backend/catalog/indexing.c:294 [22:29:32.762] should_free = false [22:29:32.762] tuple = 0x837af8e00 [22:29:32.762] i = 0 [22:29:32.762] #7 0x000000000069dc60 in InsertPgAttributeTuples (pg_attribute_rel=0x837a5dcc8, tupdesc=0x83797c038, new_rel_oid=20453, tupdesc_extra=0x0, indstate=0x837af82c0) at ../src/backend/catalog/heap.c:790 [22:29:32.762] attrs_extra = 0x0 [22:29:32.762] attrs = [22:29:32.762] natts = 5 [22:29:32.762] slotCount = 6 [22:29:32.762] close_index = false [22:29:32.762] td = [22:29:32.762] nslots = 6 [22:29:32.762] slot = 0x83797cf90 [22:29:32.762] #8 0x0000000000699d8c in AddNewAttributeTuples (new_rel_oid=20453, tupdesc=0x83d6dc210, relkind=) at ../src/backend/catalog/heap.c:863 [22:29:32.762] td = 0x83797c038 [22:29:32.762] myself = {classId = 1259, objectId = 20453, objectSubId = 3} [22:29:32.762] referenced = {classId = 1247, objectId = 17, objectSubId = 0} [22:29:32.762] natts = [22:29:32.762] rel = 0x837a5dcc8 [22:29:32.762] indstate = 0x837af82c0 [22:29:32.762] i = [22:29:32.762] attr = [22:29:32.762] td = [22:29:32.762] #9 heap_create_with_catalog (relname=relname@entry=0x821214710 "pg_toast_20441", relnamespace=relnamespace@entry=99, reltablespace=, relid=20453, relid@entry=0, reltypeid=reltypeid@entry=0, reloftypeid=reloftypeid@entry=0, ownerid=10, accessmtd=2, tupdesc=0x837ab2838, cooked_constraints=0x0, relkind=116 't', relpersistence=112 'p', shared_relation=, mapped_relation=, oncommit=ONCOMMIT_NOOP, reloptions=0, use_user_acl=, allow_system_table_mods=, is_internal=, relrewrite=0, typaddress=0x0) at ../src/backend/catalog/heap.c:1418 [22:29:32.762] relfrozenxid = 3894 [22:29:32.762] relminmxid = 1 [22:29:32.762] relfilenumber = [22:29:32.762] pg_class_desc = 0x837a5bee8 [22:29:32.762] existing_relid = [22:29:32.762] old_type_oid = [22:29:32.762] relacl = 0x0 [22:29:32.762] new_rel_desc = 0x837a6e390 [22:29:32.762] new_type_oid = [22:29:32.762] #10 0x00000000006c69f5 in create_toast_table (rel=0x837a60188, toastOid=toastOid@entry=0, toastIndexOid=toastIndexOid@entry=0, reloptions=reloptions@entry=0, lockmode=lockmode@entry=8, check=, OIDOldToast=0) at ../src/backend/catalog/toasting.c:247 [22:29:32.762] reltup = 0x5bc378 [22:29:32.762] toast_relname = "pg_toast_20441\000\000\220H!!\b\000\000\000$'\210\000\000\000\000\000\000\221\2477\b\000\000\000\240H!!\b", '\000' , "ɗ\253\000\000\000\000" [22:29:32.762] toast_idxname = "pg_toast_20441_index\000\000\000\000\374G!!\b\000\000\000\000\225\2227\b", '\000' , "\261\2337\b\000\000\0009\330B\031\000\000\000" [22:29:32.762] collationIds = {555829264, 8} [22:29:32.762] opclassIds = {11118321, 0} [22:29:32.762] coloptions = {-30048, 14235} [22:29:32.762] baseobject = {classId = 0, objectId = 0, objectSubId = 0} [22:29:32.762] toastobject = {classId = 20441, objectId = 0, objectSubId = 1259} [22:29:32.762] relOid = 20441 [22:29:32.762] tupdesc = 0x837ab2838 [22:29:32.762] namespaceid = 99 [22:29:32.762] mapped_relation = [22:29:32.762] toast_relid = [22:29:32.762] toast_rel = [22:29:32.762] indexInfo = [22:29:32.762] class_rel = [22:29:32.762] shared_relation = [22:29:32.762] #11 0x00000000006c66ba in CheckAndCreateToastTable (relOid=, relOid@entry=20441, reloptions=reloptions@entry=0, lockmode=8, check=false, OIDOldToast=0) at ../src/backend/catalog/toasting.c:86 [22:29:32.762] rel = 0x837a60188 [22:29:32.762] #12 NewRelationCreateToastTable (relOid=relOid@entry=20441, reloptions=reloptions@entry=0) at ../src/backend/catalog/toasting.c:73 [22:29:32.762] No locals. [22:29:32.762] #13 0x00000000009526ef in ProcessUtilitySlow (pstate=pstate@entry=0x837929500, pstmt=pstmt@entry=0x83791c600, queryString=queryString@entry=0x83791b100 "CREATE TABLE persons OF person_type;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x821214e30) at ../src/backend/tcop/utility.c:1195 [22:29:32.762] validnsps = {0x37afa0 "toast", 0x0} [22:29:32.762] cstmt = [22:29:32.762] toast_options = 0 [22:29:32.762] stmt = [22:29:32.762] table_rv = 0x83791cf98 [22:29:32.762] stmts = 0x0 [22:29:32.762] _local_sigjmp_buf = {{_sjb = {9774489, 0, 34915567768, 34915568144, 34915567776, 12491112, 0, 35292091648, 34915550079, 0, 206158430232, 34359738368}}} [22:29:32.762] _save_exception_stack = 0x821214b20 [22:29:32.762] _save_context_stack = 0x0 [22:29:32.762] _do_rethrow = false [22:29:32.762] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:29:32.762] parsetree = 0x83791cf08 [22:29:32.762] commandCollected = false [22:29:32.762] needCleanup = false [22:29:32.762] address = {classId = 1259, objectId = 20441, objectSubId = 0} [22:29:32.762] isTopLevel = [22:29:32.762] isCompleteQuery = [22:29:32.762] #14 0x00000000009516e8 in standard_ProcessUtility (pstmt=0x83791c600, queryString=queryString@entry=0x83791b100 "CREATE TABLE persons OF person_type;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837a75fe0, qc=0x821214e30) at ../src/backend/tcop/utility.c:1033 [22:29:32.762] isAtomicContext = false [22:29:32.762] parsetree = 0x83791cf08 [22:29:32.762] readonly_flags = [22:29:32.762] pstate = 0x837929500 [22:29:32.762] isTopLevel = [22:29:32.762] #15 0x000000083b14bf6e in pgss_ProcessUtility (pstmt=0x83791c600, queryString=0x83791b100 "CREATE TABLE persons OF person_type;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x837a75fe0, qc=0x821214e30) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [22:29:32.762] _local_sigjmp_buf = {{_sjb = {35350953639, 34915568416, 34915568280, 34915568736, 35292038656, 0, 12491112, 34915568944, 895, 8589934593, 35293451605, 0}}} [22:29:32.762] _save_exception_stack = 0x821214d30 [22:29:32.762] _save_context_stack = 0x0 [22:29:32.762] _do_rethrow = false [22:29:32.762] bufusage = {shared_blks_hit = 35350953639, shared_blks_read = 34915568416, shared_blks_dirtied = 34915568280, shared_blks_written = 34915568736, local_blks_hit = 35292038656, local_blks_read = 0, local_blks_dirtied = 12491112, local_blks_written = 34915568944, temp_blks_read = 895, temp_blks_written = 8589934593, shared_blk_read_time = {ticks = 35293451605}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 4291189379345209856}, local_blk_write_time = {ticks = 12500040}, temp_blk_read_time = {ticks = 34915568560}, temp_blk_write_time = {ticks = 6684895}} [22:29:32.762] walusage_start = {wal_records = 27, wal_fpi = 0, wal_bytes = 2747} [22:29:32.762] duration = [22:29:32.762] bufusage_start = {shared_blks_hit = 825, shared_blks_read = 15, shared_blks_dirtied = 4, shared_blks_written = 4, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 0, 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}} [22:29:32.762] walusage = {wal_records = 3153, wal_fpi = 549755813888, wal_bytes = 3896} [22:29:32.762] start = {ticks = -172609678270} [22:29:32.762] rows = [22:29:32.762] saved_queryId = 3035673551489387607 [22:29:32.762] parsetree = [22:29:32.762] saved_stmt_location = 0 [22:29:32.762] saved_stmt_len = 35 [22:29:32.762] enabled = [22:29:32.762] #16 0x0000000000950cb3 in PortalRunUtility (portal=0x8379bf100, pstmt=0x83791c600, isTopLevel=, setHoldSnapshot=, dest=0x837a75fe0, qc=0x821214e30) at ../src/backend/tcop/pquery.c:1152 [22:29:32.762] No locals. [22:29:32.762] #17 0x0000000000950374 in PortalRunMulti (portal=portal@entry=0x8379bf100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x837a75fe0, altdest=altdest@entry=0x837a75fe0, qc=qc@entry=0x821214e30) at ../src/backend/tcop/pquery.c:1316 [22:29:32.762] pstmt = 0x83791c600 [22:29:32.762] stmtlist_item__state = {l = 0x837a75f90, i = 0} [22:29:32.762] active_snapshot_set = false [22:29:32.762] stmtlist_item = 0x837a75fa8 [22:29:32.762] #18 0x000000000094fc5b in PortalRun (portal=portal@entry=0x8379bf100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x837a75fe0, altdest=altdest@entry=0x837a75fe0, qc=qc@entry=0x821214e30) at ../src/backend/tcop/pquery.c:787 [22:29:32.762] _local_sigjmp_buf = {{_sjb = {9763797, 35292705024, 34915568936, 34915569184, 34915568944, 12491112, 34915569200, 12447480, 12387199, 0, 35292709759, 34359738368}}} [22:29:32.762] _save_exception_stack = 0x821214ee0 [22:29:32.762] _save_context_stack = 0x0 [22:29:32.762] _do_rethrow = false [22:29:32.762] saveTopTransactionResourceOwner = 0x837a14458 [22:29:32.762] saveTopTransactionContext = 0x8379c3000 [22:29:32.762] saveActivePortal = 0x0 [22:29:32.762] saveResourceOwner = 0x837a14458 [22:29:32.762] savePortalContext = 0x0 [22:29:32.762] saveMemoryContext = 0x8379c3000 [22:29:32.762] result = [22:29:32.762] nprocessed = [22:29:32.762] #19 0x000000000094eae9 in exec_simple_query (query_string=query_string@entry=0x83791b100 "CREATE TABLE persons OF person_type;") at ../src/backend/tcop/postgres.c:1271 [22:29:32.762] cmdtaglen = 12 [22:29:32.762] snapshot_set = [22:29:32.762] per_parsetree_context = 0x0 [22:29:32.762] plantree_list = [22:29:32.762] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:29:32.762] format = 0 [22:29:32.762] parsetree = 0x83791c3a8 [22:29:32.762] commandTag = [22:29:32.762] cmdtagname = [22:29:32.762] querytree_list = [22:29:32.762] portal = 0x8379bf100 [22:29:32.762] receiver = 0x837a75fe0 [22:29:32.762] parsetree_item__state = {l = 0x83791c5b0, i = 0} [22:29:32.762] msec_str = "\000\000\000\000\b", '\000' , "\2355\210g\000\000\000\000\r\226\246+\017", [22:29:32.762] dest = DestRemote [22:29:32.762] was_logged = [22:29:32.762] oldcontext = 0x8379c3000 [22:29:32.762] parsetree_list = 0x83791c5b0 [22:29:32.762] use_implicit_block = false [22:29:32.762] parsetree_item = 0x83791c5c8 [22:29:32.762] save_log_statement_stats = [22:29:32.762] #20 0x000000000094c753 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [22:29:32.762] query_string = 0x83791b100 "CREATE TABLE persons OF person_type;" [22:29:32.762] input_message = {data = 0x83791b100 "CREATE TABLE persons OF person_type;", len = 37, maxlen = 1024, cursor = 37} [22:29:32.762] firstchar = [22:29:32.762] local_sigjmp_buf = {{_sjb = {9747462, 34915569376, 34915569368, 34915569920, 12499864, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [22:29:32.762] send_ready_for_query = false [22:29:32.762] idle_in_transaction_timeout_enabled = false [22:29:32.762] idle_session_timeout_enabled = false [22:29:32.762] #21 0x00000000009470f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:29:32.762] bsdata = [22:29:32.762] #22 0x000000000089e6c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x821215c10 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821215b60) at ../src/backend/postmaster/launch_backend.c:274 [22:29:32.762] pid = [22:29:32.762] #23 0x00000000008a2c16 in BackendStartup (client_sock=0x821215b60) at ../src/backend/postmaster/postmaster.c:3466 [22:29:32.762] startup_data = {canAcceptConnections = CAC_OK} [22:29:32.762] bn = 0x837a00348 [22:29:32.762] cac = CAC_OK [22:29:32.762] pid = [22:29:32.762] __error = [22:29:32.762] save_errno = [22:29:32.762] __error = [22:29:32.762] __error = [22:29:32.762] #24 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:29:32.762] 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' , "\300[!!\b\000\000\000h\025Y,\b\000\000\000W\000\000\000\000\000\000\000^\237Y,\b", '\000' , "\\!!\b\000\000\000T\344\211\000\000\000\000\000\020\\!!\b", '\000' }, salen = 16}} [22:29:32.762] i = 0 [22:29:32.762] now = [22:29:32.762] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 730594434, events = 8, fd = 0, user_data = 0x821215b10}, {pos = 932693464, events = 8, fd = 555833760, user_data = 0x0}, {pos = -1753357558, events = 8383, fd = 729761696, user_data = 0x82b805d78}, {pos = 555832856, events = 8, fd = 555832976, user_data = 0x821215618}, {pos = -1753357558, events = 8383, fd = 729740168, user_data = 0x82b805d78}, {pos = 555832904, events = 8, fd = 555833024, user_data = 0x821215648}, {pos = 729801108, events = 8, fd = 567624712, user_data = 0x82b7fe194}, {pos = 555833008, events = 8, fd = -1753377734, user_data = 0x821215650}, {pos = 744027152, events = 8, fd = 731623472, user_data = 0x20bf977de30a}, {pos = 729708632, events = 8, fd = 729832824, user_data = 0x8212156b8}, {pos = 555833136, events = 8, fd = 555833016, user_data = 0x82b7fcd0c}, {pos = 567624712, events = 8, fd = 729795852, user_data = 0x821215720}, {pos = -1753377734, events = 8383, fd = 555833160, user_data = 0x821215918}, {pos = 555833136, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x821d5a038}, {pos = 1, events = 2819620726, fd = 567624712, user_data = 0x82b7ef388}, {pos = 567646152, events = 8, fd = 0, user_data = 0x0}, {pos = 555833272, events = 8, fd = 555833736, user_data = 0x8212157a0}, {pos = -1753359198, events = 8383, fd = 2721378, user_data = 0x6d68b}, {pos = 2090263927, events = 2819620726, fd = 567648312, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821215a88}, {pos = 567624712, events = 3, fd = 555833808, user_data = 0x821d59828}, {pos = 656, events = 0, fd = 555833736, user_data = 0x8212157b8}, {pos = 555833376, events = 8, fd = -1753359589, user_data = 0x821215950}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 567648312, events = 8, fd = 1, user_data = 0x821d54408}, {pos = 729708632, events = 8, fd = 555833992, user_data = 0x8212159d0}, {pos = 555833392, events = 8, fd = 0, user_data = 0x821d4d008}, {pos = 33, events = 0, fd = 555833792, user_data = 0x20bf977d7ae7}, {pos = 567595016, events = 8, fd = 567596040, user_data = 0x821d4d808}, {pos = 567598088, events = 8, fd = 567611400, user_data = 0x821d51408}, {pos = 567613448, events = 8, fd = 567614472, user_data = 0x821d52008}, {pos = 567616520, events = 8, fd = 567617544, user_data = 0x821d52c08}, {pos = 567619592, events = 8, fd = 567620616, user_data = 0x821d53808}, {pos = 567622664, events = 8, fd = 567623688, user_data = 0x821d54408}, {pos = 567625736, events = 8, fd = 567626760, user_data = 0x821d55008}, {pos = 567628808, events = 8, fd = 567629832, user_data = 0x821d55c08}, {pos = 567631880, events = 8, fd = 567632904, user_data = 0x821d56808}, {pos = 567634952, events = 8, fd = 567640072, user_data = 0x821d58408}, {pos = 567642120, events = 8, fd = 567643144, user_data = 0x821d5b408}, {pos = 535555000, events = 0, fd = 567595016, user_data = 0x298662}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821d5a038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 555833992, events = 8, fd = 555833392, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 567648312, user_data = 0x1}, {pos = 567595016, events = 8, fd = 298, user_data = 0x821215a70}, {pos = -1753385489, events = 8383, fd = 2721378, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 567648312, user_data = 0x1}, {pos = 567624712, events = 8, fd = 932229120, user_data = 0x1}, {pos = 932229524, events = 8, fd = 0, user_data = 0x821215a40}, {pos = 744068460, events = 8, fd = 1, user_data = 0x83790b000}, {pos = 555833968, events = 8, fd = 744064770, user_data = 0x82b919170 }, {pos = 12410032, events = 0, fd = 730960240, user_data = 0x821d54408}, {pos = 555834192, events = 8, fd = -1753386018, user_data = 0x837929800}, {pos = 1, events = 0, fd = -1753386402, user_data = 0x821d4d008}, {pos = 555833976, events = 8, fd = 555834192, user_data = 0x1ab8}, {pos = 11, events = 0, fd = -1753306736, user_data = 0x0}, {pos = 555811711, events = 8, fd = 8172999, user_data = 0x821215b00}, {pos = 744027152, events = 8, fd = 731623472, user_data = 0x82b9bd310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821215b30}, {pos = 744070045, events = 8, fd = 932229120, user_data = 0x35be}, {pos = 555834256, events = 8, fd = 744036602, user_data = 0x0}, {pos = 0, events = 0, fd = -1647427473, user_data = 0x0}} [22:29:32.762] last_touch_time = 1736979854 [22:29:32.762] last_lockfile_recheck_time = 1736979854 [22:29:32.762] nevents = 1 [22:29:32.762] #25 0x00000000008a0ea4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821216188) at ../src/backend/postmaster/postmaster.c:1377 [22:29:32.762] userDoption = [22:29:32.762] listen_addr_saved = false [22:29:32.762] output_config_variable = [22:29:32.762] opt = [22:29:32.762] status = [22:29:32.762] #26 0x00000000007d82a0 in main (argc=4, argv=0x821216188) at ../src/backend/main/main.c:230 [22:29:32.762] do_check_root = [22:29:32.762] dispatch_option = DISPATCH_POSTMASTER [22:29:32.772] [22:29:32.772] [22:29:32.772] [22:29:32.831] dumping /tmp/cores/postgres.25939.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:29:32.953] [New LWP 100130] [22:29:33.023] Core was generated by `postgres: main: postgres postgres [local] ALTER PUBLICATION'. [22:29:33.023] Program terminated with signal SIGSEGV, Segmentation fault. [22:29:33.023] Address not mapped to object. [22:29:33.023] #0 0x00000000005bad89 in fetch_att (T=0x8360e5ffc, attbyval=, attlen=) at ../src/include/access/tupmacs.h:86 [22:29:33.023] 86 return *((const Datum *) T) & fetch_mask[attlen]; [22:29:33.061] [22:29:33.061] Thread 1 (LWP 100130): [22:29:33.061] #0 0x00000000005bad89 in fetch_att (T=0x8360e5ffc, attbyval=, attlen=) at ../src/include/access/tupmacs.h:86 [22:29:33.061] No locals. [22:29:33.061] #1 nocache_index_getattr (tup=tup@entry=0x8360e5ff0, attnum=1, attnum@entry=2, tupleDesc=tupleDesc@entry=0x838a39a68) at ../src/backend/access/common/indextuple.c:443 [22:29:33.061] bp = 0x0 [22:29:33.061] slow = [22:29:33.061] data_off = [22:29:33.061] tp = 0x8360e5ff8 "H@" [22:29:33.061] off = [22:29:33.061] #2 0x0000000000632d8a in index_getattr (tup=0x8360e5ff0, attnum=2, tupleDesc=0x838a39a68, isnull=) at ../src/include/access/itup.h:136 [22:29:33.061] attr = 0x838a39a90 [22:29:33.061] attr = [22:29:33.061] #3 _bt_mkscankey (rel=rel@entry=0x838ac1788, itup=itup@entry=0x8360e5ff0) at ../src/backend/access/nbtree/nbtutils.c:138 [22:29:33.061] procinfo = 0x838a79d28 [22:29:33.061] null = false [22:29:33.061] arg = [22:29:33.061] flags = [22:29:33.061] itupdesc = 0x838a39a68 [22:29:33.061] indnkeyatts = 2 [22:29:33.061] indoption = 0x838a79e60 [22:29:33.061] tupnatts = [22:29:33.061] key = 0x8360e5b68 [22:29:33.061] skey = [22:29:33.061] i = 1 [22:29:33.061] #4 0x000000000061cadf in _bt_doinsert (rel=0x838a39a68, rel@entry=0x838ac1788, itup=itup@entry=0x8360e5ff0, checkUnique=3763196, checkUnique@entry=UNIQUE_CHECK_YES, indexUnchanged=false, heapRel=heapRel@entry=0x838ac2858) at ../src/backend/access/nbtree/nbtinsert.c:113 [22:29:33.061] insertstate = {itup = 0x8211db940, itemsz = 35266650096, itup_key = 0x2, buf = 16, bounds_valid = false, low = 0, stricthigh = 47424, postingoff = 8} [22:29:33.061] is_unique = false [22:29:33.061] itup_key = [22:29:33.061] checkingunique = [22:29:33.061] stack = [22:29:33.061] #5 0x00000000006297ab in btinsert (rel=0x838ac1788, values=, isnull=, ht_ctid=0x8360e5c7c, heapRel=0x838ac2858, checkUnique=UNIQUE_CHECK_YES, indexUnchanged=, indexInfo=) at ../src/backend/access/nbtree/nbtree.c:195 [22:29:33.061] itup = 0x8360e5ff0 [22:29:33.061] result = [22:29:33.061] #6 0x00000000006a332d in CatalogIndexInsert (indstate=indstate@entry=0x8360a5838, heapTuple=heapTuple@entry=0x8360e5c78, updateIndexes=updateIndexes@entry=TU_All) at ../src/backend/catalog/indexing.c:170 [22:29:33.061] indexInfo = 0x8360c4a60 [22:29:33.061] index = 0x838ac1788 [22:29:33.061] values = {16456, 16619, 34915334320, 11073991, 35265372800, 3717354892, 34915334320, 11070168, 12493848, 2167185221, 5, 35265886848, 35265887000, 6106, 34915334416, 11076116, 56, 35266649208, 0, 35265372800, 11084960, 35265372800, 88, 1, 34915334432, 11383056, 1, 1, 34915334480, 9873257, 35266649208, 6993} [22:29:33.061] isnull = {false, false, 172, 56, 8, false, false, false, 120, 92, 14, 54, 8, false, false, false, 192, 185, 29, 33, 8, false, false, false, 224, 180, 95, false, false, false, false, false} [22:29:33.061] heapRelation = 0x838ac2858 [22:29:33.061] relationDescs = 0x835f72248 [22:29:33.061] indexInfoArray = 0x835f72278 [22:29:33.061] slot = 0x835f722a8 [22:29:33.061] i = 1 [22:29:33.061] numIndexes = [22:29:33.061] onlySummarized = [22:29:33.061] #7 0x00000000006a3218 in CatalogTupleInsert (heapRel=0x838ac2858, tup=0x8360e5c78) at ../src/backend/catalog/indexing.c:243 [22:29:33.061] indstate = 0x8360a5838 [22:29:33.061] #8 0x00000000006bfb12 in publication_add_relation (pubid=pubid@entry=16619, pri=pri@entry=0x8360e5d08, if_not_exists=) at ../src/backend/catalog/pg_publication.c:498 [22:29:33.061] values = {16631, 16619, 16456, 0, 35266649824} [22:29:33.061] nulls = {false, false, false, true, false} [22:29:33.061] myself = {classId = 906775040, objectId = 8, objectSubId = 555596384} [22:29:33.061] referenced = {classId = 6237, objectId = 0, objectSubId = 16777216} [22:29:33.061] targetrel = [22:29:33.061] relid = 16456 [22:29:33.061] pub = [22:29:33.061] relids = 0x0 [22:29:33.061] rel = 0x838ac2858 [22:29:33.061] attnums = 0x8360a5b68 [22:29:33.061] pubreloid = 16631 [22:29:33.061] tup = 0x8360e5c78 [22:29:33.061] i = [22:29:33.061] #9 0x0000000000711f4c in PublicationAddTables (pubid=pubid@entry=16619, rels=rels@entry=0x8360a5ba8, if_not_exists=, stmt=stmt@entry=0x838a4cb28) at ../src/backend/commands/publicationcmds.c:1810 [22:29:33.061] pub_rel = 0x8360e5d08 [22:29:33.061] rel = 0x838ac1368 [22:29:33.061] obj = [22:29:33.061] lc__state = {l = 0x8360a5ba8, i = 0} [22:29:33.061] lc = [22:29:33.061] #10 0x00000000007127b9 in AlterPublicationTables (stmt=0x838a4cb28, tup=0x8360a5a48, tables=, queryString=0x835f08100 "ALTER PUBLICATION pub1 ADD TABLE dump_test.test_sixth_table (col3, col2);", publish_schema=) at ../src/backend/commands/publicationcmds.c:1159 [22:29:33.061] rels = 0x8360a5ba8 [22:29:33.061] pubform = [22:29:33.061] pubid = [22:29:33.061] oldrelids = [22:29:33.061] delrels = [22:29:33.061] oldlc = [22:29:33.061] oldlc__state = [22:29:33.061] oldrelid = [22:29:33.061] found = [22:29:33.061] oldrelwhereclause = [22:29:33.061] oldcolumns = [22:29:33.061] oldrel = [22:29:33.061] rftuple = [22:29:33.061] newlc = [22:29:33.061] isnull = [22:29:33.061] whereClauseDatum = [22:29:33.061] columnListDatum = [22:29:33.061] newlc__state = [22:29:33.061] newcolumns = [22:29:33.061] newpubrel = [22:29:33.061] newrelid = [22:29:33.061] #11 AlterPublication (pstate=pstate@entry=0x8360c4900, stmt=stmt@entry=0x838a4cb28) at ../src/backend/commands/publicationcmds.c:1472 [22:29:33.061] relations = 0x8360c4a10 [22:29:33.061] schemaidlist = 0x0 [22:29:33.061] pubid = [22:29:33.061] rel = 0x838a3da58 [22:29:33.061] tup = 0x8360a5a48 [22:29:33.061] pubform = [22:29:33.061] #12 0x0000000000952f69 in ProcessUtilitySlow (pstate=pstate@entry=0x8360c4900, pstmt=pstmt@entry=0x835f09890, queryString=queryString@entry=0x835f08100 "ALTER PUBLICATION pub1 ADD TABLE dump_test.test_sixth_table (col3, col2);", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x8211dbfe0) at ../src/backend/tcop/utility.c:1850 [22:29:33.061] _local_sigjmp_buf = {{_sjb = {9774489, 0, 34915335176, 34915335552, 34915335184, 12491112, 0, 35266513152, 34915287935, 35098804199, 35310060170, 0}}} [22:29:33.061] _save_exception_stack = 0x8211dbee0 [22:29:33.061] _save_context_stack = 0x0 [22:29:33.061] _do_rethrow = false [22:29:33.061] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [22:29:33.061] parsetree = 0x838a4cb28 [22:29:33.061] commandCollected = false [22:29:33.061] needCleanup = false [22:29:33.061] address = [22:29:33.061] isTopLevel = [22:29:33.061] isCompleteQuery = [22:29:33.061] #13 0x00000000009516e8 in standard_ProcessUtility (pstmt=0x835f09890, queryString=0x835f08100 "ALTER PUBLICATION pub1 ADD TABLE dump_test.test_sixth_table (col3, col2);", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x838a4ce40, qc=0x8211dbfe0) at ../src/backend/tcop/utility.c:1033 [22:29:33.061] isAtomicContext = false [22:29:33.061] parsetree = 0x838a4cb28 [22:29:33.061] readonly_flags = [22:29:33.061] pstate = 0x8360c4900 [22:29:33.061] isTopLevel = [22:29:33.061] #14 0x0000000000951178 in ProcessUtility (pstmt=0x838a39a68, queryString=0x1 , readOnlyTree=, context=3762576, params=0x0, queryEnv=0x838a79c00, dest=0x838a4ce40, qc=0x8211dbfe0) at ../src/backend/tcop/utility.c:523 [22:29:33.061] No locals. [22:29:33.061] #15 0x0000000000950cb3 in PortalRunUtility (portal=0x835faa100, pstmt=0x835f09890, isTopLevel=, setHoldSnapshot=, dest=0x838a4ce40, qc=0x8211dbfe0) at ../src/backend/tcop/pquery.c:1152 [22:29:33.061] No locals. [22:29:33.061] #16 0x0000000000950374 in PortalRunMulti (portal=portal@entry=0x835faa100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x838a4ce40, altdest=altdest@entry=0x838a4ce40, qc=qc@entry=0x8211dbfe0) at ../src/backend/tcop/pquery.c:1316 [22:29:33.061] pstmt = 0x835f09890 [22:29:33.061] stmtlist_item__state = {l = 0x838a4cdf0, i = 0} [22:29:33.061] active_snapshot_set = false [22:29:33.061] stmtlist_item = 0x838a4ce08 [22:29:33.061] #17 0x000000000094fc5b in PortalRun (portal=portal@entry=0x835faa100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x838a4ce40, altdest=altdest@entry=0x838a4ce40, qc=qc@entry=0x8211dbfe0) at ../src/backend/tcop/pquery.c:787 [22:29:33.061] _local_sigjmp_buf = {{_sjb = {9763797, 35265356032, 34915335896, 34915336144, 34915335904, 12491112, 34915336160, 12447480, 12387199, 0, 35265315711, 34359738368}}} [22:29:33.061] _save_exception_stack = 0x8211dc090 [22:29:33.061] _save_context_stack = 0x0 [22:29:33.061] _do_rethrow = false [22:29:33.061] saveTopTransactionResourceOwner = 0x835ff37d8 [22:29:33.061] saveTopTransactionContext = 0x835fae000 [22:29:33.061] saveActivePortal = 0x0 [22:29:33.061] saveResourceOwner = 0x835ff37d8 [22:29:33.061] savePortalContext = 0x0 [22:29:33.061] saveMemoryContext = 0x835fae000 [22:29:33.061] result = [22:29:33.061] nprocessed = [22:29:33.061] #18 0x000000000094eae9 in exec_simple_query (query_string=query_string@entry=0x835f08100 "ALTER PUBLICATION pub1 ADD TABLE dump_test.test_sixth_table (col3, col2);") at ../src/backend/tcop/postgres.c:1271 [22:29:33.061] cmdtaglen = 17 [22:29:33.061] snapshot_set = [22:29:33.061] per_parsetree_context = 0x0 [22:29:33.061] plantree_list = [22:29:33.061] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:29:33.061] format = 0 [22:29:33.061] parsetree = 0x835f09598 [22:29:33.061] commandTag = [22:29:33.061] cmdtagname = [22:29:33.061] querytree_list = [22:29:33.061] portal = 0x835faa100 [22:29:33.061] receiver = 0x838a4ce40 [22:29:33.061] parsetree_item__state = {l = 0x835f09840, i = 0} [22:29:33.061] msec_str = "\000\000\000\000\b", '\000' , "\3415\210g\000\000\000\000\261\177\215\301\006f", [22:29:33.061] dest = DestRemote [22:29:33.061] was_logged = [22:29:33.061] oldcontext = 0x835fae000 [22:29:33.061] parsetree_list = 0x835f09840 [22:29:33.061] use_implicit_block = false [22:29:33.061] parsetree_item = 0x835f09858 [22:29:33.061] save_log_statement_stats = [22:29:33.061] #19 0x000000000094c753 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4687 [22:29:33.061] query_string = 0x835f08100 "ALTER PUBLICATION pub1 ADD TABLE dump_test.test_sixth_table (col3, col2);" [22:29:33.061] input_message = {data = 0x835f08100 "ALTER PUBLICATION pub1 ADD TABLE dump_test.test_sixth_table (col3, col2);", len = 74, maxlen = 1024, cursor = 74} [22:29:33.061] firstchar = [22:29:33.061] local_sigjmp_buf = {{_sjb = {9747462, 34915336336, 34915336328, 34915336880, 12499864, 1, 8192, 8388608, 34915287935, 0, 0, 1}}} [22:29:33.061] send_ready_for_query = false [22:29:33.061] idle_in_transaction_timeout_enabled = false [22:29:33.061] idle_session_timeout_enabled = false [22:29:33.061] #20 0x00000000009470f9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:29:33.061] bsdata = [22:29:33.061] #21 0x000000000089e6c5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x8211dcdc0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8211dcd10) at ../src/backend/postmaster/launch_backend.c:274 [22:29:33.061] pid = [22:29:33.061] #22 0x00000000008a2c16 in BackendStartup (client_sock=0x8211dcd10) at ../src/backend/postmaster/postmaster.c:3466 [22:29:33.061] startup_data = {canAcceptConnections = CAC_OK} [22:29:33.061] bn = 0x835fca038 [22:29:33.061] cac = CAC_OK [22:29:33.061] pid = [22:29:33.061] __error = [22:29:33.061] save_errno = [22:29:33.061] __error = [22:29:33.061] __error = [22:29:33.061] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [22:29:33.061] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\f", '\000' , "p\315\035!\b\000\000\000h\245\031+\b\000\000\000\346\000\000\000\000\000\000\000^/\032+\b", '\000' , "\260\315\035!\b\000\000\000T\344\211\000\000\000\000\000\300\315\035!\b", '\000' }, salen = 16}} [22:29:33.061] i = 0 [22:29:33.061] now = [22:29:33.061] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 738454658, events = 8, fd = 0, user_data = 0x8211dccc0}, {pos = 905381336, events = 8, fd = 555600720, user_data = 0x0}, {pos = 0, events = 0, fd = -1912713946, user_data = 0x2d450b8a130a}, {pos = 737621920, events = 8, fd = 737693048, user_data = 0x8211dc7d8}, {pos = 555599952, events = 8, fd = 555599832, user_data = 0x2d450b8a130a}, {pos = 737600392, events = 8, fd = 737693048, user_data = 0x8211dc808}, {pos = 555600000, events = 8, fd = 555599880, user_data = 0x82bf7d194}, {pos = 564970504, events = 8, fd = 737661332, user_data = 0x8211dc870}, {pos = 193578042, events = 11589, fd = 739483696, user_data = 0x1}, {pos = 555600032, events = 8, fd = 193598218, user_data = 0x82bf66858}, {pos = 737693048, events = 8, fd = 555599992, user_data = 0x8211dc8f0}, {pos = 555599992, events = 8, fd = 737656076, user_data = 0x821acc408}, {pos = 737656076, events = 8, fd = 555600096, user_data = 0x2d450b89c43a}, {pos = 555600136, events = 8, fd = 555600584, user_data = 0x8211dc8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 2555619253, fd = 564994104, user_data = 0x800000001}, {pos = 564970504, events = 8, fd = 737600392, user_data = 0x821ad1288}, {pos = 737568856, events = 8, fd = 564970504, user_data = 0x8211dc978}, {pos = 555600696, events = 8, fd = 555600224, user_data = 0x2d450b8a0ca2}, {pos = 2721378, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 564994104, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 555600952, user_data = 0x21acc408}, {pos = 555600768, events = 8, fd = 555600368, user_data = 0x1}, {pos = 555600696, events = 8, fd = 32, user_data = 0x8211dc9e0}, {pos = 193596019, events = 11589, fd = 555600640, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821ad2038}, {pos = 1, events = 8, fd = 564970504, user_data = 0x82bf66858}, {pos = 555600952, events = 8, fd = 555600768, user_data = 0x8211dc9f0}, {pos = 0, events = 0, fd = 564940808, user_data = 0x20}, {pos = 555600752, events = 8, fd = 193571559, user_data = 0x821ac5008}, {pos = 564941832, events = 8, fd = 564942856, user_data = 0x821ac5c08}, {pos = 564957192, events = 8, fd = 564958216, user_data = 0x821ac9808}, {pos = 564960264, events = 8, fd = 564961288, user_data = 0x821aca408}, {pos = 564963336, events = 8, fd = 564964360, user_data = 0x821acb008}, {pos = 564966408, events = 8, fd = 564967432, user_data = 0x821acbc08}, {pos = 564969480, events = 8, fd = 564970504, user_data = 0x821acc808}, {pos = 564972552, events = 8, fd = 564973576, user_data = 0x821acd408}, {pos = 564975624, events = 8, fd = 564976648, user_data = 0x821ace008}, {pos = 564978696, events = 8, fd = 564979720, user_data = 0x821acec08}, {pos = 564985864, events = 8, fd = 564986888, user_data = 0x821ad0808}, {pos = 564988936, events = 8, fd = 564940808, user_data = 0x298662}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821ad2038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 555600952, events = 8, fd = 555600368, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 564994104, user_data = 0x1}, {pos = 564940808, events = 8, fd = 298, user_data = 0x8211dcc20}, {pos = 193570287, events = 11589, fd = 2721378, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 564994104, user_data = 0x1}, {pos = 564970504, events = 8, fd = 904888320, user_data = 0x1}, {pos = 904888724, events = 8, fd = 0, user_data = 0x8211dcbf0}, {pos = 723133804, events = 8, fd = 1, user_data = 0x835ef8000}, {pos = 555600928, events = 8, fd = 723130114, user_data = 0x82c098170 }, {pos = 12410032, events = 0, fd = 738820464, user_data = 0x821acc408}, {pos = 555601152, events = 8, fd = 193569758, user_data = 0x835f16800}, {pos = 1, events = 0, fd = 193569374, user_data = 0x821ac5008}, {pos = 555600936, events = 8, fd = 555601152, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 193649040, user_data = 0x0}, {pos = 555549567, events = 8, fd = 8172999, user_data = 0x8211dccb0}, {pos = 723092496, events = 8, fd = 739483696, user_data = 0x82c13c310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8211dcce0}, {pos = 723135389, events = 8, fd = 904888320, user_data = 0x6536}, {pos = 555601216, events = 8, fd = 723101946, user_data = 0x0}, {pos = 0, events = 0, fd = -1912713946, user_data = 0x0}} [22:29:33.061] last_touch_time = 1736979937 [22:29:33.061] last_lockfile_recheck_time = 1736979937 [22:29:33.061] nevents = 1 [22:29:33.061] #24 0x00000000008a0ea4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8211dd338) at ../src/backend/postmaster/postmaster.c:1377 [22:29:33.061] userDoption = [22:29:33.061] listen_addr_saved = false [22:29:33.061] output_config_variable = [22:29:33.061] opt = [22:29:33.061] status = [22:29:33.061] #25 0x00000000007d82a0 in main (argc=4, argv=0x8211dd338) at ../src/backend/main/main.c:230 [22:29:33.061] do_check_root = [22:29:33.061] dispatch_option = DISPATCH_POSTMASTER