Feeds are missing after reboot

Hi there,
I am running
OpenEnergyMonitor.org | low-write 9.8.31 | 2018.06.21
for a couple of weeks and worked well. During the weeks I added some more input calculations and used the associated feed in graphs. Now after first reboot the new feeds are missing and also the new calculation on input have disappeared. I did a test and made a new calculation/feed. That worked fine but after reboot also vanished. I am puzzeld, looks like the changes only exist in memory and got lost after reboot.
Not clear what happens. Has this do with log files? I noticed size of log has changed.

[email protected]:~ $ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/root        59G  5.0G   52G   9% /
devtmpfs        460M     0  460M   0% /dev
tmpfs           464M     0  464M   0% /dev/shm
tmpfs           464M  6.2M  458M   2% /run
tmpfs           5.0M  4.0K  5.0M   1% /run/lock
tmpfs           464M     0  464M   0% /sys/fs/cgroup
tmpfs            30M  7.2M   23M  24% /var/log
tmpfs            30M   16K   30M   1% /tmp
/dev/mmcblk0p1   43M   22M   21M  52% /boot
tmpfs            93M     0   93M   0% /run/user/1000
and after reboot:
[email protected]:~ $ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/root        59G  5.0G   52G   9% /
devtmpfs        460M     0  460M   0% /dev
tmpfs           464M     0  464M   0% /dev/shm
tmpfs           464M  6.2M  458M   2% /run
tmpfs           5.0M  4.0K  5.0M   1% /run/lock
tmpfs           464M     0  464M   0% /sys/fs/cgroup
tmpfs            30M  380K   30M   2% /var/log
tmpfs            30M  4.0K   30M   1% /tmp
/dev/mmcblk0p1   43M   22M   21M  52% /boot
tmpfs            93M     0   93M   0% /run/user/1000
My mount is:
/dev/mmcblk0p2 on / type ext4 (rw,noatime,block_validity,delalloc,barrier,user_xattr,acl)
devtmpfs on /dev type devtmpfs (rw,relatime,size=470116k,nr_inodes=117529,mode=755)
sysfs on /sys type sysfs (rw,nosuid,nodev,noexec,relatime)
proc on /proc type proc (rw,relatime)
tmpfs on /dev/shm type tmpfs (rw,nosuid,nodev)
devpts on /dev/pts type devpts (rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000)
tmpfs on /run type tmpfs (rw,nosuid,nodev,mode=755)
tmpfs on /run/lock type tmpfs (rw,nosuid,nodev,noexec,relatime,size=5120k)
tmpfs on /sys/fs/cgroup type tmpfs (ro,nosuid,nodev,noexec,mode=755)
cgroup on /sys/fs/cgroup/systemd type cgroup (rw,nosuid,nodev,noexec,relatime,xattr,release_agent=/lib/systemd/systemd-cg                                                roups-agent,name=systemd)
cgroup on /sys/fs/cgroup/freezer type cgroup (rw,nosuid,nodev,noexec,relatime,freezer)
cgroup on /sys/fs/cgroup/cpuset type cgroup (rw,nosuid,nodev,noexec,relatime,cpuset)
cgroup on /sys/fs/cgroup/cpu,cpuacct type cgroup (rw,nosuid,nodev,noexec,relatime,cpu,cpuacct)
cgroup on /sys/fs/cgroup/net_cls type cgroup (rw,nosuid,nodev,noexec,relatime,net_cls)
cgroup on /sys/fs/cgroup/blkio type cgroup (rw,nosuid,nodev,noexec,relatime,blkio)
cgroup on /sys/fs/cgroup/devices type cgroup (rw,nosuid,nodev,noexec,relatime,devices)
systemd-1 on /proc/sys/fs/binfmt_misc type autofs (rw,relatime,fd=25,pgrp=1,timeout=0,minproto=5,maxproto=5,direct)
mqueue on /dev/mqueue type mqueue (rw,relatime)
sunrpc on /run/rpc_pipefs type rpc_pipefs (rw,relatime)
debugfs on /sys/kernel/debug type debugfs (rw,relatime)
configfs on /sys/kernel/config type configfs (rw,relatime)
tmpfs on /var/log type tmpfs (rw,nosuid,nodev,relatime,size=30720k)
tmpfs on /tmp type tmpfs (rw,nosuid,nodev,relatime,size=30720k)
/dev/mmcblk0p1 on /boot type vfat (rw,relatime,fmask=0022,dmask=0022,codepage=437,iocharset=ascii,shortname=mixed,errors=                                                remount-ro)
tmpfs on /run/user/1000 type tmpfs (rw,nosuid,nodev,relatime,size=94944k,mode=700,uid=1000,gid=1000)
tracefs on /sys/kernel/debug/tracing type tracefs (rw,relatime)
binfmt_misc on /proc/sys/fs/binfmt_misc type binfmt_misc (rw,relatime)

Any help/support is appreciated
Jan

/var/log is a tmpfs Filesystem - it is cleared after each reboot.
That isn’t where your problem lies though.

Here’s a df -h from my emonCMS pi:

[email protected](ro):~$ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/root       3.4G  2.3G  982M  70% /
devtmpfs        481M     0  481M   0% /dev
tmpfs           486M     0  486M   0% /dev/shm
tmpfs           486M   50M  437M  11% /run
tmpfs           5.0M  4.0K  5.0M   1% /run/lock
tmpfs           486M     0  486M   0% /sys/fs/cgroup
tmpfs            40M  6.6M   34M  17% /var/lib/openhab
/dev/mmcblk0p1   60M   22M   39M  37% /boot
tmpfs           1.0M  4.0K 1020K   1% /var/lib/dhcpcd5
tmpfs           1.0M     0  1.0M   0% /var/lib/dhcp
tmpfs            50M  8.0M   43M  16% /var/log
tmpfs            30M   32K   30M   1% /tmp
/dev/mmcblk0p3  3.8G  248M  3.4G   7% /home/pi/data

All of the persistent data (stuff that stays around between reboots) from EmonCMS should be on:

/dev/mmcblk0p3  3.8G  248M  3.4G   7% /home/pi/data

which I don’t see in your list.

How did you install it exactly?

OK, I understand with tmpfs.
I installed using exactly the description from emoncms/readme.md at master · emoncms/emoncms · GitHub
with emoncms/Low-write-mode.md at master · emoncms/emoncms · GitHub
I never saw a /dev/mmcblk0p3. Where/how/when should it be created?
There is no data dir under home/pi.

[email protected]:~ $ pwd
/home/pi
[email protected]:~ $ ls -al
total 156
drwxr-xr-x 21 pi   pi    4096 Aug  7 15:21 .
drwxr-xr-x  3 root root  4096 Apr 17 20:16 ..
-rw-------  1 pi   pi    6298 Aug  9 17:59 .bash_history
-rw-r--r--  1 pi   pi     220 Apr 17 20:16 .bash_logout
-rw-r--r--  1 pi   pi    3523 Apr 17 20:16 .bashrc
drwxr-xr-x  7 pi   pi    4096 Jul 13 12:47 .cache
drwx------ 14 pi   pi    4096 Jul 14 16:18 .config
drwx------  3 pi   pi    4096 Apr 17 21:29 .dbus
-rw-r--r--  1 pi   pi     146 Aug  9 07:59 dead.letter
drwxr-xr-x  2 pi   pi    4096 Apr 17 21:25 Desktop
drwxr-xr-x  2 pi   pi    4096 Apr 17 21:25 Documents
drwxr-xr-x  2 pi   pi    4096 Apr 17 21:25 Downloads
drwx------  3 pi   pi    4096 Apr 17 21:25 .gnupg
drwxr-xr-x  2 pi   pi    4096 Jul 14 16:02 .gstreamer-0.10
drwxr-xr-x  3 pi   pi    4096 Apr 17 20:57 .local
drwxr-xr-x  2 pi   pi    4096 Jul 14 15:55 Music
drwxr-xr-x  2 pi   pi    4096 Jul 14 08:00 .nano
drwxr-xr-x  4 pi   pi    4096 Jul 13 08:19 oldconffiles
drwxr-xr-x  2 pi   pi    4096 Apr 17 21:25 Pictures
drwx------  3 pi   pi    4096 Jul 13 12:47 .pki
-rw-r--r--  1 pi   pi     675 Apr 17 20:16 .profile
drwxr-xr-x  2 pi   pi    4096 Apr 17 21:25 Public
drwxr-xr-x  2 pi   pi    4096 Apr 17 20:57 python_games
drwxr-xr-x  2 pi   pi    4096 Apr 17 21:25 Templates
drwxr-xr-x  3 pi   pi    4096 Jul 13 12:41 .themes
drwxr-xr-x  2 pi   pi    4096 Jul 14 16:06 Videos
-rw-------  1 pi   pi      56 Jul 14 16:54 .Xauthority
-rw-------  1 pi   pi   35340 Jul 14 15:33 .xsession-errors
-rw-------  1 pi   pi    3954 Apr 17 21:31 .xsession-errors.old

Ok, I’ve had a quick read through emoncms/Low-write-mode.md at master · emoncms/emoncms · GitHub and it looks like it doesn’t make the filesystem read-only:

The “low-write” SD Card image is designed to reduce wear on an SD card. It it does this by making the root partition / read-only, keeps a lot of “files” in memory and then flushes them out to a separate read/write partition.

Is there any reason you didn’t use the SD Card image?

Hi Greebo, thanks for your support.
You are right, my filesystem is not read only at the moment, see the mount list. I don’t think that is a problem. It should make it only more robust.
The low-write is working, I can see the buffering in the Administration.

To my understanding the SD Card image is for using emontx and emoncms. I did not need emontx because I have a separate own build emon based on Arduinio Due. Therefore I thought this was the best way to go.

I checked a bit further and there is no data dir that contains emoncms data. Where is the /home/p[/data for? I presume the data all does into the database?

I am not an expert with databases, but had a check with phpmyadmin. Under feeds all my new created feeds are still there. They only seem not to be displayed on the feed list and are I can’t select them any more for new graphs. In some way the db is not read completely any more after reboot. What could cause this?

If you followed the Pi installation guide, it tells you here to create the data directories under /var/lib/ did you do this?
If so, then that’s where your data files should be stored, assuming that you haven’t changed this section in your settings.php file.

If you do decide to put your Pi into read-only, then of course you will need to create a ‘writeable’ partition, and move your data files there, as well as changing the paths in settings.php.
See this guide for details how.

Paul

Are you saying the database is actually getting updated? Have a look under /var/lib as Paul suggested and confirm last modified times on the mysql database files (default is /var/lib/mysql)

yes, all is updated. Dir are created on 13july

ls -al /var/lib/{phpfiwa,phpfina,phptimeseries}
/var/lib/phpfina:
total 13492
drwxr-xr-x  2 www-data root       4096 Aug  5 07:05 .
drwxr-xr-x 52 root     root       4096 Jul 13 13:00 ..
-rw-r--r--  1 www-data www-data 987936 Aug 11 06:30 10.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 16:26 10.meta
-rw-r--r--  1 www-data www-data 987868 Aug 11 06:30 11.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 16:29 11.meta
-rw-r--r--  1 www-data www-data 987860 Aug 11 06:30 12.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 16:30 12.meta
-rw-r--r--  1 www-data www-data 987856 Aug 11 06:30 13.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 16:30 13.meta
-rw-r--r--  1 www-data www-data 770920 Aug  7 15:12 15.dat
-rw-r--r--  1 www-data www-data     16 Jul 16 07:55 15.meta
-rw-r--r--  1 www-data www-data    232 Aug  7 15:02 18.dat
-rw-r--r--  1 www-data www-data     16 Aug  5 06:41 18.meta
-rw-r--r--  1 www-data www-data 991864 Aug 11 06:30 1.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 13:43 1.meta
-rw-r--r--  1 www-data www-data 991852 Aug 11 06:30 2.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 13:43 2.meta
-rw-r--r--  1 www-data www-data 991828 Aug 11 06:30 3.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 13:44 3.meta
-rw-r--r--  1 www-data www-data 991824 Aug 11 06:30 4.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 13:44 4.meta
-rw-r--r--  1 www-data www-data 991816 Aug 11 06:30 5.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 13:45 5.meta
-rw-r--r--  1 www-data www-data 991808 Aug 11 06:30 6.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 13:45 6.meta
-rw-r--r--  1 www-data www-data 987948 Aug 11 06:30 7.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 16:26 7.meta
-rw-r--r--  1 www-data www-data 987944 Aug 11 06:30 8.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 16:26 8.meta
-rw-r--r--  1 www-data www-data 987940 Aug 11 06:30 9.dat
-rw-r--r--  1 www-data www-data     16 Jul 13 16:26 9.meta

/var/lib/phpfiwa:
total 8
drwxr-xr-x  2 www-data root 4096 Jul 13 08:52 .
drwxr-xr-x 52 root     root 4096 Jul 13 13:00 ..

/var/lib/phptimeseries:
total 200
drwxr-xr-x  2 www-data root       4096 Aug 10 06:38 .
drwxr-xr-x 52 root     root       4096 Jul 13 13:00 ..
-rw-r--r--  1 www-data www-data 179955 Aug  7 15:12 feed_19.MYD
-rw-r--r--  1 www-data www-data     18 Aug  7 15:12 feed_20.MYD
-rw-r--r--  1 www-data www-data      9 Aug  9 07:14 feed_21.MYD
-rw-r--r--  1 www-data www-data     18 Aug 11 06:30 feed_22.MYD
[email protected]:~ $ ls -al /var/lib/{phpfiwa,phpfina,phptimeseries}

If I look in setup/feeds then I got feeds 1-13 and then 22. 22 is the one I made after last reboot and gets updated as it shows on the date/time. 19,20,21 are the ones I made after installation on 13 July and are not updated any more. However they are still in the database, which shows feeds for 1…12,13,15,19,20,21,22
So question is why 19,20,21 are not updated any more and not listed in settings/feeds?

Hi Paul, thanks for your support.
I created the dirs and did chown as in the guide, see below at answer to Greebo.
I did not do the read-only at installation and as my mount listing shows it is rw.

Do you have any active input processes updating 19.20 & 21?
If you set the emoncms log level to ‘1’ , restart emoncms, does anything show up in the log?

19 20, 21 were there before last reboot in setup/feeds list, but have disappeared after the reboot. Also not visible in the setup/input any more

After reboot and log=1 I get the following

2018-08-11 12:17:04.963|INFO|index.php|feed/list.json

  2018-08-11 12:17:05.086|INFO|rememberme_model.php|login

  2018-08-11 12:17:05.093|INFO|rememberme_model.php|findTriplet TRIPLET_FOUND

  2018-08-11 12:17:05.094|INFO|rememberme_model.php|cleanTriplet success

  2018-08-11 12:17:05.096|INFO|rememberme_model.php|setCookie: 1|b7404f7f245bb3785ceb7f907664fca0|37f3f9d42fff06bc4f944a3edb9d0ddf 1541765825

  2018-08-11 12:17:05.145|INFO|index.php|feed/list.json

  2018-08-11 12:17:05.204|INFO|rememberme_model.php|cookieIsValid

  2018-08-11 12:17:05.205|INFO|rememberme_model.php|findTriplet TRIPLET_INVALID

  2018-08-11 12:17:05.206|INFO|user_model.php|logout

  2018-08-11 12:17:05.206|INFO|rememberme_model.php|clearCookie

  2018-08-11 12:17:05.206|INFO|rememberme_model.php|setCookie:  1526213825

  2018-08-11 12:17:05.206|INFO|rememberme_model.php|clearCookie call to cleanTriplet

  2018-08-11 12:17:05.207|INFO|rememberme_model.php|cleanTriplet success

  2018-08-11 12:17:06.054|INFO|feedwriter.php|Starting feedwriter script

  2018-08-11 12:17:06.085|INFO|feed_model.php|EngineClass() Autoloaded new instance of 'RedisBuffer'.

  2018-08-11 12:17:06.887|INFO|index.php|feed/list.json

  2018-08-11 12:17:06.893|INFO|rememberme_model.php|login

  2018-08-11 12:17:06.894|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:17:11.882|INFO|index.php|feed/list.json

  2018-08-11 12:17:11.887|INFO|rememberme_model.php|login

  2018-08-11 12:17:11.888|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:17:16.888|INFO|index.php|feed/list.json

  2018-08-11 12:17:16.894|INFO|rememberme_model.php|login

  2018-08-11 12:17:16.894|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:17:21.891|INFO|index.php|feed/list.json

  2018-08-11 12:17:21.897|INFO|rememberme_model.php|login

  2018-08-11 12:17:21.898|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:17:34.295|INFO|index.php|feed/list.json

  2018-08-11 12:17:34.301|INFO|rememberme_model.php|login

  2018-08-11 12:17:34.302|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:17:39.310|INFO|index.php|feed/list.json

  2018-08-11 12:17:39.316|INFO|rememberme_model.php|login

  2018-08-11 12:17:39.317|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:17:44.302|INFO|index.php|feed/list.json

  2018-08-11 12:17:44.307|INFO|rememberme_model.php|login

  2018-08-11 12:17:44.308|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:17:49.297|INFO|index.php|feed/list.json

  2018-08-11 12:17:49.302|INFO|rememberme_model.php|login

  2018-08-11 12:17:49.303|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:17:54.310|INFO|index.php|feed/list.json

  2018-08-11 12:17:54.316|INFO|rememberme_model.php|login

  2018-08-11 12:17:54.316|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:17:59.305|INFO|index.php|feed/list.json

  2018-08-11 12:17:59.311|INFO|rememberme_model.php|login

  2018-08-11 12:17:59.311|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:04.297|INFO|index.php|feed/list.json

  2018-08-11 12:18:04.303|INFO|rememberme_model.php|login

  2018-08-11 12:18:04.304|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:09.304|INFO|index.php|feed/list.json

  2018-08-11 12:18:09.310|INFO|rememberme_model.php|login

  2018-08-11 12:18:09.311|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:14.304|INFO|index.php|feed/list.json

  2018-08-11 12:18:14.310|INFO|rememberme_model.php|login

  2018-08-11 12:18:14.310|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:19.299|INFO|index.php|feed/list.json

  2018-08-11 12:18:19.305|INFO|rememberme_model.php|login

  2018-08-11 12:18:19.305|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:24.304|INFO|index.php|feed/list.json

  2018-08-11 12:18:24.310|INFO|rememberme_model.php|login

  2018-08-11 12:18:24.310|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:29.305|INFO|index.php|feed/list.json

  2018-08-11 12:18:29.311|INFO|rememberme_model.php|login

  2018-08-11 12:18:29.311|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:34.299|INFO|index.php|feed/list.json

  2018-08-11 12:18:34.305|INFO|rememberme_model.php|login

  2018-08-11 12:18:34.305|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:39.306|INFO|index.php|feed/list.json

  2018-08-11 12:18:39.312|INFO|rememberme_model.php|login

  2018-08-11 12:18:39.312|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:39.772|INFO|index.php|input/post.json

  2018-08-11 12:18:39.827|INFO|feed_model.php|insert_data() feedid=12 updatetime=1533989919 feedtime=1533989919 value=224.45 arg=

  2018-08-11 12:18:39.834|INFO|feed_model.php|EngineClass() Autoloaded new instance of 'RedisBuffer'.

  2018-08-11 12:18:39.836|INFO|feed_model.php|insert_data() feedid=13 updatetime=1533989919 feedtime=1533989919 value=207.31 arg=

  2018-08-11 12:18:39.837|INFO|feed_model.php|insert_data() feedid=1 updatetime=1533989919 feedtime=1533989919 value=0 arg=

  2018-08-11 12:18:39.839|INFO|feed_model.php|insert_data() feedid=2 updatetime=1533989919 feedtime=1533989919 value=0 arg=

  2018-08-11 12:18:39.840|INFO|feed_model.php|insert_data() feedid=3 updatetime=1533989919 feedtime=1533989919 value=40.29 arg=

  2018-08-11 12:18:39.842|INFO|feed_model.php|insert_data() feedid=4 updatetime=1533989919 feedtime=1533989919 value=0 arg=

  2018-08-11 12:18:39.843|INFO|feed_model.php|insert_data() feedid=7 updatetime=1533989919 feedtime=1533989919 value=167.62 arg=

  2018-08-11 12:18:39.845|INFO|feed_model.php|insert_data() feedid=8 updatetime=1533989919 feedtime=1533989919 value=0 arg=

  2018-08-11 12:18:39.846|INFO|feed_model.php|insert_data() feedid=9 updatetime=1533989919 feedtime=1533989919 value=-0.6 arg=

  2018-08-11 12:18:39.847|INFO|feed_model.php|insert_data() feedid=10 updatetime=1533989919 feedtime=1533989919 value=0 arg=

  2018-08-11 12:18:39.849|INFO|feed_model.php|insert_data() feedid=5 updatetime=1533989919 feedtime=1533989919 value=419335.75 arg=

  2018-08-11 12:18:39.850|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989919 feedtime=1533989919 value=385 arg=

  2018-08-11 12:18:39.852|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989919 feedtime=1533989919 value=385 arg=join

  2018-08-11 12:18:39.854|INFO|feed_model.php|insert_data() feedid=11 updatetime=1533989919 feedtime=1533989919 value=8.3079509 arg=

  2018-08-11 12:18:44.309|INFO|index.php|feed/list.json

  2018-08-11 12:18:44.314|INFO|rememberme_model.php|login

  2018-08-11 12:18:44.315|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:49.300|INFO|index.php|feed/list.json

  2018-08-11 12:18:49.306|INFO|rememberme_model.php|login

  2018-08-11 12:18:49.306|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:49.558|INFO|index.php|input/post.json

  2018-08-11 12:18:49.601|INFO|feed_model.php|insert_data() feedid=12 updatetime=1533989929 feedtime=1533989929 value=223.32 arg=

  2018-08-11 12:18:49.602|INFO|feed_model.php|EngineClass() Autoloaded new instance of 'RedisBuffer'.

  2018-08-11 12:18:49.603|INFO|feed_model.php|insert_data() feedid=13 updatetime=1533989929 feedtime=1533989929 value=208.01 arg=

  2018-08-11 12:18:49.605|INFO|feed_model.php|insert_data() feedid=1 updatetime=1533989929 feedtime=1533989929 value=0 arg=

  2018-08-11 12:18:49.606|INFO|feed_model.php|insert_data() feedid=2 updatetime=1533989929 feedtime=1533989929 value=0 arg=

  2018-08-11 12:18:49.607|INFO|feed_model.php|insert_data() feedid=3 updatetime=1533989929 feedtime=1533989929 value=40.04 arg=

  2018-08-11 12:18:49.609|INFO|feed_model.php|insert_data() feedid=4 updatetime=1533989929 feedtime=1533989929 value=0 arg=

  2018-08-11 12:18:49.610|INFO|feed_model.php|insert_data() feedid=7 updatetime=1533989929 feedtime=1533989929 value=167.97 arg=

  2018-08-11 12:18:49.612|INFO|feed_model.php|insert_data() feedid=8 updatetime=1533989929 feedtime=1533989929 value=0 arg=

  2018-08-11 12:18:49.613|INFO|feed_model.php|insert_data() feedid=9 updatetime=1533989929 feedtime=1533989929 value=0 arg=

  2018-08-11 12:18:49.615|INFO|feed_model.php|insert_data() feedid=10 updatetime=1533989929 feedtime=1533989929 value=0 arg=

  2018-08-11 12:18:49.616|INFO|feed_model.php|insert_data() feedid=5 updatetime=1533989929 feedtime=1533989929 value=419335.75 arg=

  2018-08-11 12:18:49.617|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989929 feedtime=1533989929 value=385 arg=

  2018-08-11 12:18:49.619|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989929 feedtime=1533989929 value=385 arg=join

  2018-08-11 12:18:49.621|INFO|feed_model.php|insert_data() feedid=11 updatetime=1533989929 feedtime=1533989929 value=8.3107279 arg=

  2018-08-11 12:18:54.313|INFO|index.php|feed/list.json

  2018-08-11 12:18:54.319|INFO|rememberme_model.php|login

  2018-08-11 12:18:54.319|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:59.310|INFO|index.php|feed/list.json

  2018-08-11 12:18:59.315|INFO|rememberme_model.php|login

  2018-08-11 12:18:59.316|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:18:59.742|INFO|index.php|input/post.json

  2018-08-11 12:18:59.786|INFO|feed_model.php|insert_data() feedid=12 updatetime=1533989939 feedtime=1533989939 value=224.13 arg=

  2018-08-11 12:18:59.787|INFO|feed_model.php|EngineClass() Autoloaded new instance of 'RedisBuffer'.

  2018-08-11 12:18:59.789|INFO|feed_model.php|insert_data() feedid=13 updatetime=1533989939 feedtime=1533989939 value=206.23 arg=

  2018-08-11 12:18:59.790|INFO|feed_model.php|insert_data() feedid=1 updatetime=1533989939 feedtime=1533989939 value=0 arg=

  2018-08-11 12:18:59.792|INFO|feed_model.php|insert_data() feedid=2 updatetime=1533989939 feedtime=1533989939 value=0 arg=

  2018-08-11 12:18:59.794|INFO|feed_model.php|insert_data() feedid=3 updatetime=1533989939 feedtime=1533989939 value=41.14 arg=

  2018-08-11 12:18:59.795|INFO|feed_model.php|insert_data() feedid=4 updatetime=1533989939 feedtime=1533989939 value=0 arg=

  2018-08-11 12:18:59.797|INFO|feed_model.php|insert_data() feedid=7 updatetime=1533989939 feedtime=1533989939 value=165.76 arg=

  2018-08-11 12:18:59.798|INFO|feed_model.php|insert_data() feedid=8 updatetime=1533989939 feedtime=1533989939 value=0 arg=

  2018-08-11 12:18:59.800|INFO|feed_model.php|insert_data() feedid=9 updatetime=1533989939 feedtime=1533989939 value=-0.67 arg=

  2018-08-11 12:18:59.802|INFO|feed_model.php|insert_data() feedid=10 updatetime=1533989939 feedtime=1533989939 value=0 arg=

  2018-08-11 12:18:59.803|INFO|feed_model.php|insert_data() feedid=5 updatetime=1533989939 feedtime=1533989939 value=419335.75 arg=

  2018-08-11 12:18:59.805|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989939 feedtime=1533989939 value=387 arg=

  2018-08-11 12:18:59.807|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989939 feedtime=1533989939 value=387 arg=join

  2018-08-11 12:18:59.808|INFO|feed_model.php|insert_data() feedid=11 updatetime=1533989939 feedtime=1533989939 value=8.3135049 arg=

  2018-08-11 12:19:04.303|INFO|index.php|feed/list.json

  2018-08-11 12:19:04.309|INFO|rememberme_model.php|login

  2018-08-11 12:19:04.309|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:19:09.315|INFO|index.php|feed/list.json

  2018-08-11 12:19:09.321|INFO|rememberme_model.php|login

  2018-08-11 12:19:09.321|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:19:09.719|INFO|index.php|input/post.json

  2018-08-11 12:19:09.738|INFO|feed_model.php|insert_data() feedid=12 updatetime=1533989949 feedtime=1533989949 value=224.04 arg=

  2018-08-11 12:19:09.739|INFO|feed_model.php|EngineClass() Autoloaded new instance of 'RedisBuffer'.

  2018-08-11 12:19:09.741|INFO|feed_model.php|insert_data() feedid=13 updatetime=1533989949 feedtime=1533989949 value=202.98 arg=

  2018-08-11 12:19:09.742|INFO|feed_model.php|insert_data() feedid=1 updatetime=1533989949 feedtime=1533989949 value=0 arg=

  2018-08-11 12:19:09.744|INFO|feed_model.php|insert_data() feedid=2 updatetime=1533989949 feedtime=1533989949 value=0 arg=

  2018-08-11 12:19:09.745|INFO|feed_model.php|insert_data() feedid=3 updatetime=1533989949 feedtime=1533989949 value=39.7 arg=

  2018-08-11 12:19:09.746|INFO|feed_model.php|insert_data() feedid=4 updatetime=1533989949 feedtime=1533989949 value=0 arg=

  2018-08-11 12:19:09.748|INFO|feed_model.php|insert_data() feedid=7 updatetime=1533989949 feedtime=1533989949 value=163.97 arg=

  2018-08-11 12:19:09.749|INFO|feed_model.php|insert_data() feedid=8 updatetime=1533989949 feedtime=1533989949 value=0 arg=

  2018-08-11 12:19:09.750|INFO|feed_model.php|insert_data() feedid=9 updatetime=1533989949 feedtime=1533989949 value=-0.69 arg=

  2018-08-11 12:19:09.752|INFO|feed_model.php|insert_data() feedid=10 updatetime=1533989949 feedtime=1533989949 value=0 arg=

  2018-08-11 12:19:09.753|INFO|feed_model.php|insert_data() feedid=5 updatetime=1533989949 feedtime=1533989949 value=419335.75 arg=

  2018-08-11 12:19:09.755|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989949 feedtime=1533989949 value=387 arg=

  2018-08-11 12:19:09.757|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989949 feedtime=1533989949 value=387 arg=join

  2018-08-11 12:19:09.758|INFO|feed_model.php|insert_data() feedid=11 updatetime=1533989949 feedtime=1533989949 value=8.3162819 arg=

  2018-08-11 12:19:14.310|INFO|index.php|feed/list.json

  2018-08-11 12:19:14.315|INFO|rememberme_model.php|login

  2018-08-11 12:19:14.316|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:19:19.305|INFO|index.php|feed/list.json

  2018-08-11 12:19:19.311|INFO|rememberme_model.php|login

  2018-08-11 12:19:19.311|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:19:19.771|INFO|index.php|input/post.json

  2018-08-11 12:19:19.814|INFO|feed_model.php|insert_data() feedid=12 updatetime=1533989959 feedtime=1533989959 value=225.71 arg=

  2018-08-11 12:19:19.815|INFO|feed_model.php|EngineClass() Autoloaded new instance of 'RedisBuffer'.

  2018-08-11 12:19:19.817|INFO|feed_model.php|insert_data() feedid=13 updatetime=1533989959 feedtime=1533989959 value=203.86 arg=

  2018-08-11 12:19:19.818|INFO|feed_model.php|insert_data() feedid=1 updatetime=1533989959 feedtime=1533989959 value=0 arg=

  2018-08-11 12:19:19.819|INFO|feed_model.php|insert_data() feedid=2 updatetime=1533989959 feedtime=1533989959 value=0 arg=

  2018-08-11 12:19:19.821|INFO|feed_model.php|insert_data() feedid=3 updatetime=1533989959 feedtime=1533989959 value=40.03 arg=

  2018-08-11 12:19:19.822|INFO|feed_model.php|insert_data() feedid=4 updatetime=1533989959 feedtime=1533989959 value=0 arg=

  2018-08-11 12:19:19.824|INFO|feed_model.php|insert_data() feedid=7 updatetime=1533989959 feedtime=1533989959 value=164.47 arg=

  2018-08-11 12:19:19.825|INFO|feed_model.php|insert_data() feedid=8 updatetime=1533989959 feedtime=1533989959 value=0 arg=

  2018-08-11 12:19:19.827|INFO|feed_model.php|insert_data() feedid=9 updatetime=1533989959 feedtime=1533989959 value=-0.63 arg=

  2018-08-11 12:19:19.828|INFO|feed_model.php|insert_data() feedid=10 updatetime=1533989959 feedtime=1533989959 value=0 arg=

  2018-08-11 12:19:19.830|INFO|feed_model.php|insert_data() feedid=5 updatetime=1533989959 feedtime=1533989959 value=419335.75 arg=

  2018-08-11 12:19:19.831|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989959 feedtime=1533989959 value=387 arg=

  2018-08-11 12:19:19.833|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989959 feedtime=1533989959 value=387 arg=join

  2018-08-11 12:19:19.834|INFO|feed_model.php|insert_data() feedid=11 updatetime=1533989959 feedtime=1533989959 value=8.3190589 arg=

  2018-08-11 12:19:24.312|INFO|index.php|feed/list.json

  2018-08-11 12:19:24.318|INFO|rememberme_model.php|login

  2018-08-11 12:19:24.319|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:19:29.313|INFO|index.php|feed/list.json

  2018-08-11 12:19:29.318|INFO|rememberme_model.php|login

  2018-08-11 12:19:29.319|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:19:29.766|INFO|index.php|input/post.json

  2018-08-11 12:19:29.811|INFO|feed_model.php|insert_data() feedid=12 updatetime=1533989969 feedtime=1533989969 value=224.21 arg=

  2018-08-11 12:19:29.812|INFO|feed_model.php|EngineClass() Autoloaded new instance of 'RedisBuffer'.

  2018-08-11 12:19:29.814|INFO|feed_model.php|insert_data() feedid=13 updatetime=1533989969 feedtime=1533989969 value=203.29 arg=

  2018-08-11 12:19:29.815|INFO|feed_model.php|insert_data() feedid=1 updatetime=1533989969 feedtime=1533989969 value=0 arg=

  2018-08-11 12:19:29.817|INFO|feed_model.php|insert_data() feedid=2 updatetime=1533989969 feedtime=1533989969 value=0 arg=

  2018-08-11 12:19:29.818|INFO|feed_model.php|insert_data() feedid=3 updatetime=1533989969 feedtime=1533989969 value=39.92 arg=

  2018-08-11 12:19:29.820|INFO|feed_model.php|insert_data() feedid=4 updatetime=1533989969 feedtime=1533989969 value=0 arg=

  2018-08-11 12:19:29.822|INFO|feed_model.php|insert_data() feedid=7 updatetime=1533989969 feedtime=1533989969 value=163.38 arg=

  2018-08-11 12:19:29.823|INFO|feed_model.php|insert_data() feedid=8 updatetime=1533989969 feedtime=1533989969 value=0 arg=

  2018-08-11 12:19:29.825|INFO|feed_model.php|insert_data() feedid=9 updatetime=1533989969 feedtime=1533989969 value=0 arg=

  2018-08-11 12:19:29.826|INFO|feed_model.php|insert_data() feedid=10 updatetime=1533989969 feedtime=1533989969 value=0 arg=

  2018-08-11 12:19:29.828|INFO|feed_model.php|insert_data() feedid=5 updatetime=1533989969 feedtime=1533989969 value=419335.75 arg=

  2018-08-11 12:19:29.830|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989969 feedtime=1533989969 value=387 arg=

  2018-08-11 12:19:29.832|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989969 feedtime=1533989969 value=387 arg=join

  2018-08-11 12:19:29.833|INFO|feed_model.php|insert_data() feedid=11 updatetime=1533989969 feedtime=1533989969 value=8.3218359 arg=

  2018-08-11 12:19:34.308|INFO|index.php|feed/list.json

  2018-08-11 12:19:34.314|INFO|rememberme_model.php|login

  2018-08-11 12:19:34.314|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:19:39.315|INFO|index.php|feed/list.json

  2018-08-11 12:19:39.321|INFO|rememberme_model.php|login

  2018-08-11 12:19:39.321|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:19:39.711|INFO|index.php|input/post.json

  2018-08-11 12:19:39.752|INFO|feed_model.php|insert_data() feedid=12 updatetime=1533989979 feedtime=1533989979 value=223.83 arg=

  2018-08-11 12:19:39.753|INFO|feed_model.php|EngineClass() Autoloaded new instance of 'RedisBuffer'.

  2018-08-11 12:19:39.754|INFO|feed_model.php|insert_data() feedid=13 updatetime=1533989979 feedtime=1533989979 value=209.74 arg=

  2018-08-11 12:19:39.756|INFO|feed_model.php|insert_data() feedid=1 updatetime=1533989979 feedtime=1533989979 value=0 arg=

  2018-08-11 12:19:39.757|INFO|feed_model.php|insert_data() feedid=2 updatetime=1533989979 feedtime=1533989979 value=0 arg=

  2018-08-11 12:19:39.759|INFO|feed_model.php|insert_data() feedid=3 updatetime=1533989979 feedtime=1533989979 value=40.9 arg=

  2018-08-11 12:19:39.760|INFO|feed_model.php|insert_data() feedid=4 updatetime=1533989979 feedtime=1533989979 value=0 arg=

  2018-08-11 12:19:39.761|INFO|feed_model.php|insert_data() feedid=7 updatetime=1533989979 feedtime=1533989979 value=169.59 arg=

  2018-08-11 12:19:39.763|INFO|feed_model.php|insert_data() feedid=8 updatetime=1533989979 feedtime=1533989979 value=0 arg=

  2018-08-11 12:19:39.764|INFO|feed_model.php|insert_data() feedid=9 updatetime=1533989979 feedtime=1533989979 value=-0.76 arg=

  2018-08-11 12:19:39.765|INFO|feed_model.php|insert_data() feedid=10 updatetime=1533989979 feedtime=1533989979 value=0 arg=

  2018-08-11 12:19:39.767|INFO|feed_model.php|insert_data() feedid=5 updatetime=1533989979 feedtime=1533989979 value=419335.75 arg=

  2018-08-11 12:19:39.768|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989979 feedtime=1533989979 value=387 arg=

  2018-08-11 12:19:39.770|INFO|feed_model.php|insert_data() feedid=6 updatetime=1533989979 feedtime=1533989979 value=387 arg=join

  2018-08-11 12:19:39.771|INFO|feed_model.php|insert_data() feedid=11 updatetime=1533989979 feedtime=1533989979 value=8.3246129 arg=

  2018-08-11 12:19:44.319|INFO|index.php|feed/list.json

  2018-08-11 12:19:44.325|INFO|rememberme_model.php|login

  2018-08-11 12:19:44.325|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:19:49.309|INFO|index.php|feed/list.json

  2018-08-11 12:19:49.315|INFO|rememberme_model.php|login

  2018-08-11 12:19:49.315|INFO|rememberme_model.php|getCookieValues: not present

  2018-08-11 12:19:49.678|INFO|index.php|input/post.json

Not clear where to look for…

That doesn’t show the last update time of the mariaDB database, just the feed data… It sounds to me like your database isn’t being updated… maybe there’s a permission issue on the mariaDB sql database files?

Where can I find those database files?
Not clear how emoncms works. Are the phptimeseries data calculated with every feed input?
Looks like the problem is with phptimeseries data. Question is why did it work well till I did the reboot. The feed names for 19, 20 and 21 are still in the database. Names of any new defined go there even and stay after reboot. However they went with setttings/feeds and also on the settings/input.

The default location for mariaDB files is /var/lib/mysql. Assuming you installed following those instructions exactly, the database files should be in the default location. There should be an emoncms directory under that one that contains the database files for emonCMS.

I’m not exactly clear from your descriptions on what stays after a reboot and what doesn’t. Can you take some screenshots before and after to illustrate?

OK, I start explain with an example with 3 new feeds that I just created:24, 25 and 26
24 is just log to feed of tsec, 25 is power to kWh of Gr1RP with PHPFINA and 26 is power to kWh/d of Gr1RP with PHPTIMESERIES

[email protected]:~ $ ls -al /var/lib/{phpfiwa,phpfina,phptimeseries}
/var/lib/phpfina:
total 13928
drwxr-xr-x  2 www-data root        4096 Aug 12 06:41 .
drwxr-xr-x 52 root     root        4096 Jul 13 13:00 ..
-rw-r--r--  1 www-data www-data 1022680 Aug 12 06:38 10.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:26 10.meta
-rw-r--r--  1 www-data www-data 1022612 Aug 12 06:38 11.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:29 11.meta
-rw-r--r--  1 www-data www-data 1022604 Aug 12 06:38 12.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:30 12.meta
-rw-r--r--  1 www-data www-data 1022600 Aug 12 06:38 13.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:30 13.meta
-rw-r--r--  1 www-data www-data  770920 Aug  7 15:12 15.dat
-rw-r--r--  1 www-data www-data      16 Jul 16 07:55 15.meta
-rw-r--r--  1 www-data www-data     232 Aug  7 15:02 18.dat
-rw-r--r--  1 www-data www-data      16 Aug  5 06:41 18.meta
-rw-r--r--  1 www-data www-data 1026608 Aug 12 06:38 1.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:43 1.meta
-rw-r--r--  1 www-data www-data      48 Aug 11 10:47 23.dat
-rw-r--r--  1 www-data www-data      16 Aug 11 10:47 23.meta
-rw-r--r--  1 www-data www-data      52 Aug 12 06:38 24.dat
-rw-r--r--  1 www-data www-data      16 Aug 12 06:38 24.meta
-rw-r--r--  1 www-data www-data       0 Aug 12 06:41 25.dat
-rw-r--r--  1 www-data www-data      16 Aug 12 06:41 25.meta
-rw-r--r--  1 www-data www-data 1026596 Aug 12 06:38 2.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:43 2.meta
-rw-r--r--  1 www-data www-data 1026572 Aug 12 06:38 3.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:44 3.meta
-rw-r--r--  1 www-data www-data 1026568 Aug 12 06:38 4.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:44 4.meta
-rw-r--r--  1 www-data www-data 1026560 Aug 12 06:38 5.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:45 5.meta
-rw-r--r--  1 www-data www-data 1026552 Aug 12 06:38 6.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:45 6.meta
-rw-r--r--  1 www-data www-data 1022692 Aug 12 06:38 7.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:26 7.meta
-rw-r--r--  1 www-data www-data 1022688 Aug 12 06:38 8.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:26 8.meta
-rw-r--r--  1 www-data www-data 1022684 Aug 12 06:38 9.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:26 9.meta

/var/lib/phpfiwa:
total 8
drwxr-xr-x  2 www-data root 4096 Jul 13 08:52 .
drwxr-xr-x 52 root     root 4096 Jul 13 13:00 ..

/var/lib/phptimeseries:
total 200
drwxr-xr-x  2 www-data root       4096 Aug 12 06:45 .
drwxr-xr-x 52 root     root       4096 Jul 13 13:00 ..
-rw-r--r--  1 www-data www-data 179955 Aug  7 15:12 feed_19.MYD
-rw-r--r--  1 www-data www-data     18 Aug  7 15:12 feed_20.MYD
-rw-r--r--  1 www-data www-data      9 Aug  9 07:14 feed_21.MYD
-rw-r--r--  1 www-data www-data     18 Aug 11 08:10 feed_22.MYD
-rw-r--r--  1 www-data www-data      0 Aug 12 06:45 feed_26.MYD

And after reboot the new feeds are still there and updated because time is different

[email protected]:~ $ ls -al /var/lib/{phpfiwa,phpfina,phptimeseries}
/var/lib/phpfina:
total 13932
drwxr-xr-x  2 www-data root        4096 Aug 12 06:41 .
drwxr-xr-x 52 root     root        4096 Jul 13 13:00 ..
-rw-r--r--  1 www-data www-data 1023160 Aug 12 06:58 10.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:26 10.meta
-rw-r--r--  1 www-data www-data 1023092 Aug 12 06:58 11.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:29 11.meta
-rw-r--r--  1 www-data www-data 1023084 Aug 12 06:58 12.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:30 12.meta
-rw-r--r--  1 www-data www-data 1023080 Aug 12 06:58 13.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:30 13.meta
-rw-r--r--  1 www-data www-data  770920 Aug  7 15:12 15.dat
-rw-r--r--  1 www-data www-data      16 Jul 16 07:55 15.meta
-rw-r--r--  1 www-data www-data     232 Aug  7 15:02 18.dat
-rw-r--r--  1 www-data www-data      16 Aug  5 06:41 18.meta
-rw-r--r--  1 www-data www-data 1027088 Aug 12 06:58 1.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:43 1.meta
-rw-r--r--  1 www-data www-data      48 Aug 11 10:47 23.dat
-rw-r--r--  1 www-data www-data      16 Aug 11 10:47 23.meta
-rw-r--r--  1 www-data www-data     532 Aug 12 06:58 24.dat
-rw-r--r--  1 www-data www-data      16 Aug 12 06:38 24.meta
-rw-r--r--  1 www-data www-data     412 Aug 12 06:58 25.dat
-rw-r--r--  1 www-data www-data      16 Aug 12 06:48 25.meta
-rw-r--r--  1 www-data www-data 1027076 Aug 12 06:58 2.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:43 2.meta
-rw-r--r--  1 www-data www-data 1027052 Aug 12 06:58 3.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:44 3.meta
-rw-r--r--  1 www-data www-data 1027048 Aug 12 06:58 4.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:44 4.meta
-rw-r--r--  1 www-data www-data 1027040 Aug 12 06:58 5.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:45 5.meta
-rw-r--r--  1 www-data www-data 1027032 Aug 12 06:58 6.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 13:45 6.meta
-rw-r--r--  1 www-data www-data 1023172 Aug 12 06:58 7.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:26 7.meta
-rw-r--r--  1 www-data www-data 1023168 Aug 12 06:58 8.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:26 8.meta
-rw-r--r--  1 www-data www-data 1023164 Aug 12 06:58 9.dat
-rw-r--r--  1 www-data www-data      16 Jul 13 16:26 9.meta

/var/lib/phpfiwa:
total 8
drwxr-xr-x  2 www-data root 4096 Jul 13 08:52 .
drwxr-xr-x 52 root     root 4096 Jul 13 13:00 ..

/var/lib/phptimeseries:
total 204
drwxr-xr-x  2 www-data root       4096 Aug 12 06:45 .
drwxr-xr-x 52 root     root       4096 Jul 13 13:00 ..
-rw-r--r--  1 www-data www-data 179955 Aug  7 15:12 feed_19.MYD
-rw-r--r--  1 www-data www-data     18 Aug  7 15:12 feed_20.MYD
-rw-r--r--  1 www-data www-data      9 Aug  9 07:14 feed_21.MYD
-rw-r--r--  1 www-data www-data     18 Aug 11 08:10 feed_22.MYD
-rw-r--r--  1 www-data www-data      9 Aug 12 06:58 feed_26.MYD

phpmyadmin show same list for inputs and feeds as before the boot.
HOWEVER 24,25 and 26 are not in emoncms feed list any more, see attached pictures. So the data is still there, but not visible in emoncms feeds list.
I don’t think that is an access problem, but it has to do with data being kept in temporary memory and which got lost at reboot.

.feeds242526

Did some more checks. Emoncms is not reading feeds from the database. Not after restart and also not during running. I changed the name of a feed with phpmyadmin and that was also not reflected in the feeds list of emoncms.
All values of the existing feeds are there when I look at my graphs. Also when I add a new feed and base a graph on it then it shows the values from the time that I created it.
After reboot that new feed and data is gone.
Where does emoncms read it’s feeds and input list from? And why does this not get updated when I add a new feed?

Just a thought, are all the services running?

sudo systemctl status {feedwriter,emonhub,mosquitto,redis-server,mqtt_input}

Can you provide a screenshot of your Admin web page too please?

Do you have before reboot and after reboot views of the phpmyadmin view of your feeds table too?

 $ sudo systemctl status {feedwriter,emonhub,mosquitto,redis-server,mqtt_input}
 feedwriter.service - LSB: feedwriter script daemon
   Loaded: loaded (/etc/init.d/feedwriter; generated; vendor preset: enabled)
   Active: active (running) since Sun 2018-08-12 13:17:14 AST; 6h ago
     Docs: man:systemd-sysv-generator(8)
  Process: 671 ExecStart=/etc/init.d/feedwriter start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/feedwriter.service
           └─880 /usr/bin/php -f /var/www/emoncms/scripts/feedwriter.php

Aug 12 13:17:07 raspberrypi systemd[1]: Starting LSB: feedwriter script daemon...
Aug 12 13:17:07 raspberrypi feedwriter[671]: Log is turned off
Aug 12 13:17:07 raspberrypi feedwriter[671]: Starting RPI
Aug 12 13:17:14 raspberrypi systemd[1]: Started LSB: feedwriter script daemon.
Unit emonhub.service could not be found.
Unit mosquitto.service could not be found.

 redis-server.service - Advanced key-value store
   Loaded: loaded (/lib/systemd/system/redis-server.service; enabled; vendor preset: enabled)
   Active: active (running) since Sun 2018-08-12 13:17:06 AST; 6h ago
     Docs: http://redis.io/documentation,
           man:redis-server(1)
  Process: 588 ExecStopPost=/bin/run-parts --verbose /etc/redis/redis-server.post-down.d (code=exited, status=0/SUCCESS)
  Process: 585 ExecStop=/bin/kill -s TERM $MAINPID (code=exited, status=0/SUCCESS)
  Process: 555 ExecStop=/bin/run-parts --verbose /etc/redis/redis-server.pre-down.d (code=exited, status=0/SUCCESS)
  Process: 618 ExecStartPost=/bin/run-parts --verbose /etc/redis/redis-server.post-up.d (code=exited, status=0/SUCCESS)
  Process: 614 ExecStart=/usr/bin/redis-server /etc/redis/redis.conf (code=exited, status=0/SUCCESS)
  Process: 595 ExecStartPre=/bin/run-parts --verbose /etc/redis/redis-server.pre-up.d (code=exited, status=0/SUCCESS)
 Main PID: 617 (redis-server)
   CGroup: /system.slice/redis-server.service
           └─617 /usr/bin/redis-server 127.0.0.1:6379

Aug 12 13:17:05 raspberrypi systemd[1]: Starting Advanced key-value store...
Aug 12 13:17:06 raspberrypi run-parts[595]: run-parts: executing /etc/redis/redis-server.pre-up.d/00_example
Aug 12 13:17:06 raspberrypi run-parts[618]: run-parts: executing /etc/redis/redis-server.post-up.d/00_example
Aug 12 13:17:06 raspberrypi systemd[1]: Started Advanced key-value store.
Unit mqtt_input.service could not be found.

Nothing changes on the feeds table after reboot, All feeds stay, including old