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
<dixonepper...@gmail.com>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 <disk...@cincura.net> wrote:
>
>> On Wed, Mar 19, 2014 at 8:00 PM, E. D. Epperson Jr
>> <dixonepper...@gmail.com> 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
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
>
> --
> Dixon Epperson
>
--
Dixon Epperson
------------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
