Bug #31680 graph cache needs to be invalidated on server startup
Submitted: 18 Oct 2007 1:36 Modified: 24 Jul 2008 8:45
Reporter: Sloan Childers Email Updates:
Status: Closed Impact on me:
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:2.0 OS:Any
Assigned to: Mark Matthews CPU Architecture:Any

[18 Oct 2007 1:36] Sloan Childers
if you change languages the server needs to restart.  on restart graphs in the cache will be in the wrong language

How to repeat:
switch language from english to japanese
wait for the server to restart (takes 30 seconds)
hit the front page and english graphs in the cache are still displayed

Suggested fix:
blast the graph cache each time the server restarts and/or each time the user locale is changed
[23 Oct 2007 0:53] Joshua Ganderson
I'm confused about the mention of server restart on locale change. Since different users will have different locale's, wouldn't that mean that each request needs to be in its own locale? If this is about objects being cached that retain the locale they were instantiated with, shouldn't we be clearing that cache instead of restarting?

Perhaps I totally misunderstand but this all sounds pretty fishy to me. I _think_ this bug should be to add the user's locale to the graph name so that users can still share graphs without language collisions. Alternatively we could cache graphs by user and clear the cache when the locale changes - less performant but follows more closely with possible permissions models on viewing servers.
[23 Oct 2007 1:59] Joshua Ganderson
The server doesn't auto-restart after a user changes their locale (Sloan didn't comment on my questions about this from the bug description). Also, Sloan approved my suggestion to add the locale designation to the graph name so that you can't get graphs in the wrong locale from caching.
[23 Oct 2007 19:36] Joshua Ganderson
patch sent
[6 Nov 2007 16:10] Sloan Childers
No server restart is required.  The content of this bug was mixed with another issue erroneously.

If you change user locale the graph cache would continue to display the graph in the last locale until it times out.  The fix was to add a locale name to the graph name in the cache.
[14 Nov 2007 4:14] Andrew Cwik
fixed in
[17 Nov 2007 18:54] Sloan Childers
Fixed in 1.3, reopening to fix in 2.0
[4 Feb 2008 20:13] Joshua Ganderson
r5926 - Completed in 2.0
[22 May 2008 21:06] Marcos Palacios
Verified fixed in bld
[24 Jul 2008 8:45] Tony Bedford
An entry was added to the 1.3 and 2.0 changelogs:

If the user locale was changed the graph cache would continue to display the graph in the last locale until it timed out.