-------------------------------- SELECT * FROM mdl_user WHERE id = ? AND deleted = ? [array ( 0 => '10052', 1 => 0, )] -------------------------------- Query took: 0.00054693222045898 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE contextlevel = ? AND instanceid = ? [array ( 0 => 50, 1 => '1', )] -------------------------------- Query took: 0.00023698806762695 seconds. -------------------------------- Server Time: Wed, 18 Oct 2023 14:58:58 +0200 -------------------------------- SELECT * FROM mdl_task_adhoc WHERE id = ? [array ( 0 => 40018479, )] -------------------------------- Query took: 0.00022220611572266 seconds. -------------------------------- -------------------------------- SELECT GET_LOCK(?, ?) AS locked [array ( 0 => 'c4174f88206105df0173e84566d6a2b44b5dba13', 1 => 0, )] -------------------------------- Query took: 0.00016093254089355 seconds. -------------------------------- -------------------------------- SELECT GET_LOCK(?, ?) AS locked [array ( 0 => '9e91551d6e7baacc11dfedf7bc6da8c5cd9e7cbc', 1 => 10, )] -------------------------------- Query took: 0.00014591217041016 seconds. -------------------------------- -------------------------------- SELECT RELEASE_LOCK(?) AS unlocked [array ( 0 => '9e91551d6e7baacc11dfedf7bc6da8c5cd9e7cbc', )] -------------------------------- Query took: 0.00012397766113281 seconds. -------------------------------- -------------------------------- UPDATE mdl_task_adhoc SET classname = ?,component = ?,blocking = ?,nextruntime = ?,faildelay = ?,customdata = ?,userid = ?,timecreated = ?,timestarted = ?,hostname = ?,pid = ? WHERE id=? [array ( 0 => '\\assignfeedback_editpdf\\task\\convert_submission', 1 => 'assignfeedback_editpdf', 2 => 0, 3 => '1697633867', 4 => '0', 5 => '{"submissionid":"320527","submissionattempt":"0"}', 6 => NULL, 7 => 1697633938, 8 => 1697633938, 9 => 'srvvmlnx-mod02.bbbaden.ch', 10 => 675391, 11 => '40018479', )] -------------------------------- Query took: 0.0018930435180664 seconds. -------------------------------- Execute adhoc task: assignfeedback_editpdf\task\convert_submission Adhoc task id: 40018479 Adhoc task custom data: {"submissionid":"320527","submissionattempt":"0"} ... started 14:58:58. Current memory use 2.7 MB. -------------------------------- SELECT * FROM mdl_assign_submission WHERE id = ? [array ( 0 => '320527', )] -------------------------------- Query took: 0.00052404403686523 seconds. -------------------------------- -------------------------------- SELECT cm.*, m.name, md.name AS modname FROM mdl_course_modules cm JOIN mdl_modules md ON md.id = cm.module JOIN mdl_assign m ON m.id = cm.instance WHERE m.id = ? AND md.name = ? [array ( 0 => '7588', 1 => 'assign', )] -------------------------------- Query took: 0.00058913230895996 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE contextlevel = ? AND instanceid = ? [array ( 0 => 70, 1 => '134761', )] -------------------------------- Query took: 0.00039887428283691 seconds. -------------------------------- Converting submission for user id 13951 -------------------------------- SELECT * FROM mdl_context WHERE id = ? [array ( 0 => '33730', )] -------------------------------- Query took: 0.00026798248291016 seconds. -------------------------------- -------------------------------- SELECT DISTINCT eu1_u.id FROM mdl_user eu1_u JOIN mdl_user_enrolments ej1_ue1 ON ej1_ue1.userid = eu1_u.id JOIN mdl_enrol ej1_e1 ON (ej1_e1.id = ej1_ue1.enrolid AND ej1_e1.courseid = ?) WHERE 1 = 1 AND eu1_u.id NOT IN (SELECT DISTINCT ej1_ue.userid FROM mdl_user_enrolments ej1_ue JOIN mdl_enrol ej1_e ON (ej1_e.id = ej1_ue.enrolid AND ej1_e.courseid = ?) WHERE ej1_ue.status = ? AND ej1_e.status = ? AND ej1_ue.timestart < ? AND (ej1_ue.timeend = 0 OR ej1_ue.timeend > ?)) AND eu1_u.deleted = 0 [array ( 0 => '556', 1 => '556', 2 => 0, 3 => 0, 4 => 1697633900.0, 5 => 1697633900.0, )] -------------------------------- Query took: 0.028290987014771 seconds. -------------------------------- -------------------------------- SELECT 'x' FROM mdl_user_enrolments ue JOIN mdl_enrol e ON (e.id = ue.enrolid AND e.courseid = ?) JOIN mdl_user u ON u.id = ue.userid WHERE ue.userid = ? AND u.deleted = 0 LIMIT 0, 1 [array ( 0 => '556', 1 => '13951', )] -------------------------------- Query took: 0.00036978721618652 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_course WHERE id = ? [array ( 0 => '556', )] -------------------------------- Query took: 0.00030088424682617 seconds. -------------------------------- -------------------------------- SELECT ctx.* FROM mdl_context ctx WHERE ctx.path LIKE ? [array ( 0 => '/1/26/57602/33730/%', )] -------------------------------- Query took: 0.0021429061889648 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign WHERE id = ? [array ( 0 => '7588', )] -------------------------------- Query took: 0.0003659725189209 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_submission WHERE assignment = ? AND userid = ? AND groupid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => '7588', 1 => '13951', 2 => 0, 3 => '0', )] -------------------------------- Query took: 0.00031590461730957 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_grades WHERE assignment = ? AND userid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => '7588', 1 => '13951', 2 => '0', )] -------------------------------- Query took: 0.00032305717468262 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_submission WHERE assignment = ? AND userid = ? AND groupid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => '7588', 1 => '13951', 2 => 0, 3 => '0', )] -------------------------------- Query took: 0.00024986267089844 seconds. -------------------------------- -------------------------------- SELECT f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license, f.timecreated, f.timemodified, f.sortorder, f.referencefileid, r.repositoryid AS repositoryid, r.reference AS reference, r.lastsync AS referencelastsync FROM mdl_files f LEFT JOIN mdl_files_reference r ON f.referencefileid = r.id WHERE f.pathnamehash = ? [array ( 0 => '3e8a140ff8a7f7a7055fac0d196fc15d810bda5a', )] -------------------------------- Query took: 0.00036907196044922 seconds. -------------------------------- -------------------------------- SELECT f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license, f.timecreated, f.timemodified, f.sortorder, f.referencefileid, r.repositoryid AS repositoryid, r.reference AS reference, r.lastsync AS referencelastsync FROM mdl_files f LEFT JOIN mdl_files_reference r ON f.referencefileid = r.id WHERE f.pathnamehash = ? [array ( 0 => '819963dcd6964c9949eb908e056303a6224dc951', )] -------------------------------- Query took: 0.00031304359436035 seconds. -------------------------------- -------------------------------- SELECT 'x' FROM mdl_user_enrolments ue JOIN mdl_enrol e ON (e.id = ue.enrolid AND e.courseid = ?) JOIN mdl_user u ON u.id = ue.userid WHERE ue.userid = ? AND u.deleted = 0 LIMIT 0, 1 [array ( 0 => '556', 1 => '13951', )] -------------------------------- Query took: 0.00038886070251465 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_submission WHERE assignment = ? AND userid = ? AND groupid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => '7588', 1 => '13951', 2 => 0, 3 => '0', )] -------------------------------- Query took: 0.00025796890258789 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_user WHERE id = ? [array ( 0 => '13951', )] -------------------------------- Query took: 0.00026988983154297 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_plugin_config WHERE assignment = ? AND subtype = ? AND plugin = ? AND name = ? [array ( 0 => '7588', 1 => 'assignsubmission', 2 => 'onlinetext', 3 => 'enabled', )] -------------------------------- Query took: 0.00046992301940918 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_plugin_config WHERE assignment = ? AND subtype = ? AND plugin = ? AND name = ? [array ( 0 => '7588', 1 => 'assignsubmission', 2 => 'file', 3 => 'enabled', )] -------------------------------- Query took: 0.00041103363037109 seconds. -------------------------------- -------------------------------- SELECT f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license, f.timecreated, f.timemodified, f.sortorder, f.referencefileid, r.repositoryid AS repositoryid, r.reference AS reference, r.lastsync AS referencelastsync FROM mdl_files f LEFT JOIN mdl_files_reference r ON f.referencefileid = r.id WHERE f.contextid = ? AND f.component = ? AND f.filearea = ? AND f.filename != ? AND f.itemid = ? ORDER BY timemodified [array ( 0 => 209627, 1 => 'assignsubmission_file', 2 => 'submission_files', 3 => '.', 4 => '320527', )] -------------------------------- Query took: 0.00067687034606934 seconds. -------------------------------- -------------------------------- SELECT c.id AS conversionid, c.sourcefileid AS conversionsourcefileid, c.targetformat AS conversiontargetformat, c.status AS conversionstatus, c.statusmessage AS conversionstatusmessage, c.converter AS conversionconverter, c.destfileid AS conversiondestfileid, c.data AS conversiondata, c.timecreated AS conversiontimecreated, c.timemodified AS conversiontimemodified, c.usermodified AS conversionusermodified FROM mdl_file_conversion c JOIN mdl_files conversionsourcefile ON conversionsourcefile.id = c.sourcefileid LEFT JOIN mdl_files conversiondestfile ON conversiondestfile.id = c.destfileid WHERE conversionsourcefile.contenthash = ? AND c.targetformat = ? AND (c.destfileid IS NULL OR conversiondestfile.id IS NOT NULL) UNION ALL SELECT NULL AS conversionid, orphanedsourcefile.id AS conversionsourcefileid, ? AS conversiontargetformat, 2 AS conversionstatus, NULL AS conversionstatusmessage, NULL AS conversionconverter, orphaneddestfile.id AS conversiondestfileid, NULL AS conversiondata, 0 AS conversiontimecreated, 0 AS conversiontimemodified, 0 AS conversionusermodified FROM mdl_files orphanedsourcefile INNER JOIN mdl_files orphaneddestfile ON ( orphaneddestfile.filename = orphanedsourcefile.contenthash AND orphaneddestfile.component = 'core' AND orphaneddestfile.filearea = 'documentconversion' AND orphaneddestfile.filepath = ? ) LEFT JOIN mdl_file_conversion orphanedconversion ON orphanedconversion.destfileid = orphaneddestfile.id WHERE orphanedconversion.id IS NULL AND orphanedsourcefile.id = ? [array ( 0 => 'b2f70d687ac31cd1e138fb61a8300d1091c2017b', 1 => 'pdf', 2 => 'pdf', 3 => '/pdf/', 4 => '7616481', )] -------------------------------- Query took: 0.0013890266418457 seconds. -------------------------------- -------------------------------- SELECT f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license, f.timecreated, f.timemodified, f.sortorder, f.referencefileid, r.repositoryid AS repositoryid, r.reference AS reference, r.lastsync AS referencelastsync FROM mdl_files f LEFT JOIN mdl_files_reference r ON f.referencefileid = r.id WHERE f.id = ? [array ( 0 => 7616481, )] -------------------------------- Query took: 0.00030112266540527 seconds. -------------------------------- -------------------------------- UPDATE mdl_file_conversion SET sourcefileid = ?,targetformat = ?,status = ?,statusmessage = ?,converter = ?,destfileid = ?,data = ?,timemodified = ?,usermodified = ? WHERE id=? [array ( 0 => '7616481', 1 => 'pdf', 2 => '1', 3 => NULL, 4 => '\\fileconverter_unoconv\\converter', 5 => NULL, 6 => NULL, 7 => 1697633938, 8 => '10052', 9 => '5779', )] -------------------------------- Query took: 0.0016510486602783 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_submission WHERE assignment = ? AND userid = ? AND groupid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => '7588', 1 => '13951', 2 => 0, 3 => '0', )] -------------------------------- Query took: 0.00029611587524414 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_grades WHERE assignment = ? AND userid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => '7588', 1 => '13951', 2 => '0', )] -------------------------------- Query took: 0.0002448558807373 seconds. -------------------------------- Conversion still in progress. Requeueing self to check again. -------------------------------- INSERT INTO mdl_task_adhoc (classname,component,blocking,nextruntime,faildelay,customdata,userid,timecreated,timestarted,hostname,pid) VALUES(?,?,?,?,?,?,?,?,?,?,?) [array ( 0 => '\\assignfeedback_editpdf\\task\\convert_submission', 1 => 'assignfeedback_editpdf', 2 => 0, 3 => 1697633998, 4 => 0, 5 => '{"submissionid":"320527","submissionattempt":"0"}', 6 => NULL, 7 => 1697633938, 8 => NULL, 9 => NULL, 10 => NULL, )] -------------------------------- Query took: 0.0017280578613281 seconds. -------------------------------- ... used 26 dbqueries ... used 0.30970120429993 seconds Adhoc task complete: assignfeedback_editpdf\task\convert_submission -------------------------------- INSERT INTO mdl_task_log (type,component,classname,userid,timestart,timeend,dbreads,dbwrites,result,output,hostname,pid) VALUES(?,?,?,?,?,?,?,?,?,?,?,?) [array ( 0 => 1, 1 => 'assignfeedback_editpdf', 2 => 'assignfeedback_editpdf\\task\\convert_submission', 3 => 0, 4 => 1697633938.2626989, 5 => 1697633938.5772581, 6 => 24, 7 => 2, 8 => 0, 9 => 'Execute adhoc task: assignfeedback_editpdf\\task\\convert_submission Adhoc task id: 40018479 Adhoc task custom data: {"submissionid":"320527","submissionattempt":"0"} ... started 14:58:58. Current memory use 2.7 MB. -------------------------------- SELECT * FROM mdl_assign_submission WHERE id = ? [array ( 0 => \'320527\', )] -------------------------------- Query took: 0.00052404403686523 seconds. -------------------------------- -------------------------------- SELECT cm.*, m.name, md.name AS modname FROM mdl_course_modules cm JOIN mdl_modules md ON md.id = cm.module JOIN mdl_assign m ON m.id = cm.instance WHERE m.id = ? AND md.name = ? [array ( 0 => \'7588\', 1 => \'assign\', )] -------------------------------- Query took: 0.00058913230895996 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_context WHERE contextlevel = ? AND instanceid = ? [array ( 0 => 70, 1 => \'134761\', )] -------------------------------- Query took: 0.00039887428283691 seconds. -------------------------------- Converting submission for user id 13951 -------------------------------- SELECT * FROM mdl_context WHERE id = ? [array ( 0 => \'33730\', )] -------------------------------- Query took: 0.00026798248291016 seconds. -------------------------------- -------------------------------- SELECT DISTINCT eu1_u.id FROM mdl_user eu1_u JOIN mdl_user_enrolments ej1_ue1 ON ej1_ue1.userid = eu1_u.id JOIN mdl_enrol ej1_e1 ON (ej1_e1.id = ej1_ue1.enrolid AND ej1_e1.courseid = ?) WHERE 1 = 1 AND eu1_u.id NOT IN (SELECT DISTINCT ej1_ue.userid FROM mdl_user_enrolments ej1_ue JOIN mdl_enrol ej1_e ON (ej1_e.id = ej1_ue.enrolid AND ej1_e.courseid = ?) WHERE ej1_ue.status = ? AND ej1_e.status = ? AND ej1_ue.timestart < ? AND (ej1_ue.timeend = 0 OR ej1_ue.timeend > ?)) AND eu1_u.deleted = 0 [array ( 0 => \'556\', 1 => \'556\', 2 => 0, 3 => 0, 4 => 1697633900.0, 5 => 1697633900.0, )] -------------------------------- Query took: 0.028290987014771 seconds. -------------------------------- -------------------------------- SELECT \'x\' FROM mdl_user_enrolments ue JOIN mdl_enrol e ON (e.id = ue.enrolid AND e.courseid = ?) JOIN mdl_user u ON u.id = ue.userid WHERE ue.userid = ? AND u.deleted = 0 LIMIT 0, 1 [array ( 0 => \'556\', 1 => \'13951\', )] -------------------------------- Query took: 0.00036978721618652 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_course WHERE id = ? [array ( 0 => \'556\', )] -------------------------------- Query took: 0.00030088424682617 seconds. -------------------------------- -------------------------------- SELECT ctx.* FROM mdl_context ctx WHERE ctx.path LIKE ? [array ( 0 => \'/1/26/57602/33730/%\', )] -------------------------------- Query took: 0.0021429061889648 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign WHERE id = ? [array ( 0 => \'7588\', )] -------------------------------- Query took: 0.0003659725189209 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_submission WHERE assignment = ? AND userid = ? AND groupid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => \'7588\', 1 => \'13951\', 2 => 0, 3 => \'0\', )] -------------------------------- Query took: 0.00031590461730957 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_grades WHERE assignment = ? AND userid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => \'7588\', 1 => \'13951\', 2 => \'0\', )] -------------------------------- Query took: 0.00032305717468262 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_submission WHERE assignment = ? AND userid = ? AND groupid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => \'7588\', 1 => \'13951\', 2 => 0, 3 => \'0\', )] -------------------------------- Query took: 0.00024986267089844 seconds. -------------------------------- -------------------------------- SELECT f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license, f.timecreated, f.timemodified, f.sortorder, f.referencefileid, r.repositoryid AS repositoryid, r.reference AS reference, r.lastsync AS referencelastsync FROM mdl_files f LEFT JOIN mdl_files_reference r ON f.referencefileid = r.id WHERE f.pathnamehash = ? [array ( 0 => \'3e8a140ff8a7f7a7055fac0d196fc15d810bda5a\', )] -------------------------------- Query took: 0.00036907196044922 seconds. -------------------------------- -------------------------------- SELECT f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license, f.timecreated, f.timemodified, f.sortorder, f.referencefileid, r.repositoryid AS repositoryid, r.reference AS reference, r.lastsync AS referencelastsync FROM mdl_files f LEFT JOIN mdl_files_reference r ON f.referencefileid = r.id WHERE f.pathnamehash = ? [array ( 0 => \'819963dcd6964c9949eb908e056303a6224dc951\', )] -------------------------------- Query took: 0.00031304359436035 seconds. -------------------------------- -------------------------------- SELECT \'x\' FROM mdl_user_enrolments ue JOIN mdl_enrol e ON (e.id = ue.enrolid AND e.courseid = ?) JOIN mdl_user u ON u.id = ue.userid WHERE ue.userid = ? AND u.deleted = 0 LIMIT 0, 1 [array ( 0 => \'556\', 1 => \'13951\', )] -------------------------------- Query took: 0.00038886070251465 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_submission WHERE assignment = ? AND userid = ? AND groupid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => \'7588\', 1 => \'13951\', 2 => 0, 3 => \'0\', )] -------------------------------- Query took: 0.00025796890258789 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_user WHERE id = ? [array ( 0 => \'13951\', )] -------------------------------- Query took: 0.00026988983154297 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_plugin_config WHERE assignment = ? AND subtype = ? AND plugin = ? AND name = ? [array ( 0 => \'7588\', 1 => \'assignsubmission\', 2 => \'onlinetext\', 3 => \'enabled\', )] -------------------------------- Query took: 0.00046992301940918 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_plugin_config WHERE assignment = ? AND subtype = ? AND plugin = ? AND name = ? [array ( 0 => \'7588\', 1 => \'assignsubmission\', 2 => \'file\', 3 => \'enabled\', )] -------------------------------- Query took: 0.00041103363037109 seconds. -------------------------------- -------------------------------- SELECT f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license, f.timecreated, f.timemodified, f.sortorder, f.referencefileid, r.repositoryid AS repositoryid, r.reference AS reference, r.lastsync AS referencelastsync FROM mdl_files f LEFT JOIN mdl_files_reference r ON f.referencefileid = r.id WHERE f.contextid = ? AND f.component = ? AND f.filearea = ? AND f.filename != ? AND f.itemid = ? ORDER BY timemodified [array ( 0 => 209627, 1 => \'assignsubmission_file\', 2 => \'submission_files\', 3 => \'.\', 4 => \'320527\', )] -------------------------------- Query took: 0.00067687034606934 seconds. -------------------------------- -------------------------------- SELECT c.id AS conversionid, c.sourcefileid AS conversionsourcefileid, c.targetformat AS conversiontargetformat, c.status AS conversionstatus, c.statusmessage AS conversionstatusmessage, c.converter AS conversionconverter, c.destfileid AS conversiondestfileid, c.data AS conversiondata, c.timecreated AS conversiontimecreated, c.timemodified AS conversiontimemodified, c.usermodified AS conversionusermodified FROM mdl_file_conversion c JOIN mdl_files conversionsourcefile ON conversionsourcefile.id = c.sourcefileid LEFT JOIN mdl_files conversiondestfile ON conversiondestfile.id = c.destfileid WHERE conversionsourcefile.contenthash = ? AND c.targetformat = ? AND (c.destfileid IS NULL OR conversiondestfile.id IS NOT NULL) UNION ALL SELECT NULL AS conversionid, orphanedsourcefile.id AS conversionsourcefileid, ? AS conversiontargetformat, 2 AS conversionstatus, NULL AS conversionstatusmessage, NULL AS conversionconverter, orphaneddestfile.id AS conversiondestfileid, NULL AS conversiondata, 0 AS conversiontimecreated, 0 AS conversiontimemodified, 0 AS conversionusermodified FROM mdl_files orphanedsourcefile INNER JOIN mdl_files orphaneddestfile ON ( orphaneddestfile.filename = orphanedsourcefile.contenthash AND orphaneddestfile.component = \'core\' AND orphaneddestfile.filearea = \'documentconversion\' AND orphaneddestfile.filepath = ? ) LEFT JOIN mdl_file_conversion orphanedconversion ON orphanedconversion.destfileid = orphaneddestfile.id WHERE orphanedconversion.id IS NULL AND orphanedsourcefile.id = ? [array ( 0 => \'b2f70d687ac31cd1e138fb61a8300d1091c2017b\', 1 => \'pdf\', 2 => \'pdf\', 3 => \'/pdf/\', 4 => \'7616481\', )] -------------------------------- Query took: 0.0013890266418457 seconds. -------------------------------- -------------------------------- SELECT f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license, f.timecreated, f.timemodified, f.sortorder, f.referencefileid, r.repositoryid AS repositoryid, r.reference AS reference, r.lastsync AS referencelastsync FROM mdl_files f LEFT JOIN mdl_files_reference r ON f.referencefileid = r.id WHERE f.id = ? [array ( 0 => 7616481, )] -------------------------------- Query took: 0.00030112266540527 seconds. -------------------------------- -------------------------------- UPDATE mdl_file_conversion SET sourcefileid = ?,targetformat = ?,status = ?,statusmessage = ?,converter = ?,destfileid = ?,data = ?,timemodified = ?,usermodified = ? WHERE id=? [array ( 0 => \'7616481\', 1 => \'pdf\', 2 => \'1\', 3 => NULL, 4 => \'\\\\fileconverter_unoconv\\\\converter\', 5 => NULL, 6 => NULL, 7 => 1697633938, 8 => \'10052\', 9 => \'5779\', )] -------------------------------- Query took: 0.0016510486602783 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_submission WHERE assignment = ? AND userid = ? AND groupid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => \'7588\', 1 => \'13951\', 2 => 0, 3 => \'0\', )] -------------------------------- Query took: 0.00029611587524414 seconds. -------------------------------- -------------------------------- SELECT * FROM mdl_assign_grades WHERE assignment = ? AND userid = ? AND attemptnumber = ? ORDER BY attemptnumber DESC LIMIT 0, 1 [array ( 0 => \'7588\', 1 => \'13951\', 2 => \'0\', )] -------------------------------- Query took: 0.0002448558807373 seconds. -------------------------------- Conversion still in progress. Requeueing self to check again. -------------------------------- INSERT INTO mdl_task_adhoc (classname,component,blocking,nextruntime,faildelay,customdata,userid,timecreated,timestarted,hostname,pid) VALUES(?,?,?,?,?,?,?,?,?,?,?) [array ( 0 => \'\\\\assignfeedback_editpdf\\\\task\\\\convert_submission\', 1 => \'assignfeedback_editpdf\', 2 => 0, 3 => 1697633998, 4 => 0, 5 => \'{"submissionid":"320527","submissionattempt":"0"}\', 6 => NULL, 7 => 1697633938, 8 => NULL, 9 => NULL, 10 => NULL, )] -------------------------------- Query took: 0.0017280578613281 seconds. -------------------------------- ... used 26 dbqueries ... used 0.30970120429993 seconds Adhoc task complete: assignfeedback_editpdf\\task\\convert_submission ', 10 => 'srvvmlnx-mod02.bbbaden.ch', 11 => 675391, )] -------------------------------- Query took: 0.0033230781555176 seconds. -------------------------------- -------------------------------- DELETE FROM mdl_task_adhoc WHERE id = ? [array ( 0 => '40018479', )] -------------------------------- Query took: 0.0015630722045898 seconds. -------------------------------- -------------------------------- SELECT RELEASE_LOCK(?) AS unlocked [array ( 0 => 'c4174f88206105df0173e84566d6a2b44b5dba13', )] -------------------------------- Query took: 0.00014710426330566 seconds. --------------------------------