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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
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

Cloudron Forum

Apps | Demo | Docs | Install

Nextcloud 20.0.2 not responding, key is duplicated

Scheduled Pinned Locked Moved Solved Nextcloud
3 Posts 3 Posters 285 Views
    • 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.
  • C Offline
    C Offline
    CarbonBee
    wrote on last edited by
    #1

    Hi,

    I just updated my NextCloud to 20.0.2, and it's not responding.

    Logs said :

    Nov 30 08:17:29 Check primary keys.
    Nov 30 08:17:29 Adding primary key to the filecache_extended table, this can take some time...
    Nov 30 08:17:29
    Nov 30 08:17:29 In AbstractPostgreSQLDriver.php line 51:
    Nov 30 08:17:29
    Nov 30 08:17:29 An exception occurred while executing 'ALTER TABLE oc_filecache_extended AD
    Nov 30 08:17:29 D PRIMARY KEY (fileid)':
    Nov 30 08:17:29
    Nov 30 08:17:29 SQLSTATE[23505]: Unique violation: 7 ERROR: could not create unique index
    Nov 30 08:17:29 "oc_filecache_extended_pkey"
    Nov 30 08:17:29 DETAIL: Key (fileid)=(169141) is duplicated.
    Nov 30 08:17:29
    Nov 30 08:17:29
    Nov 30 08:17:29 In PDOConnection.php line 83:
    Nov 30 08:17:29
    Nov 30 08:17:29 SQLSTATE[23505]: Unique violation: 7 ERROR: could not create unique index
    Nov 30 08:17:29 "oc_filecache_extended_pkey"
    Nov 30 08:17:29 DETAIL: Key (fileid)=(169141) is duplicated.
    Nov 30 08:17:29
    Nov 30 08:17:29
    Nov 30 08:17:29 In PDOConnection.php line 78:
    Nov 30 08:17:29
    Nov 30 08:17:29 SQLSTATE[23505]: Unique violation: 7 ERROR: could not create unique index
    Nov 30 08:17:29 "oc_filecache_extended_pkey"
    Nov 30 08:17:29 DETAIL: Key (fileid)=(169141) is duplicated.
    Nov 30 08:17:29
    Nov 30 08:17:29
    Nov 30 08:17:29 db:add-missing-primary-keys
    

    And it's restarting every minutes.
    Could someone help me on that?

    Thanks,

    nebulonN 1 Reply Last reply
    0
  • nebulonN Offline
    nebulonN Offline
    nebulon Staff
    replied to CarbonBee on last edited by
    #2

    @carbonbee Nextcloud is incredibly flaky when it comes to updates. I assume some plugin is causing that....

    You may have to write to us on support and enable SSH access to your Cloudron so we can take a closer look. Usually the steps are something like putting the app in debug/maintenance mode from Cloudron side, then get a webterminal into the app, disable all non-core plugins, try to fixup the database then get nextcloud without plugins to work, then see if those disabled plugins may need updates and hopefully things start to work again.

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

    So @nebulon has a workaround here - https://forum.cloudron.io/topic/3827/nextcloud-update-to-20-0-2-failed/8 . We are fixing the package accordingly.

    1 Reply Last reply
    0

  • Login

  • Don't have an account? Register

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

  • Don't have an account? Register

  • Login or register to search.