Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.1.18
-
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]$
|