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/184.108.40.206-292/oozie/libserver/derby-10.10.1.1.jar:/usr/hdp/220.127.116.11-292/phoenix/bin/../phoenix-18.104.22.168.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.
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