Skip to content

fs_storage_path_prefix excluded in the migration on postgresql, but added via db:add-missing-indices #46376

@kesselb

Description

@kesselb

Did a fresh installation on PostgreSQL 16 and was greeted with:

Screenshot from 2024-07-09 15-15-48

Screenshot from 2024-07-09 15-19-16

Migration:

if (!$schema->getDatabasePlatform() instanceof PostgreSQL94Platform) {
$table->addIndex(['storage', 'path'], 'fs_storage_path_prefix', [], ['lengths' => [null, 64]]);
}

Add missing index:

$event->addMissingIndex(
'filecache',
'fs_storage_path_prefix',
['storage', 'path'],
['lengths' => [null, 64]]
);

@icewind1991 what would you recommend, is there something to do?

cc @nextcloud/server-backend

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions