Description of problem: delete_async_tasks_and_compensation_data.sql exits on KeyError: [root@elad-rhevm32 dbscripts]# psql -U postgres engine -f delete_async_tasks_and_compensation_data.sql Password for user postgres: psql:delete_async_tasks_and_compensation_data.sql:1: ERROR: cannot truncate a table referenced in a foreign key constraint DETAIL: Table "async_tasks_entities" references "async_tasks". HINT: Truncate table "async_tasks_entities" at the same time, or use TRUNCATE ... CASCADE. Version-Release number of selected component (if applicable): rhevm-dbscripts-3.2.0-10.18.beta2.el6ev.noarch rhevm-backend-3.2.0-10.18.beta2.el6ev.noarch How reproducible: 100% Steps to Reproduce: 1.On engine: Run: psql -U postgres engine -f delete_async_tasks_and_compensation_data.sql Actual results: delete_async_tasks_and_compensation_data.sql exits on KeyError Expected results: delete_async_tasks_and_compensation_data.sql should succeed
Why did you execute this script in the first place ? What was the problem scenario you were trying to solve ?
(In reply to comment #1) > Why did you execute this script in the first place ? > > What was the problem scenario you were trying to solve ? Double checked that. This script is called via the pre-upgrade step Bug is valid , I will handle that ASAP
fixed in commit: 568d77e
sf 13.1
3.2 has been released