Skip to content
Start project
Back

Error when migrating 1.4.14 -> 1.5.4

  • 0
  • Databases
View on Discord
iStornZ
9 Apr, 2024, 18:39

Hello I migrated from 1.4.14 to 1.5.4, all seems to work fine but when I try to open container docker logs appwrite-mariadb I got a lot of errors in loop every seconds:

TypeScript
// [...]
2024-04-09 18:37:05 6 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).
2024-04-09 18:37:05 8 [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-04-09 18:37:05 8 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).
2024-04-09 18:37:05 20 [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-04-09 18:37:05 20 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).
2024-04-09 18:37:05 5 [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-04-09 18:37:05 5 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).

Migration process was successful indeed. How to fix that? Thanks 🙂

TL;DR
Developers are encountering errors in the logs after migrating from version 1.4.14 to 1.5.4, specifically related to table definitions in MariaDB. The errors indicate an issue with column types. To fix this, the columns 'histogram' and 'hist_type' need to be adjusted. 'histogram' should have a type of 'longblob' and 'hist_type' should have a type of 'enum(SINGLE_PREC_HB, DOUBLE_PREC_HB, JSON_HB)'. Making these changes should resolve the errors in the logs.
Reply

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

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