Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4723

"State" column of SHOW PROCESSLIST returns wrong values (non-ascii chars) for some states



    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.5.31
    • Fix Version/s: 5.5.34
    • Component/s: None
    • Environment:
      Debian Squeeze amd64


      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.




            serg Sergei Golubchik
            jb-boin Jean Weisbuch
            0 Vote for this issue
            3 Start watching this issue



                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.