major database error

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

major database error

Postby cocas » Wed Jun 18, 2008 5:29 am

when i start the auto import funtion i get this message:

" Fatal Exception during Auto-Import process: Unable to execute query: INSERT INTO player VALUES (0, 0, '[Split Pot]', '[Split Pot]', 0, 0, FALSE);; Reason: Fatal Error (ERROR: invalid page header in block 675 of relation "player" )"

i tried to restart my screen name but but isnt working either..........
cocas
 
Posts: 1
Joined: Sat Mar 08, 2008 7:12 am

Re: major database error

Postby tarix » Wed Jun 18, 2008 8:17 am

Have you analyzed your database yet? It sounds like it got corrupted. Do you have plenty of free space on your database drive?
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Re: major database error

Postby Peligroso » Wed Jun 18, 2008 2:22 pm

The error that you are experiencing is due to a corrupted database which is typically caused by faulty hardware. You can configure PostgreSQL to ignore this error and remove the bad data.

Go Start->PostgreSQL->Configuration Files->Edit postgresql.conf

At the very bottom of this file add the following line:

zero_damaged_pages = on

File->Save. Then go Start->Programs->PostgreSQL->Reload Configurations.

I hope this will resolve your issues.
Peligroso
 
Posts: 1483
Joined: Mon Dec 10, 2007 6:51 pm
Location: Sweden

Re: major database error

Postby keggler » Wed Jun 18, 2008 2:28 pm

wallop - nice one - that should do it - the good ol' zero_damaged_pages = on switch - ahhh memories...

just to add; it would be worth investigating what hardware causes the postgres corruption - hard-drive about to go ass-over-tit???

back-up everything while you have the chance (2 independent methods) - maybe look at your SMART stats for the HDD with the db on it...

susan
keggler
 
Posts: 640
Joined: Sun Jun 01, 2008 4:53 am


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 14 guests

cron
highfalutin