Comment 3 for bug 2020195

Reviewed: https://review.opendev.org/c/openstack/ovn-octavia-provider/+/883662
Committed: https://opendev.org/openstack/ovn-octavia-provider/commit/028596705678b447797121049d542e06e1ad4355
Submitter: "Zuul (22348)"
Branch: master

commit 028596705678b447797121049d542e06e1ad4355
Author: Fernando Royo <email address hidden>
Date: Fri May 19 13:15:02 2023 +0200

    Add retry on case of sqlite3.InterfaceError on FT

    After a thorough review of the issue, it looks like that the problem
    does not originate from the base code of ovn-octavia-provider or
    neutron. Other projects are also experiencing this problem,
    indicating that it likely stems from a different source or set of
    libraries [1].

    To minimize the need for extensive rechecks on future patches, this
    patch introduces a retry mechanism, utilizing tenacity, to the
    affected methods.

    Once the root cause of the problem '(sqlite3.InterfaceError) Cursor
    needed to be reset because of commit/rollback and can no longer be
    fetched from,' is identified and resolved, this patch should be
    reverted.

    [1] https://opensearch.logs.openstack.org/_dashboards/app/discover/?security_tenant=global#/?_g=(filters:!(),refreshInterval:(pause:!t,value:0),time:(from:now-30d,to:now))&_a=(columns:!(_source),filters:!(('$state':(store:appState),meta:(alias:!n,disabled:!f,index:'94869730-aea8-11ec-9e6a-83741af3fdcd',key:build_status,negate:!f,params:(query:FAILURE),type:phrase),query:(match_phrase:(build_status:FAILURE)))),index:'94869730-aea8-11ec-9e6a-83741af3fdcd',interval:auto,query:(language:kuery,query:'message:%22Cursor%20needed%20to%20be%20reset%20because%20of%20commit%2F%22'),sort:!())

    Related-Bug: #2020195
    Change-Id: Ia7a9b5230f9cf56de8278b736022240a780130d6