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 - update to 20.0.2 failed

Nextcloud - update to 20.0.2 failed

Scheduled Pinned Locked Moved Solved Nextcloud
9 Posts 3 Posters 1.6k 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.
  • D Offline
    D Offline
    Dimitri Veny
    wrote on last edited by
    #1

    Our nextcloud instance made an update to 20.0.2
    The migration script is failing...
    Add primary key to the filecache_extended table
    --> can't add primary key on fileid

    The server is in a deadloop where the migration script is launched

    We need to get our instance back
    Help would be really appreciated

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

      Hi there,

      indeed you are not the first one to hit this. Unfortunately some Nextcloud instances for some so far unknown reason created duplicate file ids in the database and the latest version requires a primary key on those (meaning also that they have to be unique)

      I saw that you contacted us on support with SSH enabled, I will take a look to see if we can find a solution besides restoring the app instance to the previous version.

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

        Seems the same as https://forum.cloudron.io/topic/3817/nextcloud-20-0-2-not-responding-key-is-duplicated

        D 1 Reply Last reply
        0
        • girishG girish

          Seems the same as https://forum.cloudron.io/topic/3817/nextcloud-20-0-2-not-responding-key-is-duplicated

          D Offline
          D Offline
          Dimitri Veny
          wrote on last edited by
          #4

          @girish Thanks but how can we have this settled ?
          I have already sent an email to support
          What's their usual reponse time ?

          girishG 1 Reply Last reply
          0
          • D Dimitri Veny

            @girish Thanks but how can we have this settled ?
            I have already sent an email to support
            What's their usual reponse time ?

            girishG Offline
            girishG Offline
            girish
            Staff
            wrote on last edited by
            #5

            @dimitri-veny We try to respond as quickly as we can. Not sure which plan you are on, but we only have priority support for the paid plans - https://www.cloudron.io/pricing.html

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

              https://github.com/nextcloud/server/issues/19494 seems to be a similar upstream issue.

              1 Reply Last reply
              0
              • D Dimitri Veny

                Our nextcloud instance made an update to 20.0.2
                The migration script is failing...
                Add primary key to the filecache_extended table
                --> can't add primary key on fileid

                The server is in a deadloop where the migration script is launched

                We need to get our instance back
                Help would be really appreciated

                girishG Offline
                girishG Offline
                girish
                Staff
                wrote on last edited by
                #7

                @dimitri-veny Just a heads up, we are close to a solution.

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

                  So it looks like the following SQL snippet will fixup that table and then lets Nextcloud create that primary key and thus be up and running again:

                  CREATE TABLE foobar AS SELECT fileid, metadata_etag, creation_time, MAX(upload_time) AS upload_time FROM oc_filecache_extended GROUP BY fileid, metadata_etag, creation_time;
                  DROP TABLE oc_filecache_extended;
                  ALTER TABLE foobar RENAME TO oc_filecache_extended;
                  

                  I will try to test this on another instance first and then we make a new app package with that fix for others.

                  @Dimitri-Veny can you please report if your instance works as expected?

                  D 1 Reply Last reply
                  0
                  • nebulonN nebulon

                    So it looks like the following SQL snippet will fixup that table and then lets Nextcloud create that primary key and thus be up and running again:

                    CREATE TABLE foobar AS SELECT fileid, metadata_etag, creation_time, MAX(upload_time) AS upload_time FROM oc_filecache_extended GROUP BY fileid, metadata_etag, creation_time;
                    DROP TABLE oc_filecache_extended;
                    ALTER TABLE foobar RENAME TO oc_filecache_extended;
                    

                    I will try to test this on another instance first and then we make a new app package with that fix for others.

                    @Dimitri-Veny can you please report if your instance works as expected?

                    D Offline
                    D Offline
                    Dimitri Veny
                    wrote on last edited by
                    #9

                    @nebulon thanks a lot for your help !!
                    Really appreciated..
                    I confirm that our instance works correctly now 👍

                    1 Reply Last reply
                    1
                    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