msh1362
September 23rd, 2017, 11:47
سلام و خسته نباشید خدمت بزرگوران گرامی
چند تا سایت بروی این سرور لینوکس centos 7 دارم که با کنترل پنل دایرکت ادمین می باشد
دیشب یکی از سایت ها با مشکل دیتابیس رو برو شد اول گمان کردم که درایو پر شده ولی خالی بود یکی دو بار پیش امده بود که یا درایو پر بود یا با یک بار ریستارت سرور برطرف میشد
الان ریستارت کردم و دیگه کلا تمام سایت هایی که داشتم با مشکل ارتباط با دیتابیس رو بروی شده
و داخل دایرکت ادمین هم که میشم mysql غیر فعال شده و استارت نمی خوره
این هم محتویات داخل فایل ارور .err هست
در ضمن یکبار ibdata1 رو هم پاک کردم و ریستارت کردم بازهم درست نشد
مممنون میشم راهنمایی بفرمایید
170923 10:32:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170923 10:32:06 [Warning] option 'max_allowed_packet': unsigned value 4294967296 adjusted to 1073741824
170923 10:32:06 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170923 10:32:06 InnoDB: The InnoDB memory heap is disabled
170923 10:32:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170923 10:32:06 InnoDB: Compressed tables use zlib 1.2.7
170923 10:32:06 InnoDB: Using Linux native AIO
170923 10:32:06 InnoDB: Initializing buffer pool, size = 128.0M
170923 10:32:06 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
170923 10:32:06 InnoDB: Could not open or create data files.
170923 10:32:06 InnoDB: If you tried to add new data files, and it failed here,
170923 10:32:06 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170923 10:32:06 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170923 10:32:06 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170923 10:32:06 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170923 10:32:06 InnoDB: remove old data files which contain your precious data!
170923 10:32:06 [ERROR] Plugin 'InnoDB' init function returned error.
170923 10:32:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170923 10:32:06 [Note] Plugin 'FEEDBACK' is disabled.
170923 10:32:06 [ERROR] Unknown/unsupported storage engine: InnoDB
170923 10:32:06 [ERROR] Aborting
170923 10:32:06 [Note] /usr/sbin/mysqld: Shutdown complete
170923 10:32:06 mysqld_safe mysqld from pid file /var/lib/mysql/srv1.hostavaran.ir.pid ended
170923 10:32:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170923 10:32:27 [Warning] option 'max_allowed_packet': unsigned value 4294967296 adjusted to 1073741824
170923 10:32:27 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170923 10:32:27 InnoDB: The InnoDB memory heap is disabled
170923 10:32:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170923 10:32:27 InnoDB: Compressed tables use zlib 1.2.7
170923 10:32:27 InnoDB: Using Linux native AIO
170923 10:32:27 InnoDB: Initializing buffer pool, size = 128.0M
170923 10:32:28 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
170923 10:32:28 InnoDB: Could not open or create data files.
170923 10:32:28 InnoDB: If you tried to add new data files, and it failed here,
170923 10:32:28 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170923 10:32:28 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170923 10:32:28 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170923 10:32:28 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170923 10:32:28 InnoDB: remove old data files which contain your precious data!
170923 10:32:28 [ERROR] Plugin 'InnoDB' init function returned error.
170923 10:32:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170923 10:32:28 [Note] Plugin 'FEEDBACK' is disabled.
170923 10:32:28 [ERROR] Unknown/unsupported storage engine: InnoDB
170923 10:32:28 [ERROR] Aborting
170923 10:32:28 [Note] /usr/sbin/mysqld: Shutdown complete
170923 10:32:28 mysqld_safe mysqld from pid file /var/lib/mysql/srv1.hostavaran.ir.pid ended
چند تا سایت بروی این سرور لینوکس centos 7 دارم که با کنترل پنل دایرکت ادمین می باشد
دیشب یکی از سایت ها با مشکل دیتابیس رو برو شد اول گمان کردم که درایو پر شده ولی خالی بود یکی دو بار پیش امده بود که یا درایو پر بود یا با یک بار ریستارت سرور برطرف میشد
الان ریستارت کردم و دیگه کلا تمام سایت هایی که داشتم با مشکل ارتباط با دیتابیس رو بروی شده
و داخل دایرکت ادمین هم که میشم mysql غیر فعال شده و استارت نمی خوره
این هم محتویات داخل فایل ارور .err هست
در ضمن یکبار ibdata1 رو هم پاک کردم و ریستارت کردم بازهم درست نشد
مممنون میشم راهنمایی بفرمایید
170923 10:32:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170923 10:32:06 [Warning] option 'max_allowed_packet': unsigned value 4294967296 adjusted to 1073741824
170923 10:32:06 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170923 10:32:06 InnoDB: The InnoDB memory heap is disabled
170923 10:32:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170923 10:32:06 InnoDB: Compressed tables use zlib 1.2.7
170923 10:32:06 InnoDB: Using Linux native AIO
170923 10:32:06 InnoDB: Initializing buffer pool, size = 128.0M
170923 10:32:06 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
170923 10:32:06 InnoDB: Could not open or create data files.
170923 10:32:06 InnoDB: If you tried to add new data files, and it failed here,
170923 10:32:06 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170923 10:32:06 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170923 10:32:06 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170923 10:32:06 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170923 10:32:06 InnoDB: remove old data files which contain your precious data!
170923 10:32:06 [ERROR] Plugin 'InnoDB' init function returned error.
170923 10:32:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170923 10:32:06 [Note] Plugin 'FEEDBACK' is disabled.
170923 10:32:06 [ERROR] Unknown/unsupported storage engine: InnoDB
170923 10:32:06 [ERROR] Aborting
170923 10:32:06 [Note] /usr/sbin/mysqld: Shutdown complete
170923 10:32:06 mysqld_safe mysqld from pid file /var/lib/mysql/srv1.hostavaran.ir.pid ended
170923 10:32:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170923 10:32:27 [Warning] option 'max_allowed_packet': unsigned value 4294967296 adjusted to 1073741824
170923 10:32:27 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170923 10:32:27 InnoDB: The InnoDB memory heap is disabled
170923 10:32:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170923 10:32:27 InnoDB: Compressed tables use zlib 1.2.7
170923 10:32:27 InnoDB: Using Linux native AIO
170923 10:32:27 InnoDB: Initializing buffer pool, size = 128.0M
170923 10:32:28 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
170923 10:32:28 InnoDB: Could not open or create data files.
170923 10:32:28 InnoDB: If you tried to add new data files, and it failed here,
170923 10:32:28 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170923 10:32:28 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170923 10:32:28 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170923 10:32:28 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170923 10:32:28 InnoDB: remove old data files which contain your precious data!
170923 10:32:28 [ERROR] Plugin 'InnoDB' init function returned error.
170923 10:32:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170923 10:32:28 [Note] Plugin 'FEEDBACK' is disabled.
170923 10:32:28 [ERROR] Unknown/unsupported storage engine: InnoDB
170923 10:32:28 [ERROR] Aborting
170923 10:32:28 [Note] /usr/sbin/mysqld: Shutdown complete
170923 10:32:28 mysqld_safe mysqld from pid file /var/lib/mysql/srv1.hostavaran.ir.pid ended