High Availability Issue

[Srinivasa Rao]

Hi Everyone,

Need Help,

Following are my server details

1. Asterisk 1.4.42
2. vicidial 2.2.1
3. Redfone
4. RedHat
5. Soft Phone Zoiper

We are using the vicidial application for the past four years, it is very nice. For one of our client two years back we have implemented high availability for the vicidial application without mysql clustering. till last three months it was working fine. But recently we have implemented NDB cluster for mysql clustering. Currently we are facing an issue i.e. server hanging.

We are unable to identify the root cause for server hangup. For every week or less than of week of time our hardware server is getting hanged.

At the time of server hangup, we are able to see huge amount of log is generating at /var/spool/clientmqueue.
In this log, the files contains the below error message.

DBD::mysql::st execute failed: Got error 157 'Unknown error code' from NDBCLUSTER at /usr/share/astguiclient/AST_VDhopper.pl line 269.
executing: SELECT vd_server_logs,local_gmt FROM servers where server_ip = '10.1.2.110'; Got error 157 'Unknown error code' from NDBCLUSTER at /usr/share/astguiclient/AST_VDhopper.pl line 269

We are suspecting, it is because of cron job schedulers are unable to find the active database, so these scheduler files are generating the log continuously at above mentioned path.

But our NDB cluster team is not accepting any fault at their end.

Before implementation of NDB cluster our application was running fine without any issue.

Please help me to sort out this problem.

Dear williamconley/striker,

I personally request you to help me on above mentioned issue.