MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

MySQL 8.0.28 - Call Stored Procedure stuck after dropping and re-creating
Posted by: Amol Gupta
Date: February 20, 2024 08:55AM

Hi
I am facing an issue after upgrading MySQL 5.7 to MySQL 8.0.28 whenever I am trying to edit stored procedure on new version MySQL 8.0.28.

As soon as I drop and re-create stored procedure , the concurrent connections on same stored procedure are stuck and in performance schema in event_Waits_history shows following events

wait/synch/mutex/innodb/lock_sys_page_mutex


I am using dbeaver tool to persist changes in stored procedure.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQL 8.0.28 - Call Stored Procedure stuck after dropping and re-creating
313
Amol Gupta
February 20, 2024 08:55AM


Sorry, only registered users may post in this forum.
Click here to login

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.