lost checkins

[hampsterx]

Hi there,

We have just lost about 28 changesets from this afternoon! (can recover from backup but it's a last resort)

Went to checkin and it can't checkin as the changeset does not exist. Checked the database and the "changeset" table shows 3282 as most recent even though we were up to 3280.

The plastic server and db is running on a rather constrained VM. (ubuntu - 1gb Memory)

Any information appreciated,

TiM

Log is below..

------------------

2012-05-08 16:20:58,350 00000000-0000-0000-0000-000000000000 plasticscm at TIM-AGF ERROR DataConnection - Error in ExecuteReader. Query SELECT d.iobjid, d.icompression, d.slast , d.bdata FROM revisiondata d WHERE d.fidobject = ?revision AND d.itype = ?type AND d.isegment = ?segment

Table 'rep_1.revisiondata' doesn't exist

at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0

at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int32& insertedId) [0x00000] in <filename unknown>:0

2012-05-08 16:20:58,350 00000000-0000-0000-0000-000000000000 plasticscm at TIM-AGF ERROR Operations - Plastic server version: 4.1.10.268

2012-05-08 16:20:58,350 00000000-0000-0000-0000-000000000000 plasticscm at TIM-AGF ERROR Operations - OnError catching exception Table 'rep_1.revisiondata' doesn't exist

2012-05-08 16:20:58,350 plasticscm at ERROR Codice.CM.Server.ExceptionTracerSink - Dumping in-transit exception:There has been an unexpected error "Table 'rep_1.revisiondata' doesn't exist". For more information check the server log.

[psantosl]

Hi there,

Not sure why there is no answer to this post. Did you contact support directly after that??

Running out of disk space can cause trouble to some databases. A box with 1GB RAM should be more than fine, although it really depends on the load.

For Linux environments I strongly recommend using 64 bits boxes since the default garbage collector in Mono tends to screw up things, switching to sgen is a must.

@psluaces

[hampsterx]

Thanks for that, Plastic has been working beautifully apart from that hickup last week. We will keep a closer eye on that server. Can you provide more info on Sgen, not sure what you are referring to here,. I presume

-gc=sgen option for mono??

Cheers, TiM

[hampsterx]

also getting a bunch of these?

2012-05-14 16:49:23,887 (null) plasticscm at (null) INFO Channel - conn 4755 Connection reset by peer

2012-05-14 16:52:04,385 (null) plasticscm at (null) INFO Channel - conn 4758 Connection reset by peer

2012-05-14 16:52:04,924 (null) plasticscm at (null) INFO Channel - conn 4757 Connection reset by peer

2012-05-14 16:52:05,353 (null) plasticscm at (null) INFO Channel - conn 4759 Connection reset by peer

2012-05-14 16:52:05,961 (null) plasticscm at (null) INFO Channel - conn 4760 Connection reset by peer

2012-05-14 16:52:07,189 (null) plasticscm at (null) INFO Channel - conn 4762 Connection reset by peer

2012-05-14 16:52:11,093 (null) plasticscm at (null) INFO Channel - conn 4761 Connection reset by peer

2012-05-14 16:52:14,138 (null) plasticscm at (null) INFO Channel - conn 4763 Connection reset by peer

2012-05-14 16:52:15,405 (null) plasticscm at (null) INFO Channel - conn 4765 Connection reset by peer

2012-05-14 16:52:18,349 (null) plasticscm at (null) INFO Channel - conn 4766 Connection reset by peer

2012-05-14 16:52:19,501 (null) plasticscm at (null) INFO Channel - conn 4767 Connection reset by peer

2012-05-14 16:52:19,968 (null) plasticscm at (null) INFO Channel - conn 4764 Connection reset by peer

2012-05-14 16:52:21,081 (null) plasticscm at (null) INFO Channel - conn 4768 Connection reset by peer

2012-05-14 16:52:24,240 (null) plasticscm at (null) INFO Channel - conn 4769 Connection reset by peer

2012-05-14 16:52:24,512 (null) plasticscm at (null) INFO Channel - conn 4770 Connection reset by peer

2012-05-14 16:52:24,792 (null) plasticscm at (null) INFO Channel - conn 4771 Connection reset by peer

2012-05-14 16:52:26,904 (null) plasticscm at (null) INFO Channel - conn 4772 Connection reset by peer

2012-05-14 16:52:28,035 (null) plasticscm at (null) INFO Channel - conn 4773 Connection reset by peer

2012-05-14 16:52:28,254 (null) plasticscm at (null) INFO Channel - conn 4774 Connection reset by peer

2012-05-14 16:52:28,324 (null) plasticscm at (null) INFO Channel - conn 4775 Connection reset by peer

2012-05-14 16:52:29,560 (null) plasticscm at (null) INFO Channel - conn 4776 Connection reset by peer

2012-05-14 16:52:46,573 (null) plasticscm at (null) INFO Channel - conn 4777 Connection reset by peer

2012-05-14 16:52:47,596 (null) plasticscm at (null) INFO Channel - conn 4778 Connection reset by peer

2012-05-14 16:52:48,658 (null) plasticscm at (null) INFO Channel - conn 4779 Connection reset by peer

2012-05-14 16:52:49,732 (null) plasticscm at (null) INFO Channel - conn 4780 Connection reset by peer

2012-05-14 16:52:54,472 (null) plasticscm at (null) INFO Channel - conn 4781 Connection reset by peer

2012-05-14 16:52:56,034 (null) plasticscm at (null) INFO Channel - conn 4782 Connection reset by peer

2012-05-14 16:52:57,605 (null) plasticscm at (null) INFO Channel - conn 4783 Connection reset by peer

2012-05-14 16:52:57,670 (null) plasticscm at (null) INFO Channel - Tcp transport error. ReceiveMessageStatus Connection closed

2012-05-14 16:52:57,670 (null) plasticscm at (null) INFO Channel - conn 4756 Tcp transport error. Connection closed

2012-05-14 16:52:58,750 (null) plasticscm at (null) INFO Channel - conn 4784 Connection reset by peer

2012-05-14 16:55:35,459 (null) plasticscm at (null) INFO Channel - conn 4786 Connection reset by peer

2012-05-14 16:55:36,605 (null) plasticscm at (null) INFO Channel - conn 4787 Connection reset by peer

2012-05-14 16:55:40,659 (null) plasticscm at (null) INFO Channel - Tcp transport error. ReceiveMessageStatus Connection closed

2012-05-14 16:55:40,690 (null) plasticscm at (null) INFO Channel - conn 4785 Tcp transport error. Connection closed

2012-05-14 16:58:18,698 (null) plasticscm at (null) INFO Channel - Tcp transport error. ReceiveMessageStatus Connection closed

2012-05-14 16:58:18,698 (null) plasticscm at (null) INFO Channel - conn 4788 Tcp transport error. Connection closed

2012-05-14 17:06:30,523 (null) plasticscm at (null) INFO Channel - conn 4791 Connection reset by peer

2012-05-14 17:06:31,150 (null) plasticscm at (null) INFO Channel - conn 4790 Connection reset by peer

2012-05-14 17:06:31,546 (null) plasticscm at (null) INFO Channel - conn 4792 Connection reset by peer

2012-05-14 17:06:37,366 (null) plasticscm at (null) INFO Channel - conn 4793 Connection reset by peer

2012-05-14 17:06:38,046 (null) plasticscm at (null) INFO Channel - conn 4794 Connection reset by peer

2012-05-14 17:06:43,256 (null) plasticscm at (null) INFO Channel - conn 4795 Connection reset by peer

2012-05-14 17:06:43,271 (null) plasticscm at (null) INFO Channel - conn 4797 Connection reset by peer

2012-05-14 17:06:44,342 (null) plasticscm at (null) INFO Channel - conn 4796 Connection reset by peer

2012-05-14 17:06:45,716 (null) plasticscm at (null) INFO Channel - conn 4799 Connection reset by peer

2012-05-14 17:06:45,764 (null) plasticscm at (null) INFO Channel - conn 4798 Connection reset by peer

2012-05-14 17:07:12,730 (null) plasticscm at (null) INFO Channel - Tcp transport error. ReceiveMessageStatus Connection closed

2012-05-14 17:07:12,730 (null) plasticscm at (null) INFO Channel - conn 4789 Tcp transport error. Connection closed

2012-05-14 17:08:28,092 (null) plasticscm at (null) INFO Channel - Tcp transport error. ReceiveMessageStatus Connection closed

2012-05-14 17:08:28,092 (null) plasticscm at (null) INFO Channel - conn 4800 Tcp transport error. Connection closed

2012-05-14 17:14:33,119 (null) plasticscm at (null) INFO Channel - conn 4803 Connection reset by peer

2012-05-14 17:14:33,751 (null) plasticscm at (null) INFO Channel - conn 4802 Connection reset by peer

2012-05-14 17:14:34,197 (null) plasticscm at (null) INFO Channel - conn 4805 Connection reset by peer

2012-05-14 17:14:34,197 (null) plasticscm at (null) INFO Channel - conn 4804 Connection reset by peer

2012-05-14 17:14:35,783 (null) plasticscm at (null) INFO Channel - conn 4807 Connection reset by peer

2012-05-14 17:14:36,936 (null) plasticscm at (null) INFO Channel - conn 4809 Connection reset by peer

2012-05-14 17:14:37,527 (null) plasticscm at (null) INFO Channel - conn 4806 Connection reset by peer

2012-05-14 17:14:39,424 (null) plasticscm at (null) INFO Channel - conn 4808 Connection reset by peer

2012-05-14 17:14:45,998 (null) plasticscm at (null) INFO Channel - conn 4811 Connection reset by peer

2012-05-14 17:14:47,386 (null) plasticscm at (null) INFO Channel - conn 4810 Connection reset by peer

2012-05-14 17:14:50,115 (null) plasticscm at (null) INFO Channel - conn 4814 Connection reset by peer

2012-05-14 17:14:50,139 (null) plasticscm at (null) INFO Channel - conn 4813 Connection reset by peer

2012-05-14 17:14:50,323 (null) plasticscm at (null) INFO Channel - conn 4812 Connection reset by peer

2012-05-14 17:15:28,157 (null) plasticscm at (null) INFO Channel - Tcp transport error. ReceiveMessageStatus Connection closed

2012-05-14 17:15:28,157 (null) plasticscm at (null) INFO Channel - conn 4801 Tcp transport error. Connection closed

any idea?

[psantosl]

This is perfectly normal. It is just warning you when a connection is closed. Perfectly normal.

[hampsterx]

vgood, the log is kinda large so might set the log level to error only. Will keep a close eye on it.

Can you briefly ellaborate on sgen please.

TiM

[manu]

Hi!

if you want to try the sgen you just need to add the "--gc=sgen" parameter into the "plasticd" Linux start-up script. If you have any questions about it I can help you.