Skip to content

Bug in user's statistics computation #104

@U039b

Description

@U039b
django_1         | ERROR 2023-05-09 16:15:15,131 log 23 139668642068224 Internal Server Error: /stats
django_1         | Traceback (most recent call last):
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
django_1         |     return self.cursor.execute(sql, params)
django_1         | psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block
django_1         | 
django_1         | 
django_1         | The above exception was the direct cause of the following exception:
django_1         | 
django_1         | Traceback (most recent call last):
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/core/handlers/exception.py", line 47, in inner
django_1         |     response = get_response(request)
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/core/handlers/base.py", line 181, in _get_response
django_1         |     response = wrapped_callback(request, *callback_args, **callback_kwargs)
django_1         |   File "/usr/local/lib/python3.9/contextlib.py", line 79, in inner
django_1         |     return func(*args, **kwds)
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/contrib/auth/decorators.py", line 21, in _wrapped_view
django_1         |     return view_func(request, *args, **kwargs)
django_1         |   File "/app/video_downloading_platform/core/views.py", line 607, in statistics_view
django_1         |     'user_stats': __get_user_stats(),
django_1         |   File "/app/video_downloading_platform/core/views.py", line 528, in __get_user_stats
django_1         |     'collections': Batch.objects.filter(owner=user).count(),
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/db/models/query.py", line 411, in count
django_1         |     return self.query.get_count(using=self.db)
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/db/models/sql/query.py", line 517, in get_count
django_1         |     number = obj.get_aggregation(using, ['__count'])['__count']
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/db/models/sql/query.py", line 502, in get_aggregation
django_1         |     result = compiler.execute_sql(SINGLE)
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
django_1         |     cursor.execute(sql, params)
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
django_1         |     return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
django_1         |     return executor(sql, params, many, context)
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
django_1         |     return self.cursor.execute(sql, params)
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
django_1         |     raise dj_exc_value.with_traceback(traceback) from exc_value
django_1         |   File "/usr/local/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
django_1         |     return self.cursor.execute(sql, params)
django_1         | django.db.utils.InternalError: current transaction is aborted, commands ignored until end of transaction block

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions