heavy on server
Nobody has claimed this yet.
- Dominant language
- Swift
- Stars
- 2.5k
- Forks
- 1k
- Avg merge
- 2d 18h
- Merged PRs (30d)
- 13
Description
Expected behaviour
stress nextcloud server similar to nextcloud webUI or android nextcloud app, or webdav cases
Actual behaviour
caused heavy mysql usage on nextcloud server (ubuntu nextcloud snap) - often mysql process takes 50-150% cpu/core lasting hour and more, even after killing nextcloud ios app. stressed server always result in nextcloud ios app to timeout even on most simple file access, and cause timeout problem for android nextcloud app
Only notices the problem recently, with app timeouts and super heavy mysql process on nextcloud server
Steps to reproduce
install nextcloud ios app, setup account, no change to settings
Reasoning or why should it be changed/implemented?
nextcloud app never update file changes
iOS version
tested on both iPadOS 13.3.1 and iOS 12.4.5, same result
App version
2.52.9
Server configuration
nextcloud server from Ubuntu snap store, configured with sftp external storage on local account
Operating system:
Ubuntu 19.10
Web server:
Apache, part of Ubuntu snap packaged nextcloud server
Database:
MySQL, part of Ubuntu snap packaged nextcloud server
PHP version:
part of Ubuntu snap packaged nextcloud server
Nextcloud version: (see Nextcloud admin page)
17.0.3
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the issue with iOS app 2.52.9 against Nextcloud 17.0.3 from the Ubuntu snap, using the reported MySQL setup and SFTP external storage. Observe whether file-change checks produce sustained MySQL CPU usage and timeouts; done means file updates work without prolonged server load or app access timeouts.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- apache, ios, mysql, php, swift, ubuntu
- Domain
- backend, database, mobile
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100