{"action":"opened","issue":{"url":"https://api.github.com/repos/nextcloud/server/issues/9265","repository_url":"https://api.github.com/repos/nextcloud/server","labels_url":"https://api.github.com/repos/nextcloud/server/issues/9265/labels{/name}","comments_url":"https://api.github.com/repos/nextcloud/server/issues/9265/comments","events_url":"https://api.github.com/repos/nextcloud/server/issues/9265/events","html_url":"https://github.com/nextcloud/server/issues/9265","id":316553307,"number":9265,"title":"postgres db conversion - value out of range","user":{"login":"mind22","id":26789520,"avatar_url":"https://avatars2.githubusercontent.com/u/26789520?v=4","gravatar_id":"","url":"https://api.github.com/users/mind22","html_url":"https://github.com/mind22","followers_url":"https://api.github.com/users/mind22/followers","following_url":"https://api.github.com/users/mind22/following{/other_user}","gists_url":"https://api.github.com/users/mind22/gists{/gist_id}","starred_url":"https://api.github.com/users/mind22/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mind22/subscriptions","organizations_url":"https://api.github.com/users/mind22/orgs","repos_url":"https://api.github.com/users/mind22/repos","events_url":"https://api.github.com/users/mind22/events{/privacy}","received_events_url":"https://api.github.com/users/mind22/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-22T06:27:59Z","updated_at":"2018-04-22T06:27:59Z","closed_at":null,"author_association":"NONE","body":"<!--\r\nThanks for reporting issues back to Nextcloud! This is the issue tracker of Nextcloud, if you have any support question please check out https://nextcloud.com/support\r\n\r\nThis is the bug tracker for the Server component. Find other components at https://github.com/nextcloud/\r\n\r\nFor reporting potential security issues please see https://nextcloud.com/security/\r\n\r\nTo make it possible for us to help you please fill out below information carefully. \r\nYou can also use the Issue Template application to prefill most of the required information: https://apps.nextcloud.com/apps/issuetemplate\r\n\r\nIf you are a customer, please submit your issue directly in the Nextcloud Portal https://portal.nextcloud.com so it gets resolved more quickly by our dedicated engineers.\r\n\r\nNote that Nextcloud is an open source project backed by Nextcloud GmbH. Most of our volunteers are home users and thus primarily care about issues that affect home users. Our paid engineers prioritize issues of our customers. If you are neither a home user nor a customer, consider paying somebody to fix your issue, do it yourself or become a customer.\r\n--> \r\n### Steps to reproduce\r\n1. Database conversion to Postgres\r\n\r\n### Additional Info\r\nAfter conversion there was also a picture which creation date was set to 2038. So i deleted it, then maintenance filescan worked again for that user.\r\n\r\n### Server configuration\r\n\r\n**Operating system**: Ubuntu 16.04 LTE\r\n\r\n**Web server:** nginx 1.14\r\n\r\n**Database:** Postgres 9.6\r\n\r\n**PHP version:** 7.1\r\n\r\n**Nextcloud version:** 13.0.2 RC1\r\n\r\n**Updated from an older Nextcloud/ownCloud or fresh install:** older\r\n\r\n**Where did you install Nextcloud from:** official\r\n\r\n**Signing status:**\r\n<details>\r\n<summary>Signing status</summary>\r\n\r\n```\r\nNo errors have been found.\r\n```\r\n\r\n</details>\r\n\r\n**List of activated apps:**\r\n<details>\r\n<summary>App list</summary>\r\n\r\n```\r\n  - activity: 2.6.1\r\n  - admin_audit: 1.3.0\r\n  - admin_notifications: 1.0.1\r\n  - announcementcenter: 3.2.1\r\n  - apporder: 0.4.1\r\n  - beame_insta_ssl: 0.0.6\r\n  - bookmarks: 0.11.0\r\n  - bruteforcesettings: 1.0.3\r\n  - calendar: 1.6.1\r\n  - circles: 0.13.6\r\n  - comments: 1.3.0\r\n  - contacts: 2.1.3\r\n  - dav: 1.4.6\r\n  - deck: 0.3.1\r\n  - drawio: 0.8.9\r\n  - drop_account: 0.0.7\r\n  - end_to_end_encryption: 1.0.5\r\n  - external: 3.0.2\r\n  - federatedfilesharing: 1.3.1\r\n  - federation: 1.3.0\r\n  - files: 1.8.0\r\n  - files_accesscontrol: 1.3.0\r\n  - files_external: 1.4.1\r\n  - files_latexeditor: true\r\n  - files_pdfviewer: 1.2.1\r\n  - files_retention: 1.2.0\r\n  - files_rightclick: 0.5.0\r\n  - files_sharing: 1.5.0\r\n  - files_texteditor: 2.5.1\r\n  - files_trashbin: 1.3.0\r\n  - files_versions: 1.6.0\r\n  - files_videoplayer: 1.2.0\r\n  - firstrunwizard: 2.2.1\r\n  - gallery: 18.0.0\r\n  - groupfolders: 1.2.0\r\n  - keeporsweep: 0.1.4\r\n  - logreader: 2.0.0\r\n  - lookup_server_connector: 1.1.0\r\n  - mail: 0.7.10\r\n  - metadata: 0.6.0\r\n  - music: 0.5.6\r\n  - news: 12.0.1\r\n  - nextcloud_announcements: 1.2.0\r\n  - notes: 2.3.2\r\n  - notifications: 2.1.2\r\n  - oauth2: 1.1.0\r\n  - passman: 2.1.4\r\n  - password_policy: 1.3.0\r\n  - previewgenerator: 1.0.9\r\n  - provisioning_api: 1.3.0\r\n  - quicknotes: 0.1.2\r\n  - ransomware_protection: 1.1.0\r\n  - serverinfo: 1.3.0\r\n  - sharebymail: 1.3.0\r\n  - socialsharing_email: 1.0.3\r\n  - socialsharing_twitter: 1.0.2\r\n  - spreed: 3.1.0\r\n  - survey_client: 1.1.0\r\n  - systemtags: 1.3.0\r\n  - theming: 1.4.1\r\n  - twofactor_backupcodes: 1.2.3\r\n  - twofactor_totp: 1.4.1\r\n  - updatenotification: 1.3.0\r\n  - workflowengine: 1.3.0\r\n```\r\n</details>\r\n\r\n**Nextcloud configuration:**\r\n<details>\r\n<summary>Config report</summary>\r\n\r\n```\r\n<?php\r\n$CONFIG = array (\r\n  'instanceid' => '...',\r\n  'passwordsalt' => '...',\r\n  'secret' => '...',\r\n  'trusted_domains' => \r\n  array (\r\n    0 => '...',\r\n  ),\r\n  'datadirectory' => '',\r\n  'overwrite.cli.url' => 'https://…‘,\r\n  'overwriteprotocol' => 'https',\r\n  'filesystem_check_changes' => 1,\r\n  'version' => '13.0.2.0',\r\n  'dbtype' => 'pgsql',\r\n  'dbname' => 'nextcloud_db',\r\n  'dbuser' => '...',\r\n  'dbpassword' => '...',\r\n  'dbhost' => 'localhost',\r\n  'dbtableprefix' => 'oc_',\r\n  'logtimezone' => '...',\r\n  'installed' => true,\r\n  'logfile' => '...',\r\n  'loglevel' => 2,\r\n  'maintenance' => false,\r\n  'memcache.local' => '\\\\OC\\\\Memcache\\\\Redis',\r\n  'memcache.distributed' => '\\\\OC\\\\Memcache\\\\Redis',\r\n  'filelocking.enabled' => 'true',\r\n  'memcache.locking' => '\\\\OC\\\\Memcache\\\\Redis',\r\n  'redis' => \r\n  array (\r\n    'host' => '/var/run/redis/redis.sock',\r\n    'port' => 0,\r\n    'dbindex' => 0,\r\n    'password' => '...',\r\n    'timeout' => 0.0,\r\n  ),\r\n  'filelocking.ttl' => 3600,\r\n  'share_folder' => '/Mit Dir geteilt',\r\n  'mail_smtpmode' => 'smtp',\r\n  'theme' => '',\r\n  'updater.release.channel' => 'beta',\r\n  'trashbin_retention_obligation' => 'auto, 30',\r\n  'updater.secret' => '...',\r\n);\r\n```\r\n</details>\r\n\r\n**Are you using external storage, if yes which one:** no\r\n\r\n**Are you using encryption:** no\r\n\r\n\r\n### Logs\r\n\r\n#### Nextcloud log (data/nextcloud.log)\r\n<details>\r\n<summary>Nextcloud log</summary>\r\n\r\n```\r\nDoctrine\\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\" >= ?))' with params [4, 10, 3, -62104229679]: SQLSTATE[22003]: Numeric value out of range: 7 ERROR: value \"-62104229679\" is out of range for type integer\r\n/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\r\n/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 855: Doctrine\\DBAL\\DBALException driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'SELECT \"fileid\"...', Array)\r\n/var/www/nextcloud/lib/private/DB/Connection.php - line 195: Doctrine\\DBAL\\Connection->executeQuery('SELECT \"fileid\"...', Array, Array, NULL)\r\n/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 206: OC\\DB\\Connection->executeQuery('SELECT \"fileid\"...', Array, Array)\r\n/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214: Doctrine\\DBAL\\Query\\QueryBuilder->execute()\r\n/var/www/nextcloud/lib/private/Files/Cache/Cache.php - line 697: OC\\DB\\QueryBuilder\\QueryBuilder->execute()\r\n/var/www/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php - line 233: OC\\Files\\Cache\\Cache->searchQuery(Object(OC\\Files\\Search\\SearchQuery))\r\n/var/www/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php - line 233: OC\\Files\\Cache\\Wrapper\\CacheWrapper->searchQuery(Object(OC\\Files\\Search\\SearchQuery))\r\n[internal function] OC\\Files\\Cache\\Wrapper\\CacheWrapper->searchQuery(Object(OC\\Files\\Search\\SearchQuery))\r\n/var/www/nextcloud/lib/private/Files/Node/Folder.php - line 245: call_user_func_array(Array, Array)\r\n/var/www/nextcloud/lib/private/Files/Node/Folder.php - line 201: OC\\Files\\Node\\Folder->searchCommon('searchQuery', Array)\r\n/var/www/nextcloud/apps/dav/lib/Files/FileSearchBackend.php - line 158: OC\\Files\\Node\\Folder->search(Object(OC\\Files\\Search\\SearchQuery))\r\n/var/www/nextcloud/3rdparty/icewind/searchdav/src/DAV/SearchHandler.php - line 75: OCA\\DAV\\Files\\FileSearchBackend->search(Object(SearchDAV\\XML\\BasicSearch))\r\n/var/www/nextcloud/3rdparty/icewind/searchdav/src/DAV/SearchPlugin.php - line 123: SearchDAV\\DAV\\SearchHandler->handleSearchRequest(Array, Object(Sabre\\HTTP\\Response))\r\n[internal function] SearchDAV\\DAV\\SearchPlugin->searchHandler(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\r\n/var/www/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php - line 105: call_user_func_array(Array, Array)\r\n/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 479: Sabre\\Event\\EventEmitter->emit('method SEARCH', Array)\r\n/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 254: Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\r\n/var/www/nextcloud/apps/dav/lib/Server.php - line 283: Sabre\\DAV\\Server->exec()\r\n/var/www/nextcloud/apps/dav/appinfo/v2/remote.php - line 35: OCA\\DAV\\Server->exec()\r\n/var/www/nextcloud/remote.php - line 164: require_once('/var/www/nextcl...')\r\n{main}\r\n```\r\n</details>\r\n\r\n"}}
{"actor":{"display_login":"mind22"}}