Bug #46490 Full table scan hangs with more than 21 fragments
| Submitted: | 31 Jul 2009 12:12 | Modified: | 6 Aug 2009 8:13 |
|---|---|---|---|
| Reporter: | Oli Sennhauser | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S2 (Serious) |
| Version: | mysql-5.1-telco-6.2 | OS: | Any |
| Assigned to: | Frazer Clement | CPU Architecture: | Any |
| Tags: | cluster, fragment, full, hang, scan, table | ||
[4 Aug 2009 10:38]
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/79988 2960 Frazer Clement 2009-08-04 Bug#46490 : Full table scan hangs with more than 21 fragments modified: storage/ndb/include/kernel/signaldata/ScanTab.hpp storage/ndb/src/kernel/blocks/dbtc/DbtcMain.cpp
[4 Aug 2009 10:53]
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/79991 2960 Frazer Clement 2009-08-04 Bug#46490 : Full table scan hangs with more than 21 fragments modified: storage/ndb/include/kernel/signaldata/ScanTab.hpp storage/ndb/src/kernel/blocks/dbtc/DbtcMain.cpp
[5 Aug 2009 12:59]
Jonas Oreland
pushed to 6.2.19, 6.3.26 and 7.0.7
[6 Aug 2009 8:13]
Jon Stephens
Documented bugfix in the NDB-6.2.19, 6.3.26, and 7.0.7 changelogs as follows:
Full table scans failed with more than 21 fragments.
The number of fragments is the number of data nodes, times 8
(that is, MAX_FRAG_PER_NODE), divided by the number of replicas.
Thus, when NoOfReplicas = 1 at least 3 data nodes were required
to trigger this issue, and when NoOfReplicas = 2 at least 4 data
nodes were required to do so.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.062 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.
Description: MySQL cluster hangs on full table scans and gets error at the end: ndb_select_all cache_update -d vm_vs > cache_update.select ERROR: 4008 Receive from NDB failed Status: Unknown result, Classification: Unknown result error File: select_all.cpp (Line: 442) How to repeat: There seems to be a rule not to create > 4 fragments/node so you need > 4 nodes to reproduce Then put data in and try some scans Sooner or later should get a hang In debug, the 'unhandled signals after execute()' results in a node crash Suggested fix: Frazer is looking...