Database Issue: Cannot load from mysql.proc. The table is probably corrupted

[mricardi]

Hi guys,
I've been very active these days, sorry about that 😅

Now Itried to execute a sp in the database, but I got this error:
Cannot load from mysql.proc. The table is probably corrupted

could you give me a hand?

If the simplest solution is to recreate the database,
I have a dump from before the migration so If necessary I can recreate it
just let me know

[Unknown025]

An administrator might be able to help with this. I've escalated your thread so one can weigh in.

[Krydos]

I only see one database, but which table exactly are you having issues with? I did check table and repair table on all of them and nothing was broken and nothing needed repaired.

[mricardi]

Hi @Krydos how are you?

the tables are working perfectly I think that the issue is with the routines
To reproduce the error, you can try running this query in the database:

CALL apply_payment_to_debts(54);

I think something happened to the routines in the db

[Krydos]

Try it now.

[mricardi]

@Krydos now it works!!

Just as a comment, I think the routines I had in the database were lost during the migration
It’s not a big deal, I already recreated them using the scripts I took from the backup

now everything is working perfectly!!
thank you so much for your help!!

[Krydos]

1 minute ago, mricardi said:

Just as a comment, I think the routines I had in the database were lost during the migration

I'll add that to the list of possible known issues regarding the server to server moves. If we can recreate the issue we may be able to fix it for future moves. Thanks.