abraunegg / onedrive

OneDrive Client for Linux
https://abraunegg.github.io
GNU General Public License v3.0
10.22k stars 867 forks source link

Bug: items.sqlite3-wal grown to 2.2GB? #2844

Closed kastl-ars closed 2 months ago

kastl-ars commented 2 months ago

Describe the bug

For some reason the items.sqlite3-wal file in my ~/.config/onedrive/ directory has grown to 2.2GB in size.

ls -lh .config/onedrive/
insgesamt 2,2G
-rw-r--r--. 1 XXX YYY 72K 23. Sep 12:57 items.sqlite3
-rw-r--r--. 1 XXX YYY 1,9M 23. Sep 12:57 items.sqlite3-shm
-rw-r--r--. 1 XXX YYY 2,2G 23. Sep 12:57 items.sqlite3-wal
-rw-------. 1 XXX YYY  941 22. Mär 2024  refresh_token

Not sure if this is to be expected?

Kind Regards Johannes

Operating System Details

Linux XXX 6.10.11-1-default #1 SMP PREEMPT_DYNAMIC Thu Sep 19 07:33:24 UTC 2024 (bd33620) x86_64 x86_64 x86_64 GNU/Linux

openSUSE Tumbleweed

Client Installation Method

From Distribution Package

OneDrive Account Type

Business | Office365

What is your OneDrive Application Version

onedrive v2.4.25

What is your OneDrive Application Configuration

onedrive version                             = v2.4.25
Config path                                  = /home/XXX/.config/onedrive
Config file found in config path             = false
Config option 'sync_dir'                     = /home/XXX/OneDrive
Config option 'enable_logging'               = false
Config option 'log_dir'                      = /var/log/onedrive/
Config option 'disable_notifications'        = false
Config option 'min_notify_changes'           = 5
Config option 'skip_dir'                     = 
Config option 'skip_dir_strict_match'        = false
Config option 'skip_file'                    = ~*|.~*|*.tmp
Config option 'skip_dotfiles'                = false
Config option 'skip_symlinks'                = false
Config option 'monitor_interval'             = 300
Config option 'monitor_log_frequency'        = 6
Config option 'monitor_fullscan_frequency'   = 12
Config option 'read_only_auth_scope'         = false
Config option 'dry_run'                      = false
Config option 'upload_only'                  = false
Config option 'download_only'                = false
Config option 'local_first'                  = false
Config option 'check_nosync'                 = false
Config option 'check_nomount'                = false
Config option 'resync'                       = false
Config option 'resync_auth'                  = false
Config option 'cleanup_local_files'          = false
Config option 'classify_as_big_delete'       = 1000
Config option 'disable_upload_validation'    = false
Config option 'bypass_data_preservation'     = false
Config option 'no_remote_delete'             = false
Config option 'remove_source_files'          = false
Config option 'sync_dir_permissions'         = 700
Config option 'sync_file_permissions'        = 600
Config option 'space_reservation'            = 52428800
Config option 'application_id'               = 
Config option 'azure_ad_endpoint'            = 
Config option 'azure_tenant_id'              = common
Config option 'user_agent'                   = 
Config option 'force_http_11'                = false
Config option 'debug_https'                  = false
Config option 'rate_limit'                   = 0
Config option 'operation_timeout'            = 3600
Config option 'dns_timeout'                  = 60
Config option 'connect_timeout'              = 10
Config option 'data_timeout'                 = 600
Config option 'ip_protocol_version'          = 0
Config option 'sync_root_files'              = false
Selective sync 'sync_list' configured        = false
Config option 'sync_business_shared_folders' = false
Business Shared Folders configured           = false
Config option 'webhook_enabled'              = false

What is your 'curl' version

curl 8.10.0 (x86_64-suse-linux-gnu) libcurl/8.10.0 OpenSSL/3.1.4 zlib/1.3.1 brotli/1.1.0 zstd/1.5.6 libidn2/2.3.7 libpsl/0.21.5 libssh/0.10.6/openssl/zlib nghttp2/1.62.1 OpenLDAP/2.6.8
Release-Date: 2024-09-11
Protocols: dict file ftp ftps gopher gophers http https imap imaps ipfs ipns ldap ldaps mqtt pop3 pop3s rtsp scp sftp smb smbs smtp smtps telnet tftp
Features: alt-svc AsynchDNS brotli GSS-API HSTS HTTP2 HTTPS-proxy IDN IPv6 Kerberos Largefile libz NTLM PSL SPNEGO SSL threadsafe TLS-SRP UnixSockets zstd

Where is your 'sync_dir' located

Local

What are all your system 'mount points'

$ mount|grep home
/dev/nvme0n1p2 on /home type btrfs (rw,relatime,seclabel,ssd,discard=async,space_cache=v2,subvolid=262,subvol=/@/home)

What are all your local file system partition types

BTRFS

How do you use 'onedrive'

Only one system is using Onedrive, which is this one.

Steps to reproduce the behaviour

I have no idea if this is reproducible.

Complete Verbose Log Output

App is currently running, can send the logs later.

Screenshots

No response

Other Log Information or Details

No response

Additional context

No response

kastl-ars commented 2 months ago

309 describes something similar, was but apparently fixed?

abraunegg commented 2 months ago

@kastl-ars Please upgrade your client to v2.5.0 - older clients are not supported. It may mean you need to build from source until your distribution updates the packages or you raise a bug with them to fix:

image

kastl-ars commented 2 months ago

Thanks for the reply, I will see if I can upgrade.

In the meantime, what do I do with the big file? Delete? Keep?

abraunegg commented 2 months ago

Shut down the application in a graceful manner and the file should be cleaned up correctly.

v2.5.0 performs more checkpoints than v2.4.x and this is the reason for such a large file

abraunegg commented 2 months ago

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.