Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.13, 10.0(EOL), 10.1(EOL)
-
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
| Field | Original Value | New Value |
|---|---|---|
| Affects Version/s | 10.1.13 [ 21803 ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Component/s | Storage Engine - InnoDB [ 10129 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Assignee | Jan Lindström [ jplindst ] | |
| Labels | upstream | |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| 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 |
From mariadb log:
{noformat} 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. {noformat} 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 |
| Environment |
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). |
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 [ 50 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2016-04-22 05:58:56.0 | 2016-04-22 05:58:56.286 |
| Component/s | Storage Engine - XtraDB [ 10135 ] | |
| Fix Version/s | 10.0.25 [ 21701 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.1.14 [ 21804 ] |
| Comment | [ 10.1 fix appears in 10.1.14. ] |
| Workflow | MariaDB v3 [ 74830 ] | MariaDB v4 [ 150326 ] |