You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When submitting for example this Online DDL, and assuming view v exists:
vtctlclient -- ApplySchema --skip_preflight --ddl_strategy "online --allow-zero-in-date --allow-concurrent --postpone-completion" --sql "alter view v as select 17 from dual" commerce
the scheduler runs the statement to immediate completion, even though --postpone-completion is specified.
This happens because originally we were only dealing with tables. We only considered CREATE and DROP statements to be "immediate", and assumed that all ALTER statements are handled by gh-ost or vreplication. But an ALTER VIEW is an immediate operation, too, and this needs to be taken into consideration.
The new (and still undocumented --prefer-instant-ddl) flag also does not respect --postpone-completion. For example:
Here, the problem is that the query is sent to run, but it's only at that stage that it is processed and evaluated, and found to be eligible to INSTANT ddl.
The text was updated successfully, but these errors were encountered:
When submitting for example this Online DDL, and assuming view
v
exists:the scheduler runs the statement to immediate completion, even though
--postpone-completion
is specified.This happens because originally we were only dealing with tables. We only considered
CREATE
andDROP
statements to be "immediate", and assumed that allALTER
statements are handled bygh-ost
orvreplication
. But anALTER VIEW
is an immediate operation, too, and this needs to be taken into consideration.The new (and still undocumented
--prefer-instant-ddl
) flag also does not respect--postpone-completion
. For example:Here, the problem is that the query is sent to run, but it's only at that stage that it is processed and evaluated, and found to be eligible to
INSTANT
ddl.The text was updated successfully, but these errors were encountered: