Hangfire.FluentNHibernateStorage 1.2.1050 errors

Peter_YVAW4N7W6b · May 3, 2022, 4:29pm

Hangfire.FluentNHibernateStorage 1.2.1050 reported the follow errors against an Oracle 19 database. I can provide more information about the Oracle environment as needed.

Going back to 1.2.1020 of Hangfire.FluentNHibernateStorage resolved the errors.

2022-05-02 13:35:06,490 [1] ERROR NHibernate.Transaction.ITransactionFactory - System transaction prepare phase failed
System.InvalidOperationException: Batcher still has opened ressources at time of processing from system transaction.
at NHibernate.AdoNet.ConnectionManager.BeginProcessingFromSystemTransaction(Boolean allowConnectionUsage)
at NHibernate.Transaction.AdoNetWithSystemTransactionFactory.SystemTransactionContext.Prepare(PreparingEnlistment preparingEnlistment)
2022-05-02 13:35:06,772 [1] WARN Hangfire.FluentNHibernateStorage.FluentNHibernateJobStorage - Issue with dual table
System.Transactions.TransactionAbortedException: The transaction has aborted. —> System.InvalidOperationException: Batcher still has opened ressources at time of processing from system transaction.
at NHibernate.AdoNet.ConnectionManager.BeginProcessingFromSystemTransaction(Boolean allowConnectionUsage)
at NHibernate.Transaction.AdoNetWithSystemTransactionFactory.SystemTransactionContext.Prepare(PreparingEnlistment preparingEnlistment)
— End of inner exception stack trace —
at System.Transactions.TransactionStateAborted.EndCommit(InternalTransaction tx)
at System.Transactions.CommittableTransaction.Commit()
at System.Transactions.TransactionScope.InternalDispose()
at System.Transactions.TransactionScope.Dispose()
at Hangfire.FluentNHibernateStorage.FluentNHibernateJobStorage.UseStatelessSessionInTransaction[T](Func`2 func)
at Hangfire.FluentNHibernateStorage.FluentNHibernateJobStorage.EnsureDualHasOneRow()
2022-05-02 13:35:06,787 [1] ERROR CI.HS.myMeal.Services.HangfireService - Failure starting Hangfire
System.Transactions.TransactionAbortedException: The transaction has aborted. —> System.InvalidOperationException: Batcher still has opened ressources at time of processing from system transaction.
at NHibernate.AdoNet.ConnectionManager.BeginProcessingFromSystemTransaction(Boolean allowConnectionUsage)

aschenta · May 3, 2022, 7:32pm

That package is not from Hangfire so I’m not sure they’ll be able to help you here.

Searching the error brings up:

github.com/nhibernate/nhibernate-core

Using System.Transaction with IStatelessSession doesn't always flush batches to database

opened 08:05PM - 06 May 21 UTC

closed 06:11PM - 29 May 21 UTC

jklawrence

t: Bug r: Fixed c: Core p: Major

I'm having two issues with using `System.Transaction` and `IStatelessSession` to…gether. First, it doesn't work at all with the default `UseConnectionOnSystemTransactionPrepare` value of `true`. Committing a transaction like: ``` using (var transaction = new TransactionScope()) { using (var session = sessionFactory.OpenStatelessSession()) { // save a change here } transaction.Complete(); } ``` always results in this exception: ``` System.Transactions.TransactionAbortedException: The transaction has aborted. ---> System.InvalidOperationException: Batcher still has opened ressources at time of processing from system transaction. at NHibernate.AdoNet.ConnectionManager.BeginProcessingFromSystemTransaction(Boolean allowConnectionUsage) at NHibernate.Transaction.AdoNetWithSystemTransactionFactory.SystemTransactionContext.Prepare(PreparingEnlistment preparingEnlistment) --- End of inner exception stack trace --- at System.Transactions.TransactionStateAborted.EndCommit(InternalTransaction tx) at System.Transactions.CommittableTransaction.Commit() at System.Transactions.TransactionScope.InternalDispose() at System.Transactions.TransactionScope.Dispose() at StatelessBatchFlush.Program.ValidateBatching(ISessionFactory sessionFactory) in C:\Projects\NHibernate-Stateless\Program.cs:line 68 ``` Setting `UseConnectionOnSystemTransactionPrepare=false` does cause this exception to go away, but with that set the last batch of items does not get flushed to the database. `IStatelessSession` does not expose a `Flush()` method, but we've found that calling `session.GetSessionImplementation().Flush()` before completing the transaction is a workaround for this. I've created a small console app to demo the problems I'm having here: https://github.com/jklawrence/NHibernate-Stateless These same scenarios work fine when using an NHibernate transaction instead of System.Transaction. NHibernate version: 5.3.8

You could try updating FluentNHibernate/NHibernate. Otherwise you’re probably out of luck.

Topic		Replies	Views
Hangfire.FluentNHibernateStorage launching problems question	0	506	October 29, 2021
OutOfMemoryException question recurring , queues	0	1475	September 14, 2018
Transaction and ASP.NET MVC5 question	3	3048	May 2, 2015
Mono 3.12 support with SQL Server? bug?	1	2440	March 9, 2015
Exception when processing background jobs bug? serialization	7	7498	July 27, 2015

Hangfire.FluentNHibernateStorage 1.2.1050 errors

Related topics