Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-74681

Reads directly after writes to a table are stale when using read replicas if the update takes too long

    XMLWordPrintable

Details

    Description

      We are experiencing an issue when an import of the big courses are failing with error/restore_controller_dbops_nonexisting error when we are using read replica set up.

      To replicate it you'd need a decent course that would take quite a while to restore. And import it to an empty course. 

      It works ok if we exclude backup_controllers table from hitting the read replica database.

      Attachments

        Issue Links

          Activity

            People

              srdjan Srdjan Jankovic
              dmitriim Dmitrii Metelkin
              cameron1729 cameron1729
              Victor Déniz Falcón Victor Déniz Falcón
              CiBoT CiBoT
              Adrian Greeve, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              2 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                22/Aug/22

                Time Tracking

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