[OOZIE-2684] Bad database schema error for WF_ACTIONS table

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 5.1.0
• Component/s: core
• Assignee: Kinga Marton
• Reporter: Abhishek Bafna
• Created: 22/Sep/16 21:22
• Updated: 18/Jan/19 09:02
• Resolved: 29/Aug/18 14:24

Description

In SchemaCheckerService, Oozie compares expected and found indexed columns and generates the below error message which could be confusing to the users.

2016-09-16 12:39:26,564  INFO SchemaCheckXCommand:520 - SERVER[c6402.ambari.apache.org] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] About to check database schema
2016-09-16 12:39:26,703 ERROR SchemaCheckXCommand:517 - SERVER[c6402.ambari.apache.org] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Found [1] extra indexes for columns in table [WF_ACTIONS]: [wf_id]
2016-09-16 12:39:26,723 ERROR SchemaCheckXCommand:517 - SERVER[c6402.ambari.apache.org] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Database schema is BAD! Check previous error log messages for details

Issue Links

• is caused by: OOZIE-1717 Add indexes to speed up db queries
• links to: Review Board