- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Migrating Oozie database from Oracle to MySql.
- Labels:
-
Apache Oozie
Created 07-05-2016 09:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I created the oozie user and database on MySql. In the process of migrating it, Oozie server won't start and i encountered the error "Runtime Exception during Services Load. Check your list of 'oozie.services' or 'oozie.services.ext' E0103: Could not load service classes, Cannot load JDBC driver class 'com.mysql.jdbc.Driver' org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot load JDBC driver class 'com.mysql.jdbc.Driver'". Any clue on what might be wrong or do I need to remove the Oozie service completely to migrate the DB? Note that I tested the connection while changing DB details in the config and it confirmed connection was ok. @Artem Ervits @Benjamin Leonhardi
Created 07-05-2016 10:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you try this -
1, download the mysql-connector-jar from: https://dev.mysql.com/downloads/connector/j/here 2. Copy the mysql-connector-java.jar to /usr/hdp/current/oozie-server/libext and /usr/hdp/current/oozie-server/libtools # cp mysql-connector-java.jar /usrhdp/current/oozie-server/libext 3. Prepare the oozie.war by: # sudo su -l oozie -c "/usr/hdp/current/oozie-server/bin/oozie-setup.sh prepare-war -d /usr/hdp/current/oozie-server/libext"
Created 07-05-2016 10:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you try this -
1, download the mysql-connector-jar from: https://dev.mysql.com/downloads/connector/j/here 2. Copy the mysql-connector-java.jar to /usr/hdp/current/oozie-server/libext and /usr/hdp/current/oozie-server/libtools # cp mysql-connector-java.jar /usrhdp/current/oozie-server/libext 3. Prepare the oozie.war by: # sudo su -l oozie -c "/usr/hdp/current/oozie-server/bin/oozie-setup.sh prepare-war -d /usr/hdp/current/oozie-server/libext"
Created 07-05-2016 10:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you @Sagar Shimpi. The mysql-connector-java.jar exist already. I have been using Hive with MySQL on the same node. Is it possible for the mysql-connector-java.jar to have issues and the DB connection test to be OK in Ambari Web UI?-
rw-r--r--. 1 oozie hadoop 819803 Jul 5 10:14 mysql-connector-java.jar
Created 07-06-2016 09:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The oozie server starts for less than a minute and stops thereafter. I'm still looking for a fix as this critical issue.
2016-07-06 08:03:37,483 FATAL Services:514 - SERVER['server'] Runtime Exception during Services Load. Check your list of 'oozie.services' or 'oozie.services.ext' 2016-07-06 08:03:37,487 FATAL Services:514 - SERVER['server'] E0103: Could not load service classes, Cannot load JDBC driver class 'com.mysql.jdbc.Driver' org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
Created 07-06-2016 10:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
IT's working fine now. Thank you @Sagar Shimpi
Created 08-08-2017 07:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Copy mysql-connector-java.jar jar file into /usr/hdp/current/oozie-server/oozie-server/webapps/oozie/WEB-INF/lib folder, this will solved problem