Npgsql.NpgsqlException: Exception while reading from stream

[OProf77]

Thanks for the application. While I was doing the migration I got this error...

06/07/2024 06:37:34 || LOG: Fetched data from public.ana_co_visure table of postgresql...
Npgsql.NpgsqlException: Exception while reading from stream
System.TimeoutException: Timeout during reading attempt
…
at async ValueTask Npgsql.Internal.NpgsqlConnector.ReadMessageLong(bool async, DataRowLoadingMode dataRowLoadingMode, bool
readingNotifications, bool isReadingPrependedMessage)
at TResult System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder1.StateMachineBox1.System.Threading.Tasks.Sources.IValueTaskSource. GetResult(short token)
at async Task Npgsql.NpgsqlDataReader.Read(bool async, CancellationToken cancellationToken)
at bool Npgsql.NpgsqlDataReader.Read()
at int System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at int System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, string srcTable, DataReaderContainer dataReader, int startRecord, int maxRecords, DataColumn parentChapterColumn, object parentChapterValue)
at int System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, int startRecord, int maxRecords)
at void System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)
at void Application.Service.<>cDisplayClass3_0.b0(StatusContext ctx) in /postgresql-to-mssql/Services/
Service.cs:95
Npgsql.NpgsqlOperationInProgressException: A command is already in progress: SELECT * FROM public.ana_co_visure at void Npgsql.ThrowHelper.ThrowNpgsqlOperationInProgressException(NpgsqlCommand command)
at UserAction Npgsql.Internal.NpgsqlConnector.gDoStartUserAction|2790(ConnectorState newState, NpgsqlCommand command, CancellationToken cancellationToken, bool attemptPgCancellation)
at async ValueTask Npgsql.NpgsqlCommand.ExecuteReader(bool async, CommandBehavior behavior, CancellationToken cancellationToken)
at async ValueTask Npgsql.NpgsqlCommand.ExecuteReader(bool async, CommandBehavior behavior, CancellationToken cancellationToken)
at DbDataReader Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, bool wasClosed, CommandBehavior behavior) in //Dapper/SqlMapper.cs:1156
at IEnumerable Dapper.SqlMapper.QueryImpl(IDbConnection cnn, CommandDefinition command, Type effectiveType) in //Dapper/SqlMapper.cs:1184
at System.Collections.Generic.List`1..ctor(IEnumerable collection)
at IEnumerable

[OProf77]

I think that error appears on views

"06/07/2024 06:37:34 || LOG: Fetched data from public.ana_co_visure table of postgresql..."

because "public.ana_co_visure" it's a view and not a table.

Can I specify to migrate only tables and table data?

Thanks

[OProf77]

I have modified this line in Service.cs file: var getTablesQuery = $"SELECT table_name FROM information_schema.tables WHERE table_schema = '{sourceSchema}'"; with this: var getTablesQuery = $"SELECT table_name FROM information_schema.tables WHERE table_schema = '{sourceSchema}' and table_type = 'BASE TABLE'";

...and now all works fine and I have migrated all my tables(only tables without views or more) with data from Postgres to MSSQL. 2,5GB size of Postgres

[sanamhub]

Thanks @OProf77 for creating an issue, sorry cannot reach you early but happy you got the solution. I'll keep this issue open and resolve with better approach what I can find.