[RESOLVED] Issue creating chart on Gladys+

spenceur · March 7, 2022, 9:05pm

It’s still me

When I want to create a chart on Gladys +, it doesn’t offer these two fields:

Locally:

On G+:

This causes an infinite spinner when saving on G+:

With these errors in the console:

Is this intentional for security reasons @pierre-gilles?

info: It would be great to have « bug » tags to better track them on the forum.

pierre-gilles · March 8, 2022, 8:46am

@spenceur This isn’t related to this box, your Gladys Plus can’t find your local instance.

By any chance, haven’t you launched multiple Gladys instances on the same Gladys Plus account (for example, by reusing your DB)?

If that’s the case, it can cause issues because Gladys Plus only works with one instance, and the last started instance « takes control ».

spenceur · March 8, 2022, 8:47am

Absolutely not, I only have a Gladys locally on an RPI ^^

pierre-gilles · March 8, 2022, 8:49am

If you refresh your page, do you still see the same « NO_INSTANCE_FOUND » errors in the logs?

If so, I suggest trying a few things: restart your Gladys instance, and if that doesn’t solve the issue, check the logs of your Gladys instance.

Have you resolved your DNS issues? Given the errors, it smells like local Gladys problems that can’t contact the Gladys Plus server.

spenceur · March 8, 2022, 8:58am

I’ll try to restart my local instance as soon as possible ^^

I haven’t taken the time to switch to Cloudflare yet, do you think it’s related?

pierre-gilles · March 8, 2022, 9:00am

Your logs will tell us, but yes, clearly related.

If the local still has DNS issues, it’s impossible to contact the server, and therefore impossible for you to have the UI working, hence the « INSTANCE_NOT_FOUND » errors.

spenceur · March 8, 2022, 12:29pm

After a restart, still the same. I’ll handle the DNS tonight.

pierre-gilles · March 8, 2022, 1:34pm

And the logs?

spenceur · March 9, 2022, 8:10am

What exactly do you want?

Log in Gladys or in the console?

If log in Gladys, do you have a specific keyword because my logs are flooded with info about the mqtt service (maybe too much)?

pierre-gilles · March 9, 2022, 8:13am

Log gladys Nothing specific but something that looks like an error!

You can also look for the same DNS errors that you posted in another topic as well

spenceur · March 9, 2022, 8:16am

Then after a reboot of the rpi

2022-03-09T09:07:27+0100 <info> index.js:25 (shutdown) SIGTERM received.
2022-03-09T09:07:27+0100 <info> index.js:31 (shutdown) Closing database connection.

> gladys-server@ start:prod /src/server
> cross-env NODE_ENV=production node index.js

2022-03-09T09:09:17+0100 <info> job.purge.js:17 (Job.purge) Deleting all background jobs created before = Wed Mar 02 2022 09:09:17 GMT+0100 (Central European Standard Time)
Initialising OpenZWave 1.6.0 binary addon for Node.JS.
        OpenZWave Security API is ENABLED
        ZWave device db    : /usr/local/etc/openzwave
        User settings path : /src/server/services/zwave/node_modules/openzwave-shared/build/Release/../../
        Option Overrides : --Logging false --ConsoleOutput false --SaveConfiguration true
2022-03-09T09:09:27+0100 <info> service.startAll.js:30 () Service example was manually stopped, so it is ignored at startup
2022-03-09T09:09:27+0100 <info> service.startAll.js:30 () Service philips-hue was manually stopped, so it is ignored at startup
2022-03-09T09:09:27+0100 <info> service.startAll.js:30 () Service xiaomi was manually stopped, so it is ignored at startup
2022-03-09T09:09:27+0100 <info> service.startAll.js:30 () Service tasmota was manually stopped, so it is ignored at startup
2022-03-09T09:09:27+0100 <info> service.startAll.js:30 () Service ewelink was manually stopped, so it is ignored at startup
2022-03-09T09:09:27+0100 <info> service.startAll.js:30 () Service tp-link was manually stopped, so it is ignored at startup
2022-03-09T09:09:27+0100 <info> index.js:16 (Object.start) Starting RTSP service
2022-03-09T09:09:28+0100 <info> index.js:64 (Object.start) Starting CalDAV service
2022-03-09T09:09:28+0100 <info> index.js:16 (Object.start) Starting MQTT service
2022-03-09T09:09:28+0100 <info> updateContainer.js:13 (MqttHandler.updateContainer) MQTT: checking for required changes...
2022-03-09T09:09:29+0100 <info> connect.js:38 (MqttClient.<anonymous>) Connected to MQTT server mqtt://localhost
2022-03-09T09:09:29+0100 <info> subscribe.js:12 (MqttHandler.subscribe) Subscribing to MQTT topic gladys/master/#
2022-03-09T09:09:29+0100 <info> index.js:20 (Object.start) Starting Open Weather service
2022-03-09T09:09:29+0100 <info> index.js:14 (Object.start) starting GoogleActions service
2022-03-09T09:09:30+0100 <info> init.js:47 () Zigbee2mqtt USB dongle attached to /dev/ttyACM0
2022-03-09T09:09:30+0100 <info> installMqttContainer.js:103 (Zigbee2mqttManager.installMqttContainer) MQTT broker container successfully started
2022-03-09T09:09:30+0100 <info> installZ2mContainer.js:71 (Zigbee2mqttManager.installZ2mContainer) Zigbee2mqtt container successfully started
2022-03-09T09:09:31+0100 <info> connect.js:24 (MqttClient.<anonymous>) Connected to MQTT container mqtt://localhost:1884
2022-03-09T09:09:31+0100 <info> subscribe.js:12 (Zigbee2mqttManager.subscribe) Subscribing to MQTT topic zigbee2mqtt/#
2022-03-09T09:09:31+0100 <warn> handleMqttMessage.js:104 (Zigbee2mqttManager.handleMqttMessage) Zigbee2mqtt device 0x000b57fffe20c1ac not configured in Gladys.
2022-03-09T09:09:31+0100 <warn> handleMqttMessage.js:104 (Zigbee2mqttManager.handleMqttMessage) Zigbee2mqtt device 0x842e14fffe462c2a not configured in Gladys.
2022-03-09T09:09:31+0100 <info> index.js:15 (Object.start) Starting Bluetooth service
2022-03-09T09:09:33+0100 <info> bluetooth.initPresenceScanner.js:18 (BluetoothManager.initPresenceScanner) Bluetooth configuration: starting presence scanner
2022-03-09T09:09:33+0100 <info> bluetooth.initPresenceScanner.js:13 (BluetoothManager.initPresenceScanner) Bluetooth configuration: stopping presence scanner
2022-03-09T09:09:33+0100 <info> bluetooth.initPresenceScanner.js:18 (BluetoothManager.initPresenceScanner) Bluetooth configuration: starting presence scanner
2022-03-09T09:09:33+0100 <info> index.js:16 (Object.start) Starting zwave service
2022-03-09T09:09:40+0100 <warn> handleMqttMessage.js:104 (Zigbee2mqttManager.handleMqttMessage) Zigbee2mqtt device 0x54ef4410000c1618 not configured in Gladys.
2022-03-09T09:09:40+0100 <info> index.js:13 (Object.start) Starting usb service
2022-03-09T09:09:41+0100 <info> index.js:19 (Object.start) Starting Telegram service
2022-03-09T09:09:41+0100 <info> scene.dailyUpdate.js:58 () Sunrise today is at 7:33 today, in your timezone = Europe/Paris
2022-03-09T09:09:41+0100 <info> scene.dailyUpdate.js:59 () Sunset today is at 19:3 today, in your timezone = Europe/Paris
2022-03-09T09:09:41+0100 <info> scene.dailyUpdate.js:70 () The sun rose this morning. Not scheduling for today.
2022-03-09T09:09:41+0100 <info> scene.dailyUpdate.js:81 () Sunset is scheduled, in 10 hours.
2022-03-09T09:09:45+0100 <info> device.calculateAggregate.js:38 (DeviceManager.calculateAggregate) Calculating aggregates device feature state for interval hourly
2022-03-09T09:09:45+0100 <info> index.js:63 (Server.<anonymous>) Server listening on port 80
2022-03-09T09:09:47+0100 <info> index.js:801 (Socket.<anonymous>) Gladys Gateway: connected in websockets
2022-03-09T09:09:48+0100 <info> gateway.checkIfBackupNeeded.js:27 (Gateway.checkIfBackupNeeded) Not backing up instance to Gladys Gateway, last backup is recent.
2022-03-09T09:09:50+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T09:09:50+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T09:10:05+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T09:10:05+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T09:10:20+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T09:10:20+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T09:10:34+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T09:10:35+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T09:10:49+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T09:10:49+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T09:11:14+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T09:11:14+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T09:11:31+0100 <warn> poll.js:14 (RtspCameraHandler.poll) Unable to poll camera
2022-03-09T09:11:31+0100 <warn> poll.js:14 (RtspCameraHandler.poll) Unable to poll camera
2022-03-09T09:11:33+0100 <warn> poll.js:14 (RtspCameraHandler.poll) Unable to poll camera
2022-03-09T09:11:34+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T09:11:34+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T09:11:35+0100 <warn> poll.js:14 (RtspCameraHandler.poll) Unable to poll camera
2022-03-09T09:11:35+0100 <warn> poll.js:14 (RtspCameraHandler.poll) Unable to poll camera

