jboss_log=/var/log/jboss-as/old/server.log.gz; if [ ! -z "/var/tmp/jboss_counter.txt" ]; then time1=$(cat /var/tmp/jboss_counter.txt); else exit 0; fi #time=`zgrep -B1 'SQLMXMessages.throwSQLException' $jboss_log | head -n 1 | sed -e 's#,# #g' | awk '{ print $1 }'`; echo "##### $time #####" #echo "$time" > /var/tmp/jboss_counter.txt; echo $time1; if [[ $(sed -n "/$time1/,/$!d/p" /var/log/jboss-as/server.log | zgrep -B1 'SQLMXMessages.throwSQLException' | wc -l) != '0' ]]; then echo '1'; echo "### Started on $(date "+%D-%H:%m:%S")"; #time=`zgrep -B1 'SQLMXMessages.throwSQLException' $jboss_log | head -n 1 | sed -e 's#,# #g' | awk '{ print $1 }'`; #zgrep -B1 'SQLMXMessages.throwSQLException' $jboss_log; sed -n "/$time1/,/$!d/p" /var/log/jboss-as/server.log | zgrep -B1 'SQLMXMessages.throwSQLException' echo "### Ended on $(date "+%D-%H:%m:%S")"; else echo '0'; fi; time=$(zcat /var/log/jboss-as/old/server.log.2020-09-22.gz |tail -n 1|awk '{ print $1 }'|sed -e 's#,# #g'|awk '{ print $1 }'); echo $time > /var/tmp/jboss_counter.txt; ## sed -n "/$time1/,/$!d/p" /var/log/jboss-as/server.log | grep -B1 'SQLMXMessages.throwSQLException' | wc -l X=$(cat /var/tmp/jboss_counter.txt); read_to=$(wc -l /var/log/jboss-as/server.log |awk '{ print $1 }' > /var/tmp/jboss_counter.txt); Y=$read_to; sed -n -e "$X,$Y p" -e "$Y q" /var/log/jboss-as/server.log jboss_log=/var/log/jboss-as/server.log; if [[ $(sed -n -e "$X,$Y p" -e "$Y q" /var/log/jboss-as/server.log | grep -B1 'SQLMXMessages.throwSQLException' |wc -l) != '0' ]]; then echo '1'; echo "### Started on $(date "+%D-%H:%m:%S")"; tail -n 1500 $jboss_log | grep -B1 'SQLMXMessages.throwSQLException'; echo "### Ended on $(date "+%D-%H:%m:%S")"; else echo '0'; fi