Issue #8750: Deadlock on rpm repository pulp2pulp sync - Pulp

Actions

Send by e-mail Copy link

Issue #8750

closed

Deadlock on rpm repository pulp2pulp sync

Added by wibbit almost 3 years ago. Updated over 2 years ago.

Status:

CLOSED - CURRENTRELEASE

Priority:

High

Assignee:

ggainey

Category:

Sprint/Milestone:

3.16.0

Start date:

Due date:

Estimated time:

Severity:

3. High

Version:

Platform Release:

OS:

Triaged:

Yes

Groomed:

Sprint Candidate:

Tags:

Katello

Sprint:

Sprint 106

Quarter:

Description

When running repository sync, I am hitting the below deadlock.

The content is a mirror of "http://linux.dell.com/repo/hardware/dsu/os_independent/"

{'child_tasks': [],
 'created_resources': [],
 'error': {'description': 'deadlock detected\n'
                          'DETAIL:  Process 31559 waits for ShareLock on '
                          'transaction 4972396; blocked by process 31883.\n'
                          'Process 31883 waits for ShareLock on transaction '
                          '4972398; blocked by process 31559.\n'
                          'HINT:  See server log for query details.\n'
                          'CONTEXT:  while inserting index tuple (49588,3) in '
                          'relation "rpm_package_pkgId_key"\n',
           'traceback': '  File '
                        '"/opt/bats/lib/python3.8/site-packages/rq/worker.py", '
                        'line 1008, in perform_job\n'
                        '    rv = job.perform()\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/rq/job.py", '
                        'line 706, in perform\n'
                        '    self._result = self._execute()\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/rq/job.py", '
                        'line 729, in _execute\n'
                        '    result = self.func(*self.args, **self.kwargs)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/pulp_rpm/app/tasks/synchronizing.py", '
                        'line 269, in synchronize\n'
                        '    dv.create()\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/pulpcore/plugin/stages/declarative_version.py", '
                        'line 149, in create\n'
                        '    loop.run_until_complete(pipeline)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/asyncio/base_events.py", '
                        'line 616, in run_until_complete\n'
                        '    return future.result()\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/pulpcore/plugin/stages/api.py", '
                        'line 225, in create_pipeline\n'
                        '    await asyncio.gather(*futures)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/pulpcore/plugin/stages/api.py", '
                        'line 43, in __call__\n'
                        '    await self.run()\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/pulpcore/plugin/stages/content_stages.py", '
                        'line 96, in run\n'
                        '    d_content.content.save()\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/pulpcore/app/models/base.py", '
                        'line 149, in save\n'
                        '    return super().save(*args, **kwargs)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django_lifecycle/mixins.py", '
                        'line 134, in save\n'
                        '    save(*args, **kwargs)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/models/base.py", '
                        'line 743, in save\n'
                        '    self.save_base(using=using, '
                        'force_insert=force_insert,\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/models/base.py", '
                        'line 780, in save_base\n'
                        '    updated = self._save_table(\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/models/base.py", '
                        'line 873, in _save_table\n'
                        '    result = self._do_insert(cls._base_manager, '
                        'using, fields, update_pk, raw)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/models/base.py", '
                        'line 910, in _do_insert\n'
                        '    return manager._insert([self], fields=fields, '
                        'return_id=update_pk,\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/models/manager.py", '
                        'line 82, in manager_method\n'
                        '    return getattr(self.get_queryset(), name)(*args, '
                        '**kwargs)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/models/query.py", '
                        'line 1186, in _insert\n'
                        '    return '
                        'query.get_compiler(using=using).execute_sql(return_id)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/models/sql/compiler.py", '
                        'line 1377, in execute_sql\n'
                        '    cursor.execute(sql, params)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/backends/utils.py", '
                        'line 67, in execute\n'
                        '    return self._execute_with_wrappers(sql, params, '
                        'many=False, executor=self._execute)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/backends/utils.py", '
                        'line 76, in _execute_with_wrappers\n'
                        '    return executor(sql, params, many, context)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/backends/utils.py", '
                        'line 84, in _execute\n'
                        '    return self.cursor.execute(sql, params)\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/utils.py", '
                        'line 89, in __exit__\n'
                        '    raise dj_exc_value.with_traceback(traceback) from '
                        'exc_value\n'
                        '  File '
                        '"/opt/bats/lib/python3.8/site-packages/django/db/backends/utils.py", '
                        'line 84, in _execute\n'
                        '    return self.cursor.execute(sql, params)\n'},
 'finished_at': datetime.datetime(2021, 5, 13, 16, 4, 16, 230996, tzinfo=tzutc()),
 'logging_cid': '01b00ffb6c684f1a83bd46878184fe5b',
 'name': 'pulp_rpm.app.tasks.synchronizing.synchronize',
 'parent_task': None,
 'progress_reports': [{'code': 'downloading.metadata',
                       'done': 5,
                       'message': 'Downloading Metadata Files',
                       'state': 'canceled',
                       'suffix': None,
                       'total': None},
                      {'code': 'sync.downloading.artifacts',
                       'done': 5501,
                       'message': 'Downloading Artifacts',
                       'state': 'canceled',
                       'suffix': None,
                       'total': None},
                      {'code': 'associating.content',
                       'done': 5501,
                       'message': 'Associating Content',
                       'state': 'canceled',
                       'suffix': None,
                       'total': None},
                      {'code': 'parsing.advisories',
                       'done': 0,
                       'message': 'Parsed Advisories',
                       'state': 'completed',
                       'suffix': None,
                       'total': 0},
                      {'code': 'parsing.packages',
                       'done': 9010,
                       'message': 'Parsed Packages',
                       'state': 'canceled',
                       'suffix': None,
                       'total': 34644}],
 'pulp_created': datetime.datetime(2021, 5, 13, 15, 8, 17, 924670, tzinfo=tzutc()),
 'pulp_href': '/pulp/api/v3/tasks/c4ed6290-a764-4ec3-96a4-1b6ce55597f3/',
 'reserved_resources_record': ['/pulp/api/v3/repositories/rpm/rpm/f8bfd15c-a831-4e63-a8f7-2fd3156c97af/',
                               '/pulp/api/v3/remotes/rpm/rpm/d12fcb7e-9c0f-4226-bf0a-42381f4d9b51/'],
 'started_at': datetime.datetime(2021, 5, 13, 15, 8, 18, 18915, tzinfo=tzutc()),
 'state': 'failed',
 'task_group': None,
 'worker': '/pulp/api/v3/workers/b63013da-896e-4882-884a-6f9b9b6410b0/'}

A little context.

I have 3 secondary Pulp3 servers, syncing against a primary Pulp3 server, I kick off a sync of ~130 repositories per secondary in one go.

I've done this 3 times, and I've hit this deadlock on three occasions and so far only on this dell dsu repository.

Let me know if there is any more information that I can provide.

Related issues

Actions

Copy link

Updated by ggainey almost 3 years ago

Description updated (diff)

Actions

Copy link

Updated by fao89 almost 3 years ago

Project changed from Pulp to RPM Support

Actions

Copy link

Updated by dalley almost 3 years ago

Project changed from RPM Support to Pulp

Actions

Copy link

Updated by dalley almost 3 years ago

Priority changed from Normal to High
Triaged changed from No to Yes
Sprint set to Sprint 97

Actions

Copy link

Updated by dalley almost 3 years ago

Severity changed from 2. Medium to 3. High

Actions

Copy link

Updated by rchan almost 3 years ago

Sprint changed from Sprint 97 to Sprint 98

Actions

Copy link

Updated by wibbit almost 3 years ago

Morning all

Additional deadlock hit, not sure if it is related.

2021-06-16 04:45:44|ERROR   |Server: ncc1r8.us.daisies.net, Task: /pulp/api/v3/tasks/7c3fdf21-1b21-43dd-b9ad-19bbd98f4a88/ is in a failed state. With message: deadlock detected
DETAIL:  Process 21577 waits for ShareLock on transaction 13163681; blocked by process 21565.
Process 21565 waits for ShareLock on transaction 13163680; blocked by process 21577.
HINT:  See server log for query details.
CONTEXT:  while inserting index tuple (10762,2) in relation "core_artifact_sha256_key"
 
