文本排序與合并的問題

hinux

先看下面的文本內(nèi)容（其實(shí)是/var/adm/messages的內(nèi)容）：
Jul  8 11:18:07 test_server scsi: [ID 107833 kern.warning] WARNING: /pci@8,700000/scsi@3/sd@1,0 (sd31):
Jul  8 11:18:07 test_server  Error for Command: write                   Error Level: Retryable
Jul  8 11:18:07 test_server scsi: [ID 107833 kern.notice]    Requested Block: 17395                     Error Block: 17413
Jul  8 11:18:07 test_server scsi: [ID 107833 kern.notice]    Sense Key: Hardware Error
Jul  8 11:18:09 test_server scsi: [ID 107833 kern.warning] WARNING: /pci@8,700000/scsi@3/sd@1,0 (sd31):
Jul  8 11:18:09 test_server  Error for Command: write                   Error Level: Retryable
Jul  8 11:18:09 test_server scsi: [ID 107833 kern.notice]    Requested Block: 17395                     Error Block: 17413
Jul  8 11:18:09 test_server scsi: [ID 107833 kern.notice]    Sense Key: Hardware Error
Jul  8 11:18:11 test_server scsi: [ID 107833 kern.warning] WARNING: /pci@8,700000/scsi@3/sd@1,0 (sd31):
Jul  8 11:18:11 test_server  Error for Command: write                   Error Level: Retryable
Jul  8 11:18:11 test_server scsi: [ID 107833 kern.notice]    Requested Block: 17395                     Error Block: 17413
Jul  8 11:18:08 test_server scsi: [ID 107833 kern.notice]    Requested Block: 17395                     Error Block: 17413
Jul  8 11:18:08 test_server scsi: [ID 107833 kern.notice]    Sense Key: Hardware Error
Jul  8 11:18:11 test_server scsi: [ID 107833 kern.notice]    Sense Key: Hardware Error
Aug 29 11:18:11 test_server xntpd[233]: [ID 774427 daemon.notice] time reset (step) -0.999968 s warning
Jul  8 11:18:11 test_server scsi: [ID 107833 kern.warning] WARNING: /pci@8,700000/scsi@3/sd@1,0 (sd31):
Jul  8 11:18:11 test_server  SCSI transport failed: reason 'reset': retrying command
Jul  8 11:18:15 test_server scsi: [ID 107833 kern.warning] WARNING: /pci@8,700000/scsi@3/sd@1,0 (sd31):
Mar 13 15:04:33 test_server xntpd[233]: [ID 774427 daemon.notice] time reset (step) -0.999968 s warning
Aug 18 15:04:21 test_server xntpd[233]: [ID 774427 daemon.notice] time reset (step) -0.999968 s warning
Jul  8 11:18:15 test_server  Error for Command: write                   Error Level: Retryable
Jul  8 11:18:15 test_server scsi: [ID 107833 kern.notice]    Requested Block: 17395                     Error Block: 17413
Mar 18 15:04:09 test_server xntpd[233]: [ID 774427 daemon.notice] time reset (step) -0.999968 s warning
Jul  8 11:18:15 test_server scsi: [ID 107833 kern.notice]    Sense Key: Hardware Error
Jul  8 11:18:16 test_server scsi: [ID 107833 kern.warning] WARNING: /pci@8,700000/scsi@3/sd@1,0 (sd31):
Aug 29 17:50:00 test_server tldcd[18400]: [ID 782741 daemon.error] TLD(0) key = 0x2, asc = 0x4, ascq = 0x1, LOGICAL UNIT IS IN PROCESS OF BECOMING READY
Jul  8 11:18:16 test_server  Error for Command: write                   Error Level: Retryable
Jul  8 11:18:16 test_server scsi: [ID 107833 kern.notice]    Requested Block: 17395                     Error Block: 17413
Jul  8 11:18:16 test_server scsi: [ID 107833 kern.notice]    Sense Key: Hardware Error
Sep  8 17:50:00 test_server tldcd[18400]: [ID 782741 daemon.error] TLD(0) key = 0x2, asc = 0x4, ascq = 0x1, LOGICAL UNIT IS IN PROCESS OF BECOMING READY
Jul  8 11:18:17 test_server scsi: [ID 107833 kern.warning] WARNING: /pci@8,700000/scsi@3/sd@1,0 (sd31):
Jul  8 11:18:17 test_server  Error for Command: write                   Error Level: Fatal
Jul  8 11:18:17 test_server scsi: [ID 107833 kern.notice]    Requested Block: 17395                     Error Block: 17413
Jul  8 11:18:17 test_server scsi: [ID 107833 kern.notice]    Sense Key: Hardware Error
Sep  6 19:50:04 test_server tldcd[18400]: [ID 782741 daemon.error] TLD(0) key = 0x2, asc = 0x4, ascq = 0x1, LOGICAL UNIT IS IN PROCESS OF BECOMING READY
Sep  6 23:45:04 test_server tldcd[18400]: [ID 782741 daemon.error] TLD(0) key = 0x2, asc = 0x4, ascq = 0x1, LOGICAL UNIT IS IN PROCESS OF BECOMING READY
Sep  6 20:45:04 test_server tldcd[18400]: [ID 782741 daemon.error] TLD(0) key = 0x2, asc = 0x4, ascq = 0x1, LOGICAL UNIT IS IN PROCESS OF BECOMING READY
Jul  8 11:18:17 test_server md_raid: [ID 371651 kern.warning] WARNING: md d30: write error on /dev/dsk/c1t1d0s0
Jul  8 11:18:18 test_server md_raid: [ID 104909 kern.warning] WARNING: md: d30: /dev/dsk/c1t1d0s0 needs maintenance
Sep 20 15:04:09 test_server xntpd[233]: [ID 774427 daemon.notice] time reset (step) -0.999968 s warning


現(xiàn)在，我希望合并除前三個(gè)時(shí)間字段外相同內(nèi)容的行，在合并的信息的最前面顯示合并的信息行數(shù)，然后顯示的是離現(xiàn)在最近的信息產(chǎn)生時(shí)間，最后是具體內(nèi)容。
輸出效果大致如下：
1 Sep 20 15:04:09 test_server xntpd[233]: [ID 774427 daemon.notice] time reset (step) -0.999968 s warning
5 Sep  8 17:50:00 test_server tldcd[18400]: [ID 782741 daemon.error] TLD(0) key = 0x2, asc = 0x4, ascq = 0x1, LOGICAL UNIT IS IN PROCESS OF BECOMING READY
7 Jul  8 11:18:17 test_server scsi: [ID 107833 kern.notice]    Requested Block: 17395                     Error Block: 17413
7 Jul  8 11:18:17 test_server scsi: [ID 107833 kern.notice]    Sense Key: Hardware Error
7 Jul  8 11:18:17 test_server scsi: [ID 107833 kern.warning] WARNING: /pci@8,700000/scsi@3/sd@1,0 (sd31):
1 Jul  8 11:18:17 test_server md_raid: [ID 371651 kern.warning] WARNING: md d30: write error on /dev/dsk/c1t1d0s0
1 Jul  8 11:18:18 test_server md_raid: [ID 104909 kern.warning] WARNING: md: d30: /dev/dsk/c1t1d0s0 needs maintenance
1 Jul  8 11:18:17 test_server  Error for Command: write                   Error Level: Fatal
5 Jul  8 11:18:16 test_server  Error for Command: write                   Error Level: Retryable


我的思路是通過sort和uniq命令，例如"egrep -i "fault|error|warning|panic|false" /var/adm/messages | sort -b -M -r | sort +4 | uniq -c -f 4"，試了很多排序合并方法仍不行，問題出在首先要根據(jù)字段3以后的字段排序然后根據(jù)時(shí)間的后先順序合并。請(qǐng)各位指點(diǎn)一二！

welcome008

awk '{a=$1" "$2" "$3;$1="";$2="";$3="";b[$0]+=1;c[$0]=a}END{for(x in b) print b[x],c[x],x}' filename|sort -k2,3,4

沒有考慮跨月的情況

goride

剛看完awk，用數(shù)組的真有點(diǎn)難