Procedure does not exist. Error 1305 MariaDB

Asked Sep 18 '19 at 19:08

Active Sep 18 '19 at 19:56

Viewed 505 times

My server has been automatically updated from Mariadb 5.5.60 to 5.5.64. From that moment on, no stored procedure is executed. I get the error 1305: Procedure xxxx does not exist. I've been reviewing privileges for hours and I can't find the problem.

Someone help me?

The Trigger user is `bduser`@`%`

This is the start of procedure:

CREATE DEFINER=`bduser`@`%` PROCEDURE `dnpd_actualizar`(...

User `bduser`@`%` has granted: SUPER, EXECUTE, TRIGGER, and ALL PRIVILEGES and EXECUTE ON PROCEDURE.

Thanks.

edited Sep 18 '19 at 19:56

asked Sep 18 '19 at 19:08

Guillermo Herrera

Do `SHOW CREATE PROCEDURE dnpd_actualizar`. Does it exist? Who was the definer? What about the collation? – Rick James Sep 18 '19 at 20:03
Yes, exists. The definer is bduser@% y the collation is utf8_general_ci. Thanks. – Guillermo Herrera Sep 18 '19 at 22:05

Procedure does not exist. Error 1305 MariaDB

0 Answers0