-
Bug
-
Resolution: Fixed
-
High
-
7.0.10, 7.1.8, 7.2.9, 7.3.7, 7.4.2
-
7
-
111
-
Severity 2 - Major
-
143
-
Summary
JIRA 7 is shipped with Oracle JDBC driver 12.1.0.1.0: ojdbc7-12.1.0.1.jar
Oracle Driver 12.1.0.1 throws error Protocol violation during connection to Database.
Environment
- JIRA 7.x
- Database Oracle 12c Enterprise Edition Release 12.1.0.1.0 or 12.1.0.2
Steps to Reproduce
- Setup JIRA and connect it to DB
- Add some data (we don't have this specific set of data)
- Run reindex
Expected Results
It works fine.
Actual Results
The below exception is thrown in the jira.log file:
2016-04-13 21:37:52,114 JiraTaskExectionThread-4 ERROR jiraadmins 1271x19429x1 1lemfi1 10.98.60.21 /secure/admin/IndexReIndex.jspa [c.a.j.util.index.CompositeIndexLifecycleManager] Reindex All FAILED. Indexer: DefaultIndexManager: paths: [/jiraindex/infra711/jiraindex/caches/indexes/comments, /jiraindex/infra711/jiraindex/caches/indexes/issues, /jiraindex/infra711/jiraindex/caches/indexes/changes, /jiraindex/infra711/jiraindex/caches/indexes/worklogs, /jiraindex/infra711/jiraindex/caches/indexes/plugins/atlassian-subversion-revisions]
org.ofbiz.core.util.GeneralRuntimeException: Error getting the next result (Protocol violation: [ 46, ])
at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:251)
at com.atlassian.jira.ofbiz.DefaultOfBizListIterator.next(DefaultOfBizListIterator.java:100)
at com.atlassian.jira.ofbiz.WrappingOfBizListIterator.next(WrappingOfBizListIterator.java:68)
at com.atlassian.jira.issue.util.DatabaseIssuesIterator.pullNextIssue(DatabaseIssuesIterator.java:97)
at com.atlassian.jira.issue.util.DatabaseIssuesIterator.populateNextIssueIfNull(DatabaseIssuesIterator.java:68)
at com.atlassian.jira.issue.util.DatabaseIssuesIterator.hasNext(DatabaseIssuesIterator.java:51)
at com.atlassian.jira.issue.util.DatabaseIssuesIterable.foreach(DatabaseIssuesIterable.java:55)
at com.atlassian.jira.issue.index.DefaultIssueIndexer.perform(DefaultIssueIndexer.java:282)
at com.atlassian.jira.issue.index.DefaultIssueIndexer.indexIssuesBatchMode(DefaultIssueIndexer.java:151)
at com.atlassian.jira.issue.index.DefaultIndexManager.doIndexIssuesInBatchMode(DefaultIndexManager.java:984)
at com.atlassian.jira.issue.index.DefaultIndexManager.doStopTheWorldReindex(DefaultIndexManager.java:961)
at com.atlassian.jira.issue.index.DefaultIndexManager.lambda$reIndexAll$0(DefaultIndexManager.java:326)
at com.atlassian.jira.issue.index.DefaultIndexManager.withReindexLock(DefaultIndexManager.java:359)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:326)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:258)
...
Caused by: java.sql.SQLException: Protocol violation: [ 46, ]
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.fetch(T4CPreparedStatement.java:1022)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:1008)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:972)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:572)
at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191)
at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191)
at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:245)
... 33 more
Notes
May be related to Oracle Clob bug. See:
- https://confluence.atlassian.com/confkb/java-sql-sqlexception-protocol-violation-caught-while-accessing-a-page-and-oracle-db-is-used-781393258.html
- https://confluence.atlassian.com/pages/viewpage.action?pageId=780863295
- http://stackoverflow.com/questions/22785120/oracle-clob-reader-issue-protocol-violation
- http://stackoverflow.com/questions/4685021/sqlexception-protocol-violation-oracle-jdbc-driver-issue/35343994#35343994
Conflicts with:
https://jira.atlassian.com/browse/JRA-60007
Workaround
- Update Oracle driver from 12.1.0.1 to 12.2.0.1 version.
- Download 12.2.0.1 from here Oracle JDBC 12.2.0.1 Driver.
- Stop JIRA
- Delete current driver ojdbc7-12.1.0.1.jar from <JIRA-INSTALL>/lib/ folder
- Upload new driver to <JIRA_INSTALL>/lib/ folder
- Start JIRA again
- Using 12.2.0.1 will allow you to work around
JRA-61007
- causes
-
-
- Closed
-
- is related to
-
-
- Closed
-
-
-
- Gathering Impact
-
-
SIN-355 Loading...
- mentioned in
-
-
-
-
-
-
-
-
-
-
-
- relates to
-