Confluence 7.3.3 install is stuck on setting up database on postgres

[Johan]

hi,

I got the problem that Postgres setup of confluence is stuck when trying to install confluence on our vps.

It works fine until the db setup. There the connection test works fine, but when pressing coninue it starts hanging endlessly.

The postgres instance is running and after the db information is filled in, 60 tables get created in the database.

List of relations
Schema | Name | Type | Owner
--------+----------------------------+-------+------------
public | EVENTS | table | confluence
public | SECRETS | table | confluence
public | SNAPSHOTS | table | confluence
public | attachmentdata | table | confluence
public | audit_affected_object | table | confluence
public | audit_changed_value | table | confluence
public | auditrecord | table | confluence
public | bandana | table | confluence
public | bodycontent | table | confluence
public | clustersafety | table | confluence
public | confancestors | table | confluence
public | confversion | table | confluence
public | content | table | confluence
public | content_label | table | confluence
public | content_perm | table | confluence
public | content_perm_set | table | confluence
public | content_relation | table | confluence
public | contentproperties | table | confluence
public | cwd_app_dir_group_mapping | table | confluence
public | cwd_app_dir_mapping | table | confluence
public | cwd_app_dir_operation | table | confluence
public | cwd_application | table | confluence
public | cwd_application_address | table | confluence
public | cwd_application_attribute | table | confluence
public | cwd_directory | table | confluence
public | cwd_directory_attribute | table | confluence
public | cwd_directory_operation | table | confluence
public | cwd_group | table | confluence
public | cwd_group_attribute | table | confluence
public | cwd_membership | table | confluence
public | cwd_user | table | confluence
public | cwd_user_attribute | table | confluence
public | cwd_user_credential_record | table | confluence
public | decorator | table | confluence
public | diagnostics_alerts | table | confluence
public | follow_connections | table | confluence
public | hibernate_unique_key | table | confluence
public | imagedetails | table | confluence
public | indexqueueentries | table | confluence
public | journalentry | table | confluence
public | keystore | table | confluence
public | label | table | confluence
public | likes | table | confluence
public | links | table | confluence
public | logininfo | table | confluence
public | notifications | table | confluence
public | os_propertyentry | table | confluence
public | pagetemplates | table | confluence
public | plugindata | table | confluence

public | remembermetoken | table | confluence
public | scheduler_clustered_jobs | table | confluence
public | scheduler_run_details | table | confluence
public | spacepermissions | table | confluence
public | spaces | table | confluence
public | thiswillnotbecreated | table | confluence
public | trustedapp | table | confluence
public | trustedapprestriction | table | confluence
public | user_mapping | table | confluence
public | user_relation | table | confluence
public | usercontent_relation | table | confluence

After this these errors appear and the wizard is stuck with the message:

We're just setting up your database. This can take a little while

this never stops. The logs stop showing anything.

I can restart the application, but them i am stuck with a broken confluence without any layout.

My version of Confluence is:

atlassian-confluence-7.3.3-x64.bin

my db

select version();
version
-------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.5.19 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609, 64-bit
(1 row)

I am using a default installation. Threw everything away 2 times and started completely clean. always with the same problem.

i could not attach the log parts because of the 20.000 char restriction, but will supply them as soon as somebody asks for them. The snippets i can provide are:

the only thing i can see aside from the errors in the postgres log:

020-03-24 13:36:41.884 CET [14638] confluence@confluence ERROR: relation "attachments" does not exist at character 22
2020-03-24 13:36:41.884 CET [14638] confluence@confluence STATEMENT: select count(*) from ATTACHMENTS
2020-03-24 13:36:41.895 CET [14638] confluence@confluence ERROR: relation "bodycontent" does not exist at character 22
2020-03-24 13:36:41.895 CET [14638] confluence@confluence STATEMENT: select count(*) from BODYCONTENT

...

2020-03-24 13:37:34.274 CET [14748] confluence@confluence ERROR: table "hibernate_unique_key" does not exist
2020-03-24 13:37:34.274 CET [14748] confluence@confluence STATEMENT: drop table hibernate_unique_key
2020-03-24 13:37:35.840 CET [14773] confluence@confluence ERROR: relation "attachments" does not exist at character 22
2020-03-24 13:37:35.840 CET [14773] confluence@confluence STATEMENT: select count(*) from ATTACHMENTS
2020-03-24 13:39:50.754 CET [14986] confluence@confluence ERROR: relation "attachments" does not exist at character 22
2020-03-24 13:39:50.754 CET [14986] confluence@confluence STATEMENT: select count(*) from ATTACHMENTS;

is a stacktrace roughly 8 minutes afer the db errors occur:

24-Mar-2020 13:49:44.845 SEVERE [http-nio-8090-exec-3] org.apache.catalina.core.StandardHostValve.custom Exception Processing ErrorPage[errorCode=500, location=/500page.jsp]
org.apache.jasper.JasperException: An exception occurred processing [/500page.jsp] at line [123]

120: confluenceInfo = sysInfoService.getConfluenceInfo();
121: memoryInfo = sysInfoService.getMemoryInfo();
122: dbInfo = sysInfoService.getSafeDatabaseInfo();
123: sysinfo = GeneralUtil.convertBeanToMap(sysInfoService.getSystemProperties());
124:
125: isOrion = "Orion".equals(sysinfo.get("appServer"));
126: }

Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:625)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:514)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.atlassian.confluence.web.filter.DebugFilter.doFilter(DebugFilter.java:46)

...

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy216.retrieve(Unknown Source)
at com.atlassian.confluence.setup.bandana.ConfluenceCachingBandanaPersister.lambda$retrieve$0(ConfluenceCachingBandanaPersister.java:80)
at com.atlassian.confluence.impl.vcache.SynchronousExternalCache.lambda$get$11(SynchronousExternalCache.java:239)
at com.atlassian.confluence.impl.concurrency.CompletionStageUtils.lambda$foldResult$0(CompletionStageUtils.java:19)

[Fabio Racobaldo _Herzum_]

Hi @Johan ,

please check that user has correct grants on DB.

Fabio