[Solved] On page_co... some charts report en error

10 years 10 months ago - 10 years 10 months ago #377 by Xavier
Hi again,
Running EasyIoT v0.6b01, after several hours of recording, the charts from 2/4 sensors don't show and a popup report a message like:
Error /Api/EasyIoT/Control/Data/MySensors/N13S2/Sensor.Humidity/Week/
What can I do to troubleshoot?

Please Log in or Create an account to join the conversation.

10 years 10 months ago #380 by EasyIoT
You are using very old beta version of EasyIoT server.

Please Log in or Create an account to join the conversation.

10 years 10 months ago #385 by Xavier

Please Log in or Create an account to join the conversation.

10 years 10 months ago - 10 years 10 months ago #399 by Xavier
The problem remains with v0.7b0 :S
As previously in v06b01, it always appears on the same node, the Node 02 (of 2), when the dBase is populated with several hours of recording.
Once it appears, I can:
- stop the server and restart,
- allow some new records,
- open the browser on the chart page
-> if I add to the chart view a sensor belonging to node 2 the error popup.
It looks like a corrupted DBase but no error appears in the logs.
If I clear the database, it solves the issue... but I loose my data and it's not the purpose :(
---
Couldn't find my way to add an attachement (does it work?). Anyway, here is a screenshot.
[img size=400]http://x.muller.free.fr/ScreenSHOT/easyiot v07b01 - bug on chart.png

Please Log in or Create an account to join the conversation.

10 years 10 months ago - 10 years 10 months ago #400 by Xavier
I'm currently investigating the sqlite database, using the SQLite Manager addon for FireFox.
The presumably faulty dBase weights 300kB.
- An integrity full check reports OK
- All tables seem conform to what I setup:
  • Addresses: holds 4 records N1S0,N1S1,N2S2,N2S3 (as N1S2,N1S3,N2S0 & N2S1 are not populated I don't record the NaNs)
  • domains: holds only MySensors as others are inactivated
  • properties: currently only holds Sensor.Humidity & Sensor.Temperature
  • raw_values: holds 7380 samples
  • sqlite_sequence: reports the correct size of the 4 previous tables
What can I check now?
- Do the records need to have sequencial timestamps? (it might crash if a race condition occurs) what SQL command should I use to test that?

Nota: The error message is the same when the server is down (which is not the case).

Please Log in or Create an account to join the conversation.

10 years 10 months ago #417 by EasyIoT
Send me config folder and EasyIoTDatabase.sqlite. I will check.
The following user(s) said Thank You: Xavier

Please Log in or Create an account to join the conversation.

Time to create page: 0.155 seconds

Forum latest

  • No posts to display.