Why won't zonefile load?
Eivind Olsen
eivind at aminor.no
Mon Mar 7 17:13:46 UTC 2011
> We haven't reproduced that yet. (We can load new zones when server is
> running.)
I can too - sometimes, but not always, it seems.
> http://www.sqlite.org/cvstrac/wiki?p=DatabaseIsLocked has some thoughts
> on this.
I checked it out. I'm not really a programmer, so I haven't tried to look
at how BIND 10 handles the sqlite bit, anything which might match points
1-3 on that page.
> Can you please let us know what versions of sqlite3 and py-sqlite3 you
> have installed?
The version numbers as given by pkg_info on FreeBSD are:
py31-sqlite3-3.1.3_1
python31-3.1.3
sqlite3-3.7.4
> Are you using NFS?
No. This first testing was done under FreeBSD 8.2 with default UFS2
filesystems, all mounted the normal way (read/write, no special mount
options) - running in VirtualBox virtualization, but that shouldn't
matter, I'd hope.
I've just tried a bit more. First, I've done 10 imports of a minimal
version of the zonefile and all seems fine. Then I try the bigger zonefile
with DNSSEC information etc (still only a few KB, so not a huge zonefile).
As long as I've tried to have the bigger zonefile, it seems like dig gets
the SERVFAIL and after that I get the "database is locked" error, until I
shut down BIND 10. If I again does a dig I'll keep getting the "database
is locked" error when doing a new loadzone. My way out of that has been:
- shut down BIND 10
- start BIND 10
- load the smaller, nicer zonefile before I've done any queries for names
there (I can query for other information though, like version.bind)
- I can now do queries for that domain name again, and I can also loadzone
the small zone. If I load the big zone it's back to the "database is
locked" after that.
Oh btw, before I did todays testing, I ran my full zone through the
"named-compilezone -D" command - the original version works fine with the
NSD server though, and is generated by OpenDNSSEC.
This compilezoned version loads fine into BIND 10 according to the
commandline (27 RR(s) loaded in 0.15 second(s) (100.00% of bofull.zone-d))
- never mind about the odd filenames I've used while testing :)
I can do the same import of the big version several times in a row without
any apparant error, but if I then do a "dig @127.0.0.1 -p 5300 bohrnag.org
any" I get the SERVFAIL and subsequent b10-loadzones give the "database is
locked".
I'm not sure if attachments are working on this mailinglist, so I'll
include the two zonefiles in the message itself.
First, the minimal version which loads fine and seems to work (it's just
very boring :D
bohrnag.org. 3600 IN SOA ns.aminor.no. eivind.aminor.no.
2011030601 28800 7200 864000 3600
bohrnag.org. 3600 IN NS ns.aminor.no.
bohrnag.org. 3600 IN NS bohrnag.aminor.no.
bohrnag.org. 3600 IN MX 10 mx.aminor.no.
Then the bigger version with DNSSEC records etc:
bohrnag.org. 3600 IN SOA ns.aminor.no. hostmaster.aminor.no.
2011030406 28800 7200 3024000 3600
bohrnag.org. 3600 IN RRSIG SOA 8 2 3600 20110312063357
20110304205053 18201 bohrnag.org.
k0yaEC9nryYW2zks3xNsCmd/B/+2PDb6ZdVJNX0Edsq2WYlaiGjxtUnR
gDT+RZ39ocKnYM/9q0Ly97vpS6CsLRbi6KUgQOQt4Tda6tgOmXvhTgIP
sFZZ+gRxUKLsTGFYOmIKJHB/ZWq4FglDdtnoYyPjGB9MD6p7wJniP/7R xXQ=
bohrnag.org. 86400 IN NS ns.aminor.no.
bohrnag.org. 86400 IN NS bohrnag.aminor.no.
bohrnag.org. 86400 IN RRSIG NS 8 2 86400 20110311072000
20110304085047 18201 bohrnag.org.
XplJBDtkTPU/7dAXhCSrHbr7R/CPcC2MrAmIkG+Zo9/M1XP3GADJMYir
61m0fpFWyrPfpSWesYVAev3RpLyUk/aJEVWOrJwzoMfXuNRK/CsZXuu4
4l45TjqhjbT3oMGrL3sDr4SSpUVknaoRoiY9rrCHK8R3l9OQ8o/0lb/w Ac0=
bohrnag.org. 86400 IN A 213.187.177.2
bohrnag.org. 86400 IN RRSIG A 8 2 86400 20110311053844
20110304125049 18201 bohrnag.org.
RtbDZFX8wtwSMATwEjclIc5Rnmjh+DOBZjx0Rth+G10eKl0rjJSo1TiC
TFTqPfgGOAzgHdHTU4SUsXkTo9YfN0ifaTQSQHW00/w3RT6NJI87Iy9B
TRvblumnA1a4pZS0e4Q0wPVQmKFiMGclviCqNS3Yj40g73ovh5HCkMpQ ZBg=
bohrnag.org. 86400 IN MX 10 bohrnag.aminor.no.
bohrnag.org. 86400 IN RRSIG MX 8 2 86400 20110311184718
20110304125049 18201 bohrnag.org.
jOnnN2HM0jOK3txchb9twsF+r/aQ94BO6PtQXUAoROA7MFK6u0qYoK2z
zsw+XmBq3pkHXgM1EqoXD0ggJ/KwotnmO/BBPh8Pd/Dk7/GC6whk2dZw
KecYpEN+4sftlT/XVrzs7xOkfJ4WEDX0fXN9bP874/6d9cuB7Xw8VcpZ qRA=
bohrnag.org. 86400 IN TXT "Tester litt"
bohrnag.org. 86400 IN TXT "Tester litt mere"
bohrnag.org. 86400 IN TXT "Tester litt mere igjen"
bohrnag.org. 86400 IN RRSIG TXT 8 2 86400 20110310232101
20110304005039 18201 bohrnag.org.
AM6ETYrwzmmU573DkaxCgY+NlhgJ/hh0X0cin/LHdGli8be3fo9/y/l6
xrf4hmtfNdbEzZSotA5B0J5pHq87fM2z2vaC6cK/8JDsShha9DPngKtR
07tNHRZ/Lfr9g7Y75ybAwKgE+wx/ejhoWkMNc68TLz8BeBX2m+G2g/B/ xBI=
bohrnag.org. 86400 IN RP postmaster.aminor.no. postmaster.aminor.no.
bohrnag.org. 86400 IN RRSIG RP 8 2 86400 20110311172400
20110304205053 18201 bohrnag.org.
GkTnLDjCpaJF9ZHZUZLCZqZZKkDI9WujaRNWjdya4E0zpU2tvopBvfWf
2Yp1hAl43JwLtm1uu8LRtwjklPF95/GnP3sdxL1yz4zF0NZHfKKqYZCB
rCvBgnWaaEa31Ts9hY5qKEUWh7wutoSuz/FV9LCeLUFcONTURZon2JXt dOE=
bohrnag.org. 3600 IN DNSKEY 256 3 8
AwEAAbAj3KL63OwYECWjp78DffRz6eQxn430lbhA2ojaL5x6cqpG7bKY
CUmqy8RdhmM8PZqlVJwuc5RIPfBuM/PjLCbdzxQ9bpL5BmT/8X506Gt4
nTcWuvcMeaDAlDg0TFEWRMsZQfOE4JA7fmAbBBo1FfiTAzgOIHNKO8bk ot9CWeJP ; key
id = 18201
bohrnag.org. 3600 IN DNSKEY 257 3 8
AwEAAbbyfT1bVcmFJ8oAO0p/5UBkmkCTx3Pgim5qp9tTO0R/lReYswLa
K7dkv9CBHi3Si92p9EqCBlLuOLrzGljnxEs/A78ARywCFi3Fy6PKEc37
viRYGCi34/7JhFwNm3TAB/00b5Wd8On94xHH37x6DnAsE/iQ0usxzIWZ
m93yEMy2E4/GFFFywy5Wavv4+is56eSFuaLzWdGZueF2qiTElt+Mzhz1
s3gFhYa9RwUnTy1bXT+gAiDfgACMLXtiFLt3f85GvnGIvRvykuMhtJBQ
Gysx1iWKrtcE1I1pwyHmwF/tSl/UNtespGdm8sNsPKtqeQg9oahZX5u1 XIX3U3mkrFE= ;
key id = 18974
bohrnag.org. 3600 IN RRSIG DNSKEY 8 2 3600 20110311174439
20110304145050 18974 bohrnag.org.
oh9IytG/nvr33kRWcs+s6B0jUofhPgG0rqwURwZiYwZiZWX0xuC0QwNh
nJsVDEghVzShobV7Tj5V45O4kc/FSJMgffZNn10OpNGHju6Z/0YJF/un
qlU+lYF7ju/RkJdR+Zfvpn5c1+2kbzW6ed4LYDXEYIl4ZCr9rA7yymkh
+bTwATL8pUm++4oAZqPdSZ6JIN6QtO63aqYsogJ/71GpTQpKrKf3+wXg
dTqfIajFOK4i6PPMHitgtNiuTrONqcuQyFfYIY/Gq7rgLYY7bQ+g1FCn
IXfKpo7PtZZOk8EgJAlrFHnfK/K8SW3BMqLQqMb5uLp5VURfGL5Iydgc Hqq4RQ==
bohrnag.org. 3600 IN NSEC3PARAM 1 0 5 525CFE9432B6FCE1
bohrnag.org. 3600 IN RRSIG NSEC3PARAM 8 2 3600 20110311145136
20110304045046 18201 bohrnag.org.
N77gpRVr+F9ZvpAnYyjxFjD5/3a++6C1FKalbJXJRTzsIXoNkIP/OOUd
5FB31+ggLH3bGDobTSG14vrfrFazj+xszndt7Qoe27CF1lo+nICoN2VQ
Mc4hEUB50AdjCA5+vl7kF8JHzL0zW6T3Y8l9tIbm0JYRy2HqRX5fQBYz y3Q=
www.bohrnag.org. 86400 IN A 213.187.177.2
www.bohrnag.org. 86400 IN RRSIG A 8 3 86400 20110311090938
20110304185051 18201 bohrnag.org.
pIbHzU0ouDruuLS6C6Nxsl1MDrb2upmliWbvK+9L+OQ9fXl1WWXGdgkE
e1FtL9C8XElCtf97CpGI2UQPbAsEz6IzBYqwrGSgCTjz/f8/mwVU/upw
bZSIhQNTqMW+yr7Mrkav8afVBkoe5jHD37S6/FO1sn9sHek3voEfySWq 3hI=
d10kpgraof3gn110v1q5ufb033bdteuj.bohrnag.org. 3600 IN NSEC3 1 0 5
525CFE9432B6FCE1 JB118LA5445HMEEST8IM9VHDB0IB5H7U A NS SOA MX TXT RP RRSIG
DNSKEY NSEC3PARAM
d10kpgraof3gn110v1q5ufb033bdteuj.bohrnag.org. 3600 IN RRSIG NSEC3 8 3 3600
20110312015255 20110304185051 18201 bohrnag.org.
TPkPla6Jsj8QiAFx1cLr6ZJf3a2njYLdzyKg/GNpjKyaWMR/a9ZkXNXi
5On3zNB5s3MZTtbvPn/srWGX2Y1pTSH8rk8qlQIDTKn6Md5aZ38Izmgy
fr8wr5eNnkBt06kEslDb4KAOKddnDxNgCLc2p37pm2LZXiqxJxlqih8S CWQ=
jb118la5445hmeest8im9vhdb0ib5h7u.bohrnag.org. 3600 IN NSEC3 1 0 5
525CFE9432B6FCE1 D10KPGRAOF3GN110V1Q5UFB033BDTEUJ A RRSIG
jb118la5445hmeest8im9vhdb0ib5h7u.bohrnag.org. 3600 IN RRSIG NSEC3 8 3 3600
20110311122350 20110304025041 18201 bohrnag.org.
jg1PxeJArAfwW9jsqpKilymfvsTS+TzzayVtb6zejn0rOKKWcd7avQ1/
+FakR8ylTsQ4C3Zgz4CxWeKMGD8kNXULKiYVSQJ9ZpcoAyqU2K6f/gqr
hNJ/Q9qVTjiTUvfss8ZnHZI9RHNBx+ySZAU+hZqHFOwuOdD3IwqNXPm2 //E=
Let me know if you'd prefer to get these attached as files, uploaded
somewhere or something.
Regards
Eivind Olsen
eivind at aminor.no
More information about the bind10-users
mailing list