The following changes are not yet populated to all servers: datalog_status_u_server: 6

Hi,
I have configured ISPConfig 3 DNS only(primary and secondary mirror setup) with CentOS 7.3
From last six month it is working perfectly.But now it showing datalog_status_u_server: 6 in ISPconfig webpanel.
So i enable debug mode on my secondary serever by following below mentioned thread,
https://www.howtoforge.com/community/threads/please-read-before-posting.58408/

Attached is the htf_report.txt file. Below is the output of server.sh script

21.04.2017-20:26 - DEBUG - Found 2089 changes, starting update process.

Its just showing this message from last one hour,nothing is happening.

Kindly help me to resolve this issue because of this issue my new DNS records are not getting updated in my secondary server.

 

This problem got resolved after running server.sh manually.
My crontab is running fine then also i restarted it. Also i restarted the server but the things are not running smoothly like before.
is there any databse size restriction in ISPconfig DNS ?
Cant understand why this issue coming again and again.
Every time running server.sh is not good enough. Want to solve this please help.
Kindly note i have recently done yum update on both the server.
i think after this the problem might have started.
kindly help me.

 

There is no really restriction in ispconfig. Did you check the sqlserver for too many open files error? https://blog.schaal-24.de/server/error-error-in-accept-too-many-open-files/?lang=en

 

HI,
Thanks for the replay.I observed logs of mariadb .I found below mentioned error,
Version: '5.5.52-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
170428 12:46:01 [ERROR] mysqld: Table './dbispconfig/dns_soa' is marked as crashed and should be repaired
170428 12:46:01 [Warning] Checking table: './dbispconfig/dns_soa'
170428 12:46:02 [ERROR] mysqld: Table './dbispconfig/dns_rr' is marked as crashed and should be repaired
170428 12:46:02 [Warning] Checking table: './dbispconfig/dns_rr'

This error i am receiving only on my secondary DNS server .
Kindly let me how i can repair it.Please note it is an live DNS server.

 

mysqloptimize --auto-repair dbispconfig -u root -p

 

Hi,
I run below mentioned command now there is no error in marridb logs

mysqlcheck -u root -p -A --auto-repair