Upgrade to v3 failed due to migration error about postal HOT 9 CLOSED

#!/bin/bash

# Get a list of all databases
databases=$(mysql -u your_username -p'your_password' -e 'SHOW DATABASES;' | grep -Ev 'Database|information_schema|performance_schema|mysql')

# Loop through each database
for db in $databases; do
    # Get a list of all tables in the current database
    tables=$(mysql -u your_username -p'your_password' $db -e 'SHOW TABLES;' | grep -v 'Tables_in_')

    # Loop through each table
    for table in $tables; do
        # Execute the ALTER TABLE command, quoting table names with backticks
        mysql -u your_username -p'your_password' $db -e "ALTER TABLE \`$table\` ROW_FORMAT=DYNAMIC;"
    done
done

== 20240214132253 AddLockFieldsToWebhookRequests: migrating ===================
-- add_column(:webhook_requests, :locked_by, :string)
   -> 0.0105s
-- add_column(:webhook_requests, :locked_at, :datetime, {:precision=>nil})
   -> 0.0147s
-- add_index(:webhook_requests, :locked_by)
rake aborted!
StandardError: An error has occurred, all later migrations canceled: (StandardError)

Mysql2::Error: Index column size too large. The maximum column size is 767 bytes
/usr/local/bundle/gems/mysql2-0.5.6/lib/mysql2/client.rb:151:in `_query'
/usr/local/bundle/gems/mysql2-0.5.6/lib/mysql2/client.rb:151:in `block in query'
/usr/local/bundle/gems/mysql2-0.5.6/lib/mysql2/client.rb:150:in `handle_interrupt'
/usr/local/bundle/gems/mysql2-0.5.6/lib/mysql2/client.rb:150:in `query'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:638:in `block (2 levels) in raw_execute'
/usr/local/bundle/gems/activesupport-7.0.8.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'