Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgis backend broken (python 3.12.1, django==5.0.1, psycopg[binary,pool]==3.1.17, sqlalchemy==2.0.25) #57

Open
SkyHyve opened this issue Jan 16, 2024 · 1 comment

Comments

@SkyHyve
Copy link

SkyHyve commented Jan 16, 2024

Postgres backend works (except for postgis fields) but postgis backend does not. Tried to add 'server_version': '14.10' to DATABASES['default'] in django settings but does not help

portal-channels-1 | 2024-01-17 09:34:28,772 DEBUG core.py:98 dj_db_conn_pool.core.mixins.core.get_new_connection() default's pool has been created, parameter: {'pre_ping': True, 'echo': False, 'timeout': 30, 'recycle': 300, 'pool_size': 8, 'max_overflow': 32}
portal-channels-1 | 2024-01-17 09:34:28,784 DEBUG core.py:109 dj_db_conn_pool.core.mixins.core.get_new_connection() got default's connection <psycopg.Connection [IDLE] (host=postgresql database=portal) at 0x7f172b723650> from its pool
portal-channels-1 | Exception in thread django-main-thread:
portal-channels-1 | Traceback (most recent call last):
portal-channels-1 | File "/usr/local/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
portal-channels-1 | self.run()
portal-channels-1 | File "/usr/local/lib/python3.12/threading.py", line 1010, in run
portal-channels-1 | self._target(*self._args, **self._kwargs)
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/utils/autoreload.py", line 64, in wrapper
portal-channels-1 | fn(*args, **kwargs)
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/daphne/management/commands/runserver.py", line 97, in inner_run
portal-channels-1 | self.check_migrations()
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/core/management/base.py", line 574, in check_migrations
portal-channels-1 | executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
portal-channels-1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/migrations/executor.py", line 18, in init
portal-channels-1 | self.loader = MigrationLoader(self.connection)
portal-channels-1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/migrations/loader.py", line 58, in init
portal-channels-1 | self.build_graph()
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/migrations/loader.py", line 235, in build_graph
portal-channels-1 | self.applied_migrations = recorder.applied_migrations()
portal-channels-1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/migrations/recorder.py", line 89, in applied_migrations
portal-channels-1 | if self.has_table():
portal-channels-1 | ^^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/migrations/recorder.py", line 63, in has_table
portal-channels-1 | with self.connection.cursor() as cursor:
portal-channels-1 | ^^^^^^^^^^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/utils/asyncio.py", line 26, in inner
portal-channels-1 | return func(*args, **kwargs)
portal-channels-1 | ^^^^^^^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/backends/base/base.py", line 316, in cursor
portal-channels-1 | return self._cursor()
portal-channels-1 | ^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/backends/base/base.py", line 292, in _cursor
portal-channels-1 | self.ensure_connection()
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/utils/asyncio.py", line 26, in inner
portal-channels-1 | return func(*args, **kwargs)
portal-channels-1 | ^^^^^^^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/backends/base/base.py", line 275, in ensure_connection
portal-channels-1 | self.connect()
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/utils/asyncio.py", line 26, in inner
portal-channels-1 | return func(*args, **kwargs)
portal-channels-1 | ^^^^^^^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/backends/base/base.py", line 258, in connect
portal-channels-1 | self.init_connection_state()
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/backends/postgresql/base.py", line 309, in init_connection_state
portal-channels-1 | super().init_connection_state()
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/backends/base/base.py", line 225, in init_connection_state
portal-channels-1 | self.check_database_version_supported()
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/backends/base/base.py", line 196, in check_database_version_supported
portal-channels-1 | and self.get_database_version() < self.features.minimum_database_version
portal-channels-1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/backends/postgresql/base.py", line 188, in get_database_version
portal-channels-1 | return divmod(self.pg_version, 10000)
portal-channels-1 | ^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/utils/functional.py", line 47, in get
portal-channels-1 | res = instance.dict[self.name] = self.func(instance)
portal-channels-1 | ^^^^^^^^^^^^^^^^^^^
portal-channels-1 | File "/usr/local/lib/python3.12/site-packages/django/db/backends/postgresql/base.py", line 437, in pg_version
portal-channels-1 | return self.connection.info.server_version
portal-channels-1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
portal-channels-1 | AttributeError: 'dict' object has no attribute 'server_version'

@altairbow
Copy link
Owner

Which version of django-db-connection-pool are you using?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants