unexpected pageaddr error in db log

From: wd <wd(at)wdicc(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: unexpected pageaddr error in db log
Date: 2013-12-19 03:25:48
Message-ID: CABexzmj7iKXUXn+LEKp2XEUOKjOrjACBhOybHPmQ486+AxFd=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

We have upgrade our database from PostgreSQL 9.2.4 to 9.3.2, use dump &
restore in a fresh db created by initdb.

Then use pg_basebackup created 2 slave db, the error occur when start the
database.

db1

[ 2013-12-19 04:00:56.882 CST 17956 52b1fef8.4624 1 0]LOG:
database system was interrupted; last known up at 2013-12-19 03:54:05
CST
[ 2013-12-19 04:00:56.883 CST 17956 52b1fef8.4624 2 0]LOG:
entering standby mode
[ 2013-12-19 04:00:57.395 CST 17956 52b1fef8.4624 3 0]LOG:
restored log file "00000001000000040000001D" from archive
[ 2013-12-19 04:00:57.415 CST 17956 52b1fef8.4624 4 0]LOG: redo
starts at 4/1D000028
[ 2013-12-19 04:00:57.923 CST 17956 52b1fef8.4624 5 0]LOG:
restored log file "00000001000000040000001E" from archive
[ 2013-12-19 04:00:57.933 CST 17956 52b1fef8.4624 6 0]LOG:
consistent recovery state reached at 4/1E012088
[ 2013-12-19 04:00:57.933 CST 17948 52b1fef8.461c 4 0]LOG:
database system is ready to accept read only connections [
2013-12-19 04:00:58.078 CST 17956 52b1fef8.4624 7 0]LOG: unexpected
pageaddr 3/2B000000 in log segment 00000001000000040000001F, offset 0
[ 2013-12-19 04:00:58.084 CST 17969 52b1fefa.4631 1 0]LOG: started
streaming WAL from primary at 4/1F000000 on timeline 1

db2

[ 2013-12-19 04:14:20.366 CST 18340 52b2021c.47a4 1 0]LOG:
database system was interrupted; last known up at 2013-12-19 04:07:43
CST
[ 2013-12-19 04:14:20.367 CST 18340 52b2021c.47a4 2 0]LOG:
entering standby mode
[ 2013-12-19 04:14:20.870 CST 18340 52b2021c.47a4 3 0]LOG:
restored log file "000000010000000400000021" from archive
[ 2013-12-19 04:14:20.881 CST 18340 52b2021c.47a4 4 0]LOG: redo
starts at 4/21000028
[ 2013-12-19 04:14:21.648 CST 18340 52b2021c.47a4 5 0]LOG:
restored log file "000000010000000400000022" from archive
[ 2013-12-19 04:14:22.415 CST 18340 52b2021c.47a4 6 0]LOG:
restored log file "000000010000000400000023" from archive
[ 2013-12-19 04:14:23.061 CST 18340 52b2021c.47a4 7 0]LOG:
restored log file "000000010000000400000024" from archive
[ 2013-12-19 04:14:23.831 CST 18340 52b2021c.47a4 8 0]LOG:
restored log file "000000010000000400000025" from archive
[ 2013-12-19 04:14:24.598 CST 18340 52b2021c.47a4 9 0]LOG:
restored log file "000000010000000400000026" from archive
[ 2013-12-19 04:14:25.365 CST 18340 52b2021c.47a4 10 0]LOG:
restored log file "000000010000000400000027" from archive
[ 2013-12-19 04:14:26.093 CST 18340 52b2021c.47a4 11 0]LOG:
restored log file "000000010000000400000028" from archive
[ 2013-12-19 04:14:26.857 CST 18340 52b2021c.47a4 12 0]LOG:
restored log file "000000010000000400000029" from archive
[ 2013-12-19 04:14:27.592 CST 18340 52b2021c.47a4 13 0]LOG:
restored log file "00000001000000040000002A" from archive
[ 2013-12-19 04:14:28.355 CST 18340 52b2021c.47a4 14 0]LOG:
restored log file "00000001000000040000002B" from archive
[ 2013-12-19 04:14:29.077 CST 18340 52b2021c.47a4 15 0]LOG:
restored log file "00000001000000040000002C" from archive
[ 2013-12-19 04:14:29.843 CST 18340 52b2021c.47a4 16 0]LOG:
restored log file "00000001000000040000002D" from archive
[ 2013-12-19 04:14:30.564 CST 18340 52b2021c.47a4 17 0]LOG:
restored log file "00000001000000040000002E" from archive
[ 2013-12-19 04:14:31.319 CST 18340 52b2021c.47a4 18 0]LOG:
restored log file "00000001000000040000002F" from archive
[ 2013-12-19 04:14:32.071 CST 18340 52b2021c.47a4 19 0]LOG:
restored log file "000000010000000400000030" from archive
[ 2013-12-19 04:14:32.923 CST 18340 52b2021c.47a4 20 0]LOG:
restored log file "000000010000000400000031" from archive
[ 2013-12-19 04:14:33.587 CST 18340 52b2021c.47a4 21 0]LOG:
restored log file "000000010000000400000032" from archive
[ 2013-12-19 04:14:33.909 CST 18340 52b2021c.47a4 22 0]LOG:
consistent recovery state reached at 4/32CCAA88
[ 2013-12-19 04:14:33.909 CST 18332 52b2021c.479c 4 0]LOG:
database system is ready to accept read only connections[
2013-12-19 04:14:34.059 CST 18340 52b2021c.47a4 23 0]LOG: unexpected
pageaddr 3/5A000000 in log segment 000000010000000400000033, offset 0
[ 2013-12-19 04:14:34.065 CST 18431 52b2022a.47ff 1 0]LOG: started
streaming WAL from primary at 4/33000000 on timeline 1

Both db1 and db2 are working properly, so what's the error mean? Is this a
bug?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2013-12-19 05:25:12 Re: Multi Master Replication
Previous Message Joe Conway 2013-12-18 23:45:00 Re: Question(s) about crosstab