firebird-net-provider Mailing List for Firebird

Wrong computation of IsAlive in connection pool
-----------------------------------------------

                 Key: DNET-799
                 URL: http://tracker.firebirdsql.org/browse/DNET-799
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.12.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/75

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Hi,
How can I clear all connection pools.
Regards,
Rajiv

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

EF Core Migrations support
--------------------------

                 Key: DNET-797
                 URL: http://tracker.firebirdsql.org/browse/DNET-797
             Project: .NET Data provider
          Issue Type: Sub-task
          Components: Entity Framework Core
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

EF Core scaffolding support
---------------------------

                 Key: DNET-798
                 URL: http://tracker.firebirdsql.org/browse/DNET-798
             Project: .NET Data provider
          Issue Type: Sub-task
          Components: Entity Framework Core
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira