Bug #66767 print more than 1024 characters of the crashing query

• Submitted: 11 Sep 2012 12:46
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: Errors
• Severity: S4 (Feature request)
• Version: 5.5.29
• OS: Any
• CPU Architecture: Any

[11 Sep 2012 12:46] Shane Bester

Description:
when mysqld crashes, the signal handler prints 1024 characters of the query, at most.   This is not enough - many queries are bigger than this.

How to repeat:
.

Suggested fix:
print 4194304 bytes of the query.

-    my_safe_print_str(thd->query(), min(1024, thd->query_length()));
+    my_safe_print_str(thd->query(), min(1024*1024*4, thd->query_length()));

[11 Sep 2012 12:52] MySQL Verification Team

If we get picky about the limit, we could print at most 
@@global.max_allowed_packet bytes of the query