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

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

XMLWordPrintable

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

      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

            ktimoney ktimoney
            cianjohnston cianjohnston
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: