For the first time a user got this message The above request was unsuccessful because the database is currently locked. Want to try again?
I'm using two SQLite databases for distinct applications on one server; using my administrator account I ran the Admin Tools to list all the active connections and only one user was still connected to the locked database : user nlefeuvre TCP File Number 6169
So I tried to kill this connection 6169 but without any success; this connection is always there!
Is there anything that could prevent the connection to be killed ? any ideas ?
I knwo I can stop the SQLitening services ... but the problem is that I have other users connected to the other database.
Quote from: Bern Ertl on May 01, 2013, 12:28:51 pm...
Unfortunately, the kill handling that Fred implemented is "passive". It doesn't forceably kill a connection until the connection owner attempts a communication with the server. So, an administrator that is attempting to kill a live connection can only post a request and then wait as it stands now. ...
Quote from: Bern Ertl on May 10, 2013, 10:02:23 am... slKill will force a connection to die within the next 60 seconds whether that connection attempts to send any data/requests or not.
The kill connection function sends a request to kill the connection. The server terminates the connection when either the client attempts to communicate with the server, or the 60 second timeout occurs. Try sending the kill request just one time and waiting for two minutes (to be sure about the timeout window). Then check if the connection is still there.