MySQL Bugs: #26816: MySQL Administrator crashes when creating or dropping a schema

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:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.10ga	OS:	MacOS (OS X 10.4.8)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
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:
[Creating]
- Launch, connect, click "Schema" icon
- Click "+" button
- Enter name for new schema
- Wait a few seconds

[Dropping]
- Launch, connect, click "Schema" icon
- Select a schema and click "-" button
- Confirm when prompted
- Wait a few seconds

Sorry, obviously that should be: Launch, connect, click "Catalogs" icon.

Thank you for the report.

Verified as described.

Bug #26896 is a duplicate of this one.

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

    http://dev.mysql.com/doc/en/installing-source.html

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

Bug #27273 was marked as duplicate of this one

Bug #27377 was marked as duplicate of this one.

There doesn't seem to be a project in the repository for the Administrator.

Bug #27450 was marked as duplicate of this one