The following bug has been logged online:
Bug reference: 2491
Email address: wizard580(at)gmail(dot)com
PostgreSQL version: 8.1.4
Operating system: Debian sid unstable
Description: Database crash and restart
I have running transaction which makes a frequently calls to a pl/pgSQL
functions via several triggers. All in one transaction. Transaction running
for a 30 sec - 1 min time longs. Then I have a file with this functions.
CREATE OR REPLACE FUNCTION ........
I made this: cat <my_file> | psql <base> -U postgres
SQL server crashed.
When no transaction active, all fine.
I can not wait a transaction to finish, because it may begin again
immediately, and again, and again. Untill "system" decided to make some
waiting for a some event.
pgsql-bugs by date
|Next:||From: wizard580||Date: 2006-06-23 01:14:03|
|Subject: BUG #2492: "unexpected EOF on client connection" message in log|
|Previous:||From: Tom Lane||Date: 2006-06-23 00:23:46|
|Subject: Re: BUG #2486: PANIC when CTRL-C on vacuum full analyze |