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
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
Running Sen4Cap DB 2.0