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

MariaDB installation failed at custom directory installation

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.1.18
    • N/A
    • Configuration
    • None
    • Installation on CentOS 7

    Description

      Hi,

      I got the installation failed and help me where I did the mistake.

      1) login as mysql user
      2) cd /opt
      3) tar -zxvf /Downloads/mariadb-10.1.18-linux-glibc_214-x86_64.tar.gz >/dev/null
      4) ln -s /opt/mariadb-10.1.18-linux-glibc_214-x86_64 /opt/mysql
      5) cd mysql
      6) scripts/mysql_install_db --basedir=/opt/mysql --datadir=/LabOps/iSupport/data --defaults-file=/LabOps/iSupport/conf/mariadb.cnf --force --user=mysql
      OUTPUT:

      [mysql@jenkins-maa-01 mysql]$ scripts/mysql_install_db --basedir=/opt/mysql --datadir=/LabOps/iSupport/data --defaults-file=/LabOps/iSupport/conf/mariadb.cnf --force --user=mysql
      Installing MariaDB/MySQL system tables in '/LabOps/iSupport/data' ...
      2016-11-08 14:06:36 139900257593216 [Note] Using unique option prefix 'data' is error-prone and can break in the future. Please use the full name 'datadir' instead.
      2016-11-08 14:06:36 139900257593216 [Note] /opt/mysql/bin/mysqld (mysqld 10.1.18-MariaDB) starting as process 2897 ...
      2016-11-08 14:06:36 139900257593216 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2016-11-08 14:06:36 139900257593216 [Note] InnoDB: The InnoDB memory heap is disabled
      2016-11-08 14:06:36 139900257593216 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2016-11-08 14:06:36 139900257593216 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
      2016-11-08 14:06:36 139900257593216 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2016-11-08 14:06:36 139900257593216 [Note] InnoDB: Using Linux native AIO
      2016-11-08 14:06:36 139900257593216 [Note] InnoDB: Using SSE crc32 instructions
      2016-11-08 14:06:36 139900257593216 [Note] InnoDB: Initializing buffer pool, size = 128.0M
      2016-11-08 14:06:36 139900257593216 [Note] InnoDB: Completed initialization of buffer pool
      2016-11-08 14:06:36 139900257593216 [ERROR] InnoDB: Data file ./ibdata1 is of a different size 768 pages (rounded down to MB) than specified in the .cnf file 64000 pages!
      2016-11-08 14:06:36 139900257593216 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
      2016-11-08 14:06:36 139900257593216 [ERROR] Plugin 'InnoDB' init function returned error.
      2016-11-08 14:06:36 139900257593216 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      2016-11-08 14:06:36 139900257593216 [ERROR] /opt/mysql/bin/mysqld: unknown option '--log-slow-queries'
      2016-11-08 14:06:36 139900257593216 [ERROR] Aborting
      

      Installation of system tables failed!  Examine the logs in
      /LabOps/iSupport/data for more information.
       
      The problem could be conflicting information in an external
      my.cnf files. You can ignore these by doing:
       
          shell> /opt/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf
       
      You can also try to start the mysqld daemon with:
       
          shell> /opt/mysql/bin/mysqld --skip-grant --general-log &
       
      and use the command line tool /opt/mysql/bin/mysql
      to connect to the mysql database and look at the grant tables:
       
          shell> /opt/mysql/bin/mysql -u root mysql
          mysql> show tables;
       
      Try 'mysqld --help' if you have problems with paths.  Using
      --general-log gives you a log in /LabOps/iSupport/data that may be helpful.
       
      The latest information about mysql_install_db is available at
      https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
      MariaDB is hosted on launchpad; You can find the latest source and
      email lists at http://launchpad.net/maria
       
      Please check all of the above before submitting a bug report
      at http://mariadb.org/jira
      

      [mysql@jenkins-maa-01 mysql]$ cat /LabOps/iSupport/conf/mariadb.cnf
      [client-server]
      socket=/LabOps/iSupport/temp/mysql.sock
      port=3306
       
      [client]
      #password=my_password
       
      [mysqld]
      data=/LabOps/iSupport/data
       
      loose-innodb_data_file_path = ibdata1:1000M
      loose-innodb_file_per_table
       
      log-basename=mysqld
       
      general-log
      log-slow-queries
      [mysql@jenkins-maa-01 mysql]$
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            kimuthuselvan Muthuselvan I K
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.