Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-14679 META: DB layer 2.0
  3. MDL-20625

Nested DB transactions

    XMLWordPrintable

Details

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.0
    • 2.0
    • Database SQL/XMLDB
    • None
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE

    Description

      This topic was brought forward by Tim in http://moodle.org/mod/forum/discuss.php?d=135847

      I personally do not think we should start using the transactions in moodle core now, but in any case I already considered the nested transactions last year. At that time it could not be done because we were not yet using exceptions.

      Attaching patch that adds nested transactions without API changes, includes unittests.

      Attachments

        1. delegated_transactions_20091103.patch
          66 kB
          Petr Skoda
        2. delegated_transactions_20091104_2.patch
          69 kB
          Petr Skoda
        3. delegated_transactions_20091104_3.patch
          70 kB
          Petr Skoda
        4. delegated_transactions_20091104.patch
          68 kB
          Petr Skoda
        5. nested_transactions_3.patch
          19 kB
          Petr Skoda
        6. TransactionsAndExceptionsFlow.png
          41 kB
          Eloy Lafuente (stronk7)

        Issue Links

          caused a regression

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDL-47779 Review TODO with associated MDL's

          • Minor - Minor loss of function where workaround is possible
          • Open

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-30029 Add support for transactions when in message_send

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has a non-specific relationship to

          Improvement - An enhancement to an existing Moodle feature. MDL-20644 improve reliability of event triggering in DB transactions

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              skodak Petr Skoda
              Nobody Nobody
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                24/Nov/10