Found the problem. It was indeed because of incorrect oozie installation. Had to do a: sudo -u oozie /usr/lib/oozie/bin/ooziedb.sh create -run
Instead of: sudo /usr/lib/oozie/bin/ooziedb.sh create -sqlfile /usr/lib/oozie/oozie.sql -run Thanks, Som On Thu, Nov 21, 2013 at 9:58 AM, Som Satpathy <[email protected]> wrote: > 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 > >
