[ 
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)

Reply via email to