volkszaehler.org icon indicating copy to clipboard operation
volkszaehler.org copied to clipboard

Incompatibility of new DB structure and dbcopy

Open fm-maniac opened this issue 1 year ago • 0 comments

With the new DB structure omitting the consecutive ID and using the combination of timestamp and channel_ID as the primary key, dbcopy does no longer work for DB backups.

dbcopy requires a single primary key -> iterative (partly) backups fails. Full backups are always aborted after 1000 data sets.

Unfortunatly new installs of the middleware come with the new DB structure.

In general omitting the consecutive ID is welcome in terms of data efficiency. But then dbcopy needs to be updated too.

fm-maniac avatar Feb 02 '23 08:02 fm-maniac