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

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

3 answers

0 votes
AnnWorley 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,

Like Daniel_Alonso likes this

Is there any resolution to this? I have the exact same problem.

Running into exactly the same error here.  I get through the license screen, and the "Test Connection" works, and then these errors.  I don't see any evidence that Confluence is even trying to create the tables.

I have exactly the same issue. Is there any resolution for that?

I have exactly the same issue. Is there any resolution for that?

bump... Have the same issue here

Hi,

As @AnnWorley say, you need to start your Postgres container first to let him create the confluence's database correctly, and then relaunch all your container and you will not have any error message.

Regards

0 votes

Same problem here!

Rigth after conecting to the database the posgresql log shows a lot error massages like:

ERROR: relation "attachments" does not exist at character 22

I tried to pull up confluence with the following docker-compose.yml om s debian 10 server.

Starting postgres prior pulling up confluence did not solve the problem.

Creating the trial database did not work as well, but with different error massages.

What is wrong with my docker-compose here?

 

version: '3.5'

services:
confluence-prod_confluence:
image: teamatldocker/confluence
container_name: confluence-prod_confluence
restart: always
depends_on:
- confluence-prod_postgresql
networks:
confluence-prod_net:
aliases:
- confluence
volumes:
- confluence-prod_confluence:/var/atlassian/confluence
ports:
- '9480:8090'
- '8091:8091'
environment:
- 'CATALINA_OPTS= -Xms2g -Xmx4g'
- 'CONFLUENCE_PROXY_NAME=confluence.becker-systemberatung.de'
- 'CONFLUENCE_PROXY_PORT=443'
- 'CONFLUENCE_PROXY_SCHEME=https'
- 'CONFLUENCE_DELAYED_START='
logging:
driver: "json-file"
options:
max-size: "200k"
max-file: "10"

# Driver Class Name: org.postgresql.Driver
# Database URL: jdbc:postgresql://postgres:5432/confluencedb
# User Name: confluencedb
# Password: jellyfish
confluence-prod_postgresql:
image: postgres:10-alpine
container_name: confluence-prod_postgresql
restart: always
networks:
confluence-prod_net:
aliases:
- postgres
volumes:
- confluence-prod_postgresql:/var/lib/postgresql/data
environment:
- 'POSTGRES_USER=confluencedb'
# CHANGE THE PASSWORD!
- 'POSTGRES_PASSWORD=jellyfish'
- 'POSTGRES_DB=confluencedb'
- 'POSTGRES_ENCODING=UTF8'
- 'POSTGRES_COLLATE=utf8'
- 'POSTGRES_COLLATE_TYPE=utf8'
logging:
driver: "json-file"
options:
max-size: "200k"
max-file: "10"

volumes:
confluence-prod_confluence:
name: confluence-prod_confluence
confluence-prod_postgresql:
name: confluence-prod_postgresql

networks:
confluence-prod_net:
name: confluence-prod_net
driver: bridge

Hello Mister Becker,

have you found a solution to the problem?
I am tasked with setting up a confluence on docker and I am running into the same problems.

Greetings
Kevin

In my case the problem was just the setup page that initialized the database timed out, due to a slow machine. I could see the same errors in DB log, however they do not seem to cause the problem.

After cleaning the volumes up and accessing the confluence installation directly instead via traefik reverse proxy the setup did not time out and the installation could be completed.

Suggest an answer

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

How is your team having fun and bonding, remotely, utilizing Confluence?

Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...

327 views 9 7
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