nailuj90
06-08-2011, 10:00 AM
Hey,recently i can't do any backups/maintence. i get the error:
pg_dump: gebe Inhalt der Tabelle playerhandstourneykeycolumns_hero aus
pg_dump: gebe Inhalt der Tabelle playerhandstourneymisc aus
pg_dump: SQL-Anweisung schlug fehl
pg_dump: Fehlermeldung vom Server: ERROR: invalid page header in block 49397 of relation base/16761/16903
pg_dump: Die Anweisung war: COPY public.playerhandstourneymisc (playerhand_id, stacksize, effectivestacksize, seatnumber, offthebutton, finalhandtype_id, ishero, sawflopastype_id, betamountpreflop, callamountpreflop, postamountpreflop, totalbetspreflop, totalcallspreflop, threebetresponsetype_id, fourbetresponsetype_id, limpreraisedpreflop, bbstealattempted, bbstealdefended, bbstealreraised, sbstealattempted, sbstealdefended, sbstealreraised, preflopraisepercentofpot, facingraisepercentofpot) TO stdout;
pg_dump: *** abgebrochen wegen Fehler
Prozess beendete mit Exitcode 1.
What can i do to fix this?... reindexing/vacuum doesnt help
pg_dump: gebe Inhalt der Tabelle playerhandstourneykeycolumns_hero aus
pg_dump: gebe Inhalt der Tabelle playerhandstourneymisc aus
pg_dump: SQL-Anweisung schlug fehl
pg_dump: Fehlermeldung vom Server: ERROR: invalid page header in block 49397 of relation base/16761/16903
pg_dump: Die Anweisung war: COPY public.playerhandstourneymisc (playerhand_id, stacksize, effectivestacksize, seatnumber, offthebutton, finalhandtype_id, ishero, sawflopastype_id, betamountpreflop, callamountpreflop, postamountpreflop, totalbetspreflop, totalcallspreflop, threebetresponsetype_id, fourbetresponsetype_id, limpreraisedpreflop, bbstealattempted, bbstealdefended, bbstealreraised, sbstealattempted, sbstealdefended, sbstealreraised, preflopraisepercentofpot, facingraisepercentofpot) TO stdout;
pg_dump: *** abgebrochen wegen Fehler
Prozess beendete mit Exitcode 1.
What can i do to fix this?... reindexing/vacuum doesnt help