[JRASERVER-64325] Jira fails to start due to duplicate job IDs in the clusteredjob table

Type: Bug
Resolution: Fixed
Priority: Highest (View bug fix roadmap)
Fix Version/s: 7.4.6, 7.5.4, 7.7.0, 7.2.13, 7.6.2, 7.3.9
Affects Version/s: 7.1.4, 7.1.10, 7.2.8, 7.3.5, 7.3.6, 7.3.7, 7.3.8, 7.4.1, 7.5.3
Component/s: Scheduled Tasks
Labels:
- affects-server
- ee
- l1l2
- ps-hot
- pse-request

Fixed in Long Term Support Release/s:

Download 7.6
Introduced in Version:
7.01
Support reference count:
55
Symptom Severity:
Severity 1 - Critical
UIS:
1,303
Bug Fix Policy:
View Atlassian Server bug fix policy
Current Status:

Hide

Atlassian Update – 12 January 2018

Hi everyone,

All the Jira versions, which have the bug fixed, are now released.
Wish you a smooth upgrade.

Cheers,
Ignat Alexeyenko
Jira bugmaster.

Show
Atlassian Update – 12 January 2018 Hi everyone, All the Jira versions, which have the bug fixed, are now released. Wish you a smooth upgrade. Cheers, Ignat Alexeyenko Jira bugmaster.

Summary

Caesium method getJobDetails calls clusteredJobDao.find(jobId) and expects single uniq value from DB, while clusteredjob table does not ensure this.

Steps to Reproduce

Create duplicated records in table
Restart JIRA

Expected Results

JIRA works fine

Actual Results

JIRA is failing to start with the following errors:

