-
Hi
has anyone faced this error (08177) before? I think it's an application coding problem but not sure
I have never faced this problem so dunno what can this be?
Can anyone have a look at these errors?
TxCoordinator LOG: Transaction rolled back due to beforeCompletion exception
java.sql.SQLException: ORA-08177: can't serialize access for this transaction
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.(Compiled Code)
at java.lang.Exception.(Compiled Code)
at java.sql.SQLException.(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(Compiled Code)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecute(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Compiled Code)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Compiled Code)
at weblogic.jdbcbase.jts.Statement.executeUpdate(Compiled Code)
at accenture.ejb.entity.language.LanguagePSJDBC.update(Compiled Code)
at accenture.ejb.entity.language.LanguagePSJDBC.store(Compiled Code)
at weblogic.ejb.internal.EntityEJBContext.store(Compiled Code)
at weblogic.ejb.internal.EntityEJBContext.beforeCompletion(Compiled Code)
at weblogic.jts.internal.CoordinatorImpl.notifyBefore(Compiled Code)
at weblogic.jts.internal.CoordinatorImpl.prepare(Compiled Code)
at weblogic.jts.internal.CoordinatorImpl.commit(Compiled Code)
at weblogic.jts.internal.TxContext.commit(Compiled Code)
at weblogic.ejb.internal.StatefulEJBObject.postInvokeOurTx(Compiled Code)
at weblogic.ejb.internal.BaseEJBObject.postInvoke(Compiled Code)
at accenture.ejb.entity.language.LanguageBeanEOImpl.getToken(Compiled Code)
at jspwdir._jsp._acc._menuizdo_95_I._jspService(Compiled Code)
at weblogic.servlet.jsp.JspBase.service(Compiled Code)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Compiled Code)
at weblogic.servlet.internal.ServletContextImpl.invokeServlet(Compiled Code)
at weblogic.servlet.JSPServlet.service(Compiled Code)
at javax.servlet.http.HttpServlet.service(Compiled Code)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Compiled Code)
at weblogic.servlet.internal.ServletContextImpl.invokeServlet(Compiled Code)
at weblogic.servlet.internal.ServletContextImpl.invokeServlet(Compiled Code)
at weblogic.socket.MuxableSocketHTTP.invokeServlet(Compiled Code)
at weblogic.socket.MuxableSocketHTTP.execute(Compiled Code)
at weblogic.t3.srvr.ExecuteThread.run(Compiled Code)
-
08177, 00000, "can't serialize access for this transaction"
// *Cause: Encountered data changed by an operation that occurred after
// the start of this serializable transaction.
// *Action: In read/write transactions, retry the intended operation or
// transaction.
Sam
-
th error I posted is just a little part of the log, the whole log is full of this error so I guess the transaction has been retried for several times!
BTW the version is 8.1.6
-
Yes that is possible.
Sam
-
yea so retrying doesnt solve the problem it seems....
-
at java.sql.SQLException.(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(Compiled Code)
Since I don't deal v.much with the web, I don't have much idea for the cause of the problem. But, did you get to find the cause od the abouve three errors. It might help you to better target the issue. In the mean time did you get to post the problem in the dev. forum. Since those folks get to work on the dev, they may be able to guide you better in trouble shooting this issue.
I'm very http://www.plauder-smilies.de/sad/azcrying.gif for not being able to help.
Sam
