Issue Can't upgrade MariaDB

[linuxman1]

Server operating system version

Alma Linux 8

Plesk version and microupdate number

18.0.68 Update 2

I have this issue blocking upgrade process, Restarting MySQL server ... Running mysqlcheck ... cloudfil_cloud.user_level warning : Found row where the auto_increment column has the value 0 The command exit code: 0

 

[Martin Dias]

In such cases, we do recommend for now to do the manual upgrade:

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

 

[Tsi-Shawn]

Martin can you explain why we need to do a manual upgrade when we get this error other than just tell us to do a manual upgrade.

 

[linuxman1]

I did the manual upgrade some days ago and it seems fine, no issues so far.

 

[Martin Dias]

Martin can you explain why we need to do a manual upgrade when we get this error other than just tell us to do a manual upgrade.

At the moment, the automatic tool does not yet support automatic fix of the increments being broken in tables. Since some warnings and error can cause big issues if ignored, the tool will not proceed.

It might be added in future depending on demand. No ETA or guarantee for such as of this moment.