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 votes
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

Hi Ann,

it happens as soon as you set up the DB properties in the setup wizard with any version of Confluence and Postgres

That is from PostgreSQL logs

PostgreSQL init process complete; ready for start up.
2018-11-14T17:32:25.709542200Z
LOG: database system was shut down at 2018-11-14 17:32:24 UTC
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
ERROR: relation "attachments" does not exist at character 22
STATEMENT: select count(*) from ATTACHMENTS
ERROR: relation "bodycontent" does not exist at character 22
STATEMENT: select count(*) from BODYCONTENT
ERROR: relation "content" does not exist at character 22
STATEMENT: select count(*) from CONTENT
ERROR: relation "contentlock" does not exist at character 22
STATEMENT: select count(*) from CONTENTLOCK
ERROR: relation "extrnlnks" does not exist at character 22
STATEMENT: select count(*) from EXTRNLNKS
ERROR: relation "links" does not exist at character 22
STATEMENT: select count(*) from LINKS
ERROR: relation "notifications" does not exist at character 22
STATEMENT: select count(*) from NOTIFICATIONS
ERROR: relation "os_group" does not exist at character 22
STATEMENT: select count(*) from os_group
ERROR: relation "os_propertyentry" does not exist at character 22
STATEMENT: select count(*) from OS_PROPERTYENTRY
ERROR: relation "os_user" does not exist at character 22
STATEMENT: select count(*) from os_user
ERROR: relation "os_user_group" does not exist at character 22
STATEMENT: select count(*) from os_user_group
ERROR: relation "pagetemplates" does not exist at character 22
STATEMENT: select count(*) from PAGETEMPLATES
ERROR: relation "spacepermissions" does not exist at character 22
STATEMENT: select count(*) from SPACEPERMISSIONS
ERROR: relation "spaces" does not exist at character 22
STATEMENT: select count(*) from SPACES
ERROR: relation "trackbacklinks" does not exist at character 22
STATEMENT: select count(*) from TRACKBACKLINKS
ERROR: relation "contentproperties" does not exist
STATEMENT: alter table CONTENTPROPERTIES drop constraint FK984C5E4C8DD41734
ERROR: relation "spacepermissions" does not exist
STATEMENT: alter table SPACEPERMISSIONS drop constraint FKD33F23BEB2DC6081
ERROR: relation "spacepermissions" does not exist
STATEMENT: alter table SPACEPERMISSIONS drop constraint FK_SPACEPERMISSIONS_CREATOR
ERROR: relation "spacepermissions" does not exist
STATEMENT: alter table SPACEPERMISSIONS drop constraint FK_SPACEPERMISSIONS_LASTMODIFI
ERROR: relation "spacepermissions" does not exist
STATEMENT: alter table SPACEPERMISSIONS drop constraint FK_SPACEPERMISSIONS_PERMUSERNA
ERROR: relation "cwd_user_credential_record" does not exist
STATEMENT: alter table cwd_user_credential_record drop constraint FK76F874F73AEE0F
ERROR: relation "spaces" does not exist
STATEMENT: alter table SPACES drop constraint FK_SPACES_LASTMODIFIER
ERROR: relation "spaces" does not exist
STATEMENT: alter table SPACES drop constraint FK_SPACES_CREATOR
ERROR: relation "spaces" does not exist
STATEMENT: alter table SPACES drop constraint FK9228242D11B7BFEE
ERROR: relation "spaces" does not exist
STATEMENT: alter table SPACES drop constraint FK9228242D2C72D3D2
ERROR: relation "spaces" does not exist
STATEMENT: alter table SPACES drop constraint FK9228242D16994414
ERROR: relation "cwd_membership" does not exist
STATEMENT: alter table cwd_membership drop constraint fk_child_grp
ERROR: relation "cwd_membership" does not exist
STATEMENT: alter table cwd_membership drop constraint fk_child_user
ERROR: relation "cwd_membership" does not exist
STATEMENT: alter table cwd_membership drop constraint fk_parent_grp
ERROR: relation "content_label" does not exist
STATEMENT: alter table CONTENT_LABEL drop constraint FKF0E7436E27072AEF
ERROR: relation "content_label" does not exist
STATEMENT: alter table CONTENT_LABEL drop constraint FKF0E7436ED32042E4
ERROR: relation "content_label" does not exist
STATEMENT: alter table CONTENT_LABEL drop constraint FKF0E7436E8DD41734
ERROR: relation "content_label" does not exist
STATEMENT: alter table CONTENT_LABEL drop constraint FK_CONTENT_LABEL_OWNER
ERROR: relation "cwd_user" does not exist
STATEMENT: alter table cwd_user drop constraint fk_user_dir_id
ERROR: relation "attachmentdata" does not exist
STATEMENT: alter table ATTACHMENTDATA drop constraint FK9DC3E34D34A4917E
ERROR: relation "pagetemplates" does not exist
STATEMENT: alter table PAGETEMPLATES drop constraint FK_PAGETEMPLATES_LASTMODIFIER
ERROR: relation "pagetemplates" does not exist
STATEMENT: alter table PAGETEMPLATES drop constraint FK_PAGETEMPLATES_CREATOR
ERROR: relation "pagetemplates" does not exist
STATEMENT: alter table PAGETEMPLATES drop constraint FKBC7CE96AB2DC6081
ERROR: relation "pagetemplates" does not exist
STATEMENT: alter table PAGETEMPLATES drop constraint FKBC7CE96A17D4A070
ERROR: relation "logininfo" does not exist
STATEMENT: alter table logininfo drop constraint FK_logininfo_USERNAME
ERROR: relation "label" does not exist
STATEMENT: alter table LABEL drop constraint FK_LABEL_OWNER
ERROR: relation "cwd_user_attribute" does not exist
STATEMENT: alter table cwd_user_attribute drop constraint fk_user_attr_dir_id
ERROR: relation "cwd_user_attribute" does not exist
STATEMENT: alter table cwd_user_attribute drop constraint fk_user_attribute_id_user_id
ERROR: relation "extrnlnks" does not exist
STATEMENT: alter table EXTRNLNKS drop constraint FK_EXTRNLNKS_CREATOR
ERROR: relation "extrnlnks" does not exist
STATEMENT: alter table EXTRNLNKS drop constraint FK_EXTRNLNKS_LASTMODIFIER
ERROR: relation "extrnlnks" does not exist
STATEMENT: alter table EXTRNLNKS drop constraint FK97C10FE78DD41734
ERROR: relation "confancestors" does not exist
STATEMENT: alter table CONFANCESTORS drop constraint FK9494E23CC45E94DC
ERROR: relation "confancestors" does not exist
STATEMENT: alter table CONFANCESTORS drop constraint FK9494E23C37E35A2E
ERROR: relation "cwd_app_dir_mapping" does not exist
STATEMENT: alter table cwd_app_dir_mapping drop constraint fk_app_dir_dir
ERROR: relation "cwd_app_dir_mapping" does not exist
STATEMENT: alter table cwd_app_dir_mapping drop constraint FK52050E2FB347AA6A
ERROR: relation "cwd_app_dir_group_mapping" does not exist
STATEMENT: alter table cwd_app_dir_group_mapping drop constraint fk_app_dir_group_dir
ERROR: relation "cwd_app_dir_group_mapping" does not exist
STATEMENT: alter table cwd_app_dir_group_mapping drop constraint fk_app_dir_group_mapping
ERROR: relation "cwd_app_dir_group_mapping" does not exist
STATEMENT: alter table cwd_app_dir_group_mapping drop constraint fk_app_dir_group_app
ERROR: relation "cwd_directory_operation" does not exist
STATEMENT: alter table cwd_directory_operation drop constraint fk_directory_operation
ERROR: relation "cwd_app_dir_operation" does not exist
STATEMENT: alter table cwd_app_dir_operation drop constraint fk_app_dir_mapping
ERROR: relation "links" does not exist
STATEMENT: alter table LINKS drop constraint FK45157998DD41734
ERROR: relation "links" does not exist
STATEMENT: alter table LINKS drop constraint FK_LINKS_LASTMODIFIER
ERROR: relation "links" does not exist
STATEMENT: alter table LINKS drop constraint FK_LINKS_CREATOR
ERROR: relation "cwd_application_address" does not exist
STATEMENT: alter table cwd_application_address drop constraint fk_application_address
ERROR: relation "local_members" does not exist
STATEMENT: alter table local_members drop constraint FK6B8FB445CE2B3226
ERROR: relation "local_members" does not exist
STATEMENT: alter table local_members drop constraint FK6B8FB445117D5FDA
ERROR: relation "likes" does not exist

Cheers,

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,084 views 17 14
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