Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-13304

Display an error message in the UI if the database URL is incorrect

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • Installation
    • None
    • 0
    • 2
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      When installing Bamboo 4.4.5, using MySQL5.x, if the database URL is incorrect at the database configuration step, no error messages appear in the UI and the page just reloads. When looking at the logs, it has recorded details of what the problem is, but it won't be possible to know why we can't proceed with the step up process without knowing where the log file is located and looking at the information in there.

      The attached screenshot is the database configuration page after having and incorrect URl and clicking on the continue. Following is what appears in the log:

      2013-06-10 16:16:09,566 ERROR [performSetupDatabaseConnectionBackgroundThread] [SetupDatabaseConnectionAction] Unable to look up database: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
      com.atlassian.config.bootstrap.BootstrapException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
      	at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.getTestDatabaseConnection(DefaultAtlassianBootstrapManager.java:358)
      	at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.validateDatabase(SetupDatabaseConnectionAction.java:100)
      	at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.execute(SetupDatabaseConnectionAction.java:45)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:601)
      	at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
      	at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
      	at com.opensymphony.webwork.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:35)
      	at java.lang.Thread.run(Thread.java:722)
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	at com.mysql.jdbc.Util.getInstance(Util.java:386)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
      	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2385)
      	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2306)
      	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
      	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
      	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
      	at java.sql.DriverManager.getConnection(DriverManager.java:579)
      	at java.sql.DriverManager.getConnection(DriverManager.java:221)
      	at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.getTestDatabaseConnection(DefaultAtlassianBootstrapManager.java:346)
      	... 10 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'bamboo'
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	at com.mysql.jdbc.Util.getInstance(Util.java:386)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)
      	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1709)
      	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)
      	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2483)
      	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2324)
      	... 23 more
      

      Attachments

        1. NotShowingUIError_1.PNG
          72 kB
          Sepideh Setayeshfar

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ssetayeshfar Sepideh Setayeshfar (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: