| Bug #65698 | information_schema.PROCESSLIST truncated | ||
|---|---|---|---|
| Submitted: | 21 Jun 2012 9:25 | Modified: | 21 Jun 2012 18:26 |
| Reporter: | Jo R | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
| Version: | 5.1.41, 5.1.64, 5.5.26, 5.6.6 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | PROCESSLIST, truncated | ||
[21 Jun 2012 18:26]
Sveta Smirnova
Thank you for the report. Verified as described. Partial workaround: use SHOW PROCESSLIST
Description: information_schema.PROCESSLIST gets truncated when contains non ASCII character. How to repeat: execute: -- -- drop procedure if exists sp_test; delimiter $$ CREATE PROCEDURE `sp_test`() BEGIN SET @sql = CONCAT('SELECT "',unhex('31a032'),'", sleep(10)'); PREPARE stmt FROM @sql; EXECUTE stmt; END$$ delimiter ; call sp_test();drop procedure if exists sp_test; -- -- during 10 sec check information_schema.PROCESSLIST: -- -- select info from `information_schema`.`PROCESSLIST`; show warnings; -- -- it's truncated right after '1' character