MySQL Bugs: #77674: MySQL Installer

Bug #77674	MySQL Installer
Submitted:	9 Jul 2015 19:18	Modified:	10 Nov 2015 22:50
Reporter:	SathyaMoorthy Saminathan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: Installer	Severity:	S1 (Critical)
Version:	MySQL5.6.25.0, 5.6.26	OS:	Windows (7 x64)
Assigned to:	Jose Gabriel Valencia Ornelas	CPU Architecture:	Any

Description:
Run mysql-installer-community-5.6.25.0
Installed packages list will be shown in MySQL Installer
Select MySQL Server 5.6.25 and then Click Reconfigure link.
In Accounts and Roles step, Click on check button the following unhandled exception throws

"Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

Service MySQL56 was not found on computer '.'." 

How to repeat:
1. Had MySQL Server 5.1 and uninstall without restarting the PC/Laptop upgrade MySQL Server to 5.6.25. 
2. On Type and Networking step Port Number 3306 was already used by 5.1 Version.Before moving to next step restart your PC/Laptop.
3. Run mysql-installer-community-5.6.25.0
4. Installed packages list will be shown in MySQL Installer
5. Select MySQL Server 5.6.25 and then Click Reconfigure link.
6. In Accounts and Roles step, Click on check button the following unhandled exception throws

"Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

Service MySQL56 was not found on computer '.'.

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidOperationException: Service MySQL56 was not found on computer '.'. ---> System.ComponentModel.Win32Exception: The specified service does not exist as an installed service
   --- End of inner exception stack trace ---
   at System.ServiceProcess.ServiceController.GenerateNames()
   at System.ServiceProcess.ServiceController.get_ServiceName()
   at System.ServiceProcess.ServiceController.Start(String[] args)
   at WexInstaller.Plugins.Server.MySQLServiceControlManager.Start(String serviceName)
   at WexInstaller.Plugins.Server.ServerConfigurationController.StartServer()
   at WexInstaller.Plugins.Server.ServerConfigUserPanel.buttonCheck_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
MySQLInstaller
    Assembly Version: 1.4.8.0
    Win32 Version: 1.4.8.0
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Installer%20for%20Windows/MySQLInstaller.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
MySQLInstaller.Core
    Assembly Version: 1.4.8.0
    Win32 Version: 1.4.8.0
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Installer%20for%20Windows/MySQLInstaller.Core.DLL
----------------------------------------
WindowsBase
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
xuqylqqs
    Assembly Version: 1.4.8.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
5p1pgm2o
    Assembly Version: 1.4.8.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
5kgglujx
    Assembly Version: 1.4.8.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
StandardPlugins
    Assembly Version: 1.4.8.0
    Win32 Version: 1.4.8.0
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Installer%20for%20Windows/StandardPlugins.DLL
----------------------------------------
System.ServiceProcess
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceProcess/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
----------------------------------------
wotph2a3
    Assembly Version: 1.4.8.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
mbm443iz
    Assembly Version: 1.4.8.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
dozdqx41
    Assembly Version: 1.4.8.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
MySql.Data
    Assembly Version: 6.8.3.0
    Win32 Version: 6.8.3.0
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Installer%20for%20Windows/MySql.Data.DLL
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

Hello SathyaMoorthy,

Thank you for the bug report.
I tried to reproduce the issue at my end using "mysql-installer-community-5.6.25.0.msi" and reconfigure 5.6.25 server but not seeing any issue in reconfiguration.
Could you please provide repeatable steps for us to confirm this issue at our end.

Thanks,
Chiranjeevi.

screenshot

Attachment: 77674.PNG (image/png, text), 80.32 KiB.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Steps to Reproduce

1. I already installed MYSQL 5.1 on my lapatop.
2. I was trying to install MYSQL 5.6 on my laptop.
3. Default Port 3306 was already assigned to MYSQL 5.1.
4. I cancelled installing MYSQL 5.6 and try to uninstall MYSQL 5.1 
5. After uninstalling MYSQL 5.1 it ask to restart, but i never restart it.
6. I start install MYSQL 5.6 version on lap without restarting my Lap.
7. With help of MYSQL Installer start installing MYSQL 5.6 on role master setp i got follwing error 
"Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

Note: Uninstall both MYSQL 5.1 and MYSQL 5.6 and restart my lap and try to install MYSQL 5.6, it was installed successfully.

Hello SathyaMoorthy,

Thank you for your feedback.
Verified this behavior on MySQL 5.6.26 version

Thanks,
Chiranjeevi.

Reproducing steps:

1). Install MySQL 5.6.25/5.6.26.
2). Cancel and close it installation process at Accounts and Roles step.
3). Try to reinstall same one and it shows MySQL Server installed one.
4). Click on "Reconfigure" link.
5). Give any root password in "Accounts and Roles" and click on "Check" button, will get error message.

screenshot.

Attachment: 77674.PNG (image/png, text), 81.82 KiB.

http://bugs.mysql.com/bug.php?id=78838 marked as duplicate of this one.

Posted by developer:
 
when the installer detect that data dir doesn't exists or doesn't exists the config file will behave now as a new configuration

Fixed as of the upcoming MySQL Installer 1.4.12 release, and here's the changelog entry:

The Accounts and Roles step of the Reconfigure procedure could halt and
emit an unhandled exception. This could happen if the initial
configuration of MySQL Server was terminated, or otherwise incomplete.

Thank you for the bug report.