Re: Problems with Scheduling event to Call Stored Procedure

[Antonio Reale]

Roel Van de Paar Wrote:
-------------------------------------------------------
> Please provide output of:
>
> mysql> SHOW EVENTS;

I have the same problem with mysql-5.1.32 ndb-7.0.5.
Here's my "SHOW EVENTS;":
"kamailio" "create_cdr" "root@%" "SYSTEM" "RECURRING" (NULL) "1" "MINUTE" 2009-09-17 13:16:45 (NULL) "ENABLED" 0 "utf8" "utf8_general_ci" "latin1_swedish_ci"

Event scheduler global variable is ON.

The field "last execute" in the EVENTS table reports that the event is executed but I can't see the results. If I execute manually "call SP()" the stored procedure works.

I tried to debug with "mysqladmin debug" but it doesn't show any output.

Could you please provide some tips to debug this problem?
Thanks. Regards,

Antonio