Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-6496

Can't update PostgreSQL database to 1.12.5

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.12.5
    • Fix Version/s: 14.0.0
    • Component/s: Database
    • Security Level: Default (Default Security Scheme)
    • Labels:

      Description

      While updating opennms database 1.10.10 to 1.12.5 with
      /usr/share/opennms/bin/install -disU
      I received two errors:
      1) opennms tries to bind variable to table name in ALTER TABLE .. OWNER TO statement, which fails with PostgreSQL JDBC driver
      2) opennms tries to alter nonexisting table (ALTER TABLE daily_series OWNER TO opennms)

      Attached patch fixes these issues.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              schlend David Schlenk
              Reporter:
              alp Alexander Pyhalov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: