应用程序引擎的Spring Boot实例不断重新连接到postgres google sql

Question

我在google app引擎上运行Spring boot应用程序，有一天应用程序崩溃了，导致应用程序重启。查看日志，我注意到应用程序不断地连接到我的google sql postgres数据库。

查看数据库的日志，我可以看到我在数据库上有60个连接。我使用cloud-sql- JDBC -socket-factory simple使用JDBC url：dbc:postgresql://google/{databaseName}?useSSL=false&cloudSqlInstance={instanceUrl}&socketFactory=com.google.cloud.sql.postgres.SocketFactory&user={user}&password={password}连接到数据库

显示的日志包括：

A  2019-04-11 14:57:01.674  INFO 1 --- [onnection adder] c.g.cloud.sql.core.SslSocketFactory      : Connecting to Cloud SQL instance [{instance url}] on IP [{ip adress}].

A  2019-04-11 14:58:11.458  INFO 1 --- [onnection adder] c.g.cloud.sql.postgres.SocketFactory     : Connecting to Cloud SQL instance [{instance url}] via ssl socket.

A  2019-04-11 14:58:11.460  INFO 1 --- [onnection adder] c.g.cloud.sql.core.SslSocketFactory      : Connecting to Cloud SQL instance [{instance url}] on IP [{ip adress}].

A  2019-04-11 14:58:22.878  INFO 1 --- [onnection adder] c.g.cloud.sql.postgres.SocketFactory     : Connecting to Cloud SQL instance [{instance url}] via ssl socket.

A  2019-04-11 14:58:22.880  INFO 1 --- [onnection adder] c.g.cloud.sql.core.SslSocketFactory      : Connecting to Cloud SQL instance [{instance url}] on IP [{ip adress}].

A  2019-04-11 15:01:56.477  INFO 1 --- [onnection adder] c.g.cloud.sql.postgres.SocketFactory     : Connecting to Cloud SQL instance  [{instance url}] via ssl socket.

A  2019-04-11 15:01:56.479  INFO 1 --- [onnection adder] c.g.cloud.sql.core.SslSocketFactory      : Connecting to Cloud SQL instance  [{instance url}] on IP [{ip adress}].

A  2019-04-11 15:02:08.108  INFO 1 --- [onnection adder] c.g.cloud.sql.postgres.SocketFactory     : Connecting to Cloud SQL instance [{instance url}] via ssl socket.

Answer 1

建议项目在应用程序引擎中，至少有2 gb的内存，为了避免连接错误，你可以在url：https://cloud.google.com/sql/docs/postgres/connect-external-app中查看任何代码问题。