Intermitten write failure problems

Intermitten write failure problems

Postby phaggard » Wed 24 Oct 2007 15:07

We are having intermittent problems when connecting to PostgreSQL that we are having a hard time resolving. This is an example from the log file in our application:

CoreLab.PostgreSql.PgSqlException: Write failure ---> System.Net.Sockets.SocketE
xception: The socket has been shut down
at System.Net.Sockets.Socket.Send (System.Byte[] buf, Int32 offset, Int32 size
, SocketFlags flags) [0x00000]
at System.Net.Sockets.NetworkStream.Write (System.Byte[] buffer, Int32 offset,
Int32 size) [0x00000] --- End of inner exception stack trace ---

at CoreLab.PostgreSql.o.b (System.Byte[] A_0, Int32 A_1, Int32 A_2) [0x00000]
at CoreLab.PostgreSql.o.j () [0x00000]
at CoreLab.PostgreSql.a.a (System.String A_0, System.String A_1) [0x00000]
at CoreLab.PostgreSql.a.l () [0x00000]
at CoreLab.PostgreSql.PgSqlCommand.a (Boolean A_0, Int32 A_1, Int32 A_2) [0x00

This is occurring with version of the PostgreSQLDirect.NET driver accessing PostgreSQL 8.1.10 running on CentOS 5. Our application is running under mono-1.2.5 on CentOS 5 as well.

Interestingly, if this error occurs several times in row it can also generate an 'out of memory' exception from mono itself.

What are the common causes for this problem? We have not found anything unusual with the settings for PostgreSQL or by reviewing the PostgreSQL log file. The network settings appear to be normal as well..

Any help or insight would be greatly appreciated.
Posts: 5
Joined: Thu 09 Aug 2007 15:42

Postby Alexey » Thu 25 Oct 2007 06:40

Please send me a test project to reproduce the problem.
Include the definition of your own database objects.
Use e-mail address provided in the Readme file.
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Return to dotConnect for PostgreSQL