[MDEV-4001] Cassandra: server crashes in ha_cassandra::end_bulk_insert on INSERT .. SELECT with a non-existing column Created: 2013-01-05  Updated: 2013-05-28  Resolved: 2013-05-28

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.1
Fix Version/s: 10.0.3

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: cassandra

Issue Links:
Relates
relates to MDEV-431 Cassandra storage engine Closed

 Description   

#4  <signal handler called>
#5  0x0857945a in ha_cassandra::end_bulk_insert (this=0xbcfab30) at 10.0-base-cassandra/storage/cassandra/ha_cassandra.cc:2055
#6  0x08239eca in handler::ha_end_bulk_insert (this=0xbcfab30) at 10.0-base-cassandra/sql/handler.h:1966
#7  0x0823834e in select_insert::abort_result_set (this=0xbcf85b8) at 10.0-base-cassandra/sql/sql_insert.cc:3697
#8  0x08278f13 in handle_select (thd=0xbce9480, lex=0xbceab5c, result=0xbcf85b8, setup_tables_done_option=1073741824) at 10.0-base-cassandra/sql/sql_select.cc:374
#9  0x0824edb7 in mysql_execute_command (thd=0xbce9480) at 10.0-base-cassandra/sql/sql_parse.cc:3138
#10 0x082563b2 in mysql_parse (thd=0xbce9480, rawbuf=0xbcf7b08 "insert into t1 (a) select b from t1", length=35, parser_state=0x98579d84) at 10.0-base-cassandra/sql/sql_parse.cc:5874
#11 0x0824a285 in dispatch_command (command=COM_QUERY, thd=0xbce9480, packet=0xbcec759 "insert into t1 (a) select b from t1", packet_length=35) at 10.0-base-cassandra/sql/sql_parse.cc:1072
#12 0x08249751 in do_command (thd=0xbce9480) at 10.0-base-cassandra/sql/sql_parse.cc:811
#13 0x083414da in do_handle_one_connection (thd_arg=0xbce9480) at 10.0-base-cassandra/sql/sql_connect.cc:1253
#14 0x08341025 in handle_one_connection (arg=0xbce9480) at 10.0-base-cassandra/sql/sql_connect.cc:1168
#15 0xb777ee32 in start_thread () from /lib/libpthread.so.0

cqlsh:manual_test> create columnfamily cf1 ( rowkey int primary key, a int );

create table t1 (rowkey int primary key, a int) 
ENGINE=CASSANDRA 
thrift_host='127.0.0.1' keyspace='manual_test' column_family='cf1';
 
insert into t1 (a) select b from t1;

The table (or, rather, the column family) does not have to be empty: if something was inserted through another table, or through the same table but server was restarted after that, the provided INSERT .. SELECT still causes a crash. However, if I run a valid INSERT first, and then try the one above without restarting server, it works all right (throws the expected ERROR 1054 (42S22): Unknown column 'b' in 'field list').

bzr version-info
revision-id: psergey@askmonty.org-20121224043622-xn8g8y3vhtu1lb3w
revno: 3459
branch: 10.0-base-cassandra


Generated at Thu Feb 08 06:52:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.