[GH-ISSUE #85] Can't delete domain(zone) #46

New issue

Closed

opened 2026-02-28 01:20:44 +03:00 by kerem · 1 comment

kerem commented

2026-02-28 01:20:44 +03:00

Owner

Originally created by @izenk on GitHub (Apr 1, 2016).
Original GitHub issue: https://github.com/tuxis-ie/nsedit/issues/85

Hello.

nsedit commit 794fcb680c
mysql Server version: 5.5.44
pdns-static_3.4.8
Ubuntu 14.04.3 LTS

From web interface I can't delete domain/zone
I can delete record, but not domain.

Please find logs:

PowerDNS:

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR 1

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: select id,name,master,last_check,notified_serial,type,account from domains where name='artemit.local'

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type='SOA' and name='artemit.local'

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: select id,name,master,last_check,notified_serial,type,account from domains where name='artemit.local'

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type='SOA' and name='artemit.local'

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: delete from records where domain_id=57

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: delete from domainmetadata where domain_id=(select id from domains where name='artemit.local')

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: delete from cryptokeys where domain_id=(select id from domains where name='artemit.local')

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: DELETE FROM comments WHERE domain_id=57

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: delete from domains where name='artemit.local'

Apr  1 12:33:07 ab-dns1 pdns[10008]: Query: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR 1

MySQL:

1628 Connect    pdns@localhost on pdns

1628 Query  SET autocommit=0

1628 Query  SET SESSION tx_isolation='READ-COMMITTED'

1628 Query  select id,name,master,last_check,notified_serial,type,account from domains where name='artemit.local'

1628 Query  SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type='SOA' and name='artemit.local'

1628 Query  select id,name,master,last_check,notified_serial,type,account from domains where name='artemit.local'

1628 Query  SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type='SOA' and name='artemit.local'

1628 Query  delete from records where domain_id=57

1628 Query  delete from domainmetadata where domain_id=(select id from domains where name='artemit.local')

1628 Query  delete from cryptokeys where domain_id=(select id from domains where name='artemit.local')

1628 Query  DELETE FROM comments WHERE domain_id=57

1628 Query  delete from domains where name='artemit.local'

1628 Quit

What I see, that nsedit didn't send "commit" command. And due to mysql server has setting autocommit= off, domain was not deleted.

If I set autocommit=on, everything is fine.

Originally created by @izenk on GitHub (Apr 1, 2016). Original GitHub issue: https://github.com/tuxis-ie/nsedit/issues/85 Hello. nsedit commit 794fcb680c35546b24d12511997da5db79688784 mysql Server version: 5.5.44 pdns-static_3.4.8 Ubuntu 14.04.3 LTS From web interface I can't delete domain/zone I can delete record, but not domain. Please find logs: PowerDNS: ``` Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR 1 Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: select id,name,master,last_check,notified_serial,type,account from domains where name='artemit.local' Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type='SOA' and name='artemit.local' Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: select id,name,master,last_check,notified_serial,type,account from domains where name='artemit.local' Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type='SOA' and name='artemit.local' Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: delete from records where domain_id=57 Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: delete from domainmetadata where domain_id=(select id from domains where name='artemit.local') Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: delete from cryptokeys where domain_id=(select id from domains where name='artemit.local') Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: DELETE FROM comments WHERE domain_id=57 Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: delete from domains where name='artemit.local' Apr 1 12:33:07 ab-dns1 pdns[10008]: Query: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR 1 ``` MySQL: ``` 1628 Connect pdns@localhost on pdns 1628 Query SET autocommit=0 1628 Query SET SESSION tx_isolation='READ-COMMITTED' 1628 Query select id,name,master,last_check,notified_serial,type,account from domains where name='artemit.local' 1628 Query SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type='SOA' and name='artemit.local' 1628 Query select id,name,master,last_check,notified_serial,type,account from domains where name='artemit.local' 1628 Query SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type='SOA' and name='artemit.local' 1628 Query delete from records where domain_id=57 1628 Query delete from domainmetadata where domain_id=(select id from domains where name='artemit.local') 1628 Query delete from cryptokeys where domain_id=(select id from domains where name='artemit.local') 1628 Query DELETE FROM comments WHERE domain_id=57 1628 Query delete from domains where name='artemit.local' 1628 Quit ``` What I see, that nsedit didn't send "commit" command. And due to mysql server has setting autocommit= off, domain was not deleted. If I set autocommit=on, everything is fine.

kerem closed this issue

2026-02-28 01:20:45 +03:00

kerem commented

2026-02-28 01:20:45 +03:00

Author

Owner

@izenk commented on GitHub (Apr 1, 2016):

As I understand nsedit only uses pdnsapi and has no control over sql queries. And that's why this problesm is related to pdns api, not to nsedit.
Issue can be closed. Thank you.

@izenk commented on GitHub (Apr 1, 2016): As I understand nsedit only uses pdnsapi and has no control over sql queries. And that's why this problesm is related to pdns api, not to nsedit. Issue can be closed. Thank you.

kerem referenced this issue

2026-02-28 01:21:13 +03:00

[PR #49] [MERGED] This should fix the duplication of records when changing the recordtype #150