Skip Alter Table Commands During Class Rebuild in Pimcore

[2809akshay]

In Pimcore, there is a pre-defined command pimcore:deployment:classes-rebuild -c -v which is executed during deployments.
This command invokes the update function located in Dao.php under vendor/pimcore/pimcore/models/DataObject/ClassDefinition/Dao.php.

The update function includes several SQL operations, such as CREATE TABLE IF NOT EXISTS and ALTER TABLE.
However, during our weekly deployments, and while running this command, we often encounter deadlocks, particularly with the ALTER TABLE statements.
This is problematic because we also have certain jobs running daily, leading to conflicts and deployment delays.

To prevent these issues, it would be great, if we could any option that skips the ALTER TABLE commands during the class rebuild process.
If this is not feasible, we may have to explore the possibility of creating a custom DAO to handle the class rebuild functionality without triggering these table modifications.

We are using Pimcore v10.