Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug]: NC 26.0.0beta2 cron.php triggers OCP\\AppFramework\\Db\\DoesNotExistException #36541

Closed
6 of 9 tasks
Tracked by #1846
, #2336
...
nursoda opened this issue Feb 5, 2023 · 6 comments · Fixed by #36556
Closed
6 of 9 tasks
Tracked by #1846
, #2336
...

[Bug]: NC 26.0.0beta2 cron.php triggers OCP\\AppFramework\\Db\\DoesNotExistException #36541

nursoda opened this issue Feb 5, 2023 · 6 comments · Fixed by #36556
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 26-feedback bug

Comments

@nursoda
Copy link

nursoda commented Feb 5, 2023 •
edited
Loading

⚠️ 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

On a newly installed NC 26.0.0beta2 instance, I see errors in nextcloud.log (see below).

Steps to reproduce

  1. Install from Archive, setup using WebConfig, set up cron
  2. Wait for cron to be called, view nextcloud.log

Expected behavior

No errors in log :)

Installation method

Community Manual installation with Archive

Operating system

Other

PHP engine version

PHP 8.1

Web server

Nginx

Database engine version

MariaDB

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

Fresh Nextcloud Server install

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

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

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "26.0.0.4",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "skeletondirectory": "\/DATADIRECTORY\/_skeleton",
        "trusted_domains": [
            "cloud.DOMAIN.de"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "https:\/\/cloud.DOMAIN.de",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "dbindex": 9,
            "timeout": 1.5
        },
        "blacklisted_files": [],
        "logtimezone": "Europe\/Berlin",
        "trashbin_retention_obligation": "auto,30",
        "versions_retention_obligation": "auto,366",
        "default_language": "de",
        "default_locale": "de_DE",
        "default_phone_region": "DE",
        "updater.release.channel": "beta",
        "theme": "",
        "loglevel": 2,
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "tls",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "simpleSignUpLink.shown": false,
        "twofactor_enforced_groups": [
            "admin",
            "Technik"
        ],
        "twofactor_enforced_excluded_groups": [],
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "app_install_overwrite": [
            "files_frommail",
            "impersonate",
            "twofactor_email",
            "twofactor_webauthn",
            "contacts",
            "deck",
            "groupfolders",
            "notify_push",
            "twofactor_nextcloud_notification",
            "keeweb"
        ],
        "maintenance": false,
        "twofactor_enforced": "true"
    }
}

List of activated Apps

Enabled:
  - activity: 2.18.0
  - bruteforcesettings: 2.6.0
  - calendar: 4.2.3
  - calendar_resource_management: 0.4.0
  - cloud_federation_api: 1.9.0
  - comments: 1.16.0
  - contacts: 5.1.0
  - contactsinteraction: 1.7.0
  - dav: 1.25.0
  - federatedfilesharing: 1.16.0
  - federation: 1.16.0
  - files: 1.21.1
  - 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
  - groupfolders: 13.1.1
  - impersonate: 1.11.0
  - keeweb: 0.6.10
  - logreader: 2.11.0
  - lookup_server_connector: 1.14.0
  - notifications: 2.14.0
  - notify_push: 0.5.2
  - oauth2: 1.14.0
  - password_policy: 1.16.0
  - photos: 2.2.0
  - privacy: 1.10.0
  - provisioning_api: 1.16.0
  - related_resources: 1.1.0-alpha1
  - richdocuments: 8.0.0-beta.1
  - serverinfo: 1.16.0
  - settings: 1.8.0
  - sharebymail: 1.16.0
  - suspicious_login: 4.4.0
  - systemtags: 1.16.0
  - text: 3.7.0
  - theming: 2.1.1
  - twofactor_admin: 4.1.9
  - twofactor_backupcodes: 1.15.0
  - twofactor_email: 2.7.1
  - twofactor_nextcloud_notification: 3.5.0
  - twofactor_totp: 8.0.0-alpha.0
  - twofactor_webauthn: 1.0.0
  - updatenotification: 1.16.0
  - viewer: 1.10.0
  - workflowengine: 2.8.0
