500 null on admin/server-settings

[mineyannik]

Hello,

i tried to move my bitbucket server instance to another server.

Now I have to change the base url, but when I try to access the server-settings page I receive a 500 error null.

I attached the error from the atlassian-bitbucket.log

Thank you!

2018-10-12 17:01:34,075 ERROR [http-nio-7990-exec-3] mineyannik @TBMMAYx1021x200x0 1edmvvg 37.201.4.107,0:0:0:0:0:0:0:1 "GET /admin/server-settings HTTP/1.0" c.a.s.i.w.HandlerExceptionResolverImpl null
java.lang.NumberFormatException: null
        at java.lang.Integer.parseInt(Integer.java:542)
        at java.lang.Integer.parseInt(Integer.java:615)
        at com.atlassian.bitbucket.internal.ssh.dao.SshConfigurationDaoImpl.get(SshConfigurationDaoImpl.java:60)
        at com.atlassian.bitbucket.internal.ssh.service.DefaultSshConfigurationService.loadConfiguration(DefaultSshConfigurationService.java:193)
        at com.atlassian.bitbucket.internal.ssh.service.DefaultSshConfigurationService.getConfiguration(DefaultSshConfigurationService.java:101)
        at com.atlassian.bitbucket.internal.ssh.fragments.SshConfigurationFormFragment.doView(SshConfigurationFormFragment.java:61)
        at com.atlassian.stash.internal.plugin.PluginFormFragmentsFactoryImpl$PluginFormFragmentsImpl.getViewHtml(PluginFormFragmentsFactoryImpl.java:102)
        at com.atlassian.stash.internal.web.admin.ServerSettingsController.showSettings(ServerSettingsController.java:46)
        at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
        at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
        at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
        at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
        at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
        at com.atlassian.stash.internal.spring.lifecycle.LifecycleJohnsonServletFilterModuleContainerFilter.doFilter(LifecycleJohnsonServletFilterModuleContainerFilter.java:42)
        at com.atlassian.stash.internal.spring.lifecycle.LifecycleJohnsonServletFilterModuleContainerFilter.doFilter(LifecycleJohnsonServletFilterModuleContainerFilter.java:42)
        at com.atlassian.stash.internal.spring.security.StashAuthenticationFilter.doFilter(StashAuthenticationFilter.java:85)
        at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doInsideSpringSecurityChain(BeforeLoginPluginAuthenticationFilter.java:112)
        at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doFilter(BeforeLoginPluginAuthenticationFilter.java:75)
        at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:94)
        at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:67)
        at com.atlassian.stash.internal.spring.lifecycle.LifecycleJohnsonServletFilterModuleContainerFilter.doFilter(LifecycleJohnsonServletFilterModuleContainerFilter.java:42)
        at com.atlassian.bitbucket.internal.scm.git.lfs.servlet.filter.GitLfsLockingFilter.doFilter(GitLfsLockingFilter.java:50)
        at com.atlassian.stash.internal.spring.lifecycle.LifecycleJohnsonServletFilterModuleContainerFilter.doFilter(LifecycleJohnsonServletFilterModuleContainerFilter.java:42)
        at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:94)
        at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:67)
        at com.atlassian.stash.internal.spring.lifecycle.LifecycleJohnsonServletFilterModuleContainerFilter.doFilter(LifecycleJohnsonServletFilterModuleContainerFilter.java:42)
        at com.atlassian.plugin.connect.plugin.auth.oauth2.DefaultSalAuthenticationFilter.doFilter(DefaultSalAuthenticationFilter.java:69)
        at com.atlassian.plugin.connect.plugin.auth.user.ThreeLeggedAuthFilter.doFilter(ThreeLeggedAuthFilter.java:109)
        at com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:32)
        at com.atlassian.analytics.client.filter.DefaultAnalyticsFilter.doFilter(DefaultAnalyticsFilter.java:38)
        at com.atlassian.analytics.client.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:39)
        at com.atlassian.bitbucket.internal.scm.git.lfs.servlet.filter.GitLfsLockingFilter.doFilter(GitLfsLockingFilter.java:50)
        at com.atlassian.stash.internal.spring.lifecycle.LifecycleJohnsonServletFilterModuleContainerFilter.doFilter(LifecycleJohnsonServletFilterModuleContainerFilter.java:42)
        at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doBeforeBeforeLoginFilters(BeforeLoginPluginAuthenticationFilter.java:90)
        at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doFilter(BeforeLoginPluginAuthenticationFilter.java:73)
        at com.atlassian.stash.internal.request.DefaultRequestManager.doAsRequest(DefaultRequestManager.java:90)
        at com.atlassian.stash.internal.hazelcast.ConfigurableWebFilter.doFilter(ConfigurableWebFilter.java:38)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.lang.Thread.run(Thread.java:748)
        ... 278 frames trimmed

[mineyannik · Accepted solution]

I solved the issue by myself.

In the original database there are these signs:

In my Database Backup were not such signs

"DELETE FROM plugin_setting WHERE key_name = "stash.ssh.settings";". After that I restarted the server and everything is working fine now.

[Dave Theodore [Coyote Creek Consulting]]

The error likely occurred prior to this point.  Can you shut down Bitbucket, remove or move all application logs and then start.  This will let you have a clear picture of what happened.  It seems to be something with your configuration file.  Did you set the Bitbucket home directory correctly?

[mineyannik]

Yes I set it correctly.

This is the content of the log file after startup:

2018-10-12 17:43:59,469 INFO  [spring-startup]  c.a.b.i.s.c.j.c.HealthCheckRunner New health check registered: AuthenticationCheck
2018-10-12 17:43:59,473 INFO  [spring-startup]  c.a.b.i.s.c.c.DefaultClusterJobManager Registering job for StartupChecksJob
2018-10-12 17:43:59,622 INFO  [spring-startup]  c.a.s.internal.scm.PluginScmService Bitbucket is using /usr/bin/git version 2.17.1
2018-10-12 17:43:59,656 INFO  [spring-startup]  c.a.s.i.hazelcast.HazelcastLifecycle Updating Hazelcast instance capabilities
2018-10-12 17:44:00,690 WARN  [UpmScheduler:thread-1]  com.atlassian.upm.pac.PacClientImpl Update check request may take longer because of the number of apps
2018-10-12 17:44:09,468 INFO  [Caesium-1-2]  c.a.b.i.s.c.j.c.HealthCheckRunner Running up to 3 search health checks
2018-10-12 17:44:09,477 INFO  [Caesium-1-3]  c.a.b.i.s.i.jobs.StartupChecksJob Attempting provisioning in startup job
2018-10-12 17:44:09,479 INFO  [Caesium-1-3]  c.a.b.i.s.i.jobs.StartupChecksJob Running startup jobs for search
2018-10-12 17:44:09,642 INFO  [I/O dispatcher 3]  c.a.b.s.s.t.DefaultElasticsearchConnectionTester Connected to Elasticsearch version 5.5.3
2018-10-12 17:44:09,701 INFO  [Caesium-1-2]  c.a.b.i.s.c.j.c.HealthCheckRunner Health checks will run again after PT5M

And this is the log file after I tried to open the server-settings.

http://paste.ubuntu.com/p/KJ2bkJCCzQ/

[Dave Theodore [Coyote Creek Consulting]]

Can you post your config file? This seems to be a, if not the problem:

2018-10-12 17:43:59,108 ERROR [spring-startup]  c.a.s.c.p.AbstractStringPluginSettings Could not parse map element: 'port7999'
Full list: 'port7999
access.keys.enabledtrue
enabledtrue'

[Dave Theodore [Coyote Creek Consulting]]

Please obfuscate the database password!

[mineyannik]

Do you mean the bitbucket.properties?

#>*******************************************************
#> Migrated to database at jdbc:mysql://localhost:3306/bitbucket?characterEncoding=utf8&useUnicode=true
#> Updated on 2018-05-10T10:57:57.052+02:00
#>*******************************************************
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/bitbucket?characterEncoding=utf8&useUnicode=true
jdbc.user=bitbucket
jdbc.password=mysecretpassword
server.secure=true
server.scheme=https
server.proxy-port=443
server.proxy-name=my-domain.com