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.
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.