java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@fa49b44d[file =/Luis/Workspace/realjira/jira-ide-support/target/jirahome/database/jiradb.lck, exists=true, locked=false, valid=false, fl =null]:

Atlassian JIRA | Paul Slade | 6 years ago
  1. 0

    Bring up two JIRA instances pointing to the same jira.home. JIRA doesn't start up properly. It should show the "JIRA Locked" page but it doesn't. Logs: {noformat} 2011-04-28 16:46:38,169 main FATAL [atlassian.jira.startup.JiraStartupLogger] ******************************************************************************************************************************************************************************************************** The jira.home directory '/Luis/Workspace/realjira/jira-ide-support/target/jirahome' is already locked. Please see http://docs.atlassian.com/jira/docs-044/How+do+I+unlock+my+JIRA+home+directory%3F?clicked=jirahelp# for more information on locked jira.home directories. ******************************************************************************************************************************************************************************************************** 2011-04-28 16:46:38,197 main FATAL [atlassian.jira.startup.JiraStartupLogger] Startup check failed. JIRA will be locked. 2011-04-28 16:46:39,107 main INFO [jira.config.database.SystemTenantDatabaseConfigurationLoader] Reading database configuration from /Luis/Workspace/realjira/jira-ide-support/target/jirahome/dbconfig.xml 2011-04-28 16:46:39,236 main INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher 2011-04-28 16:46:39,472 main ERROR [NoModule] Error getting datasource via DBCP. java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@fa49b44d[file =/Luis/Workspace/realjira/jira-ide-support/target/jirahome/database/jiradb.lck, exists=true, locked=false, valid=false, fl =null]: at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140) at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:96) at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:142) 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:28) at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:101) 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:65) at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.startupOK(JiraDatabaseConfigChecklist.java:53) at com.atlassian.jira.startup.DatabaseChecklistLauncher.start(DatabaseChecklistLauncher.java:33) at com.atlassian.jira.startup.DefaultJiraLauncher$2.run(DefaultJiraLauncher.java:88) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:248) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:153) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:83) at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:24) at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:61) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:33) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:56) at com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:57) at com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:52) at com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.get(MultiTenantComponentMapImpl.java:121) at com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.onTenantStart(MultiTenantComponentMapImpl.java:165) at com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:134) at com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:131) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForEachListener(DefaultMultiTenantManager.java:256) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.startTenant(DefaultMultiTenantManager.java:130) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.startAll(DefaultMultiTenantManager.java:203) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:85) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) 2011-04-28 16:46:39,497 main ERROR [atlassian.jira.startup.LauncherContextListener] Unable to start JIRA. com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@fa49b44d[file =/Luis/Workspace/realjira/jira-ide-support/target/jirahome/database/jiradb.lck, exists=true, locked=false, valid=false, fl =null]: at com.atlassian.jira.exception.DataAccessException.fillInStackTrace(DataAccessException.java:65531) at java.lang.Throwable.<init>(Throwable.java:181) at java.lang.Exception.<init>(Exception.java:29) at java.lang.RuntimeException.<init>(RuntimeException.java:32) at org.apache.commons.lang.exception.NestableRuntimeException.<init>(NestableRuntimeException.java:81) at com.atlassian.jira.exception.DataAccessException.<init>(DataAccessException.java:19) at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:128) 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:65) at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.startupOK(JiraDatabaseConfigChecklist.java:53) at com.atlassian.jira.startup.DatabaseChecklistLauncher.start(DatabaseChecklistLauncher.java:33) at com.atlassian.jira.startup.DefaultJiraLauncher$2.run(DefaultJiraLauncher.java:88) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:248) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:153) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:83) at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:24) at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:61) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:33) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:56) at com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:57) at com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:52) at com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.get(MultiTenantComponentMapImpl.java:121) at com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.onTenantStart(MultiTenantComponentMapImpl.java:165) at com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:134) at com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:131) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForEachListener(DefaultMultiTenantManager.java:256) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.startTenant(DefaultMultiTenantManager.java:130) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.startAll(DefaultMultiTenantManager.java:203) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:85) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@fa49b44d[file =/Luis/Workspace/realjira/jira-ide-support/target/jirahome/database/jiradb.lck, exists=true, locked=false, valid=false, fl =null]: at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:87) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:142) 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:28) at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:101) ... 38 more {noformat} https://jdog.atlassian.com/browse/JRADEV-5517

    Atlassian JIRA | 6 years ago | Paul Slade
    java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@fa49b44d[file =/Luis/Workspace/realjira/jira-ide-support/target/jirahome/database/jiradb.lck, exists=true, locked=false, valid=false, fl =null]:
  2. 0

    Bring up two JIRA instances pointing to the same jira.home. JIRA doesn't start up properly. It should show the "JIRA Locked" page but it doesn't. Logs: {noformat} 2011-04-28 16:46:38,169 main FATAL [atlassian.jira.startup.JiraStartupLogger] ******************************************************************************************************************************************************************************************************** The jira.home directory '/Luis/Workspace/realjira/jira-ide-support/target/jirahome' is already locked. Please see http://docs.atlassian.com/jira/docs-044/How+do+I+unlock+my+JIRA+home+directory%3F?clicked=jirahelp# for more information on locked jira.home directories. ******************************************************************************************************************************************************************************************************** 2011-04-28 16:46:38,197 main FATAL [atlassian.jira.startup.JiraStartupLogger] Startup check failed. JIRA will be locked. 2011-04-28 16:46:39,107 main INFO [jira.config.database.SystemTenantDatabaseConfigurationLoader] Reading database configuration from /Luis/Workspace/realjira/jira-ide-support/target/jirahome/dbconfig.xml 2011-04-28 16:46:39,236 main INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher 2011-04-28 16:46:39,472 main ERROR [NoModule] Error getting datasource via DBCP. java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@fa49b44d[file =/Luis/Workspace/realjira/jira-ide-support/target/jirahome/database/jiradb.lck, exists=true, locked=false, valid=false, fl =null]: at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140) at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:96) at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:142) 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:28) at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:101) 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:65) at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.startupOK(JiraDatabaseConfigChecklist.java:53) at com.atlassian.jira.startup.DatabaseChecklistLauncher.start(DatabaseChecklistLauncher.java:33) at com.atlassian.jira.startup.DefaultJiraLauncher$2.run(DefaultJiraLauncher.java:88) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:248) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:153) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:83) at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:24) at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:61) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:33) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:56) at com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:57) at com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:52) at com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.get(MultiTenantComponentMapImpl.java:121) at com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.onTenantStart(MultiTenantComponentMapImpl.java:165) at com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:134) at com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:131) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForEachListener(DefaultMultiTenantManager.java:256) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.startTenant(DefaultMultiTenantManager.java:130) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.startAll(DefaultMultiTenantManager.java:203) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:85) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) 2011-04-28 16:46:39,497 main ERROR [atlassian.jira.startup.LauncherContextListener] Unable to start JIRA. com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@fa49b44d[file =/Luis/Workspace/realjira/jira-ide-support/target/jirahome/database/jiradb.lck, exists=true, locked=false, valid=false, fl =null]: at com.atlassian.jira.exception.DataAccessException.fillInStackTrace(DataAccessException.java:65531) at java.lang.Throwable.<init>(Throwable.java:181) at java.lang.Exception.<init>(Exception.java:29) at java.lang.RuntimeException.<init>(RuntimeException.java:32) at org.apache.commons.lang.exception.NestableRuntimeException.<init>(NestableRuntimeException.java:81) at com.atlassian.jira.exception.DataAccessException.<init>(DataAccessException.java:19) at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:128) 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:65) at com.atlassian.jira.startup.JiraDatabaseConfigChecklist.startupOK(JiraDatabaseConfigChecklist.java:53) at com.atlassian.jira.startup.DatabaseChecklistLauncher.start(DatabaseChecklistLauncher.java:33) at com.atlassian.jira.startup.DefaultJiraLauncher$2.run(DefaultJiraLauncher.java:88) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:248) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:153) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:83) at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:24) at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:61) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:33) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:56) at com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:57) at com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:52) at com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.get(MultiTenantComponentMapImpl.java:121) at com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.onTenantStart(MultiTenantComponentMapImpl.java:165) at com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:134) at com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:131) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForEachListener(DefaultMultiTenantManager.java:256) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.startTenant(DefaultMultiTenantManager.java:130) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.startAll(DefaultMultiTenantManager.java:203) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:85) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@fa49b44d[file =/Luis/Workspace/realjira/jira-ide-support/target/jirahome/database/jiradb.lck, exists=true, locked=false, valid=false, fl =null]: at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:87) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:142) 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:28) at com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:101) ... 38 more {noformat} https://jdog.atlassian.com/browse/JRADEV-5517

    Atlassian JIRA | 6 years ago | Paul Slade
    java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@fa49b44d[file =/Luis/Workspace/realjira/jira-ide-support/target/jirahome/database/jiradb.lck, exists=true, locked=false, valid=false, fl =null]:
  3. 0

    JDO - datanucleus - HSQL error

    Stack Overflow | 5 years ago | Aniruddha
    java.sql.SQLException: socket creation error
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    After configure Pentaho 5.4 with a Postgres database repository, it runs fine. But if I disable HSQLDB in the web.xml file I get some error at startup process. <!-- [BEGIN HSQLDB DATABASES] --> <!-- <context-param> <param-name>hsqldb-databases</param-name> <param-value>sampledata@../../data/hsqldb/sampledata,hibernate@../../data/hsqldb/hibernate,quartz@../../data/hsqldb/quartz</param-value> </context-param> --> <!-- [END HSQLDB DATABASES] --> <!-- [BEGIN HSQLDB STARTER] --> <!-- <listener> <listener-class>org.pentaho.platform.web.http.context.HsqldbStartupListener</listener-class> --> </listener> <!-- [END HSQLDB STARTER] --> 14:46:03,315 ERROR [PentahoDataSourceResolver] PentahoXmlaServlet.ERROR_0002 - IDatasourceService.UNABLE_TO_INSTANTIATE_OBJECT org.pentaho.platform.api.data.DBDatasourceServiceException: java.sql.SQLException: socket creation error at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:290) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledOrJndiDatasourceService.resolveDatabaseConnection(PooledOrJndiDatasourceService.java:31) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledOrJndiDatasourceService.resolveDatabaseConnection(DynamicallyPooledOrJndiDatasourceService.java:37) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.web.servlet.PentahoDataSourceResolver.lookup(PentahoDataSourceResolver.java:43) at mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:429) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:135) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91) at mondrian.olap.DriverManager.getConnection(DriverManager.java:113) at mondrian.olap.DriverManager.getConnection(DriverManager.java:69) at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:162) at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323) at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118) at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32) at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:187) at mondrian.server.FileRepository.getConnection(FileRepository.java:220) at mondrian.server.FileRepository.getConnection(FileRepository.java:182) at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.java:264) at org.pentaho.platform.plugin.action.olap.impl.OlapServiceImpl.getConnection(OlapServiceImpl.java:741) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.flushCacheForCatalog(MondrianCatalogHelper.java:659) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:650) at org.pentaho.platform.plugin.services.importer.MondrianImportHandler.importFile(MondrianImportHandler.java:106) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.SolutionImportHandler.importFile(SolutionImportHandler.java:155) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.ArchiveLoader.loadAll(ArchiveLoader.java:63) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:56) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.security.SecurityHelper.runAsSystem(SecurityHelper.java:396) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener.startup(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:421) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:77) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:343) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:311) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:212) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:135) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068) at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:759) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: java.sql.SQLException: socket creation error at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1679) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:271) ... 70 more 14:46:03,716 ERROR [PentahoDataSourceResolver] PentahoXmlaServlet.ERROR_0002 - IDatasourceService.UNABLE_TO_INSTANTIATE_OBJECT org.pentaho.platform.api.data.DBDatasourceServiceException: java.sql.SQLException: socket creation error at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:290) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledOrJndiDatasourceService.resolveDatabaseConnection(PooledOrJndiDatasourceService.java:31) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledOrJndiDatasourceService.resolveDatabaseConnection(DynamicallyPooledOrJndiDatasourceService.java:37) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.web.servlet.PentahoDataSourceResolver.lookup(PentahoDataSourceResolver.java:43) at mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:429) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:135) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91) at mondrian.olap.DriverManager.getConnection(DriverManager.java:113) at mondrian.olap.DriverManager.getConnection(DriverManager.java:69) at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:162) at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323) at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118) at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32) at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:187) at mondrian.server.FileRepository.getConnection(FileRepository.java:220) at mondrian.server.FileRepository.getConnection(FileRepository.java:182) at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.java:264) at org.pentaho.platform.plugin.action.olap.impl.OlapServiceImpl.getConnection(OlapServiceImpl.java:741) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.flushCacheForCatalog(MondrianCatalogHelper.java:659) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:650) at org.pentaho.platform.plugin.services.importer.MondrianImportHandler.importFile(MondrianImportHandler.java:106) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.SolutionImportHandler.importFile(SolutionImportHandler.java:155) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.ArchiveLoader.loadAll(ArchiveLoader.java:63) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:56) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.security.SecurityHelper.runAsSystem(SecurityHelper.java:396) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener.startup(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:421) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:77) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:343) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:311) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:212) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:135) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068) at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:759) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: java.sql.SQLException: socket creation error at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1679) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:271) ... 70 more

    Pentaho BI Platform Tracking | 1 year ago | Kleyson Rios
    org.pentaho.platform.api.data.DBDatasourceServiceException: java.sql.SQLException: socket creation error
  6. 0

    After configure Pentaho 5.4 with a Postgres database repository, it runs fine. But if I disable HSQLDB in the web.xml file I get some error at startup process. <!-- [BEGIN HSQLDB DATABASES] --> <!-- <context-param> <param-name>hsqldb-databases</param-name> <param-value>sampledata@../../data/hsqldb/sampledata,hibernate@../../data/hsqldb/hibernate,quartz@../../data/hsqldb/quartz</param-value> </context-param> --> <!-- [END HSQLDB DATABASES] --> <!-- [BEGIN HSQLDB STARTER] --> <!-- <listener> <listener-class>org.pentaho.platform.web.http.context.HsqldbStartupListener</listener-class> --> </listener> <!-- [END HSQLDB STARTER] --> 14:46:03,315 ERROR [PentahoDataSourceResolver] PentahoXmlaServlet.ERROR_0002 - IDatasourceService.UNABLE_TO_INSTANTIATE_OBJECT org.pentaho.platform.api.data.DBDatasourceServiceException: java.sql.SQLException: socket creation error at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:290) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledOrJndiDatasourceService.resolveDatabaseConnection(PooledOrJndiDatasourceService.java:31) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledOrJndiDatasourceService.resolveDatabaseConnection(DynamicallyPooledOrJndiDatasourceService.java:37) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.web.servlet.PentahoDataSourceResolver.lookup(PentahoDataSourceResolver.java:43) at mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:429) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:135) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91) at mondrian.olap.DriverManager.getConnection(DriverManager.java:113) at mondrian.olap.DriverManager.getConnection(DriverManager.java:69) at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:162) at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323) at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118) at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32) at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:187) at mondrian.server.FileRepository.getConnection(FileRepository.java:220) at mondrian.server.FileRepository.getConnection(FileRepository.java:182) at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.java:264) at org.pentaho.platform.plugin.action.olap.impl.OlapServiceImpl.getConnection(OlapServiceImpl.java:741) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.flushCacheForCatalog(MondrianCatalogHelper.java:659) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:650) at org.pentaho.platform.plugin.services.importer.MondrianImportHandler.importFile(MondrianImportHandler.java:106) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.SolutionImportHandler.importFile(SolutionImportHandler.java:155) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.ArchiveLoader.loadAll(ArchiveLoader.java:63) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:56) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.security.SecurityHelper.runAsSystem(SecurityHelper.java:396) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener.startup(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:421) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:77) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:343) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:311) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:212) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:135) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068) at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:759) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: java.sql.SQLException: socket creation error at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1679) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:271) ... 70 more 14:46:03,716 ERROR [PentahoDataSourceResolver] PentahoXmlaServlet.ERROR_0002 - IDatasourceService.UNABLE_TO_INSTANTIATE_OBJECT org.pentaho.platform.api.data.DBDatasourceServiceException: java.sql.SQLException: socket creation error at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:290) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledOrJndiDatasourceService.resolveDatabaseConnection(PooledOrJndiDatasourceService.java:31) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledOrJndiDatasourceService.resolveDatabaseConnection(DynamicallyPooledOrJndiDatasourceService.java:37) at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledOrJndiDatasourceService.retrieve(NonPooledOrJndiDatasourceService.java:51) at org.pentaho.platform.engine.services.connection.datasource.dbcp.BaseDatasourceService.getDataSource(BaseDatasourceService.java:69) at org.pentaho.platform.web.servlet.PentahoDataSourceResolver.lookup(PentahoDataSourceResolver.java:43) at mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:429) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:135) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91) at mondrian.olap.DriverManager.getConnection(DriverManager.java:113) at mondrian.olap.DriverManager.getConnection(DriverManager.java:69) at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:162) at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323) at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118) at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32) at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:187) at mondrian.server.FileRepository.getConnection(FileRepository.java:220) at mondrian.server.FileRepository.getConnection(FileRepository.java:182) at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.java:264) at org.pentaho.platform.plugin.action.olap.impl.OlapServiceImpl.getConnection(OlapServiceImpl.java:741) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.flushCacheForCatalog(MondrianCatalogHelper.java:659) at org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.addCatalog(MondrianCatalogHelper.java:650) at org.pentaho.platform.plugin.services.importer.MondrianImportHandler.importFile(MondrianImportHandler.java:106) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.SolutionImportHandler.importFile(SolutionImportHandler.java:155) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:115) at org.pentaho.platform.plugin.services.importer.ArchiveLoader.loadAll(ArchiveLoader.java:63) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:56) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener$1.call(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.security.SecurityHelper.runAsSystem(SecurityHelper.java:396) at org.pentaho.platform.plugin.action.defaultcontent.DefaultContentSystemListener.startup(DefaultContentSystemListener.java:43) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:421) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:412) at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:77) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:343) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:391) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:340) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:311) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:212) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:135) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068) at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:759) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: java.sql.SQLException: socket creation error at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1679) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceHelper.setupPooledDataSource(PooledDatasourceHelper.java:271) ... 70 more

    Pentaho BI Platform Tracking | 1 year ago | Kleyson Rios
    org.pentaho.platform.api.data.DBDatasourceServiceException: java.sql.SQLException: socket creation error

    5 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      The database is already in use by another process: org.hsqldb.persist.NIOLockFile@fa49b44d[file =/Luis/Workspace/realjira/jira-ide-support/target/jirahome/database/jiradb.lck, exists=true, locked=false, valid=false, fl =null]:

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcDriver.connect
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
      3. org.hsqldb.jdbcDriver.getConnection(Unknown Source)
      4. org.hsqldb.jdbcDriver.connect(Unknown Source)
      4 frames
    3. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:582)
      2. java.sql.DriverManager.getConnection(DriverManager.java:185)
      2 frames
    4. Commons DBCP
      PoolableConnectionFactory.makeObject
      1. org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:94)
      2. org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
      2 frames
    5. Commons Pool
      GenericObjectPool.borrowObject
      1. org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
      1 frame
    6. Commons DBCP
      PoolingDataSource.getConnection
      1. org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
      1 frame
    7. org.ofbiz.core
      ConnectionFactory.getConnection
      1. org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:96)
      2. org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)
      3. org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:142)
      4. org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:101)
      5. org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
      5 frames
    8. com.atlassian.jira
      LauncherContextListener$1.create
      1. com.atlassian.jira.ofbiz.DefaultOfBizConnectionFactory.getConnection(DefaultOfBizConnectionFactory.java:28)
      2. com.atlassian.jira.upgrade.util.UpgradeUtils.tableExists(UpgradeUtils.java:101)
      3. com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.databaseSetup(MinimumUpgradableVersionCheck.java:49)
      4. com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.isOk(MinimumUpgradableVersionCheck.java:30)
      5. com.atlassian.jira.startup.JiraDatabaseConfigChecklist.doStartupChecks(JiraDatabaseConfigChecklist.java:65)
      6. com.atlassian.jira.startup.JiraDatabaseConfigChecklist.startupOK(JiraDatabaseConfigChecklist.java:53)
      7. com.atlassian.jira.startup.DatabaseChecklistLauncher.start(DatabaseChecklistLauncher.java:33)
      8. com.atlassian.jira.startup.DefaultJiraLauncher$2.run(DefaultJiraLauncher.java:88)
      9. com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:248)
      10. com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:153)
      11. com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:83)
      12. com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:24)
      13. com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:61)
      14. com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:33)
      15. com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:56)
      16. com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:57)
      17. com.atlassian.jira.startup.LauncherContextListener$1.create(LauncherContextListener.java:52)
      17 frames
    9. com.atlassian.multitenant
      DefaultMultiTenantManager.startAll
      1. com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.get(MultiTenantComponentMapImpl.java:121)
      2. com.atlassian.multitenant.impl.MultiTenantComponentMapImpl.onTenantStart(MultiTenantComponentMapImpl.java:165)
      3. com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:134)
      4. com.atlassian.multitenant.impl.DefaultMultiTenantManager$1.consume(DefaultMultiTenantManager.java:131)
      5. com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForEachListener(DefaultMultiTenantManager.java:256)
      6. com.atlassian.multitenant.impl.DefaultMultiTenantManager.startTenant(DefaultMultiTenantManager.java:130)
      7. com.atlassian.multitenant.impl.DefaultMultiTenantManager.startAll(DefaultMultiTenantManager.java:203)
      7 frames
    10. com.atlassian.jira
      LauncherContextListener.contextInitialized
      1. com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:85)
      1 frame
    11. Glassfish Core
      Catalina.start
      1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
      2. org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
      3. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
      4. org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
      5. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
      6. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
      7. org.apache.catalina.core.StandardService.start(StandardService.java:516)
      8. org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
      9. org.apache.catalina.startup.Catalina.start(Catalina.java:583)
      9 frames
    12. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    13. Glassfish Core
      Bootstrap.main
      1. org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
      2. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
      2 frames