Skip to content

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

@aidanalphafund

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

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