mysql not starting [solved]

Problems with the Linux version of XAMPP, questions, comments, and anything related.

mysql not starting [solved]

Postby doctorsubtilis » 31. January 2021 21:20

I had to downgrade lampp from php8 to php 7.4 due to problems with phgedview/webtrees and others apps.
Copuied config (http, my.conf, php.ini to the new installation, as usual).
But now I have a new problem: mysql doesn't start.
Here the log:
Code: Select all
2021-01-31 21:17:06 0 [ERROR] InnoDB: Operating system error number 11 in a file operation.
2021-01-31 21:17:06 0 [ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable'
2021-01-31 21:17:06 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2021-01-31 21:17:06 0 [ERROR] InnoDB: Cannot open datafile '/opt/lampp/var/mysql/ibdata1'
2021-01-31 21:17:06 0 [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!
2021-01-31 21:17:06 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
2021-01-31 21:17:06 0 [Note] InnoDB: Starting shutdown...
2021-01-31 21:17:06 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-01-31 21:17:06 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-01-31 21:17:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-31 21:17:06 0 [ERROR] Failed to initialize plugins.
2021-01-31 21:17:06 0 [ERROR] Abortingsame InnoDB data or log files.
2021-01-31 21:16:43 0 [ERROR] InnoDB: Unable to lock /opt/lampp/var/mysql/ibdata1 error: 11
2021-01-31 21:16:43 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
[...]
2021-01-31 21:17:06 0 [ERROR] InnoDB: Unable to lock /opt/lampp/var/mysql/ibdata1 error: 11
2021-01-31 21:17:06 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-01-31 21:17:06 0 [Note] InnoDB: Unable to open the first data file
2021-01-31 21:17:06 0 [ERROR] InnoDB: Operating system error number 11 in a file operation.
2021-01-31 21:17:06 0 [ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable'
2021-01-31 21:17:06 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2021-01-31 21:17:06 0 [ERROR] InnoDB: Cannot open datafile '/opt/lampp/var/mysql/ibdata1'
2021-01-31 21:17:06 0 [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!
2021-01-31 21:17:06 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
2021-01-31 21:17:06 0 [Note] InnoDB: Starting shutdown...
2021-01-31 21:17:06 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-01-31 21:17:06 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-01-31 21:17:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-31 21:17:06 0 [ERROR] Failed to initialize plugins.
2021-01-31 21:17:06 0 [ERROR] Aborting
Last edited by doctorsubtilis on 31. January 2021 21:30, edited 1 time in total.
doctorsubtilis
 
Posts: 9
Joined: 11. September 2020 15:44
XAMPP version: 7.4.9.0
Operating System: Linux - KDE Neon 20.04

Re: mysql not starting

Postby doctorsubtilis » 31. January 2021 21:30

Ops! After a restart it works! Sorry.
doctorsubtilis
 
Posts: 9
Joined: 11. September 2020 15:44
XAMPP version: 7.4.9.0
Operating System: Linux - KDE Neon 20.04


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 23 guests