Issue while upgrading

[oscgonfer]

Running migration in a bare-metal installation, I found an issue that I am not able to fix. I am doing the upgrade before migrating to docker.

Running migrations:
  Applying part.0109_auto_20230517_1048...Redefining 'celsius' (<class 'pint.delegates.txt_defparser.plain.UnitDefinition'>)
Redefining 'fahrenheit' (<class 'pint.delegates.txt_defparser.plain.UnitDefinition'>)
Redefining 'kelvin' (<class 'pint.delegates.txt_defparser.plain.UnitDefinition'>)
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/dist-packages/psycopg/cursor.py", line 732, in execute
    raise ex.with_traceback(None)
psycopg.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

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

Traceback (most recent call last):
  File "/home/InvenTree/InvenTree/manage.py", line 24, in <module>
    main()
  File "/home/InvenTree/InvenTree/manage.py", line 20, in main
    execute_from_command_line(sys.argv)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 436, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 412, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 458, in execute
    output = self.handle(*args, **options)
  File "/home/InvenTree/InvenTree/InvenTree/management/commands/runmigrations.py", line 18, in handle
    check_for_migrations(force=True, reload_registry=False)
  File "/home/InvenTree/InvenTree/InvenTree/tasks.py", line 700, in check_for_migrations
    call_command('migrate', interactive=False)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 194, in call_command
    return command.execute(*args, **defaults)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 458, in execute
    output = self.handle(*args, **options)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 106, in wrapper
    res = handle_func(*args, **kwargs)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/commands/migrate.py", line 356, in handle
    post_migrate_state = executor.migrate(
  File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 135, in migrate
    state = self._migrate_all_forwards(
  File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards
    state = self.apply_migration(
  File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 252, in apply_migration
    state = migration.apply(state, schema_editor)
  File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/migration.py", line 132, in apply
    operation.database_forwards(
  File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/operations/special.py", line 193, in database_forwards
    self.code(from_state.apps, schema_editor)
  File "/home/InvenTree/InvenTree/part/migrations/0109_auto_20230517_1048.py", line 31, in update_template_units
    for template in PartParameterTemplate.objects.all():
  File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 398, in __iter__
    self._fetch_all()
  File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1881, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 91, in __iter__
    results = compiler.execute_sql(
  File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 102, in execute
    return super().execute(sql, params)
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
    with self.db.wrap_database_errors:
  File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/dist-packages/psycopg/cursor.py", line 732, in execute
    raise ex.with_traceback(None)
django.db.utils.InternalError: current transaction is aborted, commands ignored until end of transaction block

Some extra info:

Python version: Python 3.10.13
OS:

NAME="Ubuntu"
VERSION="20.04.6 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.6 LTS"

I can paste a pip3 freeze if needed too.

Could you give us a hand? Thank you in advance!

[SchrodingersGat]

@oscgonfer what version (of InvenTree) were you upgrading from and what version are you upgrading to?

[oscgonfer]

Hi @SchrodingersGat,

From: 0.9.0
To: Latest

[matmair]

Is this occuring while running invoke update? Can you post a full log of the update logs up to this point?

[oscgonfer]

Hi again,

Here it is. Since I am running it again, probably it changed from the first try:

➜  InvenTree git:(master) ✗ invoke update
Installing required python packages from 'requirements.txt'
Requirement already satisfied: pip in /usr/local/lib/python3.10/dist-packages (24.0)
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
Requirement already satisfied: setuptools in /usr/local/lib/python3.10/dist-packages (69.1.0)
Collecting setuptools
  Using cached setuptools-69.1.1-py3-none-any.whl.metadata (6.2 kB)
Using cached setuptools-69.1.1-py3-none-any.whl (819 kB)
Installing collected packages: setuptools
  Attempting uninstall: setuptools
    Found existing installation: setuptools 69.1.0
    Uninstalling setuptools-69.1.0:
      Successfully uninstalled setuptools-69.1.0
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
launchpadlib 1.10.13 requires testresources, which is not installed.
Successfully installed setuptools-69.1.1
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
Requirement already satisfied: asgiref==3.7.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 3)) (3.7.2)
Requirement already satisfied: async-timeout==4.0.3 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 7)) (4.0.3)
Requirement already satisfied: attrs==23.2.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 9)) (23.2.0)
Requirement already satisfied: babel==2.14.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 13)) (2.14.0)
Requirement already satisfied: backoff==2.2.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 15)) (2.2.1)
Requirement already satisfied: bleach==6.1.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 20)) (6.1.0)
Requirement already satisfied: brotli==1.1.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 22)) (1.1.0)
Requirement already satisfied: certifi==2024.2.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 24)) (2024.2.2)
Requirement already satisfied: cffi==1.16.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 28)) (1.16.0)
Requirement already satisfied: charset-normalizer==3.3.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 32)) (3.3.2)
Requirement already satisfied: coreapi==2.3.3 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 34)) (2.3.3)
Requirement already satisfied: coreschema==0.0.4 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 35)) (0.0.4)
Requirement already satisfied: cryptography==42.0.4 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 37)) (42.0.4)
Requirement already satisfied: cssselect2==0.7.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 41)) (0.7.0)
Requirement already satisfied: defusedxml==0.7.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 43)) (0.7.1)
Requirement already satisfied: deprecated==1.2.14 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 47)) (1.2.14)
Requirement already satisfied: diff-match-patch==20230430 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 52)) (20230430)
Requirement already satisfied: dj-rest-auth==5.0.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 54)) (5.0.2)
Requirement already satisfied: django==4.2.10 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 55)) (4.2.10)
Requirement already satisfied: django-allauth==0.60.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 87)) (0.60.1)
Requirement already satisfied: django-allauth-2fa==0.11.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 89)) (0.11.1)
Requirement already satisfied: django-cleanup==8.1.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 90)) (8.1.0)
Requirement already satisfied: django-cors-headers==4.3.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 91)) (4.3.1)
Requirement already satisfied: django-crispy-forms==1.14.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 92)) (1.14.0)
Requirement already satisfied: django-dbbackup==4.1.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 93)) (4.1.0)
Requirement already satisfied: django-error-report-2==0.4.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 94)) (0.4.2)
Requirement already satisfied: django-filter==23.5 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 95)) (23.5)
Requirement already satisfied: django-flags==5.0.13 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 96)) (5.0.13)
Requirement already satisfied: django-formtools==2.5.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 97)) (2.5.1)
Requirement already satisfied: django-ical==1.9.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 98)) (1.9.2)
Requirement already satisfied: django-import-export==3.3.7 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 99)) (3.3.7)
Requirement already satisfied: django-js-asset==2.2.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 100)) (2.2.0)
Requirement already satisfied: django-maintenance-mode==0.21.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 102)) (0.21.1)
Requirement already satisfied: django-markdownify==0.9.3 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 103)) (0.9.3)
Requirement already satisfied: django-money==3.2.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 104)) (3.2.0)
Requirement already satisfied: django-mptt==0.16.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 105)) (0.16.0)
Requirement already satisfied: django-otp==1.3.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 106)) (1.3.0)
Requirement already satisfied: django-picklefield==3.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 108)) (3.1)
Requirement already satisfied: django-q-sentry==0.1.6 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 110)) (0.1.6)
Requirement already satisfied: django-q2==1.6.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 111)) (1.6.1)
Requirement already satisfied: django-recurrence==1.11.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 112)) (1.11.1)
Requirement already satisfied: django-redis==5.4.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 114)) (5.4.0)
Requirement already satisfied: django-sesame==3.2.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 115)) (3.2.2)
Requirement already satisfied: django-sql-utils==0.7.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 116)) (0.7.0)
Requirement already satisfied: django-sslserver==0.22 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 117)) (0.22)
Requirement already satisfied: django-stdimage==6.0.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 118)) (6.0.2)
Requirement already satisfied: django-taggit==5.0.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 119)) (5.0.1)
Requirement already satisfied: django-user-sessions==2.0.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 120)) (2.0.0)
Requirement already satisfied: django-weasyprint==2.2.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 121)) (2.2.2)
Requirement already satisfied: django-xforwardedfor-middleware==2.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 122)) (2.0)
Requirement already satisfied: djangorestframework==3.14.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 123)) (3.14.0)
Requirement already satisfied: djangorestframework-simplejwt==5.3.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 128)) (5.3.1)
Requirement already satisfied: drf-spectacular==0.27.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 129)) (0.27.1)
Requirement already satisfied: dulwich==0.21.7 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 130)) (0.21.7)
Requirement already satisfied: et-xmlfile==1.1.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 131)) (1.1.0)
Requirement already satisfied: feedparser==6.0.11 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 133)) (6.0.11)
Requirement already satisfied: fonttools==4.47.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 134)) (4.47.2)
Requirement already satisfied: googleapis-common-protos==1.62.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 136)) (1.62.0)
Requirement already satisfied: grpcio==1.62.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 140)) (1.62.0)
Requirement already satisfied: gunicorn==21.2.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 142)) (21.2.0)
Requirement already satisfied: html5lib==1.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 143)) (1.1)
Requirement already satisfied: icalendar==5.0.11 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 145)) (5.0.11)
Requirement already satisfied: idna==3.6 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 147)) (3.6)
Requirement already satisfied: importlib-metadata==6.11.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 149)) (6.11.0)
Requirement already satisfied: inflection==0.5.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 154)) (0.5.1)
Requirement already satisfied: itypes==1.2.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 156)) (1.2.0)
Requirement already satisfied: jinja2==3.1.3 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 158)) (3.1.3)
Requirement already satisfied: jsonschema==4.21.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 160)) (4.21.1)
Requirement already satisfied: jsonschema-specifications==2023.12.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 162)) (2023.12.1)
Requirement already satisfied: markdown==3.5.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 164)) (3.5.2)
Requirement already satisfied: markuppy==1.14 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 166)) (1.14)
Requirement already satisfied: markupsafe==2.1.5 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 168)) (2.1.5)
Requirement already satisfied: oauthlib==3.2.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 170)) (3.2.2)
Requirement already satisfied: odfpy==1.4.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 172)) (1.4.1)
Requirement already satisfied: openpyxl==3.1.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 174)) (3.1.2)
Requirement already satisfied: opentelemetry-api==1.22.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 176)) (1.22.0)
Requirement already satisfied: opentelemetry-exporter-otlp==1.22.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 186)) (1.22.0)
Requirement already satisfied: opentelemetry-exporter-otlp-proto-common==1.22.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 187)) (1.22.0)
Requirement already satisfied: opentelemetry-exporter-otlp-proto-grpc==1.22.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 191)) (1.22.0)
Requirement already satisfied: opentelemetry-exporter-otlp-proto-http==1.22.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 193)) (1.22.0)
Requirement already satisfied: opentelemetry-instrumentation==0.43b0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 195)) (0.43b0)
Requirement already satisfied: opentelemetry-instrumentation-django==0.43b0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 201)) (0.43b0)
Requirement already satisfied: opentelemetry-instrumentation-redis==0.43b0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 202)) (0.43b0)
Requirement already satisfied: opentelemetry-instrumentation-requests==0.43b0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 203)) (0.43b0)
Requirement already satisfied: opentelemetry-instrumentation-wsgi==0.43b0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 204)) (0.43b0)
Requirement already satisfied: opentelemetry-proto==1.22.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 206)) (1.22.0)
Requirement already satisfied: opentelemetry-sdk==1.22.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 211)) (1.22.0)
Requirement already satisfied: opentelemetry-semantic-conventions==0.43b0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 215)) (0.43b0)
Requirement already satisfied: opentelemetry-util-http==0.43b0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 222)) (0.43b0)
Requirement already satisfied: packaging==23.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 227)) (23.2)
Requirement already satisfied: pdf2image==1.17.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 229)) (1.17.0)
Requirement already satisfied: pillow==10.2.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 230)) (10.2.0)
Requirement already satisfied: pint==0.21 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 237)) (0.21)
Requirement already satisfied: protobuf==4.25.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 238)) (4.25.2)
Requirement already satisfied: py-moneyed==3.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 242)) (3.0)
Requirement already satisfied: pycparser==2.21 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 244)) (2.21)
Requirement already satisfied: pydyf==0.8.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 246)) (0.8.0)
Requirement already satisfied: pyjwt==2.8.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 248)) (2.8.0)
Requirement already satisfied: pyphen==0.14.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 252)) (0.14.0)
Requirement already satisfied: pypng==0.20220715.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 254)) (0.20220715.0)
Requirement already satisfied: python-barcode==0.15.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 256)) (0.15.1)
Requirement already satisfied: python-dateutil==2.8.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 257)) (2.8.2)
Requirement already satisfied: python-dotenv==1.0.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 261)) (1.0.1)
Requirement already satisfied: python-fsutil==0.13.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 262)) (0.13.1)
Requirement already satisfied: python3-openid==3.2.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 264)) (3.2.0)
Requirement already satisfied: pytz==2024.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 266)) (2024.1)
Requirement already satisfied: pyyaml==6.0.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 271)) (6.0.1)
Requirement already satisfied: qrcode==7.4.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 275)) (7.4.2)
Requirement already satisfied: rapidfuzz==3.6.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 277)) (3.6.1)
Requirement already satisfied: redis==5.0.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 278)) (5.0.1)
Requirement already satisfied: referencing==0.33.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 280)) (0.33.0)
Requirement already satisfied: regex==2023.12.25 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 284)) (2023.12.25)
Requirement already satisfied: requests==2.31.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 285)) (2.31.0)
Requirement already satisfied: requests-oauthlib==1.3.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 291)) (1.3.1)
Requirement already satisfied: rpds-py==0.17.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 293)) (0.17.1)
Requirement already satisfied: sentry-sdk==1.40.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 297)) (1.40.0)
Collecting setuptools==69.1.0 (from -r requirements.txt (line 299))
  Downloading setuptools-69.1.0-py3-none-any.whl.metadata (6.1 kB)
