We started a database export using the REST API as documented here:
-- https://cloud.google.com/sql/docs/postgres/admin-api/v1beta4/instances/export
The export was still running after 3 hours, btw exporting the same database using the webui takes less than 1 minute
During the export we could see that the total connectionsin use increased linearly over time, maxing out at 200 connection limit of the instance
While this was going on the log was flooded with the following error messages:
"remaining connection slots are reserved for non-replication superuser connections"
In the end we're forced to restart the database instance which took more than an hour!
When the database was up again the operations pamel showed that the export operation was stopped with an "unknown error"
Is this a knwo issue?
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/ec78ba6f-2b51-4694-8543-c4db7b3c16a5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment