SQLAlchemy Transaction error

[waltcow]

Dify version

0.3.21

Cloud or Self Hosted

Self Hosted

Steps to reproduce

psycopg2.InterfaceError: cursor already closed

        with db.engine.begin() as conn:
            rs = conn.execute(db.text(sql_query), arg_dict)

        response_data = []

        for i in rs:
            response_data.append({
                'date': str(i.date),
                'interactions': float(i.interactions.quantize(Decimal('0.01')))
            })

        return jsonify({
            'data': response_data
        })

(https://github.com/langgenius/dify/blob/cc35d0645a862c7eea28ff34b044ba8ebf29ff6e/api/controllers/console/app/statistic.py#L259C1-L272C11)

✔️ Expected Behavior

no error

❌ Actual Behavior

sql error

[takatost]

Can you please make a PR if possible? I would be extremely grateful!

[waltcow]

Okay

[waltcow]

Can you please make a PR if possible? I would be extremely grateful!

#1586