Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

After migrating JIRA to new server application not working properly

Arvindh Raj Neelakandan September 25, 2023

Recently we migrated our JIRA application which was running in one linux machine to other. 
Steps carried out:
1. Made the service down in the server

2. Dumped the database

3. Sync the Files under /data directory and /opt directory to the new server

4. Import the database in the new server

5. Point the DNS to the new machine 

6. Start the service in the new server 

Everything went fine, but application took long time to load. 

7. After that I ran re-index  in the admin section also which ran for 4hours+ and finished success. 

Now, our problem is that we cannot assign tickets to others also move the ticket to next change or even comment in the JIRA issue comment section. 

What I am missing in the whole procedure followed? 
Whether the database collation 'utf8mb3_general_ci' is an issue?

1 answer

0 votes
Sebastian Krzewiński
Community Champion
September 25, 2023

Hi @Arvindh Raj Neelakandan 

 

1. Database is on the same server as application? DB Config is the same?

2. Application is working on the similar server (same HDD type, same RAM and CPU values)?

 

For me it looks like issues with server (worse parameters than previous one) or disk issues (slower disk) or wrong db configuration.

 

Regards,

Seba

Arvindh Raj Neelakandan September 26, 2023

1. No database is running in new server but, same configurations as old server. 

2. Application started working but, I face issues as dupicate entry.
(SQL Exception while executing the following:INSERT INTO changegroup (ID, issueid, AUTHOR, CREATED) VALUES (?, ?, ?, ?) (Duplicate entry '3320008' for key 'PRIMARY'))

I checked and removed the duplicate tables and also this error priests. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events