Re: [Firebird-net-provider] FbClient v4.0.30319

[E. D. E. J. <dix...@gm...>]

I finally got an error message on this issue.  Here is the data I pulled,
Maybe this will shed some light on what I'm doing wrong.

ErrorMsg: deadlock
ErrorData: Procedure=DataAdapterReturnDT|SprocName=USPVALIDATESESSION|GUID=7c3713d9-26bd-43f5-ba64-5bd1eb8e3fa1|NEWSESSIONTIMEOUT=20|

ErrorStack:    at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
694
   at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line
245
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at FirebirdDAO.DAO.DataAdapterFillDTWTrans(DataTable dt, String
sprocname, SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 629
   at FirebirdDAO.DAO.DataAdapterReturnDTWTrans(String sprocname,
SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 590
   at CBT.Models.DaoAccess.DataAdapterReturnDT(String procedurename,
SProcParam[] sprocparams, Guid guid, Int32 timeout, String controllerpath,
String ipaddr, String browserinfo, TransIsoLvl isolvl) in
c:\WebSites\CBT\CBT\Models\DaoAccess.cs:line 143

The transaction level is "Snapshot"

a follow up error, with the same transaction level about 11 minutes later:
ErrorMsg: lock conflict on no wait transaction
ErrorData: Procedure=DataAdapterReturnDT|SprocName=USPVALIDATESESSION|GUID=662a1981-a9e9-4fda-b287-3397197f0bbb|NEWSESSIONTIMEOUT=20|
ErrorStack:    at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
694
   at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line
245
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at FirebirdDAO.DAO.DataAdapterFillDTWTrans(DataTable dt, String
sprocname, SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 629
   at FirebirdDAO.DAO.DataAdapterReturnDTWTrans(String sprocname,
SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 590
   at CBT.Models.DaoAccess.DataAdapterReturnDT(String procedurename,
SProcParam[] sprocparams, Guid guid, Int32 timeout, String controllerpath,
String ipaddr, String browserinfo, TransIsoLvl isolvl) in
c:\WebSites\CBT\CBT\Models\DaoAccess.cs:line 143

Dixon


On Wed, Mar 19, 2014 at 3:48 PM, E. D. Epperson Jr
<dix...@gm...>wrote:

> When I hit this line:
> conn.Open();
> it breaks out of that block without throwing an exception.  Actually it
> breaks out of that class completely, but it doesn't return a datatable so
> my calling class experiences a datatable == null exception, which I handle.
>
>
> here is the code sample where I open the connection
>
>             try
>             {
>                 if (conn == null)
>                 {
>                     conn = new FbConnection(_connstr);  -- it breaks out
> here
>                 }
>                 switch (conn.State)
>                 {
>                     case ConnectionState.Closed:
>                         conn.Open();
>                         break;
>                     case ConnectionState.Broken:
>                     case ConnectionState.Connecting:
>                     case ConnectionState.Executing:
>                     case ConnectionState.Fetching:
>                         conn.Close();
>                         conn.Open();
>                         break;
>                 }
>                 return conn.State == ConnectionState.Open;
>             }
> ... then I handle any exception thrown here, except it never throws the
> exception.  I guess it just isn't opening the connection
>
> Dixon
>
>
> On Wed, Mar 19, 2014 at 3:36 PM, Jiri Cincura <di...@ci...> wrote:
>
>> On Wed, Mar 19, 2014 at 8:00 PM, E. D. Epperson Jr
>> <dix...@gm...> wrote:
>> > At some point during every day, after creating the FbConnection, I then
>> > Open.  It apparently throws an error, but my try/catch doesn't catch it.
>>
>> How do you know it throw an exception? Did you tried attaching
>> debugger to VS (from other VS)?
>>
>> --
>> Jiri {x2} Cincura (x2develop.com founder)
>> http://blog.cincura.net/ | http://www.ID3renamer.com
>>
>>
>> ------------------------------------------------------------------------------
>> Learn Graph Databases - Download FREE O'Reilly Book
>> "Graph Databases" is the definitive new guide to graph databases and their
>> applications. Written by three acclaimed leaders in the field,
>> this first edition is now available. Download your free book today!
>> http://p.sf.net/sfu/13534_NeoTech
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
>
> --
> Dixon Epperson
>



-- 
Dixon Epperson