Skip to content

PG::DependentObjectsStillExist during start_sync on index drop+recreateΒ #129

@annadowling

Description

@annadowling

When I execute start_sync I encounter the following error:

Starting sync failed: PG::DependentObjectsStillExist: ERROR: cannot drop index idx_spotlight_result_sets_default_on_tenant_template_created_at because index index_spotlight_result_sets_on_tenant_template_created_at requires it

image

Its not clear to me yet whether it was rolling back because of something else and this is a result of that.
Steps used to create this:

1. cleanup --group-name $groupName --everything
2. Manually clear all tables from target database
3. config_check --copy-schema  --group-name $groupName
4. bootstrap --copy-schema --group-name $groupName
5. start_sync --group-name $groupName

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions