Get Data Moving 1
Results 1 to 1 of 1

Thread: ERROR: "The data from the last read was changed, cannot lock"

  1. #1
    laura is offline Support
    Join Date
    Aug 2006
    Posts
    19
    Rep Power
    0

    ERROR: "The data from the last read was changed, cannot lock"

    Description

    When trying to run a Select in pessimistic locking mode we get the following error: "The data from the last read was changed, cannot lock"

    Meaning

    When the Query Processor is running a Select query in pessimistic locking mode:

    1. Records are first read and checked one by one;
    Records that pass the query selection criteria are saved in a temporary storage (memory with a mechanism to reduce to disk if it gets too large) and are immediately locked.
    The Query Processor repeats this verification for every row.

    2. Once all records are read and the list of relevant records is complete, the records are reread one by one.
    During that reading, each record is compared with the saved image from the first round in order to ensure that it was not changed.
    If this comparison fails then the lock is rejected with the message “The data from the last read was changed, cannot lock row”.
    Last edited by laura; 11-05-2006 at 03:53 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •