Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-219

After a clean install, SQL schema installation fails for some of the files

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • None
    • None
    • Poller
    • None
    • Solaris 11 + Mysql 5.1 + Observium rev3605

    Description

      Trying to install the database schema some files fail because of some inconsistence between already existing structure (previous file). Didn't find a "schema" component so I added this issue to the Poller.

      001.sql
      002.sql
      ERROR 1060 (42S21) at line 1: Duplicate column name 'cipMacHCSwitchedBytes_input'
      003.sql
      ERROR 1051 (42S02) at line 4: Unknown table 'cempMemPool'
      004.sql
      ERROR 1060 (42S21) at line 2: Duplicate column name 'bill_autoadded'
      005.sql
      ERROR 1060 (42S21) at line 1: Duplicate column name 'can_modify_passwd'
      006.sql
      007.sql
      ERROR 1060 (42S21) at line 1: Duplicate column name 'version'
      008.sql
      009.sql
      010.sql
      011.sql
      012.sql
      013.sql
      014.sql
      015.sql
      016.sql
      017.sql
      018.sql
      019.sql
      020.sql
      021.sql
      022.sql
      023.sql
      024.sql
      025.sql
      026.sql
      027.sql
      028.sql
      ERROR 1091 (42000) at line 4: Can't DROP 'AcceptedPrefixes'; check that column/key exists
      029.sql
      ERROR 1146 (42S02) at line 1: Table 'test.sensors-state' doesn't exist
      030.sql
      031.sql
      032.sql
      ERROR 1071 (42000) at line 2: Specified key was too long; max key length is 767 bytes
      033.sql
      ERROR 1060 (42S21) at line 2: Duplicate column name 'app_instance'
      034.sql
      035.sql
      036.sql
      037.sql
      038.sql
      ERROR 1091 (42000) at line 1: Can't DROP 'UNIQUE'; check that column/key exists
      039.sql
      040.sql
      041.sql
      042.sql
      043.sql
      044.sql

      Made a quick review and generated a patch that makes it run without errors.

      Attachments

        Activity

          People

            adama Adam Armstrong
            ciriarte Ciro Iriarte
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: