topic Not able to start activiti after accidentally shut down in Alfresco Forum

Not able to start activiti after accidentally shut down

gets_sanket_pat — Wed, 16 Aug 2017 15:41:56 GMT

Hi My activiti server accidentally shut down because of some reason. and so does Activiti.I am trying to restart again using the usual process but I am getting the following error.Please help. INFO 8/16/17 11:28 AM: liquibase: Waiting for changelog lock....INFO 8/16/17 11:28 AM: liquibase: Waiting f

Re: Not able to start activiti after accidentally shut down

mkappel — Fri, 25 Aug 2017 15:15:22 GMT

Hi Sanket Patel,

Yes, this could happen in case the DB is forced to shutdown, so you're right it it is probably related to the accidental shutdown.

There's a way to manually unlock: Connect to the DB console an fire following statement:

UPDATE DATABASECHANGELOGLOCK SET LOCKED=FALSE, LOCKGRANTED=null, LOCKEDBY=null where ID=1;

This might be of help as well: https://stackoverflow.com/questions/15528795/liquibase-lock-reasons

Hope this helps,

Martin

Re: Not able to start activiti after accidentally shut down

gets_sanket_pat — Fri, 25 Aug 2017 17:04:59 GMT

Yes. I will able to do that only I can connect to the liquibase database. But it is used by the alfresco.

Please also post the details how to connect to the liquibase so that I can run the above query.

Thanks

Re: Not able to start activiti after accidentally shut down

mkappel — Mon, 28 Aug 2017 08:22:37 GMT

Hi Sanket,

Try starting the database, only. Navigate to installer directory of H2 and find the start-h2.bat/sh script to Startup the database.

After Startup

connect to http://[Host-IP]:8082/ or respective port
Login with DB credentials, by default alfresco/alfresco

Martin