nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Ran server update to version 7. Running into database issues/errors

Jeff Kramer

Need immediate assistance to get Jira up and running on new version. Running into the following errors:

Error

Database

Error

Isolation level

What does this check do?

Checks if the SQL Server database is configured using the required isolation level.

Result

The database isolation level of READ_COMMITED_SNAPSHOT is OFF which is not supported by JIRA.

How can I resolve this?

Error

Collation

What does this check do?

Checks if the database and tables are configured using the required collation.

Result

The database collation 'SQL_Latin1_General_CP1_CI_AS' and table collation 'SQL_Latin1_General_CP1_CI_AS' are not supported by JIRA.

Accepted answers

All comments

Nic Brough -Adaptavist-

You need to turn the database flag on. See the link you've already posted there, that has full instructions.

Jeff Kramer

So following:

Stop JIRA, as if it is still running it will block any change of the isolation level.

Execute the below query, replacing JIRA-DATABASE with the database name to update the collation.

<span>ALTER</span> <span>DATABASE</span> <span>[</span>JIRA<span>-</span><span>DATABASE</span><span>]</span> <span>SET</span> READ_COMMITTED_SNAPSHOT <span>ON</span><span>;</span>

Verify the below SQL returns 1, which is the expected isolation level.

<span>SELECT</span> is_read_committed_snapshot_on <span>FROM</span> sys<span>.</span><span>databases</span> <span>WHERE</span> name <span>=</span> <span>'<JIRA-DATABASE>'</span><span>;</span>

Start JIRA, the isolation health check will now pass.

Can I change the collation type on the existing database or should I create a new database with the proper settings?

Jeff Kramer

Okay I created a new database, imported the old data to it and tried to connect it with the Jira config tool. I am now running into an error saving the config (access denied)?

Could someone please give me a call so we can work through this quickly? Thank You

Jeff Kramer

So I'm still stuck. New database...go to start Jira...Jira locks when trying to write to files. Here is the output from the start Jira command:

at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:4
0)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContain
er.java:698)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:646)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:631)
at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstanc
e(BasicComponentParameter.java:118)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(Com
ponentParameter.java:136)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleM
emberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getPa
rameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInje
ctor.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDepende
ncyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(
ConstructorInjector.java:364)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:9
1)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:4
0)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContain
er.java:698)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:646)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:631)
at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstanc
e(BasicComponentParameter.java:118)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(Com
ponentParameter.java:136)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleM
emberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getPa
rameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInje
ctor.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDepende
ncyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(
ConstructorInjector.java:364)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:9
1)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:4
0)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContain
er.java:698)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:646)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:631)
at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstanc
e(BasicComponentParameter.java:118)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(Com
ponentParameter.java:136)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleM
emberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getPa
rameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInje
ctor.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDepende
ncyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(
ConstructorInjector.java:364)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:9
1)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:4
0)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContain
er.java:698)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:646)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:631)
at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstanc
e(BasicComponentParameter.java:118)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(Com
ponentParameter.java:136)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleM
emberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getPa
rameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInje
ctor.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDepende
ncyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(
ConstructorInjector.java:364)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:9
1)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:4
0)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContain
er.java:698)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:646)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:631)
at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstanc
e(BasicComponentParameter.java:118)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(Com
ponentParameter.java:136)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleM
emberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getPa
rameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInje
ctor.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDepende
ncyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(
ConstructorInjector.java:364)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:9
1)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:4
0)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContain
er.java:698)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:646)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:631)
at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstanc
e(BasicComponentParameter.java:118)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(Com
ponentParameter.java:136)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleM
emberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getPa
rameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInje
ctor.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDepende
ncyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(
ConstructorInjector.java:364)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:9
1)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:4
0)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContain
er.java:698)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:646)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:631)
at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstanc
e(BasicComponentParameter.java:118)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(Com
ponentParameter.java:136)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleM
emberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getPa
rameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInje
ctor.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDepende
ncyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(
ConstructorInjector.java:364)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:9
1)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(Abs
tractBehavior.java:64)
at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:4
0)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContain
er.java:698)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:646)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContai
ner.java:677)
at com.atlassian.jira.component.CachingMutablePicoContainer.getComponent
(CachingMutablePicoContainer.java:137)
at com.atlassian.jira.ComponentManager.getComponent(ComponentManager.jav
a:484)
at com.atlassian.jira.component.ComponentAccessorWorker.getComponent(Com
ponentAccessorWorker.java:25)
at com.atlassian.jira.component.ComponentAccessor.getComponent(Component
Accessor.java:160)
at com.atlassian.jira.startup.ClusteringChecklistLauncher.start(Clusteri
ngChecklistLauncher.java:37)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(
DefaultJiraLauncher.java:128)
at com.atlassian.jira.startup.DefaultJiraLauncher$$Lambda$16/2056107478.
run(Unknown Source)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.d
oNowOrEnqueue(DatabaseConfigurationManagerImpl.java:298)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.d
oNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:194)
at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJi
raLauncher.java:121)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(Default
JiraLauncher.java:90)
at com.atlassian.jira.startup.DefaultJiraLauncher$$Lambda$2/508002497.ru
n(Unknown Source)
at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTi
mer.java:31)
at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLaunc
her.java:88)
at com.atlassian.jira.startup.LauncherContextListener.contextInitialized
(LauncherContextListener.java:79)
... 5 filtered
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.io.IOException: Unable to delete file: \Program Files\Atlassia
n\Application Data\JIRA\plugins\.osgi-plugins\felix\felix-cache\cache.lock
at org.apache.commons.io.FileUtils.forceDelete(FileUtils.java:1919)
at org.apache.commons.io.FileUtils.cleanDirectory(FileUtils.java:1399)
at org.apache.commons.io.FileUtils.deleteDirectory(FileUtils.java:1331)
at org.apache.commons.io.FileUtils.forceDelete(FileUtils.java:1910)
at org.apache.commons.io.FileUtils.cleanDirectory(FileUtils.java:1399)
... 186 more
2017-12-29 15:26:27,002 localhost-startStop-1 ERROR [c.a.j.web.dispatcher.J
iraWebworkActionDispatcher]

******************************************
JIRA startup failed, JIRA has been locked.
******************************************

29-Dec-2017 15:26:27.031 SEVERE [main] org.apache.catalina.valves.AccessLogValve
.open Failed to open access log file [D:\Program Files\Atlassian\JIRA\logs\acces
s_log.2017-12-29]
java.io.FileNotFoundException: \Program Files\Atlassian\JIRA\logs\access_log.
2017-12-29 (Access is denied)
at java.io.FileOutputStream.open0(Native Method)
at java.io.FileOutputStream.open(FileOutputStream.java:270)
at java.io.FileOutputStream.<init>(FileOutputStream.java:213)
at org.apache.catalina.valves.AccessLogValve.open(AccessLogValve.java:57
9)
at org.apache.catalina.valves.AccessLogValve.startInternal(AccessLogValv
e.java:609)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.StandardPipeline.startInternal(StandardPipel
ine.java:170)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.ja
va:931)
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.
java:262)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.StandardService.startInternal(StandardServic
e.java:439)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.
java:769)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.startup.Catalina.start(Catalina.java:625)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:351)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:485)

29-Dec-2017 15:26:27.047 INFO [main] org.apache.coyote.AbstractProtocol.start St
arting ProtocolHandler ["http-nio-8080"]
29-Dec-2017 15:26:27.056 INFO [main] org.apache.catalina.startup.Catalina.start
Server startup in 18030 ms