Bug #105675 Random error "Errcode: 13 - Permission denied" occured when creating an index

• Submitted: 23 Nov 2021 10:33
• Modified: 18 May 2022 2:45
• Reporter: Yuwei Yang
• Status: Unsupported
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.7.35
• OS: Any
• CPU Architecture: Any

[23 Nov 2021 10:33] Yuwei Yang

Description:
Below error received when creating an index on a temp table:

Error on rename of '.\ircwhxshen\#sql-d24_568.frm' to '.\ircwhxshen\tkwb739m8md000.frm' (Errcode: 13 - Permission denied)

The error is not received every time but quite often.

Example SQL Query:

create table TADSNLCX7MD000 (
    `YEAR_ID`    DECIMAL(38, 0), 
    `DAY_DATE`    DATETIME, 
    `ZIPCODE`    VARCHAR(255), 
    `WJXBFS1`    DOUBLE, 
    `Revenue`    DOUBLE, 
    `WJXBFS2`    DOUBLE);

insert into TADSNLCX7MD000 
select    `a13`.`YEAR_ID`  `YEAR_ID`,
    `a11`.`ORDER_DATE`  `DAY_DATE`,
    `a12`.`ZIPCODE`  `ZIPCODE`,
    sum((`a11`.`QTY_SOLD` * `a11`.`UNIT_COST`))  `WJXBFS1`,
    sum((`a11`.`QTY_SOLD` * (`a11`.`UNIT_PRICE` - `a11`.`DISCOUNT`)))  `Revenue`,
    sum((`a11`.`QTY_SOLD` * ((`a11`.`UNIT_PRICE` - `a11`.`DISCOUNT`) - `a11`.`UNIT_COST`)))  `WJXBFS2`
from    `ORDER_DETAIL`    `a11`
    join    `LU_CUSTOMER`    `a12`
      on     (`a11`.`CUSTOMER_ID` = `a12`.`CUSTOMER_ID`)
    join    `LU_DAY`    `a13`
      on     (`a11`.`ORDER_DATE` = `a13`.`DAY_DATE`)
where    (`a11`.`ORDER_DATE` in ('2007-01-02 00:00:00', '2007-01-03 00:00:00', '2007-01-04 00:00:00', '2007-01-05 00:00:00', '2007-01-06 00:00:00', '2008-03-20 00:00:00', '2008-03-21 00:00:00', '2008-03-22 00:00:00', '2008-03-23 00:00:00')
 and `a12`.`ZIPCODE` in ('01236     ', '01373     ', '01453     ', '01854     ', '01905     ', '02090     ', '02111     ', '02111a    ', '02114     ', '02125     ', '02127     ', '02138     '))
group by    `a13`.`YEAR_ID`,
    `a11`.`ORDER_DATE`,
    `a12`.`ZIPCODE`;

create index TADSNLCX7MD000_i on TADSNLCX7MD000 (`YEAR_ID`, `DAY_DATE`, `ZIPCODE`);

How to repeat:
Run the provided SQL Query against MySQL Database

[23 Nov 2021 10:47] MySQL Verification Team

Thank you for the bug report. You are using a quite older 5.6.35 version ,latest released version is 5.6.51.

[29 Jan 2022 6:19] Yuwei Yang

We upgrade our MySQL server version to 5.7.35 but still have this issue. Could you take another look?

[18 May 2022 2:45] Yuwei Yang

Hi team, this issue happens quite often in our environment. Can you please take a look?

BTW, how can I change the bug status to open?