mailcow web UI no more accessible by MySQL error after update

flexguse · 12 Feb

Hello everybody,

yesterday I did a regular mailcow update using the update.sh script to get the latest mailcow dockerized x86 version (as I did several times successfully before).

After the procedure I’m no more able to login into the web ui and I get this error message:

MySQL-Fehler: PDOException: SQLSTATE[HY000]: General error: 1833 Cannot change column 'domain': used in a foreign key constraint 'fk_tags_domain' of table 'mailcow.tags_domain' in /web/inc/init_db.inc.php:1171Stack trace:#0 /web/inc/init_db.inc.php(1171): PDO->query('ALTER TABLE 'do...')#1 /web/inc/prerequisites.inc.php(299): init_db_schema()#2 /web/index.php(2): require_once('/web/inc/prereq...')#3 {main}

Now I’m a little bit lost and have no idea how to fix this. In my installation I upgraded to mariaDB 10.11 somewhen. The rest of the installation is stock.

Any ideas?

esackbauer · 12 Feb

Downgrade/restore MariaDB to 10.5 again. Do not upgrade until you fully understand breaking changes and/or consequences.
This is why you always should use the complete compose stack as it is meant to resolve such dependencies.

flexguse · 12 Feb

esackbauer Thanks for your answer!

A db foreign-key should be a foreign key despite the db version. Is it guaranteed that after the db downgrade the db-script is executable?

flexguse · 13 Feb

esackbauer Downgrading has not been successful, yet. There seem to be some major changes in the internal db storage system.

Any other ideas to handle this issue? I noticed I’m able to login but SoGo is not working and with this I’m not able to sync the calendar and contacts.

esackbauer · 13 Feb

flexguse you could try to open an issue on Github, or look there if someone else had the same problem.