vacuum&analyze fatal error

Let us know what features not currently in the PT4 should be added.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

vacuum&analyze fatal error

Postby zhazham » Wed Mar 21, 2012 1:52 am

Good day, every time you import PT4 writes:
12:19:53 am: Import complete. 92,674 hands in 102 files were imported. (38 errors, 2,625 duplicates)
12:19:54 am: Performing database maintenance ...
12:43:46 am: Error: Unable to maintain database. Reason: Unable to execute query: VACUUM ANALYZE;; Reason: Fatal Error (ERROR: could not read block 119423 of relation 1663/237484/237514: Invalid argument)
12:43:46 am: Maintenance complete.
zhazham
 
Posts: 7
Joined: Sat Jan 15, 2011 8:06 am

Re: vacuum&analyze fatal error

Postby kraada » Wed Mar 21, 2012 10:01 am

Please check your anti-virus to make sure that no files in the PostgreSQL directory were quarantined - the mostly likely cause for the error you posted is that a file from the PostgreSQL directory was removed and it needs to be restored in order to function again properly.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PT4 Feature Requests

Who is online

Users browsing this forum: No registered users and 0 guests