CONCURRENT_MODIFICATION while Insert operation

[Nadavi Play]

Good day,

I have problem with Ads API on mutate operations. When i'm trying to create AdGroupAd i receive errors "CONCURRENT_MODIFICATION". How it's possible that on insert operation can be the same concurency?

It's log from mutate operation:

INSERT AD GROUP AD: {"errorCode":{"databaseError":"CONCURRENT_MODIFICATION"},"message":"Multiple requests were attempting to modify the same resource at once. Retry the request.","location":{"fieldPathElements":[{"fieldName":"operations","index":0}]}}

INSERT AD GROUP AD: {"errorCode":{"databaseError":"CONCURRENT_MODIFICATION"},"message":"Multiple requests were attempting to modify the same resource at once. Retry the request.","location":{"fieldPathElements":[{"fieldName":"operations","index":1}]}}

INSERT AD GROUP AD: {"errorCode":{"databaseError":"CONCURRENT_MODIFICATION"},"message":"Multiple requests were attempting to modify the same resource at once. Retry the request.","location":{"fieldPathElements":[{"fieldName":"operations","index":2}]}}

INSERT AD GROUP AD: {"errorCode":{"databaseError":"CONCURRENT_MODIFICATION"},"message":"Multiple requests were attempting to modify the same resource at once. Retry the request.","location":{"fieldPathElements":[{"fieldName":"operations","index":3}]}}

INSERT AD GROUP AD: {"errorCode":{"databaseError":"CONCURRENT_MODIFICATION"},"message":"Multiple requests were attempting to modify the same resource at once. Retry the request.","location":{"fieldPathElements":[{"fieldName":"operations","index":4}]}}

INSERT AD GROUP AD: {"errorCode":{"databaseError":"CONCURRENT_MODIFICATION"},"message":"Multiple requests were attempting to modify the same resource at once. Retry the request.","location":{"fieldPathElements":[{"fieldName":"operations","index":5}]}}

Same errors i recieve on inserting of Keywords Criterias:

INSERT AD GROUP CRITERIA: {"errorCode":{"databaseError":"CONCURRENT_MODIFICATION"},"message":"Multiple requests were attempting to modify the same resource at once. Retry the request.","location":{"fieldPathElements":[{"fieldName":"operations","index":957}]}}

INSERT AD GROUP CRITERIA: {"errorCode":{"databaseError":"CONCURRENT_MODIFICATION"},"message":"Multiple requests were attempting to modify the same resource at once. Retry the request.","location":{"fieldPathElements":[{"fieldName":"operations","index":958}]}}

INSERT AD GROUP CRITERIA: {"errorCode":{"databaseError":"CONCURRENT_MODIFICATION"},"message":"Multiple requests were attempting to modify the same resource at once. Retry the request.","location":{"fieldPathElements":[{"fieldName":"operations","index":959}]}}

Just for clarify, update request have the same errors but it's not so strange as Insert operations.

[Nadavi Play]

https://groups.google.com/u/2/g/adwords-api/c/-W80dhBdHzc/m/LUqzA5xTBAAJ - In this topic seems the same problem but any answer from Google Support Team

четверг, 14 сентября 2023 г. в 14:28:01 UTC+2, Nadavi Play:

[Google Ads API Forum Advisor]

Hi,

Thank you for contacting the Google Ads API support team.

I understand that you have encountered a CONCURRENT_MODIFICATION error on your end while sending mutate requests to create AdGroupAd. In general, the CONCURRENT_MODIFICATION error occurs due to multiple processes that are trying to update the same entity at the same time. This also includes updating the entity in Google Ads UI while updating via the API as well. We recommend waiting for about 30 seconds, then retry the request.

That being said, you’ll need to ensure that only one operation is performed against an entity at each moment and slow down on the consolidated repeated mutates against the same entity into a single request to avoid this issue altogether. Please give this a try and let us know if you have any additional concerns.
 

This message is in relation to case "ref:_00D1U1174p._5004Q2olHLb:ref"

Thanks,
 

Google Ads API Team

[Nadavi Play]

The problem is in INSERT operations, it's physically impossible to make concurrency on insert operation but i still recieve this errors.

пятница, 15 сентября 2023 г. в 11:41:15 UTC+2, Google Ads API Forum Advisor:

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

To investigate further, could you please provide us with the complete API logs (request and response with request-id and request header) generated at your end.

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that  you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.
 
You can send them via Reply privately to the author option or Direct reply to this email.