PDA

View Full Version : ERROR:XX000 could not read block 903 of relation base/16385/16471: Invalid argument



Sahin88
07-16-2010, 08:24 AM
Hello,

if i trie to delet more then 500 or more at one time in HM i get this error message.

ERROR:XX000 could not read block 903 of relation base/16385/16471: Invalid argument

If i delet one hand or up to 100 hands it works.

I tried to Reindex my database.
At the reindex i get also the same message:

ERROR: could not read block 903 of relation base/16385/16471: Invalid argument


Can anyone help me to fix it??
I have to delet nearly 26K hands which i have played myself. And in 100 steps it takes to long time

_Loki_
07-16-2010, 12:21 PM
I've never tried to do what you're doing. There is no need to do what you're doing in the way that you're doing it & most probably you're giving HM/postgreSQL indigestion :)

Create a new DB
Import all your raw HH's
set hero name
reboot
Use purge function to remove the 26k hands from your DB
vacuum analyse full
re-index
defrag with postgreSQL service turned off & as many progs closed as possible
reboot

NOTES:
** don't purge until 1.11.03 is officially released - there's a bug in current version to do with purge - it's out in a few days
** the purged hands stats will still be in your DB

QUESTION:
Why these 26k hands ?
Are they from a site you no longer play ?
Because they are old ?
A game type you don't play any more ?
Your answer could simplify the above process

netsrak
07-16-2010, 01:44 PM
Your database is damaged, if the reindex doesn't fix it you need to create a new database and reimport hands, notes and summaries.