Collection element: sqlalchemy.exc.DataError: (psycopg2.errors.StringDataRightTruncation) value too long for type character varying(255)

Open

#22,147 opened on Mar 17, 2026 1 comment 0 reactions 1 assignee Claimed by @mvdbeek View on GitHub

Dominant language: Python
Stars: 1.9k
Forks: 1.2k
Avg merge: 2d 16h
Merged PRs (30d): 169

Description

**Describe the bug**

The following Traceback is found in my logs. And repeats approx every second (which filled up the disk on our postgres server leading to a crash).

Guess the workflow scheduling should be aborted after the first try:

Not sure about the length limit, guess there has to be one ...

The cause is a user error (the workflow / workflow inputs were wrong).

```
galaxy.workflow.scheduling_manager DEBUG 2026-03-08 00:00:12,052 [pN:main.2,p:139507,tN:WorkflowRequestMonitor.monitor_thread] Attempting to schedule workflow invocation [5493]
galaxy.workflow.run INFO 2026-03-08 00:00:12,392 [pN:main.2,p:139507,tN:WorkflowRequestMonitor.monitor_thread] ADDING INPUT FOR STEP 63431: None
NoneType: None
galaxy.workflow.run INFO 2026-03-08 00:00:12,395 [pN:main.2,p:139507,tN:WorkflowRequestMonitor.monitor_thread] ADDING INPUT FOR STEP 63432: None
NoneType: None
galaxy.managers.collections DEBUG 2026-03-08 00:00:12,730 [pN:main.2,p:139507,tN:WorkflowRequestMonitor.monitor_thread] Created collection with 84 elements
galaxy.tools.actions.model_operations INFO 2026-03-08 00:00:12,738 [pN:main.2,p:139507,tN:WorkflowRequestMonitor.monitor_thread] Calling produce_outputs, tool is
galaxy.tools.execute DEBUG 2026-03-08 00:00:12,738 [pN:main.2,p:139507,tN:WorkflowRequestMonitor.monitor_thread] Tool __RELABEL_FROM_FILE__ created job None (223.705 ms)
galaxy.workflow.run ERROR 2026-03-08 00:00:12,798 [pN:main.2,p:139507,tN:WorkflowRequestMonitor.monitor_thread] Failed to execute scheduled workflow.
Traceback (most recent call last):
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2118, in _exec_insertmany_context
dialect.do_execute(
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.StringDataRightTruncation: value too long for type character varying(255)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/workflow/run.py", line 252, in invoke
incomplete_or_none = self._invoke_step(workflow_invocation_step)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/workflow/run.py", line 357, in _invoke_step
incomplete_or_none = invocation_step.workflow_step.module.execute(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/workflow/modules.py", line 2513, in execute
execution_tracker = execute(
^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/tools/execute.py", line 201, in execute
trans.sa_session.commit()
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/scoping.py", line 599, in commit
return self._proxied.commit()
^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2032, in commit
trans.commit(_to_root=True)
File "", line 2, in commit
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/state_changes.py", line 137, in _go
ret_value = fn(self, *arg, **kw)
^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 1313, in commit
self._prepare_impl()
File "", line 2, in _prepare_impl
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/state_changes.py", line 137, in _go
ret_value = fn(self, *arg, **kw)
^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 1288, in _prepare_impl
self.session.flush()
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4345, in flush
self._flush(objects)
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4480, in _flush
with util.safe_reraise():
^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4441, in _flush
flush_context.execute()
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute
rec.execute(self)
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute
util.preloaded.orm_persistence.save_obj(
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 93, in save_obj
_emit_insert_statements(
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 1143, in _emit_insert_statements
result = connection.execute(
^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1844, in _execute_context
return self._exec_insertmany_context(dialect, context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2126, in _exec_insertmany_context
self._handle_dbapi_exception(
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2118, in _exec_insertmany_context
dialect.do_execute(
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (psycopg2.errors.StringDataRightTruncation) value too long for type character varying(255)

[SQL: INSERT INTO dataset_collection_element (dataset_collection_id, hda_id, ldda_id, child_collection_id, element_index, element_identifier, columns) SELECT p0::INTEGER, p1::INTEGER, p2::INTEGER, p3::INTEGER, p4::INTEGER, p5::VARCHAR, p6::BYTEA FROM (VALU ... 14003 characters truncated ... ORDER BY sen_counter RETURNING dataset_collection_
element.id, dataset_collection_element.id AS id__1]
[parameters: {'element_index__0': 0, 'dataset_collection_id__0': 324494, 'ldda_id__0': None, 'element_identifier__0': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (13737 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq
.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__0': None, 'hda_id__0': 8293469, 'columns__0': None, 'element_index__1': 1, 'dataset_collection_id__1': 324494, 'ldda_id__1': None, 'element_identifier__1': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L0
01_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__1': None, 'hda_id__1': 82934
70, 'columns__1': None, 'element_index__2': 2, 'dataset_collection_id__2': 324494, 'ldda_id__2': None, 'element_identifier__2': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2
_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__2': None, 'hda_id__2': 8293471, 'columns__2': None, 'element_index__3': 3, 'dataset_collection_id__3': 324494, 'ldda_id__3': None, 'element_identifier__3': '_L001_R2_001.fastq.gz__L001_R2_001.fa
stq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__3': None, 'hda_id_
_3': 8293472, 'columns__3': None, 'element_index__4': 4, 'dataset_collection_id__4': 324494, 'ldda_id__4': None, 'element_identifier__4': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.g
zs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__4': None, 'hda_id__4': 8293473, 'columns__4': None, 'element_index__5': 5, 'dataset_collection_id__5': 324494, 'ldda_id__5': None, 'element_identifier__5': '_L001_R2_001.fastq.gz__L001
_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__5': None
, 'hda_id__5': 8293474, 'columns__5': None, 'element_index__6': 6, 'dataset_collection_id__6': 324494, 'ldda_id__6': None, 'element_identifier__6': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_0
01.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__6': None, 'hda_id__6': 8293475, 'columns__6': None, 'element_index__7': 7 ... 488 parameters truncated ... 'columns__76': None, 'element_index__77': 77, 'dataset_collection_i
d__77': 324494, 'ldda_id__77': None, 'element_identifier__77': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R
2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__77': None, 'hda_id__77': 8293546, 'columns__77': None, 'element_index__78': 78, 'dataset_collection_id__78': 324494, 'ldda_id__78': None, 'element_identifier__78': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_
R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__78': None, 'hda_id__78': 8293547, 'columns__78': None, 'element_index__79':
79, 'dataset_collection_id__79': 324494, 'ldda_id__79': None, 'element_identifier__79': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L0
01_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__79': None, 'hda_id__79': 8293548, 'columns__79': None, 'element_index__80': 80, 'dataset_collection_id__80': 324494, 'ldda_id__80': None, 'element_identifier__80': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L
001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__80': None, 'hda_id__80': 8293549, 'columns__80':
None, 'element_index__81': 81, 'dataset_collection_id__81': 324494, 'ldda_id__81': None, 'element_identifier__81': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gz
t_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__81': None, 'hda_id__81': 8293550, 'columns__81': None, 'element_index__82': 82, 'dataset_collection_id__82': 324494, 'ldda_id__82': None, 'element_identifier__82': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.g
zL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__82': None, 'hda_id__82'
: 8293551, 'columns__82': None, 'element_index__83': 83, 'dataset_collection_id__83': 324494, 'ldda_id__83': None, 'element_identifier__83': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fast
q.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__83': None, 'hda_id__83': 8293552, 'columns__83': None}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/workflow/run.py", line 100, in __invoke
outputs = invoker.invoke()
^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/workflow/run.py", line 283, in invoke
self.workflow_invocation.log_str(),
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/model/__init__.py", line 9912, in log_str
if (safe_id := getattr(self, "id", None)) is not None:
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 569, in __get__
return self.impl.get(state, dict_) # type: ignore[no-any-return]
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 1096, in get
value = self._fire_loader_callables(state, key, passive)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 1126, in _fire_loader_callables
return state._load_expired(state, passive)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/state.py", line 803, in _load_expired
self.manager.expired_attribute_loader(self, toload, passive)
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/loading.py", line 1674, in load_scalar_attributes
result = load_on_ident(
^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/loading.py", line 510, in load_on_ident
return load_on_pk_identity(
^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/loading.py", line 695, in load_on_pk_identity
session.execute(
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2365, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2241, in _execute_internal
conn = self._connection_for_bind(bind)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2110, in _connection_for_bind
return trans._connection_for_bind(engine, execution_options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "", line 2, in _connection_for_bind
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/state_changes.py", line 101, in _go
self._raise_for_prerequisite_state(fn.__name__, current_state)
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 973, in _raise_for_prerequisite_state
raise sa_exc.PendingRollbackError(
sqlalchemy.exc.PendingRollbackError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (psycopg2.errors.StringDataRightTruncation) value too long for type character varying(255)

The above exception was the direct cause of the following exception:

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/workflow/scheduling_manager.py", line 453, in __attempt_schedule
workflow_scheduler.schedule(workflow_invocation)
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/workflow/schedulers/core.py", line 41, in schedule
run.schedule(
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/workflow/run.py", line 72, in schedule
return __invoke(trans, workflow, workflow_run_config, workflow_invocation)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/workflow/run.py", line 119, in __invoke
workflow_invocation.add_message(failure)
File "/gpfs1/data/galaxy_server/galaxy/lib/galaxy/model/__init__.py", line 9876, in add_message
self.messages.append(
^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 569, in __get__
return self.impl.get(state, dict_) # type: ignore[no-any-return]
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 1096, in get
value = self._fire_loader_callables(state, key, passive)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 1131, in _fire_loader_callables
return self.callable_(state, passive)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/strategies.py", line 978, in _load_for_state
return self._emit_lazyload(
^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/strategies.py", line 1109, in _emit_lazyload
lazy_clause, params = self._generate_lazy_clause(state, passive)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/strategies.py", line 858, in _generate_lazy_clause
value = mapper._get_state_attr_by_column(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/mapper.py", line 3594, in _get_state_attr_by_column
return state.manager[prop.key].impl.get(state, dict_, passive=passive)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 1096, in get
value = self._fire_loader_callables(state, key, passive)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/attributes.py", line 1126, in _fire_loader_callables
return state._load_expired(state, passive)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/state.py", line 803, in _load_expired
self.manager.expired_attribute_loader(self, toload, passive)
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/loading.py", line 1674, in load_scalar_attributes
result = load_on_ident(
^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/loading.py", line 510, in load_on_ident
return load_on_pk_identity(
^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/loading.py", line 695, in load_on_pk_identity
session.execute(
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2365, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2241, in _execute_internal
conn = self._connection_for_bind(bind)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2110, in _connection_for_bind
return trans._connection_for_bind(engine, execution_options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "", line 2, in _connection_for_bind
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/state_changes.py", line 101, in _go
self._raise_for_prerequisite_state(fn.__name__, current_state)
File "/gpfs1/data/galaxy_server/galaxy/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 973, in _raise_for_prerequisite_state
raise sa_exc.PendingRollbackError(
sqlalchemy.exc.PendingRollbackError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (psycopg2.errors.StringDataRightTruncation) value too long for type character varying(255)

[SQL: INSERT INTO dataset_collection_element (dataset_collection_id, hda_id, ldda_id, child_collection_id, element_index, element_identifier, columns) SELECT p0::INTEGER, p1::INTEGER, p2::INTEGER, p3::INTEGER, p4::INTEGER, p5::VARCHAR, p6::BYTEA FROM (VALU ... 14003 characters truncated ... ORDER BY sen_counter RETURNING dataset_collection_element.id, dataset_collection_element.id AS id__1]
[parameters: {'element_index__0': 0, 'dataset_collection_id__0': 324494, 'ldda_id__0': None, 'element_identifier__0': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (13737 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__0': None, 'hda_id__0': 8293469, 'columns__0': None, 'element_index__1': 1, 'dataset_collection_id__1': 324494, 'ldda_id__1': None, 'element_identifier__1': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__1': None, 'hda_id__1': 8293470, 'columns__1': None, 'element_index__2': 2, 'dataset_collection_id__2': 324494, 'ldda_id__2': None, 'element_identifier__2': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__2': None, 'hda_id__2': 8293471, 'columns__2': None, 'element_index__3': 3, 'dataset_collection_id__3': 324494, 'ldda_id__3': None, 'element_identifier__3': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__3': None, 'hda_id__3': 8293472, 'columns__3': None, 'element_index__4': 4, 'dataset_collection_id__4': 324494, 'ldda_id__4': None, 'element_identifier__4': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__4': None, 'hda_id__4': 8293473, 'columns__4': None, 'element_index__5': 5, 'dataset_collection_id__5': 324494, 'ldda_id__5': None, 'element_identifier__5': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__5': None, 'hda_id__5': 8293474, 'columns__5': None, 'element_index__6': 6, 'dataset_collection_id__6': 324494, 'ldda_id__6': None, 'element_identifier__6': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14220 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__6': None, 'hda_id__6': 8293475, 'columns__6': None, 'element_index__7': 7 ... 488 parameters truncated ... 'columns__76': None, 'element_index__77': 77, 'dataset_collection_id__77': 324494, 'ldda_id__77': None, 'element_identifier__77': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__77': None, 'hda_id__77': 8293546, 'columns__77': None, 'element_index__78': 78, 'dataset_collection_id__78': 324494, 'ldda_id__78': None, 'element_identifier__78': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__78': None, 'hda_id__78': 8293547, 'columns__78': None, 'element_index__79': 79, 'dataset_collection_id__79': 324494, 'ldda_id__79': None, 'element_identifier__79': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__79': None, 'hda_id__79': 8293548, 'columns__79': None, 'element_index__80': 80, 'dataset_collection_id__80': 324494, 'ldda_id__80': None, 'element_identifier__80': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__80': None, 'hda_id__80': 8293549, 'columns__80': None, 'element_index__81': 81, 'dataset_collection_id__81': 324494, 'ldda_id__81': None, 'element_identifier__81': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__81': None, 'hda_id__81': 8293550, 'columns__81': None, 'element_index__82': 82, 'dataset_collection_id__82': 324494, 'ldda_id__82': None, 'element_identifier__82': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__82': None, 'hda_id__82': 8293551, 'columns__82': None, 'element_index__83': 83, 'dataset_collection_id__83': 324494, 'ldda_id__83': None, 'element_identifier__83': '_L001_R2_001.fastq.gz__L001_R2_001.fastq.gzL_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz0_L001_R2_001.fastq.gz1_L001_R2_001.fastq.gz__L001_R2_001.fast ... (14704 characters truncated) ... 1_R2_001.fastq.gzs_L001_R2_001.fastq.gzt_L001_R2_001.fastq.gzq_L001_R2_001.fastq.gz._L001_R2_001.fastq.gzg_L001_R2_001.fastq.gzz_L001_R2_001.fastq.gz', 'child_collection_id__83': None, 'hda_id__83': 8293552, 'columns__83': None}]
(Background on this error at: https://sqlalche.me/e/20/9h9h) (Background on this error at: https://sqlalche.me/e/20/7s2a)
```

**Galaxy Version and/or server at which you observed the bug**
Galaxy Version: 25.1
Commit: 4da5a5f5ee

**To Reproduce**
Steps to reproduce the behavior:
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

**Additional context**

TODO

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Collection element: sqlalchemy.exc.DataError: (psycopg2.errors.StringDataRightTruncation) value too long for type character varying(255)

Description

Contributor guide

Assessment

Get new issues in your inbox