Nextcloud version (eg, 12.0.2): 18.0.0
Operating system and version (eg, Ubuntu 17.04): FreeBSD 11.2-RELEASE-p6 #0 r341740
Apache or nginx version (eg, Apache 2.4.25): 2.4.41
PHP version (eg, 7.1): 7.2.27
MySQL: 5.6.45
The issue you are facing:
I’m using cloudsend, the command line tool for pushing files to my nextcloud instance. It worked great for a long time, but something changed (update?) and now the shared and synced version of the folder is being auto-renamed with an apparently endless string of (2) (2) (2)s.
The folder is owned by a unique user and when logged in to that folder,
The cloud send script is here: https://gist.github.com/MG2R/c896852b837a3807f49649c1ba2347ca
I tried upgrading from 17.3 to 18.0 to see if perhaps there was an issue with the older version, and while the upgrade went well, it didn’t fix the problem.
Now the shared folder isn’t accessible from the freeNAS ui. Clicking on the folder tries to open it but loops back to the folder list.
… -> details -> “Error while loading the file data”
HOWEVER, the folder is not munged if I log in as the owner (no (2) (2)…) .
I can unshare it from that account, but it can’t delete the folder, presumably the name is too long to process.
Rename attempt:
Could not rename "B-Cam-DB (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2)"
in the logs
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE `oc_share` SET `file_target` = ? WHERE `id` = ?' with params ["\/B-Cam-DB (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2) (2)", "43"]: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'file_target' at row 1
/usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 169:
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exceptio ... 1", Doctrine\DBA ... ]})
/usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 145:
Doctrine\DBAL\DBALException::wrapException(Doctrine\DBA ... {}, Doctrine\DBA ... ]}, "An exceptio ... 1")
/usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1063:
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBA ... {}, Doctrine\DBA ... ]}, "UPDATE `oc_ ... ?", { 1: "*** se ... "})
/usr/local/www/nextcloud/lib/private/DB/Connection.php - line 220:
Doctrine\DBAL\Connection->executeUpdate("UPDATE `oc_ ... ?", [ "*** sensi ... "], [ 2,2])
/usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 203:
OC\DB\Connection->executeUpdate("UPDATE `oc_ ... 2", { dcValue1: ... "}, { dcValue1: 2,dcValue2: 2})
/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 215:
Doctrine\DBAL\Query\QueryBuilder->execute()
/usr/local/www/nextcloud/lib/private/Share20/DefaultShareProvider.php - line 603:
OC\DB\QueryBuilder\QueryBuilder->execute()
/usr/local/www/nextcloud/lib/private/Share20/Manager.php - line 1190:
OC\Share20\DefaultShareProvider->move(OC\Share20\Share {}, "gessel")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/SharedMount.php - line 129:
OC\Share20\Manager->moveShare(OC\Share20\Share {}, "gessel")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/SharedMount.php - line 111:
OCA\Files_Sharing\SharedMount->updateFileTarget("*** sensiti ... *")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/SharedMount.php - line 77:
OCA\Files_Sharing\SharedMount->verifyMountPoint("*** sensiti ... *", [], OC\Cache\CappedMemoryCache {})
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/MountProvider.php - line 125:
OCA\Files_Sharing\SharedMount->__construct("\\OCA\\File ... e", [], { user: "ges ... e}, OC\Files\Sto ... {}, OC\Files\View {}, OC\Cache\CappedMemoryCache {})
/usr/local/www/nextcloud/lib/private/Files/Filesystem.php - line 480:
OCA\Files_Sharing\MountProvider->getMountsForUser(OC\User\User {}, OC\Files\Sto ... {})
<<closure>>
OC\Files\Filesystem::OC\Files\{closure}("*** sensiti ... *")
/usr/local/www/nextcloud/lib/private/Hooks/EmitterTrait.php - line 100:
call_user_func_array(Closure {}, [ "*** sensi ... "])
/usr/local/www/nextcloud/lib/private/Files/Config/MountProviderCollection.php - line 153:
OC\Files\Config\MountProviderCollection->emit("\\OC\\Files\\Config", "registerMountProvider", [ "*** sensi ... "])
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/AppInfo/Application.php - line 205:
OC\Files\Config\MountProviderCollection->registerProvider("*** sensiti ... *")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/AppInfo/Application.php - line 194:
OCA\Files_Sharing\AppInfo\Application->registerMountProviders(OC\Files\Con ... {})
<<closure>>
OCA\Files_Sharing\AppInfo\Application->__construct([])
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 83:
ReflectionClass->newInstanceArgs([ []])
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 100:
OC\AppFramework\Utility\SimpleContainer->buildClass(ReflectionCl ... "})
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 115:
OC\AppFramework\Utility\SimpleContainer->resolve("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 415:
OC\AppFramework\Utility\SimpleContainer->query("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/ServerContainer.php - line 134:
OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 375:
OC\ServerContainer->query("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 353:
OC\Route\Router->setupRoutes({ resources: ... ]}, "files_sharing")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 152:
OC\Route\Router->requireRouteFile("/usr/local/ ... p", "files_sharing")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 270:
OC\Route\Router->loadRoutes()
/usr/local/www/nextcloud/lib/base.php - line 1008:
OC\Route\Router->match("/css/text/d233-a4f0-icons.css")
/usr/local/www/nextcloud/index.php - line 38:
OC::handleRequest()
Caused by Doctrine\DBAL\Driver\PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'file_target' at row 1
/usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1054:
Doctrine\DBAL\Driver\PDOStatement->execute()
/usr/local/www/nextcloud/lib/private/DB/Connection.php - line 220:
Doctrine\DBAL\Connection->executeUpdate("UPDATE `oc_ ... ?", [ "*** sensi ... "], [ 2,2])
/usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 203:
OC\DB\Connection->executeUpdate("UPDATE `oc_ ... 2", { dcValue1: ... "}, { dcValue1: 2,dcValue2: 2})
/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 215:
Doctrine\DBAL\Query\QueryBuilder->execute()
/usr/local/www/nextcloud/lib/private/Share20/DefaultShareProvider.php - line 603:
OC\DB\QueryBuilder\QueryBuilder->execute()
/usr/local/www/nextcloud/lib/private/Share20/Manager.php - line 1190:
OC\Share20\DefaultShareProvider->move(OC\Share20\Share {}, "gessel")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/SharedMount.php - line 129:
OC\Share20\Manager->moveShare(OC\Share20\Share {}, "gessel")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/SharedMount.php - line 111:
OCA\Files_Sharing\SharedMount->updateFileTarget("*** sensiti ... *")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/SharedMount.php - line 77:
OCA\Files_Sharing\SharedMount->verifyMountPoint("*** sensiti ... *", [], OC\Cache\CappedMemoryCache {})
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/MountProvider.php - line 125:
OCA\Files_Sharing\SharedMount->__construct("\\OCA\\File ... e", [], { user: "ges ... e}, OC\Files\Sto ... {}, OC\Files\View {}, OC\Cache\CappedMemoryCache {})
/usr/local/www/nextcloud/lib/private/Files/Filesystem.php - line 480:
OCA\Files_Sharing\MountProvider->getMountsForUser(OC\User\User {}, OC\Files\Sto ... {})
<<closure>>
OC\Files\Filesystem::OC\Files\{closure}("*** sensiti ... *")
/usr/local/www/nextcloud/lib/private/Hooks/EmitterTrait.php - line 100:
call_user_func_array(Closure {}, [ "*** sensi ... "])
/usr/local/www/nextcloud/lib/private/Files/Config/MountProviderCollection.php - line 153:
OC\Files\Config\MountProviderCollection->emit("\\OC\\Files\\Config", "registerMountProvider", [ "*** sensi ... "])
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/AppInfo/Application.php - line 205:
OC\Files\Config\MountProviderCollection->registerProvider("*** sensiti ... *")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/AppInfo/Application.php - line 194:
OCA\Files_Sharing\AppInfo\Application->registerMountProviders(OC\Files\Con ... {})
<<closure>>
OCA\Files_Sharing\AppInfo\Application->__construct([])
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 83:
ReflectionClass->newInstanceArgs([ []])
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 100:
OC\AppFramework\Utility\SimpleContainer->buildClass(ReflectionCl ... "})
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 115:
OC\AppFramework\Utility\SimpleContainer->resolve("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 415:
OC\AppFramework\Utility\SimpleContainer->query("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/ServerContainer.php - line 134:
OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 375:
OC\ServerContainer->query("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 353:
OC\Route\Router->setupRoutes({ resources: ... ]}, "files_sharing")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 152:
OC\Route\Router->requireRouteFile("/usr/local/ ... p", "files_sharing")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 270:
OC\Route\Router->loadRoutes()
/usr/local/www/nextcloud/lib/base.php - line 1008:
OC\Route\Router->match("/css/text/d233-a4f0-icons.css")
/usr/local/www/nextcloud/index.php - line 38:
OC::handleRequest()
Caused by PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'file_target' at row 1
/usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - line 117:
PDOStatement->execute(null)
/usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1054:
Doctrine\DBAL\Driver\PDOStatement->execute()
/usr/local/www/nextcloud/lib/private/DB/Connection.php - line 220:
Doctrine\DBAL\Connection->executeUpdate("UPDATE `oc_ ... ?", [ "*** sensi ... "], [ 2,2])
/usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 203:
OC\DB\Connection->executeUpdate("UPDATE `oc_ ... 2", { dcValue1: ... "}, { dcValue1: 2,dcValue2: 2})
/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 215:
Doctrine\DBAL\Query\QueryBuilder->execute()
/usr/local/www/nextcloud/lib/private/Share20/DefaultShareProvider.php - line 603:
OC\DB\QueryBuilder\QueryBuilder->execute()
/usr/local/www/nextcloud/lib/private/Share20/Manager.php - line 1190:
OC\Share20\DefaultShareProvider->move(OC\Share20\Share {}, "gessel")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/SharedMount.php - line 129:
OC\Share20\Manager->moveShare(OC\Share20\Share {}, "gessel")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/SharedMount.php - line 111:
OCA\Files_Sharing\SharedMount->updateFileTarget("*** sensiti ... *")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/SharedMount.php - line 77:
OCA\Files_Sharing\SharedMount->verifyMountPoint("*** sensiti ... *", [], OC\Cache\CappedMemoryCache {})
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/MountProvider.php - line 125:
OCA\Files_Sharing\SharedMount->__construct("\\OCA\\File ... e", [], { user: "ges ... e}, OC\Files\Sto ... {}, OC\Files\View {}, OC\Cache\CappedMemoryCache {})
/usr/local/www/nextcloud/lib/private/Files/Filesystem.php - line 480:
OCA\Files_Sharing\MountProvider->getMountsForUser(OC\User\User {}, OC\Files\Sto ... {})
<<closure>>
OC\Files\Filesystem::OC\Files\{closure}("*** sensiti ... *")
/usr/local/www/nextcloud/lib/private/Hooks/EmitterTrait.php - line 100:
call_user_func_array(Closure {}, [ "*** sensi ... "])
/usr/local/www/nextcloud/lib/private/Files/Config/MountProviderCollection.php - line 153:
OC\Files\Config\MountProviderCollection->emit("\\OC\\Files\\Config", "registerMountProvider", [ "*** sensi ... "])
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/AppInfo/Application.php - line 205:
OC\Files\Config\MountProviderCollection->registerProvider("*** sensiti ... *")
/usr/local/www/nextcloud/apps-pkg/files_sharing/lib/AppInfo/Application.php - line 194:
OCA\Files_Sharing\AppInfo\Application->registerMountProviders(OC\Files\Con ... {})
<<closure>>
OCA\Files_Sharing\AppInfo\Application->__construct([])
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 83:
ReflectionClass->newInstanceArgs([ []])
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 100:
OC\AppFramework\Utility\SimpleContainer->buildClass(ReflectionCl ... "})
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php - line 115:
OC\AppFramework\Utility\SimpleContainer->resolve("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php - line 415:
OC\AppFramework\Utility\SimpleContainer->query("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/ServerContainer.php - line 134:
OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 375:
OC\ServerContainer->query("OCA\\Files_ ... n")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 353:
OC\Route\Router->setupRoutes({ resources: ... ]}, "files_sharing")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 152:
OC\Route\Router->requireRouteFile("/usr/local/ ... p", "files_sharing")
/usr/local/www/nextcloud/lib/private/Route/Router.php - line 270:
OC\Route\Router->loadRoutes()
/usr/local/www/nextcloud/lib/base.php - line 1008:
OC\Route\Router->match("/css/text/d233-a4f0-icons.css")
/usr/local/www/nextcloud/index.php - line 38:
OC::handleRequest()
Can’t delete… strange.
Is this the first time you’ve seen this error? (Y/N): Y
Steps to replicate it:
- I’m not sure… it’s the first time I’ve seen this.
but from the shared-to user, even after unsharing, I can’t delete or remove the folder.
The output of your Nextcloud log in Admin > Logging: