Internal Server Error 500: Messaging

This happens for existing projects but works if I create a new project on v1.5.3

No logs in sentry and docker logs Running v1.5.3 Migrated from v1.4.13

TL;DR

Developers encountering Internal Server Error 500 related to messaging. - MariaDB container logs show incorrect table definitions. - Network logs and browser network requests seem fine. - Issue persists after migration from v1.4.13 to v1.5.3. - Error occurs in existing projects but not in new projects on v1.5.3. - No logs in Sentry or Docker logs. Solution: Check and correct the table definitions in MariaDB to match the expected types.

Do you have run the migration command?

yes

What are the network logs in the browser?

Any errors being shown there?

Not very informative 😬

Yeah

What are the logs for the MariaDB container?

Also, could you check the network logs in the dev tools? What are the requests that fail and their content?

MariaDB container logs

TypeScript

2024-03-12 19:11:58 13 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
2024-03-12 19:11:58 13 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).