oozie workflow failing

[#1]

Facing issues with oozie workflow. It is failing after we changed schema on one of the table.

ERROR SchemaCheckXCommand:517 - 

Found [1] extra indexes for columns in table [WF_ACTIONS]: [wf_id]

[#2 · Accepted solution]

@nyadav

That message is not causing your workflow to fail . Please find below article which explains the same. https://community.hortonworks.com/questions/57384/oozie-mysql-error-hortonworks-25oozie-mysql-error....

Can you please provide oozie logs for the workflow scheduled

oozie job -oozie http://<oozie host>:<oozie port>/oozie -log <WF_ID>