search

nextcloud / social

🎉 Social can be used for work, or to connect to the fediverse!
https://apps.nextcloud.com/apps/social
GNU Affero General Public License v3.0
488 stars 59 forks source link

`cannot drop index oc_social_cache_actor_pkey because constraint oc_social_cache_actor_pkey on table oc_social_cache_actor requires it` #1768

Closed skjnldsv closed 1 year ago

skjnldsv commented 1 year ago

@artonge @ArtificialOwl 

{
  "reqId": "mZAaI1AYQwBCXyoxSz2d",
  "level": 3,
  "time": "2023-05-26T06:31:19+00:00",
  "remoteAddr": "xxx.xxx.xxx.xxx",
  "user": "xxxxxxxxxxxxxx",
  "app": "settings",
  "method": "POST",
  "url": "/index.php/settings/apps/enable",
  "message": "could not enable apps",
  "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36",
  "version": "27.0.0.5",
  "exception": {
    "Exception": "Exception",
    "Message": "Database error when running migration 1000Date20230217000001 for app social\nAn exception occurred while executing a query: SQLSTATE[2BP01]: Dependent objects still exist: 7 ERROR:  cannot drop index oc_social_cache_actor_pkey because constraint oc_social_cache_actor_pkey on table oc_social_cache_actor requires it\nHINT:  You can drop constraint oc_social_cache_actor_pkey on table oc_social_cache_actor instead.",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/pwet.nextcloud.com/lib/private/Installer.php",
        "line": 153,
        "function": "migrate",
        "class": "OC\\DB\\MigrationService",
        "type": "->"
      },
      {
        "file": "/var/www/pwet.nextcloud.com/apps/settings/lib/Controller/AppSettingsController.php",
        "line": 451,
        "function": "installApp",
        "class": "OC\\Installer",
        "type": "->"
      },
      {
        "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 230,
        "function": "enableApps",
        "class": "OCA\\Settings\\Controller\\AppSettingsController",
        "type": "->"
      },
      {
        "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 137,
        "function": "executeController",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->"
      },
      {
        "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/App.php",
        "line": 183,
        "function": "dispatch",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->"
      },
      {
        "file": "/var/www/pwet.nextcloud.com/lib/private/Route/Router.php",
        "line": 315,
        "function": "main",
        "class": "OC\\AppFramework\\App",
        "type": "::"
      },
      {
        "file": "/var/www/pwet.nextcloud.com/lib/base.php",
        "line": 1064,
        "function": "match",
        "class": "OC\\Route\\Router",
        "type": "->"
      },
      {
        "file": "/var/www/pwet.nextcloud.com/index.php",
        "line": 36,
        "function": "handleRequest",
        "class": "OC",
        "type": "::"
      }
    ],
    "File": "/var/www/pwet.nextcloud.com/lib/private/DB/MigrationService.php",
    "Line": 421,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Exception\\DriverException",
      "Message": "An exception occurred while executing a query: SQLSTATE[2BP01]: Dependent objects still exist: 7 ERROR:  cannot drop index oc_social_cache_actor_pkey because constraint oc_social_cache_actor_pkey on table oc_social_cache_actor requires it\nHINT:  You can drop constraint oc_social_cache_actor_pkey on table oc_social_cache_actor instead.",
      "Code": 7,
      "Trace": [
        {
          "file": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1814,
          "function": "convert",
          "class": "Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1749,
          "function": "handleDriverException",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1055,
          "function": "convertExceptionDuringQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Connection.php",
          "line": 262,
          "function": "executeQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1843,
          "function": "executeQuery",
          "class": "OC\\DB\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Migrator.php",
          "line": 162,
          "function": "query",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Migrator.php",
          "line": 68,
          "function": "applySchema",
          "class": "OC\\DB\\Migrator",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Connection.php",
          "line": 589,
          "function": "migrate",
          "class": "OC\\DB\\Migrator",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/DB/MigrationService.php",
          "line": 532,
          "function": "migrateToSchema",
          "class": "OC\\DB\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/DB/MigrationService.php",
          "line": 417,
          "function": "executeStep",
          "class": "OC\\DB\\MigrationService",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/Installer.php",
          "line": 153,
          "function": "migrate",
          "class": "OC\\DB\\MigrationService",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/apps/settings/lib/Controller/AppSettingsController.php",
          "line": 451,
          "function": "installApp",
          "class": "OC\\Installer",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/Http/Dispatcher.php",
          "line": 230,
          "function": "enableApps",
          "class": "OCA\\Settings\\Controller\\AppSettingsController",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/Http/Dispatcher.php",
          "line": 137,
          "function": "executeController",
          "class": "OC\\AppFramework\\Http\\Dispatcher",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/App.php",
          "line": 183,
          "function": "dispatch",
          "class": "OC\\AppFramework\\Http\\Dispatcher",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/private/Route/Router.php",
          "line": 315,
          "function": "main",
          "class": "OC\\AppFramework\\App",
          "type": "::"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/lib/base.php",
          "line": 1064,
          "function": "match",
          "class": "OC\\Route\\Router",
          "type": "->"
        },
        {
          "file": "/var/www/pwet.nextcloud.com/index.php",
          "line": 36,
          "function": "handleRequest",
          "class": "OC",
          "type": "::"
        }
      ],
      "File": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php",
      "Line": 91,
      "Previous": {
        "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
        "Message": "SQLSTATE[2BP01]: Dependent objects still exist: 7 ERROR:  cannot drop index oc_social_cache_actor_pkey because constraint oc_social_cache_actor_pkey on table oc_social_cache_actor requires it\nHINT:  You can drop constraint oc_social_cache_actor_pkey on table oc_social_cache_actor instead.",
        "Code": 7,
        "Trace": [
          {
            "file": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
            "line": 77,
            "function": "new",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
            "type": "::"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1050,
            "function": "query",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Connection.php",
            "line": 262,
            "function": "executeQuery",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1843,
            "function": "executeQuery",
            "class": "OC\\DB\\Connection",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Migrator.php",
            "line": 162,
            "function": "query",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Migrator.php",
            "line": 68,
            "function": "applySchema",
            "class": "OC\\DB\\Migrator",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Connection.php",
            "line": 589,
            "function": "migrate",
            "class": "OC\\DB\\Migrator",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/DB/MigrationService.php",
            "line": 532,
            "function": "migrateToSchema",
            "class": "OC\\DB\\Connection",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/DB/MigrationService.php",
            "line": 417,
            "function": "executeStep",
            "class": "OC\\DB\\MigrationService",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/Installer.php",
            "line": 153,
            "function": "migrate",
            "class": "OC\\DB\\MigrationService",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/apps/settings/lib/Controller/AppSettingsController.php",
            "line": 451,
            "function": "installApp",
            "class": "OC\\Installer",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/Http/Dispatcher.php",
            "line": 230,
            "function": "enableApps",
            "class": "OCA\\Settings\\Controller\\AppSettingsController",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/Http/Dispatcher.php",
            "line": 137,
            "function": "executeController",
            "class": "OC\\AppFramework\\Http\\Dispatcher",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/App.php",
            "line": 183,
            "function": "dispatch",
            "class": "OC\\AppFramework\\Http\\Dispatcher",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/private/Route/Router.php",
            "line": 315,
            "function": "main",
            "class": "OC\\AppFramework\\App",
            "type": "::"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/lib/base.php",
            "line": 1064,
            "function": "match",
            "class": "OC\\Route\\Router",
            "type": "->"
          },
          {
            "file": "/var/www/pwet.nextcloud.com/index.php",
            "line": 36,
            "function": "handleRequest",
            "class": "OC",
            "type": "::"
          }
        ],
        "File": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
        "Line": 30,
        "Previous": {
          "Exception": "PDOException",
          "Message": "SQLSTATE[2BP01]: Dependent objects still exist: 7 ERROR:  cannot drop index oc_social_cache_actor_pkey because constraint oc_social_cache_actor_pkey on table oc_social_cache_actor requires it\nHINT:  You can drop constraint oc_social_cache_actor_pkey on table oc_social_cache_actor instead.",
          "Code": "2BP01",
          "Trace": [
            {
              "file": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
              "line": 72,
              "function": "query",
              "class": "PDO",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Connection.php",
              "line": 1050,
              "function": "query",
              "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Connection.php",
              "line": 262,
              "function": "executeQuery",
              "class": "Doctrine\\DBAL\\Connection",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Connection.php",
              "line": 1843,
              "function": "executeQuery",
              "class": "OC\\DB\\Connection",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Migrator.php",
              "line": 162,
              "function": "query",
              "class": "Doctrine\\DBAL\\Connection",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Migrator.php",
              "line": 68,
              "function": "applySchema",
              "class": "OC\\DB\\Migrator",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/DB/Connection.php",
              "line": 589,
              "function": "migrate",
              "class": "OC\\DB\\Migrator",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/DB/MigrationService.php",
              "line": 532,
              "function": "migrateToSchema",
              "class": "OC\\DB\\Connection",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/DB/MigrationService.php",
              "line": 417,
              "function": "executeStep",
              "class": "OC\\DB\\MigrationService",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/Installer.php",
              "line": 153,
              "function": "migrate",
              "class": "OC\\DB\\MigrationService",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/apps/settings/lib/Controller/AppSettingsController.php",
              "line": 451,
              "function": "installApp",
              "class": "OC\\Installer",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/Http/Dispatcher.php",
              "line": 230,
              "function": "enableApps",
              "class": "OCA\\Settings\\Controller\\AppSettingsController",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/Http/Dispatcher.php",
              "line": 137,
              "function": "executeController",
              "class": "OC\\AppFramework\\Http\\Dispatcher",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/AppFramework/App.php",
              "line": 183,
              "function": "dispatch",
              "class": "OC\\AppFramework\\Http\\Dispatcher",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/private/Route/Router.php",
              "line": 315,
              "function": "main",
              "class": "OC\\AppFramework\\App",
              "type": "::"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/lib/base.php",
              "line": 1064,
              "function": "match",
              "class": "OC\\Route\\Router",
              "type": "->"
            },
            {
              "file": "/var/www/pwet.nextcloud.com/index.php",
              "line": 36,
              "function": "handleRequest",
              "class": "OC",
              "type": "::"
            }
          ],
          "File": "/var/www/pwet.nextcloud.com/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
          "Line": 72
        }
      }
    },
    "message": "could not enable apps",
    "exception": {},
    "CustomMessage": "could not enable apps"
  }
}