SQL-Fehlermeldung bei Neustart "Duplicate entry"

apollon77

Der Fehler kommt weil (warum auch immer) er für eine ID und einen Timestamp mehrfach Werte loggen will … Man müsste jetzt rausfinden warum das passiert ...

PrinzEisenherz1

hmmm…das ist jetzt ne gute Frage warum er das machen will.

Wie würde ich denn das am besten rausbekommen?

Gruß

Johnny

apollon77

Instanz mal auf Loglevel Debug stellen und Log posten

PrinzEisenherz1

so, hier mal ein auszug aus m log

sql.0	2018-08-07 16:04:06.630	debug	SELECT id, type, name FROM `iobroker`.datapoints WHERE name='javascript.0.IntelNUC.Temp-Core0';
sql.0	2018-08-07 16:04:06.630	debug	Type (from State) for javascript.0.IntelNUC.Temp-Core0: 0
sql.0	2018-08-07 16:04:06.616	debug	Type set in Def for javascript.0.IntelNUC.Temp-Core0: undefined
sql.0	2018-08-07 16:04:06.616	debug	Type (from Obj) for javascript.0.IntelNUC.Temp-Core0: undefined
sql.0	2018-08-07 16:04:06.616	debug	mixed / undefined / {"name":"Systemtemperatur Core-0","unit":"°C","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"
sql.0	2018-08-07 16:04:06.616	debug	Type set in Def for javascript.0.IntelNUC.Temp-Core0: undefined
sql.0	2018-08-07 16:04:06.616	debug	Type (from Obj) for javascript.0.IntelNUC.Temp-Core0: undefined
sql.0	2018-08-07 16:04:06.616	debug	mixed / undefined / {"name":"Systemtemperatur Core-0","unit":"°C","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"
sql.0	2018-08-07 16:04:06.614	debug	Type set in Def for javascript.0.IntelNUC.Temp-Core0: false
sql.0	2018-08-07 16:04:06.614	debug	Datatype javascript.0.IntelNUC.Temp-Core0: Currently: number, StorageType: false
sql.0	2018-08-07 16:04:06.535	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(303, 1533650641391, 0.22, 0, 7, 0);
sql.0	2018-08-07 16:04:06.535	info	changed history configuration to pin detected datatype for javascript.0.IntelNUC.VM-ioBroker.load15Min
sql.0	2018-08-07 16:04:06.528	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(303, 1533650641389, 0.22, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '303-1533650641389' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.525	error	Cannot delete DELETE FROM `iobroker`.undefined WHERE id=303 AND ts < 1530972240511;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
sql.0	2018-08-07 16:04:06.522	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(303, 1533650641390, 0.22, 0, 7, 0);
sql.0	2018-08-07 16:04:06.522	debug	Type (from DB-Type) for javascript.0.IntelNUC.VM-ioBroker.load15Min: 0
sql.0	2018-08-07 16:04:06.522	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.522	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.522	debug	mixed / undefined / {"name":"System-load 15-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changes
sql.0	2018-08-07 16:04:06.522	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(303, 1533650641389, 0.22, 0, 7, 0);
sql.0	2018-08-07 16:04:06.522	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load15Min: 0
sql.0	2018-08-07 16:04:06.522	debug	UPDATE `iobroker`.datapoints SET type = 0 WHERE id = 303;
sql.0	2018-08-07 16:04:06.521	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load15Min: 0
sql.0	2018-08-07 16:04:06.521	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(303, 1533650641388, 0.22, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '303-1533650641388' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.521	debug	DELETE FROM `iobroker`.undefined WHERE id=303 AND ts < 1530972240511;
sql.0	2018-08-07 16:04:06.501	error	Cannot insert INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(300, 1533650641340, '2,8', 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '300-1533650641340' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.501	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(302, 1533650641374, 0.17, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '302-1533650641374' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.501	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.501	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.501	debug	mixed / undefined / {"name":"System-load 15-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changes
sql.0	2018-08-07 16:04:06.501	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(302, 1533650641373, 0.17, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '302-1533650641373' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.501	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(303, 1533650641388, 0.22, 0, 7, 0);
sql.0	2018-08-07 16:04:06.501	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(303, 1533650641389, 0.22, 0, 7, 0);
sql.0	2018-08-07 16:04:06.501	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(303, 1533650641388, 0.22, 0, 7, 0);
sql.0	2018-08-07 16:04:06.501	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(302, 1533650641375, 0.17, 0, 7, 0);
sql.0	2018-08-07 16:04:06.501	info	changed history configuration to pin detected datatype for javascript.0.IntelNUC.VM-ioBroker.load5Min
sql.0	2018-08-07 16:04:06.501	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641355, 0.12, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '301-1533650641355' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.501	debug	DELETE FROM `iobroker`.ts_number WHERE id=302 AND ts < 1530972240481;
sql.0	2018-08-07 16:04:06.501	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.501	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.501	debug	mixed / undefined / {"name":"System-load 15-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changes
sql.0	2018-08-07 16:04:06.500	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641356, 0.12, 0, 7, 0);
sql.0	2018-08-07 16:04:06.500	info	changed history configuration to pin detected datatype for javascript.0.IntelNUC.VM-ioBroker.load1Min
sql.0	2018-08-07 16:04:06.500	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load15Min: 0
sql.0	2018-08-07 16:04:06.500	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641354, 0.12, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '301-1533650641354' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.447	debug	INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(300, 1533650641340, '2,8', 0, 7, 0);
sql.0	2018-08-07 16:04:06.447	info	changed history configuration to pin detected datatype for javascript.0.IntelNUC.VM-ioBroker.StorageUsed
sql.0	2018-08-07 16:04:06.447	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.447	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.447	debug	mixed / undefined / {"name":"System-load 15-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changes
sql.0	2018-08-07 16:04:06.447	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(302, 1533650641374, 0.17, 0, 7, 0);
sql.0	2018-08-07 16:04:06.447	debug	Type (from DB-Type) for javascript.0.IntelNUC.VM-ioBroker.load5Min: 0
sql.0	2018-08-07 16:04:06.447	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load5Min: undefined
sql.0	2018-08-07 16:04:06.447	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load5Min: undefined
sql.0	2018-08-07 16:04:06.447	debug	mixed / undefined / {"name":"System-load 5-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changesR
sql.0	2018-08-07 16:04:06.447	error	Cannot insert INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(300, 1533650641339, '2,8', 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '300-1533650641339' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.447	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641355, 0.12, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '301-1533650641355' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.447	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641354, 0.12, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '301-1533650641354' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.447	debug	DELETE FROM `iobroker`.ts_number WHERE id=301 AND ts < 1530972240424;
sql.0	2018-08-07 16:04:06.447	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load15Min: 0
sql.0	2018-08-07 16:04:06.447	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(302, 1533650641373, 0.17, 0, 7, 0);
sql.0	2018-08-07 16:04:06.447	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load5Min: 0
sql.0	2018-08-07 16:04:06.447	debug	SELECT id, type, name FROM `iobroker`.datapoints WHERE name='javascript.0.IntelNUC.VM-ioBroker.load15Min';
sql.0	2018-08-07 16:04:06.447	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load15Min: 0
sql.0	2018-08-07 16:04:06.447	debug	UPDATE `iobroker`.datapoints SET type = 0 WHERE id = 302;
sql.0	2018-08-07 16:04:06.446	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load5Min: 0
sql.0	2018-08-07 16:04:06.446	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641355, 0.12, 0, 7, 0);
sql.0	2018-08-07 16:04:06.446	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load1Min: 0
sql.0	2018-08-07 16:04:06.446	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(299, 1533650641318, 27, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '299-1533650641318' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.446	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(302, 1533650641374, 0.17, 0, 7, 0);
sql.0	2018-08-07 16:04:06.446	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(302, 1533650641373, 0.17, 0, 7, 0);
sql.0	2018-08-07 16:04:06.446	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	mixed / undefined / {"name":"System-load 15-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changes
sql.0	2018-08-07 16:04:06.446	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load5Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load5Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	mixed / undefined / {"name":"System-load 5-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changesR
sql.0	2018-08-07 16:04:06.446	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641354, 0.12, 0, 7, 0);
sql.0	2018-08-07 16:04:06.446	debug	Type (from DB-Type) for javascript.0.IntelNUC.VM-ioBroker.load1Min: 0
sql.0	2018-08-07 16:04:06.446	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load1Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load1Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	mixed / undefined / {"name":"System-load 1-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changesR
sql.0	2018-08-07 16:04:06.446	error	Cannot insert INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(300, 1533650641340, '2,8', 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '300-1533650641340' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.446	error	Cannot insert INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(300, 1533650641339, '2,8', 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '300-1533650641339' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.446	debug	DELETE FROM `iobroker`.ts_string WHERE id=300 AND ts < 1530972240406;
sql.0	2018-08-07 16:04:06.446	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load5Min: 0
sql.0	2018-08-07 16:04:06.446	debug	UPDATE `iobroker`.datapoints SET type = 0 WHERE id = 301;
sql.0	2018-08-07 16:04:06.446	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load1Min: 0
sql.0	2018-08-07 16:04:06.446	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load15Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	mixed / undefined / {"name":"System-load 15-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changes
sql.0	2018-08-07 16:04:06.446	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load5Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load5Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	mixed / undefined / {"name":"System-load 5-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changesR
sql.0	2018-08-07 16:04:06.446	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load1Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load1Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	mixed / undefined / {"name":"System-load 1-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changesR
sql.0	2018-08-07 16:04:06.446	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load15Min: false
sql.0	2018-08-07 16:04:06.446	debug	Datatype javascript.0.IntelNUC.VM-ioBroker.load15Min: Currently: number, StorageType: false
sql.0	2018-08-07 16:04:06.446	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load5Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load5Min: undefined
sql.0	2018-08-07 16:04:06.446	debug	mixed / undefined / {"name":"System-load 5-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changesR
sql.0	2018-08-07 16:04:06.446	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load1Min: undefined
sql.0	2018-08-07 16:04:06.445	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load1Min: undefined
sql.0	2018-08-07 16:04:06.445	debug	mixed / undefined / {"name":"System-load 1-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changesR
sql.0	2018-08-07 16:04:06.445	debug	INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(300, 1533650641339, '2,8', 0, 7, 0);
sql.0	2018-08-07 16:04:06.445	debug	Type (from DB-Type) for javascript.0.IntelNUC.VM-ioBroker.StorageUsed: 1
sql.0	2018-08-07 16:04:06.445	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.StorageUsed: undefined
sql.0	2018-08-07 16:04:06.445	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.StorageUsed: undefined
sql.0	2018-08-07 16:04:06.445	debug	mixed / undefined / {"name":"HDD-Speicher Verbraucht","unit":"GByte","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention
sql.0	2018-08-07 16:04:06.445	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641355, 0.12, 0, 7, 0);
sql.0	2018-08-07 16:04:06.445	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641354, 0.12, 0, 7, 0);
sql.0	2018-08-07 16:04:06.445	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641355, 0.12, 0, 7, 0);
sql.0	2018-08-07 16:04:06.445	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(301, 1533650641354, 0.12, 0, 7, 0);
sql.0	2018-08-07 16:04:06.445	debug	INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(299, 1533650641318, 27, 0, 7, 0);
sql.0	2018-08-07 16:04:06.445	info	changed history configuration to pin detected datatype for javascript.0.IntelNUC.VM-ioBroker.StorageFree
sql.0	2018-08-07 16:04:06.445	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(298, 1533650641285, 0.962891, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '298-1533650641285' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.445	debug	SELECT id, type, name FROM `iobroker`.datapoints WHERE name='javascript.0.IntelNUC.VM-ioBroker.load5Min';
sql.0	2018-08-07 16:04:06.445	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load5Min: 0
sql.0	2018-08-07 16:04:06.445	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.load1Min: 0
sql.0	2018-08-07 16:04:06.445	debug	UPDATE `iobroker`.datapoints SET type = 1 WHERE id = 300;
sql.0	2018-08-07 16:04:06.445	debug	Type (from State) for javascript.0.IntelNUC.VM-ioBroker.StorageUsed: 1
sql.0	2018-08-07 16:04:06.445	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(299, 1533650641317, 27, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '299-1533650641317' for key 'PRIMARY'
sql.0	2018-08-07 16:04:06.445	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load5Min: undefined
sql.0	2018-08-07 16:04:06.445	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load5Min: undefined
sql.0	2018-08-07 16:04:06.445	debug	mixed / undefined / {"name":"System-load 5-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changesR
sql.0	2018-08-07 16:04:06.445	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.load1Min: undefined
sql.0	2018-08-07 16:04:06.445	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.load1Min: undefined
sql.0	2018-08-07 16:04:06.445	debug	mixed / undefined / {"name":"System-load 1-Min","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention":"2678400","changesR
sql.0	2018-08-07 16:04:06.445	debug	Type set in Def for javascript.0.IntelNUC.VM-ioBroker.StorageUsed: undefined
sql.0	2018-08-07 16:04:06.445	debug	Type (from Obj) for javascript.0.IntelNUC.VM-ioBroker.StorageUsed: undefined
sql.0	2018-08-07 16:04:06.445	debug	mixed / undefined / {"name":"HDD-Speicher Verbraucht","unit":"GByte","role":"javascript","type":"mixed","custom":{"sql.0":{"enabled":true,"changesOnly":true,"debounce":"5000","maxLength":10,"retention
sql.0	2018-08-07 16:04:06.445	debug	INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(300, 1533650641340, '2,8', 0, 7, 0);

PrinzEisenherz1

Konntest du was erkennen?

Gruß Johnny

apollon77

Auszug zu kurz. Am besten wirklich starten mit dem Start vom Adapter und dann bis der ganze initiale Kram durch ist.

Gesendet vom Handy …

PrinzEisenherz1

So Apollon, hier der log ab dem Moment wo ich den sql Adapter auf debug gestellt habe, bis zu dem Zeitpunkt wo sich die sache mit den errors beruhigt hat.
1058_iobroker.2018-08-08.log

Ich hoffe Du finest was raus!?!?

Gruß

Johnny

PrinzEisenherz1

Apollon hattest Du schon mal n Minütchen wo Du den log ansehen konntest?

Hast Du was entdeckt?

Gruß

Johnny

apollon77

Nope noch keine Zeit gehabt

Stabilostick

Die Datenbank irrt hier nicht:

Zuerst:

INSERT INTO ts_number .... VALUES(107, 1533758018663, 22.98, 0, 7, 0);
INSERT INTO ts_number .... VALUES(107, 1533758018664, 22.98, 0, 7, 0);
INSERT INTO ts_number .... VALUES(107, 1533758018663, 22.98, 0, 7, 0);
INSERT INTO ts_number .... VALUES(107, 1533758018664, 22.98, 0, 7, 0);
INSERT INTO ts_number .... VALUES(107, 1533758018663, 22.98, 0, 7, 0);
INSERT INTO ts_number .... VALUES(107, 1533758018664, 22.98, 0, 7, 0);
INSERT INTO ts_number .... VALUES(168, 1533758018668, 22.98, 0, 5, 0);
INSERT INTO ts_number .... VALUES(168, 1533758018669, 22.98, 0, 5, 0);
INSERT INTO ts_number .... VALUES(168, 1533758018668, 22.98, 0, 5, 0);
INSERT INTO ts_number .... VALUES(168, 1533758018669, 22.98, 0, 5, 0);
INSERT INTO ts_number .... VALUES(168, 1533758018668, 22.98, 0, 5, 0);
INSERT INTO ts_number .... VALUES(168, 1533758018669, 22.98, 0, 5, 0);

dann kommt

changed history configuration to pin detected datatype ...
````für die verschiedenen Datenpunkte und dann gleich darauf:

DELETE FROM ts_number WHERE id=107 AND ts < 1502221980756;
INSERT INTO ts_number .... VALUES(107, 1533758018663, 22.98, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '107-1533758018663' for key 'PRIMARY'
INSERT INTO ts_number .... VALUES(107, 1533758018664, 22.98, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '107-1533758018664' for key 'PRIMARY'
INSERT INTO ts_number .... VALUES(107, 1533758018663, 22.98, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '107-1533758018663' for key 'PRIMARY'
INSERT INTO ts_number .... VALUES(107, 1533758018664, 22.98, 0, 7, 0);: Error: ER_DUP_ENTRY: Duplicate entry '107-1533758018664' for key 'PRIMARY'
INSERT INTO ts_number .... VALUES(168, 1533758018669, 22.98, 0, 5, 0);: Error: ER_DUP_ENTRY: Duplicate entry '168-1533758018669' for key 'PRIMARY'

DELETE FROM ts_number WHERE id=168 AND ts < 1502221980762;
INSERT INTO ts_number .... VALUES(168, 1533758018668, 22.98, 0, 5, 0);: Error: ER_DUP_ENTRY: Duplicate entry '168-1533758018668' for key 'PRIMARY'
INSERT INTO ts_number .... VALUES(168, 1533758018669, 22.98, 0, 5, 0);: Error: ER_DUP_ENTRY: Duplicate entry '168-1533758018669' for key 'PRIMARY'
INSERT INTO ts_number .... VALUES(168, 1533758018668, 22.98, 0, 5, 0);: Error: ER_DUP_ENTRY: Duplicate entry '168-1533758018668' for key 'PRIMARY'


Hmm, das Delete ist um ein Jahr nach vorne verschoben … 08.08.2017 21:53:01

Kannst Du zur Vollständigkeit das JavaScript posten, das die Werte setzt?

apollon77

Das ist ein Timing-Issue in der Initialisierung. Soweit bin ich schon …

Das Problem ist das Dinge noch nicht sauber initialisiert sind (sql calls sind halt asynchron) aber dann schnell Werte reinkommen. Und dann passieren komische Dinge ...

Mal warten bitte

apollon77

So, bitte mal die 1.9.3 vom Github installieren, instanz neustarten (mit Debug an wieder) und mir in jedem Fall das Log schicken/posten.

jetzt besser?

PrinzEisenherz1

Hab das update durchgeführt und den Adapter auf debugging gestellt. bis jetzt keine Verbesserung. Was mir aber aufgefallen ist, auf den ersten blick sind das alles Fehlermeldungen von Statusänderungen durch z.b. Arduinos die über simple api senden (http://<ip-adresse>:8082/set/javascript.0.xxxxxx)

hier mal das log-File
1058_iobroker.2018-08-10.log

Gruß

Johnny</ip-adresse>

Stabilostick

Kannst Du zur Vollständigkeit das JavaScript posten, das die Werte setzt?

javascript.0.IntelNUC.*

PrinzEisenherz1

Das ist kein Javascript sondern ein bash-script auf dem Proxmox

Der vollständigkeithalber

#!/bin/sh
### Scriptname:                sysinfo.sh
### Kurzbeschreibung:      Ermitteln von Systemwerten InterlNUC root-System und überträgt an ioBroker
### Ersteller:                    Prinzeisenherz1 (Schneider Johnny) am 24072018
###
#########################################################

### Lokale Variablen anlegen
ioBrokerIP="192.168.178.2:8082"
echo "ip "$ioBrokerIP
URL_set_StorageTotal="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.StorageTotal?value="
URL_set_StorageFree="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.StorageFree?value="
URL_set_StorageUsed="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.StorageUsed?value="
URL_set_MemTotal="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.MemTotal?value="
URL_set_MemFree="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.MemFree?value="
URL_set_MemUsed="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.MemUsed?value="
URL_set_load1Min="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.load1Min?value="
URL_set_load5Min="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.load5Min?value="
URL_set_load15Min="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.load15Min?value="
URL_set_Uptime_day="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.UptimeDay?value="
URL_set_Uptime_hour="http://"$ioBrokerIP"/set/javascript.0.IntelNUC.VM-ioBroker.UptimeHour?value="

### Gesamtspeicherplatz Arbeitsspeicher in Gigabyte ermitteln und an die ioBroker übertragen
tmp2=$(free -m | awk '{print $2/1024}' | sed -n '2p' | sed 's/G//g')

### Freier Speicherplatz Arbeitsspeicher in Gigabyte ermitteln und an die ioBroker übertragen
tmp3=$(free -m | awk '{print $4/1024}' | sed -n '2p' | sed 's/G//g')

### Belegter Speicherplatz Arbeitsspeicher in Gigabyte ermitteln und an die ioBroker übertragen
tmp4=$(free -m | awk '{print $3/1024}' | sed -n '2p' | sed 's/G//g')

### Gesamtspeicherplatz Datenträger in Gigabyte ermitteln und an die ioBroker übertragen
tmp10=$(df -H | awk '{print $2}' | sed -n '4p' | sed 's/G//g')

### Freier Speicherplatz Datenträger in Gigabyte ermitteln und an die ioBroker übertragen
tmp11=$(df -H | awk '{print $4}' | sed -n '4p' | sed 's/G//g')

### Belegter Speicherplatz Datenträger in Gigabyte ermitteln und an die ioBroker übertragen
tmp12=$(df -H | awk '{print $3}' | sed -n '4p' | sed 's/G//g')

### Systemload 1-Min ermitteln und an die ioBroker übertragen
tmp5=$(cat /proc/loadavg | awk '{print $1}')

### Systemload 5-Min ermitteln und an die ioBroker übertragen
tmp6=$(cat /proc/loadavg | awk '{print $2}')

### Systemload 15-Min ermitteln und an die ioBroker übertragen
tmp7=$(cat /proc/loadavg | awk '{print $3}')

### UpTime in Tage und Stunden ermitteln und an ioBroker übertragen
tmp8=$(cat /proc/uptime | awk '{printf"%.0f\n", $1}')
##############################################################################################
days=$(($tmp8 / 86400 ))
hours=$((($tmp8 / 3600) - (days * 24)))
##############################################################################################

####### Sende Gesamtspeicherplatz in Gigabyte an ioBroker
url_tmp2=$URL_set_MemTotal$tmp2
echo "$url_tmp2"
curl -s $url_tmp2 > /dev/null 2>&1
################################################################################################

####### Sende freien Speicherplatz in Gigabyte an ioBroker
url_tmp3=$URL_set_MemFree$tmp3
echo "$url_tmp3"
curl -s $url_tmp3 > /dev/null 2>&1
################################################################################################

####### Sende belegter Speicherplatz in Gigabyte an ioBroker
url_tmp4=$URL_set_MemUsed$tmp4
echo "$url_tmp4"
curl -s $url_tmp4 > /dev/null 2>&1
################################################################################################

####### Sende Gesamtspeicherplatz in Gigabyte an ioBroker
url_tmp10=$URL_set_StorageTotal$tmp10
echo "$url_tmp10"
curl -s $url_tmp10 > /dev/null 2>&1
################################################################################################

####### Sende freien Speicherplatz in Gigabyte an ioBroker
url_tmp11=$URL_set_StorageFree$tmp11
echo "$url_tmp11"
curl -s $url_tmp11 > /dev/null 2>&1
################################################################################################

####### Sende belegter Speicherplatz in Gigabyte an ioBroker
url_tmp12=$URL_set_StorageUsed$tmp12
echo "$url_tmp12"
curl -s $url_tmp12 > /dev/null 2>&1
################################################################################################

####### Sende freien Speicherplatz in Prozent an ioBroker
url_tmp5=$URL_set_load1Min$tmp5
echo "$url_tmp5"
curl -s $url_tmp5 > /dev/null 2>&1
################################################################################################

####### Sende belegter Speicherplatz in Prozent an ioBroker
url_tmp6=$URL_set_load5Min$tmp6
echo "$url_tmp6"
curl -s $url_tmp6 > /dev/null 2>&1
################################################################################################

####### Sende belegter Speicherplatz in Prozent an ioBroker
url_tmp7=$URL_set_load15Min$tmp7
echo "$url_tmp7"
curl -s $url_tmp7 > /dev/null 2>&1
################################################################################################

####### Sende UpTime an ioBroker
url_days=$URL_set_Uptime_day$days
echo "$url_days"
curl -s $url_days > /dev/null 2>&1
################################################################################################
url_hours=$URL_set_Uptime_hour$hours
echo "$url_hours"
curl -s $url_hours > /dev/null 2>&1
################################################################################################

Gruß

Johnny

PrinzEisenherz1

Hab mal auf Version 1.6.1 downgegraded und da gibt es die Probleme nicht!

Gruß

Johnny

apollon77

Hi, sorry für die Wartezeit … bitte versuch die Github Version nochmal. Habe noch was gefunden.

Zuerst wurden alle Typen und Indizes aus der DB eingelesen nur um das dann grad wieder zu überschreiben

Wenn immer noch blöd dann bitte wieder log.

Das muss zu fixen sein

apollon77

@PrinzEisenherz1: kamst Du schon zum testen der Github Version?

Segway

@Apollon77:

Habe ebenso das Problem mit Duplicate Entry mit meiner NAS SQL-DB.

Bin auch an der Lösung interessiert. Habe mir mal ein Lesezeichen gesetzt.

2018-08-20 06:25:28.243  - [31merror[39m: sql.0 Cannot insert INSERT INTO `iobroker`.ts_bool (id, ts, val, ack, _from, q) VALUES(1760, 1970000, false, 1, 4, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1760-1970000' for key 'PRIMARY'

oder möchtest du das ich das teste ? habe aber kein Testsystem, kann ich nur auf meinem Prod. System machen.

Segway

Welchen verwharungsort muss ich einstellen um die version 1.9.3 zu bekommen ?

NEWS

SQL-Fehlermeldung bei Neustart "Duplicate entry"

Support us

937
Online

31.9k
Users

80.1k
Topics

1.3m
Posts

NEWS

SQL-Fehlermeldung bei Neustart "Duplicate entry"

Support us

937Online

31.9kUsers

80.1kTopics

1.3mPosts

937
Online

31.9k
Users

80.1k
Topics

1.3m
Posts