mysqld crashes. It's a Gentoo specific bug because the table INNODB_BUFFER_POOL_CONTENT does not exist in original mysql. See http://bugs.mysql.com/bug.php?id=48203 Reproducible: Always Steps to Reproduce: 1. activate skip-innodb in my.cnf 2. start mysqld 3. do the query SELECT COUNT(*) FROM `information_schema`.`INNODB_BUFFER_POOL_CONTENT`; Actual Results: crash Expected Results: Error message
1. emerge --info 2. you didn't specify what version you were testing 3. please test against 5.0.90 If not, please examine innodb_show_bp.patch that introduced that functionality.
Re-assigning to mysql-bugs first
mysql --version mysql Ver 14.12 Distrib 5.0.90, for pc-linux-gnu (x86_64) using readline 6.1 # emerge --info mysql Portage 2.1.8.3 (default/linux/amd64/10.0, gcc-4.3.4, glibc-2.10.1-r1, 2.6.32-gentoo-r7 x86_64) ================================================================= System Settings ================================================================= System uname: Linux-2.6.32-gentoo-r7-x86_64-Intel-R-_Xeon-TM-_CPU_3.20GHz-with-gentoo-1.12.13 Timestamp of tree: Wed, 05 May 2010 00:45:01 +0000 app-shells/bash: 4.0_p37 dev-lang/python: 2.6.4-r1 sys-apps/baselayout: 1.12.13 sys-apps/sandbox: 1.6-r2 sys-devel/autoconf: 2.63-r1 sys-devel/automake: 1.10.3, 1.11.1 sys-devel/binutils: 2.18-r3 sys-devel/gcc: 4.3.4 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="*" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -march=native -pipe" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/gconf /etc/sandbox.d /etc/terminfo" CXXFLAGS="-O2 -march=native -pipe" 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://linux.rz.ruhr-uni-bochum.de/download/gentoo-mirror http://ftp.uni-erlangen.de/pub/mirrors/gentoo " LDFLAGS="-Wl,-O1" LINGUAS="de en" MAKEOPTS="-j5" 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://[masked]/gentoo-portage" USE="acl amd64 apache2 berkdb bzip2 cli cracklib crypt cups cxx domxml dri fortran gdbm gif gpm iconv idn innodb ipv6 jpeg jpg mmx modules mudflap multilib mysql ncurses nls nptl nptlonly openmp pam pcre perl png pppd python readline reflection session spl sse sse2 ssl suexec sysfs tcpd truetype unicode vim-syntax xml xml2 xorg 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_anon authn_dbd authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock dbd deflate dir disk_cache env expires ext_filter file_cache filter headers ident imagemap include info log_config logio mem_cache mime mime_magic negotiation proxy proxy_ajp proxy_balancer proxy_connect proxy_http rewrite setenvif so speling status unique_id userdir usertrack vhost_alias" APACHE2_MPMS="prefork" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="de en" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="fbdev glint intel mach64 mga neomagic nv r128 radeon savage sis tdfx trident vesa via vmware voodoo" 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, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY ================================================================= Package Settings ================================================================= dev-db/mysql-5.0.90-r2 was built with the following: USE="berkdb community latin1 (multilib) perl ssl -big-tables -cluster -debug -embedded -extraengine -max-idx-128 -minimal -profiling (-selinux) -static -test" CFLAGS="-O2 -march=native -pipe -DHAVE_ERRNO_AS_DEFINE=1 -fno-strict-aliasing" CXXFLAGS="-O2 -march=native -pipe -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions -fno-strict-aliasing -felide-constructors -fno-rtti -fno-implicit-templates -fno-strict-aliasing"
Fix committed to mysql-extras repo. Will be deployed in 5.0.91. It's not Gentoo-specific however, it bites everybody that is using the Percona patchset.
Fixed in 5.0.91.