Bitte Lies die Fehlermeldung. Es sehr alles da! Viele Grüße, Andreas
> Am 13.06.2019 um 20:00 schrieb John Doe <john...@null.net>: > > Hallo zusammen, > > mein Problem nach dem rpi-update hat sich durch ein aktuelles rpi-update > erledigt, alles läuft soweit wieder. > Leider habe ich jetzt wieder ein Problem mit dem Backup der Datenbank: > > sudo /var/www/volkszaehler.org/vendor/bin/dbcopy create -c /etc/dbcopy.yaml > Creating target schema > Creating tables > Updating schema assets for target platform compatibility: sqlite > table: aggregate > table: data > table: entities > table: entities_in_aggregator > table: properties > CREATE TABLE aggregate (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, > channel_id INTEGER DEFAULT NULL, type SMALLINT NOT NULL, timestamp BIGINT NOT > NULL, value DOUBLE PRECISION NOT NULL, count INTEGER NOT NULL, CONSTRAINT > FK_B77949FF72F5A1AA FOREIGN KEY (channel_id) REFERENCES entities (id) NOT > DEFERRABLE INITIALLY IMMEDIATE) > CREATE UNIQUE INDEX aggregate_unique ON aggregate (channel_id, type, > timestamp) > CREATE INDEX IDX_B77949FF72F5A1AA ON aggregate (channel_id) > CREATE TABLE data (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, channel_id > INTEGER DEFAULT NULL, timestamp BIGINT NOT NULL, value DOUBLE PRECISION NOT > NULL, CONSTRAINT FK_ADF3F36372F5A1AA FOREIGN KEY (channel_id) REFERENCES > entities (id) NOT DEFERRABLE INITIALLY IMMEDIATE) > CREATE UNIQUE INDEX data_unique ON data (channel_id, timestamp) > CREATE INDEX IDX_ADF3F36372F5A1AA ON data (channel_id) > CREATE TABLE entities (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, uuid > VARCHAR(36) NOT NULL, type VARCHAR(255) NOT NULL, class VARCHAR(255) NOT NULL) > CREATE UNIQUE INDEX UNIQ_50EC64E5D17F50A6 ON entities (uuid) > CREATE TABLE entities_in_aggregator (parent_id INTEGER NOT NULL, child_id > INTEGER NOT NULL, PRIMARY KEY(parent_id, child_id), CONSTRAINT > FK_2BD88468727ACA70 FOREIGN KEY (parent_id) REFERENCES entities (id) NOT > DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_2BD88468DD62C21B FOREIGN KEY > (child_id) REFERENCES entities (id) NOT DEFERRABLE INITIALLY IMMEDIATE) > CREATE INDEX IDX_2BD88468727ACA70 ON entities_in_aggregator (parent_id) > CREATE INDEX IDX_2BD88468DD62C21B ON entities_in_aggregator (child_id) > CREATE TABLE properties (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, > entity_id INTEGER DEFAULT NULL, pkey VARCHAR(255) NOT NULL, value CLOB NOT > NULL, CONSTRAINT FK_87C331C781257D5D FOREIGN KEY (entity_id) REFERENCES > entities (id) NOT DEFERRABLE INITIALLY IMMEDIATE) > CREATE UNIQUE INDEX property_unique ON properties (entity_id, pkey) > CREATE INDEX IDX_87C331C781257D5D ON properties (entity_id) > In AbstractSQLiteDriver.php line 47: > An exception occurred while executing 'CREATE TABLE aggregate (id INTEGER > PRIMARY KEY AUTOINCRE > MENT NOT NULL, channel_id INTEGER DEFAULT NULL, type SMALLINT NOT NULL, > timestamp BIGINT NOT NU > LL, value DOUBLE PRECISION NOT NULL, count INTEGER NOT NULL, CONSTRAINT > FK_B77949FF72F5A1AA FOR > EIGN KEY (channel_id) REFERENCES entities (id) NOT DEFERRABLE INITIALLY > IMMEDIATE)': > SQLSTATE[HY000]: General error: 1 table aggregate already exists > > In PDOConnection.php line 43: > SQLSTATE[HY000]: General error: 1 table aggregate already exists > > In PDOConnection.php line 41: > SQLSTATE[HY000]: General error: 1 table aggregate already exists > > create [-c|--config CONFIG] > > Hat jemand einen Tip, was ich tun könnte ? > Grüße, > > JD.