1. 

   graham.halsey, Member

   I noticed 1 core on our MySQL server supporting myDBR was constantly 100% busy. I used MONyog to trace SQL that was running against the database and found this type of query was running over and over:-

   insert into folders_tmp values ( NAME_CONST('inID',1), NAME_CONST('v_order',722342404) )

   I traced that to the body of the "sp_MyDBR_template_folder" stored procedure where there's a WHILE loop that must have got stuck in an infinite loop. It appears to have spun around that loop 722 million times!

   Qu) What does that stored procedure actually do?
   Qu) Does it matter that I killed it?
   Qu) Should there be a failsafe in there to prevent an infinite loop?

   Thanks,
   Graham.
2. 

   myDBR Team, Key Master

   Graham,
   the procedure reads out the template folder structure (folder tree). it it get's into an infinite loop, it means that the template folder structure is somehow corrupt (which should of course not happen). You can safely kill the process as it is just reading data.

   Could you run following query and send the output to support email. We'll help you to fix the issue.

   select id, parent_id from mydbr_template_folders;

   --
   myDBR Team

Reply

You must log in to post.