This issue has been created
There is 1 update.
 
 
XWiki Platform / cid:jira-generated-image-avatar-085220b5-43fe-4fac-8f93-2fd3c24d1f22 XWIKI-22605 Open

Solr re-indexes many documents after restarting on PostgreSQL

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-baf57363-08b9-4766-99bf-2799de8b7838 Michael Hamann created this issue on 24/Oct/24 14:40
 
Summary: Solr re-indexes many documents after restarting on PostgreSQL
Issue Type: cid:jira-generated-image-avatar-085220b5-43fe-4fac-8f93-2fd3c24d1f22 Bug
Affects Versions: 16.8.0
Assignee: Unassigned
Components: Search - Solr
Created: 24/Oct/24 14:40
Priority: cid:jira-generated-image-static-critical-394f80a1-d7aa-4d39-9cb2-dd7253ed60d3 Critical
Reporter: Michael Hamann
Description:

Steps to reproduce:{}

  1. Create an XWiki instance with PostgreSQL, e.g., following the setup instructions for Docker at https://github.com/xwiki/xwiki-docker?tab=readme-ov-file#for-postgresql-on-tomcat
  2. Create some content and wait for indexing to complete.
  3. Restart the wiki and look at the log.

Expected result:

During startup, no pages are re-indexed and thus a log line like INFO o.x.s.s.i.j.IndexerJob - 0 documents added, 0 deleted and 0 updated during the synchronization of the Solr index. is logged shortly after startup.

Actual result:

Many documents are re-indexed and the log line is more like INFO o.x.s.s.i.j.IndexerJob - 1023 documents added, 1023 deleted and 0 updated during the synchronization of the Solr index.

Upon closer investigation, this seems to be an ordering difference between PostgreSQL and Solr: In Solr, AI.Code.CKEditorPlugin is before AI.Code.ChatOriginConfig while in PostgreSQL, AI.Code.ChatOriginConfig is first. This seems to be about case sensitivity.

 
 

1 update

 
cid:jira-generated-image-avatar-baf57363-08b9-4766-99bf-2799de8b7838 Changes by Michael Hamann on 24/Oct/24 14:41
 
Description: { * } Steps to reproduce: { * }{*}{*}
# Create an XWiki instance with PostgreSQL, e.g., following the setup instructions for Docker at [https://github.com/xwiki/xwiki-docker?tab=readme-ov-file#for-postgresql-on-tomcat]
# Create some content and wait for indexing to complete.
# Restart the wiki and look at the log.

*Expected result:*

During startup, no pages are re-indexed and thus a log line like {{INFO o.x.s.s.i.j.IndexerJob - 0 documents added, 0 deleted and 0 updated during the synchronization of the Solr index.}} is logged shortly after startup.

*Actual result:*

Many documents are re-indexed and the log line is more like {{INFO o.x.s.s.i.j.IndexerJob - 1023 documents added, 1023 deleted and 0 updated during the synchronization of the Solr index.}}



Upon closer investigation, this seems to be an ordering difference between PostgreSQL and Solr: In Solr, AI.Code.CKEditorPlugin is before AI.Code.ChatOriginConfig while in PostgreSQL, AI.Code.ChatOriginConfig is first. This seems to be about case sensitivity.