Skip to content

fix: sort executions by scheduledat time #7095

fix: sort executions by scheduledat time

fix: sort executions by scheduledat time #7095

Triggered via pull request August 22, 2025 11:05
Status Failure
Total duration 3m 21s
Artifacts 2

test.yaml

on: pull_request
Fit to window
Zoom out
Zoom in

Annotations

7 errors
Unit Tests: pkg/database/postgres/sql_test.go#L346
sql_test.go:346: Error Trace: github.com/kubeshop/testkube/pkg/database/postgres/sqlc/executions.sql_test.go:346 Error: Received unexpected error: there is a remaining expectation which was not matched: ExpectedQuery => expecting call to Query() or to QueryRow(): - matches sql: 'SELECT e\.id, e\.group_id, e\.runner_id, e\.runner_target, e\.runner_original_target, e\.name, e\.namespace, e\.number, e\.scheduled_at, e\.assigned_at, e\.status_at, e\.test_workflow_execution_name, e\.disable_webhooks, e\.tags, e\.running_context, e\.config_params, e\.created_at, e\.updated_at, r\.status, r\.predicted_status, r\.queued_at, r\.started_at, r\.finished_at, r\.duration, r\.total_duration, r\.duration_ms, r\.paused_ms, r\.total_duration_ms, r\.pauses, r\.initialization, r\.steps, w\.name as workflow_name, w\.namespace as workflow_namespace, w\.description as workflow_description, w\.labels as workflow_labels, w\.annotations as workflow_annotations, w\.created as workflow_created, w\.updated as workflow_updated, w\.spec as workflow_spec, w\.read_only as workflow_read_only, w\.status as workflow_status, rw\.name as resolved_workflow_name, rw\.namespace as resolved_workflow_namespace, rw\.description as resolved_workflow_description, rw\.labels as resolved_workflow_labels, rw\.annotations as resolved_workflow_annotations, rw\.created as resolved_workflow_created, rw\.updated as resolved_workflow_updated, rw\.spec as resolved_workflow_spec, rw\.read_only as resolved_workflow_read_only, rw\.status as resolved_workflow_status, COALESCE\( \(SELECT json_agg\( json_build_object\( 'id', s\.id, 'ref', s\.ref, 'name', s\.name, 'category', s\.category, 'optional', s\.optional, 'negative', s\.negative, 'parent_id', s\.parent_id \) ORDER BY s\.id \) FROM test_workflow_signatures s WHERE s\.execution_id = e\.id\), '\[\]'::json \)::json as signatures_json, COALESCE\( \(SELECT json_agg\( json_build_object\( 'id', o\.id, 'ref', o\.ref, 'name', o\.name, 'value', o\.value \) ORDER BY o\.id \) FROM test_workflow_outputs o WHERE o\.execution_id = e\.id\), '\[\]'::json \)::json as outputs_json, COALESCE\( \(SELECT json_agg\( json_build_object\( 'id', rep\.id, 'ref', rep\.ref, 'kind', rep\.kind, 'file', rep\.file, 'summary', rep\.summary \) ORDER BY rep\.id \) FROM test_workflow_reports rep WHERE rep\.execution_id = e\.id\), '\[\]'::json \)::json as reports_json, ra\.global as resource_aggregations_global,
Unit Tests: pkg/database/postgres/sql_test.go#L345
sql_test.go:345: Error Trace: github.com/kubeshop/testkube/pkg/database/postgres/sqlc/executions.sql_test.go:345 Error: Not equal: expected: "test-execution" actual : "" Diff: --- Expected +++ Actual @@ -1 +1 @@ -test-execution + Test: TestSQLCTestWorkflowExecutionQueries_GetLatestTestWorkflowExecutionByTestWorkflow
Unit Tests: pkg/database/postgres/sql_test.go#L344
sql_test.go:344: Error Trace: github.com/kubeshop/testkube/pkg/database/postgres/sqlc/executions.sql_test.go:344 Error: Not equal: expected: "test-id" actual : "" Diff: --- Expected +++ Actual @@ -1 +1 @@ -test-id + Test: TestSQLCTestWorkflowExecutionQueries_GetLatestTestWorkflowExecutionByTestWorkflow
Unit Tests: pkg/database/postgres/sql_test.go#L343
sql_test.go:343: Error Trace: github.com/kubeshop/testkube/pkg/database/postgres/sqlc/executions.sql_test.go:343 Error: Received unexpected error: could not match actual sql: "-- name: GetLatestTestWorkflowExecutionByTestWorkflow :one SELECT e.id, e.group_id, e.runner_id, e.runner_target, e.runner_original_target, e.name, e.namespace, e.number, e.scheduled_at, e.assigned_at, e.status_at, e.test_workflow_execution_name, e.disable_webhooks, e.tags, e.running_context, e.config_params, e.created_at, e.updated_at, r.status, r.predicted_status, r.queued_at, r.started_at, r.finished_at, r.duration, r.total_duration, r.duration_ms, r.paused_ms, r.total_duration_ms, r.pauses, r.initialization, r.steps, w.name as workflow_name, w.namespace as workflow_namespace, w.description as workflow_description, w.labels as workflow_labels, w.annotations as workflow_annotations, w.created as workflow_created, w.updated as workflow_updated, w.spec as workflow_spec, w.read_only as workflow_read_only, w.status as workflow_status, rw.name as resolved_workflow_name, rw.namespace as resolved_workflow_namespace, rw.description as resolved_workflow_description, rw.labels as resolved_workflow_labels, rw.annotations as resolved_workflow_annotations, rw.created as resolved_workflow_created, rw.updated as resolved_workflow_updated, rw.spec as resolved_workflow_spec, rw.read_only as resolved_workflow_read_only, rw.status as resolved_workflow_status, COALESCE( (SELECT json_agg( json_build_object( 'id', s.id, 'ref', s.ref, 'name', s.name, 'category', s.category, 'optional', s.optional, 'negative', s.negative, 'parent_id', s.parent_id ) ORDER BY s.id ) FROM test_workflow_signatures s WHERE s.execution_id = e.id), '[]'::json )::json as signatures_json, COALESCE( (SELECT json_agg( json_build_object( 'id', o.id, 'ref', o.ref, 'name', o.name, 'value', o.value ) ORDER BY o.id ) FROM test_workflow_outputs o WHERE o.execution_id = e.id), '[]'::json )::json as outputs_json, COALESCE( (SELECT json_agg( json_build_object( 'id', rep.id, 'ref', rep.ref, 'kind', rep.kind, 'file', rep.file, 'summary', rep.summary ) ORDER BY rep.id ) FROM test_workflow_reports rep WHERE rep.execution_id = e.id), '[]'::json )::json as reports_json, ra.global as resource_aggregations_global, ra.step as resource_aggregations_step FROM test_workflow_executions e LEFT JOIN test_workflow_results r ON e.id = r.execution_id LEFT JOIN test_workflows w ON e.id = w.execution_id AND w.workflow_type = 'workflow' LEFT JOIN test_workflows rw ON e.id = rw.execution_id AND rw.workflow_type = 'resolved_workflow' LEFT JOIN test_workflow_resource_aggregations ra ON e.id = ra.execution_id WHERE w.name = $1::text ORDER BY CASE WHEN $2::boolean = true AND $3::boolean = false THEN e.number WHEN $3::boolean = true AND $2::boolean = false THEN EXTRACT(EPOCH FROM e.status_at)::integer ELSE EXTRACT(EPOCH FROM e.scheduled_at)::integer END DESC LIMIT 1" with expected regexp "SELECT e\.id, e\.group_id, e\.runner_id, e\.runner_target, e\.runner_original_target, e\.name, e\.namespace, e\.number, e\.scheduled_at, e\.assigned_at, e\.status_at, e\.test_workflow_execution_name, e\.disable_webhooks, e\.tags, e\.running_context, e\.config_params, e\.created_at, e\.updated_at, r\.status, r\.predicted_status, r\.queued_at, r\.started_at, r\.finished_at, r\.duration, r\.total_duration, r\.duration_ms, r\.paused_ms, r\.total_duration_ms, r\.pauses, r\.initialization, r\.steps, w\.name as workflow_name, w\.namespace as workflow_namespace, w\.description as workflow_description, w\.labels as workflow_labels, w\.annotations as workflow_annotations, w\.created as workflow_created, w\.updated as workflow_updated, w\.spec as workflow_spec, w\.read_only as workflow_read_only, w\.status as workflow_status, rw\.name as resolved_workflow_name, rw\.namespace as resolved_workflow_namespace, rw\.description as resolved_workflow_description, rw\.labels as resolved_workflow_labels, rw\.annotations as resolved_workflow_annotations, rw\.created as resolved_workflow_created, rw\.updated as resolved_work
Unit Tests
Process completed with exit code 2.
Integration Tests: test/integration/components/init/init_test.go#L70
init_test.go:70: Error Trace: github.com/kubeshop/testkube/test/integration/components/init/init_test.go:70 Error: Not equal: expected: 0 actual : 137 Test: TestInitProcessCore_Integration/ExecuteCommand
Integration Tests
Process completed with exit code 2.

Artifacts

Produced during runtime
Name Size Digest
integration-test-coverage Expired
1.28 MB
sha256:c2b497be121c99b0088243509bc8a18465678d79029be2272bc6e41da05a49ba
unit-test-coverage Expired
1.72 MB
sha256:ad37c31b92cc905ddf87f2f9dfe4be786a8bd7e6a3c52a051c07a9ed2d95ad66