JIRA Database check takes too long

Hi,

Here is the snapshot of the logs from atlassian-jira.log file. 

2014-11-23 13:51:12,610 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2014-11-23 13:51:12,611 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
2014-11-23 13:51:12,681 localhost-startStop-1 INFO      [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher
2014-11-23 13:51:23,359 localhost-startStop-1 INFO      [core.entity.jdbc.DatabaseUtil] Database Product Name is Oracle
2014-11-23 13:51:23,359 localhost-startStop-1 INFO      [core.entity.jdbc.DatabaseUtil] Database Product Version is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
2014-11-23 13:51:23,359 localhost-startStop-1 INFO      [core.entity.jdbc.DatabaseUtil] Database Driver Name is Oracle JDBC driver
2014-11-23 13:51:23,359 localhost-startStop-1 INFO      [core.entity.jdbc.DatabaseUtil] Database Driver Version is 11.2.0.2.0
2014-11-23 13:54:24,958 localhost-startStop-1 INFO      [atlassian.jira.startup.DatabaseChecklistLauncher] JIRA database startup checks completed successfully.
2014-11-23 13:54:24,959 localhost-startStop-1 INFO      [jira.config.database.DatabaseConfigurationManagerImpl] Now running Post database-configuration launchers
2014-11-23 13:54:26,745 localhost-startStop-1 INFO      [jira.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/opt/jira/jira_6.2.7/dbconfig.xml
2014-11-23 13:55:25,865 localhost-startStop-1 INFO      [atlassian.jira.startup.DatabaseLauncher] Database transactions enabled: true
2014-11-23 13:55:25,867 localhost-startStop-1 INFO      [atlassian.jira.startup.DatabaseLauncher] Using JIRA's default for database transaction isolation level: 2
2014-11-23 13:55:25,910 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger]
Database configuration OK

 

I notice that the database check too long for my JIRA instance. What are the possible causes?

 

Regards,

Vijay

3 answers

1 accepted

0 votes
Chris Fuller Atlassian Team Nov 29, 2014

I assume you mean the three minute pause here:

2014-11-23 13:51:23,359 localhost-startStop-1 INFO      [core.entity.jdbc.DatabaseUtil] Database Driver Version is 11.2.0.2.0
2014-11-23 13:54:24,958 localhost-startStop-1 INFO      [atlassian.jira.startup.DatabaseChecklistLauncher] JIRA database startup checks completed successfully.

 

My suspicion is that what you are really seeing is the automatic export that's taken by default during system startups.  I don't think it logs anything.

If you don't want it to do this, see https://confluence.atlassian.com/display/JIRA060/Disabling+Auto-Export for information on how to disable it, and I suspect that 3 minute pause will go away.

Naturally, that means it won't be taking this backup at startup anymore, so will want to arrange for an alternate backup strategy, if you haven't already done so.

Helpful but didnt implement it back then. Upgraded to 6.4 and now I can schedule Backup :) Issue resolved.

1 votes
Renjith Pillai Community Champion Nov 29, 2014

Also check if the database disk is performing good enough https://confluence.atlassian.com/display/JIRAKB/Testing+Disk+Access+Speed.

And what is the size of your JIRA instance (Database statistics in JIRA System Info)

0 votes

What do you mean "database check too long"?  It looks fine to me from your log.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,755 views 11 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot