[GeoNode-users] ERROR:An error occurred in the current transaction. You can't execute queries until the end of the 'atomic' block.
Simone Dalmasso
simone.dalmasso at gmail.com
Thu Aug 10 00:35:46 PDT 2017
Hi, could you please file a ticket for that?
Looks like a bug.
thanks
2017-08-02 21:27 GMT+02:00 Ariel Neri <ariel.neriw at gmail.com>:
> Hi, I had this error while running "updatelayers" command (only if there
> are layers from remote-store in geoserver)
> And some users reported to have same error while uploading or deleting
> layers.
>
> Here´s the traceback:
>
>
> TransactionManagementError at /admin/layers/layer/
>
> An error occurred in the current transaction. You can't execute queries until the end of the 'atomic' block.
>
> Request Method: POST
> Request URL: http://192.168.0.56/admin/layers/layer/
> Django Version: 1.8.7
> Exception Type: TransactionManagementError
> Exception Value:
>
> An error occurred in the current transaction. You can't execute queries until the end of the 'atomic' block.
>
> Exception Location: /usr/local/lib/python2.7/dist-
> packages/django/db/backends/base/base.py in validate_no_broken_transaction,
> line 327
> Python Executable: /usr/bin/python
> Python Version: 2.7.12
> Python Path:
>
> ['/home/geonode/my_geonode',
> '/usr/lib/python2.7',
> '/usr/lib/python2.7/plat-x86_64-linux-gnu',
> '/usr/lib/python2.7/lib-tk',
> '/usr/lib/python2.7/lib-old',
> '/usr/lib/python2.7/lib-dynload',
> '/usr/local/lib/python2.7/dist-packages',
> '/usr/lib/python2.7/dist-packages',
> '/usr/lib/python2.7/dist-packages/PILcompat',
> '/var/www']
>
> Server time: Mié, 2 Ago 2017 14:25:16 -0500
> Traceback Switch to copy-and-paste view
> <http://192.168.0.56/admin/layers/layer/#>
>
> - /usr/local/lib/python2.7/dist-packages/django/core/handlers/base.py
> in get_response
> 1.
>
> response = wrapped_callback(request, *callback_args, **callback_kwargs)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/contrib/admin/
> options.py in wrapper
> 1.
>
> return self.admin_site.admin_view(view)(*args, **kwargs)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/utils/decorators.py in
> _wrapped_view
> 1.
>
> response = view_func(request, *args, **kwargs)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/views/
> decorators/cache.py in _wrapped_view_func
> 1.
>
> response = view_func(request, *args, **kwargs)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/contrib/admin/sites.py
> in inner
> 1.
>
> return view(request, *args, **kwargs)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/utils/decorators.py in
> _wrapper
> 1.
>
> return bound_func(*args, **kwargs)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/utils/decorators.py in
> _wrapped_view
> 1.
>
> response = view_func(request, *args, **kwargs)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/utils/decorators.py in
> bound_func
> 1.
>
> return func.__get__(self, type(self))(*args2, **kwargs2)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/contrib/admin/
> options.py in changelist_view
> 1.
>
> response = self.response_action(request, queryset=cl.get_queryset(request))
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/contrib/admin/
> options.py in response_action
> 1.
>
> response = func(self, request, queryset)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/contrib/admin/
> actions.py in delete_selected
> 1.
>
> queryset.delete()
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/db/models/query.py in
> delete
> 1.
>
> collector.delete()
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/db/models/deletion.py
> in delete
> 1.
>
> query.delete_batch(pk_list, self.using)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/db/models/sql/
> subqueries.py in delete_batch
> 1.
>
> self.do_query(self.get_meta().db_table, self.where, using=using)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/db/models/sql/
> subqueries.py in do_query
> 1.
>
> self.get_compiler(using).execute_sql(NO_RESULTS)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/db/models/sql/
> compiler.py in execute_sql
> 1.
>
> cursor.execute(sql, params)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py
> in execute
> 1.
>
> return super(CursorDebugWrapper, self).execute(sql, params)
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py
> in execute
> 1.
>
> self.db.validate_no_broken_transaction()
>
> ...
> ▶ Local vars <http://192.168.0.56/admin/layers/layer/#>
> - /usr/local/lib/python2.7/dist-packages/django/db/backends/
> base/base.py in validate_no_broken_transaction
> 1.
>
> if self.in_atomic_block:
>
> 2.
>
> raise TransactionManagementError(
>
> 3.
>
> "This is forbidden when an 'atomic' block is active.")
>
> 4.
>
> 5.
>
> def validate_no_broken_transaction(self):
>
> 6.
>
> if self.needs_rollback:
>
> 7.
>
> raise TransactionManagementError(
>
> 1.
>
> "An error occurred in the current transaction. You can't "
>
> ...
> 1.
>
> "execute queries until the end of the 'atomic' block.")
>
> 2.
>
> 3.
>
> # ##### Foreign key constraints checks handling #####
>
> 4.
>
> 5.
>
> @contextmanager
>
> 6.
>
> def constraint_checks_disabled(self):
>
> ▼ Local vars <http://192.168.0.56/admin/layers/layer/#>
> VariableValue
> self
>
> <django.db.backends.postgresql_psycopg2.base.DatabaseWrapper object at 0x7f5b086ae0d0>
>
>
>
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geonode-users
>
>
--
Simone
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20170810/351a6a05/attachment-0001.html>
More information about the geonode-users
mailing list