NullReferenceException and PgSqlException when opening connection

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
taburaya
Posts: 9
Joined: Mon 05 Jun 2006 12:20

NullReferenceException and PgSqlException when opening connection

Post by taburaya » Thu 14 Sep 2006 11:48

Hello,

I have an ASP .NET 2.0 application using PostgreSQLDirect 2.50.19
giving me 2 weird problems :

1 - A NullReferenceException occurs when I try to open a connection.
============================================
This happens only once in a while at several application points. I have only one method to open connections used throughout the application and most of the time it works fine (except for the situations described here) . I have checked my server configuration and my connection string to ensure everything was OK (FYI : I'm using Max Pool Size = 200 in connection string, max_connections = 300 in server and I have about 10 simultaneous users).
The points where the error occurs seems to be random and after the error, if I wait some seconds and try the operation again, it works fine.
Here is the stack trace :

at CoreLab.PostgreSql.a.a(Byte[] A_0, Int32 A_1, ArrayList A_2)
at CoreLab.PostgreSql.a.d()
at CoreLab.PostgreSql.a.b(Boolean A_0)
at CoreLab.PostgreSql.a.d(Boolean A_0)
at CoreLab.PostgreSql.a.ae()
at CoreLab.PostgreSql.a.b(String A_0)
at CoreLab.PostgreSql.a.l()
at CoreLab.PostgreSql.a.q()
at CoreLab.PostgreSql.PgSqlInternalConnection.h()
at CoreLab.PostgreSql.PgSqlInternalConnection.b()
at CoreLab.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at CoreLab.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at CoreLab.PostgreSql.PgSqlConnection.Open()


2 - A PgSqlException (Unexpected server response) occurs when I try to open a connection.
==============================================
The same behaviours described above apply to this error. However it happens less frequently (1/5).
Here is the stack trace :

at CoreLab.PostgreSql.a.d(Boolean A_0)
at CoreLab.PostgreSql.a.ae()
at CoreLab.PostgreSql.a.b(String A_0)
at CoreLab.PostgreSql.a.l()
at CoreLab.PostgreSql.a.q()
at CoreLab.PostgreSql.PgSqlInternalConnection.h()
at CoreLab.PostgreSql.PgSqlInternalConnection.b()
at CoreLab.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at CoreLab.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at CoreLab.PostgreSql.PgSqlConnection.Open()



Thanks in advance

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 14 Sep 2006 12:20

Please download the latest version from our site and use it.

Post Reply