search

altairbow / django-db-connection-pool

Database connection pool component library for Django
https://pypi.python.org/pypi/django-db-connection-pool/
MIT License
181 stars 24 forks source link

ORA-01036: illegal variable name/number #49

Closed marcuoli closed 8 months ago

marcuoli commented 1 year ago

Describe the bug Just followed the guide, restarted app, refresh the page and it raises the error: ORA-01036: illegal variable name/number

Environment

Traceback The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/core/handlers/exception.py", line 55, in inner response = get_response(request) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/core/handlers/base.py", line 197, in _get_response response = wrapped_callback(request, *callback_args, callback_kwargs) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/admin/options.py", line 688, in wrapper return self.admin_site.admin_view(view)(*args, *kwargs) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/utils/decorators.py", line 134, in _wrapper_view response = view_func(request, args, kwargs) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/views/decorators/cache.py", line 62, in _wrapper_view_func response = view_func(request, *args, *kwargs) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/admin/sites.py", line 230, in inner if not self.has_permission(request): File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/admin/sites.py", line 203, in has_permission return request.user.is_active and request.user.is_staff File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/utils/functional.py", line 266, in inner self._setup() File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/utils/functional.py", line 419, in _setup self._wrapped = self._setupfunc() File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/auth/middleware.py", line 25, in request.user = SimpleLazyObject(lambda: get_user(request)) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/auth/middleware.py", line 11, in get_user request._cached_user = auth.get_user(request) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/auth/init.py", line 191, in get_user user_id = _get_user_session_key(request) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/auth/init.py", line 60, in _get_user_session_key return get_user_model()._meta.pk.to_python(request.session[SESSION_KEY]) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/sessions/backends/base.py", line 53, in getitem return self._session[key] File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/sessions/backends/base.py", line 192, in _get_session self._session_cache = self.load() File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/sessions/backends/db.py", line 42, in load s = self._get_session_from_db() File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/contrib/sessions/backends/db.py", line 32, in _get_session_from_db return self.model.objects.get( File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/models/manager.py", line 87, in manager_method return getattr(self.get_queryset(), name)(args, **kwargs) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/models/query.py", line 633, in get num = len(clone) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/models/query.py", line 380, in len self._fetch_all() File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/models/query.py", line 1881, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/models/query.py", line 91, in iter results = compiler.execute_sql( File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1560, in execute_sql cursor.execute(sql, params) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/backends/utils.py", line 102, in execute return super().execute(sql, params) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers( File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers return executor(sql, params, many, context) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute with self.db.wrap_database_errors: File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit raise dj_exc_value.with_traceback(traceback) from exc_value File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/var/www/django_sites/django_sites_venv/lib/python3.10/site-packages/dj_db_conn_pool/core/utils.py", line 38, in execute return cursor.execute(query, parameters or []) django.db.utils.DatabaseError: ORA-01036: illegal variable name/number

Thanks !!!

altairbow commented 1 year ago

Can you provide SQL and parameters? which can help locate the problem.