"recent" takes much to long to be usable

ferdiga commented 3 years ago

click on "recent" should return recently uploaded/modified files immediately it takes much to long to be useful

Steps to reproduce

click on recent

Expected behaviour

immediate display of "recent" files

Actual behaviour

very very long waiting time

Server configuration detail

Operating system: Linux 4.9.0-14-amd64 nextcloud/server#1 SMP Debian 4.9.240-2 (2020-10-30) x86_64

Webserver: Apache/2.4.25 (Debian) (apache2handler)

Database: mysql 10.4.8

PHP version:

7.3.21-1+0~20200807.66+debian9~1.gbp18a1c2 Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, sodium, session, standard, apache2handler, mysqlnd, PDO, xml, apcu, bcmath, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, imagick, intl, json, ldap, exif, mysqli, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, apc, posix, readline, shmop, SimpleXML, smbclient, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xmlreader, xmlwriter, xsl, zip, Phar, libsmbclient, Zend OPcache

Nextcloud version: 19.0.5 - 19.0.5.2

Updated from an older Nextcloud/ownCloud or fresh install:

Where did you install Nextcloud from: unknown

Signing status

Array ( )

List of activated apps

``` Enabled: - accessibility: 1.5.0 - activity: 2.12.1 - admin_audit: 1.9.0 - analytics: 2.5.0 - announcementcenter: 3.8.1 - apporder: 0.11.0 - audioplayer: 2.13.0 - bruteforcesettings: 2.0.1 - calendar: 2.0.4 - carnet: 0.23.7 - cloud_federation_api: 1.2.0 - comments: 1.9.0 - contacts: 3.4.2 - contactsinteraction: 1.0.0 - dashboard: 6.0.0 - dav: 1.15.0 - deck: 1.2.1 - drawio: 0.9.7 - emlviewer: 0.0.21 - external: 3.6.0 - federatedfilesharing: 1.9.0 - files: 1.14.0 - files_automatedtagging: 1.9.0 - files_downloadactivity: 1.8.0 - files_external: 1.10.0 - files_fulltextsearch: 1.4.3 - files_fulltextsearch_tesseract: 1.4.2 - files_pdfviewer: 1.8.0 - files_photospheres: 1.19.1 - files_rightclick: 0.16.0 - files_sharing: 1.11.0 - files_trashbin: 1.9.0 - files_versions: 1.12.0 - files_videoplayer: 1.8.0 - fulltextsearch: 1.4.2 - fulltextsearch_elasticsearch: 1.5.2 - groupfolders: 7.1.1 - issuetemplate: 0.7.0 - logreader: 2.4.0 - lookup_server_connector: 1.7.0 - metadata: 0.12.0 - nextcloud_announcements: 1.8.0 - notes: 3.6.4 - notifications: 2.7.0 - oauth2: 1.7.0 - ocr: 6.0.57 - ocsms: 2.1.8 - password_policy: 1.9.1 - phonetrack: 0.6.4 - photos: 1.1.0 - previewgenerator: 2.3.0 - privacy: 1.3.0 - provisioning_api: 1.9.0 - quickaccesssorting: 1.1.1 - quicknotes: 0.6.3 - quota_warning: 1.8.0 - rainloop: 7.0.3 - recommendations: 0.7.0 - richdocuments: 3.7.9 - richdocumentscode: 6.4.14 - serverinfo: 1.9.0 - settings: 1.1.0 - sharebymail: 1.9.0 - socialsharing_email: 2.1.0 - spreed: 9.0.6 - support: 1.2.1 - survey_client: 1.7.0 - suspicious_login: 3.2.1 - systemtags: 1.9.0 - tasks: 0.13.6 - text: 3.0.1 - theming: 1.10.0 - twofactor_backupcodes: 1.8.0 - updatenotification: 1.9.0 - user_usage_report: 1.3.3 - viewer: 1.3.0 - workflow_ocr: 1.19.1 - workflow_pdf_converter: 1.4.0 - workflow_script: 1.4.0 - workflowengine: 2.1.0 Disabled: - circles - cms_pico - dashboardcharts - encryption - federation - files_accesscontrol - files_retention - firstrunwizard - mail - ojsxc - printer - registration - user_ldap - wopi ```

Configuration (config/config.php)

``` { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "19.0.5.2", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "debug": false, "installed": true, "enable_previews": true, "forcessl": true, "theme": "", "maintenance": false, "mail_smtpmode": "smtp", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "587", "mail_smtptimeout": 10, "loglevel": 3, "allow_local_remote_servers": true, "share_folder": "\/Shared", "trusted_domains": [ "service.chricar.at" ], "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "singleuser": false, "forceSSLforSubdomains": true, "trashbin_retention_obligation": "auto", "filelocking.enabled": "true", "filesystem_check_changes": 1, "mail_smtpauthtype": "PLAIN", "mail_smtpsecure": "tls", "mail_smtpauth": 1, "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "auth.bruteforce.protection.enabled": true, "overwriteprotocol": "https", "overwrite.cli.url": "https:\/\/service.chricar.at\/owncloud", "updater.release.channel": "stable", "memcache.local": "\\OC\\Memcache\\APCu", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 6379, "password": "***REMOVED SENSITIVE VALUE***", "timeout": 1.5 }, "preview_max_x": 512, "preview_max_y": 512, "preview_max_scale_factor": 1, "preview_libreoffice_path": "\/usr\/bin\/libreoffice", "enabledPreviewProviders": [ "OC\\Preview\\Image", "OC\\Preview\\MP3", "OC\\Preview\\TXT", "OC\\Preview\\PDF", "OC\\Preview\\Movie", "OC\\Preview\\Photoshop", "OC\\Preview\\TIFF", "OC\\Preview\\SVG", "OC\\Preview\\OpenDocument" ], "has_rebuilt_cache": true, "mysql.utf8mb4": true, "app_install_overwrite": [ "files_clipboard", "files_accesscontrol", "issuetemplate", "dashboard", "files_external_gdrive", "ojsxc", "quickaccesssorting", "ocr" ], "0": { "verify_peer_off": true }, "data-fingerprint": "2e5954a0f3c41d5dc2c0cd22b19dc1e0", "updater.secret": "***REMOVED SENSITIVE VALUE***" } ```

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption:

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

Client configuration

Browser: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36

Operating system:

Logs

Web server error log

``` Insert your web server log here ```

Nextcloud log

``` Insert your Nextcloud log here ```

Browser log

Insert your browser log here, this could for example include: a) The javascript console log b) The network log c) ...

How to use GitHub

Please use the 👍 reaction to show that you are affected by the same issue.
Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
Subscribe to receive notifications on status change and new comments.

Steps to reproduce

1. 2. 3.

Expected behaviour

Tell us what should happen

Actual behaviour

Tell us what happens instead

Server configuration

Operating system:

Web server:

Database:

PHP version:

Nextcloud version: (see Nextcloud admin page)

Updated from an older Nextcloud/ownCloud or fresh install:

Where did you install Nextcloud from:

Signing status:

Signing status

``` Login as admin user into your Nextcloud and access http://example.com/index.php/settings/integrity/failed paste the results here. ```

List of activated apps:

App list

``` If you have access to your command line run e.g.: sudo -u www-data php occ app:list from within your Nextcloud installation folder ```

Nextcloud configuration:

Config report

``` If you have access to your command line run e.g.: sudo -u www-data php occ config:list system from within your Nextcloud installation folder or Insert your config.php content here. Make sure to remove all sensitive content such as passwords. (e.g. database password, passwordsalt, secret, smtp password, …) ```

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption: yes/no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

LDAP configuration (delete this part if not used)

LDAP config

``` With access to your command line run e.g.: sudo -u www-data php occ ldap:show-config from within your Nextcloud installation folder Without access to your command line download the data/owncloud.db to your local computer or access your SQL server remotely and run the select query: SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap'; Eventually replace sensitive data as the name/IP-address of your LDAP server or groups. ```

Client configuration

Browser:

Operating system:

Logs

Web server error log

``` Insert your webserver log here ```

Nextcloud log (data/nextcloud.log)

Nextcloud log

``` Insert your Nextcloud log here ```

Browser log

``` Insert your browser log here, this could for example include: a) The javascript console log b) The network log c) ... ```

ChristophWurst commented 3 years ago

@szaimen I'm not sure about the move. There is an item with Recent in the Files app and I think that's the one that is slow

szaimen commented 3 years ago

Yes but since the items get loaded from the recommendations app into the files app, I thought that this needs to be fixed in the recommendations app...

ChristophWurst commented 3 years ago

No, the API and all other code is from files/server

szaimen commented 3 years ago

@ferdiga Can you please try again if it is still an issue on NC21.0.3? Thank you!

ferdiga commented 3 years ago

21.0.3. as well as 20.0.9 return the recent files reasonably fast.

szaimen commented 3 years ago

So the issue can be closed then? :)

ferdiga commented 3 years ago

I think soOn Tue 6. Jul 2021 at 17:40, szaimen @.***> wrote: So the issue can be closed then? :)

?You are receiving this because you were mentioned.Reply to this email directly, view it on GitHub, or unsubscribe.

nextcloud / server