-
Notifications
You must be signed in to change notification settings - Fork 1.1k
Open
Labels
Description
Sentry Issue: GALAXY-MAIN-4KSCZZZ0014SG
AmbiguousColumn: column reference "assemblies_0|track_groups_0|data_tracks_0|data_format|pafuseuri" is ambiguous
LINE 7: ...|track_groups_0|data_tracks_0|data_format|use_1", job_ids_ct...
^
File "sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "sqlalchemy/engine/default.py", line 952, in do_execute
cursor.execute(statement, parameters)
ProgrammingError: (psycopg2.errors.AmbiguousColumn) column reference "assemblies_0|track_groups_0|data_tracks_0|data_format|pafuseuri" is ambiguous
LINE 7: ...|track_groups_0|data_tracks_0|data_format|use_1", job_ids_ct...
^
[SQL: WITH job_ids_cte AS
(SELECT job.id AS job_id, job_to_input_dataset_1.dataset_id AS "assemblies_0|reference_genome|genome_0", job_to_input_dataset_2.dataset_id AS "assemblies_0|track_groups_0|data_tracks_0|data_format|useuri|annotation_0", job_to_input_dataset_3.dataset_id AS "assemblies_0|track_groups_0|data_tracks_0|data_format|pafuseuri|annotation_0", job_to_input_dataset_4.dataset_id AS "assemblies_0|track_groups_0|data_tracks_0|data_format|pafuseuri|annotation_1"
FROM job JOIN job_to_input_dataset AS job_to_input_dataset_1 ON job_to_input_dataset_1.job_id = job.id JOIN history_dataset_association AS history_dataset_association_1 ON job_to_input_dataset_1.dataset_id = history_dataset_association_1.id JOIN history_dataset_association AS history_dataset_association_2 ON history_dataset_association_2.dataset_id = history_dataset_association_1.dataset_id LEFT OUTER JOIN history_dataset_association_history AS history_dataset_association_history_1 ON history_dataset_association_history_1.history_dataset_association_id = history_dataset_association_1.id AND history_dataset_association_history_1.extension = history_dataset_association_2.extension AND history_dataset_association_history_1.metadata = history_dataset_association_2.metadata AND history_dataset_association_history_1.version = job_to_input_dataset_1.dataset_version AND history_dataset_association_history_1.name = history_dataset_association_2.name JOIN job_to_input_dataset AS job_to_input_dataset_2 ON job_to_input_dataset_2.job_id = job.id JOIN history_dataset_association AS history_dataset_association_3 ON job_to_input_dataset_2.dataset_id = history_dataset_association_3.id JOIN history_dataset_association AS history_dataset_association_4 ON history_dataset_association_4.dataset_id = history_dataset_association_3.dataset_id LEFT OUTER JOIN history_dataset_association_history AS history_dataset_association_history_2 ON history_dataset_association_history_2.history_dataset_association_id = history_dataset_association_3.id AND history_dataset_association_history_2.extension = history_dataset_association_4.extension AND history_dataset_association_history_2.metadata = history_dataset_association_4.metadata AND history_dataset_association_history_2.version = job_to_input_dataset_2.dataset_version AND history_dataset_association_history_2.name = history_dataset_association_4.name JOIN job_to_input_dataset AS job_to_input_dataset_3 ON job_to_input_dataset_3.job_id = job.id JOIN history_dataset_association AS history_dataset_association_5 ON job_to_input_dataset_3.dataset_id = history_dataset_association_5.id JOIN history_dataset_association AS history_dataset_association_6 ON history_dataset_association_6.dataset_id = history_dataset_association_5.dataset_id LEFT OUTER JOIN history_dataset_association_history AS history_dataset_association_history_3 ON history_dataset_association_history_3.history_dataset_association_id = history_dataset_association_5.id AND history_dataset_association_history_3.extension = history_dataset_association_6.extension AND history_dataset_association_history_3.metadata = history_dataset_association_6.metadata AND history_dataset_association_history_3.version = job_to_input_dataset_3.dataset_version AND history_dataset_association_history_3.name = history_dataset_association_6.name JOIN job_to_input_dataset AS job_to_input_dataset_4 ON job_to_input_dataset_4.job_id = job.id JOIN history_dataset_association AS history_dataset_association_7 ON job_to_input_dataset_4.dataset_id = history_dataset_association_7.id JOIN history_dataset_association AS history_dataset_association_8 ON history_dataset_association_8.dataset_id = history_dataset_association_7.dataset_id LEFT OUTER JOIN history_dataset_association_history AS history_dataset_association_history_4 ON history_dataset_association_history_4.history_dataset_association_id = history_dataset_association_7.id AND history_dataset_association_history_4.extension = history_dataset_association_8.extension AND history_dataset_association_history_4.metadata = history_dataset_association_8.metadata AND history_dataset_association_history_4.version = job_to_input_dataset_4.dataset_version AND history_dataset_association_history_4.name = history_dataset_association_8.name
WHERE job_to_input_dataset_1.name = %(name_1)s AND history_dataset_association_2.id = %(id_1)s AND ((job_to_input_dataset_1.dataset_version IN (%(dataset_version_1)s, history_dataset_association_1.version) OR history_dataset_association_1.update_time < job.create_time) AND history_dataset_association_1.extension = history_dataset_association_2.extension AND history_dataset_association_1.name = history_dataset_association_2.name OR history_dataset_association_history_1.history_dataset_association_id IS NOT NULL) AND (history_dataset_association_1.deleted = false OR history_dataset_association_2.deleted = false) AND history_dataset_association_2.state IS NULL AND job_to_input_dataset_2.name = %(name_2)s AND history_dataset_association_4.id = %(id_2)s AND ((job_to_input_dataset_2.dataset_version IN (%(dataset_version_2)s, history_dataset_association_3.version) OR history_dataset_association_3.update_time < job.create_time) AND history_dataset_association_3.extension = history_dataset_association_4.extension AND history_dataset_association_3.name = history_dataset_association_4.name OR history_dataset_association_history_2.history_dataset_association_id IS NOT NULL) AND (history_dataset_association_3.deleted = false OR history_dataset_association_4.deleted = false) AND history_dataset_association_4.state IS NULL AND job_to_input_dataset_3.name = %(name_3)s AND history_dataset_association_6.id = %(id_3)s AND ((job_to_input_dataset_3.dataset_version IN (%(dataset_version_3)s, history_dataset_association_5.version) OR history_dataset_association_5.update_time < job.create_time) AND history_dataset_association_5.extension = history_dataset_association_6.extension AND history_dataset_association_5.name = history_dataset_association_6.name OR history_dataset_association_history_3.history_dataset_association_id IS NOT NULL) AND (history_dataset_association_5.deleted = false OR history_dataset_association_6.deleted = false) AND history_dataset_association_6.state IS NULL AND job_to_input_dataset_4.name = %(name_4)s AND history_dataset_association_8.id = %(id_4)s AND ((job_to_input_dataset_4.dataset_version IN (%(dataset_version_4)s, history_dataset_association_7.version) OR history_dataset_association_7.update_time < job.create_time) AND history_dataset_association_7.extension = history_dataset_association_8.extension AND history_dataset_association_7.name = history_dataset_association_8.name OR history_dataset_association_history_4.history_dataset_association_id IS NOT NULL) AND (history_dataset_association_7.deleted = false OR history_dataset_association_8.deleted = false) AND history_dataset_association_8.state IS NULL GROUP BY job.id, job_to_input_dataset_1.dataset_id, job_to_input_dataset_2.dataset_id, job_to_input_dataset_3.dataset_id, job_to_input_dataset_4.dataset_id),
unordered_results AS MATERIALIZED
(SELECT filtered_jobs_subquery.job_id AS job_id, filtered_jobs_subquery."assemblies_0|reference_genome|genome_0" AS "assemblies_0|reference_genome|genome_0", filtered_jobs_subquery."assemblies_0|track_groups_0|data_tracks_0|data_format|use_1" AS "assemblies_0|track_groups_0|data_tracks_0|data_format|use_1", filtered_jobs_subquery."assemblies_0|track_groups_0|data_tracks_0|data_format|paf_2" AS "assemblies_0|track_groups_0|data_tracks_0|data_format|paf_2", filtered_jobs_subquery."assemblies_0|track_groups_0|data_tracks_0|data_format|paf_3" AS "assemblies_0|track_groups_0|data_tracks_0|data_format|paf_3"
FROM (SELECT job_ids_cte.job_id AS job_id, job_ids_cte."assemblies_0|reference_genome|genome_0" AS "assemblies_0|reference_genome|genome_0", job_ids_cte."assemblies_0|track_groups_0|d...
(13 additional frame(s) were not displayed)
...
File "galaxy/workflow/run.py", line 366, in _invoke_step
incomplete_or_none = invocation_step.workflow_step.module.execute(
File "galaxy/workflow/modules.py", line 2542, in execute
completed_jobs: dict[int, Optional[Job]] = tool.completed_jobs(
File "galaxy/tools/__init__.py", line 2299, in completed_jobs
completed_jobs[i] = self.job_search.by_tool_input(
File "galaxy/managers/jobs.py", line 493, in by_tool_input
return self.__search(
File "galaxy/managers/jobs.py", line 593, in __search
for job in self.sa_session.execute(stmt):
InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block
File "sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "sqlalchemy/engine/default.py", line 952, in do_execute
cursor.execute(statement, parameters)
InternalError: (psycopg2.errors.InFailedSqlTransaction) current transaction is aborted, commands ignored until end of transaction block
[SQL: SELECT workflow.id AS workflow_id, workflow.create_time AS workflow_create_time, workflow.update_time AS workflow_update_time, workflow.stored_workflow_id AS workflow_stored_workflow_id, workflow.parent_workflow_id AS workflow_parent_workflow_id, workflow.name AS workflow_name, workflow.has_cycles AS workflow_has_cycles, workflow.has_errors AS workflow_has_errors, workflow.reports_config AS workflow_reports_config, workflow.creator_metadata AS workflow_creator_metadata, workflow.license AS workflow_license, workflow.source_metadata AS workflow_source_metadata, workflow.readme AS workflow_readme, workflow.logo_url AS workflow_logo_url, workflow.help AS workflow_help, workflow.uuid AS workflow_uuid, workflow.doi AS workflow_doi, workflow_step_1.id AS workflow_step_1_id, workflow_step_1.create_time AS workflow_step_1_create_time, workflow_step_1.update_time AS workflow_step_1_update_time, workflow_step_1.workflow_id AS workflow_step_1_workflow_id, workflow_step_1.subworkflow_id AS workflow_step_1_subworkflow_id, workflow_step_1.dynamic_tool_id AS workflow_step_1_dynamic_tool_id, workflow_step_1.type AS workflow_step_1_type, workflow_step_1.tool_id AS workflow_step_1_tool_id, workflow_step_1.tool_version AS workflow_step_1_tool_version, workflow_step_1.tool_inputs AS workflow_step_1_tool_inputs, workflow_step_1.tool_errors AS workflow_step_1_tool_errors, workflow_step_1.position AS workflow_step_1_position, workflow_step_1.config AS workflow_step_1_config, workflow_step_1.order_index AS workflow_step_1_order_index, workflow_step_1.when_expression AS workflow_step_1_when_expression, workflow_step_1.uuid AS workflow_step_1_uuid, workflow_step_1.label AS workflow_step_1_label, workflow_step_1.parent_comment_id AS workflow_step_1_parent_comment_id, workflow_comment_1.id AS workflow_comment_1_id, workflow_comment_1.order_index AS workflow_comment_1_order_index, workflow_comment_1.workflow_id AS workflow_comment_1_workflow_id, workflow_comment_1.position AS workflow_comment_1_position, workflow_comment_1.size AS workflow_comment_1_size, workflow_comment_1.type AS workflow_comment_1_type, workflow_comment_1.color AS workflow_comment_1_color, workflow_comment_1.data AS workflow_comment_1_data, workflow_comment_1.parent_comment_id AS workflow_comment_1_parent_comment_id
FROM workflow LEFT OUTER JOIN workflow_step AS workflow_step_1 ON workflow.id = workflow_step_1.workflow_id LEFT OUTER JOIN workflow_comment AS workflow_comment_1 ON workflow.id = workflow_comment_1.workflow_id
WHERE workflow.id = %(pk_1)s ORDER BY workflow_step_1.order_index ASC]
[parameters: {'pk_1': 697667}]
(Background on this error at: https://sqlalche.me/e/20/2j85)
(18 additional frame(s) were not displayed)
...
File "galaxy/workflow/run.py", line 100, in __invoke
outputs = invoker.invoke()
File "galaxy/workflow/run.py", line 284, in invoke
self.workflow_invocation.workflow.log_str(),
Failed to execute scheduled workflow.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
Type
Projects
Status
In Progress