Comment 6 for bug 1179359

Revision history for this message
Roel Van de Paar (roel11) wrote : Re: mysql_install_db does not function properly in PS 5.6.10-alpha60.2-341

The problem is: mysqld-debug vs mysqld, and it happens only on debug + valgrind/debug binaries:

===================
[roel@qaserver Percona-Server-5.6.11-alpha60.3-372-debug.Linux.x86_64]$ ./scripts/mysql_install_db --no-defaults --basedir=/ssd/Percona-Server-5.6.11-alpha60.3-372-debug.Linux.x86_64 --datadir=/ssd/Percona-Server-5.6.11-alpha60.3-372-debug.Linux.x86_64/data
FATAL ERROR: Could not find

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.

[roel@qaserver Percona-Server-5.6.11-alpha60.3-372-debug.Linux.x86_64]$ mv bin/mysqld-debug bin/mysqld <-------- !!!
[roel@qaserver Percona-Server-5.6.11-alpha60.3-372-debug.Linux.x86_64]$ ./scripts/mysql_install_db --no-defaults --basedir=/ssd/Percona-Server-5.6.11-alpha60.3-372-debug.Linux.x86_64 --datadir=/ssd/Percona-Server-5.6.11-alpha60.3-372-debug.Linux.x86_64/data
Installing MySQL system tables...2013-06-17 08:59:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[.... works ....]
===================

And it's clear from the source it doesn't check for mysqld-debug:

===================
-x $mysqld or -f "$mysqld.exe" or cannot_find_file($mysqld);
# Try to determine the hostname
my $hostname = hostname();
===================

Unless there is a good/specific reason, I would like to ask we not use mysql-debug in any case, it unnecessarily complicates testing in various ways.