PT 3 White Screen/ Freeze (housekeeping imppossible)

[mista_nice_guy]

I got a big problem with PT3 on Vista. Since 2 weeks all my tourney stats seem to be set to 0. Players from which I definitely had a couple hundred hands were set to 0 hands on the HUD. I suppose it has to with the Tourney Cache which is at 83%. AFAIK i have to update Cache to fix this, but its not possible anymore. It's been running for a around 20 hours and when i click on sth (either pokertracker or even windows explorer), PT3 turns white and freezes. To make things worse I can't even use Task Manager to shut PT3 down. And I can't shut down Windows via the Start-Button, which means I had to use the power-button of my notebook every time that happened. Same thing for backup. I cant backup my databases, because the progress stops at 10.68MB and stays there. Then again when I click on sth: White screen&Freeze...Now i reinstalled PostgreSQL but it still doesnt work.

[kraada]

If you try just doing the Cache Rebuild (and no other housekeeping functions), does that complete? If so that would solve this issue for you.

[mista_nice_guy]

I tried the Cache Rebuild once, along with the other housekeeping options. It was the first thing I tried resulting in a freeze as well. I will try it again this evening without the other options and tell you the result. However I'm concerned that my database is in bad shape, since I had to switch of my notebook via the power button a dozen times by now. (On startup checkdsk is automatically running saying sth. wrong with the "pgstat.stat"-file, just FYI) Is there anyway to check if the database is okay? I'm playing on Party Poker in case this is important.

[kraada]

That's why I said to do it without the other options.

Take a look in the Event Viewer and see if there are any errors relating to PostgreSQL there - that would give us some clues as to what's going on if there's database or hard drive errors (you can find Event Viewer in Control Panel -> Administrative Tools).

[mista_nice_guy]

The last error concerning SQL seems to be from February, total number of errors 3, all of those occured simultaneously simultaneously. But PT3 and Vista crashed each of the last 5 or 6 days. Didn't run the rebuild cache yet, gonna report soon as try.

[WhiteRider]

OK, let us know how the cache rebuild goes, but I would suggest that you try to make a full export as it's possible you'll need to re-import to a new database.

[mista_nice_guy]

Okay, cache rebuild worked indeed, took around 15 minutes. I did Cache Update as well which only took 5 minutes. Didn't play since then though, so I'm not sure yet if the hands missing are back in the HUD now. So now I have to do a full export? Do I have to run some of the other house keeping options as well? Thx for your help.

[kraada]

The other housekeeping options shouldn't make a difference here (except possibly for Reindex so that might be worth trying). See if your data looks right - if so you may not need to make a new database (then again, given the speed of the rebuild, making a new database might not take that long, either).

[mista_nice_guy]

One reason I was thinking about a new database was that I'm concerned whether the stats are still right.

Can I be sure the stats are correct, or is it possible that some stats are shown wrongly because I had to switch off my PC while running PT3.

I mean if there's a problem with the DB would some hands simply be left out completely or could the value of some stats also be affected. (i.e. wrong 3Betting % or PFR)

[kraada]

The cache rebuild rebuilds all of the stats from the data in the database, so they should be correct. But if you want to be 100% sure the only way to do so is to reimport into a new database at this point.