Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql.mariadb.JdbcMariaDBIamAuthIntegrationTests: pooledConnectionTest failed #1381

Closed
flaky-bot bot opened this issue Jul 10, 2023 · 2 comments
Closed
Assignees
Labels
flakybot: flaky Tells the Flaky Bot not to close or comment on this issue. flakybot: issue An issue filed by the Flaky Bot. Should not be added manually. priority: p2 Moderately-important priority. Fix may not be included in next release. type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns.

Comments

@flaky-bot
Copy link

flaky-bot bot commented Jul 10, 2023

Note: #1288 was also for this test, but it was closed more than 10 days ago. So, I didn't mark it flaky.


commit: 4106f93
buildURL: https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory/actions/runs/5511159748
status: failed

Test output
com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Socket fail to connect to host:address=(host=ignoreme)(port=123)(type=primary). Socket factory failed to initialized with option "socketFactory" set to "com.google.cloud.sql.mariadb.SocketFactory"
	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:582)
	at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115)
	at com.zaxxer.hikari.HikariDataSource.(HikariDataSource.java:81)
	at com.google.cloud.sql.mariadb.JdbcMariaDBIamAuthIntegrationTests.setUpPool(JdbcMariaDBIamAuthIntegrationTests.java:82)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
	at org.junit.internal.runners.statements.RunBefores.invokeMethod(RunBefores.java:33)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
	at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299)
	at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.lang.Thread.run(Thread.java:750)
Caused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:address=(host=ignoreme)(port=123)(type=primary). Socket factory failed to initialized with option "socketFactory" set to "com.google.cloud.sql.mariadb.SocketFactory"
	at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:137)
	at org.mariadb.jdbc.client.impl.StandardClient.(StandardClient.java:99)
	at org.mariadb.jdbc.Driver.connect(Driver.java:70)
	at org.mariadb.jdbc.Driver.connect(Driver.java:101)
	at org.mariadb.jdbc.Driver.connect(Driver.java:27)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
	... 16 more
Caused by: java.io.IOException: Socket factory failed to initialized with option "socketFactory" set to "com.google.cloud.sql.mariadb.SocketFactory"
	at org.mariadb.jdbc.client.impl.ConnectionHelper.standardSocket(ConnectionHelper.java:100)
	at org.mariadb.jdbc.client.socket.impl.SocketUtility.lambda$getSocketHandler$0(SocketUtility.java:38)
	at org.mariadb.jdbc.client.impl.ConnectionHelper.createSocket(ConnectionHelper.java:69)
	at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:124)
	... 25 more
Caused by: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: [cloud-sql-connector-testing:us-east5:mysql-iam-java-test] Failed to create ephemeral certificate for the Cloud SQL instance.
	at com.google.cloud.sql.core.CloudSqlInstance.getInstanceData(CloudSqlInstance.java:119)
	at com.google.cloud.sql.core.CloudSqlInstance.createSslSocket(CloudSqlInstance.java:128)
	at com.google.cloud.sql.core.CoreSocketFactory.createSslSocket(CoreSocketFactory.java:317)
	at com.google.cloud.sql.core.CoreSocketFactory.connect(CoreSocketFactory.java:195)
	at com.google.cloud.sql.core.CoreSocketFactory.connect(CoreSocketFactory.java:153)
	at com.google.cloud.sql.mariadb.SocketFactory.createSocket(SocketFactory.java:51)
	at org.mariadb.jdbc.client.impl.ConnectionHelper.standardSocket(ConnectionHelper.java:96)
	... 28 more
Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: [cloud-sql-connector-testing:us-east5:mysql-iam-java-test] Failed to create ephemeral certificate for the Cloud SQL instance.
	at com.google.common.util.concurrent.AbstractFuture.getDoneValue(AbstractFuture.java:588)
	at com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:567)
	at com.google.common.util.concurrent.AbstractFuture$TrustedFuture.get(AbstractFuture.java:113)
	at com.google.cloud.sql.core.SqlAdminApiFetcher.getInstanceData(SqlAdminApiFetcher.java:162)
	at com.google.cloud.sql.core.CloudSqlInstance.performRefresh(CloudSqlInstance.java:192)
	at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)
	at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:74)
	at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	... 1 more
Caused by: java.lang.RuntimeException: [cloud-sql-connector-testing:us-east5:mysql-iam-java-test] Failed to create ephemeral certificate for the Cloud SQL instance.
	at com.google.cloud.sql.core.SqlAdminApiFetcher.addExceptionContext(SqlAdminApiFetcher.java:388)
	at com.google.cloud.sql.core.SqlAdminApiFetcher.fetchEphemeralCertificate(SqlAdminApiFetcher.java:263)
	at com.google.cloud.sql.core.SqlAdminApiFetcher.lambda$getInstanceData$2(SqlAdminApiFetcher.java:118)
	at com.google.common.util.concurrent.CombinedFuture$CallableInterruptibleTask.runInterruptibly(CombinedFuture.java:196)
	at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:74)
	... 7 more
Caused by: com.google.api.client.googleapis.json.GoogleJsonResponseException: 429 Too Many Requests
POST https://sqladmin.googleapis.com/sql/v1beta4/projects/cloud-sql-connector-testing/instances/mysql-iam-java-test:generateEphemeralCert
{
  "code": 429,
  "details": [
    {
      "@type": "type.googleapis.com/google.rpc.ErrorInfo",
      "reason": "RATE_LIMIT_EXCEEDED"
    },
    {
      "@type": "type.googleapis.com/google.rpc.Help"
    }
  ],
  "errors": [
    {
      "domain": "global",
      "message": "Quota exceeded for quota metric 'Queries' and limit 'Queries per minute per user' of service 'sqladmin.googleapis.com' for consumer 'project_number:151338197897'.",
      "reason": "rateLimitExceeded"
    }
  ],
  "message": "Quota exceeded for quota metric 'Queries' and limit 'Queries per minute per user' of service 'sqladmin.googleapis.com' for consumer 'project_number:151338197897'.",
  "status": "RESOURCE_EXHAUSTED"
}
	at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:146)
	at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:118)
	at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:37)
	at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:439)
	at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1111)
	at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:525)
	at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:466)
	at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:576)
	at com.google.cloud.sql.core.SqlAdminApiFetcher.fetchEphemeralCertificate(SqlAdminApiFetcher.java:261)
	... 10 more
@flaky-bot flaky-bot bot added flakybot: issue An issue filed by the Flaky Bot. Should not be added manually. priority: p2 Moderately-important priority. Fix may not be included in next release. type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns. labels Jul 10, 2023
@flaky-bot
Copy link
Author

flaky-bot bot commented Jul 10, 2023

@flaky-bot flaky-bot bot closed this as completed Jul 10, 2023
@flaky-bot flaky-bot bot reopened this Jul 10, 2023
@flaky-bot flaky-bot bot added the flakybot: flaky Tells the Flaky Bot not to close or comment on this issue. label Jul 10, 2023
@flaky-bot
Copy link
Author

flaky-bot bot commented Jul 10, 2023

Looks like this issue is flaky. 😟

I'm going to leave this open and stop commenting.

A human should fix and close this.


commit: 73dc391
buildURL: https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory/actions/runs/5513874352
status: failed

Test output
org.junit.runners.model.TestTimedOutException: test timed out after 60 seconds
	at [email protected]/jdk.internal.misc.Unsafe.park(Native Method)
	at [email protected]/java.util.concurrent.locks.LockSupport.park(LockSupport.java:211)
	at app//com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:557)
	at app//com.google.common.util.concurrent.FluentFuture$TrustedFuture.get(FluentFuture.java:89)
	at app//com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:204)
	at app//com.google.cloud.sql.core.CloudSqlInstance.getInstanceData(CloudSqlInstance.java:115)
	at app//com.google.cloud.sql.core.CloudSqlInstance.createSslSocket(CloudSqlInstance.java:128)
	at app//com.google.cloud.sql.core.CoreSocketFactory.createSslSocket(CoreSocketFactory.java:317)
	at app//com.google.cloud.sql.core.CoreSocketFactory.connect(CoreSocketFactory.java:195)
	at app//com.google.cloud.sql.core.CoreSocketFactory.connect(CoreSocketFactory.java:153)
	at app//com.google.cloud.sql.mariadb.SocketFactory.createSocket(SocketFactory.java:51)
	at app//org.mariadb.jdbc.client.impl.ConnectionHelper.standardSocket(ConnectionHelper.java:96)
	at app//org.mariadb.jdbc.client.socket.impl.SocketUtility.lambda$getSocketHandler$0(SocketUtility.java:38)
	at app//org.mariadb.jdbc.client.socket.impl.SocketUtility$$Lambda$104/0x00000008010a5218.apply(Unknown Source)
	at app//org.mariadb.jdbc.client.impl.ConnectionHelper.createSocket(ConnectionHelper.java:69)
	at app//org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:124)
	at app//org.mariadb.jdbc.client.impl.StandardClient.(StandardClient.java:99)
	at app//org.mariadb.jdbc.Driver$$Lambda$103/0x000000080109b8e0.apply(Unknown Source)
	at app//org.mariadb.jdbc.Driver.connect(Driver.java:70)
	at app//org.mariadb.jdbc.Driver.connect(Driver.java:101)
	at app//org.mariadb.jdbc.Driver.connect(Driver.java:27)
	at app//com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121)
	at app//com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
	at app//com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
	at app//com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
	at app//com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
	at app//com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115)
	at app//com.zaxxer.hikari.HikariDataSource.(HikariDataSource.java:81)
	at app//com.google.cloud.sql.mariadb.JdbcMariaDBIamAuthIntegrationTests.setUpPool(JdbcMariaDBIamAuthIntegrationTests.java:82)
	at [email protected]/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at [email protected]/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:568)
	at app//org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
	at app//org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at app//org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
	at app//org.junit.internal.runners.statements.RunBefores.invokeMethod(RunBefores.java:33)
	at app//org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
	at app//org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299)
	at app//org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293)
	at [email protected]/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at [email protected]/java.lang.Thread.run(Thread.java:833)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
flakybot: flaky Tells the Flaky Bot not to close or comment on this issue. flakybot: issue An issue filed by the Flaky Bot. Should not be added manually. priority: p2 Moderately-important priority. Fix may not be included in next release. type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns.
Projects
None yet
Development

No branches or pull requests

2 participants