java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found )

Atlassian JIRA | Vladimir Vasilkin | 9 months ago
  1. 0

    Our test team catch the problem when start Jira SW 7.1.1 with Oracle DB. Jira ran correctly before (version 7.1.0). Errors from catalina.out: {noformat} 2016-03-03 12:39:18,971 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully. 2016-03-03 12:39:19,552 JIRA-Bootstrap ERROR [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:oracle:thin:@db:1521:XE', driverClassName='oracle.jdbc.OracleDriver', username='db_tc_j7_10277', password='********', isolationLevel='null', conne ctionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=20, minSize=20, initialSize=null, maxIdle=20, maxWait=30000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery='select 1 from dual', minEvictableTimeMill is=60000, timeBetweenEvictionRunsMillis=300000, poolPreparedStatements=null, testOnBorrow=false, testOnReturn=null, testWhileIdle=true, maxOpenPreparedStatements=null, numTestsPerEvictionRun=null, removeAbandonedOnBorrow=true, removeAbandonedOnMaintanance=null, removeAba ndonedTimeout=300, validationQueryTimeout=null, defaultCatalog=null}} java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found ) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2291) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2038) at org.apache.commons.dbcp2.BasicDataSource.setLogWriter(BasicDataSource.java:1625) at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:103) at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:164) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:136) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59) at org.ofbiz.core.entity.ConnectionFactory$1.getConnection(ConnectionFactory.java:52) at org.ofbiz.core.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:133) at org.ofbiz.core.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:904) at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:167) at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:145) at org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1475) at org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:270) at org.ofbiz.core.entity.GenericDelegator.initialiseAndCheckDatabase(GenericDelegator.java:238) at org.ofbiz.core.entity.GenericDelegator.<init>(GenericDelegator.java:169) at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:93) at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:90) at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319) at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) at com.google.common.cache.LocalCache.get(LocalCache.java:3937) at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941) at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824) at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4830) at org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:107) at com.atlassian.core.ofbiz.CoreFactory.getGenericDelegator(CoreFactory.java:34) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.configureOfbiz(DatabaseConfigurationManagerImpl.java:215) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:295) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:199) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:132) at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:103) at com.atlassian.jira.startup.DefaultJiraLauncher$$Lambda$3/1921819642.run(Unknown Source) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:101) at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:115) at com.atlassian.jira.startup.LauncherContextListener$$Lambda$1/1779378539.run(Unknown Source) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:480) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:416) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:825) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:596) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2301) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2287) ... 39 more 2016-03-03 12:39:19,587 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Unable to establish a connection with the database... Error was:java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found ... {noformat} Workaround is to set timezone environment. We use TZ=UTC now. It works. Jira starts correctly. Default system timezone is: {noformat} # more /etc/timezone Etc/UTC {noformat}

    Atlassian JIRA | 9 months ago | Vladimir Vasilkin
    java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found )
  2. 0

    11gR2 Fresh Install , Enterprise Manager dbconfig failure.

    Oracle Community | 7 years ago | 648231
    java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found
  3. 0

    Could not open connection after migration from Oracle 10g to 11g driver

    Stack Overflow | 1 year ago | divanov
    java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle 10g connetion error from datasources

    YouTrack | 4 years ago
    java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found
  6. 0

    Sqoop: Oracle Import -- ORA-01882: timezone region not found Issue.(Very Urgent) - Grokbase

    grokbase.com | 1 year ago
    java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

    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

      Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found )

      at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory()
    2. Apache Commons DBCP
      BasicDataSource.setLogWriter
      1. org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2291)
      2. org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2038)
      3. org.apache.commons.dbcp2.BasicDataSource.setLogWriter(BasicDataSource.java:1625)
      3 frames
    3. org.ofbiz.core
      GenericDelegator$1.load
      1. org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:103)
      2. org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)
      3. org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:164)
      4. org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:136)
      5. org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
      6. org.ofbiz.core.entity.ConnectionFactory$1.getConnection(ConnectionFactory.java:52)
      7. org.ofbiz.core.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:133)
      8. org.ofbiz.core.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:904)
      9. org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:167)
      10. org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:145)
      11. org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1475)
      12. org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:270)
      13. org.ofbiz.core.entity.GenericDelegator.initialiseAndCheckDatabase(GenericDelegator.java:238)
      14. org.ofbiz.core.entity.GenericDelegator.<init>(GenericDelegator.java:169)
      15. org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:93)
      16. org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:90)
      16 frames
    4. Guava
      LocalCache$LocalLoadingCache.getUnchecked
      1. com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
      2. com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
      3. com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
      4. com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
      5. com.google.common.cache.LocalCache.get(LocalCache.java:3937)
      6. com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
      7. com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
      8. com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4830)
      8 frames
    5. org.ofbiz.core
      GenericDelegator.getGenericDelegator
      1. org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:107)
      1 frame
    6. com.atlassian.core
      CoreFactory.getGenericDelegator
      1. com.atlassian.core.ofbiz.CoreFactory.getGenericDelegator(CoreFactory.java:34)
      1 frame
    7. com.atlassian.jira
      DefaultJiraLauncher.lambda$start$0
      1. com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.configureOfbiz(DatabaseConfigurationManagerImpl.java:215)
      2. com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:295)
      3. com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:199)
      4. com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:132)
      5. com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:103)
      5 frames