Lock table in database after migrate

ERPNext Customize ERPNext
1

i get after migrate a query in database like that and its lock :
ALTER TABLE tabSales Partner MODIFY custom_agent_type varchar(140), MODIFY commission_rate decimal(21,9) not null default 0, MODIFY custom_guarantee_amount decimal(21,9) not null default 0

how could i fix issue ?

2

Set maintenance-mode on

bench –site your_site set-maintenance-mode on

restart mariadb

sudo systemctl restart mariadb

Migrate

bench --site your-site migrate --skip-failing

Set maintenance-mode off

bench –site your_site set-maintenance-mode off
1 Like