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

Discussion in 'Installation/Configuration' started by harshu294, Apr 21, 2017.

  1. harshu294

    harshu294 Member

    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.
     

    Attached Files:

  2. harshu294

    harshu294 Member

    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.
     
    Last edited: Apr 27, 2017 at 2:03 PM
  3. florian030

    florian030 ISPConfig Developer ISPConfig Developer

  4. harshu294

    harshu294 Member

    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.
     
    Last edited: Apr 28, 2017 at 10:53 AM
  5. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    mysqloptimize --auto-repair dbispconfig -u root -p
     
  6. harshu294

    harshu294 Member

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

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

Share This Page