Hello,
sometimes I can see this error:
central-00-job-3 Failed to delete data gap: { startId: 36957986, endId: 36958007, createTime: "Thu Nov 09 13:45:15 CET 2017" }
It is 5-10 messages in a row with different data gap id. It seems it has no impact on anytning and symmetric works fine after that. Symmetric version 3.8.x. on Firebird 2.5 database. What is a cause?
Last edit: Tom 2017-11-09
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi all,
same problem here: i often see many of these errors:
2017-11-13 11:44:00,568 ERROR [sourcedb.hostdb][DataService][sourcedb.hostdb-job-13] Failed to delete data gap: { startId: 1123805, endId: 1123805, createTime: "Mon Nov 13 11:34:30 CET 2017" }
2017-11-13 11:44:00,568 ERROR [sourcedb.hostdb][DataService][sourcedb.hostdb-job-13] Failed to delete data gap: { startId: 1121659, endId: 1122735, createTime: "Mon Nov 13 11:33:57 CET 2017" }
2017-11-13 11:44:00,568 ERROR [sourcedb.hostdb][DataService][sourcedb.hostdb-job-13] Failed to delete data gap: { startId: 1122759, endId: 1123769, createTime: "Mon Nov 13 11:34:30 CET 2017" }
Usually these errors happened the same time that many batches are routed to clients. I suppose the server can't delete data gap because it is still using it for outgoing batches that are running.
If this is right, maybe it should indicated as WARNING instead of a ERROR..
We have Symmetric 3.8.31 on Derby 10.10.2 database.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is something we haven't reproduced yet, so any other background you can offer would help.
We are planning to release a diagnostic patch later this week - if you are available, it would help if you could deploy that patch and let us know if you see any data gap errors.
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
thank you for reply
yes it seems that happend only if more batches are in progres
I can try this patch on some test database, but there is no this error, and I cant change main database at the moment.. so maybe Roberto Giovanardi can help with testing
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This has been fixed for 3.8.32. The error is not affecting data sync. It keeps the correct data gaps in memory, it just wasn't updating the gap table correctly.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
sometimes I can see this error:
central-00-job-3 Failed to delete data gap: { startId: 36957986, endId: 36958007, createTime: "Thu Nov 09 13:45:15 CET 2017" }
It is 5-10 messages in a row with different data gap id. It seems it has no impact on anytning and symmetric works fine after that. Symmetric version 3.8.x. on Firebird 2.5 database. What is a cause?
Last edit: Tom 2017-11-09
Hi all,
same problem here: i often see many of these errors:
2017-11-13 11:44:00,568 ERROR [sourcedb.hostdb] [DataService] [sourcedb.hostdb-job-13] Failed to delete data gap: { startId: 1123805, endId: 1123805, createTime: "Mon Nov 13 11:34:30 CET 2017" }
2017-11-13 11:44:00,568 ERROR [sourcedb.hostdb] [DataService] [sourcedb.hostdb-job-13] Failed to delete data gap: { startId: 1121659, endId: 1122735, createTime: "Mon Nov 13 11:33:57 CET 2017" }
2017-11-13 11:44:00,568 ERROR [sourcedb.hostdb] [DataService] [sourcedb.hostdb-job-13] Failed to delete data gap: { startId: 1122759, endId: 1123769, createTime: "Mon Nov 13 11:34:30 CET 2017" }
Usually these errors happened the same time that many batches are routed to clients. I suppose the server can't delete data gap because it is still using it for outgoing batches that are running.
If this is right, maybe it should indicated as WARNING instead of a ERROR..
We have Symmetric 3.8.31 on Derby 10.10.2 database.
Guys, thank you for bringing this up. We have had several users report this and have an issue opened now: https://www.symmetricds.org/issues/view.php?id=3317
This is something we haven't reproduced yet, so any other background you can offer would help.
We are planning to release a diagnostic patch later this week - if you are available, it would help if you could deploy that patch and let us know if you see any data gap errors.
Thanks!
thank you for reply
yes it seems that happend only if more batches are in progres
I can try this patch on some test database, but there is no this error, and I cant change main database at the moment.. so maybe Roberto Giovanardi can help with testing
Hi all, no problem for us, we can setup the diagnostic patch as soon as it will be deployed.
Guys, thanks for the offers of help. I think we got to the bottom of this one and it is fixed in 3.8.32.
https://sourceforge.net/projects/symmetricds/files/symmetricds/symmetricds-3.8/
Mark
This has been fixed for 3.8.32. The error is not affecting data sync. It keeps the correct data gaps in memory, it just wasn't updating the gap table correctly.
Thanks guys, we are already trying the fixed version
Roberto