The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-05-19. For the latest, interactive version please visit https://mariadb.com/kb/.

Error #1558

You are viewing an old version of this question. View the current version here.

I am using a QNAP TS250+ NAS with MariaDB10 which I have used for just Tables.

Now, for university work, I need to design Routines (Stored Procedures).

When I do this I get error #1558 which gives :-

MySQL said: #1558 - Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50557, now running 100508. Please use mariadb-upgrade to fix this error

It seems this is an ubgrade issue but I'm already using the highest upgrade available.

Can anyone help me?

Answer

You aren't clear about which version you're using (you say MariaDB 10, but there's MariaDB 10.3, which is end-of-life, MariaDB 10.11, the latest long-term release, MariaDB 11.3, the latest short-term release, etc. The 21st column in mysql.proc was added in MariaDB 10.3. This error likely means you haven't upgraded properly from an earlier version, as mariadb-upgrade usually takes care of this. See Upgrading Between Major MariaDB Versions.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.