Ошибки драйвера SQL

Сообщите об ошибках в ioBroker
Benutzeravatar
instalator
guru
Beiträge: 1271
Registriert: 09.11.2014, 16:50
Wohnort: Барнаул
Kontaktdaten:

Re: Ошибки драйвера SQL

Beitrag von instalator » 21.12.2016, 14:20

при попвтке обновится до 1.4.0.
В итоге не обновляется
Spoiler: Show hidden text

Code: Alles auswählen

$ ./iobroker upgrade sql
host.Server-PC Adapter "system.adapter.sql.0" is stopped.
npm install iobroker.sql --production --prefix "C:/ioBroker" (System call)
npm
 
WARN
 
deprecated
 node-uuid@1.4.7: use uuid module instead
gyp
 
ERR!
 
configure error
 
gyp
 
ERR!
 
stack
 Error: Can't find Python executable "python", you can set the PYTHON env variable.
gyp
 
ERR!
 
stack
     at failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:449:14)
gyp
 
ERR!
 
stack
     at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:404:11
gyp
 
ERR!
 
stack
     at FSReqWrap.oncomplete (fs.js:82:15)
gyp
 
ERR!
 
System
 Windows_NT 6.1.7601
gyp
 
ERR!
 
command
 "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"
gyp
 
ERR!
 
cwd
 C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\node_modules\inote-util\node_modules\mmmagic
gyp
 
ERR!
 
node -v
 v4.6.2
gyp
 
ERR!
 
node-gyp -v
 v3.4.0
gyp
 
ERR!
 
not ok
 
node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v46-win32-ia32.tar.gz node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.8 and node@4.6.2 (node-v46 ABI) (falling back to source compile with node-gyp) 

gyp
 
ERR!
 
configure error
 
gyp
 
ERR!
 
stack
 Error: Can't find Python executable "python", you can set the PYTHON env variable.
gyp
 
ERR!
 
stack
     at failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:449:14)
gyp
 
ERR!
 
stack
     at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:404:11
gyp
 
ERR!
 
stack
     at FSReqWrap.oncomplete (fs.js:82:15)
gyp
 
ERR!
 
System
 Windows_NT 6.1.7601
gyp
 
ERR!
 
command
 "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\\ioBroker\\node_modules\\iobroker.sql\\node_modules\\sqlite3\\lib\\binding\\node-v46-win32-ia32\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\ioBroker\\node_modules\\iobroker.sql\\node_modules\\sqlite3\\lib\\binding\\node-v46-win32-ia32"
gyp
 
ERR!
 
cwd
 C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3
gyp
 
ERR!
 
node -v
 v4.6.2
gyp
 
ERR!
 
node-gyp -v
 v3.4.0
gyp
 
ERR!
 
not ok
 
node-pre-gyp
 
ERR!
 
build error
 
node-pre-gyp
 
ERR!
 
stack
 Error: Failed to execute 'node-gyp.cmd configure --fallback-to-build --module=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32' (1)
node-pre-gyp
 
ERR!
 
stack
     at ChildProcess.<anonymous> (C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
node-pre-gyp
 
ERR!
 
stack
     at emitTwo (events.js:87:13)
node-pre-gyp
 
ERR!
 
stack
     at ChildProcess.emit (events.js:172:7)
node-pre-gyp
 
ERR!
 
stack
     at maybeClose (internal/child_process.js:854:16)
node-pre-gyp
 
ERR!
 
stack
     at Process.ChildProcess._handle.onexit (internal/child_process.js:222:5)
node-pre-gyp
 
ERR!
 
System
 Windows_NT 6.1.7601
node-pre-gyp
 
ERR!
 
command
 "C:\\Program Files\\nodejs\\node.exe" "C:\\ioBroker\\node_modules\\iobroker.sql\\node_modules\\sqlite3\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp
 
ERR!
 
cwd
 C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3
node-pre-gyp
 
ERR!
 
node -v
 v4.6.2
node-pre-gyp
 
ERR!
 
node-pre-gyp -v
 v0.6.31
node-pre-gyp
 
ERR!
 
not ok
 
npm
 
WARN
 
optional dep failed, continuing
 sqlite3@3.1.8
npm
 
ERR!
 Windows_NT 6.1.7601
npm
 
ERR!
 
argv
 "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "install" "iobroker.sql" "--production" "--prefix" "C:/ioBroker"
npm
 
ERR!
 
node
 v4.6.2
npm
 
ERR!
 
npm 
 v2.15.11
npm
 
ERR!
 
code
 ELIFECYCLE

npm
 
ERR!
 mmmagic@0.4.5 install: `node-gyp rebuild`
npm
 
ERR!
 Exit status 1
npm
 
ERR!
 
npm
 
ERR!
 Failed at the mmmagic@0.4.5 install script 'node-gyp rebuild'.
npm
 
ERR!
 This is most likely a problem with the mmmagic package,
npm
 
ERR!
 not with npm itself.
npm
 
ERR!
 Tell the author that this fails on your system:
npm
 
ERR!
     node-gyp rebuild
npm
 
ERR!
 You can get information on how to open an issue for this project with:
npm
 
ERR!
     npm bugs mmmagic
npm
 
ERR!
 Or if that isn't available, you can get their info via:
npm
 
ERR!
 
npm
 
ERR!
     npm owner ls mmmagic
npm
 
ERR!
 There is likely additional logging output above.

npm
 
ERR!
 Please include the following file with any support request:
npm
 
ERR!
     C:\ioBroker\node_modules\iobroker\npm-debug.log
ERROR: host.Server-PC Cannot install iobroker.sql: 1
ERROR: process exited with code 25
Высокий уровень Децибел вреден для здоровья!
Мой блог

sigma
starter
Beiträge: 16
Registriert: 24.01.2017, 09:17

Re: Ошибки драйвера SQL

Beitrag von sigma » 04.10.2017, 10:30

SQL History 1.5.6. Коннект к внешнему серверу PostgreSQL.
В логе постоянно сыпятся ошибки:

Code: Alles auswählen

sql.0	2017-10-04 10:41:45.719	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898623, 'Subscribe [Equipment/Relays/R0045]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.499	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898620, 'Subscribe [Equipment/Relays/R0040]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.467	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898619, 'Subscribe [Equipment/Relays/R0037]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.151	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898611, 'Subscribe [Equipment/Relays/R0029]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.149	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898610, 'Subscribe [Equipment/Relays/R0028]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:44.944	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898603, 'Subscribe [Equipment/Buttons/B0017]', true, 1, 0);: error: duplicate key value violates unique constraint "t
sql.0	2017-10-04 10:41:44.890	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898602, 'Subscribe [Equipment/Buttons/B0016]', true, 1, 0);: error: duplicate key value violates unique constraint "t

Каким образом он умудряется выдать две записи в 1 мс?

Benutzeravatar
Bluefox
Site Admin
Beiträge: 7956
Registriert: 13.07.2014, 14:42
Kontaktdaten:

Re: Ошибки драйвера SQL

Beitrag von Bluefox » 04.10.2017, 16:21

Настрой Минимальный интервал

ford7
starter
Beiträge: 59
Registriert: 27.10.2014, 12:28

Re: Ошибки драйвера SQL

Beitrag von ford7 » 20.10.2017, 20:11

Периодически слетает настройка истории в sql (активно) только для данной переменной.
Подскажите, что бы это значило?
Dateianhänge
sql1.JPG

Antworten