Requirement already satisfied: sgmllib3k==1.0.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 303)) (1.0.0)
Requirement already satisfied: six==1.16.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 305)) (1.16.0)
Requirement already satisfied: sqlparse==0.4.4 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 310)) (0.4.4)
Requirement already satisfied: tablib==3.5.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 314)) (3.5.0)
Requirement already satisfied: tinycss2==1.2.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 316)) (1.2.1)
Requirement already satisfied: typing-extensions==4.9.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 321)) (4.9.0)
Requirement already satisfied: uritemplate==4.1.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 328)) (4.1.1)
Requirement already satisfied: urllib3==2.2.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 332)) (2.2.0)
Requirement already satisfied: weasyprint==60.2 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 337)) (60.2)
Requirement already satisfied: webencodings==0.5.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 339)) (0.5.1)
Requirement already satisfied: wrapt==1.16.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 345)) (1.16.0)
Requirement already satisfied: xlrd==2.0.1 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 350)) (2.0.1)
Requirement already satisfied: xlwt==1.3.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 352)) (1.3.0)
Requirement already satisfied: zipp==3.17.0 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 354)) (3.17.0)
Requirement already satisfied: zopfli==0.2.3 in /usr/local/lib/python3.10/dist-packages (from -r requirements.txt (line 356)) (0.2.3)
Downloading setuptools-69.1.0-py3-none-any.whl (819 kB)
   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 819.3/819.3 kB 74.2 MB/s eta 0:00:00
