RA-01013: user requested cancel of current

[Abhishek Chauhan]

Hi,

Night jobs are running in parallel, and we are getting this error,
frequently. We have used "database.query.timeout.ms": 0, but with this
property it failed with this error
"Error: java.sql.SQLException: ORA-00310: archived log contains
sequence 166819; sequence 166813 required ORA-00334: archived log:
'/data/oradata/iccdb/redo01.log'"

Error occurred during Batch Jobs: ->>

{"time":"2026-07-28T13:44:13.444982908Z","stream":"stdout","_p":"P","log":"Caused
by: Error : 1013, Position : 275, Sql = SELECT SCN, SQL_REDO,
OPERATION_CODE, TIMESTAMP, XID, CSF, TABLE_NAME, SEG_OWNER, OPERATION,
USERNAME, ROW_ID, ROLLBACK, RS_ID, STATUS, INFO, SSN, THREAD#,
DATA_OBJ#, DATA_OBJV#, DATA_OBJD#, CLIENT_ID, START_SCN, COMMIT_SCN,
START_TIMESTAMP, COMMIT_TIMESTAMP, SEQUENCE# FROM V$LOGMNR_CONTENTS
WHERE SCN > :1  AND SCN <= :2  AND (OPERATION_CODE IN
(1,2,3,6,7,27,34,36,255) OR (OPERATION_CODE = 5 AND INFO NOT LIKE
'INTERNAL DDL%')) AND (SEG_OWNER IS NULL OR UPPER(SEG_OWNER) IN
('UNKNOWN','CUSTOMER_I','OPUS_CORE','CUSTOMER')) AND (TABLE_NAME IS
NULL OR UPPER(SEG_OWNER || '.' || TABLE_NAME) IN (}
  Error Msg = ORA-01013: user requested cancel of current
operation","kubernetes":{"pod_name":"opus-gi-oraclesource-kafka-service-5d45bc68dc-d5fpc","namespace_name":"opusm","pod_id":"b49ceadb-f991-4d04-bd66-2183525afee9","host":"ip-100-80-41-213.ap-southeast-1.compute.internal","pod_ip":"1.240.29.207","container_name":"generic","docker_id":"b15eecce1168ff86e93048aaa8074df7064332801396a2a0c57945ae4a1ade42","container_hash":"99238"container_image":"992382782141.dkr.ecr.ap-southeast-1.amazonaws.com/opus-gi-oraclesource-kafka-service:prod-dry-run-0.0.2"}}
{"time":"2026-07-28T13:44:13.444864335Z","stream":"stdout","_p":"F","log":"Caused
by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of
current operation","kubernetes":{"pod_name":"opus-gi-oraclesource-kafka-service-5d45bc68dc-d5fpc","namespace_name":"opusm","pod_id":"b49ceadb-f991-4d04-bd66-2183525afee9","host":"ip-100-80-41-213.ap-southeast-1.compute.internal","pod_ip":"1.240.29.207","container_name":"generic","docker_id":"b15eecce1168ff86e93048aaa8074df7064332801396a2a0c57945ae4a1ade42","container_hash":"992382\","container_image":"992382782141.dkr.ecr.ap-southeast-1.amazonaws.com/opus-gi-oraclesource-kafka-service:prod-dry-run-0.0.2"}}
{"time":"2026-07-28T13:44:13.182673001Z","stream":"stdout","_p":"P","log":"Caused
by: Error : 1013, Position : 275, Sql = SELECT SCN, SQL_REDO,
OPERATION_CODE, TIMESTAMP, XID, CSF, TABLE_NAME, SEG_OWNER, OPERATION,
USERNAME, ROW_ID, ROLLBACK, RS_ID, STATUS, INFO, SSN, THREAD#,
DATA_OBJ#, DATA_OBJV#, DATA_OBJD#, CLIENT_ID, START_SCN, COMMIT_SCN,
START_TIMESTAMP, COMMIT_TIMESTAMP, SEQUENCE# FROM V$LOGMNR_CONTENTS
WHERE SCN > :1  AND SCN <= :2  AND (OPERATION_CODE IN
(1,2,3,6,7,27,34,36,255) OR (OPERATION_CODE = 5 AND INFO NOT LIKE
'INTERNAL DDL%')) AND (SEG_OWNER IS NULL OR UPPER(SEG_OWNER) IN
('UNKNOWN','CUSTOMER_I','OPUS_CORE','CUSTOMER')) AND (TABLE_NAME IS
NULL OR UPPER(SEG_OWNER || '.' || TABLE_NAME) IN (), Error Msg =
ORA-01013: user requested cancel of current
operation","kubernetes":{"pod_name":"opus-gi-oraclesource-kafka-service-5d45bc68dc-d5fpc","namespace_name":"opusm","pod_id":"b49ceadb-f991-4d04-bd66-2183525afee9","host":"ip-100-80-41-213.ap-southeast-1.compute.internal","pod_ip":"1.240.29.207","container_name":"generic","docker_id":"b15eecce1168ff86e93048aaa8074df7064332801396a2a0c57945ae4a1ade42","container_hash":"99238/opus-gi-oraclesource-kafka-service:prod-dry-run-0.0.2"}}
{"time":"2026-07-28T13:44:13.182542658Z","stream":"stdout","_p":"F","log":"java.sql.SQLTimeoutException:
ORA-01013: user requested cancel of current
operation","kubernetes":{"pod_name":"opus-gi-oraclesource-kafka-service-5d45bc68dc-d5fpc","namespace_name":"opusm","pod_id":"b49ceadb-f991-4d04-bd66-2183525afee9","host":"ip-100-80-41-213.ap-southeast-1.compute.internal","pod_ip":"1.240.29.207","container_name":"generic","docker_id":"b15eecce1168ff86e93048aaa8074df7064332801396a2a0c57945ae4a1ade42","container_hash":"99238opus-gi-oraclesource-kafka-service:prod-dry-run-0.0.2"}}
{"time":"2026-07-28T13:44:13.182413355Z","stream":"stdout","_p":"P","log":"Caused
by: Error : 1013, Position : 275, Sql = SELECT SCN, SQL_REDO,
OPERATION_CODE, TIMESTAMP, XID, CSF, TABLE_NAME, SEG_OWNER, OPERATION,
USERNAME, ROW_ID, ROLLBACK, RS_ID, STATUS, INFO, SSN, THREAD#,
DATA_OBJ#, DATA_OBJV#, DATA_OBJD#, CLIENT_ID, START_SCN, COMMIT_SCN,
START_TIMESTAMP, COMMIT_TIMESTAMP, SEQUENCE# FROM V$LOGMNR_CONTENTS
WHERE SCN > :1  AND SCN <= :2  AND (OPERATION_CODE IN
(1,2,3,6,7,27,34,36,255) OR (OPERATION_CODE = 5 AND INFO NOT LIKE
'INTERNAL DDL%')) AND (SEG_OWNER IS NULL OR UPPER(SEG_OWNER) IN
('UNKNOWN','CUSTOMER_I','OPUS_CORE','CUSTOMER')) AND (TABLE_NAME IS
NULL OR UPPER(SEG_OWNER || '.' || TABLE_NAME) IN (), Error Msg =
ORA-01013: user requested cancel of current
operation","kubernetes":{"pod_name":"opus-gi-oraclesource-kafka-service-5d45bc68dc-d5fpc","namespace_name":"opusm","pod_id":"b49ceadb-f991-4d04-bd66-2183525afee9","host":"ip-100-80-41-213.ap-southeast-1.compute.internal","pod_ip":"1.240.29.207","container_name":"generic","docker_id":"b15eecce1168ff86e93048aaa8074df7064332801396a2a0c57945ae4a1ade42","container_hash":"99238opus-gi-oraclesource-kafka-service:prod-dry-run-0.0.2"}}
{"time":"2026-07-28T13:44:13.182226131Z","stream":"stdout","_p":"F","log":"java.sql.SQLTimeoutException:
ORA-01013: user requested cancel of current
operation","kubernetes":{"pod_name":"opus-gi-oraclesource-kafka-service-5d45bc68dc-d5fpc","namespace_name":"opusm","pod_id":"b49ceadb-f991-4d04-bd66-2183525afee9","host":"ip-100-80-41-213.ap-southeast-1.compute.internal","pod_ip":"1.240.29.207","container_name":"generic","docker_id":"b15eecce1168ff86e93048aaa8074df7064332801396a2a0c57945ae4a1ade42","container_hash":"99238\opus-gi-oraclesource-kafka-service:prod-dry-run-0.0.2"}}
>