[mythtv-users] Backend can't connect (it was all working fine!) - mysql strangeness

[Damian]

On 10/04/2016 18:41, Bill Meek wrote:
> On 04/09/2016 08:51 PM, Damian wrote:
>> $ mysql -u mythtv -p
>> Enter password:
>> ERROR 2002 (HY000): Can't connect to local MySQL server through 
>> socket '/var/run/mysqld/mysqld.sock' (2)
>
> That error fires on my backend if mysql isn't running.
> 2 more commands in addition to what Noah said.
>
> systemctl status mysql.service
> journalctl --unit mysql.service
>

Hi Bill,

Here's the results of those commands ...

systemctl status mysql.service
\u25cf mysql.service - MySQL Community Server
    Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor 
preset: enabled)
    Active: activating (start-post) since Sun 2016-04-10 19:33:35 BST; 
5min ago
   Process: 6826 ExecStart=/usr/bin/mysqld_safe (code=exited, 
status=0/SUCCESS)
   Process: 6825 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre 
(code=exited, status=0/SUCCESS)
  Main PID: 6826 (code=exited, status=0/SUCCESS);         : 6827 
(mysql-systemd-s)
    CGroup: /system.slice/mysql.service
            \u2514\u2500control
              \u251c\u25006827 /bin/bash 
/usr/share/mysql/mysql-systemd-start post
              \u2514\u25008388 sleep 1

systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
systemd[1]: Stopped MySQL Community Server.
systemd[1]: Starting MySQL Community Server...
mysqld_safe[6826]: 160410 19:33:36 mysqld_safe Can't log to error log 
and syslog at the same ...ffect.
mysqld_safe[6826]: 160410 19:33:36 mysqld_safe Logging to 
'/var/log/mysql/error.log'.
mysqld_safe[6826]: 160410 19:33:37 mysqld_safe Starting mysqld daemon 
with databases from /va.../mysql
mysqld_safe[6826]: 160410 19:33:41 mysqld_safe mysqld from pid file 
/var/run/mysqld/mysqld.pid ended
Hint: Some lines were ellipsized, use -l to show in full.


and
journalctl --unit mysql.service
-- Logs begin at Sun 2016-04-10 19:13:07 BST, end at Sun 2016-04-10 
19:41:01 BST. --
systemd[1]: Starting MySQL Community Server...
mysqld_safe[680]: 160410 19:13:34 mysqld_safe Can't log to error log and 
syslog at the same time.  Rem
mysqld_safe[680]: 160410 19:13:34 mysqld_safe Logging to 
'/var/log/mysql/error.log'.
mysqld_safe[680]: 160410 19:13:34 mysqld_safe Starting mysqld daemon 
with databases from /var/lib/mysq
systemd[1]: mysql.service: Start-post operation timed out. Stopping.
systemd[1]: Failed to start MySQL Community Server.
systemd[1]: mysql.service: Unit entered failed state.
systemd[1]: mysql.service: Failed with result 'timeout'.
systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
systemd[1]: Stopped MySQL Community Server.
systemd[1]: Starting MySQL Community Server...
mysqld_safe[4503]: 160410 19:23:35 mysqld_safe Can't log to error log 
and syslog at the same time.  Re
mysqld_safe[4503]: 160410 19:23:35 mysqld_safe Logging to 
'/var/log/mysql/error.log'.
mysqld_safe[4503]: 160410 19:23:35 mysqld_safe Starting mysqld daemon 
with databases from /var/lib/mys
systemd[1]: mysql.service: Start-post operation timed out. Stopping.
systemd[1]: Failed to start MySQL Community Server.
systemd[1]: mysql.service: Unit entered failed state.
systemd[1]: mysql.service: Failed with result 'timeout'.
systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
systemd[1]: Stopped MySQL Community Server.
systemd[1]: Starting MySQL Community Server...
mysqld_safe[6826]: 160410 19:33:36 mysqld_safe Can't log to error log 
and syslog at the same time.  Re
mysqld_safe[6826]: 160410 19:33:36 mysqld_safe Logging to 
'/var/log/mysql/error.log'.
mysqld_safe[6826]: 160410 19:33:37 mysqld_safe Starting mysqld daemon 
with databases from /var/lib/mys
mysqld_safe[6826]: 160410 19:33:41 mysqld_safe mysqld from pid file 
/var/run/mysqld/mysqld.pid ended

Is that helpful?

Thanks,
Damian