View Full Version : Error trying to open the database
pmatt10
10-31-2008, 08:34 PM
When I try to open HM, I have this message.
The following error occured when trying to open the database: ERROR: XX001: invalid page header in block 0 of relation ''pg_index_indrelid_index''
I'm running Vista and UAC is disable. Also, I'm already running as administrator in holdemmanager.exe, hmhud.exe, dbcontrolpanel.exe since they are all in grey
after this, I have a message that sayss that Holdem Manager needs to know where to find the database and several boxes (Server Name, Login Name, Port Number, Password) and a connect button
Those messages appeared out of no where one day. I was using HM for at least 2 months before and I didnt have any problem
thank you
morny
11-01-2008, 12:18 AM
When you get to the screen with the connect button does it let you connect?
pmatt10
11-01-2008, 12:26 AM
no, when I click on it, another box appears and says
Error when connecting to PS database 07-08 database: ERROR:XX002: index ''pg_cast_source_target_index'' contains unexpected zero page at block 0
PS database 07-08 is the name of my database
morny
11-01-2008, 12:27 AM
Ok ill ask Roy to look into this, its late in hes timezone so it will be sometime tommorrow before he can respond
Rvg72
11-01-2008, 04:17 AM
Try doing a full vacuum
1) Open pgadmin from your start menu in windows under postgresql
2) Double click on the server name and enter your postgresql password (default is postgrespass)
3) Click on Databases and select the current database
4) Right click and go to Maintenance and then Vacuum and select Full and Analyze
Let me know what errors you get. it does sound like you have a DB issue with one of the main postgres tables
Roy
pmatt10
11-01-2008, 06:21 AM
here's the message I get after I vacuum:
INFO: vacuuming "information_schema.sql_packages"
INFO: "sql_packages": found 0 removable, 10 nonremovable row versions in 1 pages
DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 64 to 92 bytes long.
There were 0 unused item pointers.
Total free space (including removable row versions) is 7316 bytes.
0 pages are or will become empty, including 0 at the end of the table.
1 pages containing 7316 free bytes are potential move destinations.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
ERROR: invalid page header in block 0 of relation "pg_index_indrelid_index"
Rvg72
11-01-2008, 04:40 PM
This will hopefully work:
1) Open pgadmin from your start menu in windows under postgresql
2) Double click on the server name and enter your postgresql password (default is postgrespass)
3) Click on Databases and select the current database
4) Right click and go to Maintenance and then select Reindex and select the Force option.
Roy
pmatt10
11-01-2008, 05:53 PM
I stilll have this message...
ERROR: invalid page header in block 0 of relation "pg_index_indrelid_index"
Rvg72
11-03-2008, 07:18 PM
Did you get that error when you tried the reindex or did the reindex complete and then this error appeared?
The fastest way to get up and running again for you would be to create a new DB but I would still like to see if I could recover this index. If you have time for me to login with www.teamviewer.com then email me at support@holdemmanager.net
Thanks,
Roy
pmatt10
11-03-2008, 08:13 PM
I get that error when I tried to reindex..
And yes, I have some time for you to login with teamviewer
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.