Unable to upgrade MariaDB via Plesk: Found row where the auto_increment column has the value 0

Symptoms

• Unable to upgrade MariaDB via Tools & Settings > Database Servers > Upgrade Now button with error:

  CONFIG_TEXT: Restarting MySQL server ...
  Running mysqlcheck ...
  db_name.table_name
  warning : Found row where the auto_increment column has the value 0
  The command exit code: 0

• While checking the table of database mentioned in the error message the ID there starts with 0 instead of 1:

  CONFIG_TEXT: MariaDB [db_name]> select id from table_name;
  +--+
  | id |
  +--+
  | 0 |
  | 1 |
  | 2 |
  | 3 |

Cause

According to MariaDB's official source, the AUTO_INCREMENT columns start from 1 by default. However, the internal logic of some third-party software creates tables with IDs starting from 0.

Resolution

Upgrade MariaDB version manually with the steps of the article below:
https://support.plesk.com/hc/en-us/articles/12388091703703-How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux