Atlassian jira log and atlassian jira incoming mail log is not getting updated

Leena Bakshi

Hi All,

I am getting the following error in the jira log and it hasnt been updated since 1:55 am on 10/23/2017

 This is when we had a database failover ( planned activity) and database came up:

2017-10-22 09:27:00,528 QuartzScheduler_atlassian-scheduler-quartz1.clustered-NON_CLUSTERED_MisfireHandler ERROR      [NoModule] There was an error getting a DBCP datasource.

java.lang.RuntimeException: Unable to obtain a connection from the underlying connection pool

                at org.ofbiz.core.entity.jdbc.interceptors.connection.ConnectionTracker.trackConnection(ConnectionTracker.java:60)

                at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.trackConnection(DBCPConnectionFactory.java:243)

                at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:74)

                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 com.atlassian.jira.scheduler.Quartz1ConnectionProvider.getConnection(Quartz1ConnectionProvider.java:30)

                at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:109)

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:712)

                at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:69)

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3132)

                at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3923)

                at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3943)

Caused by: java.sql.SQLException: Network error IOException: Connection refused: connect

                at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)

                at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)

                at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

                at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

                at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)

                at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)

                at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

                at org.ofbiz.core.entity.transaction.DBCPConnectionFactory$1.call(DBCPConnectionFactory.java:247)

                at org.ofbiz.core.entity.transaction.DBCPConnectionFactory$1.call(DBCPConnectionFactory.java:244)

                at org.ofbiz.core.entity.jdbc.interceptors.connection.ConnectionTracker.trackConnection(ConnectionTracker.java:54)

                ... 15 more

Caused by: java.net.ConnectException: Connection refused: connect

                at java.net.DualStackPlainSocketImpl.connect0(Native Method)

                at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)

                at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345)

                at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)

                at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)

                at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

                at java.net.Socket.connect(Socket.java:589)

                at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)

                at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)

                at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)

                ... 25 more

 

 

Leena Bakshi

We got this problem because a night before database server was rebooted due to some other project and since our jira db sits on a physical clustered db env, a failover happened and to fix this issue we needed to reboot Jira server. After that jira started functioning as expected.