Re: [Firebird-net-provider] Error code 335544332 invalid transaction handle (expecting explicit transaction start)
Ralf, > Tried the snapshot and can't reproduce the problem currently. I presumably > misinterpreted the tracker info's. According to: https://github.com/FirebirdSQL/firebird/commits/B3_0_Release The fix has been committed on July 13, so the current Windows snapshot from July 29 should include that. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > > -Ursprüngliche Nachricht- > Von: Ralf Jansen [mailto:ralf.jan...@mailstore.com] > Gesendet: Donnerstag, 4. August 2016 14:55 > An: For users and developers of the Firebird .NET providers > <firebird-net-provider@lists.sourceforge.net> > Betreff: Re: [Firebird-net-provider] Error code 335544332 invalid transaction > handle (expecting explicit transaction start) > > Thanks Thomas, > >>From where to get that? The snapshot build on firebirdsql.org is older than >>the tracker case. So the fix is presumably not in there. > I could get the master from Github but the recent commit history doesn't look > like CORE-5307 has been fixed (at least it's not stated directly). > > > -Ursprüngliche Nachricht- > Von: Thomas Steinmaurer [mailto:t...@iblogmanager.com] > Gesendet: Donnerstag, 4. August 2016 14:15 > An: For users and developers of the Firebird .NET providers > <firebird-net-provider@lists.sourceforge.net> > Betreff: Re: [Firebird-net-provider] Error code 335544332 invalid transaction > handle (expecting explicit transaction start) > > On 04.08.2016 14:13, Thomas Steinmaurer wrote: >> Ralf, >> >>> I recently switched from an older provider version (2.x something) to >>> the current 5.0.5.0 build and use it in an embedded scenario. >>> >>> In that process I also switched from FB 2.5 to 3.0 >>> >>> >>> >>> I have stability problems when the system gets under heavy load with >>> concurrent transactions/connections. >>> >>> I receive 335544332 errors (invalid transaction handle) from random >>> locations. >>> >>> >>> >>> Any pointers at what to look? >> >> Quoting Dmitry Yemanov in firebird-support on July 12, 2016: >> >> "This appears to be a bug in Firebird 3, being researched right now. I >> hope to have the fix committed in a day or two." > > Found the CORE issue now: > http://tracker.firebirdsql.org/browse/CORE-5307 > > Marked as fixed, thus give a recent 3.0 snapshot a try. > > > > -- > With regards, > Thomas Steinmaurer > http://www.upscene.com/ > > Professional Tools and Services for Firebird FB TraceManager, IB LogManager, > Database Health Check, Tuning etc. > > -- > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > -- > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > -- > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error code 335544332 invalid transaction handle (expecting explicit transaction start)
On 04.08.2016 14:13, Thomas Steinmaurer wrote: > Ralf, > >> I recently switched from an older provider version (2.x something) to >> the current 5.0.5.0 build and use it in an embedded scenario. >> >> In that process I also switched from FB 2.5 to 3.0 >> >> >> >> I have stability problems when the system gets under heavy load with >> concurrent transactions/connections. >> >> I receive 335544332 errors (invalid transaction handle) from random >> locations. >> >> >> >> Any pointers at what to look? > > Quoting Dmitry Yemanov in firebird-support on July 12, 2016: > > "This appears to be a bug in Firebird 3, being researched right now. I > hope to have the fix committed in a day or two." Found the CORE issue now: http://tracker.firebirdsql.org/browse/CORE-5307 Marked as fixed, thus give a recent 3.0 snapshot a try. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error code 335544332 invalid transaction handle (expecting explicit transaction start)
Ralf, > I recently switched from an older provider version (2.x something) to > the current 5.0.5.0 build and use it in an embedded scenario. > > In that process I also switched from FB 2.5 to 3.0 > > > > I have stability problems when the system gets under heavy load with > concurrent transactions/connections. > > I receive 335544332 errors (invalid transaction handle) from random > locations. > > > > Any pointers at what to look? Quoting Dmitry Yemanov in firebird-support on July 12, 2016: "This appears to be a bug in Firebird 3, being researched right now. I hope to have the fix committed in a day or two." -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trace API use cases
On Thu, Dec 16, 2010 at 09:02, Kjell Rilbe kjell.ri...@datadia.se wrote: I would probably want to do this per connection. Not possible (directly) with current API. Just speaking from the Trace API, you could start a trace session with the connection_id configuration parameter properly set. Just an idea. ;-) -- With regards, Thomas Steinmaurer Upscene Productions http://www.upscene.com http://blog.upscene.com/thomas/ Download LogManager Series, FB TraceManager today! Continuous Database Monitoring Solutions supporting Firebird, InterBase, Advantage Database, MS SQL Server and NexusDB! -- Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trace API use cases
On Thu, Dec 16, 2010 at 09:50, Thomas Steinmaurer t...@iblogmanager.com wrote: Just speaking from the Trace API, you could start a trace session with the connection_id configuration parameter properly set. Just an idea. ;-) The problem would be connection pooling in .NET. :\ So, for an established connection, CURRENCT_CONNECTION isn't constant/stable? Or, I guess an exisiting connection with a given CURRENT_CONNECTION gets re-used later on? -- With regards, Thomas Steinmaurer Upscene Productions http://www.upscene.com http://blog.upscene.com/thomas/ Download LogManager Series, FB TraceManager today! Continuous Database Monitoring Solutions supporting Firebird, InterBase, Advantage Database, MS SQL Server and NexusDB! -- Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trace Database Log
Hi Dean, I want to see all the transactions made aginst the datase like: All the Select, Insert Update, Delete statements with Time. This is not really a Firebird.NET question, but I think your best bet would be to use triggers. Whenever a SELECT, UPDATE, INSERT or DELETE statement is executed, set up a trigger to save the data into an audit table. Which can be done manually (boring and error-prone) or via our product IB LogManager. http://www.upscene.com/products/audit/iblm_main.htm -- Best Regards, Thomas Steinmaurer LogManager Series - Logging/Auditing Suites supporting InterBase, Firebird, Advantage Database, MS SQL Server and NexusDB V2 Upscene Productions http://www.upscene.com - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Out this weeknd
Hello Carlos, I will be in Madrid this weekend and will have no chance to answer questions over the weekend :D Isn't the conference in Prague? ;-) Regards, Thomas - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS 2005 Prof. integration and Firebird
Hi Carlos, - Visual Studio 2005 Professional installed - Visual Studio 2005 SDK from October 2005 installed Install the April one that is the latest stable one if i'm not worng :P Works ok now with the April SDK. Thanks for your help! Regards, Thomas --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS 2005 Prof. integration and Firebird .NET provider 2 RC4
Hello Carlos, - Visual Studio 2005 Professional installed - Visual Studio 2005 SDK from October 2005 installed Install the April one that is the latest stable one if i'm not worng :P I've changed the two path occurences in FirebirdDDEXProvider.reg to: C:\\Program Files\\FirebirdClient Add \\ at the end of the path and retry, please. Whenever I click on the Connect to Database button in the Server Explorer in VS2005, I get the following error message: An unexpected error occured in the .NET framework data provider for Firebird. Please contact the provider vendor to resolve this problem. What is the message that gets shown in the Windows Event Log ?? Will check tomorrow, because I don't have access to my day job PC at the moment. Thanks, Thomas --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider