oc_filecache path too long on upgrade from 11.0.4.1 to 12.0.3

[arusa]

Steps to reproduce

1. update through web updater
2. run upgrade using web or cli command

Expected behaviour

upgrade completes successfully

Actual behaviour

Error happens while:

Repair step: Repair invalid paths in file cache","userAgent":"--","version":"11.0.4.1"}

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE `oc_filecache` SET `path` = ?, `path_hash` = MD5(?), `storage` = ? WHERE `fileid` = ?' with params ["files_versions\/Shared\/Postfach\/eps_alle\/9008983005259.eps\/Shared\/Postfach\/eps_alle\/9008983010628.eps\/Shared\/Postfach\/eps_alle\/9008983010628.eps.........\/Shared\/Postfach\/eps_alle\/9008\/Shared", "1", "19862"]:                                                             

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'path' at row 1
Update failed

I have shortened the value for the column path. It has in fact 8765 characters while the path column is varchar(4000)

Server configuration

Operating system:
Ubuntu 16.04 LTS

Web server:
apache 2.4.18

Database:
MySQL 5.7.19

PHP version:
PHP 7.0.22-0ubuntu0.16.04.1

Nextcloud version: (see Nextcloud admin page)
12.0.3

Updated from an older Nextcloud/ownCloud or fresh install:
11.0.4.1

List of activated apps:

App list

Enabled:
  - activity: 2.5.2
  - bruteforcesettings: 1.0.2
  - comments: 1.2.0
  - dav: 1.3.0
  - encryption: 1.6.0
  - federatedfilesharing: 1.2.0
  - federation: 1.2.0
  - files: 1.7.2
  - files_external: 1.3.0
  - files_pdfviewer: 1.1.1
  - files_sharing: 1.4.0
  - files_texteditor: 2.4.1
  - files_trashbin: 1.2.0
  - files_versions: 1.5.0
  - files_videoplayer: 1.1.0
  - firstrunwizard: 2.1
  - gallery: 17.0.0
  - logreader: 2.0.0
  - lookup_server_connector: 1.0.0
  - nextcloud_announcements: 1.1
  - notifications: 2.0.0
  - oauth2: 1.0.5
  - password_policy: 1.2.2
  - provisioning_api: 1.2.0
  - serverinfo: 1.2.0
  - sharebymail: 1.2.0
  - survey_client: 1.0.0
  - systemtags: 1.2.0
  - theming: 1.3.0
  - twofactor_backupcodes: 1.1.1
  - updatenotification: 1.2.0
  - workflowengine: 1.2.0
Disabled:
  - admin_audit
  - user_external
  - user_ldap

Nextcloud configuration:

Config report

{
    "system": {
        "mail_smtpmode": "smtp",
        "instanceid": "oc8c04e30a0a",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "datadirectory": "\/var\/owncloud\/data",
        "dbtype": "mysql",
        "version": "11.0.4.1",
        "installed": true,
        "forcessl": true,
        "theme": "",
        "maintenance": true,
        "trusted_domains": [
            "cloud.rusa.at"
        ],
        "share_folder": "\/Shared",
        "overwrite.cli.url": "https:\/\/cloud.rusa.at\/",
        "mail_smtpsecure": "tls",
        "mail_from_address": "cloud",
        "mail_domain": "rusa.at",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtphost": "...",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "dbname": "owncloud",
        "dbhost": "127.0.0.1",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "loglevel": 3,
        "trashbin_retention_obligation": "auto",
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

Are you using external storage, if yes which one: local/smb/sftp/...
i don't think so

Are you using encryption: yes/no
yes

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
no

Nextcloud log (data/nextcloud.log)

Nextcloud log

\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008983010628.eps\\\\\\\/Shared\\\\\\\/Postfach\\\\\\\/eps_alle\\\\\\\/9008\\\\\\\/Shared\\\", \\\"1\\\", \\\"19862\\\"]:\\n\\nSQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'path' at row 1\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'UPDATE `oc_file...', Array)\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(213): Doctrine\\\\DBAL\\\\Connection->executeUpdate('UPDATE `oc_file...', Array, Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(208): OC\\\\DB\\\\Connection->executeUpdate('UPDATE `oc_file...', Array, Array)\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(213): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Repair\\\/NC13\\\/RepairInvalidPaths.php(115): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Repair\\\/NC13\\\/RepairInvalidPaths.php(158): OC\\\\Repair\\\\NC13\\\\RepairInvalidPaths->update('19862', 'files_versions\\\/...', '1')\\n#7 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Repair\\\/NC13\\\/RepairInvalidPaths.php(169): OC\\\\Repair\\\\NC13\\\\RepairInvalidPaths->repair()\\n#8 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Repair.php(89): OC\\\\Repair\\\\NC13\\\\RepairInvalidPaths->run(Object(OC\\\\Repair))\\n#9 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(281): OC\\\\Repair->run()\\n#10 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Updater.php(130): OC\\\\Updater->doUpgrade('12.0.3.3', '11.0.4.1')\\n#11 \\\/var\\\/www\\\/owncloud\\\/core\\\/Command\\\/Upgrade.php(263): OC\\\\Updater->upgrade()\\n#12 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/symfony\\\/console\\\/Command\\\/Command.php(256): OC\\\\Core\\\\Command\\\\Upgrade->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#13 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(818): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#14 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(186): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\Upgrade), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#15 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(117): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#16 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/Console\\\/Application.php(170): Symfony\\\\Component\\\\Console\\\\Application->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#17 \\\/var\\\/www\\\/owncloud\\\/console.php(100): OC\\\\Console\\\\Application->run()\\n#18 \\\/var\\\/www\\\/owncloud\\\/occ(11): require_once('\\\/var\\\/www\\\/ownclo...')\\n#19 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":116}","userAgent":"--","version":"11.0.4.1"}
{"reqId":"dUU954HsvkyYzq9RhW3X","level":3,"time":"2017-10-08T22:44:13+00:00","remoteAddr":"","user":"--","app":"updater","method":"--","url":"--","message":"\\OC\\Updater::failure: Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing 'UPDATE `oc_filecache` SET `path` = ?, `path_hash` = MD5(?), `storage` = ? WHERE `fileid` = ?' with params [\"files_versions\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983005259.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008\\\/Shared\", \"files_versions\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983005259.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Shared\\\/Postfach\\\/eps_alle\\\/9008983010628.eps\\\/Sh:

[arusa]

I solved the problem by changing db_structure.xml

<field>
		<name>path</name>
		<type>text</type>
		<default></default>
		<notnull>false</notnull>
		<length>4000</length>
</field>

to

<field>
		<name>path</name>
		<type>text</type>
		<default></default>
		<notnull>false</notnull>
		<length>10000</length>
</field>

but I don't really know if this is the best idea.

[musaa32]

seems legit, can you close your issue

[arusa]

Ok, but now I get a code integrity warning because the checksum of db_structure.xml has changed. So maybe it would be a good idea to raise the length of the column "path" for all customers?
I don't know what oc_filecache does and why this path is so long. For me it looks like a bug, because the path seams to be repeating and I don't think that "9008983005259.eps" is a directory:

files_versions/Shared/Postfach/eps_alle/9008983005259.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008983010628.eps/Shared/Postfach/eps_alle/9008/Shared

Is there a way to repair this table?

I have already tried this two commands:

sudo -u www-data php occ files:cleanup
sudo -u www-data php occ files:scan --all

[nickvergessen]

@icewind1991 the path looks broken, any idea?

[stephen-azure]

I was upgrading 11>12 and during the occ upgrade, it hangs and then dumps the below DB error. There is only one "\Done" in the SMB path of this mount. We checked the record in the MySQL db and it has a single additional "\Done" currently that does not exist in the actual path. We tried updating the MySQL record and removing the extra \Done but that didn't keep the error from happening again. At this point, my upgrade is stuck and I need it back online.

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE oc_filecacheSETpath= ?,path_hash= MD5(?),storage= ? WHEREfileid` = ?' with params ["Buyers/Price Changes/AP Price Changes 2015/Price Changes for Joan/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Specialty Commodities 124790.pdf", "Buyers/Price Changes/AP Price Changes 2015/Price Changes
for Joan/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Done/Specialty Commodities 124790.pdf", "70", "616482"]:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'path' at row 1
Update failed`

[nickvergessen]

Do you have a stacktrace for this error?

[stephen-azure]

@nickvergessen I'm afraid I don't and I rolled the update back to 11 where it sits now.

[arusa]

@nickvergessen it's the same problem as I had. As far as I remember there is a repair-script to fix up the path column of the table oc_filecache. I assume there could be a problem with this routine that keeps adding the path to the end of the path until the value of the column is too long for the size of the varchar-field.

[arusa]

I just did the upgrade from 12.0.3 to 12.0.4 and the same problem occured again.

[nee2shaji]

I'm also facing the same issue where the file path is too long. Is there a way to fix this?
I had upgraded NC from 12 to 13.

[kesselb]

Is this still relevant? It could be good to increase the length for path.

[arusa]

I didn't get this error anymore since a long time, but the max length of my path field is still 10.000 and I've still got about 50 entries with a length a little bit longer than 4.000 chars because of those repeated path values.

[szaimen]

Hi, please update to 24.0.8 or better 25.0.2 and report back if it fixes the issue. Thank you!