Following up on the problem, here's a psql session that crashed:

access=> begin;
BEGIN
access=> SELECT Seq, NAS, SessionID, COUNT(*), MIN(ID) AS ID
access->       INTO TEMP T1
access->       FROM Session
access->       WHERE Account = '72638'
access->       GROUP BY Seq, NAS, SessionID;
SELECT
access=> DELETE
access->       FROM T1
access->       WHERE Count = 1;
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally before or
while processing the request.
We have lost the connection to the backend, so further processing is
impossible.  Terminating.


If I don't put it in a transaction it doesn't crash. If I don't use TEMP
it doesn't crash.

This is the one I sent a backtrace of yesterday, the one crashing in
nocachegetattr().

Thanks,
Anto.

Reply via email to