Database is full in sqlite

I tried to write delete query in sqlite database: DELETE FROM photoGalleryTbl WHERE id=204 and I got error: "Error: database is full开发者_运维技巧".

Can I remove that record? How??

Thanks!!

---

Maybe the partition where the sqlite file is stored is full; try to move the file elsewhere and retry the delete command.

---

Yes try to move the DB file to some other location and try to use delete command and also check if you have stored the data in DB

---

It probably is the drive or the partition. Might even be that the drive or the DB file is read-only. Alternatively, you could try querying the following database properties to find out why the DB is reporting that it is full:

max_page_count

page_count

journal_size_limit