Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9927

issue during installtion on MariaDB 10.1.8 on RHEL 7

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.1.8
    • N/A
    • Platform RedHat
    • None
    • RHEL 7

    Description

      I have done below steps to install mariaDB on my test server.

      OS : RHEL 7
      DB : MariaDB 10.1.8

      ln -s /opt/mariadb/mariadb-10.1.8-linux-x86_64 /opt/mariadb/mysql
      groupadd mysql
      useradd -g mysql mysql⁠⁠⁠⁠
      chown -R mysql:mysql /opt/mariadb/mysql/⁠⁠⁠⁠
      cp /opt/mariadb/mysql/support-files/my-small.cnf /etc/my.cnf
      basedir=/opt/mariadb/mysql
      datadir=/opt/mariadb/mysql/data
      user=mysql
      /opt/mariadb/mysql/scripts/mysql_install_db --user=mysql --basedir=/opt/mariadb/mysql --datadir=/opt/mariadb/mysql/data
      

      logs for the installation :

      [root@dpgap02v scripts]# /opt/mariadb/mysql/scripts/mysql_install_db --user=mysql --basedir=/opt/mariadb/mysql --datadir=/opt/mariadb/mysql/data
      Installing MariaDB/MySQL system tables in '/opt/mariadb/mysql/data' ...
      2016-04-15 12:05:53 140604141901696 [Note] /opt/mariadb/mysql/bin/mysqld (mysqld 10.1.8-MariaDB) starting as process 19522 ...
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: The InnoDB memory heap is disabled
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Memory barrier is not used
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Using Linux native AIO
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Using CPU crc32 instructions
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Initializing buffer pool, size = 128.0M
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Completed initialization of buffer pool
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Highest supported file format is Barracuda.
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600709 in the ib_logfiles!
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Database was not shutdown normally!
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Starting crash recovery.
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Reading tablespace information from the .ibd files...
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Restoring possible half-written data pages
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: from the doublewrite buffer...
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: 128 rollback segment(s) are active.
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Waiting for purge to start
      2016-04-15 12:05:53 140604141901696 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1600709
      2016-04-15 12:05:53 140603593561856 [Note] InnoDB: Dumping buffer pool(s) not yet started
      2016-04-15 12:05:53 140604141901696 [Note] Recovering after a crash using tc.log
      2016-04-15 12:05:53 140604141901696 [Note] Starting crash recovery...
      2016-04-15 12:05:53 140604141901696 [Note] Crash recovery finished.
      OK
      Filling help tables...
      2016-04-15 12:05:56 139928902223744 [Note] /opt/mariadb/mysql/bin/mysqld (mysqld 10.1.8-MariaDB) starting as process 19569 ...
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: The InnoDB memory heap is disabled
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Memory barrier is not used
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Using Linux native AIO
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Using CPU crc32 instructions
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Initializing buffer pool, size = 128.0M
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Completed initialization of buffer pool
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Highest supported file format is Barracuda.
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: 128 rollback segment(s) are active.
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Waiting for purge to start
      2016-04-15 12:05:56 139928902223744 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1616809
      2016-04-15 12:05:56 139928352560896 [Note] InnoDB: Dumping buffer pool(s) not yet started
      OK
      Creating OpenGIS required SP-s...
      2016-04-15 12:05:58 140614828787584 [Note] /opt/mariadb/mysql/bin/mysqld (mysqld 10.1.8-MariaDB) starting as process 19613 ...
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: The InnoDB memory heap is disabled
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Memory barrier is not used
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Using Linux native AIO
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Using CPU crc32 instructions
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Initializing buffer pool, size = 128.0M
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Completed initialization of buffer pool
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Highest supported file format is Barracuda.
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: 128 rollback segment(s) are active.
      2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Waiting for purge to start
      2016-04-15 12:05:59 140614828787584 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1616819
      2016-04-15 12:05:59 140614280656640 [Note] InnoDB: Dumping buffer pool(s) not yet started
      OK
       
      To start mysqld at boot time you have to copy
      support-files/mysql.server to the right place for your system
       
      PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
      To do so, start the server, then issue the following commands:
       
      '/opt/mariadb/mysql/bin/mysqladmin' -u root password 'new-password'
      '/opt/mariadb/mysql/bin/mysqladmin' -u root -h dpgap02v password 'new-password'
       
      Alternatively you can run:
      '/opt/mariadb/mysql/bin/mysql_secure_installation'
       
      which will also give you the option of removing the test
      databases and anonymous user created by default.  This is
      strongly recommended for production servers.
       
      See the MariaDB Knowledgebase at http://mariadb.com/kb or the
      MySQL manual for more instructions.
       
      You can start the MariaDB daemon with:
      cd '/opt/mariadb/mysql' ; /opt/mariadb/mysql/bin/mysqld_safe --datadir='/opt/mariadb/mysql/data'
       
      You can test the MariaDB daemon with mysql-test-run.pl
      cd '/opt/mariadb/mysql/mysql-test' ; perl mysql-test-run.pl
       
      Please report any problems at http://mariadb.org/jira
       
      The latest information about MariaDB is available at http://mariadb.org/.
      You can find additional information about the MySQL part at:
      http://dev.mysql.com
      Support MariaDB development by buying support/new features from MariaDB
      Corporation Ab. You can contact us about this at sales@mariadb.com.
      Alternatively consider joining our community based development effort:
      http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
      

      [root@dpgap02v scripts]#
      [root@dpgap02v scripts]#
      [root@dpgap02v scripts]#
      [root@dpgap02v scripts]# service mysql start
      Starting mysql (via systemctl):                            [  OK  ]
      [root@dpgap02v scripts]# service mysql status
      ERROR! MySQL is not running
      

      mysql is not up and running here.

      please suggest me.

      Thanks
      Anil

      Attachments

        Activity

          People

            Unassigned Unassigned
            anilvidhani Anil
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.