Dear CommCare Developers community,
I’ve the latest version of commcareHQ installed in a digital ocean node
Ubuntu 14.04 server (4gb RAM):
All Service are up and running Postgresql 9.6 (the same problem with 9.4).
couchdb. Elasticsearch, kafka (0.10.1.0 and the same problem with 0.10.1.1),
zookeeper and clery are up and running.
After uploading 2-3 forms to the server I become the following errors:
1- exceptions.AttributeError --> See the log here
Doc Type: XFormInstance
Domain: endev
DB Type: form-sql
DB Name: form-sql
Is Deletion: False
Date Created: 15 Feb 2017 16:51
Date of Last Attempt: 15 Feb 2017 16:51
Date of Next Attempt: 15 Feb 2017 16:56
Pillow: AppFormSubmissionTrackerPillow
Total Attempts: 1
Current Attempt: 1
Error Type: exceptions.AttributeError
Stack Trace: can't set attribute
File "./corehq/ex-submodules/pillowtop/pillow/interface.py", line 109, in
process_with_error_handling
self.process_change(change)
File "./corehq/ex-submodules/pillowtop/pillow/interface.py", line 168, in
process_change
self._processor.process_change(self, change)
File "./corehq/ex-submodules/pillowtop/processors/form.py", line 19, in
process_change
doc = change.get_document()
File "./corehq/ex-submodules/pillowtop/feed/interface.py", line 60, in
get_document
self.document = self.document_store.get_document(self.id)
File "/home/demo/commcare-hq/corehq/form_processor/document_stores.py",
line 22, in get_document
return
self.form_accessors.get_form(doc_id).to_json(include_attachments=True)
File
"/home/demo/commcare-hq/corehq/form_processor/interfaces/dbaccessors.py",
line 111, in get_form
return self.db_accessor.get_form(form_id)
File
"/home/demo/commcare-hq/corehq/form_processor/backends/sql/dbaccessors.py",
line 233, in get_form
return FormAccessorSQL.get_forms([form_id])[0]
File
"/home/demo/commcare-hq/corehq/form_processor/backends/sql/dbaccessors.py",
line 1135, in getitem
self._fetch_all()
File
"/home/demo/commcare-hq/corehq/form_processor/backends/sql/dbaccessors.py",
line 1128, in _fetch_all
self._result_cache = list(self.queryset)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/models/query.py",
line 1253, in iter
setattr(instance, column, values[pos])
2- Database Error: error with no message from libpq... I get this error
randomly and restarting Kafka the other services didn't help. Rebooting the
server is helping but only for a 2 or 3 submissions...
Any ideas how to solve this error?
Traceback (most recent call last):
File "/usr/lib/python2.7/multiprocessing/process.py", line 258, in
_bootstrap
self.run()
File "/usr/lib/python2.7/multiprocessing/process.py", line 114, in run
self._target(*self._args, **self._kwargs)
File "./corehq/ex-submodules/pillowtop/pillow/interface.py", line 82, in
run
self.process_changes(since=self.get_last_checkpoint_sequence(),
forever=True)
File "./corehq/ex-submodules/pillowtop/pillow/interface.py", line 94, in
process_changes
self.process_with_error_handling(change)
File "./corehq/ex-submodules/pillowtop/pillow/interface.py", line 111, in
process_with_error_handling
handle_pillow_error(self, change, ex)
File "./corehq/ex-submodules/pillowtop/pillow/interface.py", line 181, in
handle_pillow_error
error.save()
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/models/base.py",
line 708, in save
force_update=force_update, update_fields=update_fields)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/models/base.py",
line 736, in save_base
updated = self._save_table(raw, cls, force_insert, force_update, using,
update_fields)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/models/base.py",
line 820, in _save_table
result = self._do_insert(cls._base_manager, using, fields, update_pk,
raw)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/models/base.py",
line 859, in _do_insert
using=using, raw=raw)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/models/manager.py",
line 122, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/models/query.py",
line 1039, in _insert
return query.get_compiler(using=using).execute_sql(return_id)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 1060, in execute_sql
cursor.execute(sql, params)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/backends/utils.py",
line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/backends/utils.py",
line 64, in execute
return self.cursor.execute(sql, params)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/utils.py",
line 95, in exit
six.reraise(dj_exc_type, dj_exc_value, traceback)
File
"/home/demo/.virtualenvs/cchq/local/lib/python2.7/site-packages/django/db/backends/utils.py",
line 64, in execute
return self.cursor.execute(sql, params)
DatabaseError: error with no message from the libpq
Any help or suggestions would be appreciated!
Thanks
-Speedy