#35368: Postgres schema test failure locally
-----------------------------------------+------------------------
Reporter: bcail | Owner: nobody
Type: Uncategorized | Status: new
Component: Uncategorized | Version: dev
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-----------------------------------------+------------------------
The error is below. I bisected to commit
888b9042b3598bab6557c62de82505eec9ea62ed where the test started failing
for me. I'm on Linux, using Postgres 15.
{{{
ERROR: test_add_generated_field
(schema.tests.SchemaTests.test_add_generated_field)
----------------------------------------------------------------------
Traceback (most recent call last):
File "/opt/local/src/django/django/db/backends/utils.py", line 103, in
_execute
return self.cursor.execute(sql)
^^^^^^^^^^^^^^^^^
psycopg2.errors.IndeterminateCollation: could not determine which
collation to use for upper() function
HINT: Use the COLLATE clause to set the collation explicitly.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/python-3.12/lib/python3.12/unittest/case.py", line 58, in
testPartExecutor
yield
File "/opt/python-3.12/lib/python3.12/unittest/case.py", line 636, in
run
self._callTestMethod(testMethod)
^^^^^^^^^^^^^^^^^
File "/opt/python-3.12/lib/python3.12/unittest/case.py", line 589, in
_callTestMethod
if method() is not None:
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/django/test/utils.py", line 446, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/django/test/testcases.py", line 1548, in
skip_wrapper
return test_func(*args, **kwargs)
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/tests/schema/tests.py", line 923, in
test_add_generated_field_contains
editor.add_field(GeneratedFieldContainsModel, field)
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/django/db/backends/base/schema.py", line
754, in add_field
self.execute(sql, params or None)
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/django/db/backends/postgresql/schema.py",
line 48, in execute
return super().execute(sql, None)
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/django/db/backends/base/schema.py", line
201, in execute
cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/django/db/backends/utils.py", line 79, in
execute
return self._execute_with_wrappers(
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/django/db/backends/utils.py", line 92, in
_execute_with_wrappers
return executor(sql, params, many, context)
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/django/db/backends/utils.py", line 100, in
_execute
with self.db.wrap_database_errors:
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/django/db/utils.py", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
^^^^^^^^^^^^^^^^^
File "/opt/local/src/django/django/db/backends/utils.py", line 103, in
_execute
return self.cursor.execute(sql)
^^^^^^^^^^^^^^^^^
django.db.utils.ProgrammingError: could not determine which collation to
use for upper() function
HINT: Use the COLLATE clause to set the collation explicitly.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35368>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/0107018ecdbd6728-7dbd8252-c606-436b-a63a-50dd69b321a6-000000%40eu-central-1.amazonses.com.
