Upgrade script to 19.10 from 19.04.1 fails when converting artefact audio - elasticsearch triggers
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
High
|
Cecilia Vela Gurovic | ||
19.10 |
Fix Released
|
High
|
Unassigned | ||
20.04 |
Fix Released
|
High
|
Cecilia Vela Gurovic |
Bug Description
My upgrade script for 19.10 fails and leaves mahara in a unusable state.
The upgrade from cli stops with the following message(s) (see below).
*Update*: I managed to let the script finish and got my site up again by adding
around Line 274 in lib/mahara.php. Now the output of my console reads
[INF] 5a (admin/
[INF] 5a (lib/mahara.
[DBG] 5a (lib/mahara.
[DBG] 5a (artefact/
[INF] 5a (artefact/
[DBG] 5a (lib/mahara.
[INF] 5a (lib/mahara.
[DBG] 5a (lib/mahara.
[DBG] 5a (lib/mahara.
[INF] 5a (lib/mahara.
[DBG] 5a (lib/mahara.
[DBG] 5a (lib/mahara.
and everything seems to be ok.
Previous failure of script gave this output:
-------
root@server:
[INF] 96 (admin/
[INF] 96 (lib/mahara.
[DBG] 96 (artefact/
[DBG] 96 (lib/dml.php:180) mysqli error: [1305: PROCEDURE u57370db5nd.
[DBG] 96 (lib/dml.php:180) SET artefacttype = 'audio'
[DBG] 96 (lib/dml.php:180) WHERE id IN (SELECT artefact FROM "artefact_
[DBG] 96 (lib/dml.php:180) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r'));
[DBG] 96 (lib/dml.php:180) ")Command was: UPDATE "artefact"
[DBG] 96 (lib/dml.php:180) SET artefacttype = 'audio'
[DBG] 96 (lib/dml.php:180) WHERE id IN (SELECT artefact FROM "artefact_
[DBG] 96 (lib/dml.php:180) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r'));
[DBG] 96 (lib/dml.php:180)
[WAR] 96 (lib/errors.
[WAR] 96 (lib/errors.
[WAR] 96 (lib/errors.
[WAR] 96 (lib/errors.
[WAR] 96 (lib/errors.
Call stack (most recent first):
* log_message(
* log_warn(
* SQLException-
* execute_
* xmldb_artefact_
* upgrade_
* upgrade_
[WAR] 96 (lib/dml.php:181) Could not execute command: UPDATE "artefact"
[WAR] 96 (lib/dml.php:181) SET artefacttype = 'audio'
[WAR] 96 (lib/dml.php:181) WHERE id IN (SELECT artefact FROM "artefact_
[WAR] 96 (lib/dml.php:181) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r'));
[WAR] 96 (lib/dml.php:181)
Call stack (most recent first):
* execute_
* xmldb_artefact_
* upgrade_
* upgrade_
A nonrecoverable error occurred. This probably means you have encountered a bug in the systemroot@
-------
I am using:
PHP 7.3.11-
Mysql 10.1.41-MariaDB-1
Ubuntu 16.04.6 LTS (GNU/Linux 4.4.0-159-generic x86_64)
A short introspection into my database shows that there are three rows with old extension 'm4a' set to filetype 'video/mp4' which are selected from artefact_
description: | updated |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
summary: |
- Upgrade script to 19.10 from 19.04.1 fails when converting artefact - audio + Upgrade script to 19.10 from 19.04.1 fails when converting artifact + audio - elasticsearch triggers |
summary: |
- Upgrade script to 19.10 from 19.04.1 fails when converting artifact + Upgrade script to 19.10 from 19.04.1 fails when converting artefact audio - elasticsearch triggers |
description: | updated |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
Changed in mahara: | |
milestone: | 20.04.0 → none |
Thank you for the report, Hermann. This sounds like it's related to bug #1838483 where we introduced the embedding of .m4a. We'll take a look.