In this blog post, let’s learn about the error message “146 ISAM error: the other copy of this disk is currently disabled or non-existent.” in Hydra and the description of the error.
Error Message
146 ISAM error: the other copy of this disk is currently disabled or non-existent.
Error Details
The current operation inserts a row with a certain primary key value or updates a row with a certain primary key value, but a transaction that has not yet been committed has deleted that key value from the index. This error occurs only when the lock mode is set to NOT WAIT. Treat it the same as error -107 (record is locked). Roll back the current transaction, and re-execute it after a delay. Then, if the other transaction was committed, the lock no longer exists. If it was rolled back, the key exists, and this operation receives a duplicate-key error.