Softaculous


Topic : one of slave server is offline all the time


Posted By: seandex on April 26, 2017, 2:14 am
one of my slave server is offline status and won't come back forever
how can i re-attach this? it seems like master can't read slave server information
other slaves are fine.
please help.

Posted By: jevingala on April 26, 2017, 5:56 am | Post: 1
Hi,

Are you able to open Slave Virtualizor panel ?


-----------------------
Regards,
Virtualizor Team.
http://virtualizor.com/

Posted By: seandex on April 26, 2017, 6:16 am | Post: 2
Quote From : jevingala April 26, 2017, 5:56 am
Hi,

Are you able to open Slave Virtualizor panel ?


good point, i get following error on slave website:4084

SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/usr/local/emps/var/mysql/mysql.sock' (2)


service status

ERROR! MySQL is not running, but lock file (/usr/local/emps/var/lock/mysql) exists


how can I fix this?

thanks.


Posted By: jevingala on April 26, 2017, 6:49 am | Post: 3
Hi,

Make sure you have free space on '/' partition .
After making free space you can start virtualizor service and check logs in /usr/local/emp/var/log/mysqld.log for any error.


-----------------------
Regards,
Virtualizor Team.
http://virtualizor.com/

Posted By: seandex on April 26, 2017, 7:08 am | Post: 4
Quote From : jevingala April 26, 2017, 6:49 am
Hi,

Make sure you have free space on '/' partition .
After making free space you can start virtualizor service and check logs in /usr/local/emp/var/log/mysqld.log for any error.


do you have tip to free up disk space without upgrading hdd disk?
vzctl delete/destroy doesn't help.
what else i can do?

thanks.

Posted By: jevingala on April 26, 2017, 7:17 am | Post: 5
Hi,

You need to check what is eating up space using ' du -sh /* ' and then delete the un-wanted files as per your need .


Edited by jevingala : April 26, 2017, 7:17 am

-----------------------
Regards,
Virtualizor Team.
http://virtualizor.com/

Posted By: seandex on April 26, 2017, 8:00 am | Post: 6
Quote From : jevingala April 26, 2017, 7:17 am
Hi,

You need to check what is eating up space using ' du -sh /* ' and then delete the un-wanted files as per your need .


have you done this before? what directory is good target for this situation?
this is just clean centos with virtualizor on it. just went too far from making many vps.

Thanks.

Posted By: jevingala on April 26, 2017, 8:54 am | Post: 7
Hi,

Can you please open a support ticket with the server access details so that we can check and help you out :

https://www.softaculous.com/support/open.php


-----------------------
Regards,
Virtualizor Team.
http://virtualizor.com/

Posted By: seandex on April 26, 2017, 9:01 am | Post: 8
Quote From : jevingala April 26, 2017, 8:54 am
Hi,

Can you please open a support ticket with the server access details so that we can check and help you out :

https://www.softaculous.com/support/open.php


I deleted some vps manually already,
now how can I restart the mysql?

Thanks.

Posted By: seandex on April 26, 2017, 11:32 am | Post: 9
Quote From : jevingala April 26, 2017, 8:54 am
Hi,

Can you please open a support ticket with the server access details so that we can check and help you out :

https://www.softaculous.com/support/open.php


i have got it working fine now.

Thanks.

Posted By: chirag on April 28, 2017, 10:18 am | Post: 10
Hi,

Sir let us know if you face any issues.
We will be happy to help you.

-----------------------
Virtualizor - VPS Control Panel
Follow us on Facebook

Posted By: srv24x7 on April 29, 2017, 7:53 am | Post: 11
I assume after deleting the vps the server got some free disk space and that happened to fix the mysql problem.

-----------------------
Server Management, Server Security, Server Monitoring.
www.24x7servermanagement.com

Posted By: chirag on April 29, 2017, 8:05 am | Post: 12
Hi,

Ok Sir. Glad to know your issue is resolved.

Please let us know if you still face any issues.
We will be happy to help you.

-----------------------
Virtualizor - VPS Control Panel
Follow us on Facebook

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.