Disabled:
  - admin_audit: 1.16.0
  - circles: 26.0.0-beta2 (installed 26.0.0-alpha.0)
  - dashboard: 7.6.0 (installed 7.6.0)
  - deck: 1.8.3 (installed 1.8.3)
  - encryption: 2.14.0
  - files_external: 1.18.0
  - firstrunwizard: 2.15.0 (installed 2.15.0)
  - nextcloud_announcements: 1.15.0 (installed 1.15.0)
  - recommendations: 1.5.0 (installed 1.5.0)
  - support: 1.9.0 (installed 1.9.0)
  - survey_client: 1.14.0 (installed 1.14.0)
  - tables: 0.2.2 (installed 0.2.2)
  - tasks: 0.14.5 (installed 0.14.5)
  - user_ldap: 1.16.0
  - user_status: 1.6.0 (installed 1.6.0)
  - weather_status: 1.6.0 (installed 1.6.0)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{
  "reqId": "tL4zH4NFWL8vSswLDcUk",
  "level": 3,
  "time": "2023-02-05T02:04:54+01:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
  "userAgent": "--",
  "version": "26.0.0.4",
  "exception": {
    "Exception": "OCP\\AppFramework\\Db\\DoesNotExistException",
    "Message": "Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*files_versions` WHERE (`file_id` = :dcValue1) AND (`timestamp` = :dcValue2)\"; ",
    "Code": 0,
    "Trace": [
      {
        "file": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
        "line": 361,
        "function": "findOneQuery",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Db/VersionsMapper.php",
        "line": 78,
        "function": "findEntity",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 595,
        "function": "findVersionForFileId",
        "class": "OCA\\Files_Versions\\Db\\VersionsMapper",
        "type": "->"
      },
      {
        "function": "OCA\\Files_Versions\\{closure}",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 604,
        "function": "array_filter"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 69,
        "function": "expireOlderThanMaxForUser",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::"
      },
      {
        "file": "/FOLDER/lib/private/User/Manager.php",
        "line": 638,
        "function": "OCA\\Files_Versions\\BackgroundJob\\{closure}",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 70,
        "function": "callForSeenUsers",
        "class": "OC\\User\\Manager",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/Job.php",
        "line": 78,
        "function": "run",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 103,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 93,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/FOLDER/cron.php",
        "line": 152,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      }
    ],
    "File": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
    "Line": 284,
    "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
    "exception": {},
    "CustomMessage": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )"
  }
}

Additional info

No response
@nursoda nursoda added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Feb 5, 2023
@szaimen
Copy link
Contributor

szaimen commented Feb 5, 2023

Cc @artonge

@szaimen szaimen mentioned this issue Feb 5, 2023
Closed
37 tasks
artonge added a commit that referenced this issue Feb 6, 2023
@artonge
Handle empty DB while expiring versions
38c6d80 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix #36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
@artonge artonge mentioned this issue Feb 6, 2023
Merged
artonge added a commit that referenced this issue Feb 6, 2023
@artonge
Handle empty DB while expiring versions
633712a 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix #36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
artonge added a commit that referenced this issue Feb 6, 2023
@artonge
Handle empty DB while expiring versions
0dd8c91 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix #36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
@artonge
Copy link
Contributor

artonge commented Feb 6, 2023

@nursoda could you test the fix in #36556 and report back ?

@nursoda
Copy link
Author

nursoda commented Feb 7, 2023 •
edited
Loading

I tried calling the exec line of my cloud-cron.service (/usr/bin/php¹ -f /…/cloud/cron.php) as the web server user (also given there). I did so while watching a tail -f of nextcloud.log. By doing that, I could not trigger the original issue again. Last entry of that kind was two days ago (about when I posted the issue report). Do you know what triggered it so that I can re-establish such conditions? Only when I can reproduce in the original state, patching and re-testing does have any meaning, right…

¹ php-legacy actually, but that's Arch specific since that server also has NC25 instances running that cannot use PHP 8.2 yet.

@artonge
Copy link
Contributor

artonge commented Feb 7, 2023

The error comes when expiring versions. The new code expects an entry in the DB, but for versions created before 26, there is none.

You can run occ versions:expire to trigger the expiration process. But if you do not have a version that should be expired, then the bug will not be triggered.

@nursoda
Copy link
Author

nursoda commented Feb 7, 2023

I see. However, that server was created a couple on 2023-01-20 (so less that 30 days) and had no files before!

nextcloud-command pushed a commit that referenced this issue Feb 8, 2023
@artonge
Handle empty DB while expiring versions
21cd3b0 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix #36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
@nursoda
Copy link
Author

nursoda commented Feb 15, 2023

