Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] ERROR: relation "oc_appconfig" does not exist at character 57 with new install of latest version ONLY #467

Open
1 task done
alamoudimoh opened this issue Aug 24, 2024 · 12 comments

Comments

@alamoudimoh
Copy link

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

the below error only happens when installing a fresh installtion of 29.0.5-ls335

i used version 29.04 and it works fine,
i used version 29.04 and upgraded to latest tag and it worked fine, only with new installation of latest

Internal Server Error

The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.

Expected Behavior

logging into nextcloud normaly

Steps To Reproduce

  1. create new docker with PostgreSQL and nextcloud using nextcloud latest tag
  2. installtion complete successfully
  3. start the intial setup.
  4. once the database start to connect you get the following error
Internal Server Error

The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.

Environment

- OS: ubuntu 22.04
- How docker service was installed: portainer stack

CPU architecture

x86-64

Docker creation

services:
  database:
    image: postgres:16
    container_name: PostgreSQL
    restart: always
    environment:
      POSTGRES_USER: db_user
      POSTGRES_PASSWORD: db_password
      POSTGRES_DB: nextcloud_db
    volumes:
      - /Storage/PostgreSQL/database:/var/lib/postgresql/data
    networks:
      - nc_network
      
     
  app:
    image: lscr.io/linuxserver/nextcloud:29.0.4-ls332
    container_name: NextCloud
    restart: always
    environment:
      PUID: 1000
      PGID: 1000
      TZ: Asia/Riyadh
    ports:
      - 443:443
    volumes:
      - /Storage/NextCloud/config:/config
      - /Pool-Storage/Storage/data:/data
    depends_on:
      - database
      - cache
    networks:
      - nc_network

Container logs

PostgreSQL init process complete; ready for start up.
2024-08-24 11:37:48.228 UTC [1] LOG:  starting PostgreSQL 16.4 (Debian 16.4-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-08-24 11:37:48.228 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-08-24 11:37:48.228 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-08-24 11:37:48.240 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-08-24 11:37:48.253 UTC [65] LOG:  database system was shut down at 2024-08-24 11:37:48 UTC
2024-08-24 11:37:48.261 UTC [1] LOG:  database system is ready to accept connections
2024-08-24 11:37:48.360 UTC [69] ERROR:  relation "oc_mounts" does not exist at character 27
2024-08-24 11:37:48.360 UTC [69] STATEMENT:  SELECT user_id, path FROM oc_mounts INNER JOIN oc_filecache ON root_id = fileid WHERE storage_id = 1
2024-08-24 11:39:00.064 UTC [75] ERROR:  relation "oc_appconfig" does not exist at character 57
2024-08-24 11:39:00.064 UTC [75] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "oc_appconfig" WHERE "lazy" = $1
2024-08-24 11:39:00.067 UTC [75] ERROR:  relation "oc_appconfig" does not exist at character 57
2024-08-24 11:39:00.067 UTC [75] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "oc_appconfig" WHERE "lazy" = $1
2024-08-24 11:39:00.067 UTC [75] ERROR:  relation "oc_appconfig" does not exist at character 57
2024-08-24 11:39:00.067 UTC [75] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "oc_appconfig" WHERE "lazy" = $1
2024-08-24 11:39:00.068 UTC [75] ERROR:  relation "oc_appconfig" does not exist at character 57
2024-08-24 11:39:00.068 UTC [75] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "oc_appconfig" WHERE "lazy" = $1
2024-08-24 11:39:00.069 UTC [75] ERROR:  relation "oc_appconfig" does not exist at character 57
2024-08-24 11:39:00.069 UTC [75] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "oc_appconfig" WHERE "lazy" = $1
2024-08-24 11:39:00.112 UTC [76] ERROR:  relation "oc_appconfig" does not exist at character 57
2024-08-24 11:39:00.112 UTC [76] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "oc_appconfig" WHERE "lazy" = $1
2024-08-24 11:39:00.113 UTC [76] ERROR:  relation "oc_appconfig" does not exist at character 57
2024-08-24 11:39:00.113 UTC [76] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "oc_appconfig" WHERE "lazy" = $1
2024-08-24 11:39:00.113 UTC [76] ERROR:  relation "oc_appconfig" does not exist at character 57
2024-08-24 11:39:00.113 UTC [76] STATEMENT:  SELECT "appid", "configkey", "configvalue", "type" FROM "oc_appconfig" WHERE "lazy" = $1
2024-08-24 11:39:00.114 UTC [76] ERROR:  relation "oc_appconfig" does not exist at character 57
Copy link

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

@KrazyJO
Copy link

KrazyJO commented Aug 25, 2024

I have the same error :(

@j0nnymoe
Copy link
Member

This needs to be reported upstream, this is an app issue, not a container issue.

@cfragkos
Copy link

I have the same on a fresh install

@joshtrichards
Copy link

Is there an owncloud.db (SQLite) file created within your /data folder when this happens (even though you're specifying postgresql)?

@alamoudimoh
Copy link
Author

Is there an owncloud.db (SQLite) file created within your /data folder when this happens (even though you're specifying postgresql)?

yes that is correct

@KrazyJO
Copy link

KrazyJO commented Aug 27, 2024

I could solve the problem for me. The problem appeared after upgrading from 28.x to 29.x. I had to manually add add 2 columns into a table: Have a look here: nextcloud/server#46879 (comment).
Hope this helps.

@joshtrichards
Copy link

We had a similar situation arise with the micro-services Docker image (nextcloud/docker#2283).

Fixed in nextcloud/server#47521

@chrislentz
Copy link

Any updates here? The official image has had a fix for this for sometime.

@lmaddox
Copy link

lmaddox commented Sep 17, 2024

Is there an owncloud.db (SQLite) file created within your /data folder when this happens (even though you're specifying postgresql)?

Yes, in my case, there were a lot of files on the mounted drive. Deleting them seems to have triggered the container to re-create the database, this time using the PG. I notice that the /config/config.php now says that the db type is pgsql. Thanks.

@uniquePWD
Copy link

uniquePWD commented Sep 28, 2024

I'm just hitting this today. What was the solution?

Never mind, different issue

@LinuxServer-CI
Copy link
Collaborator

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Issues
Development

No branches or pull requests

9 participants