Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MariaDB exits everyday without a trace

Discussion in 'Database Discussion' 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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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:
    44,344
    Likes Received:
    1,852
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. sonicthoughts

    sonicthoughts Well-Known Member

    Joined:
    Apr 4, 2011
    Messages:
    61
    Likes Received:
    3
    Trophy Points:
    58
    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:
    44,344
    Likes Received:
    1,852
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Is Cloud Linux installed on this system?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice