[MDEV-18897] InnoDB indexes are inconsistent with what defined in .frm for table - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4.3
Fix Version/s: 10.4.4
Component/s: Server
Labels:
None
Environment:
Docker version: 17.06.0-ce, build 02c1d87
MariaDB version: mysqld 10.4.3-MariaDB-1:10.4.3+maria~bionic

Description

STR
1. Execute in console

create table host

	id int not null

		primary key,

	name varchar(20) null

);

create table client

	id int not null

		primary key,

	name varchar(20) null,

	host_id int null,

	constraint id_name_idx1_u

		unique (id, name) using hash,

	constraint client_ibfk_1

		foreign key (host_id) references host (id)

);

create index host_id

	on client (host_id);

Expected:
Index created

Actual:
Server crash. My IDE shows me

[08] (conn=9) unexpected end of stream, read 0 bytes from 4 (socket was closed by server) java.io.EOFException: unexpected end of stream, read 0 bytes from 4 (socket was closed by server)

Logs in maria_crash_log.log & docker_inspect.txt

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

docker_inspect.txt
2019-03-12 08:54
5 kB
vasilii chernov
maria_crash_log.log
2019-03-12 08:55
11 kB
vasilii chernov

Issue Links

is caused by

MDEV-371 Unique indexes for blobs

Closed

relates to

MDEV-18799 Long unique does not work after failed alter table

Closed

Activity

People

Assignee:: Sachin Setiya (Inactive)

Reporter:: vasilii chernov

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2019-03-12 09:04

Updated:: 2019-03-17 08:41

Resolved:: 2019-03-17 08:41

Git Integration

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