Skip to content

Usage of event queues with cds.sql.lock_acquire_timeout not possible #2831

Description

@stockbal

There should be a warning in the event queues documentation that the setting cds.sql.lock_acquire_timeout must not be present in package.json. If it is the event queue processing will fail on HANA.

SELECT 
  ID, timestamp, target, msg, attempts,
  partition, lastError, lastAttemptTimestamp, status, task,
  appid
FROM cds_outbox_Messages as Messages
WHERE Messages.target = 'queue' and Messages.attempts < 20 and (Messages.status is NULL or Messages.lastAttemptTimestamp < '2026-08-19T19:48:21.581Z')
ORDER BY Messages.status ASC,Messages.timestamp ASC,Messages.ID ASC
LIMIT 10 FOR UPDATE IGNORE LOCKED WAIT 15 
queue: Message retrieval failed sql syntax error: incorrect syntax near "WAIT": line 1 col 526 (at pos 526) Retry attempt 18 in 1477 s

With the setting lock_acquire_timeout in place, the select statement includes both ignore locked and wait <number> into the statement which are mutually exclusive.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions