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

Error when running Cron on MS SQL Server



    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Not a bug
    • Affects Version/s: 2.3
    • Fix Version/s: None
    • Component/s: Administration
    • Labels:
    • Database:
      Microsoft SQL
    • Affected Branches:


      I have just upgraded to a fresh version of Moodle 2.3 stable, no issues for install. On running the Cron I recieve the below error.

      Server Time: Thu, 28 Jun 2012 15:23:16 +1000
      Running clean-up tasks...
       Deleted old backup records
       Deleted old cache_text records
       Cleaned up context instances
       Built context paths
       Cleaned cache flags
       Cleaned up read notifications
      ...finished clean-up tasks
       Created missing context instances
      Cleaned up stale user sessions
      Running auth crons if required...
      Running enrol crons if required...
      Starting activity modules
      Processing module function assignment_cron ...... used 2 dbqueries
      ... used 0.020028114318848 seconds
      Processing module function forum_cron ...Starting digest processing...
      Cleaned old digest records
      ... used 4 dbqueries
      ... used 0.0063979625701904 seconds
      Processing module function quiz_cron ...
      Starting quiz reports
      Finished quiz reports
      ... used 3 dbqueries
      ... used 0.011386871337891 seconds
      Processing module function assign_cron ...done.
      ... used 6 dbqueries
      ... used 0.042878150939941 seconds
      Finished activity modules
      Starting blocks
      Finished blocks
      Starting admin reports
      Finished admin reports
      Starting main gradebook job...
      Starting processing the event queue...
      Starting the completion cron...
      Marking users as started
      Running completion_criteria_date->cron()
      Running completion_criteria_activity->cron()
      Running completion_criteria_duration->cron()
      Running completion_criteria_grade->cron()
      Running completion_criteria_course->cron()
      Aggregating completions
      Starting course reports
      Finished course reports
      Starting gradebook plugins
      Finished gradebook plugins
      Fetching external blog entries...done.
      Deleting blog associations linked to non-existent contexts...done.
      Starting registration update on hubs...
      Finished registration update on hubs.
      Recently fetched info about available updates is still fresh enough, skipping.
      Deleting session linked tokens more than one day old...done.
      Starting repository plugins
      Processing cron function for repository_dropbox...
      done. (1 dbqueries, 0 seconds)
      Finished repository plugins
      Starting admin tools
      Processing cron function for tool_qeupgradehelper...
      done. (1 dbqueries, 0 seconds)
      Finished admin tools
      Checking automated backup status...INACTIVE
      ...preventing stats to run, more than 4 hours since scheduled time.
      Deleting old draft files... !!! Error reading from database !!!
      !! SQLState: 42000<br />
      Error Code: 3988<br />
      Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]New transaction is not allowed because there are other threads running in the session.<br />
      native sqlsrv_begin_transaction
      Error code: dmlreadexception !!
      !! Stack trace: * line 407 of \lib\dml\moodle_database.php: dml_read_exception thrown
      * line 258 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database-&gt;query_end()
      * line 1368 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database-&gt;query_end()
      * line 2101 of \lib\dml\moodle_database.php: call to sqlsrv_native_moodle_database-&gt;begin_transaction()
      * line 267 of \lib\filestorage\stored_file.php: call to moodle_database-&gt;start_delegated_transaction()
      * line 604 of \lib\filestorage\file_storage.php: call to stored_file-&gt;delete()
      * line 1841 of \lib\filestorage\file_storage.php: call to file_storage-&gt;delete_area_files()
      * line 460 of \lib\cronlib.php: call to file_storage-&gt;cron()
      * line 88 of \admin\cron.php: call to cron_run()


          Issue Links



              • Votes:
                15 Vote for this issue
                18 Start watching this issue


                • Created: