Error after Oracle DB deadlock - ORA-00060 -- Urgent

Hi All,

Need a quick help…

A deadlock happened 2 days back… after DB fixed, and IS 7.1.3 was restarted got lotz of errors below

2012-11-21 15:50:33 AST [ISC.0050.0018E] Error decoding schema in FlowMap com.wm.util.coder.InvalidDatatypeException: com.wm.lang.xml.WMDocumentException: [I SC.0042.9327] Expecting </DOCUMENT> got
2012-11-21 15:50:33 AST [ISC.0050.0018E] Error decoding schema in FlowMap com.wm.util.coder.InvalidDatatypeException: com.wm.lang.xml.WMDocumentException: [I SC.0042.9327] Expecting </DOCUMENT> got
2012-11-21 15:50:33 AST [ISC.0049.0013I] Set: com.wm.util.coder.InvalidDatatypeException: [ISC.0076.9010] Sibling root element is null rootTag:Values localNa
me:null root:Text:

2012-11-21 15:50:33 AST [ISC.0049.0013I] Set: com.wm.util.coder.InvalidDatatypeException: [ISC.0076.9010] Sibling root element is null rootTag:Values localNa
me:null root:Text:

2012-11-21 15:50:33 AST [ISC.0049.0013I] Set: com.wm.util.coder.InvalidDatatypeException: [ISC.0076.9010] Sibling root element is null rootTag:Values localNa
me:null root:Text:

2012-11-21 15:50:33 AST [ISC.0050.0018E] Error decoding schema in FlowMap com.wm.util.coder.InvalidDatatypeException: com.wm.lang.xml.WMDocumentException: [I SC.0042.9327] Expecting </DOCUMENT> got

2012-11-21 15:55:05 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderSqlD] selecting locks older than (SELECT EXCL_LOCK_ID, TARGET_ID, LOCK_HOLDER,
LOCK_TYPE, LOCK_SHARE_COUNT, LOCK_TIMESTAMP FROM WM_EXCL_DIST_LOCK WHERE LOCK_TIMESTAMP<? AND LOCK_TYPE=‘E’) with this sql: 1353502325805
2012-11-21 15:55:05 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderCountD] Found 0 locks older than 1353502325805
2012-11-21 15:55:05 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderSqlD] selecting locks older than (SELECT WM_EXCL_DIST_LOCK.EXCL_LOCK_ID, WM_EX
CL_DIST_LOCK.TARGET_ID, WM_EXCL_DIST_LOCK.LOCK_HOLDER, WM_EXCL_DIST_LOCK.LOCK_TYPE, WM_EXCL_DIST_LOCK.LOCK_SHARE_COUNT, WM_EXCL_DIST_LOCK.LOCK_TIMESTAMP, WM_
SHAR_DIST_LOCK.SHAR_LOCK_ID, WM_SHAR_DIST_LOCK.LOCK_HOLDER, WM_SHAR_DIST_LOCK.EXCL_LOCK_ID, WM_SHAR_DIST_LOCK.LOCK_TIMESTAMP FROM WM_EXCL_DIST_LOCK, WM_SHAR_
DIST_LOCK WHERE WM_EXCL_DIST_LOCK.EXCL_LOCK_ID=WM_SHAR_DIST_LOCK.EXCL_LOCK_ID AND WM_EXCL_DIST_LOCK.LOCK_TYPE=‘S’ AND WM_SHAR_DIST_LOCK.LOCK_TIMESTAMP<?) wit
h this sql: 1353502325805
2012-11-21 15:55:05 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderCountD] Found 0 locks older than 1353502325805
2012-11-21 15:55:05 AST [WmDistributedLockManager.JdbcLockFactory.listOlderLocksD] Leave JdbcLockFactory.listOlderLocks(1353502325805), returning 0 locks
2012-11-21 15:55:10 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderSqlD] selecting locks older than (SELECT EXCL_LOCK_ID, TARGET_ID, LOCK_HOLDER,
LOCK_TYPE, LOCK_SHARE_COUNT, LOCK_TIMESTAMP FROM WM_EXCL_DIST_LOCK WHERE LOCK_TIMESTAMP<? AND LOCK_TYPE=‘E’) with this sql: 1353502330844
2012-11-21 15:55:10 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderCountD] Found 0 locks older than 1353502330844
2012-11-21 15:55:10 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderSqlD] selecting locks older than (SELECT WM_EXCL_DIST_LOCK.EXCL_LOCK_ID, WM_EX
CL_DIST_LOCK.TARGET_ID, WM_EXCL_DIST_LOCK.LOCK_HOLDER, WM_EXCL_DIST_LOCK.LOCK_TYPE, WM_EXCL_DIST_LOCK.LOCK_SHARE_COUNT, WM_EXCL_DIST_LOCK.LOCK_TIMESTAMP, WM_
SHAR_DIST_LOCK.SHAR_LOCK_ID, WM_SHAR_DIST_LOCK.LOCK_HOLDER, WM_SHAR_DIST_LOCK.EXCL_LOCK_ID, WM_SHAR_DIST_LOCK.LOCK_TIMESTAMP FROM WM_EXCL_DIST_LOCK, WM_SHAR_
DIST_LOCK WHERE WM_EXCL_DIST_LOCK.EXCL_LOCK_ID=WM_SHAR_DIST_LOCK.EXCL_LOCK_ID AND WM_EXCL_DIST_LOCK.LOCK_TYPE=‘S’ AND WM_SHAR_DIST_LOCK.LOCK_TIMESTAMP<?) wit
h this sql: 1353502330844
2012-11-21 15:55:10 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderCountD] Found 0 locks older than 1353502330844

OK…did you ran all the distributed locking tables…

If some thing seems messed up better drop the distributed tables and recreate it (via DB configurator) and restart the IS.

HTH,
RMG

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.