Knowledgebase
Timeout error trying to upgrade ForayAdams database on PostgreSQL
Posted by Mont Rothstein on 28 January 2014 08:20 AM

While trying to upgrade ForayAdams to 4.4 on PostgreSQL the below error occurred.  Specifically it timed out while trying to add a column to a table.  Dropping the database, and all connections, and then restoring the database from backup corrected the issue.

1/28/2014 9:33:34 AM - Foray Configure Adams 4.4.3.8
DB Transaction Failed. 
Command = ALTER TABLE asset ADD COLUMN owner_id INTEGER
Inner Exception
Server did not respond within the specified timeout interval.
   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 Foray.Adams.DatabaseManager.WriteCommandToDatabase(IDbTransaction transaction, String commandText, Int32 timeout)
Inner Exception
Server did not respond within the specified timeout interval.
   at Devart.Common.ab.a(Byte[] A_0, Int32 A_1, Int32 A_2)
   at Devart.Common.d.c(Byte[] A_0, Int32 A_1, Int32 A_2)
   at Devart.Common.n.e(Byte[] A_0, Int32 A_1, Int32 A_2)
Inner Exception
Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at Devart.Common.ab.a(Byte[] A_0, Int32 A_1, Int32 A_2)
Inner Exception
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)


Comments (0)