I see the log messages again (although I don't know exactly why), so I should be able to confirm the fix in a couple of days.

nextcloud.log 
{
  "reqId": "fz8RoccgP7YCXqZpGvD0",
  "level": 3,
  "time": "2023-02-14T14:52:34+01:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
  "userAgent": "--",
  "version": "26.0.0.5",
  "exception": {
    "Exception": "OCP\\AppFramework\\Db\\DoesNotExistException",
    "Message": "Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*files_versions` WHERE (`file_id` = :dcValue1) AND (`timestamp` = :dcValue2)\"; ",
    "Code": 0,
    "Trace": [
      {
        "file": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
        "line": 361,
        "function": "findOneQuery",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Db/VersionsMapper.php",
        "line": 78,
        "function": "findEntity",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 595,
        "function": "findVersionForFileId",
        "class": "OCA\\Files_Versions\\Db\\VersionsMapper",
        "type": "->"
      },
      {
        "function": "OCA\\Files_Versions\\{closure}",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 604,
        "function": "array_filter"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 69,
        "function": "expireOlderThanMaxForUser",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::"
      },
      {
        "file": "/FOLDER/lib/private/User/Manager.php",
        "line": 638,
        "function": "OCA\\Files_Versions\\BackgroundJob\\{closure}",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 70,
        "function": "callForSeenUsers",
        "class": "OC\\User\\Manager",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/Job.php",
        "line": 78,
        "function": "run",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 103,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 93,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/FOLDER/cron.php",
        "line": 152,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      }
    ],
    "File": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
    "Line": 284,
    "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
    "exception": {},
    "CustomMessage": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )"
  }
}
{
  "reqId": "PmAPjDmQKwaQrt9hyX8r",
  "level": 3,
  "time": "2023-02-14T15:26:59+01:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
  "userAgent": "--",
  "version": "26.0.0.5",
  "exception": {
    "Exception": "OCP\\AppFramework\\Db\\DoesNotExistException",
    "Message": "Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*files_versions` WHERE (`file_id` = :dcValue1) AND (`timestamp` = :dcValue2)\"; ",
    "Code": 0,
    "Trace": [
      {
        "file": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
        "line": 361,
        "function": "findOneQuery",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Db/VersionsMapper.php",
        "line": 78,
        "function": "findEntity",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 595,
        "function": "findVersionForFileId",
        "class": "OCA\\Files_Versions\\Db\\VersionsMapper",
        "type": "->"
      },
      {
        "function": "OCA\\Files_Versions\\{closure}",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 604,
        "function": "array_filter"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 69,
        "function": "expireOlderThanMaxForUser",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::"
      },
      {
        "file": "/FOLDER/lib/private/User/Manager.php",
        "line": 638,
        "function": "OCA\\Files_Versions\\BackgroundJob\\{closure}",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 70,
        "function": "callForSeenUsers",
        "class": "OC\\User\\Manager",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/Job.php",
        "line": 78,
        "function": "run",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 103,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 93,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/FOLDER/cron.php",
        "line": 152,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      }
    ],
    "File": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
    "Line": 284,
    "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
    "exception": {},
    "CustomMessage": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )"
  }
}
{
  "reqId": "RAHUsJ5bb8IGrFplNEQo",
  "level": 3,
  "time": "2023-02-14T16:01:23+01:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
  "userAgent": "--",
  "version": "26.0.0.5",
  "exception": {
    "Exception": "OCP\\AppFramework\\Db\\DoesNotExistException",
    "Message": "Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*files_versions` WHERE (`file_id` = :dcValue1) AND (`timestamp` = :dcValue2)\"; ",
    "Code": 0,
    "Trace": [
      {
        "file": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
        "line": 361,
        "function": "findOneQuery",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Db/VersionsMapper.php",
        "line": 78,
        "function": "findEntity",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 595,
        "function": "findVersionForFileId",
        "class": "OCA\\Files_Versions\\Db\\VersionsMapper",
        "type": "->"
      },
      {
        "function": "OCA\\Files_Versions\\{closure}",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 604,
        "function": "array_filter"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 69,
        "function": "expireOlderThanMaxForUser",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::"
      },
      {
        "file": "/FOLDER/lib/private/User/Manager.php",
        "line": 638,
        "function": "OCA\\Files_Versions\\BackgroundJob\\{closure}",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 70,
        "function": "callForSeenUsers",
        "class": "OC\\User\\Manager",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/Job.php",
        "line": 78,
        "function": "run",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 103,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 93,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/FOLDER/cron.php",
        "line": 152,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      }
    ],
    "File": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
    "Line": 284,
    "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
    "exception": {},
    "CustomMessage": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )"
  }
}
{
  "reqId": "YHbHpR8UatVLT7TMwdt0",
  "level": 3,
  "time": "2023-02-14T16:35:47+01:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
  "userAgent": "--",
  "version": "26.0.0.5",
  "exception": {
    "Exception": "OCP\\AppFramework\\Db\\DoesNotExistException",
    "Message": "Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*files_versions` WHERE (`file_id` = :dcValue1) AND (`timestamp` = :dcValue2)\"; ",
    "Code": 0,
    "Trace": [
      {
        "file": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
        "line": 361,
        "function": "findOneQuery",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Db/VersionsMapper.php",
        "line": 78,
        "function": "findEntity",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 595,
        "function": "findVersionForFileId",
        "class": "OCA\\Files_Versions\\Db\\VersionsMapper",
        "type": "->"
      },
      {
        "function": "OCA\\Files_Versions\\{closure}",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 604,
        "function": "array_filter"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 69,
        "function": "expireOlderThanMaxForUser",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::"
      },
      {
        "file": "/FOLDER/lib/private/User/Manager.php",
        "line": 638,
        "function": "OCA\\Files_Versions\\BackgroundJob\\{closure}",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 70,
        "function": "callForSeenUsers",
        "class": "OC\\User\\Manager",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/Job.php",
        "line": 78,
        "function": "run",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 103,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 93,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/FOLDER/cron.php",
        "line": 152,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      }
    ],
    "File": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
    "Line": 284,
    "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
    "exception": {},
    "CustomMessage": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )"
  }
}
{
  "reqId": "JpQizl90CUCUGsjwKZ5D",
  "level": 3,
  "time": "2023-02-14T17:10:12+01:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
  "userAgent": "--",
  "version": "26.0.0.5",
  "exception": {
    "Exception": "OCP\\AppFramework\\Db\\DoesNotExistException",
    "Message": "Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*files_versions` WHERE (`file_id` = :dcValue1) AND (`timestamp` = :dcValue2)\"; ",
    "Code": 0,
    "Trace": [
      {
        "file": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
        "line": 361,
        "function": "findOneQuery",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Db/VersionsMapper.php",
        "line": 78,
        "function": "findEntity",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 595,
        "function": "findVersionForFileId",
        "class": "OCA\\Files_Versions\\Db\\VersionsMapper",
        "type": "->"
      },
      {
        "function": "OCA\\Files_Versions\\{closure}",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 604,
        "function": "array_filter"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 69,
        "function": "expireOlderThanMaxForUser",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::"
      },
      {
        "file": "/FOLDER/lib/private/User/Manager.php",
        "line": 638,
        "function": "OCA\\Files_Versions\\BackgroundJob\\{closure}",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 70,
        "function": "callForSeenUsers",
        "class": "OC\\User\\Manager",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/Job.php",
        "line": 78,
        "function": "run",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 103,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 93,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/FOLDER/cron.php",
        "line": 152,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      }
    ],
    "File": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
    "Line": 284,
    "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
    "exception": {},
    "CustomMessage": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )"
  }
}
{
  "reqId": "JCL0EkTk6cIlyeI7Zdzr",
  "level": 3,
  "time": "2023-02-14T17:44:36+01:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
  "userAgent": "--",
  "version": "26.0.0.5",
  "exception": {
    "Exception": "OCP\\AppFramework\\Db\\DoesNotExistException",
    "Message": "Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*files_versions` WHERE (`file_id` = :dcValue1) AND (`timestamp` = :dcValue2)\"; ",
    "Code": 0,
    "Trace": [
      {
        "file": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
        "line": 361,
        "function": "findOneQuery",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Db/VersionsMapper.php",
        "line": 78,
        "function": "findEntity",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 595,
        "function": "findVersionForFileId",
        "class": "OCA\\Files_Versions\\Db\\VersionsMapper",
        "type": "->"
      },
      {
        "function": "OCA\\Files_Versions\\{closure}",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 604,
        "function": "array_filter"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 69,
        "function": "expireOlderThanMaxForUser",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::"
      },
      {
        "file": "/FOLDER/lib/private/User/Manager.php",
        "line": 638,
        "function": "OCA\\Files_Versions\\BackgroundJob\\{closure}",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 70,
        "function": "callForSeenUsers",
        "class": "OC\\User\\Manager",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/Job.php",
        "line": 78,
        "function": "run",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 103,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 93,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/FOLDER/cron.php",
        "line": 152,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      }
    ],
    "File": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
    "Line": 284,
    "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
    "exception": {},
    "CustomMessage": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )"
  }
}
{
  "reqId": "eRT0PJaFfLYCiSst0q2r",
  "level": 3,
  "time": "2023-02-14T18:19:00+01:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
  "userAgent": "--",
  "version": "26.0.0.5",
  "exception": {
    "Exception": "OCP\\AppFramework\\Db\\DoesNotExistException",
    "Message": "Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*files_versions` WHERE (`file_id` = :dcValue1) AND (`timestamp` = :dcValue2)\"; ",
    "Code": 0,
    "Trace": [
      {
        "file": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
        "line": 361,
        "function": "findOneQuery",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Db/VersionsMapper.php",
        "line": 78,
        "function": "findEntity",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 595,
        "function": "findVersionForFileId",
        "class": "OCA\\Files_Versions\\Db\\VersionsMapper",
        "type": "->"
      },
      {
        "function": "OCA\\Files_Versions\\{closure}",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/Storage.php",
        "line": 604,
        "function": "array_filter"
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 69,
        "function": "expireOlderThanMaxForUser",
        "class": "OCA\\Files_Versions\\Storage",
        "type": "::"
      },
      {
        "file": "/FOLDER/lib/private/User/Manager.php",
        "line": 638,
        "function": "OCA\\Files_Versions\\BackgroundJob\\{closure}",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/FOLDER/apps/files_versions/lib/BackgroundJob/ExpireVersions.php",
        "line": 70,
        "function": "callForSeenUsers",
        "class": "OC\\User\\Manager",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/Job.php",
        "line": 78,
        "function": "run",
        "class": "OCA\\Files_Versions\\BackgroundJob\\ExpireVersions",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 103,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/FOLDER/lib/public/BackgroundJob/TimedJob.php",
        "line": 93,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/FOLDER/cron.php",
        "line": 152,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      }
    ],
    "File": "/FOLDER/lib/public/AppFramework/Db/QBMapper.php",
    "Line": 284,
    "message": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )",
    "exception": {},
    "CustomMessage": "Error while running background job (class: OCA\\Files_Versions\\BackgroundJob\\ExpireVersions, arguments: )"
  }
}

RonaldBarnes pushed a commit to RonaldBarnes/NextCloud-server that referenced this issue Mar 1, 2023
@artonge @RonaldBarnes
Handle empty DB while expiring versions
dc46475 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
@szaimen szaimen mentioned this issue Apr 14, 2023
Closed
45 tasks
summersab pushed a commit to summersab/server that referenced this issue Jun 25, 2023
@artonge @summersab
Handle empty DB while expiring versions
947a04a 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
summersab pushed a commit to summersab/server that referenced this issue Jun 25, 2023
@artonge @summersab
Handle empty DB while expiring versions
c585e77 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
summersab pushed a commit to summersab/server that referenced this issue Jun 25, 2023
@artonge @summersab
Handle empty DB while expiring versions
c9603cd 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
summersab pushed a commit to summersab/server that referenced this issue Jun 25, 2023
@artonge @summersab
Handle empty DB while expiring versions
33d75bb 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
summersab pushed a commit to summersab/server that referenced this issue Jun 25, 2023
@artonge @summersab
Handle empty DB while expiring versions
270ac0c 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
summersab pushed a commit to summersab/server that referenced this issue Jun 26, 2023
@artonge @summersab
Handle empty DB while expiring versions
ea9f16e 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
summersab pushed a commit to summersab/server that referenced this issue Jun 26, 2023
@artonge @summersab
Handle empty DB while expiring versions
5291d27 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
summersab pushed a commit to summersab/server that referenced this issue Jun 26, 2023
@artonge @summersab
Handle empty DB while expiring versions
183a45e 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
summersab pushed a commit to summersab/server that referenced this issue Jun 26, 2023
@artonge @summersab
Handle empty DB while expiring versions
ae46edf 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
summersab pushed a commit to summersab/server that referenced this issue Jun 26, 2023
@artonge @summersab
Handle empty DB while expiring versions
82efc41 
Version on the FS can have no equivalent in the DB if they were created before the version naming feature. This makes sure that we catch the resulting exception and proceed as usual.

Fix nextcloud#36541

Signed-off-by: Louis Chemineau <louis@chmn.me>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 26-feedback bug
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Handle empty DB while expiring versions nextcloud/server
3 participants
@artonge @nursoda @szaimen