Skip to content

Unable to delete site #7

@npetalid

Description

@npetalid

Step 1: Create a site
Step 2: Configure any processors and enable it to start processing
Step 3: Disable site
Step 4: Delete site
Expected result: The site is deleted
Actual result: A message that the site is deleted succesfuly is generated but the site is not deleted

The log files report these

 SQL [delete from site_tiles where (site_id = 11); delete from config where (site_id = 11); delete from step where task_id in (select id from task where job_id in (select id from job where site_id = 11)); delete from step_resource_log where task_id in (select id from task where job_id in (select id from job where site_id = 11)); delete from task where job_id in (select id from job where site_id = 11); delete from config_job where job_id in (select id from job where site_id = 11); delete from job where (site_id = 11); delete from scheduled_task_status where task_id in (select id from scheduled_task where site_id = 11); delete from scheduled_task where (site_id = 11); delete from l1_tile_history where downloader_history_id in (select id from downloader_history where site_id = 11); delete from downloader_history where (site_id = 11); delete from downloader_count where (site_id = 11); delete from product where (site_id = 11); delete from season where (site_id = 11); delete from config where (site_id = 11); delete from site where (id = 11)]; ERROR: update or delete on table "product" violates foreign key constraint "fk_product" on table "product_stats"
May 19 13:41:02 sen4cap start.sh: Detail: Key (id)=(3242) is still referenced from table "product_stats".; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "product" violates foreign key constraint "fk_product" on table "product_stats"
May 19 13:41:02 sen4cap start.sh: Detail: Key (id)=(3242) is still referenced from table "product_stats".] with root cause
May 19 13:41:02 sen4cap start.sh: org.postgresql.util.PSQLException: ERROR: update or delete on table "product" violates foreign key constraint "fk_product" on table "product_stats"
May 19 13:41:02 sen4cap start.sh: Detail: Key (id)=(3242) is still referenced from table "product_stats".

Running Sen4Cap DB 2.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions