Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Datablade Verity FullTextSearch Index Corruption

    Hi!

    I have a big problem.
    I have a table with approximately 160.000 records and 1 Verity VTS Index on a CLOB data type.

    This table is very important!
    It is updated all day like 500 times and has huge updates in few minutes.

    It is reindexed automatically every night when nobody uses it.

    The PROBLEM is:
    Randomically the Index becomes corrupted (I guess so!) and every SELECT in the CLOB field gives a 0 records result; the solution is to rebuild the Verity Index (which takes 20 minutes or so) with the SQL command "DROP INDEX index_name; CREATE INDEX index_name ON table_name (field_name VTS_CLOB_OPS) USING VTS IN space_name".

    The QUESTION is:
    1) Anybody has suggestions?
    2) Where can I look for Verity error messages? (In the standard Informix logs I cant find any error!!!)
    3) Could be a problem of wrong sbspaces space or configuration parameters?
    4) Does Informix knows when an index gets corrupted?
    5) When Informix automatically updates its indexes?

    Please help!

    Camillo

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    I think this is a known issue.

    1) Anybody has suggestions?

    Doesn't it help if you fragment your index?

    2) Where can I look for Verity error messages? (In the standard Informix logs I cant find any error!!!)

    No Idea
    3) Could be a problem of wrong sbspaces space or configuration parameters?

    No it is not. This is a known issue with Verity. I even think there is a patch for it available, but support can't deliver it since this product is end of life.

    4) Does Informix knows when an index gets corrupted?

    It knows when it has to search it, yes.

    5) When Informix automatically updates its indexes?
    Everytime a record is inserted or updated or deleted.
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •