MySQL Bugs: #71018: "general error": you must be kidding me

Bug #71018	"general error": you must be kidding me
Submitted:	26 Nov 2013 22:43	Modified:	27 Dec 2013 16:25
Reporter:	matteo sisti sette	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.6.12	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Sometimes queries trigger this error:
"General error."

How to repeat:
-

Suggested fix:
"General error" is not an acceptable error message. This should not exist. The error message must ALWAYS give meaningful information about what the error is.

Where are you getting this message from? (Application and/or Connector used)

This message text doesn't appear anywhere in the server code or the other files in the server source tarball at all. The closest match would be this line:

  ./sql/sql_state.c:  return "HY000";		/* General error */

But then again it is just a comment there, and the "HY000" is just an error class that is just printed as a prefix to the actual, more descriptive, error message for the actual error at hand.

I also think this must be a client error.  So what is the client you are using?

Peter
(not a MySQL/Oracle person)

PHP/PDO.

The string "HY000" (only, without any other error number) was also present in the error message (sorry I don't have the script that reproduces it any more so I can't copy&past now).

Is it possible that the server is returning a generic HY000 error code?

This happened when executing a query with more than one statements, such as:
"CREATE TEMPORARY TABLE foo (bla bla bla); INSERT INTO foo bla bla la; SELECT bla bla bla"

Looks Hartmut is right, please check with PHP/PDO forums (doing a search there
are several results with PHP with General Error issue). Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".