The Sql replication problem about Raven DB version 2918

[Yanjie Zhou]

There is a problem bother me for a while about the Raven DB SQL replication when we update our DB version to 2918. 

We have one database that replicate new data to the raven DB which have the SQL replication function, When we recycle the IIS of the SQL replication Raven DB, the whole SQL replication become functional and the Raven/SqlReplication/Statues Etag changing. But after half an hour more or less, the whole SQL replication stop, no matter how many new data replicate to the database, the SQL replication will not replicate the data to the SQL server. 

I think maybe this is caused by the new version of 2918 of Raven DB or other reason?

Please help:), thank you very much

[Oren Eini (Ayende Rahien)]

That seems unlikely. Can you enable the debug log and see what is going on there?

Hibernating Rhinos Ltd  

Oren Eini l CEO l Mobile: + 972-52-548-6969

Office: +972-4-622-7811 l Fax: +972-153-4-622-7811

 

--
You received this message because you are subscribed to the Google Groups "RavenDB - 2nd generation document database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Yanjie Zhou]

I turned debug on. The sql replication stopped without error after 37 minutes. Here are the last outputs. Then nothing.

2014-09-30 14:37:24.5416,Raven.Database.Bundles.SqlReplication.SqlReplicationTask,Debug,Replicated changes of serviceactivities/ZPGMUPJE3R4OKWEIYWUZO68140928 for replication IsasServiceActivityValidation,

2014-09-30 14:37:28.8100,Raven.Database.Bundles.SqlReplication.SqlReplicationTask,Debug,Replicated changes of serviceprovidercalltransactions/8762c428-e7aa-422d-93c3-e88cdfe96785 for replication IsasServiceProviderCallTransaction,

2014-09-30 14:37:32.6171,Raven.Database.Bundles.SqlReplication.SqlReplicationTask,Debug,recorded a deleted document calendarevents/4857,

2014-09-30 14:37:34.8921,Raven.Database.Bundles.SqlReplication.SqlReplicationTask,Debug,Replicated changes of serviceprovidercalltransactions/d33b4fd6-03ce-4426-b005-d1734092b77e for replication IsasServiceProviderCallTransaction,

Then I recycled the IIS pool, and this time it runs 13 minutes 

2014-09-30 15:13:30.0421,Raven.Database.Bundles.SqlReplication.SqlReplicationTask,Debug,Replicated changes of serviceactivities/AGJHROM727EGR899MEITQ48140930 for replication IsasServiceActivity,

2014-09-30 15:13:30.0577,Raven.Database.Bundles.SqlReplication.SqlReplicationTask,Debug,Replicated changes of serviceactivities/AGJHROM727EGR899MEITQ48140930 for replication IsasServiceActivityValidation,

2014-09-30 15:20:52.2773,Raven.Database.Bundles.SqlReplication.SqlReplicationTask,Debug,recorded a deleted document calendarevents/6335,

Thanks

[Oren Eini (Ayende Rahien)]

Can you check the status from the SQL Server side? If there is a hanging connection, or something like that?

Can you send us the log file?

[Yanjie Zhou]

Hi, 

The problem that I find yesterday was resolved but I find another problem when I doing the replication, 

The error message is like this:

2014-10-01 10:39:58.5873,Raven.Database.Bundles.SqlReplication.SqlReplicationTask,Warn,"Could not process SQL Replication script for ISASClaimAppendOnly_v2, skipping document: claims/1260845","System.InvalidOperationException: Cannot modify a snapshot, this is probably a bug

   at Raven.Json.Linq.DictionaryWithParentSnapshot.set_Item(String key, RavenJToken value) in c:\Builds\RavenDB-Unstable-v2.5-New\Raven.Abstractions\Json\Linq\DictionaryWithParentSnapshot.cs:line 185

   at Raven.Database.Bundles.SqlReplication.SqlReplicationTask.ApplyConversionScript(SqlReplicationConfig cfg, IEnumerable`1 docs) in e:\_DEV_\_Ltss\TFSProject\libsrc\_ravendb\_official-2.0\ravendb-build-2918\Raven.Database\Bundles\SqlReplication\SqlReplicationTask.cs:line 475"

This error keep appear for like 50 times and then the server stopped.

Any ideas about this error?

Thanks

[Oren Eini (Ayende Rahien)]

Please upgrade to the latest build, it is resolved there.

[Yanjie Zhou]

Is the latest build 2935? Or earlier version?

Thanks

[Yanjie Zhou]

Is that 2935? Or earlier version?

[Oren Eini (Ayende Rahien)]

That one