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

Bad database schema error for WF_ACTIONS table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • None
    • 5.1.0
    • core
    • 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-00.patch
          0.8 kB
          Abhishek Bafna
        2. OOZIE-2684-001.patch
          10 kB
          Kinga Marton
        3. OOZIE-2684-002.patch
          9 kB
          Kinga Marton
        4. OOZIE-2684-003.patch
          11 kB
          Kinga Marton
        5. OOZIE-2684-004.patch
          11 kB
          Kinga Marton

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: