Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Unable to configure mysql with bamboo

IT Support March 31, 2021

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

0 votes
Kurt Klinner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 1, 2021

@IT Support 

 

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

Cheers

Kurt

IT Support April 14, 2021

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.

Kurt Klinner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 16, 2021

@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
AUG Leaders

Atlassian Community Events