File lock problems after upgrade to 33.0.0.16

The Basics

  • Nextcloud Server version (e.g., 29.x.x):
    • 33.0.0.16
  • Operating system and version (e.g., Ubuntu 24.04):
    • Ubuntu 24.04.4 LTS
  • Web server and version (e.g, Apache 2.4.25):
    • Nginx 1.29.6
  • Reverse proxy and version _(e.g. nginx 1.27.2)
    • NO
  • PHP version (e.g, 8.3):
    • 8.3
  • Is this the first time you’ve seen this error? (Yes / No):
    • YES
  • When did this problem seem to first start?
    • after upgrade to 33.0.0
  • Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
    • Virtual Machine
  • Are you using CloudfIare, mod_security, or similar? (Yes / No)
    • NO

Summary of the issue you are facing:

File lock doesn’t work. If a user opens a file, such as an .xlsx file, using Office, it doesn’t go into a locked state, meaning other users can open and edit it. Users are using Windows 11 and desktop client 4.0.7. In table oc_files_lock

Steps to replicate it (hint: details matter!):

  1. Open an excel file

  2. File is not locked and there’s no lock icon.

  3. Another user can open and modify the file

Log entries

Nextcloud

Please provide the log entries from your Nextcloud log that are generated during the time of problem (via the Copy raw option from Administration settings->Logging screen or from your nextcloud.log located in your data directory). Feel free to use a pastebin/gist service if necessary.

There is no log entries

Web Browser

If the problem is related to the Web interface, open your browser inspector Console and Network tabs while refreshing (reloading) and reproducing the problem. Provide any relevant output/errors here that appear.

PASTE

Web server / Reverse Proxy

The output of your Apache/nginx/system log in /var/log/____:

PASTE HERE

Configuration

Nextcloud

The output of occ config:list system or similar is best, but, if not possible, the contents of your config.php file from /path/to/nextcloud is fine (make sure to remove any identifiable information!):

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "cloud.studiopippo.eu",
            "127.0.0.1",
            "10.0.32.10"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "33.0.0.16",
        "overwrite.cli.url": "https:\/\/cloud.studiopippo.eu",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "filelocking.enabled": true,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "dbindex": 0,
            "password": "***REMOVED SENSITIVE VALUE***",
            "timeout": 1.5
        },
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "ssl",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": true,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "theme": "",
        "loglevel": 2,
        "maintenance_window_start": 1,
        "default_phone_region": "IT",
        "app_install_overwrite": [],
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    },
    "apps": {
        "activity": {
            "enabled": "yes",
            "installed_version": "6.0.0-dev.0",
            "types": "filesystem"
        },
        "admin_audit": {
            "enabled": "yes",
            "installed_version": "1.23.0",
            "types": "logging"
        },
        "app_api": {
            "enabled": "yes",
            "installed_version": "33.0.0",
            "types": ""
        },
        "backgroundjob": {
            "lastjob": "1"
        },
        "bruteforcesettings": {
            "enabled": "yes",
            "installed_version": "6.0.0-dev.0",
            "types": ""
        },
        "calendar": {
            "enabled": "yes",
            "installed_version": "6.2.1",
            "types": ""
        },
        "checksum": {
            "enabled": "no",
            "installed_version": "2.0.3",
            "types": "filesystem"
        },
        "circles": {
            "enabled": "yes",
            "installed_version": "33.0.0",
            "loopback_tmp_scheme": "https",
            "maintenance_run": "0",
            "maintenance_update": "{\"3\":1773813901,\"2\":1773814501,\"1\":1773814501}",
            "migration_22": "1",
            "migration_run": "0",
            "types": "filesystem,dav"
        },
        "cloud_federation_api": {
            "enabled": "yes",
            "installed_version": "1.17.0",
            "types": "filesystem"
        },
        "comments": {
            "enabled": "yes",
            "installed_version": "1.23.0",
            "types": "logging"
        },
        "contacts": {
            "enabled": "yes",
            "installed_version": "8.4.1",
            "types": "dav"
        },
        "contactsinteraction": {
            "enabled": "yes",
            "installed_version": "1.14.1",
            "types": "dav"
        },
        "core": {
            "backgroundjobs_mode": "cron",
            "emailTestSuccessful": "1",
            "installedat": "1725102739.2121",
            "lastcron": 1773814501,
            "lastupdateResult": "[]",
            "lastupdatedat": 1773814101,
            "metadataGenerationDone": true,
            "moveavatarsdone": "yes",
            "previewsCleanedUp": "1",
            "public_files": "files_sharing\/public.php",
            "updater.secret.created": 1773778252,
            "vendor": "nextcloud",
            "files_metadata": {
                "photos-original_date_time": {
                    "value": null,
                    "type": "int",
                    "etag": "",
                    "indexed": true,
                    "editPermission": 0
                },
                "photos-exif": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-ifd0": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-size": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "blurhash": {
                    "value": null,
                    "type": "string",
                    "etag": "a09195780edc904b48ee1568a0feda68",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-gps": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-place": {
                    "value": null,
                    "type": "string",
                    "etag": "",
                    "indexed": true,
                    "editPermission": 0
                }
            },
            "oc.integritycheck.checker": []
        },
        "dashboard": {
            "enabled": "yes",
            "installed_version": "7.13.0",
            "types": ""
        },
        "dav": {
            "buildCalendarReminderIndex": "yes",
            "buildCalendarSearchIndex": "yes",
            "builtSocialSearchIndex": "yes",
            "chunks_migrated": "1",
            "enabled": "yes",
            "hasCustomDefaultContact": false,
            "installed_version": "1.36.0",
            "regeneratedBirthdayCalendarsForYearFix": "yes",
            "types": "filesystem"
        },
        "deck": {
            "enabled": "yes",
            "installed_version": "1.17.0",
            "types": "dav"
        },
        "federatedfilesharing": {
            "enabled": "yes",
            "installed_version": "1.23.0",
            "types": ""
        },
        "federation": {
            "enabled": "yes",
            "installed_version": "1.23.0",
            "types": "authentication"
        },
        "files": {
            "enabled": "yes",
            "installed_version": "2.5.0",
            "mimetype_version": "33.0.0.16",
            "types": "filesystem"
        },
        "files_accesscontrol": {
            "enabled": "yes",
            "installed_version": "4.0.0",
            "types": "filesystem"
        },
        "files_antivirus": {
            "av_cmd_options": "",
            "av_host": "",
            "av_icap_mode": "reqmod",
            "av_icap_request_service": "avscan",
            "av_icap_response_header": "X-Infection-Found",
            "av_icap_tls": "0",
            "av_infected_action": "only_log",
            "av_max_file_size": "-1",
            "av_mode": "socket",
            "av_path": "\/usr\/bin\/clamscan",
            "av_port": "0",
            "av_scan_first_bytes": "-1",
            "av_socket": "\/var\/run\/clamav\/clamd.ctl",
            "av_stream_max_length": "26214400",
            "enabled": "yes",
            "installed_version": "6.2.0",
            "types": "filesystem,dav"
        },
        "files_downloadactivity": {
            "enabled": "no",
            "installed_version": "1.17.0",
            "types": "filesystem"
        },
        "files_downloadlimit": {
            "enabled": "yes",
            "installed_version": "5.1.0-dev.0",
            "types": ""
        },
        "files_lock": {
            "enabled": "yes",
            "installed_version": "33.0.1",
            "types": "filesystem,dav"
        },
        "files_pdfviewer": {
            "enabled": "yes",
            "installed_version": "6.0.0-dev.0",
            "types": ""
        },
        "files_reminders": {
            "enabled": "yes",
            "installed_version": "1.6.0",
            "types": ""
        },
        "files_sharing": {
            "enabled": "yes",
            "installed_version": "1.25.2",
            "types": "filesystem"
        },
        "files_trashbin": {
            "enabled": "yes",
            "installed_version": "1.23.0",
            "types": "filesystem,dav"
        },
        "files_versions": {
            "enabled": "yes",
            "installed_version": "1.26.0",
            "types": "filesystem,dav"
        },
        "firstrunwizard": {
            "enabled": "yes",
            "installed_version": "6.0.0-dev.0",
            "types": ""
        },
        "group_default_quota": {
            "enabled": "yes",
            "installed_version": "0.1.14",
            "types": "filesystem"
        },
        "logreader": {
            "enabled": "yes",
            "installed_version": "6.0.0",
            "types": "logging"
        },
        "lookup_server_connector": {
            "enabled": "yes",
            "installed_version": "1.21.0",
            "types": "authentication"
        },
        "mail": {
            "enabled": "yes",
            "installed_version": "5.7.3",
            "types": ""
        },
        "metadata": {
            "enabled": "no",
            "installed_version": "0.23.0",
            "types": ""
        },
        "nextcloud_announcements": {
            "enabled": "yes",
            "installed_version": "5.0.0",
            "pub_date": "Thu, 24 Oct 2019 00:00:00 +0200",
            "types": "logging"
        },
        "notes": {
            "enabled": "yes",
            "installed_version": "4.13.0",
            "types": ""
        },
        "notifications": {
            "enabled": "yes",
            "installed_version": "6.0.0",
            "types": "logging"
        },
        "oauth2": {
            "enabled": "yes",
            "installed_version": "1.21.0",
            "types": "authentication"
        },
        "password_policy": {
            "enabled": "yes",
            "installed_version": "5.0.0-dev.0",
            "types": "authentication"
        },
        "photos": {
            "enabled": "yes",
            "installed_version": "6.0.0-dev.0",
            "lastPlaceMappedUser": "admin",
            "lastPlaceMappingDone": "true",
            "types": "dav,authentication"
        },
        "privacy": {
            "enabled": "yes",
            "installed_version": "5.0.0-dev.0",
            "types": ""
        },
        "profile": {
            "enabled": "yes",
            "installed_version": "1.2.0",
            "types": ""
        },
        "provisioning_api": {
            "enabled": "yes",
            "installed_version": "1.23.0",
            "types": "prevent_group_restriction"
        },
        "quota_warning": {
            "enabled": "yes",
            "initialised": "yes",
            "installed_version": "1.23.0",
            "types": "filesystem"
        },
        "recommendations": {
            "enabled": "yes",
            "installed_version": "6.0.0-dev.0",
            "types": ""
        },
        "related_resources": {
            "enabled": "yes",
            "installed_version": "4.0.0-dev.0",
            "types": ""
        },
        "richdocuments": {
            "disable_certificate_verification": "",
            "doc_format": "ooxml",
            "enabled": "yes",
            "external_apps": "",
            "installed_version": "10.1.0",
            "public_wopi_url": "https:\/\/cloud.studiopippo.eu",
            "types": "filesystem,prevent_group_restriction",
            "wopi_allowlist": "127.0.0.1\/24,10.0.32.10,localhost",
            "wopi_url": "https:\/\/cloud.studiopippo.eu\/apps\/richdocumentscode\/proxy.php?req="
        },
        "richdocumentscode": {
            "enabled": "yes",
            "installed_version": "25.4.903",
            "types": ""
        },
        "serverinfo": {
            "cached_count_appdata_files": 100567,
            "cached_count_filecache": 416704,
            "cached_count_storages": 8,
            "enabled": "yes",
            "installed_version": "5.0.0-dev.0",
            "size_appdata_storage": -1,
            "types": ""
        },
        "settings": {
            "enabled": "yes",
            "installed_version": "1.16.0",
            "types": ""
        },
        "sharebymail": {
            "enabled": "yes",
            "installed_version": "1.23.0",
            "types": "filesystem"
        },
        "spreed": {
            "enabled": "no",
            "has_reference_id": "yes",
            "installed_version": "21.0.1",
            "project_access_invalidated": "1",
            "signaling_token_privkey_es256": "***REMOVED SENSITIVE VALUE***",
            "signaling_token_pubkey_es256": "***REMOVED SENSITIVE VALUE***",
            "types": "dav,prevent_group_restriction"
        },
        "support": {
            "SwitchUpdaterServerHasRun": "yes",
            "enabled": "yes",
            "installed_version": "5.0.0",
            "types": "session"
        },
        "survey_client": {
            "enabled": "yes",
            "installed_version": "5.0.0-dev.0",
            "types": ""
        },
        "systemtags": {
            "enabled": "yes",
            "installed_version": "1.23.0",
            "types": "logging"
        },
        "text": {
            "enabled": "yes",
            "installed_version": "7.0.0-dev.3",
            "types": "dav"
        },
        "theming": {
            "cachebuster": "5",
            "enabled": "yes",
            "installed_version": "2.8.0",
            "logoheaderMime": "image\/png",
            "name": "Studio Pippo $ Associati",
            "slogan": "***REMOVED SENSITIVE VALUE***",
            "types": "logging",
            "url": "***REMOVED SENSITIVE VALUE***"
        },
        "twofactor_backupcodes": {
            "enabled": "yes",
            "installed_version": "1.22.0",
            "types": ""
        },
        "twofactor_totp": {
            "enabled": "yes",
            "installed_version": "15.0.0-dev.0",
            "types": ""
        },
        "updatenotification": {
            "calendar": "6.2.1",
            "checksum": "1.2.6",
            "contacts": "8.3.5",
            "core": "33.0.0.16",
            "deck": "1.16.3",
            "enabled": "yes",
            "files_accesscontrol": "3.0.2",
            "files_antivirus": "6.2.0",
            "files_lock": "32.0.1",
            "group_default_quota": "0.1.14",
            "installed_version": "1.23.0",
            "mail": "5.7.3",
            "metadata": "0.23.0",
            "notes": "4.13.0",
            "quota_warning": "1.23.0",
            "richdocuments": "9.0.3",
            "richdocumentscode": "25.4.903",
            "spreed": "20.1.5",
            "types": "",
            "update_check_errors": 0
        },
        "user_status": {
            "enabled": "yes",
            "installed_version": "1.13.0",
            "types": ""
        },
        "user_usage_report": {
            "enabled": "yes",
            "installed_version": "4.0.0",
            "types": "filesystem"
        },
        "viewer": {
            "enabled": "yes",
            "installed_version": "6.0.0-dev.0",
            "types": ""
        },
        "weather_status": {
            "enabled": "yes",
            "installed_version": "1.13.0",
            "types": ""
        },
        "webhook_listeners": {
            "enabled": "yes",
            "installed_version": "1.5.0",
            "types": "filesystem"
        },
        "workflowengine": {
            "enabled": "yes",
            "installed_version": "2.15.0",
            "types": "filesystem"
        }
    }
}

