130712  1:31:33 [ERROR] mysqld got signal 11 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help

diagnose the problem, but since we have already crashed,

something is definitely wrong and this may fail.

key_buffer_size=1048572

read_buffer_size=131072

max_used_connections=3

max_threads=152

thread_count=3

connection_count=3

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 61265 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x3373330

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong...

stack_bottom = 0x7f3a9821ee58 thread_stack 0x48000

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(my_print_stacktrace+0x2e) [0x96b02e]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(handle_fatal_signal+0x363) [0x6d2023]

/lib64/libpthread.so.0() [0x3c1c60f500]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld() [0x971156]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(simple_key_cache_read+0x1bb) [0x97328b]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld() [0x97357a]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(_mi_fetch_keypage+0x48) [0x775218]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld() [0x782b3a]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(_mi_ck_real_write_btree+0x5d) [0x782f3d]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(_mi_ck_write_btree+0x6f) [0x782fef]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(mi_write+0x303) [0x783523]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(handler::ha_write_row(unsigned char*)+0x37) [0x6c4a07]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(write_record(THD*, st_table*, st_copy_info*)+0x287) [0x650147]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool)+0xed1) [0x653ca1]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(mysql_execute_command(THD*)+0x8fa) [0x5dadea]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x2c9) [0x5dfe49]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x951) [0x5e07b1]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(do_command(THD*)+0xf2) [0x5e14d2]

mariadb-5.2.15-MariaDB-linux-x86_64/bin/mysqld(handle_one_connection+0x156) [0x5d2616]

/lib64/libpthread.so.0() [0x3c1c607851]

/lib64/libc.so.6(clone+0x6d) [0x3c1c2e767d]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x7f3a4c004c48): REPLACE INTO E(col_int_key, col_datetime_key) VALUES(1, NOW())

Connection ID (thread ID): 7

Status: NOT_KILLED

==535== Invalid read of size 8

==535==    at 0xAF49B7: safe_mutex_lock (thr_mutex.c:244)

==535==    by 0xAFD000: read_block (mf_keycache.c:2692)

==535==    by 0xAFD4D0: simple_key_cache_read (mf_keycache.c:2880)

==535==    by 0xB00FBE: partitioned_key_cache_read (mf_keycache.c:5451)

==535==    by 0xB01C75: key_cache_read (mf_keycache.c:6233)

==535==    by 0x88F69E: _mi_fetch_keypage (mi_page.c:33)

==535==    by 0x8A0E19: w_search (mi_write.c:362)

==535==    by 0x8A1298: w_search (mi_write.c:427)

==535==    by 0x8A0A7A: _mi_ck_real_write_btree (mi_write.c:305)

==535==    by 0x8A0961: _mi_ck_write_btree (mi_write.c:285)

==535==    by 0x8A0864: _mi_ck_write (mi_write.c:256)

==535==    by 0x8A0137: mi_write (mi_write.c:128)

==535==    by 0x87BC20: ha_myisam::write_row(unsigned char*) (ha_myisam.cc:807)

==535==    by 0x79161A: handler::ha_write_row(unsigned char*) (handler.cc:4965)

==535==    by 0x6EF3DA: write_record(THD*, st_table*, st_copy_info*) (sql_insert.cc:1422)

==535==    by 0x6ED3E5: mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) (sql_insert.cc:866)

==535==  Address 0x1eccd3f0 is 304 bytes inside a block of size 2,516 free'd

==535==    at 0x4A0595D: free (vg_replace_malloc.c:366)

==535==    by 0xAD0877: _myfree (safemalloc.c:337)

==535==    by 0xB00E6F: end_partitioned_key_cache (mf_keycache.c:5373)

==535==    by 0xB01B6B: end_key_cache_internal (mf_keycache.c:6141)

==535==    by 0xB01FD1: repartition_key_cache_internal (mf_keycache.c:6507)

==535==    by 0xB02075: repartition_key_cache (mf_keycache.c:6556)

==535==    by 0x78F6EC: ha_repartition_key_cache(st_key_cache*) (handler.cc:4037)

==535==    by 0x65D679: sys_var_key_cache_long::update(THD*, set_var*) (set_var.cc:2568)

