File versioning / restores not working due to mismatched IDs

[k3rst1n]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• Nextcloud Server is running on 64bit capable CPU, PHP and OS.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

File versioning/restores not working due to some IDs mismatching.

Versions web interface:

Example IDs from links:
xxx/versions/333033/1684832568 - working
xxx/versions/333033/1684832558 - not working
xxx/versions/333033/1684832510 - not working
xxx/versions/333033/1684832476 - not working
xxx/versions/333033/1684832374 - not working
xxx/versions/333033/1684832245 - not working

Versions filesystem:

As visible in above screenshots, the version ID is mismatching in most cases, e.g.

Filesystem: v1684832555
Link when trying to access via web interface: 1684832558

Filesystem: v1684832507
Link when trying to access via web interface: 1684832510

Steps to reproduce

1. Modify existing file
2. Restore previous version
3. Some versions have an ID mismatch therefore links are broken and restore/download not possible

Expected behavior

1. Modify existing file
2. Restore previous version
3. File restored

Installation method

Community Docker image

Nextcloud Server version

26

Operating system

Other

PHP engine version

PHP 8.1

Web server

Apache (supported)

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

{
    "system": {
        "htaccess.RewriteBase": "\/",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "[removed]",
            "[removed]"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "26.0.1.1",
        "overwrite.cli.url": "http:[removed]:8666",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "data-fingerprint": "2ecddc2b1147ef7c8762d23006307ccc",
        "overwriteprotocol": "https",
        "app_install_overwrite": [
            "apporder"
        ],
        "mail_smtpmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_sendmailmode": "smtp",
        "mail_smtpport": "587",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "default_phone_region": "GB",
        "maintenance": false,
        "memories.exiftool": "\/var\/www\/html\/custom_apps\/memories\/exiftool-bin\/exiftool-amd64-glibc",
        "memories.vod.path": "\/var\/www\/html\/custom_apps\/memories\/exiftool-bin\/go-vod-amd64",
        "loglevel": 2
    }
}
$

List of activated Apps

Enabled:
  - activity: 2.18.0
  - admin_audit: 1.16.0
  - apporder: 0.15.0
  - bookmarks: 13.0.1
  - bruteforcesettings: 2.6.0
  - calendar: 4.3.4
  - circles: 26.0.0
  - cloud_federation_api: 1.9.0
  - collectives: 2.5.0
  - comments: 1.16.0
  - contacts: 5.2.0
  - contactsinteraction: 1.7.0
  - cookbook: 0.10.2
  - dashboard: 7.6.0
  - dav: 1.25.0
  - deck: 1.9.2
  - event_update_notification: 2.2.0
  - federatedfilesharing: 1.16.0
  - federation: 1.16.0
  - files: 1.21.1
  - files_external: 1.18.0
  - files_markdown: 2.4.0
  - files_pdfviewer: 2.7.0
  - files_rightclick: 1.5.0
  - files_sharing: 1.18.0
  - files_trashbin: 1.16.0
  - files_versions: 1.19.1
  - firstrunwizard: 2.15.0
  - integration_reddit: 2.0.0
  - keeweb: 0.6.12
  - logreader: 2.11.0
  - lookup_server_connector: 1.14.0
  - memories: 5.1.0
  - nextcloud_announcements: 1.15.0
  - notes: 4.7.2
  - notifications: 2.14.0
  - oauth2: 1.14.0
  - password_policy: 1.16.0
  - photos: 2.2.0
  - privacy: 1.10.0
  - provisioning_api: 1.16.0
  - quota_warning: 1.17.0
  - recommendations: 1.5.0
  - related_resources: 1.1.0-alpha1
  - serverinfo: 1.16.0
  - settings: 1.8.0
  - sharebymail: 1.16.0
  - support: 1.9.0
  - survey_client: 1.14.0
  - suspicious_login: 4.4.0
  - systemtags: 1.16.0
  - tasks: 0.15.0
  - text: 3.7.2
  - theming: 2.1.1
  - twofactor_backupcodes: 1.15.0
  - twofactor_nextcloud_notification: 3.7.0
  - twofactor_totp: 8.0.0-alpha.0
  - unsplash: 2.2.0
  - updatenotification: 1.16.0
  - user_ldap: 1.16.0
  - user_status: 1.6.0
  - viewer: 1.10.0
  - weather_status: 1.6.0
  - workflowengine: 2.8.0
Disabled:
  - encryption: 2.14.0 (installed 2.14.0)
  - end_to_end_encryption: 1.12.4 (installed 1.12.4)
  - extract: 1.3.5 (installed 1.3.5)
  - files_fulltextsearch: 26.0.0 (installed 26.0.0)
  - files_trackdownloads: 1.11.0 (installed 1.11.0)
  - weather: 1.7.7 (installed 1.7.7)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

Nothing in logs except entries such as

{"reqId":"Gt82dQKTVXPBjyfPr0UT","level":2,"time":"2023-05-23T10:58:32+00:00","remoteAddr":"[removed]","user":"sc","app":"suspicious_login","method":"PROPFIND","url":"/remote.php/dav/calendars/[removed]","message":"Could not predict suspiciousness: No models found","userAgent":"DAVx5/4.3-ose (2023/02/11; dav4jvm; okhttp/4.10.0) Android/13","version":"26.0.1.1","data":{"app":"suspicious_login"}}

Additional info

Operating System: Linux 5.19.17-Unraid x86_64

[szaimen]

Cc @artonge

[ruedigerkupper]

Possibly duplicate of #37461.