-
Title
Out of sync due to ORA-01013: user requested cancel of current operation -
Description
Errorlog.sql out of sync error:
-- [1] Fri Feb 22 14:42:07 2008
-- redolog seq#/offset xxxxx/xxxxx
-- redolog timestamp xxxxxx (00/00/00 00:00:00)
-- original rowid XXXXXXXXXXXXXXXXXX
-- ORA-01013: user requested cancel of current operation
-- NOT FOUND
--
update "owner"."table" statement
Event_log error:
Notice: Oracle error: ORA-01013: user requested cancel of current operation. rowid:xxxxxxxxxxxx[sp_opst (for o.sourcesid-o.targetsid-queue name)/pid]
Warning: 15033 - Failed to execute SQL on table "OWNER"."TABLE": ORA-01013: user requested cancel of current operation. [sp_opst (for for o.sourcesid-o.targetsid-queue name)/pid] -
Cause
A session that's rolled back to avert a blocking condition doesn't free its key-cache, and consequently goes on to use a ROWID associated with an Insert that was rolled back.
-
Resolution
Status : Fixed in Version 5.3.4.
The latest version can be downloaded from Supportlink.
-
Defect ID
CR129061 -
Additional Information
ORA-01013 user requested cancel of current operation
Cause: The user interrupted an Oracle operation by entering CTRL-C, Control-C, or another canceling operation. This forces the current operation to end. This is an informational message only.
Action: Continue with the next operation.