From: | eshkinkot(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13010: After promote postgres try to send old timeline WALs to archive |
Date: | 2015-04-09 14:02:18 |
Message-ID: | 20150409140218.26383.3403@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13010
Logged by: Sergey Burladyan
Email address: eshkinkot(at)gmail(dot)com
PostgreSQL version: 9.2.10
Operating system: Slackware 14.1
Description:
Hello, I have a problem with WAL archiving after promote.
I do not use streaming, only WAL archive and after promote standby
it try to archive WALs with old timeline, but I already have it in
archive (from old master) and at new master WAL archiving stopped.
pg_xlog from standby before promote:
pg_xlog/
|-- 000000010000000000000014
|-- 000000010000000000000015
|-- 000000010000000000000016
|-- 000000010000000000000017
|-- 000000010000000000000018
|-- 000000010000000000000019
|-- 00000001000000000000001A
|-- 00000001000000000000001B
|-- 00000001000000000000001C
|-- 00000001000000000000001D
|-- 00000001000000000000001E
|-- 00000001000000000000001F
|-- 000000010000000000000020
|-- 000000010000000000000021
`-- archive_status
|-- 000000010000000000000014.done
|-- 000000010000000000000015.done
|-- 000000010000000000000016.done
|-- 000000010000000000000017.done
|-- 000000010000000000000018.done
|-- 000000010000000000000019.done
|-- 00000001000000000000001A.done
|-- 00000001000000000000001B.done
|-- 00000001000000000000001C.done
|-- 00000001000000000000001D.done
|-- 00000001000000000000001E.done
|-- 00000001000000000000001F.done
|-- 000000010000000000000020.done
`-- 000000010000000000000021.done
pg_xlog from standby after promote it:
pg_xlog/
|-- 000000010000000000000020
|-- 000000010000000000000021
|-- 000000010000000000000022
|-- 000000010000000000000023
|-- 000000010000000000000024
|-- 000000010000000000000025
|-- 000000010000000000000026
|-- 000000010000000000000027
|-- 00000002.history
|-- 000000020000000000000024
|-- 000000020000000000000025
|-- 000000020000000000000026
|-- 000000020000000000000027
|-- 000000020000000000000028
|-- 000000020000000000000029
|-- 00000002000000000000002A
|-- 00000002000000000000002B
|-- 00000002000000000000002C
`-- archive_status
|-- 000000010000000000000020.done
|-- 000000010000000000000021.done
|-- 000000010000000000000022.done
|-- 000000010000000000000023.done
|-- 000000010000000000000024.done
`-- 00000002.history.done
pg_xlog later after promote:
pg_xlog/
|-- 000000010000000000000025
|-- 000000010000000000000026
|-- 000000010000000000000027
|-- 00000002.history
|-- 000000020000000000000028
|-- 000000020000000000000029
|-- 00000002000000000000002A
|-- 00000002000000000000002B
|-- 00000002000000000000002C
|-- 00000002000000000000002D
|-- 00000002000000000000002E
|-- 00000002000000000000002F
|-- 000000020000000000000030
|-- 000000020000000000000031
|-- 000000020000000000000032
|-- 000000020000000000000033
|-- 000000020000000000000034
`-- archive_status
|-- 000000010000000000000025.ready
|-- 000000010000000000000026.ready
|-- 000000010000000000000027.ready
|-- 00000002.history.done
|-- 000000020000000000000028.done
|-- 000000020000000000000029.done
|-- 00000002000000000000002A.done
|-- 00000002000000000000002B.done
|-- 00000002000000000000002C.done
`-- 00000002000000000000002D.ready
now WAL archiving stopped with messages:
2015-04-08 20:49:31 MSK LOG: archive command failed with exit code 1
2015-04-08 20:49:31 MSK DETAIL: The failed archive command was: test ! -f
~/tmp/pg-slave-switch/w/000000010000000000000025 && cp
pg_xlog/000000010000000000000025
~/tmp/pg-slave-switch/w/000000010000000000000025
2015-04-08 20:49:32 MSK LOG: archive command failed with exit code 1
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Slavov | 2015-04-09 15:11:27 | Re: BUG #12910: Memory leak with logical decoding |
Previous Message | Jeff Davis | 2015-04-09 06:18:20 | Re: Failure to coerce unknown type to specific type |