JIRA Database check takes too long

[Vijay Khacharia]

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

[crf · Accepted solution]

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.

[Vijay Khacharia]

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

[Renjith Pillai]

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)

[Nic Brough -Adaptavist-]

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