Re: [Firebird-net-provider] Error reading data from the connection

[Gerdus van Zyl]

You can just catch the exception, rollback the batch transaction if
possible, reconnect and retry that batch again.
Having retry logic is the only way to ensure reliability.

On 16 November 2017 at 16:33, LtColRDSChauhan  wrote:

> Hello,
>
> 1. I need to frequently copy a table from one database to another. This
> has started to fail now, apparently due to increase in number of records.
> Attempting to copy about 13,26,000 records fails reporting “Error reading
> data from the connection”. Number of records that I can still successful
> copy is about 13,24,510.
>
> 3. I copy the in batches of 50,000 records (variable) each. For each
> batch, i open and close connection. I have tried setting connection pooling
> true and false both. Also varied the batch size to 5000, 10 etc.
>
> 2. My database and client are on the same machine. Other details:
>
> RAM 16 GB
>
> Client application 64 Bit
>
> OS Windows 10 64 Bit
>
> Firebird ADO.NET Data Provider – tried both: 5.11.0.0 and 5.12.0
>
> Firebird 3.0.2.32703_0_Win64
>
> 3. Please suggest possible solutions.
>
> Regards,
>
> Rajiv
>
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Error reading data from the connection

[LtColRDSChauhan]

Hello,

1. I need to frequently copy a table from one database to another. This has
started to fail now, apparently due to increase in number of records.
Attempting to copy about 13,26,000 records fails reporting “Error reading
data from the connection”. Number of records that I can still successful
copy is about 13,24,510.

3. I copy the in batches of 50,000 records (variable) each. For each batch,
i open and close connection. I have tried setting connection pooling true
and false both. Also varied the batch size to 5000, 10 etc.

2. My database and client are on the same machine. Other details:

RAM 16 GB

Client application 64 Bit

OS Windows 10 64 Bit

Firebird ADO.NET Data Provider – tried both: 5.11.0.0 and 5.12.0

Firebird 3.0.2.32703_0_Win64

3. Please suggest possible solutions.

Regards,

Rajiv
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider