[asterisk-bugs] [Asterisk 0015375]: realtime mysql status always shows connected for 0 seconds/no connection

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=15375 
====================================================================== 
Reported By:                kowalma
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   15375
Category:                   Addons/res_config_mysql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
Asterisk Version:           1.6.1.1 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-06-22 06:31 CDT
Last Modified:              2009-06-22 07:34 CDT
====================================================================== 
Summary:                    realtime mysql status always shows connected for 0
seconds/no connection
Description: 
I've found issue with DB connection.

Asterisk-node1(active):/usr/src#  rasterisk  -x "realtime mysql status"
general connected to asterisk at 127.0.0.1, port 3306 with username cdr for 0
seconds.
Asterisk-node1(active):/usr/src#

shows always 0 seconds. Sometime rt shows that there is no db connection
(and then sip show peers show no sip-peer configured) but DB is queried
====================================================================== 

---------------------------------------------------------------------- 
 (0106777) kowalma (reporter) - 2009-06-22 07:34
 https://issues.asterisk.org/view.php?id=15375#c106777 
---------------------------------------------------------------------- 
Now happened following:

Asterisk-node1*CLI> realtime mysql status
Asterisk-node1*CLI> realtime mysql status
Asterisk-node1*CLI> realtime mysql status
Asterisk-node1*CLI> realtime mysql status
Asterisk-node1*CLI> realtime mysql status
Asterisk-node1*CLI> realtime mysql status
Asterisk-node1*CLI> my

and I'm not able to type anything on CLI. Only solution is to kill
asterisk CLI (but only CLI) and then CLI will work again.

That time realtime does not query MySQL - last check I had 6mins ago:

090622 14:27:29      42 Init DB     asterisk
                     42 Query       UPDATE sipfriends SET lastms = '-1'
WHERE name = '1064'
                     42 Init DB     asterisk
                     42 Query       SELECT * FROM sipfriends WHERE name =
'1064' 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-06-22 07:34 kowalma        Note Added: 0106777                          
======================================================================