Create index in GPText failed with error: org.apache.solr.client.solrj.impl.HttpSolrClient$RemoteSolrException:Error

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:
When you are unable to create or drop an index, the following error message is outputted:

select gptext.create_index('xxx', 'xxxx', 'xxx', 'xxx');
WARNING: org.apache.solr.client.solrj.impl.HttpSolrClient$RemoteSolrException:Error from server at http://hostname:port_Id/solr: Error CREATEing SolrCore 'xxx.xxx.xxx': Unable to create core [xx.xx.xx] Caused by: no segments* file found in LockValidatingDirectoryWrapper(NIOFSDirectory@/data2/primary/solr0/data/xx.xx.xxxx/data/index lockFactory=org.apache.lucene.store.NativeFSLockFactory@xxxx): files: [write.lock]. (AdminUDF.cpp:347)
CONTEXT: SQL statement "SELECT gptext.__create_index_impl( $1 , $2 , $3 , $4 , $5 )"
PL/pgSQL function "__create_index" line 185 at SQL statement
WARNING: Could not find collection : nisp_db.web.insight_reportdatagptext. (AdminUDF.cpp:371)
CONTEXT: SQL statement "SELECT gptext.__drop_index_impl( $1 , $2 )"
PL/pgSQL function "__create_index" line 227 at SQL statement
WARNING: Drop index failed. Maybe manually drop later is required.
ERROR: Create index operation failed.

Environment

Cause

According to the engineering team, this error is caused by file corruption or abnormal usage.

Resolution

To resolve this issue, re-create the data directory at each solr* directory at all segment hosts, then restart the GPText cluster.