Server version: 10.1.13-MariaDB
key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=4
max_threads=153
thread_count=2
OS: Alpinelinux 3.3.3 based on musl-libc running as guest on kvm host (Alpinelinux).
10.0.25
Description
From mariadb log:
2016-04-14 4:58:03 140116923128496 [ERROR] Table ./csm/history_digital185410 has a primary key in InnoDB data dictionary, but not in MySQL!
2016-04-14 4:58:03 140116923128496 [ERROR] InnoDB: Table csm/history_digital185410 contains 2 indexes inside InnoDB, which is different from the number of indexes 1 defined in the MySQL
2016-04-14 4:58:03 140116923128496 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
160414 4:58:03 [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.
The database crashed many times during altering tables.
There is over 400000 small tables in this database, and I wish to alter about 220000 tables.
RAM memory in system: 4GB.
Storage used for database: about 31GB
I would like to add some more details about this case.
1. This is probably related with hardware problems (one hard drive was corrupted and i have replaced it, but
didn't recovery from backup as I didn't noticed any problem with services before.
2. When I do select * from `corrupted_table`; I get right results.
3. When I do describe `corrupted_table`; I get mysqld got signal 11
4. When I do drop table `corrupted_table`; the table is droped
5. When I create `corrupted_table` and insert data, everything works fine.
So I fixed the problem in my case by drop and create table that cused the problems.
Jarosław Siebert
added a comment - I would like to add some more details about this case.
1. This is probably related with hardware problems (one hard drive was corrupted and i have replaced it, but
didn't recovery from backup as I didn't noticed any problem with services before.
2. When I do select * from `corrupted_table`; I get right results.
3. When I do describe `corrupted_table`; I get mysqld got signal 11
4. When I do drop table `corrupted_table`; the table is droped
5. When I create `corrupted_table` and insert data, everything works fine.
So I fixed the problem in my case by drop and create table that cused the problems.
#8 0x00007f244d802004 in row_merge_build_indexes (trx=0x7f243fa41278, old_table=0x7f243fab62f8, new_table=0x7f243fab6578, online=true, indexes=0x7f243fa1d470, key_numbers=0x7f243fa1d478, n_indexes=1, table=0x7f243fa5f470, add_cols=0x7f243fa1d4c8, col_map=0x7f243fa1d590, add_autoinc=18446744073709551615, sequence=...) at /src/10.1/storage/innobase/row/row0merge.cc:4079
#9 0x00007f244d72ac50 in ha_innodb::inplace_alter_table (this=0x7f243f835888, altered_table=0x7f243fa5f470, ha_alter_info=0x7f2456392a80) at /src/10.1/storage/innobase/handler/handler0alter.cc:4161
#10 0x0000560f5fc09acd in handler::ha_inplace_alter_table (this=0x7f243f835888, altered_table=0x7f243fa5f470, ha_alter_info=0x7f2456392a80) at /src/10.1/sql/handler.h:3686
#11 0x0000560f5fc01cbc in mysql_inplace_alter_table (thd=0x7f244c4f3430, table_list=0x7f243fa526a8, table=0x7f243fa4cc70, altered_table=0x7f243fa5f470, ha_alter_info=0x7f2456392a80, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f2456392af0, alter_ctx=0x7f2456393690) at /src/10.1/sql/sql_table.cc:7105
#12 0x0000560f5fc06508 in mysql_alter_table (thd=0x7f244c4f3430, new_db=0x7f243fa52c98 "test", new_name=0x0, create_info=0x7f2456394280, table_list=0x7f243fa526a8, alter_info=0x7f24563941f0, order_num=0, order=0x0, ignore=false) at /src/10.1/sql/sql_table.cc:8917
#13 0x0000560f5fc76881 in Sql_cmd_alter_table::execute (this=0x7f243fa52d88, thd=0x7f244c4f3430) at /src/10.1/sql/sql_alter.cc:325
#14 0x0000560f5fb4a7a4 in mysql_execute_command (thd=0x7f244c4f3430) at /src/10.1/sql/sql_parse.cc:5679
#15 0x0000560f5fb4e9c2 in mysql_parse (thd=0x7f244c4f3430, rawbuf=0x7f243fa525c8 "alter table t1 add j int", length=24, parser_state=0x7f24563955e0) at /src/10.1/sql/sql_parse.cc:7304
#16 0x0000560f5fb3d3c3 in dispatch_command (command=COM_QUERY, thd=0x7f244c4f3430, packet=0x7f244ff874b1 "alter table t1 add j int", packet_length=24) at /src/10.1/sql/sql_parse.cc:1486
#17 0x0000560f5fb3c0f5 in do_command (thd=0x7f244c4f3430) at /src/10.1/sql/sql_parse.cc:1107
#18 0x0000560f5fc71e34 in do_handle_one_connection (thd_arg=0x7f244c4f3430) at /src/10.1/sql/sql_connect.cc:1349
#19 0x0000560f5fc71b98 in handle_one_connection (arg=0x7f244c4f3430) at /src/10.1/sql/sql_connect.cc:1261
#20 0x0000560f6037a598 in pfs_spawn_thread (arg=0x7f244c782e70) at /src/10.1/storage/perfschema/pfs.cc:1860
#21 0x00007f24560180a4 in start_thread () from /lib64/libpthread.so.0
Stack trace from 10.1.13 release bintar
2 <signal handler called>
#3 0x00007f05ebe2ee10 in __memcpy_sse2_unaligned () from /lib64/libc.so.6
#4 0x00007f05e50be475 in memcpy (__src=<optimized out>, __dest=<optimized out>, __len=4294967295) at /usr/include/x86_64-linux-gnu/bits/string3.h:52
#10 0x00007f05e50dcd2a in row_merge_build_indexes (trx=0x7f05d653fa68, old_table=0x7f05d642d5e8, new_table=0x7f05d642d868, online=true, indexes=0x7f05d641e760, key_numbers=0x7f05d641e768, n_indexes=1, table=table@entry=0x7f05d6669008, add_cols=0x7f05d641e7b8, col_map=0x7f05d641e878, add_autoinc=18446744073709551615, sequence=...) at /home/buildbot/buildbot/build/storage/innobase/row/row0merge.cc:4079
#11 0x00007f05e5047edd in ha_innodb::inplace_alter_table (this=0x7f05d6627020, altered_table=0x7f05d6669008, ha_alter_info=0x7f05ed395050) at /home/buildbot/buildbot/build/storage/innobase/handler/handler0alter.cc:4161
#12 0x0000556311980d41 in ha_inplace_alter_table (ha_alter_info=0x7f05ed395050, altered_table=0x7f05d6669008, this=<optimized out>) at /home/buildbot/buildbot/build/sql/handler.h:3686
#14 0x0000556311abc3bd in mysql_alter_table (thd=0x7f05e2289000, thd@entry=0x7f05e2289008, new_db=<optimized out>, new_name=<optimized out>, create_info=create_info@entry=0x7f05ed396820, table_list=table_list@entry=0x7f05d64c5100, alter_info=alter_info@entry=0x7f05ed396790, order_num=0, order=0x0, ignore=false) at /home/buildbot/buildbot/build/sql/sql_table.cc:8917
#15 0x0000556311afd947 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7f05e2289008) at /home/buildbot/buildbot/build/sql/sql_alter.cc:325
#16 0x0000556311a33dcf in mysql_execute_command (thd=thd@entry=0x7f05e2289008) at /home/buildbot/buildbot/build/sql/sql_parse.cc:5679
#17 0x0000556311a3bd2d in mysql_parse (thd=0x7f05e2289008, rawbuf=<optimized out>, length=<optimized out>, parser_state=0x7f05ed398600) at /home/buildbot/buildbot/build/sql/sql_parse.cc:7304
#18 0x0000556311a3e97b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f05e2289008, packet=0x7f05e22c0009 "alter table t1 add j int", packet_length=3595325472, packet_length@entry=24) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1486
#19 0x0000556311a3ef2b in do_command (thd=0x7f05e2289008) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1107
#20 0x0000556311afa7bf in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f05e2289008) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1349
#21 0x0000556311afa917 in handle_one_connection (arg=arg@entry=0x7f05e2289008) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1261
#22 0x0000556311f3223d in pfs_spawn_thread (arg=0x7f05eb03f608) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:1860
#23 0x00007f05ec7d10a4 in start_thread () from /lib64/libpthread.so.0
Also reproducible on MySQL 5.6, MySQL 5.7.
MTR test case
--source include/have_innodb.inc
createtable t1 (pk int, i int, key(i)) engine=InnoDB;
MDEV-9713 Sporadic test failure: sys_vars.innodb_buffer_pool_load_now_basic
Previous fix using wait condition did not work because of MDEV-9867, so
we have to use conditional sleep instead. Sleep will only happen if the test
is executed after another one which also ran buffer pool dump without
server restart between two tests.
Jan Lindström (Inactive)
added a comment - commit f8adeccd78bff80725a95b73447e34a5f4528179
Author: Elena Stepanova <elenst@montyprogram.com>
Date: Mon Apr 4 17:04:14 2016 +0300
MDEV-9713 Sporadic test failure: sys_vars.innodb_buffer_pool_load_now_basic
Previous fix using wait condition did not work because of MDEV-9867 , so
we have to use conditional sleep instead. Sleep will only happen if the test
is executed after another one which also ran buffer pool dump without
server restart between two tests.
People
Jan Lindström (Inactive)
Jarosław Siebert
Votes:
0Vote for this issue
Watchers:
5Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
I would like to add some more details about this case.
1. This is probably related with hardware problems (one hard drive was corrupted and i have replaced it, but
didn't recovery from backup as I didn't noticed any problem with services before.
2. When I do select * from `corrupted_table`; I get right results.
3. When I do describe `corrupted_table`; I get mysqld got signal 11
4. When I do drop table `corrupted_table`; the table is droped
5. When I create `corrupted_table` and insert data, everything works fine.
So I fixed the problem in my case by drop and create table that cused the problems.