Questions about the Database for JIRA

[Taylor Huston]

So I am not exactly a DBA, but I know my way around a basic SQL query. Trying to troubleshoot an issue with a Jira instance, and this kind of led me down a rabbit hole that raised some questions that Google can't solve for me.

Right now in the instance I am working on, some things aren't lining up. For example:

The instance has 90245 issues in it, but 'select count(*) from jiraissue;' returns 83989.

The Instance has over 110 projects, but 'select count(*) from project;' returns 98.

There is a Project with the key of 'CON' and an ID of 12403, according to the UI. But I can't find it anywhere in the 'project' table. There's a totally different Project in that table with the same key, but it's pname doesn't line up with anything in the actual instance.

Can't tell if I am going insane or if there's something I am missing?

[Alexey Matveev]

Hello,

Reindex your Jira. cog item -> system -> reindexing

[Alexey Matveev]

Hello,

Go to cog item -> system. and then reindex your Jira in the reindexing option.