Hi all,
I am using an RPI with SBFspotUploadDaemon for quite some time now, but all for sudden, no update
appeared in pvoutput.
I decided to take a look in the vwPvoData table in the SBFspot.db database and got this error message:
database or disk is full
This is nonsense, as there is plenty of space left.
Can any of you help me out here?
Thanks,
Bert
Most probably your database is corrupt. Run pragma integrity_check
Another possibility is a corrupt SD card
I did do the check, but the answer OK came in about 1 second.
I downloaded the SBFspot.db and found this. It seems something put a NULL in the PVoutput column
the folowing in vwPvoData tableCan anybody please help?
I installed everything all over again twice. The corruption is no longer there. I see CSV and log files being created and values being read, but it looks like the daemon refuses to do the uploading.
Thanks, I already done that.
Only suspicious is the content of SBFspotUpload20210404.log
Please note that I did the starting an stopping.
[14:32:13] INFO: SBFspotUploadDaemon Version 3.0.0
[14:32:13] INFO: Starting Daemon…
[14:33:31] INFO: SBFspotUploadDaemon Version 3.0.0
[14:33:31] INFO: Starting Daemon…
[14:34:19] INFO: Stopping Daemon…
[14:34:24] INFO: SBFspotUploadDaemon Version 3.0.0
[14:34:24] INFO: Starting Daemon…
[15:28:31] WARNING: SMAbert is not yet member of SBFspot Team. Consider joining at http://pvoutput.org/listteam.jsp?tid=613
[17:29:32] WARNING: SMAbert is not yet member of SBFspot Team. Consider joining at http://pvoutput.org/listteam.jsp?tid=613
Warning is no problem. You get rid of it by joining the team.
Show us the steps explained in the wiki. The solution is there in 95% of the cases
Okay, so here we go:
$ /usr/local/bin/sbfspot.3/SBFspot -v -nosql -nocsv -finq | grep -i time
Local Host Time: 09/04/2021 18:20:16
Plant Time : 09/04/2021 18:20:17 (+1 sec)
Last Time Set : 02/04/2021 05:55:03
Operation Time: 22527.23h
Feed-In Time : 21120.41h
Current Inverter Time: 09/04/2021 18:20:16
Inverter Wake-Up Time: 09/04/2021 07:03:40
Inverter Sleep Time : 09/04/2021 18:20:16
startTime = 606F7CE0 → 09/04/2021 00:00:00
startTime = 6065A7B0 → 01/04/2021 13:00:00
$ sudo systemctl status SBFspotUpload
● SBFspotUpload.service - SBFspot Upload Daemon
Loaded: loaded (/usr/local/bin/sbfspot.3/SBFspotUpload.service; enabled; vendor preset: enabled)
Active: active (running) since Sun 2021-04-04 14:34:24 CEST; 5 days ago
Main PID: 1245 (SBFspotUploadDa)
Tasks: 1 (limit: 2062)
CGroup: /system.slice/SBFspotUpload.service
└─1245 /usr/local/bin/sbfspot.3/SBFspotUploadDaemon -c /usr/local/bin/sbfspot.3/SBFspotUpload.cfg
Apr 04 14:34:24 otgwdomo systemd[1]: Started SBFspot Upload Daemon.
Apr 04 14:34:24 otgwdomo SBFspotUploadDaemon[1245]: SBFspotUploadDaemon Version 3.0.0
Apr 04 14:34:24 otgwdomo SBFspotUploadDaemon[1245]: Loglevel=1
Apr 04 14:34:24 otgwdomo SBFspotUploadDaemon[1245]: LogDir=/home/pi/smadata/logs/
$ journalctl|grep SBFspotUpload
Apr 04 14:08:43 otgwdomo SBFspotUploadDaemon[429]: SBFspotUploadDaemon Version 3.0.0
Apr 04 14:08:43 otgwdomo SBFspotUploadDaemon[429]: Loglevel=2
Apr 04 14:08:43 otgwdomo SBFspotUploadDaemon[429]: LogDir=/var/log/sbfspot.3/
Apr 04 14:16:25 otgwdomo sudo[736]: pi : TTY=pts/0 ; PWD=/home/pi/smadata/logs ; USER=root ; COMMAND=/usr/bin/find / -namee SBFspotUpload
Apr 04 14:16:30 otgwdomo sudo[738]: pi : TTY=pts/0 ; PWD=/home/pi/smadata/logs ; USER=root ; COMMAND=/usr/bin/find / -name SBFspotUpload
Apr 04 14:20:59 otgwdomo sudo[855]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3/SBFUploadDaemonOrg ; USER=root ; COMMAND=/bin/systemctl status SBFspotUpload
Apr 04 14:22:31 otgwdomo sudo[896]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/chown root:root SBFspotUploadDaemon
Apr 04 14:22:49 otgwdomo sudo[909]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/systemctl status SBFspotUpload
Apr 04 14:22:55 otgwdomo sudo[912]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/systemctl stop SBFspotUpload
Apr 04 14:22:55 otgwdomo SBFspotUploadDaemon[429]: Exit signal received.
Apr 04 14:22:55 otgwdomo systemd[1]: SBFspotUpload.service: Succeeded.
Apr 04 14:23:01 otgwdomo sudo[915]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/systemctl start SBFspotUpload
Apr 04 14:23:01 otgwdomo SBFspotUploadDaemon[918]: SBFspotUploadDaemon Version 3.0.0
Apr 04 14:23:01 otgwdomo SBFspotUploadDaemon[918]: Loglevel=2
Apr 04 14:23:01 otgwdomo SBFspotUploadDaemon[918]: LogDir=/var/log/sbfspot.3/
Apr 04 14:23:06 otgwdomo sudo[928]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/systemctl status SBFspotUpload
Apr 04 14:30:47 otgwdomo sudo[1142]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/nano SBFspotUpload.cfg
Apr 04 14:32:07 otgwdomo sudo[1166]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/systemctl stop SBFspotUpload
Apr 04 14:32:07 otgwdomo SBFspotUploadDaemon[918]: Exit signal received.
Apr 04 14:32:07 otgwdomo systemd[1]: SBFspotUpload.service: Succeeded.
Apr 04 14:32:13 otgwdomo sudo[1179]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/systemctl start SBFspotUpload
Apr 04 14:32:13 otgwdomo SBFspotUploadDaemon[1182]: SBFspotUploadDaemon Version 3.0.0
Apr 04 14:32:13 otgwdomo SBFspotUploadDaemon[1182]: Loglevel=1
Apr 04 14:32:13 otgwdomo SBFspotUploadDaemon[1182]: LogDir=/home/pi/smadata/logs/
Apr 04 14:32:16 otgwdomo sudo[1183]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/systemctl status SBFspotUpload
Apr 04 14:34:19 otgwdomo sudo[1239]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/systemctl stop SBFspotUpload
Apr 04 14:34:19 otgwdomo SBFspotUploadDaemon[1182]: Exit signal received.
Apr 04 14:34:19 otgwdomo systemd[1]: SBFspotUpload.service: Succeeded.
Apr 04 14:34:24 otgwdomo sudo[1242]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/systemctl start SBFspotUpload
Apr 04 14:34:24 otgwdomo SBFspotUploadDaemon[1245]: SBFspotUploadDaemon Version 3.0.0
Apr 04 14:34:24 otgwdomo SBFspotUploadDaemon[1245]: Loglevel=1
Apr 04 14:34:24 otgwdomo SBFspotUploadDaemon[1245]: LogDir=/home/pi/smadata/logs/
Apr 04 14:34:28 otgwdomo sudo[1246]: pi : TTY=pts/0 ; PWD=/usr/local/bin/sbfspot.3 ; USER=root ; COMMAND=/bin/systemctl status SBFspotUpload
Apr 09 19:06:56 otgwdomo sudo[17354]: pi : TTY=pts/0 ; PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl status SBFspotUpload
sqlite> Select * from vwinverters;
2120170067|SN: 2120170067|SB 3000HF-30|02.54.11.R|2021-04-09 19:10:07|84|6981|22161734|22528.1|21121.2|OK|Closed|31.6
Two configuration settings are important for correct uploading to PVOutput.org turn out to be fine.
In domoticz, where I read the data in from pvoutput, I get this: 2021-04-18 18:17:35.874 Error: PVOutput2: Error login!
That happend rougly at the same time that it was no londer possible to upload data.
