Shell script that will remove old Rundeck executions

rundeck-execution-trip

#!/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

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