PostgreSQL instance stalled at 99GB while importing and now stuck on restart

[Stéphane Colzy]

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

[Dinesh (Google Platform Support)]

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,

[Dinesh (Google Platform Support)]

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

[Stéphane Colzy]

Ok, I'll try to increase the number of CPUs next time.

Anyway, I don't know how it happened but the import finally succeeded 12 hours later !

If you look at read/write operations nothing happens during around 10 hours and suddenly whoops it peaked at 2200 writes/s/s...

Thank you Dinesh.