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

LTI errors during unit tests on sqlsrv, caused by AdoDB tests changing logging options

    XMLWordPrintable

Details

    Description

      Seen on Moodle CI: https://ci.moodle.org/view/B%20-%20master/job/W.01.04%20-%20PHPUnit%20-%20MSSQL/1829/console

      ........................................................... 12685 / 19070 ( 66%)
      ......................................sqlsrv_query: SQLSTATE = 23000
      sqlsrv_query: error code = 2601
      sqlsrv_query: message = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.t_enrol_lti_app_registration' with unique index 't_enroltiappregi_pla_uix'. The duplicate key value is (1f308714aaa22ea1bfb352a5db424300a8e42fa4f74c57f37122510e6573d38c).
      sqlsrv_query: SQLSTATE = 01000
      sqlsrv_query: error code = 3621
      sqlsrv_query: message = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.
      .........sqlsrv_query: SQLSTATE = 23000
      sqlsrv_query: error code = 2601
      sqlsrv_query: message = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.t_enrol_lti_context' with unique index 't_enrolticont_lticon_uix'. The duplicate key value is (1, CTX123).
      sqlsrv_query: SQLSTATE = 01000
      sqlsrv_query: error code = 3621
      sqlsrv_query: message = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.
      ........sqlsrv_query: SQLSTATE = 23000
      sqlsrv_query: error code = 2601
      sqlsrv_query: message = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.t_enrol_lti_deployment' with unique index 't_enroltidepl_pladep_uix'. The duplicate key value is (1, Deploy_ID_123).
      sqlsrv_query: SQLSTATE = 01000
      sqlsrv_query: error code = 3621
      sqlsrv_query: message = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.
      .... 12744 / 19070 ( 66%)
      ...............sqlsrv_query: SQLSTATE = 23000
      sqlsrv_query: error code = 2601
      sqlsrv_query: message = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.t_enrol_lti_resource_link' with unique index 't_enroltiresolink_reslti_uix'. The duplicate key value is (res-link-1, 1).
      sqlsrv_query: SQLSTATE = 01000
      sqlsrv_query: error code = 3621
      sqlsrv_query: message = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.
      ............................................ 12803 / 19070 ( 67%)
      ........................................................... 12862 / 19070 ( 67%)
      

      & Workplace: https://ci.moodle.org/view/MW/job/MW400.01.03%20-%20PHPUnit%20-%20MSSQL/34/console (same errors as above)

      Note the error is absent from Workplace 311 tests, and Moodle 311 tests (thanks stronk7, also for suggesting relation to MDL-74138)

      Last important note, that these exceptions strangely don't cause test failures

      Attachments

        Issue Links

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              pholden Paul Holden
              Jake Dallimore Jake Dallimore
              Jun Pataleta Jun Pataleta
              CiBoT CiBoT
              David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                9/May/22

                Time Tracking

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