Unknown error

[TuKE]

Hi,

i try to use housekeeping, but i received this error (i try to close PT3 and use housekeeping again, but error was there all the time):

There were errors during the housekeeping process:
Unable to execute query: CREATE TABLE "new_holdem_hand_player_statistics" AS SELECT * FROM "holdem_hand_player_statistics" ORDER BY id_player DESC, id_session DESC, id_hand DESC;; Reason: Fatal Error (ERROR: could not read block 41237 of relation 1663/16438/28774: Invalid argument )
Unable to execute query: VACUUM FULL;; Reason: Fatal Error (ERROR: could not read block 41237 of relation 1663/16438/28774: Invalid argument )

What does it mean?

Thx

[kraada]

There are a few reasons possible for this error.

The first reason is a result of faulty hardware or a system crash. In that case, 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. You can feel free to try this method and see if it works.

The second reason is a result of an overzealous anti-virus or anti-spyware program. Make sure your a/v and a/s both have exceptions for PostgreSQL letting it do whatever it wants (especially on port 5432).

The third could be a dearth of system resources. If you are pushing an older computer too hard or are running too many other things while trying to do a massive import, you can run into this issue. There isn't much you can do about this one except stop running other programs at the same time. The good news is you can attempt to test for this fairly easily by just closing everything else and seeing if you still get the issue. The bad news is that if that is the issue, short of upgrading your computer or buying a new one there isn't much else you can do (other than stopping the other programs when you want to use PT3).