Re: bug or simply not enough stack space? - Mailing list pgsql-bugs

From Frank van Vugt
Subject Re: bug or simply not enough stack space?
Date
Msg-id 200907162142.13220.ftm.van.vugt@foxi.nl
Whole thread Raw
In response to Re: bug or simply not enough stack space?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hi Tom,

> >> Those are bugs (although there is probably only one bug and the rest is
> >> collateral damage).  May we have a test case?
> >
> > Scripts, triggers and stuff are a bit complex, before assigning the
> > resources for that, could we help with creating a backtrace?
>
> You did show a backtrace --- it proves only what was already obvious,
> namely that the problem is in transaction cleanup.

Bummer, this is not going to work.... ;(

I've been trying to mimic the structure of tables, after en deferred triggers
and corresponding inserts/updates, but I'm still unsuccesfull. On our
development database I confirmed that it's safepoint related, but that was
kind of obvious from the error as well.

Can you think of another way for me to for example get more information out of
the problemcase that I _can_ reproduce? It would for example help if I could
get a clue on what table is involved with the problematic tuples. I could
easily add extra debug/log statements to the locations these errors come from,
but would appreciate a hint as to what to add exactly ;)




--
Best,




Frank.

pgsql-bugs by date:

Previous
From: "Juan C. Aragon"
Date:
Subject: FATAL: could not reattach to shared memory (key=268, addr=01E30000): 487
Next
From: "Roman Kononov"
Date:
Subject: BUG #4926: too few pathkeys for mergeclauses