Re: switching txlog file in 7.1beta - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: switching txlog file in 7.1beta
Date
Msg-id 009301c066ba$d9f77f80$b57a30d0@sectorbase.com
Whole thread Raw
In response to AW: switching txlog file in 7.1beta  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
> REDO @ 0/327312; LSN 0/327560: prev 0/327064; xprev 0/327064; xid 594: Heap - insert: node 1
> 8719/18720; cid 0; tid 0/18
> DEBUG:  ReadRecord: there is no subrecord flag in logfile 0 seg 0 off 40
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> DEBUG:  Formatting logfile 0 seg 0 block 39 at offset 8072
> DEBUG:  The last logId/logSeg is (0, 0)
> DEBUG:  Set logId/logSeg in control file
> DEBUG:  redo done at (0, 327312)
> XLogFlush: rqst 0/0; wrt 0/327560; flsh 0/327560
> ...........
> INSERT @ 0/327560: prev 0/327312; xprev 0/0; xid 0: XLOG - checkpoint: redo 0/327560; undo 0/0; sui 21; xid 595; oid
26911;
shutdown
> XLogFlush: rqst 0/327616; wrt 0/327560; flsh 0/327560
> DEBUG:  database system is in production state
>
> Seems ReadRecord should switch to seg 1 above and not 0.
> Then txlog file 0000001 somehow gets deleted.

Something wrong was written into seg 0. ReadRecord assumes that this is end of log and
so removes anything after this place (and seg 1 too, of course).
It doesn't look like related to txlog switching. Something bad in XLogInsert/XLogWrite.
Thanks.

Vadim




pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Ocasional problems !!!!
Next
From: Oleg Bartunov
Date:
Subject: Re: index support for arrays (GiST)