You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
After refreshing the page when the task finished running, the output seems to get printed in the wrong order.
Different lines get printed in the wrong tasks or after the end of the playbook. The problem seems to be that the lines are ordered by time and since the time is the same for all the lines they get mixed.
In the file /db/sql/task.go this query: "select task_id, task, time, output from task__output where task_id=? order by time asc"
should be written as: "select task_id, task, time, output from task__output where task_id=? order by id asc"
since the database saves the id of each line.
Impact
Web-Frontend (what users interact with)
Installation method
Package
Database
MySQL
Browser
Chrome, Microsoft Edge
Semaphore Version
2.10.11-d31ebd3-1719394739
Ansible Version
No response
Logs & errors
No response
Manual installation - system information
No response
Configuration
No response
Additional information
No response
The text was updated successfully, but these errors were encountered:
Issue
After refreshing the page when the task finished running, the output seems to get printed in the wrong order.
![image](https://private-user-images.githubusercontent.com/95567298/349004488-ed795b40-ea4f-4044-a269-ddb16b3c13c2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjU1OTk3NjEsIm5iZiI6MTcyNTU5OTQ2MSwicGF0aCI6Ii85NTU2NzI5OC8zNDkwMDQ0ODgtZWQ3OTViNDAtZWE0Zi00MDQ0LWEyNjktZGRiMTZiM2MxM2MyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA5MDYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwOTA2VDA1MTEwMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTY2MGQ1ZWNhYThlNjhhMzdjZTg3YjM5MGQ4ZjI5YTIwNmU4ZDZkNzIwNTcxYTM2YWI5ODcyNmY5MjUwOGY5MmQmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.U2FskAheplFKHaySRCvGVYmbJXbim1_rt7Pvt9D4yCI)
Different lines get printed in the wrong tasks or after the end of the playbook. The problem seems to be that the lines are ordered by time and since the time is the same for all the lines they get mixed.
In the file /db/sql/task.go this query:
"select task_id, task, time, output from task__output where task_id=? order by time asc"
should be written as:
"select task_id, task, time, output from task__output where task_id=? order by id asc"
since the database saves the id of each line.
Impact
Web-Frontend (what users interact with)
Installation method
Package
Database
MySQL
Browser
Chrome, Microsoft Edge
Semaphore Version
2.10.11-d31ebd3-1719394739
Ansible Version
No response
Logs & errors
No response
Manual installation - system information
No response
Configuration
No response
Additional information
No response
The text was updated successfully, but these errors were encountered: