-
Notifications
You must be signed in to change notification settings - Fork 4
DATABASES
The influxDB service is not started directly at boot of the RPI-ECU. It can take a long time before it is running. It seems to index its databases first.
No maintenance / backup / restore can be done before it is running. With the 'healthcheck influx' we can test whether it is running or not
(menu->databases->healthcheck influx).
The measured values from the inverters are stored in databases. The daily energy increases and calculated powervalues are stored in database 'invData'. The Energy values from this database are totalized each day and stored in 'invEnergy'. The databases are used to make charts and statistics and to keep history.
When you installed a new sd-card image, your system contains an inverter and its data in the database. You should remove that.
Please see here
You can issue some commands to maintain your databases. Got to menu->databases and choose an action.
- healthcheck will show you whether the influxDB is running or not.
- in the energy database you can edit values for a specific date and inverter.
- you can query values for a certain date/inverter from the databases. You can also edit the values for a certain date/inverter in the energy database. (menu->databases->edit).
When you have been using the RPI_ECU and you need to install a new sd-card, you can make a backup first. This contains
- your existing databases.
- your settings
Go to the menu->databases->backup and follow the leads. Now a file will be made like '20220615-ecu_backup.tar' that you can download to your computer.
When you have a backup please notice that this is a backup of your settings and databases. If you want to restore it, (p.e. when you installed a new sd-card) you should do this in the period between midnight and wake-up of the system.
Make sure that the influx db is running (menu->databases->healthcheck influx) and you expanded the filesystem.
Go to menu->databases->restore and follow the leads.
You can check the results by running a query via the menu databases for a date that should have data.
The restore sometimes does not succeed the first time. Jou can just try it a second time or more until it succeeded.