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?
To skip them, increase the value in the "updated" column in the table "server". updated contains the last processes datalog_id value.
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.)?