Re: switching txlog file in 7.1beta

From: "Vadim Mikheev" <vmikheev(at)sectorbase(dot)com>
To: "Zeugswetter Andreas SB" <ZeugswetterA(at)wien(dot)spardat(dot)at>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: switching txlog file in 7.1beta
Date: 2000-12-15 17:17:06
Message-ID: 009301c066ba$d9f77f80$b57a30d0@sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2000-12-15 17:17:47 Re: Ocasional problems !!!!
Previous Message Manika dey 2000-12-15 16:36:08 Trigger