Attachment 1974001 Details for Bug 2219589 – txt file having the relevant logs when deadlock stuff happened.

txt file having the relevant logs when deadlock stuff happened.

2219589_deadlock_traceback.txt (text/plain), 21.13 KB, created by Sayan Das on 2023-07-04 13:04:35 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Sayan Das

Created: 2023-07-04 13:04:35 UTC

Size: 21.13 KB

patch

obsolete

>Upgrade log ( traceback part of it ): 
>
>2023-07-03 10:59:15 [ERROR ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: change from 'notrun' to ['0'] failed: 'pulpcore-manager migrate --noinput' returned 1 instead of one of [0]
>2023-07-03 10:59:15 [DEBUG ] [configure] Exec[pulpcore-manager migrate --noinput](provider=posix): Executing check 'pulpcore-manager migrate --plan | grep "No planned migration operations"'
>2023-07-03 10:59:15 [DEBUG ] [configure] Executing with uid=pulp: 'pulpcore-manager migrate --plan | grep "No planned migration operations"'
>2023-07-03 10:59:18 [DEBUG ] [configure] Exec[pulpcore-manager migrate --noinput](provider=posix): Executing 'pulpcore-manager migrate --noinput'
>2023-07-03 10:59:18 [DEBUG ] [configure] Executing with uid=pulp: 'pulpcore-manager migrate --noinput'
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: Operations to perform:
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   Apply all migrations: ansible, auth, certguard, container, contenttypes, core, file, rpm, sessions
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: Running migrations:
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   Applying core.0090_char_to_text_field...Traceback (most recent call last):
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     return self.cursor.execute(sql, params)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: psycopg2.errors.DeadlockDetected: deadlock detected
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: DETAIL:  Process 119422 waits for AccessExclusiveLock on relation 1620850 of database 585335; blocked by process 2915.
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: Process 2915 waits for AccessShareLock on relation 585593 of database 585335; blocked by process 119422.
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: HINT:  See server log for query details.
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: The above exception was the direct cause of the following exception:
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: Traceback (most recent call last):
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/bin/pulpcore-manager", line 33, in <module>
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     sys.exit(load_entry_point('pulpcore==3.21.6', 'console_scripts', 'pulpcore-manager')())
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/pulpcore/app/manage.py", line 11, in manage
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     execute_from_command_line(sys.argv)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     utility.execute()
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/core/management/__init__.py", line 413, in execute
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     self.fetch_command(subcommand).run_from_argv(self.argv)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/core/management/base.py", line 354, in run_from_argv
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     self.execute(*args, **cmd_options)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/core/management/base.py", line 398, in execute
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     output = self.handle(*args, **options)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/core/management/base.py", line 89, in wrapped
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     res = handle_func(*args, **kwargs)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 244, in handle
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     post_migrate_state = executor.migrate(
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/migrations/executor.py", line 117, in migrate
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/migrations/executor.py", line 227, in apply_migration
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     state = migration.apply(state, schema_editor)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/migrations/migration.py", line 126, in apply
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/migrations/operations/fields.py", line 244, in database_forwards
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     schema_editor.alter_field(from_model, from_field, to_field)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 608, in alter_field
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     self._alter_field(model, old_field, new_field, old_type, new_type,
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/backends/postgresql/schema.py", line 194, in _alter_field
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     self.execute(self._delete_index_sql(model, index_name))
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 145, in execute
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     cursor.execute(sql, params)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     return executor(sql, params, many, context)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     return self.cursor.execute(sql, params)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     raise dj_exc_value.with_traceback(traceback) from exc_value
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:   File "/usr/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns:     return self.cursor.execute(sql, params)
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: django.db.utils.OperationalError: deadlock detected
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: DETAIL:  Process 119422 waits for AccessExclusiveLock on relation 1620850 of database 585335; blocked by process 2915.
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: Process 2915 waits for AccessShareLock on relation 585593 of database 585335; blocked by process 119422.
>2023-07-03 10:59:39 [INFO  ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/returns: HINT:  See server log for query details.
>2023-07-03 10:59:39 [ERROR ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]: Failed to call refresh: 'pulpcore-manager migrate --noinput' returned 1 instead of one of [0]
>2023-07-03 10:59:39 [ERROR ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]: 'pulpcore-manager migrate --noinput' returned 1 instead of one of [0]
>2023-07-03 10:59:39 [DEBUG ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]: Evaluated in 49.88 seconds
>2023-07-03 10:59:39 [DEBUG ] [configure] Pulpcore::Admin[migrate --noinput]: Starting to evaluate the resource (2863 of 3023)
>
>
>
>postgres logs ( part of the deadlock stuff ):
>
>
>2023-07-03 10:39:21 EDT LOG:  duration: 1045.330 ms  statement: SELECT count(pulp_id) FROM core_remoteartifact WHERE md5 IS NULL AND sha1 IS NULL AND sha224 IS NULL AND sha256 IS NULL AND sha384 IS NULL AND sha512 IS NULL AND pulp_
>id NOT IN (SELECT pulp_id FROM core_remoteartifact WHERE sha1 IS NULL AND md5 IS NULL AND sha224 IS NULL AND sha384 IS NULL AND sha512 IS NULL AND sha256 IS NULL)
>2023-07-03 10:39:22 EDT LOG:  duration: 1014.225 ms  statement: SELECT count(pulp_id) FROM core_remoteartifact WHERE md5 IS NULL AND sha1 IS NULL AND sha224 IS NULL AND sha256 IS NULL AND sha384 IS NULL AND sha512 IS NULL AND pulp_
>id NOT IN (SELECT pulp_id FROM core_remoteartifact WHERE sha1 IS NULL AND md5 IS NULL AND sha224 IS NULL AND sha384 IS NULL AND sha512 IS NULL AND sha256 IS NULL)
>2023-07-03 10:39:22 EDT LOG:  duration: 1104.492 ms  statement: SELECT count(pulp_id) FROM core_remoteartifact WHERE md5 IS NULL AND sha1 IS NULL AND sha224 IS NULL AND sha256 IS NULL AND sha384 IS NULL AND sha512 IS NULL AND pulp_
>id NOT IN (SELECT pulp_id FROM core_remoteartifact WHERE sha1 IS NULL AND md5 IS NULL AND sha224 IS NULL AND sha384 IS NULL AND sha512 IS NULL AND sha256 IS NULL)
>2023-07-03 10:56:14 EDT LOG:  unexpected EOF on client connection with an open transaction
>2023-07-03 10:59:13 EDT LOG:  duration: 17663.938 ms  statement: ALTER TABLE "core_task" ALTER COLUMN "reserved_resources_record" TYPE text[] USING "reserved_resources_record"::text[]
>2023-07-03 10:59:14 EDT ERROR:  deadlock detected
>2023-07-03 10:59:14 EDT DETAIL:  Process 119384 waits for AccessExclusiveLock on relation 1620850 of database 585335; blocked by process 2915.
>        Process 2915 waits for AccessShareLock on relation 585593 of database 585335; blocked by process 119384.
>        Process 119384: DROP INDEX IF EXISTS "core_taskschedule_name_f9ade8e8_like"
>        Process 2915: SELECT "core_taskschedule"."pulp_id", "core_taskschedule"."pulp_created", "core_taskschedule"."pulp_last_updated", "core_taskschedule"."name", "core_taskschedule"."next_dispatch", "core_taskschedule"."dispatch_interval", "core_taskschedule"."task_name", "core_taskschedule"."last_task_id" FROM "core_taskschedule" LEFT OUTER JOIN "core_task" ON ("core_taskschedule"."last_task_id" = "core_task"."pulp_id") WHERE ("core_taskschedule"."next_dispatch" <= '2023-07-03T14:58:57.846890+00:00'::timestamptz AND ("core_taskschedule"."last_task_id" IS NULL OR "core_task"."state" IN ('skipped', 'completed', 'failed', 'canceled')))
>2023-07-03 10:59:14 EDT HINT:  See server log for query details.
>2023-07-03 10:59:14 EDT STATEMENT:  DROP INDEX IF EXISTS "core_taskschedule_name_f9ade8e8_like"
>2023-07-03 10:59:14 EDT LOG:  duration: 17098.414 ms  statement: SELECT "core_taskschedule"."pulp_id", "core_taskschedule"."pulp_created", "core_taskschedule"."pulp_last_updated", "core_taskschedule"."name", "core_taskschedule"."next_dispatch", "core_taskschedule"."dispatch_interval", "core_taskschedule"."task_name", "core_taskschedule"."last_task_id" FROM "core_taskschedule" LEFT OUTER JOIN "core_task" ON ("core_taskschedule"."last_task_id" = "core_task"."pulp_id") WHERE ("core_taskschedule"."next_dispatch" <= '2023-07-03T14:58:57.846890+00:00'::timestamptz AND ("core_taskschedule"."last_task_id" IS NULL OR "core_task"."state" IN ('skipped', 'completed', 'failed', 'canceled')))
>2023-07-03 10:59:27 EDT LOG:  checkpoints are occurring too frequently (20 seconds apart)
>2023-07-03 10:59:27 EDT HINT:  Consider increasing the configuration parameter "max_wal_size".
>2023-07-03 10:59:38 EDT LOG:  duration: 16260.023 ms  statement: ALTER TABLE "core_task" ALTER COLUMN "reserved_resources_record" TYPE text[] USING "reserved_resources_record"::text[]
>2023-07-03 10:59:39 EDT ERROR:  deadlock detected
>2023-07-03 10:59:39 EDT DETAIL:  Process 119422 waits for AccessExclusiveLock on relation 1620850 of database 585335; blocked by process 2915.
>        Process 2915 waits for AccessShareLock on relation 585593 of database 585335; blocked by process 119422.
>        Process 119422: DROP INDEX IF EXISTS "core_taskschedule_name_f9ade8e8_like"
>        Process 2915: SELECT "core_taskschedule"."pulp_id", "core_taskschedule"."pulp_created", "core_taskschedule"."pulp_last_updated", "core_taskschedule"."name", "core_taskschedule"."next_dispatch", "core_taskschedule"."dispatch_interval", "core_taskschedule"."task_name", "core_taskschedule"."last_task_id" FROM "core_taskschedule" LEFT OUTER JOIN "core_task" ON ("core_taskschedule"."last_task_id" = "core_task"."pulp_id") WHERE ("core_taskschedule"."next_dispatch" <= '2023-07-03T14:59:24.976970+00:00'::timestamptz AND ("core_taskschedule"."last_task_id" IS NULL OR "core_task"."state" IN ('skipped', 'completed', 'failed', 'canceled')))
>2023-07-03 10:59:39 EDT HINT:  See server log for query details.
>2023-07-03 10:59:39 EDT STATEMENT:  DROP INDEX IF EXISTS "core_taskschedule_name_f9ade8e8_like"
>2023-07-03 10:59:39 EDT LOG:  duration: 14430.568 ms  statement: SELECT "core_taskschedule"."pulp_id", "core_taskschedule"."pulp_created", "core_taskschedule"."pulp_last_updated", "core_taskschedule"."name", "core_taskschedule"."next_dispatch", "core_taskschedule"."dispatch_interval", "core_taskschedule"."task_name", "core_taskschedule"."last_task_id" FROM "core_taskschedule" LEFT OUTER JOIN "core_task" ON ("core_taskschedule"."last_task_id" = "core_task"."pulp_id") WHERE ("core_taskschedule"."next_dispatch" <= '2023-07-03T14:59:24.976970+00:00'::timestamptz AND ("core_taskschedule"."last_task_id" IS NULL OR "core_task"."state" IN ('skipped', 'completed', 'failed', 'canceled')))
>2023-07-03 11:07:01 EDT LOG:  unexpected EOF on client connection with an open transaction
>2023-07-03 11:08:00 EDT LOG:  duration: 14305.119 ms  statement: ALTER TABLE "core_task" ALTER COLUMN "reserved_resources_record" TYPE text[] USING "reserved_resources_record"::text[]
>2023-07-03 11:08:01 EDT ERROR:  deadlock detected
>
>
>

Actions: View

Attachments on bug 2219589: 1974001