Installing collected packages: setuptools
  Attempting uninstall: setuptools
    Found existing installation: setuptools 69.1.1
    Uninstalling setuptools-69.1.1:
      Successfully uninstalled setuptools-69.1.1
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
launchpadlib 1.10.13 requires testresources, which is not installed.
Successfully installed setuptools-69.1.0
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
Installing plugin packages from '/home/InvenTree/InvenTree/plugins.txt'
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
Backing up InvenTree database...
Python version 3.10.13 - /usr/bin/python3
/usr/local/lib/python3.10/dist-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
  warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
Backing Up Database: Inventree_db
Writing file to default-fablabbcn-inventory-2024-03-06-112644.psql.bin.gz
Backing up InvenTree media files...
Python version 3.10.13 - /usr/bin/python3
/usr/local/lib/python3.10/dist-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
  warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
Writing file to fablabbcn-inventory-2024-03-06-112650.tar.gz
Running InvenTree database migrations...
========================================
Python version 3.10.13 - /usr/bin/python3
/usr/local/lib/python3.10/dist-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
  warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
No changes detected
Python version 3.10.13 - /usr/bin/python3
/usr/local/lib/python3.10/dist-packages/allauth/exceptions.py:9: UserWarning: allauth.exceptions is deprecated, use allauth.core.exceptions
  warnings.warn("allauth.exceptions is deprecated, use allauth.core.exceptions")
