NANOSD database disk image is malformed. **solved**

[wilkerjnc]

After a recent power loss, when the NANOSD boots I am seeing this in the logs:

Code: Select all

database (25.08.2021 11:49:58): process started.
database (25.08.2021 11:49:58): Content of RAM database restored.
wnetd  (25.08.2021 11:50:01): process started.
system (25.08.2021 11:50:01): start of logging process initiated.
wnetd  (25.08.2021 11:50:01): send data thread started (pid:2035 tid:2036)
logger (25.08.2021 11:50:02): databases connected. Update interval 3600 seconds.
logger (25.08.2021 11:50:02): data logger (version 5.2, build 3986) started.
logger (25.08.2021 11:50:03): connect station 0 (Vantage via serial).
logger (25.08.2021 11:50:03): connect station 9 (System Data via Plug-in).
logger (25.08.2021 11:50:03): station 0 (Vantage), wakeup sent.
logger (25.08.2021 11:50:06): waiting for sensors (wind0, rain0, th0, thb0) to provide data.
logger (25.08.2021 11:50:06): services paused.
logger (25.08.2021 11:50:07): station 0 (Vantage), no need to update console date/time.
logger (25.08.2021 11:50:07): station 0 (Vantage), setup script executed.
logger (25.08.2021 11:50:07): station 0 (Vantage), internal logger activated.
logger (25.08.2021 11:50:07): station 0 (Vantage), syncing.
database (25.08.2021 11:50:07): cannot prepare select on read tables (after 100 tries in 9050ms): database disk image is malformed
database (25.08.2021 11:50:07): process received signal (11) in functions sigcrash < **getdiffms < read_tables_db < sync_db < *send_db_msg < *send_db_msg < *send_db_msg < *send_db_msg < *file_copy < 
logger (25.08.2021 11:50:17): station 0 (Vantage), gettime request sent.
logger (25.08.2021 11:50:17): station 0 (Vantage), no Vantage time offset.
logger (25.08.2021 11:50:17): station 0 (Vantage), eeprom request sent.
logger (25.08.2021 11:50:17): station 0 (Vantage), rain collector size 0.01 inch per tick.
logger (25.08.2021 11:50:17): station 0 (Vantage), transmitter 1 active as station type #0 "ISS".
logger (25.08.2021 11:50:17): station 0 (Vantage), firmware version request sent.
logger (25.08.2021 11:50:17): station 0 (Vantage), firmware version 3.80 (supports LOOP2)
logger (25.08.2021 11:50:17): station 0 (Vantage), no reading of Vantage's internal logger.
logger (25.08.2021 11:50:17): station 0 (Vantage), 10.243.1.149's request on port 22222 accepted.
logger (25.08.2021 11:50:24): sensors are now providing data.
logger (25.08.2021 11:50:24): services started.
test5m (25.08.2021 11:51:41): database daemon stalled, will be restarted now.
database (25.08.2021 11:51:41): process started.
database (25.08.2021 11:51:50): cannot prepare select on read tables (after 100 tries in 9055ms): database disk image is malformed
database (25.08.2021 11:51:50): process received signal (11) in functions sigcrash < **getdiffms < read_tables_db < sync_db < *send_db_msg < *send_db_msg < *send_db_msg < *send_db_msg < 

The MB Weather Page loads fine and data is being sent to the respective sites without issue.

WeeWx is also receiving OK.

How can I address this?

Thanks.

[wilkerjnc]

I forgot my NanoSD info:

Code: Select all

Platform:	Meteobridge NANO SD   (ambientweather Version)
RAM:	125 MB total, 56 MB free (54% used)
Storage:	swissbit SLC, 1.8 GB total, 1.8 GB free (3% used, 622.8 yrs)
SW Version:	Meteobridge 5.2 (Aug 16 2021, build 3986), FW 1.4
Uptime:	0 hours, 14 minutes    Buffer: 2 items (0%)

[wilkerjnc]

I believe it is resolved.

What I did was checked the 'force rebuild on reboot' on the Administration Tab then after a reboot:

Code: Select all

database (25.08.2021 13:08:04): process started.
database (25.08.2021 13:08:04): Content of RAM database restored.
database (25.08.2021 13:08:06): database sync done (31 tables, 126/155 writes).
wnetd  (25.08.2021 13:08:07): process started.
system (25.08.2021 13:08:07): start of logging process initiated.
wnetd  (25.08.2021 13:08:07): send data thread started (pid:2019 tid:2021)
logger (25.08.2021 13:08:08): databases connected. Update interval 3600 seconds.
logger (25.08.2021 13:08:08): data logger (version 5.2, build 3986) started.
logger (25.08.2021 13:08:08): connect station 0 (Vantage via serial).
logger (25.08.2021 13:08:08): connect station 9 (System Data via Plug-in).
logger (25.08.2021 13:08:09): station 0 (Vantage), wakeup sent.
logger (25.08.2021 13:08:12): waiting for sensors (wind0, rain0, th0, thb0) to provide data.
logger (25.08.2021 13:08:12): services paused.
logger (25.08.2021 13:08:12): station 0 (Vantage), no need to update console date/time.
logger (25.08.2021 13:08:12): station 0 (Vantage), setup script executed.
logger (25.08.2021 13:08:13): station 0 (Vantage), internal logger activated.
logger (25.08.2021 13:08:13): station 0 (Vantage), syncing.
logger (25.08.2021 13:08:23): station 0 (Vantage), gettime request sent.
logger (25.08.2021 13:08:23): station 0 (Vantage), no Vantage time offset.
logger (25.08.2021 13:08:23): station 0 (Vantage), eeprom request sent.
logger (25.08.2021 13:08:23): station 0 (Vantage), rain collector size 0.01 inch per tick.
logger (25.08.2021 13:08:23): station 0 (Vantage), transmitter 1 active as station type #0 "ISS".
logger (25.08.2021 13:08:23): station 0 (Vantage), firmware version request sent.
logger (25.08.2021 13:08:23): station 0 (Vantage), firmware version 3.80 (supports LOOP2)
logger (25.08.2021 13:08:23): station 0 (Vantage), no reading of Vantage's internal logger.
logger (25.08.2021 13:08:26): station 0 (Vantage), 10.243.1.149's request on port 22222 accepted.
logger (25.08.2021 13:08:34): sensors are now providing data.
logger (25.08.2021 13:08:34): services started.

All data is being seen on all sites.

[admin]

You did what I would have recommended. Great to hear that you are fine again.