[Bug]: cron.php generates "More than 1000 expressions in a list are not allowed on Oracle" error

[gwire]

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

Running sudo -u www-data /usr/bin/php -f /opt/nextcloud/cron.php will log an error containing

{
  "Exception": "DoctrineDBALQueryQueryException",
  "Message": "More than 1000 expressions in a list are not allowed on Oracle.",
  "Code": 0,
  "Trace": [
    {
      "file": "/opt/nextcloud/apps/text/lib/Db/SessionMapper.php",
      "line": 122,
      "function": "execute",
      "class": "OCDBQueryBuilderQueryBuilder",
      "type": "->"
    },
    {
      "file": "/opt/nextcloud/apps/text/lib/Service/SessionService.php",
      "line": 151,
      "function": "deleteInactiveWithoutSteps",
      "class": "OCATextDbSessionMapper",
      "type": "->"
    },
    {
      "file": "/opt/nextcloud/apps/text/lib/Cron/Cleanup.php",
      "line": 76,
      "function": "removeInactiveSessionsWithoutSteps",
      "class": "OCATextServiceSessionService",
      "type": "->"
    },
    {
      "file": "/opt/nextcloud/lib/public/BackgroundJob/Job.php",
      "line": 78,
      "function": "run",
      "class": "OCATextCronCleanup",
      "type": "->"
    },
    {
      "file": "/opt/nextcloud/lib/public/BackgroundJob/TimedJob.php",
      "line": 103,
      "function": "start",
      "class": "OCPBackgroundJobJob",
      "type": "->"
    },
    {
      "file": "/opt/nextcloud/lib/public/BackgroundJob/TimedJob.php",
      "line": 93,
      "function": "start",
      "class": "OCPBackgroundJobTimedJob",
      "type": "->"
    },
    {
      "file": "/opt/nextcloud/cron.php",
      "line": 152,
      "function": "execute",
      "class": "OCPBackgroundJobTimedJob",
      "type": "->"
    }
  ],
  "File": "/opt/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
  "Line": 263,
  "message": "More than 1000 expressions in a list are not allowed on Oracle.",
  "query": "DELETE FROM `*PREFIX*text_sessions` WHERE (`last_contact` < :dcValue1) AND (`id` NOT IN (:dcValue2))",
  "exception": {},
  "CustomMessage": "More than 1000 expressions in a list are not allowed on Oracle."
}

Steps to reproduce

1. sudo -u www-data /usr/bin/php -f /opt/nextcloud/cron.php

Expected behavior

Error should not occur?

Installation method

None

Nextcloud Server version

26

Operating system

Debian/Ubuntu

PHP engine version

None

Web server

None

Database engine version

None

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

None

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

No response

List of activated Apps

.

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

[max-nextcloud]

I think this is a duplicate of #3989