[Schema modification] Change schema modification process to be processed by worker
Description
The provisions tasks are being impacted by the schema modification queue. We should move it to a different worker. However, when we tried in https://totvslabs.atlassian.net/jira/software/c/projects/CAPL/boards/18?modal=detail&selectedIssue=CAPL-3846, the worker could not handle the schema modification process and kept dying and restarting.
The worker was dying because of this query:
CAPL-3780: [Schema Modification] Check out this frequent warning in internal queryDone
Now that the query’s issue is solved we must move the schema modification process to worker again, and since it processes other tasks we must increase its memory to 2Gi.