Bug #39885 Heavy DDL opertations causes hang due to error 266 in ndb_global_schema_lock
| Submitted: | 6 Oct 2008 14:42 | Modified: | 7 Oct 2008 23:04 |
|---|---|---|---|
| Reporter: | Jonathan Miller | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S2 (Serious) |
| Version: | 5.1-telco | OS: | Linux |
| Assigned to: | Tomas Ulin | CPU Architecture: | Any |
[7 Oct 2008 8:19]
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/55536 2688 Tomas Ulin 2008-10-07 Bug#39885 Heavy DDL opertaions causes hand due to error 266 in ndb_global_schema_lock
[7 Oct 2008 21:19]
Tomas Ulin
fixed in cluster 6.2.16 and 6.3.19
[7 Oct 2008 23:04]
Jon Stephens
Documented bugfix in the NDB-6.2.16 and NDB-6.3.19 changelogs as follows:
Heavy DDL usage caused the mysqld processes to hang due to a
timeout error (NDB error code 266).
[12 Dec 2008 23:30]
Bugs System
Pushed into 6.0.7-alpha (revid:tomas.ulin@sun.com-20081007081931-b2aakh63fwn6bp14) (version source revid:tomas.ulin@sun.com-20081015121427-mqe9vyomt1jroewp) (pib:5)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.041 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: In stress testing DDL operations in clone mysql-5.1-telco-6.3 the cluster/mysqld's hung during testing: #5 0x00000000007c82e1 in ndbcluster_no_global_schema_lock_abort (thd=0x2aaaac0fa140, msg=0xacadb0 "ha_ndbcluster::alter_table_phase1") at ha_ndbcluster_binlog.cc:763 763 abort(); (gdb) l 758 Thd_ndb *thd_ndb= get_thd_ndb(thd); 759 if (thd_ndb && thd_ndb->global_schema_lock_error != 0) 760 return HA_ERR_NO_CONNECTION; 761 sql_print_error("NDB: programming error, no lock taken while running " 762 "query %s. Message: %s", thd->query, msg); 763 abort(); 764 } 765 766 #include "ha_ndbcluster_lock_ext.h" 767 How to repeat: Setup a 2 mysqld, 2 DN cluster with bin logging Startup 2 cid_ndb_dd.pl against different DB's and different MySQLD's Statup the load_and_drop.pl against 1 st MySQLD Startup add_online.pl against second mysqld Startup TPCB_looper.sh against the second mysqld.