Reduce expired oauth_tokens before 2.4.6 upgrade

This article provides a solution to the issue where you see a large number of oauth_tokens in your oauth_token table, which can cause a long delay in upgrading to version 2.4.6. It’s recommended to reduce the oauth_token table using the CleanExpiredTokens.php cron job to delete the expired tokens.

Affected products and versions

Issue

If there are a large number of oauth_tokens in your oauth_token table, that can cause a long delay in upgrading to version 2.4.6.

The upgrade process includes encrypting those tokens for an extra layer of security, and it’s only done 100 records at a time. This could take several hours if there is a large number of tokens.

Reducing a large number of oauth_tokens in your oauth_token table can prevent a long delay in upgrading to version 2.4.6.

Solution

Before starting an upgrade, first ensure that the CleanExpiredTokens.php cron job is running. It reduces the size of the oauth_token table by deleting the expired oauth_tokens tokens, and should already be enabled by default.

To manually trigger the CleanExpiredTokens.php cron job, run:
bin/magento cron:run --group=default

Related reading