Open Side Menu Go to the Top

08-09-2009 , 11:27 PM
I've been getting this recently

2009/08/09 20:24:56: PokerStars: Unable to import hand (#31450222208). Reason: Unable to execute query: COPY holdem_hand_player_combinations FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 24339 of relation base/16395/34133 CONTEXT: COPY holdem_hand_player_combinations, line 1: "6991947 31441 t f f f f
Auto import error
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Auto import error
08-10-2009 , 04:33 AM
There are two main reasons for this kind of 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 PostgreSQL command prompt. Click Start --> Programs --> PostgreSQL --> Command prompt. At the prompt that appears, type “reindexdb -a” and hit enter. Be aware that if you have large databases this may take a while, so be patient and wait for it to finish.
(If the re-index doesn't work because you are not logged in as user 'postgres' enter: "reindexdb -U postgres -a").

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.
08-10-2009 , 06:04 AM
i'm pretty sure its the first reason you gave, since i was having computer troubles earlier

i'm using postgresql 8.4 so i don't have a "command prompt" option in the start menu. where else can i go to reindex my database?
08-10-2009 , 09:30 AM
Start --> Programs --> PostgreSQL 8.4 --> psql to 'postgres'.

Type \l and hit enter.
\connect "database name" and hit enter to connect to your database.

Once the prompt changes, type REINDEX DATABASE; and hit enter (don't forget the semicolon).

\q to quit.
08-10-2009 , 09:08 PM
Quote:
Originally Posted by Kraada
Start --> Programs --> PostgreSQL 8.4 --> psql to 'postgres'.

Type \l and hit enter.
\connect "database name" and hit enter to connect to your database.

Once the prompt changes, type REINDEX DATABASE; and hit enter (don't forget the semicolon).

\q to quit.

i dont have a psql to postgres option. the closest thing to what youre describing is SQL Shell (psql) which is like a command prompt

i was able to connect to my database but then i got this message

ERROR: syntax error at or near ";"
Line 1: REINDEX DATABASE;
^



08-11-2009 , 04:43 AM
Looking at the docs for this (http://www.postgresql.org/docs/8.4/s...l-reindex.html) it looks like you have to include the database name too.

broken_db=> REINDEX DATABASE broken_db;
08-12-2009 , 10:34 PM
still get the same error after purging and reimporting the new 50nl hands. finished indexing and housekeeping but still doesnt work

any other ideas? this is really frustrating to not be able to play because of pt3 screwing up. i haven't grinded for 3 days because of technical difficulties

Last edited by AFchung; 08-12-2009 at 10:42 PM.
08-13-2009 , 12:26 AM
can't edit for some reason. but heres the error

08-13-2009 , 03:25 AM
You'll probably find the simplest solution is to create a new database and re-import your hands into it.
Database Management & Maintenance Guide
Auto import error
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Auto import error

      
m