Request failed: internal server error (500)

  • Nextcloud version: 17.0.3
  • Operating system and version: CentOS 6
  • Apache or nginx version: apache 2.2.15 | nginx 1.16.1 (reverse proxy)
  • PHP version: 7.2

The official Nextcloud app for iOS is installed. after logging in with the old authorization method, the error “Request failed: internal server error (500)” is displayed.
it appears once upon the first authorization. after which the error window disappears and the application works as usual.

I use the old authorization method because I can’t use the standard one because I have nginx with reverse proxies and balancers. when I try to log in by default, I get the error “csrf check failed”. the option with “overwriteprotocol => https” helps with this error “csrf …”, but it doesn’t suit me because of the limitations of the infrastructure.

Is this the first time you’ve seen this error?:
Yes

Steps to replicate it:

  1. Open the Nextcloud app for iOS
  2. login to your account using the old authorization method
  3. get error 500

The output of your Nextcloud log:

[webdav] Fatal: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT "fileid", "storage", "path", "parent", "name", "mimetype", "mimepart", "size", "mtime", "storage_mtime", "encrypted", "etag", "permissions", "checksum" FROM "oc_filecache" "file" WHERE ("storage" = ?) AND ((("mimepart" = ?) OR ("mimepart" = ?)) AND (("mtime" <= ?) AND ("mtime" >= ?))) ORDER BY "mtime" desc, "name" desc' with params [35, 6, 14, 1583236445, -62135587783]:

SQLSTATE[22003]: Numeric value out of range: 7 ERROR: value "-62135587783" out of range for type integer at <<closure>>

 0. /var/www/html/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
    Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException("An exception oc ... r", Doctrine\DBAL\Dr ... ]})
 1. /var/www/html/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
    Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOPgSql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... r")
 2. /var/www/html/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 911
    Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOPgSql\Driver {}, Doctrine\DBAL\Dr ... ]}, "SELECT \"fileid ... c", {1: 35,2: 6,3: 1 ... 3})
 3. /var/www/html/owncloud/lib/private/DB/Connection.php line 195
    Doctrine\DBAL\Connection->executeQuery("SELECT \"fileid ... c", [35,6,14,1583236445,-62135587783], [2,1,1,1,1], null)
 4. /var/www/html/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 200
    OC\DB\Connection->executeQuery("SELECT \"fileid ... c", {dcValue1: 35,dc ... 3}, {dcValue1: 2,dcV ... 1})
 5. /var/www/html/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 214
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /var/www/html/owncloud/lib/private/Files/Cache/Cache.php line 722
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. <<closure>>
    OC\Files\Cache\Cache->searchQuery(OC\Files\Search\SearchQuery {})
 8. /var/www/html/owncloud/lib/private/Files/Node/Folder.php line 249
    undefinedundefinedcall_user_func_array([OC\Files\Cache\ ... "], [OC\Files\Search\SearchQuery {}])
 9. /var/www/html/owncloud/lib/private/Files/Node/Folder.php line 205
    OC\Files\Node\Folder->searchCommon("searchQuery", [OC\Files\Search\SearchQuery {}])
10. /var/www/html/owncloud/apps/dav/lib/Files/FileSearchBackend.php line 158
    OC\Files\Node\Folder->search(OC\Files\Search\SearchQuery {})
11. /var/www/html/owncloud/apps/dav/lib/Files/LazySearchBackend.php line 65
    OCA\DAV\Files\FileSearchBackend->search(SearchDAV\Query\ ... }})
12. /var/www/html/owncloud/3rdparty/icewind/searchdav/src/DAV/SearchHandler.php line 81
    OCA\DAV\Files\LazySearchBackend->search(SearchDAV\Query\ ... }})
13. /var/www/html/owncloud/3rdparty/icewind/searchdav/src/DAV/SearchPlugin.php line 123
    SearchDAV\DAV\SearchHandler->handleSearchRequest({{DAV:}basicsear ... }}, Sabre\HTTP\Response {})
14. <<closure>>
    SearchDAV\DAV\SearchPlugin->searchHandler(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
15. /var/www/html/owncloud/3rdparty/sabre/event/lib/EventEmitterTrait.php line 105
    undefinedundefinedcall_user_func_array([SearchDAV\DAV\S ... "], [Sabre\HTTP\Requ ... }])
16. /var/www/html/owncloud/3rdparty/sabre/dav/lib/DAV/Server.php line 479
    Sabre\Event\EventEmitter->emit("method:SEARCH", [Sabre\HTTP\Requ ... }])
17. /var/www/html/owncloud/3rdparty/sabre/dav/lib/DAV/Server.php line 254
    Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
18. /var/www/html/owncloud/apps/dav/lib/Server.php line 317
    Sabre\DAV\Server->exec()
19. /var/www/html/owncloud/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
20. /var/www/html/owncloud/remote.php line 163
    undefinedundefinedrequire_once("/var/www/html/o ... p")

SEARCH /remote.php/dav
from 31.111.29.111 by grigor at 2020-03-03T14:54:08+03:00

The output of your config.php:

<?php
$CONFIG = array (
  'instanceid' => 'XXXXX',
  'passwordsalt' => 'XXXXX',
  'secret' => 'XXXXX',
  'trusted_domains' =>.
  array (
    0 => 'share.domain.ru',
    1 => 'share.domain.loc',
    2 => 'wmail.domain.ru',
    3 => 'wmail.domain.loc',
  ),
  'datadirectory' => '/var/www/html/owncloud-data',
  'overwrite.cli.url' => 'https://share.domain.ru',
  'dbtype' => 'pgsql',
  'version' => '17.0.3.1',
  'dbname' => 'share.domain.ru',
  'dbhost' => '11.1.1.11:XXXX',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'share.domain.ru_owner',
  'dbpassword' => 'XXXX',
  'logtimezone' => 'Europe/Moscow',
  'installed' => true,
  'ldapIgnoreNamingRules' => false,
  'theme' => '',
  'kolaburl' => 'https://wmail.domain.ru',
  'kolabsecret' => 'XXXX',
  'mail_from_address' => 'share',
  'mail_smtpmode' => 'smtp',
  'mail_domain' => 'domain.ru',
  'mail_smtpauth' => 1,
  'mail_smtpname' => 'share',
  'mail_smtppassword' => 'XXXX',
  'log_type' => 'owncloud',
  'logfile' => '/var/www/html/owncloud-data/owncloud.log',
  'loglevel' => 3,
  'log_query' => false,
  'cron_log' => true,
  'maintenance' => false,
  'mail_smtphost' => 'mx2.domain.ru',
  'mail_smtpport' => '25',
  'mail_smtpauthtype' => 'PLAIN',
  'mail_smtpsecure' => 'tls',
  'appstore.experimental.enabled' => true,
  'preview_libreoffice_path' => '/usr/bin/libreoffice',
  'updatechecker' => false,
  'trashbin_retention_obligation' => 'auto',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' =>.
  array (
    'host' => 'localhost',
    'port' => XXXX,
  ),
  'asset-pipeline.enabled' => true,
  'ldapProviderFactory' => '\\OCA\\User_LDAP\\LDAPProviderFactory',
  'mail_sendmailmode' => 'smtp',
);

The output of your Apache/nginx/system log in /var/log/____:

I can`t provide logs