Bug #96895 Test main.partition_rename_longfilename fails on Samba storage
Submitted: 17 Sep 2019 5:45 Modified: 17 Sep 2019 9:51
Reporter: Wu Jiaye Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.7.26 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[17 Sep 2019 5:45] Wu Jiaye 
Description:
The test main.partition_rename_longfilename fails on Samba storage

How to repeat:
drop database test;

create database test;

use test;

DROP TABLE IF EXISTS t1, t2;

CREATE TABLE t1 (a INT)

PARTITION BY RANGE (a)

(PARTITION p0 VALUES LESS THAN (6),

 PARTITION `p1....................` VALUES LESS THAN (9),

 PARTITION p2 VALUES LESS THAN MAXVALUE);

 

 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);

 RENAME TABLE t1 TO `t2_............................end`;

Suggested fix:
https://jira.mariadb.org/browse/MDEV-4214
[17 Sep 2019 5:47] Wu Jiaye 
That will happen if the disk is mounted from a remote server, e.g. Azure Storage
[17 Sep 2019 6:18] Wu Jiaye 
Change category and severity
[17 Sep 2019 9:51] Bogdan Kecman 
Hi,

Thanks for the report, not a great idea to mount your datadir trough samba, but, it is a bug and should be fixed. Verified as stated.

thanks