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

Update to Rev 8850, database update errors

Details

    • Bug
    • Resolution: Not A Bug
    • Trivial
    • None
    • Professional Edition
    • Authentication
    • CentOS7

    Description

      Trivial bug during upgrade process, unable to drop  a column that doesn't exist. 

       

      ./discovery.php -u showed 1 error during the database/file schema update process.

       

      – Updating database/file schema
      346 -> 347 # (db) . Done (0s).
      347 -> 348 # (db) F Done (0s, 1 errors).
      348 -> 349 # (db) .. Done (0s).
      349 -> 350 # (php) Done (0s).
      350 -> 351 # (db) ..... Done (0s).
      351 -> 352 # (db) .. Done (0s).

       

      cat /opt/observium/logs/update-errors.log

      [2017/09/20 17:09:35 +0000] discovery.php(1720): ====== Schema update 347 -> 348 ==============
      [2017/09/20 17:09:35 +0000] discovery.php(1720): Query: ALTER TABLE `authlog` DROP `mechanism`;
      [2017/09/20 17:09:35 +0000] discovery.php(1720): Error: (1091) Can't DROP 'mechanism'; check that column/key exists

       

      Attachments

        Activity

          [OBS-2435] Update to Rev 8850, database update errors

          It doesn't exist because it was accidentally created on only some installs, and thus is deleted from only some installs.

          adama Adam Armstrong added a comment - It doesn't exist because it was accidentally created on only some installs, and thus is deleted from only some installs.

          People

            sid3windr Tom Laermans
            dbegley Dave
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: