Thread
#secoda-support
    h

    happy-finland-51108

    11 months ago
    [Result size exceeds LISTAGG limit code]
    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>)
    e

    elegant-house-93198

    11 months ago
    If you update the application by running the update script (
    update-secoda.sh
    ) this bug will have been fixed
    h

    happy-finland-51108

    11 months ago
    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?
    e

    elegant-house-93198

    11 months ago
    Are you able to see the login screen at all?
    h

    happy-finland-51108

    11 months ago
    nope
    e

    elegant-house-93198

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

    happy-finland-51108

    11 months ago
    5-10 minutes