Bug #40412 Installer does not uninstall or wipe out previous installation
Submitted: 29 Oct 2008 22:52 Modified: 29 Oct 2008 22:56
Reporter: Andy Bang Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Enterprise Monitor: Installing Severity:S2 (Serious)
Version:2.0 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[29 Oct 2008 22:52] Andy Bang
Description:
The Service Manager installer does not uninstall or wipe out the previous installation when you answer "Yes" to "The directory you selected already contains a MySQL installation.  If you continue installation all data will be lost.  Do you wish to continue?"

How to repeat:
1) Install an older build of the Service Manager (I used 7013 because this is the build someone started with who first reported the problem).
2) Install an agent, start it, and let it run for a few minutes.
3) Stop all services and wait a few minutes.
4) Start the 7078 Service Manager installer.
5) Just click "Next" to accept defaults.
6) On the Installation Directory screen it will say: "The directory you selected already contains a MySQL installation.  If you continue installation all data will be lost.  Do you wish to continue?"
7) Click "Yes".
8) Finish installation and tell it to start the Service Manager.
9) You'll get a 404 error.  If you look in the Tomcat logs you'll see various error messages including "Table merlin.schema_version does not exist".
10) Use a MySQL client to look in the MySQL server instance.  You'll see both a "merlin" database and a "mem" database.  The "merlin" database is from the 7013 installation and the "mem" database is from the 7078 installation.  The "merlin" database should not be there if truly "all data will be lost".
11) Also note that on Windows you'll see two instances of "MySQL Enterprise Monitor" in "Add/Remove Programs".

Suggested fix:
Wipe out all previous files before installing the new files and don't create a second instance of the same thing in "Add/Remove Programs".

As an alternative, if the suggestion above is not feasible, we should not allow installation to continue and should advise the user to uninstall the old one before installing this one in the same place.
[29 Oct 2008 22:56] Andy Bang
A bug submission somehow got duplicated.