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

Persistent query silently fails / is deleted, but still shows as RUNNING #10255

Open
1riatsila1 opened this issue Feb 28, 2024 · 0 comments
Open

Comments

@1riatsila1
Copy link

Describe the bug
A persistent query stopped working completely. Seemingly during a maintenance window, and is in an irrecoverable state. I have not been able to reproduce the error

To Reproduce
Steps to reproduce the behavior, include:

  1. The version of KSQL: 7.2.1

Have a persistent query (CREATE STREAM AS SELECT in this case)
Let some time pass
Possibly have some broker maintenance

Expected behavior
The query should operate as it always has.
Or if the query enters a bad state, it should reflect as failed or we should receive a warning.

Actual behaviour
A clear and concise description of what actually happens, including:

  • The query stops working (data is not produced onto the target topic / stream)
  • When running SHOW QUERIES I see:
<QUERY_ID>           | PERSISTENT | RUNNING:1 | <STREAM>           | <topic>           | CREATE STREAM ... AS SELECT ...

Then the following:

ksql> explain <QUERY_ID>;
Query with id:<QUERY_ID> does not exist, use SHOW QUERIES to view the full set of queries.
ksql> terminate <QUERY_ID>;
Unknown queryId: <QUERY_ID>

But running SHOW QUERIES still yeilds

<QUERY_ID>           | PERSISTENT | RUNNING:1 | <STREAM>           | <topic>           | CREATE STREAM ... AS SELECT ...

Note how the state incorrectly reflects as RUNNING

Additional context

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

No branches or pull requests

1 participant