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