[woolfy]

Hello, i have the same problem and think it just needs an additional check for the connection state and perhaps try a reconnect before throwing the 1305 error. Here is the way to reproduce it:

 

— execute a function on an out-timed connection

select myStoredFunction();

— results in an error, but not because the function does not exist, only because the connection has gone away

Error Code: 1305

FUNCTION myStoredFunction does not exist

— execute some query without using a function will trigger a reconnect

show tables;

— e.g.: select * from myTable; or similar would also work

/*[10:39:23][65 ms] SQLyog reconnected */

/*[10:39:23][42 ms]*/ show tables;

— after that, the function call works again

select myStoredFunction();

 

Best regards,

Jens

[Author]

Posts