Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 145197 - dev-db/mysql-5.0.24-r1: eats 99% cpu when compiled with -Os with gcc-3.4
Summary: dev-db/mysql-5.0.24-r1: eats 99% cpu when compiled with -Os with gcc-3.4
Status: RESOLVED WONTFIX
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: [OLD] Server (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-08-26 11:19 UTC by Anton Kuzmin
Modified: 2006-10-12 16:00 UTC (History)
0 users

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


Attachments
strace output (strace.log,54.20 KB, text/x-log)
2006-08-26 11:46 UTC, Anton Kuzmin
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Anton Kuzmin 2006-08-26 11:19:36 UTC
After upgrading mysql falls into cpu hardly stopable loop... The idacity takes place just after mysql query from php script (through PDO_mysql driver).

When I have time I will try to give some more info.
Comment 1 Jakub Moc (RETIRED) gentoo-dev 2006-08-26 11:25:48 UTC
At least please post emerge --info and some strace or whatever to find out where is it stuck, we are lacking paranormal abilities.
Comment 2 Anton Kuzmin 2006-08-26 11:44:41 UTC
Portage 2.1.1_rc1 (default-linux/amd64/2006.0, gcc-3.4.6/amd64-vanilla, glibc-2.4-r3, 2.6.17-suspend2-r4 x86_64)
=================================================================
System uname: 2.6.17-suspend2-r4 x86_64 AMD Turion(tm) 64 Mobile Technology MT-32
Gentoo Base System version 1.12.4
Last Sync: Sat, 26 Aug 2006 15:00:01 +0000
app-admin/eselect-compiler: 2.0.0_rc2-r1
dev-lang/python:     2.4.3-r2
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     [Not Present]
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.18.1
sys-devel/autoconf:  2.13, 2.60
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.17
sys-devel/gcc-config: [Not Present]
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.16
ACCEPT_KEYWORDS="amd64 ~amd64"
AUTOCLEAN="yes"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-Os -march=athlon64 -msse3 -fomit-frame-pointer -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/eselect/compiler /etc/gconf /etc/java-config/vms/ /etc/terminfo /etc/texmf/web2c"
CXXFLAGS="-Os -march=athlon64 -msse3 -fomit-frame-pointer -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks metadata-transfer parallel-fetch sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LANG="en_US.UTF-8"
LINGUAS="ru"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="amd64 X a52 acpi alsa apache2 audiofile avi beagle bitmap-fonts bzip2 cairo cdr cli crypt dbus djvu dlloader doc dvd dvdr dvdread dvi elibc_glibc emboss encode fat ffmpeg firefox flac foomaticdb fuse gcc64 gif glibc-omitfp gnome gpm gstreamer gtk gtk2 hal howl imagemagick imlib immqt input_devices_evdev input_devices_keyboard input_devices_mouse isdnlog java jpeg kde kdehiddenvisibility kernel_linux libnotify linguas_ru lzw lzw-tiff mad mjpeg mono mp3 mpeg musicbrainz mysql nautilus ncurses nforce2 nls nptl ntfs nvidia ogg opengl pam pcre pdf pdflib pdo perl pmu png postgres pppd python qt3 qt4 quicktime readline reflection reiserfs sdl session sndfile spell spl sqlite ssl svg tagwriting tcpd theora tidy tiff truetype truetype-fonts type1-fonts unicode usb userland_GNU vcd video_cards_nv video_cards_nvidia video_cards_vesa video_cards_vmware vorbis xfs xine xorg xpm xv xvid zip zlib"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Comment 3 Anton Kuzmin 2006-08-26 11:44:48 UTC
Portage 2.1.1_rc1 (default-linux/amd64/2006.0, gcc-3.4.6/amd64-vanilla, glibc-2.4-r3, 2.6.17-suspend2-r4 x86_64)
=================================================================
System uname: 2.6.17-suspend2-r4 x86_64 AMD Turion(tm) 64 Mobile Technology MT-32
Gentoo Base System version 1.12.4
Last Sync: Sat, 26 Aug 2006 15:00:01 +0000
app-admin/eselect-compiler: 2.0.0_rc2-r1
dev-lang/python:     2.4.3-r2
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     [Not Present]
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.18.1
sys-devel/autoconf:  2.13, 2.60
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.17
sys-devel/gcc-config: [Not Present]
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.16
ACCEPT_KEYWORDS="amd64 ~amd64"
AUTOCLEAN="yes"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-Os -march=athlon64 -msse3 -fomit-frame-pointer -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/eselect/compiler /etc/gconf /etc/java-config/vms/ /etc/terminfo /etc/texmf/web2c"
CXXFLAGS="-Os -march=athlon64 -msse3 -fomit-frame-pointer -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks metadata-transfer parallel-fetch sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LANG="en_US.UTF-8"
LINGUAS="ru"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="amd64 X a52 acpi alsa apache2 audiofile avi beagle bitmap-fonts bzip2 cairo cdr cli crypt dbus djvu dlloader doc dvd dvdr dvdread dvi elibc_glibc emboss encode fat ffmpeg firefox flac foomaticdb fuse gcc64 gif glibc-omitfp gnome gpm gstreamer gtk gtk2 hal howl imagemagick imlib immqt input_devices_evdev input_devices_keyboard input_devices_mouse isdnlog java jpeg kde kdehiddenvisibility kernel_linux libnotify linguas_ru lzw lzw-tiff mad mjpeg mono mp3 mpeg musicbrainz mysql nautilus ncurses nforce2 nls nptl ntfs nvidia ogg opengl pam pcre pdf pdflib pdo perl pmu png postgres pppd python qt3 qt4 quicktime readline reflection reiserfs sdl session sndfile spell spl sqlite ssl svg tagwriting tcpd theora tidy tiff truetype truetype-fonts type1-fonts unicode usb userland_GNU vcd video_cards_nv video_cards_nvidia video_cards_vesa video_cards_vmware vorbis xfs xine xorg xpm xv xvid zip zlib"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Comment 4 Anton Kuzmin 2006-08-26 11:46:33 UTC
Created attachment 95151 [details]
strace output
Comment 5 Anton Kuzmin 2006-08-27 08:03:10 UTC
Works fine after recompiling with -O2 instead of -Os
Comment 6 Anton Kuzmin 2006-09-02 07:06:38 UTC
>Works fine after recompiling with -O2 instead of -Os

I confirm! I compiled 5.0.24-r1 with -Os and again I have my system locked! Will try on gcc-4.4.1
Comment 7 Anton Kuzmin 2006-09-02 07:26:38 UTC
Yup! It seems everything is fine with mysql compiled with -Os flag on gcc-4.4.1 Are you going to handle it?
Comment 8 Luca Longinotti (RETIRED) gentoo-dev 2006-10-12 12:42:36 UTC
Ok, first -Os isn't really supported afaik as official CFLAG by us, and since you confirmed it works on GCC 4.1.X, which is the currently _stable_ GCC, I'd say we can close this and leave it as is.
Best regards, CHTEKK.
Comment 9 Anton Kuzmin 2006-10-12 16:00:23 UTC
You can filter -Os out at least in ebuild