MySQL not starting

2 posts / 0 new
Last post
KB3ITQ
MySQL not starting

First off I am a Linux beginner and a total hack job, but I'm learning. I am running Fedora version 40, 64 bit.

I installed CQRlog and it wouldn't start, I searched my error and found I needed to delete ~/.config/cqrlog folder. This got the program working. Fast forward a few days and I am in the middle of updating a qso with a confirmed qsl. CQRlog froze and I got this error. Error during connection to database: TMySQL57 Connection : Server connect failed.

Here is the error log. I've searched to do next and installed Mysql server. It could have been already installed, but it did something to make me believe it installed. Again I'm an idiot. Here is the error log, any ideas? Note in order to not paste a long error log I only included the error lines from the last day.

2024-09-18 20:05:57 0 [Note] Starting MariaDB 10.11.8-MariaDB source revision 3a069644682e336e445039e48baae9693f9a08ee as process 3427
2024-09-18 20:05:57 0 [Warning] option 'innodb-log-buffer-size': unsigned value 1048576 adjusted to 2097152
2024-09-18 20:05:57 0 [Note] InnoDB: Compressed tables use zlib 1.3.0.zlib-ng
2024-09-18 20:05:57 0 [Note] InnoDB: Number of transaction pools: 1
2024-09-18 20:05:57 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-09-18 20:05:57 0 [Note] InnoDB: Using Linux native AIO
2024-09-18 20:05:57 0 [Note] InnoDB: Initializing buffer pool, total size = 80.000MiB, chunk size = 1.250MiB
2024-09-18 20:05:57 0 [Note] InnoDB: Initialized memory pressure event listener
2024-09-18 20:05:57 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-18 20:05:57 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-09-18 20:05:58 0 [Note] InnoDB: End of log at LSN=9962664
2024-09-18 20:05:59 0 [Note] InnoDB: 128 rollback segments are active.
2024-09-18 20:05:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-09-18 20:05:59 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-09-18 20:05:59 0 [Note] InnoDB: log sequence number 9962664; transaction id 11884
2024-09-18 20:05:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-18 20:05:59 0 [Note] InnoDB: Loading buffer pool(s) from /home/kevin/.config/cqrlog/database/ib_buffer_pool
2024-09-18 20:05:59 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-09-18 20:05:59 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-09-18 20:05:59 0 [Note] Server socket created on IP: '::'.
2024-09-18 20:05:59 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-09-18 20:05:59 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-09-18 20:05:59 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.11.8-MariaDB' socket: '/home/kevin/.config/cqrlog/database/sock' port: 64000 MariaDB Server
2024-09-18 20:05:59 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2024-09-18 20:06:03 0 [Note] InnoDB: Buffer pool(s) load completed at 240918 20:06:03
2024-09-18 20:16:53 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-09-18 20:16:53 0 [Note] InnoDB: FTS optimize thread exiting.
2024-09-18 20:16:53 0 [Note] InnoDB: Starting shutdown...
2024-09-18 20:16:53 0 [Note] InnoDB: Dumping buffer pool(s) to /home/kevin/.config/cqrlog/database/ib_buffer_pool
2024-09-18 20:16:53 0 [Note] InnoDB: Buffer pool(s) dump completed at 240918 20:16:53
2024-09-18 20:16:54 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-09-18 20:16:54 0 [Note] InnoDB: Shutdown completed; log sequence number 11153749; transaction id 11895
2024-09-18 20:16:55 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-09-18 20:16:59 0 [Note] Starting MariaDB 10.11.8-MariaDB source revision 3a069644682e336e445039e48baae9693f9a08ee as process 3702
2024-09-18 20:17:00 0 [Warning] option 'innodb-log-buffer-size': unsigned value 1048576 adjusted to 2097152
2024-09-18 20:17:00 0 [Note] InnoDB: Compressed tables use zlib 1.3.0.zlib-ng
2024-09-18 20:17:00 0 [Note] InnoDB: Number of transaction pools: 1
2024-09-18 20:17:00 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-09-18 20:17:00 0 [Note] InnoDB: Using Linux native AIO
2024-09-18 20:17:00 0 [Note] InnoDB: Initializing buffer pool, total size = 80.000MiB, chunk size = 1.250MiB
2024-09-18 20:17:00 0 [Note] InnoDB: Initialized memory pressure event listener
2024-09-18 20:17:00 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-18 20:17:00 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-09-18 20:17:00 0 [Note] InnoDB: End of log at LSN=11153749
2024-09-18 20:17:01 0 [Note] InnoDB: 128 rollback segments are active.
2024-09-18 20:17:01 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-09-18 20:17:01 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-09-18 20:17:01 0 [Note] InnoDB: log sequence number 11153749; transaction id 11896
2024-09-18 20:17:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-18 20:17:01 0 [Note] InnoDB: Loading buffer pool(s) from /home/kevin/.config/cqrlog/database/ib_buffer_pool
2024-09-18 20:17:01 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-09-18 20:17:01 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-09-18 20:17:01 0 [Note] Server socket created on IP: '::'.
2024-09-18 20:17:01 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-09-18 20:17:01 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-09-18 20:17:01 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.11.8-MariaDB' socket: '/home/kevin/.config/cqrlog/database/sock' port: 64000 MariaDB Server
2024-09-18 20:17:02 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2024-09-18 20:17:03 0 [Note] InnoDB: Buffer pool(s) load completed at 240918 20:17:03
2024-09-18 20:19:39 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-09-18 20:19:39 0 [Note] InnoDB: FTS optimize thread exiting.
2024-09-18 20:19:39 0 [Note] InnoDB: Starting shutdown...
2024-09-18 20:19:39 0 [Note] InnoDB: Dumping buffer pool(s) to /home/kevin/.config/cqrlog/database/ib_buffer_pool
2024-09-18 20:19:39 0 [Note] InnoDB: Buffer pool(s) dump completed at 240918 20:19:39
2024-09-18 20:19:39 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-09-18 20:19:39 0 [Note] InnoDB: Shutdown completed; log sequence number 11228757; transaction id 11912
2024-09-18 20:19:39 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-09-18 20:19:44 0 [Note] Starting MariaDB 10.11.8-MariaDB source revision 3a069644682e336e445039e48baae9693f9a08ee as process 3755
2024-09-18 20:19:45 0 [Warning] option 'innodb-log-buffer-size': unsigned value 1048576 adjusted to 2097152
2024-09-18 20:19:45 0 [Note] InnoDB: Compressed tables use zlib 1.3.0.zlib-ng
2024-09-18 20:19:45 0 [Note] InnoDB: Number of transaction pools: 1
2024-09-18 20:19:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-09-18 20:19:45 0 [Note] InnoDB: Using Linux native AIO
2024-09-18 20:19:45 0 [Note] InnoDB: Initializing buffer pool, total size = 80.000MiB, chunk size = 1.250MiB
2024-09-18 20:19:45 0 [Note] InnoDB: Initialized memory pressure event listener
2024-09-18 20:19:45 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-18 20:19:45 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-09-18 20:19:45 0 [Note] InnoDB: End of log at LSN=11228757
2024-09-18 20:19:46 0 [Note] InnoDB: 128 rollback segments are active.
2024-09-18 20:19:46 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-09-18 20:19:46 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-09-18 20:19:46 0 [Note] InnoDB: log sequence number 11228757; transaction id 11911
2024-09-18 20:19:46 0 [Note] InnoDB: Loading buffer pool(s) from /home/kevin/.config/cqrlog/database/ib_buffer_pool
2024-09-18 20:19:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-18 20:19:46 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-09-18 20:19:46 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-09-18 20:19:46 0 [Note] Server socket created on IP: '::'.
2024-09-18 20:19:46 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-09-18 20:19:46 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-09-18 20:19:46 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.11.8-MariaDB' socket: '/home/kevin/.config/cqrlog/database/sock' port: 64000 MariaDB Server
2024-09-18 20:19:46 4 [ERROR] InnoDB: Table mysql.innodb_table_stats not found.
2024-09-18 20:19:48 0 [Note] InnoDB: Buffer pool(s) load completed at 240918 20:19:48
2024-09-18 20:21:49 6 [Warning] Aborted connection 6 to db: 'cqrlog007' user: 'cqrlog' host: '' (Got an error reading communication packets)
2024-09-18 20:21:49 8 [Warning] Aborted connection 8 to db: 'cqrlog007' user: 'cqrlog' host: '' (Got an error reading communication packets)
2024-09-18 20:21:49 7 [Warning] Aborted connection 7 to db: 'cqrlog007' user: 'cqrlog' host: '' (Got an error reading communication packets)
2024-09-18 20:21:49 4 [Warning] Aborted connection 4 to db: 'cqrlog007' user: 'cqrlog' host: '' (Got an error reading communication packets)
2024-09-18 20:21:49 5 [Warning] Aborted connection 5 to db: 'cqrlog007' user: 'cqrlog' host: '' (Got an error reading communication packets)
2024-09-18 20:21:49 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-09-18 20:21:49 0 [Note] InnoDB: FTS optimize thread exiting.
2024-09-18 20:21:49 0 [Note] InnoDB: Starting shutdown...
2024-09-18 20:21:49 0 [Note] InnoDB: Dumping buffer pool(s) to /home/kevin/.config/cqrlog/database/ib_buffer_pool
2024-09-18 20:21:49 0 [Note] InnoDB: Buffer pool(s) dump completed at 240918 20:21:49
2024-09-18 20:21:51 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-09-18 20:21:51 0 [Note] InnoDB: Shutdown completed; log sequence number 11301552; transaction id 11917
2024-09-18 20:21:51 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-09-18 20:24:25 0 [Note] Starting MariaDB 10.11.8-MariaDB source revision 3a069644682e336e445039e48baae9693f9a08ee as process 3031
2024-09-18 20:24:25 0 [Warning] option 'innodb-log-buffer-size': unsigned value 1048576 adjusted to 2097152
2024-09-18 20:24:25 0 [Note] InnoDB: Compressed tables use zlib 1.3.0.zlib-ng
2024-09-18 20:24:26 0 [Note] InnoDB: Number of transaction pools: 1
2024-09-18 20:24:26 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-09-18 20:24:26 0 [Note] InnoDB: Using Linux native AIO
2024-09-18 20:24:26 0 [Note] InnoDB: Initializing buffer pool, total size = 80.000MiB, chunk size = 1.250MiB
2024-09-18 20:24:26 0 [Note] InnoDB: Initialized memory pressure event listener
2024-09-18 20:24:26 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-18 20:24:26 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-09-18 20:24:26 0 [Note] InnoDB: End of log at LSN=11301552
2024-09-18 20:24:27 0 [Note] InnoDB: 128 rollback segments are active.
2024-09-18 20:24:27 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-09-18 20:24:27 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-09-18 20:24:27 0 [Note] InnoDB: log sequence number 11301552; transaction id 11918
2024-09-18 20:24:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-18 20:24:27 0 [Note] InnoDB: Loading buffer pool(s) from /home/kevin/.config/cqrlog/database/ib_buffer_pool
2024-09-18 20:24:27 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-09-18 20:24:27 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-09-18 20:24:27 0 [Note] Server socket created on IP: '::'.
2024-09-18 20:24:27 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-09-18 20:24:27 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-09-18 20:24:27 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.11.8-MariaDB' socket: '/home/kevin/.config/cqrlog/database/sock' port: 64000 MariaDB Server
2024-09-18 20:24:33 0 [Note] InnoDB: Buffer pool(s) load completed at 240918 20:24:33

oh1kh
MySQL not starting

OK!

So what is the current problem?

Cqrlog does not start any more ?
You get database connection error every time you try to mark qsl received for same worked qso?

It is normal to have many lines in mysql.err file as there are notes and warnings, too.

You can try to delete (while Cqrlog is NOT runnng) all "ib_logfileX" files from folder /home/kevin/.config/cqrlog/database/
the "X" can be any number, usually it is 0 (zero), but there may be also others.
Deleting file is harmless, but may sometimes help on some database connection errors.(mainly at Cqrlog startup)

If it seems that you can not modify your existing qsos (including marking qsl received) you can try to make full adif export of all qsos, then create a new log and import your adif to that.
Check that all qsos are there and try to modify them then. If it works start using this new log instead.

--
Saku
OH1KH