spenceur · March 9, 2022, 8:24am

Some error with the camera

2022-03-09T09:11:35+0100 <warn> poll.js:14 (RtspCameraHandler.poll) Unable to poll camera
2022-03-09T09:11:35+0100 <warn> poll.js:14 (RtspCameraHandler.poll) Unable to poll camera
2022-03-09T09:11:36+0100 <warn> poll.js:14 (RtspCameraHandler.poll) Unable to poll camera
2022-03-09T09:11:48+0100 <error> index.js:15 (process.<anonymous>) unhandledRejection catched: Promise {
  <rejected> [Error: ENOENT: no such file or directory, open '/tmp/gladysassistant/camera-77a26676-f39c-41b6-9a0f-1253a254c917-413-45-11-9.jpg'] {
    errno: -2,
    code: 'ENOENT',
    syscall: 'open',
    path: '/tmp/gladysassistant/camera-77a26676-f39c-41b6-9a0f-1253a254c917-413-45-11-9.jpg'
  }
}
2022-03-09T09:11:48+0100 <error> index.js:16 (process.<anonymous>) [Error: ENOENT: no such file or directory, open '/tmp/gladysassistant/camera-77a26676-f39c-41b6-9a0f-1253a254c917-413-45-11-9.jpg'] {
  errno: -2,
  code: 'ENOENT',
  syscall: 'open',
  path: '/tmp/gladysassistant/camera-77a26676-f39c-41b6-9a0f-1253a254c917-413-45-11-9.jpg'
}

spenceur · March 9, 2022, 8:31am

After a deco reco of my local to g+

22-03-09T09:28:49+0100 <warn> index.js:831 (Socket.<anonymous>) Socket disconnected client side. Trying to reconnect...
2022-03-09T09:30:04+0100 <info> index.js:801 (Socket.<anonymous>) Gladys Gateway: connected in websockets
2022-03-09T09:30:05+0100 <info> gateway.checkIfBackupNeeded.js:27 (Gateway.checkIfBackupNeeded) Not backing up instance to Gladys Gateway, last backup is recent.

spenceur · March 9, 2022, 8:32am

I’ve got nothing abnormal, I tell you

spenceur · March 9, 2022, 8:49am

@pierre-gilles On the G+ side, it takes a long time to display in the task parameters.
Otherwise, the same error still occurs on the charts.

spenceur · March 9, 2022, 8:53am

I just saw this in the logs

(node:27) MaxListenersExceededWarning: Possible EventEmitter memory leak detected. 11 discover listeners added to [Noble]. Use emitter.setMaxListeners() to increase limit
(Use `node --trace-warnings ...` to show where the warning was created)
(node:27) MaxListenersExceededWarning: Possible EventEmitter memory leak detected. 11 scanStop listeners added to [Noble]. Use emitter.setMaxListeners() to increase limit

spenceur · March 9, 2022, 12:23pm

I tried to monitor this morning and no issues on the local instance, even DNS

spenceur · March 9, 2022, 5:50pm

Après check ce soir, à pars le look de la db pour faire un backup rien de choquant non?

2022-03-09T17:10:10+0100 <info> device.calculateAggregate.js:38 (DeviceManager.calculateAggregate) Calculating aggregates device feature state for interval hourly
2022-03-09T17:10:14+0100 <info> gateway.backup.js:34 (Gateway.backup) Gateway backup: Locking Database
2022-03-09T17:10:15+0100 <info> gateway.backup.js:37 (Gateway.backup) Starting Gateway backup in folder /var/lib/gladysassistant/backups/gladys-db-backup-2022-3-9-17-10-13.db
2022-03-09T17:10:24+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T17:10:24+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T17:10:43+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T17:10:43+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T17:10:58+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T17:10:58+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T17:11:13+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T17:11:13+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T17:11:28+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T17:11:28+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T17:11:29+0100 <warn> device.calculateAggregate.js:95 (Socket.<anonymous>) device.calculateAggregate stderr: TimeoutError [SequelizeTimeoutError]: SQLITE_BUSY: database is locked
    at Query.formatError (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:412:16)
    at Query._handleQueryResponse (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:72:18)
    at Statement.afterExecute (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:246:27) {
  parent: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_hourly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  original: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_hourly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  sql: 'UPDATE `t_device_feature` SET `last_hourly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3',
  parameters: undefined
}

