Re: switching txlog file in 7.1beta

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: switching txlog file in 7.1beta
Дата
Msg-id 009301c066ba$d9f77f80$b57a30d0@sectorbase.com
обсуждение исходный текст
Ответ на AW: switching txlog file in 7.1beta  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Ocasional problems !!!!
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: index support for arrays (GiST)