[[+content_image]]
D
D
Denis Denisov2016-02-23 21:16:26
MySQL
Denis Denisov, 2016-02-23 21:16:26

Mysql Centos 6.7 keeps crashing, where to dig?

Good afternoon!
The base constantly falls and goes into a deaf down. Only reinstalling everything helps)
Centos 6.7
[[email protected] ~]# 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 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
'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:
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 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
'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 : 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
'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: 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
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
'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 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

Answer the question

In order to leave comments, you need to log in

[[+comments_count]] answer(s)
I
Igor, 2016-02-23
@unitby

Does he have enough space?
RAM for all sorts of buffers?
is swap being used?

C
CityCat4, 2016-02-23
@CityCat4

/etc/mysql.cnf (or whatever config you have) show if it exists

D
Dmitry, 2016-02-24
@imert

Look, for example, to see if the ibdata file has grown to its maximum values.

D
Denis Denisov, 2016-02-24
@karlson1980

641de9aae20542f99fd519c9c5b2b66b.jpg
some kind of crap appears and, as you said, Dmitry, the file increases somehow quickly - and that's all error

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question