[redhat-ccm-list] Problem w/search indexing in 6.0.1

[Daniel P. Berrange]

On Thu, Feb 26, 2004 at 10:30:53PM -0500, Jeff Hoffman wrote:
> Tomislav Vujec wrote:
> 
> > Let me guess, you're using Oracle 9i SE?
> > 
> > The problem didn't happen where the error was reported, but a bit
> > earlier. If you check USER_JOBS view, you'll find some failing jobs
> > there, most probably search_indexing.sync_index. To confirm that, try to
> > run the following code from the sqlplus:
> > 
> > begin
> >     search_indexing.sync_index();
> > end;
> > /
> > show errors;
> 
> ERROR at line 1:
> ORA-00439: feature not enabled: Online Index Build
> ORA-06512: at "PSITE.SEARCH_INDEXING", line 223
> ORA-06512: at line 2
> 
> So, I need to either install EE, or switch to Lucene, right?

Or manually hack the PL/SQL for the 'sync_index' method and
remove the keyword 'online' from the code. This will do offline
rebuilds of the search index. The potential problem with this
is that this locks out any other threads touching the search
index - including end user searches & metadata updates from
authors editing content. As such it could severly impact on
scalability, so EE is definitely preferrable to this.

Dan
-- 
|=-             Daniel P. Berrange  -  berrange at redhat.com              -=|
|=-   Red Hat, 338 Euston Road, London, NW1 3BT.  +44 (0)7977 267 243   -=|
|=-                                                                     -=|
|=- GnuPG: 7D3B9505   F3C9 553F A1DA 4AC2 5648 23C1 B3DF F742 7D3B 9505 -=| 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/redhat-ccm-list/attachments/20040227/cf7e13ef/attachment.sig>