Created
December 17, 2020 21:24
-
-
Save infotek/f18fffd050bb6603b42da802d6b98e1c to your computer and use it in GitHub Desktop.
npgsql problem connecting to postgresql v13 (worked with postgresql 9.6)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ERROR 2020-12-16 16:02:44,499 333535ms Archive rieveUnlimitedData - Npgsql.NpgsqlException (0x80004005): Exception while reading from stream ---> System.TimeoutException: Timeout during reading attempt | |
at Npgsql.NpgsqlConnector.<<ReadMessage>g__ReadMessageLong|194_0>d.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlDataReader.<>c__DisplayClass41_0.<<ReadMessage>g__ReadMessageSequential|0>d.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at System.Threading.Tasks.ValueTask`1.get_Result() | |
at Npgsql.NpgsqlDataReader.<NextResult>d__44.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlDataReader.NextResult() | |
at Npgsql.NpgsqlCommand.<ExecuteReader>d__105.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() | |
at Npgsql.NpgsqlCommand.<ExecuteReader>d__105.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) | |
at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) | |
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) | |
at WebApp.Archive.RetrieveUnlimitedData(String mmsiList, String endTime, Boolean nextUnlimited) in Archive.asmx.cs:line 667 | |
ERROR 2020-12-16 16:02:44,505 333541ms Archive rieveUnlimitedData - Exception while reading from stream | |
ERROR 2020-12-16 16:02:44,506 333542ms Archive rieveUnlimitedData - at Npgsql.NpgsqlConnector.<<ReadMessage>g__ReadMessageLong|194_0>d.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlDataReader.<>c__DisplayClass41_0.<<ReadMessage>g__ReadMessageSequential|0>d.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at System.Threading.Tasks.ValueTask`1.get_Result() | |
at Npgsql.NpgsqlDataReader.<NextResult>d__44.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlDataReader.NextResult() | |
at Npgsql.NpgsqlCommand.<ExecuteReader>d__105.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() | |
at Npgsql.NpgsqlCommand.<ExecuteReader>d__105.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) | |
at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) | |
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) | |
at WebApp.Archive.RetrieveUnlimitedData(String mmsiList, String endTime, Boolean nextUnlimited) in Archive.asmx.cs:line 667 | |
ERROR 2020-12-16 16:03:44,394 393430ms Archive rieveUnlimitedData - Npgsql.NpgsqlException (0x80004005): Exception while reading from stream ---> System.TimeoutException: Timeout during reading attempt | |
at Npgsql.NpgsqlConnector.<<ReadMessage>g__ReadMessageLong|194_0>d.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlDataReader.<>c__DisplayClass41_0.<<ReadMessage>g__ReadMessageSequential|0>d.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at System.Threading.Tasks.ValueTask`1.get_Result() | |
at Npgsql.NpgsqlDataReader.<NextResult>d__44.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlDataReader.NextResult() | |
at Npgsql.NpgsqlCommand.<ExecuteReader>d__105.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() | |
at Npgsql.NpgsqlCommand.<ExecuteReader>d__105.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) | |
at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) | |
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) | |
at Archive.RetrieveUnlimitedData(String mmsiList, String endTime, Boolean nextUnlimited) in Archive.asmx.cs:line 667 | |
ERROR 2020-12-16 16:03:44,394 393430ms Archive rieveUnlimitedData - Exception while reading from stream | |
ERROR 2020-12-16 16:03:44,394 393430ms Archive rieveUnlimitedData - at Npgsql.NpgsqlConnector.<<ReadMessage>g__ReadMessageLong|194_0>d.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlDataReader.<>c__DisplayClass41_0.<<ReadMessage>g__ReadMessageSequential|0>d.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at System.Threading.Tasks.ValueTask`1.get_Result() | |
at Npgsql.NpgsqlDataReader.<NextResult>d__44.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlDataReader.NextResult() | |
at Npgsql.NpgsqlCommand.<ExecuteReader>d__105.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() | |
at Npgsql.NpgsqlCommand.<ExecuteReader>d__105.MoveNext() | |
--- End of stack trace from previous location where exception was thrown --- | |
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) | |
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) | |
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) | |
at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) | |
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) | |
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) | |
at WebApp.Archive.RetrieveUnlimitedData(String mmsiList, String endTime, Boolean nextUnlimited) in Archive.asmx.cs:line 667 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment