rem0rec.cc:566: Assertion `!leaf' failed, innodb_gis.kill_server failed, sporadic,

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Highest supported file format is Barracuda.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7700243

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=50] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=8] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=7] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=10] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=12] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=13] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=15] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=17] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=18] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=20] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=22] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=23] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=25] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=27] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=28] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=30] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=32] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=33] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=35] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Recovered page [page id: space=4, page number=37] from the doublewrite buffer.

2017-10-30 11:44:25 139746469066560 [Note] InnoDB: Starting a batch to recover 74 pages from redo log.

mysqld: /home/alice/aliska/10.2/storage/innobase/rem/rem0rec.cc:566: ulint* rec_get_offsets_func(const rec_t*, const dict_index_t*, ulint*, bool, ulint, const char*, unsigned int, mem_heap_t**): Assertion `!leaf' failed.

171030 11:44:25 [ERROR] mysqld got signal 6 ;

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 https://mariadb.com/kb/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: 10.2.10-MariaDB-debug-log

key_buffer_size=1048576

read_buffer_size=131072

max_used_connections=0

max_threads=153

thread_count=0

It is possible that mysqld could use up to 

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

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

Thread pointer: 0x0

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 = 0x0 thread_stack 0x49000

/home/alice/aliska/10.2/sql/mysqld(my_print_stacktrace+0x38)[0x555b3755b4df]

/home/alice/aliska/10.2/sql/mysqld(handle_fatal_signal+0x3a3)[0x555b36decd62]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f1941753390]

/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7f1940b0c428]

/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f1940b0e02a]

/lib/x86_64-linux-gnu/libc.so.6(+0x2dbd7)[0x7f1940b04bd7]

/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f1940b04c82]

/home/alice/aliska/10.2/sql/mysqld(+0xb6a796)[0x555b3713c796]

/home/alice/aliska/10.2/sql/mysqld(+0xcb64c2)[0x555b372884c2]

/home/alice/aliska/10.2/sql/mysqld(+0xb0c046)[0x555b370de046]

/home/alice/aliska/10.2/sql/mysqld(+0xb0d8bb)[0x555b370df8bb]

/home/alice/aliska/10.2/sql/mysqld(+0xced529)[0x555b372bf529]

/home/alice/aliska/10.2/sql/mysqld(+0xd7a70f)[0x555b3734c70f]

mysys/stacktrace.c:267(my_print_stacktrace)[0x555b371f3dca]

rem/rem0rec.cc:567(rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, bool, unsigned long, char const*, unsigned int, mem_block_info_t**))[0x7f19417496ba]

log/log0recv.cc:1265(recv_parse_or_apply_log_rec_body(mlog_id_t, unsigned char*, unsigned char*, unsigned long, unsigned long, bool, buf_block_t*, mtr_t*))[0x7f1940bde3dd]

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.

Writing a core file

----------SERVER LOG END-------------

mysqltest failed but provided no output

The result from queries just before the failure was:

< snip >

count(*)

10000

drop index c2 on t1;

create spatial index idx on t1(c2);

show create table t1;

Table	Create Table

