From: | Fabio Milano <fmilano(at)crdsgroup(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Standby Server Bus 7 error |
Date: | 2014-07-24 03:53:04 |
Message-ID: | ef43d4db8b7c4a728b41ae03e5722ecf@DM2PR07MB624.namprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Any assistance in interpreting the logs is much appreciated.
Replication server crashes. Below is snippet from log.
2014-07-22 23:36:23 EDT LOG: started streaming WAL from pr
imary at 12/B0000000 on timeline 1
2014-07-22 23:43:12 EDT FATAL: could not receive data from
WAL stream: server closed the connection unexpectedly
This probably means the server terminated a
bnormally
before or while processing the request.
cp: cannot stat '/var/lib/postgresql/archive/00000001000000
12000000D0': No such file or directory
2014-07-22 23:43:12 EDT LOG: unexpected pageaddr 12/8D0000
00 in log segment 0000000100000012000000D0, offset 0
2014-07-22 23:43:28 EDT LOG: restored log file "0000000100
000012000000D0" from archive
cp: cannot stat '/var/lib/postgresql/archive/00000001000000
12000000D1': No such file or directory
2014-07-22 23:43:28 EDT LOG: unexpected pageaddr 12/A50000
00 in log segment 0000000100000012000000D1, offset 0
2014-07-22 23:43:28 EDT LOG: started streaming WAL from primary at 12/D1000000 on timeline 1
2014-07-22 23:53:13 EDT FATAL: could not receive data from WAL stream: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
cp: cannot stat '/var/lib/postgresql/archive/0000000100000012000000F1': No such file or directory
2014-07-22 23:53:13 EDT LOG: unexpected pageaddr 12/AA000000 in log segment 0000000100000012000000F1, offset 0
2014-07-22 23:53:13 EDT LOG: started streaming WAL from primary at 12/F1000000 on timeline 1
Upon trying a /etc/init.d/postgresql restart
2014-07-23 14:47:55 EDT LOG: restored log file "0000000 00001B0000001D" from archive
2014-07-23 14:47:55 EDT LOG: consistent recovery state ched at 1B/1DFC64C0
2014-07-23 14:47:55 EDT LOG: database system is ready t ccept read only connections
2014-07-23 14:47:55 EDT LOG: restored log file "0000000 00001B0000001E" from archive
2014-07-23 14:47:56 EDT LOG: startup process (PID 730) terminated by signal 7: Bus error
2014-07-23 14:47:56 EDT LOG: terminating any other acti server processes
Recovery.conf
restore_command = 'cp /var/lib/postgresql/archive/%f %p'
standby_mode = 'on'
primary_conninfo = 'host=[ipaddress] port=5432 user=sherweb_standby_server sslmode=require'
archive_cleanup_command = '/usr/lib/postgresql/9.3/bin/pg_archivecleanup /var/lib/postgresql/9.3/archive/ %r'
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2014-07-24 04:42:32 | Re: What query currently running within function |
Previous Message | John W Higgins | 2014-07-24 03:07:36 | Re: Complex Recursive Query |