Welcome to Centmin Mod Community
Become a Member

MariaDB suddenly stopped working

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by lushen, Nov 13, 2017.

  1. lushen

    lushen New Member

    6
    1
    3
    Nov 13, 2017
    Ratings:
    +3
    Local Time:
    6:58 AM
    • CentOS Version: CentOS 7 64bit
    • Centmin Mod Version Installed: 123.09beta01
    • Nginx Version Installed: 1.12.1
    • PHP Version Installed: 5.6.30
    • MariaDB MySQL Version Installed: 10.1.28
    • When was last time updated Centmin Mod code base ? : just did it few minutes ago

    Hello,

    MariaDB starting to rip my hairs. After trying to fix it by myself I decided to ask here and hopefully I can get some help.

    I manage a Forum with IP Board installed and it was working fine for a few weeks, but suddenly a few hours ago it stopped working and so far I noticed it is because of mysql.

    So, here are some relevant configs/codes:

    my.cnf:
    Code:
    [client]
    socket=/var/lib/mysql/mysql.sock
    
    [mysql]
    max_allowed_packet = 64M
    
    [mysqld]
    ignore_db_dirs=cmsetiofiotest
    local-infile=0
    ignore_db_dirs=lost+found
    character-set-server=utf8
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    #bind-address=127.0.0.1
    # optimized my.cnf for MariaDB 5.5.x
    # by eva2000
    # vbtechsupport.com
    
    #tmpdir=/home/mysqltmp
    
    innodb=ON
    #skip-federated
    ##skip-pbxt
    ##skip-pbxt_statistics
    #skip-archive
    #skip-name-resolve
    #old_passwords
    back_log = 512
    max_connections = 50
    key_buffer_size = 256M
    myisam_sort_buffer_size = 256M
    myisam_max_sort_file_size = 2048M
    join_buffer_size = 256K
    read_buffer_size = 256K
    sort_buffer_size = 256K
    table_definition_cache = 8192
    table_open_cache = 4096
    thread_cache_size = 20
    wait_timeout = 1800
    connect_timeout = 10
    tmp_table_size = 32M
    max_heap_table_size = 32M
    max_allowed_packet = 64M
    #max_seeks_for_key = 4294967295
    group_concat_max_len = 1024
    max_length_for_sort_data = 1024
    net_buffer_length = 16384
    max_connect_errors = 100000
    concurrent_insert = 2
    read_rnd_buffer_size = 512K
    bulk_insert_buffer_size = 8M
    # query_cache boost for MariaDB >10.1.2+
    # https://community.centminmod.com/posts/30811/
    #query_cache_limit = 1024K
    query_cache_limit = 256K
    query_cache_size = 0
    query_cache_type = 0
    query_cache_min_res_unit = 2K
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = InnoDB
    
    log_warnings=1
    slow_query_log=0
    long_query_time=1
    slow_query_log_file=/var/lib/mysql/slowq.log
    #log-error=/var/log/mysqld.log
    
    # innodb settings
    innodb_large_prefix=1
    innodb_purge_threads = 1
    innodb_file_format = Barracuda
    innodb_file_per_table = 1
    innodb_open_files = 1000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size = 512M
    
    ## https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/#innodb_buffer_pool_instances
    innodb_buffer_pool_instances=1
    
    innodb_log_files_in_group = 2
    innodb_log_file_size = 256M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 2
    #innodb_thread_concurrency = 8
    innodb_lock_wait_timeout=50
    innodb_flush_method = O_DIRECT
    innodb_support_xa=1
    
    # 200 * # DISKS
    innodb_io_capacity = 400
    innodb_io_capacity_max = 800
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    innodb_flush_neighbors = 0
    
    # mariadb settings
    [mariadb]
    #thread-handling = pool-of-threads
    #thread-pool-size= 20
    #mysql --port=3307 --protocol=tcp
    #extra-port=3307
    #extra-max-connections=1
    
    userstat = 0
    key_cache_segments = 1
    aria_group_commit = none
    aria_group_commit_interval = 0
    aria_log_file_size = 768M
    aria_log_purge_type = immediate
    aria_pagecache_buffer_size = 768M
    aria_sort_buffer_size = 192M
    
    [mariadb-5.5]
    innodb_file_format = Barracuda
    innodb_file_per_table = 1
    
    #ignore_db_dirs=
    query_cache_strip_comments=0
    
    innodb_read_ahead = linear
    innodb_adaptive_flushing_method = estimate
    innodb_flush_neighbor_pages = 1
    innodb_stats_update_need_lock = 0
    innodb_log_block_size = 512
    
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    [mysqld_safe]
    socket=/var/lib/mysql/mysql.sock
    #log-error=/var/log/mysqld.log
    #nice = -5
    open-files-limit = 8192
    
    [mysqldump]
    quick
    max_allowed_packet = 64M
    
    [myisamchk]
    tmpdir=/home/mysqltmp
    key_buffer = 256M
    sort_buffer = 32M
    read_buffer = 32M
    write_buffer = 32M
    
    [mysqlhotcopy]
    interactive-timeout
    
    [mariadb-10.0]
    innodb_file_format = Barracuda
    innodb_file_per_table = 1
    
    # 2 variables needed to switch from XtraDB to InnoDB plugins
    #plugin-load=ha_innodb
    #ignore_builtin_innodb
    
    ## MariaDB 10 only save and restore buffer pool pages
    ## warm up InnoDB buffer pool on server restarts
    #innodb_buffer_pool_dump_at_shutdown=1
    #innodb_buffer_pool_load_at_startup=1
    innodb_buffer_pool_populate=0
    ## Disabled settings
    performance_schema=ON
    innodb_stats_on_metadata=OFF
    innodb_sort_buffer_size=2M
    innodb_online_alter_log_max_size=128M
    query_cache_strip_comments=0
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    [mariadb-10.1]
    innodb_file_format = Barracuda
    innodb_file_per_table = 1
    
    ## wsrep specific
    # wsrep_on=OFF
    # wsrep_provider
    # wsrep_cluster_address
    # binlog_format=ROW
    # default_storage_engine=InnoDB
    # innodb_autoinc_lock_mode=2
    # innodb_doublewrite=1
    # query_cache_size=0
    
    # 2 variables needed to switch from XtraDB to InnoDB plugins
    #plugin-load=ha_innodb
    #ignore_builtin_innodb
    
    ## MariaDB 10 only save and restore buffer pool pages
    ## warm up InnoDB buffer pool on server restarts
    #innodb_buffer_pool_dump_at_shutdown=1
    #innodb_buffer_pool_load_at_startup=1
    innodb_buffer_pool_populate=0
    ## Disabled settings
    performance_schema=OFF
    innodb_stats_on_metadata=OFF
    innodb_sort_buffer_size=2M
    innodb_online_alter_log_max_size=128M
    query_cache_strip_comments=0
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    # Defragmenting unused space on InnoDB tablespace
    innodb_defragment=1
    innodb_defragment_n_pages=7
    innodb_defragment_stats_accuracy=0
    innodb_defragment_fill_factor_n_recs=20
    innodb_defragment_fill_factor=0.9
    innodb_defragment_frequency=40
    
    systemctl status mariadb.service:
    Code:
    [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 131408373703
    [Note] InnoDB: Dumping buffer pool(s) not yet started
    [Note] Plugin 'FEEDBACK' is disabled.
    [Note] Recovering after a crash using tc.log
    [ERROR] Can't init tc log
    [ERROR] Aborting
    mariadb.service: main process exited, code=exited, status=1/FAILURE
    Failed to start MariaDB database server.
    Unit mariadb.service entered failed state.
    mariadb.service failed.
    
    journalctl -xe
    Code:
    -- Unit mariadb.service has begun starting up.
    [Note] /usr/sbin/mysqld (mysqld 10.1.28-MariaDB) starting as process 27498 ...
    [Note] InnoDB: Using mutexes to ref count buffer pool pages
    [Note] InnoDB: The InnoDB memory heap is disabled
    [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    [Note] InnoDB: Compressed tables use zlib 1.2.7
    [Note] InnoDB: Using Linux native AIO
    [Note] InnoDB: Using SSE crc32 instructions
    [Note] InnoDB: Initializing buffer pool, size = 512.0M
    [Note] InnoDB: Completed initialization of buffer pool
    [Note] InnoDB: Highest supported file format is Barracuda.
    [Note] InnoDB: 128 rollback segment(s) are active.
    [Note] InnoDB: Waiting for purge to start
    [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 131408373703
    [Note] InnoDB: Dumping buffer pool(s) not yet started
    [Note] Plugin 'FEEDBACK' is disabled.
    [Note] Recovering after a crash using tc.log
    [ERROR] Can't init tc log
    [ERROR] Aborting
    mariadb.service: main process exited, code=exited, status=1/FAILURE
    Failed to start MariaDB database server.
    -- Subject: Unit mariadb.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit mariadb.service has failed.
    --
    -- The result is failed.
    Unit mariadb.service entered failed state.
    mariadb.service failed.
    Unregistered Authentication Agent for unix-process:27258:166734 (system bus name :1.49, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) 
    
    When I go to phpmyadmin, I get 2 errors aswell:

    Code:
    #2002 - No such file or directory — The server is not responding (or the local server's socket is not correctly configured).
    
    And:

    Code:
    mysqli_real_connect(): (HY000/2002): No such file or directory
    
    Feeling lost currently :(

    Hope you can help me, without re-installing everything, thanks!
     
  2. RoldanLT

    RoldanLT Well-Known Member

    3,931
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:58 PM
    1.11
    10.2
  3. lushen

    lushen New Member

    6
    1
    3
    Nov 13, 2017
    Ratings:
    +3
    Local Time:
    6:58 AM
    Yes worked, just did it right before you answered :)

    MariaDB works now, but Forum still down, but thats not an centminmod related issue, weird everything suddenly stopped working though. Thanks anyways.