1 2 Previous Next 17 Replies Latest reply: Mar 28, 2012 3:19 AM by Jonas Stumph Stevnsvig RSS

    Full Text Index Building (ARS 7.6.04)

    Jonas Stumph Stevnsvig

      Hi all

       

      I am just wondering about the full text indexing server (Apache Lucene I believe), and how it works in ARS 7.6.04. I noted that after adding FTS on a field, the operation starts, but apparently never succeeds.

       

      as far as I can see, the operations are queued in ft_pending, but never completed... does anyone have any experiences like this, or an explaination?

       

       

      FTINDEX log:

      /* ma mar 26 2012 12:46:16.4090 */Staged 1 pending entry for indexing (limit 16)

      /* ma mar 26 2012 12:46:16.4090 */Next form scan set to fire now

      /* ma mar 26 2012 12:46:16.4090 */Indexing form entries updated since 26/03/2012 12:46:16 started (seq number 83198751) for schema 461

      /* ma mar 26 2012 12:46:16.4240 */Indexing form entries updated since 26/03/2012 12:46:16 completed (seq number 83198751) for schema 461

       

      SQL log:

      /* ma mar 26 2012 16:18:48.0120 */SELECT name FROM servgrp_config

      /* ma mar 26 2012 16:18:48.0120 */OK

      /* ma mar 26 2012 16:18:48.0120 */SELECT checkInterval FROM servgrp_config

      /* ma mar 26 2012 16:18:48.0120 */OK

      /* ma mar 26 2012 16:18:48.0120 */SELECT COUNT(*) FROM ft_pending WHERE operationType = 10

      /* ma mar 26 2012 16:18:48.0120 */OK

      /* ma mar 26 2012 16:18:48.0120 */SELECT COUNT(*) FROM ft_pending WHERE operationType = 6

       

      Entries in ft_pending:

      select servername, schemaid, fieldid, operationtype, updatetime, seqnum from aradmin.ft_pending order by updatetime asc, schemaid, fieldid;

       

      SERVERNAME   SCHEMAID    FIELDID OPERATIONTYPE UPDATETIME     SEQNUM

      ---------- ---------- ---------- ------------- ---------- ----------

      cmd1cs0084        429  200000020             6 1332765963  -83285122

      cmd1cs0084        461          0            11 1332765976  -83285123

      cmd1cs0084        461          0            11 1332767564  -83285126

      cmd1cs0084        461          0            11 1332767564  -83285128

      cmd1cs0084        461          0            11 1332767564  -83285129

      cmd1cs0084        461          0            11 1332767564  -83285130

      cmd1cs0084        461          0            11 1332767564   83285131

      cmd1cs0084        461          0            11 1332767564  -83285125

      cmd1cs0084        461          0            11 1332767564  -83285124

      cmd1cs0084        461          0            11 1332767564  -83285127

        1 2 Previous Next