Errors on CS scheme operations via query service

ydb-platform / ydb

YDB is an open source Distributed SQL Database that combines high availability and scalability with strong consistency and ACID transactions

https://ydb.tech

Apache License 2.0

4.01k stars 577 forks source link

Errors on CS scheme operations via query service #8526

Open ildar-khisambeev opened 2 months ago

ildar-khisambeev commented 2 months ago

Any scheme operation, which I try to execute in YDB monitoring embedded UI with Query type = "YQL - QueryService (default)", fails. Example: Query: CREATE TABLE ... WITH (STORE = COLUMN) Error: Scheme operations cannot be executed inside transaction

Tried on cluster OLAP Perf VLA 1 with YDB version main.93089ee

spuchin commented 2 months ago

We should use NoTx (do not specify TxControl) for QueryService when working from UI. It will execute query in implicit transaction, which allows scheme operations. @adameat

adameat commented 2 months ago

what is the version of YDB server?