It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confluence 7.3.3 install is stuck on setting up database on postgres Edited

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)

 

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

5,966 views 4 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you