MySQL Fails to Start - Ubuntu 14.04 64bit


Recommended Posts

Specs
2.13Ghz Processor

1GB Memory

60GB SSD

 

https://gyazo.com/014407946954356a7af3c0c7c8f2af4b

 

SQL crashed sometime this morning at 4AM. I haven't been able to get it to start again, config files are empty. Nothing is there. I can't start the service, and then login either. I was thinking about re-installing the service, however I wasn't sure what that would do to the DBs on there. Is there a tool to where I can make an image of this and toss it into a VM to test?

Link to comment
Share on other sites

Who says mysql is not running??  From your screenshot its running - process 20774

 

Your getting login errors..  You have the wrong path to your sock file?

 

sudo find / -type s

 

This will tell you your sockets..

Link to comment
Share on other sites

Quote

root@nl-gxs-main:~# sudo find / -type s
find: `/proc/21566/task/21566/fd/5': No such file or directory
find: `/proc/21566/task/21566/fdinfo/5': No such file or directory
find: `/proc/21566/fd/5': No such file or directory
find: `/proc/21566/fdinfo/5': No such file or directory
/run/acpid.socket
/run/mysqld/mysqld.sock
/run/dbus/system_bus_socket
/run/udev/control
/dev/log

Was the output. No DB Connections can be made, even local ones. It says the process is running, but it isn't.

 

Quote

root@nl-gxs-main:~# service --status-all
 [ + ]  acpid
 [ + ]  apache2
 [ + ]  apparmor
 [ ? ]  apport
 [ + ]  atd
 [ ? ]  binfmt-support
 [ ? ]  cloudpw
 [ ? ]  console-setup
 [ + ]  cron
 [ ? ]  cryptdisks
 [ ? ]  cryptdisks-early
 [ - ]  dbus
 [ ? ]  dns-clean
 [ + ]  friendly-recovery
 [ - ]  grub-common
 [ ? ]  irqbalance
 [ ? ]  killprocs
 [ ? ]  kmod
 [ - ]  landscape-client
 [ ? ]  mysql
 [ ? ]  networking
 [ ? ]  ondemand
 [ ? ]  open-vm-tools
 [ ? ]  pppd-dns
 [ - ]  procps
 [ ? ]  rc.local
 [ + ]  resolvconf
 [ - ]  rsync
 [ + ]  rsyslog
 [ ? ]  screen-cleanup
 [ ? ]  sendsigs
 [ + ]  ssh
 [ - ]  sudo
 [ + ]  udev
 [ ? ]  umountfs
 [ ? ]  umountnfs.sh
 [ ? ]  umountroot
 [ - ]  unattended-upgrades
 [ - ]  urandom

 

Link to comment
Share on other sites

Looks like it was a patch that was keeping it from starting and connecting. I ran updates, and it took forever for it to be configured and working.

 

Everything seems to be online and functioning now.

Link to comment
Share on other sites

On 12/18/2016 at 3:39 AM, BudMan said:

here is your socket

/run/mysqld/mysqld.sock

 

 

Right, I know the socket was there. The problem was, I couldn't connect to it. It seems like running the updates fixed everything, MySQL Developers disabled something if x patch wasn't installed or something. I'm not 100% sure, but it's online and working now. I have about 100+ updates being pushed at me every week for LAMP related stuff.

Link to comment
Share on other sites

well looks more like a path issue to me..

 

In what you posted you were trying to connect to /var/run/mysqld/mysqld.sock

 

But as you can see your socket was /run/mysqld/mysqld.sock

 

That looks like you were looking in var when it was really just off a /run ?

Link to comment
Share on other sites

I mean, I didn't tell it to specifically look ing /var/run/mysqld/mysqld.sock, I was just using the command to start mysql. I wonder if Oracle changed where the socket was stored, and an update fixed it. Oh well, it works now after I ran all of those updates. I'll have to look into it more.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.