Hi, I opened today a bug report for a similar bug here : http://bugs.mysql.com/bug.php?id=189 This problem only happens with DELAYED thread.
Regards, Jocelyn ----- Original Message ----- From: "Sasa Ugrenovic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 5:37 PM Subject: Trouble with MySQL4, host field in show processlist > Hi, > > My first post here l;) > > Ok, here it goes. > I recently installed MySQL4 and transfered all my databases there. > Now, it all works great, but the host field, in show processlist > command, don't work correctly. > It don't display correct info from where the query has came. > > Example: > > > mysql> show processlist; > +--------+--------------+-----------------+--------------+----------------+- -----+--------------------+------------------+ > | Id | User | Host | db | > Command | Time | State > | Info | > +--------+--------------+-----------------+--------------+----------------+- -----+--------------------+------------------+ > | 32 | DELAYED | localhost | db1 | Delayed_insert | 0 > | Waiting for INSERT | | > | 1387 | DELAYED | localhost | db2 | Delayed_insert | > 68 | Waiting for INSERT | > > You see the localhost, value for host. > It isn't correct. > These queries are from different server, not from localhost. > I'm executing show processlist from localhost only. > > Anyone know how can i fix this, or something to show correct info ? > > Thanks in advance. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