Apps

The output of occ app:list (if possible).

- activity: 6.0.0-dev.0

  • admin_audit: 1.23.0
  • app_api: 33.0.0
  • bruteforcesettings: 6.0.0-dev.0
  • calendar: 6.2.1
  • circles: 33.0.0
  • cloud_federation_api: 1.17.0
  • comments: 1.23.0
  • contacts: 8.4.1
  • contactsinteraction: 1.14.1
  • dashboard: 7.13.0
  • dav: 1.36.0
  • deck: 1.17.0
  • federatedfilesharing: 1.23.0
  • federation: 1.23.0
  • files: 2.5.0
  • files_accesscontrol: 4.0.0
  • files_antivirus: 6.2.0
  • files_downloadlimit: 5.1.0-dev.0
  • files_lock: 33.0.1
  • files_pdfviewer: 6.0.0-dev.0
  • files_reminders: 1.6.0
  • files_sharing: 1.25.2
  • files_trashbin: 1.23.0
  • files_versions: 1.26.0
  • firstrunwizard: 6.0.0-dev.0
  • group_default_quota: 0.1.14
  • logreader: 6.0.0
  • lookup_server_connector: 1.21.0
  • mail: 5.7.3
  • nextcloud_announcements: 5.0.0
  • notes: 4.13.0
  • notifications: 6.0.0
  • oauth2: 1.21.0
  • password_policy: 5.0.0-dev.0
  • photos: 6.0.0-dev.0
  • privacy: 5.0.0-dev.0
  • profile: 1.2.0
  • provisioning_api: 1.23.0
  • quota_warning: 1.23.0
  • recommendations: 6.0.0-dev.0
  • related_resources: 4.0.0-dev.0
  • richdocuments: 10.1.0
  • richdocumentscode: 25.4.903
  • serverinfo: 5.0.0-dev.0
  • settings: 1.16.0
  • sharebymail: 1.23.0
  • support: 5.0.0
  • survey_client: 5.0.0-dev.0
  • systemtags: 1.23.0
  • text: 7.0.0-dev.3
  • theming: 2.8.0
  • twofactor_backupcodes: 1.22.0
  • twofactor_totp: 15.0.0-dev.0
  • updatenotification: 1.23.0
  • user_status: 1.13.0
  • user_usage_report: 4.0.0
  • viewer: 6.0.0-dev.0
  • weather_status: 1.13.0
  • webhook_listeners: 1.5.0
  • workflowengine: 2.15.0
    Disabled:
  • checksum: 2.0.3 (installed 2.0.3)
  • encryption: 2.21.0
  • files_downloadactivity: 1.18.1 (installed 1.17.0)
  • files_external: 1.25.1
  • metadata: 0.23.0 (installed 0.23.0)
  • suspicious_login: 11.0.0-dev.0
  • twofactor_nextcloud_notification: 7.0.0
  • user_ldap: 1.24.0

Tips for increasing the likelihood of a response

  • Use the preformatted text formatting option in the editor for all log entries and configuration output.
  • If screenshots are useful, feel free to include them.
    • If possible, also include key error output in text form so it can be searched for.
  • Try to edit log output only minimally (if at all) so that it can be ran through analyzers / formatters by those trying to help you.

When you say “using Office” are you referring to Nextcloud Office (which you have installed from the looks of it) or to MS Office running on desktop clients?

Users are using Windows 11 and desktop client 4.0.7.

Were the clients updated to v4.0.7 around the same time? I ask because it might help determine whether the issue is client-side (in the desktop client) versus server-side (i.e. in v33).

In table oc_files_lock

It looks like maybe your sentence got cut-off here.