Neuer ioBroker-Blog online: Monatsrückblick März/April 2026

[Aiouh]

Hallo, ich möchte Messwerte meiner Homematic (HM) aufzeichnen und als Verlaufsdiagramme via iobroker darstellen.
Die Daten sollen am Ende in einer MySQL Datenbank auf einem remoteserver abgelegt werden.
HM ist verbunden, Werte, z.B. Temperaturen kann ich abfregen.
Nun dachte ich "einfach" mal den SQL und den History Adapter installieren, danach mit Flot die Charts basteln.
Die Installation des SQL Adapters läuft zwar durch, mit zig Warnungen, ich kann den SQL Adapter aber nirgendwo konfigurieren, z.B. meine remote DB und Server IP eintragen. Er ist unter Adapter zu sehen, Instanzen hat er keine.
Ich habe den Adapter nochmal deinstalliert und dann neu installiert, dann friert der raspi während der Installation ein :o(

2020-01-06 08:47:55.469 - info: host.iobroker-pi iobroker add sql --host iobroker-pi
2020-01-06 08:47:59.290 - info: host.iobroker-pi iobroker NPM version: 6.13.4
2020-01-06 08:47:59.293 - info: host.iobroker-pi iobroker npm install iobroker.sql@1.9.4 --loglevel error --prefix "/opt/iobroker" (System call)
2020-01-06 08:49:23.000 - info: host.iobroker-pi iobroker In file included from ../src/binding.cc:3:../../nan/nan.h: In function ‘void Nan::AsyncQueueWorker(Nan::AsyncWorker*)’:../../nan/nan.h:2298:62: warning: cast between incompatible function types from ‘void (*)(uv_work_t*)’ {aka ‘void (*)(uv_work_s*)’} to ‘uv_after_work_cb’ {aka ‘void (*)(uv_work_s*, int)’} [-Wcast-function-type] , reinterpret_cast(AsyncExecuteComplete) ^
2020-01-06 08:49:23.109 - info: host.iobroker-pi iobroker ../src/binding.cc: In static member function ‘static void Magic::DetectFile(const Nan::FunctionCallbackInfo&)’:../src/binding.cc:184:59: warning: cast between incompatible function types from ‘void (*)(uv_work_t*)’ {aka ‘void (*)(uv_work_s*)’} to ‘uv_after_work_cb’ {aka ‘void (*)(uv_work_s*, int)’} [-Wcast-function-type] (uv_after_work_cb)Magic::DetectAfter); ^~~~~~~~~~~
2020-01-06 08:49:23.115 - info: host.iobroker-pi iobroker ../src/binding.cc: In static member function ‘static void Magic::Detect(const Nan::FunctionCallbackInfo&)’:../src/binding.cc:217:59: warning: cast between incompatible function types from ‘void (*)(uv_work_t*)’ {aka ‘void (*)(uv_work_s*)’} to ‘uv_after_work_cb’ {aka ‘void (*)(uv_work_s*, int)’} [-Wcast-function-type] (uv_after_work_cb)Magic::DetectAfter); ^~~~~~~~~~~
2020-01-06 08:49:23.138 - info: host.iobroker-pi iobroker In file included from ../src/binding.cc:1:../src/binding.cc: At global scope:/home/iobroker/.cache/node-gyp/10.18.0/include/node/node.h:573:43: warning: cast between incompatible function types from ‘void (*)(v8::Local)’ to ‘node::addon_register_func’ {aka ‘void (*)(v8::Local, v8::Local, void*)’} [-Wcast-function-type] (node::addon_register_func) (regfunc), \ ^/home/iobroker/.cache/node-gyp/10.18.0/include/node/node.h:607:3: note: in expansion of macro ‘NODE_MODULE_X’ NODE_MODULE_X(modname, regfunc, NULL, 0) // NOLINT (readability/null_usage) ^~~~~~~~~~~~~../src/binding.cc:415:3: note: in expansion of macro ‘NODE_MODULE’ NODE_MODULE(magic, init); ^~~~~~~~~~~
2020-01-06 08:49:23.267 - info: host.iobroker-pi iobroker In file included from /home/iobroker/.cache/node-gyp/10.18.0/include/node/node.h:63, from ../src/binding.cc:1:/home/iobroker/.cache/node-gyp/10.18.0/include/node/v8.h: In instantiation of ‘void v8::PersistentBase::SetWeak(P*, typename v8::WeakCallbackInfo

::Callback, v8::WeakCallbackType) [with P = node::ObjectWrap; T = v8::Object; typename v8::WeakCallbackInfo

::Callback = void (*)(const v8::WeakCallbackInfo&)]’:/home/iobroker/.cache/node-gyp/10.18.0/include/node/node_object_wrap.h:84:78: required from here/home/iobroker/.cache/node-gyp/10.18.0/include/node/v8.h:9502:16: warning: cast between incompatible function types from ‘v8::WeakCallbackInfo::Callback’ {aka ‘void (*)(const v8::WeakCallbackInfo&)’} to ‘Callback’ {aka ‘void (*)(const v8::WeakCallbackInfo&)’} [-Wcast-function-type] reinterpret_cast(callback), type); ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:49:23.317 - info: host.iobroker-pi iobroker /home/iobroker/.cache/node-gyp/10.18.0/include/node/v8.h: In instantiation of ‘void v8::PersistentBase::SetWeak(P*, typename v8::WeakCallbackInfo

::Callback, v8::WeakCallbackType) [with P = Nan::ObjectWrap; T = v8::Object; typename v8::WeakCallbackInfo

::Callback = void (*)(const v8::WeakCallbackInfo&)]’:../../nan/nan_object_wrap.h:65:61: required from here/home/iobroker/.cache/node-gyp/10.18.0/include/node/v8.h:9502:16: warning: cast between incompatible function types from ‘v8::WeakCallbackInfo::Callback’ {aka ‘void (*)(const v8::WeakCallbackInfo&)’} to ‘Callback’ {aka ‘void (*)(const v8::WeakCallbackInfo&)’} [-Wcast-function-type]
2020-01-06 08:49:33.610 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘strftimeFunc’:
2020-01-06 08:49:33.612 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:14234:27: warning: cast between incompatible function types from ‘int (*)(void *)’ to ‘void (*)(void *)’ [-Wcast-function-type] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) ^Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:22212:52: note: in expansion of macro ‘SQLITE_DYNAMIC’ z==zBuf ? SQLITE_TRANSIENT : SQLITE_DYNAMIC); ^~~~~~~~~~~~~~
2020-01-06 08:49:33.981 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3ErrorWithMsg’:
2020-01-06 08:49:33.986 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:14234:27: warning: cast between incompatible function types from ‘int (*)(void *)’ to ‘void (*)(void *)’ [-Wcast-function-type] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) ^Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:30555:54: note: in expansion of macro ‘SQLITE_DYNAMIC’ sqlite3ValueSetStr(db->pErr, -1, z, SQLITE_UTF8, SQLITE_DYNAMIC); ^~~~~~~~~~~~~~
2020-01-06 08:49:38.001 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3VdbeMemSetStr’:
2020-01-06 08:49:38.020 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:14234:27: warning: cast between incompatible function types from ‘int (*)(void *)’ to ‘void (*)(void *)’ [-Wcast-function-type] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) ^Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:75784:15: note: in expansion of macro ‘SQLITE_DYNAMIC’ if( xDel==SQLITE_DYNAMIC ){ ^~~~~~~~~~~~~~
2020-01-06 08:49:38.098 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘valueFromExpr’:
2020-01-06 08:49:38.118 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:14234:27: warning: cast between incompatible function types from ‘int (*)(void *)’ to ‘void (*)(void *)’ [-Wcast-function-type] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) ^Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:76190:55: note: in expansion of macro ‘SQLITE_DYNAMIC’ sqlite3ValueSetStr(pVal, -1, zVal, SQLITE_UTF8, SQLITE_DYNAMIC); ^~~~~~~~~~~~~~
2020-01-06 08:49:38.191 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:14234:27: warning: cast between incompatible function types from ‘int (*)(void *)’ to ‘void (*)(void *)’ [-Wcast-function-type] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) ^Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:76238:29: note: in expansion of macro ‘SQLITE_DYNAMIC’ 0, SQLITE_DYNAMIC); ^~~~~~~~~~~~~~
2020-01-06 08:49:42.263 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3VdbeExec’:
2020-01-06 08:49:42.274 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:91559:38: warning: cast between incompatible function types from ‘int (*)(u32, void *, void *, void *)’ {aka ‘int (*)(unsigned int, void *, void *, void *)’} to ‘void (*)(void *, const char *)’ [-Wcast-function-type] void (*x)(void*,const char*) = (void(*)(void*,const char*))db->xTrace; ^
2020-01-06 08:49:51.573 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘printfFunc’:
2020-01-06 08:49:51.622 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:14234:27: warning: cast between incompatible function types from ‘int (*)(void *)’ to ‘void (*)(void *)’ [-Wcast-function-type] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) ^Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:114219:25: note: in expansion of macro ‘SQLITE_DYNAMIC’ SQLITE_DYNAMIC); ^~~~~~~~~~~~~~
2020-01-06 08:49:56.870 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘generateColumnNames’:
2020-01-06 08:49:56.906 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:14234:27: warning: cast between incompatible function types from ‘int (*)(void *)’ to ‘void (*)(void *)’ [-Wcast-function-type] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) ^Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:127513:58: note: in expansion of macro ‘SQLITE_DYNAMIC’ sqlite3VdbeSetColName(v, i, COLNAME_NAME, zName, SQLITE_DYNAMIC); ^~~~~~~~~~~~~~
2020-01-06 08:49:56.942 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:14234:27: warning: cast between incompatible function types from ‘int (*)(void *)’ to ‘void (*)(void *)’ [-Wcast-function-type] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize) ^Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:127520:52: note: in expansion of macro ‘SQLITE_DYNAMIC’ sqlite3VdbeSetColName(v, i, COLNAME_NAME, z, SQLITE_DYNAMIC); ^~~~~~~~~~~~~~
2020-01-06 08:50:00.025 - info: host.iobroker-pi instance system.adapter.luftdaten.1 started with pid 2714
2020-01-06 08:50:03.913 - info: luftdaten.1 (2714) starting. Version 0.0.9 in /opt/iobroker/node_modules/iobroker.luftdaten, node: v10.18.0
2020-01-06 08:50:04.048 - info: host.iobroker-pi instance system.adapter.luftdaten.0 started with pid 2738
2020-01-06 08:50:07.361 - info: luftdaten.0 (2738) starting. Version 0.0.9 in /opt/iobroker/node_modules/iobroker.luftdaten, node: v10.18.0
2020-01-06 08:50:08.660 - warn: luftdaten.1 (2714) Error: ESOCKETTIMEDOUT
2020-01-06 08:50:12.094 - warn: luftdaten.0 (2738) Error: ESOCKETTIMEDOUT
2020-01-06 08:50:14.001 - info: luftdaten.1 (2714) Terminated (NO_ERROR): Without reason
2020-01-06 08:50:14.062 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3InvokeBusyHandler’:
2020-01-06 08:50:14.085 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:157821:12: warning: cast between incompatible function types from ‘int (*)(void *, int)’ to ‘int (*)(void *, int, sqlite3_file *)’ {aka ‘int (*)(void *, int, struct sqlite3_file *)’} [-Wcast-function-type] xTra = (int(*)(void*,int,sqlite3_file*))p->xBusyHandler; ^
2020-01-06 08:50:14.088 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3_busy_timeout’:
2020-01-06 08:50:14.111 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:157899:30: warning: cast between incompatible function types from ‘int (*)(void *, int, sqlite3_file *)’ {aka ‘int (*)(void *, int, struct sqlite3_file *)’} to ‘int (*)(void *, int)’ [-Wcast-function-type] sqlite3_busy_handler(db, (int(*)(void*,int))sqliteDefaultBusyCallback, ^
2020-01-06 08:50:14.253 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3_trace’:
2020-01-06 08:50:14.275 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:158242:16: warning: cast between incompatible function types from ‘void (*)(void *, const char *)’ to ‘int (*)(u32, void *, void *, void *)’ {aka ‘int (*)(unsigned int, void *, void *, void *)’} [-Wcast-function-type] db->xTrace = (int(*)(u32,void*,void*,void*))xTrace; ^
2020-01-06 08:50:14.522 - info: host.iobroker-pi instance system.adapter.luftdaten.1 terminated with code 0 (NO_ERROR)
2020-01-06 08:50:17.455 - info: luftdaten.0 (2738) Terminated (NO_ERROR): Without reason
2020-01-06 08:50:17.979 - info: host.iobroker-pi instance system.adapter.luftdaten.0 terminated with code 0 (NO_ERROR)
2020-01-06 08:50:54.703 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3_db_status’:Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:21035:10: warning: this statement may fall through [-Wimplicit-fallthrough=] op = SQLITE_DBSTATUS_CACHE_WRITE+1; ~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:21037:5: note: here case SQLITE_DBSTATUS_CACHE_HIT: ^~~~
2020-01-06 08:50:54.759 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3_str_vappendf’:
2020-01-06 08:50:54.762 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:27799:19: warning: this statement may fall through [-Wimplicit-fallthrough=] flag_long = sizeof(char*)==sizeof(i64) ? 2 : ~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ sizeof(char*)==sizeof(long int) ? 1 : 0; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:54.767 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:27802:7: note: here case etORDINAL: ^~~~Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:27804:19: warning: this statement may fall through [-Wimplicit-fallthrough=] cThousand = 0; ~~~~~~~~~~^~~Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:27806:7: note: here case etDECIMAL: ^~~~
2020-01-06 08:50:55.080 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3GetToken’:
2020-01-06 08:50:55.123 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:155400:9: warning: this statement may fall through [-Wimplicit-fallthrough=] if( !sqlite3Isdigit(z[1]) ) ^
2020-01-06 08:50:55.150 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:155409:5: note: here case CC_DIGIT: { ^~~~
2020-01-06 08:50:55.167 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:155499:9: warning: this statement may fall through [-Wimplicit-fallthrough=] if( z[1]=='\'' ){ ^
2020-01-06 08:50:55.189 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:155513:5: note: here case CC_ID: { ^~~~
2020-01-06 08:50:55.248 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3ExprCodeTarget’:
2020-01-06 08:50:55.274 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:101035:25: warning: this statement may fall through [-Wimplicit-fallthrough=] case TK_AGG_COLUMN: { ^
2020-01-06 08:50:55.287 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:101048:5: note: here case TK_COLUMN: { ^~~~
2020-01-06 08:50:55.356 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘resolveP2Values’:
2020-01-06 08:50:55.374 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:77303:13: warning: this statement may fall through [-Wimplicit-fallthrough=] if( pOp->p2!=0 ) p->readOnly = 0; ^
2020-01-06 08:50:55.383 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:77306:9: note: here case OP_AutoCommit: ^~~~
2020-01-06 08:50:55.392 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:77344:26: warning: this statement may fall through [-Wimplicit-fallthrough=] case OP_VFilter: { ^
2020-01-06 08:50:55.402 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:77353:9: note: here default: { ^~~~~~~
2020-01-06 08:50:55.497 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘resolveExprStep’:
2020-01-06 08:50:55.512 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:96674:20: warning: this statement may fall through [-Wimplicit-fallthrough=] case TK_ISNOT: { ^
2020-01-06 08:50:55.524 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:96690:5: note: here case TK_BETWEEN: ^~~~
2020-01-06 08:50:55.582 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘impliesNotNullRow’:
2020-01-06 08:50:55.597 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:102715:8: warning: this statement may fall through [-Wimplicit-fallthrough=] if( (pExpr->pLeft->op==TK_COLUMN && IsVirtual(pExpr->pLeft->y.pTab)) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ || (pExpr->pRight->op==TK_COLUMN && IsVirtual(pExpr->pRight->y.pTab)) ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:55.610 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:102720:5: note: here default: ^~~~~~~
2020-01-06 08:50:55.719 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘exprImpliesNotNull’:
2020-01-06 08:50:55.745 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:102582:9: warning: this statement may fall through [-Wimplicit-fallthrough=] if( exprImpliesNotNull(pParse, p->pRight, pNN, iTab, seenNot) ) return 1; ^
2020-01-06 08:50:55.758 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:102585:5: note: here case TK_SPAN: ^~~~
2020-01-06 08:50:55.864 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘fkActionTrigger’:
2020-01-06 08:50:55.882 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:117309:11: warning: this statement may fall through [-Wimplicit-fallthrough=] if( !pChanges ){ ^
2020-01-06 08:50:55.898 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:117313:7: note: here default: ^~~~~~~
2020-01-06 08:50:55.916 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3GenerateConstraintChecks’:
2020-01-06 08:50:55.931 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:118782:17: warning: this statement may fall through [-Wimplicit-fallthrough=] onError = OE_Abort; ^
2020-01-06 08:50:55.947 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:118786:7: note: here case OE_Abort: ^~~~
2020-01-06 08:50:55.964 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:118944:17: warning: this statement may fall through [-Wimplicit-fallthrough=] onError = OE_Abort; ^
2020-01-06 08:50:55.980 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:118947:7: note: here case OE_Rollback: ^~~~
2020-01-06 08:50:55.996 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:119007:9: warning: this statement may fall through [-Wimplicit-fallthrough=] sqlite3UpsertDoUpdate(pParse, pUpsert, pTab, 0, iDataCur); ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:56.012 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:119011:7: note: here case OE_Ignore: { ^~~~
2020-01-06 08:50:56.030 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:119223:9: warning: this statement may fall through [-Wimplicit-fallthrough=] sqlite3UpsertDoUpdate(pParse, pUpsert, pTab, pIdx, iIdxCur+ix); ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:56.046 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:119227:7: note: here case OE_Ignore: { ^~~~
2020-01-06 08:50:56.222 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘sqlite3VdbeExec’:
2020-01-06 08:50:56.243 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:84944:5: warning: this statement may fall through [-Wimplicit-fallthrough=] if( (pIn3->flags & MEM_Null)==0 ) break; ^
2020-01-06 08:50:56.253 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:84978:1: note: here case OP_Halt: { ^~~~
2020-01-06 08:50:56.266 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:85113:15: warning: this statement may fall through [-Wimplicit-fallthrough=] pOp->opcode = OP_String; ^
2020-01-06 08:50:56.280 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:85130:1: note: here case OP_String: { /* out2 */ ^~~~
2020-01-06 08:50:56.287 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:88339:19: warning: this statement may fall through [-Wimplicit-fallthrough=] case OP_IfNoHope: { /* jump, in3 */ ^
2020-01-06 08:50:56.297 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:88347:1: note: here case OP_NoConflict: /* jump, in3 */ ^~~~
2020-01-06 08:50:56.309 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:89268:38: warning: this statement may fall through [-Wimplicit-fallthrough=] p->aCounter[SQLITE_STMTSTATUS_SORT]++; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^~
2020-01-06 08:50:56.320 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:89283:1: note: here case OP_Rewind: { /* jump */ ^~~~
2020-01-06 08:50:56.331 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:90580:15: warning: this statement may fall through [-Wimplicit-fallthrough=] pOp->opcode = OP_AggStep1; ^
2020-01-06 08:50:56.343 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:90583:1: note: here case OP_AggStep1: { ^~~~
2020-01-06 08:50:56.354 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:91452:15: warning: this statement may fall through [-Wimplicit-fallthrough=] pOp->opcode += 2; ~~~~~~~~~~~~^~~~
2020-01-06 08:50:56.366 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:91455:1: note: here case OP_PureFunc: /* group */ ^~~~
2020-01-06 08:50:57.098 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘fts3SnippetFunc’:
2020-01-06 08:50:57.134 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:165599:22: warning: this statement may fall through [-Wimplicit-fallthrough=] case 6: nToken = sqlite3_value_int(apVal[5]); ^~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:57.158 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:165600:5: note: here case 5: iCol = sqlite3_value_int(apVal[4]); ^~~~
2020-01-06 08:50:57.204 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:165600:20: warning: this statement may fall through [-Wimplicit-fallthrough=] case 5: iCol = sqlite3_value_int(apVal[4]); ^~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:57.228 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:165601:5: note: here case 4: zEllipsis = (const char*)sqlite3_value_text(apVal[3]); ^~~~
2020-01-06 08:50:57.271 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:165601:38: warning: this statement may fall through [-Wimplicit-fallthrough=] case 4: zEllipsis = (const char*)sqlite3_value_text(apVal[3]); ^~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:57.292 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:165602:5: note: here case 3: zEnd = (const char*)sqlite3_value_text(apVal[2]); ^~~~
2020-01-06 08:50:57.332 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:165602:33: warning: this statement may fall through [-Wimplicit-fallthrough=] case 3: zEnd = (const char*)sqlite3_value_text(apVal[2]); ^~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:57.353 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:165603:5: note: here case 2: zStart = (const char*)sqlite3_value_text(apVal[1]); ^~~~
2020-01-06 08:50:57.401 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘fts3ColumnMethod’:
2020-01-06 08:50:57.448 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:165356:14: warning: this statement may fall through [-Wimplicit-fallthrough=] iCol = p->nColumn; ~~~~~^~~~~~~~~~~~
2020-01-06 08:50:57.472 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:165360:5: note: here default: ^~~~~~~
2020-01-06 08:50:57.564 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘cellArea’:
2020-01-06 08:50:57.590 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184885:22: warning: this statement may fall through [-Wimplicit-fallthrough=] case 5: area = p->aCoord[9].f - p->aCoord[8].f; ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:57.613 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184886:7: note: here case 4: area *= p->aCoord[7].f - p->aCoord[6].f; ^~~~
2020-01-06 08:50:57.659 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184886:21: warning: this statement may fall through [-Wimplicit-fallthrough=] case 4: area *= p->aCoord[7].f - p->aCoord[6].f; ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:57.686 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184887:7: note: here case 3: area *= p->aCoord[5].f - p->aCoord[4].f; ^~~~
2020-01-06 08:50:57.739 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184887:21: warning: this statement may fall through [-Wimplicit-fallthrough=] case 3: area *= p->aCoord[5].f - p->aCoord[4].f; ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:57.765 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184888:7: note: here case 2: area *= p->aCoord[3].f - p->aCoord[2].f; ^~~~
2020-01-06 08:50:57.818 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184888:21: warning: this statement may fall through [-Wimplicit-fallthrough=] case 2: area *= p->aCoord[3].f - p->aCoord[2].f; ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:57.845 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184889:7: note: here default: area *= p->aCoord[1].f - p->aCoord[0].f; ^~~~~~~
2020-01-06 08:50:57.872 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184895:22: warning: this statement may fall through [-Wimplicit-fallthrough=] case 5: area = (i64)p->aCoord[9].i - (i64)p->aCoord[8].i; ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:57.898 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184896:7: note: here case 4: area *= (i64)p->aCoord[7].i - (i64)p->aCoord[6].i; ^~~~
2020-01-06 08:50:57.952 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184896:21: warning: this statement may fall through [-Wimplicit-fallthrough=] case 4: area *= (i64)p->aCoord[7].i - (i64)p->aCoord[6].i; ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:57.978 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184897:7: note: here case 3: area *= (i64)p->aCoord[5].i - (i64)p->aCoord[4].i; ^~~~
2020-01-06 08:50:58.032 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184897:21: warning: this statement may fall through [-Wimplicit-fallthrough=] case 3: area *= (i64)p->aCoord[5].i - (i64)p->aCoord[4].i; ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:58.058 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184898:7: note: here case 2: area *= (i64)p->aCoord[3].i - (i64)p->aCoord[2].i; ^~~~
2020-01-06 08:50:58.111 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184898:21: warning: this statement may fall through [-Wimplicit-fallthrough=] case 2: area *= (i64)p->aCoord[3].i - (i64)p->aCoord[2].i; ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-01-06 08:50:58.137 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184899:7: note: here default: area *= (i64)p->aCoord[1].i - (i64)p->aCoord[0].i; ^~~~~~~
2020-01-06 08:50:58.161 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘rtreeCallbackConstraint’:
2020-01-06 08:50:58.214 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184056:56: warning: this statement may fall through [-Wimplicit-fallthrough=] readCoord(pCellData+32, &c); aCoord[8] = c.f; ~~~~~~~~~~^~~~~
2020-01-06 08:50:58.240 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184057:7: note: here case 8: readCoord(pCellData+28, &c); aCoord[7] = c.f; ^~~~
2020-01-06 08:50:58.266 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184058:56: warning: this statement may fall through [-Wimplicit-fallthrough=] readCoord(pCellData+24, &c); aCoord[6] = c.f; ~~~~~~~~~~^~~~~
2020-01-06 08:50:58.293 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184059:7: note: here case 6: readCoord(pCellData+20, &c); aCoord[5] = c.f; ^~~~
2020-01-06 08:50:58.320 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184060:56: warning: this statement may fall through [-Wimplicit-fallthrough=] readCoord(pCellData+16, &c); aCoord[4] = c.f; ~~~~~~~~~~^~~~~
2020-01-06 08:50:58.346 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184061:7: note: here case 4: readCoord(pCellData+12, &c); aCoord[3] = c.f; ^~~~
2020-01-06 08:50:58.372 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184062:56: warning: this statement may fall through [-Wimplicit-fallthrough=] readCoord(pCellData+8, &c); aCoord[2] = c.f; ~~~~~~~~~~^~~~~
2020-01-06 08:50:58.398 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184063:7: note: here default: readCoord(pCellData+4, &c); aCoord[1] = c.f; ^~~~~~~
2020-01-06 08:50:58.427 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184071:56: warning: this statement may fall through [-Wimplicit-fallthrough=] readCoord(pCellData+32, &c); aCoord[8] = c.i; ~~~~~~~~~~^~~~~
2020-01-06 08:50:58.453 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184072:7: note: here case 8: readCoord(pCellData+28, &c); aCoord[7] = c.i; ^~~~
2020-01-06 08:50:58.479 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184073:56: warning: this statement may fall through [-Wimplicit-fallthrough=] readCoord(pCellData+24, &c); aCoord[6] = c.i; ~~~~~~~~~~^~~~~
2020-01-06 08:50:58.506 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184074:7: note: here case 6: readCoord(pCellData+20, &c); aCoord[5] = c.i; ^~~~
2020-01-06 08:50:58.532 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184075:56: warning: this statement may fall through [-Wimplicit-fallthrough=] readCoord(pCellData+16, &c); aCoord[4] = c.i; ~~~~~~~~~~^~~~~
2020-01-06 08:50:58.559 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184076:7: note: here case 4: readCoord(pCellData+12, &c); aCoord[3] = c.i; ^~~~
2020-01-06 08:50:58.585 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184077:56: warning: this statement may fall through [-Wimplicit-fallthrough=] readCoord(pCellData+8, &c); aCoord[2] = c.i; ~~~~~~~~~~^~~~~
2020-01-06 08:50:58.612 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184078:7: note: here default: readCoord(pCellData+4, &c); aCoord[1] = c.i; ^~~~~~~
2020-01-06 08:50:58.615 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘rtreeNonleafConstraint’:
2020-01-06 08:50:58.641 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184130:9: warning: this statement may fall through [-Wimplicit-fallthrough=] if( p->op!=RTREE_EQ ) break; /* RTREE_LE and RTREE_LT end here */ ^
2020-01-06 08:50:58.667 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:184133:5: note: here default: /* RTREE_GT or RTREE_GE, or fallthrough of RTREE_EQ */ ^~~~~~~
2020-01-06 08:50:58.707 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘jsonRenderNode’:
2020-01-06 08:50:58.758 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:180779:9: warning: this statement may fall through [-Wimplicit-fallthrough=] if( pNode->jnFlags & JNODE_RAW ){ ^
2020-01-06 08:50:58.784 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:180785:5: note: here case JSON_REAL: ^~~~
2020-01-06 08:50:58.797 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘jsonReturn’:
2020-01-06 08:50:58.823 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:180893:7: warning: this statement may fall through [-Wimplicit-fallthrough=] int_as_real: /* fall through to real */; ^~~~~~~~~~~
2020-01-06 08:50:58.848 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:180895:5: note: here case JSON_REAL: { ^~~~
2020-01-06 08:50:58.856 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c: In function ‘jsonEachColumn’:
2020-01-06 08:50:58.883 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:182546:9: warning: this statement may fall through [-Wimplicit-fallthrough=] if( p->bRecursive ){ ^
2020-01-06 08:50:58.909 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:182556:5: note: here default: { ^~~~~~~
2020-01-06 08:18:55.708 - info: host.iobroker-pi iobroker.js-controller version 2.1.1 js-controller starting
2020-01-06 08:18:55.720 - info: host.iobroker-pi Copyright (c) 2014-2019 bluefox, 2014 hobbyquaker
2020-01-06 08:18:55.721 - info: host.iobroker-pi hostname: iobroker-pi, node: v10.18.0
2020-01-06 08:18:55.724 - info: host.iobroker-pi ip addresses: 192.168.178.73 2003:f8:4bc6:f300:10a:c823:9927:3ad2 fe80::6ab1:df9f:e0a9:9269
2020-01-06 08:18:56.775 - info: host.iobroker-pi connected to Objects and States
2020-01-06 08:18:56.979 - info: host.iobroker-pi 31 instances found
2020-01-06 08:18:57.097 - info: host.iobroker-pi starting 25 instances
2020-01-06 08:18:57.193 - info: host.iobroker-pi instance system.adapter.admin.0 started with pid 563
2020-01-06 08:19:01.115 - info: host.iobroker-pi instance system.adapter.discovery.0 started with pid 621
2020-01-06 08:19:01.232 - info: admin.0 (563) starting. Version 3.6.12 in /opt/iobroker/node_modules/iobroker.admin, node: v10.18.0
2020-01-06 08:19:01.375 - info: admin.0 (563) requesting all states
2020-01-06 08:19:01.377 - info: admin.0 (563) requesting all objects
2020-01-06 08:19:04.198 - info: admin.0 (563) received all objects
2020-01-06 08:19:04.556 - info: discovery.0 (621) starting. Version 1.3.0 in /opt/iobroker/node_modules/iobroker.discovery, node: v10.18.0
2020-01-06 08:19:04.576 - info: admin.0 (563) http server listening on port 8081
2020-01-06 08:19:04.577 - info: admin.0 (563) Use link "http://localhost:8081" to configure.
2020-01-06 08:19:05.127 - info: host.iobroker-pi instance system.adapter.info.0 started with pid 675
2020-01-06 08:19:09.121 - info: host.iobroker-pi instance system.adapter.ping.0 started with pid 694
2020-01-06 08:19:11.397 - info: ping.0 (694) starting. Version 1.3.2 in /opt/iobroker/node_modules/iobroker.ping, node: v10.18.0
2020-01-06 08:19:13.130 - info: host.iobroker-pi instance system.adapter.hm-rpc.0 started with pid 714
2020-01-06 08:19:13.298 - info: info.0 (675) starting. Version 1.5.6 in /opt/iobroker/node_modules/iobroker.info, node: v10.18.0
2020-01-06 09:02:34.561 - info: info.0 (675) Popup news was read...
2020-01-06 09:02:35.793 - info: hm-rpc.0 (714) starting. Version 1.12.1 in /opt/iobroker/node_modules/iobroker.hm-rpc, node: v10.18.0
2020-01-06 09:02:36.241 - info: host.iobroker-pi instance system.adapter.hm-rpc.1 started with pid 1126
2020-01-06 09:02:36.233 - info: hm-rpc.0 (714) [META] Meta data updated
2020-01-06 09:02:37.731 - info: hm-rpc.0 (714) binrpc server is trying to listen on 192.168.178.73:18701
2020-01-06 09:02:37.732 - info: hm-rpc.0 (714) binrpc client is trying to connect to 192.168.178.29:8701/ with ["xmlrpc_bin://192.168.178.73:18701","hm-rpc.0"]
2020-01-06 09:02:38.157 - info: hm-rpc.0 (714) binrpc -> listDevices 51
2020-01-06 09:02:38.354 - info: hm-rpc.0 (714) new CUxD devices/channels after filter: 0
2020-01-06 09:02:38.360 - info: hm-rpc.0 (714) Connected
2020-01-06 09:02:39.114 - info: hm-rpc.1 (1126) starting. Version 1.12.1 in /opt/iobroker/node_modules/iobroker.hm-rpc, node: v10.18.0
2020-01-06 09:02:39.479 - info: hm-rpc.1 (1126) [META] Meta data updated
2020-01-06 09:02:40.425 - info: host.iobroker-pi instance system.adapter.hm-rpc.2 started with pid 1177
2020-01-06 09:02:40.888 - info: hm-rpc.1 (1126) binrpc server is trying to listen on 192.168.178.73:12001
2020-01-06 09:02:40.889 - info: hm-rpc.1 (1126) binrpc client is trying to connect to 192.168.178.29:2001/ with ["xmlrpc_bin://192.168.178.73:12001","hm-rpc.1"]
2020-01-06 09:02:40.930 - info: hm-rpc.1 (1126) binrpc <- system.listMethods ["hm-rpc.1"]
2020-01-06 09:02:40.947 - info: hm-rpc.1 (1126) binrpc <- listDevices ["hm-rpc.1"]
2020-01-06 09:02:41.368 - info: hm-rpc.1 (1126) binrpc -> 242 devices
2020-01-06 09:02:42.069 - info: hm-rpc.1 (1126) Connected
2020-01-06 09:02:42.625 - info: hm-rpc.2 (1177) starting. Version 1.12.1 in /opt/iobroker/node_modules/iobroker.hm-rpc, node: v10.18.0
2020-01-06 09:02:42.976 - info: hm-rpc.2 (1177) [META] Meta data updated
2020-01-06 09:02:43.912 - info: hm-rpc.2 (1177) xmlrpc server is trying to listen on 192.168.178.73:12010
2020-01-06 09:02:43.913 - info: hm-rpc.2 (1177) xmlrpc client is trying to connect to 192.168.178.29:2010/ with ["http://192.168.178.73:12010","hm-rpc.2"]
2020-01-06 09:02:44.037 - info: hm-rpc.2 (1177) Connected
2020-01-06 09:02:44.235 - info: host.iobroker-pi instance system.adapter.hm-rega.0 started with pid 1200
2020-01-06 09:02:44.678 - info: hm-rpc.2 (1177) xmlrpc <- listDevices ["hm-rpc.2"]
2020-01-06 09:02:44.754 - info: hm-rpc.2 (1177) xmlrpc -> 0 devices
2020-01-06 09:02:46.662 - info: hm-rpc.2 (1177) xmlrpc <- newDevices 60
2020-01-06 09:02:46.724 - info: hm-rpc.2 (1177) new HmIP devices/channels after filter: 0
2020-01-06 09:02:47.146 - info: hm-rega.0 (1200) starting. Version 2.4.12 in /opt/iobroker/node_modules/iobroker.hm-rega, node: v10.18.0
2020-01-06 09:02:47.206 - info: hm-rega.0 (1200) subscribe hm-rpc.1.BidCoS-RF.50.PRESS_SHORT
2020-01-06 09:02:47.488 - info: hm-rega.0 (1200) ReGaHSS 192.168.178.29 up
2020-01-06 09:02:48.156 - info: hm-rega.0 (1200) time difference local-ccu 1s
2020-01-06 09:02:48.236 - info: host.iobroker-pi instance system.adapter.web.0 started with pid 1217
2020-01-06 09:02:48.239 - info: hm-rega.0 (1200) update favorites to enum.favorites
2020-01-06 09:02:48.369 - info: hm-rega.0 (1200) update functions to enum.functions
2020-01-06 09:02:48.389 - info: hm-rega.0 (1200) hm-rpc.1.LEQ1205873.4 has been added to functions ${funcLight}
2020-01-06 09:02:48.390 - info: hm-rega.0 (1200) hm-rpc.1.LEQ1204999.4 has been removed from functions ${funcLight}
2020-01-06 09:02:48.396 - info: hm-rega.0 (1200) hm-rpc.2.001E1A4998CC9B.1 has been added to functions Türkontakte
2020-01-06 09:02:48.397 - info: hm-rega.0 (1200) hm-rpc.1.MEQ0365208.1 has been added to functions Türkontakte
2020-01-06 09:02:48.398 - info: hm-rega.0 (1200) hm-rpc.1.PEQ0565164.1 has been added to functions Türkontakte
2020-01-06 09:02:48.398 - info: hm-rega.0 (1200) hm-rpc.1.PEQ0565190.1 has been added to functions Türkontakte
2020-01-06 09:02:48.399 - info: hm-rega.0 (1200) hm-rpc.1.PEQ0565163.1 has been added to functions Türkontakte
2020-01-06 09:02:48.400 - info: hm-rega.0 (1200) hm-rpc.1.MEQ0741975.2 has been removed from functions Türkontakte
2020-01-06 09:02:48.401 - info: hm-rega.0 (1200) hm-rpc.1.MEQ0529683.3 has been removed from functions Türkontakte
2020-01-06 09:02:48.401 - info: hm-rega.0 (1200) hm-rpc.1.MEQ0529683.4 has been removed from functions Türkontakte
2020-01-06 09:02:48.402 - info: hm-rega.0 (1200) hm-rpc.1.MEQ0529683.5 has been removed from functions Türkontakte
2020-01-06 09:02:48.403 - info: hm-rega.0 (1200) hm-rpc.1.MEQ0529683.6 has been removed from functions Türkontakte
2020-01-06 09:02:48.406 - info: hm-rega.0 (1200) hm-rpc.1.OEQ0574314.6 has been added to functions Messgeräte
2020-01-06 09:02:48.407 - info: hm-rega.0 (1200) hm-rpc.1.NEQ0863268.1 has been removed from functions Messgeräte
2020-01-06 09:02:48.493 - info: hm-rega.0 (1200) update rooms to enum.rooms
2020-01-06 09:02:48.538 - info: hm-rega.0 (1200) hm-rpc.2.001898A99DC57C.1 has been added to room Keller Heizung
2020-01-06 09:02:48.539 - info: hm-rega.0 (1200) hm-rpc.1.OEQ1018071.1 has been removed from room Keller Heizung
2020-01-06 09:02:49.275 - info: hm-rega.0 (1200) got 83 programs
2020-01-06 09:02:49.653 - info: hm-rega.0 (1200) added/updated 83 programs
2020-01-06 09:02:49.654 - info: hm-rega.0 (1200) deleted 0 programs
2020-01-06 09:02:50.596 - info: hm-rega.0 (1200) got 18 variables
2020-01-06 09:02:50.786 - info: hm-rega.0 (1200) added/updated 18 variables
2020-01-06 09:02:50.787 - info: hm-rega.0 (1200) deleted 0 variables
2020-01-06 09:02:50.789 - info: hm-rega.0 (1200) request state values
2020-01-06 09:02:51.216 - info: web.0 (1217) starting. Version 2.4.10 in /opt/iobroker/node_modules/iobroker.web, node: v10.18.0
2020-01-06 09:02:51.745 - info: web.0 (1217) socket.io server listening on port 8082
2020-01-06 09:02:51.754 - info: web.0 (1217) http server listening on port 8082
2020-01-06 09:02:51.926 - info: hm-rega.0 (1200) got state values
2020-01-06 09:02:52.254 - info: host.iobroker-pi instance system.adapter.javascript.0 started with pid 1232
2020-01-06 09:02:56.250 - info: host.iobroker-pi instance system.adapter.backitup.0 started with pid 1239
2020-01-06 09:02:58.600 - info: javascript.0 (1232) starting. Version 4.1.12 in /opt/iobroker/node_modules/iobroker.javascript, node: v10.18.0
2020-01-06 09:02:58.671 - info: javascript.0 (1232) requesting all states
2020-01-06 09:02:58.675 - info: javascript.0 (1232) requesting all objects
2020-01-06 09:03:00.284 - info: javascript.0 (1232) received all objects
2020-01-06 09:03:00.395 - info: javascript.0 (1232) received all states
2020-01-06 09:03:02.635 - info: vis.0 (1254) starting. Version 1.2.2 in /opt/iobroker/node_modules/iobroker.vis, node: v10.18.0
2020-01-06 09:03:02.921 - info: vis.0 (1254) vis license is OK.
2020-01-06 09:03:04.253 - info: host.iobroker-pi instance system.adapter.iqontrol.0 started with pid 1273
2020-01-06 09:03:04.408 - info: backitup.0 (1239) starting. Version 1.3.6 in /opt/iobroker/node_modules/iobroker.backitup, node: v10.18.0
2020-01-06 09:03:04.772 - error: backitup.0 (1239) Error: Command failed: mount :/sharename/backupDir /opt/iobroker/backups
mount: only root can do that
2020-01-06 09:03:05.838 - info: vis.0 (1254) Terminated (NO_ERROR): Without reason
2020-01-06 09:03:06.379 - info: host.iobroker-pi instance system.adapter.vis.0 terminated while should be started once
2020-01-06 09:03:06.743 - info: iqontrol.0 (1273) starting. Version 0.2.14 in /opt/iobroker/node_modules/iobroker.iqontrol, node: v10.18.0
2020-01-06 09:03:06.785 - info: iqontrol.0 (1273) Creating Toolbar...
2020-01-06 09:03:06.790 - info: iqontrol.0 (1273) Creating Views...
2020-01-06 09:03:06.792 - info: iqontrol.0 (1273) Creating Options...
2020-01-06 09:03:06.859 - info: iqontrol.0 (1273) Deleting unused Objects...
2020-01-06 09:03:08.276 - info: host.iobroker-pi instance system.adapter.modbus.0 started with pid 1294
2020-01-06 09:03:10.774 - info: modbus.0 (1294) starting. Version 2.0.9 in /opt/iobroker/node_modules/iobroker.modbus, node: v10.18.0
2020-01-06 09:03:11.438 - info: modbus.0 (1294) Connected to slave 192.168.178.82
2020-01-06 09:03:12.278 - info: host.iobroker-pi instance system.adapter.musiccast.0 started with pid 1312
2020-01-06 09:03:14.784 - debug: musiccast.0 (1312) Redis Objects: Use Redis connection: 127.0.0.1:9001
2020-01-06 09:03:14.844 - debug: musiccast.0 (1312) Objects client ready ... initialize now
2020-01-06 09:03:14.851 - debug: musiccast.0 (1312) Objects create PubSub Client
2020-01-06 09:03:14.853 - debug: musiccast.0 (1312) Objects client initialize lua scripts
2020-01-06 09:03:14.888 - debug: musiccast.0 (1312) objectDB connected
2020-01-06 09:03:14.893 - debug: musiccast.0 (1312) Redis States: Use Redis connection: 127.0.0.1:9000
2020-01-06 09:03:14.899 - debug: musiccast.0 (1312) Objects connected to redis: 127.0.0.1:9001
2020-01-06 09:03:14.909 - debug: musiccast.0 (1312) States create PubSub Client
2020-01-06 09:03:14.911 - debug: musiccast.0 (1312) statesDB connected
2020-01-06 09:03:14.982 - debug: musiccast.0 (1312) States connected to redis: 127.0.0.1:9000
2020-01-06 09:03:15.842 - info: musiccast.0 (1312) starting. Version 0.0.8 in /opt/iobroker/node_modules/iobroker.musiccast, node: v10.18.0
2020-01-06 09:03:15.897 - info: musiccast.0 (1312) Setting up NetUSB of :WXAD-10-0701E403
2020-01-06 09:03:15.933 - info: musiccast.0 (1312) socket listening
2020-01-06 09:03:16.276 - info: host.iobroker-pi instance scheduled system.adapter.luftdaten.0 */5 * * * *
2020-01-06 09:03:20.260 - info: host.iobroker-pi instance scheduled system.adapter.luftdaten.1 */5 * * * *
2020-01-06 09:03:24.263 - info: host.iobroker-pi instance system.adapter.modbus.1 started with pid 1327
2020-01-06 09:03:26.539 - info: modbus.1 (1327) starting. Version 2.0.9 in /opt/iobroker/node_modules/iobroker.modbus, node: v10.18.0
2020-01-06 09:03:27.078 - info: modbus.1 (1327) Connected to slave 192.168.178.82
2020-01-06 09:05:00.043 - info: host.iobroker-pi instance system.adapter.luftdaten.1 started with pid 1390
2020-01-06 09:05:02.695 - info: luftdaten.1 (1390) starting. Version 0.0.9 in /opt/iobroker/node_modules/iobroker.luftdaten, node: v10.18.0
2020-01-06 09:05:04.061 - info: host.iobroker-pi instance system.adapter.luftdaten.0 started with pid 1420
2020-01-06 09:05:06.464 - info: luftdaten.0 (1420) starting. Version 0.0.9 in /opt/iobroker/node_modules/iobroker.luftdaten, node: v10.18.0
2020-01-06 09:05:07.381 - warn: luftdaten.1 (1390) Error: ESOCKETTIMEDOUT
2020-01-06 09:05:11.162 - warn: luftdaten.0 (1420) Error: ESOCKETTIMEDOUT
2020-01-06 09:05:12.770 - info: luftdaten.1 (1390) Terminated (NO_ERROR): Without reason
2020-01-06 09:05:13.304 - info: host.iobroker-pi instance system.adapter.luftdaten.1 terminated with code 0 (NO_ERROR)
2020-01-06 09:05:16.551 - info: luftdaten.0 (1420) Terminated (NO_ERROR): Without reason
2020-01-06 09:05:17.082 - info: host.iobroker-pi instance system.adapter.luftdaten.0 terminated with code 0 (NO_ERROR)
2020-01-06 09:05:42.634 - debug: musiccast.0 (1312) system.adapter.admin.0: logging true

[arteck]

@Aiouh kannst du das bitte formatieren.. das kann doch keiner lesen

[Aiouh]

Ist das besser so ? (Und sorry !)
Warum Teile durchgestrichen sind weiss ich leider nicht :(

[OliverIO]

@Aiouh er meint das du um das logfile die code Tags setzt, so dass es dan so aussieht
Der Knopf sieht ungefähr so aus </>

Log

[Aiouh]

Danke, nun hab ich es doch noch begriffen !

[arteck]

@Aiouh sagte in kann SQL adapter nicht konfigurieren:

2020-01-06 08:50:58.883 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:182546:9: warning: this statement may fall through [-Wimplicit-fallthrough=] if( p->bRecursive ){ ^
2020-01-06 08:50:58.909 - info: host.iobroker-pi iobroker Release/obj/gen/sqlite-autoconf-3300100/sqlite3.c:182556:5: note: here default: { ^~~~~~~
2020-01-06 08:18:55.708 - info: host.iobroker-pi iobroker.js-controller version 2.1.1 js-controller starting
2020-01-06 08:18:55.720 - info: host.iobroker-pi Copyright (c) 2014-2019 bluefox, 2014 hobbyquaker
2020-01-06 08:18:55.721 - info: host.iobroker-pi hostname: iobroker-pi, node: v10.18.0
2020-01-06 08:18:55.724 - info: host.iobroker-pi ip addresses: 192.168.178.73 2003:f8:4bc6:f300:10a:c823:9927:3ad2 fe80::6ab1:df9f:e0a9:9269
2020-01-06 08:18:56.775 - info: host.iobroker-pi connected to Objects and States
2020-01-06 08:18:56.979 - info: host.iobroker-pi 31 instances found
2020-01-06 08:18:57.097 - info: host.iobroker-pi starting 25 instances
2020-01-06 08:18:57.193 - info: host.iobroker-pi instance system.adapter.admin.0 started with pid 563
2020-01-06 08:19:01.115 - info: host.iobroker-pi instance system.adapter.discovery.0 started with pid 621
2020-01-06 08:19:01.232 - info: admin.0 (563) starting. Version 3.6.12 in /opt/iobroker/node_modules/iobroker.admin, node: v10.18.0
2020-01-06 08:19:01.375 - info: admin.0 (563) requesting all states
2020-01-06 08:19:01.377 - info: admin.0 (563) requesting all objects

ahhhh... na schau...
hier stimmt was nicht.. da ist der zeitliche ablauf falsch..
poste bitte das gesamte LOG.. als datei

2020-01-06 09:03:04.772 - error: backitup.0 (1239) Error: Command failed: mount :/sharename/backupDir /opt/iobroker/backups
mount: only root can do that

und mach den backupit adapter erstmal aus..der ist auch falsch konfiguriert

[Aiouh]

Hier das ganze Log von heute

iobroker.2020-01-06.log.html

[apollon77]

Mal ne Frage: Kann es sein das die Kiste beim Compilieren von sql abgeraucht und restarted ist?

Steht un d8:50 irgendwas im /var/log/syslog?

Solche Zeitsprünge zurück und ein restart vom controller deutet für mich auf nen Reboot hin

Damit ist die Installation nie richtig durchgelaufen

Was ist es denn für Hardware? Es gab früher schonmal probleme dabei sqlite zu bauen bei der installation das das mega viel RAM und CPU gefressen hat. Ich tippe auf nen Raspi, korrekt?

Also am besten mal viele Adapter beenden wenn Du sql installierst. Falls es dann wieder passiert bin ich bei Netzteil und den üblichen Instabilitätsthemen, aber hier hilft /var/log/syslog

[Aiouh]

Hallo, ja, die Hardware ist ein Raspi 3B+. Rebootet hat er nicht selbst, das habe ich gemacht, nachdem er eingefroren war.
um 8:49 gibt es Einträge

Jan  5 08:49:15 raspi-zero-1 systemd[1]: Starting Daily apt download activities...
Jan  5 08:49:22 raspi-zero-1 systemd[1]: apt-daily.service: Succeeded.
Jan  5 08:49:22 raspi-zero-1 systemd[1]: Started Daily apt download activities.

Ich werde jetzt SQL nochmal deinstallieren, alle adapter beenden und schaun ob es dann mit der installation klappt.

[Aiouh]

Ich habe ausser dem Admin Adapter alle anderen deaktiviert und dann SQL installiert, das lief flott und ohne Fehler durch.
Nun werde ich mal sehn ob ich die connection zu meinem Remote MySQL Server hinbekomme.
Danke Euch für die Hilfe

[apollon77]

@Aiouh ich denke das du nur gedacht hast das er eingefroren ist sondern nur lange gedauert hat weil er swapped musste.