PDA

View Full Version : SQL vacuum taking forever and showing no signs of progress... should I be concerned?



pog0
02-04-2010, 08:58 PM
I purged about 30 million hands which would probably be more than half of my DB (from purge hands option, NOT from observed HH options) and am now in the process of a manual vacuum (full + analyze). It's been going for about 24 hours now and my hard drive has the exact same amount of used space as when I started it.

Is this normal or is something going wrong?

**
Worth noting: at one point when I checked up on it I saw the final message in the log as:

ERROR: failed to re-find parent key in index "playerhandscashkeycolumns_idx1" for split pages 1434312/122363
**
At this point the option to hit OK was available (which it isn't now because I presume it's still working).

I have an 870,000 K process of postgres.exe running along with 10 other instances running at under 60,000 K each.

system: *quad core, 32bit xp, "4" GB ram.* I believe my DB is 170 GB.

fozzy71
02-05-2010, 01:48 AM
It is froze and/or doing nothing. I would expect a vacuum on a DB that big, after a purge that big, to take a few hours, but not 24.


......
**
Worth noting: at one point when I checked up on it I saw the final message in the log as:

ERROR: failed to re-find parent key in index "playerhandscashkeycolumns_idx1" for split pages 1434312/122363
**
At this point the option to hit OK was available (which it isn't now because I presume it's still working).


That is a problem with one of your DB indexes.

You can try to fix that index - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Or you can try a general Reindex from the PGAdmin > Maintenance menu - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163


If neither of those things help, you will need to create a new DB, most likely.