Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-15003

CloudLink - Update the Maintenance Service to remove 'old' records in tbCFAMessage

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Sprint:
      2021.R5 CloudLink Sprint 4, 2021.R5 CloudLink Sprint 5
    • SCRUM Team:
      Globogym Purple Cobras
    • Story Points:
      5
    • Work Type Classification:
      Sustaining

      Description

      We need to do update the Maintenance service to perform the following:

      • Create a new table, tbCFAMessage_SwitchTarget
      • Update Maintenance service to move the records from tbCFAMessage to tbCFAMessage_SwitchTarget every day at 12 am UTC.
      • Cleanup tbCFAMessage_SwitchTarget after a certain amount of time

      Gareth Leibbrandt: The goal of this story is to ensure that tbCFAMessage doesn't get too bloated. After X number of days, the 'Maintenance' service will move the records from tbCFAMessage to tbCFAMessage_SwitchTarget. Then (I think) after a certain amount of days, tbCFAMessage_SwitchTarget is then cleaned out

        Attachments

          Issue Links

          There are no Sub-Tasks for this issue.

            Activity

              People

              • Assignee:
                Gareth.Leibbrandt Gareth Leibbrandt (Inactive)
                Reporter:
                brent.jacobz Brent Jacobz (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 21.5h
                  21.5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 16h Time Not Required
                  16h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.