grouping log files based on counter

manas_ranjan · October 5, 2012, 4:44am

I have my log file as below

00:18:02 - Nothing normal; Garbage Collection kicked off & running from last 3 min... 
00:19:02 - Nothing normal; Garbage Collection kicked off & running from last 4 min...
00:19:02 - Nothing normal; Garbage Collection kicked off & running from last 4 min...
00:20:02 - Nothing normal; Garbage Collection kicked off & running from last 5 min...
00:20:02 - Nothing normal; Garbage Collection kicked off & running from last 5 min...
00:20:02 - Nothing normal; Garbage Collection kicked off & running from last 5 min...
00:21:01 - Nothing normal; Garbage Collection kicked off & running from last 5 min...
00:21:02 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
00:21:02 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
00:21:02 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
00:22:01 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
00:22:01 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
00:22:02 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
00:22:02 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
00:22:02 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
00:23:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
00:23:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
00:23:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
00:23:02 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
00:23:02 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
00:23:02 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
00:24:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
00:24:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
00:24:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
00:24:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
00:24:02 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
00:24:02 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
00:24:02 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
00:25:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
00:25:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
00:25:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
00:25:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
00:25:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
00:25:02 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
00:25:02 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
00:25:02 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
00:26:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
00:26:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
00:26:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
00:26:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
00:26:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
00:26:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
00:26:02 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
00:26:02 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
00:26:02 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
00:27:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
00:27:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
00:27:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
00:27:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
00:27:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
00:27:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
00:27:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
00:27:02 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:27:02 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:27:02 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:28:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:28:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:28:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:28:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:28:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:28:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:28:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:28:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
00:28:02 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:28:02 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:28:02 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:29:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:29:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:29:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:29:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:29:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:29:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:29:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:29:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:29:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
00:29:02 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:29:02 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:29:02 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
00:30:02 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
00:30:02 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
00:30:02 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:28:01 - Nothing normal; Garbage Collection kicked off & running from last 3 min...
10:29:01 - Nothing normal; Garbage Collection kicked off & running from last 4 min...
10:29:01 - Nothing normal; Garbage Collection kicked off & running from last 4 min...
10:30:01 - Nothing normal; Garbage Collection kicked off & running from last 5 min...
10:30:01 - Nothing normal; Garbage Collection kicked off & running from last 5 min...
10:30:01 - Nothing normal; Garbage Collection kicked off & running from last 5 min...
10:31:01 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
10:31:01 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
10:31:01 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
10:31:01 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
10:32:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
10:32:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
10:32:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
10:32:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
10:32:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
10:33:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
10:33:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
10:33:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
10:33:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
10:33:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
10:33:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
10:34:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
10:34:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
10:34:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
10:34:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
10:34:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
10:34:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
10:34:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
10:35:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
10:35:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
10:35:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
10:35:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
10:35:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
10:35:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
10:35:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
10:35:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
10:36:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
10:36:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
10:36:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
10:36:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
10:36:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
10:36:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
10:36:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
10:36:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
10:36:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
10:37:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
10:37:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
10:37:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
10:37:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
10:37:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
10:37:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
10:37:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
10:37:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
10:37:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
10:37:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:38:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:39:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:40:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:41:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...
17:34:01 - Nothing normal; Garbage Collection kicked off & running from last 3 min...
17:35:01 - Nothing normal; Garbage Collection kicked off & running from last 4 min...
17:35:01 - Nothing normal; Garbage Collection kicked off & running from last 4 min...
17:36:01 - Nothing normal; Garbage Collection kicked off & running from last 5 min...
17:36:01 - Nothing normal; Garbage Collection kicked off & running from last 5 min...
17:36:01 - Nothing normal; Garbage Collection kicked off & running from last 5 min...
17:37:01 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
17:37:01 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
17:37:01 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
17:37:01 - Nothing normal; Garbage Collection kicked off & running from last 6 min...
17:38:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
17:38:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
17:38:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
17:38:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
17:38:01 - Nothing normal; Garbage Collection kicked off & running from last 7 min...
17:39:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
17:39:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
17:39:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
17:39:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
17:39:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
17:39:01 - Nothing normal; Garbage Collection kicked off & running from last 8 min...
17:40:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
17:40:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
17:40:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
17:40:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
17:40:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
17:40:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
17:40:01 - Nothing normal; Garbage Collection kicked off & running from last 9 min...
17:41:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
17:41:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
17:41:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
17:41:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
17:41:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
17:41:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
17:41:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
17:41:01 - Nothing normal; Garbage Collection kicked off & running from last 10 min...
17:42:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
17:42:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
17:42:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
17:42:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
17:42:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
17:42:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
17:42:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
17:42:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
17:42:01 - Nothing normal; Garbage Collection kicked off & running from last 11 min...
17:43:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
17:43:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
17:43:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
17:43:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
17:43:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
17:43:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
17:43:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
17:43:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
17:43:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
17:43:01 - Nothing normal; Garbage Collection kicked off & running from last 12 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:44:01 - Nothing normal; Garbage Collection kicked off & running from last 13 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:45:01 - Nothing normal; Garbage Collection kicked off & running from last 14 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:46:01 - Nothing normal; Garbage Collection kicked off & running from last 15 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...

All I need to display is

first GC started at 00:18:02 and continued for 15mins.
second GC started at 10:28:01 and continue for 17mins.

....
....

grouping of GC is done by keyword "from last 3 min" i.e. counter of i gradually increases by the time from 3 and then after fresh GC ,new counter reset back to 3 again.

for that I did,

 awk '/running from last 3 min/ {print $0, NR}'  /var/tmp/gc.txt
00:18:02 - Nothing normal; Garbage Collection kicked off & running from last 3 min...  1
10:28:01 - Nothing normal; Garbage Collection kicked off & running from last 3 min... 92
17:34:01 - Nothing normal; Garbage Collection kicked off & running from last 3 min... 212

so I have start time, now my question is how can I include finish time(which is normally a line before from the actual file, from 2nd or 3rd grep output line), more specifically for the last line after the grep..it should make sure that there are no line left for inbetweeners and it should find last line in-order to find the conclude time.

so it should print

first GC started at 00:18:02 ( This time I got first line of my grep marked in bold )and continued for 15mins.(this min one which I got it from 91 row number)
second GC started at 10:28:01 ( This time I got first line of my grep marked in bold ) and continue for 17mins.(this min one which I got it from 211 row number )
third GC started at 17:34:01 ( This time I got first line of my grep marked in bold ) and continue for 16mins.(this minwhich I got it from last line)

pamu · October 5, 2012, 4:55am

try this..

awk '{if($0 ~ /running from last 3 min/) {if(s){print s}}else{s=$0","NR}}END{print}' file

Add your extra text to the print...

Or if can just grep GC started
then try..

awk '/GC started/{if(!x[$1]++){print }}' file

RudiC · October 5, 2012, 5:23am

Pls adapt your output text...:

awk 'BEGIN {LASTMIN = 59}
     NR > 1 && $13 < LASTMIN {print ++CNT, ". GC", STTIME, LASTMIN, NR}
     {STTIME = $1; LASTMIN = $13}
     END{print ++CNT, ". GC", STTIME, LASTMIN, NR}
    ' /var/tmp/gc.txt

manas_ranjan · October 5, 2012, 5:49am

hey Pamu,

The first one was exactly what I'm looking for, but the o/p looks like
where starting time is the first line of the grep is wrong, only bold lines are matching but red bold are not....

00:30:02 - Nothing normal; Garbage Collection kicked off & running from last 15 min...,91
10:42:01 - Nothing normal; Garbage Collection kicked off & running from last 17 min...,211
17:47:01 - Nothing normal; Garbage Collection kicked off & running from last 16 min...

I would like my o/p to be

first GC started at 00:18:02 and continued for 15mins
second GC started at 10:28:01 and continue for 17mins
third GC started at 17:34:01 and continue for 16mins

---------- Post updated at 04:49 AM ---------- Previous update was at 04:42 AM ----------

Hey Rudi,

your o/p looks like

1 . GC 00:30:02 15 92
2 . GC 10:42:01 17 212
3 . GC 17:47:01 16 316

but my o/p should looks like

1 . GC 00:18:02 15 92
2 . GC 10:28:01 17 212
3 . GC 17:34:01 16 316

my bold mark time is always from first line and running last min i is always from the last line.

pamu · October 5, 2012, 6:03am

is this what you want..?

awk -v VM="first,second,third" -v GC="GC started at" -v CN="and continued for" -v MN="mins" '{split(VM,P,",")
if($0 ~ /running from last 3 min/) {
if(s){a++;print P[a],GC,k,CN,s,MN;};k=$1;}else{s=$(NF-1)}}
END{a++;print P[a],GC,k,CN,s,MN}' file

RudiC · October 5, 2012, 6:08am

You're right. Try

awk     'NR  > 1 && $13 < LASTMIN {print ++CNT, ". GC ...", STTIME, "...",LASTMIN}
         NR == 1 || $13 < LASTMIN {STTIME = $1}
         { LASTMIN = $13}
         END{print ++CNT, ". GC ...", STTIME, "...", LASTMIN}
        ' /var/tmp/gc.txt

elixir_sinari · October 5, 2012, 6:09am

awk '$13 < lastdur {print ++i " GC started at " start " and continued for " lastdur " mins."
start=$1
recstart=1}
NR==1{start=$1;recstart=1}
{lastdur=$13}
END{if(recstart) print ++i " GC started at " start " and continued for " lastdur " mins."}' file

manas_ranjan · October 5, 2012, 10:32am

thanks all, for amazing help.

May I ask adding little bit enhancement to the existing o/p?
can we print the existing start time-3 instead of the the time.

e.g.

first GC started at 00:18:02 and continued for 15mins
second GC started at 10:28:01 and continue for 17mins
third GC started at 17:34:01 and continue for 16mins

will be now

first GC started at  00:15:02 (00:18:02 - 3min )and continued for 15mins
second GC started at 10:25:01 (10:28:01 - 3min) and continue for 17mins
third GC started at 17:31:01  (17:34:01 - 3min )and continue for 16mins

pamu · October 5, 2012, 10:46am

try this...

mine code looking really ugly now...

awk -v VM="first,second,third" -v GC="GC started at" -v CN="and continued for" -v MN="mins" '{split(VM,P,",")
if($0 ~ /running from last 3 min/) {
if(s){a++;split($1,T,":");print P[a],GC,T[1]":"(T[2]-3)":"T[3],k,CN,s,MN;};k=$1;}else{s=$(NF-1)}}
END{a++;split($1,T,":");print P[a],GC,T[1]":"(T[2]-3)":"T[3],k,CN,s,MN}' file

manas_ranjan · October 5, 2012, 11:09am

You know, pamu it's alright

I have notice two points in your so called ugly code
1
o/p now looks like
first GC started at 10:25:01 00:02:02 and continued for 15 mins
second GC started at 17:31:01 10:28:01 and continued for 17 mins
third GC started at 17:44:01 17:34:01 and continued for 16 mins
extra bold time poping up and no minus of 3 is really happening here.

2
while subtracting 3mins from the time we should consider actual time line

e.g. here the min is greater than 3, so no issue what so ever
but what if the time said 00:02:02 , so minusing 3 would be 11:59:02

I tried to modify the bit

awk -v VM="first,second,third" -v GC="GC started at" -v CN="and continued for" -v MN="mins" '{split(VM,P,",")
> if($0 ~ /running from last 3 min/) {
> if(s){a++;split(k,T,":");print P[a],GC,T[1]":"(T[2]-3)":"T[3],CN,s,MN;};k=$1;}else{s=$(NF-1)}}
> END{a++;split(k,T,":");print P[a],GC,T[1]":"(T[2]-3)":"T[3],CN,s,MN}' gc.txt

first GC started at 00:-1:02 and continued for 15 mins
second GC started at 10:25:01 and continued for 17 mins
third GC started at 17:31:01 and continued for 16 mins

This what I'm looking for but not the -1 bit in first line, it should say 59.

pamu · October 5, 2012, 11:15am

actually one correction..

awk -v VM="first,second,third" -v GC="GC started at" -v CN="and continued for" -v MN="mins" '{split(VM,P,",")
if($0 ~ /running from last 3 min/) {
if(s){a++;split(k,T,":");print P[a],GC,T[1]":"(T[2]-3)":"T[3],k,CN,s,MN;};k=$1;}else{s=$(NF-1)}}
END{a++;split(k,T,":");print P[a],GC,T[1]":"(T[2]-3)":"T[3],k,CN,s,MN}' file

and about time less than 3 mins it will be more uglier add one condition to check if T[2] is greater than 3 or not..

bye..

RudiC · October 5, 2012, 11:26am

I LOVE moving targets. As you point out yourself, you would need to implement full blown date & time arithmetics to really solve your problem. This I have NOT done but left it for your exercise. At least, for your sample data, this should work:

awk     'BEGIN {FMTSTR = "%2d. GC started at %s (%s - %s min) and continued for %s mins.\n"}
         function prtit () {split (STTIME,B,":");
                            B[2]-=FSTMIN;
                            TMP = sprintf ("%02d:%02d:%02d", B[1], B[2], B[3]);
                            printf FMTSTR, ++CNT, TMP, STTIME, FSTMIN, LASTMIN
                          }
         NR  > 1 && $13 < LASTMIN {prtit ()} 
         NR == 1 || $13 < LASTMIN {STTIME = $1; FSTMIN = $13}
         { LASTMIN = $13}
         END {prtit ()}
        ' file
 1. GC started at 00:15:02 (00:18:02 - 3 min) and continued for 15 mins.
 2. GC started at 10:25:01 (10:28:01 - 3 min) and continued for 17 mins.
 3. GC started at 17:31:01 (17:34:01 - 3 min) and continued for 16 mins.

As I said, no day nor hours span taken care of...