Bug 425976 - 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)."
Summary: mysql.err.old contains lots of errors: "Incorrect definition of table mysql.c...
Status: REPORTED
Alias: None
Product: kmail2
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-08-30 12:08 UTC by orelie
Modified: 2020-09-22 11:03 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description orelie 2020-08-30 12:08:21 UTC
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.
Comment 2 grannie 2020-09-10 11:29:31 UTC
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
Comment 3 Niels 2020-09-22 11:03:36 UTC
I have the same problem, but I'm reluctant to experiment with mysql as suggested.

Could akonadi do this kind of maintenance itself?