[Bug]: The database keeps growing after upgrade to 29.0.0 #45046
Comments
janusn
added
0. Needs triage
|
Thanks for your report! |
|
Thanks for the prompt reply. I have check the database. The table seems to be growing was oc_filecache. It has slowed down and becomes stable again. I will keep an eye on how it goes for next couple days. The following are the output of |
|
It seems stable so far. It might be caused by something else. |
|
This is happening to me right now. It seems to be caused by a full file scan that is also generating previews of all images. EDIT: EDIT 2: |
Bug description
The database keeps growing since nextcloud server was upgraded to 29.0.0 yesterday morning. The growth seems to be accelerating! 😱
On my set up, there is a dvr rotating video file on an external storage but the database did not grow before nc29. The number of video files are more or less before and after the nc update.
I run
occ files:scan <user> --path="<path>"and$ occ preview:generate-allevery 4 hours in order to generate preview for external storages. However, I have noticed the database grows continuously, independent of the files:scan and preview:generate-all.I have checked the size of the database directory based on snapshots. Here is a summary of the size of the database directory as reported by
$ du -sm:nc updated to 29.0.0 at 05:16
Steps to reproduce
Expected behavior
The size of the database remain stable.
Installation method
Community Docker image
Nextcloud Server version
29
Operating system
Debian/Ubuntu
PHP engine version
PHP 8.3
Web server
Nginx
Database engine version
MariaDB
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?
None
What user-backends are you using?
Configuration report
{ "system": { "memcache.local": "\\OC\\Memcache\\APCu", "datadirectory": "***REMOVED SENSITIVE VALUE***", "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "***REMOVED SENSITIVE VALUE***", "***REMOVED SENSITIVE VALUE***", "***REMOVED SENSITIVE VALUE***", "***REMOVED SENSITIVE VALUE***" ], "version": "29.0.0.19", "trusted_proxies": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***", "overwritehost": "***REMOVED SENSITIVE VALUE***", "overwriteprotocol": "https", "installed": true, "default_phone_region": "GB", "maintenance": false, "loglevel": 2, "theme": "", "filelocking.enabled": "true", "upgrade.disable-web": true, "filesystem_check_changes": 0, "maintenance_window_start": 1, "dbtype": "mysql", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "mysql.utf8mb4": true, "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "mail_smtpsecure": "tls", "mail_sendmailmode": "smtp", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpauthtype": "LOGIN", "mail_smtpauth": 1, "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "587", "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "jpeg_quality": "80", "preview_max_scale_factor": 1, "enabledPreviewProviders": [ "OC\\Preview\\BMP", "OC\\Preview\\GIF", "OC\\Preview\\JPEG", "OC\\Preview\\Krita", "OC\\Preview\\MarkDown", "OC\\Preview\\OpenDocument", "OC\\Preview\\PNG", "OC\\Preview\\TXT", "OC\\Preview\\XBitmap" ], "preview_imaginary_url": "***REMOVED SENSITIVE VALUE***", "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 6379, "timeout": 1.5 } } }List of activated Apps
Nextcloud Signing status
Nextcloud Logs
Additional info
No response
The text was updated successfully, but these errors were encountered: