PDA

View Full Version : ERROR: invalid page header in block 23450 of relation "handhistories"



grogclan
08-10-2008, 04:31 AM
Found during vacuuming of DB.

Need a repair of some sort?

fabio
08-10-2008, 08:27 AM
Dont think so, but will ask Roy about that.

grogclan
08-10-2008, 11:49 AM
Well, it makes it just about imposible to vacuum the db with this error message...have to hit enter about a thousand times to get through the process...

fabio
08-10-2008, 01:29 PM
Will talk to Roy

KittyLiquor
08-16-2008, 05:22 PM
ERROR: invalid page header in block 236051 of relation "handhistories"

Any solution yet?

-----------------Kitty

fabio
08-16-2008, 05:46 PM
It seems that your databases might be corrupt. Have you 2 updated HM before this error appeared?

KittyLiquor
08-16-2008, 07:41 PM
Running v1.06.01m

Haven't updated HM in a week or so. Just added all my 2007 HH's. Database size tripled.

This type of error has happened several times over the last couple months. I can usually reindex and/or vacuum and it fixes itself. Not this time.

----------------Kitty

Rvg72
08-17-2008, 01:14 AM
Running v1.06.01m

Haven't updated HM in a week or so. Just added all my 2007 HH's. Database size tripled.

This type of error has happened several times over the last couple months. I can usually reindex and/or vacuum and it fixes itself. Not this time.

----------------Kitty

This one means the actual hand histories table was damaged. The fact it has happened many times makes me think there is something else going on with your pc or hard drive.

Anyone with this issue, please e-mail me at support@holdemmanager.net

On Monday I would like to try something through team viewer to see if I can recover most of the table otherwise the alternative is dropping the table and creating it again as a new blank one.

Roy