Espocrm Upgrades fail when there are views in database

[murugappan]

Hi,

I have been having this nightmare when an upgrade is issued for Espocrm. We have defined database views in our Espocrm MySQL database. When we perform an upgradem, the process runs forever and terminates without any changes (good thing!). To achieve the upgrade we have to remove the views and then perform the upgrade. This is a high risk.

Any resolution please?