Results 1 to 4 of 4

Thread: CentOS7 MariaDB 10.1 or Mysql 5.7

  1. #1
    Join Date
    Oct 2018
    Posts
    2

    CentOS7 MariaDB 10.1 or Mysql 5.7

    Hi
    i can't install mysql 5.7 or mariaDB 10.1
    older version of mysql or mariadb installed fine but when i try install mariadb 10.1 or mysql 5.7 show this error


    Code:
    [root@server custombuild]# /usr/local/directadmin/directadmin o
    Compiled on 'CentOS 7.0 64-Bit'Compile time: Sep 16 2018 at 18:08:25
    Compiled with IPv6
    Thanks

  2. #2
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    13,311
    Hello,

    What do you see in mysql error log?

    What do you see when running the command:

    Code:
    rpm -qa | egrep -i "^(mariadb|mysql)"
    Regards, Alex G.

    - Get the best commercial DirectAdmin support and hire me on poralix.com
    - Follow and like @Poralix on Facebook

  3. #3
    Join Date
    Oct 2018
    Posts
    2
    Quote Originally Posted by zEitEr View Post
    Hello,

    What do you see in mysql error log?

    What do you see when running the command:

    Code:
    rpm -qa | egrep -i "^(mariadb|mysql)"
    Hello
    mysql error log dosen't exsit


    Code:
    [root@server log]# rpm -qa | egrep -i "^(mariadb|mysql)"
    MariaDB-devel-10.1.36-1.el7.centos.x86_64
    MariaDB-client-10.1.36-1.el7.centos.x86_64
    MariaDB-compat-10.1.36-1.el7.centos.x86_64
    MariaDB-common-10.1.36-1.el7.centos.x86_64
    MariaDB-shared-10.1.36-1.el7.centos.x86_64
    MariaDB-server-10.1.36-1.el7.centos.x86_64
    Code:
    [root@server log]# systemctl status mysqld.service
    ● mysqld.service - MariaDB database server
       Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; vendor preset: disabled)
       Active: failed (Result: exit-code) since Fri 2018-10-05 08:21:32 EDT; 11s ago
      Process: 16576 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
      Process: 16561 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exit 0; VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] &&   systemctl set-environment _WSREP_START_POSITION=$VAR ||
    exit 1 (code=exited, status=0/SUCCESS)
      Process: 16559 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
     Main PID: 16576 (code=exited, status=1/FAILURE)
       Status: "Starting Innodb crash recovery"
    
    Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
    Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [Note] Recovering after a crash using tc.log
    Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [Note] Starting crash recovery...
    Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [Note] Crash recovery finished.
    Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [Note] Server socket created on IP: '::'.
    Oct 05 08:21:32 server.behzee.com systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
    Oct 05 08:21:32 server.behzee.com systemd[1]: Failed to start MariaDB database server.
    Oct 05 08:21:32 server.behzee.com systemd[1]: Unit mysqld.service entered failed state.
    Oct 05 08:21:32 server.behzee.com systemd[1]: mysqld.service failed.
    Code:
    [root@server log]# journalctl -xe
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool sOct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: The InnoDB memory heap is disabled
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Compressed tables use zlib 1.2.7
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Using Linux native AIO
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Using SSE crc32 instructions
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Completed initialization of buffer pool
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Highest supported file format is Barracuda.
    Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: The log sequence number 0 in ibdata file do not match the log sequence number 1687737 in tOct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] InnoDB: 128 rollback segment(s) are active.
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] InnoDB: Waiting for purge to start
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1687737
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701067446016 [Note] InnoDB: Dumping buffer pool(s) not yet started
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] Plugin 'FEEDBACK' is disabled.
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] Recovering after a crash using tc.log
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] Starting crash recovery...
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] Crash recovery finished.
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] Server socket created on IP: '::'.
    Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
    Oct 05 08:25:18  systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
    Oct 05 08:25:18  systemd[1]: Failed to start MariaDB database server.
    -- Subject: Unit mysqld.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit mysqld.service has failed.
    --
    -- The result is failed.
    Oct 05 08:25:18  systemd[1]: Unit mysqld.service entered failed state.
    Oct 05 08:25:18  systemd[1]: mysqld.service failed.

  4. #4
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    13,311
    See:

    [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
    [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

    The tables are missing. Your installation might be corrupted. You might try to install MariaDB from a scratch and re-import all the data.
    Regards, Alex G.

    - Get the best commercial DirectAdmin support and hire me on poralix.com
    - Follow and like @Poralix on Facebook

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •