-
Bug
-
Resolution: Fixed
-
High
-
5.3.1, 4.14.9
-
Severity 2 - Major
-
Accessing plugin settings on Oracle can fail with "Protocol violation" errors due to a bug in the 12.1.0.1 ojdbc7 driver.
An example, from a server running 4.14.5:
2017-08-28 23:58:47,870 WARN [ajp-nio-9001-exec-75] *15THKEJx1438x303659x4 1rfct7u 171.70.124.198 "GET /mvc/error500 HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper SQL Error: 17401, SQLState: 99999
2017-08-28 23:58:47,870 ERROR [ajp-nio-9001-exec-75] *15THKEJx1438x303659x4 1rfct7u 171.70.124.198 "GET /mvc/error500 HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper Protocol violation: [ 114, ]
2017-08-28 23:58:47,871 ERROR [ajp-nio-9001-exec-75] *15THKEJx1438x303659x4 1rfct7u 171.70.124.198 "GET /mvc/error500 HTTP/1.1" o.s.t.support.TransactionTemplate Application exception overridden by rollback exception
org.hibernate.exception.GenericJDBCException: could not extract ResultSet
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
at org.hibernate.persister.entity.AbstractEntityPersister.loadEntityIdByNaturalId(AbstractEntityPersister.java:5046)
at org.hibernate.event.internal.DefaultResolveNaturalIdEventListener.loadFromDatasource(DefaultResolveNaturalIdEventListener.java:124)
at org.hibernate.event.internal.DefaultResolveNaturalIdEventListener.resolveNaturalId(DefaultResolveNaturalIdEventListener.java:91)
at org.hibernate.event.internal.DefaultResolveNaturalIdEventListener.onResolveNaturalId(DefaultResolveNaturalIdEventListener.java:57)
at org.hibernate.internal.SessionImpl.fireResolveNaturalId(SessionImpl.java:1115)
at org.hibernate.internal.SessionImpl.access$2100(SessionImpl.java:176)
at org.hibernate.internal.SessionImpl$BaseNaturalIdLoadAccessImpl.resolveNaturalId(SessionImpl.java:2645)
at org.hibernate.internal.SessionImpl$NaturalIdLoadAccessImpl.load(SessionImpl.java:2758)
at com.atlassian.stash.internal.plugin.HibernatePluginSettingDao.getByKey(HibernatePluginSettingDao.java:103)
at com.atlassian.stash.internal.plugin.HibernatePluginSettingDao.get(HibernatePluginSettingDao.java:80)
at com.atlassian.stash.internal.plugin.DefaultPluginSettings.lambda$getActual$0(DefaultPluginSettings.java:41)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
at com.atlassian.stash.internal.plugin.DefaultPluginSettings.getActual(DefaultPluginSettings.java:41)
at com.atlassian.sal.core.pluginsettings.AbstractStringPluginSettings.get(AbstractStringPluginSettings.java:115)
... some frames trimmed
Caused by: java.sql.SQLException: Protocol violation: [ 114, ]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:669)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
... 137 common frames omitted
(The number shown in brackets after "Protocol violation" is not constant.)
Workaround
No workaround is available. In case you are facing this issue, please upgrade to one of the versions containing the fix.