[MDEV-16142] Merge new release of InnoDB MySQL 5.7.22 to 10.2 Created: 2018-05-11 Updated: 2022-10-09 Resolved: 2018-05-12 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.2 |
| Fix Version/s: | 10.2.15, 10.3.7 |
| Type: | Bug | Priority: | Blocker |
| Reporter: | Marko Mäkelä | Assignee: | Marko Mäkelä |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | upstream | ||
| Issue Links: |
|
||||||||||||||||||||||||||||||||
| Description |
|
The following changes between MySQL 5.7.21 and MySQL 5.7.22 touch InnoDB files. (empty commit message) Bug 27122803 - BACKPORT FIX FOR BUG 25899959 TO MYSQL-5.7 BUG#27189701 INNODB: EARLY RELEASE GAP LOCKS FOR RC ISOLATION However, compared to MySQL 5.7, MariaDB supports innodb_lock_schedule_algorithm=vats, and it is the default setting. If we wanted to take this patch from MySQL, we should look at the 8.0 version of it, which introduced LOCK_CATS_THRESHOLD. Furthermore, we should ensure that this does not break the locking of SPATIAL INDEX. Bug #26731689 FK ON TABLE WITH GENERATED COLS: ASSERTION POS < N_DEF Bug #27212129 [ERROR] INNODB: A RECORD LOCK WAIT HAPPENS IN A DICTIONARY OPERATION. INDEX `ID_ Bug #26805833 INNODB COMPLAINS OF SYNTAX ERROR, BUT DOES NOT SAY WHICH OPTION Bug #25076416 VIRTUAL COLUMN IS NOT CONSIDERED WHILE FETCHING THE AUTOINC COLUMN Bug #27041445 SERVER ABORTS IF FTS_DOC_ID EXCEEDS FTS_DOC_ID_MAX_STEP Bug #26935001 ALTER TABLE AUTO_INCREMENT TRIES TO READ INDEX FROM DISCARDED TABLESPACE Bug#26105334 WARNINGS WHEN BUILD WITH GCC 7.1.1. Bug #26958695 INNODB NESTED STORED FIELD WITH CONSTRAINT KEY PRODUCE BROKEN TABLE Bug#27399897 PUNCH HOLE IS MISSED IN FIRST COMPRESSION OF PAGES. Bug #27304661 MYSQL CRASH DOING SYNC INDEX ] [FATAL] INNODB: SEMAPHORE WAIT HAS LASTED > 600 Bug #27141613 ASSERTION: TRX0REC.CC:319:COL->IS_VIRTUAL() / CRASH IN TRX_UNDO_READ_V_COLS BUG#27272806 ASSERT DURING REPLICAITON:: LOCK == __NULL BUG#27294066 INNODB: FAILING ASSERTION: !(TYPE_MODE & 1024) Bug #26300119 ASSERTION IN PREBUILT->TRX->ISOLATION_LEVEL == TRX_ISO_READ_UNCOMMITTED FOLLOW-UP FIX FOR BUG#27141613 Bug#26696448 REPLAY LOG RECORD CAUSE MYSQLD CRASH DURING ONLINE DDL Bug #27158030 INNODB ONLINE ALTER CRASHES WITH CONCURRENT DML (empty commit message) Bug #23593654 CRASH IN BUF_BLOCK_FROM_AHI WHEN LARGE PAGES AND AHI ARE ENABLED Bug#27361662 ERROR NOT THROWN ON CREATING TEMPORARY TABLE IN INNODB_FILE_PER_TABLE TABLESPACE Bug#26960215 : EXPORT/IMPORT IS CRASHING WITH TABLE CREATED IN REDUNDANT ROW FORMAT Bug #26334149 - MYSQL CRASHES WHEN FULL TEXT INDEXES IBD FILES ARE ORPHANED DUE TO RENAME TABLE |
| Comments |
| Comment by Thirunarayanan Balathandayuthapani [ 2018-05-11 ] | |||||||
|
Adding the test case for Bug #26958695 INNODB NESTED STORED FIELD WITH CONSTRAINT KEY PRODUCE BROKEN TABLE
But the problem doesn't exist in MariaDB. Because num_base is set during innodb_base_col_setup_for_stored(). | |||||||
| Comment by Marko Mäkelä [ 2022-10-09 ] | |||||||
|
|