Bugzilla Bug 170943

After installing mysql-gui-tools-5.0_p10-r1, mysql-query-browser no longer
works. It brings up the login window, I provide the information, the login
window disappears after a successful authentication, and then nothing else
happens, except that one of my CPUs is pegged at 100% by
mysql-query-browser-bin.

I have straced the execution, and it appears to be just sitting, looping on a
read from a file descriptor, which I believe to be a socket, but no data is
available from the fd.

I am running ~amd64. mysql-gui-tools was built as follows:

[ebuild   R   ] dev-db/mysql-gui-tools-5.0_p10-r1  USE="administrator nls
query-browser workbench" 0 kB

Thanks-

James

Reproducible: Always

Steps to Reproduce:
1. emerge mysql-gui-tools-5.0_p10-r1
2. run mysql-query-browser
3. login




emerge --info:

Portage 2.1.2.2 (default-linux/amd64/2006.1, gcc-4.1.2, glibc-2.5-r0,
2.6.18-gentoo-r1 x86_64)
=================================================================
System uname: 2.6.18-gentoo-r1 x86_64 AMD Athlon(tm) 64 X2 Dual Core Processor
4400+
Gentoo Base System version 1.12.9
Timestamp of tree: Wed, 14 Mar 2007 17:30:01 +0000
dev-java/java-config: 1.3.7, 2.0.31-r4
dev-lang/python:     2.4.4
dev-python/pycrypto: 2.0.1-r5
sys-apps/sandbox:    1.2.18.1
sys-devel/autoconf:  2.13, 2.61
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
sys-devel/binutils:  2.17
sys-devel/gcc-config: 1.3.15
sys-devel/libtool:   1.5.23b
virtual/os-headers:  2.6.20-r1
ACCEPT_KEYWORDS="amd64 ~amd64"
AUTOCLEAN="yes"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=athlon64 -O2 -pipe -funroll-loops -msse3"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /opt/openjms/config /usr/kde/3.5/env
/usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/lib/fax /usr/share/X11/xkb
/usr/share/config /var/spool/fax/etc"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf
/etc/java-config/vms/ /etc/php/apache1-php5/ext-active/
/etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/
/etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo
/etc/texmf/web2c"
CXXFLAGS="-march=athlon64 -O2 -pipe -funroll-loops -msse3"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="http://gentoo.osuosl.org http://distfiles.gentoo.org
http://www.ibiblio.org/pub/Linux/distributions/gentoo"
LINGUAS="en en_US"
MAKEOPTS="-j3"
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
--filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="16bit-indices 3ds 64bit 7zip X X509 Xaw3d a52 aac aalib accessibility acct
acl acpi ada addbookmarks administrator aiglx aio akode alias allegro alsa
altenburgcards amarok amd64 amr animgif ansi ao aoss apache2 arj artworkextra
asf async auctex audiofile automount autoreplace avahi avalon-framework
avalon-logkit badval bash-completion battery bcmath bcp beagle berkdb bidi
binfilter bitmap-fonts bittorrent bjam blas boo bookmarks boost branding bzip2
c3p0 cairo cal3d calendar caps cdaudio cdb cddb cdinstall cdparanoia cdr cegui
cg chipcard chm chroot cjk clearcase cli clisp connectionstatus contactnotes
contrib cpudetection cracklib crypt cscope css ctype cups curl curlwrappers
custom-cflags cvs d daap dbus dcraw demo deprecated devhelp device-mapper devil
dga directfb discouraged diskio divx djvu dmi doc dom4j double-precision dri
dtaus dts dv dvb dvd dvdr dvdread dvi editor eds elf elisp enca enchant encode
epydoc evo examples exif expat extraengine extrafilters fam fame fastbuild fat
fbcon ffmpeg fftw fidonet filter firefox fits flac flatfile fmod fontconfig
foomaticdb fortran fping fpx freetds frontendonly ftp fuse gadu galago gcj gcl
gd gdbm gdl gedit geldkarte geoip geos ggi gif gimp ginac glade glib glitz glut
glw gmath gmedia gml gmp gnet gnokii gnome gnutls gphoto2 gpm gps grace
graphviz groupwise gs gsl gsm gstreamer gtk gtk2 gtkhtml gtp guile hacking hal
hardware-carrier hash haskell hbci hdf hdf5 hfs highlight hipe history hlapi
hpn html ical iconv idl idn ieee1394 ifp ilbc imagemagick imap imlib
inherit-graph inifile insecure-savers intl ipod ipv6 irc irda isdnlog ithreads
itrax jack jai java java5 javamail javascript jbig jce jfs jikes jingle jms jmx
jni jpeg jpeg2k json jython kcal kde kdecards kdeenablefinal
kdehiddenvisibility kerberos keyring kig-scripting kmid kpoll kqemu ladspa lame
lapack largefile latex lcms ldap ldap-sasl ldb lesstif lha libburn libcaca
libedit libg++ libnotify libsexy libwww lirc live lm_sensors log4j
logitech-mouse logrotate lua lucene lzo mad matroska mdb memlimit metalink
mgetty mhash midi mikmod mime ming mixer mjpeg mmap mng modplug module mono
mopac7 motif mozbranding mozdevelop moznopango mp3 mp3rtp mpeg mpi mplayer
mpm-threadpool mpqc mssql mtp muine musepack music musicbrainz mysql nas
ncurses net netbeans netboot netcdf netjack netmeeting network networking
new-clx new-login nextaw nfs nis njb nls nntp nowlistening nptl nptlonly
nsplugin ntfs ntp numarray numeric oav objc objc++ objc-gc ocaml oci8 odbc ode
odk offensive ofx ogdi ogg ole openal openbabel openexr opengl oracle oss pam
pam_chroot pam_console pam_timestamp pango pascal pcmcia pcntl pcre pda pdf pdo
perforce perl php physfs pike plotutils plugins png portaudio posix postgres
povray ppds pppd preview-latex pwdb pysolcards pyste python qdbm qhull qt3
qt3support qt4 query-browser quicktime quotas quotes rar rdesktop readline real
realmedia recode reflection regex reiser4 reiserfs remix rhino rle root rpm
rt2500pci rtc ruby samba sametime sasl sbcl scanner scenarios script sdl
sensord serial serpentine server servletapi session sftp sharedext sharedmem
simplexml skey slang slp smp sms sndfile snmp soap sockets socks5 sound sounds
source sourceview sox speex spell spl sql sqlite sqlite3 srt ssl
startup-notification staticsocket statistics streamripper subtitles subversion
svg swat sysfs syslog sysvipc szip t1lib tcl tcltk tcpd tetex texteffect tga
themes theora threads tidy tiff timidity tk tntc tokenizer toolbar tordns totem
translator transmitter truetype truetype-fonts tse3 type1-fonts unicode urandom
usb utempter v4l v4l2 valgrind vcd vga vim vim-pager vim-syntax vim-with-x
visualization voice vorbis wavpack wddx webdav webpresence wifi winbind
winpopup wireshark wlan wmf wmp workbench wxgtk1 wxwindows x264 xanim xbase xcb
xcomposite xerces-c xext xforms xfs xine xinerama xml xmldoclet xmlreader
xmlrpc xmlwriter xorg xpm xprint xscreensaver xskatcards xsl xtended xv xvid
xvmc yahoo yaz yv12 zeroconf zip zippy zlib zrtp zvbi" 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 mulaw multi
null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="synaptics
evdev mouse keyboard wacom" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633
glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en en_US"
LIRC_DEVICES="serial" USERLAND="GNU" VIDEO_CARDS="nvidia nv"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

Maybe if you could attach the strace or whatever here? Pretty hard to guess.

Created an attachment (id=113310) [details]
mysql-query-browser_strace.txt.bz2

Here you go.

Also, the first time I ran mysql-query-browser with the strace, it worked - I
got into the actual application window. I closed it, and it has failed every
time since, so there appears to be some kind of race condition that
mysql-query-browser *almost* always seems to lose.

Reopen.

An strace doesn't help much as it catches only system calls. Try using gdb to
produce a proper backtrace, so that we can see in which part it hangs. Also
providing some information on the socket that it is reading from might be
helpful.

i have the same problem

after rm -rf ~/.mysqlgui for cleaning all settings what can stuck the program
when i leave the "Default Schema" blank on the login window, the main appeared,
but it will freeze if i select any databases(schemas) on the right pannel, and
cpu will be 100% used.
if i fill the "Default Schema", the main window can't be appeared, and cpu 100%
used like above.

server: 5.0.32-7etch1 on Debian 4.0r1
client: dev-db/mysql-gui-tools-5.0_p12-r1

Created an attachment (id=136595) [details]
Patch to fix mysql-query-browser freeze when using stored procedures

It's an old bug, it happens if you're using stored procedures. Upon selecting
default schema or selecting one from within mysql-query-browser it just freezes
at 100% cpu usage.

Whole discussion can be read here: http://bugs.mysql.com/bug.php?id=30055

The patch is not mine, it's a copy from the above link and it works for me.