How to check Bigquery update data job?

538 views
Skip to first unread message

Wong See Ling

unread,
Jan 22, 2022, 2:34:41 PM1/22/22
to Google Cloud Developers
I got receive error 
google.api_core.exceptions.BadRequest: 400 Could not serialize access to table due to concurrent update

Is it anyway to check who is doing the update on that table?
Cause I check on the log explorer, it only have the insert job process.

Any advice for the Bigquery update job?

moes

unread,
Jan 24, 2022, 6:11:38 PM1/24/22
to Google Cloud Developers
Hi,

You are seeing that error due to concurrent updates. This issue generally occurs when there are multiple concurrent updates against a table, mutating DML queries (UPDATE, MERGE, DELETE) are running concurrently and therefore possibly conflicting with each other.

Note that Google Groups is reserved for general product discussions.  If you require further technical support it is recommended to post your detailed questions[1] on Stack Exchange using the supported tags[2].

[1] https://stackoverflow.com/help/how-to-ask

[2] https://cloud.google.com/support/docs/stackexchange



Reply all
Reply to author
Forward
0 new messages