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

    • MOODLE_400_STABLE
    • MOODLE_311_STABLE
    • Hide

      Do not run auth_db or enrol_database tests with SQL*Server :-P

      Show
      Do not run auth_db or enrol_database tests with SQL*Server :-P
    • Hide

      Just ensure that PHPUnit jobs @ CIs with the patch applied aren't getting, in the console any "sqlsrv_query" debugging anymore.

      You can find some runs below, in the comments (by ToBiC)

      Show
      Just ensure that PHPUnit jobs @ CIs with the patch applied aren't getting, in the console any "sqlsrv_query" debugging anymore. You can find some runs below, in the comments (by ToBiC)

      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

            stronk7 Eloy Lafuente (stronk7)
            pholden Paul Holden
            Jake Dallimore Jake Dallimore
            Jun Pataleta Jun Pataleta
            CiBoT CiBoT
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

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

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.