Ok mysql 5.7.44 is now installed; but i still have the same issue :
2025-08-14T17:41:02.677029Z 0 [ERROR] InnoDB: Unable to lock /www/server/data/ibdata1 error: 11
2025-08-14T17:41:04.741464Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2025-08-14T17:41:05.741589Z 0 [ERROR] InnoDB: Unable to lock /www/server/data/ibdata1 error: 11
2025-08-14T17:41:08.258213Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2025-08-14T17:41:09.258362Z 0 [ERROR] InnoDB: Unable to lock /www/server/data/ibdata1 error: 11
2025-08-14T17:41:11.545770Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2025-08-14T17:41:11.545803Z 0 [Note] InnoDB: Unable to open the first data file
2025-08-14T17:41:11.545826Z 0 [ERROR] InnoDB: Operating system error number 11 in a file operation.
2025-08-14T17:41:11.545845Z 0 [ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable'
2025-08-14T17:41:11.545858Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2025-08-14T17:41:11.545869Z 0 [ERROR] InnoDB: Cannot open datafile '/www/server/data/ibdata1'
2025-08-14T17:41:11.545919Z 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!
2025-08-14T17:41:11.545934Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
2025-08-14T17:41:11.846922Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2025-08-14T17:41:11.846971Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2025-08-14T17:41:11.846985Z 0 [ERROR] Failed to initialize builtin plugins.
2025-08-14T17:41:11.846996Z 0 [ERROR] Aborting
2025-08-14T17:41:11.847019Z 0 [Note] Binlog end
2025-08-14T17:41:11.847101Z 0 [Note] Shutting down plugin 'CSV'
2025-08-14T17:41:11.852243Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
ps aux | grep mysql | grep -v grep
root 86664 0.0 0.0 7244 3136 ? S 17:50 0:00 /bin/sh /etc/init.d/mysqld restart
root 86674 0.0 0.0 9288 2688 ? S 17:50 0:00 /bin/systemctl --no-pager restart mysqld.service
root 86675 0.0 0.0 8968 3136 ? Ss 17:50 0:00 /bin/sh /etc/init.d/mysqld start
root 86689 0.0 0.0 8968 3136 ? S 17:50 0:00 /bin/sh /www/server/mysql/bin/mysqld_safe --datadir=/www/server/data --pid-file=/www/server/data/twofpstudios.pid
mysql 87315 0.0 2.9 3610544 291200 ? Dl 17:50 0:00 /www/server/mysql/bin/mysqld --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=twofpstudios.err --open-files-limit=65535 --pid-file=/www/server/data/twofpstudios.pid --socket=/tmp/mysql.sock --port=3306
What i tried :
Stopped all MySQL processes:
sudo pkill -9 mysqld_safe || true
sudo pkill -9 mysqld || true
pgrep -fa mysqld || echo "OK: no mysqld"
pgrep -fa mysqld_safe || echo "OK: no mysqld_safe"
Removed stale PID and socket files:
sudo rm -f /www/server/data/*.pid /tmp/mysql*.sock /www/server/mysql/*.sock
Checked if ibdata1 was locked by any process:
sudo fuser -v /www/server/data/ibdata1
sudo lsof /www/server/data/ibdata1
No process was shown as holding the file.
Tried starting MySQL again via:
sudo /etc/init.d/mysqld start
It seems to try to start, but when I check /www/server/data/twofpstudio.err, I still get the same error:
[ERROR] InnoDB: Unable to lock /www/server/data/ibdata1 error: 11
[Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
Tried connecting with:
/www/server/mysql/bin/mysql -uroot -p -S /tmp/mysql.sock -e "SELECT VERSION();"
but I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
It looks like MySQL fails to fully start because it thinks another process is using ibdata1, but I can’t find any running mysqld process holding it.
can you help me ? I have no idea how to deal with that, GPT5 is not enough ^^.
All my sites using database are down 🙁 🙁
