Uploaded image for project: 'Policy Framework'
  1. Policy Framework
  2. POLICY-3367

oom: policy-clamp-create-tables.sql: add IF NOT EXISTS clauses

    XMLWordPrintable

Details

    • Task
    • Status: Closed
    • Low
    • Resolution: Done
    • Honolulu Release
    • Istanbul Release
    • clamp
    • None
    • Policy 20/9-04/10

    Description

      In policy-clamp-create-tables.sql, none of the CREATE TABLE statements have IF NOT EXISTS clauses. This causes the database initialization job to fail erroneously if these tables are already present.

      kubectl -n onap logs onapdep-policy-clamp-galera-config-tv2dr
+ mysql -hpolicy-mariadb -P3306 -upolicy_user -p########### policyclamp
ERROR 1050 (42S01) at line 2: Table 'dictionary' already exists

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            ktimoney Kevin Timoney
            cianjohnston Cian Johnston
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: