[06:26:30.103] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [06:26:30.432] dumping /tmp/cores/postgres.47293.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:26:30.558] [New LWP 100639] [06:26:30.644] Core was generated by `postgres: postgres regression [local] EXECUTE'. [06:26:30.644] Program terminated with signal SIGABRT, Aborted. [06:26:30.644] Sent by thr_kill() from pid 47293 and user 1003. [06:26:30.644] #0 0x000000082b40f41a in thr_kill () from /lib/libc.so.7 [06:26:31.339] [06:26:31.339] Thread 1 (LWP 100639): [06:26:31.339] #0 0x000000082b40f41a in thr_kill () from /lib/libc.so.7 [06:26:31.339] No symbol table info available. [06:26:31.339] #1 0x000000082b388e64 in raise () from /lib/libc.so.7 [06:26:31.339] No symbol table info available. [06:26:31.339] #2 0x000000082b4396f9 in abort () from /lib/libc.so.7 [06:26:31.339] No symbol table info available. [06:26:31.339] #3 0x0000000000a92a65 in ExceptionalCondition (conditionName=0x3711f6 "cplan->magic == CACHEDPLAN_MAGIC", fileName=, lineNumber=lineNumber@entry=2440) at ../src/backend/utils/error/assert.c:66 [06:26:31.339] No locals. [06:26:31.339] #4 0x0000000000a82833 in ResetPlanCache () at ../src/backend/utils/cache/plancache.c:2440 [06:26:31.339] cplan = 0xffffffffffffffc8 [06:26:31.339] iter = {cur = 0x0, end = } [06:26:31.339] #5 0x0000000000a7a1ff in CallSyscacheCallbacks (cacheid=32, hashvalue=3603097922) at ../src/backend/utils/cache/inval.c:1590 [06:26:31.339] ccitem = [06:26:31.339] i = [06:26:31.339] #6 0x0000000000914704 in ReceiveSharedInvalidMessages (invalFunction=0xa79fe0 , resetFunction=0xa7a270 ) at ../src/backend/storage/ipc/sinval.c:118 [06:26:31.339] msg = {id = 32 ' ', cc = {id = 32 ' ', dbId = 16384, hashValue = 3603097922}, cat = {id = 32 ' ', dbId = 16384, catId = 3603097922}, rc = {id = 32 ' ', dbId = 16384, relId = 3603097922}, sm = {id = 32 ' ', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 3603097922, relNumber = 2139062143}}, rm = {id = 32 ' ', dbId = 16384}, sn = {id = 32 ' ', dbId = 16384, relId = 3603097922}} [06:26:31.339] getResult = 4 [06:26:31.339] messages = {{id = 32 ' ', cc = {id = 32 ' ', dbId = 16384, hashValue = 3603097922}, cat = {id = 32 ' ', dbId = 16384, catId = 3603097922}, rc = {id = 32 ' ', dbId = 16384, relId = 3603097922}, sm = {id = 32 ' ', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 3603097922, relNumber = 2139062143}}, rm = {id = 32 ' ', dbId = 16384}, sn = {id = 32 ' ', dbId = 16384, relId = 3603097922}}, {id = 31 '\037', cc = {id = 31 '\037', dbId = 16384, hashValue = 402939344}, cat = {id = 31 '\037', dbId = 16384, catId = 402939344}, rc = {id = 31 '\037', dbId = 16384, relId = 402939344}, sm = {id = 31 '\037', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 402939344, relNumber = 2139062143}}, rm = {id = 31 '\037', dbId = 16384}, sn = {id = 31 '\037', dbId = 16384, relId = 402939344}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 0, hashValue = 1214}, cat = {id = -5 '\373', dbId = 0, catId = 1214}, rc = {id = -5 '\373', dbId = 0, relId = 1214}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 0, dbOid = 1214, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 0}, sn = {id = -5 '\373', dbId = 0, relId = 1214}}, {id = -2 '\376', cc = {id = -2 '\376', dbId = 16384, hashValue = 54611}, cat = {id = -2 '\376', dbId = 16384, catId = 54611}, rc = {id = -2 '\376', dbId = 16384, relId = 54611}, sm = {id = -2 '\376', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 54611, relNumber = 2139062143}}, rm = {id = -2 '\376', dbId = 16384}, sn = {id = -2 '\376', dbId = 16384, relId = 54611}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}, {id = -2 '\376', cc = {id = -2 '\376', dbId = 16384, hashValue = 54576}, cat = {id = -2 '\376', dbId = 16384, catId = 54576}, rc = {id = -2 '\376', dbId = 16384, relId = 54576}, sm = {id = -2 '\376', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 54576, relNumber = 2139062143}}, rm = {id = -2 '\376', dbId = 16384}, sn = {id = -2 '\376', dbId = 16384, relId = 54576}}, {id = -2 '\376', cc = {id = -2 '\376', dbId = 16384, hashValue = 54570}, cat = {id = -2 '\376', dbId = 16384, catId = 54570}, rc = {id = -2 '\376', dbId = 16384, relId = 54570}, sm = {id = -2 '\376', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 54570, relNumber = 2139062143}}, rm = {id = -2 '\376', dbId = 16384}, sn = {id = -2 '\376', dbId = 16384, relId = 54570}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}, {id = -2 '\376', cc = {id = -2 '\376', dbId = 16384, hashValue = 54575}, cat = {id = -2 '\376', dbId = 16384, catId = 54575}, rc = {id = -2 '\376', dbId = 16384, relId = 54575}, sm = {id = -2 '\376', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 54575, relNumber = 2139062143}}, rm = {id = -2 '\376', dbId = 16384}, sn = {id = -2 '\376', dbId = 16384, relId = 54575}}, {id = -2 '\376', cc = {id = -2 '\376', dbId = 16384, hashValue = 54574}, cat = {id = -2 '\376', dbId = 16384, catId = 54574}, rc = {id = -2 '\376', dbId = 16384, relId = 54574}, sm = {id = -2 '\376', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 54574, relNumber = 2139062143}}, rm = {id = -2 '\376', dbId = 16384}, sn = {id = -2 '\376', dbId = 16384, relId = 54574}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}, {id = -2 '\376', cc = {id = -2 '\376', dbId = 16384, hashValue = 54574}, cat = {id = -2 '\376', dbId = 16384, catId = 54574}, rc = {id = -2 '\376', dbId = 16384, relId = 54574}, sm = {id = -2 '\376', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 54574, relNumber = 2139062143}}, rm = {id = -2 '\376', dbId = 16384}, sn = {id = -2 '\376', dbId = 16384, relId = 54574}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}, {id = -2 '\376', cc = {id = -2 '\376', dbId = 16384, hashValue = 54570}, cat = {id = -2 '\376', dbId = 16384, catId = 54570}, rc = {id = -2 '\376', dbId = 16384, relId = 54570}, sm = {id = -2 '\376', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 54570, relNumber = 2139062143}}, rm = {id = -2 '\376', dbId = 16384}, sn = {id = -2 '\376', dbId = 16384, relId = 54570}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}, {id = 6 '\006', cc = {id = 6 '\006', dbId = 16384, hashValue = 2882649433}, cat = {id = 6 '\006', dbId = 16384, catId = 2882649433}, rc = {id = 6 '\006', dbId = 16384, relId = 2882649433}, sm = {id = 6 '\006', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2882649433, relNumber = 2139062143}}, rm = {id = 6 '\006', dbId = 16384}, sn = {id = 6 '\006', dbId = 16384, relId = 2882649433}}, {id = 7 '\a', cc = {id = 7 '\a', dbId = 16384, hashValue = 980390589}, cat = {id = 7 '\a', dbId = 16384, catId = 980390589}, rc = {id = 7 '\a', dbId = 16384, relId = 980390589}, sm = {id = 7 '\a', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 980390589, relNumber = 2139062143}}, rm = {id = 7 '\a', dbId = 16384}, sn = {id = 7 '\a', dbId = 16384, relId = 980390589}}, {id = 6 '\006', cc = {id = 6 '\006', dbId = 16384, hashValue = 166740195}, cat = {id = 6 '\006', dbId = 16384, catId = 166740195}, rc = {id = 6 '\006', dbId = 16384, relId = 166740195}, sm = {id = 6 '\006', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 166740195, relNumber = 2139062143}}, rm = {id = 6 '\006', dbId = 16384}, sn = {id = 6 '\006', dbId = 16384, relId = 166740195}}, {id = 7 '\a', cc = {id = 7 '\a', dbId = 16384, hashValue = 2156143580}, cat = {id = 7 '\a', dbId = 16384, catId = 2156143580}, rc = {id = 7 '\a', dbId = 16384, relId = 2156143580}, sm = {id = 7 '\a', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2156143580, relNumber = 2139062143}}, rm = {id = 7 '\a', dbId = 16384}, sn = {id = 7 '\a', dbId = 16384, relId = 2156143580}}, {id = 6 '\006', cc = {id = 6 '\006', dbId = 16384, hashValue = 301184780}, cat = {id = 6 '\006', dbId = 16384, catId = 301184780}, rc = {id = 6 '\006', dbId = 16384, relId = 301184780}, sm = {id = 6 '\006', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 301184780, relNumber = 2139062143}}, rm = {id = 6 '\006', dbId = 16384}, sn = {id = 6 '\006', dbId = 16384, relId = 301184780}}, {id = 7 '\a', cc = {id = 7 '\a', dbId = 16384, hashValue = 2230518377}, cat = {id = 7 '\a', dbId = 16384, catId = 2230518377}, rc = {id = 7 '\a', dbId = 16384, relId = 2230518377}, sm = {id = 7 '\a', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2230518377, relNumber = 2139062143}}, rm = {id = 7 '\a', dbId = 16384}, sn = {id = 7 '\a', dbId = 16384, relId = 2230518377}}, {id = 6 '\006', cc = {id = 6 '\006', dbId = 16384, hashValue = 3106465457}, cat = {id = 6 '\006', dbId = 16384, catId = 3106465457}, rc = {id = 6 '\006', dbId = 16384, relId = 3106465457}, sm = {id = 6 '\006', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 3106465457, relNumber = 2139062143}}, rm = {id = 6 '\006', dbId = 16384}, sn = {id = 6 '\006', dbId = 16384, relId = 3106465457}}, {id = 57 '9', cc = {id = 57 '9', dbId = 16384, hashValue = 1950819820}, cat = {id = 57 '9', dbId = 16384, catId = 1950819820}, rc = {id = 57 '9', dbId = 16384, relId = 1950819820}, sm = {id = 57 '9', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 1950819820, relNumber = 2139062143}}, rm = {id = 57 '9', dbId = 16384}, sn = {id = 57 '9', dbId = 16384, relId = 1950819820}}, {id = 56 '8', cc = {id = 56 '8', dbId = 16384, hashValue = 4040683822}, cat = {id = 56 '8', dbId = 16384, catId = 4040683822}, rc = {id = 56 '8', dbId = 16384, relId = 4040683822}, sm = {id = 56 '8', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 4040683822, relNumber = 2139062143}}, rm = {id = 56 '8', dbId = 16384}, sn = {id = 56 '8', dbId = 16384, relId = 4040683822}}, {id = -2 '\376', cc = {id = -2 '\376', dbId = 16384, hashValue = 54611}, cat = {id = -2 '\376', dbId = 16384, catId = 54611}, rc = {id = -2 '\376', dbId = 16384, relId = 54611}, sm = {id = -2 '\376', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 54611, relNumber = 2139062143}}, rm = {id = -2 '\376', dbId = 16384}, sn = {id = -2 '\376', dbId = 16384, relId = 54611}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}, {id = -2 '\376', cc = {id = -2 '\376', dbId = 16384, hashValue = 54611}, cat = {id = -2 '\376', dbId = 16384, catId = 54611}, rc = {id = -2 '\376', dbId = 16384, relId = 54611}, sm = {id = -2 '\376', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 54611, relNumber = 2139062143}}, rm = {id = -2 '\376', dbId = 16384}, sn = {id = -2 '\376', dbId = 16384, relId = 54611}}, {id = -5 '\373', cc = {id = -5 '\373', dbId = 16384, hashValue = 2608}, cat = {id = -5 '\373', dbId = 16384, catId = 2608}, rc = {id = -5 '\373', dbId = 16384, relId = 2608}, sm = {id = -5 '\373', backend_hi = 127 '\177', backend_lo = 32639, rlocator = {spcOid = 16384, dbOid = 2608, relNumber = 2139062143}}, rm = {id = -5 '\373', dbId = 16384}, sn = {id = -5 '\373', dbId = 16384, relId = 2608}}} [06:26:31.339] nextmsg = 1 [06:26:31.339] nummsgs = 4 [06:26:31.339] #7 0x0000000000a7a31a in AcceptInvalidationMessages () at ../src/backend/utils/cache/inval.c:808 [06:26:31.339] recursion_depth = 0 [06:26:31.339] #8 0x0000000000919f6c in LockRelationOid (relid=relid@entry=54560, lockmode=lockmode@entry=1) at ../src/backend/storage/lmgr/lmgr.c:136 [06:26:31.339] tag = {locktag_field1 = 16384, locktag_field2 = 54560, locktag_field3 = 0, locktag_field4 = 0, locktag_type = 0 '\000', locktag_lockmethodid = 1 '\001'} [06:26:31.339] locallock = 0x835d8c730 [06:26:31.339] res = LOCKACQUIRE_NOT_AVAIL [06:26:31.339] #9 0x0000000000698fcb in RangeVarGetRelidExtended (relation=relation@entry=0x835c927c0, lockmode=lockmode@entry=1, flags=1, callback=callback@entry=0x0, callback_arg=callback_arg@entry=0x0) at ../src/backend/catalog/namespace.c:577 [06:26:31.339] oldRelId = 0 [06:26:31.339] retry = [06:26:31.339] inval_count = 9512 [06:26:31.339] relId = 54560 [06:26:31.339] missing_ok = [06:26:31.339] #10 0x00000000005b3a2e in relation_openrv_extended (relation=relation@entry=0x835c927c0, lockmode=lockmode@entry=1, missing_ok=true) at ../src/backend/access/common/relation.c:185 [06:26:31.339] relOid = [06:26:31.339] #11 0x0000000000642c7b in table_openrv_extended (relation=0x1891f, relation@entry=0x835c927c0, lockmode=6, lockmode@entry=1, missing_ok=false) at ../src/backend/access/table/table.c:108 [06:26:31.339] r = [06:26:31.339] #12 0x00000000008679a9 in parserOpenTable (pstate=pstate@entry=0x837d30a48, relation=0x835c927c0, lockmode=1) at ../src/backend/parser/parse_relation.c:1424 [06:26:31.339] pcbstate = {pstate = 0x837d30a48, location = 28, errcallback = {previous = 0x0, callback = 0x8647e0 , arg = 0x8214abe10}} [06:26:31.339] rel = [06:26:31.339] #13 0x0000000000867cd9 in addRangeTableEntry (pstate=pstate@entry=0x837d30a48, relation=0x6, relation@entry=0x835c927c0, alias=0x0, inh=true, inFromCl=true) at ../src/backend/parser/parse_relation.c:1501 [06:26:31.339] rte = 0x837d30d68 [06:26:31.339] refname = 0x837d30838 "my_property_secure" [06:26:31.339] lockmode = 0 [06:26:31.339] rel = [06:26:31.339] perminfo = [06:26:31.339] nsitem = [06:26:31.339] #14 0x000000000084c14e in transformTableEntry (pstate=0x837d30a48, r=0x835c927c0) at ../src/backend/parser/parse_clause.c:400 [06:26:31.339] No locals. [06:26:31.339] #15 transformFromClauseItem (pstate=pstate@entry=0x837d30a48, n=0x835c927c0, top_nsitem=top_nsitem@entry=0x8214ac018, namespace=namespace@entry=0x8214ac020) at ../src/backend/parser/parse_clause.c:1075 [06:26:31.339] rv = 0x835c927c0 [06:26:31.339] nsitem = 0x0 [06:26:31.339] rtr = [06:26:31.339] #16 0x000000000084ab69 in transformFromClause (pstate=pstate@entry=0x837d30a48, frmList=0x835c92770) at ../src/backend/parser/parse_clause.c:133 [06:26:31.339] nsitem = 0x82b4b0af8 [06:26:31.339] namespace = 0x108 [06:26:31.339] n = 0x6 [06:26:31.339] fl__state = {l = , i = 0} [06:26:31.339] fl = [06:26:31.339] #17 0x0000000000845a29 in transformSelectStmt (pstate=pstate@entry=0x837d30a48, stmt=stmt@entry=0x835c92578) at ../src/backend/parser/analyze.c:1374 [06:26:31.339] qry = 0x837d30b58 [06:26:31.339] qual = [06:26:31.339] l = [06:26:31.339] #18 0x000000000084461b in transformStmt (pstate=pstate@entry=0x837d30a48, parseTree=parseTree@entry=0x835c92578) at ../src/backend/parser/analyze.c:374 [06:26:31.339] n = 0x835c92578 [06:26:31.339] result = [06:26:31.339] #19 0x0000000000842b5c in transformOptionalSelectInto (parseTree=0x835c92578, pstate=) at ../src/backend/parser/analyze.c:304 [06:26:31.339] stmt = [06:26:31.339] ctas = [06:26:31.339] #20 transformTopLevelStmt (pstate=pstate@entry=0x837d30a48, parseTree=parseTree@entry=0x835c92548) at ../src/backend/parser/analyze.c:254 [06:26:31.339] result = [06:26:31.339] #21 0x0000000000842a1b in parse_analyze_fixedparams (parseTree=parseTree@entry=0x835c92548, sourceText=sourceText@entry=0x835c92360 "PREPARE p2 AS SELECT * FROM my_property_secure WHERE f_leak(passwd);", paramTypes=paramTypes@entry=0x0, numParams=numParams@entry=0, queryEnv=queryEnv@entry=0x0) at ../src/backend/parser/analyze.c:122 [06:26:31.339] pstate = 0x837d30a48 [06:26:31.339] jstate = 0x0 [06:26:31.339] query = [06:26:31.339] #22 0x0000000000935bc1 in pg_analyze_and_rewrite_fixedparams (parsetree=0x835c92548, query_string=0x835c92360 "PREPARE p2 AS SELECT * FROM my_property_secure WHERE f_leak(passwd);", paramTypes=0x0, numParams=0, queryEnv=queryEnv@entry=0x0) at ../src/backend/tcop/postgres.c:694 [06:26:31.339] query = [06:26:31.339] querytree_list = [06:26:31.339] #23 0x0000000000a8152e in RevalidateCachedQuery (plansource=plansource@entry=0x835c9d900, queryEnv=queryEnv@entry=0x0) at ../src/backend/utils/cache/plancache.c:728 [06:26:31.339] snapshot_set = [06:26:31.339] rawtree = 0x0 [06:26:31.339] tlist = [06:26:31.339] resultDesc = [06:26:31.339] oldcxt = [06:26:31.339] querytree_context = [06:26:31.339] qlist = [06:26:31.339] #24 0x0000000000a80e03 in GetCachedPlan (plansource=0x835c9d900, boundParams=boundParams@entry=0x0, owner=owner@entry=0x0, queryEnv=queryEnv@entry=0x0) at ../src/backend/utils/cache/plancache.c:1200 [06:26:31.339] plan = 0x0 [06:26:31.339] qlist = [06:26:31.339] customplan = [06:26:31.339] #25 0x0000000000703042 in ExecuteQuery (pstate=pstate@entry=0x835c92438, stmt=stmt@entry=0x835c6cad0, intoClause=intoClause@entry=0x0, params=params@entry=0x0, dest=0x835c7c728, qc=qc@entry=0x8214ac438) at ../src/backend/commands/prepare.c:193 [06:26:31.339] paramLI = 0x0 [06:26:31.339] estate = 0x0 [06:26:31.339] entry = 0x837e6ec78 [06:26:31.339] portal = 0x835d93210 [06:26:31.339] query_string = 0x835c93100 "PREPARE p2 AS SELECT * FROM my_property_secure WHERE f_leak(passwd);" [06:26:31.339] cplan = [06:26:31.339] plan_list = [06:26:31.339] eflags = [06:26:31.339] count = [06:26:31.339] #26 0x000000000093d772 in standard_ProcessUtility (pstmt=0x835c6cb80, queryString=0x835c6c100 "EXECUTE p2;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x835c7c728, qc=0x8214ac438) at ../src/backend/tcop/utility.c:750 [06:26:31.339] isAtomicContext = false [06:26:31.339] parsetree = 0x835c6cad0 [06:26:31.339] readonly_flags = [06:26:31.339] pstate = 0x835c92438 [06:26:31.339] isTopLevel = [06:26:31.339] #27 0x000000000093cfc8 in ProcessUtility (pstmt=0x1891f, queryString=0x6 , readOnlyTree=, context=725677050, params=0x0, queryEnv=0x0, dest=0x835c7c728, qc=0x8214ac438) at ../src/backend/tcop/utility.c:523 [06:26:31.339] No locals. [06:26:31.339] #28 0x000000000093cac3 in PortalRunUtility (portal=portal@entry=0x835d93100, pstmt=0x835c6cb80, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x835c7c728, qc=qc@entry=0x8214ac438) at ../src/backend/tcop/pquery.c:1182 [06:26:31.339] No locals. [06:26:31.339] #29 0x000000000093bc7d in FillPortalStore (portal=portal@entry=0x835d93100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1055 [06:26:31.339] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:26:31.339] treceiver = 0x835c7c728 [06:26:31.339] #30 0x000000000093b991 in PortalRun (portal=portal@entry=0x835d93100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x835c6cf40, altdest=altdest@entry=0x835c6cf40, qc=0x8214ac570) at ../src/backend/tcop/pquery.c:787 [06:26:31.339] _local_sigjmp_buf = {{_sjb = {9681200, 35263164672, 34918286440, 34918286672, 34918286448, 35263180800, 12345368, 12378712, 35263153023, 35261959312, 4294967984, 0}}} [06:26:31.339] _save_exception_stack = 0x8214ac640 [06:26:31.339] _save_context_stack = 0x0 [06:26:31.339] _do_rethrow = false [06:26:31.339] saveTopTransactionResourceOwner = 0x835d75c98 [06:26:31.339] saveTopTransactionContext = 0x835d97000 [06:26:31.339] saveActivePortal = 0x0 [06:26:31.339] saveResourceOwner = 0x835d75c98 [06:26:31.339] savePortalContext = 0x0 [06:26:31.339] saveMemoryContext = 0x835d97000 [06:26:31.339] result = [06:26:31.339] nprocessed = [06:26:31.339] #31 0x000000000093a7ea in exec_simple_query (query_string=query_string@entry=0x835c6c100 "EXECUTE p2;") at ../src/backend/tcop/postgres.c:1285 [06:26:31.339] cmdtaglen = 7 [06:26:31.339] snapshot_set = [06:26:31.339] per_parsetree_context = 0x0 [06:26:31.339] plantree_list = [06:26:31.339] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:26:31.339] format = 0 [06:26:31.339] parsetree = 0x835c6cb00 [06:26:31.339] commandTag = [06:26:31.339] cmdtagname = [06:26:31.339] querytree_list = [06:26:31.339] portal = 0x835d93100 [06:26:31.339] receiver = 0x835c6cf40 [06:26:31.339] parsetree_item__state = {l = 0x835c6cb30, i = 0} [06:26:31.339] msec_str = "\000\000\000\000\b", '\000' , "VD\372f\000\000\000\000\333\365N\243\354\fR@" [06:26:31.339] dest = DestRemote [06:26:31.339] was_logged = [06:26:31.339] oldcontext = 0x835d97000 [06:26:31.339] parsetree_list = 0x835c6cb30 [06:26:31.339] use_implicit_block = false [06:26:31.339] parsetree_item = 0x835c6cb48 [06:26:31.339] save_log_statement_stats = [06:26:31.339] #32 0x0000000000938443 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4791 [06:26:31.339] query_string = 0x835c6c100 "EXECUTE p2;" [06:26:31.339] input_message = {data = 0x835c6c100 "EXECUTE p2;", len = 12, maxlen = 1024, cursor = 12} [06:26:31.339] firstchar = [06:26:31.339] local_sigjmp_buf = {{_sjb = {9664742, 34918286912, 34918286872, 34918287456, 12387448, 1, 8192, 8388608, 34918237055, 0, 0, 1}}} [06:26:31.339] send_ready_for_query = false [06:26:31.339] idle_in_transaction_timeout_enabled = false [06:26:31.339] idle_session_timeout_enabled = false [06:26:31.339] #33 0x0000000000932c19 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:26:31.339] bsdata = [06:26:31.339] #34 0x000000000088c797 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x8214ad384 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214ad2c0) at ../src/backend/postmaster/launch_backend.c:274 [06:26:31.339] pid = [06:26:31.339] #35 0x0000000000890b68 in BackendStartup (client_sock=0x8214ad2c0) at ../src/backend/postmaster/postmaster.c:3420 [06:26:31.339] startup_data = {canAcceptConnections = CAC_OK} [06:26:31.339] bn = 0x835c788a8 [06:26:31.339] pid = [06:26:31.339] __error = [06:26:31.339] save_errno = [06:26:31.339] __error = [06:26:31.339] __error = [06:26:31.339] #36 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [06:26:31.339] s = {sock = 9, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\240\336\3065\b", '\000' , " \323J!\b\000\000\000h\225\360)\b\000\000\000\v\000\000\000\000\000\000\000^\037\361)\b", '\000' , "`\323J!\b\000\000\000Dň\000\000\000\000\000p\323J!\b", '\000' }, salen = 16}} [06:26:31.339] i = 0 [06:26:31.339] now = [06:26:31.339] events = {{pos = 3, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 902621176, events = 8, fd = 558551296, user_data = 0x0}, {pos = 0, events = 0, fd = -1044936294, user_data = 0x3a5ed65a130a}, {pos = 724469664, events = 8, fd = 724540792, user_data = 0x8214acd88}, {pos = 558550528, events = 8, fd = 558550408, user_data = 0x82b2f2f98}, {pos = 563872776, events = 8, fd = 724512664, user_data = 0x8214acdf0}, {pos = -698760134, events = 14942, fd = 558550480, user_data = 0xc}, {pos = 726403280, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 726331440, user_data = 0x1}, {pos = 558550608, events = 8, fd = -698739958, user_data = 0x82b2db858}, {pos = 724540792, events = 8, fd = 558550568, user_data = 0x8214acea0}, {pos = 558550568, events = 8, fd = 724503820, user_data = 0x8219c0408}, {pos = 724503820, events = 8, fd = 558550672, user_data = 0x3a5ed659c43a}, {pos = -299709009, events = 8, fd = 558550896, user_data = 0xbc1150 }, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = -1044936294, events = 1938055400, fd = 902676480, user_data = 0x8214aceb0}, {pos = 725666098, events = 8, fd = 558551112, user_data = 0x8219c5288}, {pos = 724416600, events = 8, fd = 563872776, user_data = 0x8214acf28}, {pos = 558551272, events = 8, fd = 558550800, user_data = 0x3a5ed65a0ca2}, {pos = 2702085, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 563896376, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558551528, user_data = 0x300901607}, {pos = 558551344, events = 8, fd = 563894440, user_data = 0x290}, {pos = 558551272, events = 8, fd = 558550824, user_data = 0x8214acf90}, {pos = -698741989, events = 14942, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x8219c6038}, {pos = 1, events = 8, fd = 563872776, user_data = 0x82b2db858}, {pos = 558551528, events = 3, fd = 558551344, user_data = 0x8214ad0e8}, {pos = 0, events = 0, fd = 656, user_data = 0x8214ad0a8}, {pos = 558551328, events = 8, fd = -698766617, user_data = 0x8219b9008}, {pos = 563844104, events = 8, fd = 563845128, user_data = 0x8219b9c08}, {pos = 563859464, events = 8, fd = 563860488, user_data = 0x8219bd808}, {pos = 563862536, events = 8, fd = 563863560, user_data = 0x8219be408}, {pos = 563865608, events = 8, fd = 563866632, user_data = 0x8219bf008}, {pos = 563868680, events = 8, fd = 563869704, user_data = 0x8219bfc08}, {pos = 563871752, events = 8, fd = 563872776, user_data = 0x8219c0808}, {pos = 563874824, events = 8, fd = 563875848, user_data = 0x8219c1408}, {pos = 563877896, events = 8, fd = 563878920, user_data = 0x8219c2008}, {pos = 563880968, events = 8, fd = 563881992, user_data = 0x8219c2c08}, {pos = 563888136, events = 8, fd = 563889160, user_data = 0x8219c4808}, {pos = 563891208, events = 8, fd = 563843080, user_data = 0x293b05}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8219c6038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558551528, events = 8, fd = 558550944, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 563896376, user_data = 0x1}, {pos = 563843080, events = 8, fd = 313, user_data = 0x8214ad1d0}, {pos = -698767889, events = 14942, fd = 2702085, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 563896376, user_data = 0x1}, {pos = 563872776, events = 8, fd = 902160384, user_data = 0x1}, {pos = 902160788, events = 8, fd = 0, user_data = 0x8214ad1a0}, {pos = 703665516, events = 8, fd = 1, user_data = 0x835c5e000}, {pos = 558551504, events = 8, fd = 703661826, user_data = 0x82b40d170 }, {pos = 12308368, events = 0, fd = 725668208, user_data = 0x8219c0408}, {pos = 558551728, events = 8, fd = -698768418, user_data = 0x835c7c800}, {pos = 1, events = 0, fd = -698768802, user_data = 0x8219b9008}, {pos = 558551512, events = 8, fd = 558551728, user_data = 0x1c20}, {pos = 902225568, events = 8, fd = -698689136, user_data = 0x0}, {pos = 558498687, events = 8, fd = 8110535, user_data = 0x8214ad260}, {pos = 703624208, events = 8, fd = 726331440, user_data = 0x82b4b1310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214ad290}, {pos = 703667101, events = 8, fd = 902160384, user_data = 0xad6f}, {pos = 558551792, events = 8, fd = 703633658, user_data = 0x0}, {pos = 0, events = 0, fd = -1044936294, user_data = 0x0}} [06:26:31.340] last_touch_time = 1727677506 [06:26:31.340] last_lockfile_recheck_time = 1727677506 [06:26:31.340] nevents = 1 [06:26:31.340] #37 0x000000000088e985 in PostmasterMain (argc=argc@entry=5, argv=argv@entry=0x8214ad8d8) at ../src/backend/postmaster/postmaster.c:1351 [06:26:31.340] userDoption = [06:26:31.340] listen_addr_saved = [06:26:31.340] output_config_variable = [06:26:31.340] opt = [06:26:31.340] status = [06:26:31.340] #38 0x00000000007c8eac in main (argc=5, argv=0x8214ad8d8) at ../src/backend/main/main.c:197 [06:26:31.340] do_check_root =