Random database connection errors

[fehaar]

Some of my users are having random database connection errors when connecting to the Plastic server. It happens at irregular intervals and does not seem to be related to server load as it also happens when few people are using it. It seems to be happening only on a specific project.

 

The get the attached error message. We are using a SQLite backend on the server.

 

Usually they can just retry the operation, so it is not destroying anything, it is just annoying.

[manu]

Hi!

 

are you using Sqlite, right? Sqlite only allows one connection at the same time so if two developers open the branch explorer at the same time one of them will get the error.

 

As you can see sqlite is telling you that the database is locked, sqlite is processing a request and you have to wait. It's not a real problem because Plastic will rollback the operation and you can retry it but it's annoying.

 

I do recommend you to switch to MySQL you will notice that it's much faster for a team and you will get rid if the database errors.