Created
March 21, 2017 23:26
-
-
Save lefthand/6014f0bd108281c4318f21efedefe6b7 to your computer and use it in GitHub Desktop.
Shell script that will remove old Rundeck executions
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# for rundeck with mysql db | |
# keep last X executions for each job | |
KEEP=300 | |
cd /var/lib/rundeck/logs/rundeck | |
JOBS=`find . -maxdepth 3 -path "*/job/*" -type d` | |
for j in $JOBS ; do | |
echo "Processing job $j" | |
ids=`find $j -iname "*.rdlog" | sed -e "s/.*\/\([0-9]*\)\.rdlog/\1/" | sort -n -r` | |
echo $ids | |
declare -a JOBIDS=($ids) | |
if [ ${#JOBIDS[@]} -gt $KEEP ]; then | |
for job in ${JOBIDS[@]:$KEEP};do | |
echo " * Deleting job: $job" | |
echo " rm -rf $j/logs/$job.*" | |
rm -rf $j/logs/$job.* | |
wfid=$(mysql rundeckdb -e "SELECT workflow_id FROM execution WHERE id = $job\G" | awk '/workflow_id/{print $2}') | |
wfsid=$(mysql rundeckdb -e "SELECT group_concat(workflow_step_id) wfsid FROM workflow_workflow_step WHERE workflow_commands_id = $wfid\G" | awk '/wfsid/{print $2}') | |
echo " mysql rundeckdb -e 'DELETE FROM log_file_storage_request WHERE execution_id=$job'" | |
mysql rundeckdb -e "DELETE FROM log_file_storage_request WHERE execution_id=$job" | |
echo " mysql rundeckdb -e 'DELETE FROM execution WHERE id=$job'" | |
mysql rundeckdb -e "DELETE FROM execution WHERE id=$job" | |
echo " mysql rundeckdb -e 'DELETE FROM base_report WHERE jc_exec_id=${job}'" | |
mysql rundeckdb -e "DELETE FROM base_report WHERE jc_exec_id='${job}'" | |
echo " mysql rundeckdb -e 'DELETE FROM workflow WHERE id = $wfid'" | |
mysql rundeckdb -e "DELETE FROM workflow WHERE id = $wfid" | |
echo " mysql rundeckdb -e 'DELETE FROM workflow_workflow_step WHERE workflow_commands_id = $wfid'" | |
mysql rundeckdb -e "DELETE FROM workflow_workflow_step WHERE workflow_commands_id = $wfid" | |
echo " mysql rundeckdb -e 'DELETE FROM workflow_step WHERE id IN ($wfsid)'" | |
mysql rundeckdb -e "DELETE FROM workflow_step WHERE id IN ($wfsid)" | |
done | |
fi | |
done |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hello,
Thanks for the script it really helps me, when i am using the same script it shows deleting jobs but it is keep on executing same steps it's not going to further.
echo " * Deleting job: $job"
rm -rf $j/logs/$job.*
Deleting job: 3104429
14:48:45 | | | rm -rf ./XYZ/job/81476133-1da6-40fc-7d3c-abf2caedd1f9/logs/3104429.*
Later it is failing with below timeout error after 2hr
15:29:20 | | | Result: 2147483647
15:29:21 | | | Failed: NonZeroResultCode: Result code was 2147483647
| ANY04210451 [console] |
15:29:21 | | | Cancellation while running step [1]
could you please help me what causes this issue. is this caused due to any permission issue ??
Thanks In Advance.
Regards,
Krishna