Mobile workers

Hi everyone,

I have installed comm-care HQ on Ubuntu 14.04. I am using Docker to run
server
when I created mobile user it create successfully when I click to show
active mobile user it shows me following error

On web

There was an issue contacting the server. Please check your internet
connection. If this issue continues, please file a bug report.

On Terminal it shows me

web_1 | File “/mnt/commcare-hq/corehq/elastic.py”, line 166, in run_query
web_1 | raise ESError(e)
web_1 | ESError: TransportError(400, u’SearchPhaseExecutionException[Failed
to execute phase [query], all shards failed; shardFailures
{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][0]:
SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{“sort”: {“username.exact”: {“order”:
“asc”}}, “query”: {“filtered”: {“filter”: {“and”: [{“or”: [{“term”:
{“domain.exact”: “test”}}, {“term”: {“domain_memberships.domain.exact”:
“test”}}]}, {“term”: {“doc_type”: “CommCareUser”}}, {“term”: {“is_active”:
false}}, {“term”: {“base_doc”: “couchuser”}}]}, “query”: {“match_all”:
{}}}}, “from”: 0, “size”: 10}]]]; nested:
SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse
Failure [No mapping found for [username.exact] in order to sort on]];
}{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][1]:
SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{“sort”: {“username.exact”: {“order”:
“asc”}}, “query”: {“filtered”: {“filter”: {“and”: [{“or”: [{“term”:
{“domain.exact”: “test”}}, {“term”: {“domain_memberships.domain.exact”:
“test”}}]}, {“term”: {“doc_type”: “CommCareUser”}}, {“term”: {“is_active”:
false}}, {“term”: {“base_doc”: “couchuser”}}]}, “query”: {“match_all”:
{}}}}, “from”: 0, “size”: 10}]]]; nested:
SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse
Failure [No mapping found for [username.exact] in order to sort on]];
}{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][2]:
SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{“sort”: {“username.exact”: {“order”:
“asc”}}, “query”: {“filtered”: {“filter”: {“and”: [{“or”: [{“term”:
{“domain.exact”: “test”}}, {“term”: {“domain_memberships.domain.exact”:
“test”}}]}, {“term”: {“doc_type”: “CommCareUser”}}, {“term”: {“is_active”:
false}}, {“term”: {“base_doc”: “couchuser”}}]}, “query”: {“match_all”:
{}}}}, “from”: 0, “size”: 10}]]]; nested:
SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse
Failure [No mapping found for [username.exact] in order to sort on]];
}{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][3]:
SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{“sort”: {“username.exact”: {“order”:
“asc”}}, “query”: {“filtered”: {“filter”: {“and”: [{“or”: [{“term”:
{“domain.exact”: “test”}}, {“term”: {“domain_memberships.domain.exact”:
“test”}}]}, {“term”: {“doc_type”: “CommCareUser”}}, {“term”: {“is_active”:
false}}, {“term”: {“base_doc”: “couchuser”}}]}, “query”: {“match_all”:
{}}}}, “from”: 0, “size”: 10}]]]; nested:
SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse
Failure [No mapping found for [username.exact] in order to sort on]];
}{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][4]:
SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{“sort”: {“username.exact”: {“order”:
“asc”}}, “query”: {“filtered”: {“filter”: {“and”: [{“or”: [{“term”:
{“domain.exact”: “test”}}, {“term”: {“domain_memberships.domain.exact”:
“test”}}]}, {“term”: {“doc_type”: “CommCareUser”}}, {“term”: {“is_active”:
false}}, {“term”: {“base_doc”: “couchuser”}}]}, “query”: {“match_all”:
{}}}}, “from”: 0, “size”: 10}]]]; nested:
SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse
Failure [No mapping found for [username.exact] in order to sort on]]; }]’)

Guide me how to solve it

Thanks for your help

Sheeraz

Hi Sheeraz,

I would try deleting your user index on elasticsearch and then reindexing
it. (./manage.py ptop_preindex). This may be due to a stale mapping file in
elasticsearch.

··· On Mon, Oct 10, 2016 at 5:05 AM, Sheeraz Mahmood wrote:

Hi everyone,

I have installed comm-care HQ on Ubuntu 14.04. I am using Docker to run
server
when I created mobile user it create successfully when I click to show
active mobile user it shows me following error

On web

There was an issue contacting the server. Please check your internet
connection. If this issue continues, please file a bug report.

On Terminal it shows me

web_1 | File “/mnt/commcare-hq/corehq/elastic.py”, line 166, in run_query
web_1 | raise ESError(e)
web_1 | ESError: TransportError(400, u’SearchPhaseExecutionException[Failed
to execute phase [query], all shards failed; shardFailures
{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][0]:
SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{“sort”: {“username.exact”: {“order”:
“asc”}}, “query”: {“filtered”: {“filter”: {“and”: [{“or”: [{“term”:
{“domain.exact”: “test”}}, {“term”: {“domain_memberships.domain.exact”:
“test”}}]}, {“term”: {“doc_type”: “CommCareUser”}}, {“term”: {“is_active”:
false}}, {“term”: {“base_doc”: “couchuser”}}]}, “query”: {“match_all”:
{}}}}, “from”: 0, “size”: 10}]]]; nested: SearchParseException[[hqusers_2016-07-19][0]:
from[-1],size[-1]: Parse Failure [No mapping found for [username.exact] in
order to sort on]]; }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][1]:
SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{“sort”: {“username.exact”: {“order”:
“asc”}}, “query”: {“filtered”: {“filter”: {“and”: [{“or”: [{“term”:
{“domain.exact”: “test”}}, {“term”: {“domain_memberships.domain.exact”:
“test”}}]}, {“term”: {“doc_type”: “CommCareUser”}}, {“term”: {“is_active”:
false}}, {“term”: {“base_doc”: “couchuser”}}]}, “query”: {“match_all”:
{}}}}, “from”: 0, “size”: 10}]]]; nested: SearchParseException[[hqusers_2016-07-19][1]:
from[-1],size[-1]: Parse Failure [No mapping found for [username.exact] in
order to sort on]]; }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][2]:
SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{“sort”: {“username.exact”: {“order”:
“asc”}}, “query”: {“filtered”: {“filter”: {“and”: [{“or”: [{“term”:
{“domain.exact”: “test”}}, {“term”: {“domain_memberships.domain.exact”:
“test”}}]}, {“term”: {“doc_type”: “CommCareUser”}}, {“term”: {“is_active”:
false}}, {“term”: {“base_doc”: “couchuser”}}]}, “query”: {“match_all”:
{}}}}, “from”: 0, “size”: 10}]]]; nested: SearchParseException[[hqusers_2016-07-19][2]:
from[-1],size[-1]: Parse Failure [No mapping found for [username.exact] in
order to sort on]]; }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][3]:
SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{“sort”: {“username.exact”: {“order”:
“asc”}}, “query”: {“filtered”: {“filter”: {“and”: [{“or”: [{“term”:
{“domain.exact”: “test”}}, {“term”: {“domain_memberships.domain.exact”:
“test”}}]}, {“term”: {“doc_type”: “CommCareUser”}}, {“term”: {“is_active”:
false}}, {“term”: {“base_doc”: “couchuser”}}]}, “query”: {“match_all”:
{}}}}, “from”: 0, “size”: 10}]]]; nested: SearchParseException[[hqusers_2016-07-19][3]:
from[-1],size[-1]: Parse Failure [No mapping found for [username.exact] in
order to sort on]]; }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][4]:
SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse
Failure [Failed to parse source [{“sort”: {“username.exact”: {“order”:
“asc”}}, “query”: {“filtered”: {“filter”: {“and”: [{“or”: [{“term”:
{“domain.exact”: “test”}}, {“term”: {“domain_memberships.domain.exact”:
“test”}}]}, {“term”: {“doc_type”: “CommCareUser”}}, {“term”: {“is_active”:
false}}, {“term”: {“base_doc”: “couchuser”}}]}, “query”: {“match_all”:
{}}}}, “from”: 0, “size”: 10}]]]; nested: SearchParseException[[hqusers_2016-07-19][4]:
from[-1],size[-1]: Parse Failure [No mapping found for [username.exact] in
order to sort on]]; }]’)

Guide me how to solve it

Thanks for your help

Sheeraz


You received this message because you are subscribed to the Google Groups
"CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Thanks Cory for your response

First i delete the all index by using curl -XDELETE localhost:9200/.mar*
then i recreate index by using ./manage.py ptop_preindex
and it worked

Thanks again

Sheeraz

··· On Monday, October 10, 2016 at 8:44:28 PM UTC+5, Cory Zue wrote: > > Hi Sheeraz, > > I would try deleting your user index on elasticsearch and then reindexing > it. (./manage.py ptop_preindex). This may be due to a stale mapping file in > elasticsearch. > > On Mon, Oct 10, 2016 at 5:05 AM, Sheeraz Mahmood <sheeraz...@gmail.com > wrote: > >> Hi everyone, >> >> >> I have installed comm-care HQ on Ubuntu 14.04. I am using Docker to run >> server >> when I created mobile user it create successfully when I click to show >> active mobile user it shows me following error >> >> >> On web >> >> >> There was an issue contacting the server. Please check your internet >> connection. If this issue continues, please file a bug report. >> >> >> On Terminal it shows me >> >> >> web_1 | File "/mnt/commcare-hq/corehq/elastic.py", line 166, in run_query >> web_1 | raise ESError(e) >> web_1 | ESError: TransportError(400, >> u'SearchPhaseExecutionException[Failed to execute phase [query], all shards >> failed; shardFailures {[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][0]: >> SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse >> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >> {}}}}, "from": 0, "size": 10}]]]; nested: >> SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse >> Failure [No mapping found for [username.exact] in order to sort on]]; >> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][1]: >> SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse >> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >> {}}}}, "from": 0, "size": 10}]]]; nested: >> SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse >> Failure [No mapping found for [username.exact] in order to sort on]]; >> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][2]: >> SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse >> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >> {}}}}, "from": 0, "size": 10}]]]; nested: >> SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse >> Failure [No mapping found for [username.exact] in order to sort on]]; >> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][3]: >> SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse >> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >> {}}}}, "from": 0, "size": 10}]]]; nested: >> SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse >> Failure [No mapping found for [username.exact] in order to sort on]]; >> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][4]: >> SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse >> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >> {}}}}, "from": 0, "size": 10}]]]; nested: >> SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse >> Failure [No mapping found for [username.exact] in order to sort on]]; }]') >> >> >> Guide me how to solve it >> >> Thanks for your help >> >> >> Sheeraz >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "CommCare Developers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-developers+unsubscribe@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

Dear Sheeraz and all -

I have a similar issue with docker setup. Re-creating the index did not
work. I believe this command should be run in the web service in docker
since Commcare is running within a container? I am learning fast just that
there is so much to learn and time is short.

What is the correct way of running the recreation of the index? thanks,

Euc

··· On Thursday, October 13, 2016 at 7:48:10 AM UTC+1, Sheeraz Mahmood wrote: > > Thanks Cory for your response > > First i delete the all index by using curl -XDELETE localhost:9200/.mar* > then i recreate index by using ./manage.py ptop_preindex > and it worked > > Thanks again > > Sheeraz > > On Monday, October 10, 2016 at 8:44:28 PM UTC+5, Cory Zue wrote: >> >> Hi Sheeraz, >> >> I would try deleting your user index on elasticsearch and then reindexing >> it. (./manage.py ptop_preindex). This may be due to a stale mapping file in >> elasticsearch. >> >> On Mon, Oct 10, 2016 at 5:05 AM, Sheeraz Mahmood wrote: >> >>> Hi everyone, >>> >>> >>> I have installed comm-care HQ on Ubuntu 14.04. I am using Docker to run >>> server >>> when I created mobile user it create successfully when I click to show >>> active mobile user it shows me following error >>> >>> >>> On web >>> >>> >>> There was an issue contacting the server. Please check your internet >>> connection. If this issue continues, please file a bug report. >>> >>> >>> On Terminal it shows me >>> >>> >>> web_1 | File "/mnt/commcare-hq/corehq/elastic.py", line 166, in run_query >>> web_1 | raise ESError(e) >>> web_1 | ESError: TransportError(400, >>> u'SearchPhaseExecutionException[Failed to execute phase [query], all shards >>> failed; shardFailures {[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][0]: >>> SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse >>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>> {}}}}, "from": 0, "size": 10}]]]; nested: >>> SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse >>> Failure [No mapping found for [username.exact] in order to sort on]]; >>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][1]: >>> SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse >>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>> {}}}}, "from": 0, "size": 10}]]]; nested: >>> SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse >>> Failure [No mapping found for [username.exact] in order to sort on]]; >>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][2]: >>> SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse >>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>> {}}}}, "from": 0, "size": 10}]]]; nested: >>> SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse >>> Failure [No mapping found for [username.exact] in order to sort on]]; >>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][3]: >>> SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse >>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>> {}}}}, "from": 0, "size": 10}]]]; nested: >>> SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse >>> Failure [No mapping found for [username.exact] in order to sort on]]; >>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][4]: >>> SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse >>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>> {}}}}, "from": 0, "size": 10}]]]; nested: >>> SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse >>> Failure [No mapping found for [username.exact] in order to sort on]]; }]') >>> >>> >>> Guide me how to solve it >>> >>> Thanks for your help >>> >>> >>> Sheeraz >>> >>> -- >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "CommCare Developers" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to commcare-developers+unsubscribe@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >>

Dear all,

I read through /scripts/docker and saw some insights. I ran:

sudo ./scripts/docker bash
su cchq
python /mnt/commcare-hq-ro/manage.py ptop_preindex

and got this error:

ValueError: Unable to configure handler ‘accountinglog’: [Errno 30]
Read-only file system: ‘/mnt/commcare-hq-ro/commcarehq.accounting.log’
Exception KeyError: KeyError(139721164183344,) in <module ‘threading’ from
’/usr/local/lib/python2.7/threading.pyc’> ignored

Any assistance please on the format for re-indexing elasticsearch in web
container is appreciated. I will keep reading the source code and hoping to
learn more from the group.

thanks,

Euc

··· On Friday, October 14, 2016 at 3:43:16 PM UTC+1, Eucalyptus D wrote: > > Dear Sheeraz and all - > > I have a similar issue with docker setup. Re-creating the index did not > work. I believe this command should be run in the web service in docker > since Commcare is running within a container? I am learning fast just that > there is so much to learn and time is short. > > What is the correct way of running the recreation of the index? thanks, > > Euc > > > > On Thursday, October 13, 2016 at 7:48:10 AM UTC+1, Sheeraz Mahmood wrote: >> >> Thanks Cory for your response >> >> First i delete the all index by using curl -XDELETE >> localhost:9200/.mar* >> then i recreate index by using ./manage.py ptop_preindex >> and it worked >> >> Thanks again >> >> Sheeraz >> >> On Monday, October 10, 2016 at 8:44:28 PM UTC+5, Cory Zue wrote: >>> >>> Hi Sheeraz, >>> >>> I would try deleting your user index on elasticsearch and then >>> reindexing it. (./manage.py ptop_preindex). This may be due to a stale >>> mapping file in elasticsearch. >>> >>> On Mon, Oct 10, 2016 at 5:05 AM, Sheeraz Mahmood wrote: >>> >>>> Hi everyone, >>>> >>>> >>>> I have installed comm-care HQ on Ubuntu 14.04. I am using Docker to run >>>> server >>>> when I created mobile user it create successfully when I click to show >>>> active mobile user it shows me following error >>>> >>>> >>>> On web >>>> >>>> >>>> There was an issue contacting the server. Please check your internet >>>> connection. If this issue continues, please file a bug report. >>>> >>>> >>>> On Terminal it shows me >>>> >>>> >>>> web_1 | File "/mnt/commcare-hq/corehq/elastic.py", line 166, in >>>> run_query >>>> web_1 | raise ESError(e) >>>> web_1 | ESError: TransportError(400, >>>> u'SearchPhaseExecutionException[Failed to execute phase [query], all shards >>>> failed; shardFailures {[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][0]: >>>> SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse >>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>> SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse >>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][1]: >>>> SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse >>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>> SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse >>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][2]: >>>> SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse >>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>> SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse >>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][3]: >>>> SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse >>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>> SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse >>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][4]: >>>> SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse >>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>> SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse >>>> Failure [No mapping found for [username.exact] in order to sort on]]; }]') >>>> >>>> >>>> Guide me how to solve it >>>> >>>> Thanks for your help >>>> >>>> >>>> Sheeraz >>>> >>>> -- >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "CommCare Developers" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to commcare-developers+unsubscribe@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>>

Dear all,

I read through docker documentation and got some insights.

ran: “scripts/docker bash web” to connect to web container and ran “python
manage.py ptop_preindex” from /mnt/lib to rebuild the index.

Mobile users now load correctly. Next problem is with kafka generating
errors when I set locations for mobile users. I am getting closer
gradually. thanks all for the support.

Euc

