Script Timmings

[saqibali]

Dialer stops dialing on every day at 1 am. Also when try to access the Database it seems that it has been locked. Looking into the AST_DB_optimize.pl script it locks some tables during the script execution but after changing the timming of that script too, does'nt make any difference.

when this happens the DB percentage goes way high upto 70%.
Astguiclient version 2.0.2
Timezone sets on server as AMERICA/NEWYORK.

cron entries are

### keepalive script for astguiclient processes
* * * * * /usr/share/astguiclient/ADMIN_keepalive_ALL.pl

### kill Hangup script for Asterisk updaters
* * * * * /usr/share/astguiclient/AST_manager_kill_hung_congested.pl

### updater for voicemail
* * * * * /usr/share/astguiclient/AST_vm_update.pl

### updater for conference validator
* * * * * /usr/share/astguiclient/AST_conf_update.pl

### flush queue DB table every hour for entries older than 1 hour
11 * * * * /usr/share/astguiclient/AST_flush_DBqueue.pl -q

### fix the vicidial_agent_log once every hour
33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl

### updater for VICIDIAL hopper
* * * * * /usr/share/astguiclient/AST_VDhopper.pl -q

### adjust the GMT offset for the leads in the vicidial_list table
1 7 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug --postal-code-gmt

### reset several temporary-info tables in the database
2 7 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl

### optimize the database tables within the asterisk database
3 7 * * * /usr/share/astguiclient/AST_DB_optimize.pl

### adjust time on the server with ntp
30 * * * * /usr/sbin/ntpdate -u 18.145.0.30 2>/dev/null 1>&2


### VICIDIAL agent time log weekly summary report generation
2 0 * * 0 /usr/share/astguiclient/AST_agent_week.pl

i dun know whether its due to the scripts. as i also tried by excluding the AST_DB_optimize script from cron job but dialer stops dialing at 1 am.

[mflorell]

try to use the 'top' script to see what is running, or the 'mtop' script when the dialing stops.

Also, I would strongly suggest upgrading to at least 2.0.4.1rc2 or higher.