Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 537160 - emerge --config dev-db/mysql-5.6.22 tries to use / as tmpdir and fails with perm denied
Summary: emerge --config dev-db/mysql-5.6.22 tries to use / as tmpdir and fails with p...
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: [OLD] Unspecified (show other bugs)
Hardware: AMD64 Linux
: Normal normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-20 19:03 UTC by Andrey Utkin
Modified: 2015-01-21 14:07 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 Andrey Utkin 2015-01-20 19:03:16 UTC
# emerge --config =dev-db/mysql-5.6.22


Configuring pkg...

 * Please provide a password for the mysql 'root' user now
 * or through the /root/.my.cnf file.
 * Avoid ["'\_%] characters in the password
    >
 * Retype the password
    >
 * Creating the mysql database and setting proper
 * permissions on it ...
 * Command: '/usr/share/mysql/scripts/mysql_install_db' '--basedir=/usr'  --loose-skip-grant-tables --loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start --loose-skip-ssl --loose-skip-log-bin --loose-skip-relay-log --loose-skip-slow-query-log --loose-skip-external-locking --loose-skip-log-slave-updates --user=mysql '--datadir=///var/lib/mysql' '--tmpdir=//'
2015-01-20 20:55:50 25202 [Note] InnoDB: Memory barrier is not used
2015-01-20 20:55:50 25202 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-01-20 20:55:50 25202 [Note] InnoDB: Using Linux native AIO
2015-01-20 20:55:50 25202 [Note] InnoDB: Using CPU crc32 instructions
/usr/sbin/mysqld: Can't create/write to file '/ibI8acOQ' (Errcode: 13 - Permission denied)
2015-01-20 20:55:50 7f4dd605f740  InnoDB: Error: unable to create temporary file; errno: 13
2015-01-20 20:55:50 25202 [ERROR] Plugin 'InnoDB' init function returned error.
2015-01-20 20:55:50 25202 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-01-20 20:55:50 25202 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-01-20 20:55:50 25202 [ERROR] Aborting

2015-01-20 20:55:50 25202 [Note] Binlog end
2015-01-20 20:55:50 25202 [Note] /usr/sbin/mysqld: Shutdown complete

 * ERROR: dev-db/mysql-5.6.22::gentoo failed (config phase):
 *   Failed to run mysql_install_db. Please review /var/log/mysql/mysqld.err AND /var/tmp/portage/dev-db/mysql-5.6.22/temp/mysql_install_db.log
 * 
 * Call stack:
 *     ebuild.sh, line   93:  Called pkg_config
 *   environment, line 4424:  Called mysql-multilib_pkg_config
 *   environment, line 4048:  Called die
 * The specific snippet of code:
 *           die "Failed to run mysql_install_db. Please review ${EPREFIX}/var/log/mysql/mysqld.err AND ${TMPDIR}/mysql_install_db.log";
 * 
 * If you need support, post the output of `emerge --info '=dev-db/mysql-5.6.22::gentoo'`,
 * the complete build log and the output of `emerge -pqv '=dev-db/mysql-5.6.22::gentoo'`.
 * The complete build log is located at '/var/tmp/portage/dev-db/mysql-5.6.22/temp/build.log'.
 * The ebuild environment file is located at '/var/tmp/portage/dev-db/mysql-5.6.22/temp/environment'.
 * Working directory: '/var/tmp/portage/dev-db/mysql-5.6.22/temp'
 * S: '/var/tmp/portage/dev-db/mysql-5.6.22/work/mysql-5.6.22'



 # emerge --info
Portage 2.2.15 (python 2.7.8-final-0, default/linux/amd64/13.0/desktop, gcc-4.8.3, glibc-2.20, 3.19.0-rc2-next-20150105-zver-00001-ga248787 x86_64)
=================================================================
System uname: Linux-3.19.0-rc2-next-20150105-zver-00001-ga248787-x86_64-Intel-R-_Core-TM-_i5-3450_CPU_@_3.10GHz-with-gentoo-2.2
KiB Mem:     8017136 total,    504128 free
KiB Swap:    9767516 total,   9738772 free
Timestamp of tree: Tue, 20 Jan 2015 18:00:01 +0000
sh bash 4.3_p30-r1
ld GNU ld (Gentoo 2.24 p1.4) 2.24
ccache version 3.2 [disabled]
app-shells/bash:          4.3_p30-r1
dev-java/java-config:     2.2.0
dev-lang/perl:            5.20.1-r3
dev-lang/python:          2.7.8, 3.3.5-r1, 3.4.2
dev-util/ccache:          3.2
dev-util/cmake:           3.0.2
dev-util/pkgconfig:       0.28-r2
sys-apps/baselayout:      2.2
sys-apps/openrc:          0.13.6
sys-apps/sandbox:         2.6-r1
sys-devel/autoconf:       2.13, 2.69
sys-devel/automake:       1.11.6, 1.13.4, 1.14.1
sys-devel/binutils:       2.24-r3
sys-devel/gcc:            4.8.3
sys-devel/gcc-config:     1.8
sys-devel/libtool:        2.4.3-r2
sys-devel/make:           4.1-r1
sys-kernel/linux-headers: 3.17-r1 (virtual/os-headers)
sys-libs/glibc:           2.20
Repositories: gentoo zugaina tox-overlay steam-overlay prism-overlay sunrise
ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="* -@EULA"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -pipe -march=core2 -mtune=generic"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/config /usr/share/gnupg/qualified.txt /usr/share/maven-bin-3.0/conf /usr/share/maven-bin-3.2/conf /var/lib/hsqldb"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5.5/ext-active/ /etc/php/apache2-php5.6/ext-active/ /etc/php/cgi-php5.5/ext-active/ /etc/php/cgi-php5.6/ext-active/ /etc/php/cli-php5.5/ext-active/ /etc/php/cli-php5.6/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo"
CXXFLAGS="-O2 -pipe -march=core2 -mtune=generic"
DISTDIR="/usr/portage/distfiles"
FCFLAGS="-O2 -pipe"
FEATURES="assume-digests binpkg-logs config-protect-if-modified distlocks ebuild-locks fixlafiles merge-sync news parallel-fetch preserve-libs protect-owned sandbox sfperms splitdebug strict unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync"
FFLAGS="-O2 -pipe"
GENTOO_MIRRORS="http://distfiles.gentoo.org"
LANG="ru_RU.UTF-8"
LC_ALL="ru_RU.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
MAKEOPTS="-j5"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --omit-dir-times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/var/lib/layman/zugaina /var/lib/layman/tox-overlay /var/lib/layman/steam-overlay /var/lib/layman/prism-overlay /var/lib/layman/sunrise"
USE="X a52 aac acl acpi alsa amd64 bash-completion berkdb branding bzip2 cairo cdda cdr cli consolekit cracklib crypt cups cxx dbus dri dts dvd dvdr emboss encode exif firefox flac fortran freetype gdbm gif glamor gtk iconv imlib ipv6 jpeg lcms libnotify logrotate mad mmx mng modules mp3 mp4 mpeg multilib ncurses nls nptl ogg opengl openmp pam pango pcre pdf png policykit ppds python qt3support qt4 readline sdl session sse sse2 sse3 ssl ssse3 startup-notification svg threads tiff truetype type1 udev udisks unicode upower usb vorbis wxwidgets x264 xcb xml xv xvid zlib" ABI_X86="64" 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" APACHE2_MODULES="authn_core authz_core socache_shmcb unixd 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" CALLIGRA_FEATURES="kexi words flow plan sheets stage tables krita karbon braindump author" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ublox ubx" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="php5-5" PYTHON_SINGLE_TARGET="python2_7" PYTHON_TARGETS="python2_7 python3_3" QEMU_SOFTMMU_TARGETS="x86_64 arm" QEMU_USER_TARGETS="x86_64 arm" RUBY_TARGETS="ruby19 ruby20 ruby21" USERLAND="GNU" VIDEO_CARDS="intel" 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, INSTALL_MASK, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, SYNC, USE_PYTHON


Reproducible: Always
Comment 1 Mr. Bones. (RETIRED) gentoo-dev 2015-01-20 19:17:07 UTC
mysql: worst game ever
Comment 2 Brian Evans (RETIRED) gentoo-dev 2015-01-20 19:35:48 UTC
I suspect a configuration problem with your my.cnf.

The tmpdir is determined from your my.cnf using this command:

`/usr/bin/my_print_defaults mysqld | sed -n "/^--tmpdir=/s,--tmpdir=,,gp"`

This can also be shown by `/usr/bin/my_print_defaults mysqld | grep tmpdir`

Please let me know if you need more assistance or find me on freenode IRC
Comment 3 Andrey Utkin 2015-01-21 13:55:37 UTC
This was a reinstall from quickpkg after emerge -C. I've come around it by `chmod o+w /` temporarily.

It is possible that something got screwed in my process of reinstallation. Sorry but I have no time to investigate this issue, feel free to close this ticket.

> mysql: worst game ever

Would you advise MariaDB as a replacement? Is it really better than current MySQL?
Comment 4 Brian Evans (RETIRED) gentoo-dev 2015-01-21 14:07:45 UTC
(In reply to Andrey Utkin from comment #3)
> This was a reinstall from quickpkg after emerge -C. I've come around it by
> `chmod o+w /` temporarily.
> 
> It is possible that something got screwed in my process of reinstallation.
> Sorry but I have no time to investigate this issue, feel free to close this
> ticket.
> 
> > mysql: worst game ever
> 
> Would you advise MariaDB as a replacement? Is it really better than current
> MySQL?

The answer is probably very simple.. quickpkg does *not* include configs by default and can give you a blank file unless you add --include-config.