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


    Cloudron Forum

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

    Solved Nextcloud 20.0.2 not responding, key is duplicated

    Nextcloud
    3
    3
    275
    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.
    • C
      CarbonBee last edited by

      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,

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

        @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 Reply Quote 1
        • girish
          girish Staff last edited by

          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 Reply Quote 0
          • First post
            Last post
          Powered by NodeBB