MySQL Bugs: #16019: Administrator Fails and Locks up randomly

Bug #16019	Administrator Fails and Locks up randomly
Submitted:	27 Dec 2005 15:46	Modified:	16 Jan 2006 12:35
Reporter:	[ name withheld ]	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.1.5	OS:	Linux (FC4)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:

I'm running fedora core 4 with MySQL 5.0.17-standard.  The Administrator randomly locks up.  If I want to adjust a user's setting I have to delete the user and add them back.  I prevents any changes after a user has been saved.

Administrator fails when I attempt to edit or delete a stored procedure... might be related to the problem above.

How to repeat:

Bring up the administrator as root.  Click on user administration and attempt to edit any user.  When saving you'll get an error stating a duplicate record exists.

Attempt to edit a stored procedure and the entire application fails.

It seems there's been a few files changed with the new version of MySQL Server and that's not been carried through with this version administrator.  I've noticed that updates I'd saved have not updated the files under the MySQL Database being the user and proc_priv tables.

I was unable to repeat running Administrator on FC4 against the server
5.0.19 built from source. Could you please start the server with the
log query option: --log for to verify where it failed.

Thanks

Hi Miguel,

Ok.... but got to say what a pain in the butt !  The log file refused to work at first because the server configuration wanted it in the /var/log/mysql which didn't exist so I manually set it up.

When I stopped/restarted the server nothing and went back into the administrator and locked up nothing showed in the log file but in the terminal window I did get an errors of some sort.

(mysql-administrator-bin:3751): Gtk-CRITICAL **; gtk_range_set_range: assertion 'min < max' failed when I looked at the error logs

MySQL Error No: 1054 Unknown column 'Create_view_priv' in field list when I attempted to edit or view a user... this didn't lock me up but gave an error dialog from within the administrator and if I attempted to remove the user the app croaks and I get 3823 Segmentation fault

Query browser still unusable it gives a 3885 Segmentation fault on everything.

Hope this helps... you got me what's wrong ?

Nothing shows in the error log.

I think I've got a fix on part of the problem.

I added the following columns as ENUM types to the DB & User tables in the MySQL database and now I'm able to edit & update users and the administrator doesn't appear to lock up anymore.

Create_view_priv
Show_view_priv
Create_routine_priv
Alter_routine_priv

Unfortunately the Query browser still continually failes and is still unusable.

Hi Miguel,

I've downloaded and administrator 1.1.6 and so far all seems fine except for backup... it still fails continually with the ansi quotes error.

You guys might pass a word on to Red Hat that the administrator update wipes out MySQL 5 and replaces it with version 4 and gives you no options on avoiding that.

Thanks,

Don

Thank you for the feedback. I am closing this bug since the ansi quote issue
is already reported: http://bugs.mysql.com/bug.php?id=16347