problem database

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

Moderator: Mattk

Post Reply
Gerrit
Junior Boarder
Junior Boarder
Posts: 29
Joined: Wed Feb 28, 2018 7:19 pm

problem database

Post 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
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: problem database

Post 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.
Gerrit
Junior Boarder
Junior Boarder
Posts: 29
Joined: Wed Feb 28, 2018 7:19 pm

Re: problem database

Post by Gerrit »

Unfortunately it does not help, I did see that ,ijn card is full, old the data is not deleted.

Image
Gerrit
Junior Boarder
Junior Boarder
Posts: 29
Joined: Wed Feb 28, 2018 7:19 pm

Re: problem database

Post 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
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: problem database

Post 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.
Gerrit
Junior Boarder
Junior Boarder
Posts: 29
Joined: Wed Feb 28, 2018 7:19 pm

Re: problem database

Post by Gerrit »

The problem is solved.
The charts folder had filled up, I deleted it manually.
Post Reply