Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Nextcloud
  3. How to fix thes errors in PostgreSQL Logs related to oc_filecache_extended ?

How to fix thes errors in PostgreSQL Logs related to oc_filecache_extended ?

Scheduled Pinned Locked Moved Solved Nextcloud
postgresqlnextcloud
12 Posts 3 Posters 2.7k Views 3 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • nebulonN nebulon

    Hm this issue again...we have had various problems with those cache keys during app update. Apparently some nextcloud addons use fields and until recently the table primary key was not correctly set, resulting in not unique keys.
    We have a special section for attempts to handle this in the start.sh since recently: https://git.cloudron.io/cloudron/nextcloud-app/-/blob/master/start.sh#L173

    Which nextcloud package version are you currently at?

    JOduMonTJ Offline
    JOduMonTJ Offline
    JOduMonT
    wrote on last edited by
    #3

    @nebulon said in How to fix thes errors in PostgreSQL Logs related to oc_filecache- _extended ?:

    Which nextcloud package version are you currently at?

    Nextcloud Package v4.8.5 App v20.0.5

    Nextcloud apps

    • Auditing / Logging 1.10.0 Featured
    • Bookmarks 4.0.5
    • Calendar 2.1.3 Featured
    • Circles 0.20.6 Featured
    • Collaborative tags 1.10.0 Featured
    • Comments 1.10.0 Featured
    • Contacts 3.4.3 Featured
    • Contacts Interaction 1.1.0 Featured
    • Dashboard 7.0.0 Featured
    • Deck 1.2.3 Featured
    • Deleted files 1.10.1 Featured
    • Duplicate Finder 0.0.4
    • External storage support 1.11.1 Featured
    • Federation 1.10.1 Featured
    • File sharing 1.12.2 Featured
    • First run wizard 2.9.0 Featured
    • Flow Upload 1.1.2
    • Forms 2.1.0 Featured
    • Impersonate 1.7.0 Featured
    • LDAP user and group backend 1.10.2 Featured
    • Log Reader 2.5.0 Featured
    • Monitoring 1.10.0
    • Featured News 15.1.1
    • Nextcloud announcements 1.9.0 Featured
    • Notes 4.0.2 Featured
    • Notifications 2.8.0 Featured
    • ONLYOFFICE 6.2.0 Featured
    • Password policy 1.10.1 Featured
    • PDF viewer 2.0.1 Featured
    • Photos 1.2.3 Featured
    • Privacy 1.4.0 Featured
    • QOwnNotesAPI 20.9.0
    • Recommendations 0.8.0 Featured
    • Retention 1.9.0 Featured
    • Right click 0.17.0 Featured
    • Share by mail 1.10.0 Featured
    • Social 0.4.2 Featured
    • Social sharing via Diaspora 2.1.0 Featured
    • Social sharing via email 2.1.0 Featured
    • Social sharing via Facebook 2.1.0 Featured
    • Social sharing via Twitter 2.1.0 Featured
    • Support 1.3.0 Featured
    • Talk 10.0.5 Featured
    • Tasks 0.13.6 Featured
    • Text 3.1.0 Featured
    • Theming 1.11.0 Featured
    • Two-Factor TOTP Provider 5.0.0
    • Update notification 1.10.0 Featured
    • Usage survey 1.8.0 Featured
    • User status 1.0.1 Featured
    • Versions 1.13.0 Featured
    • Video player 1.9.0 Featured
    • Weather status 1.0.0 Featured

    I'm welling to execute command and disable apps for test purpose
    just tell me 🙂

    nebulonN 1 Reply Last reply
    0
    • JOduMonTJ JOduMonT

      @nebulon said in How to fix thes errors in PostgreSQL Logs related to oc_filecache- _extended ?:

      Which nextcloud package version are you currently at?

      Nextcloud Package v4.8.5 App v20.0.5

      Nextcloud apps

      • Auditing / Logging 1.10.0 Featured
      • Bookmarks 4.0.5
      • Calendar 2.1.3 Featured
      • Circles 0.20.6 Featured
      • Collaborative tags 1.10.0 Featured
      • Comments 1.10.0 Featured
      • Contacts 3.4.3 Featured
      • Contacts Interaction 1.1.0 Featured
      • Dashboard 7.0.0 Featured
      • Deck 1.2.3 Featured
      • Deleted files 1.10.1 Featured
      • Duplicate Finder 0.0.4
      • External storage support 1.11.1 Featured
      • Federation 1.10.1 Featured
      • File sharing 1.12.2 Featured
      • First run wizard 2.9.0 Featured
      • Flow Upload 1.1.2
      • Forms 2.1.0 Featured
      • Impersonate 1.7.0 Featured
      • LDAP user and group backend 1.10.2 Featured
      • Log Reader 2.5.0 Featured
      • Monitoring 1.10.0
      • Featured News 15.1.1
      • Nextcloud announcements 1.9.0 Featured
      • Notes 4.0.2 Featured
      • Notifications 2.8.0 Featured
      • ONLYOFFICE 6.2.0 Featured
      • Password policy 1.10.1 Featured
      • PDF viewer 2.0.1 Featured
      • Photos 1.2.3 Featured
      • Privacy 1.4.0 Featured
      • QOwnNotesAPI 20.9.0
      • Recommendations 0.8.0 Featured
      • Retention 1.9.0 Featured
      • Right click 0.17.0 Featured
      • Share by mail 1.10.0 Featured
      • Social 0.4.2 Featured
      • Social sharing via Diaspora 2.1.0 Featured
      • Social sharing via email 2.1.0 Featured
      • Social sharing via Facebook 2.1.0 Featured
      • Social sharing via Twitter 2.1.0 Featured
      • Support 1.3.0 Featured
      • Talk 10.0.5 Featured
      • Tasks 0.13.6 Featured
      • Text 3.1.0 Featured
      • Theming 1.11.0 Featured
      • Two-Factor TOTP Provider 5.0.0
      • Update notification 1.10.0 Featured
      • Usage survey 1.8.0 Featured
      • User status 1.0.1 Featured
      • Versions 1.13.0 Featured
      • Video player 1.9.0 Featured
      • Weather status 1.0.0 Featured

      I'm welling to execute command and disable apps for test purpose
      just tell me 🙂

      nebulonN Offline
      nebulonN Offline
      nebulon
      Staff
      wrote on last edited by
      #4

      @jodumont For a start, can you put the app into developer mode and then verify that indeed sudo -u www-data php /app/code/occ db:add-missing-primary-keys is the failing command?

      After that you can run the sql commands mentioned in that start.sh if section. As far as I can tell if that is run, you shouldn't hit the issue you are seeing.

      JOduMonTJ amg-webA 2 Replies Last reply
      0
      • nebulonN nebulon

        @jodumont For a start, can you put the app into developer mode and then verify that indeed sudo -u www-data php /app/code/occ db:add-missing-primary-keys is the failing command?

        After that you can run the sql commands mentioned in that start.sh if section. As far as I can tell if that is run, you shouldn't hit the issue you are seeing.

        JOduMonTJ Offline
        JOduMonTJ Offline
        JOduMonT
        wrote on last edited by
        #5

        @nebulon said in How to fix thes errors in PostgreSQL Logs related to oc_filecache_extended ?:

        @jodumont For a start, can you put the app into developer mode and then verify that indeed sudo -u www-data php /app/code/occ db:add-missing-primary-keys is the failing command?

        Dev Mode ?
        I restarted the Nextcloud Apps in recovery mode
        and executed the command in the Terminal App
        it ran without issue

        Check primary keys.
        Done.
        
        1 Reply Last reply
        0
        • nebulonN Offline
          nebulonN Offline
          nebulon
          Staff
          wrote on last edited by
          #6

          yes I meant recovery mode. So can you then see in the logs where the issue you initially posted appears?

          JOduMonTJ 1 Reply Last reply
          0
          • nebulonN nebulon

            yes I meant recovery mode. So can you then see in the logs where the issue you initially posted appears?

            JOduMonTJ Offline
            JOduMonTJ Offline
            JOduMonT
            wrote on last edited by
            #7

            @nebulon said in How to fix thes errors in PostgreSQL Logs related to oc_filecache_extended ?:

            yes I meant recovery mode. So can you then see in the logs where the issue you initially posted appears?

            ok I did it again this (my) morning
            Nextcloud ran the command without any issue

            Check primary keys.
            Done.
            

            and in PostgreSQL logs nothing appear

            • yesterday = 21:15
            • today = 06:46
            Jan 15 17:15:36 Starting supervisor
            Jan 15 17:15:37 2021-01-15 10:15:37,375 CRIT Supervisor running as root (no user in config file)
            Jan 15 17:15:37 2021-01-15 10:15:37,393 INFO Included extra file "/etc/supervisor/conf.d/postgresql-service.conf" during parsing
            Jan 15 17:15:37 2021-01-15 10:15:37,393 INFO Included extra file "/etc/supervisor/conf.d/postgresql.conf" during parsing
            Jan 15 17:15:37 2021-01-15 10:15:37,462 INFO RPC interface 'supervisor' initialized
            Jan 15 17:15:37 2021-01-15 10:15:37,481 CRIT Server 'inet_http_server' running without any HTTP authentication checking
            Jan 15 17:15:37 2021-01-15 10:15:37,482 INFO RPC interface 'supervisor' initialized
            Jan 15 17:15:37 2021-01-15 10:15:37,485 CRIT Server 'unix_http_server' running without any HTTP authentication checking
            Jan 15 17:15:37 2021-01-15 10:15:37,485 INFO supervisord started with pid 1
            Jan 15 17:15:38 2021-01-15 10:15:38,488 INFO spawned: 'postgresql' with pid 37
            Jan 15 17:15:38 2021-01-15 10:15:38,490 INFO spawned: 'postgresql-service' with pid 38
            Jan 15 17:15:38 2021-01-15 10:15:38.598 UTC [37] LOG: listening on IPv4 address "0.0.0.0", port 5432
            Jan 15 17:15:38 2021-01-15 10:15:38.606 UTC [37] LOG: listening on IPv6 address "::", port 5432
            Jan 15 17:15:38 2021-01-15 10:15:38.610 UTC [37] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
            Jan 15 17:15:38 2021-01-15 10:15:38.785 UTC [45] LOG: database system was shut down at 2021-01-15 10:15:35 UTC
            Jan 15 17:15:38 2021-01-15 10:15:38.817 UTC [37] LOG: database system is ready to accept connections
            Jan 15 17:15:39 Postgresql service endpoint listening on https://:::3000
            Jan 15 17:15:40 2021-01-15 10:15:40,459 INFO success: postgresql entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
            Jan 15 17:15:40 2021-01-15 10:15:40,459 INFO success: postgresql-service entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
            Jan 15 21:15:56 [POST] /databases
            Jan 15 21:18:54 [POST] /databases
            Jan 16 06:45:34 [POST] /databases
            Jan 16 06:46:12 [GET] /healthcheck
            
            1 Reply Last reply
            0
            • nebulonN Offline
              nebulonN Offline
              nebulon
              Staff
              wrote on last edited by
              #8

              So where and when do those error logs initially posted appear then?

              JOduMonTJ 1 Reply Last reply
              0
              • nebulonN nebulon

                So where and when do those error logs initially posted appear then?

                JOduMonTJ Offline
                JOduMonTJ Offline
                JOduMonT
                wrote on last edited by
                #9

                @nebulon said in How to fix thes errors in PostgreSQL Logs related to oc_filecache_extended ?:

                So where and when do those error logs initially posted appear then?

                In PostgreSQL, the January 14, probably while I was messing with my CIFS

                nebulonN 1 Reply Last reply
                0
                • JOduMonTJ JOduMonT

                  @nebulon said in How to fix thes errors in PostgreSQL Logs related to oc_filecache_extended ?:

                  So where and when do those error logs initially posted appear then?

                  In PostgreSQL, the January 14, probably while I was messing with my CIFS

                  nebulonN Offline
                  nebulonN Offline
                  nebulon
                  Staff
                  wrote on last edited by
                  #10

                  @jodumont Actually I meant the original error logs from Nextcloud or are those gone by now and the issue somehow resolved? Asking since apparently then it was not related to the add-missing-primary-keys command?

                  1 Reply Last reply
                  0
                  • nebulonN nebulon

                    @jodumont For a start, can you put the app into developer mode and then verify that indeed sudo -u www-data php /app/code/occ db:add-missing-primary-keys is the failing command?

                    After that you can run the sql commands mentioned in that start.sh if section. As far as I can tell if that is run, you shouldn't hit the issue you are seeing.

                    amg-webA Offline
                    amg-webA Offline
                    amg-web
                    wrote on last edited by
                    #11

                    @nebulon said in How to fix thes errors in PostgreSQL Logs related to oc_filecache_extended ?:

                    into developer mode

                    Hi,

                    I could not find how to put app into developer mode
                    Can you tell me? I have same issue in DB

                    nebulonN 1 Reply Last reply
                    0
                    • amg-webA amg-web

                      @nebulon said in How to fix thes errors in PostgreSQL Logs related to oc_filecache_extended ?:

                      into developer mode

                      Hi,

                      I could not find how to put app into developer mode
                      Can you tell me? I have same issue in DB

                      nebulonN Offline
                      nebulonN Offline
                      nebulon
                      Staff
                      wrote on last edited by
                      #12

                      @amg-web I mean the recovery mode, which you can enable for the app in the "Repair" section on the app configure view in the Cloudron dashboard.

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • Bookmarks
                      • Search