ShredderControl - Revision history

Phanousk at 14:40, 6 February 2019

2019-02-06T14:40:55Z

← Older revision		Revision as of 10:40, 6 February 2019
Line 7:		Line 7:
	Ideally, both [[CountTickets]] and [[ShredderControl]] will be located in /path/to/rt/sbin where rtx-shredder is located.		Ideally, both [[CountTickets]] and [[ShredderControl]] will be located in /path/to/rt/sbin where rtx-shredder is located.

	<source lang="bash">#!/bin/bash		<source lang="bash"><pre>
			#!/bin/bash

	Statuses=( new open stalled resolved rejected deleted )		Statuses=( new open stalled resolved rejected deleted )
Line 19:		Line 20:
	echo -e "$count\t`date -d '7 hours ago' '+%D %T'`"		echo -e "$count\t`date -d '7 hours ago' '+%D %T'`"
	done		done
			</pre></source>
			<source lang="bash"><pre>
	[root@rt02 sbin]# cat shredder.sh		[root@rt02 sbin]# cat shredder.sh
	#!/bin/bash		#!/bin/bash
Line 24:		Line 27:
	usage()		usage()
	{		{
	cat ~~<<~~ EOF		cat << EOF

	Usage: $0 ~~<~~status~~>~~ [num] [wait] [until]		Usage: $0 <status> [num] [wait] [until]
	Options:		Options:
	status - Ticket status name. Required.		status - Ticket status name. Required.
Line 90:		Line 93:

	echo -n "Finished at: " ; date +'%D %T %Z'		echo -n "Finished at: " ; date +'%D %T %Z'
	</source>		</pre></source>



	I made some modifications, for 3.8.9 and Ubuntu Server 10.04 - Luciano		I made some modifications, for 3.8.9 and Ubuntu Server 10.04 - Luciano
	<source lang="bash">		<source lang="bash"><pre>
	#!/bin/bash		#!/bin/bash

Line 163:		Line 166:
	echo -n "Finished at: " ; date +'%D %T %Z'		echo -n "Finished at: " ; date +'%D %T %Z'

	</source>		</pre></source>
	[[Category:Shredder]]		[[Category:Shredder]]
	[[Category:Contribution]]		[[Category:Contribution]]

Phanousk at 10:38, 22 January 2018

2018-01-22T10:38:38Z

← Older revision		Revision as of 06:38, 22 January 2018
Line 73:		Line 73:
	fi		fi

	numticketleft="\./count-tickets.sh $status \| awk '{print $2}'\"		numticketleft="\./count-tickets.sh $status \| awk '{print $2}'"
	if [ $numticketleft -le $untl ] ; then		if [ $numticketleft -le $untl ] ; then
	echo "The number of tickets ($numticketleft) is equal or less than the until limit set ($untl). No work to do."		echo "The number of tickets ($numticketleft) is equal or less than the until limit set ($untl). No work to do."

Phanousk at 12:08, 19 January 2018

2018-01-19T12:08:40Z

← Older revision		Revision as of 08:08, 19 January 2018
Line 37:		Line 37:
	This will run until there are no tickets left, shredding 5 tickets at a time, with a second pause between shreds.		This will run until there are no tickets left, shredding 5 tickets at a time, with a second pause between shreds.
	$0 deleted 10 1 5		$0 deleted 10 1 5
	This will run until there's 5 or less tickets, shredding 10 at a time, with a second pause between shreds.		This will run until there is 5 or less tickets, shredding 10 at a time, with a second pause between shreds.

	EOF		EOF
Line 73:		Line 73:
	fi		fi

	numticketleft="`./count-tickets.sh $status \| awk '{print $2}'`"		numticketleft="\./count-tickets.sh $status \| awk '{print $2}'\"
	if [ $numticketleft -le $untl ] ; then		if [ $numticketleft -le $untl ] ; then
	echo "The number of tickets ($numticketleft) is equal or less than the until limit set ($untl). No work to do."		echo "The number of tickets ($numticketleft) is equal or less than the until limit set ($untl). No work to do."

Phanousk at 12:04, 19 January 2018

2018-01-19T12:04:33Z

← Older revision		Revision as of 08:04, 19 January 2018
Line 7:		Line 7:
	Ideally, both [[CountTickets]] and [[ShredderControl]] will be located in /path/to/rt/sbin where rtx-shredder is located.		Ideally, both [[CountTickets]] and [[ShredderControl]] will be located in /path/to/rt/sbin where rtx-shredder is located.

	<~~nowiki~~>#!/bin/bash		<source lang="bash">#!/bin/bash

	Statuses=( new open stalled resolved rejected deleted )		Statuses=( new open stalled resolved rejected deleted )
Line 90:		Line 90:

	echo -n "Finished at: " ; date +'%D %T %Z'		echo -n "Finished at: " ; date +'%D %T %Z'
	</~~nowiki~~>		</source>



	I made some modifications, for 3.8.9 and Ubuntu Server 10.04 - Luciano		I made some modifications, for 3.8.9 and Ubuntu Server 10.04 - Luciano
	<~~nowiki~~>		<source lang="bash">
	#!/bin/bash		#!/bin/bash

Line 163:		Line 163:
	echo -n "Finished at: " ; date +'%D %T %Z'		echo -n "Finished at: " ; date +'%D %T %Z'

	</~~nowiki~~>		</source>
	[[Category:Shredder]]		[[Category:Shredder]]
	[[Category:Contribution]]		[[Category:Contribution]]

Admin: 5 revisions imported

2016-04-06T20:37:45Z

5 revisions imported

New page

This BASH script allows one to shred a large number of tickets hopefully without making the machine unresponsive.

It shreds tickets of a specified status, a specified number at a time, with a specified pause between shreds, until a specified number of tickets are left. If that sentence is confusing, check the usage text in the script.

This script requires the [[CountTickets]] script which should be named count-tickets.sh.

Ideally, both [[CountTickets]] and [[ShredderControl]] will be located in /path/to/rt/sbin where rtx-shredder is located.

<nowiki>#!/bin/bash

Statuses=( new open stalled resolved rejected deleted )
if [ $1 ] ; then Statuses=( $* ) ; fi

for Status in ${Statuses[@]} ; do
echo -en "$Status:\t"
if [ ${#Status} -lt 7 ] ; then echo -en "\t" ; fi
count=`echo "select count(*) from Tickets where Tickets.Status=\"$Status\";" | mysql rt3`
count=`echo $count | awk '{print $2}'`
echo -e "$count\t`date -d '7 hours ago' '+%D %T'`"
done
[root@rt02 sbin]# cat shredder.sh
#!/bin/bash

usage()
{
cat << EOF

Usage: $0 <status> [num] [wait] [until]
Options:
status - Ticket status name. Required.
num - Number of tickets to shred at a time. Default=5
wait - Number of seconds to wait between shred sets. Default=1
until - How long to continue running until X tickets are remaining. Default=n/a

Examples:
$0 rejected
This will run until there are no tickets left, shredding 5 tickets at a time, with a second pause between shreds.
$0 deleted 10 1 5
This will run until there's 5 or less tickets, shredding 10 at a time, with a second pause between shreds.

EOF
}

Statuses=( new open stalled resolved rejected deleted )
if ! [ $1 ] ; then usage ; exit
else
if ! [[ "${Statuses[*]}" =~ "$1" ]] ; then
echo "Status $1 not recognized."
echo "Statuses allowed: ${Statuses[*]}"
exit
fi
status="$1"
fi

if [ $2 ] ; then
num=$2
if [ $num -lt 1 ] ; then echo "Use a value for num above 0 [zero]." ; exit ; fi
if [ $num -gt 100 ] ; then echo "Use a value for num below 101." ; exit ; fi
else num=5
fi

if [ $3 ] ; then
wait=$3
if [ $wait -lt 0 ] ; then echo "Use a positive, or zero, value for wait." ; exit ; fi
if [ $wait -gt 100 ] ; then echo "Use a value for wait below 101." ; exit ; fi
else wait=1
fi

if [ $4 ] ; then
untl=$4
if [ $wait -lt 0 ] ; then echo "Use a positive, or zero, value for until." ; exit ; fi
else untl=0
fi

numticketleft="`./count-tickets.sh $status | awk '{print $2}'`"
if [ $numticketleft -le $untl ] ; then
echo "The number of tickets ($numticketleft) is equal or less than the until limit set ($untl). No work to do."
exit
fi

shredcmd="./rtx-shredder --force --plugin 'Tickets=status,$status;limit,$num'"

echo -n "Started at: " ; date +'%D %T %Z'

while [ $numticketleft -gt $untl ] ; do
eval $shredcmd > /dev/null
sleep $wait
numticketleft="`./count-tickets.sh $status | awk '{print $2}'`"
done

echo -n "Finished at: " ; date +'%D %T %Z'
</nowiki>

I made some modifications, for 3.8.9 and Ubuntu Server 10.04 - Luciano
<nowiki>
#!/bin/bash

usage () {

echo "Usage: $0 <status> [num] [wait] [until]"
echo "Options:"
echo " status - Ticket status name. Required."
echo " num - Number of tickets to shred at a time. Default=5"
echo " wait - Number of seconds to wait between shred sets. Default=1"
echo " until - How long to continue running until X tickets are remaining. Default=n/a"

echo " Examples:"
echo " $0 Rejected"
echo " This will run until there are no tickets left, shredding 5 tickets at a time, with a second pause between shreds."
echo " $0 Deleted 10 1 5"
echo " This will run until theres 5 or less tickets, shredding 10 at a time, with a second pause between shreds."
exit 1
}

Statuses=( New Open Stalled Resolved Rejected Deleted )
if ! [ $1 ] ; then usage ; exit
else
if ! [[ "${Statuses[*]}" =~ "$1" ]] ; then
echo "Status $1 not recognized."
echo "Statuses allowed: ${Statuses[*]}"
exit
fi
status="$1"
fi

if [ $2 ] ; then
num=$2
if [ $num -lt 1 ] ; then echo "Use a value for num above 0 [zero]." ; exit ; fi
if [ $num -gt 100 ] ; then echo "Use a value for num below 101." ; exit ; fi
else num=5
fi

if [ $3 ] ; then
wait=$3
if [ $wait -lt 0 ] ; then echo "Use a positive, or zero, value for wait." ; exit ; fi
if [ $wait -gt 100 ] ; then echo "Use a value for wait below 101." ; exit ; fi
else wait=1
fi

if [ $4 ] ; then
untl=$4
if [ $wait -lt 0 ] ; then echo "Use a positive, or zero, value for until." ; exit ; fi
else untl=0
fi

numticketleft="`./count-tickets.sh $status | awk '{print $2}'`"
if [ $numticketleft -le $untl ] ; then
echo "The number of tickets ($numticketleft) is equal or less than the until limit set ($untl). No work to do."
exit
fi

echo -n "Started at: " ; date +'%D %T %Z'

while [ $numticketleft -gt $untl ] ; do
./rt-shredder --force --plugin "Tickets=query,Status = '$status' AND LastUpdated < '30 days ago';limit,$num"
sleep $wait
numticketleft="`./count-tickets.sh $status | awk '{print $2}'`"
done

echo -n "Finished at: " ; date +'%D %T %Z'

</nowiki>
[[Category:Shredder]]
[[Category:Contribution]]

143.54.235.94 at 16:11, 28 July 2011

2011-07-28T16:11:42Z

Show changes

143.54.235.94 at 16:06, 28 July 2011

2011-07-28T16:06:15Z

New page

This BASH script allows one to shred a large number of tickets hopefully without making the machine unresponsive.

It shreds tickets of a specified status, a specified number at a time, with a specified pause between shreds, until a specified number of tickets are left. If that sentence is confusing, check the usage text in the script.

This script requires the [[CountTickets]] script which should be named count-tickets.sh.

Ideally, both [[CountTickets]] and [[ShredderControl]] will be located in /path/to/rt/sbin where rtx-shredder is located.

<nowiki>#!/bin/bash

Statuses=( new open stalled resolved rejected deleted )
if [ $1 ] ; then Statuses=( $* ) ; fi

for Status in ${Statuses[@]} ; do
echo -en "$Status:\t"
if [ ${#Status} -lt 7 ] ; then echo -en "\t" ; fi
count=`echo "select count(*) from Tickets where Tickets.Status=\"$Status\";" | mysql rt3`
count=`echo $count | awk '{print $2}'`
echo -e "$count\t`date -d '7 hours ago' '+%D %T'`"
done
[root@rt02 sbin]# cat shredder.sh
#!/bin/bash

usage()
{
cat << EOF

Usage: $0 <status> [num] [wait] [until]
Options:
status - Ticket status name. Required.
num - Number of tickets to shred at a time. Default=5
wait - Number of seconds to wait between shred sets. Default=1
until - How long to continue running until X tickets are remaining. Default=n/a

Examples:
$0 rejected
This will run until there are no tickets left, shredding 5 tickets at a time, with a second pause between shreds.
$0 deleted 10 1 5
This will run until there's 5 or less tickets, shredding 10 at a time, with a second pause between shreds.

EOF
}

Statuses=( new open stalled resolved rejected deleted )
if ! [ $1 ] ; then usage ; exit
else
if ! [[ "${Statuses[*]}" =~ "$1" ]] ; then
echo "Status $1 not recognized."
echo "Statuses allowed: ${Statuses[*]}"
exit
fi
status="$1"
fi

if [ $2 ] ; then
num=$2
if [ $num -lt 1 ] ; then echo "Use a value for num above 0 [zero]." ; exit ; fi
if [ $num -gt 100 ] ; then echo "Use a value for num below 101." ; exit ; fi
else num=5
fi

if [ $3 ] ; then
wait=$3
if [ $wait -lt 0 ] ; then echo "Use a positive, or zero, value for wait." ; exit ; fi
if [ $wait -gt 100 ] ; then echo "Use a value for wait below 101." ; exit ; fi
else wait=1
fi

if [ $4 ] ; then
untl=$4
if [ $wait -lt 0 ] ; then echo "Use a positive, or zero, value for until." ; exit ; fi
else untl=0
fi

numticketleft="`./count-tickets.sh $status | awk '{print $2}'`"
if [ $numticketleft -le $untl ] ; then
echo "The number of tickets ($numticketleft) is equal or less than the until limit set ($untl). No work to do."
exit
fi

shredcmd="./rtx-shredder --force --plugin 'Tickets=status,$status;limit,$num'"

echo -n "Started at: " ; date +'%D %T %Z'

while [ $numticketleft -gt $untl ] ; do
eval $shredcmd > /dev/null
sleep $wait
numticketleft="`./count-tickets.sh $status | awk '{print $2}'`"
done

echo -n "Finished at: " ; date +'%D %T %Z'
</nowiki>

I made some modifications, for 3.8.9 and Ubuntu Server 10.04 - Luciano

<nowiki>
#!/bin/bash

usage () {

echo "Usage: $0 <status> [num] [wait] [until]"
echo "Options:"
echo " status - Ticket status name. Required."
echo " num - Number of tickets to shred at a time. Default=5"
echo " wait - Number of seconds to wait between shred sets. Default=1"
echo " until - How long to continue running until X tickets are remaining. Default=n/a"

echo " Examples:"
echo " $0 Rejected"
echo " This will run until there are no tickets left, shredding 5 tickets at a time, with a second pause between shreds."
echo " $0 Deleted 10 1 5"
echo " This will run until theres 5 or less tickets, shredding 10 at a time, with a second pause between shreds."
exit 1
}

Statuses=( New Open Stalled Resolved Rejected Deleted )
if ! [ $1 ] ; then usage ; exit
else
if ! [[ "${Statuses[*]}" =~ "$1" ]] ; then
echo "Status $1 not recognized."
echo "Statuses allowed: ${Statuses[*]}"
exit
fi
status="$1"
fi

if [ $2 ] ; then
num=$2
if [ $num -lt 1 ] ; then echo "Use a value for num above 0 [zero]." ; exit ; fi
if [ $num -gt 100 ] ; then echo "Use a value for num below 101." ; exit ; fi
else num=5
fi

if [ $3 ] ; then
wait=$3
if [ $wait -lt 0 ] ; then echo "Use a positive, or zero, value for wait." ; exit ; fi
if [ $wait -gt 100 ] ; then echo "Use a value for wait below 101." ; exit ; fi
else wait=1
fi

if [ $4 ] ; then
untl=$4
if [ $wait -lt 0 ] ; then echo "Use a positive, or zero, value for until." ; exit ; fi
else untl=0
fi

numticketleft="`./count-tickets.sh $status | awk '{print $2}'`"
if [ $numticketleft -le $untl ] ; then
echo "The number of tickets ($numticketleft) is equal or less than the until limit set ($untl). No work to do."
exit
fi

# shredcmd="./rt-shredder --force --plugin 'Tickets=query,Status = $status;limit,$num'"
#shredcmd="sbin/rt-shredder --force --plugin "Tickets=query,Status = '$status' AND LastUpdated < '30 days ago';limit,$num"
#cat "(/usr/local/rt/sbin/rt-shredder --force --plugin "Tickets=query,Status = '$status' AND LastUpdated < '30 days ago';limit,$num")" > shredcmd

echo -n "Started at: " ; date +'%D %T %Z'

while [ $numticketleft -gt $untl ] ; do
./rt-shredder --force --plugin "Tickets=query,Status = '$status' AND LastUpdated < '30 days ago';limit,$num"
# eval $shredcmd > /dev/null
sleep $wait
numticketleft="`./count-tickets.sh $status | awk '{print $2}'`"
done

echo -n "Finished at: " ; date +'%D %T %Z'

</nowiki>