On a Postgres instance I set max_connections to 262142 (one below the max) and now the instance is stuck in an error loop! I can't stop it, reset it, or edit it!!! This is crazy! It appears the UI/system is generating invalid config files and I can't edit the instance b/c an update is in process, now the update has timed out with "unknown error" and only the DELETE button works and gcloud says an operation is in progress.
-- HELP! How do we unset this flag to get the instance back to life?
I 2019-07-29T01:21:07.055077Z [1]: [2-1] db=,user= FATAL: configuration file "/pgsql/data/postgresql.conf" contains errors
I 2019-07-29T01:21:10.824534Z [1]: [1-1] db=,user= LOG: invalid value for parameter "max_connections": 262142 undefined
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/093597e3-fdb7-4854-af4b-290fec8352fc%40googlegroups.com.
No comments:
Post a Comment