[MDEV-5014] Strange \t\n\n\n characters in SHOW PROCESSLIST Created: 2013-09-13  Updated: 2013-10-17  Due: 2013-10-16  Resolved: 2013-10-17

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.32
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Robert J. Gebis Assignee: Elena Stepanova
Resolution: Incomplete Votes: 0
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,



 Comments   
Comment by Elena Stepanova [ 2013-09-16 ]

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.

Comment by Elena Stepanova [ 2013-10-17 ]

Closing as incomplete for now, please feel free to comment to reopen the report if the problem still exists.

Generated at Thu Feb 08 07:01:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.