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 <rdsc1...@gmail.com>
> 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:
> <CAMG8wxgcL1RM2EWhX3pf46Kcmr+Tya=Yb7ef8gPjN0yJcRnhAg@mail.
> 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 <rdsc1...@gmail.com>
> > 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:
> > <CAMG8wxj8BvBGE88rEvN=2zhg7-W9u-VSZPU_wtCJkok1WKrXgg@mail.
> > 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 <j...@cincura.net>
> > > 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
> >
> > + 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
> > > Firebird-net-provider@lists.sourceforge.net
> > > 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
> > Firebird-net-provider@lists.sourceforge.net
> > 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
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------
>
> End of Firebird-net-provider Digest, Vol 139, Issue 9
> *****************************************************
>
------------------------------------------------------------------------------
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
