Skip to main content

MariaDB exits everyday without a trace

mehrdd
Hi After updating to MariaDB, it exits once a day. i thought it's a fixed-time exiting, but it's not, last night it was quits at 10:00PM and today it quits at 8:00PM I don't know what i have to do, note: i have not any problem before updating to MariaDB ... Thanks in advance

Comments

6 comments

Date Votes
  • 24x7ss
    Can you check MariaDb error logs in /var/lib/mysql/hostname.err and provide me the output when it exits.
    0
  • mehrdd
    Here's my 100 lines of hostname.err : (i'm restarting mysql after exiting to work again)
    150618 23:00:04 [Note] InnoDB: Completed initialization of buffer pool 150618 23:00:04 [Note] InnoDB: Highest supported file format is Barracuda. 150618 23:00:04 [Note] InnoDB: 128 rollback segment(s) are active. 150618 23:00:04 [Note] InnoDB: Waiting for purge to start 150618 23:00:04 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 4341099555 150618 23:00:04 [Note] Plugin 'FEEDBACK' is disabled. 150618 23:00:04 [Note] Server socket created on IP: '::'. 150618 23:00:04 [Note] Event Scheduler: Loaded 0 events 150618 23:00:04 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.0.19-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 150619 7:00:02 [Note] /usr/sbin/mysqld: Normal shutdown 150619 7:00:02 [Note] Event Scheduler: Purging the queue. 0 events 150619 7:00:02 [Note] InnoDB: FTS optimize thread exiting. 150619 7:00:02 [Note] InnoDB: Starting shutdown... 150619 7:00:04 [Note] InnoDB: Shutdown completed; log sequence number 4347819345 150619 7:00:04 [Note] /usr/sbin/mysqld: Shutdown complete 150619 07:00:04 mysqld_safe mysqld from pid file /var/lib/mysql/**hostname**.pid ended 150619 07:00:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150619 7:00:05 [Note] /usr/sbin/mysqld (mysqld 10.0.19-MariaDB) starting as process 6937 ... 150619 7:00:05 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150619 7:00:05 [Note] InnoDB: The InnoDB memory heap is disabled 150619 7:00:05 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150619 7:00:05 [Note] InnoDB: Memory barrier is not used 150619 7:00:05 [Note] InnoDB: Compressed tables use zlib 1.2.3 150619 7:00:05 [Note] InnoDB: Using Linux native AIO 150619 7:00:05 [Note] InnoDB: Using CPU crc32 instructions 150619 7:00:05 [Note] InnoDB: Initializing buffer pool, size = 5.0G 150619 7:00:05 [Note] InnoDB: Completed initialization of buffer pool 150619 7:00:05 [Note] InnoDB: Highest supported file format is Barracuda. 150619 7:00:05 [Note] InnoDB: 128 rollback segment(s) are active. 150619 7:00:05 [Note] InnoDB: Waiting for purge to start 150619 7:00:05 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 4347819345 150619 7:00:05 [Note] Plugin 'FEEDBACK' is disabled. 150619 7:00:05 [Note] Server socket created on IP: '::'. 150619 7:00:05 [Note] Event Scheduler: Loaded 0 events 150619 7:00:05 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.0.19-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 150619 20:25:31 [Note] /usr/sbin/mysqld: Normal shutdown 150619 20:25:31 [Note] Event Scheduler: Purging the queue. 0 events 150619 20:25:32 [Note] InnoDB: FTS optimize thread exiting. 150619 20:25:32 [Note] InnoDB: Starting shutdown... 150619 20:25:33 [Note] InnoDB: Shutdown completed; log sequence number 4357902247 150619 20:25:33 [Note] /usr/sbin/mysqld: Shutdown complete 150619 20:25:33 mysqld_safe mysqld from pid file /var/lib/mysql/**hostname**.pid ended 150619 20:25:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150619 20:25:34 [Note] /usr/sbin/mysqld (mysqld 10.0.19-MariaDB) starting as process 5126 ... 150619 20:25:34 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150619 20:25:34 [Note] InnoDB: The InnoDB memory heap is disabled 150619 20:25:34 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150619 20:25:34 [Note] InnoDB: Memory barrier is not used 150619 20:25:34 [Note] InnoDB: Compressed tables use zlib 1.2.3 150619 20:25:34 [Note] InnoDB: Using Linux native AIO 150619 20:25:34 [Note] InnoDB: Using CPU crc32 instructions 150619 20:25:34 [Note] InnoDB: Initializing buffer pool, size = 5.0G 150619 20:25:34 [Note] InnoDB: Completed initialization of buffer pool 150619 20:25:34 [Note] InnoDB: Highest supported file format is Barracuda. 150619 20:25:34 [Note] InnoDB: 128 rollback segment(s) are active. 150619 20:25:34 [Note] InnoDB: Waiting for purge to start 150619 20:25:34 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 4357902247 150619 20:25:34 [Note] Plugin 'FEEDBACK' is disabled. 150619 20:25:34 [Note] Server socket created on IP: '::'. 150619 20:25:34 [Note] Event Scheduler: Loaded 0 events 150619 20:25:34 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.0.19-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 150619 20:52:08 [ERROR] InnoDB: Duplicate FTS_DOC_ID value on table steelped_parin/contents 150619 20:52:08 [ERROR] Cannot find index FTS_DOC_ID_INDEX in InnoDB index translation table. 150619 20:52:08 [Warning] Find index FTS_DOC_ID_INDEX in InnoDB index list but not its MySQL index number It could be an InnoDB internal index. 150619 23:00:01 [Note] /usr/sbin/mysqld: Normal shutdown 150619 23:00:01 [Note] Event Scheduler: Purging the queue. 0 events 150619 23:00:01 [Note] InnoDB: FTS optimize thread exiting. 150619 23:00:01 [Note] InnoDB: Starting shutdown... 150619 23:00:03 [Note] InnoDB: Shutdown completed; log sequence number 4359842204 150619 23:00:03 [Note] /usr/sbin/mysqld: Shutdown complete 150619 23:00:03 mysqld_safe mysqld from pid file /var/lib/mysql/**hostname**.pid ended 150619 23:00:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150619 23:00:03 [Note] /usr/sbin/mysqld (mysqld 10.0.19-MariaDB) starting as process 25887 ... 150619 23:00:03 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150619 23:00:03 [Note] InnoDB: The InnoDB memory heap is disabled 150619 23:00:03 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150619 23:00:03 [Note] InnoDB: Memory barrier is not used 150619 23:00:03 [Note] InnoDB: Compressed tables use zlib 1.2.3 150619 23:00:03 [Note] InnoDB: Using Linux native AIO 150619 23:00:03 [Note] InnoDB: Using CPU crc32 instructions 150619 23:00:03 [Note] InnoDB: Initializing buffer pool, size = 5.0G 150619 23:00:03 [Note] InnoDB: Completed initialization of buffer pool 150619 23:00:03 [Note] InnoDB: Highest supported file format is Barracuda. 150619 23:00:03 [Note] InnoDB: 128 rollback segment(s) are active. 150619 23:00:03 [Note] InnoDB: Waiting for purge to start 150619 23:00:03 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 4359842204 150619 23:00:03 [Note] Plugin 'FEEDBACK' is disabled. 150619 23:00:03 [Note] Server socket created on IP: '::'. 150619 23:00:03 [Note] Event Scheduler: Loaded 0 events 150619 23:00:03 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.0.19-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
    0
  • mehrdd
    This is my.cnf : Is there anyway to fix this issue ? I have to restart mysql service everyday and it's killing me ..
    [mysqld] innodb_file_per_table=1 max_allowed_packet=268435456 open_files_limit=1000000 max_connections=500 wait_timeout=27000 interactive_timeout=27000 low_priority_updates=1 concurrent_insert=ALWAYS thread_cache_size=16K tmp_table_size = 128M max_heap_table_size = 128M query_cache_size = 128M query_cache_limit = 250M table_open_cache=1500 table_open_cache=1K table_definition_cache = 4K key_buffer = 64M key_buffer_size=100M innodb_buffer_pool_size=5G join_buffer_size = 256K default-storage-engine=MyISAM
    0
  • cPanelMichael
    Hello :) Does MariaDB continue to restart on a regular basis? If so, you may want to try running a MySQL/MariaDB tuner script to see if it advises any changes to your existing configuration values in the /etc/my.cnf file. Thank you.
    0
  • sonicthoughts
    I have the same issue. stops without any indication of why. nothing in cron or /var/log/messages or any of the mysql log files: 150827 5:52:55 [Note] /usr/sbin/mysqld: Normal shutdown 150827 5:52:55 [Note] Event Scheduler: Purging the queue. 0 events 150827 5:52:55 [Note] InnoDB: FTS optimize thread exiting. 150827 5:52:55 [Note] InnoDB: Starting shutdown... 150827 5:52:57 [Note] InnoDB: Shutdown completed; log sequence number 28249218796 150827 5:52:57 [Note] /usr/sbin/mysqld: Shutdown complete
    0
  • cPanelMichael
    I have the same issue. stops without any indication of why. nothing in cron or /var/log/messages or any of the mysql log files:

    Is Cloud Linux installed on this system? Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post