[Opendnssec-user] problem Database locked

[Jolivet Sylvain]

Hi,

I'm using opendnssec 1.3.2 and I found a problem when the ods-enforcerd running 
and when I execute an ods-ksmutil command.

For example, I try to export DNSKEY like this :



ods-ksmutil key export -z nameshield.se -e ready
SQLite database set to: /var/lib/opendnssec/db/kasp.db

;ready KSK DNSKEY record:
nameshield.se.  3600    IN      DNSKEY  257 3 8 
AwEAAc1MYiFkxDQhFCvH6PBFLo3qtGrXgpe8RsAb86Pba8EVJxE8BiZk1eTu5q6pXFn07XnLXglV9vMp
4G2C/7jv7wY4ljzXsqYkj3wbeLumYoPSXdY0L7yc1wPyHGzHoXLyaSIxFRde4zUdskfQn7iGg21K5Kr1
f+nk0CyvbuXkNWenpoYU0c4YXGEr6+yFys30DYBQFWBC3w0DOj9ZhzxB4hB6CLSaTX9/TBBbeCvG9tUM
IA6r8H79HKflk8H7fZLOau2j3cHWxFc032MA4jfprXLMiXFeGjYqIVtTafH7V9gNH3rNvRbtQYU86JhZ
044C4fos5AC3tJvt1Ag1dUAggys= ;{id = 5017 (ksk), size = 2048b}


And after this command, The ods-enforcerd log some error and stop running :


ods-enforcerd: Policy for nameshield.se set to test_deploiement.
ods-enforcerd: Config will be output to 
/var/lib/opendnssec/signconf/se/n/signer.nameshield.se.xml.
Aug 11 02:20:06 leman ods-enforcerd: ERROR: error executing SQL - database is 
locked
ods-enforcerd: No change to: 
/var/lib/opendnssec/signconf/se/n/signer.nameshield.se.xml
ods-enforcerd: Zone all-cool.fr found.
ods-enforcerd: Policy for all-cool.fr set to test_deploiement.
ods-enforcerd: Config will be output to 
/var/lib/opendnssec/signconf/fr/a/signer.all-cool.fr.xml.
ods-enforcerd: ERROR: error executing SQL - SQL logic error or missing database
ods-enforcerd: ERROR: database operation failed - SQL logic error or missing 
database
ods-enforcerd: KsmRequestKeys returned: 71691
ods-enforcerd: Signconf not written for all-cool.fr
ods-enforcerd: Disconnecting from Database...
ods-enforcerd: Sleeping for 300 seconds.
ods-enforcerd: Reading config "/etc/opendnssec/conf.xml"
ods-enforcerd: Reading config schema "/usr/share/opendnssec/conf.rng"
ods-enforcerd: Communication Interval: 300
ods-enforcerd: No DS Submit command supplied
ods-enforcerd: SQLite database set to: /var/lib/opendnssec/db/kasp.db
ods-enforcerd: Log User set to: local7
ods-enforcerd: Switched log facility to: local7
ods-enforcerd: Connecting to Database...
ods-enforcerd: ERROR: error executing SQL - database is locked



I don't understand why the ods-enforcer stop working, because I suppose that the 
ods-ksmutil make just SELECT in database.



Best regards.
Sylvain