One issue i face is that I need to delete the file often in testing.When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties.
Request Method: POST Request URL: Exception Type: Operational Error Exception Value: unable to open database file Exception Location: /usr/lib/pymodules/python2.5/django/db/backends/sqlite3/in execute, line 193 Python Executable: /usr/bin/python Python Version: 2.5.2 Python Path: ['/var/www', '/usr/lib/python2.5', '/usr/lib/python2.5/plat-linux2', '/usr/lib/python2.5/lib-tk', '/usr/lib/python2.5/lib-dynload', '/usr/local/lib/python2.5/site-packages', '/usr/lib/python2.5/site-packages', '/usr/lib/pymodules/python2.5', '/usr/lib/pymodules/python2.5/gtk-2.0'] Server time: Sun, -0500 Aha, just stumbled across an article explaining this.
The db file scattered read wait event identifies that a full table scan is occurring.
When performing a full table scan into the buffer cache, the blocks read are read into memory locations that are not physically adjacent to each other.
Note: if you have logging, you will need to do this for the django logfile as well or apache won't like it much.
I think you could've just added the pi user to the www-data group too.