Details
Description
Hello we are doing some testing for mariaDB in our environment. Can you please take a look and offer a possible resolution?
Thank you!
[mweiner@mariadb sql]$ ./mysqld & [1] 2261 [mweiner@mariadb sql]$ 141104 12:52:31 [Warning] An old style --language or -lc-message-dir value with language specific part detected: /opt/mariadb-10.0.14/sql/share/english/ 141104 12:52:31 [Warning] Use --lc-messages-dir without language specific part instead. 141104 12:52:31 [Warning] Can't create test file /opt/mariadb-10.0.14/mariadb.lower-test 141104 12:52:31 [Note] InnoDB: Using mutexes to ref count buffer pool pages 141104 12:52:31 [Note] InnoDB: The InnoDB memory heap is disabled 141104 12:52:31 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 141104 12:52:31 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 141104 12:52:31 [Note] InnoDB: Compressed tables use zlib 1.2.3 141104 12:52:31 [Note] InnoDB: Not using CPU crc32 instructions 141104 12:52:31 [Note] InnoDB: Initializing buffer pool, size = 128.0M 141104 12:52:31 [Note] InnoDB: Completed initialization of buffer pool 141104 12:52:31 [Note] InnoDB: Highest supported file format is Barracuda. 2014-11-04 12:52:31 3fffd6a8720 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. 141104 12:52:31 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/gtid_slave_pos'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 141104 12:52:31 [ERROR] InnoDB: Tablespace open failed for '"mysql"."gtid_slave_pos"', ignored. 2014-11-04 12:52:31 3fffd6a8720 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. 141104 12:52:31 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/innodb_index_stats'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 141104 12:52:31 [ERROR] InnoDB: Tablespace open failed for '"mysql"."innodb_index_stats"', ignored. 2014-11-04 12:52:31 3fffd6a8720 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. 141104 12:52:31 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/innodb_table_stats'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 141104 12:52:31 [ERROR] InnoDB: Tablespace open failed for '"mysql"."innodb_table_stats"', ignored. 141104 12:52:31 [Note] InnoDB: 128 rollback segment(s) are active. 141104 12:52:31 [Note] InnoDB: Waiting for purge to start 141104 12:52:31 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 1616718 141104 12:52:31 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 141104 12:52:31 [Warning] ./mysqld: unknown option '--loose-mutex-deadlock-detector' 141104 12:52:31 [Warning] ./mysqld: unknown option '--loose-mutex-deadlock-detector' 141104 12:52:31 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 141104 12:52:31 [Note] Server socket created on IP: '::'. 141104 12:52:31 [ERROR] Can't start server : Bind on unix socket: Permission denied 141104 12:52:31 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 141104 12:52:31 [ERROR] Aborting 141104 12:52:31 [Note] InnoDB: FTS optimize thread exiting. 141104 12:52:31 [Note] InnoDB: Starting shutdown... 141104 12:52:34 [Note] InnoDB: Shutdown completed; log sequence number 1616728 141104 12:52:34 [Note] ./mysqld: Shutdown complete
^C
[1]+ Exit 1 ./mysqld
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Issuing from root I encounter:
[root@mariadb sql]# ./mysqld
141104 14:44:50 [Warning] An old style --language or -lc-message-dir value with language specific part detected: /opt/mariadb-10.0.14/sql/share/english/
141104 14:44:50 [Warning] Use --lc-messages-dir without language specific part instead.
141104 14:44:51 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
141104 14:44:51 [ERROR] Aborting
141104 14:44:51 [Note] ./mysqld: Shutdown complete