`files_external:scan` fails when an external storage returns an ETag longer than 40 characters
Open
Nobody has claimed this yet.
1. to develop
31-feedback
bug
feature: database
feature: external storage
feature: filesystem
feature: object storage
- Dominant language
- PHP
- Stars
- 36.9k
- Forks
- 5.2k
- Avg merge
- 2d 3h
- Merged PRs (30d)
- 713
Description
⚠️ This issue respects the following points: ⚠️
- This is a bug, not a question or a configuration/webserver/proxy issue.
- This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
- Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
- I agree to follow Nextcloud's Code of Conduct.
Bug description
Since some weeks I have noticed some error message in my Nextcloud log.
After some analysis, it seems to be related to an external mount.
| Mount ID | Mount Point | Storage | Authentication Type | Configuration | Options |
|---|---|---|---|---|---|
| 2 | /xxxx_yyyy | Amazon S3 | Clé d'accès | bucket: "REMOVED SENSITIVE VALUE", hostname: "s3.rbx.io.cloud.ovh.net", key: "REMOVED SENSITIVE VALUE", legacy_auth: false, port: "443", region: "rbx", secret: "REMOVED SENSITIVE VALUE", storageClass: "STANDARD", useMultipartCopy: false, use_path_style: false, use_ssl: true |
Steps to reproduce
- Configure the mount
- launch the command:
php occ files_external:scan -u user1 2
Expected behavior
Scan completed without error
Nextcloud Server version
31
Operating system
Debian/Ubuntu
PHP engine version
PHP 8.3
Web server
Nginx
Database engine version
PostgreSQL
Is this bug present after an update or on a fresh install?
Upgraded to a MAJOR version (ex. 31 to 32)
Are you using the Nextcloud Server Encryption module?
Encryption is Disabled
What user-backends are you using?
- Default user-backend (database)
- LDAP/ Active Directory
- SSO - SAML
- Other
Configuration report
{
"system": {
"memcache.local": "\\OC\\Memcache\\APCu",
"apps_paths": [
{
"path": "\/var\/www\/html\/apps",
"url": "\/apps",
"writable": false
},
{
"path": "\/var\/www\/html\/custom_apps",
"url": "\/custom_apps",
"writable": true
}
],
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"localhost",
"cloud.<redacted1>.org",
"cloud.<redacted2>.org"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "pgsql",
"version": "31.0.9.1",
"overwrite.cli.url": "https:\/\/cloud.<redacted1>.org",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"instanceid": "***REMOVED SENSITIVE VALUE***",
"overwriteprotocol": "https",
"default_language": "fr",
"default_locale": "fr_FR",
"skeletondirectory": "",
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtpauthtype": "LOGIN",
"mail_smtpauth": 1,
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "587",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"updater.release.channel": "stable",
"maintenance": false,
"data-fingerprint": "5d0172db5ecc43baf4389a4de798b7f8",
"loglevel": 2,
"trusted_proxies": "***REMOVED SENSITIVE VALUE***",
"memcache.distributed": "\\OC\\Memcache\\Redis",
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 6379
},
"theme": "",
"default_phone_region": "FR",
"defaultapp": "files",
"maintenance_window_start": 22,
"activity_expire_days": 90
}
}
List of activated Apps
Enabled:
- activity: 4.0.0
- admin_audit: 1.21.0
- app_api: 5.0.2
- bookmarks: 15.2.0
- bruteforcesettings: 4.0.0
- calendar: 5.5.5
- circles: 31.0.0
- cloud_federation_api: 1.14.0
- comments: 1.21.0
- contacts: 7.3.2
- contactsinteraction: 1.12.0
- cospend: 3.1.3
- dashboard: 7.11.0
- dav: 1.33.0
- deck: 1.15.2
- drawio: 3.1.0
- federatedfilesharing: 1.21.0
- federation: 1.21.0
- files: 2.3.1
- files_downloadlimit: 4.0.0
- files_external: 1.23.0
- files_pdfviewer: 4.0.0
- files_reminders: 1.4.0
- files_sharing: 1.23.1
- files_trashbin: 1.21.0
- files_versions: 1.24.0
- firstrunwizard: 4.0.0
- gpxpod: 7.0.4
- impersonate: 2.0.0
- keeweb: 0.6.21
- logreader: 4.0.0
- lookup_server_connector: 1.19.0
- mail: 5.5.5
- maps: 1.6.0
- nextcloud_announcements: 3.0.0
- notes: 4.12.3
- notifications: 4.0.0
- oauth2: 1.19.1
- password_policy: 3.0.0
- photos: 4.0.0
- polls: 8.4.6
- privacy: 3.0.0
- profile: 1.0.0
- provisioning_api: 1.21.0
- quota_warning: 1.22.0
- recommendations: 4.0.0
- related_resources: 2.0.0
- richdocuments: 8.7.5
- serverinfo: 3.0.0
- settings: 1.14.0
- sharebymail: 1.21.0
- spreed: 21.1.5
- support: 3.0.0
- survey_client: 3.0.0
- systemtags: 1.21.1
- text: 5.0.0
- theming: 2.6.1
- twofactor_backupcodes: 1.20.0
- twofactor_totp: 13.0.0-dev.0
- updatenotification: 1.21.0
- user_status: 1.11.0
- viewer: 4.0.0
- weather_status: 1.11.0
- webhook_listeners: 1.2.0
- workflowengine: 2.13.0
Disabled:
- encryption: 2.19.0 (installed 2.15.0)
- suspicious_login: 9.0.1
- twofactor_nextcloud_notification: 5.0.0
- user_ldap: 1.22.0
Nextcloud Signing status
No errors have been found.
Nextcloud Logs
{"reqId":"wiUrHNCurLOZzutJ4LiM","level":3,"time":"2025-10-01T12:25:05+00:00","remoteAddr":"","user":"--","app":"files","method":"","url":"--","message":"Error while trying to scan mount as /user1/files/Mount_path/:An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(40)","userAgent":"--","version":"31.0.9.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(40)","Code":7,"Trace":[{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":69,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\DriverException"},"","UPDATE `*PREFIX*filecache` SET `mtime` = :dcValue8, `storage_mtime` = :dcValue9, `etag` = :dcValue10, `checksum` = :dcValue11, `parent` = :dcValue12 WHERE (`fileid` = :dcValue1) AND (`storage` = :dcValue2) AND (((`mtime` <> :dcValue3) OR (`mtime` IS NULL)) OR ((`storage_mtime` <> :dcValue4) OR (`storage_mtime` IS NULL)) OR ((`etag` <> :dcValue5) OR (`etag` IS NULL)) OR ((`checksum` <> :dcValue6) OR (`checksum` IS NULL)) OR ((`parent` <> :dcValue7) OR (`parent` IS NULL)))"]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["UPDATE `*PREFIX*filecache` SET `mtime` = :dcValue8, `storage_mtime` = :dcValue9, `etag` = :dcValue10, `checksum` = :dcValue11, `parent` = :dcValue12 WHERE (`fileid` = :dcValue1) AND (`storage` = :dcValue2) AND (((`mtime` <> :dcValue3) OR (`mtime` IS NULL)) OR ((`storage_mtime` <> :dcValue4) OR (`storage_mtime` IS NULL)) OR ((`etag` <> :dcValue5) OR (`etag` IS NULL)) OR ((`checksum` <> :dcValue6) OR (`checksum` IS NULL)) OR ((`parent` <> :dcValue7) OR (`parent` IS NULL)))",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":55,"dcValue3":1749996585,"dcValue4":1749996585,"dcValue5":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 7 more entries, set log level to debug to see all entries"},{"dcValue1":1,"dcValue2":1,"dcValue3":2,"dcValue4":2,"dcValue5":2,"0":"And 7 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":289,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[{"__class__":"OC\\DB\\ConnectionAdapter"}]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":363,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":139,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":273,"function":"update","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":227,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName/FileName.mov","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":490,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName/FileName.mov",3,744176,{"__class__":"OC\\Files\\Cache\\CacheEntry"},true,{"name":"FileName.mov:","mimetype":"video/quicktime","mtime":1749996585,"storage_mtime":1749996585,"etag":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 6 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":414,"function":"handleChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3,744176,true,87753240,false]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":323,"function":"scanChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3,744176,true,-1]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":587,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":599,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":586,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[{"__class__":"Closure"},"DirName"]},{"file":"/var/www/html/lib/private/Files/Utils/Scanner.php","line":168,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":50,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":133,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":["user1"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":97,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":84,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/cron.php","line":170,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]}],"File":"/var/www/html/lib/private/DB/Exceptions/DbalException.php","Line":56,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(40)","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1976,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1918,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1218,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"UPDATE \"oc_filecache\" SET \"mtime\" = ?, \"storage_mtime\" = ?, \"etag\" = ?, \"checksum\" = ?, \"parent\" = ? WHERE (\"fileid\" = ?) AND (\"storage\" = ?) AND (((\"mtime\" <> ?) OR (\"mtime\" IS NULL)) OR ((\"storage_mtime\" <> ?) OR (\"storage_mtime\" IS NULL)) OR ((\"etag\" <> ?) OR (\"etag\" IS NULL)) OR ((\"checksum\" <> ?) OR (\"checksum\" IS NULL)) OR ((\"parent\" <> ?) OR (\"parent\" IS NULL)))",[1749996585,1749996585,"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","",744176,"And 7 more entries, set log level to debug to see all entries"],[2,2,2,2,2,"And 7 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE \"oc_filecache\" SET \"mtime\" = ?, \"storage_mtime\" = ?, \"etag\" = ?, \"checksum\" = ?, \"parent\" = ? WHERE (\"fileid\" = ?) AND (\"storage\" = ?) AND (((\"mtime\" <> ?) OR (\"mtime\" IS NULL)) OR ((\"storage_mtime\" <> ?) OR (\"storage_mtime\" IS NULL)) OR ((\"etag\" <> ?) OR (\"etag\" IS NULL)) OR ((\"checksum\" <> ?) OR (\"checksum\" IS NULL)) OR ((\"parent\" <> ?) OR (\"parent\" IS NULL)))",[1749996585,1749996585,"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","",744176,"And 7 more entries, set log level to debug to see all entries"],[2,2,2,2,2,"And 7 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["UPDATE \"oc_filecache\" SET \"mtime\" = :dcValue8, \"storage_mtime\" = :dcValue9, \"etag\" = :dcValue10, \"checksum\" = :dcValue11, \"parent\" = :dcValue12 WHERE (\"fileid\" = :dcValue1) AND (\"storage\" = :dcValue2) AND (((\"mtime\" <> :dcValue3) OR (\"mtime\" IS NULL)) OR ((\"storage_mtime\" <> :dcValue4) OR (\"storage_mtime\" IS NULL)) OR ((\"etag\" <> :dcValue5) OR (\"etag\" IS NULL)) OR ((\"checksum\" <> :dcValue6) OR (\"checksum\" IS NULL)) OR ((\"parent\" <> :dcValue7) OR (\"parent\" IS NULL)))",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":55,"dcValue3":1749996585,"dcValue4":1749996585,"dcValue5":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 7 more entries, set log level to debug to see all entries"},{"dcValue1":1,"dcValue2":1,"dcValue3":2,"dcValue4":2,"dcValue5":2,"0":"And 7 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["UPDATE \"oc_filecache\" SET \"mtime\" = :dcValue8, \"storage_mtime\" = :dcValue9, \"etag\" = :dcValue10, \"checksum\" = :dcValue11, \"parent\" = :dcValue12 WHERE (\"fileid\" = :dcValue1) AND (\"storage\" = :dcValue2) AND (((\"mtime\" <> :dcValue3) OR (\"mtime\" IS NULL)) OR ((\"storage_mtime\" <> :dcValue4) OR (\"storage_mtime\" IS NULL)) OR ((\"etag\" <> :dcValue5) OR (\"etag\" IS NULL)) OR ((\"checksum\" <> :dcValue6) OR (\"checksum\" IS NULL)) OR ((\"parent\" <> :dcValue7) OR (\"parent\" IS NULL)))",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":55,"dcValue3":1749996585,"dcValue4":1749996585,"dcValue5":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 7 more entries, set log level to debug to see all entries"},{"dcValue1":1,"dcValue2":1,"dcValue3":2,"dcValue4":2,"dcValue5":2,"0":"And 7 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["UPDATE `*PREFIX*filecache` SET `mtime` = :dcValue8, `storage_mtime` = :dcValue9, `etag` = :dcValue10, `checksum` = :dcValue11, `parent` = :dcValue12 WHERE (`fileid` = :dcValue1) AND (`storage` = :dcValue2) AND (((`mtime` <> :dcValue3) OR (`mtime` IS NULL)) OR ((`storage_mtime` <> :dcValue4) OR (`storage_mtime` IS NULL)) OR ((`etag` <> :dcValue5) OR (`etag` IS NULL)) OR ((`checksum` <> :dcValue6) OR (`checksum` IS NULL)) OR ((`parent` <> :dcValue7) OR (`parent` IS NULL)))",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":55,"dcValue3":1749996585,"dcValue4":1749996585,"dcValue5":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 7 more entries, set log level to debug to see all entries"},{"dcValue1":1,"dcValue2":1,"dcValue3":2,"dcValue4":2,"dcValue5":2,"0":"And 7 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":289,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[{"__class__":"OC\\DB\\ConnectionAdapter"}]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":363,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":139,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":273,"function":"update","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":227,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName/FileName.mov","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":490,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName/FileName.mov",3,744176,{"__class__":"OC\\Files\\Cache\\CacheEntry"},true,{"name":"FileName.mov","mimetype":"video/quicktime","mtime":1749996585,"storage_mtime":1749996585,"etag":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 6 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":414,"function":"handleChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3,744176,true,87753240,false]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":323,"function":"scanChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3,744176,true,-1]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":587,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":599,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":586,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[{"__class__":"Closure"},"DirName"]},{"file":"/var/www/html/lib/private/Files/Utils/Scanner.php","line":168,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":50,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":133,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":["user1"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":97,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":84,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/cron.php","line":170,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":87,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(40)","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[{"__class__":"PDOException","errorInfo":["22001",7,"ERROR: value too long for type character varying(40)"]}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1212,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE \"oc_filecache\" SET \"mtime\" = ?, \"storage_mtime\" = ?, \"etag\" = ?, \"checksum\" = ?, \"parent\" = ? WHERE (\"fileid\" = ?) AND (\"storage\" = ?) AND (((\"mtime\" <> ?) OR (\"mtime\" IS NULL)) OR ((\"storage_mtime\" <> ?) OR (\"storage_mtime\" IS NULL)) OR ((\"etag\" <> ?) OR (\"etag\" IS NULL)) OR ((\"checksum\" <> ?) OR (\"checksum\" IS NULL)) OR ((\"parent\" <> ?) OR (\"parent\" IS NULL)))",[1749996585,1749996585,"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","",744176,"And 7 more entries, set log level to debug to see all entries"],[2,2,2,2,2,"And 7 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["UPDATE \"oc_filecache\" SET \"mtime\" = :dcValue8, \"storage_mtime\" = :dcValue9, \"etag\" = :dcValue10, \"checksum\" = :dcValue11, \"parent\" = :dcValue12 WHERE (\"fileid\" = :dcValue1) AND (\"storage\" = :dcValue2) AND (((\"mtime\" <> :dcValue3) OR (\"mtime\" IS NULL)) OR ((\"storage_mtime\" <> :dcValue4) OR (\"storage_mtime\" IS NULL)) OR ((\"etag\" <> :dcValue5) OR (\"etag\" IS NULL)) OR ((\"checksum\" <> :dcValue6) OR (\"checksum\" IS NULL)) OR ((\"parent\" <> :dcValue7) OR (\"parent\" IS NULL)))",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":55,"dcValue3":1749996585,"dcValue4":1749996585,"dcValue5":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 7 more entries, set log level to debug to see all entries"},{"dcValue1":1,"dcValue2":1,"dcValue3":2,"dcValue4":2,"dcValue5":2,"0":"And 7 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["UPDATE \"oc_filecache\" SET \"mtime\" = :dcValue8, \"storage_mtime\" = :dcValue9, \"etag\" = :dcValue10, \"checksum\" = :dcValue11, \"parent\" = :dcValue12 WHERE (\"fileid\" = :dcValue1) AND (\"storage\" = :dcValue2) AND (((\"mtime\" <> :dcValue3) OR (\"mtime\" IS NULL)) OR ((\"storage_mtime\" <> :dcValue4) OR (\"storage_mtime\" IS NULL)) OR ((\"etag\" <> :dcValue5) OR (\"etag\" IS NULL)) OR ((\"checksum\" <> :dcValue6) OR (\"checksum\" IS NULL)) OR ((\"parent\" <> :dcValue7) OR (\"parent\" IS NULL)))",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":55,"dcValue3":1749996585,"dcValue4":1749996585,"dcValue5":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 7 more entries, set log level to debug to see all entries"},{"dcValue1":1,"dcValue2":1,"dcValue3":2,"dcValue4":2,"dcValue5":2,"0":"And 7 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["UPDATE `*PREFIX*filecache` SET `mtime` = :dcValue8, `storage_mtime` = :dcValue9, `etag` = :dcValue10, `checksum` = :dcValue11, `parent` = :dcValue12 WHERE (`fileid` = :dcValue1) AND (`storage` = :dcValue2) AND (((`mtime` <> :dcValue3) OR (`mtime` IS NULL)) OR ((`storage_mtime` <> :dcValue4) OR (`storage_mtime` IS NULL)) OR ((`etag` <> :dcValue5) OR (`etag` IS NULL)) OR ((`checksum` <> :dcValue6) OR (`checksum` IS NULL)) OR ((`parent` <> :dcValue7) OR (`parent` IS NULL)))",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":55,"dcValue3":1749996585,"dcValue4":1749996585,"dcValue5":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 7 more entries, set log level to debug to see all entries"},{"dcValue1":1,"dcValue2":1,"dcValue3":2,"dcValue4":2,"dcValue5":2,"0":"And 7 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":289,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[{"__class__":"OC\\DB\\ConnectionAdapter"}]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":363,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":139,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":273,"function":"update","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":227,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName/FileName.mov","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":490,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName/FileName.mov",3,744176,{"__class__":"OC\\Files\\Cache\\CacheEntry"},true,{"name":"FileName.mov","mimetype":"video/quicktime","mtime":1749996585,"storage_mtime":1749996585,"etag":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 6 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":414,"function":"handleChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3,744176,true,87753240,false]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":323,"function":"scanChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3,744176,true,-1]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":587,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":599,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":586,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[{"__class__":"Closure"},"DirName"]},{"file":"/var/www/html/lib/private/Files/Utils/Scanner.php","line":168,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":50,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":133,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":["user1"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":97,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":84,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/cron.php","line":170,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(40)","Code":"22001","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1212,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE \"oc_filecache\" SET \"mtime\" = ?, \"storage_mtime\" = ?, \"etag\" = ?, \"checksum\" = ?, \"parent\" = ? WHERE (\"fileid\" = ?) AND (\"storage\" = ?) AND (((\"mtime\" <> ?) OR (\"mtime\" IS NULL)) OR ((\"storage_mtime\" <> ?) OR (\"storage_mtime\" IS NULL)) OR ((\"etag\" <> ?) OR (\"etag\" IS NULL)) OR ((\"checksum\" <> ?) OR (\"checksum\" IS NULL)) OR ((\"parent\" <> ?) OR (\"parent\" IS NULL)))",[1749996585,1749996585,"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","",744176,"And 7 more entries, set log level to debug to see all entries"],[2,2,2,2,2,"And 7 more entries, set log level to debug to see all entries"]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["UPDATE \"oc_filecache\" SET \"mtime\" = :dcValue8, \"storage_mtime\" = :dcValue9, \"etag\" = :dcValue10, \"checksum\" = :dcValue11, \"parent\" = :dcValue12 WHERE (\"fileid\" = :dcValue1) AND (\"storage\" = :dcValue2) AND (((\"mtime\" <> :dcValue3) OR (\"mtime\" IS NULL)) OR ((\"storage_mtime\" <> :dcValue4) OR (\"storage_mtime\" IS NULL)) OR ((\"etag\" <> :dcValue5) OR (\"etag\" IS NULL)) OR ((\"checksum\" <> :dcValue6) OR (\"checksum\" IS NULL)) OR ((\"parent\" <> :dcValue7) OR (\"parent\" IS NULL)))",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":55,"dcValue3":1749996585,"dcValue4":1749996585,"dcValue5":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 7 more entries, set log level to debug to see all entries"},{"dcValue1":1,"dcValue2":1,"dcValue3":2,"dcValue4":2,"dcValue5":2,"0":"And 7 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["UPDATE \"oc_filecache\" SET \"mtime\" = :dcValue8, \"storage_mtime\" = :dcValue9, \"etag\" = :dcValue10, \"checksum\" = :dcValue11, \"parent\" = :dcValue12 WHERE (\"fileid\" = :dcValue1) AND (\"storage\" = :dcValue2) AND (((\"mtime\" <> :dcValue3) OR (\"mtime\" IS NULL)) OR ((\"storage_mtime\" <> :dcValue4) OR (\"storage_mtime\" IS NULL)) OR ((\"etag\" <> :dcValue5) OR (\"etag\" IS NULL)) OR ((\"checksum\" <> :dcValue6) OR (\"checksum\" IS NULL)) OR ((\"parent\" <> :dcValue7) OR (\"parent\" IS NULL)))",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":55,"dcValue3":1749996585,"dcValue4":1749996585,"dcValue5":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 7 more entries, set log level to debug to see all entries"},{"dcValue1":1,"dcValue2":1,"dcValue3":2,"dcValue4":2,"dcValue5":2,"0":"And 7 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["UPDATE `*PREFIX*filecache` SET `mtime` = :dcValue8, `storage_mtime` = :dcValue9, `etag` = :dcValue10, `checksum` = :dcValue11, `parent` = :dcValue12 WHERE (`fileid` = :dcValue1) AND (`storage` = :dcValue2) AND (((`mtime` <> :dcValue3) OR (`mtime` IS NULL)) OR ((`storage_mtime` <> :dcValue4) OR (`storage_mtime` IS NULL)) OR ((`etag` <> :dcValue5) OR (`etag` IS NULL)) OR ((`checksum` <> :dcValue6) OR (`checksum` IS NULL)) OR ((`parent` <> :dcValue7) OR (`parent` IS NULL)))",{"dcValue1":"*** sensitive parameters replaced ***","dcValue2":55,"dcValue3":1749996585,"dcValue4":1749996585,"dcValue5":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 7 more entries, set log level to debug to see all entries"},{"dcValue1":1,"dcValue2":1,"dcValue3":2,"dcValue4":2,"dcValue5":2,"0":"And 7 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":289,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[{"__class__":"OC\\DB\\ConnectionAdapter"}]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":363,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":139,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":273,"function":"update","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":227,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName/FileName.mov","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":490,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName/FileName.mov",3,744176,{"__class__":"OC\\Files\\Cache\\CacheEntry"},true,{"name":"FileName.mov","mimetype":"video/quicktime","mtime":1749996585,"storage_mtime":1749996585,"etag":"0d5c617e0df59ed6219879e5890dc5805647d886bd0962a0e27a9cc8b79bc442","0":"And 6 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":414,"function":"handleChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3,744176,true,87753240,false]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":323,"function":"scanChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3,744176,true,-1]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":587,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["DirName",2,3]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":599,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":586,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[{"__class__":"Closure"},"DirName"]},{"file":"/var/www/html/lib/private/Files/Utils/Scanner.php","line":168,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":50,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":133,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":["user1"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":97,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":84,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/cron.php","line":170,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"Error while trying to scan mount as /user1/files/Mount_path/:An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(40)","exception":{"query":"UPDATE `*PREFIX*filecache` SET `mtime` = :dcValue8, `storage_mtime` = :dcValue9, `etag` = :dcValue10, `checksum` = :dcValue11, `parent` = :dcValue12 WHERE (`fileid` = :dcValue1) AND (`storage` = :dcValue2) AND (((`mtime` <> :dcValue3) OR (`mtime` IS NULL)) OR ((`storage_mtime` <> :dcValue4) OR (`storage_mtime` IS NULL)) OR ((`etag` <> :dcValue5) OR (`etag` IS NULL)) OR ((`checksum` <> :dcValue6) OR (`checksum` IS NULL)) OR ((`parent` <> :dcValue7) OR (`parent` IS NULL)))"},"CustomMessage":"Error while trying to scan mount as /user1/files/Mount_path/:An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(40)"}}
{"reqId":"wiUrHNCurLOZzutJ4LiM","level":3,"time":"2025-10-01T12:25:05+00:00","remoteAddr":"","user":"--","app":"files","method":"","url":"--","message":"Error while trying to scan mount as /user1/:An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block","userAgent":"--","version":"31.0.9.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block","Code":7,"Trace":[{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":53,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\DriverException"},"","SELECT `fileid` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)"]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `fileid` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)",{"dcValue1":19,"dcValue2":"d41d8cd98f00b204e9800998ecf8427e"},{"dcValue1":1,"dcValue2":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[{"__class__":"OC\\DB\\ConnectionAdapter"}]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":476,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":513,"function":"getId","class":"OC\\Files\\Cache\\Cache","type":"->","args":[""]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":577,"function":"inCache","class":"OC\\Files\\Cache\\Cache","type":"->","args":[""]},{"file":"/var/www/html/lib/private/Files/Utils/Scanner.php","line":168,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":50,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":133,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":["user1"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":97,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":84,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/cron.php","line":170,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]}],"File":"/var/www/html/lib/private/DB/Exceptions/DbalException.php","Line":56,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1976,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1918,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1111,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"SELECT \"fileid\" FROM \"oc_filecache\" WHERE (\"storage\" = ?) AND (\"path_hash\" = ?)",[19,"d41d8cd98f00b204e9800998ecf8427e"],[1,2]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"fileid\" FROM \"oc_filecache\" WHERE (\"storage\" = ?) AND (\"path_hash\" = ?)",[19,"d41d8cd98f00b204e9800998ecf8427e"],[1,2],null]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"fileid\" FROM \"oc_filecache\" WHERE (\"storage\" = :dcValue1) AND (\"path_hash\" = :dcValue2)",{"dcValue1":19,"dcValue2":"d41d8cd98f00b204e9800998ecf8427e"},{"dcValue1":1,"dcValue2":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `fileid` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)",{"dcValue1":19,"dcValue2":"d41d8cd98f00b204e9800998ecf8427e"},{"dcValue1":1,"dcValue2":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[{"__class__":"OC\\DB\\ConnectionAdapter"}]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":476,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":513,"function":"getId","class":"OC\\Files\\Cache\\Cache","type":"->","args":[""]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":577,"function":"inCache","class":"OC\\Files\\Cache\\Cache","type":"->","args":[""]},{"file":"/var/www/html/lib/private/Files/Utils/Scanner.php","line":168,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":50,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":133,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":["user1"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":97,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":84,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/cron.php","line":170,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":87,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[{"__class__":"PDOException","errorInfo":["25P02",7,"ERROR: current transaction is aborted, commands ignored until end of transaction block"]}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1104,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"fileid\" FROM \"oc_filecache\" WHERE (\"storage\" = ?) AND (\"path_hash\" = ?)",[19,"d41d8cd98f00b204e9800998ecf8427e"],[1,2],null]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"fileid\" FROM \"oc_filecache\" WHERE (\"storage\" = :dcValue1) AND (\"path_hash\" = :dcValue2)",{"dcValue1":19,"dcValue2":"d41d8cd98f00b204e9800998ecf8427e"},{"dcValue1":1,"dcValue2":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `fileid` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)",{"dcValue1":19,"dcValue2":"d41d8cd98f00b204e9800998ecf8427e"},{"dcValue1":1,"dcValue2":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[{"__class__":"OC\\DB\\ConnectionAdapter"}]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":476,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":513,"function":"getId","class":"OC\\Files\\Cache\\Cache","type":"->","args":[""]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":577,"function":"inCache","class":"OC\\Files\\Cache\\Cache","type":"->","args":[""]},{"file":"/var/www/html/lib/private/Files/Utils/Scanner.php","line":168,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":50,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":133,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":["user1"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":97,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":84,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/cron.php","line":170,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block","Code":"25P02","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1104,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"fileid\" FROM \"oc_filecache\" WHERE (\"storage\" = ?) AND (\"path_hash\" = ?)",[19,"d41d8cd98f00b204e9800998ecf8427e"],[1,2],null]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"fileid\" FROM \"oc_filecache\" WHERE (\"storage\" = :dcValue1) AND (\"path_hash\" = :dcValue2)",{"dcValue1":19,"dcValue2":"d41d8cd98f00b204e9800998ecf8427e"},{"dcValue1":1,"dcValue2":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `fileid` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)",{"dcValue1":19,"dcValue2":"d41d8cd98f00b204e9800998ecf8427e"},{"dcValue1":1,"dcValue2":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[{"__class__":"OC\\DB\\ConnectionAdapter"}]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":476,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Files/Cache/Cache.php","line":513,"function":"getId","class":"OC\\Files\\Cache\\Cache","type":"->","args":[""]},{"file":"/var/www/html/lib/private/Files/Cache/Scanner.php","line":577,"function":"inCache","class":"OC\\Files\\Cache\\Cache","type":"->","args":[""]},{"file":"/var/www/html/lib/private/Files/Utils/Scanner.php","line":168,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":50,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"/var/www/html/apps/files/lib/BackgroundJob/ScanFiles.php","line":133,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":["user1"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":97,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":84,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]},{"file":"/var/www/html/cron.php","line":170,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"}]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"Error while trying to scan mount as /user1/:An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block","exception":{"query":"SELECT `fileid` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)"},"CustomMessage":"Error while trying to scan mount as /user1/:An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block"}}
Additional info
Any idea on what I can do to try to figure out what the issue is ?
I asked the user to remove this specific file, but not sure if it will change anything.
Any idea is welcome.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the files_external:scan command and the cache paths shown in lib/private/Files/Cache/Cache.php, CacheWrapper.php, and Scanner.php. Reproduce the scan against the external mount using an ETag longer than 40 characters, then verify that the file cache update and scan complete without the database truncation error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php, postgresql
- Domain
- backend, cloud, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 52/100