Back
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).
These 2 errors are repeating n times
Doesn't seems related
Network logs
And what's the request content/headers?
