Critical error wp_comments

v7vTC2P6

I ran on large tables via CLI and had this error for wp_comments.

This all worked on the staging site although there may be a few differences in versions between the 2 versions.

Are you able to see the reason this may have happened?

Index WP MySQL For Speed 1.4.5
Versions  Plugin:1.4.5 MySQL:8.0.22-13 WordPress:42 WordPress database:53496 php                      :7.4.14
WordPress database error Incorrect table definition; there can be only one auto                       column and it must be defined as a key for query ALTER TABLE wp_comments DROP PR                      IMARY KEY, ADD PRIMARY KEY (comment_post_ID, comment_ID)/**imfs-query-tag*228526                      253*/ made by include('phar:///usr/local/bin/wp/php/boot-phar.php'), include('ph                      ar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap,                       WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run                      _command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->inv                      oke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closur                      e}, call_user_func, ImsfCli->enable, ImsfCli->doRekeying, ImfsDb->rekeyTables, I                      mfsDb->rekeyTable, ImfsDb->query
Error: There has been a critical error on this website.Learn more about troubles                      hooting WordPress. There has been a critical error on this website.

thanks
Mike