Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MySQL error while generating previews #155

Closed
EugenVau opened this issue Mar 13, 2019 · 5 comments
Closed

MySQL error while generating previews #155

EugenVau opened this issue Mar 13, 2019 · 5 comments

Comments

@EugenVau
Copy link

After about half an hour of generating previews I get the following error and the generator dies:

[Doctrine\DBAL\Exception\DriverException]
An exception occurred while executing 'UPDATE `oc_filecache` SET `mimepart` = ?, `mimetype` = ?, `mtime` = ?, `size` = ?, `etag` = ?, `storage_mtime` = ?,
`permissions` = ?, `parent` = ?, `checksum`=? WHERE (`mimepart` <> ? OR `mimetype` <> ? OR `mtime` <> ? OR `size` <> ? OR `etag` <> ? OR `storage_mtime`
<> ? OR `permissions` <> ? OR `parent` <> ? OR `checksum` <> ? OR `mimepart` IS NULL OR `mimetype` IS NULL OR `mtime` IS NULL OR `size` IS NULL OR `etag`
IS NULL OR `storage_mtime` IS NULL OR `permissions` IS NULL OR `parent` IS NULL OR `checksum` IS NULL) AND `fileid` = ? '
with params ["5", "6", 1216844043, "182528", "LGEbs7SpF7-HgFd0JDZHpzl3jx-w-TkEVP5zq4EzrHg", 1216844043, 27, 8846, "", "5", "6", 1216844043, "182528",
"LGEbs7SpF7-HgFd0JDZHpzl3jx-w-TkEVP5zq4EzrHg", 1216844043, 27, 8846, "", "9463"]:

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

Exception trace:
 Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
 Doctrine\DBAL\DBALException::driverExceptionDuringQuery() at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855
 Doctrine\DBAL\Connection->executeQuery() at /var/www/nextcloud/lib/private/DB/Connection.php:195
 OC\DB\Connection->executeQuery() at /var/www/nextcloud/lib/private/Files/Cache/Cache.php:332
 OC\Files\Cache\Cache->update() at /var/www/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php:138
 OC\Files\Cache\Wrapper\CacheWrapper->update() at /var/www/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php:111
 OC\Files\Cache\Wrapper\CacheWrapper->put() at /var/www/nextcloud/lib/private/Files/Cache/Scanner.php:292
 OC\Files\Cache\Scanner->addToCache() at /var/www/nextcloud/lib/private/Files/Cache/Scanner.php:221
 OC\Files\Cache\Scanner->scanFile() at /var/www/nextcloud/lib/private/Files/Cache/Watcher.php:106
 OC\Files\Cache\Watcher->update() at /var/www/nextcloud/lib/private/Files/View.php:1334
 OC\Files\View->getCacheEntry() at /var/www/nextcloud/lib/private/Files/View.php:1374
 OC\Files\View->getFileInfo() at /var/www/nextcloud/lib/private/Preview/Image.php:37
 OC\Preview\Image->getThumbnail() at /var/www/nextcloud/lib/private/Preview/GeneratorHelper.php:59
 OC\Preview\GeneratorHelper->getThumbnail() at /var/www/nextcloud/lib/private/Preview/Generator.php:194
 OC\Preview\Generator->getMaxPreview() at /var/www/nextcloud/lib/private/Preview/Generator.php:118
 OC\Preview\Generator->getPreview() at /var/www/nextcloud/lib/private/PreviewManager.php:205
 OC\PreviewManager->getPreview() at /var/www/nextcloud/apps/previewgenerator/lib/Command/Generate.php:184
 OCA\PreviewGenerator\Command\Generate->parseFile() at /var/www/nextcloud/apps/previewgenerator/lib/Command/Generate.php:171
 OCA\PreviewGenerator\Command\Generate->parseFolder() at /var/www/nextcloud/apps/previewgenerator/lib/Command/Generate.php:169
 OCA\PreviewGenerator\Command\Generate->parseFolder() at /var/www/nextcloud/apps/previewgenerator/lib/Command/Generate.php:169
 OCA\PreviewGenerator\Command\Generate->parseFolder() at /var/www/nextcloud/apps/previewgenerator/lib/Command/Generate.php:153
 OCA\PreviewGenerator\Command\Generate->generateUserPreviews() at /var/www/nextcloud/apps/previewgenerator/lib/Command/Generate.php:126
 OCA\PreviewGenerator\Command\Generate->execute() at /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php:255
 Symfony\Component\Console\Command\Command->run() at /var/www/nextcloud/3rdparty/symfony/console/Application.php:946
 Symfony\Component\Console\Application->doRunCommand() at /var/www/nextcloud/3rdparty/symfony/console/Application.php:248
 Symfony\Component\Console\Application->doRun() at /var/www/nextcloud/3rdparty/symfony/console/Application.php:148
 Symfony\Component\Console\Application->run() at /var/www/nextcloud/lib/private/Console/Application.php:213
 OC\Console\Application->run() at /var/www/nextcloud/console.php:96
 require_once() at /var/www/nextcloud/occ:11

In PDOStatement.php line 107:

  [Doctrine\DBAL\Driver\PDOException (22001)]
  SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'etag' at row 1

Nextcloud 15.0.5.3 on Ubuntu 16.04 with PHP 7.2.16 and MySQL 5.7.25

@EugenVau
Copy link
Author

EugenVau commented Apr 9, 2019

No reaction in 27 days? Not even "won't fix / invalid / needs info / whatever"? Is this still maintained?

@borekon
Copy link

borekon commented May 30, 2019

Maybe you have to tweak a bit your sql server (use barracuda instead of antelope,etc)

@joshtrichards
Copy link
Member

Hi @EugenVau - Thanks for your report and I'm sorry you never saw a response on this. Since this is a bug reporting channel and not a tech support channel, reports are read and acted upon without individual follow-up in all cases.

In any case, this issue was fixed the day after your report. The issue was the etag was >40 characters was not being handled. This was an issue at the NC Server level - not in previewgenerator itself. It was fixed the day after your report in nextcloud/server#14684 and nextcloud/server#14694 and released in NC 15.0.6.

I think this Issue can safely be closed out.

@borekon
Copy link

borekon commented Jun 21, 2023

No reaction in 27 days? Not even "won't fix / invalid / needs info / whatever"? Is this still maintained?

Finally a reaction in 4 years... LOL

@st3iny
Copy link
Member

st3iny commented Jul 4, 2023

Closing as this was fixed in server.

@st3iny st3iny closed this as completed Jul 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants