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.

Bug #1204849 reported by Roel Van de Paar on 2013-07-25
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.7
5.1
Undecided
Unassigned
5.5
High
Unassigned
5.6
High
Unassigned
5.7
High
Unassigned

Bug Description

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

Tags: qa Edit Tag help
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :

[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"

Roel Van de Paar (roel11) wrote :

100% upstream.

tags: added: upstream

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

tags: removed: upstream

Likely related to bug 1719555

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.