Welcome to Centmin Mod Community
Become a Member

MariaDB MariaDB fail to start

Discussion in 'MariaDB & General MySQL news & discussions' started by YuchiRO, Nov 10, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:36 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    need disk inode count too
    Code (Text):
    df -hTi
    lsof +L1


     
  2. YuchiRO

    YuchiRO Member

    100
    6
    18
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    9:36 PM
    5.5.4
    Code:
    df -hTi
    Filesystem          Type     Inodes IUsed IFree IUse% Mounted on
    /dev/mapper/vg-root ext4        26M  967K   25M    4% /
    devtmpfs            devtmpfs   7.9M   499  7.9M    1% /dev
    tmpfs               tmpfs      7.9M     1  7.9M    1% /dev/shm
    tmpfs               tmpfs      7.9M   653  7.9M    1% /run
    tmpfs               tmpfs      7.9M    13  7.9M    1% /sys/fs/cgroup
    /dev/sda1           ext2        63K   352   63K    1% /boot
    /dev/mapper/vg-tmp  ext4        64K   64K     0  100% /tmp
    tmpfs               tmpfs      7.9M     1  7.9M    1% /run/user/0
    
    Code:
    lsof +L1
    COMMAND   PID  USER   FD   TYPE DEVICE SIZE/OFF NLINK NODE NAME
    php-fpm 11694  root    3u   REG  253,2        0     0 8196 /tmp/.ZendSem.PXuQnR (deleted)
    php-fpm 13450 nginx    3u   REG  253,2        0     0 8196 /tmp/.ZendSem.PXuQnR (deleted)
    php-fpm 13451 nginx    3u   REG  253,2        0     0 8196 /tmp/.ZendSem.PXuQnR (deleted)
    php-fpm 13459 nginx    3u   REG  253,2        0     0 8196 /tmp/.ZendSem.PXuQnR (deleted)
    php-fpm 13460 nginx    3u   REG  253,2        0     0 8196 /tmp/.ZendSem.PXuQnR (deleted)
    
     
  3. eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:36 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    php-fpm temp files consumed 100% of your disk inodes probably with many temp files

    try first restarting nginx + php-fpm then start mariadb

    then try removing contents in /tmp and reboot server
    Code (Text):
    rm -rf /tmp/*


    what is contents for /etc/centminmod/php.d/zendopcache.ini
     
  4. YuchiRO

    YuchiRO Member

    100
    6
    18
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    9:36 PM
    5.5.4
    Work like charm after clear tmp files. Is possible to increase size of tmp folder ?

    Thanks your help
     
  5. eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:36 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    contents of /etc/centminmod/php.d/zendopcache.ini ?

    really depends on how much if any unallocated disk space you have on your disk not already formatted for partitions as you current /tmp is a logical volume

    edit: found exactly your exact situation Enlarging /tmp dir - CentOS

    might want to contact your web host and see what options are available to you if you do not understand what you need to do
     
  6. YuchiRO

    YuchiRO Member

    100
    6
    18
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    9:36 PM
    5.5.4
    Here my zenopcache

    Code:
    zend_extension=opcache.so
    ;opcache.error_log=/var/log/php_opcache_error.log
    opcache.enable=1
    opcache.memory_consumption=784
    opcache.interned_strings_buffer=8
    opcache.max_wasted_percentage=5
    opcache.max_accelerated_files=16000
    ; http://php.net/manual/en/opcache.configuration.php#ini.opcache.revalidate-freq
    ; defaults to zend opcache checking every 180 seconds for PHP file changes
    ; set to zero to check every second if you are doing alot of frequent
    ; php file edits/developer work
    ; opcache.revalidate_freq=0
    opcache.revalidate_freq=180
    opcache.fast_shutdown=0
    opcache.enable_cli=0
    opcache.save_comments=1
    opcache.enable_file_override=1
    opcache.validate_timestamps=1
    ;opcache.huge_code_pages=1
    My wordpress site using redis cache + w3 totalcache.
    My server is un-manage plan, they dont support that problems.
     
  7. eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:36 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    then probably best to backup data and reload OS/repartition disk if you have control over how you partitioned and allocated /tmp size

    also might want to lower opcache memory allocation from opcache.memory_consumption=784 to
    opcache.memory_consumption=256 and restart php-fpm
     
  8. eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    12:36 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    just to elaborate on previous post when you repartition on fresh OS, don't make a /tmp partition instead let /tmp reside in / with largest disk free space