2017-03-03 02:26:53,599 Structure-Jobs-1143be31 Queue-Thread#1 ERROR anonymous     [c.a.c.manager.application.ApplicationServiceGeneric] com.atlassian.cache.CacheException: java.lang.IllegalStateException: Too many rows found for query on ClusteredJob
    	row1: OfBizClusteredJob[id=81932,delegate=ImmutableClusteredJob[jobId=com.atlassian.jira.crowd.embedded.JiraDirectoryPollerManager.10001,jobRunnerKey=com.atlassian.jira.crowd.embedded.JiraDirectoryPollerManager,schedule=Schedule[type=INTERVAL,intervalScheduleInfo=IntervalScheduleInfo[firstRunTime=Fri Mar 03 01:56:51 PST 2017,intervalInMillis=3540000]],nextRunTime=Fri Mar 03 01:56:51 PST 2017,version=1,rawParameters=[ .. ]
row2:
	OfBizClusteredJob[id=82235,delegate=ImmutableClusteredJob[jobId=com.atlassian.jira.crowd.embedded.JiraDirectoryPollerManager.10001,jobRunnerKey=com.atlassian.jira.crowd.embedded.JiraDirectoryPollerManager,schedule=Schedule[type=INTERVAL,intervalScheduleInfo=IntervalScheduleInfo[firstRunTime=Fri Mar 03 01:56:51 PST 2017,intervalInMillis=3540000]],nextRunTime=Fri Mar 03 01:56:51 PST 2017,version=1,rawParameters=[ .. ]]
com.atlassian.crowd.exception.DirectoryInstantiationException: com.atlassian.cache.CacheException: java.lang.IllegalStateException: Too many rows found for query on 
	at com.atlassian.crowd.directory.loader.CacheableDirectoryInstanceLoader.getDirectory(CacheableDirectoryInstanceLoader.java:92)
	at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.getDirectoryImplementation(DirectoryManagerGeneric.java:272)
....
Caused by: com.atlassian.cache.CacheException: java.lang.IllegalStateException: Too many rows found for query on ClusteredJob
	row1: OfBizClusteredJob[id=81932,delegate=ImmutableClusteredJob[jobId=com.atlassian.jira.crowd.embedded.JiraDirectoryPollerManager.10001,jobRunnerKey=com.atlassian.jira.crowd.embedded.JiraDirectoryPollerManager,schedule=Schedule[type=INTERVAL,intervalScheduleInfo=IntervalScheduleInfo[firstRunTime=Fri Mar 03 01:56:51 PST 2017,intervalInMillis=3540000]],nextRunTime=Fri Mar 03 01:56:51 PST 2017,version=1,rawParameters=
row2:
	OfBizClusteredJob[id=82235,delegate=ImmutableClusteredJob[jobId=com.atlassian.jira.crowd.embedded.JiraDirectoryPollerManager.10001,jobRunnerKey=com.atlassian.jira.crowd.embedded.JiraDirectoryPollerManager,schedule=Schedule[type=INTERVAL,intervalScheduleInfo=IntervalScheduleInfo[firstRunTime=Fri Mar 03 01:56:51 PST 2017,intervalInMillis=3540000]],nextRunTime=Fri Mar 03 01:56:51 PST 2017,version=1,rawParameters=
	at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl$1.consume(SelectQueryImpl.java:198)
	at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.forEach(SelectQueryImpl.java:231)
	at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.consumeWith(SelectQueryImpl.java:214)
	at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.singleValue(SelectQueryImpl.java:191)
	at com.atlassian.jira.scheduler.OfBizClusteredJobDao.find(OfBizClusteredJobDao.java:88)
	at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.getJobDetails(CaesiumSchedulerService.java:230)
	at com.atlassian.scheduler.core.DelegatingSchedulerService.getJobDetails(DelegatingSchedulerService.java:97)
	at com.atlassian.jira.crowd.embedded.JiraDirectoryPollerManager.hasPoller(JiraDirectoryPollerManager.java:64)
	at com.atlassian.crowd.manager.directory.monitor.DirectoryMonitorManagerImpl.hasMonitor(DirectoryMonitorManagerImpl.java:108)
	at com.atlassian.crowd.directory.loader.DbCachingRemoteDirectoryInstanceLoader.getDirectory(DbCachingRemoteDirectoryInstanceLoader.java:113)
...

Notes

Related Indexes for clusteredjob table:

"pk_clusteredjob" PRIMARY KEY, btree (id)
"clusteredjob_jobid_idx" btree (job_id)

Workaround

Delete duplicated records, see https://confluence.atlassian.com/jirakb/jira-fails-to-start-due-to-too-many-rows-found-for-query-on-clusteredjob-800702971.html

is caused by

JRASERVER-64326 JIRA CaesiumSchedulerService can insert duplicated records into clusteredjob

Gathering Impact

is related to

JSDSERVER-5302 Service Desk customer notification audit

Closed

relates to

JSDSERVER-5273 Notifications that contain only an image will break SD notification job when using Oracle database

Closed

RAID-722 You do not have permission to view this issue

mentioned in: JIRA Software 7.6.x upgrade notes; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...

(36 mentioned in)

Form Name

Benito Picarelli made changes - 01/Jun/2023 2:37 PM

Remote Link

Original: This issue links to "RAID-722 (JIRA Server)" [ 330875 ]

New: This issue links to "RAID-722 (JIRA Server (Bulldog))" [ 330875 ]

Julien Rey made changes - 22/Feb/2021 4:43 PM

Remote Link

Original: This issue links to "Page (Confluence)" [ 415461 ]

set-jac-bot made changes - 22/May/2020 8:27 AM

Fixed in Enterprise Release/s

New: [Download 7.6|https://confluence.atlassian.com/enterprise/atlassian-enterprise-releases-948227420.html]

set-jac-bot made changes - 26/Sep/2019 1:01 AM

Summary

Original: Duplicate job IDs in clusteredjob table prevents JIRA from starting

New: Jira fails to start due to duplicate job IDs in the clusteredjob table

Tomasz Bartyzel made changes - 20/May/2019 12:55 PM

Remote Link

Original: This issue links to "Page (Atlassian Documentation)" [ 391684 ]

Tomasz Bartyzel made changes - 19/Apr/2019 6:25 AM

Remote Link

Original: This issue links to "Page (Atlassian Documentation)" [ 391125 ]

Tomasz Bartyzel made changes - 19/Apr/2019 6:25 AM

Remote Link

Original: This issue links to "Page (Atlassian Documentation)" [ 391124 ]

Bugfix Automation Bot made changes - 28/Mar/2019 12:22 AM

Minimum Version

New: 7.01

Julien Rey made changes - 14/Mar/2019 9:38 PM

Remote Link

New: This issue links to "Page (Confluence)" [ 415461 ]

Luciano Fagundes (Inactive) made changes - 10/Jan/2019 7:04 PM

Affects Version/s

New: 7.5.3 [ 75316 ]

Assignee:: Przemyslaw Czuj

Reporter:: Andriy Yakovlev [Atlassian]

Affected customers:: 67 This affects my team

Watchers:: 84 Start watching this issue

Created:: 07/Mar/2017 1:23 PM

Updated:: 01/Jun/2023 2:37 PM

Resolved:: 20/Dec/2017 8:12 PM

Details

Description

Summary

Steps to Reproduce

Expected Results

Actual Results

Notes

Workaround

Attachments

Issue Links

Forms

Activity

People

Dates