In some legacy instances we have seen zone record-view linkages come out of alignment and result in unexpected behavior. | Note |
|---|
| title | BACKUP YOUR DATABASE |
|---|
| Please note that the following mysql commands modify your database! Please take a backup copy of your database before performance any database modifications. |
First, verify the error with the following mysql commands: | Code Block |
|---|
| SELECT count(*) FROM `zone_server_linkage` as t1
INNER JOIN `records` as t2 ON t1.`zoneid` = t2.`zone_id`
INNER JOIN `dns_views` as t3 ON t1.`serverid` = t3.`server_id` AND
`name` = '_6connectDefault'
LEFT JOIN `dns_view_record_linkage` as t4 ON t2.`id` = t4.`record_id`
AND t3.`id` = t4.`view_id`
WHERE t4.`id` IS NULL; |
If the reply comes back non-zero, then your database is most likely exhibiting unexpected behavior. The following mysql commands will re-align all the record-view linkages: | Code Block |
|---|
| INSERT INTO `dns_view_record_linkage` SELECT '', t2.`id` as `record_id`,
t3.`id` as `view_id` FROM `zone_server_linkage` as t1
INNER JOIN `records` as t2 ON t1.`zoneid` = t2.`zone_id`
INNER JOIN `dns_views` as t3 ON t1.`serverid` = t3.`server_id` AND
`name` = '_6connectDefault'
LEFT JOIN `dns_view_record_linkage` as t4 ON t2.`id` = t4.`record_id`
AND t3.`id` = t4.`view_id`
WHERE t4.`id` IS NULL; |
Contact support(support@6connect.com) if you have any additional questions or this does not resolve the issue. | 