# Few records in in the db for the same example **URL:** https://support.prodi.gy/t/few-records-in-in-the-db-for-the-same-example/6577 **Category:** Uncategorized **Tags:** usage **Created:** [June 1, 2023, 3:04pm UTC](https://support.prodi.gy/t/few-records-in-in-the-db-for-the-same-example/6577 "2023-06-01T15:04:04Z") **Posts on this page:** 1 **Showing post:** 11
### Author: ![ryanwesslen](https://sea2.discourse-cdn.com/flex020/user_avatar/support.prodi.gy/ryanwesslen/32/2969_2.png) [@ryanwesslen](https://support.prodi.gy/u/ryanwesslen) #### Post date: [June 6, 2023, 8:55pm UTC](https://support.prodi.gy/t/few-records-in-in-the-db-for-the-same-example/6577/11 "2023-06-06T20:55:26Z")
hi @zparcheta! Trying to step in because Vincent is juggling a lot. > [@zparcheta](#): > > I just performed a real scenario exercise using `http://hostname/?session=` > and `"exclude_by": "task"`. From 50 examples, 4 are repeated. > In the second exercise, the first example is not saved in the DB. I'm trying to catch up but is the root of your problem that you saw some duplicate records when annotating? I'm not sure I understand what you mean by the "first example" not saved in the DB and if this is a critical problem you're trying to solve. > [@zparcheta](#): > > But honestly, I think it will it be difficult to reproduce the errors. I repeated the same experiment another time and everything went ok. And as you mention here, you noticed it once, but not again? Any chance that these duplicates tend to be near the end of your stream? Also I noticed that your `prodigy.json` keeps the default of `feed_overlap: false`. This sounds like it could be work stealing. I just wrote up a detailed response accumulating a lot of details on this and why it's actually a preventive measure to avoid an alternative problem: examples getting dropped. We have lots of plans in the work to provide alternative options (e.g., task routing and in v2, a complete overhaul of our stream generator that would eliminate the need for work stealing). > [@Tasks are duplicated](https://support.prodi.gy/t/tasks-are-duplicated/6583/2): > > hi @auguststapput! Thanks for your question and welcome to the Prodigy community wave Could it be work-stealing? Did you notice these duplicates near the end of the stream? We fixed a front-end bug was fixed in v1.11.9, which given you're using v1.11.11. But work stealing is still a possibility as we outlined in our [v1.11.9 announcement](https://support.prodi.gy/t/prodigy-v1-11-9-release/6263): It should be be noted though, that a small number of duplicates is still expected in multi-user workflows with [feed overlap](https://prodi.gy/docs/api-web-app#multi-user-sessions)set to false. This is perfec… > It should be noted though, that a small number of duplicates is still expected in multi-user workflows with [`feed overlap`](https://prodi.gy/docs/api-web-app#multi-user-sessions)set to `false`. This is perfectly normal behavior and should only occur towards the end of the example stream. These "end-of-queue" duplicates come from the [work-stealing mechanism](https://support.prodi.gy/t/repeated-examples-in-multi-user-sessions/5235/2)in the internal Prodigy feed. "Work-stealing" is a **preventive mechanism to avoid records in the stream from being lost** when an annotator requests a batch of examples to annotate, effectively locking those examples, and then never annotates them. This mechanism allows annotators that reach the end of a shared stream to annotate these otherwise locked examples that other annotators are holding on to. Essentially we have prioritized annotating all examples in your data stream at least once vs at most once while potentially losing a few. If it is work stealing, probably your best tactic on this is to remind your annotators to save their annotations when they're done and don't keep a browser open indefinitely. Another option you can do that will reduce the chance of duplicates is reducing your `batch_size` to 1. However, this has the trade-off that users can't go back and modify their last example as accepted records will be immediately saved to the database. Does this make sense? --- _[View the full topic](https://support.prodi.gy/t/few-records-in-in-the-db-for-the-same-example/6577)._