Re: DatabaseError.CONCURRENT_MODIFICATION error

2020-02-19 Thread Google Ads API Forum Advisor Prod
Hello Qian, As a suggestion to avoid such errors in a multi threaded environment, I would like to share some best practices from this handy guide. One recommendation in that guide includes : "When you retry requests, use an exponential backoff policy. For example, if you first pause 5 seconds

Re: DatabaseError.CONCURRENT_MODIFICATION error

2020-02-18 Thread Qian Huang
Hi Nikisha, For one user list, we will add millions of users, so currently we chunk them into several requests, each request will contain 1000 user mutation, then we send these requests concurrently. If the concurrent modification error is happend on user list level, it means we can't send

Re: DatabaseError.CONCURRENT_MODIFICATION error

2020-02-18 Thread Google Ads API Forum Advisor Prod
Hello Qian, The entity in this scenario will refer to the user list that you are trying to update via API for mutating members of the user list. The concurrent modification error indicates that two or more processes are trying to update the same user list at same instance of time. It might

Re: DatabaseError.CONCURRENT_MODIFICATION error

2020-02-16 Thread Qian Huang
Hi Nikisha, I checked change history, looks like only one script is sending request. However, the history are quite general, it only says: "Remarketing list changed", "Members are uploaded to add to this list". Could you tell more details about that for this mutate member api, what's the

RE: DatabaseError.CONCURRENT_MODIFICATION error

2020-02-14 Thread Google Ads API Forum Advisor Prod
Hello Qian, Thank you for reaching out. The CONCURRENT_MODIFICATION error is observed when multiple processes are trying to make changes to a single entity at once. Could you please check the Change History in the Google Ads interface to verify if there were no other changes being made to the

DatabaseError.CONCURRENT_MODIFICATION error

2020-02-13 Thread Qian Huang
Hi, when I send mutateMembers requests, there are a lots DatabaseError.CONCURRENT_MODIFICATION error: soap:Client [DatabaseError.CONCURRENT_MODIFICATION @ com.google.ads.api.services.campaignmgmt.common.error.DatabaseError.init(Datab