Comment 2 for bug 2034014

2023-09-04 10:13:10 maasserver.utils.views: [error] Attempt #5 for /MAAS/api/2.0/machines/ failed; giving up (91.8s elapsed in total)
Traceback (most recent call last):
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "maasserver_filesystem_partition_id_acquired_5fe51ba7_uniq"
DETAIL: Key (partition_id, acquired)=(140, t) already exists.

The above exception was the direct cause of the following exception:
Traceback (most recent call last):
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/utils/views.py", line 245, in handle_uncaught_exception
    return self.process_exception_by_middleware(exc, request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/utils/views.py", line 243, in handle_uncaught_exception
    raise exc from exc.__cause__
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/utils/views.py", line 309, in get_response
    response = django_get_response(request)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/core/handlers/base.py", line 75, in get_response
    response = self._middleware_chain(request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/prometheus/middleware.py", line 52, in __call__
    response = self.get_response(request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/middleware.py", line 331, in __call__
    response = self.get_response(request)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/utils/deprecation.py", line 94, in __call__
    response = response or self.get_response(request)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/utils/deprecation.py", line 94, in __call__
    response = response or self.get_response(request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/middleware.py", line 172, in __call__
    return self.get_response(request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/middleware.py", line 517, in __call__
    result = self.get_response(request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/middleware.py", line 363, in __call__
    return self.get_response(request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/middleware.py", line 363, in __call__
    return self.get_response(request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/middleware.py", line 444, in __call__
    return self.get_response(request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/middleware.py", line 501, in __call__
    return self.get_response(request)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/utils/deprecation.py", line 94, in __call__
    response = response or self.get_response(request)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/utils/deprecation.py", line 94, in __call__
    response = response or self.get_response(request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/middleware.py", line 103, in __call__
    return self.get_response(request)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/utils/deprecation.py", line 94, in __call__
    response = response or self.get_response(request)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/middleware.py", line 153, in __call__
    return self.get_response(request)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/core/handlers/base.py", line 115, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/core/handlers/base.py", line 113, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/utils/views.py", line 288, in view_atomic_with_post_commit_savepoint
    return view_atomic(*args, **kwargs)
  File "/usr/lib/python3.8/contextlib.py", line 75, in inner
    return func(*args, **kwds)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/api/support.py", line 56, in __call__
    response = super().__call__(request, *args, **kwargs)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/views/decorators/vary.py", line 20, in inner_func
    response = func(*args, **kwargs)
  File "/snap/maas/29774/usr/lib/python3.8/dist-packages/piston3/resource.py", line 197, in __call__
    result = self.error_handler(e, request, meth, em_format)
  File "/snap/maas/29774/usr/lib/python3.8/dist-packages/piston3/resource.py", line 195, in __call__
    result = meth(request, *args, **kwargs)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/api/support.py", line 306, in dispatch
    return function(self, request, *args, **kwargs)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/api/machines.py", line 2570, in allocate
    machine.acquire(
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/models/node.py", line 3368, in acquire
    self._create_acquired_filesystems()
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/models/node.py", line 4441, in _create_acquired_filesystems
    _clone_object(filesystem, acquired=True)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/models/node.py", line 6946, in _clone_object
    obj.save()
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/models/filesystem.py", line 289, in save
    super().save(*args, **kwargs)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/models/cleansave.py", line 183, in save
    return super().save(*args, **kwargs)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/models/timestampedmodel.py", line 78, in save
    return super().save(*args, **kwargs)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/models/base.py", line 740, in save
    self.save_base(using=using, force_insert=force_insert,
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/models/base.py", line 777, in save_base
    updated = self._save_table(
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/models/cleansave.py", line 252, in _save_table
    res = super()._save_table(
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/models/base.py", line 870, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/models/base.py", line 907, in _do_insert
    return manager._insert([self], fields=fields, return_id=update_pk,
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/models/manager.py", line 82, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/models/query.py", line 1186, in _insert
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py", line 1375, in execute_sql
    cursor.execute(sql, params)
  File "/snap/maas/29774/lib/python3.8/site-packages/maasserver/prometheus/middleware.py", line 22, in execute
    return super().execute(sql, params=params)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/utils.py", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/snap/maas/29774/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
django.db.utils.IntegrityError: duplicate key value violates unique constraint "maasserver_filesystem_partition_id_acquired_5fe51ba7_uniq"
DETAIL: Key (partition_id, acquired)=(140, t) already exists.

2023-09-04 10:13:10 regiond: [info] 127.0.0.1 POST /MAAS/api/2.0/machines/?op=allocate HTTP/1.1 --> 409 CONFLICT (referrer: -; agent: Go-http-client/1.1)
2023-09-04 10:13:11 maasserver.preseed: [warn] WARNING: '/snap/maas/29774/etc/maas/preseeds/curtin_userdata' contains deprecated preseed variables. Please remove: main_archive_directory, ports_archive_directory