[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