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 Key is duplicated still after Update

Nextcloud Key is duplicated still after Update

Scheduled Pinned Locked Moved Solved Nextcloud
3 Posts 3 Posters 561 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.
  • S Offline
    S Offline
    smilebasti
    wrote on last edited by
    #1

    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

    girishG 1 Reply Last reply
    0
    • S smilebasti

      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

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

      @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
      0
      • nebulonN Offline
        nebulonN Offline
        nebulon
        Staff
        wrote on last edited by
        #3

        Fixed now with the latest app package.

        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