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

从0.3.22 升级到 0.3.23 获取数据集列表时报错 #533

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

Originally created by @xsxs89757 on GitHub (Sep 25, 2023).

Dify version

0.3.23

Cloud or Self Hosted

Self Hosted

Steps to reproduce

从0.3.22 升级到 0.3.23 获取数据集列表时报错
ERROR:app:Exception on /console/api/datasets [GET]
0|flask-app | Traceback (most recent call last):
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in execute_context
0|flask-app | self.dialect.do_execute(
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
0|flask-app | cursor.execute(statement, parameters)
0|flask-app | psycopg2.errors.UndefinedColumn: column datasets.collection_binding_id does not exist
0|flask-app | LINE 1: ...el_provider AS datasets_embedding_model_provider, datasets.c...
0|flask-app | ^
0|flask-app | The above exception was the direct cause of the following exception:
0|flask-app | Traceback (most recent call last):
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request
0|flask-app | rv = self.dispatch_request()
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request
0|flask-app | return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask_restful/__init__.py", line 467, in wrapper
0|flask-app | resp = resource(*args, **kwargs)
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask/views.py", line 109, in view
0|flask-app | return current_app.ensure_sync(self.dispatch_request)(**kwargs)
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask_restful/__init_.py", line 582, in dispatch_request
0|flask-app | resp = meth(*args, **kwargs)
0|flask-app | File "/data/dify/api/controllers/console/setup.py", line 79, in decorated
0|flask-app | return view(*args, **kwargs)
0|flask-app | File "/data/dify/api/core/login/login.py", line 94, in decorated_view
0|flask-app | return current_app.ensure_sync(func)(*args, **kwargs)
0|flask-app | File "/data/dify/api/controllers/console/wraps.py", line 19, in decorated
0|flask-app | return view(*args, **kwargs)
0|flask-app | File "/data/dify/api/controllers/console/datasets/datasets.py", line 80, in get
0|flask-app | datasets, total = DatasetService.get_datasets(page, limit, provider,
0|flask-app | File "/data/dify/api/services/dataset_service.py", line 52, in get_datasets
0|flask-app | datasets = Dataset.query.filter(
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask_sqlalchemy/query.py", line 98, in paginate
0|flask-app | return QueryPagination(
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask_sqlalchemy/pagination.py", line 72, in init
0|flask-app | items = self._query_items()
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask_sqlalchemy/pagination.py", line 358, in _query_items
0|flask-app | out = query.limit(self.per_page).offset(self._query_offset).all()
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2773, in all
0|flask-app | return self._iter().all()
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
0|flask-app | result = self.session.execute(
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1717, in execute
0|flask-app | result = conn._execute_20(statement, params or {}, execution_options)
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20
0|flask-app | return meth(self, args_10style, kwargs_10style, execution_options)
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
0|flask-app | return connection._execute_clauseelement(
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
0|flask-app | ret = self._execute_context(
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
0|flask-app | self.handle_dbapi_exception(
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in handle_dbapi_exception
0|flask-app | util.raise(
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise
0|flask-app | raise exception
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
0|flask-app | self.dialect.do_execute(
0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
0|flask-app | cursor.execute(statement, parameters)
0|flask-app | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column datasets.collection_binding_id does not exist
0|flask-app | LINE 1: ...el_provider AS datasets_embedding_model_provider, datasets.c...
0|flask-app | ^
0|flask-app | [SQL: SELECT datasets.id AS datasets_id, datasets.tenant_id AS datasets_tenant_id, datasets.name AS datasets_name, datasets.description AS datasets_description, datasets.provider AS datasets_provider, datasets.permission AS datasets_permission, datasets.data_source_type AS datasets_data_source_type, datasets.indexing_technique AS datasets_indexing_technique, datasets.index_struct AS datasets_index_struct, datasets.created_by AS datasets_created_by, datasets.created_at AS datasets_created_at, datasets.updated_by AS datasets_updated_by, datasets.updated_at AS datasets_updated_at, datasets.embedding_model AS datasets_embedding_model, datasets.embedding_model_provider AS datasets_embedding_model_provider, datasets.collection_binding_id AS datasets_collection_binding_id
0|flask-app | FROM datasets
0|flask-app | WHERE datasets.provider = %(provider_1)s AND datasets.tenant_id = %(tenant_id_1)s AND (datasets.created_by = %(created_by_1)s OR datasets.permission = %(permission_1)s) ORDER BY datasets.created_at DESC
0|flask-app | LIMIT %(param_1)s OFFSET %(param_2)s]
0|flask-app | [parameters: {'provider_1': 'vendor', 'tenant_id_1': UUID('5c3ef32e-abb8-4ea0-b459-37a4a0255974'), 'created_by_1': UUID('7cd42f43-6d50-488c-b0e0-9d0ad2214a73'), 'permission_1': 'all_team_members', 'param_1': 30, 'param_2': 0}]
0|flask-app | (Background on this error at: https://sqlalche.me/e/14/f405)

✔️ Expected Behavior

No response

❌ Actual Behavior

No response

Originally created by @xsxs89757 on GitHub (Sep 25, 2023). ### Dify version 0.3.23 ### Cloud or Self Hosted Self Hosted ### Steps to reproduce 从0.3.22 升级到 0.3.23 获取数据集列表时报错 ERROR:app:Exception on /console/api/datasets [GET] 0|flask-app | Traceback (most recent call last): 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context 0|flask-app | self.dialect.do_execute( 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute 0|flask-app | cursor.execute(statement, parameters) 0|flask-app | psycopg2.errors.UndefinedColumn: column datasets.collection_binding_id does not exist 0|flask-app | LINE 1: ...el_provider AS datasets_embedding_model_provider, datasets.c... 0|flask-app | ^ 0|flask-app | The above exception was the direct cause of the following exception: 0|flask-app | Traceback (most recent call last): 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request 0|flask-app | rv = self.dispatch_request() 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request 0|flask-app | return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask_restful/__init__.py", line 467, in wrapper 0|flask-app | resp = resource(*args, **kwargs) 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask/views.py", line 109, in view 0|flask-app | return current_app.ensure_sync(self.dispatch_request)(**kwargs) 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask_restful/__init__.py", line 582, in dispatch_request 0|flask-app | resp = meth(*args, **kwargs) 0|flask-app | File "/data/dify/api/controllers/console/setup.py", line 79, in decorated 0|flask-app | return view(*args, **kwargs) 0|flask-app | File "/data/dify/api/core/login/login.py", line 94, in decorated_view 0|flask-app | return current_app.ensure_sync(func)(*args, **kwargs) 0|flask-app | File "/data/dify/api/controllers/console/wraps.py", line 19, in decorated 0|flask-app | return view(*args, **kwargs) 0|flask-app | File "/data/dify/api/controllers/console/datasets/datasets.py", line 80, in get 0|flask-app | datasets, total = DatasetService.get_datasets(page, limit, provider, 0|flask-app | File "/data/dify/api/services/dataset_service.py", line 52, in get_datasets 0|flask-app | datasets = Dataset.query.filter( 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask_sqlalchemy/query.py", line 98, in paginate 0|flask-app | return QueryPagination( 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask_sqlalchemy/pagination.py", line 72, in __init__ 0|flask-app | items = self._query_items() 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/flask_sqlalchemy/pagination.py", line 358, in _query_items 0|flask-app | out = query.limit(self.per_page).offset(self._query_offset).all() 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2773, in all 0|flask-app | return self._iter().all() 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter 0|flask-app | result = self.session.execute( 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1717, in execute 0|flask-app | result = conn._execute_20(statement, params or {}, execution_options) 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20 0|flask-app | return meth(self, args_10style, kwargs_10style, execution_options) 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection 0|flask-app | return connection._execute_clauseelement( 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement 0|flask-app | ret = self._execute_context( 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context 0|flask-app | self._handle_dbapi_exception( 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception 0|flask-app | util.raise_( 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ 0|flask-app | raise exception 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context 0|flask-app | self.dialect.do_execute( 0|flask-app | File "/root/.conda/envs/dify/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute 0|flask-app | cursor.execute(statement, parameters) 0|flask-app | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column datasets.collection_binding_id does not exist 0|flask-app | LINE 1: ...el_provider AS datasets_embedding_model_provider, datasets.c... 0|flask-app | ^ 0|flask-app | [SQL: SELECT datasets.id AS datasets_id, datasets.tenant_id AS datasets_tenant_id, datasets.name AS datasets_name, datasets.description AS datasets_description, datasets.provider AS datasets_provider, datasets.permission AS datasets_permission, datasets.data_source_type AS datasets_data_source_type, datasets.indexing_technique AS datasets_indexing_technique, datasets.index_struct AS datasets_index_struct, datasets.created_by AS datasets_created_by, datasets.created_at AS datasets_created_at, datasets.updated_by AS datasets_updated_by, datasets.updated_at AS datasets_updated_at, datasets.embedding_model AS datasets_embedding_model, datasets.embedding_model_provider AS datasets_embedding_model_provider, datasets.collection_binding_id AS datasets_collection_binding_id 0|flask-app | FROM datasets 0|flask-app | WHERE datasets.provider = %(provider_1)s AND datasets.tenant_id = %(tenant_id_1)s AND (datasets.created_by = %(created_by_1)s OR datasets.permission = %(permission_1)s) ORDER BY datasets.created_at DESC 0|flask-app | LIMIT %(param_1)s OFFSET %(param_2)s] 0|flask-app | [parameters: {'provider_1': 'vendor', 'tenant_id_1': UUID('5c3ef32e-abb8-4ea0-b459-37a4a0255974'), 'created_by_1': UUID('7cd42f43-6d50-488c-b0e0-9d0ad2214a73'), 'permission_1': 'all_team_members', 'param_1': 30, 'param_2': 0}] 0|flask-app | (Background on this error at: https://sqlalche.me/e/14/f405) ### ✔️ Expected Behavior _No response_ ### ❌ Actual Behavior _No response_
yindo added the 🐞 bug label 2026-02-21 17:27:28 -05:00
yindo closed this issue 2026-02-21 17:27:28 -05:00
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#533
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?