Soft reboot vicibox

[vkad]

Is there a way or a script to reboot a hung vicidial without rebooting the cluster.

We have had an incidence twice in the past week. The realtime screen shows that calls are being placed, but there is no activity on the asterisk interface.

After rebooting everything is resolved. The strange thing is that these servers have less than 20% load when this happens.

Any insights why this might be happening. I haven't found any error messages in the logs. Simply restarting asterisk doesn't fix the problem.

[mflorell]

If you have a cluster, you should not have to reboot the DB server frequently at all. In fact we have some clients that go years without rebooting their DB or web servers. The Asterisk servers on the other hand usually need to be rebooted daily. As for being "hung", that could be caused by any number of issues, almost always related to Asterisk.

[vkad]

I didn't know asterisk servers need to be rebooted daily. Ours usually go without rebooting for weeks.

DB is fine. Web is fine. Its just that realtime shows calls are being dialled, but carrier stats show no calls being placed (also asterisk shows no dialling).

[mflorell]

Depending on your call volume, you can go for a while without rebooting Asterisk servers, but at higher call volumes, it's just a matter of time before Asterisk freezes or crashes, which is why we usually recommend daily reboots.

[vkad]

100k-200k calls per day ?

I don't know if that is high call volume?

Sometimes we are getting this issue twice in a day. Sometimes we go days without it now.

[mflorell]

I would recommend daily Asterisk server reboots for that kind of system.

[vkad]

I would recommend daily Asterisk server reboots for that kind of system.

I don't understand why this is happening, but we are doing daily reboots of asterisk server, yet, we get in a situation when autodialing where Realtime screen shows 200 calls are being placed, carrier shows no calls being placed, there is no activity on asterisk....There is no debug information anywhere....

I don't know what to do as this exact system was working fine before. Today we have had to reboot the servers in shift three times.

How can real time screen show calls being dialled (yet, nothing on carrier stats and asterisk)?

[mflorell]

There are many reasons that can happen. It's sometimes hard to tell which one it is without looking at everything that is running on the servers, and the database records.

[vkad]

There are many reasons that can happen. It's sometimes hard to tell which one it is without looking at everything that is running on the servers, and the database records.

And it is fixed after a reboot....

What are the main reasons?

[vkad]

it was a vicidial_manger getting full (was using a memory table)

[Invictus]

it was a vicidial_manger getting full (was using a memory table)

in mysql config, increase tmp_table_size and max_heap_table_size.

first in mysql cli check values;

Code: Select all

select @@global.tmp_table_size;
select @@global.max_heap_table_size;

then increase values

Code: Select all

SET GLOBAL tmp_table_size=NEW_VALUE;
SET GLOBAL max_heap_table_size=NEW_VALUE;

in /etc/my.cnf file, add under [mysqld] section

Code: Select all

tmp_table_size=NEW_VALUE
max_heap_table_size=NEW_VALUE

[thephaseusa]

That issue recently happened to me. The problem was I was dialing more numbers than my 1 asterisk server could process. I was getting up over 100 concurrent calls. They say you need 1 asterisk server for every 100 concurrent calls, so look at your numbers and see if this could be your issue.

[vkad]

The issue was resolved when I changed it to MyISAM

[mflorell]

Thanks for posting a followup!

I know I've stated this many times here on the forums, but just for redundancy's sake, when thinking about database engines for use with VICIdial:

InnoDB = BAD

MyISAM = GOOD!!!