[Mono-list] Npgsql bug? Timeout while getting a connection from pool

matthieu Barthélemy bonsouere at gmail.com
Thu Aug 14 14:24:05 EDT 2008


Hi all,

I just installed the 2.0-preview of mono, with all packages, from the
Opensuse 10.3 repository.

My app opens several (between 4 and 8 for now ) connections, each one
in a different thread. Everything works fine during 3-4min, and then
it raises this exception :

Unhandled Exception: System.Exception: Timeout while getting a
connection from pool.
  at Npgsql.NpgsqlConnectorPool.RequestPooledConnector
(Npgsql.NpgsqlConnection Connection) [0x00000]
  at Npgsql.NpgsqlConnectorPool.RequestConnector
(Npgsql.NpgsqlConnection Connection) [0x00000]
  at Npgsql.NpgsqlConnection.Open () [0x00000]
  at (wrapper remoting-invoke-with-check) Npgsql.NpgsqlConnection:Open ()
  at shMonitor.Core.Storage.Backends.Postgres.GetConnection () [0x00000]
  at shMonitor.Core.Storage.Backends.Postgres.GetAdapter
(System.String query) [0x00000]
  at shMonitor.Core.Storage.DAL.GetDataAdapter (System.String query) [0x00000]
  at shMonitor.Core.Storage.DALMonitoringPoint.GetNextElementsToSchedule
(DateTime startTime, Int32 secInterval) [0x00000]
  at shMonitor.Core.Processing.Processor.Enqueue () [0x00000]


My connection string is :

connString="Server=127.0.0.1;Port=5432;User
id=shmonitor;Password=;Database=shmonitor;Pooling=true;MaxPoolSize=100;Timeout=20;"

The code throwing this error is :

NpgsqlConnection 	conn = new NpgsqlConnection(connString);
conn.Open();



If I change the Timeout parameter to be 200, the result is the same
(although the app takes a few minutes more to crash).
Without using pooling, the exception is thrown immediately.

My app worked fine with Mono 1.9.

Is this a known issue with 2.0 preview?
Let me know anything I could do to help to solve this.

Thanks!

Matthieu Barthélemy


More information about the Mono-list mailing list