[Mono-list] Mysql con.Close( ) problem

[Roberto Zenteno]

Hi
I have an ASP.NET application running on mono 1.2.2.1-0, mysql-5.0.26-12 and
bytefx-data-mysql-1.2.2.1-0 on Linux OpenSuse.

Suddenly my application started getting this error Too many connections, and
running a show processlist on the mysql console I could see the reason, more
than 100 connectios were open.

So I try to find the page that wasn´t closing the connections and I didn´t
found it.

So I wrote a simple page that executes a con.Open() and a con.Close()
sentences and inmediatly ran a show proccesslis on the console, and I got

+-------+----------+-----------------+-----------+---------+------+-------+------------------+
| Id    | User     | Host                 | db              | Command | Time
| State | Info             |
+-------+----------+-----------------+-----------+---------+------+-------+------------------+

| 2    | seewrite | localhost:45572 | DBempleos | Sleep       |    6
|          | NULL             |

The conection stays open unless I kill it.

Does anybody know what could be wrong.

Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20070131/3a0a76a7/attachment.html