Want to subscribe to topics you're interested in?
Become a Member

Install MariaDB Problem with Starting MariaDB

Discussion in 'Install & Upgrades or Pre-Install Questions' started by R0rke, Dec 22, 2018.

  1. R0rke

    R0rke Member

    127
    17
    18
    Jun 2, 2016
    Iran
    Ratings:
    +28
    Local Time:
    1:10 AM
    1.11.1
    10.1
    • CentOS Version: CentOS 7 64bit
    • Centmin Mod Version Installed: 123.09beta01
    • Nginx Version Installed: nginx/1.15.7
    • PHP Version Installed: PHP 5.6.39
    • MariaDB MySQL Version Installed: can't detect
    • When was last time updated Centmin Mod code base? : its latest fresh install
    • Persistent Config: there is no config done by me.
    Code:
    cat: /etc/centminmod/custom_config.inc: No such file or directory
    I installed Centminmod latest version via git on fresh Centos 7.
    and this happened after install
    Capture.PNG
    also MariaDB not working
    Code:
     Unit mariadb.service has begun starting up.
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [Note] /usr/sbin/mysqld (mysqld 10.1.37-MariaDB) starting as process 32
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [Note] InnoDB: The InnoDB memory heap is disabled
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory b
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [Note] InnoDB: Compressed tables use zlib 1.2.7
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [Note] InnoDB: Using Linux native AIO
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [Note] InnoDB: Using SSE crc32 instructions
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [ERROR] mysqld: Can't create/write to file '/home/mysqltmp/ib6swavP' (E
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 7fd68ae00900  InnoDB: Error: unable to create temporary file; errno: 13
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [ERROR] Plugin 'InnoDB' init function returned error.
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [Note] Plugin 'FEEDBACK' is disabled.
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [ERROR] Unknown/unsupported storage engine: InnoDB
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [ERROR] Aborting
    Dec 21 17:07:59 local.host systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    Dec 21 17:07:59 local.host systemd[1]: Failed to start MariaDB 10.1.37 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.

     
  2. eva2000

    eva2000 Administrator Staff Member

    37,710
    8,254
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,710
    Local Time:
    7:10 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    seems related to
    Code (Text):
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 140559429667072 [ERROR] mysqld: Can't create/write to file '/home/mysqltmp/ib6swavP' (E
    Dec 21 17:07:59 local.host mysqld[32248]: 2018-12-21 17:07:59 7fd68ae00900  InnoDB: Error: unable to create temporary file; errno: 13
    


    for 100% sure method use the installers these days
    Code (Text):
    yum -y update; curl -O https://centminmod.com/betainstaller.sh && chmod 0700 betainstaller.sh && bash betainstaller.sh
    

    if there isn't any data on newly installed 123.09beta01, easiest way is just reload fresh CentOS 7 OS, and re-install fresh centminmod 123.09beta01

    or you need to troubleshoot this install

    To troubleshoot initial installation, you need to check the initial install log at /root/centminlogs and instructions under Sharing logs and errors heading for using Pastebin.com or Gists to share a sanitised version of the contents of the initial install log. You can see full details at How to troubleshoot Centmin Mod initial install issues

    Example for 123.09beta01 and newer list /root/centminlogs files in date ascending order and grep for installer_*
    Code (Text):
    ls -lahrt /root/centminlogs | grep installer_*
    

    example output returns install log at /root/centminlogs both a the full log and minimal log (smaller in size with some stuff filtered out)
    Code (Text):
    ls -lahrt /root/centminlogs | grep installer_*
    -rw-r--r-- 1 root root 4.3M Jul 12 09:06 installer_120718-083445.log
    -rw-r--r-- 1 root root 826K Jul 12 10:20 installer_120718-083445_minimal.log
    


    Example for 123.08stable list /root/centminlogs files in date ascending order and grep for install.log
    Code (Text):
    ls -lahrt /root/centminlogs | grep install.log
    

    example output returns install log at /root/centminlogs/centminmod_1.2.3-eva2000.09.001_111016-112321_install.log
    Code (Text):
    ls -lahrt /root/centminlogs | grep install.log
    -rw-r--r--  1 root root 2.2M Oct 11 01:40 centminmod_1.2.3-eva2000.09.001_111016-112321_install.log
    

    in SSH use cat to ouput contents of /root/centminlogs/centminmod_1.2.3-eva2000.09.001_111016-112321_install.log. Clear your SSH client window/buffer so only output is the contents of the file

    for 123.08stable
    Code (Text):
    cat /root/centminlogs/centminmod_1.2.3-eva2000.09.001_111016-112321_install.log
    

    for 123.09beta01 and newer
    Code (Text):
    cat /root/centminlogs/installer_120718-083445_minimal.log
    


    Then copy and paste into Pastebin.com or Gists entry. If your SSH window scroll buffer isn't that large to get the whole contents of the install log, you can download file manually and copy and paste contents. But makes sure it's sanitised version of the contents of the initial install log as outlined at How to troubleshoot Centmin Mod initial install issues
     
    • Like Like x 1
  3. R0rke

    R0rke Member

    127
    17
    18
    Jun 2, 2016
    Iran
    Ratings:
    +28
    Local Time:
    1:10 AM
    1.11.1
    10.1
    I do reinstall after a fresh installation of centos, but still same issue.
    i can't use installers cause i do some custom changes before install.
    i send logs in a private message to u. I'm not able to post them on Pastebin cause of limitation on free users or guests on their website.
     
  4. eva2000

    eva2000 Administrator Staff Member

    37,710
    8,254
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,710
    Local Time:
    7:10 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
..