Back

Internal Server Error 500: Messaging

  • 0
  • Self Hosted
  • Messaging
Abhishek
12 Mar, 2024, 19:30

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.
D5
12 Mar, 2024, 19:37

Do you have run the migration command?

Abhishek
12 Mar, 2024, 19:37

yes

D5
12 Mar, 2024, 19:38

What are the network logs in the browser?

D5
12 Mar, 2024, 19:38

Any errors being shown there?

Abhishek
12 Mar, 2024, 19:39
D5
12 Mar, 2024, 19:45

Not very informative 😬

Abhishek
12 Mar, 2024, 19:47

Yeah

D5
12 Mar, 2024, 19:47

What are the logs for the MariaDB container?

D5
12 Mar, 2024, 19:48

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

Abhishek
12 Mar, 2024, 19:53

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

D5
12 Mar, 2024, 19:54

Doesn't seems related

Abhishek
12 Mar, 2024, 19:54

Network logs

D5
12 Mar, 2024, 19:54

And what's the request content/headers?

Abhishek
12 Mar, 2024, 19:59
Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more