[MDEV-12348] Cannot reorganize partitions after upgrade to 10.0.30 Created: 2017-03-23  Updated: 2019-01-13  Resolved: 2017-11-20

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Storage Engine - TokuDB
Affects Version/s: 10.0.30
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Jan Hejl Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback, partitioning, structure, tokudb
Environment:

Gentoo linux
4.9.13-hardened
2x AMD Opteron 6376
Xen 4.7.1-r8 dom0
Glibc 2.23-r3, GCC 4.9.4

Attachments: File my.cnf     File scanner.sql    
Issue Links:
Relates
relates to MDEV-18221 Failed to execute action for entry = ... Open

 Description   

After upgrading MariaDB server from version 10.0.29 to version 10.0.30 i'm unable to reoganize partitions in my DB (table structure attached) with command:

LOCK TABLE scanner WRITE;
 
alter table scanner reorganize partition pMAX INTO (partition p1492218001 values less than (1492218001), partition pMAX values less than MAXVALUE);

mysqld.err shows:

170323 12:32:25 [ERROR] Could not rename table from ./dbname/scanner#P#p1490880727#TMP# to ./dbname/scanner#P#p1490880727 because destination db does not exist
 
170323 12:32:25 [ERROR] Could not rename table from ./dbname/scanner#P#pMAX#TMP# to ./dbname/scanner#P#pMAX because destination db does not exist
 
170323 12:32:25 [ERROR] Could not rename table from ./dbname/scanner#P#pMAX#TMP# to ./dbname/scanner#P#pMAX because destination db does not exist
 
170323 12:32:25 [ERROR] Failed to execute action for entry = 5 from ddl log

I'm a bit afraid this was introduced with https://github.com/MariaDB/server/commit/dc1c9e69d0

Downgrading to 10.0.29 helped.
Even dump and restore was a solution, but I would like to ommit dump/restore solution, there's a lot of DB and lot more data.

Any hints?

 Comments   
Comment by Elena Stepanova [ 2017-03-24 ]

I"m not getting the error, maybe it depends on configuration somehow – could you please attach your cnf files?
What is the error code ALTER fails with, as shown in the client?

cvicentiu, any ideas about this?

Comment by Jan Hejl [ 2017-03-24 ]

Bash, mysql binary output:

ERROR 1017 (HY000) at line 1: Can't find file: 'scanner' (errno: 2 "No such file or directory")

Config file attached.

Comment by Jan Hejl [ 2017-04-10 ]

Any ideas?

Comment by Elena Stepanova [ 2017-10-23 ]

jhejl,

are you still having this problem?
If you do – what does ERROR 1017 (HY000) at line 1: Can't find file: 'scanner' (errno: 2 "No such file or directory") relate to, what were you attempting to execute?

Comment by Elena Stepanova [ 2017-11-20 ]

If you have further information on the issue, please comment and we will re-open the report.

Generated at Thu Feb 08 07:57:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.