Обсуждение: RE: [BUGS] Loosing files after backend crash

> > 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

"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
>> Hmm.  Maybe the WAL redo is messing things up??

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

I'm not convinced that any files have really been deleted.  Maybe it's
just that the pg_class entries are wrong, or even more likely that the
indexes on pg_class are messed up (pointing at the wrong pg_class rows).
        regards, tom lane