Informix Error -3460: This row has been locked by another user -- try again later.

Reasons / Common Causes

-3460 fires when another user is currently using (locking) the row or table being accessed — per the official guidance, another individual is currently using the table.

1. Another user currently holds a lock on the row/table, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Wait a few moments, and reenter the statement, per the official guidance.

Examples

Checking current locks before retrying

SELECT * FROM sysmaster:syslocks WHERE dbsname = 'mydb';

Diagnostic Checks

1. Check sysmaster:syslocks for the lock, and retry the operation once it's released.

Related Errors / Related Topics

• -3011 — "A table is locked -- no reading or writing is permitted." A closely related concurrency error, about the same underlying locking condition surfaced at a different point in the runtime.

Another user currently holds a lock on the row/table — wait and retry.