Excalibur blade, ext_contains locking issue -
08-24-2010
, 09:18 AM
Hi All,
We are using the Excalibur Text Search datablade, and are running into
an error during Inserts.
The error reads: "A select is in progress, so updating the index is
not allowed".
Now, the obvious answer is that a "Select for Update" cursor is
locking the table, however I have been guaranteed that none of the
programs use Update cursors. (I am new to this company, so I can only
take their word for it)
We do have many regular Selects that utilize the 'ext_contains' search
from the datablade.
Is it possible that ext_contains creates Locks on the Indexes?
Thanks,
Michael Hoffman
DBA
Colorado Secretary of State |