t1	CREATE TABLE `t1` (

  `c1` int(11) DEFAULT NULL,

  `c2` geometry NOT NULL,

  SPATIAL KEY `idx` (`c2`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

check table t1;

Table	Op	Msg_type	Msg_text

test.t1	check	status	OK

truncate table t1;

call mtr.add_suppression("InnoDB: A copy of page \[page id: space=[0-9]+, page number=[0-9]+\] in the doublewrite buffer slot [0-9]+ is not within space bounds");

START TRANSACTION;

CALL insert_t1(5000);

COMMIT;

# Kill and restart

Thread 1 (Thread 0x7f1935207700 (LWP 29922)):

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

#1  0x0000555b3755b5d1 in my_write_core (sig=6) at /home/alice/aliska/10.2/mysys/stacktrace.c:477

#2  0x0000555b36ded10e in handle_fatal_signal (sig=6) at /home/alice/aliska/10.2/sql/signal_handler.cc:303

#3  <signal handler called>

#4  0x00007f1940b0c428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54

#5  0x00007f1940b0e02a in __GI_abort () at abort.c:89

#6  0x00007f1940b04bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x555b37795f10 "!leaf", file=file@entry=0x555b37795df0 "/home/alice/aliska/10.2/storage/innobase/rem/rem0rec.cc", line=line@entry=566, function=function@entry=0x555b37797200 <rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, bool, unsigned long, char const*, unsigned int, mem_block_info_t**)::__PRETTY_FUNCTION__> "ulint* rec_get_offsets_func(const rec_t*, const dict_index_t*, ulint*, bool, ulint, const char*, unsigned int, mem_heap_t**)") at assert.c:92

#7  0x00007f1940b04c82 in __GI___assert_fail (assertion=0x555b37795f10 "!leaf", file=0x555b37795df0 "/home/alice/aliska/10.2/storage/innobase/rem/rem0rec.cc", line=566, function=0x555b37797200 <rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, bool, unsigned long, char const*, unsigned int, mem_block_info_t**)::__PRETTY_FUNCTION__> "ulint* rec_get_offsets_func(const rec_t*, const dict_index_t*, ulint*, bool, ulint, const char*, unsigned int, mem_heap_t**)") at assert.c:101

#8  0x0000555b3713c796 in rec_get_offsets_func (rec=0x7f193669c07e "", index=0x7f1924001668, offsets=0x0, leaf=true, n_fields=18446744073709551615, file=0x555b3780e9c0 "/home/alice/aliska/10.2/storage/innobase/btr/btr0cur.cc", line=3489, heap=0x7f1935205ff8) at /home/alice/aliska/10.2/storage/innobase/rem/rem0rec.cc:566

#9  0x0000555b372884c2 in btr_cur_parse_update_in_place (ptr=0x7f19364f418a "", end_ptr=0x7f19364f418a "", page=0x7f193669c000 "", page_zip=0x0, index=0x7f1924001668) at /home/alice/aliska/10.2/storage/innobase/btr/btr0cur.cc:3489

#10 0x0000555b370de046 in recv_parse_or_apply_log_rec_body (type=MLOG_COMP_REC_UPDATE_IN_PLACE, ptr=0x7f19364f4156 "\a", end_ptr=0x7f19364f418a "", space_id=4, page_no=4, apply=true, block=0x7f193623f310, mtr=0x7f1935206550) at /home/alice/aliska/10.2/storage/innobase/log/log0recv.cc:1265

#11 0x0000555b370df8bb in recv_recover_page (just_read_in=true, block=0x7f193623f310) at /home/alice/aliska/10.2/storage/innobase/log/log0recv.cc:1771

#12 0x0000555b372bf529 in buf_page_io_complete (bpage=0x7f193623f310, evict=false) at /home/alice/aliska/10.2/storage/innobase/buf/buf0buf.cc:6015

#13 0x0000555b3734c70f in fil_aio_wait (segment=2) at /home/alice/aliska/10.2/storage/innobase/fil/fil0fil.cc:5341

#14 0x0000555b371f3dca in io_handler_thread (arg=0x555b3816ac70 <n+16>) at /home/alice/aliska/10.2/storage/innobase/srv/srv0start.cc:343

#15 0x00007f19417496ba in start_thread (arg=0x7f1935207700) at pthread_create.c:333

#16 0x00007f1940bde3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Compressed file /home/alice/aliska/10.2/mysql-test/var/log/innodb_gis.kill_server-innodb/mysqld.1/data/core

innodb_gis.alter_spatial_index 'innodb'  w1 [ pass ]   1346

***Warnings generated in error logs during shutdown after running tests: innodb_gis.kill_server

mysqld: /home/alice/aliska/10.2/storage/innobase/rem/rem0rec.cc:566: ulint* rec_get_offsets_func(const rec_t*, const dict_index_t*, ulint*, bool, ulint, const char*, unsigned int, mem_heap_t**): Assertion `!leaf' failed.