··· On Friday, October 14, 2016 at 4:33:10 PM UTC+1, Eucalyptus D wrote: > > Dear all, > > I read through /scripts/docker and saw some insights. I ran: > > sudo ./scripts/docker bash > su cchq > python /mnt/commcare-hq-ro/manage.py ptop_preindex > > and got this error: > > ValueError: Unable to configure handler 'accountinglog': [Errno 30] > Read-only file system: '/mnt/commcare-hq-ro/commcarehq.accounting.log' > Exception KeyError: KeyError(139721164183344,) in '/usr/local/lib/python2.7/threading.pyc'> ignored > > Any assistance please on the format for re-indexing elasticsearch in web > container is appreciated. I will keep reading the source code and hoping to > learn more from the group. > > thanks, > > Euc > > On Friday, October 14, 2016 at 3:43:16 PM UTC+1, Eucalyptus D wrote: >> >> Dear Sheeraz and all - >> >> I have a similar issue with docker setup. Re-creating the index did not >> work. I believe this command should be run in the web service in docker >> since Commcare is running within a container? I am learning fast just that >> there is so much to learn and time is short. >> >> What is the correct way of running the recreation of the index? thanks, >> >> Euc >> >> >> >> On Thursday, October 13, 2016 at 7:48:10 AM UTC+1, Sheeraz Mahmood wrote: >>> >>> Thanks Cory for your response >>> >>> First i delete the all index by using curl -XDELETE >>> localhost:9200/.mar* >>> then i recreate index by using ./manage.py ptop_preindex >>> and it worked >>> >>> Thanks again >>> >>> Sheeraz >>> >>> On Monday, October 10, 2016 at 8:44:28 PM UTC+5, Cory Zue wrote: >>>> >>>> Hi Sheeraz, >>>> >>>> I would try deleting your user index on elasticsearch and then >>>> reindexing it. (./manage.py ptop_preindex). This may be due to a stale >>>> mapping file in elasticsearch. >>>> >>>> On Mon, Oct 10, 2016 at 5:05 AM, Sheeraz Mahmood wrote: >>>> >>>>> Hi everyone, >>>>> >>>>> >>>>> I have installed comm-care HQ on Ubuntu 14.04. I am using Docker to >>>>> run server >>>>> when I created mobile user it create successfully when I click to show >>>>> active mobile user it shows me following error >>>>> >>>>> >>>>> On web >>>>> >>>>> >>>>> There was an issue contacting the server. Please check your internet >>>>> connection. If this issue continues, please file a bug report. >>>>> >>>>> >>>>> On Terminal it shows me >>>>> >>>>> >>>>> web_1 | File "/mnt/commcare-hq/corehq/elastic.py", line 166, in >>>>> run_query >>>>> web_1 | raise ESError(e) >>>>> web_1 | ESError: TransportError(400, >>>>> u'SearchPhaseExecutionException[Failed to execute phase [query], all shards >>>>> failed; shardFailures {[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][0]: >>>>> SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse >>>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>>> SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse >>>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][1]: >>>>> SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse >>>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>>> SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse >>>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][2]: >>>>> SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse >>>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>>> SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse >>>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][3]: >>>>> SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse >>>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>>> SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse >>>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][4]: >>>>> SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse >>>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>>> SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse >>>>> Failure [No mapping found for [username.exact] in order to sort on]]; }]') >>>>> >>>>> >>>>> Guide me how to solve it >>>>> >>>>> Thanks for your help >>>>> >>>>> >>>>> Sheeraz >>>>> >>>>> -- >>>>> >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "CommCare Developers" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to commcare-developers+unsubscribe@googlegroups.com. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>>

apologies, manage.py is run from /mnt/commcare in the web container and not
from /mnt/lib.

