LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 10-13-2014, 09:36 AM   #1
mohitvad
Member
 
Registered: Feb 2010
Posts: 34

Rep: Reputation: 0
Pattern to matching


Hi,

I want to match pattern. It should grep the following logs and email. I want to grep the word "Exception" and immediate logs those starts with "!" . Can you please give me the sed regex or grep regex that i can use in shell script . Below are logs and my desired output.

DEBUG 2014-10-13 07:58:07,725 [ID: ] [URL: ] c.o.p.s.db.Test - : jdbc:ingres://172.20.17.217:VW7/ACDB2
! java.lang.ClassNotFoundException: org.tmatesoft.svn.core.SVNException
! at java.net.URLClassLoader$1.run(URLClassLoader.java:372) ~[na:1.8.0_20]
! at java.net.URLClassLoader$1.run(URLClassLoader.java:361) ~[na:1.8.0_20]
! at java.security.AccessController.doPrivileged(Native Method) ~[na:1.8.0_20]
! at java.net.URLClassLoader.findClass(URLClassLoader.java:360) ~[na:1.8.0_20]
! at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[na:1.8.0_20]
! at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) ~[na:1.8.0_20]
! at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[na:1.8.0_20]
!... 58 common frames omitted
DEBUG 2014-10-13 07:59:17,725 [ID: ] [URL: ] c.o.p.s.db.Test - : jdbc:ingres://172.20.17.217:VW7/ACDB2
DEBUG 2014-10-13 07:59:27,725 [ID: ] [URL: ] c.o.p.s.db.Test - : jdbc:ingres://172.20.17.217:VW7/ACDB2
DEBUG 2014-10-13 07:59:57,725 [ID: ] [URL: ] c.o.p.s.db.Test - : jdbc:ingres://172.20.17.217:VW7/ACDB2


Output should be:

! java.lang.ClassNotFoundException: org.tmatesoft.svn.core.SVNException
! at java.net.URLClassLoader$1.run(URLClassLoader.java:372) ~[na:1.8.0_20]
! at java.net.URLClassLoader$1.run(URLClassLoader.java:361) ~[na:1.8.0_20]
! at java.security.AccessController.doPrivileged(Native Method) ~[na:1.8.0_20]
! at java.net.URLClassLoader.findClass(URLClassLoader.java:360) ~[na:1.8.0_20]
! at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[na:1.8.0_20]
! at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) ~[na:1.8.0_20]
! at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[na:1.8.0_20]
!... 58 common frames omitted
 
Old 10-13-2014, 10:50 AM   #2
smallpond
Senior Member
 
Registered: Feb 2011
Location: Massachusetts, USA
Distribution: Fedora
Posts: 4,126

Rep: Reputation: 1260Reputation: 1260Reputation: 1260Reputation: 1260Reputation: 1260Reputation: 1260Reputation: 1260Reputation: 1260Reputation: 1260
How about
Code:
awk '/Exception/ {flag=1} !/^!/ {flag=0} {if (flag) print $0}' test_file
 
1 members found this post helpful.
Old 10-13-2014, 12:00 PM   #3
mohitvad
Member
 
Registered: Feb 2010
Posts: 34

Original Poster
Rep: Reputation: 0
Thanks the above code worked. Now i want the regex can give me. Below are logs and the desired output.


Logs:
DEBUG 2014-10-13 07:58:07,725 [ID: ] [URL: ] c.o.p.s.db.Test - : jdbc:ingres://172.20.17.217:VW7/ACDB2
! java.lang.ClassNotFoundException: org.tmatesoft.svn.core.SVNException
! at java.net.URLClassLoader$1.run(URLClassLoader.java:372) ~[na:1.8.0_20]
! at java.net.URLClassLoader$1.run(URLClassLoader.java:361) ~[na:1.8.0_20]
! at java.security.AccessController.doPrivileged(Native Method) ~[na:1.8.0_20]
! at java.net.URLClassLoader.findClass(URLClassLoader.java:360) ~[na:1.8.0_20]
! at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[na:1.8.0_20]
! at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) ~[na:1.8.0_20]
! at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[na:1.8.0_20]
!... 58 common frames omitted
DEBUG 2014-10-13 07:59:17,725 [ID: ] [URL: ] c.o.p.s.db.Test - : jdbc:ingres://172.20.17.217:VW7/ACDB2
java.sql.SQLDataException: Integer divide by zero detected in query.
at rock.util.SqlExType.getSqlEx(SqlExType.java:103)
at rock.util.SqlExFactory.get(SqlExFactory.java:96)
at rock.rock(DrvObj.java:852)
at rock.jdbc.DrvObj.readResults(DrvObj.java:636)
at rock.jdbc.RsltFtch.preLoad(RsltFtch.java:611)
at rock.jdbc.RsltCurs.preLoad(RsltCurs.java:306)
at rock.jdbc.RsltCurs.<init>(RsltCurs.java:235)




Desired Output:
! java.lang.ClassNotFoundException: org.tmatesoft.svn.core.SVNException
! at java.net.URLClassLoader$1.run(URLClassLoader.java:372) ~[na:1.8.0_20]
! at java.net.URLClassLoader$1.run(URLClassLoader.java:361) ~[na:1.8.0_20]
! at java.security.AccessController.doPrivileged(Native Method) ~[na:1.8.0_20]
! at java.net.URLClassLoader.findClass(URLClassLoader.java:360) ~[na:1.8.0_20]
! at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[na:1.8.0_20]
! at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) ~[na:1.8.0_20]
! at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[na:1.8.0_20]
!... 58 common frames omitted

java.sql.SQLDataException: Integer divide by zero detected in query.
at rock.util.SqlExType.getSqlEx(SqlExType.java:103)
at rock.util.SqlExFactory.get(SqlExFactory.java:96)
at rock.rock(DrvObj.java:852)
at rock.jdbc.DrvObj.readResults(DrvObj.java:636)
at rock.jdbc.RsltFtch.preLoad(RsltFtch.java:611)
at rock.jdbc.RsltCurs.preLoad(RsltCurs.java:306)
at rock.jdbc.RsltCurs.<init>(RsltCurs.java:235)
 
Old 10-13-2014, 12:13 PM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,553

Rep: Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946
Quote:
Originally Posted by mohitvad View Post
Thanks the above code worked. Now i want the regex can give me. Below are logs and the desired output.
Can you show us ANY effort of your own??? Asking for handouts without showing some effort is fairly rude. You've been given help, and should be easily able to take what you've been handed and modify it to suit your needs.

You've been using Linux for four years now...have you not done ANYTHING with scripting, regex, awk/sed/grep in all that time?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching patterns or partial pattern matching yaplej Programming 6 12-16-2012 10:21 AM
[SOLVED] awk with pipe delimited file (specific column matching and multiple pattern matching) lolmon Programming 4 08-31-2011 12:17 PM
pattern matching vinaytp Linux - Newbie 2 10-10-2009 06:06 AM
Pattern Matching Aveltium Linux - Newbie 5 04-12-2009 11:14 PM
pattern matching nadeemr Linux - Newbie 8 06-13-2007 11:05 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 05:41 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration