Skip to content

[QueryService] Cannot update multiply tables in one transaction #2699

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
alex268 opened this issue Mar 13, 2024 · 1 comment
Closed

[QueryService] Cannot update multiply tables in one transaction #2699

alex268 opened this issue Mar 13, 2024 · 1 comment
Assignees

Comments

@alex268
Copy link
Member

alex268 commented Mar 13, 2024

When we try to update different tables in one transaction on QueryService we get error
code: INTERNAL_ERROR, issues: [contrib/ydb/core/kqp/executer_actor/kqp_executer_impl.cpp:98 CreateKqpExecuter(): requirement *txsType == NKqpProto::TKqpPhyTx::TYPE_DATA failed, message: Cannot execute multiple non-data physical txs. (S_ERROR)]

Reproduction:
You can reproduce this problem from Java SDK branch
First build query service module with dependencies (all commands are executed from SDK root)
mvn -am -pl query -DskipTests=true install
Then execute test on docker container
mvn -pl query -Dtest=tech.ydb.query.QueryIntegrationTest#updateMultipleTablesInOneTransaction surefire:test
Or execute test on existing YDB instance
mvn -pl query -DYDB_ENDPOINT=<endpoint>:2135 -DYDB_DATABASE=/Root/db1 -Dtest=tech.ydb.query.QueryIntegrationTest#updateMultipleTablesInOneTransaction surefire:test

@gridnevvvit
Copy link
Member

issue was fixed in PR #2919

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants