We have a cluster of 3. 2 telephony and 1 WEB & DB. All dedicated, scratched installed on Alma.
VERSION: 2.14-859a
BUILD: 220623-0824
Version: 2.14b0.5
SVN Version: 3611
DB Schema Version: 1662
The problem is that a the start of the shift everything works fine. But lets say after 2 hours into production, real times stats start to deviate from the numbers in the reports.
Stage 1:
In the real time report, the dropped calls would be 70 but when we fetch data from Inbound/Outbound Reports dropped calls will be 100
Stage 2:
After 2 hours, in real-time report the number of dropped calls will fall from 70 to 50. And in the IB/OB report the number of dropped calls will be 120.
Stage 3:
After another hour or so, in real time report the stats will jump back to there actual number.
Stage 4:
The numbers will keep jumping up and down during the whole shift.
Stage 5:
At the end of shift, numbers in real time report will match the numbers in IB/OB report. 150 number of dropped calls in real-time report and 150 in IB/OB Report.
There are screens on DB+WEB:
3382247.ASTconf3way (Detached)
3382244.ASTVDadapt (Detached)
3189096.ASTVDremote (Detached)
3086943.ASTemail (Detached)
4198.ASTVDadFILL (Detached)
2866.ASTfastlog (Detached)
2853.ASTVDauto (Detached)
2836.ASTlisten (Detached)
2830.ASTsend (Detached)
2826.ASTupdate (Detached)
2602.asterisk (Detached)
2594.astshell20220823175652 (Detached)
12 Sockets in /run/screen/S-root.
Step Taken:
1) Optimized and repair MYSQL. Didnt find any crashed tables every time.
2) Load on the servers is just fine.
Any suggestions what else to look into?
Thank you.