4.0.12 show processlist bug under Solaris
am 28.03.2003 23:54:13 von Bruce DembeckiG'Day! We did the 4.0.12 upgrade last night. Since that time anything
accessing show processlist results in the list showing all IP#s or hostnames
of all connections being that of the machine asking for the show
processlist.
How to reproduce:
Running 4.0.12 Under Solaris 8 or Solaris 9, same results. I can switch
between mysql 4.0.12 and 4.0.11 and get either the correct host listing
under 4.0.11 or the wrong listing under 4.0.12.
I have posted two examples from the same server a few minutes apart (Sorry
they are so long, I've shortened them for brevity), one example is produced
locally, one from my laptop several miles from the server. This server is
currently holding connections from 10 application servers, and the single
connection from either localhost or my laptop that ran the show processlist
command. Clearly there should be more hostnames or IP in the list.
Best Regards, Bruce
mysql> show processlist;
+------+-------------+-----------------+-------------------- --+-------------
| Id | User | Host | db | Command
+------+-------------+-----------------+-------------------- --+-------------
| 1 | system user | localhost | NULL | Connect
| 4 | repl | localhost:32921 | NULL | Binlog Dump
| 18 | jive | localhost:42776 | jive_ebay_de | Sleep
| 20 | jive | localhost:42777 | jive_ebay_de | Sleep
| 22 | jive | localhost:42778 | jive_ebay_de | Sleep
| 23 | jive | localhost:42779 | jive_ebay_de | Sleep
| 24 | jive | localhost:42780 | jive_ebay_de | Sleep
| 25 | jive | localhost:42781 | jive_ebay_de | Sleep
| 37 | jive | localhost:62705 | jive_sccounty | Sleep
| 38 | ebay | localhost:62706 | jive_ebayqa_en | Sleep
| 40 | jive | localhost:62707 | jive_ebay_de | Sleep
| 41 | ebay | localhost:62708 | jive_ebayqa_en | Sleep
| 42 | ebay | localhost:62709 | jive_ebayqa_en | Sleep
| 43 | jive | localhost:62710 | jive_sccounty | Sleep
| 44 | jive | localhost:62711 | jive_sccounty | Sleep
| 45 | jive | localhost:62712 | jive_sccounty | Sleep
| 46 | jive | localhost:62713 | jive_sccounty | Sleep
| 47 | jive | localhost:62714 | jive_ebay_de | Sleep
| 48 | jive | localhost:62715 | jive_ebay_de | Sleep
| etc etc etc... And a whole bunch more like this....
+------+-------------+-----------------+-------------------- --+-------------
134 rows in set (0.01 sec)
mysql>
mysql> show processlist;
+------+-------------+--------------------+----------------- -----+----------
| Id | User | Host | db | Command
+------+-------------+--------------------+----------------- -----+----------
| 1 | system user | 172.20.42.28 | NULL | Connect
| 4 | repl | 172.20.42.28:32921 | NULL | Binlog
| 18 | jive | 172.20.42.28:42776 | jive_ebay_de | Sleep
| 20 | jive | 172.20.42.28:42777 | jive_ebay_de | Sleep
| 22 | jive | 172.20.42.28:42778 | jive_ebay_de | Sleep
| 23 | jive | 172.20.42.28:42779 | jive_ebay_de | Sleep
| 24 | jive | 172.20.42.28:42780 | jive_ebay_de | Sleep
| 25 | jive | 172.20.42.28:42781 | jive_ebay_de | Sleep
| 26 | jive | 172.20.42.28:42782 | jive_ebay_de | Sleep
| 27 | jive | 172.20.42.28:42783 | jive_ebay_de | Sleep
| 28 | jive | 172.20.42.28:42784 | jive_ebay_de | Sleep
| 29 | jive | 172.20.42.28:42785 | jive_ebay_de | Sleep
| 31 | ebay | 172.20.42.28:42786 | jive_ebayqa_en | Sleep
| etc etc etc.... And a whole bunch more like this...
+------+-------------+--------------------+----------------- -----+----------
133 rows in set (0.18 sec)
mysql>
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org