[Asterisk-Users] realtime odbc/mysql eating connections

[Frank Sautter]

our asterisk is configured to retrieve sippeers and iaxpeers via odbc 
from a mysql database. after each call "show processlist;" within the 
mysql console shows 2 more persistent connections which are showing no 
further activity and will not go away even after restaring asterisk.

is anybody else experiencing this?
what can i do do resolve this?

this is a "show processlist" on the mysql console
+-----+----------+-----------+----------+---------+-------+-------+----------------+
|  Id | User     | Host      | db       | Command | Time  | State | Info 

+-----+----------+-----------+----------+---------+-------+-------+----------------+
|   7 | asterisk | localhost | asterisk | Sleep   | 2     |       | NULL 
            |   8 | asterisk | localhost | asterisk | Sleep   | 13596 | 
       | NULL            |  11 | asterisk | localhost | asterisk | Sleep 
   | 13596 |       | NULL
......... stuff deleted ...............
| 171 | asterisk | localhost | asterisk | Sleep   | 31    |       | NULL 

| 172 | asterisk | localhost | asterisk | Sleep   | 31    |       | NULL 

| 173 | asterisk | localhost | asterisk | Sleep   | 1     |       | NULL 

| 174 | asterisk | localhost | asterisk | Sleep   | 1     |       | NULL 

+-----+----------+-----------+----------+---------+-------+-------+----------------+
160 rows in set (0.00 sec)

# less /etc/odbc.ini
[asterisk]
Description = MySQL Asterisk database
Trace       = Off
TraceFile   = stderr
Driver      = MySQL
Socket      = /var/run/mysqld/mysqld.sock
Server      = localhost
User        = asterisk
Password    = <obscured>
#Port       = 3306
Database    = asterisk

# less /etc/asterisk/res_odbc.conf
[asterisk]
dsn => asterisk
username => asterisk
password => <obscured>
pre-connect => yes

# less /etc/asterisk/extconfig.conf
[settings]
iaxusers => odbc,asterisk,iaxfriends
iaxpeers => odbc,asterisk,iaxfriends
sipusers => odbc,asterisk,sipfriends
sippeers => odbc,asterisk,sipfriends