[Maria-discuss] MariaDB won't start after updating Fedora 26 to Fedora 27
After checking the logs I see mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2 "No such file or directory")If I manually create this dir I can then start it ... until the next reboot. What is the correct fix to ensure its works as it did before the update please?
Am 21.11.2017 um 09:13 schrieb Bill Damage:
After checking the logs I see mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2 "No such file or directory") If I manually create this dir I can then start it ... until the next reboot. What is the correct fix to ensure its works as it did before the update please?
https://www.freedesktop.org/software/systemd/man/tmpfiles.d.html or make a proper unit because the pid-file is not needed at all as well as mysqld_safe
[root@srv-rhsoft:~]$ systemctl status mysqld ? mysqld.service - MariaDB Database Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since Sat 2017-11-18 01:36:22 CET; 3 days ago Main PID: 912 (mysqld) Status: "Taking your SQL requests now..." Tasks: 51 (limit: 2048) CGroup: /system.slice/mysqld.service ??912 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --pid-file=/dev/null
Thanks Reindl.
I want to do it the way Fedora should be doing by default as there are a few servers, and I don't want to deviate from being able to update them all just using "dnf ..." in future - it's worked fine that way for years. Actually I have one still on F26, and just bounced it to see that the dir in question is recreated OK. So, if tmpfiles.d is the way it's being done, what would I look for on *that* system to see why it broke on F27 please? I'm not a db guy at all, I just need to get the db up each boot without manual intervention, or worse a custom dir creation script which may break in the future. On Tuesday, 21 November 2017, 09:24:36 GMT, Reindl Harald h.reindl@thelounge.net wrote:
Am 21.11.2017 um 09:13 schrieb Bill Damage:
After checking the logs I see mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2 "No such file or directory") If I manually create this dir I can then start it ... until the next reboot. What is the correct fix to ensure its works as it did before the update please?
https://www.freedesktop.org/software/systemd/man/tmpfiles.d.html or make a proper unit because the pid-file is not needed at all as well as mysqld_safe
[root@srv-rhsoft:~]$ systemctl status mysqld ? mysqld.service - MariaDB Database Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since Sat 2017-11-18 01:36:22 CET; 3 days ago Main PID: 912 (mysqld) Status: "Taking your SQL requests now..." Tasks: 51 (limit: 2048) CGroup: /system.slice/mysqld.service ??912 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --pid-file=/dev/null
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Am 21.11.2017 um 11:04 schrieb Bill Damage:
Thanks Reindl.
I want to do it the way Fedora should be doing by default as there are a few servers, and I don't want to deviate from being able to update them all just using "dnf ..." in future - it's worked fine that way for years.
Actually I have one still on F26, and just bounced it to see that the dir in question is recreated OK. So, if tmpfiles.d is the way it's being done, what would I look for on *that* system to see why it broke on F27 please? I'm not a db guy at all, I just need to get the db up each boot without manual intervention, or worse a custom dir creation script which may break in the future.
besides that https://bugzilla.redhat.com/enter_bug.cgi?product=Fedora is the place for packager bugs https://www.freedesktop.org/software/systemd/man/tmpfiles.d.html is not rocket science
as for everything in systemd context /etc/tmpfiles.d/ is for local stuff and /usr/lib/tmpfiles.d/ for distro stuff - just copy over the obviously missing file from F26 to the same location while your bugreport got handeled for the next update - all of that two steps wouldn't haven taken longer than write the mail
On Tuesday, 21 November 2017, 09:24:36 GMT, Reindl Harald h.reindl@thelounge.net wrote:
Am 21.11.2017 um 09:13 schrieb Bill Damage:
After checking the logs I see mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2 "No such file or directory") If I manually create this dir I can then start it ... until the next reboot. What is the correct fix to ensure its works as it did before the update please?
https://www.freedesktop.org/software/systemd/man/tmpfiles.d.html or make a proper unit because the pid-file is not needed at all as well as mysqld_safe
[root@srv-rhsoft mailto:root@srv-rhsoft:~]$ systemctl status mysqld ? mysqld.service - MariaDB Database Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since Sat 2017-11-18 01:36:22 CET; 3 days ago Main PID: 912 (mysqld) Status: "Taking your SQL requests now..." Tasks: 51 (limit: 2048) CGroup: /system.slice/mysqld.service ??912 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --pid-file=/dev/null
On 11/21/2017 03:13 AM, Bill Damage wrote:
After checking the logs I see mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2 "No such file or directory") If I manually create this dir I can then start it ... until the next reboot. What is the correct fix to ensure its works as it did before the update please?
/var/run/mariabd is a temp directory created by the system on booting
[ruben@www3 ~]$ cat /usr/lib/tmpfiles.d/mariadb.conf d /run/mysqld 0755 mysql mysql -
on my system
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (3)
-
Bill Damage -
Reindl Harald -
Ruben Safir