DVCS accumulates events in the AO_E8B6CC_SYNC_EVENT table

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: 8.20.21, 9.7.0, 9.8.0
    • Component/s: DVCS Connector
    • 8.2
    • 4
    • Severity 2 - Major

      Issue Summary

      This is reproducible on Data Center: yes

      Steps to Reproduce

      1. Run synchronisation of a big repository that needs a lot of time to finish

      Expected Results

      The size of AO_E8B6CC_SYNC_EVENT table fluctuates but doesn't grow indefinitely.

      Actual Results

      Events are accumulated in the table and are not fired unless the synchronisation process is finished. For some repositories the sync process can be long-running (a few months) so the table can accumulate million of events which are usually irrelevant after such a timespan.

      Workaround

      Remove redundant events from the table. The most common event is "DevSummaryChangedEvent" which triggers cache refresh for the development panel plugin. Its cache is automatically invalidated after 30 minutes, so removing those events won't affect eventual consistency of dev status.

       

      delete from "AO_E8B6CC_SYNC_EVENT" where "EVENT_CLASS" = 'com.atlassian.jira.plugins.dvcs.event.DevSummaryChangedEvent'; 

       

       

            Assignee:
            awojtasik
            Reporter:
            Sławomir Zaraziński
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: