reschnip / pitank

Automatically exported from code.google.com/p/pitank
0 stars 0 forks source link

Database Locked Errors #1

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
This issue crops up every now and again when you try and do anything that 
requires writes to the database.  

Instead of completing the desired action a ticket is generated saying that the 
database is locked. 

This is because the database is currently running using SQLite and the 
background processes for monitoring temperature, etc write values to the 
database. SQLite locks the database whenever it is being written to. 

There are a couple of possible solutions i can see. 
1. Migrate database to PostgreSQL. 
2. Change the code so that temperature values are not stored in the database. 

Option 1 would seem the easiest solution.

Original issue reported on code.google.com by BeardedO...@gmail.com on 27 Aug 2013 at 8:34

GoogleCodeExporter commented 9 years ago

Original comment by BeardedO...@gmail.com on 27 Aug 2013 at 8:39

GoogleCodeExporter commented 9 years ago

Original comment by BeardedO...@gmail.com on 27 Aug 2013 at 8:39