Pivotal Knowledge Base

Follow

extra file in commit_log directory cause gptext error.

Problem:
Running query in gptext would return error:

select * from gptext.docs_commit_timestamps(TABLE(Select 1 SCATTER BY 1), 'xxx.xxx') xxx;
"ERROR","xxxx","invalid value" "mdw"" for ""YYYY""  (segxxx slicex sdwxx:xxxxx pid=xxxx)" "Value must be an integer."

 

Cause:
One extra file created at one segment data directory under solr/indexes/xxx/data/commit_log/ directory. When executing the function, gptext would read all files in this directory with certain format. Any extra file would cause this function to fail.

 

Solution:
Move this file out of this directory.

 

Note:
This issue will be traced through Jira TA-964. The dev team will improve the error message in gptext.

 

Comments

Powered by Zendesk