database full - website not updating **solved**

All about the standard Meteobridge devices based on mobile routers from TP-Link, D-Link, ASUS

Moderator: Mattk

Post Reply
pwilman
Senior Boarder
Senior Boarder
Posts: 44
Joined: Sun Jan 14, 2018 9:46 am

database full - website not updating **solved**

Post by pwilman » Sun Mar 31, 2019 9:03 am

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
Senior Boarder
Senior Boarder
Posts: 44
Joined: Sun Jan 14, 2018 9:46 am

Re: database full - website not updating

Post by pwilman » Sun Mar 31, 2019 9:35 am

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
Senior Boarder
Senior Boarder
Posts: 44
Joined: Sun Jan 14, 2018 9:46 am

Re: database full - website not updating

Post by pwilman » Sun Mar 31, 2019 9:42 am

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
Attachments
Screen Shot 2019-03-31 at 08.40.09.png
Screen Shot 2019-03-31 at 08.40.09.png (32.23 KiB) Viewed 307 times

User avatar
ConligWX
Gold Boarder
Gold Boarder
Posts: 214
Joined: Wed Nov 14, 2018 12:48 pm
Location: Conlig, Co. Down, UK
Contact:

Re: database full - website not updating

Post by ConligWX » Sun Mar 31, 2019 10:17 am

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
Senior Boarder
Senior Boarder
Posts: 40
Joined: Fri Jan 16, 2015 7:49 pm
Contact:

Re: database full - website not updating

Post by bardek » Sun Mar 31, 2019 10:23 am

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

User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 5879
Joined: Mon Oct 01, 2007 10:51 pm

Re: database full - website not updating **solved**

Post by admin » Sun Apr 07, 2019 12:57 pm

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

pwilman
Senior Boarder
Senior Boarder
Posts: 44
Joined: Sun Jan 14, 2018 9:46 am

Re: database full - website not updating **solved**

Post by pwilman » Sun Apr 07, 2019 2:01 pm

Boris,

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

Paul

Post Reply