Postgres Setup Error Messages

Hi,

I recently purchased starter licenses for Jira and Conlfuence for my business.  I have been trying to get Confluence running on Postgres using docker images.  I have tried Atlassian's images as well as others.  I've tried different versions of Postgres.   Each time, after I enter the license info, the server crashes.  The log has these messages in it:

 

postgres | ERROR: relation "attachments" does not exist at character 22
postgres | STATEMENT: select count(*) from ATTACHMENTS
postgres | ERROR: relation "bodycontent" does not exist at character 22
postgres | STATEMENT: select count(*) from BODYCONTENT
postgres | ERROR: relation "content" does not exist at character 22
postgres | STATEMENT: select count(*) from CONTENT
postgres | ERROR: relation "contentlock" does not exist at character 22
postgres | STATEMENT: select count(*) from CONTENTLOCK
postgres | ERROR: relation "extrnlnks" does not exist at character 22
postgres | STATEMENT: select count(*) from EXTRNLNKS
postgres | ERROR: relation "links" does not exist at character 22
postgres | STATEMENT: select count(*) from LINKS
postgres | ERROR: relation "notifications" does not exist at character 22
postgres | STATEMENT: select count(*) from NOTIFICATIONS
postgres | ERROR: relation "os_group" does not exist at character 22
postgres | STATEMENT: select count(*) from os_group
postgres | ERROR: relation "os_propertyentry" does not exist at character 22
postgres | STATEMENT: select count(*) from OS_PROPERTYENTRY
postgres | ERROR: relation "os_user" does not exist at character 22
postgres | STATEMENT: select count(*) from os_user
postgres | ERROR: relation "os_user_group" does not exist at character 22
postgres | STATEMENT: select count(*) from os_user_group
postgres | ERROR: relation "pagetemplates" does not exist at character 22
postgres | STATEMENT: select count(*) from PAGETEMPLATES
postgres | ERROR: relation "spacepermissions" does not exist at character 22
postgres | STATEMENT: select count(*) from SPACEPERMISSIONS
postgres | ERROR: relation "spaces" does not exist at character 22
postgres | STATEMENT: select count(*) from SPACES
postgres | ERROR: relation "trackbacklinks" does not exist at character 22
postgres | STATEMENT: select count(*) from TRACKBACKLINKS

 

I have tried Googling but to no avail.  

 

Thanks,

Larry

1 answer

0 vote
Ann Worley Atlassian Team Sep 25, 2017

Hi Larry,

I understand that you are seeing errors in the log indicating that tables Confluence expects in the database do not exist. Are those errors from the PostgreSQL log or the Confluence log?

In my experience with the setup wizard for Confluence, the license step comes before the database setup step, so I am not sure why the logs would indicate that the tables cannot be found at that time, as the tables are not created until the database setup step. Could you let me know at what point you are entering the license? Is the Docker instance already set up and then you are entering a Production license? 

Please let me know what steps you are taking to change the database Confluence is using.

Please check the Confluence logs for more information about what is happening when you enter the license. The logs are:

  • <confluence_install>/logs/ (anything recent in this directory
  • <confluence_home>/logs/atlassian-confluence.log
    Note: The <confluence_home> directory is the path defined in the following file: <confluence_install>/confluence/WEB-INF/classes/confluence-init.properties

Thanks,

Ann

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

373 views 20 10
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you