Possibility of changing feed type from memory to mysql

Emoncms
1

Hello, I have been using emoncms for years and my database was created in 2010. I use a raspberry 4 on an ssd disk and therefore I have no writing problems.

The latest feeds created are of the MEMORY type, so with every restart (very rare but unfortunately it can be necessary) I lose the feed history.

Would it be possible to transform them into mysql by intervening directly on Mariadb via query?

Or, how should I operate to change the feed type? Thank you

2

Totally or just a few minutes gap?

3

Unfortunately total

4

Something not right with your setup then. It should be writing to a file and not holding it all in memory.

What is your setup? (base OS, how installed, how old etc).

5

Server

CPU
1 Threads(s) | 4 Core(s) | 1 Sockets(s) | Cortex-A72 | 324.00MIPS |
OS
Linux 5.10.63-v7l+
Host
emoncmsServer2k21 | emoncmsServer2k21 | (192.168.0.25)
Data
2023-05-22 15:56:26 CEST
Uptime
15:56:26 up 19 days, 3:50, 1 user, load average: 0,21, 0,32, 0,50 HTTP

Server
Apache/2.4.51 (Raspbian) HTTP/1.1 CGI/1.1 80

MySQL

Versione
5.5.5-10.5.12-MariaDB-0+deb11u1-log
Host
127.0.0.1 (127.0.0.1)
Data
2023-05-22 15:56:26 (UTC 02:00‌​)
Statistiche
Uptime: 1674676 Threads: 25 Questions: 34775010 Slow queries: 3 Opens: 1156 Open tables: 1148 Queries per second avg: 20.765

Redis

Versione

Redis Server
    6.0.16
PHP Redis
    5.3.4

Powered by OpenEnergyMonitor.org | low-write 11.2.3

immagine

il problema riguarda solo i feed con indicato MEMORY , tutti gli altri con indicato MYSQL funzionano regolarmente

6

How did you install this? Clearly a non standard install.

How did you create those feeds?

7

The problem was introduced from version 11, before in the menu there was normal mysql, now only mysql memory.

immagine

So i checked mariadb, the feed exists as a table and is getting the values ​​regularly.

In the feed table I noticed that the engine field of the latest feeds has the value 8, while the old ones have the value 0.

Therefore I assume that by upgrading that value, the feed passes from memory to mysql without any problem.

You can confirm ?

8

Changing the number wont work alone.
You need to change the feed type on mysql itself or recreate it.
Memory feeds lose its data after a restart.

9

@TrystanLea will need to answer this one.

10

Hello @michelino It sounds like your settings.ini configuration may be hiding the MYSQL TimeSeries engine. What does the following entry look like for you?

[feed]
engines_hidden = [6,10]
1 Like