MySQL Bugs: #62138: crash if table is empty or not existing

Bug #62138	crash if table is empty or not existing
Submitted:	10 Aug 2011 11:07	Modified:	26 Aug 2011 14:37
Reporter:	Thomas Willms	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.34	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	crash

Description:
crash if no table present in database

How to repeat:
take a directory of a database with frm files but without any other file in it and try to connect two times.

Please, give more details on what exactly to do (using mysql command line client, if possible) to get the crash. 

I have no problem after creating db directory with single (copied from MyISAM table in other database) tt.frm file inside:

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -uroot -proot db -P3310
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.1.56-community-log MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show tables;
+--------------+
| Tables_in_db |
+--------------+
| tt           |
+--------------+
1 row in set (0.00 sec)

mysql> select * from tt;
ERROR 1017 (HY000): Can't find file: 'tt' (errno: 2)

Hello Valeriy,

I start a mysqlserver instance and connect to it. The server instance has several databases which are based only on directories with one or more frm files copied from another installation (of which other data are lost or properly not well connected).
When I start workbench the databases are shown with their tables.
If you click on a table the there is written :

	
	Time	Action	Message	Duration / Fetch
0	1	14:35:08	select * from `tomcat2`.`personen`
LIMIT 0, 1000	Error Code: 1146. La table 'tomcat2.personen' n'existe pas	0.000 sec

So this is OK. One action more and afterwards I got the message indicating the problem and I was connected automatically to the bug page.

Before I had it several times. I just tried to reproduce it but there was no problem. In fact I am not sure what I did exactly.
Might this be due to the fact that I had no model before ?  This was the only thing I am aware that I changed it.

Anyway, I don't understand why there are no tables in my databases. I still have some files ibdata1 and model files, but I don't get everything connected in a way that table data reappear as it was before. There are only frm files in the directory, but I saved also the ib_data1 - file and the models somewhere.

If I can reproduce the problem once more I will try to pay attention to my further actions.

Thanks - I am impressed by the rapidity of the answer.

Thomas Willms

So, crash/error dialog box was in MySQL Workbench, not at server side. What exact Workbench version, 5.2.x, do you use?

The version is 5.2.34 CE

There is no newer one, is it?

Bye

Thomas Willms

Thanks a lot for your report Thomas.
Please feel free to re-open this defect if you ever find how to reproduce it.