Olá, estou me deparando com um erro de banco na upgrade do moodle 2.9 para 3.0. O erro acontece durante a upgrade depois da tela de plugins. O banco é um postrgresql.
Sistema
Erro de execução DDL SQL
Debug info: ERROR: canceling statement due to statement timeout
BEGIN ISOLATION LEVEL SERIALIZABLE;
ALTER TABLE mdl_message ADD timeuserfromdeleted BIGINT NOT NULL DEFAULT 0
; COMMIT
Error code: ddlexecuteerror
BEGIN ISOLATION LEVEL SERIALIZABLE;
ALTER TABLE mdl_message ADD timeuserfromdeleted BIGINT NOT NULL DEFAULT 0
; COMMIT
Error code: ddlexecuteerror
Stack trace:
- line 449 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
- line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
- line 671 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
- line 76 of /lib/ddl/database_manager.php: call to pgsql_native_moodle_database->change_database_structure()
- line 533 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
- line 4488 of /lib/db/upgrade.php: call to database_manager->add_field()
- line 1588 of /lib/upgradelib.php: call to xmldb_main_upgrade()
- line 507 of /admin/index.php: call to upgrade_core()
