Page 1 of 1

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

Posted: Thu Mar 07, 2024 8:45 pm
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)

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

Posted: Thu Mar 07, 2024 9:49 pm
by Mattk
What is your USB details?

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

Posted: Thu Mar 07, 2024 10:28 pm
by Scareduck
Mattk wrote: Thu Mar 07, 2024 9:49 pm What is your USB details?
How would I discover them?

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

Posted: Thu Mar 07, 2024 11:55 pm
by Mattk
On the System>Information Tab, top System box, should be third row down Storage ????

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

Posted: Fri Mar 08, 2024 1:46 am
by Scareduck
USB Front: 10c4:ea60 Silicon Labs: CP210x UART Bridge
USB Back:

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

Posted: Fri Mar 08, 2024 2:13 am
by admin
Please share complete "System - Information" tab.

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

Posted: Fri Mar 08, 2024 3:06 am
by Scareduck
Screenshot from 2024-03-07 19-04-27.png
Screenshot from 2024-03-07 19-04-27.png (100.23 KiB) Viewed 1036 times

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

Posted: Fri Mar 08, 2024 7:26 pm
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

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

Posted: Sat Mar 09, 2024 1:12 am
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.

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

Posted: Sat Mar 09, 2024 2:58 am
by Scareduck
I did a factory reset and reprogrammed everything. It seems to be relaying data now.