"cannot create table... database or disk is full"

This section covers the Meteobridge PRO, PRO2, NANO SD, Raspberry Pi and VM platforms exclusively

Moderator: Mattk

Post Reply
Scareduck
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: Sat Feb 17, 2018 12:28 am

"cannot create table... database or disk is full"

Post by Scareduck »

Meteobridge PRO running 5.8, FW 1.4.

External logging appears hung up. Have been through several proposed solutions:
  • Database -> Administration, set Boot Options to "forced rebuild on reboot", then reboot. (Incidentally, this does not stick after rebooting, and reverts to "no check/rebuild on reboot".
  • Same as above, plus switching Per-Minute Data to "automated deletion past 90 days", then reboot.
Getting the following errors even after all this. Ideas?

Code: Select all

dbase  (07.03.2024 12:30:19): cannot prepare insert into 'th0temp_min' RAM (after 0 tries in 1ms): no such table: th0temp_min (1)
dbase  (07.03.2024 12:30:19): rollback on insert forced (1) (min RAM): th0temp
dbase  (07.03.2024 12:30:19): cannot create table (after 0 tries in 1ms): database or disk is full (13)
dbase  (07.03.2024 12:30:19): cannot commit (after 0 tries in 1ms): cannot commit - no transaction is active (1)
dbase  (07.03.2024 12:30:19): cannot rollback (after 0 tries in 1ms): cannot rollback - no transaction is active (1)
Mattk
Platinum Boarder
Platinum Boarder
Posts: 1387
Joined: Mon Sep 22, 2014 3:24 am

Re: "cannot create table... database or disk is full"

Post by Mattk »

What is your USB details?
Scareduck
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: Sat Feb 17, 2018 12:28 am

Re: "cannot create table... database or disk is full"

Post by Scareduck »

Mattk wrote: Thu Mar 07, 2024 9:49 pm What is your USB details?
How would I discover them?
Mattk
Platinum Boarder
Platinum Boarder
Posts: 1387
Joined: Mon Sep 22, 2014 3:24 am

Re: "cannot create table... database or disk is full"

Post by Mattk »

On the System>Information Tab, top System box, should be third row down Storage ????
Scareduck
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: Sat Feb 17, 2018 12:28 am

Re: "cannot create table... database or disk is full"

Post by Scareduck »

USB Front: 10c4:ea60 Silicon Labs: CP210x UART Bridge
USB Back:
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: "cannot create table... database or disk is full"

Post by admin »

Please share complete "System - Information" tab.
Scareduck
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: Sat Feb 17, 2018 12:28 am

Re: "cannot create table... database or disk is full"

Post by Scareduck »

Screenshot from 2024-03-07 19-04-27.png
Screenshot from 2024-03-07 19-04-27.png (100.23 KiB) Viewed 1038 times
Scareduck
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: Sat Feb 17, 2018 12:28 am

Re: "cannot create table... database or disk is full"

Post by Scareduck »

Incidentally, here is a typical error sequence in the log:

Code: Select all

dbase  (08.03.2024 11:14:49): cannot create table (after 0 tries in 1ms): database or disk is full (13)
dbase  (08.03.2024 11:14:49): cannot commit (after 0 tries in 1ms): cannot commit - no transaction is active (1)
dbase  (08.03.2024 11:14:49): cannot rollback (after 0 tries in 1ms): cannot rollback - no transaction is active (1)
dbase  (08.03.2024 11:14:49): cannot prepare insert into 'th0temp_min' RAM (after 0 tries in 1ms): no such table: th0temp_min (1)
dbase  (08.03.2024 11:14:49): rollback on insert forced (1) (min RAM): th0temp
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: "cannot create table... database or disk is full"

Post by admin »

Can you please provide me a login? please send URL and temporary password to "info(at)meteobridge.com".
As the ATP storage is not mentioned in the upper section of the "System - Information" tab, I fear that something went wrong with the internal USB storage.
Scareduck
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: Sat Feb 17, 2018 12:28 am

Re: "cannot create table... database or disk is full"

Post by Scareduck »

I did a factory reset and reprogrammed everything. It seems to be relaying data now.
Post Reply