Skip to content

Instantly share code, notes, and snippets.

@yoku0825
Created March 24, 2014 06:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yoku0825/9735203 to your computer and use it in GitHub Desktop.
Save yoku0825/9735203 to your computer and use it in GitHub Desktop.
(gdb) bt
#0 0x00007f8a94c34540 in __memset_sse2 () from /lib64/libc.so.6
#1 0x00007f8a61cb6bac in buffer_new (ctx=0x7f8a4c33b818, ii=0x7f8a4c7aec80, size=12, pos=0x7f8a940f6f7c, bt=0x7f8a940f6f58,
br=0x7f8a940f6f60, bp=0x7f8a940f6f68, id=1114079, h=0x7f8a4c35b1f0) at ii.c:3415
#2 0x00007f8a61cb72fe in grn_ii_update_one (ctx=0x7f8a4c33b818, ii=0x7f8a4c7aec80, tid=1114079, u=0x7f8a4c35b6f0,
h=0x7f8a4c35b1f0) at ii.c:3801
#3 0x00007f8a61cb7ca6 in grn_ii_column_update (ctx=0x7f8a4c33b818, ii=<value optimized out>, rid=0, section=1,
oldvalue=0x0, newvalue=0x7f8a4c33b998, posting=0x0) at ii.c:5101
#4 0x00007f8a61bbca6a in grn_column_index_update (ctx=0x7f8a4c33b818, column=<value optimized out>,
id=<value optimized out>, section=<value optimized out>, oldvalue=<value optimized out>, newvalue=<value optimized out>)
at db.c:5959
#5 0x00007f8a66c46389 in ha_mroonga::storage_write_row_multiple_column_index (this=0x7f8a4c33a6b0,
buf=<value optimized out>, record_id=1114079, key_info=0x7f8a940f71e0, index_column=0x7f8a4c7aec80)
at ha_mroonga.cpp:5380
#6 0x00007f8a66c465d8 in ha_mroonga::storage_write_row_multiple_column_indexes (this=0x7f8a4c33a6b0,
buf=0x7f8a4c3556c0 "\337\377\020", record_id=1114079) at ha_mroonga.cpp:5414
#7 0x00007f8a66c4c786 in ha_mroonga::storage_write_row (this=0x7f8a4c33a6b0, buf=0x7f8a4c3556c0 "\337\377\020")
at ha_mroonga.cpp:5300
#8 0x000000000059194f in handler::ha_write_row (this=0x7f8a4c33a6b0, buf=0x7f8a4c3556c0 "\337\377\020")
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/sql/handler.cc:7265
#9 0x00000000006d7e8b in write_record (thd=0x2c35110, table=0x7f8a4c339dc0, info=0x7f8a940f8790, update=0x0)
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/sql/sql_insert.cc:1921
#10 0x0000000000861c7a in read_sep_field (thd=0x2c35110, ex=0x7f8a4c005160, table_list=0x7f8a4c0051f0, fields_vars=...,
set_fields=..., set_values=..., handle_duplicates=DUP_ERROR, ignore=false, read_file_from_client=false)
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/sql/sql_load.cc:1127
#11 mysql_load (thd=0x2c35110, ex=0x7f8a4c005160, table_list=0x7f8a4c0051f0, fields_vars=..., set_fields=...,
set_values=..., handle_duplicates=DUP_ERROR, ignore=false, read_file_from_client=false)
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/sql/sql_load.cc:506
#12 0x00000000006f873b in mysql_execute_command (thd=0x2c35110)
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/sql/sql_parse.cc:3693
#13 0x00000000006faca8 in mysql_parse (thd=0x2c35110,
rawbuf=0x7f8a4c005070 "LOAD DATA INFILE '/tmp/test.tsv' INTO TABLE mroonga.t1", length=<value optimized out>,
parser_state=<value optimized out>)
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/sql/sql_parse.cc:6235
#14 0x00000000006fc6d6 in dispatch_command (command=COM_QUERY, thd=0x2c35110,
packet=0x2d15851 "LOAD DATA INFILE '/tmp/test.tsv' INTO TABLE mroonga.t1", packet_length=54)
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/sql/sql_parse.cc:1334
#15 0x00000000006fdf87 in do_command (thd=0x2c35110)
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/sql/sql_parse.cc:1036
#16 0x00000000006c5866 in do_handle_one_connection (thd_arg=0x2c35110)
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/sql/sql_connect.cc:982
#17 0x00000000006c5945 in handle_one_connection (arg=0x2c35110)
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/sql/sql_connect.cc:898
#18 0x0000000000b3cbf6 in pfs_spawn_thread (arg=<value optimized out>)
at /export/home/pb2/build/sb_0-11248666-1389759794.13/rpm/BUILD/mysql-5.6.16/mysql-5.6.16/storage/perfschema/pfs.cc:1858
#19 0x00007f8a95f29ddb in start_thread () from /lib64/libpthread.so.0
#20 0x00007f8a94c90a1d in clone () from /lib64/libc.so.6
(gdb)
$ perl -e 'use Digest::MD5 qw(md5_hex); for ($n= 1; $n<= 3000000; $n++) {printf("%d\t%s\n", $n, md5_he
x($n));}' > /tmp/test.tsv
mysql> CREATE DATABASE mroonga;
Query OK, 1 row affected (0.02 sec)
mysql> CREATE TABLE mroonga.t1 (num int unsigned not null, val varchar(32) not null, KEY(num, val)) Engine= Mroonga;
Query OK, 0 rows affected (0.09 sec)
mysql> LOAD DATA INFILE '/tmp/test.tsv' INTO TABLE mroonga.t1;
ERROR 2013 (HY000): Lost connection to MySQL server during query
or
## put mroonga.test into mysql-test/t and enter this
$ ./mtr --mysqld=--secure-file-priv=/tmp mroonga
INSTALL PLUGIN mroonga SONAME 'ha_mroonga.so';
CREATE TABLE t1 (num int unsigned not null, val varchar(32) not null, KEY (num, val)) Engine= Mroonga;
--perl
use Digest::MD5 qw(md5_hex);
open($fh, "> /tmp/test.tsv");
for ($n= 1; $n<= 3000000; $n++)
{printf($fh "%d\t%s\n", $n, md5_hex($n));}
EOF
LOAD DATA INFILE '/tmp/test.tsv' INTO TABLE t1;
UNINSTALL PLUGIN mroonga;
DROP TABLE t1;
--remove_file /tmp/test.tsv
--exit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment