[kmail2] [Bug 425976] New: 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)."

bugzilla_noreply at kde.org bugzilla_noreply at kde.org
Sun Aug 30 13:08:21 BST 2020


https://bugs.kde.org/show_bug.cgi?id=425976

            Bug ID: 425976
           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: kmail2
           Version: unspecified
          Platform: Other
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: general
          Assignee: kdepim-bugs at kde.org
          Reporter: weltio at web.de
  Target Milestone: ---

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.


More information about the Kdepim-bugs mailing list