2022-03-09T17:11:29+0100 <warn> device.calculateAggregate.js:101 (ChildProcess.<anonymous>) device.calculateAggregate: Exiting child process with code 1
2022-03-09T17:11:29+0100 <error> device.onHourlyDeviceAggregateEvent.js:22 (DeviceManager.onHourlyDeviceAggregateEvent) Error: TimeoutError [SequelizeTimeoutError]: SQLITE_BUSY: database is locked
    at Query.formatError (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:412:16)
    at Query._handleQueryResponse (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:72:18)
    at Statement.afterExecute (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:246:27) {
  parent: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_hourly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  original: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_hourly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  sql: 'UPDATE `t_device_feature` SET `last_hourly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3',
  parameters: undefined
}

    at ChildProcess.<anonymous> (/src/server/lib/device/device.calculateAggregate.js:102:23)
    at ChildProcess.emit (events.js:400:28)
    at maybeClose (internal/child_process.js:1058:16)
    at Socket.<anonymous> (internal/child_process.js:443:11)
    at Socket.emit (events.js:400:28)
    at Pipe.<anonymous> (net.js:686:12)
2022-03-09T17:11:33+0100 <info> device.calculateAggregate.js:38 (DeviceManager.calculateAggregate) Calculating aggregates device feature state for interval daily
2022-03-09T17:11:44+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T17:11:44+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T17:12:13+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T17:12:13+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T17:12:20+0100 <warn> device.calculateAggregate.js:95 (Socket.<anonymous>) device.calculateAggregate stderr: TimeoutError [SequelizeTimeoutError]: SQLITE_BUSY: database is locked
    at Query.formatError (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:412:16)
    at Query._handleQueryResponse (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:72:18)
    at Statement.afterExecute (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:246:27) {
  parent: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_daily_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  original: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
2022-03-09T17:12:26+0100 <info> device.calculateAggregate.js:38 (DeviceManager.calculateAggregate) Calculating aggregates device feature state for interval monthly
    sql: 'UPDATE `t_device_feature` SET `last_daily_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  sql: 'UPDATE `t_device_feature` SET `last_daily_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3',
  parameters: undefined
}

2022-03-09T17:12:20+0100 <warn> device.calculateAggregate.js:101 (ChildProcess.<anonymous>) device.calculateAggregate: Exiting child process with code 1
2022-03-09T17:12:20+0100 <error> device.onHourlyDeviceAggregateEvent.js:27 (DeviceManager.onHourlyDeviceAggregateEvent) Error: TimeoutError [SequelizeTimeoutError]: SQLITE_BUSY: database is locked
    at Query.formatError (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:412:16)
    at Query._handleQueryResponse (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:72:18)
    at Statement.afterExecute (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:246:27) {
  parent: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_daily_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  original: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_daily_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  sql: 'UPDATE `t_device_feature` SET `last_daily_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3',
  parameters: undefined
}

    at ChildProcess.<anonymous> (/src/server/lib/device/device.calculateAggregate.js:102:23)
    at ChildProcess.emit (events.js:400:28)
    at maybeClose (internal/child_process.js:1058:16)
    at Process.ChildProcess._handle.onexit (internal/child_process.js:293:5)
2022-03-09T17:12:27+0100 <error> index.js:15 (process.<anonymous>) unhandledRejection catched: Promise {
  <rejected> [Error: ENOENT: no such file or directory, open '/tmp/gladysassistant/camera-77a26676-f39c-41b6-9a0f-1253a254c917-281-24-12-17.jpg'] {
    errno: -2,
    code: 'ENOENT',
    syscall: 'open',
    path: '/tmp/gladysassistant/camera-77a26676-f39c-41b6-9a0f-1253a254c917-281-24-12-17.jpg'
  }
}
2022-03-09T17:12:27+0100 <error> index.js:16 (process.<anonymous>) [Error: ENOENT: no such file or directory, open '/tmp/gladysassistant/camera-77a26676-f39c-41b6-9a0f-1253a254c917-281-24-12-17.jpg'] {
  errno: -2,
  code: 'ENOENT',
  syscall: 'open',
  path: '/tmp/gladysassistant/camera-77a26676-f39c-41b6-9a0f-1253a254c917-281-24-12-17.jpg'
}
2022-03-09T17:12:33+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature illuminance not configured in Gladys.
2022-03-09T17:12:33+0100 <warn> handleMqttMessage.js:100 () Zigbee2mqtt device 0x54ef4410000c1618, feature linkquality not configured in Gladys.
2022-03-09T17:12:40+0100 <warn> device.calculateAggregate.js:95 (Socket.<anonymous>) device.calculateAggregate stderr: TimeoutError [SequelizeTimeoutError]: SQLITE_BUSY: database is locked
    at Query.formatError (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:412:16)
    at Query._handleQueryResponse (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:72:18)
    at Statement.afterExecute (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:246:27) {
  parent: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_monthly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  original: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_monthly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  sql: 'UPDATE `t_device_feature` SET `last_monthly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3',
  parameters: undefined
}

