Skip to content

Instantly share code, notes, and snippets.

@yoku0825
Created February 3, 2014 10:24
Show Gist options
  • Save yoku0825/8781540 to your computer and use it in GitHub Desktop.
Save yoku0825/8781540 to your computer and use it in GitHub Desktop.
(gdb) bt full
#0 mrn_set_geometry (this=<value optimized out>, field=<value optimized out>, buf=0x7f945c8356c0) at ha_mroonga.cpp:1187
error = 0
buffer = {
<my_aligned_storage<24ul, 8ul>> = {
{
data = "3\000\000\000\002\000\000\000\b\b\001H\224\177\000\000\360U\203\\\224\177\000",
align = {<No data fields>}
}
}, <No data fields>}
geometry = 0x0
#1 ha_mroonga::generic_store_bulk_geometry (this=<value optimized out>, field=<value optimized out>, buf=0x7f945c8356c0)
at ha_mroonga.cpp:9295
buffer = {
Ptr = 0xc955ef "",
str_length = 0,
Alloced_length = 0,
alloced = false,
str_charset = 0x127ea20
}
geometry = <value optimized out>
len = <value optimized out>
error = 0
wkb = 0xc955ef ""
#2 0x00007f9474d1f3aa in ha_mroonga::storage_write_row (this=0x7f9448012f50, buf=0x7f9448010740 "\002")
at ha_mroonga.cpp:5256
field = 0x7f9448010808
column_name = <value optimized out>
j = <value optimized out>
n_columns = 16
debug_column_access = {
table_ = 0x7f9448011f60,
bitmap_ = 0x7f9448012050
}
added = 1
slot_data = <value optimized out>
pkey_size = 4
__FUNCTION__ = "storage_write_row"
colbuf = {
header = {
type = 2 '\002',
impl_flags = 0 '\000',
flags = 4,
domain = 8
},
u = {
b = {
head = 0x2 <Address 0x2 out of bounds>,
curr = 0x0,
tail = 0x0
},
v = {
body = 0x2,
sections = 0x0,
n_sections = 0
}
}
}
error = 0
thd = 0x3aaf9d0
i = <value optimized out>
pkey = <value optimized out>
pkey_nr = 0
#3 0x0000000000591d7f in handler::ha_write_row (this=0x7f9448012f50, buf=0x7f9448010740 "\002")
at /export/home/pb2/build/sb_0-10831761-1384712157.44/rpm/BUILD/mysql-5.6.15/mysql-5.6.15/sql/handler.cc:7221
locker = 0x7f945c836750
state = {
m_flags = 3,
m_io_operation = PSI_TABLE_WRITE_ROW,
m_table = 0x7f947cbca040,
m_table_share = 0x3aaf9d0,
m_thread = 0x7f947cb11740,
m_timer_start = 1789613614110532,
m_timer = 0xb561b0 <my_timer_cycles>,
m_wait = 0xac1022659b,
m_index = 64
}
error = <value optimized out>
#4 0x00000000006d74eb in write_record (thd=0x3aaf9d0, table=0x7f9448011f60, info=0x7f945c836a00, update=0x7f945c836980)
at /export/home/pb2/build/sb_0-10831761-1384712157.44/rpm/BUILD/mysql-5.6.15/mysql-5.6.15/sql/sql_insert.cc:1921
error = <value optimized out>
trg_error = <value optimized out>
key = <value optimized out>
save_read_set = 0x7f9448012050
save_write_set = 0x7f9448012070
prev_insert_id = 0
insert_id_for_cur_row = <value optimized out>
duplicate_handling = DUP_ERROR
ignore_errors = false
#5 0x00000000006dfcb7 in mysql_insert (thd=0x3aaf9d0, table_list=0x7f9448005088, fields=..., values_list=...,
update_fields=<value optimized out>, update_values=<value optimized out>, duplic=DUP_ERROR, ignore=false)
at /export/home/pb2/build/sb_0-10831761-1384712157.44/rpm/BUILD/mysql-5.6.15/mysql-5.6.15/sql/sql_insert.cc:1072
error = 0
res = <value optimized out>
err = <value optimized out>
transactional_table = <value optimized out>
joins_freed = <value optimized out>
was_insert_delayed = <value optimized out>
is_locked = false
counter = 2
id = <value optimized out>
info = {
<Sql_alloc> = {<No data fields>},
members of COPY_INFO:
_vptr.COPY_INFO = 0x1232c70,
m_optype = COPY_INFO::INSERT_OPERATION,
m_changed_columns = 0x3ab2750,
m_changed_columns2 = 0x0,
m_manage_defaults = false,
m_function_default_columns = 0x7f9448005a40,
handle_duplicates = DUP_ERROR,
ignore = false,
stats = {
records = 2,
deleted = 0,
updated = 0,
copied = 1,
error_count = 0,
touched = 0
},
escape_char = 0,
last_errno = 0,
update_values = 0x0
}
update = {
<Sql_alloc> = {<No data fields>},
members of COPY_INFO:
_vptr.COPY_INFO = 0x1232c70,
m_optype = COPY_INFO::UPDATE_OPERATION,
m_changed_columns = 0x3ab2780,
m_changed_columns2 = 0x0,
m_manage_defaults = true,
m_function_default_columns = 0x0,
handle_duplicates = DUP_ERROR,
ignore = false,
stats = {
records = 0,
deleted = 0,
updated = 0,
copied = 0,
error_count = 0,
touched = 0
},
escape_char = 0,
last_errno = 0,
update_values = 0x3ab2768
}
context = 0x3ab2268
query = 0x7f9448004f50 "INSERT INTO t1 VALUES (1, GeomFromText('POINT(0 0)')), (2, NULL)"
log_on = true
unused_conds = 0x0
num_partitions = 0
can_prune_partitions = partition_info::PRUNE_NO
used_partitions = {
bitmap = 0x1,
n_bits = 1,
last_word_mask = 0,
last_word_ptr = 0x7f945c836b30,
mutex = 0x8fc014
}
prune_needs_default_values = false
lock_type = TL_WRITE_CONCURRENT_INSERT
values = <value optimized out>
value_count = 2
table = 0x7f9448011f60
__FUNCTION__ = "mysql_insert"
#6 0x00000000006f60be in mysql_execute_command (thd=0x3aaf9d0)
at /export/home/pb2/build/sb_0-10831761-1384712157.44/rpm/BUILD/mysql-5.6.15/mysql-5.6.15/sql/sql_parse.cc:3434
res = <value optimized out>
up_result = <value optimized out>
lex = 0x3ab1b10
select_lex = 0x3ab2218
first_table = 0x7f9448005088
all_tables = 0x7f9448005088
unit = 0x3ab1bd0
have_table_map_for_update = false
ots = {
ctx = 0x3ab1af8,
error = false
}
trace_command = {
<Opt_trace_struct> = {
started = false,
requires_key = false,
has_disabled_I_S = false,
empty = false,
stmt = 0x0,
saved_key = 0x0
}, <No data fields>}
trace_command_steps = {
<Opt_trace_struct> = {
started = false,
requires_key = false,
has_disabled_I_S = false,
empty = false,
stmt = 0x0,
saved_key = 0x0
}, <No data fields>}
__FUNCTION__ = "mysql_execute_command"
#7 0x00000000006fa288 in mysql_parse (thd=0x3aaf9d0,
rawbuf=0x7f9448004f50 "INSERT INTO t1 VALUES (1, GeomFromText('POINT(0 0)')), (2, NULL)", length=<value optimized out>,
parser_state=<value optimized out>)
at /export/home/pb2/build/sb_0-10831761-1384712157.44/rpm/BUILD/mysql-5.6.15/mysql-5.6.15/sql/sql_parse.cc:6235
lex = 0x3ab1b10
err = <value optimized out>
found_semicolon = 0x0
qlen = 64
error = <value optimized out>
__FUNCTION__ = "mysql_parse"
#8 0x00000000006fbcb6 in dispatch_command (command=COM_QUERY, thd=0x3aaf9d0,
packet=0x3b81d01 "INSERT INTO t1 VALUES (1, GeomFromText('POINT(0 0)')), (2, NULL)", packet_length=64)
at /export/home/pb2/build/sb_0-10831761-1384712157.44/rpm/BUILD/mysql-5.6.15/mysql-5.6.15/sql/sql_parse.cc:1334
packet_end = 0x7f9448004f90 ""
parser_state = {
m_lip = {
m_thd = 0x3aaf9d0,
yylineno = 1,
yytoklen = 1,
yylval = 0x7f945c837990,
lookahead_token = -1,
lookahead_yylval = 0x0,
m_ptr = 0x7f9448004f91 "\a",
m_tok_start = 0x7f9448004f91 "\a",
m_tok_end = 0x7f9448004f91 "\a",
m_end_of_query = 0x7f9448004f90 "",
m_tok_start_prev = 0x7f9448004f90 "",
m_buf = 0x7f9448004f50 "INSERT INTO t1 VALUES (1, GeomFromText('POINT(0 0)')), (2, NULL)",
m_buf_length = 64,
m_echo = true,
m_echo_saved = false,
m_cpp_buf = 0x7f9448004ff8 "INSERT INTO t1 VALUES (1, GeomFromText('POINT(0 0)')), (2, NULL)",
m_cpp_ptr = 0x7f9448005038 "",
m_cpp_tok_start = 0x7f9448005038 "",
m_cpp_tok_start_prev = 0x7f9448005038 "",
m_cpp_tok_end = 0x7f9448005038 "",
m_body_utf8 = 0x0,
m_body_utf8_ptr = 0x4 <Address 0x4 out of bounds>,
m_cpp_utf8_processed_ptr = 0x0,
next_state = MY_LEX_END,
found_semicolon = 0x0,
tok_bitmap = 127 '\177',
ignore_space = false,
stmt_prepare_mode = false,
multi_statements = true,
in_comment = NO_COMMENT,
in_comment_saved = 7631727,
m_cpp_text_start = 0x7f9448005030 "2, NULL)",
m_cpp_text_end = 0x7f9448005031 ", NULL)",
m_underscore_cs = 0x0,
m_digest_psi = 0x0
},
m_yacc = {
yacc_yyss = 0x0,
yacc_yyvs = 0x0,
m_set_signal_info = {
m_item = {0x0 <repeats 12 times>}
},
m_lock_type = TL_READ_DEFAULT,
m_mdl_type = MDL_SHARED_READ,
m_ha_rkey_mode = HA_READ_KEY_EXACT
}
}
net = 0x3aafbe8
error = <value optimized out>
__FUNCTION__ = "dispatch_command"
#9 0x00000000006fd567 in do_command (thd=0x3aaf9d0)
at /export/home/pb2/build/sb_0-10831761-1384712157.44/rpm/BUILD/mysql-5.6.15/mysql-5.6.15/sql/sql_parse.cc:1036
return_value = <value optimized out>
packet = 0x3b81d00 "\003INSERT INTO t1 VALUES (1, GeomFromText('POINT(0 0)')), (2, NULL)"
packet_length = <value optimized out>
net = 0x3aafbe8
command = COM_QUERY
#10 0x00000000006c4f06 in do_handle_one_connection (thd_arg=0x3aaf9d0)
at /export/home/pb2/build/sb_0-10831761-1384712157.44/rpm/BUILD/mysql-5.6.15/mysql-5.6.15/sql/sql_connect.cc:982
rc = <value optimized out>
thd = 0x3aaf9d0
#11 0x00000000006c4fe5 in handle_one_connection (arg=0x3aaf9d0)
at /export/home/pb2/build/sb_0-10831761-1384712157.44/rpm/BUILD/mysql-5.6.15/mysql-5.6.15/sql/sql_connect.cc:898
thd = 0x7f945c8355b0
psi = <value optimized out>
#12 0x0000000000ae00e6 in pfs_spawn_thread (arg=<value optimized out>)
at /export/home/pb2/build/sb_0-10831761-1384712157.44/rpm/BUILD/mysql-5.6.15/mysql-5.6.15/storage/perfschema/pfs.cc:1858
typed_arg = 0x3ad8c80
user_arg = 0x3aaf9d0
user_start_routine = 0x6c4fa0 <handle_one_connection(void*)>
pfs = <value optimized out>
klass = <value optimized out>
#13 0x00007f947ffa0ddb in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#14 0x00007f947ed07a1d in clone () from /lib64/libc.so.6
No symbol table info available.
mysql> DROP DATABASE IF EXISTS mroonga;
Query OK, 1 row affected (0.22 sec)
mysql> CREATE DATABASE mroonga;
Query OK, 1 row affected (0.00 sec)
mysql> use mroonga
Database changed
mysql> CREATE TABLE t1 (num int PRIMARY KEY, geo geometry NOT NULL) Engine= mroonga;
Query OK, 0 rows affected (0.15 sec)
mysql> INSERT INTO t1 (1, NULL);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1, NULL)' at line 1
mysql>
mysql> INSERT INTO t1 VALUES (1, NULL);
ERROR 1048 (23000): Column 'geo' cannot be null
mysql>
mysql> INSERT INTO t1 VALUES (1, GeomFromText('POINT(0 0)')), (2, NULL);
ERROR 2013 (HY000): Lost connection to MySQL server during query
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment