<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 07/22/2015 05:39 PM, Adam Young
      wrote:<br>
    </div>
    <blockquote cite="mid:55B00D93.8010109@redhat.com" type="cite">
      <meta content="text/html; charset=windows-1252"
        http-equiv="Content-Type">
      <div class="moz-cite-prefix">On 07/22/2015 03:41 PM, Morgan
        Fainberg wrote:<br>
      </div>
      <blockquote
        cite="mid:A5C397AA-F300-4E80-9D69-0DF0777587C1@gmail.com"
        type="cite">
        <meta http-equiv="content-type" content="text/html;
          charset=windows-1252">
        <div>This is an indicator that the bottleneck is not the db
          strictly speaking, but also related to the way we match. This
          means we need to spend some serious cycles on improving both
          the stored record(s) for revocation events and the matching
          algorithm. <br>
        </div>
      </blockquote>
      <br>
      The simplest approach to revocation checking is to do a linear
      search through the events.  I think the old version of the code
      that did that is in a code review, and I will pull it out.<br>
      <br>
      If we remove the tree, then the matching will have to run through
      each of the records and see if there is a match;  the test will be
      linear with the number of records (slightly shorter if a token is
      actually revoked).<br>
    </blockquote>
    <br>
    This was the origianal, linear search version of the code.<br>
    <br>
<a class="moz-txt-link-freetext" href="https://review.openstack.org/#/c/55908/50/keystone/contrib/revoke/model.py,cm">https://review.openstack.org/#/c/55908/50/keystone/contrib/revoke/model.py,cm</a><br>
    <br>
    <blockquote cite="mid:55B00D93.8010109@redhat.com" type="cite"> <br>
      <br>
      <br>
      <br>
      <br>
      <blockquote
        cite="mid:A5C397AA-F300-4E80-9D69-0DF0777587C1@gmail.com"
        type="cite">
        <div><br>
          Sent via mobile</div>
        <div><br>
          On Jul 22, 2015, at 11:51, Matt Fischer <<a
            moz-do-not-send="true" href="mailto:matt@mattfischer.com">matt@mattfischer.com</a>>

          wrote:<br>
          <br>
        </div>
        <blockquote type="cite">
          <div>
            <div dir="ltr">Dolph,
              <div><br>
              </div>
              <div>Per our IRC discussion, I was unable to see any
                performance improvement here although not calling DELETE
                so often will reduce the number of deadlocks when we're
                under heavy load especially given the globally
                replicated DB we use.</div>
              <div><br>
              </div>
              <div><br>
              </div>
            </div>
            <div class="gmail_extra"><br>
              <div class="gmail_quote">On Tue, Jul 21, 2015 at 5:26 PM,
                Dolph Mathews <span dir="ltr"><<a
                    moz-do-not-send="true"
                    href="mailto:dolph.mathews@gmail.com"
                    target="_blank">dolph.mathews@gmail.com</a>></span>
                wrote:<br>
                <blockquote class="gmail_quote" style="margin:0 0 0
                  .8ex;border-left:1px #ccc solid;padding-left:1ex">
                  <div dir="ltr">Well, you might be in luck! Morgan
                    Fainberg actually implemented an improvement that
                    was apparently documented by Adam Young way back in
                    March: 
                    <div><br>
                        <a moz-do-not-send="true"
                        href="https://bugs.launchpad.net/keystone/+bug/1287757"
                        target="_blank">https://bugs.launchpad.net/keystone/+bug/1287757</a><br>
                    </div>
                    <div><br>
                    </div>
                    <div>There's a link to the stable/kilo backport in
                      comment #2 - I'd be eager to hear how it performs
                      for you!</div>
                    <div>
                      <div class="h5">
                        <div>
                          <div class="gmail_extra"><br>
                            <div class="gmail_quote">On Tue, Jul 21,
                              2015 at 5:58 PM, Matt Fischer <span
                                dir="ltr"><<a moz-do-not-send="true"
                                  href="mailto:matt@mattfischer.com"
                                  target="_blank">matt@mattfischer.com</a>></span>
                              wrote:<br>
                              <blockquote class="gmail_quote"
                                style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
                                <div dir="ltr">
                                  <div class="gmail_extra">Dolph,</div>
                                  <div class="gmail_extra"><br>
                                  </div>
                                  <div class="gmail_extra">Excuse the
                                    delayed reply, was waiting for a
                                    brilliant solution from someone.
                                    Without one, personally I'd prefer
                                    the cronjob as it seems to be the
                                    type of thing cron was designed for.
                                    That will be a painful change as
                                    people now rely on this behavior so
                                    I don't know if its feasible. I will
                                    be setting up monitoring for the
                                    revocation count and alerting me if
                                    it crosses probably 500 or so. If
                                    the problem gets worse then I think
                                    a custom no-op or sql driver is the
                                    next step.</div>
                                  <div class="gmail_extra"><br>
                                  </div>
                                  <div class="gmail_extra">Thanks.</div>
                                  <div>
                                    <div>
                                      <div class="gmail_extra"><br>
                                      </div>
                                      <div class="gmail_extra"><br>
                                        <div class="gmail_quote">On Wed,
                                          Jul 15, 2015 at 4:00 PM, Dolph
                                          Mathews <span dir="ltr"><<a
                                              moz-do-not-send="true"
                                              href="mailto:dolph.mathews@gmail.com"
                                              target="_blank">dolph.mathews@gmail.com</a>></span>
                                          wrote:<br>
                                          <blockquote
                                            class="gmail_quote"
                                            style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
                                            <div dir="ltr"><br>
                                              <div class="gmail_extra"><br>
                                                <div class="gmail_quote"><span>On

                                                    Wed, Jul 15, 2015 at
                                                    4:51 PM, Matt
                                                    Fischer <span
                                                      dir="ltr"><<a
                                                        moz-do-not-send="true"
