Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Incomplete
-
Affects Version/s: 5.5.32
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:Ubuntu 12.04 LTS x64
Description
When executing from command line
mysql -u user -ppassword -e "SHOW PROCESSLIST" | grep Query
At times I see this strange like with \n\t\t\t\t between fields. This is simple Procedure call that inserts to same table. Here is example output from above query.
\n\t\t\t\t\t\t\t0.000t\t\t\t\t\t\t account,Tron Query 0 NULL INSERT INTO tb_order (orderID,
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Closing as incomplete for now, please feel free to comment to reopen the report if the problem still exists.
Hi Robert,
1) What does it look like when you don't do grep?
2) Your output example is not quite clear. Is it the complete line, untampered? For example, I can't figure what account,Tron stands for, there should be no comma in the output as far as I can tell. Could you please provide the original line? If there are security issues involved (User, Host, db), please feel free to replace them with <user> <host>:<port> <db> accordingly.
3) Please provide the output of SHOW CREATE PROCEDURE <procedure name>
Thanks.