#!/usr/bin/perl -w
use strict;

my ($ts, %store);
while (<DATA>){
    $ts = $1 if /^(\[[^\]]+])/;
    $store{$ts} = $1 if /(DBPoolSQLException:.*)/;
}

for (keys %store){
    # Qualify this with whatever time-stamp matching you want
    print "$_: $store{$_}\n";
}

__END__
[Wed Aug 04 00:10:40.591 2010] [DEBUG] [TP-Processor19, time=1280895040587, uri=/ibdsupport/workflow/webapp/workflow/coordinator/gotoCoordinatorNew.cb2] [com.boylesoftware.cb2.BLOBJT.cache]: [208973459] Retrieve cached object 'segmentProp.map' for segment 142
[Wed Aug 04 00:10:40.591 2010] [DEBUG] [TP-Processor19, time=1280895040587, uri=/ibdsupport/workflow/webapp/workflow/coordinator/gotoCoordinatorNew.cb2] [com.boylesoftware.cb2.BLOBJT.cache]: [208973459] Retrieve cached object 'segmentProp.map' for segment 142

[Wed Aug 04 00:10:40.666 2010] [ERROR] [TP-Processor19, time=1280895040587, uri=/ibdsupport/workflow/webapp/workflow/coordinator/gotoCoordinatorNew.cb2] [com.boylesoftware.cb2.DAOBJT]: [208973534] Got an error executing query "fetchJobQueueTime" chunk "5".
com.boylesoftware.cb2.BLException: Database error in the DAO.

      at com.boylesoftware.cb2.DAO.executeUpdate_Internal(DAO.java:2483) [cb2ms.jar:na]
        at com.boylesoftware.cb2.DAO.executeNamedQuery(DAO.java:2634) [cb2ms.jar:na]
        at com.boylesoftware.cb2.DAO.fetch_Internal(DAO.java:2524) [cb2ms.jar:na]
        at com.boylesoftware.cb2.DAO.fetchWithNamedParams(DAO.java:2721) [cb2ms.jar:na]
        at com.boylesoftware.cb2.DAO.fetchWithNamedParams(DAO.java:3826) [cb2ms.jar:na]
        at com.somecompany.insidetrack.tt.project.ProjConsoleBLO.fetchJobQueueTime(ProjConsoleBLO.java:527) [ProjConsoleBLO.class:na]
        at com.somecompany.insidetrack.tt.presentation.workflow.JobOverviewListPE.init(JobOverviewListPE.java:221) [JobOverviewListPE.class:na]
        at com.boylesoftware.cb2.presentation.servlet.ShowPageAction.execute(ShowPageAction.java:141) [cb2ms.jar:na]
        at com.boylesoftware.cb2.presentation.servlet.CB2Action.execute(CB2Action.java:205) [cb2ms.jar:na]
        at org.apache.struts.action.RequestProcessor.processActionPerform(Unknown Source) [struts.jar:1.1]

        at java.lang.Thread.run(Thread.java:619) [na:1.6.0_16]
Caused by: msjava.dbpool.DBPoolSQLException: The column prefix '#projJob' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
 (DataSource: insidetrack-db, Type: SYBASE)

[Wed Aug 04 00:10:40.666 2010] [DEBUG] [TP-Processor19, time=1280895040587, uri=/ibdsupport/workflow/webapp/workflow/coordinator/gotoCoordinatorNew.cb2] [com.boylesoftware.cb2.DAOBJT]: [208973534] executing chunk "6" with a timeout of 360 seconds