You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by "Biju Nair (JIRA)" <ji...@apache.org> on 2015/02/10 17:46:12 UTC
[jira] [Updated] (OOZIE-2136) Oozie server startup error when JDBC
URL for a MySql DB with HA is used
[ https://issues.apache.org/jira/browse/OOZIE-2136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Biju Nair updated OOZIE-2136:
-----------------------------
Description:
Two instances of MySql DB is set-up on two nodes with HA. When tried to use the value {{jdbc:mysql://bcpc-vm1,bcpc-vm2/oozie}} for the property {{oozie.service.JPAService.jdbc.url}} Oozie start-up fails. The URL format is as per MySql [specification|http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html].The following is the error entry in the Oozie log.
2015-02-10 10:48:14,811 INFO HadoopAccessorService:543 - USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] final password is xHGotFJ3c6WxgojAGKZP
2015-02-10 10:48:15,525 FATAL Services:537 - Runtime Exception during Services Load. Check your list of 'oozie.services' or 'oozie.services.ext'
2015-02-10 10:48:15,531 FATAL Services:537 - USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] E0103: Could not load service classes, Cannot create PoolableConnectionFactory (No database selected)
org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot create PoolableConnectionFactory (No database selected)
at org.apache.oozie.service.Services.loadServices(Services.java:306)
at org.apache.oozie.service.Services.init(Services.java:210)
at org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:45)
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:799)
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.deployWAR(HostConfig.java:943)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
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:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
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:754)
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: <openjpa-2.2.2-r422266:1468616 fatal general error> org.apache.openjpa.persistence.PersistenceException: Cannot create PoolableConnectionFactory (No database selected)
at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102)
at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603)
at org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1518)
at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:531)
at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:456)
was:
Two instances of MySql DB is set-up on two nodes with HA. When tried to use the value {{<value>jdbc:mysql://bcpc-vm1,bcpc-vm2/oozie</value>}} for the property {{<name>oozie.service.JPAService.jdbc.url</name>}} Oozie start-up fails. The following is the error entry in the Oozie log.
2015-02-10 10:48:14,811 INFO HadoopAccessorService:543 - USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] final password is xHGotFJ3c6WxgojAGKZP
2015-02-10 10:48:15,525 FATAL Services:537 - Runtime Exception during Services Load. Check your list of 'oozie.services' or 'oozie.services.ext'
2015-02-10 10:48:15,531 FATAL Services:537 - USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] E0103: Could not load service classes, Cannot create PoolableConnectionFactory (No database selected)
org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot create PoolableConnectionFactory (No database selected)
at org.apache.oozie.service.Services.loadServices(Services.java:306)
at org.apache.oozie.service.Services.init(Services.java:210)
at org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:45)
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:799)
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.deployWAR(HostConfig.java:943)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
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:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
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:754)
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: <openjpa-2.2.2-r422266:1468616 fatal general error> org.apache.openjpa.persistence.PersistenceException: Cannot create PoolableConnectionFactory (No database selected)
at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102)
at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603)
at org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1518)
at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:531)
at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:456)
> Oozie server startup error when JDBC URL for a MySql DB with HA is used
> -------------------------------------------------------------------------
>
> Key: OOZIE-2136
> URL: https://issues.apache.org/jira/browse/OOZIE-2136
> Project: Oozie
> Issue Type: Bug
> Components: core
> Reporter: Biju Nair
> Labels: oozie
>
> Two instances of MySql DB is set-up on two nodes with HA. When tried to use the value {{jdbc:mysql://bcpc-vm1,bcpc-vm2/oozie}} for the property {{oozie.service.JPAService.jdbc.url}} Oozie start-up fails. The URL format is as per MySql [specification|http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html].The following is the error entry in the Oozie log.
> 2015-02-10 10:48:14,811 INFO HadoopAccessorService:543 - USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] final password is xHGotFJ3c6WxgojAGKZP
> 2015-02-10 10:48:15,525 FATAL Services:537 - Runtime Exception during Services Load. Check your list of 'oozie.services' or 'oozie.services.ext'
> 2015-02-10 10:48:15,531 FATAL Services:537 - USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] E0103: Could not load service classes, Cannot create PoolableConnectionFactory (No database selected)
> org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot create PoolableConnectionFactory (No database selected)
> at org.apache.oozie.service.Services.loadServices(Services.java:306)
> at org.apache.oozie.service.Services.init(Services.java:210)
> at org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:45)
> 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:799)
> 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.deployWAR(HostConfig.java:943)
> at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
> 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:1065)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
> 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:754)
> 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: <openjpa-2.2.2-r422266:1468616 fatal general error> org.apache.openjpa.persistence.PersistenceException: Cannot create PoolableConnectionFactory (No database selected)
> at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102)
> at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603)
> at org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1518)
> at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:531)
> at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:456)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)