topic Couldn't upgrade db schema ?? in Alfresco Archive

Couldn't upgrade db schema ??

bhj2 — Mon, 04 Jul 2011 14:47:28 GMT

Hello, I was using activiti 5.4 with my own vaadin explorer and mysql as db. It was working fine. Then I decided to change to the last version (5.6). I compiled my project, deployed it on my glassfish server and started using my app. It was also working fine. BUT when I redeployed my project and tri

Re: Couldn't upgrade db schema ??

jbarrez — Tue, 05 Jul 2011 07:20:22 GMT

So if I understand you correct, the database upgrade is run whenever you redeploy your app?

That's definitely not what it should do: the upgrade should upgrade the database schema, and in the next redeploys the engine should see that the schema is up to date now. Can you verify what the values of the ACT_GE_PROPERTY table is? There is the current schema version saved.

Re: Couldn't upgrade db schema ??

bhj2 — Wed, 06 Jul 2011 06:44:02 GMT

So if I understand you correct, the database upgrade is run whenever you redeploy your app?

That's definitely not what it should do: the upgrade should upgrade the database schema, and in the next redeploys the engine should see that the schema is up to date now. Can you verify what the values of the ACT_GE_PROPERTY table is? There is the current schema version saved.

You understand me correct. And another person working on the same project but with tomcat and your activiti explorer has a similar problem.

in my db, the schema in ACT_GE_PROPERTY, is create(5.6) upgrade(5.6 -> 5.4)

In his db, the schema is is the same except he has no exception and much more upgrades… create (5.6) upgrade(5.6 -> 5.4) upgrade(5.4 -> 5.6) upgrade(5.6 -> 5.4) upgrade(5.4 -> 5.6) upgrade(5.6 -> 5.4) upgrade(5.4 -> 5.6), etc…

Best regards!
bhj2

Re: Couldn't upgrade db schema ??

bhj2 — Wed, 06 Jul 2011 07:25:19 GMT

I set the schema.version to "5.6" and the history to "create(5.6)" and I think (didn't do lots of tests) that it is working now.

Re: Couldn't upgrade db schema ??

bhj2 — Wed, 06 Jul 2011 08:27:32 GMT

Actually it is not working. I thought it was because i put

<property name="databaseSchemaUpdate" value="false" />

in activiti.cfg.xml …

Re: Couldn't upgrade db schema ??

jbarrez — Thu, 07 Jul 2011 07:56:37 GMT

Very bizar. Are you using a shared database? the upgrade details seem completely screwed …

Re: Couldn't upgrade db schema ??

bhj2 — Mon, 11 Jul 2011 09:10:36 GMT

I was using two different applications. I didn't notice that one was still using engine5.4.jar But shouldn't it be possible to use engine 5.4 with db 5.6?

Re: Couldn't upgrade db schema ??

jbarrez — Mon, 11 Jul 2011 09:54:57 GMT

Ah, that explains it. You can't use an older engine against a newer DB, as the database structure might have evolved.

No, the engine checks on boot if the database is in the right state. If not, it tries to fix it, hence the errors you are seeing.