freaksed Posted January 21, 2014 Report Share Posted January 21, 2014 I migrated to MySQL but now I can't make repos. I tried completely deleting everything, and uninstalling Plastic. I've increased every timeout variable I could find in MySQL and added the one to the db.conf. Plastic is not even able to create the default repo when starting the server with an empty db. It creates the "repositories" but fails to create "rep_1". Bellow a clean log from restarting the server with a blank db. Any help with this would be greatly appreciated since I am out of ideas. 2014-01-20 22:28:44,170 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'BufferPoolMax' is set to '10'. It sets the maximum number of available buffers for object data transfers 2014-01-20 22:28:44,204 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'SerializationObjectsAtSink' is set to 'True'. True means SerializationBase descendants are directly written into the response buffer 2014-01-20 22:28:44,204 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'sinklevel' compression mode set. all metadata will be serialized 2014-01-20 22:28:44,227 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - Start listening 2014-01-20 22:28:44,231 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'BufferPoolMax' is set to '10'. It sets the maximum number of available buffers for object data transfers 2014-01-20 22:28:44,231 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'SerializationObjectsAtSink' is set to 'True'. True means SerializationBase descendants are directly written into the response buffer 2014-01-20 22:28:44,231 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'sinklevel' compression mode set. all metadata will be serialized 2014-01-20 22:28:44,236 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - Using certificate file ssl-certificate.pfx 2014-01-20 22:28:44,266 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - Start listening 2014-01-20 22:28:53,421 1dbc4a94-1fd9-414e-8356-497959c57bab NT AUTHORITY\SYSTEM at Server:BEN-PC INFO Transaction - Transaction timeout -> 120000ms 2014-01-20 22:29:30,431 1f3ed9ae-4966-4394-a26e-e2c875170b77 NT AUTHORITY\SYSTEM at Server:BEN-PC ERROR DataManager - Error in DoExecuteDatabaseScript. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at MySql.Data.MySqlClient.MySqlConnection.HandleTimeout(TimeoutException tex) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at axf.a(CmConnection A_0, String A_1, Boolean A_2) 2014-01-20 22:29:30,431 1f3ed9ae-4966-4394-a26e-e2c875170b77 NT AUTHORITY\SYSTEM at Server:BEN-PC ERROR DataManager - Error trying to create the database rep_1: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 2014-01-20 22:29:30,433 1f3ed9ae-4966-4394-a26e-e2c875170b77 NT AUTHORITY\SYSTEM at Server:BEN-PC ERROR DataManager - Error in CreateSingleRepository. The database rep_1 can't be created. Check the server log (plastic.server.log). Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Codice.CM.Data.BaseDataManager.ExecuteCreateDatabaseScript(String databaseName, String contentResourceName) at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId) 2014-01-20 22:29:30,510 1f3ed9ae-4966-4394-a26e-e2c875170b77 NT AUTHORITY\SYSTEM at Server:BEN-PC INFO Transaction - RollbackArea -- Transaction removed 1f3ed9ae-4966-4394-a26e-e2c875170b77 2014-01-20 22:29:30,511 NT AUTHORITY\SYSTEM at ERROR Transaction - The database rep_1 can't be created. Check the server log (plastic.server.log). Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId) at ou.a(SOTRepositoryCreationData A_0, SEID A_1) at ou.a(SOTCreationData A_0, SEID A_1) at Codice.CM.Server.RepositoryHandler.CreateRepository(String repositoryName) at Codice.CM.Server.TransactionManager.ExecuteServerTransactedCall(DoServerTransactedCallDelegate call) 2014-01-20 22:29:30,512 NT AUTHORITY\SYSTEM at ERROR Codice.CM.Server.RepositoryHandler - The database rep_1 can't be created. Check the server log (plastic.server.log). Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId) at ou.a(SOTRepositoryCreationData A_0, SEID A_1) at ou.a(SOTCreationData A_0, SEID A_1) at Codice.CM.Server.RepositoryHandler.CreateRepository(String repositoryName) at Codice.CM.Server.TransactionManager.ExecuteServerTransactedCall(DoServerTransactedCallDelegate call) at Codice.CM.Server.RepositoryHandler.InitService() Link to comment Share on other sites More sharing options...
manu Posted January 27, 2014 Report Share Posted January 27, 2014 I think we are chatting using the email. As soon as we find the solution we'll publish it here. Link to comment Share on other sites More sharing options...
Andy22 Posted February 12, 2014 Report Share Posted February 12, 2014 I'm getting the same error trying to use PlasticSCM with MySQL: ,987 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at ANDY-PC INFO Operations - Create repository test1,337 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - Tcp transport error. ReceiveMessageStatus Connection closed,337 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - conn 1 Tcp transport error. Connection closed,329 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at ANDY-PC ERROR DataManager - Error in DoExecuteDatabaseScript. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at MySql.Data.MySqlClient.MySqlConnection.HandleTimeout(TimeoutException tex) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at axf.a(CmConnection A_0, String A_1, Boolean A_2),345 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at ANDY-PC ERROR DataManager - Error trying to create the database rep_7: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.,345 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at ANDY-PC ERROR DataManager - Error in CreateSingleRepository. The database rep_7 can't be created. Check the server log (plastic.server.log). Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Codice.CM.Data.BaseDataManager.ExecuteCreateDatabaseScript(String databaseName, String contentResourceName) at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId),345 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at ANDY-PC ERROR Operations - Plastic server version: 5.0.44.528,345 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at ANDY-PC ERROR Operations - OnError catching exception The database rep_7 can't be created. Check the server log (plastic.server.log). Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.,407 NT AUTHORITY\SYSTEM at ERROR Codice.CM.Server.ExceptionTracerSink - Dumping in-transit exception:The database rep_7 can't be created. Check the server log (plastic.server.log). Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.,407 NT AUTHORITY\SYSTEM at INFO ChannelCall - recb: 528|rect: 0|sentb: 1518|sendt: 0|prt: 30436|th: 5|dest: 0|mt: 30436|sert: 0|zip: 0| 192.168.0.22|CreateRepository So any update on this problem? Thx Andy PS: I already did try increasing the connection timeout from 10 to 60 seconds, without any change. Link to comment Share on other sites More sharing options...
Andy22 Posted February 12, 2014 Report Share Posted February 12, 2014 Update: I was able to fix this problem, by reinstalling MySQL and choose "Development" machine instead of "Dedicated MySQL server". So some configuration difference between those 2 options seem to cause this problem. Update2: After following those tips: http://www.plasticscm.com/infocenter/technical-articles/kb-how-to-fine-tune-mysql-performance-for-plastic-scm.aspx i'm back to the old error and can't create repositories. If i remove all the memory tweaks, except the "max_allowed_packet" i'm "sometimes" able to create repositories again. Means it did work once and now it dosn't again, without changing anything in the MySQL config. It seems to help if u start/stop the MySQL server, before u try create a new repo. This is on a dedicated 4G ram x64 server, that runs nothing but Plastic + MySQL! Link to comment Share on other sites More sharing options...
calbzam Posted February 17, 2014 Report Share Posted February 17, 2014 Hi, It seems a bit difficult to reproduce. What Linux distro are you using? How did you install MySQL, packages? After removing the memory tweaks, you said that sometimes able to create databases. No pattern or workflow for reproducing? Regards, Carlos Link to comment Share on other sites More sharing options...
Andy22 Posted February 17, 2014 Report Share Posted February 17, 2014 Hi, It seems a bit difficult to reproduce. What Linux distro are you using? How did you install MySQL, packages? After removing the memory tweaks, you said that sometimes able to create databases. No pattern or workflow for reproducing? Regards, Carlos Was on a Windows 2012 R2 Server, but like noted we changed to Firebird now, since MySQL performance was really bad. We just installed the latest MySQL CE on the server using the "Dedicated MySQL" option and applied the "max_allowed_packet" tweak, that was all. We than directly started to have problems and increased the connection timeouts, since i suspected this might be the problem. We also noticed that the repos where actually created in the database, since we could see them in the Workbench, but somehow Plastic timed out. We than applied all the Plastic memory tweaks, without any luck and reinstalled MySQL using the "Developer" option, than we actually could create 2 test repos and the next day it stopped working again. We did a server reboot and could create 1 new repo, but directly after it failed again. bye Andy Link to comment Share on other sites More sharing options...
apujol Posted August 5, 2014 Report Share Posted August 5, 2014 Hi, I'm having the same problem when creating the repositories on MySQL (5.6) for the first time. I have reinstalled the Plastic SCM several times, changing different parameters in the database but the result is always the same. It starts creating the database repositories and rep_1 and executing several commands (as I can monitor in the MySQL process list), but after 30 seconds it suddently stops and show this on the trace: 2014-08-05 17:55:15,437 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - Start listening 2014-08-05 17:55:23,968 9e747076-cb9f-4ec6-b8e0-1e1562731875 NT AUTHORITY\SYSTEM at Server:SRVCPSXT INFO Transaction - Transaction timeout -> 120000ms 2014-08-05 17:55:56,687 5cdc96ce-c833-455a-9290-968a9209178b NT AUTHORITY\SYSTEM at Server:SRVCPSXT ERROR DataManager - Error in DoExecuteDatabaseScript. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at MySql.Data.MySqlClient.MySqlConnection.HandleTimeout(TimeoutException tex) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at axf.a(CmConnection A_0, String A_1, Boolean A_2) 2014-08-05 17:55:56,687 5cdc96ce-c833-455a-9290-968a9209178b NT AUTHORITY\SYSTEM at Server:SRVCPSXT ERROR DataManager - Error trying to create the database wn_scm_rep_1: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 2014-08-05 17:55:56,687 5cdc96ce-c833-455a-9290-968a9209178b NT AUTHORITY\SYSTEM at Server:SRVCPSXT ERROR DataManager - Error in CreateSingleRepository. The database wn_scm_rep_1 can't be created. Check the server log (plastic.server.log). Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Codice.CM.Data.BaseDataManager.ExecuteCreateDatabaseScript(String databaseName, String contentResourceName) at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId) 2014-08-05 17:55:56,734 5cdc96ce-c833-455a-9290-968a9209178b NT AUTHORITY\SYSTEM at Server:SRVCPSXT INFO Transaction - RollbackArea -- Transaction removed 5cdc96ce-c833-455a-9290-968a9209178b 2014-08-05 17:55:56,734 NT AUTHORITY\SYSTEM at ERROR Transaction - The database wn_scm_rep_1 can't be created. Check the server log (plastic.server.log). Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId) at ou.a(SOTRepositoryCreationData A_0, SEID A_1) at ou.a(SOTCreationData A_0, SEID A_1) at Codice.CM.Server.RepositoryHandler.CreateRepository(String repositoryName) at Codice.CM.Server.RepositoryHandler.a() at Codice.CM.Server.TransactionManager.ExecuteServerTransactedCall(DoServerTransactedCallDelegate call) 2014-08-05 17:55:56,734 NT AUTHORITY\SYSTEM at ERROR Codice.CM.Server.RepositoryHandler - The database wn_scm_rep_1 can't be created. Check the server log (plastic.server.log). Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId) at ou.a(SOTRepositoryCreationData A_0, SEID A_1) at ou.a(SOTCreationData A_0, SEID A_1) at Codice.CM.Server.RepositoryHandler.CreateRepository(String repositoryName) at Codice.CM.Server.RepositoryHandler.a() at Codice.CM.Server.TransactionManager.ExecuteServerTransactedCall(DoServerTransactedCallDelegate call) at Codice.CM.Server.RepositoryHandler.c() at Codice.CM.Server.RepositoryHandler.InitService() I have already try adding Connection Timeout=300 and <CommandTimeout>300</CommandTimeout>, but the result is the same. How can I increment this operation timeout in order to give enough time to create the databases? Many thanks in advance... Alejandro Link to comment Share on other sites More sharing options...
calbzam Posted August 12, 2014 Report Share Posted August 12, 2014 Hi, I experienced this issue before, but increasing the command timeout fixed the problem. Could you tell me your Plastic version and Linux distribution? I will test using the same scenario. Regards, Carlos Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.