NucleusLogic Posted June 10, 2015 Report Share Posted June 10, 2015 We have been using Plastic SCM now for a couple of years with no issues. A couple of days ago, our clients stopped working. Checking the server the server wasn't running, (Linux). But after starting the server and trying again to connect from the client. We were still not able to. Following is the extract from the server log file during the connection attempt. I can list the repositories on the server from the command line, but not connect to it from our clients. Any help would be great. Thanks, Simon --------------------------------------------------------------------------------------------------------------------------------------------------------- 2015-06-10 14:42:12,426 00000000-0000-0000-0000-000000000000 plasticscm at SIMON -ACER-LT ERROR DataConnection - There was a problem in OpenConnection. The datab ase file is locked database is locked [/opt/plasticscm4/server/rep_1.plastic.sqlite] 2015-06-10 14:42:12,427 00000000-0000-0000-0000-000000000000 plasticscm at SIMON -ACER-LT ERROR Operations - Plastic server version: 5.0.44.519 2015-06-10 14:42:12,427 00000000-0000-0000-0000-000000000000 plasticscm at SIMON -ACER-LT ERROR Operations - OnError catching exception Plastic SCM server dev.nu cleuslogic.com:8087 wasn't able to open a connection to the database. Check the server log (plastic.server.log). Error: The database file is locked database is locked 2015-06-10 14:42:12,428 plasticscm at ERROR Codice.CM.Server.ExceptionTracerSi nk - Dumping in-transit exception:Plastic SCM server dev.nucleuslogic.com:8087 w asn't able to open a connection to the database. Check the server log (plastic.s erver.log). Error: The database file is locked database is locked 2015-06-10 14:42:12,429 plasticscm at INFO ChannelCall - recb: 920|rect: 0 |sentb: 1954|sendt: 0|prt: 30105|th: 2150|dest: 0|mt: 30105|sert: 0|zi p: 0| 110.143.254.103|GetBranchInfo 2015-06-10 14:42:12,909 251806cf-ca29-4219-8841-99008340a655 plasticscm at Serve r:dev.nucleuslogic.com ERROR DataConnection - There was a problem in OpenConnect ion. The database file is locked database is locked [/opt/plasticscm4/server/rep_1.plastic.sqlite] 2015-06-10 14:42:12,910 251806cf-ca29-4219-8841-99008340a655 plasticscm at Serve r:dev.nucleuslogic.com ERROR SecurityManager.License.LicenseManager - Error tryi ng to check license for database 1. Plastic SCM server dev.nucleuslogic.com:8087 wasn't able to open a connection to the database. Check the server log (plastic .server.log). Error: The database file is locked database is locked. at Codice.CM.Data.DataConnection.b (Codice.CM.Data.CmConne ction A_0, CmConnectionType A_1) [0x00000] in <filename unknown>:0 at Codice.CM.Data.DataConnection.b (System.String A_0, System.String A_1, CmCo nnectionType A_2) [0x00000] in <filename unknown>:0 at Codice.CM.Data.DataConnection.GetRepositoryConnection (Int64 repId, CmConne ctionType conType) [0x00000] in <filename unknown>:0 at aw.b (Int64 A_0) [0x00000] in <filename unknown>:0 at SecurityManager.License.LicenseManager.DoUpdateUsage () [0x00000] in <filen ame unknown>:0 2015-06-10 14:42:13,571 00000000-0000-0000-0000-000000000000 plasticscm at SIMON -ACER-LT INFO Operations - Get info for branch 62 at repository ID 1 Link to comment Share on other sites More sharing options...
manu Posted June 10, 2015 Report Share Posted June 10, 2015 Hi Simon! How many people are using the Plastic SCM server? SQLite is a really good backend for a single developer but it's awful for more, it's because sqlite can only handle one request at the same time. That's why we recommend MySQL over SQLite if more than one developer are going to be using the same Plastic SCM server. In your current setup I guess that one query is stuck at the SQLite engine, restarting the Plastic SCM server might solve it. Tell me if restarting server does the job, if the problem persists stop the Plastic SCM daemon and check if any *journal* file exists inside the Plastic SCM server directory. Link to comment Share on other sites More sharing options...
NucleusLogic Posted June 11, 2015 Author Report Share Posted June 11, 2015 restarting the daemon, did not resolve the problem. And yes there is a journal file in the server directory that is timestamped around the time the issues started occuring. rep_1.plastic.sqlite-journal can I just delete this file? Link to comment Share on other sites More sharing options...
manu Posted June 11, 2015 Report Share Posted June 11, 2015 Yes, that should release the lock. Anyway do a backup of your sqlite databases and the journal file. After removing the file restart the Plastic SCM server, or even better, stop it, remove the file and start it. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.