Skip to content

MOVE PARTITION tries to move parts to the same disk where they already belong #7424

@excitoon

Description

@excitoon

@filimonov:

alter table test move partition tuple() TO volume 'default';

ALTER TABLE test
    MOVE PARTITION tuple() TO VOLUME 'default'


Ok.

0 rows in set. Elapsed: 148.339 sec.

ip-172-31-47-236.eu-central-1.compute.internal :) select database, table, disk_name,formatReadableSize(sum(bytes_on_disk)) from system.parts group by database, table, disk_name;

SELECT 
    database, 
    table, 
    disk_name, 
    formatReadableSize(sum(bytes_on_disk))
FROM system.parts
GROUP BY 
    database, 
    table, 
    disk_name

┌─database─┬─table─────┬─disk_name─┬─formatReadableSize(sum(bytes_on_disk))─┐
│ default  │ test      │ default   │ 13.32 GiB                              │
│ system   │ trace_log │ default   │ 9.87 KiB                               │
│ default  │ test      │ ephemeral │ 8.39 GiB                               │
│ system   │ part_log  │ default   │ 48.35 KiB                              │
└──────────┴───────────┴───────────┴────────────────────────────────────────┘

alter table test move partition tuple() TO volume 'default';

ALTER TABLE test
    MOVE PARTITION tuple() TO VOLUME 'default'


Received exception from server (version 19.15.3):
Code: 479. DB::Exception: Received from localhost:9000. DB::Exception: Part all_601_792_3_955 already on volume 'default'. 

0 rows in set. Elapsed: 0.041 sec. 

Why not moved?

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConfirmed user-visible misbehaviour in official releasecomp-multidiskMultiple disks/volumes storage policies, disk abstractions.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions