Bug #41215 Permissions problem running mysql_install_db on suse9
Submitted: 3 Dec 2008 19:43 Modified: 15 May 2013 21:57
Reporter: Michelle Caisse Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Packaging Severity:S3 (Non-critical)
Version:6.0.8-0 OS:Linux (suse 9)
Assigned to: Assigned Account CPU Architecture:Any

[3 Dec 2008 19:43] Michelle Caisse
Description:
qauser@qa-suse9-x86:/data0/michelle> mysql_install_db
Installing MySQL system tables...
081203 20:30:28 [Warning] Can't create test file /var/lib/mysql/qa-suse9-x86.lower-test
081203 20:30:28 [Warning] Can't create test file /var/lib/mysql/qa-suse9-x86.lower-test
081203 20:30:28 [ERROR] Falcon: can't open file "/var/lib/mysql/falcon_master.fts": Permission denied (13)
081203 20:30:28 [ERROR] Plugin 'Falcon' init function returned error.
081203 20:30:28 [ERROR] Plugin 'Falcon' registration as a STORAGE ENGINE failed.
081203 20:30:28 [ERROR] mysqld: File '/var/lib/mysql/maria_log_control' not found (Errcode: 13)
081203 20:30:28 [ERROR] mysqld: Got error 'Can't open file' when trying to use maria control file '/var/lib/mysql/maria_log_control'
081203 20:30:28 [ERROR] Plugin 'MARIA' init function returned error.
081203 20:30:28 [ERROR] Plugin 'MARIA' registration as a STORAGE ENGINE failed.
081203 20:30:28 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=1
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 337762 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x9289018
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x40d14028 thread_stack 0x30c00
/usr/sbin/mysqld(unsigned long+0x28) [0x8643208]
/usr/sbin/mysqld(unsigned char+0x3ec) [0x824aa4c]
[0xffffe420]
/usr/sbin/mysqld(plugin_lock(THD*, st_plugin_int**)+0x2b) [0x83afa4b]
/usr/sbin/mysqld(ha_resolve_by_legacy_type(THD*, legacy_db_type)+0x34) [0x8333de4]
/usr/sbin/mysqld(ha_checktype(THD*, legacy_db_type, bool, bool)+0x2c) [0x8333e2c]
/usr/sbin/mysqld(sys_var_thd_storage_engine::check(THD*, set_var*)+0x167) [0x826bdf7]
/usr/sbin/mysqld(set_var::check(THD*)+0x11b) [0x826aeab]
/usr/sbin/mysqld(sql_set_variables(THD*, List<set_var_base>*)+0x3f) [0x826c02f]
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x2614) [0x8259c54]
/usr/sbin/mysqld(mysql_parse(THD*, char const*, unsigned, char const**)+0x13d) [0x825ddfd]
/usr/sbin/mysqld(unsigned char+0x429) [0x825ff59]
/lib/tls/libpthread.so.0 [0x40044aa7]
/lib/tls/libc.so.6(__clone+0x5e) [0x401f8c2e]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x929a190 = set storage_engine=myisam
thd->thread_id=1
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/sbin/mysqld --skip-grant &

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 --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com/.  Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!

How to repeat:
mysql_install_db
[3 Dec 2008 23:38] Michelle Caisse
No problem when running as root (sudo) with no existing /var/lib/mysql directory. No problem running on top of a just-created /var/lib/mysql, i.e. running mysql_install_db twice in a row. There seems to be a problem running on top of an existing /var/lib/mysql from a previous version. Needs a more complete repro.
[15 May 2013 21:57] Yngve Svendsen
Obsolete Server version, obsolete OS version, incomplete reproduction case.