Lefort
02-16-2011, 02:55 PM
I recently had some computer issues and had to shut down the computer manually with HM running as well as a bunch of clients and other software.
Upon restart, HM forced me to re-connect to my database. And a couple funny things have happened since. First off, one of the many clients stopped auto-importing.. as in the auto-import no longer looked for that folder as it had vanished off the list. No big deal, I just added it again. But it has me a bit paranoid that I'm missing hands on some sites somewhere or something.
More importantly (of the bugs), I'm now getting an "Optimize Reports" window every time I start HM and it tries to optimize 3 players. It's 3 players that have used my computer to play before so they may have more hands than most players in my DB. It says "processing.." and then I get the following error after about 1-2 minutes: "The following error occurred: ERROR: XX001: invalid page header in block 40387 of relation "playerhandsflop"." This happens for each name, so it takes me ~5 minutes before I can use the program after opening it. And it happens every time.
Normally, I wouldn't care much. But I'm just paranoid that my whole DB is going to crash or become corrupt or something while all I had to do was a quick-fix of some sort.
Note that I've had problems with Analyzing/Vacuuming and Backup/Restore with pgAdmin with my database in the past, as seen here: http://forums.holdemmanager.com/manager-general/41916-database-back-up-restore-attempt.html
Thanks for any help, it's much appreciated.
Upon restart, HM forced me to re-connect to my database. And a couple funny things have happened since. First off, one of the many clients stopped auto-importing.. as in the auto-import no longer looked for that folder as it had vanished off the list. No big deal, I just added it again. But it has me a bit paranoid that I'm missing hands on some sites somewhere or something.
More importantly (of the bugs), I'm now getting an "Optimize Reports" window every time I start HM and it tries to optimize 3 players. It's 3 players that have used my computer to play before so they may have more hands than most players in my DB. It says "processing.." and then I get the following error after about 1-2 minutes: "The following error occurred: ERROR: XX001: invalid page header in block 40387 of relation "playerhandsflop"." This happens for each name, so it takes me ~5 minutes before I can use the program after opening it. And it happens every time.
Normally, I wouldn't care much. But I'm just paranoid that my whole DB is going to crash or become corrupt or something while all I had to do was a quick-fix of some sort.
Note that I've had problems with Analyzing/Vacuuming and Backup/Restore with pgAdmin with my database in the past, as seen here: http://forums.holdemmanager.com/manager-general/41916-database-back-up-restore-attempt.html
Thanks for any help, it's much appreciated.