Nextcloud version (eg, 10.0.2): Nextcloud 11.0.1 (stable)
Operating system and version (eg, Ubuntu 16.04): docker image nextcloud:11.0.1-apache
Apache or nginx version (eg, Apache 2.4.25): Server version: Apache/2.4.10 (Debian) Server built: Sep 15 2016 20:44:43
PHP version (eg, 5.6): PHP 5.6.30 (cli) (built: Jan 24 2017 19:28:09)
Is this the first time you’ve seen this error?: Yes
Can you reliably replicate it? (If so, please outline steps):
The issue you are facing:
I’m using AWS S3 as primary storage. During more than one week everything was going really good. But after sometimes, when someone try to upload a file (any size), he gets a little internal server error in the top of the website, but the file still gets uploaded and that file is working as intended.
The output of your Nextcloud log in Admin > Logging:
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE “oc_filecache” SET “path_hash” = ?, “path” = ?, “parent” = ?, “name” = ?, “mimepart” = ?, “mimetype” = ?, “size” = ?, “mtime” = ?, “storage_mtime” = ?, “encrypted” = ?, “etag” = ?, “permissions” = ?, “checksum”=? WHERE (“path_hash” <> ? OR “path” <> ? OR “parent” <> ? OR “name” <> ? OR “mimepart” <> ? OR “mimetype” <> ? OR “size” <> ? OR “mtime” <> ? OR “storage_mtime” <> ? OR “encrypted” <> ? OR “etag” <> ? OR “permissions” <> ? OR “checksum” <> ? OR “path_hash” IS NULL OR “path” IS NULL OR “parent” IS NULL OR “name” IS NULL OR “mimepart” IS NULL OR “mimetype” IS NULL OR “size” IS NULL OR “mtime” IS NULL OR “storage_mtime” IS NULL OR “encrypted” IS NULL OR “etag” IS NULL OR “permissions” IS NULL OR “checksum” IS NULL) AND “fileid” = ? ’ with params [“53064f3059381f240b610b4fc4104cc6”, “files/LIVRABLES/20170227/PSD13_INGE_GE.zip”, 78308, “PSD13_INGE_GE.zip”, 5, 19, 6646377, “1488152380.575”, 1488185217, 0, “58b3e781186c8”, 27, null, “53064f3059381f240b610b4fc4104cc6”, “files/LIVRABLES/20170227/PSD13_INGE_GE.zip”, 78308, “PSD13_INGE_GE.zip”, 5, 19, 6646377, “1488152380.575”, 1488185217, 0, “58b3e781186c8”, 27, null, 78330]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: “1488152380.575”`
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php $CONFIG = array ( 'instanceid' => 'xxxxxx', 'passwordsalt' => 'xxxxx', 'secret' => 'xxxxx', 'trusted_domains' => array ( 0 => 'xxxxx.fr', ), 'datadirectory' => '/var/www/html/data', 'overwrite.cli.url' => 'https://xxxxx.fr', 'dbtype' => 'pgsql', 'version' => '11.0.1.2', 'dbname' => 'xxxxxx', 'dbhost' => 'xxxxx.fr', 'dbport' => '', 'dbtableprefix' => 'oc_', 'dbuser' => 'xxxxx', 'dbpassword' => 'xxxxxxx', 'logtimezone' => 'UTC', 'installed' => true, 'objectstore' => array( 'class' => 'OC\\Files\\ObjectStore\\S3', 'arguments' => array( 'bucket' => 'XXXXX', 'autocreate' => true, 'key' => 'XXXXXX', 'secret' => 'XXXXXXX', 'hostname' => 's3-eu-west-1.amazonaws.com', 'region' => 'eu-west-1', ), ), );
The output of your Apache/nginx/system log in /var/log/____
:
n/c
Thanks for you help.