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

Long running no data query Timeout "Operation timed out" #221

Open
gempir opened this issue Jul 17, 2024 · 1 comment
Open

Long running no data query Timeout "Operation timed out" #221

gempir opened this issue Jul 17, 2024 · 1 comment

Comments

@gempir
Copy link

gempir commented Jul 17, 2024

I have a long running query. The query just copies data from 1 table into another table.
So no data is actually transferred to the client and no data is being sent besides the initial query.

This can take longer than 5 minutes.
This works fine in the normal builtin cpp clickhouse-client and finishes after ~10-20mins

But in this client that makes use of the http API I cannot get past 5 minutes.

In Statement.php line 190:

  [ClickHouseDB\Exception\QueryException (28)]
  Operation timed out after 300000 milliseconds with 0 bytes received

I have set every setting imaginable on the client.

        $this->clickhouseClient->setTimeout($timeoutSeconds);
        $this->clickhouseClient->setConnectTimeOut($timeoutSeconds);
        $this->clickhouseClient->settings()->max_execution_time($timeoutSeconds);
        $this->clickhouseClient->settings()->set('tcp_keep_alive_timeout', $timeoutSeconds);
        $this->clickhouseClient->settings()->set('send_timeout', $timeoutSeconds);
        $this->clickhouseClient->settings()->set('receive_timeout', $timeoutSeconds);
        $this->clickhouseClient->settings()->set('session_timeout', $timeoutSeconds);
        $this->clickhouseClient->write($query, $bindings);

Is there something I'm missing? Maybe some hard limit somewhere?

@gempir
Copy link
Author

gempir commented Jul 17, 2024

#197 sounds similar but patching the client and trying it out with javascript does not seem to make a difference.

A normal curl cli calls works.

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

1 participant