Update 2017/11/22 15:13:04-2.0 - ERROR (version created - 25, build 1 from the 2016-11-05 15.35.36 by buildguy) : org. Pentaho. Di. Core. Exception. KettleDatabaseException:
2017/11/22 15:13:04 - update 2.0 - Error inserting/updating the row
2017/11/22 15:13:04 - update 2.0 - transaction (process ID 61) and another process is a deadlock on the lock resources, and has been chosen victim fault locks, please rerun the transaction,
2017/11/22 15:13:04 - update 2.0 -
2017/11/22 15:13:04 - update 2.0 - at org. Pentaho. Di. Core. The database. The database. The insertRow (1321). The database Java:
2017/11/22 15:13:04 - update 2.0 - at org. Pentaho. Di. Trans. Steps. The update. The update. LookupValues (190). The update Java:
2017/11/22 15:13:04 - update 2.0 - at org. Pentaho. Di. Trans. Steps. The update. The update. The processRow (319). The update Java:
2017/11/22 15:13:04 - update 2.0 - at org. Pentaho. Di. Trans. Step. RunThread. Run (62) RunThread. Java:
2017/11/22 15:13:04-2.0 at the Java update. Lang. Thread. The run (745) Thread. Java:
2017/11/22 15:13:04 - update 2.0 - under Caused by: com. Microsoft. Essentially. JDBC. SQLServerException: transaction (process ID 61) and another process is a deadlock on the lock resources, and has been chosen victim fault locks, please rerun the transaction,
2017/11/22 15:13:04 - update 2.0 - at com. Microsoft. Essentially. JDBC. SQLServerException. MakeFromDatabaseError SQLServerException. Java: (216)
2017/11/22 15:13:04 - update 2.0 - at com. Microsoft. Essentially. JDBC. SQLServerStatement. GetNextResult SQLServerStatement. Java: (1515)
2017/11/22 15:13:04 - update 2.0 - at com. Microsoft. Essentially. JDBC. SQLServerPreparedStatement. DoExecutePreparedStatement SQLServerPreparedStatement. Java: (404)
2017/11/22 15:13:04 - update 2.0 - at com. Microsoft. Essentially, JDBC. SQLServerPreparedStatement $PrepStmtExecCmd. The doExecute (SQLServerPreparedStatement. Java: 350)
2017/11/22 15:13:04 - update 2.0 - at com. Microsoft. Essentially. JDBC. TDSCommand. Execute (IOBuffer. Java: 5696)
2017/11/22 15:13:04 - update 2.0 - at com. Microsoft. Essentially. JDBC. SQLServerConnection. ExecuteCommand (SQLServerConnection. Java: 1715)
2017/11/22 15:13:04 - update 2.0 - at com. Microsoft. Essentially. JDBC. SQLServerStatement. ExecuteCommand (SQLServerStatement. Java: 180)
2017/11/22 15:13:04 - update 2.0 - at com. Microsoft. Essentially. JDBC. SQLServerStatement. ExecuteStatement SQLServerStatement. Java: (155)
2017/11/22 15:13:04 - update 2.0 - at com. Microsoft. Essentially. JDBC. SQLServerPreparedStatement. ExecuteUpdate (SQLServerPreparedStatement. Java: 314)
2017/11/22 15:13:04 - update 2.0 - at org. Pentaho. Di. Core. The database. The database. The insertRow (1288). The database Java:
2017/11/22 15:13:04 - update 2.0 -... 4 more
2017/11/22 15:13:04 - delete 2.0 completion processing (I=0, O=0, R=3, W=2, U=3, E=0)
Update 2017/11/22 15:13:04-2.0 - completion processing (I=1, O=0, R=1, W=0, U=0, E=1)
2017/11/22 15:13:04 - KY - TRAN - B_Brand - ERROR (version created - 25, build 1 from the 2016-11-05 15.35.36 by buildguy) : ERROR is detected!
2017/11/22 15:13:04 - Spoon - conversion completed!!!!!
2017/11/22 15:13:04 - KY - TRAN - B_Brand - ERROR (version created - 25, build 1 from the 2016-11-05 15.35.36 by buildguy) : ERROR is detected!
2017/11/22 15:13:04 - KY - TRAN - B_Brand - ERROR (version created - 25, build 1 from the 2016-11-05 15.35.36 by buildguy) : ERROR is detected!
2017/11/22 15:13:04 - KY - TRAN - B_Brand - conversion is detected
2017/11/22 15:13:04 - KY - TRAN - B_Brand - conversion is killing other steps!
CodePudding user response:
Similar problems encountered three conditions:1, update or insert update steps, the specified key field is not set up the index, after adding indexes as well
2, copy the steps or submit data volume decreases a little
3, restart the kettle (I don't understand why, after two completely is trying out)
CodePudding user response:
This is obvious, lock, and see what the lock,CodePudding user response:
The table has been locked