You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This happens only in combination with external storage.
I have two external storage, one a SMB Share and one local external storage (onedrive folder 500GB)
same issue like #75 (comment)
but only in combination with external storage
Steps to reproduce:
add an external storage (local folder or smb)
Create a hidden tag, e.g. "Folder documents"
Assign this tag to a folder within the external storage
Create a rule: Assign tag "document" when file system tag is "folder documents"
Now do a occ files:scan --all (or just the affected folder)
When I delete the automated tagging rule, the scan works without problems. Or when i remove the hidden tag from the folder.
Expected behaviour
files:scan should finish without problems.
Actual behaviour
I get an error:
#sudo -u www-data php -f /var/www/nextcloud/occ files:scan --all
Starting scan for user 1 out of 8 (xxxxxxx)
Exception during scan: An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1780): Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1719): Doctrine\DBAL\Connection->handleDriverException()
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1067): Doctrine\DBAL\Connection->convertExceptionDuringQuery()
#3 /var/www/nextcloud/lib/private/DB/Connection.php(261): Doctrine\DBAL\Connection->executeQuery()
#4 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery()
#5 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/nextcloud/lib/private/Files/Cache/Cache.php(493): OC\DB\QueryBuilder\QueryBuilder->execute()
#7 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(389): OC\Files\Cache\Cache->getId()
#8 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(394): OC\Files\Cache\Scanner->scanChildren()
#9 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(394): OC\Files\Cache\Scanner->scanChildren()
#10 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(342): OC\Files\Cache\Scanner->scanChildren()
#11 /var/www/nextcloud/lib/private/Files/Utils/Scanner.php(256): OC\Files\Cache\Scanner->scan()
#12 /var/www/nextcloud/apps/files/lib/Command/Scan.php(161): OC\Files\Utils\Scanner->scan()
#13 /var/www/nextcloud/apps/files/lib/Command/Scan.php(217): OCA\Files\Command\Scan->scanFiles()
#14 /var/www/nextcloud/apps/recognize/vendor/symfony/console/Command/Command.php(298): OCA\Files\Command\Scan->execute()
#15 /var/www/nextcloud/core/Command/Base.php(177): Symfony\Component\Console\Command\Command->run()
#16 /var/www/nextcloud/apps/recognize/vendor/symfony/console/Application.php(1040): OC\Core\Command\Base->run()
#17 /var/www/nextcloud/apps/recognize/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#18 /var/www/nextcloud/apps/recognize/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#19 /var/www/nextcloud/lib/private/Console/Application.php(214): Symfony\Component\Console\Application->run()
#20 /var/www/nextcloud/console.php(100): OC\Console\Application->run()
#21 /var/www/nextcloud/occ(11): require_once('...')
#22 {main}
in the PostgreSQL log i can this:
2023-03-30 14:14:18.615 CEST [1261593] nextclouduser@nextcloud_db FEHLER: doppelter Schlüsselwert verletzt Unique-Const raint »oc_systemtag_object_mapping_pkey«
2023-03-30 14:14:18.615 CEST [1261593] nextclouduser@nextcloud_db DETAIL: Schlüssel »(objecttype, objectid, systemtagid )=(files, 43734, 9)« existiert bereits.
2023-03-30 14:14:18.615 CEST [1261593] nextclouduser@nextcloud_db ANWEISUNG: INSERT INTO "oc_systemtag_object_mapping" ("objectid", "objecttype", "systemtagid") VALUES($1, $2, $3)
2023-03-30 14:14:18.617 CEST [1261593] nextclouduser@nextcloud_db FEHLER: aktuelle Transaktion wurde abgebrochen, Befeh le werden bis zum Ende der Transaktion ignoriert
2023-03-30 14:14:18.617 CEST [1261593] nextclouduser@nextcloud_db ANWEISUNG: SELECT "fileid" FROM "oc_filecache" WHERE ("storage" = $1) AND ("path_hash" = $2)
I believe my company is experiencing this issue as well. I have written about it on Nextcloud's forums, but so far no response. We are using AIO for our deployment.
This happens only in combination with external storage.
I have two external storage, one a SMB Share and one local external storage (onedrive folder 500GB)
same issue like #75 (comment)
but only in combination with external storage
Steps to reproduce:
When I delete the automated tagging rule, the scan works without problems. Or when i remove the hidden tag from the folder.
Expected behaviour
files:scan should finish without problems.
Actual behaviour
I get an error:
in the PostgreSQL log i can this:
Server configuration
Operating system: Ubuntu 22.04.2 LTS (Jammy Jellyfish)
Web server: nginx/1.23.3
Database: postgres (PostgreSQL) 15.2 (Ubuntu 15.2-1.pgdg22.04+1)
PHP version: PHP 8.1.2-1ubuntu2.11
Nextcloud version: Nextcloud 25.0.5 Version
Where did you install Nextcloud from: https://download.nextcloud.com/server/releases/latest.tar.bz2
Signing status:
No errors have been found.
List of activated apps:
Nextcloud configuration:
Are you using external storage, if yes which one: local storage and smb
**No encryption
**No LDAP/ActiveDirectory/Webdav/...
Logs
Nextcloud log (data/owncloud.log)
due to sensitive data, i can sent it via mail.
The text was updated successfully, but these errors were encountered: