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

          [OBS-219] After a clean install, SQL schema installation fails for some of the files

          committed in #3609.

          these were just duplicates left over from various database changes. nothing to worry about, the database was fine in the end.

          applied to remove errors.

          adama Adam Armstrong added a comment - committed in #3609. these were just duplicates left over from various database changes. nothing to worry about, the database was fine in the end. applied to remove errors.

          People

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

            Dates

              Created:
              Updated:
              Resolved: