search

HenriWahl / dhcpy6d

MAC address aware DHCPv6 server written in Python
https://dhcpy6d.de
GNU General Public License v2.0
94 stars 27 forks source link

dhcpy6d prints `Error: table meta already exists` on startup #45

Closed FelixJacobi closed 2 years ago

FelixJacobi commented 2 years ago

Hi,

Sep 22 13:47:16 iserv.felix.mein-iserv.de dhcpy6d[4187198]: Query: CREATE TABLE meta (item_key varchar(255) NOT NULL,                                  item_value varchar(255) NOT NULL, PRIMARY KEY (item_key))
Sep 22 13:47:16 iserv.felix.mein-iserv.de dhcpy6d[4187198]: Error: table meta already exists

I configured sqlite as volatile database storage:

felix.mein-iserv.de ~ # grep volatile /etc/dhcpy6d.conf
store_volatile = sqlite
store_sqlite_volatile = /var/lib/dhcpy6d/volatile.sqlite

After upgrading to Debian Bullseye where a new dhcpy6d version is included, this message is now printed on startup. There was already an existing SQLite database created by dhcpy6d many years ago in place.

The message is printed several times on startup and then once a ~minute again.

Thank you for your time.

Best regards, Felix

HenriWahl commented 2 years ago

Can you send me the sqlite file for testing it?

Looks like the attempt to create the meta table should not block if the table already exists.

FelixJacobi commented 2 years ago

Can you send me the sqlite file for testing it?

Looks like the attempt to create the meta table should not block if the table already exists.

Send via email. Thanks so far.

HenriWahl commented 2 years ago

fixed with v1.0.6