[Haskell-cafe] HDBC SQLite error

Jurriën Stutterheim j.stutterheim at me.com
Tue Nov 1 17:30:02 CET 2011

Hi all,

I have recently switched one of my web applications to SQLite via HDBC. I use it to store some user credentials and data. Initially it seemed to work fine, until I tried logging in from two different browsers. That's when I got the following error when trying to log in:

SqlError {seState = "", seNativeError = 5, seErrorMsg = "step: database is locked"}

My application only uses two functions (query and query', see [1]) directly, and the authentication code[2] uses HDBC directly. I'm not sure why I'm getting this error, because as far as I can see, I'm not keeping any transactions open longer than I have to in the auth code. Does anyone have an idea what might be wrong and how to fix it?



[1] https://github.com/norm2782/snaplet-hdbc/blob/master/src/Snap/Snaplet/Hdbc.hs#L155
[2] https://github.com/norm2782/snaplet-hdbc/blob/master/src/Snap/Snaplet/Auth/Backends/Hdbc.hs

More information about the Haskell-Cafe mailing list