Errors in /opt/zextras/log/mysql_error.log

When checking my logs after I heard that /opt/zextras/log/nginx_clamav_signature_provider_access.log never rotates I found worrying errors in /opt/zextras/log/mysql_error.log 

This spring I updated PostgreSQL to 16 and I guess I got these errors after that. I followed to guide https://docs.zextras.com/carbonio-ce/html/release/other-upgrades.html#postgresql-16-upgrade but I did not do the last optional step (remove unused DB). And I am not sure the errors in mysql_error.log has anything to do with this upgrade but the first error was seen 2024-02-04. Below is when I saw the error for the first time and then how it looks today.

Today I am running 24.7.1 on 5.15.0-121-generic #131~20.04.1-Ubuntu and I want to be sure that the errors will not cause any problems updating to 24.9.1. All updates 2024 has worked well with some smaller issues.

240204 11:44:53 mysqld_safe mysqld from pid file /opt/zextras/log/mysql.pid ended
240204 11:59:37 mysqld_safe Starting mysqld daemon with databases from /opt/zextras/db/data
2024-02-04 11:59:38 0 [Note] Starting MariaDB 10.4.32-MariaDB-log source revision c4143f909528e3fab0677a28631d10389354c491 as process 5277
2024-02-04 11:59:39 0 [Note] InnoDB: Using Linux native AIO
2024-02-04 11:59:39 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-02-04 11:59:39 0 [Note] InnoDB: Uses event mutexes
2024-02-04 11:59:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-02-04 11:59:39 0 [Note] InnoDB: Number of pools: 1
2024-02-04 11:59:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-04 11:59:39 0 [Note] InnoDB: Initializing buffer pool, total size = 5G, instances = 8, chunk size = 128M
2024-02-04 11:59:39 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-04 11:59:39 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-02-04 11:59:43 0 [Note] InnoDB: Upgrading redo log: 2*524288000 bytes; LSN=227898588
2024-02-04 11:59:43 0 [Note] InnoDB: Starting to delete and rewrite log files.
2024-02-04 11:59:43 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 524288000 bytes
2024-02-04 11:59:43 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 524288000 bytes
2024-02-04 11:59:43 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2024-02-04 11:59:44 0 [Note] InnoDB: New log files created, LSN=227898588
2024-02-04 11:59:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-04 11:59:44 0 [Note] InnoDB: Creating sys_virtual system tables.
2024-02-04 11:59:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-04 11:59:44 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-04 11:59:44 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-02-04 11:59:44 0 [Note] InnoDB: Waiting for purge to start
2024-02-04 11:59:44 0 [Note] InnoDB: 10.4.32 started; log sequence number 227898588; transaction id 767336
2024-02-04 11:59:44 0 [Note] InnoDB: Loading buffer pool(s) from /opt/zextras/db/data/ib_buffer_pool
2024-02-04 11:59:44 0 [Note] InnoDB: Cannot open '/opt/zextras/db/data/ib_buffer_pool' for reading: No such file or directory
2024-02-04 11:59:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-04 11:59:44 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-02-04 11:59:44 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU
2024-02-04 11:59:44 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2024-02-04 11:59:49 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2024-02-04 11:59:49 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2024-02-04 11:59:49 0 [Note] Reading of all Master_info entries succeeded
2024-02-04 11:59:49 0 [Note] Added new Master_info '' to hash table
2024-02-04 11:59:49 0 [Note] /opt/zextras/common/sbin/mysqld: ready for connections.
Version: '10.4.32-MariaDB-log' socket: '/opt/zextras/data/tmp/mysql/mysql.sock' port: 7306 Zextras MariaDB binary distribution
2024-02-04 12:00:03 9 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2024-02-04 12:00:03 9 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

...


241019 10:31:24 mysqld_safe mysqld from pid file /run/carbonio/mysql.pid ended
241019 10:43:03 mysqld_safe Starting mariadbd daemon with databases from /opt/zextras/db/data
2024-10-19 10:43:10 0 [Note] Starting MariaDB 10.5.25-MariaDB-log source revision 29c185bd771ac441121468b3850d6dc8d13b8a1f as process 4002
2024-10-19 10:43:11 0 [Note] InnoDB: Uses event mutexes
2024-10-19 10:43:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-10-19 10:43:11 0 [Note] InnoDB: Number of pools: 1
2024-10-19 10:43:11 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-10-19 10:43:11 0 [Note] InnoDB: Using Linux native AIO
2024-10-19 10:43:11 0 [Note] InnoDB: Initializing buffer pool, total size = 4966055936, chunk size = 134217728
2024-10-19 10:43:11 0 [Note] InnoDB: Completed initialization of buffer pool
2024-10-19 10:43:25 0 [Note] InnoDB: 128 rollback segments are active.
2024-10-19 10:43:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-10-19 10:43:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-10-19 10:43:26 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-10-19 10:43:26 0 [Note] InnoDB: 10.5.25 started; log sequence number 635521100; transaction id 2453199
2024-10-19 10:43:26 0 [Note] InnoDB: Loading buffer pool(s) from /opt/zextras/db/data/ib_buffer_pool
2024-10-19 10:43:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-10-19 10:43:27 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-10-19 10:43:28 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU
2024-10-19 10:43:28 0 [ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2024-10-19 10:43:38 1 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2024-10-19 10:43:38 1 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2024-10-19 10:43:38 0 [Note] Reading of all Master_info entries succeeded
2024-10-19 10:43:38 0 [Note] Added new Master_info '' to hash table
2024-10-19 10:43:38 0 [Note] /opt/zextras/common/sbin/mariadbd: ready for connections.
Version: '10.5.25-MariaDB-log' socket: '/run/carbonio/mysql.sock' port: 7306 Zextras MariaDB binary distribution
2024-10-19 10:43:41 0 [Note] InnoDB: Buffer pool(s) load completed at 241019 10:43:41
2024-10-19 10:44:15 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2024-10-19 10:44:15 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2024-10-19 10:44:16 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2024-10-19 10:44:16 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

I do not dare to run mysql_upgrade or delete the old database. Should I delete the old database with:

pg_dropcluster 12 main --stop
pg_dropcluster 16 main_pristine --stop

And is it safe to run mysql_update or should I do something else first?

I am grateful for any the help.

//Sigtrap