dbTalk Databases Forums  

Excalibur blade, ext_contains locking issue

comp.databases.informix comp.databases.informix


Discuss Excalibur blade, ext_contains locking issue in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
offdisc
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.