Back
Error when migrating 1.4.14 -> 1.5.4
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. 