MYSQL startup (actually shutdown) error

3 posts / 0 new
Last post
n3gb
MYSQL startup (actually shutdown) error

Today when I went to start CQRLOG on my Archive machine, I got an error about starting MYSQL. Looking into databases/mysql.err, I found that the error was probably caused by a failure to shutdown correctly the previous session.

I had this problem before, and the only common factor was what I was doing at the end of the last session: deleting several old log databases. I think I dropped 4 or 5 old test cases, then canceled the selection window and exited.

Attached is `tail -200 mysql.err', showing the end of successful shutdown on 28-Jan, the unsuccessful shutdown on 1-Feb, then the attempts to start on 2-Feb. Note that the exit on 1-Feb produced no window showing any problem.


2022-01-28 17:51:31 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`cqrlog_main` index `club_nr4` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-01-28 17:51:31 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`cqrlog_main` index `club_nr5` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-01-28 17:51:31 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`notes` index `callsign` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`profiles` index `nr` but the required persistent statistics storage is not present or is co
rrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club1` index `club_nr` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club1` index `fromdate` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club1` index `todate` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club1` index `clubcall` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club2` index `club_nr` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club2` index `fromdate` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club2` index `todate` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club2` index `clubcall` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club3` index `club_nr` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:32 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club3` index `fromdate` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club3` index `todate` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club3` index `clubcall` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club4` index `club_nr` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club4` index `fromdate` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club4` index `todate` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club4` index `clubcall` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club5` index `club_nr` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club5` index `fromdate` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club5` index `todate` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`club5` index `clubcall` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:33 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`zipcode1` index `zip` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-01-28 17:51:34 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`zipcode2` index `zip` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-01-28 17:51:34 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`zipcode3` index `zip` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-01-28 17:51:34 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`dxcc_id` index `adif` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-01-28 17:51:35 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`log_changes` index `id_cqrlog_main` but the required persistent statistics storage is not p
resent or is corrupted. Using transient stats instead.
2022-01-28 17:51:35 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`call_alert` index `id` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-01-28 17:51:35 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`call_alert` index `callsign` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-01-28 17:56:20 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`cqrlog_main` index `main_index` but the required persistent statistics storage is not prese
nt or is corrupted. Using transient stats instead.
2022-01-28 17:56:21 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`cqrlog_main` index `callsign` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-01-28 17:56:21 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`cqrlog_main` index `name` but the required persistent statistics storage is not present or
is corrupted. Using transient stats instead.
2022-01-28 17:56:21 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`cqrlog_main` index `qth` but the required persistent statistics storage is not present or i
s corrupted. Using transient stats instead.
2022-01-28 17:56:21 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`cqrlog_main` index `adif` but the required persistent statistics storage is not present or
is corrupted. Using transient stats instead.
2022-01-28 17:56:21 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`cqrlog_main` index `idcall` but the required persistent statistics storage is not present o
r is corrupted. Using transient stats instead.
2022-01-28 17:56:22 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog015`.`cqrlog_main` index `band` but the required persistent statistics storage is not present or
is corrupted. Using transient stats instead.
2022-01-28 18:12:51 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-01-28 18:12:51 0 [Note] InnoDB: FTS optimize thread exiting.
2022-01-28 18:12:51 0 [Note] InnoDB: Starting shutdown...
2022-01-28 18:12:51 0 [Note] InnoDB: Dumping buffer pool(s) to /home/gwb/.config/cqrlog/database/ib_buffer_pool
2022-01-28 18:12:51 0 [Note] InnoDB: Restricted to 1260 pages due to innodb_buf_pool_dump_pct=25
2022-01-28 18:12:51 0 [Note] InnoDB: Buffer pool(s) dump completed at 220128 18:12:51
2022-01-28 18:12:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-01-28 18:12:53 0 [Note] InnoDB: Shutdown completed; log sequence number 290833658; transaction id 648194
2022-01-28 18:12:53 0 [Note] /usr/sbin/mysqld: Shutdown complete

2022-02-01 18:57:48 0 [Note] InnoDB: Uses event mutexes
2022-02-01 18:57:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-01 18:57:48 0 [Note] InnoDB: Number of pools: 1
2022-02-01 18:57:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-02-01 18:57:48 0 [Note] InnoDB: Using Linux native AIO
2022-02-01 18:57:48 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2022-02-01 18:57:48 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-01 18:57:48 0 [Note] InnoDB: 128 rollback segments are active.
2022-02-01 18:57:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-01 18:57:48 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-01 18:57:48 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-02-01 18:57:48 0 [Note] InnoDB: 10.5.13 started; log sequence number 290833658; transaction id 648194
2022-02-01 18:57:48 0 [Note] InnoDB: Loading buffer pool(s) from /home/gwb/.config/cqrlog/database/ib_buffer_pool
2022-02-01 18:57:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-01 18:57:48 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2022-02-01 18:57:48 0 [Note] Server socket created on IP: '::'.
2022-02-01 18:57:48 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2022-02-01 18:57:48 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")
2022-02-01 18:57:48 0 [Note] Reading of all Master_info entries succeeded
2022-02-01 18:57:48 0 [Note] Added new Master_info '' to hash table
2022-02-01 18:57:48 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.5.13-MariaDB' socket: '/home/gwb/.config/cqrlog/database/sock' port: 64000 MariaDB package
2022-02-01 18:57:48 0 [Note] InnoDB: Buffer pool(s) load completed at 220201 18:57:48
2022-02-01 18:57:49 4 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2022-02-01 18:58:05 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `main_index` but the required persistent statistics storage is not prese
nt or is corrupted. Using transient stats instead.
2022-02-01 18:58:05 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `callsign` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-02-01 18:58:05 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `name` but the required persistent statistics storage is not present or
is corrupted. Using transient stats instead.
2022-02-01 18:58:05 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `qth` but the required persistent statistics storage is not present or i
s corrupted. Using transient stats instead.
2022-02-01 18:58:05 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `adif` but the required persistent statistics storage is not present or
is corrupted. Using transient stats instead.
2022-02-01 18:58:05 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `idcall` but the required persistent statistics storage is not present o
r is corrupted. Using transient stats instead.
2022-02-01 18:58:05 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `band` but the required persistent statistics storage is not present or
is corrupted. Using transient stats instead.
2022-02-01 18:58:05 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `club_nr1` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-02-01 18:58:05 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `club_nr2` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-02-01 18:58:05 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `club_nr3` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-02-01 18:58:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `club_nr4` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-02-01 18:58:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `club_nr5` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-02-01 18:58:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`notes` index `callsign` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`profiles` index `nr` but the required persistent statistics storage is not present or is co
rrupted. Using transient stats instead.
2022-02-01 18:58:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club1` index `club_nr` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club1` index `fromdate` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club1` index `todate` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club1` index `clubcall` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club2` index `club_nr` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club2` index `fromdate` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club2` index `todate` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club2` index `clubcall` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club3` index `club_nr` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club3` index `fromdate` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club3` index `todate` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club3` index `clubcall` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club4` index `club_nr` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club4` index `fromdate` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club4` index `todate` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-02-01 18:58:08 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club4` index `clubcall` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:08 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club5` index `club_nr` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:08 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club5` index `fromdate` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:08 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club5` index `todate` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-02-01 18:58:08 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`club5` index `clubcall` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:08 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`zipcode1` index `zip` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-02-01 18:58:08 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`zipcode2` index `zip` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-02-01 18:58:09 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`zipcode3` index `zip` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-02-01 18:58:09 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`dxcc_id` index `adif` but the required persistent statistics storage is not present or is c
orrupted. Using transient stats instead.
2022-02-01 18:58:09 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`log_changes` index `id_cqrlog_main` but the required persistent statistics storage is not p
resent or is corrupted. Using transient stats instead.
2022-02-01 18:58:10 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`call_alert` index `id` but the required persistent statistics storage is not present or is
corrupted. Using transient stats instead.
2022-02-01 18:58:10 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`call_alert` index `callsign` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-02-01 19:02:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `main_index` but the required persistent statistics storage is not prese
nt or is corrupted. Using transient stats instead.
2022-02-01 19:02:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `callsign` but the required persistent statistics storage is not present
or is corrupted. Using transient stats instead.
2022-02-01 19:02:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `name` but the required persistent statistics storage is not present or
is corrupted. Using transient stats instead.
2022-02-01 19:02:06 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `qth` but the required persistent statistics storage is not present or i
s corrupted. Using transient stats instead.
2022-02-01 19:02:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `adif` but the required persistent statistics storage is not present or
is corrupted. Using transient stats instead.
2022-02-01 19:02:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `idcall` but the required persistent statistics storage is not present o
r is corrupted. Using transient stats instead.
2022-02-01 19:02:07 4 [Note] InnoDB: Recalculation of persistent statistics requested for table `cqrlog016`.`cqrlog_main` index `band` but the required persistent statistics storage is not present or
is corrupted. Using transient stats instead.
2022-02-01 19:10:59 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-02-01 19:10:59 0 [Note] InnoDB: FTS optimize thread exiting.
2022-02-01 19:10:59 0 [Note] InnoDB: Starting shutdown...
2022-02-01 19:10:59 0 [Note] InnoDB: Dumping buffer pool(s) to /home/gwb/.config/cqrlog/database/ib_buffer_pool
2022-02-01 19:10:59 0 [Note] InnoDB: Restricted to 1260 pages due to innodb_buf_pool_dump_pct=25
2022-02-01 19:10:59 0 [Note] InnoDB: Buffer pool(s) dump completed at 220201 19:10:59
malloc(): unsorted double linked list corrupted
220201 19:11:00 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.5.13-MariaDB
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=5
max_threads=258
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 699027 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x49000
2022-02-02 12:35:01 0 [ERROR] mysqld: Can't lock aria control file '/home/gwb/.config/cqrlog/database/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2022-02-02 12:35:31 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/home/gwb/.config/cqrlog/database/ar
ia_log_control'
2022-02-02 12:35:31 0 [ERROR] Plugin 'Aria' init function returned error.
2022-02-02 12:35:31 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-02-02 12:35:31 0 [Note] InnoDB: Uses event mutexes
2022-02-02 12:35:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-02 12:35:31 0 [Note] InnoDB: Number of pools: 1
2022-02-02 12:35:31 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-02-02 12:35:31 0 [Note] InnoDB: Using Linux native AIO
2022-02-02 12:35:31 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2022-02-02 12:35:31 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-02 12:35:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=290833658,290833658
2022-02-02 12:35:31 0 [Note] InnoDB: Ignoring data file './cqrlog016/#sql-alter-6839-4.ibd' with space ID 679. Another data file called ./cqrlog016/log_changes.ibd exists with the same space ID.
2022-02-02 12:35:31 0 [Note] InnoDB: Ignoring data file './cqrlog016/#sql-alter-6839-4.ibd' with space ID 679. Another data file called ./cqrlog016/log_changes.ibd exists with the same space ID.
2022-02-02 12:35:31 0 [Note] InnoDB: Ignoring data file './cqrlog016/#sql-alter-6839-4.ibd' with space ID 679. Another data file called ./cqrlog016/log_changes.ibd exists with the same space ID.
2022-02-02 12:35:31 0 [Note] InnoDB: Starting a batch to recover 761 pages from redo log.
2022-02-02 12:35:32 0 [Note] InnoDB: Starting final batch to recover 362 pages from redo log.
2022-02-02 12:35:33 0 [Note] InnoDB: 128 rollback segments are active.
2022-02-02 12:35:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-02 12:35:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-02 12:35:33 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-02 12:35:33 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-02-02 12:35:33 0 [Note] InnoDB: 10.5.13 started; log sequence number 307174730; transaction id 696572
2022-02-02 12:35:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-02 12:35:33 0 [Note] InnoDB: Loading buffer pool(s) from /home/gwb/.config/cqrlog/database/ib_buffer_pool
2022-02-02 12:35:33 0 [ERROR] Failed to initialize plugins.
2022-02-02 12:35:33 0 [ERROR] Aborting
2022-02-02 12:36:37 0 [ERROR] mysqld: Can't lock aria control file '/home/gwb/.config/cqrlog/database/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2022-02-02 12:37:07 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/home/gwb/.config/cqrlog/database/ar
ia_log_control'
2022-02-02 12:37:07 0 [ERROR] Plugin 'Aria' init function returned error.
2022-02-02 12:37:07 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-02-02 12:37:07 0 [Note] InnoDB: Uses event mutexes
2022-02-02 12:37:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-02 12:37:07 0 [Note] InnoDB: Number of pools: 1
2022-02-02 12:37:07 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-02-02 12:37:08 0 [Note] InnoDB: Using Linux native AIO
2022-02-02 12:37:08 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2022-02-02 12:37:08 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-02 12:37:08 0 [Note] InnoDB: 128 rollback segments are active.
2022-02-02 12:37:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-02 12:37:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-02 12:37:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-02-02 12:37:08 0 [Note] InnoDB: 10.5.13 started; log sequence number 307176156; transaction id 696572
2022-02-02 12:37:08 0 [Note] InnoDB: Loading buffer pool(s) from /home/gwb/.config/cqrlog/database/ib_buffer_pool
2022-02-02 12:37:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-02 12:37:08 0 [ERROR] Failed to initialize plugins.
2022-02-02 12:37:08 0 [ERROR] Aborting

n3gb
MYSQL startup (actually shutdown) error

Forgot the other info

CQRLOG 2.5.2(001)
openSUSE Leap 15.3
mariadb 10.5.13

oh1kh
MYSQL startup (actually shutdown) error

Hi!

"canceled the selection window and exited."
I assume that this means that you had a log open, then using "NewQS/File/Open or create new log" you went to delete those logs.

I do not know if this has any relation to this error, but I have found out that most safest way to change log is to close cqrlog, start again and select the other log.
Same with deleting logs. Close cqrlog, start again and delete logs you want to. Then press cancel and DBconnect window (whole cqrlog) closes.

Coming to Database connect window from NewQSO is a bit unstable. Most of times operations work, but sometimes they do not.
That is because Database connection window is not the "root" of cqrlog like it should be. Entering to Database window from NewQSO should close all other threads and current log, but it does not. That is why pressing cancel there returns to full running system if entering was done via "NewQS/File/Open or create new log"

That is just my opinion.

--
Saku
OH1KH