Uh, so the only way is still to log in and do the show processlist/kill combo. The sql connect command is failing because it needs to authorize a new IP, but it can't do this while the import is running.
Your instance already has 3 IPs authorized (which you can see in the authorizednetworks section of 'gcloud sql instances describe INSTANCE'). If you can connect from one of those IP addresses then you can kill from them. You can also do so from within your GAE app, but doing so is a bit harder.
On Fri, Mar 18, 2016 at 12:12 PM, <peter.shin@syw.com> wrote:
Using "gcloud beta sql connect [INSTANCE-ID]" results in "ERROR: (gcloud.beta.sql.connect) Operation failed because another operation was already in progress."--
The storage is indeed increasing, and "Read/Write InnoDB Pages" is sustained at around 89 pages/sec, lowering occasionally.
Is there a way to kill the current operation, as I don't want it to finish anymore?
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3eb2775f-99c7-45c0-ab03-7534735e4721%40googlegroups.com.
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bbUxAG2n3sUhx5LsuOCLkqa%3DY3kHTUwvhsqkKpYRNjEqA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment