Changesets missing from filter results
elevenchars opened this issue · 10 comments
I'm submitting a bug report
Brief Description
There appear to be some changesets missing from the downtime. This is important for people who do QA for an area/type of edit using OSMCha filters.
What is the current behaviour, (attach relevant screenshots) ?
Notice that changeset 147430472 is missing from the filter results.
What is the expected behaviour ?
The filter results should include all changesets which match it.
When does this occur ?
The conditions for this to occur are unclear, I just happened to notice it when I opened OSMCha after the downtime.
How do we replicate the issue ?
- Filter to changesets by citrula link
- Compare to changesets listed at citrula's OpenStreetMap profile
- Notice that there is a changeset missing
Please tell us about your environment:
I'm using Firefox 122.0 (64-bit) and the production instance located at https://osmcha.org.
Other Information / context:
@batpad requested I open an issue here after I mentioned this issue in Slack.
Changesets 147448293 and 147448264 are missing for me as well
Thanks @elevenchars @emersonveenstra ! My hunch is this happened during the 48 hour period or so when we were hitting db throttling issues. We can attempt to re-run / backfill changeset files for those days. If this does seem to be continuing to happen, then it's definitely a matter of concern and we'll go through logs a bit better to try and figure what's happening.
20th may all changeset are missing, I can barely find only one.
Hello. Running some filters now. It seems to be a huge gap, but not only from 20th... the filter gives me 6 changesets for a whole country in the last 24 hours, which is not real.
thanks
Not sure this is the same issue, but while reviewing new users in Washington State, user MIJoeB is shown to have 3 changesets by OSMCha, but only shows 2 when asked to show all of their changesets.
Pulling from OSM data I see:
changesets=# select id,user_id,user_name,tags->'comment' from osm_changeset where user_id = 21081684;
id | user_id | user_name | comment
-----------+----------+-----------+-----------------------
147833372 | 21081684 | MIJoeB | added proper driveway
147833588 | 21081684 | MIJoeB | updated address
147833600 | 21081684 | MIJoeB | updated address
The last changeset, 147833600, is missing from the list.
I backfilled the missing changesets. Let me know if you identify some others that are missing.
thank you very much. I´ll check out
148305067 is missing from OSMCha
148306393, 148305867, 148305542, 148305559 are all missing from the past day
148325316 and 148356889 are missing from the past day.