I've been migrating from ns10 to ns11 (doing a --syncjobs to catch any changes) and last few efforts I get failure messages: ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) now there IS no /run/mysqld/mysqld.sock and infact no /run/mysqld directory. why would it suddenly want to connect to this? I've just been running ./migrate --syncjobs happily and its been completing properly till now!
The error means that MySQL or MariaDB is not started and therefore can not be used. If you migrate MySQL databases from one server to another using mysql and mysqldump commands, MySQL/MariaDB must be started.
hmm - indeed mysql (mariadb) was NOT running on the TARGET deb12 server I just built! (I was looking on the source server!) it was certainly running before as ispconfig3 etc was working fine - and multiple migrates had succeeded. so now I'm left puzzling why it would suddenly NOT be running??? thats a bit concerning as I was planning on migrating to this server over the weekend! thanks till. you are right as always! I'm perusing syslog to try get an idea of why it would have stopped running and I notice a zillion lines: 2024-01-06T11:39:15.965440-05:00 ns11 ntpd[1881]: DNS: dns_check: processing 2.debian.pool.ntp.org, 8, 101 2024-01-06T11:39:15.965535-05:00 ns11 ntpd[1881]: DNS: dns_check: DNS error: -3, Temporary failure in name resolution 2024-01-06T11:39:15.965608-05:00 ns11 ntpd[1881]: DNS: dns_take_status: 2.debian.pool.ntp.org=>temp, 3 2024-01-06T11:39:16.964628-05:00 ns11 ntpd[1881]: DNS: dns_probe: 0.debian.pool.ntp.org, cast_flags:8, flags:101 2024-01-06T11:39:16.964941-05:00 ns11 ntpd[1881]: DNS: dns_check: processing 0.debian.pool.ntp.org, 8, 101 2024-01-06T11:39:16.965443-05:00 ns11 ntpd[1881]: DNS: dns_check: DNS error: -3, Temporary failure in name resolution any idea why its complaining? and its been doing this for days! geez never mind - named is not running either!!! this is getting concerning
No, likely a short interruption of internet connection or so. But its the NTP Daemon and not MySQL, so not related. I recommend harddisk usage and RAM usage, as these are the most common reasons for failing.
How much is free? How much memory and swap is used? Code: free -h Any out of memory processes killed? Code: grep -i 'out of memory" /var/log/syslog