[MDEV-16521] Server crash with spider_quick_mode = 3 and CHECKSUM TABLE Created: 2018-06-19  Updated: 2018-08-01  Resolved: 2018-06-20

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Mattias Jonsson Assignee: Jacob Mathew (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Linux


Issue Links:
Duplicate
duplicates MDEV-16279 Spider crashes on CHECKSUM TABLE with... Closed

 Description   

With spider_quick_mode=3 and CHECKSUM TABLE t EXTENDED;

(As suggested in MDEV-16249)

#3  0x00007fabe5566960 in spider_db_mysql_row::store_to_tmp_table (this=0x7f97c8022810, tmp_table=0x7f97c809ae30, str=0x7faad83e3660)
    at /MariaDB/server/storage/spider/spd_db_mysql.cc:471
warning: Source file is more recent than executable.
471	  tmp_table->field[0]->set_notnull();
(gdb) p tmp_table
$1 = (TABLE *) 0x7f97c809ae30
(gdb) p tmp_table->field[0]
$2 = (Field *) 0x0
(gdb) bt
#0  0x00007fac2de32a01 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00007fac2e9e9fc2 in handle_fatal_signal (sig=11) at /MariaDB/server/sql/signal_handler.cc:305
#2  <signal handler called>
#3  0x00007fabe5566960 in spider_db_mysql_row::store_to_tmp_table (this=0x7f97c8022810, tmp_table=0x7f97c809ae30, str=0x7faad83e3660)
    at /MariaDB/server/storage/spider/spd_db_mysql.cc:471
#4  0x00007fabe550225b in spider_db_store_result (spider=spider@entry=0x7fa9f00227a0, link_idx=link_idx@entry=0, table=0x7fa9f0020f98)
    at /MariaDB/server/storage/spider/spd_db_conn.cc:4010
#5  0x00007fabe555534f in ha_spider::rnd_next_internal (this=0x7fa9f00227a0, buf=0x0) at /MariaDB/server/storage/spider/ha_spider.cc:7761
#6  0x00007fabe55556fa in ha_spider::pre_rnd_next (this=0x7fa9f00227a0, use_parallel=<optimized out>)
    at /MariaDB/server/storage/spider/ha_spider.cc:7832
#7  0x00007fac2ef2d77c in ha_partition::handle_pre_scan (this=this@entry=0x7fa9f0021b70, reverse_order=reverse_order@entry=false, 
    use_parallel=<optimized out>) at /MariaDB/server/sql/ha_partition.cc:7220
#8  0x00007fac2ef30fc9 in ha_partition::rnd_next (this=0x7fa9f0021b70, buf=0x7fa9f002d0a0 "\377\277\377\377")
    at /MariaDB/server/sql/ha_partition.cc:5049
#9  0x00007fac2e9eeb81 in handler::ha_rnd_next (this=0x7fa9f0021b70, buf=0x7fa9f002d0a0 "\377\277\377\377")
    at /MariaDB/server/sql/handler.cc:2764
#10 0x00007fac2e89e5cf in mysql_checksum_table (thd=thd@entry=0x7f97c80009a8, tables=tables@entry=0x7f97c8011740, 
    check_opt=check_opt@entry=0x7f97c80055d0) at /MariaDB/server/sql/sql_table.cc:10600
#11 0x00007fac2e814a26 in mysql_execute_command (thd=thd@entry=0x7f97c80009a8) at /MariaDB/server/sql/sql_parse.cc:4544
#12 0x00007fac2e81b6b2 in mysql_parse (thd=0x7f97c80009a8, rawbuf=<optimized out>, length=37, parser_state=0x7faad83e5630, 
    is_com_multi=<optimized out>, is_next_command=<optimized out>) at /MariaDB/server/sql/sql_parse.cc:8019
#13 0x00007fac2e81e1bf in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f97c80009a8, packet=packet@entry=0x7f97c8009319 "", 
    packet_length=packet_length@entry=37, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false)
    at /MariaDB/server/sql/sql_parse.cc:1846
#14 0x00007fac2e81f02e in do_command (thd=0x7f97c80009a8) at /MariaDB/server/sql/sql_parse.cc:1391
#15 0x00007fac2e8ee52a in do_handle_one_connection (connect=connect@entry=0x7fac31c7ab38) at /MariaDB/server/sql/sql_connect.cc:1402
#16 0x00007fac2e8ee64d in handle_one_connection (arg=arg@entry=0x7fac31c7ab38) at /MariaDB/server/sql/sql_connect.cc:1308
#17 0x00007fac2ef1160d in pfs_spawn_thread (arg=0x7fac3226f5d8) at /MariaDB/server/storage/perfschema/pfs.cc:1862
#18 0x00007fac2de2de25 in start_thread () from /lib64/libpthread.so.0
#19 0x00007fac2cceabad in clone () from /lib64/libc.so.6



 Comments   
Comment by Mattias Jonsson [ 2018-06-19 ]

Oh sorry, I already reported this as MDEV-16279, please close this one as a duplicate.

Comment by Jacob Mathew (Inactive) [ 2018-06-20 ]

This bug is a duplicate of bug MDEV-16279.

Generated at Thu Feb 08 08:29:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.