PDA

View Full Version : backup error



alyam
02-06-2011, 03:04 AM
pg_dump: Error message from server: ERROR: invalid page header in block 26675 of relation "compiledplayerresults_month"
pg_dump: The command was: COPY public.compiledplayerresults_month (compiledplayerresults_id, totalhands, totalamountwon, totalrake, totalbbswon, vpiphands, pfrhands, couldcoldcall, didcoldcall, couldthreebet, didthreebet, couldsqueeze, didsqueeze, facingtwopreflopraisers, calledtwopreflopraisers, raisedtwopreflopraisers, smallblindstealattempted, smallblindstealdefended, smallblindstealreraised, bigblindstealattempted, bigblindstealdefended, bigblindstealreraised, sawnonsmallshowdown, wonnonsmallshowdown, sawlargeshowdown, wonlargeshowdown, sawnonsmallshowdownlimpedflop, wonnonsmallshowdownlimpedflop, sawlargeshowdownlimpedflop, wonlargeshowdownlimpedflop, wonhand, wonhandwhensawflop, wonhandwhensawturn, wonhandwhensawriver, facedthreebetpreflop, foldedtothreebetpreflop, calledthreebetpreflop, raisedthreebetpreflop, facedfourbetpreflop, foldedtofourbetpreflop, calledfourbetpreflop, raisedfourbetpreflop, bigbetpreflopsawshowdown, bigbetflopsawshowdown, bigbetturnsawshowdown, bigbetriversawshowdown, bigcallpreflopsawshowdown, bigcallflopsawshowdown, bigcallturnsawshowdown, bigcallriversawshowdown, bigbetpreflopwonshowdown, bigbetflopwonshowdown, bigbetturnwonshowdown, bigbetriverwonshowdown, bigcallpreflopwonshowdown, bigcallflopwonshowdown, bigcallturnwonshowdown, bigcallriverwonshowdown, turnfoldippassonflopcb, turncallippassonflopcb, turnraiseippassonflopcb, riverfoldippassonturncb, rivercallippassonturncb, riverraiseippassonturncb, sawflop, sawshowdown, wonshowdown, totalbets, totalcalls, flopcontinuationbetpossible, flopcontinuationbetmade, turncontinuationbetpossible, turncontinuationbetmade, rivercontinuationbetpossible, rivercontinuationbetmade, facingflopcontinuationbet, foldedtoflopcontinuationbet, calledflopcontinuationbet, raisedflopcontinuationbet, facingturncontinuationbet, foldedtoturncontinuationbet, calledturncontinuationbet, raisedturncontinuationbet, facingrivercontinuationbet, foldedtorivercontinuationbet, calledrivercontinuationbet, raisedrivercontinuationbet, totalpostflopstreetsseen, totalaggressivepostflopstreetsseen, vs_ep_raise_ip_fold, vs_ep_raise_ip_call, vs_ep_raise_ip_raise, vs_mp_raise_ip_fold, vs_mp_raise_ip_call, vs_mp_raise_ip_raise, vs_co_raise_ip_fold, vs_co_raise_ip_call, vs_co_raise_ip_raise, vs_sb_raise_ip_fold, vs_sb_raise_ip_call, vs_sb_raise_ip_raise, vs_ep_raise_oop_fold, vs_ep_raise_oop_call, vs_ep_raise_oop_raise, vs_mp_raise_oop_fold, vs_mp_raise_oop_call, vs_mp_raise_oop_raise, vs_co_raise_oop_fold, vs_co_raise_oop_call, vs_co_raise_oop_raise, vs_bt_raise_oop_fold, vs_bt_raise_oop_call, vs_bt_raise_oop_raise, ep_vs_raise_ip_fold, ep_vs_raise_ip_call, ep_vs_raise_ip_raise, ep_vs_raise_oop_fold, ep_vs_raise_oop_call, ep_vs_raise_oop_raise, mp_vs_raise_ip_fold, mp_vs_raise_ip_call, mp_vs_raise_ip_raise, mp_vs_raise_oop_fold, mp_vs_raise_oop_call, mp_vs_raise_oop_raise, co_vs_raise_ip_fold, co_vs_raise_ip_call, co_vs_raise_ip_raise, co_vs_raise_oop_fold, co_vs_raise_oop_call, co_vs_raise_oop_raise, bt_vs_raise_oop_fold, bt_vs_raise_oop_call, bt_vs_raise_oop_raise, sb_vs_raise_ip_fold, sb_vs_raise_ip_call, sb_vs_raise_ip_raise) TO stdout;
pg_dump: *** aborted because of error

Sarek
02-06-2011, 04:42 AM
what kind of backup you used?
if HM-internal - try to do it via PGadmin
but keep in mind - they are not compatible, so you have to restore via PGadmin too

alyam
02-06-2011, 05:25 AM
what kind of backup you used?
if HM-internal - try to do it via PGadmin
but keep in mind - they are not compatible, so you have to restore via PGadmin too
via PGadmin
HM-internal has error too:
[06.02.2011 12:22] HM: error: pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid page header in block 26675 of relation "compiledplayerresults_month"
pg_dump: The command was: COPY public.compiledplayerresults_month (compiledplayerresults_id, totalhands, totalamountwon, totalrake, totalbbswon, vpiphands, pfrhands, couldcoldcall, didcoldcall, couldthreebet, didthreebet, couldsqueeze, didsqueeze, facingtwopreflopraisers, calledtwopreflopraisers, raisedtwopreflopraisers, smallblindstealattempted, smallblindstealdefended, smallblindstealreraised, bigblindstealattempted, bigblindstealdefended, bigblindstealreraised, sawnonsmallshowdown, wonnonsmallshowdown, sawlargeshowdown, wonlargeshowdown, sawnonsmallshowdownlimpedflop, wonnonsmallshowdownlimpedflop, sawlargeshowdownlimpedflop, wonlargeshowdownlimpedflop, wonhand, wonhandwhensawflop, wonhandwhensawturn, wonhandwhensawriver, facedthreebetpreflop, foldedtothreebetpreflop, calledthreebetpreflop, raisedthreebetpreflop, facedfourbetpreflop, foldedtofourbetpreflop, calledfourbetpreflop, raisedfourbetpreflop, bigbetpreflopsawshowdown, bigbetflopsawshowdown, bigbetturnsawshowdown, bigbetriversawshowdown, bigcallpreflopsawshowdown, bigcallflopsawshowdown, bigcallturnsawshowdown, bigcallriversawshowdown, bigbetpreflopwonshowdown, bigbetflopwonshowdown, bigbetturnwonshowdown, bigbetriverwonshowdown, bigcallpreflopwonshowdown, bigcallflopwonshowdown, bigcallturnwonshowdown, bigcallriverwonshowdown, turnfoldippassonflopcb, turncallippassonflopcb, turnraiseippassonflopcb, riverfoldippassonturncb, rivercallippassonturncb, riverraiseippassonturncb, sawflop, sawshowdown, wonshowdown, totalbets, totalcalls, flopcontinuationbetpossible, flopcontinuationbetmade, turncontinuationbetpossible, turncontinuationbetmade, rivercontinuationbetpossible, rivercontinuationbetmade, facingflopcontinuationbet, foldedtoflopcontinuationbet, calledflopcontinuationbet, raisedflopcontinuationbet, facingturncontinuationbet, foldedtoturncontinuationbet, calledturncontinuationbet, raisedturncontinuationbet, facingrivercontinuationbet, foldedtorivercontinuationbet, calledrivercontinuationbet, raisedrivercontinuationbet, totalpostflopstreetsseen, totalaggressivepostflopstreetsseen, vs_ep_raise_ip_fold, vs_ep_raise_ip_call, vs_ep_raise_ip_raise, vs_mp_raise_ip_fold, vs_mp_raise_ip_call, vs_mp_raise_ip_raise, vs_co_raise_ip_fold, vs_co_raise_ip_call, vs_co_raise_ip_raise, vs_sb_raise_ip_fold, vs_sb_raise_ip_call, vs_sb_raise_ip_raise, vs_ep_raise_oop_fold, vs_ep_raise_oop_call, vs_ep_raise_oop_raise, vs_mp_raise_oop_fold, vs_mp_raise_oop_call, vs_mp_raise_oop_raise, vs_co_raise_oop_fold, vs_co_raise_oop_call, vs_co_raise_oop_raise, vs_bt_raise_oop_fold, vs_bt_raise_oop_call, vs_bt_raise_oop_raise, ep_vs_raise_ip_fold, ep_vs_raise_ip_call, ep_vs_raise_ip_raise, ep_vs_raise_oop_fold, ep_vs_raise_oop_call, ep_vs_raise_oop_raise, mp_vs_raise_ip_fold, mp_vs_raise_ip_call, mp_vs_raise_ip_raise, mp_vs_raise_oop_fold, mp_vs_raise_oop_call, mp_vs_raise_oop_raise, co_vs_raise_ip_fold, co_vs_raise_ip_call, co_vs_raise_ip_raise, co_vs_raise_oop_fold, co_vs_raise_oop_call, co_vs_raise_oop_raise, bt_vs_raise_oop_fold, bt_vs_raise_oop_call, bt_vs_raise_oop_raise, sb_vs_raise_ip_fold, sb_vs_raise_ip_call, sb_vs_raise_ip_raise) TO stdout;

[06.02.2011 12:22] error: error backup up HM

Sarek
02-06-2011, 05:31 AM
try to do DB reindex (full) via PGadmin
if this don't helps = your DB is corrupt and you have to create new one

alyam
02-06-2011, 05:43 AM
try to do DB reindex (full) via PGadmin
if this don't helps = your DB is corrupt and you have to create new one
reindex force?

netsrak
02-06-2011, 06:57 AM
Doesn't matter, force is obsolete as explained in the help

alyam
02-06-2011, 07:09 AM
reindex not working.
reimport all hands takes few days.
fuck hm

Sarek
02-06-2011, 04:08 PM
it is a kind of "securiry" rule: to make DB backup on regular basis