** Description changed:
My upgrade script for 19.10 fails and leaves mahara in a unusable state.
The upgrade from cli stops with the following message(s):
--------------------------------------------------- start of console
root@server:/var/www/mahara/htdocs/admin# sudo -u www-data php
cli/upgrade.php -f
[INF] 96 (admin/cli/upgrade.php:70) Upgrading Mahara
[INF] 96 (lib/mahara.php:240) artefact.file wird aktualisiert
[DBG] 96 (artefact/file/db/upgrade.php:514) Update m4a, m4b, m4p and m4r file
types to be audio/mp4 mimetype
[DBG] 96 (lib/dml.php:180) mysqli error: [1305: PROCEDURE
u57370db5nd.search_elasticsearch_queue_artefact_trigger does not exist] in
EXECUTE("UPDATE "artefact"
[DBG] 96 (lib/dml.php:180) SET artefacttype = 'audio'
[DBG] 96 (lib/dml.php:180) WHERE id IN (SELECT artefact
FROM "artefact_file_files"
[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_file_files"
[DBG] 96 (lib/dml.php:180) WHERE oldextension IN ('m4a',
'm4b', 'm4p', 'm4r'));
[DBG] 96 (lib/dml.php:180)
[WAR] 96 (lib/errors.php:859) Could not execute command: UPDATE "artefact"
[WAR] 96 (lib/errors.php:859) SET artefacttype = 'audio'
[WAR] 96 (lib/errors.php:859) WHERE id IN (SELECT
artefact FROM "artefact_file_files"
[WAR] 96 (lib/errors.php:859) WHERE oldextension IN
('m4a', 'm4b', 'm4p', 'm4r'));
[WAR] 96 (lib/errors.php:859)
Call stack (most recent first):
* log_message(string(size 261), integer, true, true) at
/var/www/mahara-19.10.0/htdocs/lib/errors.php:95
* log_warn(string(size 261)) at
/var/www/mahara-19.10.0/htdocs/lib/errors.php:859
* SQLException->__construct(string(size 261)) at
/var/www/mahara-19.10.0/htdocs/lib/dml.php:181
* execute_sql(string(size 234)) at
/var/www/mahara-19.10.0/htdocs/artefact/file/db/upgrade.php:516
* xmldb_artefact_file_upgrade(string(size 10)) at
/var/www/mahara-19.10.0/htdocs/lib/upgrade.php:453
* upgrade_plugin(object(stdClass)) at
/var/www/mahara-19.10.0/htdocs/lib/mahara.php:274
* upgrade_mahara(array(size 1)) at
/var/www/mahara-19.10.0/htdocs/admin/cli/upgrade.php:74
[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_file_files"
[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_sql(string(size 234)) at
/var/www/mahara-19.10.0/htdocs/artefact/file/db/upgrade.php:516
* xmldb_artefact_file_upgrade(string(size 10)) at
/var/www/mahara-19.10.0/htdocs/lib/upgrade.php:453
* upgrade_plugin(object(stdClass)) at
/var/www/mahara-19.10.0/htdocs/lib/mahara.php:274
* upgrade_mahara(array(size 1)) at
/var/www/mahara-19.10.0/htdocs/admin/cli/upgrade.php:74
A nonrecoverable error occurred. This probably means you have encountered a
bug in the systemroot@server:/var/www/mahara/htdoc
--------------------------------------------------- end of console
I am using:
PHP 7.3.11-1+ubuntu16.04.1
Mysql 10.1.41-MariaDB-1
Ubuntu 16.04.6 LTS (GNU/Linux 4.4.0-159-generic x86_64)
- A first look at the table where the error occurs ("artefact_file_files")
- shows that the column which should be updated ("artefacttype") does not
- exist or is named differently ("filetype") - but I don't know if this
- would throw an error.
-
- +--------------+-------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +--------------+-------------+------+-----+---------+-------+
- | artefact | bigint(10) | NO | PRI | NULL | |
- | size | bigint(10) | YES | | NULL | |
- | oldextension | text | YES | | NULL | |
- | fileid | bigint(10) | YES | | NULL | |
- | filetype | text | YES | | NULL | |
- | contenthash | varchar(64) | YES | MUL | NULL | |
- +--------------+-------------+------+-----+---------+-------+
+ 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 artifact_file_files.
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask
on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1850786
Title:
Upgrade script to 19.10 from 19.04.1 fails when converting artefact
audio
Status in Mahara:
New
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):
--------------------------------------------------- start of console
root@server:/var/www/mahara/htdocs/admin# sudo -u www-data php
cli/upgrade.php -f
[INF] 96 (admin/cli/upgrade.php:70) Upgrading Mahara
[INF] 96 (lib/mahara.php:240) artefact.file wird aktualisiert
[DBG] 96 (artefact/file/db/upgrade.php:514) Update m4a, m4b, m4p and m4r file
types to be audio/mp4 mimetype
[DBG] 96 (lib/dml.php:180) mysqli error: [1305: PROCEDURE
u57370db5nd.search_elasticsearch_queue_artefact_trigger does not exist] in
EXECUTE("UPDATE "artefact"
[DBG] 96 (lib/dml.php:180) SET artefacttype = 'audio'
[DBG] 96 (lib/dml.php:180) WHERE id IN (SELECT artefact
FROM "artefact_file_files"
[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_file_files"
[DBG] 96 (lib/dml.php:180) WHERE oldextension IN ('m4a',
'm4b', 'm4p', 'm4r'));
[DBG] 96 (lib/dml.php:180)
[WAR] 96 (lib/errors.php:859) Could not execute command: UPDATE "artefact"
[WAR] 96 (lib/errors.php:859) SET artefacttype = 'audio'
[WAR] 96 (lib/errors.php:859) WHERE id IN (SELECT
artefact FROM "artefact_file_files"
[WAR] 96 (lib/errors.php:859) WHERE oldextension IN
('m4a', 'm4b', 'm4p', 'm4r'));
[WAR] 96 (lib/errors.php:859)
Call stack (most recent first):
* log_message(string(size 261), integer, true, true) at
/var/www/mahara-19.10.0/htdocs/lib/errors.php:95
* log_warn(string(size 261)) at
/var/www/mahara-19.10.0/htdocs/lib/errors.php:859
* SQLException->__construct(string(size 261)) at
/var/www/mahara-19.10.0/htdocs/lib/dml.php:181
* execute_sql(string(size 234)) at
/var/www/mahara-19.10.0/htdocs/artefact/file/db/upgrade.php:516
* xmldb_artefact_file_upgrade(string(size 10)) at
/var/www/mahara-19.10.0/htdocs/lib/upgrade.php:453
* upgrade_plugin(object(stdClass)) at
/var/www/mahara-19.10.0/htdocs/lib/mahara.php:274
* upgrade_mahara(array(size 1)) at
/var/www/mahara-19.10.0/htdocs/admin/cli/upgrade.php:74
[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_file_files"
[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_sql(string(size 234)) at
/var/www/mahara-19.10.0/htdocs/artefact/file/db/upgrade.php:516
* xmldb_artefact_file_upgrade(string(size 10)) at
/var/www/mahara-19.10.0/htdocs/lib/upgrade.php:453
* upgrade_plugin(object(stdClass)) at
/var/www/mahara-19.10.0/htdocs/lib/mahara.php:274
* upgrade_mahara(array(size 1)) at
/var/www/mahara-19.10.0/htdocs/admin/cli/upgrade.php:74
A nonrecoverable error occurred. This probably means you have encountered a
bug in the systemroot@server:/var/www/mahara/htdoc
--------------------------------------------------- end of console
I am using:
PHP 7.3.11-1+ubuntu16.04.1
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 artifact_file_files.
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1850786/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
