[MDEV-18486] Database crash on a table with indexed virtual column - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2.15, 10.3.11, 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.2.23, 10.3.14, 10.4.4
Component/s: Virtual Columns
Labels:
- crash
Environment:

Hide
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

Show
NAME="CentOS Linux" VERSION="7 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="7" PRETTY_NAME="CentOS Linux 7 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:7" HOME_URL=" https://www.centos.org/ " BUG_REPORT_URL=" https://bugs.centos.org/ " CENTOS_MANTISBT_PROJECT="CentOS-7" CENTOS_MANTISBT_PROJECT_VERSION="7" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="7"

Description

Database crashed with queries executed on tables with stored generated fields.
DB was highly inconsistent and crashing on random select, insert and truncate statements. Attached logs

Attachments

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

mysql_error.log
524 kB
2019-02-05 20:57

Issue Links

is duplicated by

MDEV-15881 Assertion `is_valid_value_slow()' failed in Datetime::Datetime or corrupt data after ALTER with indexed persistent column

Closed

MDEV-18695 Corruption (?) with multi-value insert and stored virtual column index

Closed

is part of

MDEV-17221 Production Database restarted

Closed

relates to

MDEV-15881 Assertion `is_valid_value_slow()' failed in Datetime::Datetime or corrupt data after ALTER with indexed persistent column

Closed

MDEV-17834 Server crashes in row_upd_build_difference_binary on LOAD DATA into table with indexed virtual column

Closed

MDEV-18270 ASAN heap-use-after-free in Field_long::val_int()

Closed

MDEV-18366 Crash on SELECT on a table that contains indexed virtual columns

Closed

MDEV-18414 Server crash or ASAN heap-use-after-free in my_strtod_int / Value_source::Converter_strntod::Converter_strntod

Closed

MDEV-18449 ASAN heap-use-after-free in my_strnncollsp_simple

Closed

MDEV-23018 Database corruption involving an index on a virtual column and a charset change

Confirmed

(5 relates to)

Activity

Ascending order - Click to sort in descending order

Syed Tausiff created issue - 2019-02-05 20:59

Syed Tausiff made changes - 2019-02-05 20:59

Field	Original Value	New Value
Link		This issue is part of ~~MDEV-17221~~ [ ~~MDEV-17221~~ ]

Elena Stepanova made changes - 2019-02-05 21:18

Epic/Theme

server

Elena Stepanova made changes - 2019-02-05 21:18

Labels

crash

crash need_feedback

Syed Tausiff made changes - 2019-02-05 21:21

Description

Database crashed with queries executed on tables with stored generated fields.
DB was highly inconsistent and crashing on random select, insert and delete statements. Attached logs

Elena Stepanova made changes - 2019-02-05 21:28

Labels

crash need_feedback

crash

Syed Tausiff made changes - 2019-02-05 21:30

Description

Database crashed with queries executed on tables with stored generated fields.
DB was highly inconsistent and crashing on random select, insert and delete statements. Attached logs

Database crashed with queries executed on tables with stored generated fields.
DB was highly inconsistent and crashing on random select, insert and truncate statements. Attached logs

Elena Stepanova made changes - 2019-02-05 21:31

Status

Open [ 1 ]

Confirmed [ 10101 ]

Elena Stepanova made changes - 2019-02-05 21:57

Summary

Database crash - [ERROR] mysqld got signal 11 ;

Database crash - [ERROR] mysqld got signal 11 - variety of crashes on a table with indexed virtual column