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

From Mikheev, Vadim
Subject RE: [BUGS] Loosing files after backend crash
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D336A@sectorbase1.sectorbase.com
Whole thread Raw
Responses Re: [BUGS] Loosing files after backend crash  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > 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??

It could mess up pg_class content, but it never deletes
files (currently).

Vadim


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Final call for platform testing
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] Loosing files after backend crash