database full - website not updating **solved**

[pwilman]

Hello,

I have a Nano SD with a SWISSBIT SLC 2GB storage card.

At 23.59 my unit stopped sending data. I rebooted this morning and it started sending data for about 3 minutes and then stopped. I noticed the following message in the "system tab" when it came back online

database (31.03.2019 07:53:31): process started.
database (31.03.2019 07:53:31): Content of RAM database restored.
database (31.03.2019 07:53:31): cannot commit (after 0 tries in 1ms): database or disk is full (13)
database (31.03.2019 07:53:31): cannot rollback (after 0 tries in 1ms): cannot rollback - no transaction is active (1)
database (31.03.2019 07:53:31): rollback on sync forced (month): data10num
database (31.03.2019 07:53:31): cannot rollback (after 0 tries in 1ms): cannot rollback - no transaction is active (1)
wnetd (31.03.2019 07:53:33): process started.
system (31.03.2019 07:53:33): start of logging process initiated.
logger (31.03.2019 07:53:34): databases connected. Update interval 3600 seconds.
logger (31.03.2019 07:53:34): data logger (version 5.1a, build 2030) started.
logger (31.03.2019 07:53:36): connect station 0 (Vantage via USB serial).
logger (31.03.2019 07:53:36): connect station 9 (System Data via Plug-in).
logger (31.03.2019 07:53:36): wakeup sent.
logger (31.03.2019 07:53:39): waiting for sensors (wind0, rain0, th0, thb0) to provide data.
logger (31.03.2019 07:53:39): services paused.

The header information at the top of the storage tab is also telling me "swissbit SLC, 1845 MB total, 0 MB free (100% used)".

When I reboot the Nano works for about 3 mins and then my website goes offline (www.paulwilman.com)

I am on the lastest version of the firmware now (2030). When my station went down at 23:59 has the database somehow got corrupt?

It maybe a total co-incidence but a local nano SD user is also showing on his website that his station went offline at 23:59 last night?

Paul

[pwilman]

update:

I went into the files on the storage card and found that at 23:59 a chart had been created at 1.8GB in size. I have deleted this chart. However whist I was there you could see the hourly iso chart was increasing in size by about 1MB every second...it was growing in size right in front of my eyes.

I have now switched all the chart creation and uploads off to see if that helps.....

Does anyone know what is going on?

Paul

[pwilman]

despite all charts being turned off, the chart is still being saved onto my SD card. Attached is a screen shot of the offending file...

I hope someone can help....

Paul

[ConligWX]

what length of time chart are you creating to make it that big?

even my Yearly charts are not massive, have you edited the actual template at all?

also when you create the chart do you not have an ftp service to upload the chart to the webserver and then delete the old?

I think you'll need to post more info on the exact templates used so we can try and replicate it.

Chart:
Time Frame:
Language:
Template

FTP
Delete file
Template:
Path (File):

have you tried deleting the entries and re-adding them?

[bardek]

its because of DST time change, I've noticed that all chart, backup templates enters endless loop from changed hour. Reported in other topic

[admin]

Please delete the large faulty chart file generated in the charts folder. Newest update will no longer have the problem.

[pwilman]

Boris,

Thanks so much for fixing. I am on the latest version now. Fingers crossed for the September change.

Paul