all-things-risingwave

What could be causing a SQL query to hang indefinitely without returning a result or reporting an error?

I have inserted about 1 million data into a source and executed a SQL query like select count(*) from mv or select * from mv limit 40000, but the query is not returning any result and not reporting any error. It has been in a waiting state for over 30 minutes. There are no error messages in the logs. Query mode seems to have an impact on the situation, where setting it to distribute mode makes it return results sometimes but not consistently, and introduces another error message. What could be causing this issue?

ji

jie

Asked on Oct 18, 2022

  • The issue could be related to the query mode settings, specifically when set to distribute mode.
  • It's possible that the version being used (v0.1.12) is not the latest and may have some bugs.
  • There might be a hang-up local mode execution issue.
  • Task status reported as Unspecified could indicate potential issues.
  • Testing the latest version (v0.1.13) or the latest main branch could help resolve the problem.
Oct 19, 2022Edited by