Operations to perform:
  Apply all migrations: InvenTree, account, admin, auth, build, common, company, contenttypes, django_q, error_report, exchange, flags, label, machine, order, otp_static, otp_totp, part, plugin, report, socialaccount, stock, taggit, user_sessions, users
Running migrations:
  Applying part.0109_auto_20230517_1048...Redefining 'celsius' (<class 'pint.delegates.txt_defparser.plain.UnitDefinition'>)
Redefining 'fahrenheit' (<class 'pint.delegates.txt_defparser.plain.UnitDefinition'>)
Redefining 'kelvin' (<class 'pint.delegates.txt_defparser.plain.UnitDefinition'>)
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/dist-packages/psycopg/cursor.py", line 732, in execute
    raise ex.with_traceback(None)
psycopg.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

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

Traceback (most recent call last):
  File "/home/InvenTree/InvenTree/manage.py", line 24, in <module>
    main()
  File "/home/InvenTree/InvenTree/manage.py", line 20, in main
    execute_from_command_line(sys.argv)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 436, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 412, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 458, in execute
    output = self.handle(*args, **options)
  File "/home/InvenTree/InvenTree/InvenTree/management/commands/runmigrations.py", line 18, in handle
    check_for_migrations(force=True, reload_registry=False)
  File "/home/InvenTree/InvenTree/InvenTree/tasks.py", line 700, in check_for_migrations
    call_command('migrate', interactive=False)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 194, in call_command
    return command.execute(*args, **defaults)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 458, in execute
    output = self.handle(*args, **options)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 106, in wrapper
    res = handle_func(*args, **kwargs)
  File "/usr/local/lib/python3.10/dist-packages/django/core/management/commands/migrate.py", line 356, in handle
    post_migrate_state = executor.migrate(
  File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 135, in migrate
    state = self._migrate_all_forwards(
  File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards
    state = self.apply_migration(
  File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 252, in apply_migration
    state = migration.apply(state, schema_editor)
  File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/migration.py", line 132, in apply
    operation.database_forwards(
  File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/operations/special.py", line 193, in database_forwards
    self.code(from_state.apps, schema_editor)
  File "/home/InvenTree/InvenTree/part/migrations/0109_auto_20230517_1048.py", line 31, in update_template_units
    for template in PartParameterTemplate.objects.all():
  File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 398, in __iter__
    self._fetch_all()
  File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1881, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 91, in __iter__
    results = compiler.execute_sql(
  File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 102, in execute
    return super().execute(sql, params)
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
    with self.db.wrap_database_errors:
  File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python3.10/dist-packages/psycopg/cursor.py", line 732, in execute
    raise ex.with_traceback(None)
django.db.utils.InternalError: current transaction is aborted, commands ignored until end of transaction block

[SchrodingersGat]

@oscgonfer looks like the data migration is causing an issue here. It may be possible to get around this by specifying non atomic transactions

In part/migrations/0109_auto_20230517_1048.py try adding atomic = False to this class:

InvenTree/InvenTree/part/migrations/0109_auto_20230517_1048.py

Line 139 in 6eddb18

class Migration(migrations.Migration):

If the migration runs fine after this please let me know and we can run patch the migration file.

[oscgonfer]

aha! that did the trick!

[SchrodingersGat]

@oscgonfer thanks for letting me know - I will issue a fix

[oscgonfer]

@SchrodingersGat

Also, probably worth including a fix on some functions I had to modify locally while using python 3.10.

In particular, some of the migration functions have declared input types, which clash with the 3.10 function signatures:. Below a diff of my local fix:

diff --git a/InvenTree/part/migrations/0109_auto_20230517_1048.py b/InvenTree/part/migrations/0109_auto_20230517_1048.py
index 01e3ad002..3d64e9219 100644
--- a/InvenTree/part/migrations/0109_auto_20230517_1048.py
+++ b/InvenTree/part/migrations/0109_auto_20230517_1048.py
@@ -137,6 +137,7 @@ def update_parameter_values(apps, schema_editor):
 
 
 class Migration(migrations.Migration):
+    atomic = False
 
     dependencies = [
         ('part', '0108_auto_20230516_1334'),
diff --git a/tasks.py b/tasks.py
index 2c2b56089..b0bbb87f2 100644
--- a/tasks.py
+++ b/tasks.py
@@ -397,11 +397,11 @@ def migrate(c):
 )
 def update(
     c,
-    skip_backup: bool = False,
-    frontend: bool = False,
-    no_frontend: bool = False,
-    skip_static: bool = False,
-    uv: bool = False,
+    skip_backup = False,
+    frontend = False,
+    no_frontend = False,
+    skip_static = False,
+    uv = False,
 ):
     """Update InvenTree installation.
 
@@ -552,7 +552,7 @@ def export_records(
     post=[rebuild_models, rebuild_thumbnails],
 )
 def import_records(
-    c, filename='data.json', clear: bool = False, retain_temp: bool = False
+    c, filename='data.json', clear = False, retain_temp = False
 ):
     """Import database records from a file."""
     # Get an absolute path to the supplied filename

[SchrodingersGat]

@oscgonfer can you please submit a PR with these changes?