MySQL Bugs: #19778: RBR mysqlbinlog: Restoring to cluster database causes MySQLD to crash

Bug #19778	RBR mysqlbinlog: Restoring to cluster database causes MySQLD to crash
Submitted:	12 May 2006 17:41	Modified:	22 Feb 2007 14:40
Reporter:	Jonathan Miller	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Row Based Replication ( RBR )	Severity:	S1 (Critical)
Version:	5.1.11	OS:	Linux (Linux 32 Bit OS)
Assigned to:	Alexander Barkov	CPU Architecture:	Any

Description:
May be same as http://bugs.mysql.com/bug.php?id=17642

ndbdev@ndb08:~/jmiller/builds/bin> resolve_stack_dump -s /tmp/mysqld.sym -n  ./binlog1.trace
0x81dbfd2 net_clear + 50
0xa46420 (?)
0x4 (?)
0x82c1e05 _Z16create_sub_tablePKcS0_6DBTYPEi + 73
0x82b0645 _ZN12ha_partition9write_rowEPc + 65
0x827c77c _Z28fill_schema_table_privilegesP3THDP13st_table_listP4Item + 240
0x827c7c6 _Z28fill_schema_table_privilegesP3THDP13st_table_listP4Item + 314
0x827a4f3 _ZN28Format_description_log_eventD1Ev + 35
0x834da31 _ZN14partition_info20check_partition_infoEPP10handlertonP7handlery + 533
0x81fcf4c _Z21mysql_execute_commandP3THD + 8144
0x81fd25d _Z21mysql_execute_commandP3THD + 8929
0x81fdb40 _Z21mysql_execute_commandP3THD + 11204
0x81fec82 _Z21mysql_execute_commandP3THD + 15622
0x81ff039 _Z21mysql_execute_commandP3THD + 16573
0xa25b80 (?)
0x97d9ce (?)

How to repeat:
Setup a cluster with binlog. Add tables, data and then use mysqlbinlog to dump into a text file. Then run the text file in using mysql source command.

Changed category to a more appropriate one.

Jonathan, please proved a mysql-test case.

Hi,

As I thought the patch for http://bugs.mysql.com/bug.php?id=17642 also corrected the crash seen in this bug report. The test is attached showing that NDB now passes using the mysqlbinlog for restoring.

Best wishes,
Jonathan

Test results/reject file

Attachment: rpl_ndb_mysqlbinlog_base64.reject (application/octet-stream, text), 1.92 KiB.

Test file

Attachment: rpl_ndb_mysqlbinlog_base64.test (application/octet-stream, text), 1.14 KiB.