Problem of upload deamon?


#1

hi there
my raspberry sbfspot stopped uploading to pvoutput.org around 2 pm french time.
I ran the upload deamon and this is what I had:
pi@raspberrypi:~ $ sudo systemctl status SBFspotUpload● SBFspotUpload.service - SBFspot Upload Daemon
Loaded: loaded (/mnt/usb/usr/local/bin/sbfspot.3/SBFspotUpload.service; enabl
Active: failed (Result: exit-code) since Wed 2019-02-06 20:48:54 CET; 4min 14
Main PID: 3445 (code=exited, status=1/FAILURE)

févr. 06 20:48:54 raspberrypi systemd[1]: Started SBFspot Upload Daemon.
févr. 06 20:48:54 raspberrypi SBFspotUploadDaemon[3445]: Upgrade your database t
févr. 06 20:48:54 raspberrypi systemd[1]: SBFspotUpload.service: Main process ex
févr. 06 20:48:54 raspberrypi systemd[1]: SBFspotUpload.service: Unit entered fa
févr. 06 20:48:54 raspberrypi systemd[1]: SBFspotUpload.service: Failed with res
lines 1-10/10 (END)

when I ran the famous command to test sbfspot I had this:
pi@raspberrypi:~ $ /mnt/usb/usr/local/bin/sbfspot.3/SBFspot -v -finq -nocsv
SBFspot V3.5.0
Yet another tool to read power production of SMA solar inverters
© 2012-2018, SBF (https://github.com/SBFspot/SBFspot)
Compiled for Linux (LE) 32 bit with SQLite support
Commandline Args: -v -finq -nocsv
Reading config ‘/mnt/usb/usr/local/bin/sbfspot.3/SBFspot.cfg’
Wed Feb 6 21:09:18 2019: INFO: Starting…
sunrise: 08:06
sunset : 18:10
Connecting to 00:80:25:15:FB:C2 (1/10)
Initializing…
SUSyID: 125 - SessionID: 825396518 (0x31328D26)
SMA netID=01
Serial Nr: 7D2F6B0E (2100259598)
BT Signal=67.1%
Logon OK
Failed to get current plant time (-1)
SetPlantTime returned an error: -1
SUSyID: 113 - SN: 2100259598
Device Name: SN: 2100259598
Device Class: Onduleur solaire
Device Type: SB 3000TL-20
Software Version: 02.08.01.R
Serial number: 2100259598
SUSyID: 113 - SN: 2100259598
Device Status: Ok
SUSyID: 113 - SN: 2100259598
Device Temperature: 0.0°C
SUSyID: 113 - SN: 2100259598
GridRelay Status: Aucune information
SUSyID: 113 - SN: 2100259598
Pac max phase 1: 3000W
Pac max phase 2: 3000W
Pac max phase 3: 3000W
SUSyID: 113 - SN: 2100259598
Energy Production:
EToday: 2.963kWh
ETotal: 14696.100kWh
Operation Time: 19669.67h
Feed-In Time : 19329.23h
SUSyID: 113 - SN: 2100259598
DC Spot Data:
String 1 Pdc: 0.000kW - Udc: 0.00V - Idc: 0.000A
String 2 Pdc: 0.000kW - Udc: 0.00V - Idc: 0.000A
SUSyID: 113 - SN: 2100259598
AC Spot Data:
Phase 1 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Phase 2 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Phase 3 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Total Pac : 0.000kW
SUSyID: 113 - SN: 2100259598
Grid Freq. : 0.00Hz
SUSyID: 113 - SN: 2100259598
Current Inverter Time: 06/02/2019 21:10:19
Inverter Wake-Up Time: 06/02/2019 08:34:50
Inverter Sleep Time : 06/02/2019 18:13:11
[2019-02-06 21:10:24.897] Error: sqlite3_exec() returned: ‘unable to open database file’ while executing
INSERT OR IGNORE INTO Inverters VALUES(2100259598,‘SN: 2100259598’,‘SB 3000TL-20’,‘02.08.01.R’,0,0,0,0,0,0,’’,’’,0)
[2019-02-06 21:10:24.897] Error: exec_query() returned: ‘unable to open database file’ while executing
INSERT OR IGNORE INTO Inverters VALUES(2100259598,‘SN: 2100259598’,‘SB 3000TL-20’,‘02.08.01.R’,0,0,0,0,0,0,’’,’’,0)
[2019-02-06 21:10:24.902] Error: sqlite3_exec() returned: ‘unable to open database file’ while executing
UPDATE Inverters SET Name=‘SN: 2100259598’,Type=‘SB 3000TL-20’,SW_Version=‘02.08.01.R’ WHERE Serial=2100259598
[2019-02-06 21:10:24.902] Error: exec_query() returned: ‘unable to open database file’ while executing
UPDATE Inverters SET Name=‘SN: 2100259598’,Type=‘SB 3000TL-20’,SW_Version=‘02.08.01.R’ WHERE Serial=2100259598
[2019-02-06 21:10:24.907] Error: sqlite3_exec() returned: ‘unable to open database file’ while executing
UPDATE Inverters SET TimeStamp=1549483824,TotalPac=0,EToday=2963,ETotal=14696100,OperatingTime=19669.7,FeedInTime=19329.2,Status=‘OK’,GridRelay=‘N/A’,Temperature=0 WHERE Serial=2100259598
[2019-02-06 21:10:24.908] Error: exec_query() returned: ‘unable to open database file’ while executing
UPDATE Inverters SET TimeStamp=1549483824,TotalPac=0,EToday=2963,ETotal=14696100,OperatingTime=19669.7,FeedInTime=19329.2,Status=‘OK’,GridRelay=‘N/A’,Temperature=0 WHERE Serial=2100259598
[2019-02-06 21:10:24.913] Error: sqlite3_exec() returned: ‘unable to open database file’ while executing
INSERT INTO SpotData VALUES(1549483824,2100259598,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2963,14696100,0,19669.7,19329.2,67.0588,‘OK’,‘N/A’,0)
[2019-02-06 21:10:24.913] Error: [spot_data]exec_query() returned: ‘unable to open database file’ while executing
INSERT INTO SpotData VALUES(1549483824,2100259598,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2963,14696100,0,19669.7,19329.2,67.0588,‘OK’,‘N/A’,0)


  • ArchiveDayData() *

startTime = 5C5A1570 -> 06/02/2019 00:00:00


  • ArchiveMonthData() *

startTime = 5C5426B0 -> 01/02/2019 12:00:00
Reading events: 2019-Feb-01
Wed Feb 6 21:10:25 2019: INFO: Done.
pi@raspberrypi:~ $

I do not know what to do to solve this.
thank you very much for the help.
regards
louloutte31


#2

Check the path to sbfspot.db in your config files.


#3

Paths are correct.
I’ve tried again to run the deamon and pvoutput is now refreshed.
I’ll check it tomorrow.


#4

Hello.
Everything is back to normal without any change.
Thank you for the help.