Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-3098

Work around deadlock when creating invoices

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.6.0-b1
    • Component/s: None
    • Labels:
      None

      Description

      A deadlock can sometimes be encountered when creating invoices for large data sets, particularly the combination of the cron running to create invoices from services while the system adds an invoice elsewhere.

      1. Replicate the deadlock consistently to fix
      2. Attempt to retry the transaction that deadlocked
      3. If necessary, wait before running
        • The script can sleep for a period of time (50-100ms) so there is a small window where a new invoice could be created if they are created too frequently that there is no time window for another process to create an invoice

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            tyson Tyson Phillips (Inactive)
            Reporter:
            tyson Tyson Phillips (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              28/May/19

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 3 hours, 53 minutes
              3h 53m

                Agile