Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 333335 - dev-db/mariadb-5.1.42-r1 install_mysql_db fails
Summary: dev-db/mariadb-5.1.42-r1 install_mysql_db fails
Status: RESOLVED TEST-REQUEST
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: AMD64 Linux
: High normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-18 18:42 UTC by Curtis Maurand
Modified: 2010-10-06 20:36 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Curtis Maurand 2010-08-18 18:42:45 UTC
download, compilation and install of mariadb05.1.42-r1 goes smoothly.  When I run emerge --config =dev-db/mariadb-5.1.42-r1, mysql_install_db fails.  This is a relatively new gentoo install.  This also fails with mysql-5.1.42 as well, but for different reasons.

Reproducible: Always

Steps to Reproduce:
1. emerge mariadb
2. emerge --config =dev-db/mariadb-5.1.42-r1
3.

Actual Results:  
 * Please provide a password for the mysql 'root' user now,
 * or in the MYSQL_ROOT_PASSWORD env var.
 * Avoid ["'\_%] characters in the password
    >
 * Retype the password
    >
 * ERROR: dev-db/mariadb-5.1.42-r1 failed:
 *   Failed to run mysql_install_db. Please review /var/log/mysql/mysqld.err AND /var/tmp/portage/dev-db/mariadb-5.1.42-r1/temp/mysql_install_db.log
 *
 * Call stack:
 *     ebuild.sh, line   54:  Called pkg_config
 *   environment, line 4168:  Called mysql_pkg_config
 *   environment, line 3737:  Called die
 * The specific snippet of code:
 *           die "Failed to run mysql_install_db. Please review /var/log/mysql/mysqld.err AND ${TMPDIR}/mysql_install_db.log";
 *
 * If you need support, post the output of 'emerge --info =dev-db/mariadb-5.1.42-r1',
 * the complete build log and the output of 'emerge -pqv =dev-db/mariadb-5.1.42-r1'.
 * This ebuild is from an overlay named 'gentoo': '//var/db/pkg/'
 * The complete build log is located at '/var/tmp/portage/dev-db/mariadb-5.1.42-r1/temp/build.log'.
 * The ebuild environment file is located at '/var/tmp/portage/dev-db/mariadb-5.1.42-r1/temp/environment'.
 * S: '/var/tmp/portage/dev-db/mariadb-5.1.42-r1/work/mariadb-5.1.42'

Also

Installing MariaDB/MySQL system tables...

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 MariaDB is available on the web at
http://askmonty.org/wiki/index.php/MariaDB.
If you have a problem, you can consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS at http://dev.mysql.com/doc/
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 /usr/scripts/mysqlbug script!



Expected Results:  
Expected that the databases would install properly thereby giving me a funcioning server.

Portage 2.1.8.3 (default/linux/amd64/10.0, gcc-4.3.4, glibc-2.11.2-r0, 2.6.32-gentoo-r7 x86_64)
=================================================================
                        System Settings
=================================================================
System uname: Linux-2.6.32-gentoo-r7-x86_64-AMD_Phenom-tm-_II_X6_1055T_Processor-with-gentoo-1.12.13
Timestamp of tree: Wed, 18 Aug 2010 14:05:01 +0000
app-shells/bash:     4.0_p37
dev-lang/python:     2.6.5-r2, 3.1.2-r3
dev-util/cmake:      2.6.4-r3
sys-apps/baselayout: 1.12.13
sys-apps/sandbox:    1.6-r2
sys-devel/autoconf:  2.13, 2.65
sys-devel/automake:  1.9.6-r3, 1.10.3, 1.11.1
sys-devel/binutils:  2.20.1-r1
sys-devel/gcc:       4.3.4, 4.4.3-r2
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6b
virtual/os-headers:  2.6.30-r1
ACCEPT_KEYWORDS="amd64"
ACCEPT_LICENSE="* -@EULA"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-Os -pipe -fomit-frame-pointer -march=barcelona"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo"
CXXFLAGS="-Os -pipe -fomit-frame-pointer -march=barcelona"
DISTDIR="/usr/portage/distfiles"
FEATURES="assume-digests distlocks fixpackages news parallel-fetch protect-owned sandbox sfperms strict unmerge-logs unmerge-orphans userfetch"
GENTOO_MIRRORS="http://mirror.datapipe.net/gentoo"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="3dnow 3dnowext X acl alsa amavis amd64 amr apache2 authdaemond bcmath berkdb big-tables bl bzip2 cairo cdb cli cluster consolekit cracklib crypt ctype cups cxx daemon db dbm dbus device-mapper dga directfb dmx dri emerald esd expat extraengine extras faac faad fam fat flatfile fortran ftp gd gdu gif glibc-omitfp gmplayer gnome gnutls gocr gpm gs gsm gtk hal hash hpijs iconv imagemagick imap innodb iodbc jbig jfs joystick jpeg jpeg2k json kerberos lame libedit logrotate lzo mad max-idx-128 milter mmx mmxext mng modules mp3 mp4 mpeg mssql mudflap multilib mysql mysqli nagios-dns nagios-game nagios-ntp nagios-ping nagios-ssh ncurses netpbm nfsv3 nls nptl nptlonly ntfs ocrad odbc openal openmp openssl opensslcrypt openvz pam pbxt pcre pdo perl png policykit posix pppd pth pulseaudio python qdbm readline reflection reiser4 reiserfs rrdtool samba sasl schroedinger sdl session sieve simplexml smtp soap sockets spamassassin speex spl sqlite sqlite3 sse sse2 sse4a ssl subversion svg sysfs syslog tcpd tesseract theora threads threadsafe tiff tls tools truetype unicode vde vdpau vorbis wddx x264 xanim xfs xine xinerama xml xmlpatterns xmlreader xmlrpc xmlwriter xorg xpm xsl xslt xvid xvmc zip zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default                    authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner                  authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env                 expires ext_filter file_cache filter headers include info log_config logio                    mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id                    userdir usertrack vhost_alias asis auth_digest authn_dbd imap                    dbd imagemap" APACHE2_MPMS="worker" ELIBC="glibc" INPUT_DEVICES="evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="radeon radeonhd" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, LINGUAS, MAKEOPTS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY

=================================================================
                        Package Settings
=================================================================

dev-db/mariadb-5.1.42-r1 was built with the following:
USE="big-tables cluster community extraengine max-idx-128 (multilib) pbxt perl ssl -debug -embedded -latin1 -libevent -minimal -profiling (-selinux) -static -test"
CFLAGS="-Os -pipe -fomit-frame-pointer -march=barcelona -DHAVE_ERRNO_AS_DEFINE=1 -fno-strict-aliasing"
CXXFLAGS="-Os -pipe -fomit-frame-pointer -march=barcelona -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions -fno-strict-aliasing -felide-constructors -fno-rtti -fno-implicit-templates -fno-strict-aliasing"
Comment 1 Curtis Maurand 2010-08-18 20:43:31 UTC
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.
100818 16:39:13 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem.
100818 16:39:14 [Warning] Could not remove temporary table: '/tmp/#sql3704_1_0', error: 2
ERROR: 1  Can't create/write to file '/var/lib/mysql/p/#sql3704_1_0.MYI' (Errcode: 2)
100818 16:39:14 [ERROR] Aborting

100818 16:39:14 [Note] /usr/sbin/mysqld: Shutdown complete

drwxrwxrwt 4 root root 1024 Aug 18 16:39 /tmp

Comment 2 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2010-10-06 20:36:46 UTC
Please test recompiled with USE=-max-idx-128.