Bug #28083 Show processlist is not showing some queries going onto one database (logical)
Submitted: 24 Apr 2007 22:28 Modified: 27 Apr 2007 9:26
Reporter: sujay koduri Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:5.0.32-enterprise-gpl-log OS:Linux (2.6.9-42.ELsmp)
Assigned to: Sveta Smirnova CPU Architecture:Any
Tags: database, PROCESSLIST, show

[24 Apr 2007 22:28] sujay koduri
Description:
The output of "show processlist" command is not coming up fine from the mysql command line client. 
I am running SQL Queries simulataneously on four different databases (One physical database and 4 logical databases). But the output of "show full processlist" is displaying the queries only from 3 databases. It is showing that the connection has got established but it is not displaying any activity on that connection. All those are select queries and I am able to see the Query results fine for that queries. It is just that I am not able to see those queries from the output of "show processlist".

My client program is written in C and I am connecting as root from the database server itself to issue this command. 

Please let me know if you need any details.

Thank you
Sujay

How to repeat:
a) Create 4 databases (Lets say loadtest1..loadtest4) using 'create database'. 
b) Populate some data into those 4 databases. 
c) Try to make 4 Persistent connections; one to each of these databases. 
d) Run select queries on all these connections. 
e) Through mysql command line client, see the output of "show processlist" command.
f) You will observe that the output doesnt show any activity on the database connection that connects to loadtest4. 

Please let me know if you have any questions on this.

Thank you
Sujay
[25 Apr 2007 9:02] Sveta Smirnova
test case

Attachment: bug28083.tar (application/x-tar, text), 10.00 KiB.

[25 Apr 2007 9:11] Sveta Smirnova
Thank you for the report.

I can not repeat the problem using attached test (change paths and ports, then run bug28083.sh)

Please provide your configuration file and output of SHOW GLOBAL STATUS, SHOW VARIABLES and SHOW PROCESSLIST. Better if you invoke these statements from your C program.
[26 Apr 2007 20:31] sujay koduri
Sorry, even I am not able to reproduce it. I am trying to do it again. Will update this once I am able to reproduce the same. 

Sorry for the inconvenience caused.

Regards
Sujay
[27 Apr 2007 9:26] Sveta Smirnova
Thank you for the feedback.

According to it I'll close the report as "Can't repeat" Feel free to reopen it then you can repeat the issue.