Monday, March 26, 2018

[google-cloud-sql-discuss] Re: PostgreSQL instance stalled at 99GB while importing and now stuck on restart

I understand instance is available now as system restart finally finished. You may perform CPU upgrade as recommended in my previous post. 

On Sunday, March 25, 2018 at 7:09:01 PM UTC-4, Dinesh (Google Platform Support) wrote:
Hi Stephane,

I observed your instance CPU utilization is hitting around 99.7%. This looks like the main cause of the problem. 

Going forward, I will raise a request with back-end team to unstuck your PostgreSQL instance from the backend and will provide you an update. To resolve the issue, you must increase the number of CPU or upgrade instance machine type. 

You may want to go through Best Practices for data import on Cloud SQL 

Regards,

On Sunday, March 25, 2018 at 12:12:40 PM UTC-4, Stéphane Colzy wrote:
Hi,

I tried to import a 115GB database sql dump into this instance and all went well until it got stuck at 99GB storage usage.
Then I tried to restart it and now it's stuck.

However, this brand new instance had 300GB of storage allocated.

can someone help ?
thx
Stephane

--
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/2d0f0da6-083e-4605-b93c-ec7f958f347e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment