First bamboo user not an admin

[Yassin]

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

[Nic Brough -Adaptavist- · Accepted solution]

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.

[Yassin]

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.