Boston Linux & UNIX was originally founded in 1994 as part of The Boston Computer Society. We meet on the third Wednesday of each month at the Massachusetts Institute of Technology, in Building E51.

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Discuss] mysql problem



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




BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org