Yes it's enabled.
But the error is still there. Here is the steps i followed:
I was following the following Post:
Elasticsearch node health in the red - #4 by czue
-
Delete Indices
-
recreate indices using /manage.py ptop_preindex
Issue: Indices created but size of indices are less than the previous size
and Indices created with a replica value of 1. Previously, we didn't have a replica for each index. -
run run ./manage.py ptop_reindexer_v2 [datatype] --cleanup” where datatype is one of
'domain', 'user', 'group', 'groups-to-user', 'case', 'form', 'sql-case', 'sql-form', 'case-search',
'case-search-resumable', 'report-case', 'report-xform', 'sql-app-form-submission','user-app-form-submission','sms','app', 'couch-app-form-submission', 'user-sync-history'.
it's ok for SQL-case but brings an error for SQL-form.
- Then I look at the other post: Submit History and Case List shows no data
Now i run ./manage.py ptop_reindexer_v2 sql-case --reset
After running the above cmd case, hqcases_2016-03-04 index size changed from 30 MB to 5.8 GB. which is OK
- Running ./manage.py ptop_reindexer_v2 sql-form --reset
running ok and brings an error in the middle. The following is the output
Processed 61000/61000 of 2295034 documents in 0:27:00.875969 (16:29:20.517414 remaining)
2019-11-17 13:11:38,923 INFO reindexer Processing batch of 1000 docs
Processed 62000/62000 of 2295034 documents in 0:27:27.464704 (16:28:56.179448 remaining)
......
......
Traceback (most recent call last):
File "/home/cchq/www/echis/releases/2019-11-10_16.43/python_env-3.6/lib/python3.6/site-packages/memoized.py", line 138, in call
return cache[key]
KeyError: ()
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/cchq/www/echis/releases/2019-11-10_16.43/python_env-3.6/lib/python3.6/site-packages/memo
ized.py", line 138, in call
return cache[key]
KeyError: ()
----------
File "/home/cchq/www/echis/releases/2019-11-10_16.43/python_env-3.6/lib/python3.6/site-packages/memoized.py", line 18, in _inner
return m(*args, **kwargs)
File "/home/cchq/www/echis/releases/2019-11-10_16.43/python_env-3.6/lib/python3.6/site-packages/memoized.py", line 140, in call
value = self.func( *args, **kwargs)
File "/home/cchq/www/echis/releases/2019-11-10_16.43/corehq/form_processor/models.py", line 550, in
get_xml
raise MissingFormXml(self.form_id)
corehq.form_processor.exceptions.MissingFormXml: 78ce09b4-3af6-4e1a-b5e0-b2c6c60bae7f
Sentry is attempting to send 0 pending error messages
Waiting up to 2 seconds
Press Ctrl-C to quit
6.The following is the output of indices: curl -XGET 172.19.3.41:9200/_cat/indices
green open smslogs_2017-02-09 5 1 0 0 1.4kb 720b
green open xforms_2016-07-07 5 1 64840 0 332.4mb 166.3mb
green open hqusers_2017-09-07 2 1 79869 190 28.2mb 14.1mb
green open hqdomains_2016-08-08 5 1 13 13 360kb 172.6kb
green open case_search_2018-05-29 5 1 2033433 3100 5.8gb 2.9gb
green open report_cases_czei39du507m9mmpqk3y01x72a3ux4p0 5 1 0 0 970b 575b
green open hqgroups_2017-05-29 5 1 4 4 26.2kb 13.1kb
green open report_xforms_20160824_1708 5 1 0 0 1.4kb 720b
green open hqcases_2016-03-04 5 1 6204612 10108 6.2gb 3.1gb
green open hqapps_2019-08-14 5 1 15798 1171 142.1mb 71mb