Bug #121619 ndb reports Scan already complete

• Submitted: 26 Oct 21:36
• Reporter: Jiyuan Li
• Status: Open
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 9.3.0-cluster
• OS: Ubuntu (24.04)
• CPU Architecture: Any

[26 Oct 21:36] Jiyuan Li

Description:
Executing transactions in NDB cluster reports `Scan already complete'

How to repeat:
-- session S0
  START TRANSACTION;
  SELECT c0 FROM t0 WHERE c0=0 FOR UPDATE;
  SELECT SLEEP(3);
  COMMIT;

  -- session S1
  SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
  SET SESSION innodb_lock_wait_timeout=2;
  START TRANSACTION;
  SELECT c3 FROM t0 WHERE c3=3 FOR UPDATE;

  SELECT /*+ NO_BNL(t2) */
         DISTINCT COUNT(t2.c1), COUNT(1)
  FROM t0, t2
  ORDER BY t0.c1
  LIMIT 1;