Lists: | pgsql-bugs |
---|
From: | "Valentine Gogichashvili" <valgog(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5574: PANIC on hot-standby: heap_update_redo |
Date: | 2010-07-27 15:02:45 |
Message-ID: | 201007271502.o6RF2j2R026503@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5574
Logged by: Valentine Gogichashvili
Email address: valgog(at)gmail(dot)com
PostgreSQL version: 9.0beta3
Operating system: RedHat Linux (2.4.21-53.ELsmp)
Description: PANIC on hot-standby: heap_update_redo
Details:
A hot-standby and a source database are identical machines.
A hot-standby machine was recieving WAL files for 2 days now (omnipitr
scripts), and then it crashed with the following error:
2010-07-27 15:20:38.318 CEST,,,22151,,4c49acba.5687,5691,,2010-07-23
16:52:42 CEST,1/0,0,LOG,00000,"restored log file
""0000000100000024000000CA"" from archive",,,,,,,,,""
2010-07-27 15:21:38.430 CEST,,,22151,,4c49acba.5687,5692,,2010-07-23
16:52:42 CEST,1/0,0,LOG,00000,"restored log file
""0000000100000024000000CB"" from archive",,,,,,,,,""
2010-07-27 15:22:37.682 CEST,,,22151,,4c49acba.5687,5693,,2010-07-23
16:52:42 CEST,1/0,0,LOG,00000,"restored log file
""0000000100000024000000CC"" from archive",,,,,,,,,""
2010-07-27 15:23:37.224 CEST,,,22151,,4c49acba.5687,5694,,2010-07-23
16:52:42 CEST,1/0,0,LOG,00000,"restored log file
""0000000100000024000000CD"" from archive",,,,,,,,,""
2010-07-27 15:24:37.606 CEST,,,22151,,4c49acba.5687,5695,,2010-07-23
16:52:42 CEST,1/0,0,LOG,00000,"restored log file
""0000000100000024000000CE"" from archive",,,,,,,,,""
2010-07-27 15:25:38.118 CEST,,,22151,,4c49acba.5687,5696,,2010-07-23
16:52:42 CEST,1/0,0,LOG,00000,"restored log file
""0000000100000024000000CF"" from archive",,,,,,,,,""
2010-07-27 15:26:09.759 CEST,,,22151,,4c49acba.5687,5697,,2010-07-23
16:52:42 CEST,1/0,0,PANIC,XX000,"heap_update_redo: invalid max offset
number",,,,,"xlog redo update: rel 16384/31487/35687; tid 207118/46; new
207118/73",,,,""
2010-07-27 15:26:09.999 CEST,,,22148,,4c49acba.5684,2,,2010-07-23 16:52:42
CEST,,0,LOG,00000,"startup process (PID 22151) was terminated by signal 6:
Aborted",,,,,,,,,""
2010-07-27 15:26:09.999 CEST,,,22148,,4c49acba.5684,3,,2010-07-23 16:52:42
CEST,,0,LOG,00000,"terminating any other active server
processes",,,,,,,,,""
After retrying to startup the hot-standby again:
2010-07-27 16:00:38.300 CEST,,,2899,,4c4ee686.b53,1,,2010-07-27 16:00:38
CEST,,0,LOG,00000,"database system was interrupted while in recovery at log
time 2010-07-27 15:16:41 CEST",,"If this has occurred more than once some
data might be corrupted and you might need to choose an earlier recovery
target.",,,,,,,""
2010-07-27 16:00:38.300 CEST,,,2899,,4c4ee686.b53,2,,2010-07-27 16:00:38
CEST,,0,LOG,00000,"entering standby mode",,,,,,,,,""
2010-07-27 16:00:38.520 CEST,,,2899,,4c4ee686.b53,3,,2010-07-27 16:00:38
CEST,,0,LOG,00000,"restored log file ""0000000100000024000000C7"" from
archive",,,,,,,,,""
2010-07-27 16:00:39.050 CEST,,,2899,,4c4ee686.b53,4,,2010-07-27 16:00:38
CEST,1/0,0,LOG,00000,"redo starts at 24/C70046E8",,,,,,,,,""
2010-07-27 16:00:39.300 CEST,,,2899,,4c4ee686.b53,5,,2010-07-27 16:00:38
CEST,1/0,0,LOG,00000,"restored log file ""0000000100000024000000C8"" from
archive",,,,,,,,,""
2010-07-27 16:00:39.560 CEST,,,2899,,4c4ee686.b53,6,,2010-07-27 16:00:38
CEST,1/0,0,LOG,00000,"restored log file ""0000000100000024000000C9"" from
archive",,,,,,,,,""
2010-07-27 16:00:39.840 CEST,,,2899,,4c4ee686.b53,7,,2010-07-27 16:00:38
CEST,1/0,0,LOG,00000,"restored log file ""0000000100000024000000CA"" from
archive",,,,,,,,,""
2010-07-27 16:00:40.310 CEST,,,2899,,4c4ee686.b53,8,,2010-07-27 16:00:38
CEST,1/0,0,LOG,00000,"restored log file ""0000000100000024000000CB"" from
archive",,,,,,,,,""
2010-07-27 16:00:40.370 CEST,,,2899,,4c4ee686.b53,9,,2010-07-27 16:00:38
CEST,1/0,0,PANIC,XX000,"heap_update_redo: invalid lp",,,,,"xlog redo update:
rel 16384/31487/35687; tid 182931/32; new 185403/25",,,,""
2010-07-27 16:00:40.410 CEST,,,2896,,4c4ee686.b50,1,,2010-07-27 16:00:38
CEST,,0,LOG,00000,"startup process (PID 2899) was terminated by signal 6:
Aborted",,,,,,,,,""
2010-07-27 16:00:40.410 CEST,,,2896,,4c4ee686.b50,2,,2010-07-27 16:00:38
CEST,,0,LOG,00000,"terminating any other active server
processes",,,,,,,,,""
With best regards,
-- Valentine
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Valentine Gogichashvili" <valgog(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5574: PANIC on hot-standby: heap_update_redo |
Date: | 2010-07-27 22:22:47 |
Message-ID: | 17051.1280269367@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
"Valentine Gogichashvili" <valgog(at)gmail(dot)com> writes:
> A hot-standby machine was recieving WAL files for 2 days now (omnipitr
> scripts), and then it crashed with the following error:
> 2010-07-27 15:26:09.759 CEST,,,22151,,4c49acba.5687,5697,,2010-07-23
> 16:52:42 CEST,1/0,0,PANIC,XX000,"heap_update_redo: invalid max offset
> number",,,,,"xlog redo update: rel 16384/31487/35687; tid 207118/46; new
> 207118/73",,,,""
Difficult to do anything with this unless you can provide more data.
What changes were being made on the master server at the time?
regards, tom lane
From: | valgog <valgog(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5574: PANIC on hot-standby: heap_update_redo |
Date: | 2010-07-27 22:23:39 |
Message-ID: | 21d51dd9-26d2-4d11-98aa-04902b7705a4@j8g2000yqd.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
On Jul 27, 5:02 pm, val(dot)(dot)(dot)(at)gmail(dot)com ("Valentine Gogichashvili")
wrote:
> The following bug has been logged online:
>
> Bug reference: 5574
> Logged by: Valentine Gogichashvili
> Email address: val(dot)(dot)(dot)(at)gmail(dot)com
> PostgreSQL version: 9.0beta3
> Operating system: RedHat Linux (2.4.21-53.ELsmp)
> Description: PANIC on hot-standby: heap_update_redo
> Details:
>
> A hot-standby and a source database are identical machines.
>
> A hot-standby machine was recieving WAL files for 2 days now (omnipitr
> scripts), and then it crashed with the following error:
> ....
Oh, I think it was my fault... as I started another copy of the hot-
standby from the different location and did not relink the
tablespaces :( Sorry for trouble....
-- Valentine