{'child_tasks': [],                                                                                                                                                                                                                                                                                                     [49/129]
 'created_resources': [],
 'error': {'description': 'deadlock detected\n'
                          'DETAIL:  Process 21577 waits for ShareLock on '
                          'transaction 13163681; blocked by process 21565.\n'
                          'Process 21565 waits for ShareLock on transaction '
                          '13163680; blocked by process 21577.\n'
                          'HINT:  See server log for query details.\n'
                          'CONTEXT:  while inserting index tuple (10762,2) in '
                          'relation "core_artifact_sha256_key"\n',
           'traceback': '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/pulpcore/tasking/pulpcore_worker.py", '
                        'line 199, in _perform_task\n'
                        '    result = func(*args, **kwargs)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/pulp_rpm/app/tasks/synchronizing.py", '
                        'line 383, in synchronize\n'
                        '    version = dv.create()\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/pulpcore/plugin/stages/declarative_version.py", '
                        'line 151, in create\n'
                        '    loop.run_until_complete(pipeline)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/asyncio/base_events.py", '
                        'line 616, in run_until_complete\n'
                        '    return future.result()\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/pulpcore/plugin/stages/api.py", '
                        'line 225, in create_pipeline\n'
                        '    await asyncio.gather(*futures)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/pulpcore/plugin/stages/api.py", '
                        'line 43, in __call__\n'
                        '    await self.run()\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/pulpcore/plugin/stages/artifact_stages.py", '
                        'line 240, in run\n'
                        '    Artifact.objects.bulk_get_or_create(\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/pulpcore/app/models/content.py", '
                        'line 82, in bulk_get_or_create\n'
                        '    return super().bulk_create(objs, '
                        'batch_size=batch_size)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/django/db/models/manager.py", '
                        'line 82, in manager_method\n'
                        '    return getattr(self.get_queryset(), name)(*args, '
                        '**kwargs)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/django/db/models/query.py", '
                        'line 468, in bulk_create\n'
                        '    self._batched_insert(objs_with_pk, fields, '
                        'batch_size, ignore_conflicts=ignore_conflicts)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/django/db/models/query.py", '
                        'line 1202, in _batched_insert\n'
                        '    inserted_id = self._insert(\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/django/db/models/query.py", '
                        'line 1186, in _insert\n'
                        '    return '
                        'query.get_compiler(using=using).execute_sql(return_id)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/django/db/models/sql/compiler.py", '
                        'line 1377, in execute_sql\n'
                        '    cursor.execute(sql, params)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/django/db/backends/utils.py", '
                        'line 67, in execute\n'
                        '    return self._execute_with_wrappers(sql, params, '
                        'many=False, executor=self._execute)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/django/db/backends/utils.py", '
                        'line 76, in _execute_with_wrappers\n'
                        '    return executor(sql, params, many, context)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/django/db/backends/utils.py", '
                        'line 84, in _execute\n'
                        '    return self.cursor.execute(sql, params)\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/django/db/utils.py", '
                        'line 89, in __exit__\n'
                        '    raise dj_exc_value.with_traceback(traceback) from '
                        'exc_value\n'
                        '  File '
                        '"/opt/puppies/lib/python3.8/site-packages/django/db/backends/utils.py", '
                        'line 84, in _execute\n'
                        '    return self.cursor.execute(sql, params)\n'},
 'finished_at': datetime.datetime(2021, 6, 16, 8, 40, 17, 194098, tzinfo=tzutc()),
 'logging_cid': 'fc876948b9d644f988743eb828d99ee4',
 'name': 'pulp_rpm.app.tasks.synchronizing.synchronize',
 'parent_task': None,
 'progress_reports': [{'code': 'sync.downloading.metadata',
                       'done': 6,
                       'message': 'Downloading Metadata Files',
                       'state': 'completed',
                       'suffix': None,
                       'total': None},
                      {'code': 'sync.parsing.packages',
                       'done': 193,
                       'message': 'Parsed Packages',
                       'state': 'completed',
                       'suffix': None,
                       'total': 193},
                      {'code': 'sync.parsing.comps',
                       'done': 0,
                       'message': 'Parsed Comps',
                       'state': 'completed',
                       'suffix': None,
                       'total': 0},
                      {'code': 'sync.parsing.advisories',
                       'done': 0,
                       'message': 'Parsed Advisories',
                       'state': 'completed',
                       'suffix': None,
                       'total': 0},
                      {'code': 'sync.downloading.artifacts',
                       'done': 4,
                       'message': 'Downloading Artifacts',
                       'state': 'completed',
                       'suffix': None,
                       'total': None},
                      {'code': 'associating.content',
                       'done': 0,
                       'message': 'Associating Content',
                       'state': 'canceled',
                       'suffix': None,
                       'total': None}],
 'pulp_created': datetime.datetime(2021, 6, 16, 8, 40, 10, 566935, tzinfo=tzutc()),
 'pulp_href': '/pulp/api/v3/tasks/7c3fdf21-1b21-43dd-b9ad-19bbd98f4a88/',
 'reserved_resources_record': ['/pulp/api/v3/remotes/rpm/rpm/48462531-7d83-4dc2-adf7-cd88e4d65495/',
                               '/pulp/api/v3/repositories/rpm/rpm/60559b7c-0acd-4c63-9e50-c8dad09e6bb1/'],
 'started_at': datetime.datetime(2021, 6, 16, 8, 40, 10, 632317, tzinfo=tzutc()),
 'state': 'failed',
 'task_group': None,
 'worker': '/pulp/api/v3/workers/82c16745-9a8f-4e58-8395-c0a360672ba0/'}

Associated sql

127.0.0.1(43873):60c9b8ea.5449:2021-06-16 04:40:17.065 EDT:app=[unknown]:pid=21577:ERROR:  deadlock detected
127.0.0.1(43873):60c9b8ea.5449:2021-06-16 04:40:17.065 EDT:app=[unknown]:pid=21577:DETAIL:  Process 21577 waits for ShareLock on transaction 13163681; blocked by process 21565.
        Process 21565 waits for ShareLock on transaction 13163680; blocked by process 21577.
        Process 21577: INSERT INTO "core_artifact" ("pulp_id", "pulp_created", "pulp_last_updated", "file", "size", "md5", "sha1", "sha224", "sha256", "sha384", "sha512") VALUES ('15b7946a-1e75-461c-99d9-c2244eea44e0'::uuid, '2021-06-16T08:40:16.019791+00:00'::timestamptz, '2021-06-16T08:40:16.019827+00:00'::timestamptz, 'artifact/44/414c7788cd8a1722906fb34bb019290d1269bb24bbf3ce9f1d63fe15464354', 83110084, NULL, 'ca43066416a794b8cfb822eff9ebf9f28cb202cd', '6699ad24ccbecc3508bc22d5890f489ea047518d4e43c4766a39e33a', '44414c7788cd8a1722906fb34bb019290d1269bb24bbf3ce9f1d63fe15464354', 'dbff1aaf5bec37bbe77a028826fa2df26a1cc23185d9fb8e32160a2fe626bda835c81232ba10092cec9d40e175cd1b8d', '0e2bb59c3bcb8304e7879ed1a7a6f099be74cde005a814ea57df1e8cd670f19f0638cfaddecfd1804632bbac599a34729c23d6a9b0bdfdc5ab87f29bfe040194'), ('eb61e401-00aa-405d-9746-788e0cb8171e'::uuid, '2021-06-16T08:40:16.025499+00:00'::timestamptz, '2021-06-16T08:40:16.025541+00:00'::timestamptz, 'artifact/aa/71e111378ebf86acc7cc3be9342bd531686e7da57c4ba9d11dce28568356fd', 8
        Process 21565: INSERT INTO "core_artifact" ("pulp_id", "pulp_created", "pulp_last_updated", "file", "size", "md5", "sha1", "sha224", "sha256", "sha384", "sha512") VALUES ('c7b9cbea-b8fb-4de8-ace5-9cd656c57f9b'::uuid, '2021-06-16T08:40:15.723890+00:00'::timestamptz, '2021-06-16T08:40:15.723913+00:00'::timestamptz, 'artifact/aa/71e111378ebf86acc7cc3be9342bd531686e7da57c4ba9d11dce28568356fd', 83759432, NULL, '2144350cd1442c7cb26ca6bc9d8d62723cb885de', '822899be4cb83ecb84951913d66b6e77c9b75d9d17e610b835ab4445', 'aa71e111378ebf86acc7cc3be9342bd531686e7da57c4ba9d11dce28568356fd', 'fe2f747706bdb6e59fd6e072a4ef4de240f4aaaa5fee3230a5a8386d9efdfc45561c066dfb55577eb10c150db5189aee', '28e0923bce01f818c174868538c3fb321c469458485978d8a0dff93ea2efbddbcb2de9e671a9924197fd3e74b7c99d43d1bf8a0744e3277ea1f7e5827ddc358f'), ('b2e45e1b-5201-40a0-be7c-eabe5de5b81f'::uuid, '2021-06-16T08:40:15.834199+00:00'::timestamptz, '2021-06-16T08:40:15.834241+00:00'::timestamptz, 'artifact/44/414c7788cd8a1722906fb34bb019290d1269bb24bbf3ce9f1d63fe15464354', 8
127.0.0.1(43873):60c9b8ea.5449:2021-06-16 04:40:17.065 EDT:app=[unknown]:pid=21577:HINT:  See server log for query details.
127.0.0.1(43873):60c9b8ea.5449:2021-06-16 04:40:17.065 EDT:app=[unknown]:pid=21577:CONTEXT:  while inserting index tuple (10762,2) in relation "core_artifact_sha256_key"
127.0.0.1(43873):60c9b8ea.5449:2021-06-16 04:40:17.065 EDT:app=[unknown]:pid=21577:STATEMENT:  INSERT INTO "core_artifact" ("pulp_id", "pulp_created", "pulp_last_updated", "file", "size", "md5", "sha1", "sha224", "sha256", "sha384", "sha512") VALUES ('15b7946a-1e75-461c-99d9-c2244eea44e0'::uuid, '2021-06-16T08:40:16.019791+00:00'::timestamptz, '2021-06-16T08:40:16.019827+00:00'::timestamptz, 'artifact/44/414c7788cd8a1722906fb34bb019290d1269bb24bbf3ce9f1d63fe15464354', 83110084, NULL, 'ca43066416a794b8cfb822eff9ebf9f28cb202cd', '6699ad24ccbecc3508bc22d5890f489ea047518d4e43c4766a39e33a', '44414c7788cd8a1722906fb34bb019290d1269bb24bbf3ce9f1d63fe15464354', 'dbff1aaf5bec37bbe77a028826fa2df26a1cc23185d9fb8e32160a2fe626bda835c81232ba10092cec9d40e175cd1b8d', '0e2bb59c3bcb8304e7879ed1a7a6f099be74cde005a814ea57df1e8cd670f19f0638cfaddecfd1804632bbac599a34729c23d6a9b0bdfdc5ab87f29bfe040194'), ('eb61e401-00aa-405d-9746-788e0cb8171e'::uuid, '2021-06-16T08:40:16.025499+00:00'::timestamptz, '2021-06-16T08:40:16.025541+00:00'::timestamptz, 'artifact/aa/71e111378ebf86acc7cc3be9342bd531686e7da57c4ba9d11dce28568356fd', 83759432, NULL, '2144350cd1442c7cb26ca6bc9d8d62723cb885de', '822899be4cb83ecb84951913d66b6e77c9b75d9d17e610b835ab4445', 'aa71e111378ebf86acc7cc3be9342bd531686e7da57c4ba9d11dce28568356fd', 'fe2f747706bdb6e59fd6e072a4ef4de240f4aaaa5fee3230a5a8386d9efdfc45561c066dfb55577eb10c150db5189aee', '28e0923bce01f818c174868538c3fb321c469458485978d8a0dff93ea2efbddbcb2de9e671a9924197fd3e74b7c99d43d1bf8a0744e3277ea1f7e5827ddc358f'), ('6ad9c70e-1b89-4141-80d8-5c08c62a6391'::uuid, '2021-06-16T08:40:16.026218+00:00'::timestamptz, '2021-06-16T08:40:16.026239+00:00'::timestamptz, 'artifact/01/41012c79a64e19eb7226de0c92f7132aaf85aba98c90fde4190a912e646bbf', 83113088, NULL, 'e916686c96edb4552054fb6de000ccfcb6bf3740', 'fe480371f7cd2a95c36d0e1b42f8d6179838f5bd6f8e97de9b5fcd8c', '0141012c79a64e19eb7226de0c92f7132aaf85aba98c90fde4190a912e646bbf', '5523d2af63f3f39676e86776871f13fbcd45c540eec274a7bd2df31bba1aaf9619d1e6abfa175ebcf16c0aa69642ffe0', 'cec5e688a31602bab11595f5316e5c0ce7278271a612737d9b41a67f1b9873713781b2f1bdec8b0f7d6a0e27728a831714bd99d79cec7916e3d7751f09976369'), ('52688fd7-23ef-40da-8f0e-680ecf79af9e'::uuid, '2021-06-16T08:40:16.026752+00:00'::timestamptz, '2021-06-16T08:40:16.026772+00:00'::timestamptz, 'artifact/2a/20884fea781c0e27b39ea3def7da7e5c829c0c26fe9cca8a9a9a7317adc580', 81421384, NULL, '63e540ef02aad8dc10395a31c1e8c52f62e9c25b', 'c93578e511e306afde1a50307eacd61647ce30020b4f5d36c11983e4', '2a20884fea781c0e27b39ea3def7da7e5c829c0c26fe9cca8a9a9a7317adc580', 'b438fc8d7efcfdebe356ab35bedf4ac61fabbff4cddb09885a570c7fc95aca1f594e2b32e8eefed03c9274c35eadd60d', '799fdc774c33e1c9227c5c5a9d50cc421ab053899de630e65ae48420d5af204839c4674f7a2e5c474a056d2ad64f65a5506825fab94db838e7cef1e4de032be7') RETURNING "core_artifact"."pulp_id"

Actions

Copy link

Updated by rchan almost 3 years ago

Sprint changed from Sprint 98 to Sprint 99

Actions

Copy link

#10

Updated by ttereshc almost 3 years ago

Subject changed from Deadlock on rpm repository sync to Deadlock on rpm repository pulp2pulp sync

Actions

Copy link

#11

Updated by rchan almost 3 years ago

Sprint changed from Sprint 99 to Sprint 100

Actions

Copy link

#12

Updated by dalley almost 3 years ago

Has duplicate Issue #8985: deadlock detected during pulp3 to pulp3 sync added

Actions

Copy link

#13

Updated by dalley almost 3 years ago

Tags Katello added

Actions

Copy link

#14

Updated by dalley almost 3 years ago

Status changed from NEW to ASSIGNED
Assignee set to dalley

Actions

Copy link

#15

Updated by dalley almost 3 years ago

Related to Issue #9082: deadlock during rpm repo sync: " CONTEXT: while inserting index tuple (1,9) in relation "rpm_package_pkgId_key"" added

Actions

Copy link

#16

Updated by rchan almost 3 years ago

Sprint changed from Sprint 100 to Sprint 101

Actions

Copy link

#17

Updated by dalley almost 3 years ago

Status changed from ASSIGNED to NEW
Assignee deleted (~~dalley~~)

Actions

Copy link

#18

Updated by dalley almost 3 years ago

Status changed from NEW to CLOSED - DUPLICATE

Actions

Copy link

#19

Updated by dalley almost 3 years ago

Status changed from CLOSED - DUPLICATE to NEW

Actions

Copy link

#20

Updated by dalley almost 3 years ago

Related to deleted (Issue #9082: deadlock during rpm repo sync: " CONTEXT: while inserting index tuple (1,9) in relation "rpm_package_pkgId_key"")

Actions

Copy link

#21

Updated by dalley almost 3 years ago

Has duplicate Issue #9082: deadlock during rpm repo sync: " CONTEXT: while inserting index tuple (1,9) in relation "rpm_package_pkgId_key"" added

Actions

Copy link

#22

Updated by dalley almost 3 years ago

See duplicates and BZ for more details

Actions

Copy link

#23

Updated by dalley over 2 years ago

Related to Issue #8963: deadlock when synching Foreman proxy added

Actions

Copy link

#24

Updated by dalley over 2 years ago

Related to deleted (Issue #8963: deadlock when synching Foreman proxy)

Actions

Copy link

#25

Updated by dalley over 2 years ago

Has duplicate Issue #8963: deadlock when synching Foreman proxy added

Actions

Copy link

#26

Updated by ggainey over 2 years ago

Status changed from NEW to ASSIGNED
Assignee set to ggainey

Actions

Copy link

#27

Updated by ggainey over 2 years ago

I can reproduce this problem at-will on core/3.11 and rpm/3.10. However, I cannot reproduce it, at all, on pulpcore-latest.

It's possible the new tasking-system has changed the timing enough that we no longer fall into the window. But there have also been A LOT of changes between 3.11 and Now.

The script I'm using to recreate is here:

https://github.com/ggainey/pulp_startup/blob/main/8750_deadlocks/repro_3-11.sh

(Same but with --autopublish for latest: https://github.com/ggainey/pulp_startup/blob/main/8750_deadlocks/repro.sh )

I'm going to try to reproduce on exactly core/3.14, rpm/3.13; I also have a lock-ordering theory that will try out on 3.11-et-al. Will report back here with results.

Actions

Copy link

#28

Updated by ggainey over 2 years ago

Update from QE - problem can be recreated on 3.14, but only by turning on the Olde Taskinge Systemme . Investigation continues.

Actions

Copy link

#29

Updated by ipanova@redhat.com over 2 years ago

Sprint changed from Sprint 101 to Sprint 102

Actions

Copy link

#30

Updated by rchan over 2 years ago

Sprint changed from Sprint 102 to Sprint 103

Actions

Copy link

#31

Updated by jsherril@redhat.com over 2 years ago

We've hit this on the new tasking system in 3.14: https://community.theforeman.org/t/katello-nightly-rpm-pipeline-1061-failed/24932

Actions

Copy link

#32

Updated by rchan over 2 years ago

Sprint changed from Sprint 103 to Sprint 104

Actions

Copy link

#33

Updated by dalley over 2 years ago

One more report: https://community.theforeman.org/t/helpful-warning-smart-proxies-in-pulp3-4-1-use-a-lot-more-ram/25105/4

Actions

Copy link

#34

Updated by dalley over 2 years ago

Has duplicate Issue #9343: Deadlock during sync added

Actions

Copy link

#35

Updated by rchan over 2 years ago

Sprint changed from Sprint 104 to Sprint 105

Actions

Copy link

#36

Updated by ttereshc over 2 years ago

Copied to Backport #9379: Backport "Deadlock on rpm repository pulp2pulp sync"to 3.14.z added

Actions

Copy link

#37

Updated by Skullman over 2 years ago

More examples: python3-pulpcore-3.14.5-2 python3-pulp-rpm-3.14.2-1

Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]: pulp [62672f3c1f5844b29a8c0869db07cf4c]: pulpcore.tasking.pulpcore_worker:INFO: Task a2d9b01f-3a62-4f35-8ad6-9b793c43a9c1 failed (deadlock detected
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]: DETAIL:  Process 244121 waits for ShareLock on transaction 2141154; blocked by process 244124.
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]: Process 244124 waits for ShareLock on transaction 2141157; blocked by process 244121.
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]: HINT:  See server log for query details.
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]: CONTEXT:  while updating tuple (24547,1) in relation "core_artifact"
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]: )
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]: pulp [62672f3c1f5844b29a8c0869db07cf4c]: pulpcore.tasking.pulpcore_worker:INFO:   File "/usr/lib/python3.6/site-packages/pulpcore/tasking/pulpcore_worker.py", line 272, in _perform_task
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    result = func(*args, **kwargs)
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/pulp_rpm/app/tasks/synchronizing.py", line 475, in synchronize
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    version = dv.create()
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/declarative_version.py", line 151, in create
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    loop.run_until_complete(pipeline)
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib64/python3.6/asyncio/base_events.py", line 484, in run_until_complete
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    return future.result()
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/api.py", line 225, in create_pipeline
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    await asyncio.gather(*futures)
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/api.py", line 43, in __call__
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    await self.run()
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/artifact_stages.py", line 89, in run
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    existing_artifacts.touch()
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/pulpcore/app/models/content.py", line 103, in touch
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    return self.update(timestamp_of_interest=now())
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/django/db/models/query.py", line 741, in update
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    rows = query.get_compiler(self.db).execute_sql(CURSOR)
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1471, in execute_sql
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    cursor = super().execute_sql(result_type)
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1142, in execute_sql
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    cursor.execute(sql, params)
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    return executor(sql, params, many, context)
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    return self.cursor.execute(sql, params)
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    raise dj_exc_value.with_traceback(traceback) from exc_value
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
Sep 15 06:42:11 pulp314-machine pulpcore-worker[49536]:    return self.cursor.execute(sql, params)

Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]: pulp [7b40012f6a534fb89265b6f5048677f1]: pulpcore.tasking.pulpcore_worker:INFO: Task a598f9f2-5e00-445b-85d4-f8a9baa85328 failed (deadlock detected
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]: DETAIL:  Process 245936 waits for ShareLock on transaction 2154128; blocked by process 245931.
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]: Process 245931 waits for ShareLock on transaction 2154127; blocked by process 245936.
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]: HINT:  See server log for query details.
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]: CONTEXT:  while updating tuple (1306,29) in relation "core_contentartifact"
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]: )
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]: pulp [7b40012f6a534fb89265b6f5048677f1]: pulpcore.tasking.pulpcore_worker:INFO:   File "/usr/lib/python3.6/site-packages/pulpcore/tasking/pulpcore_worker.py", line 272, in _perform_task
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    result = func(*args, **kwargs)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/pulp_rpm/app/tasks/synchronizing.py", line 475, in synchronize
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    version = dv.create()
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/declarative_version.py", line 151, in create
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    loop.run_until_complete(pipeline)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib64/python3.6/asyncio/base_events.py", line 484, in run_until_complete
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    return future.result()
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/api.py", line 225, in create_pipeline
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    await asyncio.gather(*futures)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/api.py", line 43, in __call__
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    await self.run()
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/content_stages.py", line 151, in run
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    ContentArtifact.objects.bulk_update(to_update_ca_bulk, ["artifact"])
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    return getattr(self.get_queryset(), name)(*args, **kwargs)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/django/db/models/query.py", line 525, in bulk_update
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    self.filter(pk__in=pks).update(**update_kwargs)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/django/db/models/query.py", line 741, in update
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    rows = query.get_compiler(self.db).execute_sql(CURSOR)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1471, in execute_sql
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    cursor = super().execute_sql(result_type)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1142, in execute_sql
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    cursor.execute(sql, params)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    return executor(sql, params, many, context)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    return self.cursor.execute(sql, params)
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    raise dj_exc_value.with_traceback(traceback) from exc_value
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
Sep 15 07:26:09 pulp314-machine pulpcore-worker[48925]:    return self.cursor.execute(sql, params)

Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]: pulp [49271f8bee164dc8ab0d9df7183796ea]: pulpcore.tasking.pulpcore_worker:INFO: Task 578dbe28-c9b7-4e87-b68e-6d5beb15aa32 failed (deadlock detected
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]: DETAIL:  Process 258618 waits for ShareLock on transaction 2192080; blocked by process 258632.
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]: Process 258632 waits for ShareLock on transaction 2192082; blocked by process 258618.
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]: HINT:  See server log for query details.
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]: CONTEXT:  while inserting index tuple (106599,2) in relation "rpm_package_pkgId_key"
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]: )
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]: pulp [49271f8bee164dc8ab0d9df7183796ea]: pulpcore.tasking.pulpcore_worker:INFO:   File "/usr/lib/python3.6/site-packages/pulpcore/tasking/pulpcore_worker.py", line 272, in _perform_task
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    result = func(*args, **kwargs)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/pulp_rpm/app/tasks/synchronizing.py", line 475, in synchronize
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    version = dv.create()
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/declarative_version.py", line 151, in create
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    loop.run_until_complete(pipeline)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib64/python3.6/asyncio/base_events.py", line 484, in run_until_complete
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    return future.result()
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/api.py", line 225, in create_pipeline
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    await asyncio.gather(*futures)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/api.py", line 43, in __call__
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    await self.run()
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/pulpcore/plugin/stages/content_stages.py", line 113, in run
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    d_content.content.save()
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/pulpcore/app/models/base.py", line 149, in save
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    return super().save(*args, **kwargs)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django_lifecycle/mixins.py", line 134, in save
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    save(*args, **kwargs)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/models/base.py", line 744, in save
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    force_update=force_update, update_fields=update_fields)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/models/base.py", line 782, in save_base
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    force_update, using, update_fields,
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/models/base.py", line 873, in _save_table
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/models/base.py", line 911, in _do_insert
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    using=using, raw=raw)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    return getattr(self.get_queryset(), name)(*args, **kwargs)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/models/query.py", line 1186, in _insert
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    return query.get_compiler(using=using).execute_sql(return_id)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1377, in execute_sql
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    cursor.execute(sql, params)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    return executor(sql, params, many, context)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    return self.cursor.execute(sql, params)
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    raise dj_exc_value.with_traceback(traceback) from exc_value
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:  File "/usr/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
Sep 15 12:53:35 pulp314-machine pulpcore-worker[49383]:    return self.cursor.execute(sql, params)

