Degraded performance Customers may experience intermittent errors using Community search. Our platform vendor is investigating.
It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
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
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.
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)
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.
Read moreHey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
Connect with like-minded Atlassian users at free events near you!
Find a groupConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
Start an AUGYou're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.