Hi All,
I have installed and set up oozie on a single node ubuntu box. When I try
to run the following simple workflow.xml:
<workflow-app xmlns='uri:oozie:workflow:0.4' name='test-wf'> <start
to='end'/> <end name='end'/></workflow-app>
I get the following error:
*Error: E0803 : E0803: IO error, E0603: SQL error in operation,
<openjpa-2.2.2-r422266:1468616 fatal store error>
org.apache.openjpa.persistence.RollbackException: The transaction has been
rolled back. See the nested exceptions for details on the errors that
occurred. FailedObject: org.apache.oozie.WorkflowJobBean@120942eb*
I had pushed the workflow.xml to HDFS, and following are my job.properties:
# Oozie job properties.
nameNode=hdfs://localhost:8020
jobTracker=localhost:8021
queueName=default
workflowDir=processing-workflows
oozie.wf.application.path=${nameNode}/user/${user.name
}/${workflowDir}/test-wf
I installed oozie based on (
http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/latest/CDH4-Installation-Guide/cdh4ig_topic_17_5.html),
following is my script:
sudo apt-get install -y oozie
sudo apt-get install -y oozie-client
sudo apt-get install -y unzip
sudo wget -cv http://archive.cloudera.com/gplextras/misc/ext-2.2.zip
sudo unzip ext-2.2.zip
sudo cp -r ext-2.2 /usr/lib/oozie/libext
sudo /usr/lib/oozie/bin/ooziedb.sh create -sqlfile /usr/lib/oozie/oozie.sql
-run
sudo chmod -R 1777 /var/log/oozie
sudo service oozie start
I suspect, the cause of the error above is because of faulty installation
of oozie. Please share your inputs on what could be causing this problem
and how to resolve this.
Thanks,
Som
