Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.5.31
-
None
-
Debian Squeeze amd64
Description
An example of these abnormal values (i added the "|cat -v" at the end of the command to convert the non-ascii chars to standardized notations to avoid the loss/modification of those while copy/pasting to JIRA) :
# /bin/ksh -c 'i=0; while((i<100));do mysql -e "SHOW FULL PROCESSLIST\G" |perl -e "while(\$nl=<>){if(m/^\s*State:\s+[^A-z\s].*\$/){print \$_.\$nl;}} continue{\$_=\$nl;}"; sleep 0.2; ((i++)); done' |cat -v
|
State: ^F
|
Info: INSERT IGNORE INTO dfreeirzq6.t43769 (id,date,mail,bgtrfvd,etc) SELECT tbl.id, tbl.date, tbl.mail, tbl.etc,43769 FROM fjtyris.dfreeirzq437 AS tbl WHERE tbl.bgtrfvd=43769 LIMIT 100
|
State: M-^XM-#M-^@y:^?
|
Info: INSERT IGNORE INTO [...]
|
State: M-xYM->M-D9^?
|
Info: INSERT IGNORE INTO [...]
|
State: M-`M-L.M-U9^?
|
Info: INSERT IGNORE INTO [...]
|
State: ^HM-Gv4:^?
|
Info: INSERT IGNORE INTO [...]
|
State: ^F
|
Info: INSERT IGNORE INTO [...]
|
State: 8i+y:^?
|
Info: INSERT IGNORE INTO [...]
|
State: @a^LM-u9^?
|
Info: INSERT IGNORE INTO [...]
|
Insert queries in the example has been stripped for security reason but all looks the same but not ran on the same base and table ; these queries are all almost the same.
This does not seems to happen on the other server under MySQL 5.5.30 having the same tables/structures and applications executing the same kind of queries.
I havent found so far anything out of the ordinary on the app executing the queries (it does other queries than these INSERTS using the same function without encountering the same bug.
ps: it seems that the STATE value on INFORMATION_SCHEMA.PROCESSLIST is correct and is "Repair with 3 threads" for the problematic recuring INSERT queries so the bug is only on the output of the SHOW PROCESSLIST command.