[ https://issues.apache.org/jira/browse/OOZIE-2684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16566745#comment-16566745 ]
Julia Kinga Marton commented on OOZIE-2684: ------------------------------------------- There are other mismatches as well. Using mySql I've got the following errors: {code:java} 2018-08-02 14:53:44,883 INFO SchemaCheckXCommand:520 - SERVER[kmarton-MBP] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] About to check database schema 2018-08-02 14:53:44,919 ERROR SchemaCheckXCommand:517 - SERVER[kmarton-MBP] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Found [2] extra indexes for columns in table [BUNDLE_ACTIONS]: [last_modified_time, pending] 2018-08-02 14:53:44,924 ERROR SchemaCheckXCommand:517 - SERVER[kmarton-MBP] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Found [2] extra indexes for columns in table [COORD_JOBS]: [done_materialization, pending] 2018-08-02 14:53:44,929 ERROR SchemaCheckXCommand:517 - SERVER[kmarton-MBP] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Found [1] extra indexes for columns in table [WF_ACTIONS]: [wf_id] 2018-08-02 14:53:44,932 ERROR SchemaCheckXCommand:517 - SERVER[kmarton-MBP] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Database schema is BAD! Check previous error log messages for details {code} @Abhishek Bafna, do you have any plans with this issue? I can take it over, if you have other priorities :) > Bad database schema error for WF_ACTIONS table > ---------------------------------------------- > > Key: OOZIE-2684 > URL: https://issues.apache.org/jira/browse/OOZIE-2684 > Project: Oozie > Issue Type: Bug > Components: core > Reporter: Abhishek Bafna > Assignee: Abhishek Bafna > Priority: Blocker > Fix For: 5.1.0 > > Attachments: OOZIE-2684-00.patch > > > In {{SchemaCheckerService}}, Oozie compares expected and found indexed > columns and generates the below error message which could be confusing to the > users. > {noformat} > 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 > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)