[vz-users] Probleme beim Datenbank-BackUp

[John Doe]

Hallo Frank, 

ein Update von was denn?
Und woher kommt der Fehler? 
Grüße, 

JD. 

> Sent: Thursday, June 13, 2019 at 9:14 PM
> From: "Frank Richter" <frank.richter83 at gmail.com>
> To: "volkszaehler.org - users" <volkszaehler-users at demo.volkszaehler.org>
> Subject: Re: [vz-users] Probleme beim Datenbank-BackUp
>
> Die Fehlermeldung ist eigentlich eindeutig: die Tabelle gibt's schon, also
> ist create der falsche Befehl. Ich glaub update müsste passen.
> 
> Grüße
> Frank
> 
> John Doe <johndoe at null.net> schrieb am Do., 13. Juni 2019, 20:00:
> 
> > 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.
> >
>