Skip site navigation (1) Skip section navigation (2)

BUG #5574: PANIC on hot-standby: heap_update_redo

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 (view raw or flat)
Thread:
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

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2010-07-27 20:13:56
Subject: Re: failed to fetch tuple for EvalPlanQual recheck
Previous:From: Kevin GrittnerDate: 2010-07-27 13:46:09
Subject: Re: BUG #5573: How can i add field inbetween in the table while creating

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group