{"action":"created","issue":{"url":"https://api.github.com/repos/PowerDNS/pdns/issues/3828","repository_url":"https://api.github.com/repos/PowerDNS/pdns","labels_url":"https://api.github.com/repos/PowerDNS/pdns/issues/3828/labels{/name}","comments_url":"https://api.github.com/repos/PowerDNS/pdns/issues/3828/comments","events_url":"https://api.github.com/repos/PowerDNS/pdns/issues/3828/events","html_url":"https://github.com/PowerDNS/pdns/issues/3828","id":153492492,"number":3828,"title":"PowerDNS gives wrong Serial from SOA record","user":{"login":"prismanet","id":2393553,"avatar_url":"https://avatars.githubusercontent.com/u/2393553?v=3","gravatar_id":"","url":"https://api.github.com/users/prismanet","html_url":"https://github.com/prismanet","followers_url":"https://api.github.com/users/prismanet/followers","following_url":"https://api.github.com/users/prismanet/following{/other_user}","gists_url":"https://api.github.com/users/prismanet/gists{/gist_id}","starred_url":"https://api.github.com/users/prismanet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/prismanet/subscriptions","organizations_url":"https://api.github.com/users/prismanet/orgs","repos_url":"https://api.github.com/users/prismanet/repos","events_url":"https://api.github.com/users/prismanet/events{/privacy}","received_events_url":"https://api.github.com/users/prismanet/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-06T16:50:05Z","updated_at":"2016-05-06T20:48:17Z","closed_at":null,"body":"Hi,\r\n\r\nWe're currently running PowerDNS Authoritative 3.4.8 on master and slaves. PowerDNS Recursor 3.7.3 is also running on all hosts. Backend is SQLite. We have about 100 domains. Running CentOS 6.7 and PowerDNS RPMs were used for install.\r\n\r\nThe issue we're facing is that when we query the SOA record from a domain the servers are authoritative for, the serial is increased by 2 from its value in the database. For example, a domain for which its SOA record has a serial of \"2016050401\" in the database. PowerDNS will answer \"2016050403\" to all requests. \r\n\r\nThe biggest issue this cause is that slaves will have a different Serial than Masters which will cause some consistency issues because Slaves update their SOA with the serial received from the master when queried which adds 2. \r\n\r\nDoes anybody else have the same issue?\r\n\r\nThanks!\r\nSylvain"},"comment":{"url":"https://api.github.com/repos/PowerDNS/pdns/issues/comments/217554781","html_url":"https://github.com/PowerDNS/pdns/issues/3828#issuecomment-217554781","issue_url":"https://api.github.com/repos/PowerDNS/pdns/issues/3828","id":217554781,"user":{"login":"Habbie","id":525838,"avatar_url":"https://avatars.githubusercontent.com/u/525838?v=3","gravatar_id":"","url":"https://api.github.com/users/Habbie","html_url":"https://github.com/Habbie","followers_url":"https://api.github.com/users/Habbie/followers","following_url":"https://api.github.com/users/Habbie/following{/other_user}","gists_url":"https://api.github.com/users/Habbie/gists{/gist_id}","starred_url":"https://api.github.com/users/Habbie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Habbie/subscriptions","organizations_url":"https://api.github.com/users/Habbie/orgs","repos_url":"https://api.github.com/users/Habbie/repos","events_url":"https://api.github.com/users/Habbie/events{/privacy}","received_events_url":"https://api.github.com/users/Habbie/received_events","type":"User","site_admin":false},"created_at":"2016-05-06T20:48:17Z","updated_at":"2016-05-06T20:48:17Z","body":"(1) `grep -r soa-edit /etc/powerdns`\r\n(2) `SELECT * FROM domainmetadata WHERE kind LIKE 'SOA%';\r\n\r\nplease :)"}}