Uploaded image for project: 'mod-users'
  1. mod-users
  2. MODUSERS-182

Issues with indexes upgrading to Edelweiss

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: TBD
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Template:

      Description

      While upgrading mod-users from Daisy to Edelweiss, we noticed that the following 3 indexes had problems:

      CREATE INDEX proxyfor_userid_idx_gin
      ON fs00001000_mod_users.proxyfor USING gin (lower(f_unaccent(jsonb ->> 'userId'::text)))

      ERROR: data type text has no default operator class for access method "gin"
      Hint: You must specify an operator class for the index or define a default operator class for the data type.
      Line: 1

      CREATE INDEX users_active_idx_gin
      ON fs00001000_mod_users.users USING gin (lower(f_unaccent(jsonb ->> 'active'::text)))

      ERROR: data type text has no default operator class for access method "gin"
      Hint: You must specify an operator class for the index or define a default operator class for the data type.
      Line: 1

      CREATE UNIQUE INDEX users_barcode_idx_unique
      ON fs00001000_mod_users.users USING btree (lower(f_unaccent(jsonb ->> 'barcode'::text)))

      ERROR: could not create unique index "users_barcode_idx_unique"
      Detail: Key (lower(f_unaccent(jsonb ->> 'barcode'::text)))=() is duplicated.
      Line: 1

        TestRail: Results

          Attachments

            Activity

              People

              Assignee:
              adam Adam Dickmeiss
              Reporter:
              sduvvuri Sobha Duvvuri
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  TestRail: Runs

                    TestRail: Cases