Beta 30.7 Update Cache issue

[Josiah]

I updated to beta 30.7 from 30.5 today. I imported 57,998 hands into a database which contained (before import) 318,445 hands, of which 283,892 were cached. I have checked Cluster, Vacuum, Analyze & Update Cache upon completion.

The import ran fine at 220.3 h/s (normal speed), the Housekeeping part took 1:39:53, which is very long. Under 30.5 it used to run 10 minutes or so. With 1.5 million hands in a database it usually runs a bit more than an hour.

I tried 30.6 but reverted to 30.5 because it would exit during Housekeeping with an error (something like "lost database connection"). I did not report this due to lack of time.

I will try again tomorrow evening, if it takes the same amount of time I will probably revert to 30.5 again.

Any thing I should do to help identify the issue?

[Josiah]

Brief update: I imported 8962 hands, with Cluster, Vacuum, Analyze & Update Cache upon completion checked. Housekeeping ran 49:03. Cluster, Vacuum & Analyze took less than 5 min. The rest of the time was spent in Update Cache.

[WhiteRider]

Once your cache is up to date (100%) it will now stay updated incrementally (except in a few cases like changing aliases, changing a sessions limit description, adding custom stats, for instance).

[Josiah]

I just ran the following tests:

1) save database with pg_dump -C PT3-2010-02a >PT3-2010-02a-20100222 (on Linux)
2) dropdb PT3-2010-02a (on Linux)
3) psql postgres <PT3-2010-02a-20100222 (on Linux)
---------------------------
4)
test PT3 beta 30.7 (Win2K)

Database PT3-2010-02a
Cache Status 391,957 of 391,957 (100%)
import of 5 files 15:51:28
finished 15:52:23, 4035 hands in 5 files (0 errors, 163 duplicates)

15:52:28 Housekeeping (Cluster, Vacuum, Analyze, Update Cache)
Cluster ran 02:46 (approximate)
Vacuum ran 0:07 (approximate)
Analyze ran 0:07 (approximate)
16:33:08: Housekeeping Complete (~41 min)
Cache Status 395,992 of 395,992 (100%)
-----
5) dropdb PT3-2010-02a (on Linux)
6) psql postgres <PT3-2010-02a-20100222 (on Linux)
7) Install PT3 beta 30.5 (in Win2K)
-----
8)test PT3 beta 30.5 (Win2K)

Database PT3-2010-02a
Cache Status 391,957 of 391,957 (100%)
import of 5 files 16:47:26
finished 16:48:34, 4035 hands in 5 files (0 errors, 163 duplicates)
16:48:39 Housekeeping (Cluster, Vacuum, Analyze, Update Cache)
Cluster ran 02:15 (approximate)
Vacuum ran 0:05 (approximate)
Analyze ran 0:05 (approximate)
17:11:48: Housekeeping Complete (~23 min)
Cache Status 395,992 of 395,992 (100%)
----------------------------------------------------------------------
Beta 30.5 runs housekeeping significantly faster than 30.7, Specifically the Update Cache phase.

Incremental update does not seem to be happening,

[WhiteRider]

I suspect that is because there are additional things to be cached in 30.7 which aren't in 30.5 which means the cache needs to be fully rebuilt.
If you build the cache in 30.7 then import a small number of hands how long does the cache update take after that?

FWIW Win2k is not a supported operating system.

[Josiah]

If you build the cache in 30.7 then import a small number of hands how long does the cache update take after that?

Hmmm, that is what I did. The OP describes the initial run with 30.7. The second post describes a subsequent run importing only 8962 hands.

In the test I start with a database in which 30.7 has already fully updated the cache. 30.7 says that the cache is 100%, and so does 30.5.

30.7 is slower than 30.5.

I am aware that W2k is not officially supported, and will move to XP if I have to, but I would rather not. XP is bloatware.

[kraada]

Could you please create a support ticket with the detailed report above? I want to make sure this issue doesn't get lost.

[Josiah]

Support ticket posted. Note that I have, at your request, done this several times, yet no one has ever followed up.

[tarix]

Support ticket posted. Note that I have, at your request, done this several times, yet no one has ever followed up.

Support has responded to every ticket you've opened with us except your most recent one about this issue.

You can review your tickets at the My Support Tickets page.

[Josiah]

Support has responded to every ticket you've opened with us except your most recent one about this issue.

You can review your tickets at the My Support Tickets page.

OK, you are correct, but I have not received any emails. I just tested the address, it works. Nothing in the junk mail folder. Have I inadvertently set a "no mail" option somewhere? If so I cannot find it.