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.
>>
>
>