Uploaded image for project: 'mod-tags'
  1. mod-tags
  2. MODTAG-59

Issues observed upgrading from Juniper to Kiwi release

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      eHoldings Sprint 126, eHoldings Sprint 127
    • Story Points:
      3
    • Development Team:
      Spitfire
    • Release:
      R3 2021 Bug Fix
    • Epic Link:

      Description

      Overview: 

      We compared schema of a cleanly installed kiwi environment to kiwi bugfest (which was upgraded from Juniper and detected some differences/issues

      -tags table does not have uuid as 'created_by' column type (has text instead)

      • function 'upsert' is still present in kiwi bugfest environment 

      Also attaching logs from upgrade - error is observed on duplicate key 
      2021-10-12 20:33:45.228,"20:33:45 [674455/proxy;119604/tenant] [fs09000000] [] [mod-tags] INFO JavaLogger Change set db/changelog/changes/v1.0.0/create-indexes-and-initial-tags.xml::MODTAG-52@@populate-initial-tags::psmagin failed, but failOnError was false. Error: ERROR: duplicate key value violates unique constraint ""unq_tags_label""",kbf/mod-tags/a7e22e2253374bd5995a96da6b94e040
      2021-10-12 20:33:45.228, Detail: Key (label)=(important) already exists. [Failed SQL: (0) INSERT INTO fs09000000_mod_tags.tags (label) VALUES ('important')],kbf/mod-tags/a7e22e2253374bd5995a96da6b94e040

      Steps to Reproduce:

      1. Upgrade an existing Juniper environment to Kiwi 

      Expected Results: 

      Upgraded schema can be compared to a cleanly installed schema an no differences detected

      Actual Results:

      Differences detected and error message in log during upgrade
      Additional Information:
      URL:
      Interested parties:

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Igor_Gorchakov Igor Gorchakov
                Reporter:
                cgodfrey Carole Godfrey
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases