MySQL Bugs: #66395: 5.6.6 installer wants to upgrade 5.5 server

Bug #66395	5.6.6 installer wants to upgrade 5.5 server
Submitted:	15 Aug 2012 8:03	Modified:	12 Mar 2013 1:07
Reporter:	Peter Laursen (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: Installer	Severity:	S3 (Non-critical)
Version:	5.6.6	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	qc

Description:
It seems that the 'integrated installer cannot handle multiple MySQL installations. 

I have 5.5.33 and 5.6.5 installed (installed with the 'standalone' .msi installers). I downloaded mysql-installer-community-5.5.27.0 and mysql-installer-community-5.6.6-m9.0 ('unified' installers).

1) 
Upgrading 5.5.x using with mysql-installer-community-5.5.27.0 fails with ther error log 

Action 09:50:13: INSTALL. 
1: MySQL Server 5.5 2: {B9ED0ABA-7E2B-4C1B-8466-40E8BCE3DCA3} 
Action 09:50:13: FindRelatedProducts. Searching for related applications
Action 09:50:13: AppSearch. Searching for installed applications
Action 09:50:13: LaunchConditions. Evaluating launch conditions
A later version of MySQL Server 5.5 is already installed. Setup will now exit.
1: MySQL Server 5.5 2: {B9ED0ABA-7E2B-4C1B-8466-40E8BCE3DCA3} 3: 3 

(this was also reported by me with the 'standalone' installer: 
http://bugs.mysql.com/bug.php?id=56889)

2)
When trying to upgrading 5.6.5 with mysql-installer-community-5.6.6-m9.0 The installer detects the 5.5x instance and attempts to upgrade it - and not the 5.6 instance.   An image will be attached.

How to repeat:
See above.

Suggested fix:
Handle multiple MySQL versions in parallel like before (or as supposed to be working before). 5.5 installer should handle 5.5 and upgrade 5.5 to latest version.  5.6 installer should handle 5.6.

5.6 installer attempts to upgrade 5.5 and not 5.6

Attachment: wrongversion.jpg (image/jpeg, text), 51.99 KiB.

Added Windows as OS

There are two new installer files available on the mirror - mysql-installer-community-5.5.27.2.msi and mysql-installer-community-5.6.6-m9.1.msi - but they don't change anything of what reported here.

Hello Peter,

can you please clarify which 5.5.x version you had installed before you tried to update using the new installer(s)? You wrote in the initial description "5.5.33" but I assume that's a typo and it was 5.5.23 (as shown in your screenshot later on).

thanks in advance

Yes .. you are right of course.  It was 5.5.23 I atttempted to upgrade from. This was was upgraded from 5.5.22 using the 'stand-alone' .msi installer etc.  I don't remember when I did a fresh install last time and what the version was, but it could be up to around 2 years ago.

So the underlying reason for my issues could be an incorrect registry entry or similar added by an older installer version - older than 5.5.23 or maybe even an old 5.1 or 5.6 installer.

I could give it a try to unstall all my MySQL servers completely from the system, cleanse regsitry and do a fresh install of 5.0.96, 5.1.65, 5.5.27 and 5.6.6 (in that order - I will need all of them for application testing). 

I have no problems personally by resolving this for myself. I tend to completely forget about MySQL installers totally for the future (and install MySQL as a service using "mysqld -install servicename" command instead) as they have wasted a lot of my time over the last 6 months - also because the bug reports I have posted about it have been largely ignored.  The bottomline is a practically nothing with any MySQL installer works for me now  - and using the installers is a complete waste of my time. It leads nowhere except for bug reports that are getting ignored.

But if you want I may be able to find time for a last attempt to make the installers work in the weekend. If you have some hints on what I should pay attention to/look for etc. please specify.

Thank you for the bug report. Verified on 32-bit Windows XP. I had 5.5.24 (from Installer) and 5.6.5 (from standalone .msi) installed, and Installer 5.6.6 tried to upgrade 5.5.24 installation without any extra questions or visible options.

Hello,

I just would like to emphrase that the installer is nog working on at least my 64-bit windows7 systemen (trying to update from 5.6.5 m8).

IMHO it is not an improvement at all

I would suggest to generate the old but working 64 bit msi.

Valeriy, could you please pass that message !

Sincerely,

Louis

Hello,

I just would like to emphrase that the installer is nog working on at least my 64-bit windows7 systemen (trying to update from 5.6.5 m8).

IMHO it is not an improvement at all

I would suggest to generate the old but working 64 bit msi.

Valeriy, could you please pass that message !

Sincerely,

Louis

This seems to be fixed in mysql-installer-community-5.6.8.0-rc. I was able to upgrade from 5.6.7 while 5.5.28 was installed and running.

That bug was fixed as of MySQL Installer 1.1.4, and here's the changelog entry:

MySQL Installer would fail to upgrade previous installations of MySQL Server.

Thank you for the bug report.