Community Packages

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#62101 - [percona-server] 8.0.15_5-1 cannot be installed on a new server

Attached to Project: Community Packages
Opened by Artem Zaytsev (avz) - Thursday, 21 March 2019, 06:31 GMT
Last edited by Massimiliano Torromeo (mtorromeo) - Thursday, 28 March 2019, 13:27 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To Massimiliano Torromeo (mtorromeo)
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description:

When I try to start percona-server right after installation on a new server, I get an error from mysqld_pre_systemd

```
Mar 20 20:50:06 base-image.brgd.ru systemd[1]: Starting MySQL Server...
Mar 20 20:50:06 base-image.brgd.ru mysqld_pre_systemd[5050]: mktemp: failed to create file via template '/var/lib/mysql-files/install-validate-password-plugin.XXXXXX.sql': No such file or directory
Mar 20 20:50:06 base-image.brgd.ru mysqld_pre_systemd[5050]: chmod: cannot access '': No such file or directory
Mar 20 20:50:06 base-image.brgd.ru mysqld_pre_systemd[5050]: /usr/bin/mysqld_pre_systemd: line 43: : No such file or directory
Mar 20 20:50:06 base-image.brgd.ru mysqld_pre_systemd[5050]: /usr/bin/mysqld_pre_systemd: line 44: $initfile: ambiguous redirect
Mar 20 20:50:07 base-image.brgd.ru mysqld_pre_systemd[5050]: /usr/bin/mysqld_pre_systemd: line 119: 5077 Killed /usr/bin/mysqld ${instance:+--defaults-group-suffix=@$instance} --initialize --datadir="$datadir" --user=mysql --init-file="$initfile"
```

I think the reason is that the /var/lib/mysql-files directory is not created either during installation or in mysqld_pre_systemd itself, so mktemp fails with an error in this code:

```
install_validate_password_sql_file () {
local initfile
initfile="$(mktemp /var/lib/mysql-files/install-validate-password-plugin.XXXXXX.sql)"
chmod a+r "$initfile"
echo "SET @@SESSION.SQL_LOG_BIN=0;" > "$initfile"
echo "INSERT INTO mysql.component (component_id, component_group_id, component_urn) VALUES (1, 1, 'file://component_validate_password');" >> $initfile
echo $initfile
}
```

If I manually create a directory /var/lib/mysql-files, the first run is normal and then everything works fine.

Steps to reproduce:
1. Install archlinux
2. pacman -S percona-server
3. systemctl start mysqld
This task depends upon

Closed by  Massimiliano Torromeo (mtorromeo)
Thursday, 28 March 2019, 13:27 GMT
Reason for closing:  Fixed
Additional comments about closing:  percona-server-8.0.15_5-2

Loading...