PDA

View Full Version : DB vacuum errors



Goobertron
09-06-2011, 03:50 PM
I tried to do a manual vacuum today after purging over a million hands but it returns an error message repeatedly. When trying to vacuum using the HEM database management tool i get the same message which reads 'ERROR:XX000 could not read block 59441 of relation base/16397/16620: Invalid argument'.

If i try to do a DB reindex i get a similar message. Is there anything i can do since I want to reclaim the space as I will be moving it to an SSD fairly soon where space is at a premium.


Thanks

olliepower
09-06-2011, 09:22 PM
What firewall/anti virus do you have?

Have you tried creating a new database?

1) Create a new database

here's a FAQ on how to create a new database http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database

2) Import a small sample of hands

3) Try to vacuum the DB


If that works,

Your database is corrupt.

Export your Hand Histories
http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands

Export Your Notes
http://faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback � Options > Rakeback & Bonuses http://faq.holdemmanager.com/images/rakeback-bonuses-01.jpg

Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

http://faq.holdemmanager.com/images/tourney-data-view-01.jpg

Then can you create a new database http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database

Finally reimport all your hands/notes/summaries into the new database

Goobertron
09-08-2011, 11:31 AM
Hi,

If i have to create a new database and re-import my hands will i lose 2 million odd hands i've imported and then purged or will they also appear in HMArchive? It'd be pretty tragic if i lost the info from those purged hands since I'm a very heavy user of tablescanner.

Thanks

Patvs
09-08-2011, 01:53 PM
All original handhistories are in the HMArchive folder, including purged hands.

Note: if you played those hands on PokerStars/Full Tilt/PartyPoker, you can also just email their support and request the handhistories for every hand you've ever played.

Goobertron
09-09-2011, 09:59 AM
I exported my hands and then reimported them into a new database but after finishing it has imported only 160k hands meaning the 3million+ hands that i had previously imported and then purged have not been exported and/or imported into the new DB.

netsrak
09-10-2011, 05:22 AM
Purged hands can't be exported because the handhistory is deleted by the purge. Please check your archive folder if you have them there.