Skip to content
This repository was archived by the owner on Mar 31, 2026. It is now read-only.

Slow queries returning "RST_STREAM with error code 2" #19

Description

@aidanalphafund

When running a slow query (30+ seconds), I'm getting the following error:

pyarrow._flight.FlightInternalError: Flight returned internal error, with message: Received RST_STREAM with error code 2. gRPC client debug context: UNKNOWN:Error received from peer ipv4:54.174.236.48:443 {created_time:"2023-05-26T17:31:53.650218-06:00", grpc_status:13, grpc_message:"Received RST_STREAM with error code 2"}. Client context: OK

I'm storing stock market information in my database, and running this query:

        SELECT 
        DATE_BIN(INTERVAL '5 minutes', time) as date,
        symbol,
        selector_first(open, time)['value'] as open,
        selector_last(close, time)['value'] as close,
        selector_max(high, time)['value'] as high,
        selector_min(low, time)['value'] as low,
        sum(volume) as volume
        from minute_bar
        GROUP BY symbol, date
        ORDER BY symbol, date

When running using the influxdb data explorer, this query takes around 2 minutes to run. I consistently get this same error when using the flightsql-dbapi python library to run the query

Activity

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions