Hallo Tester.
-
Bingo!!! Das Upload flot hast gebracht!
Vielen Dank!!!
-
erledigt.
Beim Update vom js-controller die Meldungen:
$ sudo npm install https://github.com/ioBroker/ioBroker.js-controller/tarball/master --production [sudo] Passwort für michael: npm WARN deprecated jade@0.26.3: Jade has been renamed to pug, please install the latest version of pug instead of jade npm WARN deprecated graceful-fs@2.0.3: graceful-fs v3.0.0 and before will fail on node releases >= v7.0\. Please update to graceful-fs@^4.0.0 as soon as possible. Use 'npm ls graceful-fs' to find it in the tree. |Und im Log sind die SQL Fehler erhalten geblieben:
sql.0 12 16:23:13.293 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(11, 1463062982278, 42.5, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql.0 12 16:23:13.293 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(10, 1463062982277, 999.22, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql.0 12 16:23:03.302 error sql.0 Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(15, 1463062982277, 0, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql.0 12 16:23:03.301 error sql.0 Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(6, 1463062982277, 0, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql-0 12 16:22:05.322 error Cannot delete DELETE FROM ts_number WHERE id=8 AND ts < 1461853320320;: Error: SQLITE_BUSY: database is locked sql-0 12 16:21:58.668 error Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(5, 1463062917661, 'stabil', 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql-0 12 16:21:58.668 error Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(15, 1463062917661, 0, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql-0 12 16:21:58.668 error Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(6, 1463062917661, 0, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql-0 12 16:21:54.618 error Cannot delete DELETE FROM ts_number WHERE id=2 AND ts < 1461853260616;: Error: SQLITE_BUSY: database is locked sql-0 12 16:21:54.295 info enabled logging of javascript.1.WIFFI.Arbeitszimmer.wz_azimutUmgebung, wie oben beschrieben:
ubuntu 16.04
npm 2.15.1
node 4.4.4
-
erledigt.
Beim Update vom js-controller die Meldungen:
$ sudo npm install https://github.com/ioBroker/ioBroker.js-controller/tarball/master --production [sudo] Passwort für michael: npm WARN deprecated jade@0.26.3: Jade has been renamed to pug, please install the latest version of pug instead of jade npm WARN deprecated graceful-fs@2.0.3: graceful-fs v3.0.0 and before will fail on node releases >= v7.0\. Please update to graceful-fs@^4.0.0 as soon as possible. Use 'npm ls graceful-fs' to find it in the tree. |Und im Log sind die SQL Fehler erhalten geblieben:
sql.0 12 16:23:13.293 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(11, 1463062982278, 42.5, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql.0 12 16:23:13.293 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(10, 1463062982277, 999.22, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql.0 12 16:23:03.302 error sql.0 Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(15, 1463062982277, 0, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql.0 12 16:23:03.301 error sql.0 Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(6, 1463062982277, 0, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql-0 12 16:22:05.322 error Cannot delete DELETE FROM ts_number WHERE id=8 AND ts < 1461853320320;: Error: SQLITE_BUSY: database is locked sql-0 12 16:21:58.668 error Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(5, 1463062917661, 'stabil', 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql-0 12 16:21:58.668 error Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(15, 1463062917661, 0, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql-0 12 16:21:58.668 error Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(6, 1463062917661, 0, 0, 3, 0);: Error: SQLITE_BUSY: database is locked sql-0 12 16:21:54.618 error Cannot delete DELETE FROM ts_number WHERE id=2 AND ts < 1461853260616;: Error: SQLITE_BUSY: database is locked sql-0 12 16:21:54.295 info enabled logging of javascript.1.WIFFI.Arbeitszimmer.wz_azimutUmgebung, wie oben beschrieben:
ubuntu 16.04
npm 2.15.1
node 4.4.4 `
Danke. Kannst du nur sql updaten? Noch mal :) -
ubuntu 16.04
npm 2.15.1
node 4.4.4
Danke. Kannst du nur sql updaten? Noch mal :)erledigt.
sql.0 13 02:53:18.213 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(12, 1463100788209, 20.9, 0, 3, 0);: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: ts_number.id, ts_number.ts sql.0 13 02:53:18.210 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(11, 1463100788194, -17.9, 0, 3, 0);: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: ts_number.id, ts_number.ts sql.0 13 02:53:18.207 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(10, 1463100788193, 1001.09, 0, 3, 0);: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: ts_number.id, ts_number.ts sql.0 13 02:53:18.205 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(9, 1463100788191, 0.11, 0, 3, 0);: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: ts_number.id, ts_number.ts sql.0 13 02:53:18.202 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(8, 1463100788190, 30.5, 0, 3, 0);: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: ts_number.id, ts_number.ts sql.0 13 02:53:18.200 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(13, 1463100788190, 30.2, 0, 3, 0);: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: ts_number.id, ts_number.ts sql.0 13 02:53:18.198 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(7, 1463100788188, 98, 0, 3, 0);: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: ts_number.id, ts_number.ts sql-0 13 02:53:09.201 warn Cannot get index of "javascript.1.WIFFI.Arbeitszimmer.wz_motion_left": Error: SQLITE_BUSY: database is locked sql-0 13 02:53:09.201 error Cannot select SELECT id, type FROM datapoints WHERE name='javascript.1.WIFFI.Arbeitszimmer.wz_motion_left';: Error: SQLITE_BUSY: database is locked sql-0 13 02:53:08.173 info enabled logging of javascript.1.WIFFI.Arbeitszimmer.wz_azimutioBroker Versionen:
root@ubuntu-1604-dev:/opt/iobroker# ./iobroker update update done Adapter "web" : 1.4.3 , installed 1.4.3 Adapter "rickshaw" : 0.3.1 , installed 0.4.0 [Updateable] Adapter "sql" : 0.1.2 , installed 0.3.1 [Updateable] Controller "js-controller" : 0.8.10 , installed 0.8.10 Adapter "javascript" : 2.0.6 , installed 2.0.6 Adapter "history" : 0.2.1 , installed 0.4.0 [Updateable] Adapter "fritzbox" : 0.2.1 , installed 0.2.1 Adapter "flot" : 1.0.0 , installed 1.2.0 [Updateable] Adapter "admin" : 1.0.3 , installed 1.1.1 [Updateable] -
erledigt
root@RPi2-1:/opt/iobroker# uname -a && node -v && nodejs -v && npm -v Linux RPi2-1 4.1.19-v7+ #858 SMP Tue Mar 15 15:56:00 GMT 2016 armv7l GNU/Linux v4.4.3 v0.10.29 2.15.1root@RPi2-1:/opt/iobroker# ps -A | grep " io.*" 713 ? 01:48:02 iobroker.js-con 722 ? 01:00:08 io.admin.0 727 ? 00:51:32 io.sql.0 732 ? 00:06:08 io.web.0 743 ? 00:50:16 io.history.0 1276 ? 00:48:06 io.javascript.0root@RPi2-1:/opt/iobroker# node node_modules/iobroker.js-controller/iobroker.js update
! update done
! Adapter "zwave" : 0.2.5
! Adapter "yr" : 1.0.1 , installed 1.0.1
! Adapter "yamaha" : 0.1.5
! Adapter "wolf" : 0.1.0
! Adapter "web" : 1.4.3 , installed 1.4.3
! Adapter "weatherunderground": 0.1.0
! Adapter "vis-timeandweather": 1.1.0
! Adapter "vis-rgraph" : 0.0.2
! Adapter "vis-plumb" : 0.1.6
! Adapter "vis-metro" : 1.0.0
! Adapter "vis-lcars" : 1.0.0
! Adapter "vis-keyboard" : 0.0.2
! Adapter "vis-justgage" : 0.4.1 , installed 0.4.1
! Adapter "vis-jqui-mfd" : 0.1.0
! Adapter "vis-hqwidgets" : 1.0.0
! Adapter "vis-google-fonts": 0.1.0
! Adapter "vis-fancyswitch": 1.0.0
! Adapter "vis-colorpicker": 0.1.3
! Adapter "vis-bars" : 0.1.1
! Adapter "vis" : 0.9.4 , installed 0.9.4
! Adapter "vcard" : 0.0.6
! Adapter "text2command" : 1.0.0
! Adapter "terminal" : 0.1.2
! Adapter "telegram" : 0.2.4
! Adapter "starline" : 0.1.5
! Adapter "sonos" : 0.1.8
! Adapter "squeezebox" : 0.1.0
! Adapter "samsung" : 0.0.10
! Adapter "rpi" : 0.0.4
! Adapter "rickshaw" : 0.3.1 , installed 0.4.0 [Updateable]
! Adapter "pushover" : 0.1.1
! Adapter "pushbullet" : 0.0.11
! Adapter "piface" : 0.0.50
! Adapter "phantomjs" : 0.1.2
! Adapter "owfs" : 0.0.2
! Adapter "onkyo" : 0.2.0
! Adapter "occ" : 0.2.4
! Adapter "tvspielfilm" : 0.2.2 , installed 0.1.0 [Updateable]
! Adapter "sql" : 0.1.2 , installed 0.2.0 [Updateable]
! Adapter "socketio" : 1.4.0
! Adapter "simple-api" : 1.1.0
! Adapter "scenes" : 0.2.5
! Adapter "sayit" : 0.3.17
! Adapter "s7" : 0.2.4
! Adapter "ping" : 1.1.1
! Adapter "noolite" : 0.0.1
! Adapter "node-red" : 1.0.0
! Adapter "mysensors" : 0.2.3
! Adapter "mqtt" : 1.0.2
! Adapter "modbus" : 0.3.10
! Adapter "mobile" : 0.4.1
! Adapter "miele" : 0.0.12
! Adapter "megad" : 1.2.0
! Adapter "knx" : 0.2.10
! Controller "js-controller" : 0.8.10 , installed 0.8.10
! Adapter "javascript" : 2.0.6 , installed 2.0.6
! Adapter "influxdb" : 0.1.2
! Adapter "icons-ultimate-png": 0.1.0
! Adapter "icons-open-icon-library-png": 0.1.3
! Adapter "icons-mfd-svg" : 0.1.2
! Adapter "icons-mfd-png" : 0.1.2
! Adapter "icons-material-svg": 0.1.0
! Adapter "icons-material-png": 0.1.0
! Adapter "icons-icons8" : 0.0.1
! Adapter "icons-addictive-flavour-png": 0.1.0
! Adapter "ical" : 1.1.1
! Adapter "hmm" : 1.0.1
! Adapter "homekit" : 0.1.4
! Adapter "hue" : 0.5.3
! Adapter "hm-rpc" : 1.1.3
! Adapter "hm-rega" : 0.3.7
! Adapter "history" : 0.2.1 , installed 0.4.0 [Updateable]
! Adapter "harmony" : 0.5.5
! Adapter "geofency" : 0.1.4
! Adapter "fritzbox" : 0.2.1
! Adapter "feiertage" : 0.3.2 , installed 0.3.2
! Adapter "flot" : 1.0.0 , installed 1.2.0 [Updateable]
! Adapter "email" : 0.1.2
! Adapter "dwd" : 2.0.3 , installed 2.0.3
! Adapter "cul" : 0.0.4
! Adapter "chromecast" : 1.0.6
! Adapter "b-control-em" : 0.1.1
! Adapter "artnet" : 0.0.3
! Adapter "admin" : 1.0.3 , installed 1.1.1 [Updateable]root@RPi2-1:/opt/iobroker# node node_modules/iobroker.js-controller/iobroker.js stop Stopping iobroker controller daemon... iobroker controller daemon stopped. Exit code for "killall.sh": 0root@RPi2-1:/opt/iobroker# sudo npm install https://github.com/ioBroker/ioBroker.js … all/master --production
! npm WARN deprecated jade@0.26.3: Jade has been renamed to pug, please install the latest version of pug instead of jade
! npm WARN deprecated graceful-fs@2.0.3: graceful-fs v3.0.0 and before will fail on node releases >= v7.0. Please update to graceful-fs@^4.0.0 as soon as possible. Use 'npm ls graceful-fs' to find it in the tree.
! /
! > iobroker.js-controller@0.8.10 install /opt/iobroker/node_modules/iobroker.js-controller
! > node lib/setup.js setup first
! iobroker.js-controller@0.8.10 node_modules/iobroker.js-controller
! ├── mime@1.3.4
! ├── daemonize2@0.4.2
! ├── adm-zip@0.4.7
! ├── ncp@2.0.0
! ├── semver@4.3.6
! ├── node.extend@1.1.5 (is@3.1.0)
! ├── node-schedule@1.0.0 (long-timeout@0.0.2, cron-parser@1.1.0)
! ├── winston@2.2.0 (cycle@1.0.3, stack-trace@0.0.9, eyes@0.1.8, isstream@0.1.2, async@1.0.0, pkginfo@0.3.1, colors@1.0.3)
! ├── yargs@3.32.0 (decamelize@1.2.0, camelcase@2.1.1, y18n@3.2.1, window-size@0.1.4, cliui@3.2.0, os-locale@1.4.0, string-width@1.0.1)
! ├── winston-daily-rotate-file@1.0.1 (winston@2.1.1)
! ├── socket.io@1.4.6 (has-binary@0.1.7, debug@2.2.0, socket.io-parser@2.2.6, socket.io-adapter@0.4.0, engine.io@1.6.9)
! ├── socket.io-client@1.4.6 (to-array@0.1.4, component-emitter@1.2.0, indexof@0.0.1, component-bind@1.0.0, backo2@1.0.2, object-component@0.0.3, has-binary@0.1.7, debug@2.2.0, socket.io-parser@2.2.6, parseuri@0.0.4, engine.io-client@1.6.9)
! ├── request@2.72.0 (aws-sign2@0.6.0, tunnel-agent@0.4.3, forever-agent@0.6.1, oauth-sign@0.8.2, is-typedarray@1.0.0, caseless@0.11.0, stringstream@0.0.5, aws4@1.4.1, isstream@0.1.2, json-stringify-safe@5.0.1, extend@3.0.0, tough-cookie@2.2.2, node-uuid@1.4.7, qs@6.1.0, combined-stream@1.0.5, mime-types@2.1.11, form-data@1.0.0-rc4, hawk@3.1.3, bl@1.1.2, http-signature@1.1.1, har-validator@2.0.6)
! ├── prompt@1.0.0 (revalidator@0.1.8, pkginfo@0.4.0, colors@1.1.2, read@1.0.7, winston@2.1.1, utile@0.3.0)
! ├── tar.gz@1.0.3 (commander@2.9.0, bluebird@2.10.2, tar@2.2.1, chai@3.5.0, fstream@1.0.9, mocha@2.4.5, mout@0.11.1)
! └── npm@2.15.5root@RPi2-1:/opt/iobroker# sudo npm install https://github.com/ioBroker/ioBroker.ad … all/master --production
! iobroker.admin@1.1.1 node_modules/iobroker.admin
! ├── connect-flash@0.1.1
! ├── xtend@4.0.1
! ├── passport-local@1.0.0 (passport-strategy@1.0.0)
! ├── cookie-parser@1.4.1 (cookie-signature@1.0.6, cookie@0.2.3)
! ├── passport@0.2.2 (pause@0.0.1, passport-strategy@1.0.0)
! ├── express-session@1.13.0 (cookie-signature@1.0.6, utils-merge@1.0.0, on-headers@1.0.1, cookie@0.2.3, parseurl@1.3.1, depd@1.1.0, crc@3.4.0, uid-safe@2.0.0, debug@2.2.0)
! ├── body-parser@1.15.1 (content-type@1.0.2, bytes@2.3.0, depd@1.1.0, on-finished@2.3.0, raw-body@2.1.6, http-errors@1.4.0, qs@6.1.0, debug@2.2.0, iconv-lite@0.4.13, type-is@1.6.12)
! ├── express@4.13.4 (escape-html@1.0.3, cookie-signature@1.0.6, utils-merge@1.0.0, merge-descriptors@1.0.1, methods@1.1.2, vary@1.0.1, content-type@1.0.2, parseurl@1.3.1, cookie@0.1.5, fresh@0.3.0, content-disposition@0.5.1, etag@1.7.0, range-parser@1.0.3, serve-static@1.10.2, array-flatten@1.1.1, path-to-regexp@0.1.7, depd@1.1.0, qs@4.0.0, on-finished@2.3.0, finalhandler@0.4.1, debug@2.2.0, proxy-addr@1.0.10, send@0.13.1, type-is@1.6.12, accepts@1.2.13)
! ├── socket.io@1.4.6 (has-binary@0.1.7, debug@2.2.0, socket.io-parser@2.2.6, socket.io-adapter@0.4.0, engine.io@1.6.9, socket.io-client@1.4.6)
! └── request@2.72.0 (aws-sign2@0.6.0, tunnel-agent@0.4.3, oauth-sign@0.8.2, forever-agent@0.6.1, caseless@0.11.0, is-typedarray@1.0.0, stringstream@0.0.5, aws4@1.4.1, isstream@0.1.2, json-stringify-safe@5.0.1, extend@3.0.0, tough-cookie@2.2.2, node-uuid@1.4.7, qs@6.1.0, combined-stream@1.0.5, mime-types@2.1.11, form-data@1.0.0-rc4, bl@1.1.2, hawk@3.1.3, http-signature@1.1.1, har-validator@2.0.6)nun SQL (mit einigen Hinweisen)
root@RPi2-1:/opt/iobroker# sudo npm install https://github.com/ioBroker/ioBroker.sql/tarball/master –production
! -
! > sqlite3@3.1.3 install /opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3
! > node-pre-gyp install –fallback-to-build
! make: Entering directory '/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/build'
! ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3090100/sqlite3.c
! TOUCH Release/obj.target/deps/action_before_build.stamp
! CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3090100/sqlite3.o
! AR(target) Release/obj.target/deps/sqlite3.a
! COPY Release/sqlite3.a
! CXX(target) Release/obj.target/node_sqlite3/src/database.o
! ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginOpen(node_sqlite3::Database::Baton*)’:
! ../src/database.cc:143:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginClose(node_sqlite3::Database::Baton*)’:
! ../src/database.cc:227:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginExec(node_sqlite3::Database::Baton*)’:
! ../src/database.cc:505:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginLoadExtension(node_sqlite3::Database::Baton*)’:
! ../src/database.cc:605:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! CXX(target) Release/obj.target/node_sqlite3/src/node_sqlite3.o
! CXX(target) Release/obj.target/node_sqlite3/src/statement.o
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginPrepare(node_sqlite3::Database::Baton*)’:
! ../src/statement.cc:118:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! In file included from ../src/statement.cc:6:0:
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginBind(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:322:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(Bind);
! ^
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginGet(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:370:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(Get);
! ^
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginRun(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:438:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(Run);
! ^
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginAll(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:504:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(All);
! ^
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginEach(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:601:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(Each);
! ^
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginReset(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:724:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(Reset);
! ^
! SOLINK_MODULE(target) Release/obj.target/node_sqlite3.node
! COPY Release/node_sqlite3.node
! COPY /opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/lib/binding/node-v46-linux-arm/node_sqlite3.node
! TOUCH Release/obj.target/action_after_build.stamp
! make: Leaving directory '/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/build'
! iobroker.sql@0.3.1 node_modules/iobroker.sql
! ├── mysql@2.10.2 (bignumber.js@2.1.4, readable-stream@1.1.14)
! ├── pg@4.5.5 (packet-reader@0.2.0, pg-connection-string@0.1.3, generic-pool@2.1.1, buffer-writer@1.0.1, semver@4.3.6, pg-types@1.11.0, pgpass@0.0.3)
! ├── sql-client@0.7.0 (argf@0.0.1, optimist@0.6.1, inote-util@0.8.1)
! ├── mssql@3.3.0 (generic-pool@2.4.2, promise@7.1.1, tedious@1.14.0)
! └── sqlite3@3.1.3 (nan@2.2.1)root@RPi2-1:/opt/iobroker# sudo npm install https://github.com/ioBroker/ioBroker.hi … all/master --production
iobroker.history@0.4.0 node_modules/iobroker.history
root@RPi2-1:/opt/iobroker# sudo npm install https://github.com/ioBroker/ioBroker.fl ... all/master --production
iobroker.flot@1.2.0 node_modules/iobroker.flot
root@RPi2-1:/opt/iobroker# sudo npm install https://github.com/ioBroker/ioBroker.ri ... all/master --production
iobroker.rickshaw@0.4.0 node_modules/iobroker.rickshaw
root@RPi2-1:/opt/iobroker# node node_modules/iobroker.js-controller/iobroker.js start
Starting iobroker controller daemon... iobroker controller daemon started. PID: 9525 root@RPi2-1:/opt/iobroker# ps -A | grep " io.*" 9525 ? 00:00:14 iobroker.js-con 9534 ? 00:00:12 io.admin.0 9539 ? 00:00:10 io.sql.0 9548 ? 00:00:07 io.web.0 9553 ? 00:00:05 io.history.0 9597 ? 00:00:06 io.javascript.0Gruß
Jürgen
-
==> /opt/iobroker/log/iobroker.2016-05-13.log <== 2016-05-13 06:17:48.426 - error: sql.0 Cannot select SELECT id, type FROM datapoints WHERE name='yr.0.forecast.day0.icon';: Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:48.438 - warn: sql.0 Cannot get index of "yr.0.forecast.day0.icon": Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:48.441 - error: sql.0 Cannot select SELECT id, type FROM datapoints WHERE name='yr.0.forecast.day0.text';: Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:48.442 - warn: sql.0 Cannot get index of "yr.0.forecast.day0.text": Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:48.573 - error: sql.0 Cannot select SELECT id, type FROM datapoints WHERE name='yr.0.forecast.day0.precipitation_level';: Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:48.574 - warn: sql.0 Cannot get index of "yr.0.forecast.day0.precipitation_level": Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:51.144 - info: feiertage.0 starting. Version 0.3.2 in /opt/iobroker/node_modules/iobroker.feiertage 2016-05-13 06:17:51.937 - info: host.RPi2-1 instance system.adapter.feiertage.0 terminated with code 0 (OK) 2016-05-13 06:18:02.398 - error: sql.0 Cannot select SELECT id, type FROM datapoints WHERE name='feiertage.0.heute.boolean';: Error: SQLITE_BUSY: database is locked 2016-05-13 06:18:02.401 - warn: sql.0 Cannot get index of "feiertage.0.heute.boolean": Error: SQLITE_BUSY: database is locked -
==> /opt/iobroker/log/iobroker.2016-05-13.log <== 2016-05-13 06:17:48.426 - error: sql.0 Cannot select SELECT id, type FROM datapoints WHERE name='yr.0.forecast.day0.icon';: Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:48.438 - warn: sql.0 Cannot get index of "yr.0.forecast.day0.icon": Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:48.441 - error: sql.0 Cannot select SELECT id, type FROM datapoints WHERE name='yr.0.forecast.day0.text';: Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:48.442 - warn: sql.0 Cannot get index of "yr.0.forecast.day0.text": Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:48.573 - error: sql.0 Cannot select SELECT id, type FROM datapoints WHERE name='yr.0.forecast.day0.precipitation_level';: Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:48.574 - warn: sql.0 Cannot get index of "yr.0.forecast.day0.precipitation_level": Error: SQLITE_BUSY: database is locked 2016-05-13 06:17:51.144 - info: feiertage.0 starting. Version 0.3.2 in /opt/iobroker/node_modules/iobroker.feiertage 2016-05-13 06:17:51.937 - info: host.RPi2-1 instance system.adapter.feiertage.0 terminated with code 0 (OK) 2016-05-13 06:18:02.398 - error: sql.0 Cannot select SELECT id, type FROM datapoints WHERE name='feiertage.0.heute.boolean';: Error: SQLITE_BUSY: database is locked 2016-05-13 06:18:02.401 - warn: sql.0 Cannot get index of "feiertage.0.heute.boolean": Error: SQLITE_BUSY: database is locked ```` `Danke. Noch mal updaten (nur sql reicht.)
-
root@RPi2-1:/home/pi# cd /opt/iobroker/
root@RPi2-1:/opt/iobroker# node node_modules/iobroker.js-controller/iobroker.js stop Stopping iobroker controller daemon... iobroker controller daemon stopped. Exit code for "killall.sh": 0root@RPi2-1:/opt/iobroker# sudo npm install https://github.com/ioBroker/ioBroker.sql/tarball/master –production
! -
! > sqlite3@3.1.3 install /opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3
! > node-pre-gyp install –fallback-to-build
! make: Entering directory '/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/build'
! ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3090100/sqlite3.c
! TOUCH Release/obj.target/deps/action_before_build.stamp
! CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3090100/sqlite3.o
! AR(target) Release/obj.target/deps/sqlite3.a
! COPY Release/sqlite3.a
! CXX(target) Release/obj.target/node_sqlite3/src/database.o
! ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginOpen(node_sqlite3::Database::Baton*)’:
! ../src/database.cc:143:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginClose(node_sqlite3::Database::Baton*)’:
! ../src/database.cc:227:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginExec(node_sqlite3::Database::Baton*)’:
! ../src/database.cc:505:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/database.cc: In static member function ‘static void node_sqlite3::Database::Work_BeginLoadExtension(node_sqlite3::Database::Baton*)’:
! ../src/database.cc:605:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! CXX(target) Release/obj.target/node_sqlite3/src/node_sqlite3.o
! CXX(target) Release/obj.target/node_sqlite3/src/statement.o
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginPrepare(node_sqlite3::Database::Baton*)’:
! ../src/statement.cc:118:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! In file included from ../src/statement.cc:6:0:
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginBind(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:322:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(Bind);
! ^
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginGet(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:370:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(Get);
! ^
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginRun(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:438:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(Run);
! ^
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginAll(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:504:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(All);
! ^
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginEach(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:601:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(Each);
! ^
! ../src/statement.cc: In static member function ‘static void node_sqlite3::Statement::Work_BeginReset(node_sqlite3::Statement::Baton*)’:
! ../src/macros.h:125:9: warning: unused variable ‘status’ [-Wunused-variable]
! int status = uv_queue_work(uv_default_loop(),
! ^
! ../src/statement.cc:724:5: note: in expansion of macro ‘STATEMENT_BEGIN’
! STATEMENT_BEGIN(Reset);
! ^
! SOLINK_MODULE(target) Release/obj.target/node_sqlite3.node
! COPY Release/node_sqlite3.node
! COPY /opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/lib/binding/node-v46-linux-arm/node_sqlite3.node
! TOUCH Release/obj.target/action_after_build.stamp
! make: Leaving directory '/opt/iobroker/node_modules/iobroker.sql/node_modules/sqlite3/build'
! iobroker.sql@0.3.2 node_modules/iobroker.sql
! ├── mysql@2.10.2 (bignumber.js@2.1.4, readable-stream@1.1.14)
! ├── pg@4.5.5 (packet-reader@0.2.0, pg-connection-string@0.1.3, generic-pool@2.1.1, buffer-writer@1.0.1, semver@4.3.6, pg-types@1.11.0, pgpass@0.0.3)
! ├── sql-client@0.7.0 (argf@0.0.1, optimist@0.6.1, inote-util@0.8.1)
! ├── mssql@3.3.0 (generic-pool@2.4.2, promise@7.1.1, tedious@1.14.0)
! └── sqlite3@3.1.3 (nan@2.2.1)
! root@RPi2-1:/opt/iobroker#root@RPi2-1:/opt/iobroker# node node_modules/iobroker.js-controller/iobroker.js start Starting iobroker controller daemon... iobroker controller daemon started. PID: 10400 -
ich denke ja.
Nächste Woche werde ich dann alles veröffentlichen. `
Danke für die Rückmeldung.
Das bedeutet ist sollte bis nächste Woche mit der Installation des SQL-Adaptern auf meinem neuen Produktiv-System (DS412+) noch warten.
Gruß
Jürgen
-
Moin zusammen,
bzgl. SQL-Adapter und mySQL-DB teste ich gerade einen Anbieter, der hosted SQL (MS-SQL und auch mySQL) anbietet.
Keinen "Ärger" mit Backup, Last, usw. - und das für kleines Geld (wie ich finde)
Schaut selber : http://www.ecs-webhosting.de/de/cloud-m … osting.htm
Gruß,
Eric
-
H Homoran verschob dieses Thema von Tester am
-
H Homoran verschob dieses Thema von ...nicht in offiziellem Repo am
Hey! Du scheinst an dieser Unterhaltung interessiert zu sein, hast aber noch kein Konto.
Hast du es satt, bei jedem Besuch durch die gleichen Beiträge zu scrollen? Wenn du dich für ein Konto anmeldest, kommst du immer genau dorthin zurück, wo du zuvor warst, und kannst dich über neue Antworten benachrichtigen lassen (entweder per E-Mail oder Push-Benachrichtigung). Du kannst auch Lesezeichen speichern und Beiträge positiv bewerten, um anderen Community-Mitgliedern deine Wertschätzung zu zeigen.
Mit deinem Input könnte dieser Beitrag noch besser werden 💗
Registrieren AnmeldenSupport us
527
Online32.8k
Benutzer82.8k
Themen1.3m
Beiträge