MySQL patches by Codership

Bug #815079
Comment #1

Comment 1 for bug 815079

Revision history for this message

Seppo Jaakola (seppo-jaakola) wrote on 2011-07-23:

Applier:
Thread 7 (Thread 0x7f33bdba0700 (LWP 30721)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x00000000009bc3ff in safe_cond_wait (cond=0x23b5db8, mp=0x23b5d40, file=0xb1d002 "os/os0sync.c", line=422) at thr_mutex.c:237
#2 0x00000000008c747f in os_event_wait_low (event=0x23b5d40, reset_sig_count=0) at os/os0sync.c:422
#3 0x00000000008f089a in srv_suspend_mysql_thread (thr=0x7f33e049a8d8) at srv/srv0srv.c:1567
#4 0x00000000008db22b in row_mysql_handle_errors (new_err=0x7f33bdb9db50, trx=0x7f33e046c8b8, thr=0x7f33e049a8d8, savept=0x7f33bdb9db20) at row/row0mysql.c:497
#5 0x00000000008dc2fc in row_insert_for_mysql (mysql_rec=0x7f33b8037048 "\341\021", prebuilt=0x7f33e04618b8) at row/row0mysql.c:1177
#6 0x00000000008698a6 in ha_innobase::write_row (this=0x7f33b8036e58, record=0x7f33b8037048 "\341\021") at handler/ha_innodb.cc:4473
#7 0x000000000077ae2c in handler::ha_write_row (this=0x7f33b8036e58, buf=0x7f33b8037048 "\341\021") at handler.cc:4722
#8 0x000000000073b94e in Rows_log_event::write_row (this=0x7f33b80d0b68, rli=0x48d8ce0, overwrite=false) at log_event.cc:8675
#9 0x000000000073baa7 in Write_rows_log_event::do_exec_row (this=0x7f33b80d0b68, rli=0x48d8ce0) at log_event.cc:8846
#10 0x0000000000737326 in Rows_log_event::do_apply_event (this=0x7f33b80d0b68, rli=0x48d8ce0) at log_event.cc:7617
#11 0x0000000000639e50 in Log_event::apply_event (this=0x7f33b80d0b68, rli=0x48d8ce0) at log_event.h:1067
#12 0x0000000000637c9e in wsrep_bf_apply_rbr (thd=0x48c73e8, rbr_buf=0x7f33b00ae000 "\a,)N\023", buf_len=0) at sql_parse.cc:8420
#13 0x0000000000638286 in wsrep_bf_apply_cb (ctx=0x48c73e8, data=0x7f33bdb9ea80, global_seqno=986647) at sql_parse.cc:8502
#14 0x00007f33bfa39db6 in ?? () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#15 0x00007f33bfa3b951 in ?? () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#16 0x00007f33bfa3be5e in galera::ReplicatorSMM::apply_trx(void*, galera::TrxHandle*) () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#17 0x00007f33bfa41440 in galera::ReplicatorSMM::process_trx(void*, galera::TrxHandle*) () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#18 0x00007f33bfa37c23 in galera::GcsActionSource::dispatch(void*, void const*, unsigned long, gcs_act_type, long, long) () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#19 0x00007f33bfa38091 in galera::GcsActionSource::process(void*) () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#20 0x00007f33bfa3cf50 in galera::ReplicatorSMM::async_recv(void*) () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#21 0x00007f33bfa4ecc3 in galera_recv () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#22 0x00000000006386fc in wsrep_replication_process (thd=0x48c73e8) at sql_parse.cc:8619
#23 0x00000000006153f8 in start_wsrep_THD (arg=0x638632) at mysqld.cc:4484
#24 0x00007f33e2b20971 in start_thread (arg=<value optimized out>) at pthread_create.c:304
#25 0x00007f33e1d8a92d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#26 0x0000000000000000 in ?? ()

Victim:
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x00000000009bc3ff in safe_cond_wait (cond=0x23b5cd8, mp=0x23b5c60, file=0xb1d002 "os/os0sync.c", line=422) at thr_mutex.c:237
#2 0x00000000008c747f in os_event_wait_low (event=0x23b5c60, reset_sig_count=0) at os/os0sync.c:422
#3 0x00000000008f089a in srv_suspend_mysql_thread (thr=0x7f33e04930b8) at srv/srv0srv.c:1567
#4 0x00000000008db22b in row_mysql_handle_errors (new_err=0x7f33bdb5c5f8, trx=0x7f33e047b0b8, thr=0x7f33e04930b8, savept=0x0) at row/row0mysql.c:497
#5 0x00000000008e9ddc in row_search_for_mysql (buf=0x4928628 "\341O", mode=1, prebuilt=0x7f33e04810b8, match_mode=0, direction=1) at row/row0sel.c:4436
#6 0x000000000086b45b in ha_innobase::general_fetch (this=0x4928438, buf=0x4928628 "\341O", direction=1, match_mode=0) at handler/ha_innodb.cc:5394
#7 0x000000000086b58d in ha_innobase::index_next (this=0x4928438, buf=0x4928628 "\341O") at handler/ha_innodb.cc:5430
#8 0x0000000000779d84 in handler::read_range_next (this=0x4928438) at handler.cc:4337
#9 0x0000000000779859 in handler::read_multi_range_next (this=0x4928438, found_range_p=0x7f33bdb5cd18) at handler.cc:4218
#10 0x000000000075ef69 in QUICK_RANGE_SELECT::get_next (this=0x49040a0) at opt_range.cc:8566
#11 0x000000000076bc2c in rr_quick (info=0x7f33bdb5cdd0) at records.cc:331
#12 0x00000000006e581a in mysql_update (thd=0x7f33b00cbf78, table_list=0x49cc9e0, fields=..., values=..., conds=0x496de50, order_num=0, order=0x0, limit=18446744073709551614, handle_duplicates=DUP_ERROR,
    ignore=false) at sql_update.cc:529
#13 0x0000000000629bf5 in mysql_execute_command (thd=0x7f33b00cbf78) at sql_parse.cc:3581
#14 0x00000000006333bc in mysql_parse (thd=0x7f33b00cbf78,
    rawbuf=0x49cc788 "UPDATE comm01 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (43799*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (43799*z % 65537)) % 65537, r = RAND() WHERE r > 0.515168 A"..., length=215, found_semicolon=0x7f33bdb5e958) at sql_parse.cc:6623
#15 0x0000000000623fc0 in dispatch_command (command=COM_QUERY, thd=0x7f33b00cbf78,
    packet=0x7f33b00ceaf9 "UPDATE comm01 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (43799*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (43799*z % 65537)) % 65537, r = RAND() WHERE r > 0.515168 A"..., packet_length=215) at sql_parse.cc:1492
#16 0x0000000000622c55 in do_command (thd=0x7f33b00cbf78) at sql_parse.cc:1064
#17 0x000000000062027c in handle_one_connection (arg=0x7f33b00cbf78) at sql_connect.cc:1309
#18 0x00007f33e2b20971 in start_thread (arg=<value optimized out>) at pthread_create.c:304
#19 0x00007f33e1d8a92d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#20 0x0000000000000000 in ?? ()
(gdb) f 15
#15 0x0000000000623fc0 in dispatch_command (command=COM_QUERY, thd=0x7f33b00cbf78,
    packet=0x7f33b00ceaf9 "UPDATE comm01 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (43799*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (43799*z % 65537)) % 65537, r = RAND() WHERE r > 0.515168 A"..., packet_length=215) at sql_parse.cc:1492
1492 mysql_parse(thd, thd->query(), thd->query_length(), &end_of_stmt);
(gdb) p thd->thread_id
$10 = 8564

Applier:
Thread 7 (Thread 0x7f33bdba0700 (LWP 30721)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1  0x00000000009bc3ff in safe_cond_wait (cond=0x23b5db8, mp=0x23b5d40, file=0xb1d002 "os/os0sync.c", line=422) at thr_mutex.c:237
#2  0x00000000008c747f in os_event_wait_low (event=0x23b5d40, reset_sig_count=0) at os/os0sync.c:422
#3  0x00000000008f089a in srv_suspend_mysql_thread (thr=0x7f33e049a8d8) at srv/srv0srv.c:1567
#4  0x00000000008db22b in row_mysql_handle_errors (new_err=0x7f33bdb9db50, trx=0x7f33e046c8b8, thr=0x7f33e049a8d8, savept=0x7f33bdb9db20) at row/row0mysql.c:497
#5  0x00000000008dc2fc in row_insert_for_mysql (mysql_rec=0x7f33b8037048 "\341\021", prebuilt=0x7f33e04618b8) at row/row0mysql.c:1177
#6  0x00000000008698a6 in ha_innobase::write_row (this=0x7f33b8036e58, record=0x7f33b8037048 "\341\021") at handler/ha_innodb.cc:4473
#7  0x000000000077ae2c in handler::ha_write_row (this=0x7f33b8036e58, buf=0x7f33b8037048 "\341\021") at handler.cc:4722
#8  0x000000000073b94e in Rows_log_event::write_row (this=0x7f33b80d0b68, rli=0x48d8ce0, overwrite=false) at log_event.cc:8675
#9  0x000000000073baa7 in Write_rows_log_event::do_exec_row (this=0x7f33b80d0b68, rli=0x48d8ce0) at log_event.cc:8846
#10 0x0000000000737326 in Rows_log_event::do_apply_event (this=0x7f33b80d0b68, rli=0x48d8ce0) at log_event.cc:7617
#11 0x0000000000639e50 in Log_event::apply_event (this=0x7f33b80d0b68, rli=0x48d8ce0) at log_event.h:1067
#12 0x0000000000637c9e in wsrep_bf_apply_rbr (thd=0x48c73e8, rbr_buf=0x7f33b00ae000 "\a,)N\023", buf_len=0) at sql_parse.cc:8420
#13 0x0000000000638286 in wsrep_bf_apply_cb (ctx=0x48c73e8, data=0x7f33bdb9ea80, global_seqno=986647) at sql_parse.cc:8502
#14 0x00007f33bfa39db6 in ?? () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#15 0x00007f33bfa3b951 in ?? () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#16 0x00007f33bfa3be5e in galera::ReplicatorSMM::apply_trx(void*, galera::TrxHandle*) () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#17 0x00007f33bfa41440 in galera::ReplicatorSMM::process_trx(void*, galera::TrxHandle*) () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#18 0x00007f33bfa37c23 in galera::GcsActionSource::dispatch(void*, void const*, unsigned long, gcs_act_type, long, long) () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#19 0x00007f33bfa38091 in galera::GcsActionSource::process(void*) () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#20 0x00007f33bfa3cf50 in galera::ReplicatorSMM::async_recv(void*) () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#21 0x00007f33bfa4ecc3 in galera_recv () from /home/seppo/work/testing/node2/galera/lib/libgalera_smm.so
#22 0x00000000006386fc in wsrep_replication_process (thd=0x48c73e8) at sql_parse.cc:8619
#23 0x00000000006153f8 in start_wsrep_THD (arg=0x638632) at mysqld.cc:4484
#24 0x00007f33e2b20971 in start_thread (arg=<value optimized out>) at pthread_create.c:304
#25 0x00007f33e1d8a92d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#26 0x0000000000000000 in ?? ()

Victim:
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1  0x00000000009bc3ff in safe_cond_wait (cond=0x23b5cd8, mp=0x23b5c60, file=0xb1d002 "os/os0sync.c", line=422) at thr_mutex.c:237
#2  0x00000000008c747f in os_event_wait_low (event=0x23b5c60, reset_sig_count=0) at os/os0sync.c:422
#3  0x00000000008f089a in srv_suspend_mysql_thread (thr=0x7f33e04930b8) at srv/srv0srv.c:1567
#4  0x00000000008db22b in row_mysql_handle_errors (new_err=0x7f33bdb5c5f8, trx=0x7f33e047b0b8, thr=0x7f33e04930b8, savept=0x0) at row/row0mysql.c:497
#5  0x00000000008e9ddc in row_search_for_mysql (buf=0x4928628 "\341O", mode=1, prebuilt=0x7f33e04810b8, match_mode=0, direction=1) at row/row0sel.c:4436
#6  0x000000000086b45b in ha_innobase::general_fetch (this=0x4928438, buf=0x4928628 "\341O", direction=1, match_mode=0) at handler/ha_innodb.cc:5394
#7  0x000000000086b58d in ha_innobase::index_next (this=0x4928438, buf=0x4928628 "\341O") at handler/ha_innodb.cc:5430
#8  0x0000000000779d84 in handler::read_range_next (this=0x4928438) at handler.cc:4337
#9  0x0000000000779859 in handler::read_multi_range_next (this=0x4928438, found_range_p=0x7f33bdb5cd18) at handler.cc:4218
#10 0x000000000075ef69 in QUICK_RANGE_SELECT::get_next (this=0x49040a0) at opt_range.cc:8566
#11 0x000000000076bc2c in rr_quick (info=0x7f33bdb5cdd0) at records.cc:331
#12 0x00000000006e581a in mysql_update (thd=0x7f33b00cbf78, table_list=0x49cc9e0, fields=..., values=..., conds=0x496de50, order_num=0, order=0x0, limit=18446744073709551614, handle_duplicates=DUP_ERROR, 
    ignore=false) at sql_update.cc:529
#13 0x0000000000629bf5 in mysql_execute_command (thd=0x7f33b00cbf78) at sql_parse.cc:3581
#14 0x00000000006333bc in mysql_parse (thd=0x7f33b00cbf78, 
    rawbuf=0x49cc788 "UPDATE comm01 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (43799*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (43799*z % 65537)) % 65537, r = RAND() WHERE r > 0.515168 A"..., length=215, found_semicolon=0x7f33bdb5e958) at sql_parse.cc:6623
#15 0x0000000000623fc0 in dispatch_command (command=COM_QUERY, thd=0x7f33b00cbf78, 
    packet=0x7f33b00ceaf9 "UPDATE comm01 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (43799*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (43799*z % 65537)) % 65537, r = RAND() WHERE r > 0.515168 A"..., packet_length=215) at sql_parse.cc:1492
#16 0x0000000000622c55 in do_command (thd=0x7f33b00cbf78) at sql_parse.cc:1064
#17 0x000000000062027c in handle_one_connection (arg=0x7f33b00cbf78) at sql_connect.cc:1309
#18 0x00007f33e2b20971 in start_thread (arg=<value optimized out>) at pthread_create.c:304
#19 0x00007f33e1d8a92d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#20 0x0000000000000000 in ?? ()
(gdb) f 15
#15 0x0000000000623fc0 in dispatch_command (command=COM_QUERY, thd=0x7f33b00cbf78, 
    packet=0x7f33b00ceaf9 "UPDATE comm01 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (43799*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (43799*z % 65537)) % 65537, r = RAND() WHERE r > 0.515168 A"..., packet_length=215) at sql_parse.cc:1492
1492	    mysql_parse(thd, thd->query(), thd->query_length(), &end_of_stmt);
(gdb) p thd->thread_id
$10 = 8564