Bug #50988 bugs.mysql.com dumps sql instead of printing a user-friendly message
Submitted: 8 Feb 2010 12:13 Modified: 18 May 2010 14:55
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Websites: bugs.mysql.com Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Ray Lambe CPU Architecture:Any

[8 Feb 2010 12:13] Shane Bester
Description:
Recently i noticed certain bugsdb queries are failing, and returning sql+error message instead of the proper results.  see screenshot for example.

I assume there is some long query killer that kills the query.

How to repeat:
the url i use to track all bugs is this:

http://tinyurl.com/yk99d6f

it will work most of the time, unless server is loaded and query gets killed.

Suggested fix:
don't dump sql in view of the public..  log the error on the server logs, and show a friendly, useful error message to the client.
[8 Feb 2010 12:14] MySQL Verification Team
example screenshot when a query failed

Attachment: bugs_sql_dump.jpg (image/jpeg, text), 77.42 KiB.

[18 May 2010 14:55] Ray Lambe
This has been fixed.