JIRA health check include the integrity between tables and sequence_value_item

Description

Problem

Data in sequence_value_item table is not consistent with other tables, for examples

MaxID: 861886 > SEQ_NAME_OptionConfiguration: 861700 which is the problem.

Suggested Solution

It will be really useful to include an integrity check on the id value within the table sequence_value_item and all related tables needs it to provide the next ID. It will give the administrator the indication potential issue and fix it with a maintenance window.

Environment

None

Assignee

Unassigned

Reporter

Yilin Mo

Components

None

Add-on Type

None

Team

None

CC

None

Risk factor

None

Affected Product/s

None

Priority

Major
Configure