Skip site navigation (1) Skip section navigation (2)

BUG #2491: Database crash and restart

From: "" <wizard580(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2491: Database crash and restart
Date: 2006-06-23 00:42:16
Message-ID: 200606230042.k5N0gGt5002849@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2491
Logged by:          
Email address:      wizard580(at)gmail(dot)com
PostgreSQL version: 8.1.4
Operating system:   Debian sid unstable
Description:        Database crash and restart
Details: 

Situation:
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.

Responses

pgsql-bugs by date

Next:From: wizard580Date: 2006-06-23 01:14:03
Subject: BUG #2492: "unexpected EOF on client connection" message in log
Previous:From: Tom LaneDate: 2006-06-23 00:23:46
Subject: Re: BUG #2486: PANIC when CTRL-C on vacuum full analyze

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group