Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Fixed
-
5.1.67, 5.2.14, 5.3.12, 5.5.35, 10.0.8
-
None
-
None
-
Debian wheezy amd64 using MariaDB debian repository packages
Description
For various reasons I am encountering errors when attempting to setup a database (Note, those problems are not the subject of this bug)
However, the error message suggests running file /usr/scripts/mysqlbug which does not exist (neither does directory /usr/scripts)
Installation was from APT repository http://mirror.aarnet.edu.au/pub/MariaDB/repo/10.0/debian version 10.0.8+maria-1~wheezy, as per the instructions at https://downloads.mariadb.org/mariadb/repositories/#mirror=aarnet_pty_ltd&distro=Debian&distro_release=wheezy&version=10.0
I eventually found the file at /usr/bin/mysqlbug provided by mariadb-client-10.0
Example:
root@atlantis4:/var/log# mysql_install_db --verbose
|
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
|
140216 22:06:29 [Note] InnoDB: The InnoDB memory heap is disabled
|
140216 22:06:29 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
140216 22:06:29 [Note] InnoDB: Compressed tables use zlib 1.2.7
|
140216 22:06:29 [Note] InnoDB: Using Linux native AIO
|
140216 22:06:29 [Note] InnoDB: Not using CPU crc32 instructions
|
140216 22:06:29 [Note] InnoDB: Initializing buffer pool, size = 256.0M
|
140216 22:06:29 [Note] InnoDB: Completed initialization of buffer pool
|
140216 22:06:29 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
|
140216 22:06:29 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
|
140216 22:06:29 [Note] InnoDB: Database physically writes the file full: wait...
|
140216 22:06:29 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
|
140216 22:06:30 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
|
2014-02-16 22:06:30 7f4114944780 InnoDB: Operating system error number 22 in a file operation.
|
InnoDB: Error number 22 means 'Invalid argument'.
|
InnoDB: Some operating system error numbers are described at
|
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
|
140216 22:06:30 [ERROR] InnoDB: File ./ib_logfile101: 'aio write' returned OS error 122. Cannot continue operation
|
|
Installation of system tables failed! Examine the logs in
|
/var/lib/mysql for more information.
|
|
The problem could be conflicting information in an external
|
my.cnf files. You can ignore these by doing:
|
|
shell> /scripts/mysql_install_db --defaults-file=~/.my.cnf
|
|
You can also try to start the mysqld daemon with:
|
|
shell> /usr/sbin/mysqld --skip-grant --general-log &
|
|
and use the command line tool /usr/bin/mysql
|
to connect to the mysql database and look at the grant tables:
|
|
shell> /usr/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 /var/lib/mysql 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 mailing us! And remember, if
|
you do mail us, you should use the /usr/scripts/mysqlbug script!
|
Attachments
Issue Links
- is part of
-
MDEV-5652 5.5.36 merge
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Description |
For various reasons I am encountering errors when attempting to setup a database (Note, those problems are not the subject of this bug) However, the error message suggests running file /usr/scripts/mysqlbug which does not exist (neither does directory /usr/scripts) Installation was from APT repository http://mirror.aarnet.edu.au/pub/MariaDB/repo/10.0/debian version 10.0.8+maria-1~wheezy, as per the instructions at https://downloads.mariadb.org/mariadb/repositories/#mirror=aarnet_pty_ltd&distro=Debian&distro_release=wheezy&version=10.0 I eventually found the file at /usr/bin/mysqlbug provided by mariadb-client-10.0 Example: root@atlantis4:/var/log# mysql_install_db --verbose Installing MariaDB/MySQL system tables in '/var/lib/mysql' ... 140216 22:06:29 [Note] InnoDB: The InnoDB memory heap is disabled 140216 22:06:29 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 140216 22:06:29 [Note] InnoDB: Compressed tables use zlib 1.2.7 140216 22:06:29 [Note] InnoDB: Using Linux native AIO 140216 22:06:29 [Note] InnoDB: Not using CPU crc32 instructions 140216 22:06:29 [Note] InnoDB: Initializing buffer pool, size = 256.0M 140216 22:06:29 [Note] InnoDB: Completed initialization of buffer pool 140216 22:06:29 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 140216 22:06:29 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 140216 22:06:29 [Note] InnoDB: Database physically writes the file full: wait... 140216 22:06:29 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 140216 22:06:30 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2014-02-16 22:06:30 7f4114944780 InnoDB: Operating system error number 22 in a file operation. InnoDB: Error number 22 means 'Invalid argument'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html 140216 22:06:30 [ERROR] InnoDB: File ./ib_logfile101: 'aio write' returned OS error 122. Cannot continue operation Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/sbin/mysqld --skip-grant --general-log & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/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 /var/lib/mysql 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 mailing us! And remember, if you do mail us, you should use the /usr/scripts/mysqlbug script! |
For various reasons I am encountering errors when attempting to setup a database (Note, those problems are not the subject of this bug) However, the error message suggests running file /usr/scripts/mysqlbug which does not exist (neither does directory /usr/scripts) Installation was from APT repository http://mirror.aarnet.edu.au/pub/MariaDB/repo/10.0/debian version 10.0.8+maria-1~wheezy, as per the instructions at https://downloads.mariadb.org/mariadb/repositories/#mirror=aarnet_pty_ltd&distro=Debian&distro_release=wheezy&version=10.0 I eventually found the file at /usr/bin/mysqlbug provided by mariadb-client-10.0 Example: {noformat} root@atlantis4:/var/log# mysql_install_db --verbose Installing MariaDB/MySQL system tables in '/var/lib/mysql' ... 140216 22:06:29 [Note] InnoDB: The InnoDB memory heap is disabled 140216 22:06:29 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 140216 22:06:29 [Note] InnoDB: Compressed tables use zlib 1.2.7 140216 22:06:29 [Note] InnoDB: Using Linux native AIO 140216 22:06:29 [Note] InnoDB: Not using CPU crc32 instructions 140216 22:06:29 [Note] InnoDB: Initializing buffer pool, size = 256.0M 140216 22:06:29 [Note] InnoDB: Completed initialization of buffer pool 140216 22:06:29 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 140216 22:06:29 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 140216 22:06:29 [Note] InnoDB: Database physically writes the file full: wait... 140216 22:06:29 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 140216 22:06:30 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2014-02-16 22:06:30 7f4114944780 InnoDB: Operating system error number 22 in a file operation. InnoDB: Error number 22 means 'Invalid argument'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html 140216 22:06:30 [ERROR] InnoDB: File ./ib_logfile101: 'aio write' returned OS error 122. Cannot continue operation Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/sbin/mysqld --skip-grant --general-log & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/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 /var/lib/mysql 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 mailing us! And remember, if you do mail us, you should use the /usr/scripts/mysqlbug script! {noformat} |
Affects Version/s | 5.1.67 [ 12100 ] | |
Affects Version/s | 5.2.14 [ 12101 ] | |
Affects Version/s | 5.3.12 [ 12000 ] | |
Affects Version/s | 5.5.35 [ 14000 ] |
Assignee | Sergei Golubchik [ serg ] |
Fix Version/s | 10.0.9 [ 14400 ] | |
Fix Version/s | 5.5.36 [ 14600 ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Workflow | defaullt [ 34733 ] | MariaDB v2 [ 42804 ] |
Workflow | MariaDB v2 [ 42804 ] | MariaDB v3 [ 61813 ] |
Workflow | MariaDB v3 [ 61813 ] | MariaDB v4 [ 147518 ] |