Created
March 24, 2014 06:34
-
-
Save yoku0825/9735203 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
(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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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