Percona XtraDB Cluster - HA scalable solution for MySQL

UNIV_DEBUG crashes when binlogging is turned off

Reported by Raghavendra D Prabhu on 2013-05-20
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster
Raghavendra D Prabhu

Bug Description

When a debug build is used, the server crashes when binlogging is off.

#0 0x00007ffff637d1c9 in raise () from /usr/lib/
#1 0x00007ffff637e5c8 in abort () from /usr/lib/
#2 0x00007ffff6376356 in __assert_fail_base () from /usr/lib/
#3 0x00007ffff6376402 in __assert_fail () from /usr/lib/
#4 0x0000000000771e03 in TC_LOG_DUMMY::log_and_order (this=<optimized out>, thd=<optimized out>, xid=<optimized out>, all=<optimized out>, need_commit_ordered=<optimized out>) at /tmp/pbuild/sql/log.h:80
#5 0x00000000006d654f in ha_commit_trans (thd=thd@entry=0x2345630, all=all@entry=false) at /tmp/pbuild/sql/
#6 0x000000000066a198 in trans_commit_stmt (thd=thd@entry=0x2345630) at /tmp/pbuild/sql/
#7 0x00000000005aad8d in mysql_execute_command (thd=thd@entry=0x2345630) at /tmp/pbuild/sql/
#8 0x00000000005abf64 in mysql_parse (thd=thd@entry=0x2345630,
    rawbuf=rawbuf@entry=0x7fffa4024e80 "INSERT INTO sbtest1(k, c, pad) VALUES(14935, '08566691963-88624912351-16662227201-46648573979-64646226163-77505759394-75470094713-41097360717-15161106334-50535565977', '63188288836-92351140030-0639058"..., length=length@entry=524207, parser_state=parser_state@entry=0x7fffe4667730) at /tmp/pbuild/sql/
#9 0x00000000005acbd3 in wsrep_mysql_parse (thd=thd@entry=0x2345630,
    rawbuf=0x7fffa4024e80 "INSERT INTO sbtest1(k, c, pad) VALUES(14935, '08566691963-88624912351-16662227201-46648573979-64646226163-77505759394-75470094713-41097360717-15161106334-50535565977', '63188288836-92351140030-0639058"..., length=524207, parser_state=parser_state@entry=0x7fffe4667730) at /tmp/pbuild/sql/
#10 0x00000000005adb6a in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2345630,
    packet=packet@entry=0x23cadd1 "INSERT INTO sbtest1(k, c, pad) VALUES(14935, '08566691963-88624912351-16662227201-46648573979-64646226163-77505759394-75470094713-41097360717-15161106334-50535565977', '63188288836-92351140030-0639058"..., packet_length=packet_length@entry=524207) at /tmp/pbuild/sql/
#11 0x00000000005af904 in do_command (thd=0x2345630) at /tmp/pbuild/sql/
#12 0x000000000065b544 in do_handle_one_connection (thd_arg=thd_arg@entry=0x2345630) at /tmp/pbuild/sql/
#13 0x000000000065b77d in handle_one_connection (arg=0x2345630) at /tmp/pbuild/sql/
#14 0x00007ffff7bc6dd2 in start_thread () from /usr/lib/
#15 0x00007ffff642dced in clone () from /usr/lib/

The reason is:

class TC_LOG_DUMMY: public TC_LOG // use it to disable the logging
  int open(const char *opt_name) { return 0; }
  void close() { }
    TC_LOG_DUMMY is only used when there are <= 1 XA-capable engines, and we
    only use internal XA during commit when >= 2 XA-capable engines
  int log_and_order(THD *thd, my_xid xid, bool all,
                    bool need_commit_ordered)
    DBUG_ASSERT(0 /* Internal error - TC_LOG_DUMMY::log_and_order() called */); -------------------------------------------> It hits this assert


It crashed during

sysbench --test=./oltp.lua --db-driver=mysql --mysql-engine-trx=yes --mysql-table-engine=innodb --mysql-socket=/pxc/datadir/pxc.sock --mysql-user=root --mysql-password=test --oltp-table-size=30000 prepare

The config used is

Changed in percona-xtradb-cluster:
milestone: none → 5.5.31-24.8
assignee: nobody → Raghavendra D Prabhu (raghavendra-prabhu)
status: New → Fix Committed
no longer affects: codership-mysql
Changed in percona-xtradb-cluster:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers