From: | "Erik Rijkers" <er(at)xs4all(dot)nl> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | testing HS/SR - invalid magic number |
Date: | 2010-04-14 00:34:09 |
Message-ID: | 4b8d8f816970c5f9c1fd1f4d3bc7c3bd.squirrel@webmail.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This replication test that was working well earlier (it ran daily), stopped working
after reinstall of new instances of cvs HEAD. I think the change must have been today (or at least
recent).
This test copies a schema from a 8.4.3 instance to the 9.0 primary:
pg_dump -c -h /tmp -p 5432 -n public --no-owner --no-privileges ms \
| psql -1qtA -h /tmp -p 7575 -d replicas
I tried it twice, with a complete reinstall from the cvs repository;
last one just now (created 20100414 0128), and once a few hours earlier.
-- logfile primary:
LOG: database system was shut down at 2010-04-14 02:15:01 CEST
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
2010-04-14 02:15:14 CEST 14756 start=2010-04-14 02:15:14 CEST LOG: database system was shut
down at 2010-04-14 02:15:12 CEST
2010-04-14 02:15:14 CEST 14752 start=2010-04-14 02:15:13 CEST LOG: database system is ready to
accept connections
2010-04-14 02:18:23 CEST 15100 [unknown] rijkers start=2010-04-14 02:18:22 CEST LOG: replication
connection authorized: user=rijkers host=127.0.0.1 port=55248
[...]
2010-04-14 02:21:10 CEST 15100 [unknown] rijkers start=2010-04-14 02:18:22 CEST FATAL: requested
WAL segment 000000010000000000000032 has already been removed
2010-04-14 02:21:11 CEST 15377 [unknown] rijkers start=2010-04-14 02:21:11 CEST LOG: replication
connection authorized: user=rijkers host=127.0.0.1 port=50869
2010-04-14 02:21:11 CEST 15377 [unknown] rijkers start=2010-04-14 02:21:11 CEST FATAL: requested
WAL segment 000000010000000000000032 has already been removed
2010-04-14 02:21:16 CEST 15384 [unknown] rijkers start=2010-04-14 02:21:16 CEST LOG: replication
connection authorized: user=rijkers host=127.0.0.1 port=50870
2010-04-14 02:21:16 CEST 15384 [unknown] rijkers start=2010-04-14 02:21:16 CEST FATAL: requested
WAL segment 000000010000000000000032 has already been removed
2010-04-14 02:21:21 CEST 15400 [unknown] rijkers start=2010-04-14 02:21:21 CEST LOG: replication
connection authorized: user=rijkers host=127.0.0.1 port=50871
2010-04-14 02:21:22 CEST 15400 [unknown] rijkers start=2010-04-14 02:21:21 CEST FATAL: requested
WAL segment 000000010000000000000032 has already been removed
2010-04-14 02:21:26 CEST 15406 [unknown] rijkers start=2010-04-14 02:21:26 CEST LOG: replication
connection authorized: user=rijkers host=127.0.0.1 port=50872
etc.
-- logfile standby:
2010-04-14 02:18:22 CEST 5598 start=2010-04-14 02:18:22 CEST LOG: database system was
interrupted; last known up at 2010-04-14 02:17:54 CEST
2010-04-14 02:18:22 CEST 5598 start=2010-04-14 02:18:22 CEST LOG: entering standby mode
cp: cannot stat `/var/data1/pg_stuff/dump/hotslave/replication_archive/000000010000000000000001':
No such file or directory
2010-04-14 02:18:23 CEST 5601 start=2010-04-14 02:18:22 CEST LOG: streaming replication
successfully connected to primary
2010-04-14 02:18:24 CEST 5598 start=2010-04-14 02:18:22 CEST LOG: redo starts at 0/1000020
2010-04-14 02:18:24 CEST 5598 start=2010-04-14 02:18:22 CEST LOG: consistent recovery state
reached at 0/2000000
2010-04-14 02:18:24 CEST 5597 start=2010-04-14 02:18:22 CEST LOG: database system is ready to
accept read only connections
2010-04-14 02:21:11 CEST 5601 start=2010-04-14 02:18:22 CEST FATAL: could not receive data from
WAL stream: FATAL: requested WAL segment 000000010000000000000032 has already been removed
cp: cannot stat `/var/data1/pg_stuff/dump/hotslave/replication_archive/000000010000000000000032':
No such file or directory
2010-04-14 02:21:11 CEST 5598 start=2010-04-14 02:18:22 CEST LOG: invalid magic number 0000 in
log file 0, segment 50, offset 13795328
cp: cannot stat `/var/data1/pg_stuff/dump/hotslave/replication_archive/000000010000000000000032':
No such file or directory
2010-04-14 02:21:11 CEST 5784 start=2010-04-14 02:21:11 CEST LOG: streaming replication
successfully connected to primary
2010-04-14 02:21:11 CEST 5784 start=2010-04-14 02:21:11 CEST FATAL: could not receive data from
WAL stream: FATAL: requested WAL segment 000000010000000000000032 has already been removed
cp: cannot stat `/var/data1/pg_stuff/dump/hotslave/replication_archive/000000010000000000000032':
No such file or directory
2010-04-14 02:21:11 CEST 5598 start=2010-04-14 02:18:22 CEST LOG: invalid magic number 0000 in
log file 0, segment 50, offset 13795328
cp: cannot stat `/var/data1/pg_stuff/dump/hotslave/replication_archive/000000010000000000000032':
No such file or directory
2010-04-14 02:21:16 CEST 5790 start=2010-04-14 02:21:16 CEST LOG: streaming replication
successfully connected to primary
2010-04-14 02:21:16 CEST 5790 start=2010-04-14 02:21:16 CEST FATAL: could not receive data from
WAL stream: FATAL: requested WAL segment 000000010000000000000032 has already been removed
cp: cannot stat `/var/data1/pg_stuff/dump/hotslave/replication_archive/000000010000000000000032':
No such file or directory
2010-04-14 02:21:16 CEST 5598 start=2010-04-14 02:18:22 CEST LOG: invalid magic number 0000 in
log file 0, segment 50, offset 13795328
cp: cannot stat `/var/data1/pg_stuff/dump/hotslave/replication_archive/000000010000000000000032':
No such file or directory
2010-04-14 02:21:21 CEST 5795 start=2010-04-14 02:21:21 CEST LOG: streaming replication
successfully connected to primary
2010-04-14 02:21:22 CEST 5795 start=2010-04-14 02:21:21 CEST FATAL: could not receive data from
WAL stream: FATAL: requested WAL segment 000000010000000000000032 has already been removed
etc.... that block of lines then endlessly repeats.
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Rijkers | 2010-04-14 00:51:42 | Re: testing HS/SR - invalid magic number |
Previous Message | Robert Haas | 2010-04-14 00:33:31 | Re: Remaining Streaming Replication Open Items |