Hands in database is gone, but the database says it still exists and takes up 70GB

[Facelessvoid]

After running NoteCaddy Edge for a couple of hours, I rebooted my PC, but then a message about not connecting to PSQL came up. Tried couple of things to fix it, but didn't help. After some time I just tried to change the password and then it suddenly connected.. Now a weird bug is happening, where I search on a player and HM2 says there's plenty of hands on the specific players, but when I click on them it shows no hands. My database also takes up 70GB, so they must be there somewhere...

What can I do to fix this? My database is huge, I've 7.5M hands

[fozzy71]

70GB for 7+ mill hands and NCE is not out of the realm of possibility. Have you tried to reset and recreate the NC notes?

Please try to vacuum/analyze and reindex your database - http://hm2faq.holdemmanager.com/ques...29#maintenance

If you continue to have problems, try the following:

Try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB - http://hm2faq.holdemmanager.com/ques...y+played+hands

If the new database seems to work properly, it sounds like your database might be corrupt. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary.

Here is a FAQ explaining how to backup your database and all settings in one easy step - http://hm2faq.holdemmanager.com/ques...onfigs+work%3F

If none of the above steps helped:

Please enable the Settings > Feature Logging > [x] 'HUDStats' and 'FastPoker' option and increase the Max number of log files option to 10 so old logs are saved with date/time stamps. You can also enable this before you launch HM2 from the Start Menu - http://hm2faq.holdemmanager.com/ques...ging#startmenu

Please reproduce the problem and:
- Use the tool in the following link to send a HUD Report - http://hm2faq.holdemmanager.com/ques...Reporting+Tool
- Attach a screen shot of the table/desktop
- Try to include the Active Sessions tab and/or Sessions Report that also includes your windows clock and poker client lobby clock in the screen shot
- Save a copy of the original Hand history for the table with the issue
- Close HM2 and attach your log.txt file with a detailed description of what you were doing and what problems you were experiencing - http://hm2faq.holdemmanager.com/ques...ger+Support%3F

With all the above information we should be able to narrow down what is causing the issue, if all the information is not included we will need to email you again to request it.

Please zip and email the requested files to hm2support@holdemmanager.com and if there is a forum thread with additional information please link to this thread and let us know your forum name if there are several people in the thread.

[Facelessvoid]

Can't find my backup, so I guess im screwed (Don't think I have one)
Really nice program, always having so many trouble with bugs and shit, and now all of my hands are gone. Have paid thousand of dollars for those.

A friend tried to help me as well, but we couldn't fix it. So I guess I've to deal with it. Seems like the database is corrupted

[udbrky]

If you continue to have problems, please reproduce the problem and zip/attach your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing - http://hm2faq.holdemmanager.com/ques...ger+Support%3F

in an email with a link to this thread to support@holdemmanager.com