After upgrade to atlassian stash 2.7.1 from 2.6.4 I see the following error in the log file of stash host directory

component-import> for the interface you're trying to use. https://developer.atlassian.com/x/TAEr for more details.

2013-09-16 21:17:47,556 INFO [localhost-startStop-2] c.a.s.internal.home.HomeLockAcquirer Releasing lock on /opt/stash

2013-09-16 21:17:47,558 INFO [localhost-startStop-2] c.a.s.i.server.BuildInfoLogger Stash 2.6.4 has shut down

2013-09-16 21:26:08,637 INFO [localhost-startStop-1] c.a.s.i.server.BuildInfoLogger Starting Stash 2.7.1 (f18cb1d built on Thu Aug 29 01:13:02 UTC 2013)

2013-09-16 21:26:08,642 INFO [localhost-startStop-1] c.a.s.i.server.BuildInfoLogger JVM: Sun Microsystems Inc. Java HotSpot(TM) 64-Bit Server VM 1.6.0_38-b05

2013-09-16 21:26:09,837 INFO [localhost-startStop-1] c.a.s.internal.home.HomeLockAcquirer Successfully acquired lock on home directory /opt/stash for 6014@app-br-39e

2013-09-16 21:26:12,103 INFO [localhost-startStop-1] c.a.s.internal.home.HomeLockAcquirer Releasing lock on /opt/stash

2013-09-16 21:26:12,106 INFO [localhost-startStop-1] c.a.s.i.server.BuildInfoLogger Stash 2.7.1 has shut down

2013-09-16 21:26:12,116 ERROR [localhost-startStop-1] o.s.web.context.ContextLoader Context initialization failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'crowdUserDao' defined in class path resource [crowd-spi-context.xml]: Unsatisfied dependency expressed through constructor argument with index 0 of type [org.springframework.transaction.PlatformTransactionManager]: : Error creating bean with name 'pluginConfiguration' defined in class path resource [stash-context.xml]: Cannot resolve reference to bean 'pluginPersistentStateStore' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pluginPersistentStateStore' defined in class path resource [stash-context.xml]: Cannot create inner bean 'com.atlassian.stash.internal.plugin.DefaultPluginPersistentStateStore#380fe8c4' of type [com.atlassian.stash.internal.plugin.DefaultPluginPersistentStateStore] while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.atlassian.stash.internal.plugin.DefaultPluginPersistentStateStore#380fe8c4' defined in class path resource [stash-context.xml]: Cannot resolve reference to bean 'pluginStateDao' while setting constructor argument; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'pluginStateDao' defined in URL [jar:file:/opt/atlassian-stash-2.7.1/atlassian-stash/WEB-INF/lib/stash-dao-impl-2.7.1.jar!/com/atlassian/stash/internal/plugin/HibernatePluginStateDao.class]: Unsatisfied dependency expressed through constructor argument with index 0 of type [org.hibernate.SessionFactory]: : Error creating bean with name 'liquibase' defined in class path resource [stash-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL UPDATE `stash`.`DATABASECHANGELOGLOCK` SET `LOCKED` = 1, `LOCKEDBY` = 'fe80:0:0:0:250:56ff:feaa:7715%3 (fe80:0:0:0:250:56ff:feaa:7715%3)', `LOCKGRANTED` = '2013-09-16 21:26:12.66' WHERE `ID` = 1 AND `LOCKED` = 0: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [stash-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL UPDATE `stash`.`DATABASECHANGELOGLOCK` SET `LOCKED` = 1, `LOCKEDBY` = 'fe80:0:0:0:250:56ff:feaa:7715%3 (fe80:0:0:0:250:56ff:feaa:7715%3)', `LOCKGRANTED` = '2013-09-16 21:26:12.66' WHERE `ID` = 1 AND `LOCKED` = 0: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pluginConfiguration' defined in class path resource [stash-context.xml]: Cannot resolve reference to bean 'pluginPersistentStateStore' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pluginPersistentStateStore' defined in class path resource [stash-context.xml]: Cannot create inner bean 'com.atlassian.stash.internal.plugin.DefaultPluginPersistentStateStore#380fe8c4' of type [com.atlassian.stash.internal.plugin.DefaultPluginPersistentStateStore] while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.atlassian.stash.internal.plugin.DefaultPluginPersistentStateStore#380fe8c4' defined in class path resource [stash-context.xml]: Cannot resolve reference to bean 'pluginStateDao' while setting constructor argument; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'pluginStateDao' defined in URL [jar:file:/opt/atlassian-stash-2.7.1/atlassian-stash/WEB-INF/lib/stash-dao-impl-2.7.1.jar!/com/atlassian/stash/internal/plugin/HibernatePluginStateDao.class]: Unsatisfied dependency expressed through constructor argument with index 0 of type [org.hibernate.SessionFactory]: : Error creating bean with name 'liquibase' defined in class path resource [stash-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL UPDATE `stash`.`DATABASECHANGELOGLOCK` SET `LOCKED` = 1, `LOCKEDBY` = 'fe80:0:0:0:250:56ff:feaa:7715%3 (fe80:0:0:0:250:56ff:feaa:7715%3)', `LOCKGRANTED` = '2013-09-16 21:26:12.66' WHERE `ID` = 1 AND `LOCKED` = 0: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [stash-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL UPDATE `stash`.`DATABASECHANGELOGLOCK` SET `LOCKED` = 1, `LOCKEDBY` = 'fe80:0:0:0:250:56ff:feaa:7715%3 (fe80:0:0:0:250:56ff:feaa:7715%3)', `LOCKGRANTED` = '2013-09-16 21:26:12.66' WHERE `ID` = 1 AND `LOCKED` = 0: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'

at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:730) ~[spring-beans-3.2.3.RELEASE.jar:3.2.3.RELEASE]

at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:196) ~[spring-beans-3.2.3.RELEASE.jar:3.2.3.RELEASE]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1045) ~[spring-beans-3.2.3.RELEASE.jar:3.2.3.RELEASE]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:949) ~[spring-beans-3.2.3.RELEASE.jar:3.2.3.RELEASE]

1 answer

For anyone watching this question, the solution was related to MySQL and Stash changing the default transaction level to read-commited which doesn't work with binary logging.

From Ken's support ticket we have updated our documentation to hopefully avoid this happening for other customers:

https://confluence.atlassian.com/display/STASH/Stash+2.7+release+notes

And:

https://confluence.atlassian.com/display/STASH/Connecting+Stash+to+MySQL

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Piotr Plewa
Published Dec 27, 2017 in Bitbucket

Recipe: Deploying AWS Lambda functions with Bitbucket Pipelines

Bitbucket Pipelines helps me manage and automate a number of serverless deployments to AWS Lambda and this is how I do it. I'm building Node.js Lambda functions using node-lambda&nbsp...

1,742 views 1 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you