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
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