SBFspotUploadDeamon not uploading

Topics: 5. Support
Apr 10, 2016 at 6:26 PM
Edited Apr 10, 2016 at 7:27 PM
Hello,

I've received this morning an alert from PVOutput telling me my inverter was idle.
After checking the daemon log :
[07:30:41] INFO: Uploading 2 datapoints, starting with 20160410,07:25,1742971,0 => OK (200)
[07:40:41] INFO: Uploading 2 datapoints, starting with 20160410,07:35,1742974,24 => OK (200)
[07:50:41] INFO: Uploading 2 datapoints, starting with 20160410,07:45,1742979,36 => OK (200)
[08:00:41] INFO: Uploading datapoint: 20160410,07:55,1742988,60 => OK (200)
[08:10:41] INFO: Uploading 3 datapoints, starting with 20160410,08:00,1742993,60,,,,258.73 => OK (200)
[08:20:41] INFO: Uploading 2 datapoints, starting with 20160410,08:15,1743015,108 => OK (200)
[08:30:42] INFO: Uploading 2 datapoints, starting with 20160410,08:25,1743037,132 => OK (200)
[08:40:41] INFO: Uploading 2 datapoints, starting with 20160410,08:35,1743066,192 => OK (200)
[08:50:41] INFO: Uploading 2 datapoints, starting with 20160410,08:45,1743101,216 => OK (200)
[09:00:42] INFO: Uploading 2 datapoints, starting with 20160410,08:55,1743150,312 => OK (200)
[09:10:41] INFO: Uploading 2 datapoints, starting with 20160410,09:05,1743209,348 => OK (200)
[09:20:41] INFO: Uploading 2 datapoints, starting with 20160410,09:15,1743274,396 => OK (200)
[09:30:41] INFO: Uploading 2 datapoints, starting with 20160410,09:25,1743352,492 => OK (200)
It was 11 AM, I restarted my Pi as show in the log :
[11:11:15] INFO: Stopping Daemon...
[11:11:32] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[11:11:32] INFO: Starting Daemon...
[11:12:12] INFO: Uploading 20 datapoints, starting with 20160410,09:35,1743440,528 => OK (200)
20 points were sent, but not any others.

I've restarded the system but now nothing is sent to PVOuput by the daemon as there was no data to be sent :
[13:04:41] INFO: Stopping Daemon...
[13:04:57] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[13:04:57] INFO: Starting Daemon...
[15:58:44] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[15:58:44] INFO: Starting Daemon...
[16:03:03] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[16:03:04] INFO: Starting Daemon...
[20:14:47] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[20:14:47] INFO: Starting Daemon...
But when I manually launch the SBFspot shell, it works well and data are added to the database.

Does someone have an idea of what happens ?
The last data sent to the website (http://pvoutput.org/intraday.jsp?id=42856&sid=39166&dt=20160410) where this morning at 11:10

I've checked the vwPvoData view and the records are present but PVoutput flag is not set to 1 for the records after 11:10
Apr 11, 2016 at 6:24 PM
Re,

Probleme solved ... by starting with a new DB with empty DayData and EventData tables.
So strange, that should be a SQLite limitation
Marked as answer by Pascal69480 on 4/11/2016 at 11:29 AM
Coordinator
Apr 11, 2016 at 8:03 PM
hmm, don't think so...
Have a look at the SQLite limitations
Maximum Number Of Rows In A Table
The theoretical maximum number of rows in a table is (2 power 64) (18446744073709551616 or about 1.8e+19). This limit is unreachable since the maximum database size of 140 terabytes will be reached first. A 140 terabytes database can hold no more than approximately 1e+13 rows, and then only if there are no indices and if each row contains very little data.

It might be a corrupted db, but if you're able to add records, that should not be the case.
I'm still working on version 4 with more performant queries and better logging.