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; } } }

JIRA 7.1.0 will not run on Windows Server 2012 R2 / MS SQL

Neal Culiner

Hello,

I just upgraded JIRA from the prior version to 7.1.0 and it will not render in the browser at all. I've tried everything but cannot figure out these errors. I'm using MS SQL Server 2014 (2012 compat on the JIRA db). Any suggestions?

2016-02-11 10:37:02,608 http-nio-209.9.229.56-80-exec-13 WARN      [o.a.commons.dbcp2.BasicDataSource] Failed to complete JMX registration
javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource
	at com.sun.jmx.mbeanserver.Repository.addMBean(Repository.java:437)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerWithRepository(DefaultMBeanServerInterceptor.java:1898)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(DefaultMBeanServerInterceptor.java:966)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(DefaultMBeanServerInterceptor.java:900)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:324)
	at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:522)
	at org.apache.commons.dbcp2.BasicDataSource.jmxRegister(BasicDataSource.java:2346)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2029)
	at org.apache.commons.dbcp2.BasicDataSource.setLogWriter(BasicDataSource.java:1625)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:100)
	at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)
	at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:136)
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
	at org.ofbiz.core.entity.ConnectionFactory$1.getConnection(ConnectionFactory.java:52)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:133)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:904)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:167)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:145)
	at org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1475)
	at org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:270)
	at org.ofbiz.core.entity.GenericDelegator.initialiseAndCheckDatabase(GenericDelegator.java:238)
	at org.ofbiz.core.entity.GenericDelegator.&lt;init&gt;(GenericDelegator.java:169)
	at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:93)
	at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:90)
	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
	at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
	at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
	at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4830)
	at org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:107)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getDelegator(OFBizPropertySet.java:293)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:298)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.exists(OFBizPropertySet.java:170)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet.exists(JiraCachingPropertySet.java:566)
	at com.atlassian.jira.propertyset.BootstrapOfBizPropertyEntryStore.getType(BootstrapOfBizPropertyEntryStore.java:67)
	at com.atlassian.jira.propertyset.CachingOfBizPropertySet.exists(CachingOfBizPropertySet.java:139)
	at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getOption(ApplicationPropertiesStore.java:157)
	at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getOption(ApplicationPropertiesImpl.java:85)
	... 18 filtered
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)

2016-02-11 10:34:04,940 http-nio-209.9.229.56-80-exec-12 ERROR      [o.a.c.c.C.[.[localhost].[/].[internal-error-servlet]] Servlet.service() for servlet internal-error-servlet threw exception
java.lang.AbstractMethodError
	at net.sourceforge.jtds.jdbc.JtdsConnection.isValid(JtdsConnection.java:2833)
	at org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:914)
	at org.apache.commons.dbcp2.PoolableConnection.validate(PoolableConnection.java:283)
	at org.apache.commons.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:357)
	at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304)
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2287)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2038)
	at org.apache.commons.dbcp2.BasicDataSource.setLogWriter(BasicDataSource.java:1625)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:100)
	at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)
	at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:136)
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
	at org.ofbiz.core.entity.ConnectionFactory$1.getConnection(ConnectionFactory.java:52)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:133)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:904)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:167)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:145)
	at org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1475)
	at org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:270)
	at org.ofbiz.core.entity.GenericDelegator.initialiseAndCheckDatabase(GenericDelegator.java:238)
	at org.ofbiz.core.entity.GenericDelegator.&lt;init&gt;(GenericDelegator.java:169)
	at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:93)
	at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:90)
	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
	at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
	at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
	at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4830)
	at org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:107)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getDelegator(OFBizPropertySet.java:293)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:298)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.exists(OFBizPropertySet.java:170)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet.exists(JiraCachingPropertySet.java:566)
	at com.atlassian.jira.propertyset.BootstrapOfBizPropertyEntryStore.getType(BootstrapOfBizPropertyEntryStore.java:67)
	at com.atlassian.jira.propertyset.CachingOfBizPropertySet.exists(CachingOfBizPropertySet.java:139)
	at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getOption(ApplicationPropertiesStore.java:157)
	at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getOption(ApplicationPropertiesImpl.java:85)
	... 23 filtered
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)

Accepted answers

Stefan Ernst

