langgenius/dify
1
0
Fork 0
mirror of https://github.com/langgenius/dify.git synced 2026-07-21 20:15:31 -04:00
Code Issues 775 Packages Projects Releases 10 Wiki Activity

SQLAlchemy Transaction error #721

New Issue
Closed
opened 2026-02-21 17:28:10 -05:00 by yindo · 3 comments
yindo commented 2026-02-21 17:28:10 -05:00
Owner
Copy Link
Copy Source

Originally created by @waltcow on GitHub (Nov 21, 2023).

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)

image

✔️ Expected Behavior

no error

❌ Actual Behavior

sql error

Originally created by @waltcow on GitHub (Nov 21, 2023). ### Dify version 0.3.21 ### Cloud or Self Hosted Self Hosted ### Steps to reproduce > psycopg2.InterfaceError: cursor already closed ```python 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) <img width="2421" alt="image" src="https://github.com/langgenius/dify/assets/3941174/4851b484-5896-4a9d-ac38-845fa377d25f"> ### ✔️ Expected Behavior no error ### ❌ Actual Behavior sql error
yindo added the 🐞 bug label 2026-02-21 17:28:10 -05:00
yindo closed this issue 2026-02-21 17:28:10 -05:00
yindo commented 2026-02-21 17:28:10 -05:00
Author
Owner
Copy Link
Copy Source

@takatost commented on GitHub (Nov 21, 2023):

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

@takatost commented on GitHub (Nov 21, 2023): Can you please make a PR if possible? I would be extremely grateful!
yindo commented 2026-02-21 17:28:10 -05:00
Author
Owner
Copy Link
Copy Source

@waltcow commented on GitHub (Nov 21, 2023):

Okay

@waltcow commented on GitHub (Nov 21, 2023): Okay
yindo commented 2026-02-21 17:28:10 -05:00
Author
Owner
Copy Link
Copy Source

@waltcow commented on GitHub (Nov 21, 2023):

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

https://github.com/langgenius/dify/pull/1586

@waltcow commented on GitHub (Nov 21, 2023): > Can you please make a PR if possible? I would be extremely grateful! https://github.com/langgenius/dify/pull/1586
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Knowledge Pipeline
Proposal
WIP
cloud
dependencies
feat:webapp
good first issue
outdated
performance
pull-request
Mirrored from GitHub Pull Request
 python:uv
refactor
size:L
stale
status: accepting prs
status: blocked
status: in discussion
stt & tts
vulnerablity
web
wont-fix
🌊 feat:workflow
🌚 invalid
🐞 bug
👻 feat:rag
💪 enhancement
📚 documentation
🔨 feat:tools
🙋‍♂️ question
🙏 help wanted
🤔 cant-reproduce
🤖 feat:agent
No Label 🐞 bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
yindo
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#721
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?