==535==    by 0x65FDE8: set_var::update(THD*) (set_var.cc:3739)

==535==    by 0x65F874: sql_set_variables(THD*, List<set_var_base>*) (set_var.cc:3614)

==535==    by 0x64CF89: mysql_execute_command(THD*) (sql_parse.cc:3615)

==535==    by 0x654CAA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6216)

==535==    by 0x6469B2: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1248)

==535==    by 0x645C15: do_command(THD*) (sql_parse.cc:920)

==535==    by 0x642A2E: handle_one_connection (sql_connect.cc:1226)

==535==    by 0x3C1C607850: start_thread (pthread_create.c:301)

==535==

#0  __pthread_kill (threadid=<value optimized out>, signo=<value optimized out>) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63

        pd = <value optimized out>

        tid = 21950

        val = <value optimized out>

#1  0x0000000000aef17f in my_write_core (sig=6) at stacktrace.c:440

No locals.

#2  0x00000000007a602c in handle_fatal_signal (sig=6) at signal_handler.cc:255

        curr_time = 1373623633

        tm = {tm_sec = 13, tm_min = 7, tm_hour = 13, tm_mday = 12, tm_mon = 6, tm_year = 113, tm_wday = 5, tm_yday = 192, tm_isdst = 0, tm_gmtoff = 10800, tm_zone = 0x2050750 "GMT"}

        thd = 0x32e6718

#3  <signal handler called>

No symbol table info available.

#4  0x0000003c1c2328a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64

        resultvar = 0

        pid = <value optimized out>

        selftid = 21950

#5  0x0000003c1c234085 in abort () at abort.c:92

        save_stage = 2

        act = {__sigaction_handler = {sa_handler = 0x7fe384534470, sa_sigaction = 0x7fe384534470}, sa_mask = {__val = {8482578528384, 22, 13689184, 62, 140615154358720, 258169924440, 140615573815296,

              140615154353216, 4294967295, 206158430256, 5, 17849688, 0, 0, 3, 0}}, sa_flags = 467722192, sa_restorer = 0x5}

        sigs = {__val = {32, 0 <repeats 15 times>}}

#6  0x0000000000af4b70 in safe_mutex_lock (mp=0x7fe338161808, my_flags=0, file=0xd0e160 "mf_keycache.c", line=4382) at thr_mutex.c:306

        error = 22

        __PRETTY_FUNCTION__ = "safe_mutex_lock"

#7  0x0000000000affdee in flush_simple_key_cache_blocks (keycache=0x7fe338161758, file=45, file_extra=0x0, type=FLUSH_KEEP) at mf_keycache.c:4382

        res = 0

        _db_stack_frame_ = {func = 0x7fe3845344a0 " ES\204\343\177", file = 0xb06c29 "H\211E\370H\203}\370", level = 0, prev = 0x0}

#8  0x0000000000b013d7 in flush_partitioned_key_cache_blocks (keycache=0x7fe3380636d8, file=45, file_extra=0x7fe338024750, type=FLUSH_KEEP) at mf_keycache.c:5695

        partition = 0x7fe338161758

        i = 0

        partitions = 3

        err = 0

        dirty_part_map = 0x7fe338024750

        _db_stack_frame_ = {func = 0x7fe384534530 "`ES\204", file = 0xaf510d "\213E\354H\203\304@[A\\\311\303UH\211\345ATSH\201\354\340", level = 0, prev = 0x0}

#9  0x0000000000b01e0e in flush_key_blocks (keycache=0x2052d98, file=45, file_extra=0x7fe338024750, type=FLUSH_KEEP) at mf_keycache.c:6392

No locals.

#10 0x0000000000891d70 in mi_lock_database (info=0x7fe338030d78, lock_type=2) at mi_locking.c:76

        error = 0

        count = 0

        share = 0x7fe3380244c8

        _db_stack_frame_ = {func = 0x7fe3845345c0 "0FS\204\343\177", file = 0xb06a62 "H\211E\370H\203}\370", level = 0, prev = 0x0}

#11 0x000000000087f458 in ha_myisam::external_lock (this=0x7fe338022d70, thd=0x32e6718, lock_type=2) at ha_myisam.cc:1932

No locals.

#12 0x000000000079139c in handler::ha_external_lock (this=0x7fe338022d70, thd=0x32e6718, lock_type=2) at handler.cc:4926

        _db_stack_frame_ = {func = 0x7fe3845346a0 "", file = 0x33500b06cc1 <Address 0x33500b06cc1 out of bounds>, level = 0, prev = 0x0}

        dbug_violation_helper = {_entered = true}

        __PRETTY_FUNCTION__ = "int handler::ha_external_lock(THD*, int)"

        error = 0

#13 0x000000000062d8e5 in unlock_external (thd=0x32e6718, table=0x7fe33c006ea0, count=1) at lock.cc:829

        error = 0

        error_code = 0

        _db_stack_frame_ = {func = 0x7fe384534700 "", file = 0x18400b06a62 <Address 0x18400b06a62 out of bounds>, level = 0, prev = 0x0}

        dbug_violation_helper = {_entered = true}

#14 0x000000000062c87b in mysql_unlock_tables (thd=0x32e6718, sql_lock=0x7fe33c006e78) at lock.cc:390

---Type <return> to continue, or q <return> to quit---

        _db_stack_frame_ = {func = 0x7fe300000000 <Address 0x7fe300000000 out of bounds>, file = 0x0, level = 0, prev = 0x0}

        dbug_violation_helper = {_entered = true}

#15 0x000000000069573f in close_thread_tables (thd=0x32e6718) at sql_base.cc:1355

        dbug_violation_helper = {_entered = true}

        __PRETTY_FUNCTION__ = "void close_thread_tables(THD*)"

        table = 0x0

        prelocked_mode = NON_PRELOCKED

        _db_stack_frame_ = {func = 0x7fe300000000 <Address 0x7fe300000000 out of bounds>, file = 0x0, level = 0, prev = 0x0}

#16 0x0000000000647d44 in dispatch_command (command=COM_QUERY, thd=0x32e6718, packet=0x32ea099 "REPLACE INTO E(col_int_key, col_datetime_key) VALUES(1, NOW())", packet_length=62) at sql_parse.cc:1693

        net = 0x32e6808

        dbug_violation_helper = {_entered = true}

        __FUNCTION__ = "dispatch_command"

        __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)"

        error = false

        _db_stack_frame_ = {func = 0x7fe384534ca0 "@MS\204\343\177", file = 0x7fe384534cee "", level = 0, prev = 0x0}

#17 0x0000000000645c16 in do_command (thd=0x32e6718) at sql_parse.cc:920

        return_value = false

        packet = 0x32ea098 "\003REPLACE INTO E(col_int_key, col_datetime_key) VALUES(1, NOW())"

        packet_length = 63

        net = 0x32e6808

        command = COM_QUERY

        dbug_violation_helper = {_entered = true}

        __PRETTY_FUNCTION__ = "bool do_command(THD*)"

        _db_stack_frame_ = {func = 0x7fe384534e40 "\220NS\204\343\177", file = 0x642699 "\213\005I_\260", level = 0, prev = 0x0}

#18 0x0000000000642a2f in handle_one_connection (arg=0x32e6718) at sql_connect.cc:1226

        net = 0x32e6808

        create_user = true

        thd = 0x32e6718

#19 0x0000003c1c607851 in start_thread (arg=0x7fe384535700) at pthread_create.c:301

        __res = <value optimized out>

        pd = 0x7fe384535700

        now = <value optimized out>

        unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140615154358016, -1401933795574547793, 18118240, 140615154358720, 0, 3, 1390587551184190127, -1372634280569996625}, mask_was_saved = 0}}, priv = {

            pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}

        not_first_call = <value optimized out>

        pagesize_m1 = <value optimized out>

        sp = <value optimized out>

        freesize = <value optimized out>

#20 0x0000003c1c2e767d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115

FLUSH TABLES WITH READ LOCK ; SET GLOBAL key_cache_segments = 64 ; UNLOCK TABLES;

query_init:

  SET GLOBAL key_buffer_size = 1024*1024;

thread1:

  FLUSH TABLES WITH READ LOCK ; SET GLOBAL key_cache_segments = _digit ; UNLOCK TABLES;

query:

  REPLACE INTO E(col_int_key, col_datetime_key) VALUES(1, NOW());

  FLUSH TABLES WITH READ LOCK ; SET GLOBAL key_cache_segments = 64 ; UNLOCK TABLES;

130715  3:20:58 [ERROR] mysqld got signal 8 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help

diagnose the problem, but since we have already crashed,

something is definitely wrong and this may fail.

Server version: 5.3.11-MariaDB-log

key_buffer_size=1258291200

read_buffer_size=2097152

max_used_connections=214

max_threads=801

thread_count=18

connection_count=18

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 6980843 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x2aab42ad1840

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong...

stack_bottom = 0x426cf0f8 thread_stack 0x48000

./bin/mysqld(my_print_stacktrace+0x2e) [0x9cb88e]

./bin/mysqld(handle_fatal_signal+0x3f9) [0x751eb9]

/lib64/libpthread.so.0 [0x3d52a0eb70]

./bin/mysqld(simple_key_cache_read+0xfa) [0x9d21aa]

./bin/mysqld(_mi_fetch_keypage+0x48) [0x814e18]

./bin/mysqld(_mi_search+0x7c) [0x80d48c]

./bin/mysqld(mi_rkey+0x16d) [0x7fdbad]

./bin/mysqld(ha_myisam::index_read_idx_map(unsigned char*, unsigned int, unsigned char const*, unsigned long, ha_rkey_function)+0x5d) [0x7e74ad]

./bin/mysqld [0x6a05f2]

./bin/mysqld [0x6a0974]

./bin/mysqld [0x6b6e8b]

./bin/mysqld(JOIN::optimize()+0xc87) [0x6b8b07]

./bin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0xd6) [0x6c0966]

./bin/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x16f) [0x6c13ff]

./bin/mysqld [0x635c3e]

./bin/mysqld(mysql_execute_command(THD*)+0x3a43) [0x63b843]

./bin/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x299) [0x63e629]

./bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xd56) [0x63f7d6]

./bin/mysqld(do_command(THD*)+0x101) [0x640081]

./bin/mysqld(handle_one_connection+0xfd) [0x6317fd]

/lib64/libpthread.so.0 [0x3d52a0673d]

/lib64/libc.so.6(clone+0x6d) [0x3d51ed44bd]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x2aabbe867e38): /* comment */ SELECT f, pcds.b FROM mpcds pcds JOIN mcbm fcbm USING(bf_id) WHERE fcbm.f = 123456 LIMIT 5000

Connection ID (thread ID): 46182543

Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

information that should help you find out what is causing the crash.

+----+-------------+-------+-------+---------------+---------+---------+-------+------+-------+

| id | select_type | table | type  | possible_keys | key     | key_len | ref   | rows | Extra |

+----+-------------+-------+-------+---------------+---------+---------+-------+------+-------+

|  1 | SIMPLE      | fcbm  | const | PRIMARY       | PRIMARY | 4       | const |    1 |       |

|  1 | SIMPLE      | pcds  | const | PRIMARY       | PRIMARY | 10      | const |    1 |       |

+----+-------------+-------+-------+---------------+---------+---------+-------+------+-------+

CREATE TABLE `mpcds` (

  `bf_id` varchar(8) NOT NULL,

  `b` smallint(5) unsigned DEFAULT NULL,

  PRIMARY KEY (`bf_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=999999999 PACK_KEYS=1

CREATE TABLE `mfcbm` (

  `f` int(10) unsigned NOT NULL,

  `c` char(9) DEFAULT NULL,

  `bf_id` varchar(8) DEFAULT NULL,

  PRIMARY KEY (`f`),

  KEY `compuid` (`c`,`f`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=999999999 PACK_KEYS=1

query_init:

  SET GLOBAL key_buffer_size = 64*1024*1024;

thread1:

  SET GLOBAL key_cache_segments = { $prng->int(0,64) } ;

query:

  REPLACE INTO E(col_int_key, col_datetime_key) VALUES(1, NOW());

MariaDB [(none)]> set global key_buffer_size = 64*1024*1024;

ERROR 1210 (HY000): Incorrect arguments to SET