Full Text Index Building (ARS 7.6.04)
Jonas Stevnsvig Mar 26, 2012 9:49 AMHi 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