Uploaded image for project: 'Red Hat build of Keycloak'
  1. Red Hat build of Keycloak
  2. RHBK-2443

Upgrade 26.0.5 -> 26.0.6 completely breaks admin events in the admin UI [GHI#35288]

XMLWordPrintable

    • False
    • Hide

      None

      Show
      None
    • False

      Before reporting an issue

      [X] I have read and understood the above terms for submitting issues, and I understand that my issue may be closed without action if I do not follow them.

      Area

      admin/ui

      Describe the bug

      When upgrading from KC 26.0.5 to 26.0.6 with a PostgreSQL database,
      the new 'details_json' column was introduced.
      However, when we have some admin events already in there, the column stays NULL.

      When already having admin events pre upgrade, the UI completely breaks when opening the event view,
      and the REST call to /admin/realms/master/admin-events?first=0&max=51 returns an error 404 with the message {{

      {"error":"unknown_error","error_description":"Cannot parse the JSON"}

      }}.

      Manually executing UPDATE admin_event_entity SET details_json='{}' WHERE details_json IS NULL; against the database fixes the view, but the admin events are almost all empty.

      Version

      26.0.6

      Regression

      [x] The issue is a regression

      Expected behavior

      A bugfix version upgrade should not break the database.

      Actual behavior

      A bugfix version upgrade broke the database.

      How to Reproduce?

      1. Install KC 26.0.5 with PostgreSQL as the database.
      2. Enable admin events
      3. Generate some admin events (REALM UPDATE and CLIENT CREATE) in our testsystem)
      4. Upgrade to KC 26.0.6
      5. Try to access the event view, the UI only shows a red error message.

      Anything else?

      No response

              Unassigned Unassigned
              pvlha Pavel Vlha
              Keycloak UI
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: