[Pgpool-general] pitr errors

[louis fridkis]

I am testing PITR, following the instructions in: "23.3.3. Recovering with
an On-line Backup." In step 9 I inspect the database and find that it is
working perfectly. All the data from the original is present and I am able
to create a new table and insert rows. The problem is that there are errors
in the log as follows:

########################################
...
2009-09-23 13:32:32 PDT::@[11675]:LOG:  restored log file
"00000003000000EF000000A5" from archive
cp: cannot stat
`/home/postgres/data/pnp/pgsql8.3.3/mnt/data/pns/pgsql8.3.3/archive_log/00000003000000EF000000A6':
No such file or directory
2009-09-23 13:32:32 PDT::@[11675]:LOG:  record with zero length at
EF/A6000560
2009-09-23 13:32:32 PDT::@[11675]:LOG:  redo done at EF/A6000530
2009-09-23 13:32:32 PDT::@[11675]:LOG:  last completed transaction was at
log time 2009-09-23 13:32:51.364195-07
cp: cannot stat
`/home/postgres/data/pnp/pgsql8.3.3/mnt/data/pns/pgsql8.3.3/archive_log/00000003000000EF000000A6':
No such file or directory
cp: cannot stat
`/home/postgres/data/pnp/pgsql8.3.3/mnt/data/pns/pgsql8.3.3/archive_log/00000004.history':
No such file or directory
2009-09-23 13:32:32 PDT::@[11675]:LOG:  selected new timeline ID: 4
2009-09-23 13:32:32 PDT::@[11675]:LOG:  restored log file "00000003.history"
from archive
2009-09-23 13:32:32 PDT::@[11675]:LOG:  archive recovery complete
2009-09-23 13:32:32 PDT::@[11675]:LOG:  checkpoint starting: shutdown
immediate
2009-09-23 13:32:33 PDT::@[11675]:LOG:  checkpoint complete: wrote 824
buffers (2.5%); 0 transaction log file(s) added, 0 removed, 0 recycled;
write=0.010 s, sync=0.336 s, total=0.356 s
2009-09-23 13:32:33 PDT::@[11759]:LOG:  autovacuum launcher started
2009-09-23 13:32:33 PDT::@[11673]:LOG:  database system is ready to accept
connections
########################################

When I check the WAL file directories I find that all is in order. The file
00000004.history does not exist, but it is not supposed to exist. The file
00000003000000EF000000A6 is not in the backup archive (archive_log) because
it had not been moved there yet at the time I did the pitr. It is in the
current archive (pg_xlog), where it should be. Here is a listing of those
directories:

########################################
> ls archive_log/
...
00000003000000A100000024.0001F538.backup
00000003000000EE00000097                  00000003000000EF000000A2
00000003000000A1000000B5.0001B730.backup
00000003000000EE00000098                  00000003000000EF000000A3
00000003000000A200000047.0001EE70.backup
00000003000000EE00000099                  00000003000000EF000000A4
00000003000000A2000000D8.0001B938.backup
00000003000000EE0000009A                  00000003000000EF000000A5
00000003000000A30000006A.00020230.backup
00000003000000EE0000009B                  00000003.history
ls ../archive_log/*history
../archive_log/00000002.history  ../archive_log/00000003.history
> ls ../pg_xlog/
00000002.history                          00000003000000EF000000A6
00000003000000EF000000A9  00000003000000EF000000AC
00000003000000EF0000005D.000000D8.backup  00000003000000EF000000A7
00000003000000EF000000AA  00000003.history
00000003000000EF000000A5                  00000003000000EF000000A8
00000003000000EF000000AB  archive_status
> ls ../pg_xlog/*
../pg_xlog/00000002.history
../pg_xlog/00000003000000EF000000A7  ../pg_xlog/00000003000000EF000000AB
../pg_xlog/00000003000000EF0000005D.000000D8.backup
../pg_xlog/00000003000000EF000000A8  ../pg_xlog/00000003000000EF000000AC
../pg_xlog/00000003000000EF000000A5
../pg_xlog/00000003000000EF000000A9  ../pg_xlog/00000003.history
../pg_xlog/00000003000000EF000000A6
../pg_xlog/00000003000000EF000000AA

../pg_xlog/archive_status:
00000002.history.done  00000003000000EF0000005D.000000D8.backup.done
00000003000000EF000000A5.done  00000003.history.done
########################################
So, my question is, can I ignore these error messages and assume that the
pitr worked and all is fine?

Lou ...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090923/d87b2b8b/attachment.html>