Details
-
Bug
-
Resolution: Fixed
-
Critical
-
None
-
None
-
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.