Uploaded image for project: 'Oozie'
  1. Oozie
  2. OOZIE-2684

Bad database schema error for WF_ACTIONS table

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.1.0
    • Component/s: core
    • Labels:
      None

      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
      

        Attachments

        1. OOZIE-2684-004.patch
          11 kB
          Kinga Marton
        2. OOZIE-2684-003.patch
          11 kB
          Kinga Marton
        3. OOZIE-2684-002.patch
          9 kB
          Kinga Marton
        4. OOZIE-2684-001.patch
          10 kB
          Kinga Marton
        5. OOZIE-2684-00.patch
          0.8 kB
          Abhishek Bafna

          Issue Links

            Activity

              People

              • Assignee:
                kmarton Kinga Marton
                Reporter:
                abhishekbafna Abhishek Bafna
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: