Problem with cluster time -Time synchronization-

[achillf]

Hallo, i have a problem with time in cluster servers. In server report server's times change with 1 minute refresh and not every second. Php,db,blade1 and blade 2 time are ok. But blade 3,blade 5 and server(10.130.0.20) refreshing every 1 minute. What can i do. And whats going wrong? Sorry i dont know how to give you asterisk version and other version reports of installation. I dont know how to get this infos.If you need these information can you telling me how to take these infos and after i ll give you. But i believe that this problem is so simple but because im newbie.

That's i only know:
VERSION: 2.6-380a
BUILD: 121029-0109

[mflorell]

You need to set up ntpd on all of your servers and point to a single time source.

[achillf]

You need to set up ntpd on all of your servers and point to a single time source.

hi mflorell thank for your answer. How can i do that? Also problem is that times didnt stack. Every 1 minute sychronize each other,then stop again.Seconds didnt change at all. If i type date inside linux the time works fine

For example if DB Time goes to '2017-07-21 12:12:03' and keep going then the time of 10.130.0.20 server goes to '2017-07-21 12:12:03' and stack for the next minute.

What if tables crash happens?

[achillf]

mflorell i see this topic: viewtopic.php?f=4&t=36648 with same problem and you reply alo this:

Re: Vicibox 7.0.3 Time Sync stuck at the top of the minute
Postby mflorell » Wed Dec 21, 2016 4:12 pm

Try running "/usr/share/astguiclient/AST_update.pl --debugX" manually and see if it gives you an error.

I was running this command /usr/share/astguiclient/AST_update.pl --debugX inside putty and the result is the picture below:

[mflorell]

Are any of these on virtual machines?

Search for instructions on how to configure ntpd, it can be different depending on the linux version and distro you are using.

You should run table checks on all of your MySQL tables to ensure none of them are crashed.

[achillf]

There is no server in virtual machine, mflorell i know only a few things about vicidial-asterisk-linux, can you give me some commands to run for repair ? or to find the problem? or something else to run and can be fixed.

[mflorell]

It looks like there are probably multiple issues with your system, and sending you a few commands isn't going to fix them.

You should probably get a person skilled in Linux to help you first, to make sure your system is stable and there are no hardware issues, then you can worry about VICIdial.

[hiteshg]

As per the logs you have shown it seems that server_performance table is crashed. You need to repair the same in your Database