Monday, 2025-11-24

*** mhen_ is now known as mhen02:30
*** ykarel_ is now known as ykarel09:05
opendevreviewQuentin GROLLEAU proposed openstack/keystone master: Index ON revocation_event table to optimize token checks.  https://review.opendev.org/c/openstack/keystone/+/92973609:35
*** ykarel__ is now known as ykarel12:44
dmsimard[m]hi, just putting a bit of visibility on this bug that bit us recently: https://bugs.launchpad.net/keystone/+bug/208108213:44
gtemaYes dmsimard - noticed respinned change. Linter gods demands another sacrifice13:45
dmsimard[m]we know about ('idx_revocation_event_composite', 'revocation_event', ['issued_before,user_id,project_id,audit_id']) but not sure about the other one13:46
gtemasadly me neither13:47
gtemaI can't really explain the potential usecase for myself. But on the other side it should not harm either13:47
gtemaon prtactice, however, the table should be relatively small13:48
dmsimard[m]for us it was small until it wasn't 😅13:49
dmsimard[m]there was a bug in glance that prevented it from creating trusts, fixing it lead to the growth of the revocation_event table which increased load and slowed down stuff13:50
gtemayeah, due to the pretty unfortunate keystone design there is no dedicated cleanup process for the table - this is definitely different with the KeystoneNG13:50
opendevreviewArtem Goncharov proposed openstack/keystone master: Index ON revocation_event table to optimize token checks.  https://review.opendev.org/c/openstack/keystone/+/92973613:52
opendevreviewArnaud Morin proposed openstack/keystone master: Add a new index on revocation_event table  https://review.opendev.org/c/openstack/keystone/+/92973613:53
opendevreviewTakashi Kajinami proposed openstack/oslo.policy master: Remove support for JSON format policy file  https://review.opendev.org/c/openstack/oslo.policy/+/92971515:55

Generated by irclog2html.py 4.0.0 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!