backup error
Results 1 to 6 of 6

Thread: backup error

  1. #1
    Member
    Join Date
    Jul 2010
    Posts
    48

    Default backup error

    Im getting this error when trying to backup my HEM. Not sure if it's backed up correctly, or stop in the middle?HEM file is saved.

    [8/8/2011 7:03 PM] HOLDEMMANAGER: error: pg_dump: SQL command failed
    pg_dump: Error message from server: ERROR: invalid page header in block 15040 of relation "playerhandscashkeycolumns"
    pg_dump: The command was: COPY public.playerhandscashkeycolumns (pokerhand_id, playerhand_id, handtimestamp, gametype_id, player_id, numberofplayers, positiontype_id, holecard1int, holecard2int, holecardvalue_id, rakeamount, netamountwon, streetwentallin, didvpip, didpfr, preflopaction_id, firstpreflopactiontype_id, maxstreetseen, totalflopbets, totalflopcalls, totalturnbets, totalturncalls, totalriverbets, totalrivercalls, preflopplayeractiontype_id, flopcbetpossible, flopcbetmade, flopfacingcbet, flopfoldedtocbet, flopplayeractiontype_id, turncbetpossible, turncbetmade, turnfacingcbet, turnfoldedtocbet, turnplayeractiontype_id, rivercbetpossible, rivercbetmade, riverfacingcbet, riverfoldedtocbet, riverplayeractiontype_id, holecard3int, holecard4int) TO stdout;

    [8/8/2011 7:03 PM] error: error backup up HOLDEMMANAGER

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

    Default

    Your database is damaged.
    Please try a reindex of your database via pgadminIII->maintenance.
    If that doesn't help you should create a new database and reimport all your hands (+notes +summaries).

  3. #3
    Junior Member
    Join Date
    Oct 2011
    Posts
    2

    Default

    Hi, I have a problem with backup my database. I tryed to reindex my DB, I tryed to make a backup in pgadmin by I always get the same error, which is: ERROR: could not read block 2929 of relation base/17116/17139: Invalid argument. Can you give some advise please? Thanks a lot.

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

    Default

    That's a sign of a corrupt database.

    Create a new database: Options--> Database Management--> Connect--> Create New Database--> (set it as default)--> Start HoldemManager
    Reimport your archive folder
    Then create the backup: http://faq.holdemmanager.com/questio...estoreDatabase
    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
    Junior Member
    Join Date
    Oct 2011
    Posts
    2

    Default

    Reimport your archive folder
    Hi, thanks for your advice. Can you explain to me what does "Reimport your archive folder" means exactly, please? I am not sure how to do this step. Thanks a lot.

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

    Default

    Run a import from folder, on the archive folder, default location is: C:/HMArchive
    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

Similar Threads

  1. HEM Backup error when loading backup
    By briancl in forum Manager General
    Replies: 10
    Last Post: 02-23-2011, 06:20 AM
  2. backup error
    By alyam in forum Manager General
    Replies: 7
    Last Post: 02-06-2011, 04:08 PM
  3. backup error
    By chewbacca77 in forum Manager General
    Replies: 2
    Last Post: 11-16-2010, 01:29 PM
  4. backup error
    By armonica in forum Manager General
    Replies: 19
    Last Post: 10-16-2009, 03:14 PM
  5. error when trying to backup
    By Evigt_Drabbad in forum Manager General
    Replies: 2
    Last Post: 12-23-2008, 01:22 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
  •