I have made a clean install of Linux Mint 21.2 because an update of kernel failed… coud not get indo harddrive, so I made a clean new install
Downloaded CQRlog from repository, but start up failed… Then uninstall and trying install via terminal… also failed… trying several times with new startup… still failed.. the old CQRlog on the old harddrive worked. I’m tearing my hair ( the rest of it) out… I still hope I can find my log in LOTW… if not, I must retype it all ( I still have papercopies, but my sequrity backup is missing on my USB memorystick…. I dont know why.. error in reading says it..( but that is a minor problem)
CQR writes…
Error during connection to database: TMySQL57Connection : Server connect failed.
I dont not know how to repair it.. maybee I shoud shut down hamradio, and set my radios onn the shelf… ( the magnet solar storm has making it easyer to quit..no activity, only S9 in noise...(as usual)
Maria db, client mm is already installed, appparmor edit also. I dont know what to do now
sorry for spelling and grammar
oz1hyi / 5p1w Willy
Repair database says List index (0) out of bounds.
Error file:
2024-05-14T16:33:23.429491Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 16934
2024-05-14T16:33:23.430401Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-14T16:33:23.430411Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-14T16:33:23.573460Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: aea6899c-120f-11ef-b2ba-d4c9efe0c3d4.
2024-05-14T16:33:23.704297Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-14T16:33:23.704425Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-14T16:33:23.704440Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-14T16:33:23.704818Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-14T16:43:45.678536Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 17544
2024-05-14T16:43:45.679397Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-14T16:43:45.679406Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-14T16:43:45.683386Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-14T16:43:45.683483Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-14T16:43:45.683497Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-14T16:43:45.683835Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-15 7:35:17 0 [Note] Starting MariaDB 10.6.16-MariaDB-0ubuntu0.22.04.1 source revision as process 6152
2024-05-15 7:35:17 0 [Note] InnoDB: The first data file './ibdata1' did not exist. A new tablespace will be created!
2024-05-15 7:35:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-15 7:35:17 0 [Note] InnoDB: Number of pools: 1
2024-05-15 7:35:17 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-05-15 7:35:17 0 [Note] InnoDB: Using liburing
2024-05-15 7:35:17 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2024-05-15 7:35:17 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-15 7:35:17 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-15 7:35:17 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
2024-05-15 7:35:17 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 100663296 bytes
2024-05-15 7:35:18 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2024-05-15 7:35:18 0 [Note] InnoDB: New log file created, LSN=10313
2024-05-15 7:35:18 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2024-05-15 7:35:18 0 [Note] InnoDB: Doublewrite buffer created
2024-05-15 7:35:18 0 [Note] InnoDB: 128 rollback segments are active.
2024-05-15 7:35:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-15 7:35:18 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-15 7:35:18 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-05-15 7:35:18 0 [Note] InnoDB: 10.6.16 started; log sequence number 0; transaction id 3
2024-05-15 7:35:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-15 7:35:18 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-05-15 7:35:18 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-05-15 7:35:18 0 [Note] Server socket created on IP: '::'.
2024-05-15 7:35:18 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2024-05-15 7:35:18 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2024-05-15 7:35:19 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.16-MariaDB-0ubuntu0.22.04.1' socket: '/home/willy/.config/cqrlog/database/sock' port: 64000 Ubuntu 22.04
2024-05-15 7:35:20 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2024-05-15 7:35:20 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`bands` index `band` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-05-15 7:35:21 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`dxclusters` index `description` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-05-15 7:35:22 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`iota_list` index `iota_nr` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-05-15 7:35:23 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`iota_list` index `pref` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-05-15 7:35:23 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`dxcc_ref` index `pref` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-05-15 7:35:24 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`dxcc_ref` index `adif` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-05-15 7:35:25 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`qslmgr` index `callsign` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-05-15 7:35:25 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`qslmgr` index `fromdate` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-05-15 7:35:26 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog_common`.`log_list` index `log_nr` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-05-15 7:35:27 7 [Warning] Aborted connection 7 to db: 'information_schema' user: 'cqrlog' host: '' (Got an error reading communication packets)
2024-05-15 7:35:27 8 [Warning] Aborted connection 8 to db: 'information_schema' user: 'cqrlog' host: '' (Got an error reading communication packets)
2024-05-15 7:35:27 6 [Warning] Aborted connection 6 to db: 'information_schema' user: 'cqrlog' host: '' (Got an error reading communication packets)
2024-05-15 7:35:27 5 [Warning] Aborted connection 5 to db: 'information_schema' user: 'cqrlog' host: '' (Got an error reading communication packets)
2024-05-15 7:35:28 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog001`.`cqrlog_main` index `main_index` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-05-15 7:35:28 4 [Warning] Aborted connection 4 to db: 'cqrlog001' user: 'cqrlog' host: '' (Got an error reading communication packets)
2024-05-15 8:34:15 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-05-15 8:34:15 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-15 8:34:15 0 [Note] InnoDB: Starting shutdown...
2024-05-15 8:34:15 0 [Note] InnoDB: Dumping buffer pool(s) to /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:34:15 0 [Note] InnoDB: Buffer pool(s) dump completed at 240515 8:34:15
2024-05-15 8:34:16 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-05-15 8:34:16 0 [Note] InnoDB: Shutdown completed; log sequence number 65509; transaction id 75
2024-05-15 8:34:16 0 [Note] /usr/sbin/mysqld: Shutdown complete
2024-05-15 8:34:19 0 [Note] Starting MariaDB 10.6.16-MariaDB-0ubuntu0.22.04.1 source revision as process 7938
2024-05-15 8:34:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-15 8:34:19 0 [Note] InnoDB: Number of pools: 1
2024-05-15 8:34:19 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-05-15 8:34:19 0 [Note] InnoDB: Using liburing
2024-05-15 8:34:19 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2024-05-15 8:34:19 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-15 8:34:20 0 [Note] InnoDB: 128 rollback segments are active.
2024-05-15 8:34:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-15 8:34:20 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-15 8:34:20 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-05-15 8:34:20 0 [Note] InnoDB: 10.6.16 started; log sequence number 65509; transaction id 76
2024-05-15 8:34:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-15 8:34:20 0 [Note] InnoDB: Loading buffer pool(s) from /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:34:20 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-05-15 8:34:20 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-05-15 8:34:20 0 [Note] Server socket created on IP: '::'.
2024-05-15 8:34:20 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2024-05-15 8:34:20 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2024-05-15 8:34:20 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.16-MariaDB-0ubuntu0.22.04.1' socket: '/home/willy/.config/cqrlog/database/sock' port: 64000 Ubuntu 22.04
2024-05-15 8:34:20 0 [Note] InnoDB: Buffer pool(s) load completed at 240515 8:34:20
2024-05-15 8:34:20 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2024-05-15 8:34:57 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-05-15 8:34:57 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-15 8:34:57 0 [Note] InnoDB: Starting shutdown...
2024-05-15 8:34:57 0 [Note] InnoDB: Dumping buffer pool(s) to /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:34:57 0 [Note] InnoDB: Buffer pool(s) dump completed at 240515 8:34:57
2024-05-15 8:34:57 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-05-15 8:34:57 0 [Note] InnoDB: Shutdown completed; log sequence number 65521; transaction id 76
2024-05-15 8:34:57 0 [Note] /usr/sbin/mysqld: Shutdown complete
2024-05-15T06:39:47.865415Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 9394
2024-05-15T06:39:47.866208Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-15T06:39:47.866219Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-15T06:39:47.964547Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-15T06:39:47.964651Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-15T06:39:47.964677Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-15T06:39:47.965020Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-15T06:41:20.437285Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 9488
2024-05-15T06:41:20.438096Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-15T06:41:20.438105Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-15T06:41:20.442091Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-15T06:41:20.442192Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-15T06:41:20.442212Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-15T06:41:20.442547Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-15 8:44:21 0 [Note] Starting MariaDB 10.6.16-MariaDB-0ubuntu0.22.04.1 source revision as process 10122
2024-05-15 8:44:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-15 8:44:21 0 [Note] InnoDB: Number of pools: 1
2024-05-15 8:44:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-05-15 8:44:21 0 [Note] InnoDB: Using liburing
2024-05-15 8:44:21 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2024-05-15 8:44:21 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-15 8:44:22 0 [Note] InnoDB: 128 rollback segments are active.
2024-05-15 8:44:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-15 8:44:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-15 8:44:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-05-15 8:44:22 0 [Note] InnoDB: 10.6.16 started; log sequence number 65521; transaction id 76
2024-05-15 8:44:22 0 [Note] InnoDB: Loading buffer pool(s) from /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:44:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-15 8:44:22 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-05-15 8:44:22 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-05-15 8:44:22 0 [Note] Server socket created on IP: '::'.
2024-05-15 8:44:22 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2024-05-15 8:44:22 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2024-05-15 8:44:22 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.16-MariaDB-0ubuntu0.22.04.1' socket: '/home/willy/.config/cqrlog/database/sock' port: 64000 Ubuntu 22.04
2024-05-15 8:44:22 0 [Note] InnoDB: Buffer pool(s) load completed at 240515 8:44:22
2024-05-15 8:44:22 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2024-05-15 8:44:49 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-05-15 8:44:49 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-15 8:44:49 0 [Note] InnoDB: Starting shutdown...
2024-05-15 8:44:49 0 [Note] InnoDB: Dumping buffer pool(s) to /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:44:49 0 [Note] InnoDB: Buffer pool(s) dump completed at 240515 8:44:49
2024-05-15 8:44:49 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-05-15 8:44:49 0 [Note] InnoDB: Shutdown completed; log sequence number 65549; transaction id 76
2024-05-15 8:44:50 0 [Note] /usr/sbin/mysqld: Shutdown complete
2024-05-15 8:46:44 0 [Note] Starting MariaDB 10.6.16-MariaDB-0ubuntu0.22.04.1 source revision as process 1674
2024-05-15 8:46:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-15 8:46:44 0 [Note] InnoDB: Number of pools: 1
2024-05-15 8:46:44 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-05-15 8:46:44 0 [Note] InnoDB: Using liburing
2024-05-15 8:46:44 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2024-05-15 8:46:44 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-15 8:46:45 0 [Note] InnoDB: 128 rollback segments are active.
2024-05-15 8:46:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-15 8:46:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-15 8:46:45 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-05-15 8:46:45 0 [Note] InnoDB: 10.6.16 started; log sequence number 65549; transaction id 76
2024-05-15 8:46:45 0 [Note] InnoDB: Loading buffer pool(s) from /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:46:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-15 8:46:45 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-05-15 8:46:45 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-05-15 8:46:45 0 [Note] Server socket created on IP: '::'.
2024-05-15 8:46:45 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2024-05-15 8:46:45 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2024-05-15 8:46:45 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.16-MariaDB-0ubuntu0.22.04.1' socket: '/home/willy/.config/cqrlog/database/sock' port: 64000 Ubuntu 22.04
2024-05-15 8:46:46 0 [Note] InnoDB: Buffer pool(s) load completed at 240515 8:46:46
2024-05-15 8:46:46 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2024-05-15 8:53:37 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-05-15 8:53:37 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-15 8:53:37 0 [Note] InnoDB: Starting shutdown...
2024-05-15 8:53:37 0 [Note] InnoDB: Dumping buffer pool(s) to /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:53:37 0 [Note] InnoDB: Buffer pool(s) dump completed at 240515 8:53:37
2024-05-15 8:53:38 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-05-15 8:53:38 0 [Note] InnoDB: Shutdown completed; log sequence number 65561; transaction id 76
2024-05-15 8:53:38 0 [Note] /usr/sbin/mysqld: Shutdown complete
2024-05-15 8:53:42 0 [Note] Starting MariaDB 10.6.16-MariaDB-0ubuntu0.22.04.1 source revision as process 2686
2024-05-15 8:53:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-15 8:53:42 0 [Note] InnoDB: Number of pools: 1
2024-05-15 8:53:42 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-05-15 8:53:42 0 [Note] InnoDB: Using liburing
2024-05-15 8:53:42 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2024-05-15 8:53:42 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-15 8:53:43 0 [Note] InnoDB: 128 rollback segments are active.
2024-05-15 8:53:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-15 8:53:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-15 8:53:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-05-15 8:53:43 0 [Note] InnoDB: 10.6.16 started; log sequence number 65561; transaction id 76
2024-05-15 8:53:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-15 8:53:43 0 [Note] InnoDB: Loading buffer pool(s) from /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:53:43 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-05-15 8:53:43 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-05-15 8:53:43 0 [Note] Server socket created on IP: '::'.
2024-05-15 8:53:43 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2024-05-15 8:53:43 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2024-05-15 8:53:43 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.16-MariaDB-0ubuntu0.22.04.1' socket: '/home/willy/.config/cqrlog/database/sock' port: 64000 Ubuntu 22.04
2024-05-15 8:53:43 0 [Note] InnoDB: Buffer pool(s) load completed at 240515 8:53:43
2024-05-15 8:53:43 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2024-05-15 8:54:07 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-05-15 8:54:07 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-15 8:54:07 0 [Note] InnoDB: Starting shutdown...
2024-05-15 8:54:07 0 [Note] InnoDB: Dumping buffer pool(s) to /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:54:07 0 [Note] InnoDB: Buffer pool(s) dump completed at 240515 8:54:07
2024-05-15 8:54:07 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-05-15 8:54:07 0 [Note] InnoDB: Shutdown completed; log sequence number 65573; transaction id 76
2024-05-15 8:54:07 0 [Note] /usr/sbin/mysqld: Shutdown complete
2024-05-15 8:55:41 0 [Note] Starting MariaDB 10.6.16-MariaDB-0ubuntu0.22.04.1 source revision as process 3093
2024-05-15 8:55:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-15 8:55:41 0 [Note] InnoDB: Number of pools: 1
2024-05-15 8:55:41 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-05-15 8:55:41 0 [Note] InnoDB: Using liburing
2024-05-15 8:55:41 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2024-05-15 8:55:41 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-15 8:55:42 0 [Note] InnoDB: 128 rollback segments are active.
2024-05-15 8:55:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-15 8:55:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-15 8:55:42 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-05-15 8:55:42 0 [Note] InnoDB: 10.6.16 started; log sequence number 65573; transaction id 76
2024-05-15 8:55:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-15 8:55:42 0 [Note] InnoDB: Loading buffer pool(s) from /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:55:42 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-05-15 8:55:42 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-05-15 8:55:42 0 [Note] Server socket created on IP: '::'.
2024-05-15 8:55:42 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2024-05-15 8:55:42 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2024-05-15 8:55:42 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.16-MariaDB-0ubuntu0.22.04.1' socket: '/home/willy/.config/cqrlog/database/sock' port: 64000 Ubuntu 22.04
2024-05-15 8:55:42 0 [Note] InnoDB: Buffer pool(s) load completed at 240515 8:55:42
2024-05-15 8:55:42 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2024-05-15 8:56:16 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-05-15 8:56:16 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-15 8:56:16 0 [Note] InnoDB: Starting shutdown...
2024-05-15 8:56:16 0 [Note] InnoDB: Dumping buffer pool(s) to /home/willy/.config/cqrlog/database/ib_buffer_pool
2024-05-15 8:56:16 0 [Note] InnoDB: Buffer pool(s) dump completed at 240515 8:56:16
2024-05-15 8:56:17 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-05-15 8:56:17 0 [Note] InnoDB: Shutdown completed; log sequence number 65585; transaction id 76
2024-05-15 8:56:17 0 [Note] /usr/sbin/mysqld: Shutdown complete
2024-05-15T06:58:49.963599Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 3633
2024-05-15T06:58:49.964505Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-15T06:58:49.964514Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-15T06:58:50.220015Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-15T06:58:50.220155Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-15T06:58:50.220170Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-15T06:58:50.220577Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-15T07:08:09.602193Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 5426
2024-05-15T07:08:09.602945Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-15T07:08:09.602955Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-15T07:08:09.616112Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-15T07:08:09.616215Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-15T07:08:09.616231Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-15T07:08:09.616577Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-15T07:15:39.687903Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 6108
2024-05-15T07:15:39.688775Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-15T07:15:39.688784Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-15T07:15:39.693096Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-15T07:15:39.693255Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-15T07:15:39.693277Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-15T07:15:39.693858Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-15T07:15:47.822582Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 6124
2024-05-15T07:15:47.823436Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-15T07:15:47.823445Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-15T07:15:47.827736Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-15T07:15:47.827826Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-15T07:15:47.827840Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-15T07:15:47.828170Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-15T07:40:03.669900Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 8663
2024-05-15T07:40:03.670759Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-15T07:40:03.670769Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-15T07:40:03.674903Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-15T07:40:03.675007Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-15T07:40:03.675021Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-15T07:40:03.675379Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
2024-05-15T07:44:55.082672Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 9002
2024-05-15T07:44:55.083550Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-15T07:44:55.083560Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-15T07:44:55.087706Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-05-15T07:44:55.087809Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-15T07:44:55.087827Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-15T07:44:55.088159Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu).
HI !
The error shows up here: (mysqld 8.0.36-0ubuntu0.22.04.1) (Ubuntu)
You should install MariaDb that overrides Mysql. Ubuntu packets have error that install Mysql instead of MariaDB
Se this message: https://www.cqrlog.com/node/3637
--
Saku
OH1KH