Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: 10.0.0
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:I wanted to install mariadb on RHEL Server release 5.8 (Tikanga).
$ uname -a
Linux vlmmk644 2.6.18-308.8.1.0.1.el5 #1 SMP Tue May 29 20:48:54 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
Description
$ ./scripts/mysql_install_db
Installing MariaDB/MySQL system tables in './data' ...
130126 5:16:47 InnoDB: The InnoDB memory heap is disabled
130126 5:16:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130126 5:16:47 InnoDB: Compressed tables use zlib 1.2.3
130126 5:16:47 InnoDB: Using Linux native AIO
130126 5:16:47 InnoDB: CPU supports crc32 instructions
130126 5:16:47 InnoDB: Error: Linux Native AIO is not supported on tmpdir.
InnoDB: You can either move tmpdir to a file system that supports native AIO
InnoDB: or you can set innodb_use_native_aio to FALSE to avoid this message.
130126 5:16:47 InnoDB: Error: Linux Native AIO check on tmpdir returned error[22]
130126 5:16:47 InnoDB: Warning: Linux Native AIO disabled.
130126 5:16:47 InnoDB: Initializing buffer pool, size = 128.0M
130126 5:16:47 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
130126 5:16:47 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130126 5:16:47 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130126 5:16:47 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130126 5:16:48 InnoDB: Doublewrite buffer not found: creating new
130126 5:16:48 InnoDB: Doublewrite buffer created
130126 5:16:48 InnoDB: 128 rollback segment(s) are active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130126 5:16:48 InnoDB: 1.2.0 started; log sequence number 0
130126 5:16:48 [ERROR] ./bin/mysqld: unknown variable 'name=MariaDB'
130126 5:16:48 [ERROR] Aborting
130126 5:16:48 InnoDB: FTS optimize thread exiting.
130126 5:16:48 InnoDB: Starting shutdown...
130126 5:16:49 InnoDB: Shutdown completed; log sequence number 1595685
130126 5:16:49 [Note] ./bin/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
./data 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> ./bin/mysqld --skip-grant --general-log &
and use the command line tool ./bin/mysql
to connect to the mysql database and look at the grant tables:
shell> ./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 ./data that may be helpful.
The latest information about mysql_install_db is available at
http://kb.askmonty.org/v/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 ./bin/mysqlbug script!
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
$ ./bin/mysqld_safe --no-defaults
130126 06:02:18 mysqld_safe Logging to '/fisc/dba/mani/mysql/data/vlmmk644.err'.
130126 06:02:18 mysqld_safe Starting mysqld daemon with databases from /fisc/dba/mani/mysql/data
rm: cannot remove `/tmp/mysql.sock': Operation not permitted
130126 06:02:19 mysqld_safe mysqld from pid file /fisc/dba/mani/mysql/data/vlmmk644.pid ended
Hi Mani,
Please try to read the messages that the software produces instead of just pasting them, they do make sense most of the time. This one says there is /tmp/mysql.sock which the server needs, but you don't have permissions for.
If you need guidance on setting correct permissions on files, please read Linux documentation.
For basic information on how to start MariaDB server, please read https://kb.askmonty.org/en/starting-and-stopping-mariadb/ (you probably need all sections).
Forgot to mention: please keep in mind that if you already have /tmp/mysql.sock, there is a chance that you also have a running MySQL/MariaDB server on the machine. If that's the case, you'll need to provide a unique port and socket value for the server you are trying to start, to avoid conflicts. Yo will find how to do that in the KB section by the link above.
Thank You.
Looks like it went through now.
$ ./bin/mysqld_safe --no-defaults
130126 07:38:18 mysqld_safe Logging to '/fisc/dba/mani/mysql/data/vlmmk644.err'.
130126 07:38:18 mysqld_safe Starting mysqld daemon with databases from /fisc/dba/mani/mysql/data
130126 07:38:19 mysqld_safe mysqld from pid file /fisc/dba/mani/mysql/data/vlmmk644.pid ended
can you please assist me here.
i have run this command ./scripts/mysql_install_db
and now i want to start mysqld and list databases
Hi,
Please attach your my.cnf file or paste its contents here.
If you didn't create my.cnf file, and you think there shouldn't be any at all, run the install script with --no-defaults option:
./scripts/mysql_install_db --no-defaults