NEWS
Adapter SQL - SQLITE_CANTOPEN: unable to open database file
-
Hallo zusammen,
nachdem ich einen Stromausfall hatte, funktioniert mein SQL Adapte auf dem BananaPi nicht mehr - im Log steht folgende Meldung:
! 2019-02-01 22:00:00.164 - error: sql.0 Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(6, 1549054800108, '-42.2', 0, 2, 0);: Error: SQLITE_CANTOPEN: unable to open database file
! 2019-02-01 22:00:00.179 - error: sql.0 Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(7, 1549054800111, '301', 0, 2, 0);: Error: SQLITE_CANTOPEN: unable to open database file
! 2019-02-01 22:00:00.392 - error: sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(12, 1549054799380, 25059, 1, 2, 0);: Error: SQLITE_CANTOPEN: unable to open database file
! 2019-02-01 22:00:00.406 - error: sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(18, 1549054799390, 1980, 1, 2, 0);: Error: SQLITE_CANTOPEN: unable to open database file
! 2019-02-01 22:00:00.951 - error: sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(23, 1549054799936, -27.814672438356354, 1, 2, 0);: Error: SQLITE_CANTOPEN: unable to open database file
! 2019-02-01 22:00:05.731 - info: ical.0 starting. Version 1.7.0 in /opt/iobroker/node_modules/iobroker.ical, node: v8.14.0
! 2019-02-01 22:00:06.138 - error: sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(13, 1549054805129, 0, 1, 3, 0);: Error: SQLITE_CANTOPEN: unable to open database file
! 2019-02-01 22:00:06.144 - error: sql.0 Cannot delete DELETE FROM ts_number WHERE id=13 AND ts < 1547845200138;: Error: SQLITE_CANTOPEN: unable to open database file
! 2019-02-01 22:00:06.465 - info: ical.0 processing URL: Müllabfuhr https://calendar.google.com/calendar/ic … /basic.ics
! 2019-02-01 22:00:07.690 - info: ical.0 processing URL: ItaloBrothers https://calendar.google.com/calendar/ic ... /basic.ics
! 2019-02-01 22:00:09.953 - error: sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(14, 1549054808940, 0, 1, 3, 0);: Error: SQLITE_CANTOPEN: unable to open database file
! 2019-02-01 22:00:09.964 - error: sql.0 Cannot delete DELETE FROM ts_number WHERE id=14 AND ts < 1547845200954;: Error: SQLITE_CANTOPEN: unable to open database fileDer Adapater scheint aber zu laufen bzw. die Verbindung scheint zu stehen. Was kann ich da machen?
6907_bildschirmfoto_2019-02-01_um_22.06.33.png
6907_bildschirmfoto_2019-02-01_um_22.06.27.png