[MDEV-24499] Server upgrade causes compound index and related query to fail. Created: 2020-12-29  Updated: 2021-01-01

Status: Open
Project: MariaDB Server
Component/s: Partitioning, Storage Engine - InnoDB, Upgrades
Affects Version/s: 10.4.10
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Sarabjeet Duhra Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Windows Server 2016


Attachments: File db.err    

 Description   

Steps to reproduce:
Step 1: Install DB version 10.1.14
Step 2: Upgrade DB to 10.4.10
mysql_upgrade reports errors as seen in attached log.
The errors are for a compound index on a table with 721 partitions.
All partitions are pre-created during install/upgrade.
Partitions uses values less than date to organize the data - one partition for each day.
Each day a new partition is used to store data into this table called history.
Data older than 721 days is deleted from the table by dropping the oldest partition.
Table DDL:

create table `history` (
`value_key int(11) not null,
`timestamp` datetime not null,
`valuei` int(11),
`group_id` int(11) not null default 0,
unique index `idx_value_id_timestamp`(`value_key`, `timestamp`, `group_id`)


Generated at Thu Feb 08 09:30:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.