Re: [BUGS] Loosing files after backend crash - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [BUGS] Loosing files after backend crash
Date
Msg-id 4689.986315647@sss.pgh.pa.us
Whole thread Raw
In response to RE: [BUGS] Loosing files after backend crash  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> Some more input from Konstantin (his answer to my message bounced
> from bug-list -:)):

> How much time passed after sequence creation till crash?
>> 
>> About 5-10 seconds. I opened a transaction, created a sequence,
>> created a temporary table with one column having NEXTVAL(seq) as
>   ^^^^^^^^^^^^^^^^^^^^^^^^^
>> default, inserted some data into the table, committed the transaction.
>> After that I ran my function, which crashed the backend after 
>> 3-4 seconds of work.

Hmm.  Maybe the WAL redo is messing things up??
        regards, tom lane


pgsql-hackers by date:

Previous
From: Fredrik Hultkrantz
Date:
Subject: International characters and the jdbcdriver
Next
From: "Maurizio"
Date:
Subject: Re: QNX : POSSIBLE BUG IN CONFIGURE ?