После перезагрузки Ubuntu падает MySQL
Posted: Wed Mar 15, 2017 1:58 pm
Vestacp:0.9.8, Ubuntu 14.04.4 x64, phpfpm, MySQL 5.5
512mb оперативной памяти и одно ядро
Перезагружаю MySQL начинает работать, потом опять падение, после нескольких перезагрузок базы начитает нормально работать, но до следующей перезагрузки сервера, при этом сыпятся ошибки:
из этой темы все попробовал, но результата нет viewtopic.php?f=32&t=5070
/etc/init.d/mysql stop
mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak
cp -a /var/lib/mysql/ibdata1.bak /var/lib/mysql/ibdata1
/etc/init.d/mysql start
это не помогает
конфиг my.cnf сейчас дефолтный
Помогите пожалуйста разобраться!
третий день бьюсь, гугл моего решения не дает...
512mb оперативной памяти и одно ядро
Перезагружаю MySQL начинает работать, потом опять падение, после нескольких перезагрузок базы начитает нормально работать, но до следующей перезагрузки сервера, при этом сыпятся ошибки:
SpoilerShow
170315 9:41:44 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
170315 9:41:44 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... codes.html
170315 9:41:44 InnoDB: Could not open or create data files.
170315 9:41:44 InnoDB: If you tried to add new data files, and it failed here,
170315 9:41:44 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170315 9:41:44 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170315 9:41:44 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170315 9:41:44 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170315 9:41:44 InnoDB: remove old data files which contain your precious data!
170315 9:41:44 [ERROR] Plugin 'InnoDB' init function returned error.
170315 9:41:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170315 9:41:44 [ERROR] Unknown/unsupported storage engine: InnoDB
170315 9:41:44 [ERROR] Aborting
170315 9:41:44 [Note] /usr/sbin/mysqld: Shutdown complete
170315 9:41:44 [Note] Plugin 'FEDERATED' is disabled.
170315 9:41:44 InnoDB: The InnoDB memory heap is disabled
170315 9:41:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170315 9:41:44 InnoDB: Compressed tables use zlib 1.2.8
170315 9:41:44 InnoDB: Using Linux native AIO
170315 9:41:44 InnoDB: Initializing buffer pool, size = 5.0M
170315 9:41:44 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
170315 9:41:44 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Error in opening ./ibdata1
170315 9:41:44 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... codes.html
170315 9:41:44 InnoDB: Could not open or create data files.
170315 9:41:44 InnoDB: If you tried to add new data files, and it failed here,
170315 9:41:44 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170315 9:41:44 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170315 9:41:44 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170315 9:41:44 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170315 9:41:44 InnoDB: remove old data files which contain your precious data!
170315 9:41:44 [ERROR] Plugin 'InnoDB' init function returned error.
170315 9:41:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170315 9:41:44 [ERROR] Unknown/unsupported storage engine: InnoDB
170315 9:41:44 [ERROR] Aborting
170315 9:41:44 [Note] /usr/sbin/mysqld: Shutdown complete
170315 9:41:44 [Note] Plugin 'FEDERATED' is disabled.
170315 9:41:44 InnoDB: The InnoDB memory heap is disabled
170315 9:41:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170315 9:41:44 InnoDB: Compressed tables use zlib 1.2.8
170315 9:41:44 InnoDB: Using Linux native AIO
170315 9:41:44 InnoDB: Initializing buffer pool, size = 5.0M
170315 9:41:44 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
170315 9:41:44 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
/etc/init.d/mysql stop
mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak
cp -a /var/lib/mysql/ibdata1.bak /var/lib/mysql/ibdata1
/etc/init.d/mysql start
это не помогает
конфиг my.cnf сейчас дефолтный
Помогите пожалуйста разобраться!
третий день бьюсь, гугл моего решения не дает...