Page 1 of 1

Catastrophic Vesta Failure after Apt-get update

Posted: Thu Jan 29, 2015 9:29 am
by 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 ?

Re: Catastrophic Vesta Failure after Apt-get update

Posted: Thu Jan 29, 2015 10:03 am
by cagatay
Image

DONT UPDATE MYSQL OR YOU VESTA WILL FAIL

I am running Debian 7 64 bit

Re: Catastrophic Vesta Failure after Apt-get update

Posted: Thu Jan 29, 2015 10:10 am
by mcsteevie
cagatay wrote:Image

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.

Re: Catastrophic Vesta Failure after Apt-get update

Posted: Thu Jan 29, 2015 10:14 am
by cagatay
This is what I am getting when trying to restart mysql

Image

Re: Catastrophic Vesta Failure after Apt-get update

Posted: Thu Jan 29, 2015 10:24 am
by 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.

Re: Catastrophic Vesta Failure after Apt-get update

Posted: Thu Jan 29, 2015 10:29 am
by cagatay
mcsteevie wrote: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)

Re: Catastrophic Vesta Failure after Apt-get update

Posted: Thu Jan 29, 2015 12:00 pm
by cagatay
mcsteevie wrote:
cagatay wrote:Image

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.

Re: Catastrophic Vesta Failure after Apt-get update

Posted: Thu Jan 29, 2015 12:17 pm
by mcsteevie
Glad it helped :-)