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

Accepted Answer
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.

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 Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

21,509 views 2 7
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