Bug #51795 "reading from net" state for local authorized idle connection
Submitted: 6 Mar 2010 15:24 Modified: 9 Mar 2010 7:26
Reporter: Kavita T Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.23 OS:Linux (rhel4u8 2.6.9-89.ELsmp)
Assigned to: CPU Architecture:Any
Tags: reading from net status

[6 Mar 2010 15:24] Kavita T 
Description:
Lack of a particular environment setting causes -
root:localhost mysql login state to be in false "reading from net" state for as long as the connection is idle, causing monitoring alerts. whereas, with a customized .bash_profile that status switches to "NULL" state.
| Id     | User        | Host                  | db   | Command     | Time   | State                                                                 | Info                  |

| 159400 | root        | localhost             | NULL | Connect     |     16 | Reading from net                                                      | NULL                  |

| 159405 | root        | localhost             | NULL | Sleep       |     17 |                                                                       | NULL                  |

How to repeat:
easily reproducible with or without .bash_profile settings.
[9 Mar 2010 7:26] Sveta Smirnova 
Thank you for the report.

This is fixed in version 5.0. Please upgrade: support of version 4.1 finished at 2009-12-31. See http://www.mysql.com/about/legal/lifecycle/#calendar for details