Uploaded image for project: 'Red Hat OpenStack Services on OpenShift'
  1. Red Hat OpenStack Services on OpenShift
  2. OSPRH-10457

trust and trust_role tables are never archived (shadow or not) and there're no supported mechanism to clean those

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • None
    • openstack-keystone
    • False
    • Hide

      None

      Show
      None
    • True
    • ?
    • None
    • Low

      Description of problem:
      trust and trust_role tables are never archived (shadow or not) and there're no supported mechanism to clean those:

      MariaDB [keystone]> delete from trust_role where trust_id in (select id from trust where deleted_at is not null);
      Query OK, 3950918 rows affected (18.978 sec)

      MariaDB [keystone]> delete from trust where deleted_at is not null;
      Query OK, 1975401 rows affected (46.569 sec)

      Version-Release number of selected component (if applicable):

      How reproducible:

      Steps to Reproduce:
      1.
      2.
      3.

      Actual results:

      Expected results:

      Additional info:

              Unassigned Unassigned
              dwilde@redhat.com Dave Wilde
              rhos-dfg-security
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: