Bug #19770 Repeated DDL ops causes second MySQLD to signal 11
Submitted: 12 May 2006 13:20 Modified: 15 Jun 2006 10:32
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S1 (Critical)
Version:5.1.11 OS:Linux (Linux 32 Bit OS)
Assigned to: Tomas Ulin CPU Architecture:Any

[12 May 2006 13:20] Jonathan Miller
Description:
key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x96dcb60
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xb7f258c4, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81dbfd2
0x1ae420
0x83bf56e
0x83bf56e
0x83bb59a
0x83c2370
0x83be2db
0x82d7d66
0x82d8673
0x82cff7b
0x82af4c2
0x82c5d8c
0x82d63cd
0x82da8e4
0x684b80
0x5dc9ce

0x81dbfd2 handle_segfault + 438
0x1ae420 (?)
0x83bf56e _ZN21NdbEventOperationImplD1Ev + 40
0x83bf56e _ZN21NdbEventOperationImplD1Ev + 40
0x83bb59a _ZN17NdbEventOperationD1Ev + 58
0x83c2370 _ZN14NdbEventBuffer20createEventOperationEPKcR8NdbError + 154
0x83be2db _ZN3Ndb20createEventOperationEPKc + 47
0x82d7d66 _Z27ndbcluster_create_event_opsP19st_ndbcluster_sharePKN13NdbDictionary5TableEPKc + 7020x82d8673 _Z30ndbcluster_create_binlog_setupP3NdbPKcjS2_S2_c + 973
0x82cff7b _ZN13ha_ndbcluster6createEPKcP8st_tableP24st_ha_create_information + 273
0x82af4c2 _Z27ha_create_table_from_engineP3THDPKcS2_ + 610
0x82c5d8c _Z28ndb_create_table_from_engineP3THDPKcS2_ + 104
0x82d63cd _Z37ndb_binlog_thread_handle_schema_eventP3THDP3NdbP17NdbEventOperationP4ListI14Cluster_schemaES8_P11st_mem_root + 383
0x82da8e4 ndb_binlog_thread_func + 2168
0x684b80 (?)
0x5dc9ce (?)

How to repeat:
Master Cluster:
host 1 ndb_mgm, ndbd
host 2 ndbd
host 3 mysqld, mysqld
host 4 mysqld, mysqld
Slave Cluster:
host 1 ndb_mgm, ndbd, MySQLD
host 2 ndbd
Tests:
host 1 cid_ndb_dd.pl
host 3 TPC-B (8) total, 4 against each mysqld.

Second MySQLD on host 4 crashed.
[14 Jun 2006 10:04] Tomas Ulin
pushed to 5.1.12
[15 Jun 2006 10:32] Jon Stephens
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented in 5.1.12 changelog. Closed.