Pillowtop output: No command set, please see --help for runtime instructions

Dear Cory and all,

So I took a break and re-tried after a while and no errors. Everything was
properly installed and running but I do not have data or reports. They are
empty.

Supervisor runs defined processes. commcarehq-prod-pillowtop- logs the
following in /tmp/pillowtop-.log:

No command set, please see --help for runtime instructions

Here is the config
in /home/commcarehq/commcare-hq/services/supervisor/changeme_supervisor_pillowtop.conf:

[program:commcarehq-prod-pillowtop-]
command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop
directory=/home/commcarehq/commcare-hq/
user=commcarehq
numprocs=1
autostart=true
autorestart=true
stdout_logfile=/tmp/pillowtop-.log
redirect_stderr=true
stderr_logfile=/tmp/pillowtop-.error.log
startsecs=10
; Need to wait for currently executing tasks to finish at shutdown.
; Increase this if you have very long running tasks.
stopwaitsecs = 10
; if rabbitmq is supervised, set its priority higher
; so it starts first
priority=998

kindly assist. regards.

Euc

Hey,

I think maybe try changing this line:

command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop

to

command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop --all

cheers,
Cory

··· On Thu, Dec 1, 2016 at 7:36 PM, Eucalyptus D wrote:

Dear Cory and all,

So I took a break and re-tried after a while and no errors. Everything was
properly installed and running but I do not have data or reports. They are
empty.

Supervisor runs defined processes. commcarehq-prod-pillowtop- logs the
following in /tmp/pillowtop-.log:

No command set, please see --help for runtime instructions

Here is the config in /home/commcarehq/commcare-hq/services/supervisor/
changeme_supervisor_pillowtop.conf:

[program:commcarehq-prod-pillowtop-]
command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop
directory=/home/commcarehq/commcare-hq/
user=commcarehq
numprocs=1
autostart=true
autorestart=true
stdout_logfile=/tmp/pillowtop-.log
redirect_stderr=true
stderr_logfile=/tmp/pillowtop-.error.log
startsecs=10
; Need to wait for currently executing tasks to finish at shutdown.
; Increase this if you have very long running tasks.
stopwaitsecs = 10
; if rabbitmq is supervised, set its priority higher
; so it starts first
priority=998

kindly assist. regards.

Euc


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 Cory,

I did and the errors are back: OperationalError: SSL SYSCALL error: EOF
detected

2016-12-02 22:11:03,082 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:03,085 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:03,086 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:02,768 ERROR Notify Exception: processor error in pillow
CaseTo
ElasticsearchPillow SSL SYSCALL error: EOF detected
Traceback (most recent call last):
File
"/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

     face.py", line 94, in process_changes
self.process_with_error_handling(change)

File
"/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

     face.py", line 111, in process_with_error_handling
handle_pillow_error(self, change, ex)

File
"/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

     face.py", line 179, in handle_pillow_error
error = PillowError.get_or_create(change, pillow)

File
"/home/commcarehq/commcare-hq/corehq/ex-submodules/pillow_retry/models.py

     ", line 88, in get_or_create
error = cls.objects.get(doc_id=doc_id, pillow=pillow.pillow_id)

File
"/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/mana

     ger.py", line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)

File
"/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

     y.py", line 328, in get
num = len(clone)

File
"/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

     y.py", line 144, in __len__
self._fetch_all()

File
"/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

     y.py", line 965, in _fetch_all
self._result_cache = list(self.iterator())

File
"/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

     y.py", line 238, in iterator
results = compiler.execute_sql()

File
"/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/sql/

     compiler.py", line 840, in execute_sql
cursor.execute(sql, params)

File
"/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

     ils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)

File
"/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

     ils.py", line 64, in execute
return self.cursor.execute(sql, params)

File
"/home/commcarehq/local/lib/python2.7/site-packages/django/db/utils.py",

      line 98, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)

File
"/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

     ils.py", line 64, in execute
return self.cursor.execute(sql, params)

OperationalError: SSL SYSCALL error: EOF detected

The database logs: commcarehq@commcarehq LOG: SSL error: decryption failed
or bad record mac

back to where I started from. Any leads? thanks

··· On Friday, December 2, 2016 at 5:44:53 PM UTC+1, Cory Zue wrote: > > Hey, > > I think maybe try changing this line: > > command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py > run_ptop > > to > > command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py > run_ptop --all > > cheers, > Cory > > On Thu, Dec 1, 2016 at 7:36 PM, Eucalyptus D <eucal...@me.net.ng > wrote: > >> Dear Cory and all, >> >> So I took a break and re-tried after a while and no errors. Everything >> was properly installed and running but I do not have data or reports. They >> are empty. >> >> Supervisor runs defined processes. commcarehq-prod-pillowtop- logs the >> following in /tmp/pillowtop-.log: >> >> No command set, please see --help for runtime instructions >> >> Here is the config >> in /home/commcarehq/commcare-hq/services/supervisor/changeme_supervisor_pillowtop.conf: >> >> [program:commcarehq-prod-pillowtop-] >> command=/home/commcarehq/bin/python >> /home/commcarehq/commcare-hq/manage.py run_ptop >> directory=/home/commcarehq/commcare-hq/ >> user=commcarehq >> numprocs=1 >> autostart=true >> autorestart=true >> stdout_logfile=/tmp/pillowtop-.log >> redirect_stderr=true >> stderr_logfile=/tmp/pillowtop-.error.log >> startsecs=10 >> ; Need to wait for currently executing tasks to finish at shutdown. >> ; Increase this if you have very long running tasks. >> stopwaitsecs = 10 >> ; if rabbitmq is supervised, set its priority higher >> ; so it starts first >> priority=998 >> >> kindly assist. regards. >> >> Euc >> >> -- >> >> --- >> 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. >> > >

Hey Eucalyptus,

This looks like the same error you were encountering on the last thread
https://groups.google.com/forum/#!topic/commcare-developers/EWLcDCLU4VY.

Like I mentioned, I’d check postgres logs and just google the errors and
see what comes up.

Cory

··· On Sat, Dec 3, 2016 at 9:24 PM, Eucalyptus D wrote:

Dear Cory,

I did and the errors are back: OperationalError: SSL SYSCALL error: EOF
detected

2016-12-02 22:11:03,082 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:03,085 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:03,086 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:02,768 ERROR Notify Exception: processor error in pillow
CaseTo
ElasticsearchPillow SSL SYSCALL error: EOF detected
Traceback (most recent call last):
File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

       face.py", line 94, in process_changes
self.process_with_error_handling(change)

File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

       face.py", line 111, in process_with_error_handling
handle_pillow_error(self, change, ex)

File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

       face.py", line 179, in handle_pillow_error
error = PillowError.get_or_create(change, pillow)

File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillow_retry/models.py

       ", line 88, in get_or_create
error = cls.objects.get(doc_id=doc_id, pillow=pillow.pillow_id)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/mana

       ger.py", line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 328, in get
num = len(clone)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 144, in __len__
self._fetch_all()

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 965, in _fetch_all
self._result_cache = list(self.iterator())

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 238, in iterator
results = compiler.execute_sql()

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/sql/

       compiler.py", line 840, in execute_sql
cursor.execute(sql, params)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

       ils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

       ils.py", line 64, in execute
return self.cursor.execute(sql, params)

File “/home/commcarehq/local/lib/python2.7/site-packages/django/db/utils.py”,

        line 98, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

       ils.py", line 64, in execute
return self.cursor.execute(sql, params)

OperationalError: SSL SYSCALL error: EOF detected

The database logs: commcarehq@commcarehq LOG: SSL error: decryption
failed or bad record mac

back to where I started from. Any leads? thanks

On Friday, December 2, 2016 at 5:44:53 PM UTC+1, Cory Zue wrote:

Hey,

I think maybe try changing this line:

command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop

to

command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop --all

cheers,
Cory

On Thu, Dec 1, 2016 at 7:36 PM, Eucalyptus D eucal...@me.net.ng wrote:

Dear Cory and all,

So I took a break and re-tried after a while and no errors. Everything
was properly installed and running but I do not have data or reports. They
are empty.

Supervisor runs defined processes. commcarehq-prod-pillowtop- logs the
following in /tmp/pillowtop-.log:

No command set, please see --help for runtime instructions

Here is the config in /home/commcarehq/commcare-h
q/services/supervisor/changeme_supervisor_pillowtop.conf:

[program:commcarehq-prod-pillowtop-]
command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop
directory=/home/commcarehq/commcare-hq/
user=commcarehq
numprocs=1
autostart=true
autorestart=true
stdout_logfile=/tmp/pillowtop-.log
redirect_stderr=true
stderr_logfile=/tmp/pillowtop-.error.log
startsecs=10
; Need to wait for currently executing tasks to finish at shutdown.
; Increase this if you have very long running tasks.
stopwaitsecs = 10
; if rabbitmq is supervised, set its priority higher
; so it starts first
priority=998

kindly assist. regards.

Euc


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.


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 Cory,

postgres logs: commcarehq@commcarehq LOG: SSL error: decryption failed or
bad record mac

Can I use another database with Commcare? is there a preferred version of
postgres recommended for the deployment?

thanks.

Euc

··· On Sun, Dec 4, 2016 at 6:59 AM, Cory Zue wrote:

Hey Eucalyptus,

This looks like the same error you were encountering on the last thread
https://groups.google.com/forum/#!topic/commcare-developers/EWLcDCLU4VY.

Like I mentioned, I’d check postgres logs and just google the errors and
see what comes up.

Cory

On Sat, Dec 3, 2016 at 9:24 PM, Eucalyptus D eucalyptus@me.net.ng wrote:

Dear Cory,

I did and the errors are back: OperationalError: SSL SYSCALL error: EOF
detected

2016-12-02 22:11:03,082 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:03,085 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:03,086 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:02,768 ERROR Notify Exception: processor error in pillow
CaseTo
ElasticsearchPillow SSL SYSCALL error: EOF detected
Traceback (most recent call last):
File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

       face.py", line 94, in process_changes
self.process_with_error_handling(change)

File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

       face.py", line 111, in process_with_error_handling
handle_pillow_error(self, change, ex)

File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

       face.py", line 179, in handle_pillow_error
error = PillowError.get_or_create(change, pillow)

File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillow_retry/models.py

       ", line 88, in get_or_create
error = cls.objects.get(doc_id=doc_id, pillow=pillow.pillow_id)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/mana

       ger.py", line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 328, in get
num = len(clone)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 144, in __len__
self._fetch_all()

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 965, in _fetch_all
self._result_cache = list(self.iterator())

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 238, in iterator
results = compiler.execute_sql()

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/sql/

       compiler.py", line 840, in execute_sql
cursor.execute(sql, params)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

       ils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

       ils.py", line 64, in execute
return self.cursor.execute(sql, params)

File “/home/commcarehq/local/lib/python2.7/site-packages/django/db/utils.py”,

        line 98, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

       ils.py", line 64, in execute
return self.cursor.execute(sql, params)

OperationalError: SSL SYSCALL error: EOF detected

The database logs: commcarehq@commcarehq LOG: SSL error: decryption
failed or bad record mac

back to where I started from. Any leads? thanks

On Friday, December 2, 2016 at 5:44:53 PM UTC+1, Cory Zue wrote:

Hey,

I think maybe try changing this line:

command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop

to

command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop --all

cheers,
Cory

On Thu, Dec 1, 2016 at 7:36 PM, Eucalyptus D eucal...@me.net.ng wrote:

Dear Cory and all,

So I took a break and re-tried after a while and no errors. Everything
was properly installed and running but I do not have data or reports. They
are empty.

Supervisor runs defined processes. commcarehq-prod-pillowtop- logs the
following in /tmp/pillowtop-.log:

No command set, please see --help for runtime instructions

Here is the config in /home/commcarehq/commcare-h
q/services/supervisor/changeme_supervisor_pillowtop.conf:

[program:commcarehq-prod-pillowtop-]
command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop
directory=/home/commcarehq/commcare-hq/
user=commcarehq
numprocs=1
autostart=true
autorestart=true
stdout_logfile=/tmp/pillowtop-.log
redirect_stderr=true
stderr_logfile=/tmp/pillowtop-.error.log
startsecs=10
; Need to wait for currently executing tasks to finish at shutdown.
; Increase this if you have very long running tasks.
stopwaitsecs = 10
; if rabbitmq is supervised, set its priority higher
; so it starts first
priority=998

kindly assist. regards.

Euc


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.


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.


You received this message because you are subscribed to a topic in the
Google Groups “CommCare Developers” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-developers/kiJfNmpM0Sc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

We use Postgres 9.4.10. I would not recommend using another database as we
haven’t ever deployed on anything else. It seems unlikely to me that the
issue is with postgres itself, but rather with your configuration or how
you are accessing it.

··· On Sun, Dec 4, 2016 at 8:32 AM, Eucalyptus Deglupta wrote:

Dear Cory,

postgres logs: commcarehq@commcarehq LOG: SSL error: decryption failed
or bad record mac

Can I use another database with Commcare? is there a preferred version of
postgres recommended for the deployment?

thanks.

Euc

On Sun, Dec 4, 2016 at 6:59 AM, Cory Zue czue@dimagi.com wrote:

Hey Eucalyptus,

This looks like the same error you were encountering on the last thread
https://groups.google.com/forum/#!topic/commcare-developers/EWLcDCLU4VY
.

Like I mentioned, I’d check postgres logs and just google the errors and
see what comes up.

Cory

On Sat, Dec 3, 2016 at 9:24 PM, Eucalyptus D eucalyptus@me.net.ng wrote:

Dear Cory,

I did and the errors are back: OperationalError: SSL SYSCALL error: EOF
detected

2016-12-02 22:11:03,082 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:03,085 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:03,086 INFO interface Starting pillow <class
’pillowtop.pillow.
interface.ConstructedPillow’>
2016-12-02 22:11:02,768 ERROR Notify Exception: processor error in
pillow CaseTo
ElasticsearchPillow SSL SYSCALL error: EOF detected
Traceback (most recent call last):
File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

       face.py", line 94, in process_changes
self.process_with_error_handling(change)

File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

       face.py", line 111, in process_with_error_handling
handle_pillow_error(self, change, ex)

File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter

       face.py", line 179, in handle_pillow_error
error = PillowError.get_or_create(change, pillow)

File "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillow_retry/models.py

       ", line 88, in get_or_create
error = cls.objects.get(doc_id=doc_id, pillow=pillow.pillow_id)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/mana

       ger.py", line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 328, in get
num = len(clone)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 144, in __len__
self._fetch_all()

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 965, in _fetch_all
self._result_cache = list(self.iterator())

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer

       y.py", line 238, in iterator
results = compiler.execute_sql()

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/sql/

       compiler.py", line 840, in execute_sql
cursor.execute(sql, params)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

       ils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

       ils.py", line 64, in execute
return self.cursor.execute(sql, params)

File “/home/commcarehq/local/lib/python2.7/site-packages/django/db/utils.py”,

        line 98, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)

File "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut

       ils.py", line 64, in execute
return self.cursor.execute(sql, params)

OperationalError: SSL SYSCALL error: EOF detected

The database logs: commcarehq@commcarehq LOG: SSL error: decryption
failed or bad record mac

back to where I started from. Any leads? thanks

On Friday, December 2, 2016 at 5:44:53 PM UTC+1, Cory Zue wrote:

Hey,

I think maybe try changing this line:

command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop

to

command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop --all

cheers,
Cory

On Thu, Dec 1, 2016 at 7:36 PM, Eucalyptus D eucal...@me.net.ng wrote:

Dear Cory and all,

So I took a break and re-tried after a while and no errors. Everything
was properly installed and running but I do not have data or reports. They
are empty.

Supervisor runs defined processes. commcarehq-prod-pillowtop- logs
the following in /tmp/pillowtop-.log:

No command set, please see --help for runtime instructions

Here is the config in /home/commcarehq/commcare-h
q/services/supervisor/changeme_supervisor_pillowtop.conf:

[program:commcarehq-prod-pillowtop-]
command=/home/commcarehq/bin/python /home/commcarehq/commcare-hq/manage.py
run_ptop
directory=/home/commcarehq/commcare-hq/
user=commcarehq
numprocs=1
autostart=true
autorestart=true
stdout_logfile=/tmp/pillowtop-.log
redirect_stderr=true
stderr_logfile=/tmp/pillowtop-.error.log
startsecs=10
; Need to wait for currently executing tasks to finish at shutdown.
; Increase this if you have very long running tasks.
stopwaitsecs = 10
; if rabbitmq is supervised, set its priority higher
; so it starts first
priority=998

kindly assist. regards.

Euc


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.


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.


You received this message because you are subscribed to a topic in the
Google Groups “CommCare Developers” group.
To unsubscribe from this topic, visit https://groups.google.com/d/to
pic/commcare-developers/kiJfNmpM0Sc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


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 Cory,

Same issue, I am depressed now. I seem to run into same issue with all
deployment options… I followed the instructions step by step. I wonder
what may be wrong. I have read lots of source code and can’t see anything
off. Any angels out there? help a bro.

··· On Sunday, December 4, 2016 at 7:39:24 AM UTC+1, Cory Zue wrote: > > We use Postgres 9.4.10. I would not recommend using another database as we > haven't ever deployed on anything else. It seems unlikely to me that the > issue is with postgres itself, but rather with your configuration or how > you are accessing it. > > On Sun, Dec 4, 2016 at 8:32 AM, Eucalyptus Deglupta <eucal...@me.net.ng > wrote: > >> Dear Cory, >> >> postgres logs: commcarehq@commcarehq LOG: SSL error: decryption failed >> or bad record mac >> >> Can I use another database with Commcare? is there a preferred version of >> postgres recommended for the deployment? >> >> thanks. >> >> Euc >> >> On Sun, Dec 4, 2016 at 6:59 AM, Cory Zue <cz...@dimagi.com > wrote: >> >>> Hey Eucalyptus, >>> >>> This looks like the same error you were encountering on the last thread >>> >>> . >>> >>> Like I mentioned, I'd check postgres logs and just google the errors and >>> see what comes up. >>> >>> Cory >>> >>> >>> On Sat, Dec 3, 2016 at 9:24 PM, Eucalyptus D <eucal...@me.net.ng > wrote: >>> >>>> Dear Cory, >>>> >>>> I did and the errors are back: OperationalError: SSL SYSCALL error: EOF >>>> detected >>>> >>>> 2016-12-02 22:11:03,082 INFO interface Starting pillow >>> 'pillowtop.pillow. >>>> interface.ConstructedPillow'> >>>> 2016-12-02 22:11:03,085 INFO interface Starting pillow >>> 'pillowtop.pillow. >>>> interface.ConstructedPillow'> >>>> 2016-12-02 22:11:03,086 INFO interface Starting pillow >>> 'pillowtop.pillow. >>>> interface.ConstructedPillow'> >>>> 2016-12-02 22:11:02,768 ERROR Notify Exception: processor error in >>>> pillow CaseTo >>>> ElasticsearchPillow SSL SYSCALL error: EOF detected >>>> Traceback (most recent call last): >>>> File >>>> "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter >>>> >>>> face.py", line 94, in process_changes >>>> self.process_with_error_handling(change) >>>> File >>>> "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter >>>> >>>> face.py", line 111, in process_with_error_handling >>>> handle_pillow_error(self, change, ex) >>>> File >>>> "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillowtop/pillow/inter >>>> >>>> face.py", line 179, in handle_pillow_error >>>> error = PillowError.get_or_create(change, pillow) >>>> File >>>> "/home/commcarehq/commcare-hq/corehq/ex-submodules/pillow_retry/models.py >>>> >>>> ", line 88, in get_or_create >>>> error = cls.objects.get(doc_id=doc_id, pillow=pillow.pillow_id) >>>> File >>>> "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/mana >>>> >>>> ger.py", line 127, in manager_method >>>> return getattr(self.get_queryset(), name)(*args, **kwargs) >>>> File >>>> "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer >>>> >>>> y.py", line 328, in get >>>> num = len(clone) >>>> File >>>> "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer >>>> >>>> y.py", line 144, in __len__ >>>> self._fetch_all() >>>> File >>>> "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer >>>> >>>> y.py", line 965, in _fetch_all >>>> self._result_cache = list(self.iterator()) >>>> File >>>> "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/quer >>>> >>>> y.py", line 238, in iterator >>>> results = compiler.execute_sql() >>>> File >>>> "/home/commcarehq/local/lib/python2.7/site-packages/django/db/models/sql/ >>>> >>>> compiler.py", line 840, in execute_sql >>>> cursor.execute(sql, params) >>>> File >>>> "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut >>>> >>>> ils.py", line 79, in execute >>>> return super(CursorDebugWrapper, self).execute(sql, params) >>>> File >>>> "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut >>>> >>>> ils.py", line 64, in execute >>>> return self.cursor.execute(sql, params) >>>> File >>>> "/home/commcarehq/local/lib/python2.7/site-packages/django/db/utils.py", >>>> >>>> line 98, in __exit__ >>>> six.reraise(dj_exc_type, dj_exc_value, traceback) >>>> File >>>> "/home/commcarehq/local/lib/python2.7/site-packages/django/db/backends/ut >>>> >>>> ils.py", line 64, in execute >>>> return self.cursor.execute(sql, params) >>>> OperationalError: SSL SYSCALL error: EOF detected >>>> >>>> The database logs: commcarehq@commcarehq LOG: SSL error: decryption >>>> failed or bad record mac >>>> >>>> back to where I started from. Any leads? thanks >>>> >>>> On Friday, December 2, 2016 at 5:44:53 PM UTC+1, Cory Zue wrote: >>>>> >>>>> Hey, >>>>> >>>>> I think maybe try changing this line: >>>>> >>>>> command=/home/commcarehq/bin/python >>>>> /home/commcarehq/commcare-hq/manage.py run_ptop >>>>> >>>>> to >>>>> >>>>> command=/home/commcarehq/bin/python >>>>> /home/commcarehq/commcare-hq/manage.py run_ptop --all >>>>> >>>>> cheers, >>>>> Cory >>>>> >>>>> On Thu, Dec 1, 2016 at 7:36 PM, Eucalyptus D wrote: >>>>> >>>>>> Dear Cory and all, >>>>>> >>>>>> So I took a break and re-tried after a while and no errors. >>>>>> Everything was properly installed and running but I do not have data or >>>>>> reports. They are empty. >>>>>> >>>>>> Supervisor runs defined processes. commcarehq-prod-pillowtop- logs >>>>>> the following in /tmp/pillowtop-.log: >>>>>> >>>>>> No command set, please see --help for runtime instructions >>>>>> >>>>>> Here is the config >>>>>> in /home/commcarehq/commcare-hq/services/supervisor/changeme_supervisor_pillowtop.conf: >>>>>> >>>>>> [program:commcarehq-prod-pillowtop-] >>>>>> command=/home/commcarehq/bin/python >>>>>> /home/commcarehq/commcare-hq/manage.py run_ptop >>>>>> directory=/home/commcarehq/commcare-hq/ >>>>>> user=commcarehq >>>>>> numprocs=1 >>>>>> autostart=true >>>>>> autorestart=true >>>>>> stdout_logfile=/tmp/pillowtop-.log >>>>>> redirect_stderr=true >>>>>> stderr_logfile=/tmp/pillowtop-.error.log >>>>>> startsecs=10 >>>>>> ; Need to wait for currently executing tasks to finish at shutdown. >>>>>> ; Increase this if you have very long running tasks. >>>>>> stopwaitsecs = 10 >>>>>> ; if rabbitmq is supervised, set its priority higher >>>>>> ; so it starts first >>>>>> priority=998 >>>>>> >>>>>> kindly assist. regards. >>>>>> >>>>>> Euc >>>>>> >>>>>> -- >>>>>> >>>>>> --- >>>>>> 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. >>>>>> >>>>> >>>>> -- >>>> >>>> --- >>>> 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. >>>> >>> >>> -- >>> >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "CommCare Developers" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/commcare-developers/kiJfNmpM0Sc/unsubscribe >>> . >>> To unsubscribe from this group and all its topics, send an email to >>> commcare-developers+unsubscribe@googlegroups.com . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> >> --- >> 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. >> > >