[debian-mysql] Bug#1009290: Bug#1009290: mariadb-server-10.6: Fails to start on live system

[Faustin Lammler]

Hi Denys,
I am not sure that the problem is the same, in your case it seems that
the datadir does not exist or need to be recreated.

If you are sure that nothing can be lost (or that you have backups), you
should try the following:
| sudo systemctl stop mariadb
| sudo rm -rf /var/lib/mysql/*
| sudo -u mysql mariadb-install-db
| Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
| 2022-05-23 14:18:53 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 1
| 2022-05-23 14:18:53 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
| 2022-05-23 14:18:53 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
| OK
| ...
| sudo systemctl start mariadb

Regards,

Denys Nykula <vegan at libre.net.ua>,
18/05/2022 – 17:16:00 (+0300):

> Hello. The apt install of mariadb-server-10.6 fails for me too,
> with the same line "Could not execute systemctl" but different
> journal messages. I removed the existing setup in /etc and /var,
> purged dependencies, but install still fails. How do I debug?
> 
> systemd[1]: Starting MariaDB 10.6.7 database server...
> [Note] /usr/sbin/mariadbd (server 10.6.7-MariaDB-3+b1) starting as process 98614 ...
> [Note] InnoDB: The first data file './ibdata1' did not exist. A new tablespace will be created!
> [Note] InnoDB: Compressed tables use zlib 1.2.11
> [Note] InnoDB: Number of pools: 1
> [Note] InnoDB: Using crc32 + pclmulqdq instructions
> [Note] InnoDB: Using liburing
> [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
> [Note] InnoDB: Completed initialization of buffer pool
> [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ... 
> [Note] InnoDB: File './ibdata1' size is now 12 MB.
> [Note] InnoDB: Setting log file ./ib_logfile101 size to 100663296 bytes
> [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
> [Note] InnoDB: New log file created, LSN=10329
> [Note] InnoDB: Doublewrite buffer not found: creating new
> [Note] InnoDB: Doublewrite buffer created
> [Note] InnoDB: 128 rollback segments are active.
> [Note] InnoDB: Creating shared tablespace for temporary tables 
> [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 
> [Note] InnoDB: File './ibtmp1' size is now 12 MB.
> [Note] InnoDB: 10.6.7 started; log sequence number 0; transaction id 3
> [Note] Plugin 'FEEDBACK' is disabled.
> [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 
> [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
> [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
> [Note] Server socket created on IP: '127.0.0.1'.
> [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist 
> [ERROR] Aborting 
> Warning: Memory not freed: 280
> systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
> systemd[1]: mariadb.service: Failed with result 'exit-code'.
> systemd[1]: Failed to start MariaDB 10.6.7 database server.
> 
> _______________________________________________
> pkg-mysql-maint mailing list
> pkg-mysql-maint at alioth-lists.debian.net
> https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-mysql-maint

-- 
Faustin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20220523/e5f8bffa/attachment-0001.sig>