Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section General Discussion
  • Search

"restart" "'mysql'" failed after upgrade

General questions about VestaCP
Post Reply
  • Print view
Advanced search
14 posts
  • 1
  • 2
  • Next
kandalf
Posts: 87
Joined: Tue May 13, 2014 11:53 pm

"restart" "'mysql'" failed after upgrade
  • Quote

Post by kandalf » Tue Jun 09, 2015 3:35 pm

Hello first of all thank you for the new version.

Unfortonatly I have the same problem at least in 3 different servers (Centos 6.6) if I try to restart the mysql I allways get "restart" "'mysql'"

Any solution?

Update: Restart the server also failed, the other services seems ok
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: "restart" "'mysql'" failed after upgrade
  • Quote

Post by skurudo » Tue Jun 09, 2015 6:37 pm

Loot at mysql error log in /var/log and show us.
Top

kandalf
Posts: 87
Joined: Tue May 13, 2014 11:53 pm

Re: "restart" "'mysql'" failed after upgrade
  • Quote

Post by kandalf » Tue Jun 09, 2015 7:09 pm

skurudo wrote:Loot at mysql error log in /var/log and show us.
I look at mysql error and there are none. If I restart via ssh everything works I think that the problem is on the website. But the strange thing is this occur on all my servers
Top

kandalf
Posts: 87
Joined: Tue May 13, 2014 11:53 pm

Re: "restart" "'mysql'" failed after upgrade
  • Quote

Post by kandalf » Wed Jun 10, 2015 4:24 pm

New update:
If i ran the code

Code: Select all

v-restart-service mysqld
Via ssh with root login the service restart without problems but within the vesta panel it fail always.
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: "restart" "'mysql'" failed after upgrade
  • Quote

Post by skurudo » Wed Jun 10, 2015 7:57 pm

Try to restart service and then look at /usr/local/vesta/log/nginx-error.log
Top

kandalf
Posts: 87
Joined: Tue May 13, 2014 11:53 pm

Re: "restart" "'mysql'" failed after upgrade
  • Quote

Post by kandalf » Wed Jun 10, 2015 10:12 pm

skurudo wrote:Try to restart service and then look at /usr/local/vesta/log/nginx-error.log
Everytime refresh the "server" page I get an error:

Code: Select all

 [error] 3227#0: *596 FastCGI sent in stderr: "PHP message: PHP Notice:  Undefined variable: status in /usr/local/vesta/web/templates/admin/list_services.html on line 51" while reading upstream, client: 37.189.xx.xx, server: _, request: "GET /list/server/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/vesta-php.sock:", host: "xxxx.info:8083", referrer: "https://xxxx.info:8083/list/server/"
A simple refresh on "server" page return always this error.

I look and every logs that I remember and don't find anything. The strange thing is this occurs on all my servers
Top

Zuzlan
Posts: 5
Joined: Sun Aug 09, 2015 11:13 pm

Re: "restart" "'mysql'" failed after upgrade
  • Quote

Post by Zuzlan » Sun Aug 09, 2015 11:20 pm

Same problem
"restart" "'mysql'" failed

Today I received an email 'Vesta Control Panel"
Can't connect to localhost
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

https://myservip:8083/list/server/ - here I found that mysql is disabled and it's not restarted with an error "restart" "'mysql'" failed

Any ideas?
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: "restart" "'mysql'" failed after upgrade
  • Quote

Post by skurudo » Tue Aug 11, 2015 10:46 pm

Zuzlan wrote:Same problem
"restart" "'mysql'" failed
Why you think problem the same? Be more clear, tell us about your OS, VestaCP version?
Zuzlan wrote:Today I received an email 'Vesta Control Panel"
Can't connect to localhost
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
What's in mysql error log? /var/log/
Zuzlan wrote:https://myservip:8083/list/server/ - here I found that mysql is disabled and it's not restarted with an error "restart" "'mysql'" failed
When you restart mysql from console, you get error?
Zuzlan wrote:Any ideas?
too many for this late night show ;-)
need more data about your server
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: "restart" "'mysql'" failed after upgrade
  • Quote

Post by skurudo » Tue Aug 11, 2015 10:48 pm

kandalf wrote:

Code: Select all

 [error] 3227#0: *596 FastCGI sent in stderr: "PHP message: PHP Notice:  Undefined variable: status in /usr/local/vesta/web/templates/admin/list_services.html on line 51" while reading upstream, client: 37.189.xx.xx, server: _, request: "GET /list/server/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/vesta-php.sock:", host: "xxxx.info:8083", referrer: "https://xxxx.info:8083/list/server/"
Broken sudo ;-(
viewtopic.php?f=16&t=7063#p27116
Top

Zuzlan
Posts: 5
Joined: Sun Aug 09, 2015 11:13 pm

Re: "restart" "'mysql'" failed after upgrade
  • Quote

Post by Zuzlan » Wed Aug 12, 2015 12:28 am

Hello
Thank you for you reply, skurudo

You are right. It wasn't the same problem. Just similar simptom with "restart" "'mysql'" failed.

But about everything in order.
Operating system: Centos 6 x86
VestaCP version: was installed the latest version on 17 Feb 2015. And updated (after problem appeared) to 0.9.8 (i686)

In my case the problem was with mysql database server. It was down. I have tried to start it from Vesta Panel ( "restart" "'mysql'" failed ), also tried to start it by SSH. It was still down, so I looked at the log file.
There was records about "InnoDB: We intentionally generate a memory trap." and links to http://dev.mysql.com/doc/refman/5.5/en/ ... overy.html for some ways to fix this issue.
mysql service was falling each time right after start
Full log for that moment - http://www.zuzlan.name/hlam/mysqld.log-old.zip

Then we tried to change config: innodb_force_recovery = ['1'..'6']. It helped to start mysql, but still site not worked with an error - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Logs file was increased it's size extremely fast - http://www.zuzlan.name/hlam/mysqld.log-old2.zip
From this time I could successfully restore DB from backups, but the problem isn't gone anywhere

We had no idea what to do with this, so decision was reinstall "mysql" manually (dont know how to do it with Vesta Panel).It wasn't help, so we decided to delete all DB files with Midnight Commander (it was impossible to delete bases with Panel). After files delete - everything is fine. Then we resore DB from backup again. At this time problem was gone.

Still have no idea how fix it simply in case the problem appears again
Top


Post Reply
  • Print view

14 posts
  • 1
  • 2
  • Next

Return to “General Discussion”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password