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

[grogclan]

Found during vacuuming of DB.

Need a repair of some sort?

[fabio]

Dont think so, but will ask Roy about that.

[grogclan]

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]

Will talk to Roy

[KittyLiquor]

ERROR: invalid page header in block 236051 of relation "handhistories"

Any solution yet?

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

[fabio]

It seems that your databases might be corrupt. Have you 2 updated HM before this error appeared?

[KittyLiquor]

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]

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