Error socket not connected

Error socket not connected

Postby alfrye » Fri 04 Mar 2011 03:38

I have a c stored procedure that accepts a bytea parameter that reads the bytes in write them to the file system. everything works correctly as long as the file I am reading in is less than 2 MB. When the source file is larger than 2 mb I immediatly get the socket not connected error and non of my stored procedure code runs. I have tried using the dotconnect for LINQ and the standard dotconnect and both give same result. I jave also tried changing the connection and command timeout time and either seem to help!

Thanks,
Alan
alfrye
 
Posts: 16
Joined: Wed 05 May 2010 19:39

Socket not connected

Postby alfrye » Fri 04 Mar 2011 14:36

Here is the call stack

at Devart.Data.PostgreSql.PgSqlDataReader.e(Int32 A_0)
at Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at Devart.Common.DbCommandBase.ExecuteNonQuery()
at UnitTests.RtacCommonDataProviderTest.UpgradeHMIRuntimeTest()
alfrye
 
Posts: 16
Joined: Wed 05 May 2010 19:39

Socket not connected

Postby alfrye » Fri 04 Mar 2011 21:56

I was able able to track down my issue and it was a code error in the c stored procedure. Once this was correct everything started working as expected.
alfrye
 
Posts: 16
Joined: Wed 05 May 2010 19:39


Return to dotConnect for PostgreSQL