[Bug]: php-fpm eats all cpus executing select from oc_schedulingobjects #39758
Labels
0. Needs triage
Pending check for reproducibility or if it fits our roadmap
27-feedback
bug
feature: caldav
Related to CalDAV internals
needs info
stale
Ticket or PR with no recent activity
Comments
p5n
added
bug
0. Needs triage
|
Logged execution time from apache - 25-50 sec and even more Can it be because of huge oc_schedulingobjects table and many shared calendars? |
|
Perhaps #45235 will help with this? |
|
It should, I fixed it by adding to cron.daily so far so good |
|
This issue has been automatically marked as stale because it has not had recent activity and seems to be missing some essential information. It will be closed if no further activity occurs. Thank you for your contributions. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Bug description
pgtop shows
apachetop shows ~7-8 req/sec most of them are not about calendar
Steps to reproduce
On my installation with ~500 users and 20-30 shared calendars (some of them shared for all) you need just wait for some time. For me it does not look like nextcloud is highly loaded, it looks like some infinite loops execute sql.
oc_schedulingobjects contains more than 1 000 000 records.
Expected behavior
Do not eat all cpu cores on less than 10 http requests per second
Installation method
Other Community project
Nextcloud Server version
27
Operating system
Other
PHP engine version
PHP 8.1
Web server
Apache (supported)
Database engine version
PostgreSQL
Is this bug present after an update or on a fresh install?
Upgraded to a MAJOR version (ex. 22 to 23)
Are you using the Nextcloud Server Encryption module?
Encryption is Disabled
What user-backends are you using?
Configuration report
{ "system": { "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "pgsql", "version": "27.0.1.2", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "loglevel": 2, "log_type": "file", "logfile": "\/var\/log\/nextcloud\/nextcloud.log", "log_query": false, "log_rotate_size": 268435456, "lastupdatedat": "1328756567.0597", "forcessl": true, "enablebackup": false, "maxZipInputSize": "20971520", "allowZipDownload": true, "instanceid": "***REMOVED SENSITIVE VALUE***", "ldapIgnoreNamingRules": false, "passwordsalt": "***REMOVED SENSITIVE VALUE***", "defaultapp": "dashboard", "maintenance": false, "theme": "", "overwrite.cli.url": "https:\/\/cloud.dsr-corporation.com", "overwritehost": "cloud.dsr-corporation.com", "overwritewebroot": "\/", "trusted_domains": [ "cloud.dsr-corporation.com" ], "trusted_proxies": "***REMOVED SENSITIVE VALUE***", "appstoreenabled": false, "secret": "***REMOVED SENSITIVE VALUE***", "debug": false, "filelocking.enabled": true, "trashbin_retention_obligation": "disabled", "versions_retention_obligation": "disabled", "htaccess.RewriteBase": "\/", "ldapProviderFactory": "\\OCA\\User_LDAP\\LDAPProviderFactory", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "sendmail", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpauthtype": "LOGIN", "simpleSignUpLink.shown": false, "onlyoffice": { "verify_peer_off": true }, "app_install_overwrite": [ "files_markdown", "onlyoffice", "tasks", "rainloop", "social", "keeweb", "impersonate", "talk_matterbridge", "twofactor_totp", "polls", "calendar_resource_management", "end_to_end_encryption", "forms", "previewgenerator" ], "mysql.utf8mb4": true, "mail_sendmailmode": "pipe", "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.local": "\\OC\\Memcache\\APCu", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 6379 }, "memcache.locking": "\\OC\\Memcache\\Redis", "default_phone_region": "US" } }List of activated Apps
Nextcloud Signing status
Nextcloud Logs
Additional info
Nextcloud intallation from ArchLinux repos
The text was updated successfully, but these errors were encountered: