Unusual error SQLNonTransientException: Internal error.

[Vladimir Ralev]

I was scanning some older logs and found this exception in the google sql driver. It's the first time I have seen it, but it may be interesting to you:

Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/ef2fDS

        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)

        at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141) [hibernate-core-4.1.2.Final.jar:4.1.2.Final]

        at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:278) [hibernate-core-4.1.2.Final.jar:4.1.2.Final]

        at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297) [hibernate-core-4.1.2.Final.jar:4.1.2.Final]

        ... 84 more

Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/ef2fDS

        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:390)

        at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)

        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)

        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)

        ... 87 more

Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying to create a connection: null

        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:371)

        at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)

        at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)

        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)

        ... 90 more

Caused by: javax.resource.ResourceException: Could not create connection

        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)

        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)

        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761)

        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343)

        ... 93 more

Caused by: java.sql.SQLNonTransientException: Internal error.

        at com.google.cloud.sql.jdbc.internal.Exceptions.newSqlExceptionForApplicationError(Exceptions.java:185)

        at com.google.cloud.sql.jdbc.internal.Exceptions.newSqlException(Exceptions.java:211)

        at com.google.cloud.sql.jdbc.internal.SqlProtoClient.check(SqlProtoClient.java:158)

        at com.google.cloud.sql.jdbc.internal.SqlProtoClient.openConnection(SqlProtoClient.java:60)

        at com.google.cloud.sql.jdbc.Driver.connect(Driver.java:66)

        at com.google.cloud.sql.Driver.connectImpl(Driver.java:109)

        at com.google.cloud.sql.Driver.connect(Driver.java:98)

        at com.google.cloud.sql.Driver.connect(Driver.java:31)

        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)

        ... 96 more

[sara...@gmail.com]

are you solved this problem?

[David Newgas]

I don't know about the particular error mentioned there, but it looks like the user that generated that stack trace was using a very old, deprecated driver for connecting to Cloud SQL. We recommend using the standard, non-google driver if you are connecting from outside of google network, or the com.mysql.jdbc.GoogleDriver driver if you are connecting from App Engine. Specifically you should follow the appropriate connection instructions from the "connecting to instances" set of pages on our docs at https://cloud.google.com/sql/docs/.

David

--
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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ad2232ec-4501-4833-a730-43f7b4db18ba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.