[MDEV-9918] [ERROR] mysqld got signal 11 during ALTER TABLE `name` COLUMN ADD - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1.13, 10.0(EOL), 10.1(EOL)
Fix Version/s: 10.0.25, 10.1.14
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Labels:
- upstream
Environment:

Hide
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).

Show
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).

Sprint:
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

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

Attachments

Activity

Transition	Time In Source Status	Execution Times

Elena Stepanova made transition - 2016-04-15 13:49

Open

Confirmed

1d 10h 21m

Jan Lindström (Inactive) made transition - 2016-04-20 05:49

Confirmed

In Progress

4d 16h

Jan Lindström (Inactive) made transition - 2016-04-22 05:58

In Progress

Closed

2d 8m

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Jarosław Siebert

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2016-04-14 03:28

Updated:: 2016-06-23 15:52

Resolved:: 2016-04-22 05:58

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server