Duplicate key error in server logs

[Segi]

I am seeing this error every minute in my server logs since upgrading to 5.3.2:

Code: Select all

Mon Mar 05 03:41:46: ERROR Scheduler error:  error checking for scheduled tasks to be run
com.ebasetech.ufs.utility.PersistenceException: Error inserting runtime scheduled task runtime record, The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'RUNTIME_SCHEDULED_TASKS_INX' defined on 'RUNTIME_SCHEDULED_TASKS'.
	at com.ebasetech.ufs.runtime.scheduler.ScheduledTaskRuntimeRepository.insertRuntimeTaskToRepository(ScheduledTaskRuntimeRepository.java:144)
	at com.ebasetech.ufs.runtime.scheduler.RuntimeScheduledTask.insertRuntimeTasks(RuntimeScheduledTask.java:386)
	at com.ebasetech.ufs.runtime.scheduler.RuntimeScheduledTask.applyScheduledTaskChangesToDatabase(RuntimeScheduledTask.java:240)
	at com.ebasetech.ufs.runtime.scheduler.Scheduler.detectScheduledTaskChanges(Scheduler.java:148)
	at com.ebasetech.ufs.runtime.scheduler.Scheduler.dispatcher(Scheduler.java:60)
	at com.ebasetech.ufs.runtime.scheduler.Scheduler.run(Scheduler.java:116)

[Jon]

See viewtopic.php?f=3&t=1227

[Segi]

I removed all of the scheduled tasks and re-added them 1 by one. I didn't find any duplicate IDs but the error has seem to gone away

Thanks for the help

[Segi]

I re-encountered this error today and found that I do in fact have 2 different scheduled tasks that have the same runtimeTaskIdentifier and I was able to figure out why this happened.

I recently duplicated one of my existing tasks in Verj Studio, gave it a new name and change the scheduled task properties but internally Verj did not assign it a new task identifier which is a bug in my opinion. Please fix this so that scheduled tasks generate a new runtimeTaskIdentifier

[Jon]

Agreed, we'll fix it. Thanks for finding this.