| Summary: | mysql.err.old contains lots of errors: "Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255)." | ||
|---|---|---|---|
| Product: | [Applications] kmail2 | Reporter: | orelie |
| Component: | general | Assignee: | kdepim bugs <pim-bugs-null> |
| Status: | REPORTED --- | ||
| Severity: | normal | CC: | grannie, niels.misc |
| Priority: | NOR | ||
| Version First Reported In: | unspecified | ||
| Target Milestone: | --- | ||
| Platform: | Other | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
Fixed by:
akonadictl stop
/usr/bin/mysqld --defaults-file=/home/${USER}/.local/share/akonadi/mysql.conf --datadir=/home/${USER}/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-${USER}-mysql.socket &
mysql --socket=/tmp/akonadi-${USER}-mysql.socket -e 'create database mysql'
mysql_upgrade --socket=/tmp/akonadi-${USER}-mysql.socket
mysqladmin --socket=/tmp/akonadi-${USER}-mysql.socket shutdown
I have the same problem, but I'm reluctant to experiment with mysql as suggested. Could akonadi do this kind of maintenance itself? |
On both my computers I have > 10GiB .local/share/akonadi/db_data/mysql.err.old files du mysql.err.old -h 17G mysql.err.old cat mysql.err.old|grep -v 'Note' | cut -d ' ' -f4-| sort | uniq -c 192119 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255). 192120 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255). 20 [ERROR] InnoDB: Column last_update in table `mysql`.`innodb_table_stats` is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`collectionattributetable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`collectionmimetyperelation` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`collectionpimitemrelation` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`collectiontable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`flagtable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`mimetypetable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`parttable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`parttypetable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`pimitemflagrelation` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`pimitemtable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`pimitemtagrelation` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`relationtable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`relationtypetable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`resourcetable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`schemaversiontable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`tagattributetable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`tagremoteidresourcerelationtable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`tagtable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `akonadi`.`tagtypetable` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 [ERROR] InnoDB: Fetch of persistent statistics requested for table `mysql`.`gtid_slave_pos` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 1 socket: '/run/user/1000/akonadi/mysql.socket' port: 0 Arch Linux 1 (Standardeingabe) 20 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address. 1 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.