Hi Cecilia, Kristina and the Mahara Team. Thanks for the hint, but it didn't resolve our problem.
What we did: Complete new Web and Db Server (with new IP's) Dump the old mysql DB with locked-tables and complete-inserts. Restore the DB on the new Db Server and grant the privileges from webserver to DB. Start the update and it failed with the same error as previously mentioned. The analysis showed the following: There are some "hardcoded" entries in the DB-Dump with the old IP address. Example: /*!50003 CREATE*/ /*!50017 DEFINER="xxx_user"@"xxx.xxx.xxx.60"*/ /*!50003 TRIGGER "search_elasticsearch_view_artefact_delete" BEFORE delete ON "view_artefact" FOR EACH ROW CALL "search_elasticsearch_queue2_trigger"('view_artefact', 'delete', OLD.artefact, null) */;; where xxx.xxx.xxx.60 is the ip of the old webserver. After changing the ip to the new ip of the webserver xxx.xxx.xxx.106 and then restore the dump , we can update from 18.04.2 to 18.10 and to 20.04. Perhaps this issue is related to elasticsearch. Thank you very much and have a nice day Regards from Germany Jochen and Philippe -- 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/1885589 Title: MySQL Error when upgrading from 18.04.02 to 19.04+ Status in Mahara: New Bug description: Greetings from Germany, While trying to upgrade Mahara from 18.04.02 to 19.04 we've encountered following problem with our MySQL Server: Failed to get a recordset: mysqli error:[1449: The user specified as a definer ($mysqluser@$mysqlhost) does not exist] This problem seems to occur regardless of what version we try to upgrade to (tried with 18.10, 19.04, 19.10, 20.04). Philippe To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1885589/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp