JIRA Services Fail due to 'Passed List had more than one value' Error
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
The mail queue must be flushed manually. Flushing the queue manually works (from
Administration > Mail Queue).LDAP synchronisation fails and cannot complete successfully.
The below may be found within the atlassian-jira.log:
1
2
3
4
5
6
Exception in thread "JiraQuartzScheduler_QuartzSchedulerThread" java.lang.IllegalArgumentException: Passed List had more than one value.
at org.ofbiz.core.entity.EntityUtil.getOnly(EntityUtil.java:58)
at com.atlassian.scheduler.OfBizJobStore.persistTrigger(OfBizJobStore.java:335)
at com.atlassian.scheduler.OfBizJobStore.triggerFired(OfBizJobStore.java:681)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:307)
...Cause
There are duplicate Quartz triggers saved in the database which is blocking the service from proceeding.
Resolution
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Shutdown JIRA.
Run the following SQL query in the JIRA database to find the duplicate schedule triggers:
1select trigger_name, count(*) as cn from qrtz_triggers group by trigger_name having cn>1;For the duplicate schedule triggers found in the STEP 3, run the following SQL statement to get the duplicated ID's:
1select id, trigger_name from qrtz_triggers where trigger_name = <the trigger_name found in STEP 2>;Delete one of duplicate rows from qrtz_triggers table by ID:
1delete from qrtz_triggers where id = <one of duplicate triggers' ids found in STEP 3>;Restart JIRA instance.
Reindex JIRA (Administration -> System -> Indexing).
ℹ️ Please see our Troubleshooting LDAP User Management documentation for further assistance with diagnosing LDAP problems.
Was this helpful?