[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)

[Knut Hildebrandt]

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

Knut Hildebrandt <knut.hildebrandt at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |knut.hildebrandt at gmx.de

--- Comment #3 from Knut Hildebrandt <knut.hildebrandt at gmx.de> ---
Same here and that already for an while and long before the right now installed
Akonadi version came out.

Akonadi: 22.08.1-2
mariadb: 10.9.3-1
Operating System: Manjaro Linux
KDE Plasma Version: 5.25.5
KDE Frameworks Version: 5.98.0
Qt Version: 5.15.6
Kernel Version: 5.10.148-1-MANJARO (64-bit)
Graphics Platform: X11

BTW, I've got thousands of error messages like the ones I paste here including
the messages generated by the shutdown of Akonadi:
...
2022-10-24 20:07:45 67 [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').
2022-10-24 20:07:45 67 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'histogram' at position 10 to have type
longblob, found type varbinary(255).
2022-10-24 20:07:45 67 [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').
2022-10-24 20:07:45 67 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'histogram' at position 10 to have type
longblob, found type varbinary(255).
2022-10-24 20:07:45 67 [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').
2022-10-24 20:07:45 67 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'histogram' at position 10 to have type
longblob, found type varbinary(255).
2022-10-24 20:07:51 0 [Note] /usr/bin/mysqld (initiated by: unknown): Normal
shutdown
2022-10-24 20:07:51 0 [Note] InnoDB: FTS optimize thread exiting.
2022-10-24 20:07:51 0 [Note] InnoDB: Starting shutdown...
2022-10-24 20:07:51 0 [Note] InnoDB: Dumping buffer pool(s) to
/home/knut/.local/share/akonadi/db_data/ib_buffer_pool
2022-10-24 20:07:51 0 [Note] InnoDB: Restricted to 2016 pages due to
innodb_buf_pool_dump_pct=25
2022-10-24 20:07:51 0 [Note] InnoDB: Buffer pool(s) dump completed at 221024
20:07:51
2022-10-24 20:07:51 0 [Note] InnoDB: Removed temporary tablespace data file:
"./ibtmp1"
2022-10-24 20:07:51 0 [Note] InnoDB: Shutdown completed; log sequence number
25265153099; transaction id 170786390
2022-10-24 20:07:51 0 [Note] /usr/bin/mysqld: Shutdown complete

At startup there are a couple of warnings before the error messages start
again:
2022-10-24 20:27:12 0 [Warning] option 'innodb-log-buffer-size': unsigned value
1048576 adjusted to 2097152
2022-10-24 20:27:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-10-24 20:27:12 0 [Note] InnoDB: Number of transaction pools: 1
2022-10-24 20:27:12 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-10-24 20:27:12 0 [Note] InnoDB: Using Linux native AIO
2022-10-24 20:27:12 0 [Note] InnoDB: Initializing buffer pool, total size =
128.000MiB, chunk size = 2.000MiB
2022-10-24 20:27:12 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-24 20:27:12 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-10-24 20:27:12 0 [Note] InnoDB: 128 rollback segments are active.
2022-10-24 20:27:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB.
Physically writing the file full; Please wait ...
2022-10-24 20:27:12 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2022-10-24 20:27:12 0 [Note] InnoDB: log sequence number 25265153099;
transaction id 170786391
2022-10-24 20:27:12 0 [Note] InnoDB: Loading buffer pool(s) from
/home/knut/.local/share/akonadi/db_data/ib_buffer_pool
2022-10-24 20:27:12 1 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 1 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 0 [Note] /usr/bin/mysqld: ready for connections.
Version: '10.9.3-MariaDB'  socket: '/run/user/1000/akonadi/mysql.socket'  port:
0  Arch Linux
2022-10-24 20:27:12 0 [Note] InnoDB: Buffer pool(s) load completed at 221024
20:27:12
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 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').
2022-10-24 20:27:12 5 [ERROR] Incorrect definition of table mysql.column_stats:
expected column 'histogram' at position 10 to have type longblob, found type
varbinary(255).
2022-10-24 20:27:12 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').
...

BTW, that's what I get when I try to upgrade mariadb:
$ mariadb-upgrade
Reading datadir from the MariaDB server failed. Got the following error when
executing the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local server through socket
'/run/mysqld/mysqld.sock' (2)
FATAL ERROR: Upgrade failed

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