Warn: No fulltext index configured for field dc:title, falling back on LIKE query

gsc_ — Wed, 07 Jan 2015 12:44:24 GMT

Hi,

We've detected a 'WARN' in the Nuxeo server.log:

WARN [http-bio-0.0.0.0-8080-exec-88] [org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker] No fulltext index configured for field dc:title, falling back on LIKE query

TRACE [http-bio-0.0.0.0-8080-exec-88] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCLogger] (9) SQL: SELECT [_C1] FROM (SELECT [hierarchy].[id] AS [_C1] FROM [hierarchy] LEFT JOIN [dublincore] [_F1] ON [hierarchy].[id] = [_F1].[id] LEFT JOIN [misc] [_F2] ON [hierarchy].[id] = [_F2].[id] WHERE (([hierarchy].[primarytype] IN ('SectionRoot', 'Workspace', 'Forum', 'RelationSearch', 'user_open_tasks_cv', 'FollowLifeCycleTransitionTask', 'PublishTask', 'Thread', 'Collection', 'TemplateRoot', 'Document', 'Folder', 'DocumentRouteStep', 'Domain', 'Collections', 'File', 'WorkspaceRoot', 'AdvancedSearch', 'Note', 'quota_heaviest_containers_cv', 'Favorites', 'Section', 'SimpleTask', 'ConditionalTask', 'OrderedFolder', 'BasicAuditSearch')) AND (LOWER([_F1].[title]) LIKE '%curso%') AND ([hierarchy].[isversion] IS NULL) AND ([_F2].[lifecyclestate] <> 'deleted')) UNION ALL SELECT [_H].[id] AS [_C1] FROM [hierarchy] [_H] JOIN [proxies] ON [_H].[id] = [proxies].[id] JOIN [hierarchy] ON [proxies].[targetid] = [hierarchy].[id] LEFT JOIN [dublincore] [_F1] ON [hierarchy].[id] = [_F1].[id] LEFT JOIN [misc] [_F2] ON [hierarchy].[id] = [_F2].[id] WHERE (([hierarchy].[primarytype] IN ('SectionRoot', 'Workspace', 'Forum', 'RelationSearch', 'user_open_tasks_cv', 'FollowLifeCycleTransitionTask', 'PublishTask', 'Thread', 'Collection', 'TemplateRoot', 'Document', 'Folder', 'DocumentRouteStep', 'Domain', 'Collections', 'File', 'WorkspaceRoot', 'AdvancedSearch', 'Note', 'quota_heaviest_containers_cv', 'Favorites', 'Section', 'SimpleTask', 'ConditionalTask', 'OrderedFolder', 'BasicAuditSearch')) AND (LOWER([_F1].[title]) LIKE '%curso%') AND ([_H].[isversion] IS NULL) AND ([_F2].[lifecyclestate] <> 'deleted'))) AS [_T] -- LIMIT 10 OFFSET 0 -- COUNT TOTAL UP TO 10

There was no fulltext index in the dublincore table, so I've created (for the 'title' field). I've tested it in a SQL Server Query (changing the LIKE with a CONTAINS predicate) and it works, but Nuxeo is throwing the same error.

Does anyone know how to fix it?

Thanks!

Re: Warn: No fulltext index configured for field dc:title, falling back on LIKE query

Florent_Guillau — Wed, 07 Jan 2015 14:14:06 GMT

Please check VCS Configuration to see how to configure fulltext indexes. But this won't help because note that due to SQL Server limitations (see doc) only one fulltext index can be configured, which prevents the use of additional ones like for "title".

In Nuxeo 6.0 and later Elasticsearch is used instead of native database fulltext, in part to work around these limitations.

topic Warn: No fulltext index configured for field dc:title, falling back on LIKE query in Nuxeo Forum

Warn: No fulltext index configured for field dc:title, falling back on LIKE query

Re: Warn: No fulltext index configured for field dc:title, falling back on LIKE query