'Stock', IntegrityError(1062, "Duplicate entry 'Stock'

dineshpanchal432 · January 14, 2022, 8:56am

Fresh installed ERPNext

bench --site xyz.com install-app erpnext

Installing erpnext…
An error occurred while installing erpnext:
(‘Module Def’, ‘Stock’, IntegrityError(1062, “Duplicate entry ‘Stock’ for key ‘PRIMARY’”))

Muhammad_Saad · January 18, 2024, 6:43am

github.com/frappe/frappe

Frappe app install should be atomic

opened 01:33AM - 24 Jan 22 UTC

closed 08:20AM - 12 May 22 UTC

ChillarAnand

feature-request

When installing an app, if there is any issue app installation will fail and db …is left in bad state. When user fixes the issue and tries to install again, it will fail with integrity error. ``` $ bsv install-app erpnext Installing erpnext... An error occurred while installing erpnext: ('Module Def', 'Accounts', IntegrityError(1062, "Duplicate entry 'Accounts' for key 'PRIMARY'")) ``` Users have to manually clean up the db state to install the app again. To avoid this, we can make app install step as atomic and if there are any issues during installation, we can rollback to previous state.