I'm facing with a strange problem.
I'm running XAMPP 5.6.23.0 under Sierra, I have created plists to start MySQL and Apache automatically. This works fine (Applications work).
However to make the MySQL Plist working I had to do : chmod 600 my.cnf
The MySQL plist is as follows :
- Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>EnableTransactions</key>
<true/>
<key>Label</key>
<string>apachefriends.xampp.mysql.start</string>
<key>ProgramArguments</key>
<array>
<string>/Applications/XAMPP/xamppfiles/xampp</string>
<string>startmysql</string>
</array>
<key>RunAtLoad</key>
<true/>
<key>WorkingDirectory</key>
<string>/Applications/XAMPP/xamppfiles</string>
<key>KeepAlive</key>
<false/>
<key>AbandonProcessGroup</key>
<true/>
</dict>
</plist>
If I start the control panel, the MySQL status goes to "Checking" then "Stopped" but the Apache status is "Running". This is wrong because MySQL works.
From the control panel, If I stop all, obviously all server status go to "Stopped". However, MySQL remains active (because my applications which connect to any data base still works).
Now, If I'm trying to restart MySQL from the control panel, status goes to "Starting" and after a while (about 20 seconds) returns to "Stopped". At this time, I checked the err log file, and noticed a loop for messages written into this file (see bellow). That I do not understand.
So I tried to push further my investigations.
I removed the PList from /Library/LaunchDaemons, and just tried to start MySQl from the control panel. This time everything went OK. It seems to me there is a sort of incompatibility with Plist and the Control-panel procedures.
Any idea ? Thanks a lot in advance
Gégé
macbook-pro-de-gerard.home.err
2017-01-15 10:53:59 1843 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/macbook-pro-de-gerard.home.pid ended
2017-01-15 11:02:39 1183 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
2017-01-15 11:02:39 140736210990016 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2017-01-15 11:02:39 140736210990016 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld (mysqld 10.1.13-MariaDB) starting as process 1325 ...
2017-01-15 11:02:39 140736210990016 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
2017-01-15 11:02:39 140736210990016 [ERROR] mysqld: Can't lock aria control file '/Applications/XAMPP/xamppfiles/var/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds
2017-01-15 11:03:10 140736210990016 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/Applications/XAMPP/xamppfiles/var/mysql/aria_log_control'
2017-01-15 11:03:10 140736210990016 [ERROR] Plugin 'Aria' init function returned error.
2017-01-15 11:03:10 140736210990016 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2017-01-15 11:03:10 140736210990016 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-15 11:03:10 140736210990016 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-15 11:03:10 140736210990016 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-15 11:03:10 140736210990016 [Note] InnoDB: Memory barrier is not used
2017-01-15 11:03:10 140736210990016 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-01-15 11:03:10 140736210990016 [Note] InnoDB: Using SSE crc32 instructions
2017-01-15 11:03:10 140736210990016 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-01-15 11:03:10 140736210990016 [Note] InnoDB: Completed initialization of buffer pool
2017-01-15 11:03:10 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:10 140736210990016 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-01-15 11:03:10 140736210990016 [Note] InnoDB: Retrying to lock the first data file
2017-01-15 11:03:11 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:11 140736210990016 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-01-15 11:03:12 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:12 140736210990016 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-01-15 11:03:13 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:13 140736210990016 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-01-15 11:03:14 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:14 140736210990016 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-01-15 11:03:15 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:15 140736210990016 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-01-15 11:03:16 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:16 140736210990016 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-01-15 11:03:17 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:17 140736210990016 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-01-15 11:03:18 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:18 140736210990016 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-01-15 11:03:19 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:19 140736210990016 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-01-15 11:03:20 140736210990016 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1, error: 35
2017-01-15 11:03:20
it loops forever.... but if I exit from control panel (stop) the loops terminates and the following messages are added to the error log.
InnoDB: Error number 35 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2017-01-15 11:28:11 140735724544960 [ERROR] InnoDB: Can't open '/Applications/XAMPP/xamppfiles/var/mysql/ibdata1'
2017-01-15 11:28:11 140735724544960 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2017-01-15 11:28:11 140735724544960 [ERROR] Plugin 'InnoDB' init function returned error.
2017-01-15 11:28:11 140735724544960 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-01-15 11:28:11 140735724544960 [Note] Plugin 'FEEDBACK' is disabled.
2017-01-15 11:28:11 140735724544960 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-01-15 11:28:11 140735724544960 [ERROR] Aborting
2017-01-15 11:28:11 883 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/macbook-pro-de-gerard.home.pid ended