Errors during housekeeping process

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Errors during housekeeping process

Postby Dilas » Tue Mar 29, 2011 12:30 pm

At the end of housekeeping I get the following error message:

There were errors during the housekeeping process:
Unable to execute query: REINDEX DATABASE "PT3 DB"; Reason: Fatal Error (ERROR: concurrent delete in progress )
Unable to execute query: VACUUM;; Reason: Fatal Error (ERROR: invalid page header in block 64175 of relation "holdem_hand_player_detail" )
Unable to execute query: ANALYZE;; Reason: Fatal Error (ERROR: invalid page header in block 64212 of relation "holdem_hand_player_detail" )
Invalid PostgreSQL connection object

What can I do ?
Dilas
 
Posts: 138
Joined: Wed Apr 23, 2008 11:48 am

Re: Errors during housekeeping process

Postby kraada » Tue Mar 29, 2011 1:01 pm

There are two main reasons for this error. The first is a result of data corruption from a computer crash that requires reindexing your database. You can reindex your database from the Housekeeping menu.

The second reason for this error is a result of faulty hardware. You can set PostgreSQL to ignore these errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text "zero_damaged_pages = on" on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data. If you continue to have problems with that hard drive, you should consider replacing it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 7 guests

cron