DROPPED / ANSWERED calls are not showing in realtime page

[PJ111288]

Hi Saviours,

I have running server which is working fine in production but since yesterday i found that "DROPPED / ANSWERED calls are not showing in realtime page". I have mysql logs and no error in it so run this /usr/share/astguiclient/AST_update.pl --debugX and got this and i have to break this otherwise its going on like loop.

[root@dialer mysql]# /usr/share/astguiclient/AST_update.pl --debugX

----- SUPER-DUPER DEBUGGING -----
BUILD: 140510-0119
2020-07-27 2:44:41|PROGRAM STARTED|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2020-07-27 2:44:41|LOGGED INTO MYSQL SERVER ON 1 CONNECTION||
SHOW CHANNELS format: 4

|1|SELECT count(*) FROM server_updater where server_ip='192.168.2.55';|
LOOKING FOR Zap/DAHDI clients assigned to this server:
|SELECT extension FROM phones where protocol='Zap' and server_ip='192.168.2.55'|
LOOKING FOR IAX2 clients assigned to this server:
|SELECT extension FROM phones where protocol='IAX2' and server_ip='192.168.2.55'|
LOOKING FOR SIP clients assigned to this server:
|SELECT extension FROM phones where protocol='SIP' and server_ip='192.168.2.55'|
121025
121021
121022
121024
121023
121011
121002
121003
121004
121005
121006
121007
121008
121009
121010
121088
121095
121013
121014
121015
121016
121017
121018
121077
121020
121058
121029
121057
121055
121091
121053
121052
121051
121050
121049
121099
121056
121047
121046
121045
121044
121043
121040
121062
121042
121038
121037
121036
121035
121084
121034
121033
121032
121026
121031
121027
121028
121081
121030
121061
121048
121063
121064
121065
121066
121090
121054
121068
121071
32115
121059
121019
121082
121074
121039
121100
121072
121078
121079
121085
121075
121083
121076
121060
121086
121087
121069
121092
121089
121001
121080
121093
121094
121067
121096
121097
121098
121073
121070
121101
4333
121012
121041
Zap Clients: |
IAX2 Clients: |
SIP Clients: |121025|121025@121025|121021|121021@121021|121022|121022@121022|121024|121024@121024|121023|121023@121023|121011|121011@121011|121002|121002@121002|121003|121003@121003|121004|121004@121004|121005|121005@121005|121006|121006@121006|121007|121007@121007|121008|121008@121008|121009|121009@121009|121010|121010@121010|121088|121088@121088|121095|121095@121095|121013|121013@121013|121014|121014@121014|121015|121015@121015|121016|121016@121016|121017|121017@121017|121018|121018@121018|121077|121077@121077|121020|121020@121020|121058|121058@121058|121029|121029@121029|121057|121057@121057|121055|121055@121055|121091|121091@121091|121053|121053@121053|121052|121052@121052|121051|121051@121051|121050|121050@121050|121049|121049@121049|121099|121099@121099|121056|121056@121056|121047|121047@121047|121046|121046@121046|121045|121045@121045|121044|121044@121044|121043|121043@121043|121040|121040@121040|121062|121062@121062|121042|121042@121042|121038|121038@121038|121037|121037@121037|121036|121036@121036|121035|121035@121035|121084|121084@121084|121034|121034@121034|121033|121033@121033|121032|121032@121032|121026|121026@121026|121031|121031@121031|121027|121027@121027|121028|121028@121028|121081|121081@121081|121030|121030@121030|121061|121061@121061|121048|121048@121048|121063|121063@121063|121064|121064@121064|121065|121065@121065|121066|121066@121066|121090|121090@121090|121054|121054@121054|121068|121068@121068|121071|121071@121071|32115|32115@32115|121059|121059@121059|121019|121019@121019|121082|121082@121082|121074|121074@121074|121039|121039@121039|121100|121100@121100|121072|121072@121072|121078|121078@121078|121079|121079@121079|121085|121085@121085|121075|121075@121075|121083|121083@121083|121076|121076@121076|121060|121060@121060|121086|121086@121086|121087|121087@121087|121069|121069@121069|121092|121092@121092|121089|121089@121089|121001|121001@121001|121080|121080@121080|121093|121093@121093|121094|121094@121094|121067|121067@121067|121096|121096@121096|121097|121097@121097|121098|121098@121098|121073|121073@121073|121070|121070@121070|121101|121101@121101|4333|4333@4333|121012|121012@121012|121041|121041@121041|
2020-07-27 2:44:41|STARTING NEW MANAGER TELNET CONNECTION||ATTEMPT|ONE DAY INTERVAL:12||
2020-07-27 2:44:41|STARTING NEW MANAGER TELNET CONNECTION|updatecron|CONFIRMED CONNECTION|ONE DAY INTERVAL:12||

