MySql Fails to Start - Install IDE shows MYSQL Install Fail - RESOLVED - IDE3 UPDATE

[Unit101]

Problem:
New install of IDE (v2.2.0.39) on new PC with fresh Win 10 Pro x64 OS.
At end of install it says Database failed and prompts you to run the IDE troubleshooter.
Message Dialog like this: "Power PMAC IDE Installation Varification Report"
MySQL databases are no created.
NOTE: Please go to "IDE Troubleshooting"....
In IDE Troubleshooter you run button "IDE Troubleshooting" it says database repaired.
However it is NOT.
When you run IDE in Output window after starting you get a message like this:
Database Error: Unable to connect to any of the specified MySQL hosts...

What is Wrong:
MySQL service is NOT starting and running.
Go to Computer Services - Select MySQL in list - select Start.
It will fail with a Error 1067.
Open \data\compName.err and you see this :
InnoDB: Operating system error number 87 in a file operation.
File name .\ib_logfile0
File operation call: 'aio read'.

When MySQL starts it can't write to the ib_logfile0
- this seems to be a issue with how large the drive is and it sectors being 4096 instead of 512 in size
- so if you are running on a large >1.5TB or so this is a problem

FIX:
- only temporary fix ... if you manually DELETE the \data\ib_logfile0 then you can
start the MySQL no problem
- now start IDE and it is working with it's DBASE files fine

HOWEVER:
- next time you start system MySQL will FAIL to Start Again

Permanent fix:
- widely reported that a new switch is available in 5.6 > that lets you allow for
this, adding a line to my.ini will fix this issue
- but it appears we are using a older version for MySQL 5.0 so it is not supported

Can we simply manually install a newer MySQL and have the IDE use this ? I
don't see why not as long as the service is started and pointing to the correct dbase files... I will give this a try.

Thanks for any other suggestions or help.

mike

[Unit101]

Continue to work on this issue.

To make it work fine all I need to do is delete file:
C:\Program Files (x86)\MySQL\MySQL Server 5.0\data\ib_logfile0

Then start the MySQL service.
It starts fine and IDE seems happy with the database, Intellisense works...

Tried putting the MySQL in a different directory, no joy.

Also seems to ignore the my.ini settings related to database location, if
I change this and move the data dir it still works in same local dir as always.
In fact you can modify any of the my.ini settings and seems to have no effect when starting the service or process.

The fix is supposed to be add this line to my.ini
innodb_flush_method=normal

But I don't believe the ini is having any effect on startup... it is simply using some defaults.

Again if interested here is error log on startup of MySQL:
161226 6:51:18 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/o...codes.html
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.

Here is same LOG if I Delete the ib_logfile0 FIRST, it starts up fine
161226 6:54:12 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Error: all log files must be created at the same time.
InnoDB: All log files must be created also in database creation.
InnoDB: If you want bigger or smaller log files, shut down the
InnoDB: database and make sure there were no errors in shutdown.
InnoDB: Then delete the existing log files. Edit the .cnf file
InnoDB: and start the database again.
161226 6:54:12 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.41-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)

I'm convinced the issue is that I'm using a 2TB SSD and that MySQL is NOT using the my.ini settings... it reads it... but ignores the settings

Thanks

[Unit101]

RESOLVED !!!

Ok I was on the right track.

#1 forget about the my.ini it is not being used, not sure why but it is ignored by the MySQL service startup configured by IDE
- you can delete this file and it runs exactly the same
- the MySQL ignores ANY Settings in this file, including the location of Dbase files
- perhaps it is read by the IDE ?

#2 Issue is related to the size and type of HDD that IDE is installed on

[Unit101]

RESOLVED !!!

Ok I was on the right track.

#1 forget about the my.ini it is not being used, not sure why but it is ignored by the MySQL service startup configured by IDE
- you can delete this file and it runs exactly the same
- the MySQL ignores ANY Settings in this file, including the location of Dbase files
- perhaps it is read by the IDE ?

#2 Issue is related to the size and type of HDD that IDE is installed on
- some GBP or SSD, RAID ... larger drives >1.5TB will show this issue
- it is related to sector size of formatted drive

#3 FIX is well documented by other MySQL users
- it is to tell MySQL to use this when writing the files (logs)
innodb_flush_method=normal

