I edited a Mapping but Connect is stuck in Alter Schema


You added or removed columns from a Mapping and hit Save. Connect has been stuck for more than 5 min in the Alter Schema state.


Being stuck in Alter Schema is usually caused by a query holding open locks on the table. You can verify is that is the case by inspecting the output of pg:locks. If there are queries that are holding locks, you can kill them using pg:kill. You will be able to identify queries generated by Connect because the application_name will have an "hc." prefix.

heroku pg:locks
heroku pg:kill pid

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support
Terms of Service Privacy Cookies © 2018 Salesforce.com