Hi,
${subject} happened while executing ${attached query} at regresssion
database, using 14dev (commit
d5a83d79c9f9b660a6a5a77afafe146d3c8c6f46) and produced ${attached
stack trace}.Sadly just loading the regression database and executing this query is not enough to reproduce. Not sure what else I can do to help with this one. -- Jaime Casanova Director de Servicios Profesionales SystemGuards - Consultores de PostgreSQL
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
set = {__val = {0, 140734235450160, 2, 6, 6456150, 94891112648656,
4611686018427388799, 140604537363110, 0, 281470681751457, 0, 0, 0, 0, 0, 0}}
pid = <optimized out>
tid = <optimized out>
ret = <optimized out>
#1 0x00007fe10b488535 in __GI_abort () at abort.c:79
save_stage = 1
act = {__sigaction_handler = {sa_handler = 0x3feb080000000000,
sa_sigaction = 0x3feb080000000000}, sa_mask = {__val = {0, 4605253854145256240,
0, 13781012405103410633, 0, 140604535119861, 2,
7220455706289059512, 7018409646405740088, 0, 7003723482445100592,
0, 3166617362634023936, 140734235450400, 684527088, 140734235451264}}, sa_flags
= 0, sa_restorer = 0x28cd0df0}
sigs = {__val = {32, 0 <repeats 15 times>}}
#2 0x0000564d8f7748be in ExceptionalCondition (conditionName=0x564d8f800559
"delstate->ndeltids > 0", errorType=0x564d8f7fe869 "FailedAssertion",
fileName=0x564d8f7fe948 "heapam.c", lineNumber=7220)
at assert.c:69
No locals.
#3 0x0000564d8f176825 in heap_index_delete_tuples (rel=0x7fe1022847c8,
delstate=0x7fff3e1ca120) at heapam.c:7220
latestRemovedXid = 0
blkno = 4294967295
buf = 0
page = 0x0
maxoff = 0
priorXmax = 2446144864
prefetch_state = {cur_hblkno = 4294967295, next_item = 0, ndeltids = 0,
deltids = 0x564d91cd3748}
prefetch_distance = 10
SnapshotNonVacuumable = {snapshot_type = SNAPSHOT_NON_VACUUMABLE, xmin
= 0, xmax = 2446145024, xip = 0x216, xcnt = 0, subxip = 0xffffffffffffffff,
subxcnt = 1042063264, suboverflowed = 255,
takenDuringRecovery = 127, copied = false, curcid = 1042063408,
speculativeToken = 32767, vistest = 0x564d8fab1c10 <GlobalVisDataRels>,
active_count = 2446145040, regd_count = 22093, ph_node = {
first_child = 0x7fff3e1ca070, next_sibling = 0x7fff3e1ca060,
prev_or_parent = 0x564d91ddda08}, whenTaken = 462, lsn = 18446744071860729372,
snapXactCompletionCount = 0}
finalndeltids = 0
nblocksaccessed = 0
nblocksfavorable = 0
curtargetfreespace = 0
lastfreespace = 0
actualfreespace = 0
bottomup_final_block = false
#4 0x0000564d8f195780 in table_index_delete_tuples (rel=0x7fe1022847c8,
delstate=0x7fff3e1ca120) at ../../../../src/include/access/tableam.h:1240
No locals.
#5 0x0000564d8f195e6a in index_compute_xid_horizon_for_tuples
(irel=0x564d924f6428, hrel=0x7fe1022847c8, ibuf=807, itemnos=0x7fff3e1ca190,
nitems=0) at genam.c:331
delstate = {bottomup = false, bottomupfreespace = 0, ndeltids = 0,
deltids = 0x564d91cd3748, status = 0x564d91cd3768}
latestRemovedXid = 0
ipage = 0x7fe102fc5f00 ""
itup = 0x7fff3e1ca630
#6 0x0000564d8f13e568 in gistprunepage (rel=0x564d924f6428,
page=0x7fe102fc5f00 "", buffer=807, heapRel=0x7fe1022847c8) at gist.c:1669
deletable = {1, 0, 0, 0, 46976, 37580, 22016, 0, 41520, 15900, 32767,
0, 42544, 15900, 32767, 0, 42752, 15900, 0, 0, 2674, 2890, 32737, 0, 1, 0,
25580, 15290, 41984, 48994, 5558, 11250, 42752, 15900,
32767, 0, 52880, 36628, 22093, 0, 46976, 37580, 22093, 0, 13728,
37325, 22093, 0, 32512, 765, 32737, 0, 25640, 37455, 22093, 0, 0, 0, 2, 0,
65535, 255, 0, 0, 41472, 15900, 32767, 0, 14468, 566,
32737, 0, 41536, 15900, 0, 256, 14468, 566, 32737, 0, 13736, 37325,
22093, 0, 25640, 37455, 22093, 0, 0, 0, 0, 0, 0, 512, 32737, 0, 41584, 15900,
32767, 0, 47989, 36700, 22093, 0, 41712, 15900, 0,
256, 14468, 566, 32737, 0, 41632, 15900, 32767, 0, 56219, 36700,
22093, 0, 0, 0, 0, 0, 14464, 566, 32737, 0, 0, 0, 3, 0, 21856, 174, 0, 8192,
41680, 15900, 32767, 0, 56472, 36700, 22093, 0, 11968,
37108, 22093, 0, 0, 0, 0, 0, 14480, 566, 32737, 0, 14464, 566, 32737,
0, 41712, 15900, 32767, 0, 54083, 36639, 22093, 0, 40672, 765, 32737, 0, 25640,
37455, 22093, 0, 0, 0, 0, 0, 0, 512, 32737, 0,
41776, 15900, 0, 256, 14468, 566, 32737, 0, 41776, 15900, 32767, 0,
47349, 36700, 22093, 0...}
ndeletable = 0
offnum = 292
maxoff = 291
latestRemovedXid = 0
#7 0x0000564d8f139e3e in gistplacetopage (rel=0x564d924f6428, freespace=0,
giststate=0x564d92ccb780, buffer=807, itup=0x7fff3e1ca6e0, ntup=1, oldoffnum=0,
newblkno=0x0, leftchildbuf=0,
splitinfo=0x7fff3e1ca690, markfollowright=true, heapRel=0x7fe1022847c8,
is_build=false) at gist.c:274
blkno = 4
page = 0x7fe102fc5f00 ""
is_leaf = true
recptr = 94891117474655
i = 32767
is_split = true
__func__ = "gistplacetopage"
#8 0x0000564d8f13d4ac in gistinserttuples (state=0x7fff3e1ca740,
stack=0x564d91cd36f0, giststate=0x564d92ccb780, tuples=0x7fff3e1ca6e0, ntup=1,
oldoffnum=0, leftchild=0, rightchild=0, unlockbuf=false,
unlockleftchild=false) at gist.c:1277
splitinfo = 0x0
is_split = false
#9 0x0000564d8f13d3f2 in gistinserttuple (state=0x7fff3e1ca740,
stack=0x564d91cd36f0, giststate=0x564d92ccb780, tuple=0x564d91cd35a0,
oldoffnum=0) at gist.c:1230
No locals.
#10 0x0000564d8f13c02c in gistdoinsert (r=0x564d924f6428, itup=0x564d91cd35a0,
freespace=0, giststate=0x564d92ccb780, heapRel=0x7fe1022847c8, is_build=false)
at gist.c:885
iid = 0x7fe102fd7f18
idxtuple = 0x7fe102fd9ed8
firststack = {blkno = 0, buffer = 816, page = 0x7fe102fd7f00 "", lsn =
684527088, retry_from_parent = false, downlinkoffnum = 0, parent = 0x0}
stack = 0x564d91cd36f0
state = {r = 0x564d924f6428, heapRel = 0x7fe1022847c8, freespace = 0,
is_build = false, stack = 0x564d91cd36f0}
xlocked = true
__func__ = "gistdoinsert"
#11 0x0000564d8f139ab6 in gistinsert (r=0x564d924f6428, values=0x7fff3e1ca900,
isnull=0x7fff3e1ca8e0, ht_ctid=0x564d922fabe0, heapRel=0x7fe1022847c8,
checkUnique=UNIQUE_CHECK_NO, indexUnchanged=false,
indexInfo=0x564d922f9678) at gist.c:182
giststate = 0x564d92ccb780
itup = 0x564d91cd35a0
oldCxt = 0x564d9219d980
#12 0x0000564d8f196ccc in index_insert (indexRelation=0x564d924f6428,
values=0x7fff3e1ca900, isnull=0x7fff3e1ca8e0, heap_t_ctid=0x564d922fabe0,
heapRelation=0x7fe1022847c8, checkUnique=UNIQUE_CHECK_NO,
indexUnchanged=false, indexInfo=0x564d922f9678) at indexam.c:193
__func__ = "index_insert"
#13 0x0000564d8f3a42d9 in ExecInsertIndexTuples (resultRelInfo=0x564d9219f6c8,
slot=0x564d922fabb0, estate=0x564d9219daa0, update=true, noDupErr=false,
specConflict=0x0, arbiterIndexes=0x0)
at execIndexing.c:425
applyNoDupErr = false
checkUnique = UNIQUE_CHECK_NO
indexRelation = 0x564d924f6428
indexInfo = 0x564d922f9678
indexUnchanged = false
satisfiesConstraint = false
tupleid = 0x564d922fabe0
result = 0x0
i = 0
numIndices = 1
relationDescs = 0x564d922f9d00
heapRelation = 0x7fe1022847c8
indexInfoArray = 0x564d922f9d20
econtext = 0x564d923a51f0
values = {94891165070112, 140604394414004, 140604394413824,
103079215905, 0, 0, 94891165070240, 0, 74016213477824, 94888713569568, 0,
1099511627998, 40, 94891165068208, 17179880169, 94891165070064, 0,
2403045067, 0, 0, 140734235453952, 94891113177498, 140734235454192,
140734235454188, 0, 94891164426080, 1, 94891165068208, 140734235454386,
140604380563400, 3124296, 94891165070064}
isnull = {false, 113, 205, 40, false, false, false, false, 80, 113,
205, 40, false, false, false, false, 20, false, false, false, false, false,
false, false, 28, 179, 47, 146, 77, 86, false, false}
#14 0x0000564d8f3e924f in ExecUpdate (mtstate=0x564d9219f490,
resultRelInfo=0x564d9219f6c8, tupleid=0x7fff3e1cabb2, oldtuple=0x0,
slot=0x564d922fabb0, planSlot=0x564d922f9f88, epqstate=0x564d9219f588,
estate=0x564d9219daa0, canSetTag=true) at nodeModifyTable.c:1634
lockmode = LockTupleNoKeyExclusive
partition_constraint_failed = false
update_indexes = true
resultRelationDesc = 0x7fe1022847c8
result = TM_Ok
tmfd = {ctid = {ip_blkid = {bi_hi = 40840, bi_lo = 37423}, ip_posid =
22093}, xmax = 2452591880, cmax = 22093, traversed = 88}
recheckIndexes = 0x0
__func__ = "ExecUpdate"
#15 0x0000564d8f3ea2c8 in ExecModifyTable (pstate=0x564d9219f490) at
nodeModifyTable.c:2254
node = 0x564d9219f490
estate = 0x564d9219daa0
operation = CMD_UPDATE
resultRelInfo = 0x564d9219f6c8
subplanstate = 0x564d922f9560
junkfilter = 0x564d922f9508
slot = 0x564d922fabb0
planSlot = 0x564d922f9f88
tupleid = 0x7fff3e1cabb2
tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 24}, ip_posid = 40}
oldtupdata = {t_len = 88, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 0},
ip_posid = 16}, t_tableOid = 8, t_data = 0x564d92e8d2a0}
oldtuple = 0x0
proute = 0x0
relinfos = 0x0
lc = 0x564d91eb4620
__func__ = "ExecModifyTable"
#16 0x0000564d8f3a5ce9 in ExecProcNode (node=0x564d9219f490) at
../../../src/include/executor/executor.h:247
No locals.
#17 0x0000564d8f3a8645 in ExecutePlan (estate=0x564d9219daa0,
planstate=0x564d9219f490, use_parallel_mode=false, operation=CMD_UPDATE,
sendTuples=true, numberTuples=0, direction=ForwardScanDirection,
dest=0x564d92cf6808, execute_once=true) at execMain.c:1542
slot = 0x564d922fa4b8
current_tuple_count = 4661
#18 0x0000564d8f3a634a in standard_ExecutorRun (queryDesc=0x564d91d62cc0,
direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:364
estate = 0x564d9219daa0
operation = CMD_UPDATE
dest = 0x564d92cf6808
sendTuples = true
oldcontext = 0x564d92cf64d0
__func__ = "standard_ExecutorRun"
#19 0x0000564d8f3a6160 in ExecutorRun (queryDesc=0x564d91d62cc0,
direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:308
No locals.
#20 0x0000564d8f5e7b97 in ProcessQuery (plan=0x564d92d94c00,
sourceText=0x564d90f096f0 "update public.test_range_gist set \n ir =
public.test_range_gist.ir\nreturning \n pg_catalog.pg_dependencies_out(\n
cast(pg_catalog.pg_dependencies_in(\n cast(cast(null as cstring) as
cstring)) a"..., params=0x0, queryEnv=0x0, dest=0x564d92cf6808,
qc=0x7fff3e1cae30) at pquery.c:160
queryDesc = 0x564d91d62cc0
#21 0x0000564d8f5e9554 in PortalRunMulti (portal=0x564d92cd77f8,
isTopLevel=true, setHoldSnapshot=true, dest=0x564d92cf6808,
altdest=0x564d8fa834e0 <donothingDR>, qc=0x7fff3e1cae30) at pquery.c:1267
pstmt = 0x564d92d94c00
stmtlist_item__state = {l = 0x564d92d94c98, i = 0}
active_snapshot_set = true
stmtlist_item = 0x564d92d94cb0
#22 0x0000564d8f5e9072 in FillPortalStore (portal=0x564d92cd77f8,
isTopLevel=true) at pquery.c:1014
treceiver = 0x564d92cf6808
qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0}
__func__ = "FillPortalStore"
#23 0x0000564d8f5e8a21 in PortalRun (portal=0x564d92cd77f8,
count=9223372036854775807, isTopLevel=true, run_once=true, dest=0x564d92d94cf0,
altdest=0x564d92d94cf0, qc=0x7fff3e1cb000) at pquery.c:751
_save_exception_stack = 0x7fff3e1cb110
_save_context_stack = 0x0
_local_sigjmp_buf = {{__jmpbuf = {0, -2666701550760200971,
94891112648656, 140734235457072, 0, 0, -2666701550716160779,
-8531898426349292299}, __mask_was_saved = 0, __saved_mask = {__val = {
19586897912, 94891176185048, 128, 94891144156624,
94891175535824, 140734235455328, 21256, 94891159202944, 94891176173536,
140734235455360, 94891119671956, 109, 112, 94891176185184, 112,
1042067344}}}}
_do_rethrow = false
result = false
nprocessed = 94891176185072
saveTopTransactionResourceOwner = 0x564d90f3eb40
saveTopTransactionContext = 0x564d9225dd70
saveActivePortal = 0x0
saveResourceOwner = 0x564d90f3eb40
savePortalContext = 0x0
saveMemoryContext = 0x564d9225dd70
__func__ = "PortalRun"
#24 0x0000564d8f5e2632 in exec_simple_query (
query_string=0x564d90f096f0 "update public.test_range_gist set \n ir =
public.test_range_gist.ir\nreturning \n pg_catalog.pg_dependencies_out(\n
cast(pg_catalog.pg_dependencies_in(\n cast(cast(null as cstring) as
cstring)) a"...) at postgres.c:1240
snapshot_set = true
per_parsetree_context = 0x0
plantree_list = 0x564d92d94c98
parsetree = 0x564d92d4c358
commandTag = CMDTAG_UPDATE
qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0}
querytree_list = 0x564d923b42d8
portal = 0x564d92cd77f8
receiver = 0x564d92d94cf0
format = 0
parsetree_item__state = {l = 0x564d92d4c390, i = 0}
dest = DestRemote
oldcontext = 0x564d9225dd70
parsetree_list = 0x564d92d4c390
parsetree_item = 0x564d92d4c3a8
save_log_statement_stats = false
was_logged = false
use_implicit_block = false
msec_str =
"\021\000\000\000\002\000\000\000\003\002\000\000\000\000\000\000\360\226\360\220MV\000\000\375\001\000\000\006\000\000"
__func__ = "exec_simple_query"
#25 0x0000564d8f5e6b51 in PostgresMain (argc=1, argv=0x7fff3e1cb290,
dbname=0x564d90f3cea0 "regression", username=0x564d90f3ce78 "jcasanov") at
postgres.c:4394
query_string = 0x564d90f096f0 "update public.test_range_gist set \n ir
= public.test_range_gist.ir\nreturning \n pg_catalog.pg_dependencies_out(\n
cast(pg_catalog.pg_dependencies_in(\n cast(cast(null as cstring) as
cstring)) a"...
firstchar = 81
input_message = {
data = 0x564d90f096f0 "update public.test_range_gist set \n ir =
public.test_range_gist.ir\nreturning \n pg_catalog.pg_dependencies_out(\n
cast(pg_catalog.pg_dependencies_in(\n cast(cast(null as cstring) as
cstring)) a"..., len = 510, maxlen = 1024, cursor = 510}
local_sigjmp_buf = {{__jmpbuf = {0, -2666701549776636683,
94891112648656, 140734235457072, 0, 0, -2666701549722110731,
-8531898433799949067}, __mask_was_saved = 1, __saved_mask = {__val = {0, 0, 0,
0,
0, 0, 0, 33022, 14935519656805164164, 0, 1099511627520, 0, 0,
4294901760, 18446462598732840960, 0}}}}
send_ready_for_query = false
idle_in_transaction_timeout_enabled = false
idle_session_timeout_enabled = false
__func__ = "PostgresMain"
#26 0x0000564d8f526331 in BackendRun (port=0x564d90f2e980) at postmaster.c:4484
av = {0x564d8f916ccf "postgres", 0x0}
ac = 1
#27 0x0000564d8f525c60 in BackendStartup (port=0x564d90f2e980) at
postmaster.c:4206
bn = 0x564d90f28ef0
pid = 0
__func__ = "BackendStartup"
#28 0x0000564d8f522081 in ServerLoop () at postmaster.c:1730
port = 0x564d90f2e980
i = 1
rmask = {fds_bits = {64, 0 <repeats 15 times>}}
selres = 1
now = 1611724924
readmask = {fds_bits = {224, 0 <repeats 15 times>}}
nSockets = 8
last_lockfile_recheck_time = 1611724886
last_touch_time = 1611724286
__func__ = "ServerLoop"
#29 0x0000564d8f5218d0 in PostmasterMain (argc=3, argv=0x564d90f03d50) at
postmaster.c:1402
opt = -1
status = 0
userDoption = 0x564d90f26570 "data"
listen_addr_saved = true
i = 64
output_config_variable = 0x0
__func__ = "PostmasterMain"
#30 0x0000564d8f4209a7 in main (argc=3, argv=0x564d90f03d50) at main.c:209
do_check_root = true
update public.test_range_gist set
ir = public.test_range_gist.ir
returning
pg_catalog.pg_dependencies_out(
cast(pg_catalog.pg_dependencies_in(
cast(cast(null as cstring) as cstring)) as pg_dependencies)) as c0,
(select b from public.rtest_order2 limit 1 offset 2)
as c1,
public.test_range_gist.ir as c2,
public.test_range_gist.ir as c3,
public.test_range_gist.ir as c4,
public.test_range_gist.ir as c5,
public.test_range_gist.ir as c6,
public.test_range_gist.ir as c7
query.sql
Description: application/sql
