On a 9.41 system I believe I have most if not all of my duplicates cleaned up however when I run it via Drush I am now getting the following:
> [error] Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO "cache_discovery" ("cid", "expire", "created", "tags", "checksum", "data", "serialized") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6) ON DUPLICATE KEY UPDATE "cid" = VALUES("cid"), "expire" = VALUES("expire"), "created" = VALUES("created"), "tags" = VALUES("tags"), "checksum" = VALUES("checksum"), "data" = VALUES("data"), "serialized" = VALUES("serialized"); Array
> (
> [:db_insert_placeholder_0] => last_write_timestamp_cache_discovery
> [:db_insert_placeholder_1] => -1
> [:db_insert_placeholder_2] => 1656001491.813
> [:db_insert_placeholder_3] =>
> [:db_insert_placeholder_4] => 0
> [:db_insert_placeholder_5] => d:1656001491.814;
> [:db_insert_placeholder_6] => 1
> )
> in Drupal\Core\Cache\DatabaseBackend->doSetMultiple() (line 273 of /home/sites/sitename/public_html/core/lib/Drupal/Core/Cache/DatabaseBackend.php).
> [error] Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT savepoint_1 does not exist: ROLLBACK TO SAVEPOINT savepoint_1; Array
> (
> )
> in Drupal\Core\Entity\Sql\SqlContentEntityStorage->delete() (line 757 of /home/sites/sitename/public_html/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
>
> In SqlContentEntityStorage.php line 811:
>
> SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT savepoint
> _1 does not exist: ROLLBACK TO SAVEPOINT savepoint_1; Array
> (
> )
>
>
> In ExceptionHandler.php line 53:
>
> SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT savepoint
> _1 does not exist: ROLLBACK TO SAVEPOINT savepoint_1; Array
> (
> )
>
>
> In StatementWrapper.php line 145:
>
> SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT savepoint
> _1 does not exist
>
>
In ProcessBase.php line 155:
Output is empty.
Suggestions?
Postponed: needs info
2.0
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
@Christopher Riley Can this be reproduced everytime you run it? Or does it only happen from time to time?
Deadlocks can be very specific, see https://www.percona.com/blog/how-to-deal-with-mysql-deadlocks/
If you encounter it all the time, there might be an issue with the module's logic.