On 11-01-13 11:32 AM, Angelo K. Huang wrote:
I couldn't find any ORA error in our server log or application log when this
error happens.
For Trenton,
Did you see any ORA error in your cases?
No; that's partly what leads me to believe it's some sort of
communication error, with maybe the network, or dropped connections,
etc. Also the phrase "protocol error" gives a bit of hint too.
This is whole stack trace.
Caused by:<openjpa-1.2.1-r752877:753278 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Protocol violation
{prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status,
t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path,
t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time,
t0.created_time, t0.time_unit, t0.time_zone, t0.time_out FROM COORD_JOBS t0
WHERE t0.bean_type = ? ORDER BY t0.created_time DESC) WHERE ROWNUM<= ?
[params=(String) CoordinatorJobBean, (long) 50]} [code=17401, state=99999]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
at
org.apache.openjpa.lib.rop.WindowResultList.<init>(WindowResultList.java:64)
at
org.apache.openjpa.jdbc.kernel.JDBCFetchConfigurationImpl.newResultList(JDBCFetchConfigurationImpl.java:234)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:805)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:775)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:771)
at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:517)
at
org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:255)
at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:294)
at
org.apache.oozie.store.CoordinatorStore$15.call(CoordinatorStore.java:609)
at
org.apache.oozie.store.CoordinatorStore$15.call(CoordinatorStore.java:567)
at
org.apache.oozie.store.CoordinatorStore.doOperation(CoordinatorStore.java:425)
... 40 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Protocol
violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name,
t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time,
t0.app_path, t0.concurrency, t0.frequency, t0.last_action,
t0.next_matd_time, t0.created_time, t0.time_unit, t0.time_zone, t0.time_out
FROM COORD_JOBS t0 WHERE t0.bean_type = ? ORDER BY t0.created_time DESC)
WHERE ROWNUM<= ? [params=(String) CoordinatorJobBean, (long) 50]}
[code=17401, state=99999]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:852)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1595)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)
at
org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:496)
at
org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384)
at
org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:325)
at
org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:331)
at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
at
org.apache.openjpa.lib.rop.WindowResultList.<init>(WindowResultList.java:57)
... 52 more
