OCI DWH ETL performance job fails due to Lock wait timeout exceeded
- Views:
- 106
- Visibility:
- Public
- Votes:
- 0
- Category:
- oncommand-insight-data-warehouse
- Specialty:
- oci
- Last Updated:
Applies to
OnCommand Insight DataWareHouse 7.3.x
Issue
- OCI DWH ETL performance job fails
- DWH log:
2022-04-18 18:13:26,385 ERROR [Thread-17 (ActiveMQ-client-global-threads)] JobDispatcherBean (JobDispatcherBean.java:131) - Job{name='Performance', id=423771} failed
com.netapp.sanscreen.dwh.performance.PerformanceException: Failed running performance job
at com.netapp.sanscreen.dwh.performance.PerformanceRunnerBean.run(PerformanceRunnerBean.java:105) ~[performance.jar:?]
at com.netapp.sanscreen.dwh.performance.PerformanceRunnerBean.run(PerformanceRunnerBean.java:55) ~[performance.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_271]
.....
Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:123) ~[mysql-connector-java-commercial.jar!/:8.0.22]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-commercial.jar!/:8.0.22]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-commercial.jar!/:8.0.22]
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) ~[mysql-connector-java-commercial.jar!/:8.0.22]
....
[Truncated]