Bug #55255 a user can fill up disk with errors: Can't find description of time zone
Submitted: 14 Jul 2010 12:10 Modified: 14 Jul 2010 12:43
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: General Severity:S1 (Critical)
Version:5.1.49, 5.0, 5.6.99 OS:Any
Assigned to: CPU Architecture:Any

[14 Jul 2010 12:10] Shane Bester
Description:
a minimally privileged user can fill the disk by running queries that cause this to be printed to the error log:

100917  1:56:08 [ERROR] Can't find description of time zone '000000000000'
100917  1:56:08 [ERROR] Can't find description of time zone '000000000000'
100917  1:56:08 [ERROR] Can't find description of time zone '001.7569e+21'
100917  1:56:08 [ERROR] Can't find description of time zone '001.7569e+21'

How to repeat:
select convert_tz(1,repeat('a',999999),1);

run this a gazillion trillion zillion times. check disk space.

Suggested fix:
the bug is that the error in the error log should be returned to the client instead. nothing must be printed to the error log.
[14 Jul 2010 12:43] Sveta Smirnova
Thank you for the report.

Verified as described.
[26 Feb 2013 10:10] MySQL Verification Team
For some unknown reason I cannot repeat this bug anymore, even though the code that prints the warning message is still there.
[15 Jul 2013 10:48] Hartmut Holzgraefe
Can reproduce this with 5.1.60 but not with 5.5.30 or 5.6.12

So close as "Close" or as "Won't fix" (for 5.1.x)?