Running: ./v2pixel_playback.sh -d 3 -a 17
2011-05-12 01:34:22.253 (3) [main]: Debug Level set to 3
2011-05-12 01:34:22.344 (3) [main]: No licensing config file found, assuming TSA production environment
2011-05-12 01:34:22.348 (2) [main]: Using DB user/pass: spike / tar63t
2011-05-12 01:34:22.356 (2) [main]: Event Batch Dispatch Interval Set To: 900
2011-05-12 01:34:22.358 (2) [main]: Event Batch Dispatch Limit Set To: 10
2011-05-12 01:34:22.359 (2) [main]: Event Generation: Enabled
2011-05-12 01:34:22.360 (2) [main]: Account Dispatcher Thread Pool Size Set To: 8
2011-05-12 01:34:22.360 (2) [main]: Using Account IDs: (17)
2011-05-12 01:34:22.387 (2) [main]: Account List Operator:  in 
2011-05-12 01:34:22.388 (2) [main]: Pixel Log Directory: /usr/local/share/tsa/logs/spike-v2
2011-05-12 01:34:22.468 (3) [main]: ----------------Pixel Log Playback starting
2011-05-12 01:34:25.693 (3) [P1T1]: DatabasePool with a limit of 5 created
2011-05-12 01:34:25.919 (3) [P1T1]: DatabasePool with a limit of 5 created
2011-05-12 01:34:26.301 (2) [P1T1]: Site Initialized For accountID: 17 / siteID: 35
2011-05-12 01:34:26.471 (3) [P1T1]: Using TimeZone: America/Los_Angeles
2011-05-12 01:34:26.617 (3) [P1T1]: Schema 'waypointFilteringDisabled' doesn't exist in scope sites
2011-05-12 01:34:26.647 (3) [P1T1]: Loaded 3 User Agent Filters
2011-05-12 01:34:26.649 (3) [P1T1]: Loaded 13 Remote Address (CIDR) Filters
2011-05-12 01:34:27.095 (2) [P1T1]: Successfully Opened File: /usr/local/share/tsa/logs/spike-v2/working/2011-01-07-1000-35.tsv
2011-05-12 01:34:27.099 (3) [P1T1]: Temp Processing File: /tmp/pixlog_35_25548csv
2011-05-12 01:34:27.111 (3) [P1T1]: Temp Processing File: /tmp/pixprodlog_35_25549csv
2011-05-12 01:34:27.113 (2) [P1T1]: Playback Started For File [2011-01-07-1000-35.tsv] For Account: WWMW - Cellular Safety Commission [17]
2011-05-12 01:34:27.503 (3) [P1T1]: Initializing Search Engine Name Referer Pattern Map
2011-05-12 01:34:30.402 (3) [P1T1]: Initializing Distribution Map
2011-05-12 01:34:31.259 (2) [P1T1]: Preprocess Complete of 3 Lines, Filtered: 0 Lines, Errors: 0 Lines, Elapsed Time: 4.146s
2011-05-12 01:34:33.040 (2) [P1T1]: loadStagingData completed: 0.96s
2011-05-12 01:34:33.055 (2) [P1T1]: loadWaypointConversions completed: 0.12s
2011-05-12 01:34:33.079 (3) [P1T1]: DuplicateWaypointFilter::getCount completed: 0.11s
2011-05-12 01:34:33.079 (3) [P1T1]: DuplicateWaypointFilter::filter Found 0 duplicates, completed: 0.19s
2011-05-12 01:34:33.080 (2) [P1T1]: filterDuplicateWaypoints completed: 0.24s
2011-05-12 01:34:33.096 (3) [P1T1]: Conversions::update completed: 0.8s
2011-05-12 01:34:33.140 (3) [P1T1]: Conversions::doCountConversions completed: 0.44s
2011-05-12 01:34:33.172 (3) [P1T1]: Conversions::needCatchAllProductMade completed (false): 0.24s
2011-05-12 01:34:33.180 (3) [P1T1]: Conversions::needTSACountedProductMade completed (false): 0.8s
2011-05-12 01:34:33.187 (3) [P1T1]: Conversions::needTSAUncountedProductMade completed (false): 0.7s
2011-05-12 01:34:33.187 (3) [P1T1]: Conversions::createMissing completed: 0.91s
2011-05-12 01:34:33.203 (3) [P1T1]: Conversions::update completed: 0.15s
2011-05-12 01:34:33.204 (2) [P1T1]: resolveConversions completed: 0.124s
2011-05-12 01:34:33.287 (3) [P1T1]: WaypointSources::resolveSources create waypointSources complete: 0.76s
2011-05-12 01:34:33.367 (3) [P1T1]: WaypointSources::resolveSources update waypointLog complete: 0.48s
2011-05-12 01:34:33.423 (3) [P1T1]: WaypointSources::createRefcdSources insert into st-tracker.sources complete: 0.55s
2011-05-12 01:34:33.435 (3) [P1T1]: WaypointSources::createRefcdSources create waypointRefcdSources complete: 0.11s
2011-05-12 01:34:33.451 (3) [P1T1]: WaypointSources::createRefcdSources update waypointLog complete: 0.15s
2011-05-12 01:34:33.452 (3) [P1T1]: WaypointSources::createRefcdSources complete: 0.84s
2011-05-12 01:34:43.837 (3) [P1T1]: WaypointSources::resolveLinkSources update waypointLog(1) complete: 10.385s
2011-05-12 01:34:43.909 (3) [P1T1]: WaypointSources::createLinkSources complete: 0.68s
2011-05-12 01:34:44.112 (3) [P1T1]: WaypointSources::resolveLinkSources update waypointLog(2) complete: 0.271s
2011-05-12 01:34:44.116 (3) [P1T1]: WaypointSources::resolveLinkSources complete: 10.664s
2011-05-12 01:34:44.117 (3) [P1T1]: WaypointSources::resolveSources complete: 10.905s
2011-05-12 01:34:44.117 (2) [P1T1]: resolveWaypointSources completed: 10.913s
2011-05-12 01:34:44.193 (3) [P1T1]: UserAgent::makeUserAgentTable: 0.72s
2011-05-12 01:34:44.206 (3) [P1T1]: UserAgent::assignNewUserAgents: 0.6s
2011-05-12 01:34:44.208 (2) [P1T1]: resolveUserAgents completed: 0.90s
2011-05-12 01:34:44.778 (2) [P1T1]: resolveCreatives completed: 0.570s
2011-05-12 01:34:44.878 (3) [P1T1]: Temp Processing File: /tmp/pixsources_35_25550csv
2011-05-12 01:34:44.880 (3) [P1T1]: Temp Processing File: /tmp/pixdebounce_35_25551csv
2011-05-12 01:34:44.949 (3) [P1T1]: SessionSources::makeFirstWaypointLog: 0.67s
2011-05-12 01:34:45.196 (3) [P1T1]: SessionSources::makeSessionSourceTable: 0.243s
2011-05-12 01:34:45.328 (3) [P1T1]: SessionSources::makeSessionSourceRowsSnapshot: 0.132s
2011-05-12 01:34:45.454 (3) [P1T1]: SessionSources::resolveInternalLinkSources insert pre-existing internal sources complete: 0.126s
2011-05-12 01:34:45.478 (3) [P1T1]: SessionSources::makeSessionSourceRowsSnapshot: 0.24s
2011-05-12 01:34:45.502 (3) [P1T1]: SessionSources::createInternalLinkSources complete: 0.22s
2011-05-12 01:34:45.512 (3) [P1T1]: SessionSources::resolveInternalLinkSources insert new internal sources complete: 0.8s
2011-05-12 01:34:45.512 (3) [P1T1]: SessionSources::resolveInternalLinkSources complete: 0.316s
2011-05-12 01:34:45.540 (3) [P1T1]: SessionSources::makeSessionSourceRowsSnapshot: 0.28s
2011-05-12 01:34:45.548 (3) [P1T1]: SessionSources::updateRemainingFirstSessions update waypointLog.sourceID: 0.6s
2011-05-12 01:34:45.558 (3) [P1T1]: SessionSources::remainingHits create sortedWaypointLog: 0.10s
2011-05-12 01:34:45.572 (3) [P1T1]: SessionSources::remainingHits create remainingHits: 0.14s
2011-05-12 01:34:45.584 (3) [P1T1]: SessionSources::remainingHits select sorted remaining rows: 0.12s
2011-05-12 01:34:45.584 (3) [P1T1]: Done Preprocessing Source Sessions: 0.791s
2011-05-12 01:34:45.604 (3) [P1T1]: Batch Session Assignments Created: 0.20s
2011-05-12 01:34:45.604 (3) [P1T1]: SessionSources::loadSessionSourceData Loading 1 Rows
2011-05-12 01:34:45.690 (3) [P1T1]: SessionSources::loadSessionSourceData Complete: 0.86s
2011-05-12 01:34:45.692 (3) [P1T1]: SessionSources::loadDebounceData Loading 0 Rows
2011-05-12 01:34:45.780 (3) [P1T1]: SessionSources::loadDebounceData Complete: 0.88s
2011-05-12 01:34:45.784 (2) [P1T1]: Debounce Count: 0
2011-05-12 01:34:45.784 (3) [P1T1]: Debounce Check History Count: 0 / Debounce Check History Time: 0.0s
2011-05-12 01:34:45.784 (2) [P1T1]: resolveSessions completed: 0.991s
2011-05-12 01:34:45.784 (3) [P1T1]: Starting commitToWaypointLog
2011-05-12 01:34:45.790 (3) [P1T1]: Start Transaction for `spike_v2` complete: 0.6s
2011-05-12 01:34:45.882 (3) [P1T1]: copy to `spike_v2`.`waypointLog` complete: 0.90s
2011-05-12 01:34:45.966 (3) [P1T1]: commitToWaypointConversionLog completed: 0.76s
2011-05-12 01:34:45.994 (3) [P1T1]: commit to `spike_v2` complete: 0.28s
2011-05-12 01:34:46.002 (2) [P1T1]: commitToWaypointLog completed: 0.218s
2011-05-12 01:34:46.014 (0) [P1T1]: Processed 3 Log Lines / 3 Hits Imported / Total Time: 18.888s (571 lines/hour, 571 hits/hour)
2011-05-12 01:34:46.218 (3) [main]: ------------Pixel Log Playback done
2011-05-12 01:34:46.220 (3) [Thread-0]: shutting down. reached point of no return ...
shutting down. reached point of no return ...