The mysql stored procedure has been inserted successfully only once. What is the reason for this?

Today, we encountered a strange problem. For the same batch insertion, one can be inserted successfully in batch, but the other cannot be inserted successfully. Please take a look at it.

the following is pseudo code

-- A (SQL)( SQL )
CREATE PROCEDURE `A`()
  BEGIN
    REPLACE INTO `table` (`num`) 
      SELECT SUM(`num`) AS `num`
      FROM `table`;
  END;

-- B ( A)
CREATE PROCEDURE `B`()
  BEGIN
    WHILE 100 DO
      CALL `A`;
    END WHILE;
  END;

the above two stored procedures are my code logic, each time REPLACE INTO. SELECT. takes about 0.2 seconds.
when I call CALL `B` , only the first entry is inserted successfully, and no other entries are inserted and no error is reported. The SQL statements generated by
are error-free because printed statements can be inserted in bulk manually.

what"s even weirder is that I have other REPLACE INTO. With the same function. SELECT. (relatively short execution time, 0.01s), but it can be inserted successfully in batch.

is this caused by the lock? I use the InnoDB storage engine.

< hr >

there may be some things that I am not quite clear about:

the above code is pseudocode, and there is no problem with loop structure and generation and execution of SQL
three main issues are discussed here:
- caused by a row lock (not supposed to be)
- same table, same query structure, why short execution time can be inserted (0.001 level), long execution time can not be inserted (0.1level)
- whether the execution procedure is called during execution, whether it is executed by Synchronize or asynchronously (that is, whether to go through the process after the completion of the CALL execution, or to move on to the next cyclic process until the completion of the execution)

delimiter $$ CREATE PROCEDURE `A`() BEGIN REPLACE INTO `sumtable` (`id`,`mysum`) SELECT 0 AS `id`,SUM(`mysum`) AS `mysum` FROM `sumtable`; END; $$ -- B ( A) CREATE PROCEDURE `B`() BEGIN DECLARE v1 INT DEFAULT 100; WHILE v1>0 DO CALL `A`; SET v1 = v1 - 1; END WHILE; END; $$

CREATE PROCEDURE `A`() BEGIN SET $sql = 'REPLACE INTO `table` (`num`) SELECT SUM(`num`) AS `num` FROM `table`;'; SET @sql = $sql; PREPARE STMT FROM @sql; EXECUTE STMT; DEALLOCATE PREPARE STMT; END; CREATE PROCEDURE `B`() BEGIN WHILE 100 DO CALL `A`; END WHILE; END;