The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MariaDB exits everyday without a trace

Discussion in 'Database Discussions' started by mehrdd, Jun 19, 2015.

  1. mehrdd

    mehrdd Registered

    Joined:
    Jun 24, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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
     
  2. 24x7ss

    24x7ss Well-Known Member

    Joined:
    Sep 30, 2014
    Messages:
    271
    Likes Received:
    16
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Can you check MariaDb error logs in /var/lib/mysql/hostname.err and provide me the output when it exits.
     
  3. mehrdd

    mehrdd Registered

    Joined:
    Jun 24, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Here's my 100 lines of hostname.err :
    (i'm restarting mysql after exiting to work again)

    Code:
    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
     
  4. mehrdd

    mehrdd Registered

    Joined:
    Jun 24, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    This is my.cnf :
    Is there anyway to fix this issue ?
    I have to restart mysql service everyday and it's killing me ..

    Code:
    [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
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  6. sonicthoughts

    sonicthoughts Well-Known Member

    Joined:
    Apr 4, 2011
    Messages:
    61
    Likes Received:
    3
    Trophy Points:
    8
    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
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Is Cloud Linux installed on this system?

    Thank you.
     
Loading...

Share This Page