WebDAV Problem keine Verbindung mehr

🌐 Non-english support 🇩🇪 Deutsch (german)
, ,
1

Hallo Leute,

ich brauch mal bitte eure Hilfe. Ich sichere mein Handy mit Swift Backup in die Nextcloud.

Seit 2 Tagen sichert er aber nicht mehr und nun sehe ich das im NC Protokoll:

[webdav] Fehler: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[XX002]: Index corrupted: 7 ERROR: heap tid from index tuple (157,22) points past end of heap page line pointer array at offset 211 of block 74 in index “oc_filecache_pkey” at <>

  1. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1814
    Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert(["Doctrine\DBAL … "], [“Doctrine\DBAL\Query”])
  2. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1749
    Doctrine\DBAL\Connection->handleDriverException(["Doctrine\DBAL … "], [“Doctrine\DBAL\Query”])
  3. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1163
    Doctrine\DBAL\Connection->convertExceptionDuringQuery(["Doctrine\DBAL … "], “INSERT INTO "o … )”, [5,11,1710676537 … "], [2,2,2,2,2,"And … "])
  4. /var/www/html/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement(“INSERT INTO "o … )”, [5,11,1710676537 … "], [2,2,2,2,2,"And … "])
  5. /var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement(“INSERT INTO "o … )”, [5,11,1710676537 … "], [2,2,2,2,2,"And … "])
  6. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
  7. /var/www/html/lib/private/Files/Cache/Cache.php line 315
    OC\DB\QueryBuilder\QueryBuilder->execute()
  8. /var/www/html/lib/private/Files/Cache/Scanner.php line 307
    OC\Files\Cache\Cache->insert(“*** sensitive parameters replaced ***”, ["application/oc … "])
  9. /var/www/html/lib/private/Files/Cache/Scanner.php line 240
    OC\Files\Cache\Scanner->addToCache(“*** sensitive parameters replaced ***”, ["application/oc … "], -1)
  10. /var/www/html/lib/private/Files/Cache/Scanner.php line 352
    OC\Files\Cache\Scanner->scanFile(“*** sensitive parameters replaced ***”, 3, 66295, false, false)
  11. /var/www/html/lib/private/Files/Cache/Updater.php line 130
    OC\Files\Cache\Scanner->scan(“*** sensitive parameters replaced ***”, false, 3, false)
  12. /var/www/html/apps/dav/lib/Connector/Sabre/File.php line 368
    OC\Files\Cache\Updater->update(“*** sensitive parameters replaced ***”)
  13. /var/www/html/apps/dav/lib/Connector/Sabre/Directory.php line 149
    OCA\DAV\Connector\Sabre\File->put(“*** sensitive parameters replaced ***”)
  14. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 1098
    OCA\DAV\Connector\Sabre\Directory->createFile(“*** sensitive parameters replaced ***”)
  15. /var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 504
    Sabre\DAV\Server->createFile(“*** sensitive parameters replaced ***”)
  16. /var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpPut([“Sabre\HTTP\Request”], [“Sabre\HTTP\Response”])
  17. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit(“method:PUT”, [["Sabre\HTTP\ … ]])
  18. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod([“Sabre\HTTP\Request”], [“Sabre\HTTP\Response”])
  19. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
  20. /var/www/html/apps/dav/lib/Server.php line 368
    Sabre\DAV\Server->exec()
  21. /var/www/html/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
  22. /var/www/html/remote.php line 172
    require_once(“/var/www/html/a … p”)

Caused by:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[XX002]: Index corrupted: 7 ERROR: heap tid from index tuple (157,22) points past end of heap page line pointer array at offset 211 of block 74 in index “oc_filecache_pkey” at <>

  1. /var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 103
    Doctrine\DBAL\Driver\PDO\Exception::new([“PDOException”, … ]])
  2. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
  3. /var/www/html/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement(“INSERT INTO "o … )”, [5,11,1710676537 … "], [2,2,2,2,2,"And … "])
  4. /var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement(“INSERT INTO "o … )”, [5,11,1710676537 … "], [2,2,2,2,2,"And … "])
  5. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
  6. /var/www/html/lib/private/Files/Cache/Cache.php line 315
    OC\DB\QueryBuilder\QueryBuilder->execute()
  7. /var/www/html/lib/private/Files/Cache/Scanner.php line 307
    OC\Files\Cache\Cache->insert(“*** sensitive parameters replaced ***”, ["application/oc … "])
  8. /var/www/html/lib/private/Files/Cache/Scanner.php line 240
    OC\Files\Cache\Scanner->addToCache(“*** sensitive parameters replaced ***”, ["application/oc … "], -1)
  9. /var/www/html/lib/private/Files/Cache/Scanner.php line 352
    OC\Files\Cache\Scanner->scanFile(“*** sensitive parameters replaced ***”, 3, 66295, false, false)
  10. /var/www/html/lib/private/Files/Cache/Updater.php line 130
    OC\Files\Cache\Scanner->scan(“*** sensitive parameters replaced ***”, false, 3, false)
  11. /var/www/html/apps/dav/lib/Connector/Sabre/File.php line 368
    OC\Files\Cache\Updater->update(“*** sensitive parameters replaced ***”)
  12. /var/www/html/apps/dav/lib/Connector/Sabre/Directory.php line 149
    OCA\DAV\Connector\Sabre\File->put(“*** sensitive parameters replaced ***”)
  13. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 1098
    OCA\DAV\Connector\Sabre\Directory->createFile(“*** sensitive parameters replaced ***”)
  14. /var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 504
    Sabre\DAV\Server->createFile(“*** sensitive parameters replaced ***”)
  15. /var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpPut([“Sabre\HTTP\Request”], [“Sabre\HTTP\Response”])
  16. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit(“method:PUT”, [["Sabre\HTTP\ … ]])
  17. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod([“Sabre\HTTP\Request”], [“Sabre\HTTP\Response”])
  18. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
  19. /var/www/html/apps/dav/lib/Server.php line 368
    Sabre\DAV\Server->exec()
  20. /var/www/html/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
  21. /var/www/html/remote.php line 172
    require_once(“/var/www/html/a … p”)

Caused by:

PDOException: SQLSTATE[XX002]: Index corrupted: 7 ERROR: heap tid from index tuple (157,22) points past end of heap page line pointer array at offset 211 of block 74 in index “oc_filecache_pkey” at <>

  1. /var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 101
    PDOStatement->execute(“*** sensitive parameters replaced ***”)
  2. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
  3. /var/www/html/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement(“INSERT INTO "o … )”, [5,11,1710676537 … "], [2,2,2,2,2,"And … "])
  4. /var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement(“INSERT INTO "o … )”, [5,11,1710676537 … "], [2,2,2,2,2,"And … "])
  5. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
  6. /var/www/html/lib/private/Files/Cache/Cache.php line 315
    OC\DB\QueryBuilder\QueryBuilder->execute()
  7. /var/www/html/lib/private/Files/Cache/Scanner.php line 307
    OC\Files\Cache\Cache->insert(“*** sensitive parameters replaced ***”, ["application/oc … "])
  8. /var/www/html/lib/private/Files/Cache/Scanner.php line 240
    OC\Files\Cache\Scanner->addToCache(“*** sensitive parameters replaced ***”, ["application/oc … "], -1)
  9. /var/www/html/lib/private/Files/Cache/Scanner.php line 352
    OC\Files\Cache\Scanner->scanFile(“*** sensitive parameters replaced ***”, 3, 66295, false, false)
  10. /var/www/html/lib/private/Files/Cache/Updater.php line 130
    OC\Files\Cache\Scanner->scan(“*** sensitive parameters replaced ***”, false, 3, false)
  11. /var/www/html/apps/dav/lib/Connector/Sabre/File.php line 368
    OC\Files\Cache\Updater->update(“*** sensitive parameters replaced ***”)
  12. /var/www/html/apps/dav/lib/Connector/Sabre/Directory.php line 149
    OCA\DAV\Connector\Sabre\File->put(“*** sensitive parameters replaced ***”)
  13. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 1098
    OCA\DAV\Connector\Sabre\Directory->createFile(“*** sensitive parameters replaced ***”)
  14. /var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 504
    Sabre\DAV\Server->createFile(“*** sensitive parameters replaced ***”)
  15. /var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpPut([“Sabre\HTTP\Request”], [“Sabre\HTTP\Response”])
  16. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 472
    Sabre\DAV\Server->emit(“method:PUT”, [["Sabre\HTTP\ … ]])
  17. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod([“Sabre\HTTP\Request”], [“Sabre\HTTP\Response”])
  18. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
  19. /var/www/html/apps/dav/lib/Server.php line 368
    Sabre\DAV\Server->exec()
  20. /var/www/html/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
  21. /var/www/html/remote.php line 172
    require_once(“/var/www/html/a … p”)

Habe die Verbindung in SwiftBackup beendet und kann sie nun auch nicht mehr neu herstellen.

Vielleicht wisst ihr ja weiter

Zum System:

Neuste NextCloud AIO als Container aufm Pi4 mit SSD

2

die Fehlermeldung deutet auf ein Problem mit dem DB Index. Da du das Support Template ignoriert hast kann kann ich nur raten dass du Postgres verwendest database indexes - How to fix PostgreSQL errors telling tid from new index tuple overlaps with invalid duplicate tuple? - Stack Overflow. Ich würde in den Foren/Docs der Datenbank schauen wie man ein Index reparieren/neu erstellen kann.

Ein Index geht nicht “einfach so” Kaputt vermutlich gab ein Problem/Ausfall auf dem DB server - ich würde auch die Datenbank selbst prüfen.

3

Das wusste ich nicht wie ich das in der AIO umsetzen soll … Habs mit dem Borg Backup probiert und von vor 3 Tagen nen Backup eingespielt.

Scheint zu laufen.

Denke aber wahrscheinlich, das Problem war habe meinen Papierkorb im Dashboard geleert und dabei hatte sich der Pi verabschiedet. Wird wohl was zerschossen haben

Edit: 10 Min später ohne Änderung selbes Problem. Neustart der Container, melden nun auch den Fehler:

System config value dbpersistent set to boolean false
System config value files_external_allow_create_new_local set to boolean false
In ExceptionConverter.php line 91:

An exception occurred while executing a query: SQLSTATE[XX002]: Index corru
pted: 7 ERROR: heap tid from index tuple (157,22) points past end of heap
page line pointer array at offset 15 of block 74 in index “oc_filecache_pke
y”

In Exception.php line 30:

SQLSTATE[XX002]: Index corrupted: 7 ERROR: heap tid from index tuple (157,
22) points past end of heap page line pointer array at offset 15 of block 7
4 in index “oc_filecache_pkey”

In Statement.php line 101:

SQLSTATE[XX002]: Index corrupted: 7 ERROR: heap tid from index tuple (157,
22) points past end of heap page line pointer array at offset 15 of block 7
4 in index “oc_filecache_pkey”

app:update [–all] [–showonly] [–allow-unstable] [–] []
System config value trusted_proxies => 0 set to string 127.0.0.1
System config value trusted_proxies => 1 set to string ::1
Config value base_endpoint for app notify_push set to https://xxx.de/push
In ExceptionConverter.php line 91:

An exception occurred while executing a query: SQLSTATE[XX002]: Index corru
pted: 7 ERROR: heap tid from index tuple (157,22) points past end of heap
page line pointer array at offset 15 of block 74 in index “oc_filecache_pke
y”

In Exception.php line 30:

SQLSTATE[XX002]: Index corrupted: 7 ERROR: heap tid from index tuple (157,
22) points past end of heap page line pointer array at offset 15 of block 7
4 in index “oc_filecache_pkey”

In Statement.php line 101:

SQLSTATE[XX002]: Index corrupted: 7 ERROR: heap tid from index tuple (157,
22) points past end of heap page line pointer array at offset 15 of block 7
4 in index “oc_filecache_pkey”

Und am Ende nen Internal Server Error 500 über Webseite und App aufm Handy, aber die NextCloud App aufm PC ist erfolgreich verbunden.

4

So da alles nichts geklappt hat, habe ich neuinstalliert