Skip to content
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

KSQL does not accept more queries when running QueryLimit - 1 queries #5454

Closed
spena opened this issue May 21, 2020 · 0 comments · Fixed by #5461
Closed

KSQL does not accept more queries when running QueryLimit - 1 queries #5454

spena opened this issue May 21, 2020 · 0 comments · Fixed by #5461
Assignees
Labels
Milestone

Comments

@spena
Copy link
Member

spena commented May 21, 2020

Describe the bug
If the query limit is set to 20, then KSQL only allows executing 19 queries.

To Reproduce
Set the limit to 1 in the ksql-server.properties file:

ksql.query.persistent.active.limit=1

Open the CLI and execute one persistent query (it will fail):

ksql> create stream t1(id int) with (kafka_topic='t1', value_format='json', replicas=1, partitions=1);
 Message        
----------------
 Stream created 
----------------
ksql> create stream s1 as select * from t1;
Not executing statement(s) 'create stream s1 as select * from t1;' as it would cause the number of active, persistent queries to exceed the configured limit. Use the TERMINATE command to terminate existing queries, or increase the 'ksql.query.persistent.active.limit' setting via the 'ksql-server.properties' file. Current persistent query count: 1. Configured limit: 1.

Expected behavior
I should be able to execute as many queries as the limit allowed me (1 query in the above example).

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

Successfully merging a pull request may close this issue.

1 participant