vaccuum/analyze database error

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

vaccuum/analyze database error

Postby schuttedog » Tue May 20, 2008 9:39 pm

i can't vaccuum/analyze my database anymore. now i get this database error:


an error has occurred trying to perform the requested action. the error was:
7 - SQLSTATE = 58P01
ERROR: could not access the statusof transaction 4280664096;
Error while executing the query

any help would be greatly appreciated.

thanks
schuttedog
 
Posts: 16
Joined: Tue Mar 18, 2008 1:23 pm

Re: vaccuum/analyze database error

Postby ptrack pat » Tue May 20, 2008 9:41 pm

You can try reindexing as detailed here
http://www.pokertracker3.com/forums/arc ... ex+pgadmin
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: vaccuum/analyze database error

Postby schuttedog » Tue May 20, 2008 10:06 pm

thanks for the response, i will try that.
schuttedog
 
Posts: 16
Joined: Tue Mar 18, 2008 1:23 pm


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 17 guests

cron