| 2019-10-31 13:02:06 |
hermannkm |
bug |
|
|
added bug |
| 2019-10-31 16:47:36 |
hermannkm |
description |
My upgrade script for 19.10 fails with the following message(s):
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
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) |
My upgrade script for 19.10 fails 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 | |
+--------------+-------------+------+-----+---------+-------+ |
|
| 2019-10-31 16:49:28 |
hermannkm |
description |
My upgrade script for 19.10 fails 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 | |
+--------------+-------------+------+-----+---------+-------+ |
My upgrade script for 19.10 fails 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 | |
+--------------+-------------+------+-----+---------+-------+ |
|
| 2019-11-01 06:30:45 |
hermannkm |
description |
My upgrade script for 19.10 fails 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 | |
+--------------+-------------+------+-----+---------+-------+ |
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 | |
+--------------+-------------+------+-----+---------+-------+ |
|
| 2019-11-01 14:34:48 |
hermannkm |
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 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 | |
+--------------+-------------+------+-----+---------+-------+ |
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. |
|
| 2019-11-02 02:01:21 |
hermannkm |
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. |
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
drop_elasticsearch_triggers();
$funname($data);
create_elasticsearch_triggers();
around Line 274 in lib/mahara.php. Now the output of my console reads
[INF] 5a (admin/cli/upgrade.php:70) Upgrading Mahara
[INF] 5a (lib/mahara.php:240) artefact.file wird aktualisiert
[DBG] 5a (lib/mahara.php:5625) Dropping elasticsearch triggers
[DBG] 5a (artefact/file/db/upgrade.php:514) Update m4a, m4b, m4p and m4r file types to be audio/mp4 mimetype
[INF] 5a (artefact/file/lib.php:236) Synced filetype list with filetypes.xml
[DBG] 5a (lib/mahara.php:5640) Adding elasticsearch triggers back in
[INF] 5a (lib/mahara.php:240) artefact.plans wird aktualisiert
[DBG] 5a (lib/mahara.php:5625) Dropping elasticsearch triggers
[DBG] 5a (lib/mahara.php:5640) Adding elasticsearch triggers back in
[INF] 5a (lib/mahara.php:240) auth.saml wird aktualisiert
[DBG] 5a (lib/mahara.php:5625) Dropping elasticsearch triggers
[DBG] 5a (lib/mahara.php:5640) Adding elasticsearch triggers back in
and everything seems to be ok.
Previous failure of script gave this output:
--------------------------------------------------- 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. |
|
| 2019-11-02 02:02:43 |
hermannkm |
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 |
|
| 2019-11-02 02:10:09 |
Kristina Hoeppner |
nominated for series |
|
mahara/19.10 |
|
| 2019-11-02 02:10:09 |
Kristina Hoeppner |
bug task added |
|
mahara/19.10 |
|
| 2019-11-02 02:10:09 |
Kristina Hoeppner |
nominated for series |
|
mahara/20.04 |
|
| 2019-11-02 02:10:09 |
Kristina Hoeppner |
bug task added |
|
mahara/20.04 |
|
| 2019-11-02 02:10:19 |
Kristina Hoeppner |
mahara/20.04: status |
New |
Confirmed |
|
| 2019-11-02 02:10:21 |
Kristina Hoeppner |
mahara/19.10: status |
New |
Confirmed |
|
| 2019-11-02 02:10:24 |
Kristina Hoeppner |
mahara/20.04: importance |
Undecided |
High |
|
| 2019-11-02 02:10:27 |
Kristina Hoeppner |
mahara/19.10: importance |
Undecided |
High |
|
| 2019-11-02 02:10:30 |
Kristina Hoeppner |
mahara/20.04: milestone |
|
20.04.0 |
|
| 2019-11-02 02:10:33 |
Kristina Hoeppner |
mahara/19.10: milestone |
|
19.10.1 |
|
| 2019-11-02 13:08:26 |
hermannkm |
summary |
Upgrade script to 19.10 from 19.04.1 fails when converting artifact audio - elasticsearch triggers |
Upgrade script to 19.10 from 19.04.1 fails when converting artefact audio - elasticsearch triggers |
|
| 2019-11-02 13:08:57 |
hermannkm |
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
drop_elasticsearch_triggers();
$funname($data);
create_elasticsearch_triggers();
around Line 274 in lib/mahara.php. Now the output of my console reads
[INF] 5a (admin/cli/upgrade.php:70) Upgrading Mahara
[INF] 5a (lib/mahara.php:240) artefact.file wird aktualisiert
[DBG] 5a (lib/mahara.php:5625) Dropping elasticsearch triggers
[DBG] 5a (artefact/file/db/upgrade.php:514) Update m4a, m4b, m4p and m4r file types to be audio/mp4 mimetype
[INF] 5a (artefact/file/lib.php:236) Synced filetype list with filetypes.xml
[DBG] 5a (lib/mahara.php:5640) Adding elasticsearch triggers back in
[INF] 5a (lib/mahara.php:240) artefact.plans wird aktualisiert
[DBG] 5a (lib/mahara.php:5625) Dropping elasticsearch triggers
[DBG] 5a (lib/mahara.php:5640) Adding elasticsearch triggers back in
[INF] 5a (lib/mahara.php:240) auth.saml wird aktualisiert
[DBG] 5a (lib/mahara.php:5625) Dropping elasticsearch triggers
[DBG] 5a (lib/mahara.php:5640) Adding elasticsearch triggers back in
and everything seems to be ok.
Previous failure of script gave this output:
--------------------------------------------------- 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. |
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
drop_elasticsearch_triggers();
$funname($data);
create_elasticsearch_triggers();
around Line 274 in lib/mahara.php. Now the output of my console reads
[INF] 5a (admin/cli/upgrade.php:70) Upgrading Mahara
[INF] 5a (lib/mahara.php:240) artefact.file wird aktualisiert
[DBG] 5a (lib/mahara.php:5625) Dropping elasticsearch triggers
[DBG] 5a (artefact/file/db/upgrade.php:514) Update m4a, m4b, m4p and m4r file types to be audio/mp4 mimetype
[INF] 5a (artefact/file/lib.php:236) Synced filetype list with filetypes.xml
[DBG] 5a (lib/mahara.php:5640) Adding elasticsearch triggers back in
[INF] 5a (lib/mahara.php:240) artefact.plans wird aktualisiert
[DBG] 5a (lib/mahara.php:5625) Dropping elasticsearch triggers
[DBG] 5a (lib/mahara.php:5640) Adding elasticsearch triggers back in
[INF] 5a (lib/mahara.php:240) auth.saml wird aktualisiert
[DBG] 5a (lib/mahara.php:5625) Dropping elasticsearch triggers
[DBG] 5a (lib/mahara.php:5640) Adding elasticsearch triggers back in
and everything seems to be ok.
Previous failure of script gave this output:
--------------------------------------------------- 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 artefact_file_files. |
|
| 2019-11-06 22:54:07 |
Cecilia Vela Gurovic |
mahara/20.04: assignee |
|
Cecilia Vela Gurovic (ceciliavg) |
|
| 2019-11-06 22:54:20 |
Cecilia Vela Gurovic |
mahara/20.04: status |
Confirmed |
In Progress |
|
| 2019-11-11 19:57:24 |
Robert Lyon |
mahara/20.04: status |
In Progress |
Fix Committed |
|
| 2019-11-11 20:00:12 |
Robert Lyon |
mahara/19.10: status |
Confirmed |
In Progress |
|
| 2019-11-11 21:13:33 |
Robert Lyon |
mahara/19.10: status |
In Progress |
Fix Committed |
|
| 2019-11-11 23:50:04 |
Cecilia Vela Gurovic |
mahara/19.10: status |
Fix Committed |
Fix Released |
|
| 2020-04-29 07:51:41 |
Cecilia Vela Gurovic |
mahara/20.04: status |
Fix Committed |
Fix Released |
|
| 2020-04-29 07:51:43 |
Cecilia Vela Gurovic |
mahara: status |
Fix Committed |
Fix Released |
|
| 2020-04-29 19:31:59 |
Robert Lyon |
mahara: milestone |
20.04.0 |
|
|