|SELECT channel,extension FROM live_channels where server_ip = '192.168.2.55'|

|UPDATE server_updater set last_update='2020-07-27 2:44:41' where server_ip='192.168.2.55'|
0|Response: Follows
1|Privilege: Command

|UPDATE servers SET sysload='032',channels_total='0',cpu_idle_percent='98',disk_usage='1 59|2 1|3 40|' where server_ip='192.168.2.55';|
concise: -1 loop: 5769999
2020-07-27 2:44:41|NO CHANNELS HERE|COUNTER: 1|5769999|ONE DAY INTERVAL:12|Privilege: Command|
*|EMPTY CHANNELS: 1|1|Privilege: Command

|SELECT channel,extension FROM live_channels where server_ip = '192.168.2.55'|

|UPDATE server_updater set last_update='2020-07-27 2:44:42' where server_ip='192.168.2.55'|
0|Response: Follows
1|Privilege: Command
concise: -1 loop: 5769998
2020-07-27 2:44:42|NO CHANNELS HERE|COUNTER: 2|5769998|ONE DAY INTERVAL:12|Privilege: Command|
*|EMPTY CHANNELS: 2|1|Privilege: Command

|SELECT channel,extension FROM live_channels where server_ip = '192.168.2.55'|

|UPDATE server_updater set last_update='2020-07-27 2:44:42' where server_ip='192.168.2.55'|
0|Response: Follows
1|Privilege: Command
concise: -1 loop: 5769997
2020-07-27 2:44:42|NO CHANNELS HERE|COUNTER: 3|5769997|ONE DAY INTERVAL:12|Privilege: Command|
*|EMPTY CHANNELS: 3|1|Privilege: Command
2020-07-27 2:44:42|NO CHANNELS HERE|COUNTER: 3|5769996|ONE DAY INTERVAL:12|Privilege: Command|

|DELETE FROM live_sip_channels where server_ip='192.168.2.55'|

|DELETE FROM live_channels where server_ip='192.168.2.55'|

|SELECT channel,extension FROM live_channels where server_ip = '192.168.2.55'|

|UPDATE server_updater set last_update='2020-07-27 2:44:43' where server_ip='192.168.2.55'|
0|Response: Follows
1|Privilege: Command
concise: -1 loop: 5769996
2020-07-27 2:44:43|NO CHANNELS HERE|COUNTER: 4|5769996|ONE DAY INTERVAL:12|Privilege: Command|
*|EMPTY CHANNELS: 4|1|Privilege: Command

|SELECT channel,extension FROM live_channels where server_ip = '192.168.2.55'|

|UPDATE server_updater set last_update='2020-07-27 2:44:43' where server_ip='192.168.2.55'|
0|Response: Follows
1|Privilege: Command
concise: -1 loop: 5769995
2020-07-27 2:44:43|NO CHANNELS HERE|COUNTER: 5|5769995|ONE DAY INTERVAL:12|Privilege: Command|
*|EMPTY CHANNELS: 5|1|Privilege: Command

Please help on this i have no idea what is going because server has all screens.

[root@dialer mysql]# screen -ls
There are screens on:
31538.ASTVDadapt (Detached)
31530.ASTVDauto (Detached)
31535.ASTVDremote (Detached)
31521.ASTupdate (Detached)
31524.ASTsend (Detached)
2837.asterisk (Detached)
2830.astshell20200726235745 (Detached)
3089.ASTfastlog (Detached)
31541.ASTconf3way (Detached)
31527.ASTlisten (Detached)
10 Sockets in /var/run/screen/S-root.

======================================
Asterisk 1.8
Centos 6.10
DB 1379
SVN 2.9
=======================================
I know i have very OLD configuration so please bear with me.

Many Thanks.

[PJ111288]

Can any one advise on this! Now i have other with same server and getting same output when run this /usr/share/astguiclient/AST_update.pl --debugX.

Now problem is as i try to answer ringback so its hangup.
.

[PJ111288]

Can any one advise on this! Now i have other with same server and getting same output when run this /usr/share/astguiclient/AST_update.pl --debugX.

Now problem is as i try to answer ringback so its hangup.
.

Thanks guys. i am able to fix the issue. Thanks for your best wishes because of that i m able to do this.

[carpenox]

how did u fix it in case someone else has the problem?

[PJ111288]

sorry for the very late reply...there was some configuration issue.