You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by "Julia Kinga Marton (JIRA)" <ji...@apache.org> on 2018/08/02 13:00:00 UTC
[jira] [Commented] (OOZIE-2684) Bad database schema error for
WF_ACTIONS table
[ 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)