Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Workflow-manager is hanging with Processing...

Highlighted

Workflow-manager is hanging with Processing...

New Contributor

As workflow-manager is hung, I am trying to delete entries from Oozie-db configured on Derby database, however I am getting an error while delete records from table "Error: An SQL data change is not permitted for a read-only connection, user or database. (state=25502,code=30000)".

Launched Derby from command line using: java -cp .:/usr/hdp/2.6.5.0-292/oozie/libserver/derby-10.10.1.1.jar:/usr/hdp/2.6.5.0-292/phoenix/bin/../phoenix-4.7.0.2.6.5.0-292-thin-client.jar sqlline.SqlLine -d org.apache.derby.jdbc.EmbeddedDriver -u jdbc:derby:/hadoop/oozie/data/oozie-db -n none -p none --color=true --fastConnect=false --verbose=true --isolation=TRANSACTION_READ_UNCOMMITTED

It might be due to launching a Derby from non-admin account.

Your inputs would be greatly appreciated. Thank you.

1 REPLY 1

Re: Workflow-manager is hanging with Processing...

New Contributor

Any other solution to resume Workflow-manager on Ambari? I am following this, but couldn't delete entries mentioned above. link: https://community.hortonworks.com/articles/138689/oozie-jobs-get-stuck-in-prep-status.html

Don't have an account?
Coming from Hortonworks? Activate your account here