Menu
▾
▴
[Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 9
|
From: LtColRDSChauhan <rds...@gm...> - 2017-12-03 04:14:40
|
On Thu, Nov 23, 2017 at 10:54 AM, < fir...@li...> wrote: > Send Firebird-net-provider mailing list submissions to > fir...@li... > > 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 > fir...@li... > > You can reach the person managing the list at > fir...@li... > > 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 <rds...@gm...> > To: fir...@li... > Subject: [Firebird-net-provider] Error reading data from the > connection Re: Firebird-net-provider Digest, Vol 139, Issue 7 > Message-ID: > <CAMG8wxgcL1RM2EWhX3pf46Kcmr+Tya=Yb7ef8gPjN0yJcRnhAg@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > On Sat, Nov 18, 2017 at 7:31 PM, < > fir...@li...> wrote: > > > Send Firebird-net-provider mailing list submissions to > > fir...@li... > > > > 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 > > fir...@li... > > > > You can reach the person managing the list at > > fir...@li... > > > > 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 <rds...@gm...> > > To: fir...@li... > > Subject: [Firebird-net-provider] Error reading data from the > > connection Re: Firebird-net-provider Digest, Vol 139, Issue 6 > > Message-ID: > > <CAMG8wxj8BvBGE88rEvN=2zhg7-W9u-VSZPU_wtCJkok1WKrXgg@mail. > > gmail.com> > > Content-Type: text/plain; charset="utf-8" > > > > On Sat, Nov 18, 2017 at 5:46 PM, < > > fir...@li...> wrote: > > > > > Send Firebird-net-provider mailing list submissions to > > > fir...@li... > > > > > > 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 > > > fir...@li... > > > > > > You can reach the person managing the list at > > > fir...@li... > > > > > > 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 <ji...@ci...> > > > To: fir...@li... > > > 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 > > > > + Errors Count = 2 > > System.Collections.Generic.List<FirebirdSql.Data.Common.IscError> > > > > 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 > > > > IsWarning false 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.RuntimeMethodInfo} > > > > + Static members > > > > + Non-Public members > > > > Message "Error reading data > from > > the connection." string > > > > SQLSTATE "08006" > > string > > > > Source > > "FirebirdSql.Data.FirebirdClient" > > string > > > > StackTrace " at > > FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()\r\n at > > FirebirdSql.Data.FirebirdClient.FbDataReader.Read()\r\n at > > System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping > > mapping)\r\n at > > System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable > > datatable, String srcTable, DataReaderContainer dataReader, Int32 > > startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object > > parentChapterValue)\r\n at System.Data.Common.DataAdapter.Fill(DataSet > > dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, > Int32 > > maxRecords)\r\n at System.Data.Common.DbDataAdapter.FillInternal( > DataSet > > dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, > > String srcTable, IDbCommand command, CommandBehavior behavior)\r\n at > > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 > startRecord, > > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior > > behavior)\r\n at System.Data.Common.DbDataAdapter.Fill(DataSet > dataSet, > > String srcTable)\r\n at HMSMaster.FHMSMaster.TableS_N_ROWS_Fill(String > > tableS, Int64 nRows, Int64 iSkip, String strOrderBy) in > > D:\\HMS\\AppHMS\\SolnHMS\\HMSMaster\\FHMSMaster.cs:line 1294" > > string > > > > + TargetSite > > {FirebirdSql.Data.Common.DbValue[] > > Fetch()} System.Reflection.MethodBase > > {System.Reflection.RuntimeMethodInfo} > > > > + Static members > > > > + Non-Public members > > > > > Additional inputs: > > I observed that while copying 13,26,000 records from source in batches of > 50,000 each, exception was raised after copying 12,50,000. > So from the source I deleted the already copied 12,50,000 records and > resumed to copy the remaining 76,000. > This also failed. > Attempted versions: 6 Alpha 2, 5.12.0.0, 5.11.0.0 and 4.5.2.0. > However, I could manually insert the 76,000 records using flamerobin. > > Now to copy this particular table of the database I am using > FbCommand's ExecuteNonQuery to run a stored procedure which copies record > using Execute Statement On External database. > This works fine and faster. > > For the time being, I appear to have manoeuvred out of dead end. > > > Inputs from firebird-support helped me pinpoint the issue in my case: Use of default isolation level in FbTransaction. Changing to the under mentioned resolved my issue : tx = con.BeginTransaction( new FbTransactionOptions() { TransactionBehavior = FbTransactionBehavior.Concurrency | FbTransactionBehavior.NoWait } ); > > > > -- > > > 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 > > > > > > ------------------------------ > > > > > > Subject: Digest Footer > > > > > > _______________________________________________ > > > Firebird-net-provider mailing list > > > Fir...@li... > > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > > > > ------------------------------ > > > > > > End of Firebird-net-provider Digest, Vol 139, Issue 6 > > > ***************************************************** > > > > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > > > ------------------------------ > > > > ------------------------------------------------------------ > > ------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > ------------------------------ > > > > Subject: Digest Footer > > > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > ------------------------------ > > > > End of Firebird-net-provider Digest, Vol 139, Issue 7 > > ***************************************************** > > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > ------------------------------ > > End of Firebird-net-provider Digest, Vol 139, Issue 9 > ***************************************************** > |
