Bug #26816 MySQL Administrator crashes when creating or dropping a schema
Submitted: 3 Mar 2007 4:50 Modified: 12 Mar 2007 13:09
Reporter: Robert Sinton Email Updates:
Status: Closed Impact on me:
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.2.10ga OS:MacOS (OS X 10.4.8)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[3 Mar 2007 4:50] Robert Sinton
When adding a new schema or dropping an existing one, the progress dialog displays for about 3 seconds, then the application crashes.

The creation or deletion operation does not succeed.
New databases can be created and existing ones dropped using the command line tool without problem.
In existing databases, new tables can be created and existing ones dropped using MySQL Administrator without problem.

Occured consistently on a G4 eMac, OS X 10.4.8 with all updates, clean install of MySQL 5.0.27 standard. Also reproduced on a G5 iMac, OS X 10.4.8.

From the crash report:

Thread: 2
Exception:  EXC_BAD_ACCESS (0x0001)
Codes:      KERN_INVALID_ADDRESS (0x0001) at 0xffffffff
Thread 2 Crashed:
0   com.mysql.MySQLToolsCommon 	0x1006b054 myx_query_execute_direct + 92 (icplusplus.c:28)
1   com.mysql.MySQLToolsCommon 	0x1000f070 -[CallbackRequest execute:] + 240 (icplusplus.c:28)
2   com.mysql.MySQLToolsCommon 	0x1000f1c8 -[WaitCallbackRequest execute:] + 116 (icplusplus.c:28)
3   com.mysql.MySQLToolsCommon 	0x1000f408 -[MMySQLDispatcher(Private) executeRequest:] + 116 (icplusplus.c:28)
4   com.mysql.MySQLToolsCommon 	0x1000f90c processRequests + 100 (icplusplus.c:28)
5   libSystem.B.dylib          	0x9002b508 _pthread_body + 96

How to repeat:
- Launch, connect, click "Schema" icon
- Click "+" button
- Enter name for new schema
- Wait a few seconds

- Launch, connect, click "Schema" icon
- Select a schema and click "-" button
- Confirm when prompted
- Wait a few seconds
[3 Mar 2007 4:52] Robert Sinton
Sorry, obviously that should be: Launch, connect, click "Catalogs" icon.
[5 Mar 2007 10:14] Sveta Smirnova
Thank you for the report.

Verified as described.
[7 Mar 2007 5:39] Valeriy Kravchuk
Bug #26896 is a duplicate of this one.
[12 Mar 2007 13:09] Vladimir Kolesnikov
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

[18 Mar 2007 14:52] Jonathon Popphan
I have experienced the same problem with MySQL Administrator.  I discovered an alternative software solution that works, however.  It is called YourSQL and is freely available for download from www.yoursql.com.  YourSQL will assist with creating and deleting schema, as well as providing an easy to use query feature as well as the ability to view the raw data in each table.  However there is no functionality for creating backups of databases or restoring databases.  The MySQL Administrator does work on OSX 10.4.8 for backup and restore, so I guess that some of us will need to use both for a while until the bug in MySQL Administrator is fixed.

I am not associated with YourSQL, by the way.  I just found it and it works, so wanted to share my solution with others.

Jonathon Popphan
Atlanta, GA USA
[20 Mar 2007 17:43] Sveta Smirnova
Bug #27273 was marked as duplicate of this one
[22 Mar 2007 17:37] Sveta Smirnova
Bug #27377 was marked as duplicate of this one.
[22 Mar 2007 17:43] blake miller
There doesn't seem to be a project in the repository for the Administrator.
[28 Mar 2007 8:42] Sveta Smirnova
Bug #27450 was marked as duplicate of this one