in reply to Re^2: DBD::SQLite "file is encrypted or is not a database" in running application (repro code)
in thread [SOLVED]: DBD::SQLite "file is encrypted or is not a database" in running application
Hey Dave,
I just want to say that having each process use its own DB handle seemed to have corrected my issues.
The way this particular app works is there's a core API class (OO) at its centre. There's also a DB class (OO) that manages all of the database work (it creates the actual DB handle in the new() call). The DB handle gets inserted into the DB object. The API is the only thing that talks to the DB object, so the DB object is inserted into the API object.
So, what I've done is this:
I know it's not very elegant at the moment, but I have quite a good test suite, so after some more testing, I'll be able to clean it up significantly now that I know what the issue was.
I appreciate the feedback in helping me get this resolved.
ps. The app has been running for 19+ hours as of now with very consistent memory footprint and CPU usage, all of my timers work properly in a real run, and it seems very stable.
|
|---|