Install baulked by db setup

[Malcolm B I_Anson]

Bamboo installation stops at “Please wait while Bamboo sets up your database”. JAVA_HOME is configured to  jdk1.8.0_251 and database login details are correct.  Ran this command wmic path win32_process where Name='java.exe' get ProcessId,Caption,Commandline | findstr /i bamboo and confirmed only one process of Bamboo is running. Please advise us how to troubleshoot the problem. Even restarting Bamboo does not help.

[Nic Brough -Adaptavist-]

Do you have an error message?  "Baulked" suggests it's just sitting there, but we can't be sure from that, can you describe what you see in the browser?

More importantly, can you look at the log to see what that is saying?

[Malcolm B I_Anson]

Yes, you've got what I meant:  "baulked" in that there is no response.  It's just waiting for hours at “Please wait while Bamboo sets up your database".  The logs are too long to insert here.  Can I send them to you somehow?  I note one entry which may be of interest:  The web application [ROOT] registered the JDBC driver [org.h2.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

[Jeyanthan I]

Hi @Malcolm B I_Anson ,

Are you doing a fresh install? If so, kill the current process and try to install it with a supported database like PostgreSQL or MySQL and check what happens. The last few lines of <bamboo-home>/logs/atlassian-bamboo.log may reveal the progress on what is going on in the background.  I'm afraid we couldn't conclude anything with the limited information you have provided.

Also, from the message, I see that you are using the default H2 database. H2 is a flat-file database and is not transaction safe and thus you may run into the risk of irrecoverable data loss mainly during system crashes.  It is not recommended for production environments.

If you are evaluating Bamboo (with an evaluation license), please feel free to contact us via support.atlassian.com.

Cheers,
Jey

[Malcolm B I_Anson]

Thank you for your quick responses!

It is a fresh install.

I tried both Microsoft SQL Server and PostgreSQL. It is a fresh install.

We are not using a flat database.  That was only to test to see if it is database-related issue. In any case, same problem occurred.

[Malcolm B I_Anson]

I should add that this is not just an evaluation.

[Jeyanthan I]

Thanks for clarifying. Please share the last  100ines of atlassian-bamboo.log when you reach this point when you see it spinning forever. We'll got to know more on what's going on.

[Malcolm B I_Anson]

Thanks for asking!  Here you go: 

2020-06-11 15:44:10,601 INFO [performSetupDatabaseConnectionBackgroundThread] [SetupDatabaseConnectionAction] Validating connection to url: [jdbc:sqlserver://localhost:1433;databaseName=bamboo]

2020-06-11 15:44:10,960 INFO [performSetupDatabaseConnectionBackgroundThread] [SetupDatabaseConnectionAction] Database configuration is valid.

2020-06-11 15:44:10,960 INFO [performSetupDatabaseConnectionBackgroundThread] [SetupUtilityBean] Setting up database: mssql

2020-06-11 15:44:10,960 INFO [performSetupDatabaseConnectionBackgroundThread] [SetupUtilityBean] Bootstrapping database: mssql

2020-06-11 15:44:10,960 INFO [performSetupDatabaseConnectionBackgroundThread] [DefaultHibernateConfigurator] Saving bootstrap configuration...

2020-06-11 15:44:10,976 INFO [performSetupDatabaseConnectionBackgroundThread] [DefaultHibernateConfigurator] Refreshing Spring context...

2020-06-11 15:44:11,507 WARN [performSetupDatabaseConnectionBackgroundThread] [GenericTypeAwarePropertyDescriptor] Invalid JavaBean property 'mappingResources' being accessed! Ambiguous write methods found next to actually used [public void bucket.core.persistence.hibernate.ConfigurableLocalSessionFactoryBean.setMappingResources(bucket.core.persistence.hibernate.MappingResources)]: [public void org.springframework.orm.hibernate5.LocalSessionFactoryBean.setMappingResources(java.lang.String[])]

2020-06-11 15:44:12,023 INFO [performSetupDatabaseConnectionBackgroundThread] [AbstractPoolBackedDataSource] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@2925ae14 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@c8d2cab2 [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, identityToken -> 1hge15gaa191gnqnpkrsyc|2e018648, idleConnectionTestPeriod -> 30, initialPoolSize -> 3, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 120, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@e2441e71 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> 1hge15gaa191gnqnpkrsyc|40659e6f, jdbcUrl -> jdbc:sqlserver://localhost:1433;databaseName=bamboo, properties -> {handling_mode=DELAYED_ACQUISITION_AND_HOLD, user=******, password=******} ], preferredTestQuery -> null, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> 1hge15gaa191gnqnpkrsyc|13f81f7b, numHelperThreads -> 3 ]

2020-06-11 15:44:12,085 INFO [performSetupDatabaseConnectionBackgroundThread] [ResettableTableHiLoGenerator] Registering exportables...

2020-06-11 15:44:12,085 INFO [performSetupDatabaseConnectionBackgroundThread] [ResettableTableHiLoGenerator] Generator table: org.hibernate.mapping.Table(hibernate_unique_key)

2020-06-11 15:44:12,241 ERROR [performSetupDatabaseConnectionBackgroundThread] [MetadataContext] HHH015007: Illegal argument on static metamodel field injection : com.atlassian.bamboo.resultsummary.AbstractResultsSummary_#testClassResults; expected type :  org.hibernate.metamodel.internal.PluralAttributeImpl$SetAttributeImpl; encountered type : javax.persistence.metamodel.ListAttribute

2020-06-11 15:44:12,241 ERROR [performSetupDatabaseConnectionBackgroundThread] [MetadataContext] HHH015007: Illegal argument on static metamodel field injection : com.atlassian.bamboo.agent.elastic.server.ElasticImageConfigurationImpl_#subnetIds; expected type :  org.hibernate.metamodel.internal.SingularAttributeImpl; encountered type : javax.persistence.metamodel.CollectionAttribute

2020-06-11 15:44:12,241 ERROR [performSetupDatabaseConnectionBackgroundThread] [MetadataContext] HHH015007: Illegal argument on static metamodel field injection : com.atlassian.bamboo.agent.elastic.server.ElasticImageConfigurationImpl_#availabilityZones; expected type :  org.hibernate.metamodel.internal.SingularAttributeImpl; encountered type : javax.persistence.metamodel.CollectionAttribute

2020-06-11 15:44:12,241 ERROR [performSetupDatabaseConnectionBackgroundThread] [MetadataContext] HHH015007: Illegal argument on static metamodel field injection : com.atlassian.bamboo.project.DefaultProject_#allPlans; expected type :  org.hibernate.metamodel.internal.PluralAttributeImpl$CollectionAttributeImpl; encountered type : javax.persistence.metamodel.ListAttribute

2020-06-11 15:44:12,273 ERROR [performSetupDatabaseConnectionBackgroundThread] [MetadataContext] HHH015007: Illegal argument on static metamodel field injection : com.atlassian.bamboo.commit.CommitImpl_#files; expected type :  org.hibernate.metamodel.internal.PluralAttributeImpl$SetAttributeImpl; encountered type : javax.persistence.metamodel.ListAttribute

2020-06-11 15:44:12,288 ERROR [performSetupDatabaseConnectionBackgroundThread] [MetadataContext] HHH015007: Illegal argument on static metamodel field injection : com.atlassian.bamboo.resultsummary.tests.TestClassImpl_#testCases; expected type :  org.hibernate.metamodel.internal.PluralAttributeImpl$SetAttributeImpl; encountered type : javax.persistence.metamodel.ListAttribute

2020-06-11 15:44:12,571 INFO [performSetupDatabaseConnectionBackgroundThread] [BrokerService] Using Persistence Adapter: KahaDBPersistenceAdapter[C:\Users\admin\bamboo-home\jms-store\bamboo\KahaDB]

2020-06-11 15:44:12,571 INFO [performSetupDatabaseConnectionBackgroundThread] [SharedFileLocker] Database C:\Users\admin\bamboo-home\jms-store\bamboo\KahaDB\lock is locked by another server. This broker is now in slave mode waiting a lock to be acquired

2020-06-11 15:44:13,101 WARN [http-nio-8085-exec-24] [TokenHelper] Could not find token mapped to token name: token

2020-06-11 15:44:15,242 ERROR [http-nio-8085-exec-25] [FiveOhOh] 500 Exception was thrown.

java.lang.IllegalStateException: No WebApplicationContext found: no ContextLoaderListener registered?

                at org.springframework.web.context.support.WebApplicationContextUtils.getRequiredWebApplicationContext(WebApplicationContextUtils.java:84)

                at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.lookupSessionFactory(OpenSessionInViewFilter.java:193)

                at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.lookupSessionFactory(OpenSessionInViewFilter.java:179)

                at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:130)

                at com.atlassian.bamboo.persistence.BambooSessionInViewFilter.doFilterInternal(BambooSessionInViewFilter.java:24)

                at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                at com.atlassian.bamboo.filter.BambooCompressingFilter.doFilter(BambooCompressingFilter.java:39)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                at com.atlassian.bamboo.filter.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:40)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                at com.atlassian.bamboo.filter.ClickjackingAndMimeTypeSniffingPreventionFilter.doFilter(ClickjackingAndMimeTypeSniffingPreventionFilter.java:36)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                at com.atlassian.bamboo.filter.CookieCacheControlFilter.doFilter(CookieCacheControlFilter.java:49)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:37)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:49)

                at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:43)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)

                at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

                at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

                at org.apache.catalina.valves.StuckThreadDetectionValve.invoke(StuckThreadDetectionValve.java:206)

                at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688)

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)

                at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:609)

                at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)

                at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)

                at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1623)

                at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

                at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

[Malcolm B I_Anson]

Can I provide any further information to assist with this troubleshooting? 

[Jeyanthan I]

Hey Malcom,

Yes, I may need more information from you. Please check your inbox. I just created an internal ticket to work with you on this.

Cheers,
Jey

[Malcolm B I_Anson]

Thanks for creating the ticket