Actions

Copy link

#38

Updated by pulpbot over 2 years ago

Status changed from ASSIGNED to POST

PR: https://github.com/pulp/pulpcore/pull/1637

Actions

Copy link

#39

Updated by rchan over 2 years ago

Sprint changed from Sprint 105 to Sprint 106

Added by ggainey over 2 years ago

Revision 6af3519b | View on GitHub

Fix occasional deadlocks when doing multiple similar syncs concurrently.

Forcing deadlocks requires a lot of time and pulpcore-workers running. There is therefore no specific CI test for this, but there is a reproducer script that will force deadlocks to happen (and show that they're fixed) here:

https://github.com/ggainey/pulp_startup/blob/main/8750_deadlocks/file_repro.sh

fixes #8750. [nocoverage]

Actions

Copy link

#40

Updated by ggainey over 2 years ago

Status changed from POST to MODIFIED

Applied in changeset pulpcore|6af3519b4931bd34c49653a80c52fd1c7cd08821.

Actions

Copy link

#41

Updated by pulpbot over 2 years ago

Sprint/Milestone set to 3.16.0

Actions

Copy link

#42

Updated by pulpbot over 2 years ago

Status changed from MODIFIED to CLOSED - CURRENTRELEASE

Actions

Send by e-mail Copy link

Also available in: Atom PDF

Project

Profile

Help

Pulp

Agile boards

Custom queries

Issue #8750

Deadlock on rpm repository pulp2pulp sync

Updated by ggainey almost 3 years ago

Updated by fao89 almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley almost 3 years ago

Updated by rchan almost 3 years ago

Updated by wibbit almost 3 years ago

Updated by rchan almost 3 years ago

Updated by ttereshc almost 3 years ago

Updated by rchan almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley almost 3 years ago

Updated by rchan almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley almost 3 years ago

Updated by dalley over 2 years ago

Updated by dalley over 2 years ago

Updated by dalley over 2 years ago

Updated by ggainey over 2 years ago

Updated by ggainey over 2 years ago

Updated by ggainey over 2 years ago

Updated by ipanova@redhat.com over 2 years ago

Updated by rchan over 2 years ago

Updated by jsherril@redhat.com over 2 years ago

Updated by rchan over 2 years ago

Updated by dalley over 2 years ago

Updated by dalley over 2 years ago

Updated by rchan over 2 years ago

Updated by ttereshc over 2 years ago

Updated by Skullman over 2 years ago

Updated by pulpbot over 2 years ago

Updated by rchan over 2 years ago

Added by ggainey over 2 years ago

Updated by ggainey over 2 years ago

Updated by pulpbot over 2 years ago

Updated by pulpbot over 2 years ago