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.

I might have similiar problems.
I sync my passwort manager via Nextcloud. After the last update i am no longer able to write back changes.

Hi,

I’m only replying now because I had a fever…

I have update windows desktop client to 4.0.8 and the problem persist.

I updated the Windows client to 4.0.8, but the problem persists. Basically, if a file (e.g., Excel or Word) is opened by a user (either via the Web or the Office App installed on PC), other users don’t see the lock, either via the desktop client or the Web, and can easily edit the file. However, the oc_files_lock table is updated correctly. This means that as soon as a user opens a file, the oc_files_lock table is populated correctly, as is when the file is closed.

Thank you

1 Like

Same here issues with normal files, synced with keepass files and with contacts.

2 Likes

On my Nextcloud 32 system I have installed the files lock app. I use the manual locking very seldom. The app has improved the locking overall.

When a file is opened locally it is shown in the web app and when I try to open the file with Nextcloud Office, it is opened read only.

And also the other way round. When a file is opened in Nextcloud Office, I can open the file locally only in read only. This works for me with LibreOffice and Microsoft 365.

Here the link to the app:

Hello,

the app Temporary files lock is installed (version 33.0.1). We had this problem after updating nextcloud to version 33.0.0.16

Thank you

Hello,

can someone help me to solve the problem?

Thak you