Vesta 2.0 is coming soon! See our progress update: https://vestacp.com/docs/vesta-2-update
Постоянно падает mysql
-
karlson1980
- Posts: 30
- Joined: Sat Feb 20, 2016 3:40 pm
- Os: CentOS 6x
- Web: nginx + php-fpm
Постоянно падает mysql
День добрый!
Постоянно падает база и уходит в глухой даун. Помогает только переустановка всего)
Centos 6.7
[root@ns398679 ~]# rpm -qa | grep mysql
mysql-5.5.48-1.el6.remi.x86_64
compat-mysql51-5.1.54-1.el6.remi.x86_64
mysql-libs-5.5.48-1.el6.remi.x86_64
php-mysql-5.4.45-4.el6.remi.x86_64
mysql-server-5.5.48-1.el6.remi.x86_64
14:58:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:04:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:04:20 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:04:20 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 14267 ...
160223 15:04:20 [Note] Plugin 'FEDERATED' is disabled.
160223 15:04:20 InnoDB: The InnoDB memory heap is disabled
160223 15:04:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:04:20 InnoDB: Compressed tables use zlib 1.2.3
160223 15:04:20 InnoDB: Using Linux native AIO
160223 15:04:20 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:04:20 InnoDB: Completed initialization of buffer pool
160223 15:04:20 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:04:20 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:04:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:04:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:04:26 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:04:26 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 14964 ...
160223 15:04:26 [Note] Plugin 'FEDERATED' is disabled.
160223 15:04:26 InnoDB: The InnoDB memory heap is disabled
160223 15:04:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:04:26 InnoDB: Compressed tables use zlib 1.2.3
160223 15:04:26 InnoDB: Using Linux native AIO
160223 15:04:26 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:04:26 InnoDB: Completed initialization of buffer pool
160223 15:04:26 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:04:26 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
noDB: memory cache!
160223 15:04:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:05:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:05:52 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:05:52 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 1684 ...
160223 15:05:52 [Note] Plugin 'FEDERATED' is disabled.
160223 15:05:52 InnoDB: The InnoDB memory heap is disabled
160223 15:05:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:05:52 InnoDB: Compressed tables use zlib 1.2.3
160223 15:05:52 InnoDB: Using Linux native AIO
160223 15:05:52 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:05:52 InnoDB: Completed initialization of buffer pool
160223 15:05:52 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:05:52 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:05:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:14:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:14:31 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:14:31 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 1683 ...
160223 15:14:31 [Note] Plugin 'FEDERATED' is disabled.
160223 15:14:31 InnoDB: The InnoDB memory heap is disabled
160223 15:14:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:14:31 InnoDB: Compressed tables use zlib 1.2.3
160223 15:14:31 InnoDB: Using Linux native AIO
160223 15:4:31 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:14:31 InnoDB: Completed initialization of buffer pool
160223 15:14:31 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:14:31 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:14:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:25:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:25:26 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:25:26 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 1683 ...
160223 15:25:26 [Note] Plugin 'FEDERATED' is disabled.
160223 15:25:26 InnoDB: The InnoDB memory heap is disabled
160223 15:25:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:25:26 InnoDB: Compressed tables use zlib 1.2.3
160223 15:25:26 InnoDB: Using Linux native AIO
160223 15:25:26 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:25:26 InnoDB: Completed initialization of buffer pool
160223 15:25:26 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:25:26 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:25:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Постоянно падает база и уходит в глухой даун. Помогает только переустановка всего)
Centos 6.7
[root@ns398679 ~]# rpm -qa | grep mysql
mysql-5.5.48-1.el6.remi.x86_64
compat-mysql51-5.1.54-1.el6.remi.x86_64
mysql-libs-5.5.48-1.el6.remi.x86_64
php-mysql-5.4.45-4.el6.remi.x86_64
mysql-server-5.5.48-1.el6.remi.x86_64
14:58:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:04:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:04:20 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:04:20 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 14267 ...
160223 15:04:20 [Note] Plugin 'FEDERATED' is disabled.
160223 15:04:20 InnoDB: The InnoDB memory heap is disabled
160223 15:04:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:04:20 InnoDB: Compressed tables use zlib 1.2.3
160223 15:04:20 InnoDB: Using Linux native AIO
160223 15:04:20 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:04:20 InnoDB: Completed initialization of buffer pool
160223 15:04:20 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:04:20 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:04:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:04:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:04:26 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:04:26 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 14964 ...
160223 15:04:26 [Note] Plugin 'FEDERATED' is disabled.
160223 15:04:26 InnoDB: The InnoDB memory heap is disabled
160223 15:04:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:04:26 InnoDB: Compressed tables use zlib 1.2.3
160223 15:04:26 InnoDB: Using Linux native AIO
160223 15:04:26 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:04:26 InnoDB: Completed initialization of buffer pool
160223 15:04:26 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:04:26 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
noDB: memory cache!
160223 15:04:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:05:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:05:52 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:05:52 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 1684 ...
160223 15:05:52 [Note] Plugin 'FEDERATED' is disabled.
160223 15:05:52 InnoDB: The InnoDB memory heap is disabled
160223 15:05:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:05:52 InnoDB: Compressed tables use zlib 1.2.3
160223 15:05:52 InnoDB: Using Linux native AIO
160223 15:05:52 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:05:52 InnoDB: Completed initialization of buffer pool
160223 15:05:52 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:05:52 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:05:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:14:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:14:31 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:14:31 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 1683 ...
160223 15:14:31 [Note] Plugin 'FEDERATED' is disabled.
160223 15:14:31 InnoDB: The InnoDB memory heap is disabled
160223 15:14:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:14:31 InnoDB: Compressed tables use zlib 1.2.3
160223 15:14:31 InnoDB: Using Linux native AIO
160223 15:4:31 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:14:31 InnoDB: Completed initialization of buffer pool
160223 15:14:31 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:14:31 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:14:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:25:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:25:26 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:25:26 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 1683 ...
160223 15:25:26 [Note] Plugin 'FEDERATED' is disabled.
160223 15:25:26 InnoDB: The InnoDB memory heap is disabled
160223 15:25:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:25:26 InnoDB: Compressed tables use zlib 1.2.3
160223 15:25:26 InnoDB: Using Linux native AIO
160223 15:25:26 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:25:26 InnoDB: Completed initialization of buffer pool
160223 15:25:26 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:25:26 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:25:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Re: Постоянно падает mysql
http://dev.mysql.com/doc/refman/5.6/en/ ... pying.html
If you don't have 5.6.6 or later, then consider these
* ALTER TABLE
* RENAME TABLE
* dump and reload a table.
If you don't have 5.6.6 or later, then consider these
* ALTER TABLE
* RENAME TABLE
* dump and reload a table.