For AI agents: the complete documentation index is at llms.txt. Every page is also available as markdown by appending .md to its URL, or by sending an Accept: text/markdown request header.

ALTER LIVE VIEW RESUME WAL

Restarts WAL apply on a live view whose own WAL was suspended after an error, such as a full disk, so that the view's disk tier catches up again.

Syntax​

ALTER LIVE VIEW viewName RESUME WAL
    [ FROM { TRANSACTION | TXN } sequencerTxn ];

Parameters​

ParameterDescription
viewNameName of the live view to resume
FROM TRANSACTION or FROM TXNOptional transaction to resume from. Defaults to the failed transaction
sequencerTxnA transaction number of the view's own WAL, as reported by wal_tables(), not a base-table transaction

When to use​

A live view writes its output to its own WAL-backed table. If applying one of the view's WAL transactions fails, QuestDB suspends the view's WAL like that of any other WAL table. The view's next flush after a base-table commit retries the apply and clears the suspension if the cause is gone, but a view whose base table is idle stays suspended until you resume it. live_views() still reports view_status = 'active' for a suspended view, so check wal_tables() instead:

Find suspended live views
SELECT w.name, w.writerTxn, w.sequencerTxn, w.errorTag, w.errorMessage
FROM wal_tables() w
JOIN live_views() v ON w.name = v.view_name
WHERE w.suspended;

RESUME WAL only recovers a suspended WAL writer. It does not revalidate a view that has been invalidated; an invalid view must be dropped and recreated.

Examples​

Resume WAL processing
ALTER LIVE VIEW trades_ma RESUME WAL;
Resume from a specific transaction
ALTER LIVE VIEW trades_ma RESUME WAL FROM TRANSACTION 5;

Resuming from a later transaction skips the earlier ones. Fix the underlying issue and resume from the failed transaction where possible.

Permissions (Enterprise)​

Resuming WAL on a live view requires the RESUME WAL permission on the view:

Grant resume permission
GRANT RESUME WAL ON trades_ma TO user1;

Errors​

Messages are shown by their stable prefix. The server may append details, such as [name=trades_ma].

ErrorCause
live view name expectedThe name refers to a table or view that is not a live view
table does not existNo table or view with this name exists
'resume' or 'suspend' expectedThe statement uses an unsupported ALTER LIVE VIEW operation, such as SET TTL or ADD COLUMN. Only RESUME WAL is supported

See also​