Unable to upload to Wikidata from OpenRefine

Hi, I tried twice this morning to upload a batch of data from OpenRefine to Wikidata. No error message appeared in OpenRefine, but I noticed the items in the preview pane weren't showing the newly created Qids. The items haven't uploaded to Wikidata, and there's no evidence of upload in https://editgroups.toolforge.org/ either.
I closed OpenRefine, waited a few hours and tried again but am still getting the same errors in my log, which I've pasted below.
Do you know what the issue might be?
Thanks
Helen

15:22:00.283 [ refine_server] Starting Server bound to '127.0.0.1:3333' (0ms)
15:22:00.336 [ refine_server] Initializing context: '/' from 'C:\Users\WILLIAHK\openrefine-3.7.5\webapp' (53ms)
15:22:02.255 [ refine] Starting OpenRefine 3.7.5 [a04fb5f]... (1919ms)
15:22:02.255 [ refine] initializing FileProjectManager with dir (0ms)
15:22:02.256 [ refine] C:\Users\WILLIAHK\AppData\Roaming\OpenRefine (1ms)
15:22:12.664 [ refine] POST /command/core/load-language (10408ms)
15:22:12.783 [ refine] GET /command/core/get-preference (119ms)
15:22:12.825 [ refine] POST /command/core/load-language (42ms)
15:22:12.863 [ refine] POST /command/core/load-language (38ms)
15:22:12.890 [ refine] POST /command/core/load-language (27ms)
15:22:13.037 [ refine] GET /command/core/get-importing-configuration (147ms)
15:22:13.070 [ refine] GET /command/core/get-all-project-tags (33ms)
15:22:13.087 [ refine] GET /command/core/get-all-project-metadata (17ms)
15:22:13.353 [ refine] GET /command/core/get-csrf-token (266ms)
15:22:13.387 [ refine] GET /command/core/get-languages (34ms)
15:22:13.531 [ refine] GET /command/core/get-version (144ms)
15:22:13.763 [ refine] GET /command/database/saved-connection (232ms)
15:22:56.510 [ refine] POST /command/core/load-language (42747ms)
15:22:56.531 [ refine] GET /command/core/get-preference (21ms)
15:22:56.532 [ refine] GET /command/core/get-preference (1ms)
15:22:56.550 [ refine] POST /command/core/load-language (18ms)
15:22:56.566 [ refine] POST /command/core/load-language (16ms)
15:22:56.596 [ refine] POST /command/core/load-language (30ms)
15:22:56.615 [ refine] POST /command/core/load-language (19ms)
15:22:56.644 [ refine] GET /command/core/get-project-metadata (29ms)
15:22:57.162 [ project] Loaded project 2501521841515 from disk in 0 sec(s) (518ms)
15:22:57.201 [ refine] GET /command/core/get-models (39ms)
15:22:57.281 [ refine] POST /command/core/get-all-preferences (80ms)
15:22:57.376 [ refine] GET /command/core/get-history (95ms)
15:22:57.405 [ refine] POST /command/core/get-rows (29ms)
15:22:57.494 [ refine] GET /command/core/get-history (89ms)
15:22:57.529 [ refine] GET /command/core/get-preference (35ms)
15:23:01.562 [ refine] GET /command/core/get-preference (4033ms)
15:23:01.749 [ refine] GET /command/core/get-csrf-token (187ms)
15:23:01.841 [ refine] POST /command/wikidata/preview-wikibase-schema (92ms)
15:23:26.572 [ refine] GET /command/core/get-csrf-token (24731ms)
15:23:26.602 [ refine] POST /command/wikidata/preview-wikibase-schema (30ms)
15:23:50.370 [ refine] GET /command/core/get-csrf-token (23768ms)
15:23:50.393 [ refine] POST /command/wikidata/save-wikibase-schema (23ms)
15:23:50.432 [ refine] GET /command/core/get-history (39ms)
15:23:50.450 [ refine] GET /command/core/get-preference (18ms)
15:24:04.543 [ refine] GET /command/wikidata/login (14093ms)
15:24:04.572 [ refine] GET /command/core/get-csrf-token (29ms)
15:24:04.605 [ refine] POST /command/wikidata/login (33ms)
15:24:05.002 [ refine] GET /command/core/get-csrf-token (397ms)
15:24:05.044 [ refine] POST /command/wikidata/preview-wikibase-schema (42ms)
15:24:16.214 [ refine] GET /command/core/get-csrf-token (11170ms)
15:24:16.240 [ refine] POST /command/wikidata/perform-wikibase-edits (26ms)
15:24:16.289 [..mWikibaseEditsOperation] Performing edits (49ms)
15:24:16.293 [..ting.EditBatchProcessor] Requesting documents (4ms)
15:24:17.134 [..ting.EditBatchProcessor] MediaWiki error while editing [failed-save]: The save has failed. (841ms)
15:24:17.623 [..ting.EditBatchProcessor] MediaWiki error while editing [failed-save]: The save has failed. (489ms)
15:24:18.089 [..ting.EditBatchProcessor] MediaWiki error while editing [failed-save]: The save has failed. (466ms)
15:24:18.518 [..ting.EditBatchProcessor] MediaWiki error while editing [failed-save]: The save has failed. (429ms)
15:24:19.022 [..ting.EditBatchProcessor] MediaWiki error while editing [failed-save]: The save has failed. (504ms)
15:24:19.576 [..ting.EditBatchProcessor] MediaWiki error while editing [failed-save]: The save has failed. (554ms)
15:24:20.041 [..ting.EditBatchProcessor] MediaWiki error while editing [failed-save]: The save has failed. (465ms)
15:24:20.557 [..ting.EditBatchProcessor] MediaWiki error while editing [failed-save]: The save has failed. (516ms)
15:24:21.104 [..ting.EditBatchProcessor] MediaWiki error while editing [failed-save]: The save has failed. (547ms)
15:24:21.106 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 4595 milliseconds. (2ms)
15:24:26.118 [..ting.EditBatchProcessor] MediaWiki error while editing [failed-save]: The save has failed. (5012ms)
15:24:26.120 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 18 milliseconds. (2ms)
15:24:26.379 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (259ms)
15:24:26.384 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 243 milliseconds. (5ms)
15:24:26.856 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (472ms)
15:24:26.856 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 226 milliseconds. (0ms)
15:24:27.415 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (559ms)
15:24:27.416 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 104 milliseconds. (1ms)
15:24:27.775 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (359ms)
15:24:27.793 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 232 milliseconds. (18ms)
15:24:28.313 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (520ms)
15:24:28.321 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 265 milliseconds. (8ms)
15:24:28.872 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (551ms)
15:24:28.872 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 179 milliseconds. (0ms)
15:24:29.300 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (428ms)
15:24:29.307 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 260 milliseconds. (7ms)
15:24:29.833 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (526ms)
15:24:29.835 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 4881 milliseconds. (2ms)
15:24:34.963 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (5128ms)
15:24:34.963 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 163 milliseconds. (0ms)
15:24:35.434 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (471ms)
15:24:35.434 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 187 milliseconds. (0ms)
15:24:35.908 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (474ms)
15:24:35.911 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 184 milliseconds. (3ms)
15:24:36.353 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (442ms)
15:24:36.353 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 156 milliseconds. (0ms)
15:24:36.790 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (437ms)
15:24:36.790 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 231 milliseconds. (0ms)
15:24:37.239 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (449ms)
15:24:37.239 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 335 milliseconds. (0ms)
15:24:37.844 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (605ms)
15:24:37.846 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 212 milliseconds. (2ms)
15:24:38.340 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (494ms)
15:24:38.342 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 229 milliseconds. (2ms)
15:24:38.855 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (513ms)
15:24:38.855 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 4856 milliseconds. (0ms)
15:24:43.953 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (5098ms)
15:24:43.953 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 180 milliseconds. (0ms)
15:24:44.407 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (454ms)
15:24:44.408 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 222 milliseconds. (1ms)
15:24:44.871 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (463ms)
15:24:44.875 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 221 milliseconds. (4ms)
15:24:45.359 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (484ms)
15:24:45.360 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 164 milliseconds. (1ms)
15:24:45.795 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (435ms)
15:24:45.798 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 233 milliseconds. (3ms)
15:24:46.306 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (508ms)
15:24:46.322 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 269 milliseconds. (16ms)
15:24:46.867 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (545ms)
15:24:46.868 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 192 milliseconds. (1ms)
15:24:47.329 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (461ms)
15:24:47.332 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 241 milliseconds. (3ms)
15:24:47.868 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (536ms)
15:24:47.868 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 4839 milliseconds. (0ms)
15:24:52.957 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (5089ms)
15:24:52.958 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 180 milliseconds. (1ms)
15:24:53.392 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (434ms)
15:24:53.395 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 237 milliseconds. (3ms)
15:24:53.887 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (492ms)
15:24:53.887 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 198 milliseconds. (0ms)
15:24:54.326 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (439ms)
15:24:54.327 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 202 milliseconds. (1ms)
15:24:54.770 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (443ms)
15:24:54.770 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 260 milliseconds. (0ms)
15:24:55.297 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (527ms)
15:24:55.300 [..baseapi.WbEditingAction] We are editing too fast. Pausing for 297 milliseconds. (3ms)
15:24:55.872 [..ting.EditBatchProcessor] MediaWiki error while editing [no-automatic-entity-id]: Cannot automatically assign ID: As an anti-abuse measure, you are limited from performing this action too many times in a short space of time, and you have exceeded this limit. Please try again in a few minutes. (572ms)
15:24:55.873 [..ting.EditBatchProcessor] Failed to rewrite update on entity http://www.wikidata.org/entity/Q26849495. Missing entity: new item (reconciled from -7490598213354342479). Skipping update. (1ms)
15:24:56.166 [ refine] GET /command/core/get-history (293ms)
15:24:56.186 [ refine] GET /command/core/get-project-metadata (20ms)
15:24:56.202 [ refine] GET /command/core/get-models (16ms)
15:24:56.220 [ refine] POST /command/core/get-all-preferences (18ms)
15:24:56.237 [ refine] POST /command/core/get-rows (17ms)
15:24:56.287 [ refine] POST /command/core/compute-facets (50ms)
15:24:56.303 [ refine] GET /command/core/get-preference (16ms)
15:27:03.571 [ ProjectManager] Saving some modified projects ... (127268ms)
15:27:03.613 [ project_utilities] Saved project '2501521841515' (42ms)

Hi all, I've tried another 2 times to upload this content to Wikidata but am still getting the same error messages as above. I found this OpenRefine doesn't properly handle MediaWiki rate limits · Issue #6018 · OpenRefine/OpenRefine · GitHub and have managed to find my own log page for this Abuse filter log - Wikidata which indicates I'm triggering filter 36 for non notable subpage I've not yet managed to work out what that means though. I'm loading issue metadata for a journal title, prior to adding article metadata for that journal, which will all link to the issue data. I've done this before for other journals, so not sure what's going wrong. This now perhaps needs Wikimedia expertise rather than OpenRefine expertise, but nevertheless, if anyone has any ideas I'd be very grateful!

Thanks
Helen

Happy to report this issue has been resolved! Linking to the related chat on Wikidata in case this helps someone else to resolve a similar situation in the future
https://www.wikidata.org/wiki/Wikidata:Project_chat#Help_to_resolve_triggering_an_abuse_filter_via_OpenRefine_upload

Amazing! This confirms that we need to be much better at reporting those problems to users, so that you could identify better that the edits were failing because of an abuse filter. I have been working on this recently, so I hope this makes it into a published version at some point!

1 Like

That would be amazing @antonin_d - it would be so helpful to be able to see what's causing an edit to fail. Thanks!