2022-03-09T17:12:40+0100 <warn> device.calculateAggregate.js:101 (ChildProcess.<anonymous>) device.calculateAggregate: Exiting child process with code 1
2022-03-09T17:12:40+0100 <error> device.onHourlyDeviceAggregateEvent.js:32 (DeviceManager.onHourlyDeviceAggregateEvent) Error: TimeoutError [SequelizeTimeoutError]: SQLITE_BUSY: database is locked
    at Query.formatError (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:412:16)
    at Query._handleQueryResponse (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:72:18)
    at Statement.afterExecute (/src/server/node_modules/sequelize/lib/dialects/sqlite/query.js:246:27) {
  parent: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_monthly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  original: [Error: SQLITE_BUSY: database is locked] {
    errno: 5,
    code: 'SQLITE_BUSY',
    sql: 'UPDATE `t_device_feature` SET `last_monthly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3'
  },
  sql: 'UPDATE `t_device_feature` SET `last_monthly_aggregate`=$1,`updated_at`=$2 WHERE `id` = $3',
  parameters: undefined
}

    at ChildProcess.<anonymous> (/src/server/lib/device/device.calculateAggregate.js:102:23)
    at ChildProcess.emit (events.js:400:28)
    at maybeClose (internal/child_process.js:1058:16)
    at Process.ChildProcess._handle.onexit (internal/child_process.js:293:5)

spenceur · March 9, 2022, 5:52pm

Oh, I had another DNS issue!

2022-03-09T17:07:16+0100 <error> index.js:15 (process.<anonymous>) unhandledRejection catched: Promise {
  <rejected> Error: getaddrinfo EAI_AGAIN api.gladysgateway.com
      at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:71:26) {
    errno: -3001,
    code: 'EAI_AGAIN',
    syscall: 'getaddrinfo',
    hostname: 'api.gladysgateway.com',
    config: {
      url: 'https://api.gladysgateway.com/instances/users',
      method: 'get',
      headers: [Object],
      transformRequest: [Array],
      transformResponse: [Array],
      timeout: 0,
      adapter: [Function: httpAdapter],
      xsrfCookieName: 'XSRF-TOKEN',
      xsrfHeaderName: 'X-XSRF-TOKEN',
      maxContentLength: -1,
      maxBodyLength: -1,
      validateStatus: [Function: validateStatus],
      data: undefined
    },
    request: Writable {
      _writableState: [WritableState],
      _events: [Object: null prototype],
      _eventsCount: 2,
      _maxListeners: undefined,
      _options: [Object],
      _ended: true,
      _ending: true,
      _redirectCount: 0,
      _redirects: [],
      _requestBodyLength: 0,
      _requestBodyBuffers: [],
      _onNativeResponse: [Function (anonymous)],
      _currentRequest: [ClientRequest],
      _currentUrl: 'https://api.gladysgateway.com/instances/users',
      [Symbol(kCapture)]: false
    },
    response: undefined,
    isAxiosError: true,
    toJSON: [Function: toJSON]
  }
}

pierre-gilles · March 9, 2022, 5:53pm

Hello! I just checked your logs, nothing seems wrong to me.

You even have the message « Gladys Gateway: connected in websockets » which means your instance is able to connect to Gladys Plus.

On the Gladys Plus frontend (plus.gladysassistant.com), do you still have the error « NO_INSTANCE_FOUND » in the logs? Can you confirm that your frontend is completely broken (nothing works)?

Topic		Replies	Views
Actions ne se chargent pas dans une grande scène Configuration	35	1219	May 16, 2022
Gladys Assistant v4.25.1: Tasmota, et correction de bugs! Actualités	22	859	July 17, 2023
Bug dashboard graphique "Grouper par" avec valeur identique Configuration	23	145	June 20, 2025
Dashboard - Evolutions / Bugs / etc Développement	141	6673	November 21, 2023
[RESOLU] Lenteur parfois sur dashboard Gladys Plus Configuration	48	1929	February 23, 2021

[RESOLVED] Issue creating chart on Gladys+

Related topics