Confluence can't connect with postgresql database

[mkrupniewski-blueowl]

I install Confluence according to the instructions using Nginx and proxy, I have an empty postgresql database. During installation, when selecting a database, I enter the database data, click test and everything is ok. However, when I click Next button, so that the application connects to this database, for about 2-3 minutes the page tries to reload and then pops up 504 Timeout Gateway error. At the same time CPU consumption reaches 100%, then I have to reset the VPS server.
I have no idea where the error is: have I configured something wrong somewhere? Is there something wrong with the database? or maybe the server does not withstand (1CPU, 2gb RAM)?

[mkrupniewski-blueowl · Accepted solution]

Mayby 1CPU and 2GB RAM not enough? I found this -> https://confluence.atlassian.com/doc/server-hardware-requirements-guide-30736403.html and server should have at least 6gb ram,...?

[Edwin Kyalangalilwa]

Hi @mkrupniewski-blueowl ,

Please check for any errors in the Confluence log file. Which is found under:

<confluence-home>/logs/atlassian-confluence.log

[mkrupniewski-blueowl]

there is no such file in this folder

[Edwin Kyalangalilwa]

Ok, check under:

<confluence-install>/logs/

This will give us a definitive error. If it's memory or something else.

[mkrupniewski-blueowl]

same - no such file

[mkrupniewski-blueowl]

OK, I found this file and here is log during connecting with DB:

2019-11-21 18:58:41,915 INFO [http-nio-8090-exec-9] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2019-11-21 18:58:49,396 INFO [http-nio-8090-exec-9] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2019-11-21 18:59:20,268 INFO [http-nio-8090-exec-9] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext initialized in 38351 ms
2019-11-21 18:59:20,324 INFO [http-nio-8090-exec-9] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$5 Preparing to shut down the plugin system
2019-11-21 18:59:20,332 INFO [http-nio-8090-exec-9] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$5 Shutting down the plugin system
2019-11-21 18:59:20,543 WARN [FelixStartLevel] [plugin.osgi.factory.OsgiBundlePlugin] disableInternal Cannot disable Bundle 'com.atlassian.platform.spring-velocity-support-0.0.7', not ACTIVE
2019-11-21 18:59:20,615 INFO [http-nio-8090-exec-9] [atlassian.plugin.manager.DefaultPluginManager] lambda$earlyStartup$3 Plugin system earlyStartup begun
2019-11-21 18:59:22,898 WARN [http-nio-8090-exec-9] [org.twdata.pkgscanner.ExportPackageListBuilder] logDuplicateWarning Package Scanner found duplicates for package 'com.atlassian.integration.jira.applinks' with different versions. Files: confluence-7.1.0.jar and jira-integration-spi-6.2.0.jar
'/var/www/atlassian/confluence/confluence/WEB-INF/lib/confluence-7.1.0.jar'
'/var/www/atlassian/confluence/confluence/WEB-INF/lib/jira-integration-spi-6.2.0.jar'
-- referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 18:59:25,647 WARN [FelixStartLevel] [extender.internal.support.ExtenderConfiguration] addDefaultDependencyFactories Gemini Blueprint extensions bundle not present, annotation processing disabled.
-- referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 19:00:38,646 INFO [http-nio-8090-exec-9] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
2019-11-21 19:00:40,752 WARN [Navlink Plugin Executor:thread-1] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupdbtype.action | referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 19:00:50,611 WARN [Navlink Plugin Executor:thread-1] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupdbtype.action | referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 19:01:00,612 WARN [Navlink Plugin Executor:thread-2] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupdbtype.action | referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 19:01:10,683 WARN [Navlink Plugin Executor:thread-1] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupdbtype.action | referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 19:01:20,523 INFO [http-nio-8090-exec-5] [atlassian.plugin.manager.DefaultPluginManager] lambda$lateStartup$4 Plugin system lateStartup begun
2019-11-21 19:10:06,892 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 7.1.0 [build 8301 based on commit hash 8fa50d05398fea29bc3b44b63cde07d279fbe836] - synchrony version 3.1.0-master-0f086db5

[mkrupniewski-blueowl]

OK, I found this file and paste log during connecting with DB:

2019-11-21 18:58:41,915 INFO [http-nio-8090-exec-9] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2019-11-21 18:58:49,396 INFO [http-nio-8090-exec-9] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2019-11-21 18:59:20,268 INFO [http-nio-8090-exec-9] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext initialized in 38351 ms
2019-11-21 18:59:20,324 INFO [http-nio-8090-exec-9] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$5 Preparing to shut down the plugin system
2019-11-21 18:59:20,332 INFO [http-nio-8090-exec-9] [atlassian.plugin.manager.DefaultPluginManager] lambda$shutdown$5 Shutting down the plugin system
2019-11-21 18:59:20,543 WARN [FelixStartLevel] [plugin.osgi.factory.OsgiBundlePlugin] disableInternal Cannot disable Bundle 'com.atlassian.platform.spring-velocity-support-0.0.7', not ACTIVE
2019-11-21 18:59:20,615 INFO [http-nio-8090-exec-9] [atlassian.plugin.manager.DefaultPluginManager] lambda$earlyStartup$3 Plugin system earlyStartup begun
2019-11-21 18:59:22,898 WARN [http-nio-8090-exec-9] [org.twdata.pkgscanner.ExportPackageListBuilder] logDuplicateWarning Package Scanner found duplicates for package 'com.atlassian.integration.jira.applinks' with different versions. Files: confluence-7.1.0.jar and jira-integration-spi-6.2.0.jar
'/var/www/atlassian/confluence/confluence/WEB-INF/lib/confluence-7.1.0.jar'
'/var/www/atlassian/confluence/confluence/WEB-INF/lib/jira-integration-spi-6.2.0.jar'
-- referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 18:59:25,647 WARN [FelixStartLevel] [extender.internal.support.ExtenderConfiguration] addDefaultDependencyFactories Gemini Blueprint extensions bundle not present, annotation processing disabled.
-- referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 19:00:38,646 INFO [http-nio-8090-exec-9] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
2019-11-21 19:00:40,752 WARN [Navlink Plugin Executor:thread-1] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupdbtype.action | referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 19:00:50,611 WARN [Navlink Plugin Executor:thread-1] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupdbtype.action | referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 19:01:00,612 WARN [Navlink Plugin Executor:thread-2] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupdbtype.action | referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 19:01:10,683 WARN [Navlink Plugin Executor:thread-1] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupdbtype.action | referer: https://confluence.tocstrategy.com/setup/setupdbtype-start.action | traceId: 00116cf00abde52d | userName: anonymous | action: setupdbtype
2019-11-21 19:01:20,523 INFO [http-nio-8090-exec-5] [atlassian.plugin.manager.DefaultPluginManager] lambda$lateStartup$4 Plugin system lateStartup begun

[mkrupniewski-blueowl]

OK, I found this log, but not errors here