Previous Topic: -180 - ROW HELD BY PREVIOUS LOGICAL UNIT OF WORK WAS DELETEDNext Topic: -182 - UNIQUE/PRIMARY CANNOT BE SPECIFIED DUE TO NULL ON nnnnnn


-181 - ROW HELD BY PREVIOUS LOGICAL UNIT OF WORK WAS UPDATED

Explanation

A row held for update by the previous LUW (logical unit of work) was updated before the current LUW could regain exclusive control over the row.

The SQLSTATE that equates to this SQL return code is 24S02.

User Response

Try executing again when the table being used is less likely to have other update users, after evaluating the effect of the updated row on the outcome.