Bug #62476 Error: SQL logic error or missing database
Submitted: 19 Sep 2011 16:44 Modified: 21 Sep 2011 22:35
Reporter: Marc Guyer Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.34 OS:MacOS (10.6.8)
Assigned to: CPU Architecture:Any

[19 Sep 2011 16:44] Marc Guyer 
Description:
Unexpected error: "Error: SQL logic error or missing database" when working in SQL Editor.  Occasionally upon executing a query the error is encountered.  When this error is encountered, attempting to open a new query tab either fails silently or crashes WB altogether.  Attempting to open a connection to another db server results in a connection failure with the same error: "SQL logic error or missing database".

Often when an existing SQL Editor tab is open and I attempt to open a new SQL Editor tab connected to another db (different host, too), the same error occurs.

How to repeat:
I have not been able to establish a reliable progression to repeat.  However it is fairly consistent.  I suspect it is related to my setup.  I exclusively connect to my dbs via TCP/IP over SSH.  This is very cool functionality btw as it eliminates the need to maintain my own tunnels.  

Wish I could help more with steps...
[19 Sep 2011 17:19] Marc Guyer 
Forgot to mention that I get this behavior on two different machines with basically the same setup.
[19 Sep 2011 17:52] Valeriy Kravchuk 
Any ideas on what kind of queries lead to this error are welcomed. I also wonder what server versions, x.y.z, are you working with.
[19 Sep 2011 20:20] Marc Guyer 
I've been having this problem for quite a while and no particular queries seem to cause it.  The server version is 5.1.41 in every case.
[20 Sep 2011 9:40] MySQL Verification Team 
What OS is running the MySQL server which are you connecting? Thanks in advance.
[20 Sep 2011 17:18] Marc Guyer 
Ubuntu 10.04.3 LTS

Linux cgdev 2.6.35.1-rscloud #4 SMP Wed Aug 11 15:44:25 UTC 2010 x86_64 GNU/Linux
[21 Sep 2011 22:35] Alfredo Kojima 
This is a duplicate of bug #59520
[22 Sep 2011 16:10] Matt Frankland 
I have this same error when connecting over SSH tunnel. Client is 5.2.34 for OSX 10.6.7, connecting to server version 5.0.89.

Connection will work when initialized, but queries start to fail after 45minutes to an hour. The connection never works for long. If I ask the client to reconnect, it will usually crash instead of clean exit.