You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by "Dénes Bodó (Jira)" <ji...@apache.org> on 2021/06/18 07:57:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=17365300#comment-17365300 ]
Dénes Bodó commented on OOZIE-2136:
-----------------------------------
I think the solution can be around OOZIE-2574 where the JDBC URL which contains comma (,) is surrounded with quotation marks (").
Let me test against some databases if using quotation marks always around the JDBC URL breaks something or not.
> 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
> Assignee: Dénes Bodó
> Priority: Major
> 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:3306/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
(v8.3.4#803005)