Error when importing DNS zone files

Discussion in 'General' started by SilkBC, Sep 25, 2025 at 1:08 AM.

Tags:
  1. SilkBC

    SilkBC Member

    Hello,

    I am running a multi-server setup.

    I am importing some DNS zone files into my DNS and running into an issue where I have 33 updates stuck. When I look at the 'ispconfig.log' file on my primary DNS server, I see the following:

    24.09.2025-23:04 - ERROR - Replication of datalog_id: 1853 failed. Error: (dns_soa) in MySQL server: (localhost) Column 'sys_userid' cannot be null # SQL: REPLACE INTO ?? (??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
    24.09.2025-23:04 - ERROR - Error in Replication, changes were not processed.​

    When I look at the 'dns_soa" table on my primary name server, all entries have a value in the 'sys_userid' column. I also had a look at datalog_id 1853 in the sys_datalog table on the control panel server and can see the DNS zone file it is having trouble with, but I am not sure what to look at or update to resolve. Can I just delete that datalog_id record from the sys_datalog table? I am guessing not, but figured I would check :) If unable to delete it (or otherwise preferred not to), is there something I can do to have it skipped?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    To skip them, increase the value in the "updated" column in the table "server". updated contains the last processes datalog_id value.
     
  3. SilkBC

    SilkBC Member

    OK, so looking at that "server" table on my control panel server, my two DNS servers have a value of "1852" in the "updated" column. Would I update this value for both of them to "1853" in this case, so it then thinks that update was processed and then (hopefully) processes the remaining updates (1854, 1855, etc.)?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

Share This Page