PDA

View Full Version : HELP - Vacuum running for more than 36 hours (error messages)



dragonrib
04-13-2010, 11:33 AM
I´m running a vacuum by pgadmin, after made a big purge in a big database.

I´ve already receive the same error message 18 times :

"ERROR: could not read block 222314 of relation 1663/16403/16503: Invalid argument"

So i click ok, and the process goes on...

Maybe in loop ?

Should i stop ?

I´ve already found in the messages, 9 times this same message :

"DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: analyzing "public.pokersites"INFO: "pokersites": scanned 1 of 1 pages, containing 20 live rows and 0 dead rows; 20 rows in sample, 20 estimated total rowsINFO: vacuuming "public.handhistories"INFO: "handhistories": found 0 removable, 4894267 nonremovable row versions in 624316 pages"

I have the full message log here if help.

Thanks for your help.

dragonrib
04-13-2010, 04:11 PM
Anyone ?

morny
04-13-2010, 06:30 PM
That usually is indicating some sort of problem with your database, try doing a reindex and if that doesnt help youll probably need to export your hands into a new database to avoid future problems

Patvs
04-13-2010, 06:33 PM
"ERROR: could not read block 222314 of relation 1663/16403/16503: Invalid argument" is the sign of a corrupt database.

You can
-1 reindex the entire database (hopefully, fixing the index solves the database corruption)--> more likely
-2 you'll have to create a new database.
Create a .backup in pgadminIII before you purge a large number of hands.