Forums
Home Product Q&A Discussion groups Articles Ask a question Search
Learning
Events
Champions

Forums

Articles
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources
  • Community
  • Products
  • Jira
  • Questions
  • Jira won't connect to MySQL DB - HTTP Status 500 - org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not rece

Jira won't connect to MySQL DB - HTTP Status 500 - org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not rece

Billie Thompson
Billie Thompson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
February 17, 2014

Hi,

I'm getting the "HTTP Status 500 - org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)" error.

Here's the error log:

Feb 18, 2014 3:10:58 PM org.apache.catalina.core.StandardServer await
INFO: A valid shutdown command was received via the shutdown port. Stopping the Server instance.
Feb 18, 2014 3:10:58 PM org.apache.coyote.AbstractProtocol pause
INFO: Pausing ProtocolHandler ["http-bio-8080"]
Feb 18, 2014 3:10:58 PM org.apache.catalina.core.StandardService stopInternal
INFO: Stopping service Catalina
2014-02-18 15:10:58,924 localhost-startStop-2 INFO      [atlassian.jira.startup.DefaultJiraLauncher] Stopping launchers
Feb 18, 2014 3:10:58 PM org.apache.coyote.AbstractProtocol stop
INFO: Stopping ProtocolHandler ["http-bio-8080"]
Feb 18, 2014 3:10:58 PM org.apache.coyote.AbstractProtocol destroy
INFO: Destroying ProtocolHandler ["http-bio-8080"]
Feb 18, 2014 3:11:00 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
Feb 18, 2014 3:11:00 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Feb 18, 2014 3:11:01 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 730 ms
Feb 18, 2014 3:11:01 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Feb 18, 2014 3:11:01 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.29
2014-02-18 15:11:09,677 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger] 

****************
JIRA starting...
****************

2014-02-18 15:11:09,866 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger] 

___ Environment _____________________________

     JIRA Build                                    : 6.1.7#6163-sha1:94d557d067e7b31a37a03eea89c85612ea7bb3b6
     Build Date                                    : Wed Jan 22 00:00:00 GMT 2014
     JIRA Installation Type                        : Standalone
     Application Server                            : Apache Tomcat/7.0.29 - Servlet API 3.0
     Java Version                                  : 1.7.0_25 - Oracle Corporation
     Current Working Directory                     : /opt/atlassian/jira/bin
     Maximum Allowable Memory                      : 682MB
     Total Memory                                  : 464MB
     Free Memory                                   : 228MB
     Used Memory                                   : 236MB
     Memory Pool: Code Cache                       : Code Cache: init = 2555904(2496K) used = 1727232(1686K) committed = 2555904(2496K) max = 50331648(49152K)
     Memory Pool: PS Eden Space                    : PS Eden Space: init = 100663296(98304K) used = 172292328(168254K) committed = 198311936(193664K) max = 213123072(208128K)
     Memory Pool: PS Survivor Space                : PS Survivor Space: init = 16777216(16384K) used = 20248112(19773K) committed = 20250624(19776K) max = 20250624(19776K)
     Memory Pool: PS Old Gen                       : PS Old Gen: init = 268435456(262144K) used = 54652400(53371K) committed = 268435456(262144K) max = 536870912(524288K)
     Memory Pool: PS Perm Gen                      : PS Perm Gen: init = 21757952(21248K) used = 17812320(17394K) committed = 21757952(21248K) max = 402653184(393216K)
     JVM Input Arguments                           : -Djava.util.logging.config.file=/opt/atlassian/jira/conf/logging.properties -XX:MaxPermSize=384m -Xms384m -Xmx768m -Djava.awt.headless=true -Datlassian.standalone=JIRA -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Dmail.mime.decodeparameters=true -Dorg.dom4j.factory=com.atlassian.core.xml.InterningDocumentFactory -XX:+PrintGCDateStamps -XX:-OmitStackTraceInFastThrow -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/opt/atlassian/jira/endorsed -Dcatalina.base=/opt/atlassian/jira -Dcatalina.home=/opt/atlassian/jira -Djava.io.tmpdir=/opt/atlassian/jira/temp
     Java Compatibility Information                : JIRA version = 6.1.7, Java Version = 1.7.0_25

