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

Failing MoodleNet tests when creating activity packages on Oracle

XMLWordPrintable

      See these failures on CI, all appear to have the same root cause:

      core\moodlenet\activity_packager_test::test_get_package
      stored_file_creation_exception: Cannot create file 26/core/moodlenet_resource/11681824490/assign_backup.mbz (ORA-01438: value larger than specified precision allowed for this column
      INSERT INTO t_files (contenthash,pathnamehash,contextid,component,filearea,itemid,filepath,filename,userid,filesize,mimetype,status,source,author,license,timecreated,timemodified,sortorder,referencefileid) VALUES (:contenthash,:pathnamehash,:contextid,:component,:filearea,:itemid,:filepath,:filename,:userid,:filesize,:mimetype,:status,:source,:author,:license,:timecreated,:timemodified,:sortorder,:referencefileid) RETURNING id INTO :oracle_id
      [array (
        'contenthash' => '7c4bfb3759cce223a5df5d8a10cd68985d0d479d',
        'pathnamehash' => '2aadd31dd0a7612de423dc815bf457d16944ceaa',
        'contextid' => 26,
        'component' => 'core',
        'filearea' => 'moodlenet_resource',
        'itemid' => '11681824490',
        'filepath' => '/',
        'filename' => 'assign_backup.mbz',
        'userid' => '2',
        'filesize' => '3672',
        'mimetype' => 'application/vnd.moodle.backup',
        'status' => '0',
        'source' => NULL,
        'author' => NULL,
        'license' => NULL,
        'timecreated' => '1681824490',
        'timemodified' => 1681824490,
        'sortorder' => '0',
        'referencefileid' => NULL,
      )])
       
      /var/www/html/lib/filestorage/file_storage.php:1199
      /var/www/html/lib/classes/moodlenet/activity_packager.php:164
      /var/www/html/lib/classes/moodlenet/activity_packager.php:86
      /var/www/html/lib/tests/moodlenet/activity_packager_test.php:120
      /var/www/html/lib/phpunit/classes/advanced_testcase.php:80
      

      Initial suspect is the odd definition of 'itemid' property, which would likely overflow the maximum length of that field

            pholden Paul Holden
            pholden Paul Holden
            Jake Dallimore Jake Dallimore
            Andrew Lyons Andrew Lyons
            CiBoT CiBoT
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 5 minutes
                1h 5m

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