Bug #42084 Only 11 TUP scans are allowed in parallel

• Submitted: 13 Jan 2009 14:32
• Modified: 15 Jan 2009 15:47
• Reporter: Jonas Oreland
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: *
• OS: Any
• Assigned to: Jonas Oreland
• CPU Architecture: Any

[13 Jan 2009 14:32] Jonas Oreland

Description:
ACC scans has a hard-limit of 11 parallel scans per fragment
TUP/TUX scans has no such limit, but is anyway currently limited to 30

However, the TUP scan was incorrectly also limited to ACC
as they where put in same queue (for waiting scans)

This effectively limited the SUM(ACC scans+TUP scans) to 11
Where the core code "supported" 11 ACC + 30 TUP scans per fragment

How to repeat:
run testprg in issue

Suggested fix:
Introduce different wait-queue of ACC/TUP scans

[13 Jan 2009 14:41] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/63118

2789 Jonas Oreland	2009-01-13
      ndb - bug#42084 - dont limit TUP scans to 11, introduce different queue for TUP scans, so that it can be handled correctly wrt ACC scans

[13 Jan 2009 15:22] Bugs System

Pushed into 5.1.30-ndb-6.2.17 (revid:[e-mail]-20090113144248-gyp8lp05f9gkftqi) (version source revid:[e-mail]-20090113144248-gyp8lp05f9gkftqi) (merge vers: 5.1.30-ndb-6.2.17) (pib:6)

[13 Jan 2009 15:23] Bugs System

Pushed into 5.1.30-ndb-6.3.21 (revid:[e-mail]-20090113144531-goxxcgj2zkrcefst) (version source revid:[e-mail]-20090113144531-goxxcgj2zkrcefst) (merge vers: 5.1.30-ndb-6.3.21) (pib:6)

[13 Jan 2009 15:24] Bugs System

Pushed into 5.1.30-ndb-6.4.1 (revid:[e-mail]-20090113150522-1kqdjb04on3f11x2) (version source revid:[e-mail]-20090113150522-1kqdjb04on3f11x2) (merge vers: 5.1.30-ndb-6.4.1) (pib:6)

[15 Jan 2009 15:47] Jon Stephens

Documented in the NDB-6.2.17/6.3.21/6.4.1 changelogs as follows:

        A maximum of 11 TUP scans were allowed in parallel.

[10 Feb 2009 20:13] Bugs System

Pushed into 6.0.10-alpha (revid:[e-mail]-20090210194937-s7xshv5l3m1v7wi9) (version source revid:[e-mail]-20090123110300-k3vjhnm1iop8c0h7) (merge vers: 6.0.10-alpha) (pib:6)