___ Java System Properties _________________

     atlassian.standalone                          : JIRA
     awt.toolkit                                   : sun.awt.X11.XToolkit
     catalina.base                                 : /opt/atlassian/jira
     catalina.home                                 : /opt/atlassian/jira
     catalina.useNaming                            : true
     common.loader                                 : ${catalina.base}/lib,
                                                     ${catalina.base}/lib/*.jar,
                                                     ${catalina.home}/lib,
                                                     ${catalina.home}/lib/*.jar
     file.encoding                                 : UTF-8
     file.encoding.pkg                             : sun.io
     java.awt.graphicsenv                          : sun.awt.X11GraphicsEnvironment
     java.awt.headless                             : true
     java.awt.printerjob                           : sun.print.PSPrinterJob
     java.class.version                            : 51.0
     java.home                                     : /opt/atlassian/jira/jre
     java.io.tmpdir                                : /opt/atlassian/jira/temp
     java.naming.factory.initial                   : org.apache.naming.java.javaURLContextFactory
     java.naming.factory.url.pkgs                  : org.apache.naming
     java.runtime.name                             : Java(TM) SE Runtime Environment
     java.runtime.version                          : 1.7.0_25-b15
     java.specification.name                       : Java Platform API Specification
     java.specification.vendor                     : Oracle Corporation
     java.specification.version                    : 1.7
     java.util.logging.config.file                 : /opt/atlassian/jira/conf/logging.properties
     java.util.logging.manager                     : org.apache.juli.ClassLoaderLogManager
     java.vendor                                   : Oracle Corporation
     java.vendor.url                               : http://java.oracle.com/
     java.vendor.url.bug                           : http://bugreport.sun.com/bugreport/
     java.version                                  : 1.7.0_25
     java.vm.info                                  : mixed mode
     java.vm.name                                  : Java HotSpot(TM) 64-Bit Server VM
     java.vm.specification.name                    : Java Virtual Machine Specification
     java.vm.specification.vendor                  : Oracle Corporation
     java.vm.specification.version                 : 1.7
     java.vm.vendor                                : Oracle Corporation
     java.vm.version                               : 23.25-b01
     mail.mime.decodeparameters                    : true
     org.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER : true
     org.dom4j.factory                             : com.atlassian.core.xml.InterningDocumentFactory
     os.arch                                       : amd64
     os.name                                       : Linux
     os.version                                    : 3.4.62-x1-64
     package.access                                : sun.,
                                                     org.apache.catalina.,
                                                     org.apache.coyote.,
                                                     org.apache.tomcat.,
                                                     org.apache.jasper.
     package.definition                            : sun.,
                                                     java.,
                                                     org.apache.catalina.,
                                                     org.apache.coyote.,
                                                     org.apache.tomcat.,
                                                     org.apache.jasper.
     server.loader                                 : 
     shared.loader                                 : 
     sun.arch.data.model                           : 64
     sun.boot.library.path                         : /opt/atlassian/jira/jre/lib/amd64
     sun.cpu.endian                                : little
     sun.cpu.isalist                               : 
     sun.io.unicode.encoding                       : UnicodeLittle
     sun.java.command                              : org.apache.catalina.startup.Bootstrap start
     sun.java.launcher                             : SUN_STANDARD
     sun.jnu.encoding                              : UTF-8
     sun.management.compiler                       : HotSpot 64-Bit Tiered Compilers
     sun.os.patch.level                            : unknown
     tomcat.util.buf.StringCache.byte.enabled      : true
     tomcat.util.scan.DefaultJarScanner.jarsToSkip : bootstrap.jar,
                                                     commons-daemon.jar,
                                                     tomcat-juli.jar,
                                                     annotations-api.jar,
                                                     el-api.jar,
                                                     jsp-api.jar,
                                                     servlet-api.jar,
                                                     catalina.jar,
                                                     catalina-ant.jar,
                                                     catalina-ha.jar,
                                                     catalina-tribes.jar,
                                                     jasper.jar,
                                                     jasper-el.jar,
                                                     ecj-*.jar,
                                                     tomcat-api.jar,
                                                     tomcat-util.jar,
                                                     tomcat-coyote.jar,
                                                     tomcat-dbcp.jar,
                                                     tomcat-jni.jar,
                                                     tomcat-spdy.jar,
                                                     tomcat-i18n-en.jar,
                                                     tomcat-i18n-es.jar,
                                                     tomcat-i18n-fr.jar,
                                                     tomcat-i18n-ja.jar,
                                                     tomcat-juli-adapters.jar,
                                                     catalina-jmx-remote.jar,
                                                     catalina-ws.jar,
                                                     tomcat-jdbc.jar,
                                                     commons-beanutils*.jar,
                                                     commons-codec*.jar,
                                                     commons-collections*.jar,
                                                     commons-dbcp*.jar,
                                                     commons-digester*.jar,
                                                     commons-fileupload*.jar,
                                                     commons-httpclient*.jar,
                                                     commons-io*.jar,
                                                     commons-lang*.jar,
                                                     commons-logging*.jar,
                                                     commons-math*.jar,
                                                     commons-pool*.jar,
                                                     jstl.jar,
                                                     geronimo-spec-jaxrpc*.jar,
                                                     wsdl4j*.jar,
                                                     ant.jar,
                                                     ant-junit*.jar,
                                                     aspectj*.jar,
                                                     jmx.jar,
                                                     h2*.jar,
                                                     hibernate*.jar,
                                                     httpclient*.jar,
                                                     jmx-tools.jar,
                                                     jta*.jar,
                                                     log4j*.jar,
                                                     mail*.jar,
                                                     slf4j*.jar,
                                                     xercesImpl.jar,
                                                     xmlParserAPIs.jar,
                                                     xml-apis.jar,
                                                     dnsns.jar,
                                                     ldapsec.jar,
                                                     localedata.jar,
                                                     sunjce_provider.jar,
                                                     sunmscapi.jar,
                                                     sunpkcs11.jar,
                                                     jhall.jar,
                                                     tools.jar,
                                                     sunec.jar,
                                                     zipfs.jar,
                                                     apple_provider.jar,
                                                     AppleScriptEngine.jar,
                                                     CoreAudio.jar,
                                                     dns_sd.jar,
                                                     j3daudio.jar,
                                                     j3dcore.jar,
                                                     j3dutils.jar,
                                                     jai_core.jar,
                                                     jai_codec.jar,
                                                     mlibwrapper_jai.jar,
                                                     MRJToolkit.jar,
                                                     vecmath.jar,
                                                     junit.jar,
                                                     junit-*.jar,
                                                     ant-launcher.jar
     user.country                                  : GB
     user.dir                                      : /opt/atlassian/jira/bin
     user.home                                     : /home/jira1
     user.language                                 : en
     user.name                                     : jira1
     user.timezone                                 : GB

2014-02-18 15:11:10,025 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraHomeStartupCheck] The jira.home directory '/var/atlassian/application-data/jira' is validated and locked for exclusive use by this instance.
2014-02-18 15:11:10,041 localhost-startStop-1 INFO      [jira.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/atlassian/application-data/jira/dbconfig.xml
2014-02-18 15:11:10,120 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2014-02-18 15:11:10,120 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
2014-02-18 15:11:10,171 localhost-startStop-1 INFO      [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher
2014-02-18 15:11:10,350 localhost-startStop-1 ERROR      [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:mysql://localhost:3306/jira?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB', driverClassName='com.mysql.jdbc.Driver', username='root', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=20, minSize=20, initialSize=null, maxIdle=20, maxWait=30000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery='select 1', minEvictableTimeMillis=60000, timeBetweenEvictionRunsMillis=300000, poolPreparedStatements=null, testOnBorrow=null, testOnReturn=null, testWhileIdle=true, maxOpenPreparedStatements=null, numTestsPerEvictionRun=null, removeAbandonedTimeout=300, validationQueryTimeout=3, defaultCatalog=null}}
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:1134)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:109)
	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:101)
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
	at com.atlassian.jira.ofbiz.DefaultOfBizConnectionFactory.getConnection(DefaultOfBizConnectionFactory.java:48)
	at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:102)
	at com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.databaseSetup(MinimumUpgradableVersionCheck.java:49)
	at com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.isOk(MinimumUpgradableVersionCheck.java:30)
	at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.doStartupChecks(JiraDatabaseConfigChecklist.java:64)
	at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.startupOK(JiraDatabaseConfigChecklist.java:52)
	at com.atlassian.jira.startup.DatabaseChecklistLauncher.start(DatabaseChecklistLauncher.java:39)
	at com.atlassian.jira.startup.DefaultJiraLauncher$2.run(DefaultJiraLauncher.java:110)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:315)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:215)
	at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:105)
	at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:30)
	at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:77)
	at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34)
	at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:72)
	at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:54)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1129)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:358)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2498)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2535)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2320)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
	... 33 more
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:308)
	... 49 more
2014-02-18 15:11:10,357 localhost-startStop-1 ERROR      [atlassian.jira.startup.LauncherContextListener] Unable to start JIRA.
com.atlassian.jira.exception.DataAccessException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:129)
	at com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.databaseSetup(MinimumUpgradableVersionCheck.java:49)
	at com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.isOk(MinimumUpgradableVersionCheck.java:30)
	at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.doStartupChecks(JiraDatabaseConfigChecklist.java:64)
	at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.startupOK(JiraDatabaseConfigChecklist.java:52)
	at com.atlassian.jira.startup.DatabaseChecklistLauncher.start(DatabaseChecklistLauncher.java:39)
	at com.atlassian.jira.startup.DefaultJiraLauncher$2.run(DefaultJiraLauncher.java:110)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:315)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:215)
	at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:105)
	at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:30)
	at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:77)
	at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34)
	at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:72)
	at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:54)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1129)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:358)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2498)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2535)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2320)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:87)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)
	at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:101)
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
	at com.atlassian.jira.ofbiz.DefaultOfBizConnectionFactory.getConnection(DefaultOfBizConnectionFactory.java:48)
	at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:102)
	... 24 more
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:308)
	... 44 more
2014-02-18 15:11:10,988 localhost-startStop-1 ERROR      [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:mysql://localhost:3306/jira?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB', driverClassName='com.mysql.jdbc.Driver', username='root', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=20, minSize=20, initialSize=null, maxIdle=20, maxWait=30000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery='select 1', minEvictableTimeMillis=60000, timeBetweenEvictionRunsMillis=300000, poolPreparedStatements=null, testOnBorrow=null, testOnReturn=null, testWhileIdle=true, maxOpenPreparedStatements=null, numTestsPerEvictionRun=null, removeAbandonedTimeout=300, validationQueryTimeout=3, defaultCatalog=null}}
java.lang.RuntimeException: javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource
	at org.weakref.jmx.MBeanExporter.export(MBeanExporter.java:45)
	at org.apache.commons.dbcp.ManagedBasicDataSource.exportMBean(ManagedBasicDataSource.java:70)
	at org.apache.commons.dbcp.ManagedBasicDataSource.<init>(ManagedBasicDataSource.java:61)
	at org.apache.commons.dbcp.ManagedBasicDataSourceFactory.createDataSource(ManagedBasicDataSourceFactory.java:278)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.createDataSource(DBCPConnectionFactory.java:190)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:91)
	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:101)
	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:128)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:899)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:162)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:140)
	at org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1430)
	at org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:251)
	at org.ofbiz.core.entity.GenericDelegator.<init>(GenericDelegator.java:184)
	at org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:116)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getDelegator(OFBizPropertySet.java:293)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:82)
	at com.atlassian.jira.propertyset.PropertySetCache.bulkLoad(PropertySetCache.java:318)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet$12.run(JiraCachingPropertySet.java:785)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet.doLocked(JiraCachingPropertySet.java:846)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet.init(JiraCachingPropertySet.java:770)
	at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:58)
	at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:31)
	at com.atlassian.jira.config.properties.PropertySetUtils.createDatabaseBackedPropertySet(PropertySetUtils.java:34)
	at com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:26)
	at com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:22)
	at com.atlassian.util.concurrent.ResettableLazyReference$InternalReference.create(ResettableLazyReference.java:140)
	at com.atlassian.util.concurrent.LazyReference$Sync.run(LazyReference.java:321)
	at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:143)
	at com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)
	at com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87)
	at com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27)
	at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268)
	at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getString(ApplicationPropertiesStore.java:346)
	at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getDefaultBackedString(ApplicationPropertiesImpl.java:60)
	at com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$ApplicationPropertiesClassNameRetriever.get(UserNameTransformer.java:68)
	at com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$Factory.get(UserNameTransformer.java:99)
	at com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter$OSUserResolver.<init>(TrustedApplicationFilter.java:40)
	at com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter.<init>(TrustedApplicationFilter.java:25)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:134)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:256)
	at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:382)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:103)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4650)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5306)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource
	at com.sun.jmx.mbeanserver.Repository.addMBean(Unknown Source)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerWithRepository(Unknown Source)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(Unknown Source)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(Unknown Source)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(Unknown Source)
	at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(Unknown Source)
	at org.weakref.jmx.MBeanExporter.export(MBeanExporter.java:39)
	... 61 more
2014-02-18 15:11:11,003 localhost-startStop-1 ERROR      [core.entity.jdbc.DatabaseUtil] Unable to establish a connection with the database... Error was:com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2014-02-18 15:11:11,003 localhost-startStop-1 ERROR      [core.entity.jdbc.DatabaseUtil] Could not get table name information from the database, aborting.
2014-02-18 15:11:11,026 localhost-startStop-1 ERROR      [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:mysql://localhost:3306/jira?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB', driverClassName='com.mysql.jdbc.Driver', username='root', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=20, minSize=20, initialSize=null, maxIdle=20, maxWait=30000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery='select 1', minEvictableTimeMillis=60000, timeBetweenEvictionRunsMillis=300000, poolPreparedStatements=null, testOnBorrow=null, testOnReturn=null, testWhileIdle=true, maxOpenPreparedStatements=null, numTestsPerEvictionRun=null, removeAbandonedTimeout=300, validationQueryTimeout=3, defaultCatalog=null}}
java.lang.RuntimeException: javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource
	at org.weakref.jmx.MBeanExporter.export(MBeanExporter.java:45)
	at org.apache.commons.dbcp.ManagedBasicDataSource.exportMBean(ManagedBasicDataSource.java:70)
	at org.apache.commons.dbcp.ManagedBasicDataSource.<init>(ManagedBasicDataSource.java:61)
	at org.apache.commons.dbcp.ManagedBasicDataSourceFactory.createDataSource(ManagedBasicDataSourceFactory.java:278)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.createDataSource(DBCPConnectionFactory.java:190)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:91)
	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:101)
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
	at org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:402)
	at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:962)
	at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:630)
	at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:131)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:804)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:789)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:766)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:82)
	at com.atlassian.jira.propertyset.PropertySetCache.bulkLoad(PropertySetCache.java:318)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet$12.run(JiraCachingPropertySet.java:785)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet.doLocked(JiraCachingPropertySet.java:846)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet.init(JiraCachingPropertySet.java:770)
	at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:58)
	at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:31)
	at com.atlassian.jira.config.properties.PropertySetUtils.createDatabaseBackedPropertySet(PropertySetUtils.java:34)
	at com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:26)
	at com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:22)
	at com.atlassian.util.concurrent.ResettableLazyReference$InternalReference.create(ResettableLazyReference.java:140)
	at com.atlassian.util.concurrent.LazyReference$Sync.run(LazyReference.java:321)
	at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:143)
	at com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)
	at com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87)
	at com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27)
	at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268)
	at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getString(ApplicationPropertiesStore.java:346)
	at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getDefaultBackedString(ApplicationPropertiesImpl.java:60)
	at com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$ApplicationPropertiesClassNameRetriever.get(UserNameTransformer.java:68)
	at com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$Factory.get(UserNameTransformer.java:99)
	at com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter$OSUserResolver.<init>(TrustedApplicationFilter.java:40)
	at com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter.<init>(TrustedApplicationFilter.java:25)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:134)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:256)
	at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:382)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:103)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4650)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5306)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource
	at com.sun.jmx.mbeanserver.Repository.addMBean(Unknown Source)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerWithRepository(Unknown Source)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(Unknown Source)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(Unknown Source)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(Unknown Source)
	at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(Unknown Source)
	at org.weakref.jmx.MBeanExporter.export(MBeanExporter.java:39)
	... 58 more
2014-02-18 15:11:11,043 localhost-startStop-1 ERROR      [NoModule] Could not determine database type.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1129)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:358)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2498)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2535)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2320)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:87)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)
	at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:101)
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
	at org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:402)
	at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:962)
	at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:630)
	at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:131)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:804)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:789)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:766)
	at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:82)
	at com.atlassian.jira.propertyset.PropertySetCache.bulkLoad(PropertySetCache.java:318)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet$12.run(JiraCachingPropertySet.java:785)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet.doLocked(JiraCachingPropertySet.java:846)
	at com.atlassian.jira.propertyset.JiraCachingPropertySet.init(JiraCachingPropertySet.java:770)
	at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:58)
	at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:31)
	at com.atlassian.jira.config.properties.PropertySetUtils.createDatabaseBackedPropertySet(PropertySetUtils.java:34)
	at com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:26)
	at com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:22)
	at com.atlassian.util.concurrent.ResettableLazyReference$InternalReference.create(ResettableLazyReference.java:140)
	at com.atlassian.util.concurrent.LazyReference$Sync.run(LazyReference.java:321)
	at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:143)
	at com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)
	at com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87)
	at com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27)
	at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268)
	at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getString(ApplicationPropertiesStore.java:346)
	at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getDefaultBackedString(ApplicationPropertiesImpl.java:60)
	at com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$ApplicationPropertiesClassNameRetriever.get(UserNameTransformer.java:68)
	at com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$Factory.get(UserNameTransformer.java:99)
	at com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter$OSUserResolver.<init>(TrustedApplicationFilter.java:40)
	at com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter.<init>(TrustedApplicationFilter.java:25)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:134)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:256)
	at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:382)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:103)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4650)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5306)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:308)
	... 67 more
2014-02-18 15:11:11,046 localhost-startStop-1 WARN      [jira.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.trustedapps.user.name.transformation.policy.class' from database. Using default
Feb 18, 2014 3:11:11 PM org.apache.catalina.startup.HostConfig start
SEVERE: Unable to create directory for deployment: /opt/atlassian/jira/conf/Catalina/localhost
Feb 18, 2014 3:11:11 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Feb 18, 2014 3:11:11 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 10337 ms
2014-02-18 15:11:12,806 http-bio-8080-exec-1 WARN   -   [jira.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.i18n.default.locale' from database. Using default
2014-02-18 15:11:12,904 http-bio-8080-exec-1 WARN   -   [jira.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.i18n.default.locale' from database. Using default
2014-02-18 15:11:12,918 http-bio-8080-exec-1 WARN   -   [500ErrorPage.ee9f2fe4-be83-4f27-b622-686ce5a4d730] Cannot initialize ExtendedSystemInfoUtilsImpl
com.atlassian.jira.util.dbc.Assertions$NullArgumentException: jiraLicenseService should not be null!
	at com.atlassian.jira.util.dbc.Assertions.notNull(Assertions.java:29)
	at com.atlassian.jira.util.system.ExtendedSystemInfoUtilsImpl.<init>(ExtendedSystemInfoUtilsImpl.java:152)
	at com.atlassian.jira.util.system.ExtendedSystemInfoUtilsImpl.<init>(ExtendedSystemInfoUtilsImpl.java:159)
	at com.atlassian.jira.web.servlet.InternalServerErrorServlet.initializeInternalServerErrorDS(InternalServerErrorServlet.java:147)
	at com.atlassian.jira.web.servlet.InternalServerErrorServlet.doRequest(InternalServerErrorServlet.java:68)
	at com.atlassian.jira.web.servlet.InternalServerErrorServlet.doGet(InternalServerErrorServlet.java:110)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.jira.web.filters.XContentTypeOptionsNoSniffFilter.doFilter(XContentTypeOptionsNoSniffFilter.java:22)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:71)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:71)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:71)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:80)
	at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
	at com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter(JiraGzipFilter.java:55)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:71)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87)
	at com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:57)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:690)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:479)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
	at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:457)
	at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:328)
	at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:419)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:191)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
2014-02-18 15:11:13,036 http-bio-8080-exec-2 WARN   -   [jira.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.i18n.default.locale' from database. Using default
2014-02-18 15:11:13,036 http-bio-8080-exec-2 WARN   -   [jira.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.i18n.default.locale' from database. Using default
2014-02-18 15:11:13,038 http-bio-8080-exec-2 WARN   -   [500ErrorPage.a406238e-65a5-406b-b07f-ef8349ff73f7] Cannot initialize ExtendedSystemInfoUtilsImpl
com.atlassian.jira.util.dbc.Assertions$NullArgumentException: jiraLicenseService should not be null!
	at com.atlassian.jira.util.dbc.Assertions.notNull(Assertions.java:29)
	at com.atlassian.jira.util.system.ExtendedSystemInfoUtilsImpl.<init>(ExtendedSystemInfoUtilsImpl.java:152)
	at com.atlassian.jira.util.system.ExtendedSystemInfoUtilsImpl.<init>(ExtendedSystemInfoUtilsImpl.java:159)
	at com.atlassian.jira.web.servlet.InternalServerErrorServlet.initializeInternalServerErrorDS(InternalServerErrorServlet.java:147)
	at com.atlassian.jira.web.servlet.InternalServerErrorServlet.doRequest(InternalServerErrorServlet.java:68)
	at com.atlassian.jira.web.servlet.InternalServerErrorServlet.doGet(InternalServerErrorServlet.java:110)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.jira.web.filters.XContentTypeOptionsNoSniffFilter.doFilter(XContentTypeOptionsNoSniffFilter.java:22)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:71)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:71)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:71)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:80)
	at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
	at com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter(JiraGzipFilter.java:55)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:71)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87)
	at com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:57)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:690)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:479)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
	at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:457)
	at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:328)
	at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:419)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:191)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

I believe these are the important lines:

2014-02-18 15:11:10,171 localhost-startStop-1 INFO      [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher
2014-02-18 15:11:10,350 localhost-startStop-1 ERROR      [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:mysql://localhost:3306/jira?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB', driverClassName='com.mysql.jdbc.Driver', username='root', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=20, minSize=20, initialSize=null, maxIdle=20, maxWait=30000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery='select 1', minEvictableTimeMillis=60000, timeBetweenEvictionRunsMillis=300000, poolPreparedStatements=null, testOnBorrow=null, testOnReturn=null, testWhileIdle=true, maxOpenPreparedStatements=null, numTestsPerEvictionRun=null, removeAbandonedTimeout=300, validationQueryTimeout=3, defaultCatalog=null}}
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
Here's my dbconfig:
<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
    <name>defaultDS</name>
    <delegator-name>default</delegator-name>
    <database-type>mysql</database-type>
    <jdbc-datasource>
        <url>jdbc:mysql://localhost:3306/jira?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB</url>
        <driver-class>com.mysql.jdbc.Driver</driver-class>
        <username>root</username>
        <password>*********</password>
        <pool-min-size>20</pool-min-size>
        <pool-max-size>20</pool-max-size>
        <pool-max-wait>30000</pool-max-wait>
        <pool-max-idle>20</pool-max-idle>
        <pool-remove-abandoned>true</pool-remove-abandoned>
        <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>

        <validation-query>select 1</validation-query>
        <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
        <time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>

        <pool-test-while-idle>true</pool-test-while-idle>
        <validation-query-timeout>3</validation-query-timeout>
    </jdbc-datasource>
</jira-database-config>

The connector is in the lib directory:

# ls -lrathF /opt/atlassian/jira/lib/*mysql*
-rw-r--r-- 1 root 857K Feb 18 14:28 /opt/atlassian/jira/lib/mysql-connector-java-5.1.29-bin.jar

manually connecting using the details in the DB conf xml works fine.

And MySQL is listening on the correct port:

# lsof -i :3306

COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME

mysqld 31846 mysql 10u IPv4 337843 0t0 TCP localhost:mysql (LISTEN)

Answer
Watch
Like Be the first to like this
2511 views

4 answers

0 votes
D. Herminghaus
D. Herminghaus September 26, 2015

Addendum: Here is a (so far positively tested) workaround, and I feel quite dirty having to do it this way. It would still be nice if you reviewed your current DB scenarios based on this, as we are likely to need more than ten users about some time.

  1. disable init.d script.
  2. Create bash script doing what init.d script does (cd to JIRA app directory, run startup script), but first of all sleep some 2-3 minutes. (e.g. "sleep 3m && cd "$jiradir" && ./start-jira.sh)
  3. Call bash script to be exexuted by cron job @reboot.

It works that way, so I won't complain any longer. However, this is really bad stuff IMO. Please fix it.

Reply
0 votes
D. Herminghaus
D. Herminghaus September 26, 2015

Starting JIRA at boot is impossible. I have tried literally any option (vary db users, use same-host DB, edit hosts file, vary host names, disable service in init.d and instead launch startup script with delay after reboot, do all this with both root or JIRA user). It is simply not possible to have JIRA running after a reboot without getting this sucking Tomcat error. And I really don't figure that "JIRA on a kvm quest connecting to another kvm guest with a db host" is a task so rare you would not even test it thoroughly; you would, wouldn't you.

 

I am pretty aware that you cannot test every possible setup when delivering an overall complex (and mainly pretty nice) software like this one, but honestly: This will keep me from purchasing anything beyond 10 users 10$. (Don't dream of my using a cloud account.)

Since I do not have any of that stress with Confluence (following the exactly same paradigms, but obviously using a different/older? 3rd party foundation), I suspect you imported something you cannot even account for yourselves. But still I do not want this to be my problem.

Feel free to suggest something that works, but until then my decision is rather clear. Sorry to say that. But manual restarts just due to our otherwise fully automated systems (which include regular backups, "causing" this problem) is pretty much not what I figure efficient.

Thanks anyway, pardon my frustration.

Reply
0 votes
kyungmin ryu
kyungmin ryu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
September 15, 2014

Check it whether the MySQL database network access is allowed or not.

Reply
0 votes
Billie Thompson
Billie Thompson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
February 17, 2014

So I got this fixed.

How I did it was switch from using "localhost" to "127.0.0.1" as the DB host. Connecting explicitly to "localhost" via the mysql client works fine. Seemingly something weird is going on there, I presume Java is attempting to connect to ::1 rather than 127.0.0.1

View More Comments
richie_gee
richie_gee
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 18, 2014

thank you for sharing your resolution, mind to accept the answer as this might benefit the community in the future.

about your observation, you might need to map the localhost to the machine's host file which reroute to 127.0.0.1. From the problem described, I do suspect it is routed to ::1 instead on the host configuration.

Hope this helps, cheers!

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events
    Community
    Forums
    FAQs Forums guidelines
    Learning
    About learning Resources
    Events
    Champions
    Copyright © 2025 Atlassian
    Privacy Policy Terms Security
    Welcome illustration

    Welcome to the new Atlassian Community

    Online forums and learning are now in one easy-to-use experience.

    By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.