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


Navigation

    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    SOLVED Nextcloud Key is duplicated still after Update

    Nextcloud
    3
    3
    35
    Loading More Posts
    • 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.
    • S
      smilebasti last edited by

      Hi,
      i got the overnight Update of my Nextcloud. Now i have the following duplicate Key Error:

      Dec 14 10:59:07 => Applying oc_filecache_extended workaround
      Dec 14 10:59:07 SELECT 9852
      Dec 14 10:59:07 ALTER TABLE
      Dec 14 10:59:07 ALTER TABLE
      Dec 14 10:59:07 DROP TABLE
      Dec 14 10:59:07 Check primary keys.
      Dec 14 10:59:08 Adding primary key to the filecache_extended table, this can take some time...
      
      Dec 14 10:59:09 In AbstractPostgreSQLDriver.php line 51:
      Dec 14 10:59:09
      Dec 14 10:59:09 An exception occurred while executing 'ALTER TABLE oc_filecache_extended AD
      Dec 14 10:59:09 D PRIMARY KEY (fileid)':
      Dec 14 10:59:09
      Dec 14 10:59:09 SQLSTATE[23505]: Unique violation: 7 ERROR: could not create unique index
      Dec 14 10:59:09 "oc_filecache_extended_pkey"
      Dec 14 10:59:09 DETAIL: Key (fileid)=(35050) is duplicated.
      
      Dec 14 10:59:09 In PDOConnection.php line 83:
      Dec 14 10:59:09
      Dec 14 10:59:09 SQLSTATE[23505]: Unique violation: 7 ERROR: could not create unique index
      Dec 14 10:59:09 "oc_filecache_extended_pkey"
      Dec 14 10:59:09 DETAIL: Key (fileid)=(35050) is duplicated.
      
      Dec 14 10:59:09 In PDOConnection.php line 78:
      Dec 14 10:59:09
      Dec 14 10:59:09 SQLSTATE[23505]: Unique violation: 7 ERROR: could not create unique index
      Dec 14 10:59:09 "oc_filecache_extended_pkey"
      Dec 14 10:59:09 DETAIL: Key (fileid)=(35050) is duplicated.
      
      Dec 14 10:59:09 db:add-missing-primary-keys
      

      I just did the latest update manualy but i didn't fix anything. Also i tried restarting Cloudron with Nextcloud in Recovery Mode as mentioned in a different Issue.

      Cloudron is now 6.0.1 and Nextcloud is now 20.0.3 with the Packaged version v4.8.3

      Thanks ahead for your help

      girish 1 Reply Last reply Reply Quote 0
      • girish
        girish Staff @smilebasti last edited by

        @smilebasti Oh, this new package was intending to fix exactly this issue (https://git.cloudron.io/cloudron/nextcloud-app/-/commit/47070946b19792dab4347751f0d6384c677836a2). Can you please send me a mail to support@cloudron.io, so I can take a look at why it's failing? Thanks!

        (cc @nebulon )

        1 Reply Last reply Reply Quote 0
        • nebulon
          nebulon Staff last edited by

          Fixed now with the latest app package.

          1 Reply Last reply Reply Quote 1
          • First post
            Last post