PDA

View Full Version : error when opening HEM



alpatters
01-10-2009, 06:20 PM
I am seeing the following error message when opening HEM

"An error occurred while retrieving the imported file list: XX000: invalid memory alloc request size 4294967293"

I am using 1.07 on Vista and have been using HEM since pre 1.0 versions without any problems.

morny
01-11-2009, 10:06 PM
Sounds like the database is corrupt, can you export the hands from it http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 and then create a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and then reimport the hands

alpatters
01-14-2009, 06:58 PM
The export doesn't work either. I did the export via pgAdmin.
The pg_dump fails on the importedfiles table. I get the same error as HEM displays. I can't even do a select * on the table either so it seems that table is corrupt.

I guess my options are to drop the importedfiles table and recreate an empty one. Will this work? I have the auto import setup to move files after import so I guess this table is not being used. In fact HEM seems to be working anyway.

So advice needed? How does HEM use the importedfiles table, and if I drop it and create an empty table will it screw it up?

Thanks,
Alan

morny
01-14-2009, 07:37 PM
If its just the index then follow this method and it should repair it. Theres an index called importedfiles_idx so use that one http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

alpatters
01-15-2009, 05:14 AM
I don't get the error about an index problem so I am not sure that is it. I'll give it a go anyway.

I even get this error when I do "select * from importedfiles" and it returns nothing, so I can't even view any data in the table.

"An error occurred while retrieving the imported file list: XX000: invalid memory alloc request size 4294967293"

One other clue is that I saw a log entry suggesting that 4294967293 is a transaction Id. Not sure why it would be using that as an alloc size though. Maybe a red herring.

Thanks.

alpatters
01-19-2009, 05:15 PM
Hi,

It seems it is not the index that is the problem. When I try to fix it I get the error "Index rebuilding has failed: ERROR 58P01: could not access status of transaction 4294853188."

So the imported files table seems to be badly corrupted. My question now is what will happen if I drop the table and recreate an empty one?

Thanks,

morny
01-19-2009, 07:07 PM
I can check with Roy if you want however i know from other threads with these errors that Roy said nothing can be done once a table is damaged, considering that then i dont think youve anything to lose by trying since its unrecoverable (once youve exported the hands first or have the HH are archived) but if youd like me to check first let me know