href="mailto:matt@mattfischer.com" target="_blank">matt@mattfischer.com</a>></span>
                                                    wrote:<br>
                                                    <blockquote
                                                      class="gmail_quote"
                                                      style="margin:0px
                                                      0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
                                                      <div dir="ltr">I'm
                                                        having some
                                                        issues with
                                                        keystone
                                                        revocation
                                                        events. The
                                                        bottom line is
                                                        that due to the
                                                        way keystone
                                                        handles the
                                                        clean-up of
                                                        these events[1],
                                                        having more than
                                                        a few leads to:
                                                        <div><br>
                                                        </div>
                                                        <div> - bad
                                                          performance,
                                                          up to 2x
                                                          slower token
                                                          validation
                                                          with about 600
                                                          events based
                                                          on my perf
                                                          measurements.</div>
                                                        <div> - database
                                                          deadlocks,
                                                          which cause
                                                          API calls to
                                                          fail, more
                                                          likely with
                                                          more events it
                                                          seems</div>
                                                        <div><br>
                                                        </div>
                                                        <div>I am seeing
                                                          this behavior
                                                          in code from
                                                          trunk on June
                                                          11 using
                                                          Fernet tokens,
                                                          but the token
                                                          backend does
                                                          not seem to
                                                          make a
                                                          difference.</div>
                                                        <div><br>
                                                        </div>
                                                        <div>Here's what
                                                          happens to the
                                                          db in terms of
                                                          deadlock:</div>
                                                        <div>2015-07-15
                                                          21:25:41.082
                                                          31800 TRACE
                                                          keystone.common.wsgi
                                                          DBDeadlock:
                                                          (OperationalError)
                                                          (1213,
                                                          'Deadlock
                                                          found when
                                                          trying to get
                                                          lock; try
                                                          restarting
                                                          transaction')
                                                          'DELETE FROM
                                                          revocation_event
                                                          WHERE
                                                          revocation_event.revoked_at
                                                          < %s'
                                                          (datetime.datetime(2015,
                                                          7, 15, 18, 55,
                                                          41, 55186),)<br>
                                                        </div>
                                                        <div><br>
                                                        </div>
                                                        <div>When this
                                                          starts
                                                          happening, I
                                                          just go
                                                          truncate the
                                                          table, but
                                                          this is not
                                                          ideal. If [1]
                                                          is really true
                                                          then the
                                                          design is not
                                                          great, it
                                                          sounds like
                                                          keystone is
                                                          doing a
                                                          revocation
                                                          event clean-up
                                                          on every token
                                                          validation
                                                          call. Reading
                                                          and
                                                          deleting/locking
                                                          from my db
                                                          cluster is not
                                                          something I
                                                          want to do on
                                                          every validate
                                                          call.</div>
                                                      </div>
                                                    </blockquote>
                                                    <div><br>
                                                    </div>
                                                  </span>
                                                  <div>Unfortunately,
                                                    that's *exactly*
                                                    what keystone is
                                                    doing. Adam and I
                                                    had a conversation
                                                    about this problem
                                                    in Vancouver which
                                                    directly resulted in
                                                    opening the bug
                                                    referenced on the
                                                    operator list:<br>
                                                    <br>
                                                      <a
                                                      moz-do-not-send="true"
href="https://bugs.launchpad.net/keystone/+bug/1456797" target="_blank">https://bugs.launchpad.net/keystone/+bug/1456797</a><br>
                                                    <br>
                                                  </div>
                                                  <div>Neither of us
                                                    remembered the
                                                    actual implemented
                                                    behavior, which is
                                                    what you've run into
                                                    and Deepti verified
                                                    in the bug's
                                                    comments.<br>
                                                  </div>
                                                  <span>
                                                    <div> </div>
                                                    <blockquote
                                                      class="gmail_quote"
                                                      style="margin:0px
                                                      0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
                                                      <div dir="ltr">
                                                        <div><br>
                                                        </div>
                                                        <div>So, can I
                                                          turn of token
                                                          revocation for
                                                          now? I didn't
                                                          see an obvious
                                                          no-op driver.</div>
                                                      </div>
                                                    </blockquote>
                                                    <div><br>
                                                    </div>
                                                  </span>
                                                  <div>Not sure how,
                                                    other than writing
                                                    your own no-op
                                                    driver, or perhaps
                                                    an extended driver
                                                    that doesn't try to
                                                    clean the table on
                                                    every read?<br>
                                                  </div>
                                                  <span>
                                                    <div> </div>
                                                    <blockquote
                                                      class="gmail_quote"
                                                      style="margin:0px
                                                      0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
                                                      <div dir="ltr">
                                                        <div>And in the
                                                          long-run can
                                                          this be fixed?
                                                          I'd rather do
                                                          almost
                                                          anything else,
                                                          including
                                                          writing a
                                                          cronjob than
                                                          what happens
                                                          now.</div>
                                                      </div>
                                                    </blockquote>
                                                    <div><br>
                                                    </div>
                                                  </span>
                                                  <div>If anyone has a
                                                    better solution than
                                                    the current one,
                                                    that's also better
                                                    than requiring a
                                                    cron job on
                                                    something like
                                                    keystone-manage
                                                    revocation_flush I'd
                                                    love to hear it.<br>
                                                  </div>
                                                  <div><br>
                                                  </div>
                                                  <blockquote
                                                    class="gmail_quote"
                                                    style="margin:0px
                                                    0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><span>
                                                      <div dir="ltr">
                                                        <div><br>
                                                        </div>
                                                        <div>[1] - <a
                                                          moz-do-not-send="true"
href="http://lists.openstack.org/pipermail/openstack-operators/2015-June/007210.html"
target="_blank">http://lists.openstack.org/pipermail/openstack-operators/2015-June/007210.html</a></div>
                                                      </div>
                                                      <br>
                                                    </span>__________________________________________________________________________<br>
                                                    OpenStack
                                                    Development Mailing
                                                    List (not for usage
                                                    questions)<br>
                                                    Unsubscribe: <a
                                                      moz-do-not-send="true"
href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe"
                                                      rel="noreferrer"
                                                      target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
                                                    <a
                                                      moz-do-not-send="true"
href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev"
                                                      rel="noreferrer"
                                                      target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
                                                    <br>
                                                  </blockquote>
                                                </div>
                                                <br>
                                              </div>
                                            </div>
                                            <br>
__________________________________________________________________________<br>
                                            OpenStack Development
                                            Mailing List (not for usage
                                            questions)<br>
                                            Unsubscribe: <a
                                              moz-do-not-send="true"
href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe"
                                              rel="noreferrer"
                                              target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
                                            <a moz-do-not-send="true"
                                              href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev"
                                              rel="noreferrer"
                                              target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
                                            <br>
                                          </blockquote>
                                        </div>
                                        <br>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                                <br>
__________________________________________________________________________<br>
                                OpenStack Development Mailing List (not
                                for usage questions)<br>
                                Unsubscribe: <a moz-do-not-send="true"
href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe"
                                  rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
                                <a moz-do-not-send="true"
                                  href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev"
                                  rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
                                <br>
                              </blockquote>
                            </div>
                            <br>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                  <br>
__________________________________________________________________________<br>
                  OpenStack Development Mailing List (not for usage
                  questions)<br>
                  Unsubscribe: <a moz-do-not-send="true"
href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe"
                    rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
                  <a moz-do-not-send="true"
                    href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev"
                    rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
                  <br>
                </blockquote>
              </div>
              <br>
            </div>
          </div>
        </blockquote>
        <blockquote type="cite">
          <div><span>__________________________________________________________________________</span><br>
            <span>OpenStack Development Mailing List (not for usage
              questions)</span><br>
            <span>Unsubscribe: <a moz-do-not-send="true"
                href="mailto:OpenStack-dev-request@lists.openstack.org">OpenStack-dev-request@lists.openstack.org</a>?subject:unsubscribe</span><br>
            <span><a moz-do-not-send="true"
                href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a></span><br>
          </div>
        </blockquote>
        <br>
        <fieldset class="mimeAttachmentHeader"></fieldset>
        <br>
        <pre wrap="">__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:OpenStack-dev-request@lists.openstack.org?subject:unsubscribe">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a>
</pre>
      </blockquote>
      <br>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: <a class="moz-txt-link-abbreviated" href="mailto:OpenStack-dev-request@lists.openstack.org?subject:unsubscribe">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>