×

Notice

The forum is in read only mode.

Trino.history() - Trino issues accessing data today (12th June'24)

5 months 3 weeks ago #2738 by Herson
Good morning,

There appears to be an operational issue with the TRINO platform today.   I'm getting the following error when running my usual SQL query.

sqlalchemy.exc.OperationalError: (trino.exceptions.TrinoExternalError) TrinoExternalError(type=EXTERNAL, name=HIVE_UNKNOWN_ERROR, message="Unable to execute HTTP request: Timeout waiting for connection from pool", query_id=20240612_080708_78666_jtdt5)

SQL: select time,icao24,lat,lon, velocity,heading,vertrate, callsign,onground,baroaltitude,geoaltitude,lastposupdate,lastcontact, hour ,'WINCHESTER-WEST' as area_of_record,  format('%S',to_unixtime(date '2024-06-12' + interval '-31' day)) as vStartParameterCalc, format('%S',to_unixtime(date '2024-06-12' + interval '0' day)) as vEndParameterInput   FROM state_vectors_data4 where lat between 51.06152 and 51.09048 and lon between -1.366071 and -1.320889 and hour between to_unixtime(date '2024-06-12' + interval '-31' day) and to_unixtime(date '2024-06-12' + interval '0' day) order by 14 desc limit all]

(Background on this error at: sqlalche.me/e/20/e3q8)

Best regards.

Richard.
5 months 3 weeks ago #2739 by Herson
This is no longer an issue and is now back working.  Thanks all.

Richard.
Powered by Kunena Forum