Z-Archive » Taylor

Andy reported:
The SQL error has nothing to do with the server crash.

This morning however, the student sync failed. With the sync process terminated prematurely, the server is now in a “hanging” state where after a user login the home page would take forever to load. I would have no choice but to restart the server now.

Don’t ask me for log, as the log file is over 600MB !! caused by millions of lines below:
org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=tucsvrbv001/5989858, BranchQual=, localId=5989858]; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=tucsvrbv001/5989858, BranchQual=, localId=5989858])

The root cause is this user id: 80092. I’m trying to see if the sync can run after I delete the user 80092

ERROR 2010/10/13 00:53:29:879 broadvision.visitor.server.ProfileDao.modifyList: generic profile exception failed to get data from table BV_EP_UPROF_BK
userId:80092

com.broadvision.visitor.exceptions.ProfileException: failed to append to list table BV_EP_UPROF_BK
userId:80092

com.broadvision.visitor.exceptions.DuplicateProfileDataException:
com.broadvision.data.exceptions.DuplicateDataException: SQL ErrorCode=1, State=23000, Message=ORA-00001: unique constraint (BVDBA.BV_EP_UPROF_BK_PK) violated

To be honest, at that time the error was logged 12:53am I do not know what caused this as the student sync was only scheduled to run daily at 4am