Hybris 6.5 - Running update and only selecting "Update Running System" takes a long time

[Former Member]

We are finding that the system updates are taking a long time. Even if we only select "Update Running System", the updates are taking 1+ hours. Has anyone experienced anything similar and recommend any fixes?

[g_madhava1]

Sorry not really an answer.

In my case, It looks like Hybris for some reason is recreating all the custom tables again - as identified in the - update_master_schema.sql.

Let's say if the current custom table is A, Then with in the update_master_schema.sql I could see that the table A_ gets created, then copying the data from A to A_ and recreate table A and copy the data once again from A_ to A. This is pretty inefficient, and is the root cause on my side. This happens only on 1 of the DEV server.

Is there a documentation which points out how Hybris determines that a custom table needs to be recreated ?

- was your issue somewhat related to my issue or was yours altogether a different issue ?

[tino_kissig]

You could try to call ant updateystem -DdryRun=true and have look at both of the sql scripts whether there's something in it which takes very long.

https://help.hybris.com/6.6.0/hcd/51c0d5fac2064b2d8a1161b67732a2cd.html