Arch Linux

mdcclxv

Member

Registered: 2022-04-26

Posts: 207

[SOLVED] Trying to install mysql fails

Hi everyone,

I'm trying to install mysql and I get the following error at the end of the installation process:

:: Running post-transaction hooks...
(1/4) Creating system user accounts...
(2/4) Reloading system manager configuration...
(3/4) Creating temporary files...
Cannot set file attributes for '/var/log/journal', maybe due to incompatibility in specified attributes, previous=0x10001000, current=0x10001000, expected=0x10801000, ignoring.
Cannot set file attributes for '/var/log/journal/607d78a5bae345429e385bcbfa46ccd3', maybe due to incompatibility in specified attributes, previous=0x00001000, current=0x00001000, expected=0x00801000, ignoring.
Cannot set file attributes for '/var/log/journal/remote', maybe due to incompatibility in specified attributes, previous=0x10001000, current=0x10001000, expected=0x10801000, ignoring.
Cannot set file attributes for '/var/lib/mysql', maybe due to incompatibility in specified attributes, previous=0x10001000, current=0x10001000, expected=0x10801000, ignoring.
(4/4) Arming ConditionNeedsUpdate...

My root partition is formatted with F2FS (NVMe drives). I found this post https://bbs.archlinux.org/viewtopic.php?id=272893 but I definitely don't understand what needs to be done

Trying afterwards to start mysql via systemctl throws the following error:

Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.

journalctl -xeu mariadb.service outputs

Apr 30 03:04:14 amd mariadbd[2222]: 2022-04-30  3:04:14 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Apr 30 03:04:14 amd mariadbd[2222]: 2022-04-30  3:04:14 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
Apr 30 03:04:14 amd mariadbd[2222]: 2022-04-30  3:04:14 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Apr 30 03:04:14 amd mariadbd[2222]: 2022-04-30  3:04:14 0 [Note] InnoDB: Buffer pool(s) load completed at 220430  3:04:14
Apr 30 03:04:14 amd mariadbd[2222]: 2022-04-30  3:04:14 0 [Note] Server socket created on IP: '0.0.0.0'.
Apr 30 03:04:14 amd mariadbd[2222]: 2022-04-30  3:04:14 0 [Warning] Failed to create a socket for IPv6 '::': errno: 97.
Apr 30 03:04:14 amd mariadbd[2222]: 2022-04-30  3:04:14 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
Apr 30 03:04:14 amd mariadbd[2222]: 2022-04-30  3:04:14 0 [ERROR] Aborting
Apr 30 03:04:14 amd mariadbd[2222]: Warning: Memory not freed: 280
Apr 30 03:04:14 amd systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE

Any clues?

Thanks in advance.

Last edited by mdcclxv (2022-04-30 00:35:52)

Slithery

Administrator

From: Norfolk, UK

Registered: 2013-12-01

Posts: 5,776

Re: [SOLVED] Trying to install mysql fails

Did you configure it properly before trying to start the service?
https://wiki.archlinux.org/title/MariaDB#Installation

---

No, it didn't "fix" anything. It just shifted the brokeness one space to the right. - jasonwryan
Closing -- for deletion; Banning -- for muppetry. - jasonwryan

aur - dotfiles

mdcclxv

Member

Registered: 2022-04-26

Posts: 207

Re: [SOLVED] Trying to install mysql fails

Did you configure it properly before trying to start the service?
https://wiki.archlinux.org/title/MariaDB#Installation

Working now, I sort of panicked because of those install errors and forgot to search the wiki about MySQL on Arch.

Thank you