Open Side Menu Go to the Top

06-17-2010 , 11:23 PM
Guys,

Have never had these issues before, but all of a sudden they have just sprung up and have scoured the forum to try and fix myself to NO avail.

Whenever I run Housekeeping I get the following error:

Unable to execute query; VACUUM;; Reaon; FATAL ERROR (Error: Invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail")

There are then many other errors that follow it citing fatal errors for Analyzing, Clustering, Updating Cache......all of it.

I've tried running it with the REINDEX option...no good
Tried to get postgreSQL to ignore error by editing postgreSQL.conf and get:

Cannot create the C:\program files (x86)\postgreSQL\8.3\data\postgreSQL.conf file
Make sure the path and file name are correct


I've even just run a CHKDSK on this lappy and don't seem to see anything...getting to the end of my rope....any ideas? I'm getting to the point of thinking that the H/D is needing a replace, but want to make sure...lappy is only 14 months old.

ANY help is greatly appreciated.
Numerous Database Errors
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Numerous Database Errors
06-18-2010 , 10:27 AM
Click Start --> Programs --> Accessories --> right click Notepad and click Run As Administrator. Then open the postgresql.conf file and edit it to add the zero_damaged_pages setting. The file will then save properly. Restart the PostgreSQL server and that will likely fix things for you.
06-18-2010 , 01:36 PM
Did as instructed...closed the file and reloaded configuration. Tried to run a housekeeping and was greeted by the same error message in regards to vacuuming:

Unable to execute query; VACUUM;; Reason; Fatal Error
(ERROR; invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail")


You mentioned restarting the postgreSQL server...how would this be done? All I did was after saving the file and closing it was start up PT3....anything else I should have done?

Let me know and thanks in advance for your help.
06-18-2010 , 04:07 PM
Restarting I gather is the Stop Service and Start Service commands under the Reload Configuration tabs in Programs....if thats the case, then that is what I did.

Tried every which way to get it to work....made sure that the zero_damaged_pages setting had " " around them and saved the file. Reloaded the configuration and then stopped and started the service....ran Housekeeping and............still Errors.

Any other ideas?
06-18-2010 , 05:33 PM
There should not be "s around zero_damaged_pages = on. There should not be a # at the front of the line. The line should read exactly:

zero_damaged_pages = on

Give it one more try - if it doesn't work, please create a support ticket and we'll see if there's anything else we can do for you.
06-19-2010 , 02:19 AM
Took out the "s...Reloaded the Configuration, Stopped and Started (even Running as Administrator)....now PT3 takes FOREVER to load, and then DOESN'T....tells me:

It comes up with a dialogue box asking me about the database....port #'s and browsing the databases, etc. ONLY THERE AREN'T ANY all of a sudden...it asks if I want to create a new one? Then another box pops up that says:

unable to conect post gresql database PT3_..................
Reason unable to login database PT3_....................
reason :could not conect with server: Conection refused (oXooo274d/10061)
is the server running on host???and accepting TCP/IP connection on port 5432


I then checked the Add/Remove Programs list in the Control Panel to see if postgreSQL is actually still in the machine....it's listed, so I then try something else I found on the Forum and clicked Start --> Run ... and typed in services.msc and hit enter. Located the PostgreSQL service from the list and clicked on it then click Start Service......it went for more than a while and then gave me a message that said:

Windows could not start the postgresql-8.3 - PostgreSQL Server 8.3 service on local computer.
Error 1053 - The service did not respond to the start or control request in a timely fashion


So then I clicked Start --> Control Panel --> Administrative Tools --> Event Viewer and in the Application section look for an error from PostgreSQL...NO ERROR

So from here I am lost....is it better to uninstall postgreSQL 8.3 and PT3 from the machine and try ALL OVER again? (I have it running on a second machine, but was hoping to start using this as my main machine again...so I'm sure I can take all the HH and stuff from the other machine (which actually has more hands,etc. in it already)

I can't get PT3 to boot up properly now, so a support ticket could be alittle tough.....Good times

Any more info would be greatly appreciated.
06-19-2010 , 10:31 AM
Take a look at the most recent files in the C:\Program Files\PostgreSQL\8.3\data\base\pg_log directory and look for an error there - if you find any error please post it here, otherwise please create a support ticket and one of our technicians will assist you.
06-19-2010 , 07:02 PM
The following are the last 4 entries in order: (there seem to be errors in every one)

2010-06-17 17:35:53 EDT LOG: database system was shut down at 2010-06-14 17:31:47 EDT
2010-06-17 17:35:53 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 17:35:53 EDT FATAL: the database system is starting up
2010-06-17 17:35:54 EDT LOG: database system is ready to accept connections
2010-06-17 17:35:54 EDT LOG: autovacuum launcher started
2010-06-17 17:35:54 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 17:41:07 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 17:41:08 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 17:41:08 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 17:41:08 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 17:41:43 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-17 17:41:43 EDT STATEMENT: VACUUM;
2010-06-17 17:42:06 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-17 17:42:06 EDT STATEMENT: ANALYZE;
2010-06-17 17:43:34 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-17 17:43:34 EDT STATEMENT: CLUSTER tourney_holdem_hand_player_detail;
2010-06-17 17:43:35 EDT WARNING: there is no transaction in progress
2010-06-17 17:43:35 EDT WARNING: there is no transaction in progress
2010-06-17 17:43:36 EDT WARNING: there is no transaction in progress
2010-06-17 17:43:38 EDT WARNING: there is no transaction in progress
2010-06-17 17:59:47 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 17:59:47 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 17:59:47 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 17:59:47 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 18:00:20 EDT NOTICE: table "pg_class" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "sql_features" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "sql_implementation_info" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "pg_statistic" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "sql_languages" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "sql_packages" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "sql_parts" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "sql_sizing" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "sql_sizing_profiles" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "pg_ts_config" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "pg_ts_config_map" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "pg_ts_dict" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "pg_ts_parser" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "pg_ts_template" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "pg_type" was reindexed
2010-06-17 18:00:20 EDT NOTICE: table "pg_attribute" was reindexed
2010-06-17 18:00:21 EDT NOTICE: table "pg_proc" was reindexed
2010-06-17 18:00:21 EDT NOTICE: table "pg_autovacuum" was reindexed
2010-06-17 18:00:21 EDT NOTICE: table "pg_attrdef" was reindexed
2010-06-17 18:00:21 EDT NOTICE: table "pg_constraint" was reindexed
2010-06-17 18:00:21 EDT NOTICE: table "pg_inherits" was reindexed
2010-06-17 18:00:21 EDT NOTICE: table "pg_index" was reindexed
2010-06-17 18:00:21 EDT NOTICE: table "pg_operator" was reindexed
2010-06-17 18:00:21 EDT NOTICE: table "pg_opfamily" was reindexed
2010-06-17 18:00:21 EDT NOTICE: table "pg_opclass" was reindexed
2010-06-17 18:00:21 EDT NOTICE: table "pg_am" was reindexed
2010-06-17 18:00:22 EDT NOTICE: table "pg_amop" was reindexed
2010-06-17 18:00:22 EDT NOTICE: table "pg_amproc" was reindexed
2010-06-17 18:00:22 EDT NOTICE: table "pg_language" was reindexed
2010-06-17 18:00:22 EDT NOTICE: table "pg_largeobject" was reindexed
2010-06-17 18:00:22 EDT NOTICE: table "pg_aggregate" was reindexed
2010-06-17 18:00:22 EDT NOTICE: table "pg_rewrite" was reindexed
2010-06-17 18:00:22 EDT NOTICE: table "pg_trigger" was reindexed
2010-06-17 18:00:23 EDT NOTICE: table "pg_description" was reindexed
2010-06-17 18:00:23 EDT NOTICE: table "pg_cast" was reindexed
2010-06-17 18:00:23 EDT NOTICE: table "pg_enum" was reindexed
2010-06-17 18:00:23 EDT NOTICE: table "pg_namespace" was reindexed
2010-06-17 18:00:24 EDT NOTICE: table "pg_conversion" was reindexed
2010-06-17 18:00:24 EDT NOTICE: table "pg_depend" was reindexed
2010-06-17 18:00:25 EDT NOTICE: table "holdem_hand_summary" was reindexed
2010-06-17 18:00:28 EDT NOTICE: table "tourney_holdem_results" was reindexed
2010-06-17 18:00:28 EDT NOTICE: table "holdem_hand_histories" was reindexed
2010-06-17 18:00:28 EDT NOTICE: table "holdem_limit" was reindexed
2010-06-17 18:00:28 EDT NOTICE: table "settings" was reindexed
2010-06-17 18:00:30 EDT NOTICE: table "player" was reindexed
2010-06-17 18:00:43 EDT NOTICE: table "tourney_holdem_hand_player_statistics" was reindexed
2010-06-17 18:00:43 EDT NOTICE: table "holdem_table" was reindexed
2010-06-17 18:00:43 EDT NOTICE: table "notes" was reindexed
2010-06-17 18:00:43 EDT NOTICE: table "tourney_holdem_hand_histories" was reindexed
2010-06-17 18:00:43 EDT NOTICE: table "tourney_holdem_blinds" was reindexed
2010-06-17 18:00:43 EDT NOTICE: table "holdem_table_session_summary" was reindexed
2010-06-17 18:00:43 EDT NOTICE: table "tourney_holdem_summary" was reindexed
2010-06-17 18:00:44 EDT NOTICE: table "tourney_holdem_hand_player_combinations" was reindexed
2010-06-17 18:00:44 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-17 18:00:44 EDT STATEMENT: REINDEX DATABASE "PT3 DB"
2010-06-17 18:00:45 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-17 18:00:45 EDT STATEMENT: VACUUM;
2010-06-17 18:00:47 EDT ERROR: invalid page header in block 3355 of relation "tourney_holdem_hand_player_detail"
2010-06-17 18:00:47 EDT STATEMENT: ANALYZE;
2010-06-17 18:00:50 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-17 18:00:50 EDT STATEMENT: ANALYZE;
2010-06-17 18:01:35 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-17 18:01:35 EDT STATEMENT: CLUSTER tourney_holdem_hand_player_detail;
2010-06-17 18:01:36 EDT WARNING: there is no transaction in progress
2010-06-17 18:01:36 EDT WARNING: there is no transaction in progress
2010-06-17 18:01:38 EDT WARNING: there is no transaction in progress
2010-06-17 18:01:39 EDT WARNING: there is no transaction in progress
2010-06-17 18:18:48 EDT LOG: received fast shutdown request
2010-06-17 18:18:48 EDT LOG: aborting any active transactions
2010-06-17 18:18:48 EDT LOG: autovacuum launcher shutting down
2010-06-17 18:18:48 EDT LOG: shutting down
2010-06-17 18:18:48 EDT LOG: database system is shut down


2010-06-17 19:44:37 EDT LOG: database system was shut down at 2010-06-17 18:18:48 EDT
2010-06-17 19:44:37 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 19:44:37 EDT FATAL: the database system is starting up
2010-06-17 19:44:38 EDT LOG: database system is ready to accept connections
2010-06-17 19:44:38 EDT LOG: autovacuum launcher started
2010-06-17 19:44:38 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 20:02:31 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 20:02:32 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 20:02:32 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 20:02:32 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 20:02:49 EDT NOTICE: table "pg_class" was reindexed
2010-06-17 20:02:49 EDT NOTICE: table "sql_features" was reindexed
2010-06-17 20:02:49 EDT NOTICE: table "sql_implementation_info" was reindexed
2010-06-17 20:02:49 EDT NOTICE: table "pg_statistic" was reindexed
2010-06-17 20:02:49 EDT NOTICE: table "sql_languages" was reindexed
2010-06-17 20:02:49 EDT NOTICE: table "sql_packages" was reindexed
2010-06-17 20:02:49 EDT NOTICE: table "sql_parts" was reindexed
2010-06-17 20:02:49 EDT NOTICE: table "sql_sizing" was reindexed
2010-06-17 20:02:49 EDT NOTICE: table "sql_sizing_profiles" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_ts_config" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_ts_config_map" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_ts_dict" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_ts_parser" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_ts_template" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_type" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_attribute" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_proc" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_autovacuum" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_attrdef" was reindexed
2010-06-17 20:02:50 EDT NOTICE: table "pg_constraint" was reindexed
2010-06-17 20:02:51 EDT NOTICE: table "pg_inherits" was reindexed
2010-06-17 20:02:51 EDT NOTICE: table "pg_index" was reindexed
2010-06-17 20:02:51 EDT NOTICE: table "pg_operator" was reindexed
2010-06-17 20:02:51 EDT NOTICE: table "pg_opfamily" was reindexed
2010-06-17 20:02:51 EDT NOTICE: table "pg_opclass" was reindexed
2010-06-17 20:02:51 EDT NOTICE: table "pg_am" was reindexed
2010-06-17 20:02:51 EDT NOTICE: table "pg_amop" was reindexed
2010-06-17 20:02:51 EDT NOTICE: table "pg_amproc" was reindexed
2010-06-17 20:02:51 EDT NOTICE: table "pg_language" was reindexed
2010-06-17 20:02:51 EDT NOTICE: table "pg_largeobject" was reindexed
2010-06-17 20:02:52 EDT NOTICE: table "pg_aggregate" was reindexed
2010-06-17 20:02:52 EDT NOTICE: table "pg_rewrite" was reindexed
2010-06-17 20:02:52 EDT NOTICE: table "pg_trigger" was reindexed
2010-06-17 20:02:52 EDT NOTICE: table "pg_description" was reindexed
2010-06-17 20:02:52 EDT NOTICE: table "pg_cast" was reindexed
2010-06-17 20:02:52 EDT NOTICE: table "pg_enum" was reindexed
2010-06-17 20:02:52 EDT NOTICE: table "pg_namespace" was reindexed
2010-06-17 20:02:53 EDT NOTICE: table "pg_conversion" was reindexed
2010-06-17 20:02:53 EDT NOTICE: table "pg_depend" was reindexed
2010-06-17 20:02:55 EDT NOTICE: table "holdem_hand_histories" was reindexed
2010-06-17 20:02:58 EDT NOTICE: table "tourney_holdem_results" was reindexed
2010-06-17 20:02:59 EDT NOTICE: table "holdem_limit" was reindexed
2010-06-17 20:02:59 EDT NOTICE: table "settings" was reindexed
2010-06-17 20:03:01 EDT NOTICE: table "player" was reindexed
2010-06-17 20:03:02 EDT NOTICE: table "notes" was reindexed
2010-06-17 20:03:02 EDT NOTICE: table "holdem_table" was reindexed
2010-06-17 20:03:21 EDT NOTICE: table "tourney_holdem_hand_player_statistics" was reindexed
2010-06-17 20:03:22 EDT NOTICE: table "holdem_hand_summary" was reindexed
2010-06-17 20:03:22 EDT NOTICE: table "holdem_table_session_summary" was reindexed
2010-06-17 20:03:23 EDT NOTICE: table "tourney_holdem_blinds" was reindexed
2010-06-17 20:03:23 EDT NOTICE: table "tourney_holdem_summary" was reindexed
2010-06-17 20:03:26 EDT NOTICE: table "tourney_holdem_hand_histories" was reindexed
2010-06-17 20:03:27 EDT NOTICE: table "tourney_holdem_hand_player_combinations" was reindexed
2010-06-17 20:03:28 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-17 20:03:28 EDT STATEMENT: REINDEX DATABASE "PT3 DB"
2010-06-17 20:03:29 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-17 20:03:29 EDT STATEMENT: VACUUM;
2010-06-17 20:03:32 EDT ERROR: invalid page header in block 3353 of relation "tourney_holdem_hand_player_detail"
2010-06-17 20:03:32 EDT STATEMENT: ANALYZE;
2010-06-17 20:03:34 EDT ERROR: invalid page header in block 3353 of relation "tourney_holdem_hand_player_detail"
2010-06-17 20:03:34 EDT STATEMENT: ANALYZE;
2010-06-17 20:04:23 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-17 20:04:23 EDT STATEMENT: CLUSTER tourney_holdem_hand_player_detail;
2010-06-17 20:04:25 EDT WARNING: there is no transaction in progress
2010-06-17 20:04:25 EDT WARNING: there is no transaction in progress
2010-06-17 20:04:26 EDT WARNING: there is no transaction in progress
2010-06-17 20:04:28 EDT WARNING: there is no transaction in progress
2010-06-17 23:12:12 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 23:12:12 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 23:12:13 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-17 23:12:13 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"


2010-06-18 04:04:43 EDT LOG: received fast shutdown request
2010-06-18 04:04:43 EDT LOG: aborting any active transactions
2010-06-18 04:04:43 EDT LOG: autovacuum launcher shutting down
2010-06-18 04:04:43 EDT LOG: shutting down
2010-06-18 04:04:44 EDT LOG: database system is shut down


2010-06-18 12:49:49 EDT LOG: database system was shut down at 2010-06-18 04:04:44 EDT
2010-06-18 12:49:49 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 12:49:49 EDT FATAL: the database system is starting up
2010-06-18 12:49:51 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 12:49:51 EDT FATAL: the database system is starting up
2010-06-18 12:49:52 EDT LOG: database system is ready to accept connections
2010-06-18 12:49:52 EDT LOG: autovacuum launcher started
2010-06-18 12:49:52 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 13:27:21 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 13:27:22 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 13:27:22 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 13:27:22 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 13:27:45 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 13:27:45 EDT STATEMENT: VACUUM;
2010-06-18 13:28:08 EDT ERROR: invalid page header in block 3356 of relation "tourney_holdem_hand_player_detail"
2010-06-18 13:28:08 EDT STATEMENT: ANALYZE;
2010-06-18 13:29:41 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 13:29:41 EDT STATEMENT: CLUSTER tourney_holdem_hand_player_detail;
2010-06-18 13:29:44 EDT WARNING: there is no transaction in progress
2010-06-18 13:29:44 EDT WARNING: there is no transaction in progress
2010-06-18 13:29:46 EDT WARNING: there is no transaction in progress
2010-06-18 13:29:48 EDT WARNING: there is no transaction in progress
2010-06-18 15:30:23 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:30:23 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:30:23 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:30:24 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:31:12 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:31:12 EDT STATEMENT: VACUUM;
2010-06-18 15:31:15 EDT ERROR: invalid page header in block 3358 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:31:15 EDT STATEMENT: ANALYZE;
2010-06-18 15:31:17 EDT ERROR: invalid page header in block 3355 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:31:17 EDT STATEMENT: ANALYZE;
2010-06-18 15:32:11 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:32:11 EDT STATEMENT: CLUSTER tourney_holdem_hand_player_detail;
2010-06-18 15:32:12 EDT WARNING: there is no transaction in progress
2010-06-18 15:32:12 EDT WARNING: there is no transaction in progress
2010-06-18 15:32:14 EDT WARNING: there is no transaction in progress
2010-06-18 15:32:15 EDT WARNING: there is no transaction in progress
2010-06-18 15:48:41 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:48:41 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:48:41 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:48:41 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:49:48 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:49:48 EDT STATEMENT: VACUUM;
2010-06-18 15:49:51 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:49:51 EDT STATEMENT: ANALYZE;
2010-06-18 15:49:53 EDT ERROR: invalid page header in block 3354 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:49:53 EDT STATEMENT: ANALYZE;
2010-06-18 15:50:50 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:50:50 EDT STATEMENT: CLUSTER tourney_holdem_hand_player_detail;
2010-06-18 15:50:52 EDT WARNING: there is no transaction in progress
2010-06-18 15:50:52 EDT WARNING: there is no transaction in progress
2010-06-18 15:50:54 EDT WARNING: there is no transaction in progress
2010-06-18 15:50:56 EDT WARNING: there is no transaction in progress
2010-06-18 15:58:02 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:58:02 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:58:02 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:58:02 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-18 15:58:46 EDT NOTICE: table "pg_class" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "sql_features" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "sql_implementation_info" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "pg_statistic" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "sql_languages" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "sql_packages" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "sql_parts" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "sql_sizing" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "sql_sizing_profiles" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "pg_ts_config" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "pg_ts_config_map" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "pg_ts_dict" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "pg_ts_parser" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "pg_ts_template" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "pg_type" was reindexed
2010-06-18 15:58:46 EDT NOTICE: table "pg_attribute" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_proc" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_autovacuum" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_attrdef" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_constraint" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_inherits" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_index" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_operator" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_opfamily" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_opclass" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_am" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_amop" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_amproc" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_language" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_largeobject" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_aggregate" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_rewrite" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_trigger" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_description" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_cast" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_enum" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_namespace" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_conversion" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "pg_depend" was reindexed
2010-06-18 15:58:47 EDT NOTICE: table "holdem_hand_summary" was reindexed
2010-06-18 15:58:49 EDT NOTICE: table "tourney_holdem_results" was reindexed
2010-06-18 15:58:49 EDT NOTICE: table "holdem_table" was reindexed
2010-06-18 15:58:49 EDT NOTICE: table "settings" was reindexed
2010-06-18 15:58:49 EDT NOTICE: table "holdem_hand_histories" was reindexed
2010-06-18 15:59:01 EDT NOTICE: table "tourney_holdem_hand_player_statistics" was reindexed
2010-06-18 15:59:03 EDT NOTICE: table "player" was reindexed
2010-06-18 15:59:03 EDT NOTICE: table "notes" was reindexed
2010-06-18 15:59:03 EDT NOTICE: table "tourney_holdem_hand_player_combinations" was reindexed
2010-06-18 15:59:03 EDT NOTICE: table "holdem_limit" was reindexed
2010-06-18 15:59:03 EDT NOTICE: table "tourney_holdem_hand_histories" was reindexed
2010-06-18 15:59:03 EDT NOTICE: table "tourney_holdem_blinds" was reindexed
2010-06-18 15:59:03 EDT NOTICE: table "tourney_holdem_summary" was reindexed
2010-06-18 15:59:04 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:59:04 EDT STATEMENT: REINDEX DATABASE "PT3 DB"
2010-06-18 15:59:05 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:59:05 EDT STATEMENT: VACUUM;
2010-06-18 15:59:07 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:59:07 EDT STATEMENT: ANALYZE;
2010-06-18 15:59:10 EDT ERROR: invalid page header in block 3353 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:59:10 EDT STATEMENT: ANALYZE;
2010-06-18 15:59:54 EDT ERROR: invalid page header in block 3352 of relation "tourney_holdem_hand_player_detail"
2010-06-18 15:59:54 EDT STATEMENT: CLUSTER tourney_holdem_hand_player_detail;
2010-06-18 15:59:55 EDT WARNING: there is no transaction in progress
2010-06-18 15:59:56 EDT WARNING: there is no transaction in progress
2010-06-18 15:59:57 EDT WARNING: there is no transaction in progress
2010-06-18 15:59:59 EDT WARNING: there is no transaction in progress
2010-06-18 16:30:29 EDT LOG: received fast shutdown request
2010-06-18 16:30:29 EDT LOG: aborting any active transactions
2010-06-18 16:30:29 EDT LOG: autovacuum launcher shutting down
2010-06-18 16:30:29 EDT LOG: shutting down
2010-06-18 16:30:29 EDT LOG: database system is shut down

The 16 prior files all looked like this (for the most part):

2010-06-13 19:05:11 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-13 19:05:11 EDT FATAL: the database system is starting up
2010-06-13 19:05:11 EDT LOG: database system was shut down at 2010-06-13 14:42:46 EDT
2010-06-13 19:05:12 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-13 19:05:12 EDT FATAL: the database system is starting up
2010-06-13 19:05:13 EDT LOG: database system is ready to accept connections
2010-06-13 19:05:13 EDT LOG: autovacuum launcher started
2010-06-13 19:05:13 EDT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2010-06-13 20:35:17 EDT LOG: received fast shutdown request
2010-06-13 20:35:17 EDT LOG: aborting any active transactions
2010-06-13 20:35:17 EDT LOG: autovacuum launcher shutting down
2010-06-13 20:35:17 EDT LOG: shutting down
2010-06-13 20:35:19 EDT LOG: database system is shut down


Hopefully this helps, because I am really just trying to find the easiest solution to this...again be it a full uninstall and reinstall, whatever....just want to be able to play on this machine again.

Look forward to your response.
Image17
06-20-2010 , 05:59 AM
The easiest solution is likely to be to create a new database, if PT3 can connect to PostgreSQL at all. If not, you could try reinstalling PostgreSQL - How to reinstall PostgreSQL.

If you're still having problems please create a Support ticket as Kraada suggested and one of our support technicians will work with you to sort this out.
06-21-2010 , 11:52 PM
Finally got a full reinstall of PostgreSQL to take.....so it works, for now.
Lets hope this is the end for now....thanks again.
Numerous Database Errors
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Numerous Database Errors

      
m