- most users simply put this i the my.ini (or cnf linux) and it is fixed
- but as #2 states the my.ini is here ignored

#4 How to FIX
- go to regedt32 - HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL
- edit the Image Path (startup cmd)
- add cmd line switch to tell MySQL to use above "flush method"
- here is what it should look like:
"C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe" "--innodb_flush_method=normal --defaults-file=C:\Program Files (x86)\MySQL\MySQL Server 5.0\my.ini" MySQL

- notice I added the --innodb_flush_method=normal cmd line switch
- now this feature is used on startup and it works fine

I suspect this will NOT impact other systems... so would like to test on a typical system to see if still works fine... but I'm not a SQL expert... just weathered a bit.

[Unit101]

I had SAME ISSUE with IDE 3.0.1.0 INSTALL.
It fails to install and start the MySql service, it tells me to uninstall MySql which does not fix issue.

Error during install is with a Dialog box message:
"Failed to start the 'MySQL' service. Please try uninstalling 'MySQL'... and rerun the
PowerPMAC IDE installer."

Fix is same as before but now implemented using ini file, it appears that IDE3 is NOW using the MySql ini file on startup, the IDE2 did not.

1. So go to C:\Program Files (x86)\MySQL\MySQL Server 5.0
2. Edit the file "ppmac.ini"
Attached is my ppmac.ini file (rename from .txt to .ini to use this)
3. Add this line to the file inside the # SERVER SECTION
innodb_flush_method=normal
4. Save file
5. Rerun the IDE install (do NOT uninstall MySql)
6. Now the MySql will start and IDE will complete install and run ok.

[Unit101]

UPDATE 11/8/17 NEW INSTALL with Version 3.1.1.0 has same Issue.

It will fail to install with same error, MySql won't Start.
Need to do same fix to ppmac.ini file as before and re-install.

[J0hann]

(11-08-2017, 08:44 AM)Unit101 Wrote: UPDATE 11/8/17 NEW INSTALL with Version 3.1.1.0 has same Issue.

It will fail to install with same error, MySql won't Start.
Need to do same fix to ppmac.ini file as before and re-install.

Hello Mike,

Hi have a similar issue on IDE v.4: I'm trying to update my IDE from 4.0.3.0 to 4.1.0.24 using the patch installation. At the very beginning of the installation (as administrator), I have an MYSQL failure message:

"Failed to install the 'MySQL' tables required for PowerPMAC IDE (error code: failed to get port). Please try rebooting the PC and running the installer again."

I updated the .ini file but it did not work, the problem might be a different one.
Have you encountered this ? Do you have any fix ?

Thanks !

EDIT: solved by uninstalling everything and installing directly the full 4.1.0.24 firmware.

[gmschoon]

(11-08-2017, 08:44 AM)Unit101 Wrote: UPDATE 11/8/17 NEW INSTALL with Version 3.1.1.0 has same Issue.

It will fail to install with same error, MySql won't Start.
Need to do same fix to ppmac.ini file as before and re-install.

We have a similar issue with 4.2.0.13 fresh install on a clean Windows 10 (256 GB SSD) build. MySQL fails to install tables (error 1).

Tried following the suggested fixes, however it appears to be failing at an earlier stage in the process and as such deletes the ppmac4.ini (as per log below), as part of the failed install cleanup.

"1: Custom Action: The 'Install_PPMAC_MySQL_Files' batch file failed (error code: 1)
1: Custom Action: Entering 'RemovePMACMySQLDataFiles' function
1: Custom Action: Deleted 'ppmac4.ini' from C:\Program Files (x86)\MySQL\MySQL Server 5.0
...
CustomAction Install_PMAC_MySQL_Files returned actual error code 1602"

Based on the nature of the issue, we thought the quickest way to resolve this might be to create a new partition on the SSD, with sector size that MySQL 5 tables will be happy with.

Any suggestions appreciated...

[Matsuzawa Makoto]

hi,this is mac

>>gmschoon

could you success install IDEv4 by your way?

[Eric Hotchkiss]

Matsuzawa,

I'm not sure if reviving forum posts that could have been the same problem is the best strategy. If you are having trouble installing IDE 4 please send an email to support@deltatau.com so we can look into your issue specifically.

Regards,