[
https://issues.apache.org/jira/browse/OOZIE-2684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16578402#comment-16578402
]
Julia Kinga Marton commented on OOZIE-2684:
-------------------------------------------
In OOZIE-1717 new composite indices were added (manually, not via annotations),
but the schema checker handles only the those defined with annotations.
Those columns which are part of some composite indices, but they are not single
column ones, those will be reported by the Schema checker as extra indices.
> 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: Julia Kinga Marton
> 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)
