Page 1 of 1

problem database

Posted: Sat Nov 23, 2024 11:05 pm
by Gerrit
There is a problem with the data base, I get this error message.
Database Error: Cannot prepare read tables (0 tries, 14ms): database disk image is malformed

Gerrit

chart (23.11.2024 22:00:12): cannot prepare select on read_table 'th0temp_day' (after 100 tries in 10640ms): database disk image is malformed
chart (23.11.2024 22:00:23): cannot prepare select on read_table 'th0hum_day' (after 100 tries in 10703ms): database disk image is malformed
chart (23.11.2024 22:00:34): cannot prepare select on read_table 'thb0seapress_day' (after 100 tries in 10731ms): database disk image is malformed
chart (23.11.2024 22:00:44): cannot prepare select on read_table 'wind0avgwind_day' (after 100 tries in 10677ms): database disk image is malformed
chart (23.11.2024 22:00:55): cannot prepare select on read_table 'wind0wind_day' (after 100 tries in 10661ms): database disk image is malformed
chart (23.11.2024 22:01:06): cannot prepare select on read_table 'rain0total_day' (after 100 tries in 10657ms): database disk image is malformed
chart (23.11.2024 22:01:16): cannot prepare select on read_table 'sol0rad_day' (after 100 tries in 10702ms): database disk image is malformed
chart (23.11.2024 22:01:27): cannot prepare select on read_table 'uv0index_day' (after 100 tries in 10658ms): database disk image is malformed
chart (23.11.2024 22:01:38): cannot prepare select on read_table 'th0temp_day' (after 100 tries in 10682ms): database disk image is malformed
chart (23.11.2024 22:01:48): cannot prepare select on read_table 'th0hum_day' (after 100 tries in 10634ms): database disk image is malformed
chart (23.11.2024 22:01:59): cannot prepare select on read_table 'thb0seapress_day' (after 100 tries in 10689ms): database disk image is malformed
chart (23.11.2024 22:02:10): cannot prepare select on read_table 'wind0avgwind_day' (after 100 tries in 10651ms): database disk image is malformed
chart (23.11.2024 22:02:20): cannot prepare select on read_table 'wind0wind_day' (after 100 tries in 10702ms): database disk image is malformed
chart (23.11.2024 22:02:31): cannot prepare select on read_table 'rain0total_day' (after 100 tries in 10724ms): database disk image is malformed

Re: problem database

Posted: Sat Nov 23, 2024 11:22 pm
by admin
I recommend that you make use of "rebuild on reboot" option on "Database - Adminstration" tab and avoid hard power-offs in the future.

Re: problem database

Posted: Sun Nov 24, 2024 8:27 am
by Gerrit
Unfortunately it does not help, I did see that ,ijn card is full, old the data is not deleted.

Image

Re: problem database

Posted: Tue Nov 26, 2024 7:31 pm
by Gerrit
After 2 days there is only 31MB left of the 70mb, old data is not deleted, is set to delete after 30 days.


Image

Image

Re: problem database

Posted: Mon Dec 02, 2024 11:58 pm
by admin
Database will never give back once occupied space to the filesystem. It makes use of free space within the database. Only way to solve this is to do a reconstruction.

Re: problem database

Posted: Wed Dec 04, 2024 8:10 am
by Gerrit
The problem is solved.
The charts folder had filled up, I deleted it manually.