with
- Code: Select all
<ValueType>Number</ValueType>
When setting them with a float number (updatedevicestateonserver() indigo THEN changes the sql data type to REAL.
That transaction takes a long time in the sql database as all previous entries must be converted to real. When the database is very large (20Gbyte in my case) indigo timeouts waiting for the transaction to finish.
Then many things go wrong (20 pages of red error messages) and the only option is to stop the sqllogger plugin and restart it with other plugins disabled to stop writing to the database. After all states have been converted to REAL I can restart the other plugins and everything runs fine again.
Is there anyway to
1. initialize the device/state as real and not integer
2. increase the sql wait-time
?
thanks
Karl