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. Nextcloud in Error state even though it's running (after Cloudron 5.5 update)

Nextcloud in Error state even though it's running (after Cloudron 5.5 update)

Scheduled Pinned Locked Moved Solved Nextcloud
38 Posts 4 Posters 3.3k Views 4 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.
  • girishG Offline
    girishG Offline
    girish
    Staff
    wrote on last edited by
    #4

    What happened was that the db migration failed because postgres wanted more memory. What I did was to give it more memory and trigger a in-place import. That did the trick.

    1 Reply Last reply
    0
    • necrevistonnezrN Offline
      necrevistonnezrN Offline
      necrevistonnezr
      wrote on last edited by necrevistonnezr
      #5

      Something is not right with my Nextcloud instance, either, after the Cloudron 5.5 update. I had to increase the memory to 8 GB and CPU to 50 %, otherwise the app was in a "not responding" state.

      All clients (mac, PC, iOS) are in an endless loop to sync but never actually do. My Nextcloud website takes forever to load (all other Cloudron services like FreshRSS are fine). I re-setup the iOS client which takes forever. After entering credentials on the login dialog, I'm not being redirected to the app but I see a webview of Nextcloud.

      The Nextcloud logs don't show anything odd at a first glance except this:

      "Aug 18 09:23:29 [Tue Aug 18 07:23:29.826254 2020] [rewrite:error] [pid 8495] [client 172.18.0.1:50318] AH00670: Options FollowSymLinks and SymLinksIfOwnerMatch are both off, so the RewriteRule directive is also forbidden due to its similar ability to circumvent directory restrictions : /app/code/config"
      

      and (?)

      Aug 18 09:27:12 58:C 18 Aug 07:27:12.149 * DB saved on disk
      Aug 18 09:27:12 58:C 18 Aug 07:27:12.159 * RDB: 0 MB of memory used by copy-on-write
      Aug 18 09:27:12 15:M 18 Aug 07:27:12.220 * Background saving terminated with success
      
      girishG 1 Reply Last reply
      0
      • necrevistonnezrN Offline
        necrevistonnezrN Offline
        necrevistonnezr
        wrote on last edited by
        #6

        Also: Suddenly there's a new folder "uploads" that wasn't there before and that I didn't create.

        1 Reply Last reply
        0
        • necrevistonnezrN Offline
          necrevistonnezrN Offline
          necrevistonnezr
          wrote on last edited by
          #7

          I think the culprit is PostgreSQL 11 - was that recently changed in the Nextcloud Docker? My CPU runs at 100 % the whole time....

          Anmerkung 2020-08-18 153717.png

          1 Reply Last reply
          0
          • girishG Offline
            girishG Offline
            girish
            Staff
            wrote on last edited by
            #8

            Yes, Cloudron moved to Postgres 11 in the previous release (Cloudron 5.5). Can you just try restarting Postgres under services?

            Another thing is in /home/yellowtent/platformdata/logs/box.log do you see some error like Error importing postgresql ?

            necrevistonnezrN 1 Reply Last reply
            0
            • necrevistonnezrN necrevistonnezr

              Something is not right with my Nextcloud instance, either, after the Cloudron 5.5 update. I had to increase the memory to 8 GB and CPU to 50 %, otherwise the app was in a "not responding" state.

              All clients (mac, PC, iOS) are in an endless loop to sync but never actually do. My Nextcloud website takes forever to load (all other Cloudron services like FreshRSS are fine). I re-setup the iOS client which takes forever. After entering credentials on the login dialog, I'm not being redirected to the app but I see a webview of Nextcloud.

              The Nextcloud logs don't show anything odd at a first glance except this:

              "Aug 18 09:23:29 [Tue Aug 18 07:23:29.826254 2020] [rewrite:error] [pid 8495] [client 172.18.0.1:50318] AH00670: Options FollowSymLinks and SymLinksIfOwnerMatch are both off, so the RewriteRule directive is also forbidden due to its similar ability to circumvent directory restrictions : /app/code/config"
              

              and (?)

              Aug 18 09:27:12 58:C 18 Aug 07:27:12.149 * DB saved on disk
              Aug 18 09:27:12 58:C 18 Aug 07:27:12.159 * RDB: 0 MB of memory used by copy-on-write
              Aug 18 09:27:12 15:M 18 Aug 07:27:12.220 * Background saving terminated with success
              
              girishG Offline
              girishG Offline
              girish
              Staff
              wrote on last edited by
              #9

              @necrevistonnezr said in Nextcloud in Error state even though it's running (after Cloudron 5.5 update):

              Aug 18 09:27:12 58:C 18 Aug 07:27:12.149 * DB saved on disk
              Aug 18 09:27:12 58:C 18 Aug 07:27:12.159 * RDB: 0 MB of memory used by copy-on-write
              Aug 18 09:27:12 15:M 18 Aug 07:27:12.220 * Background saving terminated with success

              This one is from redis, you can ignore it.

              1 Reply Last reply
              0
              • girishG girish

                Yes, Cloudron moved to Postgres 11 in the previous release (Cloudron 5.5). Can you just try restarting Postgres under services?

                Another thing is in /home/yellowtent/platformdata/logs/box.log do you see some error like Error importing postgresql ?

                necrevistonnezrN Offline
                necrevistonnezrN Offline
                necrevistonnezr
                wrote on last edited by
                #10

                @girish said in Nextcloud in Error state even though it's running (after Cloudron 5.5 update):

                Yes, Cloudron moved to Postgres 11 in the previous release (Cloudron 5.5). Can you just try restarting Postgres under services?

                Another thing is in /home/yellowtent/platformdata/logs/box.log do you see some error like Error importing postgresql ?

                No error in box.log
                After restarting Postgres, it immediateley goes back to 100 % CPU.

                Anmerkung 2020-08-18 162033.png

                1 Reply Last reply
                0
                • girishG Offline
                  girishG Offline
                  girish
                  Staff
                  wrote on last edited by
                  #11

                  Just to narrow the issue down, if you stop the nextcloud app, does the postgresql cpu usage go back to normal? From the screenshot it seems it's busy in some SELECT command.

                  necrevistonnezrN 1 Reply Last reply
                  0
                  • girishG girish

                    Just to narrow the issue down, if you stop the nextcloud app, does the postgresql cpu usage go back to normal? From the screenshot it seems it's busy in some SELECT command.

                    necrevistonnezrN Offline
                    necrevistonnezrN Offline
                    necrevistonnezr
                    wrote on last edited by
                    #12

                    @girish said in Nextcloud in Error state even though it's running (after Cloudron 5.5 update):

                    Just to narrow the issue down, if you stop the nextcloud app, does the postgresql cpu usage go back to normal? From the screenshot it seems it's busy in some SELECT command.

                    After stopping the app, CPU cores go down to the usual 5-15 %

                    Anmerkung 2020-08-18 163519.png

                    1 Reply Last reply
                    0
                    • girishG Offline
                      girishG Offline
                      girish
                      Staff
                      wrote on last edited by girish
                      #13

                      @necrevistonnezr Do you think you can stop the existing nextcloud and then maybe clone from the latest backup and check if postgres is still using a lot of CPU? If it works out, maybe you can then just move stopped nextcloud into another domain and then put the cloned one there.

                      necrevistonnezrN 2 Replies Last reply
                      0
                      • girishG girish

                        @necrevistonnezr Do you think you can stop the existing nextcloud and then maybe clone from the latest backup and check if postgres is still using a lot of CPU? If it works out, maybe you can then just move stopped nextcloud into another domain and then put the cloned one there.

                        necrevistonnezrN Offline
                        necrevistonnezrN Offline
                        necrevistonnezr
                        wrote on last edited by necrevistonnezr
                        #14

                        @girish said in Nextcloud in Error state even though it's running (after Cloudron 5.5 update):

                        @necrevistonnezr Do you think you can stop the existing nextcloud and then maybe clone from the latest backup and check if postgres is still using a lot of CPU? If it works out, maybe you can then just move stopped nextcloud into another domain and then put the cloned one there.

                        Clone Nextcloud into another subdomain you mean? How do I do that?

                        EDIT: Found it.

                        1 Reply Last reply
                        0
                        • nebulonN Offline
                          nebulonN Offline
                          nebulon
                          Staff
                          wrote on last edited by
                          #15

                          What was the root cause if you found it?
                          On a side note postgres really gets hammered with SELECTs during for example a rescan of nextcloud files.

                          necrevistonnezrN 1 Reply Last reply
                          0
                          • nebulonN nebulon

                            What was the root cause if you found it?
                            On a side note postgres really gets hammered with SELECTs during for example a rescan of nextcloud files.

                            necrevistonnezrN Offline
                            necrevistonnezrN Offline
                            necrevistonnezr
                            wrote on last edited by
                            #16

                            @nebulon said in Nextcloud in Error state even though it's running (after Cloudron 5.5 update):

                            What was the root cause if you found it?
                            On a side note postgres really gets hammered with SELECTs during for example a rescan of nextcloud files.

                            I meant I found the cloning process, I haven't found the cause for the CPU spikes.
                            I'm trying go clone a backup to a new subdomain but I don't have enough free space to clone a 300 GB Nextcloud instance... 😞

                            1 Reply Last reply
                            0
                            • girishG girish

                              @necrevistonnezr Do you think you can stop the existing nextcloud and then maybe clone from the latest backup and check if postgres is still using a lot of CPU? If it works out, maybe you can then just move stopped nextcloud into another domain and then put the cloned one there.

                              necrevistonnezrN Offline
                              necrevistonnezrN Offline
                              necrevistonnezr
                              wrote on last edited by necrevistonnezr
                              #17

                              @girish said in Nextcloud in Error state even though it's running (after Cloudron 5.5 update):

                              @necrevistonnezr Do you think you can stop the existing nextcloud and then maybe clone from the latest backup and check if postgres is still using a lot of CPU? If it works out, maybe you can then just move stopped nextcloud into another domain and then put the cloned one there.

                              I did that now. Took 10 hours. Result is the same. 100 % CPU on Postgres on Nextcloud (app id 410c...). This is HUGELY frustrating. And I can't even login, it takes forever.

                              Clipboard01.jpg

                              1 Reply Last reply
                              0
                              • nebulonN Offline
                                nebulonN Offline
                                nebulon
                                Staff
                                wrote on last edited by
                                #18

                                For a start, do you have some nextcloud client running on your laptop or so? Maybe that fires requests like crazy and thus hammering postgres as a result?

                                1 Reply Last reply
                                0
                                • necrevistonnezrN Offline
                                  necrevistonnezrN Offline
                                  necrevistonnezr
                                  wrote on last edited by
                                  #19

                                  No, I switched off all clients on purpose - and after cloning to a new subdomain, there would be no connection, anyway.

                                  1 Reply Last reply
                                  0
                                  • nebulonN Offline
                                    nebulonN Offline
                                    nebulon
                                    Staff
                                    wrote on last edited by
                                    #20

                                    maybe some plugin causes this? Can you use the occ tool via terminal into the app to disable some?

                                    necrevistonnezrN 1 Reply Last reply
                                    0
                                    • nebulonN nebulon

                                      maybe some plugin causes this? Can you use the occ tool via terminal into the app to disable some?

                                      necrevistonnezrN Offline
                                      necrevistonnezrN Offline
                                      necrevistonnezr
                                      wrote on last edited by necrevistonnezr
                                      #21

                                      @nebulon said in Nextcloud in Error state even though it's running (after Cloudron 5.5 update):

                                      maybe some plugin causes this? Can you use the occ tool via terminal into the app to disable some?

                                      I think only the bare minimum is enabled....

                                      occ app:list
                                      Enabled:
                                        - accessibility: 1.5.0
                                        - activity: 2.12.0
                                        - admin_audit: 1.9.0
                                        - calendar: 2.0.3
                                        - cloud_federation_api: 1.2.0
                                        - comments: 1.9.0
                                        - contacts: 3.3.0
                                        - contactsinteraction: 1.0.0
                                        - dav: 1.15.0
                                        - encryption: 2.7.0
                                        - federatedfilesharing: 1.9.0
                                        - files: 1.14.0
                                        - files_external: 1.10.0
                                        - files_pdfviewer: 1.8.0
                                        - files_rightclick: 0.16.0
                                        - files_sharing: 1.11.0
                                        - files_trashbin: 1.9.0
                                        - files_versions: 1.12.0
                                        - files_videoplayer: 1.8.0
                                        - firstrunwizard: 2.8.0
                                        - logreader: 2.4.0
                                        - lookup_server_connector: 1.7.0
                                        - nextcloud_announcements: 1.8.0
                                        - notifications: 2.7.0
                                        - oauth2: 1.7.0
                                        - password_policy: 1.9.1
                                        - photos: 1.1.0
                                        - privacy: 1.3.0
                                        - provisioning_api: 1.9.0
                                        - recommendations: 0.7.0
                                        - serverinfo: 1.9.0
                                        - settings: 1.1.0
                                        - sharebymail: 1.9.0
                                        - spreed: 9.0.3
                                        - support: 1.2.1
                                        - systemtags: 1.9.0
                                        - text: 3.0.1
                                        - theming: 1.10.0
                                        - twofactor_backupcodes: 1.8.0
                                        - twofactor_totp: 4.1.3
                                        - updatenotification: 1.9.0
                                        - user_ldap: 1.9.0
                                        - viewer: 1.3.0
                                        - workflowengine: 2.1.0
                                      Disabled:
                                        - bookmarks
                                        - bruteforcesettings
                                        - documentserver_community
                                        - federation
                                        - mail
                                        - maps
                                        - ransomware_detection
                                        - survey_client
                                        - tasks
                                        - twofactor_admin
                                      
                                      1 Reply Last reply
                                      0
                                      • nebulonN Offline
                                        nebulonN Offline
                                        nebulon
                                        Staff
                                        wrote on last edited by
                                        #22

                                        This is very strange, since if noone accesses nextcloud there shouldn't be long-running processes accessing the database either.

                                        1 Reply Last reply
                                        0
                                        • necrevistonnezrN Offline
                                          necrevistonnezrN Offline
                                          necrevistonnezr
                                          wrote on last edited by
                                          #23

                                          To be clear: Postgres goes crazy if I try to login from a browser or a client...

                                          necrevistonnezrN 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