On 27/1/18 9:49 pm, Sjoerd Mullender wrote:
On 27/01/18 01:12, Stephen Morris wrote:
On 26/1/18 7:58 pm, Sjoerd Mullender wrote:
On 26/01/18 00:59, Stephen Morris wrote:
On 26/1/18 10:49 am, Stephen Morris wrote:
On 25/1/18 4:33 am, John Pilkington wrote:
On 24/01/18 17:09, John Pilkington wrote:
sysstemctl | grep maria gives
● mariadb.service loaded failed
failed MariaDB 10.1 database server
There was a 'normal shutdown' of version 10.1.29
version 10.1.30 reports:
2018-01-24 13:55:42 140690185448192 [ERROR] mysqld: Can't
create/write to file '/run/mariadb/mariadb.pid' (Errcode: 2 "No such
file or directory")
2018-01-24 13:55:42 140690185448192 [ERROR] Can't start server:
can't create PID file: No such file or directory
I reinstalled and it failed again.
John P
yumex-dnf offered 10.1.21-5 as a downgrade, and that is running.
Just some info on this, I'm on F27 using mariadb (64 bit) 10.2.9-3 and
it does not appear to be exhibiting this issue in that systemctl
status mariadb shows that the service has started at boot time.
Just further to this, on my system, which may be a hangover from having
installed the community-mysql packages first and using that environment
before uninstalling these and installing the mariadb equivalents, the
mariadb.pid file is placed in /run/mysqld which is owned by User/Group
mysql. The time stamp on this file indicates that it was successfully
created with this mornings boot.
See the bug report: https://bugzilla.redhat.com/show_bug.cgi?id=1538066
Quick fix until mariadb update arrives: add the following line to the
file /usr/lib/tmpfiles.d/mariadb.conf:
d /run/mariadb 0755 mysql mysql -
My mariadb.conf, as installed from the Fedora repositories, has the
following line already in there, but in there twice:
d /run/mysql 0755 mysql mysql
The directory in /usr/lib/tmpfiles.d/mariadb.conf has to match the one
in /etc/my.cnf.d/mariadb-server.cnf for the pid-file variable. The new
value seems to be /run/mariadb.
I've looked at /etc/my.cnf.d/mariadb-server.cnf on my system and in the
[mysqld] section it has the following entries:
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mariadb/mariadb.log
pid-file=/run/mysqld/mariadb.pid
I did have the community-mysql packages installed, but when in answer to
another thread I raised I was told that mariadb was the Fedora
officially support package, I uninstalled the community-mysql packages
and installed the equivalent mariadb packages, which is the first time I
have ever had mariadb installed. I do have some other mysql addon
packages that in their description and package name do not have any
indication that they are written for either of the two package
environments, one of which provides the admin tool that netbeans wants
to know about in its mysql configuration. Netbeans mysql configuration
also has places to specify the commands to start and stop mariadb but I
haven't specified those as with the service automatically starting at
boot time I don't need to.
Is it possible the directory locations have changed with 10.2 as, from
my perspective, the maridb.conf and mariadb-server.cnf files are as
supplied by the Fedora packages?
regards,
Steve
regards,
Steve
regards,
Steve
regards,
Steve
_______________________________________________
users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
_______________________________________________
users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
_______________________________________________
users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
_______________________________________________
users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
_______________________________________________
users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
_______________________________________________
users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
_______________________________________________
users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
