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

2018-09-16 Thread Mark Rotteveel 

You are posting to the old list. The list has moved to Google Groups.

Subscribe by sending a mail to:
firebird-net-provider+subscr...@googlegroups.com

or by visiting
https://groups.google.com/forum/#!forum/firebird-net-provider

Mark

On 16-11-2017 15: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




--
Mark Rotteveel


___
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 Re: Firebird-net-provider Digest, Vol 139, Issue 9

2017-12-02 Thread LtColRDSChauhan 
On Thu, Nov 23, 2017 at 10:54 AM, <
firebird-net-provider-requ...@lists.sourceforge.net> wrote:

> Send Firebird-net-provider mailing list submissions to
> firebird-net-provider@lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> or, via email, send a message with subject or body 'help' to
> firebird-net-provider-requ...@lists.sourceforge.net
>
> You can reach the person managing the list at
> firebird-net-provider-ow...@lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Firebird-net-provider digest..."
>
>
> Today's Topics:
>
>1. Error reading data from the connection Re:
>   Firebird-net-provider Digest, Vol 139, Issue 7 (LtColRDSChauhan)
>
>
> --
>
> Message: 1
> Date: Thu, 23 Nov 2017 10:54:48 +0530
> From: LtColRDSChauhan 
> To: firebird-net-provider@lists.sourceforge.net
> Subject: [Firebird-net-provider] Error reading data from the
> connection Re: Firebird-net-provider Digest, Vol 139, Issue 7
> Message-ID:
>  gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Sat, Nov 18, 2017 at 7:31 PM, <
> firebird-net-provider-requ...@lists.sourceforge.net> wrote:
>
> > Send Firebird-net-provider mailing list submissions to
> > firebird-net-provider@lists.sourceforge.net
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-
> provider
> > or, via email, send a message with subject or body 'help' to
> > firebird-net-provider-requ...@lists.sourceforge.net
> >
> > You can reach the person managing the list at
> > firebird-net-provider-ow...@lists.sourceforge.net
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of Firebird-net-provider digest..."
> >
> >
> > Today's Topics:
> >
> >1. Error reading data from the connection Re:
> >   Firebird-net-provider Digest, Vol 139, Issue 6 (LtColRDSChauhan)
> >
> >
> > --
> >
> > Message: 1
> > Date: Sat, 18 Nov 2017 19:31:44 +0530
> > From: LtColRDSChauhan 
> > To: firebird-net-provider@lists.sourceforge.net
> > Subject: [Firebird-net-provider] Error reading data from the
> > connection Re: Firebird-net-provider Digest, Vol 139, Issue 6
> > Message-ID:
> >  > gmail.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > On Sat, Nov 18, 2017 at 5:46 PM, <
> > firebird-net-provider-requ...@lists.sourceforge.net> wrote:
> >
> > > Send Firebird-net-provider mailing list submissions to
> > > firebird-net-provider@lists.sourceforge.net
> > >
> > > To subscribe or unsubscribe via the World Wide Web, visit
> > > https://lists.sourceforge.net/lists/listinfo/firebird-net-
> > provider
> > > or, via email, send a message with subject or body 'help' to
> > > firebird-net-provider-requ...@lists.sourceforge.net
> > >
> > > You can reach the person managing the list at
> > > firebird-net-provider-ow...@lists.sourceforge.net
> > >
> > > When replying, please edit your Subject line so it is more specific
> > > than "Re: Contents of Firebird-net-provider digest..."
> > >
> > >
> > > Today's Topics:
> > >
> > >1. Re: Error reading data from the connection Re:
> > >   Firebird-net-provider Digest, Vol 139, Issue 3 (Ji?? ?in?ura)
> > >
> > >
> > > --
> > >
> > > Message: 1
> > > Date: Sat, 18 Nov 2017 09:07:35 +0100
> > > From: Ji?? ?in?ura 
> > > To: firebird-net-provider@lists.sourceforge.net
> > > Subject: Re: [Firebird-net-provider] Error reading data from the
> > > connection Re: Firebird-net-provider Digest, Vol 139, Issue 3
> > > Message-ID:
> > > <1510992455.1577004.1176679856.4C4DB47A@webmail.
> > > messagingengine.com>
> > > Content-Type: text/plain; charset="utf-8"
> > >
> > > I would check inner exception to see what

[Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 7

2017-11-22 Thread LtColRDSChauhan 
On Sat, Nov 18, 2017 at 7:31 PM, <
firebird-net-provider-requ...@lists.sourceforge.net> wrote:

> Send Firebird-net-provider mailing list submissions to
> firebird-net-provider@lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> or, via email, send a message with subject or body 'help' to
> firebird-net-provider-requ...@lists.sourceforge.net
>
> You can reach the person managing the list at
> firebird-net-provider-ow...@lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Firebird-net-provider digest..."
>
>
> Today's Topics:
>
>1. Error reading data from the connection Re:
>   Firebird-net-provider Digest, Vol 139, Issue 6 (LtColRDSChauhan)
>
>
> --
>
> Message: 1
> Date: Sat, 18 Nov 2017 19:31:44 +0530
> From: LtColRDSChauhan 
> To: firebird-net-provider@lists.sourceforge.net
> Subject: [Firebird-net-provider] Error reading data from the
> connection Re: Firebird-net-provider Digest, Vol 139, Issue 6
> Message-ID:
>  gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Sat, Nov 18, 2017 at 5:46 PM, <
> firebird-net-provider-requ...@lists.sourceforge.net> wrote:
>
> > Send Firebird-net-provider mailing list submissions to
> > firebird-net-provider@lists.sourceforge.net
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-
> provider
> > or, via email, send a message with subject or body 'help' to
> > firebird-net-provider-requ...@lists.sourceforge.net
> >
> > You can reach the person managing the list at
> > firebird-net-provider-ow...@lists.sourceforge.net
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of Firebird-net-provider digest..."
> >
> >
> > Today's Topics:
> >
> >1. Re: Error reading data from the connection Re:
> >   Firebird-net-provider Digest, Vol 139, Issue 3 (Ji?? ?in?ura)
> >
> >
> > --
> >
> > Message: 1
> > Date: Sat, 18 Nov 2017 09:07:35 +0100
> > From: Ji?? ?in?ura 
> > To: firebird-net-provider@lists.sourceforge.net
> > Subject: Re: [Firebird-net-provider] Error reading data from the
> > connection Re: Firebird-net-provider Digest, Vol 139, Issue 3
> > Message-ID:
> > <1510992455.1577004.1176679856.4C4DB47A@webmail.
> > messagingengine.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > I would check inner exception to see what happened.
> >
> >
> Thanks for responding, Jiri.
> The details of exception are as under please. Let me know if more details
> are required.
>
>
> - ex   {"Error reading data from the
> connection."}   FirebirdSql.Data.FirebirdClient.FbException
>
> +Data
> {System.Collections.ListDictionaryInternal}
> System.Collections.IDictionary
> {System.Collections.ListDictionaryInternal}
>
>   ErrorCode   335544726  int
>
> +Errors
> {FirebirdSql.Data.FirebirdClient.FbErrorCollection}
> FirebirdSql.Data.FirebirdClient.FbErrorCollection
>
>   HResult -2147467259  int
>
>   HelpLink   null string
>
> - InnerException   {"Error reading data from
> the connection."}   System.Exception
> {FirebirdSql.Data.Common.IscException}
>
> +Data
> {System.Collections.ListDictionaryInternal}
> System.Collections.IDictionary
> {System.Collections.ListDictionaryInternal}
>
>   ErrorCode   335544726  int
>
> +ErrorsCount = 2
> System.Collections.Generic.List
>
>   HResult -2146233088  int
>
>   HelpLink   null string
>
> - InnerException   {"I/O error occurred."}
>System.Exception
> {System.IO.IOException}
>
> +Data
> {System.Collections.List

[Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 6

2017-11-18 Thread LtColRDSChauhan 
On Sat, Nov 18, 2017 at 5:46 PM, <
firebird-net-provider-requ...@lists.sourceforge.net> wrote:

> Send Firebird-net-provider mailing list submissions to
> firebird-net-provider@lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> or, via email, send a message with subject or body 'help' to
> firebird-net-provider-requ...@lists.sourceforge.net
>
> You can reach the person managing the list at
> firebird-net-provider-ow...@lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Firebird-net-provider digest..."
>
>
> Today's Topics:
>
>1. Re: Error reading data from the connection Re:
>   Firebird-net-provider Digest, Vol 139, Issue 3 (Ji?? ?in?ura)
>
>
> --
>
> Message: 1
> Date: Sat, 18 Nov 2017 09:07:35 +0100
> From: Ji?? ?in?ura 
> To: firebird-net-provider@lists.sourceforge.net
> Subject: Re: [Firebird-net-provider] Error reading data from the
> connection Re: Firebird-net-provider Digest, Vol 139, Issue 3
> Message-ID:
> <1510992455.1577004.1176679856.4C4DB47A@webmail.
> messagingengine.com>
> Content-Type: text/plain; charset="utf-8"
>
> I would check inner exception to see what happened.
>
>
Thanks for responding, Jiri.
The details of exception are as under please. Let me know if more details
are required.


- ex   {"Error reading data from the
connection."}   FirebirdSql.Data.FirebirdClient.FbException

+Data
{System.Collections.ListDictionaryInternal}
System.Collections.IDictionary
{System.Collections.ListDictionaryInternal}

  ErrorCode   335544726  int

+Errors
{FirebirdSql.Data.FirebirdClient.FbErrorCollection}
FirebirdSql.Data.FirebirdClient.FbErrorCollection

  HResult -2147467259  int

  HelpLink   null string

- InnerException   {"Error reading data from
the connection."}   System.Exception
{FirebirdSql.Data.Common.IscException}

+Data
{System.Collections.ListDictionaryInternal}
System.Collections.IDictionary
{System.Collections.ListDictionaryInternal}

  ErrorCode   335544726  int

+ErrorsCount = 2
System.Collections.Generic.List

  HResult -2146233088  int

  HelpLink   null string

- InnerException   {"I/O error occurred."}
   System.Exception
{System.IO.IOException}

+Data
{System.Collections.ListDictionaryInternal}
System.Collections.IDictionary
{System.Collections.ListDictionaryInternal}

  HResult -2146232800  int

  HelpLink   null string

- InnerException   null System.Exception

+Static members

  Message  "I/O error occurred."
string

  Source
"FirebirdSql.Data.FirebirdClient"
string

  StackTrace  "   at
FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(Int32 count)\r\n   at
FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()\r\n   at
FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()\r\n   at
FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()"
string

+TargetSite   {Byte[]
ReadBytes(Int32)}
System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo}

+Static members

+Non-Public members

  IsWarningfalse  bool

  Message  "Error reading data from
the connection."string

  SQLSTATE"08006"
string

  Source
"FirebirdSql.Data.FirebirdClient"
string

  StackTrace  "   at
FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()\r\n   at
FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()" string

+TargetSite
{FirebirdSql.Data.Common.DbValue[]
Fetch()}   System.Reflection.MethodBase
{System.Reflection.Runtim

Re: [Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 3

2017-11-18 Thread Jiří Činčura 
I would check inner exception to see what happened.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/


--
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

Re: [Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 3

2017-11-17 Thread LtColRDSChauhan 
On Fri, Nov 17, 2017 at 7:19 PM, LtColRDSChauhan  wrote:

>
>
> On Fri, Nov 17, 2017 at 5:38 PM,  requ...@lists.sourceforge.net> wrote:
>
>> Send Firebird-net-provider mailing list submissions to
>> firebird-net-provider@lists.sourceforge.net
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-pr
>> ovider
>> or, via email, send a message with subject or body 'help' to
>> firebird-net-provider-requ...@lists.sourceforge.net
>>
>> You can reach the person managing the list at
>> firebird-net-provider-ow...@lists.sourceforge.net
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of Firebird-net-provider digest..."
>>
>>
>> Today's Topics:
>>
>>1. Error reading data from the connection (LtColRDSChauhan)
>>2. Re: Error reading data from the connection (Gerdus van Zyl)
>>
>>
>> ----------
>>
>> Message: 1
>> Date: Thu, 16 Nov 2017 20:03:05 +0530
>> From: LtColRDSChauhan 
>> To: firebird-net-provider@lists.sourceforge.net
>> Subject: [Firebird-net-provider] Error reading data from the
>> connection
>> Message-ID:
>> > ail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> 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
>> -- next part --
>> An HTML attachment was scrubbed...
>>
>> --
>>
>> Message: 2
>> Date: Thu, 16 Nov 2017 16:51:38 +0200
>> From: Gerdus van Zyl 
>> To: "For users and developers of the Firebird .NET providers"
>> 
>> Subject: Re: [Firebird-net-provider] Error reading data from the
>> connection
>> Message-ID:
>> > gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> 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.
>>
>
> I am using try-catch and roll back.
> Also retrying again and again after roll back for last 48hrs.
> The result is consistently the same ie copying about 13,26,000 records
> fails reporting Error reading data from the connection,
> while copying  about 13,24,510 record always succeeds.
> The issue here is more then just ensuring reliability.
>
I could pin point the issue in my case.

With the select command text for FbDataAdapter set as:

SELECT first 5 SKIP 126 * FROM PATIENT_BILL order by REGDID, SER

Calling Fill raises the exception Error reading data from the connection
immediately on a freshly created single connection with no pooling.

Am I missing some setting for FbDataAdapter?


> May be I am missing out settings.
> Please suggest possible solutions.
>
>
>
>> 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
&

[Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 3

2017-11-17 Thread LtColRDSChauhan 
On Fri, Nov 17, 2017 at 5:38 PM, <
firebird-net-provider-requ...@lists.sourceforge.net> wrote:

> Send Firebird-net-provider mailing list submissions to
> firebird-net-provider@lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> or, via email, send a message with subject or body 'help' to
> firebird-net-provider-requ...@lists.sourceforge.net
>
> You can reach the person managing the list at
> firebird-net-provider-ow...@lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Firebird-net-provider digest..."
>
>
> Today's Topics:
>
>1. Error reading data from the connection (LtColRDSChauhan)
>2. Re: Error reading data from the connection (Gerdus van Zyl)
>
>
> --
>
> Message: 1
> Date: Thu, 16 Nov 2017 20:03:05 +0530
> From: LtColRDSChauhan 
> To: firebird-net-provider@lists.sourceforge.net
> Subject: [Firebird-net-provider] Error reading data from the
> connection
> Message-ID:
>  gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> 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
> -- next part --
> An HTML attachment was scrubbed...
>
> ----------
>
> Message: 2
> Date: Thu, 16 Nov 2017 16:51:38 +0200
> From: Gerdus van Zyl 
> To: "For users and developers of the Firebird .NET providers"
> 
> Subject: Re: [Firebird-net-provider] Error reading data from the
> connection
> Message-ID:
>  mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> 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.
>

I am using try-catch and roll back.
Also retrying again and again after roll back for last 48hrs.
The result is consistently the same ie copying about 13,26,000 records
fails reporting Error reading data from the connection,
while copying  about 13,24,510 record always succeeds.
The issue here is more then just ensuring reliability.
May be I am missing out settings.
Please suggest possible solutions.



> 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
> > ___
> &

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

2017-11-16 Thread 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

2017-11-16 Thread 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

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

2015-01-25 Thread Luciano Mendes 
Well I opened the bug http://tracker.firebirdsql.org/browse/DNET-585 but it
was closed as Won't Fix :(



--
View this message in context: 
http://firebird.1100200.n4.nabble.com/Error-reading-data-from-the-connection-tp4638893p4638927.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

--
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

2015-01-23 Thread Jiří Činčura 
> Probably the provider pulls a bad connection from the pool and tries to use 
> it despite its being broken.

OK, so once more. Provider is not reopening the connection or doing *anything* 
with it. In fact it's even impossible to do it reliably.


--
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

2015-01-23 Thread Michał Ziemski 
I get this error too from time to time.

When using pooling, after the firebird server is restarted it's immposible
to establish a new connection to the serwer.
Probably the provider pulls a bad connection from the pool and tries to use
it despite its being broken.

Cheers.
Michał

2015-01-23 12:44 GMT+01:00 Jiří Činčura :

>  That’s expected. The driver is not reopening the connection.
>
>
>
> --
>
> Mgr. Jiří Činčura
>
> Independent IT Specialist
>
>
>
> *From:* Nicolas F. Timmers [mailto:nftimm...@hotmail.com]
> *Sent:* Friday, January 23, 2015 11:49 AM
> *To:* 'For users and developers of the Firebird .NET providers'
> *Subject:* [Firebird-net-provider] Error reading data from the connection
>
>
>
> Hello
>
> I am experiencing an error regarding the new version of Firebird Client
> 4.6.0
>
> In summary the following steps are necessary to generate the error
>
>
>
> 1) Using a page Ex: Default.aspx, make a connection to the database
>
> 2) After made the connection end the firebird service by windows services
>
> 3) When you return to the page and try to make a new connection an error
> is generated
>
> 4) Error reading data from the connection
>
>
>
> What did seems to be is that when the firebird service is stopped the
> Firebird Client is trying to use the Pooling my question is if an attempt
> is made in pooling successfully should not the DLL fill the pooling again?
>
>
> --
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
--
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

2015-01-23 Thread Jiří Činčura 
That’s expected. The driver is not reopening the connection.

--
Mgr. Jiří Činčura
Independent IT Specialist

From: Nicolas F. Timmers [mailto:nftimm...@hotmail.com]
Sent: Friday, January 23, 2015 11:49 AM
To: 'For users and developers of the Firebird .NET providers'
Subject: [Firebird-net-provider] Error reading data from the connection

Hello
I am experiencing an error regarding the new version of Firebird Client 4.6.0
In summary the following steps are necessary to generate the error

1) Using a page Ex: Default.aspx, make a connection to the database
2) After made the connection end the firebird service by windows services
3) When you return to the page and try to make a new connection an error is 
generated
4) Error reading data from the connection

What did seems to be is that when the firebird service is stopped the Firebird 
Client is trying to use the Pooling my question is if an attempt is made in 
pooling successfully should not the DLL fill the pooling again?
--
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet___
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

2015-01-23 Thread Nicolas F. Timmers 
Hello

I am experiencing an error regarding the new version of Firebird Client
4.6.0

In summary the following steps are necessary to generate the error

 

1) Using a page Ex: Default.aspx, make a connection to the database

2) After made the connection end the firebird service by windows services

3) When you return to the page and try to make a new connection an error is
generated

4) Error reading data from the connection

 

What did seems to be is that when the firebird service is stopped the
Firebird Client is trying to use the Pooling my question is if an attempt is
made in pooling successfully should not the DLL fill the pooling again?

--
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider