This message was deleted.

Hi there. We have the following error when trying to export data from Redshift:

psycopg2.InternalError) Result size exceeds LISTAGG limit DETAIL: ----------------------------------------------- error: Result size exceeds LISTAGG limit code: 8001 context: LISTAGG limit: 65535 query: 2102954 location: string_ops.cpp:116 process: query0_117_2102954 [pid=28836] ----------------------------------------------- [SQL: WITH queries AS ( SELECT query, LISTAGG(CASE WHEN LEN(RTRIM(text)) = 0 THEN text ELSE RTRIM(text) END) WITHIN GROUP (ORDER BY sequence) as query_statement, COUNT(*) as row_count FROM stl_querytext GROUP BY query ORDER BY query desc ) SELECT DISTINCT(sqt.query_statement) as query, CURRENT_DATABASE() as cluster FROM queries AS sqt LEFT JOIN stl_scan ssc ON ssc.query = sqt.query LEFT JOIN svv_table_info sti ON ssc.tbl = sti.table_id WHERE sti.schema IS NOT NULL AND sti.database = CURRENT_DATABASE() AND starttime > DATEADD(hour, -24, getdate()) LIMIT 1000 ] (Background on this error at: <https://sqlalche.me/e/14/2j85>)

If you update the application by running the update script (

update-secoda.sh

) this bug will have been fixed

after running script and updating .env I have

502 Bad Gateway

are there maybe some logs I should check out in case of any problems?

Are you able to see the login screen at all?

nope

Sometimes it takes a couple of minutes to start up after a restart. How long ago did you restart it?

5-10 minutes