DB vacuum errors
Results 1 to 6 of 6
  1. #1
    Member
    Join Date
    Nov 2008
    Posts
    59

    Default DB vacuum errors

    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

  2. #2
    Moderator olliepower's Avatar
    Join Date
    Nov 2008
    Posts
    385

    Default

    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/questio...elete+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/questio...6+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/...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/...ta-view-01.jpg

    Then can you create a new database http://faq.holdemmanager.com/questio...elete+Database

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

  3. #3
    Member
    Join Date
    Nov 2008
    Posts
    59

    Default

    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

  4. #4
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    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.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  5. #5
    Member
    Join Date
    Nov 2008
    Posts
    59

    Default

    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.

  6. #6
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    Purged hands can't be exported because the handhistory is deleted by the purge. Please check your archive folder if you have them there.

Similar Threads

  1. Vacuum
    By MAHAYANAMAN in forum Manager General
    Replies: 4
    Last Post: 02-21-2014, 07:22 AM
  2. vacuum analyze database errors
    By kwin in forum Manager General
    Replies: 1
    Last Post: 02-27-2011, 07:45 PM
  3. help me to vacuum
    By sergiod in forum Manager General
    Replies: 1
    Last Post: 07-27-2010, 11:11 PM
  4. pgSQL errors while trying to backup and vacuum
    By Josey Wales in forum Manager General
    Replies: 11
    Last Post: 01-31-2010, 07:29 AM
  5. import errors and vacuum problem
    By stacker in forum Manager General
    Replies: 1
    Last Post: 01-12-2009, 04:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •