Re: Bug #514: Backend crashes periodically

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Warren Volz <wrv(at)po(dot)cwru(dot)edu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #514: Backend crashes periodically
Date: 2001-11-12 03:53:08
Message-ID: 737.1005537188@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Warren Volz <wrv(at)po(dot)cwru(dot)edu> writes:
> p debug_query_string output:

> $1 = 0x820caa0 "DELETE FROM session WHERE session_key =
> 'bRUjmnqcb5prUNRE.Bb0sq+fZB69dkdVlCAKNBsb'"

BTW, do you have rules or triggers on that table? The backtrace shows
the system executing a nestloop join, which implies at least a two-table
query, which says that there's more going on than meets the eye here.
It would be useful to see the full schema for this table and any related
tables, as well as an EXPLAIN VERBOSE for the above query.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Warren Volz 2001-11-12 04:20:20 Re: Bug #514: Backend crashes periodically
Previous Message Tom Lane 2001-11-12 02:03:03 Re: [BUGS] 7.2 doc comments