··· On Sunday, October 16, 2016 at 10:40:42 PM UTC+1, Eucalyptus D wrote: > > Dear all, > > I read through docker documentation and got some insights. > > ran: "scripts/docker bash web" to connect to web container and ran "python > manage.py ptop_preindex" from /mnt/lib to rebuild the index. > > Mobile users now load correctly. Next problem is with kafka generating > errors when I set locations for mobile users. I am getting closer > gradually. thanks all for the support. > > Euc > > > On Friday, October 14, 2016 at 4:33:10 PM UTC+1, Eucalyptus D wrote: >> >> Dear all, >> >> I read through /scripts/docker and saw some insights. I ran: >> >> sudo ./scripts/docker bash >> su cchq >> python /mnt/commcare-hq-ro/manage.py ptop_preindex >> >> and got this error: >> >> ValueError: Unable to configure handler 'accountinglog': [Errno 30] >> Read-only file system: '/mnt/commcare-hq-ro/commcarehq.accounting.log' >> Exception KeyError: KeyError(139721164183344,) in > from '/usr/local/lib/python2.7/threading.pyc'> ignored >> >> Any assistance please on the format for re-indexing elasticsearch in web >> container is appreciated. I will keep reading the source code and hoping to >> learn more from the group. >> >> thanks, >> >> Euc >> >> On Friday, October 14, 2016 at 3:43:16 PM UTC+1, Eucalyptus D wrote: >>> >>> Dear Sheeraz and all - >>> >>> I have a similar issue with docker setup. Re-creating the index did not >>> work. I believe this command should be run in the web service in docker >>> since Commcare is running within a container? I am learning fast just that >>> there is so much to learn and time is short. >>> >>> What is the correct way of running the recreation of the index? thanks, >>> >>> Euc >>> >>> >>> >>> On Thursday, October 13, 2016 at 7:48:10 AM UTC+1, Sheeraz Mahmood wrote: >>>> >>>> Thanks Cory for your response >>>> >>>> First i delete the all index by using curl -XDELETE >>>> localhost:9200/.mar* >>>> then i recreate index by using ./manage.py ptop_preindex >>>> and it worked >>>> >>>> Thanks again >>>> >>>> Sheeraz >>>> >>>> On Monday, October 10, 2016 at 8:44:28 PM UTC+5, Cory Zue wrote: >>>>> >>>>> Hi Sheeraz, >>>>> >>>>> I would try deleting your user index on elasticsearch and then >>>>> reindexing it. (./manage.py ptop_preindex). This may be due to a stale >>>>> mapping file in elasticsearch. >>>>> >>>>> On Mon, Oct 10, 2016 at 5:05 AM, Sheeraz Mahmood >>>> >>>>>> Hi everyone, >>>>>> >>>>>> >>>>>> I have installed comm-care HQ on Ubuntu 14.04. I am using Docker to >>>>>> run server >>>>>> when I created mobile user it create successfully when I click to >>>>>> show active mobile user it shows me following error >>>>>> >>>>>> >>>>>> On web >>>>>> >>>>>> >>>>>> There was an issue contacting the server. Please check your internet >>>>>> connection. If this issue continues, please file a bug report. >>>>>> >>>>>> >>>>>> On Terminal it shows me >>>>>> >>>>>> >>>>>> web_1 | File "/mnt/commcare-hq/corehq/elastic.py", line 166, in >>>>>> run_query >>>>>> web_1 | raise ESError(e) >>>>>> web_1 | ESError: TransportError(400, >>>>>> u'SearchPhaseExecutionException[Failed to execute phase [query], all shards >>>>>> failed; shardFailures {[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][0]: >>>>>> SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse >>>>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>>>> SearchParseException[[hqusers_2016-07-19][0]: from[-1],size[-1]: Parse >>>>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][1]: >>>>>> SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse >>>>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>>>> SearchParseException[[hqusers_2016-07-19][1]: from[-1],size[-1]: Parse >>>>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][2]: >>>>>> SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse >>>>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>>>> SearchParseException[[hqusers_2016-07-19][2]: from[-1],size[-1]: Parse >>>>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][3]: >>>>>> SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse >>>>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>>>> SearchParseException[[hqusers_2016-07-19][3]: from[-1],size[-1]: Parse >>>>>> Failure [No mapping found for [username.exact] in order to sort on]]; >>>>>> }{[GjZ8wYKWQySlDNecNxYniQ][hqusers_2016-07-19][4]: >>>>>> SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse >>>>>> Failure [Failed to parse source [{"sort": {"username.exact": {"order": >>>>>> "asc"}}, "query": {"filtered": {"filter": {"and": [{"or": [{"term": >>>>>> {"domain.exact": "test"}}, {"term": {"domain_memberships.domain.exact": >>>>>> "test"}}]}, {"term": {"doc_type": "CommCareUser"}}, {"term": {"is_active": >>>>>> false}}, {"term": {"base_doc": "couchuser"}}]}, "query": {"match_all": >>>>>> {}}}}, "from": 0, "size": 10}]]]; nested: >>>>>> SearchParseException[[hqusers_2016-07-19][4]: from[-1],size[-1]: Parse >>>>>> Failure [No mapping found for [username.exact] in order to sort on]]; }]') >>>>>> >>>>>> >>>>>> Guide me how to solve it >>>>>> >>>>>> Thanks for your help >>>>>> >>>>>> >>>>>> Sheeraz >>>>>> >>>>>> -- >>>>>> >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "CommCare Developers" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to commcare-developers+unsubscribe@googlegroups.com. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>>