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

3 years 9 months ago - 3 years 9 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.

3 years 9 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.

3 years 9 months ago #385 by Xavier
Sorry!

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

3 years 9 months ago - 3 years 9 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.

3 years 9 months ago - 3 years 9 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.

3 years 9 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.195 seconds