Community
Q&A
Jira
Questions
urgent please help me I deleted a lot of data from the jiraissue table.

urgent please help me I deleted a lot of data from the jiraissue table.

I deleted a lot of data from the jiraissue table. From the database.
The backup of the 'jiraissue' table is the 'jiraissue2' table
I am importing data from table 'jiraissue2' to table 'jiraissue'.
but i can't see that issue on all issue in jira

1 answer

1 accepted

0 votes

Answer accepted

First, you should NEVER do anything with the database except through the UI or API. That said, have you tried re-indexing. If so and that didn't work call Atlassian support, but I expect they will tell you to restore your database from the last COMPLETE backup. You should be backing up the database using the built in backup process. The database has pointers everywhere so deleting something has cascading impacts.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I agree
thank you for your attention.
I haven't tried the 're-index' operation.
How can I re-index?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

check https://confluence.atlassian.com/adminjiraserver/search-indexing-938847710.html

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Thank you very much. You saved me.:)

The 're-index' process was the solution for me.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Glad it work., Just don't do anything with the database again. You might not be so lucky

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS

Community showcase