You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
No exception thrown up with following code using python google-cloud-spanner==3.19.0 running on GCE instance, the script just hangs after 30 minutes and the deletion stopped after 30 minutes
Is there an update on this. I am trying to delete 200m rows and seems to get different results.
some times it succeeds.
more than often it fails with timeout or deadline exceeded error.
I face the similar issue when I run a plain SQL from terminal
gcloud spanner databases execute-sql XXXX
--instance=my-dev-instance
--sql="delete * from mytable where id ='1234';"
This involves deleting 300million rows.
I tried running this on nohup as well.
No error, but I don't see the delete happening after some 30 minutes.
When are we expecting a fix for this
There is an internal bug opened for this and potentially a fix in https://github.com/asthamohta/python-spanner/tree/retry-error. But it is not confirmed yet, so want to open this in github issue to track it and just in case it is not recorded.
No exception thrown up with following code using python google-cloud-spanner==3.19.0 running on GCE instance, the script just hangs after 30 minutes and the deletion stopped after 30 minutes
The text was updated successfully, but these errors were encountered: