Problem with SQLITE_CORRUPT

---

Hi folks,

have a problem with the SQLITE database.
Every second I get a message like:

SQLITE_CORRUPT: database disk image is malformed

• Of course I don’t have a backup

Guess my sdcard in the Raspi is on the way to cemetry …

Any ideas how to fix this without reinstallation of my (huge) pimatic stuff …

Thanks in advance,

DerIng

@DerIng you could rename or delete the pimatic-database.sqlite file, but you will lost all tracked states, temps etc. Then pimatic creates a new database and pimatic is running again. You’re not losing you config.json with this.

@DerIng Hi, try to look what is wrong. I’m using this tool: https://github.com/sqlitebrowser/sqlitebrowser/releases

Do not delete the pimatic database!
Make a backup copy of your database: cp pimatic-database.sqlite pimatic-database.sqlite.bak
En then try: sqlite3 pimatic-database.sqlite ".dump" | sqlite3 pimatic-database-new.sqlite
followed by: cp pimatic-database-new.sqlite pimatic-database.sqlite

And try to start pimatic.

Edit: maybe you first need to do an sudo apt-get install sqlite3

Thanks all!
I ended up with the deletion of the sql file.
@Harry van der Wolf: Tried to make a dump. Unfortunately the corrupt database was not able to be dumped anymore …
But at the end pimatic is running again. Will have to grab a new sdcard very soon and keep fingers crossed to be able to create a backup of the old one!

Cheers,
DerIng

go for an ssd!! doesn’t make any sense to “burn” sd cards in the pi.
from the my howto1 is a link below where you see the procedure. its just copy and paste works

https://www.raspberrypi.org/forums/viewtopic.php?f=29&t=44177

An ssd is overkill. The slow usb2 on the raspi is enough for a normal old 2.5" harddisk. The normal harddisk can easily saturate the usb2 especially as usb2 is still half-duplex even further reducing performance. A usb3 running at mucher higher speeds and being full-duplex (can receive and send at the same time) delivers a better performance in combination with an ssd.
The only reason to use an ssd with the raspi is power consumption.
If you have a bananapi with a sata connection an SSD gives improved performance.

well, a 32gb ssd is not that expensive at all, around 20 to 25 euro.
i am having a 120gb ssd attached and use the leftover space as little fileserver.