2

I restarted my raspberry pi and now then I got this error on my website:

SQLSTATE[HY000] [2002] No such file or directory

I look at sudo service mysql status and I can see this.

Jan 09 17:34:45 raspberrypi systemd[1]: Failed to start MariaDB database server.
Jan 09 17:34:45 raspberrypi systemd[1]: mariadb.service: Unit entered failed state.
Jan 09 17:34:45 raspberrypi systemd[1]: mariadb.service: Failed with result 'signal'.

Has it updated and installed MariaDB? Because I was just using MYSQL i thought.

Can anyone help me fix this, my website is down and lots of people are trying to use it, I need to get it up for tonight.

Error log for mysql:

Jan 09 17:34:45 raspberrypi systemd[1]: Failed to start MariaDB database server.
Jan 09 17:34:45 raspberrypi systemd[1]: mariadb.service: Unit entered failed state.
Jan 09 17:34:45 raspberrypi systemd[1]: mariadb.service: Failed with result 'signal'.

Systemctl output

Jan 09 17:12:32 raspberrypi systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Jan 09 17:12:32 raspberrypi systemd[1]: Failed to start MariaDB database server.
Jan 09 17:12:32 raspberrypi systemd[1]: mariadb.service: Unit entered failed state.
Jan 09 17:12:32 raspberrypi systemd[1]: mariadb.service: Failed with result 'signal'.
Jan 09 17:12:37 raspberrypi systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
Jan 09 17:12:37 raspberrypi systemd[1]: Stopped MariaDB database server.
Jan 09 17:12:37 raspberrypi systemd[1]: Starting MariaDB database server...
Jan 09 17:12:39 raspberrypi systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Jan 09 17:12:39 raspberrypi systemd[1]: Failed to start MariaDB database server.
Jan 09 17:12:39 raspberrypi systemd[1]: mariadb.service: Unit entered failed state.
Jan 09 17:12:39 raspberrypi systemd[1]: mariadb.service: Failed with result 'signal'.
Jan 09 17:12:44 raspberrypi systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
Jan 09 17:12:44 raspberrypi systemd[1]: Stopped MariaDB database server.
Jan 09 17:12:44 raspberrypi systemd[1]: Starting MariaDB database server...
Jan 09 17:12:46 raspberrypi systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Jan 09 17:12:46 raspberrypi systemd[1]: Failed to start MariaDB database server.
Jan 09 17:12:46 raspberrypi systemd[1]: mariadb.service: Unit entered failed state.
Jan 09 17:12:46 raspberrypi systemd[1]: mariadb.service: Failed with result 'signal'.
Jan 09 17:12:51 raspberrypi systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
Jan 09 17:12:51 raspberrypi systemd[1]: Stopped MariaDB database server.
Jan 09 17:12:51 raspberrypi systemd[1]: Starting MariaDB database server...
Jan 09 17:12:53 raspberrypi systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Jan 09 17:12:53 raspberrypi systemd[1]: Failed to start MariaDB database server.
lines 1-32
Improve this question
6
  • Could you run journalctl -u mariadb.service and edit in the output? That might have more extensive logs.
    – Aurora0001
    Commented Jan 9, 2018 at 17:44
  • @Aurora0001 I have edited in the systemctl output. Its the same. Im sure I was using INNODB Engine before. How can I get it back?
    – cobra12
    Commented Jan 9, 2018 at 17:50
  • First, you should probably check if MySQL is currently installed (run dpkg -l | grep mysql, and see if you can spot mysql-server). If it is, you could try uninstalling MariaDB and see if that helps (be sure to back up as appropriate first).
    – Aurora0001
    Commented Jan 9, 2018 at 17:55
  • @Aurora0001 I tried installing MariaDB but when I go to uninstall mariadb-common it said MySQL has unmet dependencies. I’ve heard that raspbian stretch changed the database format. So I’m guessing that’s what’s caused the error. If I go to reinstall MySQL it said it wants to install mariadb with it. So I’m wondering how to install the old version which I think used innoDB
    – cobra12
    Commented Jan 9, 2018 at 18:37
  • How do you think I can do this?
    – cobra12
    Commented Jan 9, 2018 at 18:37

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.