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 attachment 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 attachment 136595 [details, diff] 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.
This patch has been applied in mysql-gui-tools-5.0_p12-r2.
