abort in get_const_ordered_table_node | sql/sql_base.cc:9661: Const_ordered_table_node* Join_node::get_const_ordered_table_node(const TABLE*): Assertion `0' failed.

[Roel Van de Paar]

Thread 1 (LWP 24259):
+bt
#0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000686bde in handle_fatal_signal (sig=6) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x000000340c4328a5 in raise () from /lib64/libc.so.6
#4 0x000000340c434085 in abort () from /lib64/libc.so.6
#5 0x000000340c42ba1e in __assert_fail_base () from /lib64/libc.so.6
#6 0x000000340c42bae0 in __assert_fail () from /lib64/libc.so.6
#7 0x00000000006c05ea in get_const_ordered_table_node (table=<optimized out>, this=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:9661
#8 get_ordered_column_node (field=<optimized out>, this=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:9679
#9 Join_node::add_equi_column (this=0x7f7511aa2b90, left=0x7f748c0e8790, right=0x7f748c01c050) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:9701
#10 0x00000000006c28c6 in Join_node::add_const_equi_columns (this=0x7f7511aa2b90, cond=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:9769
#11 0x00000000006cd258 in add_join_list (join_list=0x14e6ae0 <end_of_list>, this=0x7f7511aa2b90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:9622
#12 add_join_list (join_list=0x7f748c015170, this=0x7f7511aa2b90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:9619
#13 Join_node (order=0x7f748c0f8470, cond=0x7f748c019c08, join_list=0x7f748c015170, this=0x7f7511aa2b90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:9638
#14 is_order_deterministic (join_list=0x7f748c015170, cond=0x7f748c019c08, order=0x7f748c0f8470) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:9837
#15 0x00000000008bdc7b in JOIN::optimize (this=0x7f748c0f86a8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_optimizer.cc:276
#16 0x0000000000749279 in mysql_execute_select (free_join=true, select_lex=0x26e8f68, thd=0x26e6490) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1087
#17 mysql_select (thd=0x26e6490, tables=0x7f748c005bf0, wild_num=0, fields=..., conds=0x7f748c019c08, order=<optimized out>, group=0x26e9068, having=0x0, select_options=3489925888, result=0x7f748c0f8568, unit=0x26e8920, select_lex=0x26e8f68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1222
#18 0x0000000000749dbb in handle_select (thd=0x26e6490, result=0x7f748c0f8568, setup_tables_done_option=1073741824) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:111
#19 0x0000000000726748 in mysql_execute_command (thd=0xffffffffffffdc58) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3727
#20 0x0000000000727818 in mysql_parse (thd=0x26e6490, rawbuf=0x26e8858 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#21 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x26e6490, packet=0x26ea421 "INSERT INTO transforms.insert_select_24257 SELECT table1 . `col_char_latin1_not_null` AS field1 FROM table1_innodb_key_pk_parts_2_int_autoinc AS table1 LEFT JOIN table1_int_autoinc AS table2 LEFT JOIN table1_key_pk_parts_2_int_autoinc AS table3 ON table2 . `col_int_key` = table3 . `pk` ON table1 . `col_int_key` = table2 . `col_int_key` WHERE table3 . `pk` >= 7 AND table3 . `pk` <= ( 8 + 2 ) AND table1 . `col_int_key` > 8 AND table1 . `col_int_key` < ( 8 + 5 ) OR table1 . `col_int_key` IS NULL OR table1 . `col_int_key` >= 0 OR table2 . `pk` IN (8, 8, 2) OR table1 . `col_int_key` <> 3 AND table1 . `col_int` IN (2, 8, 5) AND table1 . `col_int_key` != 5 AND table3 . `col_int_key` > 8 AND table3 . `col_int_key` <= ( 8 + 5 ) AND table2 . `pk` IS NULL OR table2 . `pk` NOT IN (75) AND table2 . `pk` BETWEEN 8 AND (8 + 35 ) OR table2 . `pk` BETWEEN 8 AND (8 + 2 ) OR table2 . `pk` <> 4 ORDER BY field1 LIMIT 100 ", packet_length=934) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#22 0x0000000000729a47 in do_command (thd=0x26e6490) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#23 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#24 0x00000000006ed727 in handle_one_connection (arg=0x26e6490) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#25 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x2669440) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#26 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#27 0x000000340c4e890d in clone () from /lib64/libc.so.6

=================

2013-07-17 19:30:46 24039 [Note] /ssd/Percona-Server-5.6.12-rc60.4-405-debug.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.6.12-rc60.4-debug-log' socket: '/ssd/209184/current1_7/tmp/master.sock' port: 13120 Percona Server with XtraDB (GPL), Release rc60.4, Revision 405-debug
mysqld: /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:9661: Const_ordered_table_node* Join_node::get_const_ordered_table_node(const TABLE*): Assertion `0' failed.
16:34:23 UTC - mysqld got signal 6 ;
[...]
Query (7f748c004c50): INSERT INTO transforms.insert_select_24257 SELECT table1 . `col_char_latin1_not_null` AS field1 FROM table1_innodb_key_pk_parts_2_int_autoinc AS table1 LEFT JOIN table1_int_autoinc AS table2 LEFT JOIN table1_key_pk_parts_2_int_autoinc AS table3 ON table2 . `col_int_key` = table3 . `pk` ON table1 . `col_int_key` = table2 . `col_int_key` WHERE table3 . `pk` >= 7 AND table3 . `pk` <= ( 8 + 2 ) AND table1 . `col_int_key` > 8 AND table1 . `col_int_key` < ( 8 + 5 ) OR table1 . `col_int_key` IS NULL OR table1 . `col_int_key` >= 0 OR table2 . `pk` IN (8, 8, 2) OR table1 . `col_int_key` <> 3 AND table1 . `col_int` IN (2, 8, 5) AND table1 . `col_int_key` != 5 AND table3 . `col_int_key` > 8 AND table3 . `col_int_key` <= ( 8 + 5 ) AND table2 . `pk` IS NULL OR table2 . `pk` NOT IN (75) AND table2 . `pk` BETWEEN 8 AND (8 + 35 ) OR table2 . `pk` BETWEEN 8 AND (8 + 2 ) OR table2 . `pk` <> 4 ORDER BY field1 LIMIT 100

[Roel Van de Paar (roel11)]

[roel@qaserver 209184]$ cat cmd71
ps -ef | grep 'cmdrun_71' | grep -v grep | awk '{print $2}' | xargs sudo kill -9
rm -Rf /ssd/209184/cmdrun_71
mkdir /ssd/209184/cmdrun_71
cd /ssd/randgen
bash -c "set -o pipefail; perl /ssd/randgen/runall.pl --queries=100000000 --seed=1019 --duration=300 --querytimeout=60 --reporter=Shutdown,Backtrace,QueryTimeout,ErrorLog,ErrorLogAlarm --mysqld=--log-output=none --mysqld=--sql_mode=ONLY_FULL_GROUP_BY --mysqld=--slow_query_log --mysqld=--userstat --threads=25 --mysqld=--innodb_file_per_table=1 --validator=Transformer --basedir=/ssd/Percona-Server-5.6.12-rc60.4-405-debug.Linux.x86_64 --grammar=/tmp/976291/4.yy --gendata=/ssd/randgen/conf/replication/replication-6.0.zz --mtr-build-thread=707 --mask=12946 --vardir1=/ssd/209184/cmdrun_71 > /ssd/209184/cmdrun71.log 2>&1"

[Laurynas Biveinis (laurynas-biveinis)]

100% upstream.

[Laurynas Biveinis (laurynas-biveinis)]

Not upstream. This is introduced by us applying the patch at http://bugs.mysql.com/bug.php?id=42415

[Laurynas Biveinis (laurynas-biveinis)]

Likely related to bug 1719555

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-697