Menu
▾
▴
[Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 7
|
From: LtColRDSChauhan <rds...@gm...> - 2017-11-23 05:24:57
|
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. > > > -- > > 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 > ***************************************************** > |
