Caused by: com.atlassian.user.EntityException: Couldn't check whether user already exists
at com.atlassian.user.impl.delegation.DelegatingUserManager.createUser(DelegatingUserManager.java:148)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.atlassian.crowd.integration.atlassianuser.DynamicDelegationAccessor$DelegatingInvocationHandler.invoke(DynamicDelegationAccessor.java:125)
at com.sun.proxy.$Proxy37.createUser(Unknown Source)
at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:96)
... 166 more
Caused by: com.atlassian.user.impl.RepositoryException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select defaulthib0_.id as id9_, defaulthib0_.name as name9_, defaulthib0_.password as password9_, defaulthib0_.email as email9_, defaulthib0_.created as created9_, defaulthib0_.fullname as fullname9_ from users defaulthib0_ where defaulthib0_.name=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at com.atlassian.user.impl.hibernate3.HibernateUserManager.internalGetUser(HibernateUserManager.java:213)
at com.atlassian.user.impl.hibernate3.HibernateUserManager.getUser(HibernateUserManager.java:73)
at com.atlassian.user.impl.cache.CachingUserManager.getUser(CachingUserManager.java:73)
at com.atlassian.user.impl.delegation.DelegatingUserManager.getUser(DelegatingUserManager.java:70)
at com.atlassian.user.impl.delegation.DelegatingUserManager.createUser(DelegatingUserManager.java:144)
... 173 more
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select defaulthib0_.id as id9_, defaulthib0_.name as name9_, defaulthib0_.password as password9_, defaulthib0_.email as email9_, defaulthib0_.created as created9_, defaulthib0_.fullname as fullname9_ from users defaulthib0_ where defaulthib0_.name=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:642)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:414)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:416)
at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:348)
at com.atlassian.user.impl.hibernate3.HibernateUserManager.internalGetUser(HibernateUserManager.java:199)
... 177 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2319)
at org.hibernate.loader.Loader.list(Loader.java:2268)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at com.atlassian.user.impl.hibernate3.HibernateUserManager$1.doInHibernate(HibernateUserManager.java:207)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
... 179 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "users" does not exist
Position: 206
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 188 more
Looks like your database is damaged or was configured incorrectly. I cant tell you a lot more than that without knowing what prompts the error and what you're trying to do.
It was confusing for me as well so I checked everything double but found nothing to fix. I did clean up the home folder after stopping bamboo, then restarted it and it succeeded to finish the installation&Setup. hope it helps someone else.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.