Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Unable to configure mysql with bamboo

I tried installing Bamboo server 7.2.3 march build on a ubuntu machine which has mysql 5.7.33 version running on it. I've followed getting started instruction to enable custom installation of Bamboo server with external database.

Steps I've followed,

- created a database named -bamboo under mysql

- created and provided privileges to username bamboouser

- Added mysql connector jar file (mysql-connector-java-5.1.4 to the bamboo installation directory to support mysql jdbc

 

The installation hung at this stage (waited for  hrs to see if it progress) and nothing worked. Please provide the fix/workaround.

 

copying the logs for reference:-

2021-03-31 23:41:42,069 INFO [performSetupDatabaseConnectionBackgroundThread] [DefaultHibernateConfigurator] Bamboo schema created.
2021-03-31 23:41:42,074 INFO [performSetupDatabaseConnectionBackgroundThread] [DefaultBootstrapManager] Running validation tasks
2021-03-31 23:41:42,159 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ----------------------------------------------------------------------
2021-03-31 23:41:42,159 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 1 : Assert that Bamboo isn't running on HSQL database (post-bootstrap)
2021-03-31 23:41:42,159 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ----------------------------------------------------------------------
2021-03-31 23:41:42,163 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 1 completed successfully.
2021-03-31 23:41:42,172 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -------------------------------------------------------------------
2021-03-31 23:41:42,172 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 2 : Validate that JDBC driver is available in classpath (bootstrap)
2021-03-31 23:41:42,172 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -------------------------------------------------------------------
2021-03-31 23:41:42,173 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 2 completed successfully.
2021-03-31 23:41:42,178 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------------------------
2021-03-31 23:41:42,178 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 3 : Validate if build number in home directory matches database (bootstrap)
2021-03-31 23:41:42,178 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------------------------
2021-03-31 23:41:42,178 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 3 completed successfully.
2021-03-31 23:41:42,181 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -----------------------------------------
2021-03-31 23:41:42,181 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 4 : Verify Java compatibility (bootstrap)
2021-03-31 23:41:42,181 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -----------------------------------------
2021-03-31 23:41:42,181 INFO [performSetupDatabaseConnectionBackgroundThread] [JavaVersionIsSupported] Testing compatibility of Java version 1.8.0_282 with this version of Bamboo.
2021-03-31 23:41:42,182 INFO [performSetupDatabaseConnectionBackgroundThread] [JavaVersionIsSupported] Detected Java version 1.8.0_282, your version is supported.
2021-03-31 23:41:42,182 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 4 completed successfully.
2021-03-31 23:41:42,186 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -----------------------------------------------------------------
2021-03-31 23:41:42,186 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 2901 : Test if build number is applicable for upgrade (bootstrap)
2021-03-31 23:41:42,186 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -----------------------------------------------------------------
2021-03-31 23:41:42,186 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 2901 completed successfully.
2021-03-31 23:41:42,190 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ------------------------------------------------------------
2021-03-31 23:41:42,190 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 2902 : Test if plan keys are correctly formatted (bootstrap)
2021-03-31 23:41:42,190 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ------------------------------------------------------------
2021-03-31 23:41:42,196 INFO [performSetupDatabaseConnectionBackgroundThread] [HikariDataSource] HikariPool-2 - Started.
2021-03-31 23:41:42,200 INFO [performSetupDatabaseConnectionBackgroundThread] [PoolBase] HikariPool-2 - Driver does not support get/set network timeout for connections. (com.mysql.jdbc.JDBC4Conne
ction.getNetworkTimeout()I)
2021-03-31 23:41:42,214 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 2902 completed successfully.
2021-03-31 23:41:42,222 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -----------------------------------------------------------------------------
2021-03-31 23:41:42,222 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 4300 : Make sure there's single row in HIBERNATE_UNIQUE_KEY table (bootstrap)
2021-03-31 23:41:42,222 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -----------------------------------------------------------------------------
2021-03-31 23:41:42,224 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 4300 completed successfully.
2021-03-31 23:41:42,240 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -------------------------------------------------------------------------------------
2021-03-31 23:41:42,241 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 4410 : Make sure that all branch keys start with their master's chain key (bootstrap)
2021-03-31 23:41:42,241 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -------------------------------------------------------------------------------------
2021-03-31 23:41:42,242 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 4410 completed successfully.
2021-03-31 23:41:42,247 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------
2021-03-31 23:41:42,247 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 51010 : Check if lucene index root dir exists (bootstrap)
2021-03-31 23:41:42,247 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------
2021-03-31 23:41:42,247 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 51010 completed successfully.
2021-03-31 23:41:42,252 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -----------------------------------------------------------------------------
2021-03-31 23:41:42,252 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 51012 : Make sure that MySQL server uses InnoDB engine for tables (bootstrap)
2021-03-31 23:41:42,252 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -----------------------------------------------------------------------------
2021-03-31 23:41:42,270 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 51012 completed successfully.
2021-03-31 23:41:42,275 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] --------------------------------------------------------------------------
2021-03-31 23:41:42,275 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 51102 : Make sure server key has been initialized and is valid (bootstrap)
2021-03-31 23:41:42,275 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] --------------------------------------------------------------------------
2021-03-31 23:41:42,276 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 51102 completed successfully.
2021-03-31 23:41:42,281 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -------------------------------------------
2021-03-31 23:41:42,281 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 51111 : Verify DB compatibility (bootstrap)
2021-03-31 23:41:42,281 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -------------------------------------------
2021-03-31 23:41:42,281 INFO [performSetupDatabaseConnectionBackgroundThread] [DatabaseIsSupported] Testing compatibility of [MySQL] 5.7.33 (5.7.33) using JDBC driver [MySQL-AB JDBC Driver] 5.1.0
(mysql-connector-java-5.1.4 ( Revision: ${svn.Revision} )) with this version of Bamboo.
2021-03-31 23:41:42,281 INFO [performSetupDatabaseConnectionBackgroundThread] [DatabaseIsSupported] Detected MYSQL version [MySQL] 5.7.33 (5.7.33), your DBMS version is supported.
2021-03-31 23:41:42,282 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 51111 completed successfully.
2021-03-31 23:41:42,286 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------
2021-03-31 23:41:42,286 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 51210 : Verify file name encoding (bootstrap)
2021-03-31 23:41:42,286 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------
2021-03-31 23:41:42,286 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 51210 completed successfully.
2021-03-31 23:41:42,291 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------------------------
2021-03-31 23:41:42,291 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 51301 : Test if collation and commit isolation is set correctly (bootstrap)
2021-03-31 23:41:42,291 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------------------------
2021-03-31 23:41:42,291 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 51301 completed successfully.
2021-03-31 23:41:42,296 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ----------------------------------------------------------------
2021-03-31 23:41:42,296 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 51302 : Check that MySQL tables are case insensitive (bootstrap)
2021-03-31 23:41:42,296 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ----------------------------------------------------------------
2021-03-31 23:41:42,297 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 51302 completed successfully.
2021-03-31 23:41:42,301 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------------------------------------
2021-03-31 23:41:42,301 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 51404 : Make sure OSGi bundle cache directory is empty, clean it if needed. (bootstrap)
2021-03-31 23:41:42,301 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------------------------------------
2021-03-31 23:41:42,302 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 51404 completed successfully.
2021-03-31 23:41:42,307 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -------------------------------------------------------------------
2021-03-31 23:41:42,307 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 60001 : Make sure JNDI location of mail server is valid (bootstrap)
2021-03-31 23:41:42,307 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -------------------------------------------------------------------
2021-03-31 23:41:42,307 INFO [performSetupDatabaseConnectionBackgroundThread] [MailServerJndiLocationIsValid] Validating JNDI location of mail server in configuration file '/var/bamboo/bamboo-hom
e/bamboo-mail.cfg.xml'.
2021-03-31 23:41:42,362 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 60001 completed successfully.
2021-03-31 23:41:42,372 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------------------------------------
------
2021-03-31 23:41:42,372 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 60601 : Validate existing Atlassian User directories for Embedded Crowd migration (boot
strap)
2021-03-31 23:41:42,372 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------------------------------------
------
2021-04-01 07:20:51,141 ERROR [http-nio-8085-exec-15] [ExceptionMappingInterceptor] Method "execute" failed for object com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction@2f767e5
c
ognl.MethodFailedException: Method "execute" failed for object com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction@2f767e5c [java.lang.AbstractMethodError: com.mysql.jdbc.JDBC4Co
nnection.getSchema()Ljava/lang/String;]
       at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1981)
       at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
       at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:98)
       at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:90)
       at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:2045)
       at ognl.ASTMethod.getValueBody(ASTMethod.java:97)
       at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
       at ognl.SimpleNode.getValue(SimpleNode.java:258)
       at ognl.Ognl.getValue(Ognl.java:537)
       at ognl.Ognl.getValue(Ognl.java:501)
       at com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:492)
       at com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:544)
       at com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:490)
       at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:438)
       at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:293)
       at org.apache.struts2.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:55)
       at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.AbstractMethodError: com.mysql.jdbc.JDBC4Connection.getSchema()Ljava/lang/String;
       at com.zaxxer.hikari.pool.HikariProxyConnection.getSchema(HikariProxyConnection.java)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchemaUncached(AbstractDbmsBean.java:436)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchema(AbstractDbmsBean.java:428)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.isTablePresent(AbstractDbmsBean.java:253)
       at com.atlassian.bamboo.upgrade.tasks.validation.EmbeddedCrowdUpgradeBootstrapValidation.isPostEmbeddedCrowdUpgrade(EmbeddedCrowdUpgradeBootstrapValidation.java:25)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.lambda$doUpgrade$0(AtlassianUserRepositoriesAreValid.java:39)
       at com.atlassian.bamboo.upgrade.AbstractBootstrapUpgradeTask.withDatabaseConnection(AbstractBootstrapUpgradeTask.java:65)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.doUpgrade(AtlassianUserRepositoriesAreValid.java:38)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.doUpgrade(AtlassianUserRepositoriesAreValid.java:33)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.runValidationTask(BootstrapUpgradeManagerImpl.java:134)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.lambda$runValidationTasks$0(BootstrapUpgradeManagerImpl.java:93)
       at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.forEachTask(AbstractUpgradeManager.java:147)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.runValidationTasks(BootstrapUpgradeManagerImpl.java:93)
       at com.atlassian.bamboo.setup.DefaultBootstrapManager.runValidationTasks(DefaultBootstrapManager.java:392)
       at com.atlassian.bamboo.setup.DefaultBootstrapManager.postBootstrapDatabase(DefaultBootstrapManager.java:321)
       at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.bootstrapDatabase(DefaultAtlassianBootstrapManager.java:289)
       at com.atlassian.bamboo.ww2.actions.setup.SetupUtilityBean.setupStandardDatabase(SetupUtilityBean.java:187)
       at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.execute(SetupDatabaseConnectionAction.java:87)
       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:498)
       at ognl.OgnlRuntime.invokeMethodInsideSandbox(OgnlRuntime.java:1266)
       at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:1251)
       at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1969)
       ... 16 more
/-- Encapsulated exception ------------\
java.lang.AbstractMethodError: com.mysql.jdbc.JDBC4Connection.getSchema()Ljava/lang/String;
       at com.zaxxer.hikari.pool.HikariProxyConnection.getSchema(HikariProxyConnection.java)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchemaUncached(AbstractDbmsBean.java:436)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchema(AbstractDbmsBean.java:428)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.isTablePresent(AbstractDbmsBean.java:253)
       at com.atlassian.bamboo.upgrade.tasks.validation.EmbeddedCrowdUpgradeBootstrapValidation.isPostEmbeddedCrowdUpgrade(EmbeddedCrowdUpgradeBootstrapValidation.java:25)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.lambda$doUpgrade$0(AtlassianUserRepositoriesAreValid.java:39)
       at com.atlassian.bamboo.upgrade.AbstractBootstrapUpgradeTask.withDatabaseConnection(AbstractBootstrapUpgradeTask.java:65)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.doUpgrade(AtlassianUserRepositoriesAreValid.java:38)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.doUpgrade(AtlassianUserRepositoriesAreValid.java:33)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.runValidationTask(BootstrapUpgradeManagerImpl.java:134)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.lambda$runValidationTasks$0(BootstrapUpgradeManagerImpl.java:93)
       at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.forEachTask(AbstractUpgradeManager.java:147)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.runValidationTasks(BootstrapUpgradeManagerImpl.java:93)
       at com.atlassian.bamboo.setup.DefaultBootstrapManager.runValidationTasks(DefaultBootstrapManager.java:392)
       at com.atlassian.bamboo.setup.DefaultBootstrapManager.postBootstrapDatabase(DefaultBootstrapManager.java:321)
       at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.bootstrapDatabase(DefaultAtlassianBootstrapManager.java:289)
       at com.atlassian.bamboo.ww2.actions.setup.SetupUtilityBean.setupStandardDatabase(SetupUtilityBean.java:187)
       at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.execute(SetupDatabaseConnectionAction.java:87)
       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:498)
       at ognl.OgnlRuntime.invokeMethodInsideSandbox(OgnlRuntime.java:1266)
       at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:1251)
       at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1969)
       at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
       at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:98)
       at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:90)
       at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:2045)
       at ognl.ASTMethod.getValueBody(ASTMethod.java:97)
       at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
       at ognl.SimpleNode.getValue(SimpleNode.java:258)
       at ognl.Ognl.getValue(Ognl.java:537)
       at ognl.Ognl.getValue(Ognl.java:501)
       at com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:492)
       at com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:544)
       at com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:490)
       at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:438)
       at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:293)
       at org.apache.struts2.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:55)
       at java.lang.Thread.run(Thread.java:748)
\--------------------------------------/
2021-04-01 07:20:51,247 ERROR [http-nio-8085-exec-15] [FiveOhOh] 500 Exception was thrown.
ognl.MethodFailedException: Method "execute" failed for object com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction@2f767e5c [java.lang.AbstractMethodError: com.mysql.jdbc.JDBC4Co
nnection.getSchema()Ljava/lang/String;]
       at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1981)
       at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
       at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:98)
       at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:90)
       at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:2045)
       at ognl.ASTMethod.getValueBody(ASTMethod.java:97)
       at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
       at ognl.SimpleNode.getValue(SimpleNode.java:258)
       at ognl.Ognl.getValue(Ognl.java:537)
       at ognl.Ognl.getValue(Ognl.java:501)
       at com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:492)
       at com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:544)
       at com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:490)
       at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:438)
       at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:293)
       at org.apache.struts2.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:55)
       at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.AbstractMethodError: com.mysql.jdbc.JDBC4Connection.getSchema()Ljava/lang/String;
       at com.zaxxer.hikari.pool.HikariProxyConnection.getSchema(HikariProxyConnection.java)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchemaUncached(AbstractDbmsBean.java:436)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchema(AbstractDbmsBean.java:428)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.isTablePresent(AbstractDbmsBean.java:253)
       at com.atlassian.bamboo.upgrade.tasks.validation.EmbeddedCrowdUpgradeBootstrapValidation.isPostEmbeddedCrowdUpgrade(EmbeddedCrowdUpgradeBootstrapValidation.java:25)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.lambda$doUpgrade$0(AtlassianUserRepositoriesAreValid.java:39)
       at com.atlassian.bamboo.upgrade.AbstractBootstrapUpgradeTask.withDatabaseConnection(AbstractBootstrapUpgradeTask.java:65)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.doUpgrade(AtlassianUserRepositoriesAreValid.java:38)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.doUpgrade(AtlassianUserRepositoriesAreValid.java:33)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.runValidationTask(BootstrapUpgradeManagerImpl.java:134)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.lambda$runValidationTasks$0(BootstrapUpgradeManagerImpl.java:93)
       at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.forEachTask(AbstractUpgradeManager.java:147)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.runValidationTasks(BootstrapUpgradeManagerImpl.java:93)
       at com.atlassian.bamboo.setup.DefaultBootstrapManager.runValidationTasks(DefaultBootstrapManager.java:392)
       at com.atlassian.bamboo.setup.DefaultBootstrapManager.postBootstrapDatabase(DefaultBootstrapManager.java:321)
       at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.bootstrapDatabase(DefaultAtlassianBootstrapManager.java:289)
       at com.atlassian.bamboo.ww2.actions.setup.SetupUtilityBean.setupStandardDatabase(SetupUtilityBean.java:187)
       at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.execute(SetupDatabaseConnectionAction.java:87)
       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:498)
       at ognl.OgnlRuntime.invokeMethodInsideSandbox(OgnlRuntime.java:1266)
       at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:1251)
       at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1969)
       ... 16 more
/-- Encapsulated exception ------------\
java.lang.AbstractMethodError: com.mysql.jdbc.JDBC4Connection.getSchema()Ljava/lang/String;
       at com.zaxxer.hikari.pool.HikariProxyConnection.getSchema(HikariProxyConnection.java)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchemaUncached(AbstractDbmsBean.java:436)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchema(AbstractDbmsBean.java:428)
       at com.atlassian.bamboo.utils.db.AbstractDbmsBean.isTablePresent(AbstractDbmsBean.java:253)
       at com.atlassian.bamboo.upgrade.tasks.validation.EmbeddedCrowdUpgradeBootstrapValidation.isPostEmbeddedCrowdUpgrade(EmbeddedCrowdUpgradeBootstrapValidation.java:25)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.lambda$doUpgrade$0(AtlassianUserRepositoriesAreValid.java:39)
       at com.atlassian.bamboo.upgrade.AbstractBootstrapUpgradeTask.withDatabaseConnection(AbstractBootstrapUpgradeTask.java:65)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.doUpgrade(AtlassianUserRepositoriesAreValid.java:38)
       at com.atlassian.bamboo.upgrade.tasks.validation.AtlassianUserRepositoriesAreValid.doUpgrade(AtlassianUserRepositoriesAreValid.java:33)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.runValidationTask(BootstrapUpgradeManagerImpl.java:134)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.lambda$runValidationTasks$0(BootstrapUpgradeManagerImpl.java:93)
       at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.forEachTask(AbstractUpgradeManager.java:147)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.runValidationTasks(BootstrapUpgradeManagerImpl.java:93)
       at com.atlassian.bamboo.setup.DefaultBootstrapManager.runValidationTasks(DefaultBootstrapManager.java:392)
       at com.atlassian.bamboo.setup.DefaultBootstrapManager.postBootstrapDatabase(DefaultBootstrapManager.java:321)
       at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.bootstrapDatabase(DefaultAtlassianBootstrapManager.java:289)
       at com.atlassian.bamboo.ww2.actions.setup.SetupUtilityBean.setupStandardDatabase(SetupUtilityBean.java:187)
       at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.execute(SetupDatabaseConnectionAction.java:87)
       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:498)
       at ognl.OgnlRuntime.invokeMethodInsideSandbox(OgnlRuntime.java:1266)
       at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:1251)
       at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1969)
       at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
       at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:98)
       at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:90)
       at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:2045)
       at ognl.ASTMethod.getValueBody(ASTMethod.java:97)
       at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
       at ognl.SimpleNode.getValue(SimpleNode.java:258)
       at ognl.Ognl.getValue(Ognl.java:537)
       at ognl.Ognl.getValue(Ognl.java:501)
       at com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:492)
       at com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:544)
       at com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:490

 

1 answer

@IT Support 

 

This might be related to the Java version you use. Which JDK/JRE are you using?

Cheers

Kurt

Hi Kurt,

I've followed the software requirements from the below link which didn't help in solving the issue with mysql.

https://confluence.atlassian.com/bamboo/supported-platforms-289276764.html

 

I've switched to use POSTGRESQL as external database option which helped in a successful installation of Bamboo.

@IT Support 

 

Glad to hear that switching to postgres did solve that problem, although we do not know what caused the mysql issue

 

Cheers

Kurt

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Bamboo

Bamboo Data Center 8.1 is now available

G’day Bamboo customers, Bamboo DC 8.1 is now available with it the following features and programs: SAML 2.0, OpenID Connect, and Crowd SSO In order to help admins with a simplified user manage...

154 views 0 4
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you