MySQL Bugs: #20385: MySQL Administrator crashes when click User Administration

Bug #20385	MySQL Administrator crashes when click User Administration
Submitted:	12 Jun 2006 1:54	Modified:	26 Jul 2006 18:52
Reporter:	Ygor Lemos	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.1.10	OS:	Linux (Linux 2.6.15.4)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	User Management

Description:
Server running: MySQL 5.0.21
Client running: MySQL Client Version 5.0.21

Tested on the same machine on debian Sarge.

When you click on the User Administration the program gets everything "disabled" and hangs forever (displaying "Retrieving data from MySQL" on the statusbar).

Also I notice that when the program hangs, all GTK applications running on machine gets hanged too until I kill mysql-admin process.

How to repeat:
Just logon to server and click on User Administration.

Hi Ygor. Thanks for your problem report.
I was unable to verify:
  MySQL Administrator 1.1.10
  Suse 10.0, GLIBC 2.3.5 compiled on Linux 2.6.12 (Suse)
  MySQL 5.0.23-debug, bk build
Maybe it's Debian specific? Can you try on other platform and get back to me with results?

I will test on Gentoo 2006.0 and Zenwalk 2.6 and postback the results.

Tkz

Ygor Lemos

Adding my $0.02
Same problem Ubuntu 6.06 (also debian based)
MySQL Server: MySQL 5.0.22-Debian_0ubuntu6.06
Client: MySQL Client Version 5.0.19 (under help->about says vers. 1.1.6

I'll see if I can get one up before the weekend on RHEL and/or FreeBSD

I'm seeing this on Fedora Core 5 as well.
My CPU is a 64 bit Intel.

Running it on the localhost seems to work okay.

I can use the mysql shell on the FC5 box to talk to the database machine just fine.

Hi and thank you all for your input!
I was able to verify described problem on my FC5 x64 AMD with latest version of MySQL Administrator downloaded from URL:http://gd.tuwien.ac.at/db/mysql/Downloads/MySQLAdministrationSuite/mysql-administrator-1.1...
I am also unable to browse user information on localhost (FC5).

Environment:
MySQL Administrator 1.1.10-1 from URL mentioned above on FC5 x64 AMD (details below)
Various MySQL servers, 4.1 and 5.0 BK, on WinXP SP2 and Suse 10.0
MySQL server 5.0.23 on localhost

Findings: 
On FC5 x64 clicking User Administration causes MySQL Administrator to hang no matter where the server is. I was able to produce just one crash. Details might be helpful:
[root@FC5X64 ~]# /usr/bin/mysql-administrator
** (mysql-administrator-bin:426): CRITICAL **: file MGFileBrowserList.cc: line 135 (void MGFileBrowserList::get_row_object(const Gtk::TreeIter&, std::string&)): assertion `iter' failed
[root@FC5X64 ~]#
I was unable to repeat the error with same Administrator version on Suse 10.0 and on WinXP SP2

[root@FC5X64 mysql]# bin/mysqld_safe --no-defaults --port=3307
Starting mysqld daemon with databases from /var/lib/mysql/var
STOPPING server from pid file /var/lib/mysql/var/FC5X64.pid
060630 09:34:57  mysqld ended

[root@FC5X64 mysql]# bin/mysql -uroot --port=3307
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.23

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.0.23    |
+-----------+
1 row in set (0.00 sec)

mysql> quit
Bye
[root@FC5X64 mysql]# bin/mysqladmin -uroot --port=3307 shutdown

[root@FC5X64 ~]# uname --all
Linux FC5X64 2.6.16-1.2111_FC5 #1 SMP Thu May 4 21:16:04 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux
[root@FC5X64 ~]# /lib/libc.so.6
GNU C Library development release version 2.4, by Roland McGrath et al.
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
Compiled by GNU CC version 4.1.0 20060304 (Red Hat 4.1.0-2).
Compiled on a Linux 2.6.9 system on 2006-03-07.
Available extensions:
        The C stubs add-on version 2.1.2.
        crypt add-on version 2.1 by Michael Glad and others
        GNU Libidn by Simon Josefsson
        GNU libio by Per Bothner
        NIS(YP)/NIS+ NSS modules 0.19 by Thorsten Kukuk
        Native POSIX Threads Library by Ulrich Drepper et al
        BIND-8.2.3-T5B
Thread-local storage support included.
For bug reporting instructions, please see:
<http://www.gnu.org/software/libc/bugs.html>.
[root@FC5X64 ~]#

I got this bug too  on fresh Archlinux 0.7.2, native kernel 2.6.17-ARCH,
just installed mysql and mysql-admin withot any changes on user accounts.

This is a duplicate of #17879

I was able to repeat this and fixed it on Ubuntu dapper on a dual core athlon64, with gtk 2.8.18. I'm not able to repeat it anymore after the fix.