try adding a validation query to your dbconfig.xml and restart Jira

&lt;validation-query&gt;select 1&lt;/validation-query&gt;

this fixed the issue for me (SQL 2012)

All comments

Nic Brough -Adaptavist-

There's something wrong with the database connection settings. This is the second report I've seen today of "run upgrade on Windows, database fails to connect", which makes me start to suspect a bug in the installer when run as an upgrade.

As an attempt to fix it, could you read up earlier through the log - we're looking for the first database error.

I'd also take this to Atlassian at https://support.atlassian.com (if it continues to look like the installer being a problem)

Neal Culiner

I sent a request to Atlassian, I really need to stop being an early adopter! Half a day on this already...wish I could attach the log, let me see if I can get more detail here.

2016-02-11 10:17:03,181 JIRA-Bootstrap INFO      [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from \Atlassian\Application Data\JIRA\dbconfig.xml
2016-02-11 10:17:03,503 JIRA-Bootstrap INFO      [c.a.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2016-02-11 10:17:03,504 JIRA-Bootstrap INFO      [c.a.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
2016-02-11 10:17:05,351 JIRA-Bootstrap ERROR      [c.a.jira.startup.LauncherContextListener] Unable to start JIRA.
com.google.common.util.concurrent.ExecutionError: java.lang.AbstractMethodError
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2201)
	at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
	at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
	at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4830)
	at org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:107)
	at com.atlassian.core.ofbiz.CoreFactory.getGenericDelegator(CoreFactory.java:34)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.configureOfbiz(DatabaseConfigurationManagerImpl.java:215)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:295)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:199)
	at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:132)
	at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$803(DefaultJiraLauncher.java:103)
	at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31)
	at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:101)
	at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:115)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.AbstractMethodError
	at net.sourceforge.jtds.jdbc.JtdsConnection.isValid(JtdsConnection.java:2833)
	at org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:914)
	at org.apache.commons.dbcp2.PoolableConnection.validate(PoolableConnection.java:283)
	at org.apache.commons.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:357)
	at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2038)
	at org.apache.commons.dbcp2.BasicDataSource.setLogWriter(BasicDataSource.java:1625)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:100)
	at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)
	at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:136)
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
	at org.ofbiz.core.entity.ConnectionFactory$1.getConnection(ConnectionFactory.java:52)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:133)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:904)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:167)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:145)
	at org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1475)
	at org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:270)
	at org.ofbiz.core.entity.GenericDelegator.initialiseAndCheckDatabase(GenericDelegator.java:238)
	at org.ofbiz.core.entity.GenericDelegator.&lt;init&gt;(GenericDelegator.java:169)
	at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:93)
	at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:90)
	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
	... 15 more

Stefan Ernst

try adding a validation query to your dbconfig.xml and restart Jira

&lt;validation-query&gt;select 1&lt;/validation-query&gt;

this fixed the issue for me (SQL 2012)

Neal Culiner

Thank you thank you thank you! That worked! If anyone else needs this place it just above:

&lt;/jdbc-datasource&gt;

Neal Culiner

Sometimes I wonder if Atlassian depends too much on automated testing and releases that things like this break. I guess they need better test fixtures such as a SQL Server 2012 test.

Stefan Ernst

Glad I could help smile This gave me the idea:

http://stackoverflow.com/questions/26404283/java-hibernate-with-sql-server-2012-not-working

Pedro Souza

As it turns out, this is a new bug in JIRA 7.1.0 and it is currently being tracked in the bug report below:

https://jira.atlassian.com/browse/JRA-59768

Feel free to add your vote and add yourself as a watcher in the bug report.

Kind regards,

Pedro Souza.

Neal Culiner

https://jira.atlassian.com/browse/JRA-59768

Pedro Souza

Thank you Stefan Ernst for sharing the workaround! smile

Orzech

The root of this problem is in database driver:

Caused by: java.lang.AbstractMethodError at

  net.sourceforge.jtds.jdbc.JtdsConnection.isValid(JtdsConnection.java:2833)

which does not support JDBC4 isValid method. Drivers are not part of JIRA installation and some users will need to update dbconfigs in order to make it work or reinstall database driver to one that supports isValid method.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

jira

jira-software

jira-administration