[Discuss] mysql problem

[Joe Polcari]

What's the mysqld log say?

-----Original Message-----
From: Discuss [mailto:discuss-bounces+joe=polcari.com at blu.org] On Behalf Of dan moylan
Sent: Friday, February 02, 2018 10:05 AM
To: boston linux and unix (blu)
Cc: betty moylan
Subject: [Discuss] mysql problem


running fc26 on acer aspire laptop
using mariadb

mysql been running fine for months.

suddenly:

# mysql

ERROR 2002 (HY000): Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111 "Connection
refused")

# dnf install mariadb
# dnf install mariadb-server

both indicated everything was already installed.

# systemctl enable mariadb.service

produced no errors

# systemctl start  mariadb.service

produced this:

> ● mariadb.service - MariaDB 10.1 database server
>   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
>   Active: failed (Result: exit-code) since Thu 2018-02-01 15:46:02 EST; 13min ago
>  Process: 20074 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
>  Process: 20000 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
>  Process: 19970 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
> Main PID: 20074 (code=exited, status=1/FAILURE)
>
> Feb 01 15:46:01 rigel systemd[1]: Starting MariaDB 10.1 database server...
> Feb 01 15:46:01 rigel mysql-check-socket[19970]: Socket file /var/lib/mysql/mysql.sock exists.
> Feb 01 15:46:01 rigel mysql-check-socket[19970]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically.
> Feb 01 15:46:01 rigel mysql-prepare-db-dir[20000]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
> Feb 01 15:46:01 rigel mysql-prepare-db-dir[20000]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.
> Feb 01 15:46:01 rigel mysqld[20074]: 2018-02-01 15:46:01 140518537700544 [Note] /usr/libexec/mysqld (mysqld 10.1.30-MariaDB) starting as process 20074 ...
> Feb 01 15:46:02 rigel systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
> Feb 01 15:46:02 rigel systemd[1]: Failed to start MariaDB 10.1 database server.
> Feb 01 15:46:02 rigel systemd[1]: mariadb.service: Unit entered failed state.
> Feb 01 15:46:02 rigel systemd[1]: mariadb.service: Failed with result 'exit-code'.

any suggestions as to what might have happened, or what i should do?

ole dan

j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777-0207 (cel)
jdm at moylan.us
www.moylan.us
[no html pls]
_______________________________________________
Discuss mailing list
Discuss at blu.org
http://lists.blu.org/mailman/listinfo/discuss


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus