Catastrophic Vesta Failure after Apt-get update

[cagatay]

Hello,

Yesterday I did a apt-get update / upgrade.

It updated mysql package and now I noticed all my wordpress websites (I host wordpress only) are returning default installation screen.

Anyone experienced the same ?

[cagatay]

DONT UPDATE MYSQL OR YOU VESTA WILL FAIL

I am running Debian 7 64 bit

[mcsteevie]

DONT UPDATE MYSQL OR YOU VESTA WILL FAIL

Error 24 and "can't open file" usually mean that there are too many files open (the open file limit may be set too low). Have you tried adding the following to /etc/my.cnf:

Code: Select all

[mysqld]

open_files_limit = 100000

Make sure you restart mysql after the change.

[cagatay]

This is what I am getting when trying to restart mysql

[mcsteevie]

Can you check the open file limit?

Code: Select all

sudo -u mysql bash

ulimit -a

Should give you a load of readouts. Please look for the line that starts with "open files" and post here.

[cagatay]

Can you check the open file limit?

Code: Select all

sudo -u mysql bash

ulimit -a

Should give you a load of readouts. Please look for the line that starts with "open files" and post here.

I posted the last message before I read your message, please hold now I am dealing with apache. Your solution stopped mysql errors, but because I am on a new server I have to figure out a way starting apache (ip address change)

[cagatay]

DONT UPDATE MYSQL OR YOU VESTA WILL FAIL

Error 24 and "can't open file" usually mean that there are too many files open (the open file limit may be set too low). Have you tried adding the following to /etc/my.cnf:

Code: Select all

[mysqld]

open_files_limit = 100000

Make sure you restart mysql after the change.

Thank you very much, it solved the problem.

[mcsteevie]

Glad it helped :-)