Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.2(EOL)
-
None
Description
Hi there. I don't know did I created a right type of issue, but still. I installed MariaDB Server version
Ver 10.2.37-MariaDB for Linux on mips
|
, and when I try to run
mysql_install_db --force
|
, it can't install DB.
Full log:
Installing MariaDB/MySQL system tables in '/mnt/data/mysql' ...
|
2022-03-23 15:46:31 2013113988 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
|
2022-03-23 15:46:32 2013113988 [ERROR] mysqld: Can't create/write to file '/tmp/ibXXXXXX' (Errcode: 13 "Permission denied")
|
2022-03-23 15:46:32 2013113988 [ERROR] InnoDB: Unable to create temporary file; errno: 13
|
2022-03-23 15:46:32 2013113988 [ERROR] mysqld: Can't create/write to file '/tmp/ibXXXXXX' (Errcode: 13 "Permission denied")
|
2022-03-23 15:46:32 2013113988 [ERROR] InnoDB: Unable to create temporary file; errno: 13
|
2022-03-23 15:46:32 2013113988 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
|
2022-03-23 15:46:32 2013113988 [ERROR] Plugin 'InnoDB' init function returned error.
|
2022-03-23 15:46:32 2013113988 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
|
2022-03-23 15:46:32 2013113988 [ERROR] mysqld: Can't create/write to file '/mnt/data/mysql/aria_log_control' (Errcode: 13 "Permission denied")
|
2022-03-23 15:46:32 2013113988 [ERROR] mysqld: Got error 'Can't create file' when trying to use aria control file '/mnt/data/mysql/aria_log_control'
|
2022-03-23 15:46:32 2013113988 [ERROR] Plugin 'Aria' init function returned error.
|
2022-03-23 15:46:32 2013113988 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
|
2022-03-23 15:46:32 2013113988 [ERROR] Unknown/unsupported storage engine: InnoDB
|
2022-03-23 15:46:32 2013113988 [ERROR] Aborting
|
|
|
Warning: Memory not freed: 392
|
|
|
Installation of system tables failed! Examine the logs in
|
/mnt/data/mysql for more information.
|
|
|
The problem could be conflicting information in an external
|
my.cnf files. You can ignore these by doing:
|
|
|
shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf
|
|
|
You can also try to start the mysqld daemon with:
|
|
|
shell> /usr/bin/mysqld --skip-grant-tables --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 /mnt/data/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
|
You can find the latest source at https://downloads.mariadb.org and
|
the maria-discuss email list at https://launchpad.net/~maria-discuss
|
|
|
Please check all of the above before submitting a bug report
|
at http://mariadb.org/jira
|
And yes, I've tried to follow commands mentioned in log.
1. Could not open required defaults file: /root/.my.cnf
Fatal error in defaults handling. Program aborted
2.
2022-03-24 3:00:26 2012884612 [Note] /usr/bin/mysqld (mysqld 10.2.37-MariaDB-log) starting as process 10216 ...
|
2022-03-24 3:00:26 2012884612 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2022-03-24 3:00:26 2012884612 [Note] InnoDB: Uses event mutexes
|
2022-03-24 3:00:26 2012884612 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
2022-03-24 3:00:26 2012884612 [Note] InnoDB: Using Linux native AIO
|
2022-03-24 3:00:26 2012884612 [Note] InnoDB: Number of pools: 1
|
2022-03-24 3:00:26 2012884612 [Note] InnoDB: Using generic crc32 instructions
|
2022-03-24 3:00:26 2012884612 [ERROR] mysqld: Can't create/write to file '/tmp/ibXXXXXX' (Errcode: 13 "Permission denied")
|
2022-03-24 3:00:26 2012884612 [ERROR] InnoDB: Unable to create temporary file; errno: 13
|
2022-03-24 3:00:26 2012884612 [ERROR] mysqld: Can't create/write to file '/tmp/ibXXXXXX' (Errcode: 13 "Permission denied")
|
2022-03-24 3:00:26 2012884612 [ERROR] InnoDB: Unable to create temporary file; errno: 13
|
2022-03-24 3:00:26 2012884612 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
|
2022-03-24 3:00:26 2012884612 [Note] InnoDB: Starting shutdown...
|
2022-03-24 3:00:26 2012884612 [ERROR] Plugin 'InnoDB' init function returned error.
|
2022-03-24 3:00:26 2012884612 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
|
2022-03-24 3:00:26 2012884612 [ERROR] mysqld: Can't create/write to file '/mnt/data/mysql/aria_log_control' (Errcode: 13 "Permission denied")
|
2022-03-24 3:00:26 2012884612 [ERROR] mysqld: Got error 'Can't create file' when trying to use aria control file '/mnt/data/mysql/aria_log_control'
|
2022-03-24 3:00:26 2012884612 [ERROR] Plugin 'Aria' init function returned error.
|
2022-03-24 3:00:26 2012884612 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
|
2022-03-24 3:00:26 2012884612 [ERROR] Unknown/unsupported storage engine: InnoDB
|
2022-03-24 3:00:26 2012884612 [ERROR] Aborting
|
And 3. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
When I try to restart mysqld using service, it just says
mysqld: Cannot detect privileges table. You might need to run
mysqld: 'mysql_install_db --force --basedir=/usr'
mysqld: to initialize the system tables.
That command also fails with permission denied.
But, the permissions are fine. /mnt/data/mysql is owned by mariadb, and it has 777 permissions on it. TMP folder also has 777 permissions on it.
Can somebody help me with that issue?
Are the locations mounted read only? What filesystem(s)?
Is there apparmor, selinux or another MAC system enabled?