Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Couldn't rollback ADO.NET connection. Transaction not connected, or was disconnected #2290

Open
silhanji opened this issue Feb 29, 2024 · 0 comments

Comments

@silhanji
Copy link

Describe the bug

I have clustered Quartz deployed against clustered Maria DB in ASP.NET Core Server. Once in a while following message appears in log:

2024-02-29 00:04:05.441 +01:00 [ERR] Couldn't rollback ADO.NET connection. Transaction not connected, or was disconnected
System.InvalidOperationException: Transaction not connected, or was disconnected
   at Quartz.Impl.AdoJobStore.ConnectionAndTransactionHolder.CheckNotZombied()
   at Quartz.Impl.AdoJobStore.ConnectionAndTransactionHolder.Rollback(Boolean transientError)

This does not seem to have any impact on the app, I did not noticed any failed jobs. However I am curious if this could be symptom of some bad configuration on my side?

Also I don't notice any database outages, which would explain the error.

Version used

Quartz 3.8.0
Quartz.AspNetCore 3.8.0
Quartz.Serialization.Json 3.8.0

To Reproduce

Not sure how to reproduce, this is all of my Quartz configuration:

services.AddQuartz(options =>
{
	options.SchedulerName = "Scheduler";
	options.SchedulerId = "AUTO";
	
	options.UseDefaultThreadPool(threadPool =>
	{
		threadPool.MaxConcurrency = 10;
	});
	
	options.UsePersistentStore(store =>
	{
		store.UseMySqlConnector(mysql =>
		{
			mysql.ConnectionString = "CONNECTION_STRING";
			mysql.TablePrefix = "QRTZ_";
		});
		
		store.UseProperties = true;
		store.UseSerializer<JsonObjectSerializer>();
		
		store.UseClustering();
	});
	
	
});
services.AddQuartzServer(options =>
{
	options.WaitForJobsToComplete = true;
});

Expected behavior

No error entry in log.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant