2010-10-21 09:03:49.187 (3) [main]: Debug Level set to 5 2010-10-21 09:03:49.192 (3) [main]: No licensing config file found, assuming TSA production environment 2010-10-21 09:03:49.195 (5) [main]: yesterday: month=10, day=20, year=2010 2010-10-21 09:03:50.587 (3) [main]: Configured properties according to file :: /var/local/tsa/datafeedConfig/Facebook.xml 2010-10-21 09:03:50.593 (5) [main]: parseInteger->[17] 2010-10-21 09:03:50.615 (5) [main]: parseInteger<-[17] 2010-10-21 09:03:50.649 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-21 09:03:51.705 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:51.741 (4) [main]: null key, and no data, unable to build condition 2010-10-21 09:03:51.752 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:51.754 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` limit 1] 2010-10-21 09:03:51.796 (5) [main]: recordAsSubs("db", 43, "main") 2010-10-21 09:03:51.797 (5) [main]: ProfilerRec.end("db", true): ret=43 2010-10-21 09:03:51.798 (4) [main]: time=0.043 2010-10-21 09:03:51.798 (4) [main]: Query executed in 0.043s 2010-10-21 09:03:51.801 (5) [main]: loading 19 columns from result set: 2010-10-21 09:03:51.802 (5) [main]: loaded column: accounts.id->1 2010-10-21 09:03:51.803 (5) [main]: loaded column: accounts.description->Admin Account 2010-10-21 09:03:51.805 (5) [main]: loaded column: accounts.tier->3 2010-10-21 09:03:51.806 (5) [main]: loaded column: accounts.priority->50 2010-10-21 09:03:51.807 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-21 09:03:51.808 (5) [main]: loaded column: accounts.reportConversions->false 2010-10-21 09:03:51.809 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-21 09:03:51.810 (5) [main]: loaded column: accounts.isBidManaged->false 2010-10-21 09:03:51.811 (5) [main]: loaded column: accounts.isActive->false 2010-10-21 09:03:51.812 (5) [main]: loaded column: accounts.perfMetric->cpa 2010-10-21 09:03:51.813 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-21 09:03:51.814 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-21 09:03:51.815 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-21 09:03:51.816 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-21 09:03:51.818 (5) [main]: loaded column: accounts.nowTime->null 2010-10-21 09:03:51.819 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-21 09:03:51.820 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-21 09:03:51.821 (5) [main]: loaded column: accounts.warehouseInstance->2 2010-10-21 09:03:51.821 (5) [main]: loaded column: accounts.isOnline->true 2010-10-21 09:03:51.822 (4) [main]: Record Loaded 2010-10-21 09:03:51.823 (4) [main]: DataCache: put key acct-st-tracker null 2010-10-21 09:03:51.829 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:51.829 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-1")) limit 1] 2010-10-21 09:03:51.833 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-21 09:03:51.833 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:51.834 (4) [main]: time=0.0040 2010-10-21 09:03:51.835 (4) [main]: Query executed in 0.004s 2010-10-21 09:03:51.836 (5) [main]: loading 8 columns from result set: 2010-10-21 09:03:51.837 (5) [main]: loaded column: databaseInstances.id->15 2010-10-21 09:03:51.838 (5) [main]: loaded column: databaseInstances.name->acct-st-tracker-1 2010-10-21 09:03:51.839 (5) [main]: loaded column: databaseInstances.description->Account-specific Catch-all database 2010-10-21 09:03:51.839 (5) [main]: loaded column: databaseInstances.type->mysql 2010-10-21 09:03:51.840 (5) [main]: loaded column: databaseInstances.database->st-tracker 2010-10-21 09:03:51.841 (5) [main]: loaded column: databaseInstances.host->acctdb-01-write 2010-10-21 09:03:51.842 (5) [main]: loaded column: databaseInstances.port->3306 2010-10-21 09:03:51.843 (5) [main]: loaded column: databaseInstances.access->rw 2010-10-21 09:03:51.843 (4) [main]: Record Loaded 2010-10-21 09:03:51.844 (4) [main]: DataCache: put key acct-st-tracker-1 2010-10-21 09:03:51.846 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:51.852 (3) [main]: DatabasePool with a limit of 80 created 2010-10-21 09:03:51.860 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2010-10-21 09:03:51.912 (4) [main]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:51.913 (4) [main]: Created new Object 2010-10-21 09:03:51.914 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:51.915 (4) [main]: spike: SQL->[select @@version] 2010-10-21 09:03:51.918 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:51.919 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:51.931 (4) [main]: time=0.0030 2010-10-21 09:03:51.931 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:51.932 (4) [main]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-21 09:03:51.933 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-21 09:03:51.934 (3) [main]: DatabasePool with a limit of 80 created 2010-10-21 09:03:51.963 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:51.964 (4) [main]: Created new Object 2010-10-21 09:03:51.965 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:51.965 (4) [main]: spike: SQL->[select @@version] 2010-10-21 09:03:51.968 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:51.969 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:51.969 (4) [main]: time=0.0030 2010-10-21 09:03:51.970 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:51.971 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl" 2010-10-21 09:03:51.978 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:51.979 (4) [main]: spike: SQL->[select * from `tsacommon`.`accountDistributionMap` where ((`accountID`="17") and (`distributionID`="177")) limit 1] 2010-10-21 09:03:51.981 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:51.982 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:51.983 (4) [main]: time=0.0030 2010-10-21 09:03:51.984 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:51.985 (3) [main]: Distribution status is [ACTIVE] for accountID[17], distributionID[177] 2010-10-21 09:03:51.988 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:51.989 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where ((`id`="177") and (`description`="Facebook") and (`shortCode`="FB")) limit 1] 2010-10-21 09:03:51.992 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:51.993 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:51.994 (4) [main]: time=0.0030 2010-10-21 09:03:51.995 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:51.996 (5) [main]: loading 19 columns from result set: 2010-10-21 09:03:51.997 (5) [main]: loaded column: distribution.id->177 2010-10-21 09:03:51.998 (5) [main]: loaded column: distribution.accountID->0 2010-10-21 09:03:51.999 (5) [main]: loaded column: distribution.siteID->0 2010-10-21 09:03:52.000 (5) [main]: loaded column: distribution.type->paid search 2010-10-21 09:03:52.000 (5) [main]: loaded column: distribution.channelID->5 2010-10-21 09:03:52.001 (5) [main]: loaded column: distribution.showStats->1 2010-10-21 09:03:52.002 (5) [main]: loaded column: distribution.bidMatchTypes->null 2010-10-21 09:03:52.003 (5) [main]: loaded column: distribution.trackMatchTypes->null 2010-10-21 09:03:52.004 (5) [main]: loaded column: distribution.mergeMatchTypeStats->false 2010-10-21 09:03:52.004 (5) [main]: loaded column: distribution.rollupMatchTypes->null 2010-10-21 09:03:52.005 (5) [main]: loaded column: distribution.positionalBidding->false 2010-10-21 09:03:52.006 (5) [main]: loaded column: distribution.description->Facebook 2010-10-21 09:03:52.328 (5) [main]: loaded column: distribution.shortCode->fb 2010-10-21 09:03:52.329 (5) [main]: loaded column: distribution.searchEngineClass->null 2010-10-21 09:03:52.330 (5) [main]: loaded column: distribution.bidMinCPC->null 2010-10-21 09:03:52.347 (5) [main]: loaded column: distribution.bidCapCPC->null 2010-10-21 09:03:52.348 (5) [main]: loaded column: distribution.bidMinCPM->null 2010-10-21 09:03:52.349 (5) [main]: loaded column: distribution.bidCapCPM->null 2010-10-21 09:03:52.350 (5) [main]: skipping invalid column: distribution.obsolete 2010-10-21 09:03:52.352 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:52.382 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.383 (4) [main]: spike: SQL->[select id from `tsacommon`.`sites` where ((`accountID`=17)) limit 1] 2010-10-21 09:03:52.399 (5) [main]: recordAsSubs("db", 16, "main") 2010-10-21 09:03:52.401 (5) [main]: ProfilerRec.end("db", true): ret=16 2010-10-21 09:03:52.402 (4) [main]: time=0.016 2010-10-21 09:03:52.402 (4) [main]: Query executed in 0.016s 2010-10-21 09:03:52.403 (4) [main]: in getSiteID()... siteID[35] 2010-10-21 09:03:52.404 (4) [main]: -- Source Map 2010-10-21 09:03:52.405 (4) [main]: Map= 2010-10-21 09:03:52.406 (4) [main]: Ad Name [class java.lang.String] => altKey [class java.lang.String] 2010-10-21 09:03:52.407 (4) [main]: -- SourceBidType Map 2010-10-21 09:03:52.407 (4) [main]: Map= 2010-10-21 09:03:52.408 (4) [main]: -- Campaign Map 2010-10-21 09:03:52.408 (4) [main]: Map= 2010-10-21 09:03:52.409 (4) [main]: Campaign Name [class java.lang.String] => description [class java.lang.String] 2010-10-21 09:03:52.409 (4) [main]: -- Publishser Activity Map 2010-10-21 09:03:52.409 (4) [main]: Map= 2010-10-21 09:03:52.409 (4) [main]: Clicks [class java.lang.String] => count [class java.lang.String] 2010-10-21 09:03:52.410 (4) [main]: Impressions [class java.lang.String] => impressions [class java.lang.String] 2010-10-21 09:03:52.410 (4) [main]: -- Publishser Product Map 2010-10-21 09:03:52.410 (4) [main]: Map= 2010-10-21 09:03:52.411 (4) [main]: Conversions [class java.lang.String] => count [class java.lang.String] 2010-10-21 09:03:52.413 (4) [main]: -- XMLDataFeedProperties:XMLDataFeedProperties DataFeedAccountInfo toString Information Account Description :: CSC Id Behavior Type :: ConfigFileIdBehavior Distribution Name :: Facebook Distribution Short Code:: FB Distribution Id :: 177 Id Map :: 17 :: 17 DataFeedFileInfo toString Information FileBehaviorType :: MultipleDaysFileBehavior ColumnDatePattern :: yyyy-MM-dd HH:mm FileDatePattern :: yyyyMMdd FileHourPattern :: yyyy-MM-dd HH:mm FileDelimiter :: , FileDirectory :: /var/local/tsa/publishers/17/177/ FileExtension :: .csv FilePrefix :: 17_FB_ FileSuffix :: TruncateLeadingZero :: false UseSpacePadding :: true Header Behavior Type :: DefaultHeaderBehavior List of header names :: headers :: Date delimiter :: null headers :: Campaign Name delimiter :: null headers :: Campaign ID delimiter :: null headers :: Ad Name delimiter :: null headers :: Ad ID delimiter :: null headers :: Impressions delimiter :: null headers :: Clicks delimiter :: null headers :: Click Rate delimiter :: null headers :: Actions delimiter :: null headers :: Action Rate delimiter :: null headers :: Conversions delimiter :: null headers :: Cost Per Conversion delimiter :: null headers :: CPC delimiter :: null headers :: CPM delimiter :: null headers :: Spent (USD) delimiter :: null headers :: Unique Impressions delimiter :: null headers :: Unique Clicks delimiter :: null headers :: Unique Click Rate delimiter :: null dfColumn :: Ad Name dbTable :: sources dbColumn :: altKey values :: null dfColumn :: Impressions dbTable :: publisherActivitySummary dbColumn :: impressions values :: null dfColumn :: Clicks dbTable :: publisherActivitySummary dbColumn :: count values :: null dfColumn :: Conversions dbTable :: publisherProductSummary dbColumn :: count values :: null dfColumn :: Campaign Name dbTable :: campaigns dbColumn :: description values :: null Product Behavior Type :: ProductByRowBehavior DataFeedProduct Column Mappings Id :: AltKey :: Ad Name Creative :: tsacr Date :: Hour :: DataFeedProduct Column Mappings Product Code:: null Cost :: Count :: Unique Impressions Revenue :: Product Saving Settings Key :: productCode && value :: Unique Impressions - feed Key :: countConversions && value :: false Key :: showData && value :: false Key :: showCost && value :: false Key :: showConv && value :: true Key :: showRev && value :: false Key :: columnLabel && value :: Unique Impressions - feed DataFeedProduct Column Mappings Product Code:: null Cost :: Count :: Unique Clicks Revenue :: Product Saving Settings Key :: productCode && value :: Unique Clicks - feed Key :: countConversions && value :: false Key :: showData && value :: false Key :: showCost && value :: false Key :: showConv && value :: true Key :: showRev && value :: false Key :: columnLabel && value :: Unique Clicks - feed DataFeed Date Info Header Behavior Type :: FileNameDateBehavior Date Offset ::0 Creative Behavior :: CreativeByDatabaseBehavior Refcd Behavior :: RefcdByColumnAndPositionBehavior Refcd refcdColumnName :: Ad Name Refcd delimiter :: | Refcd position :: 1 Description position :: 2 2010-10-21 09:03:52.413 (4) [main]: -- theHeaderDetails: 2010-10-21 09:03:52.414 (4) [main]: List= 2010-10-21 09:03:52.414 (4) [main]: 0: dfColumn :: Ad Name, dbTable :: sources, dbColumn :: altKey, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-21 09:03:52.414 (4) [main]: 1: dfColumn :: Impressions, dbTable :: publisherActivitySummary, dbColumn :: impressions, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-21 09:03:52.415 (4) [main]: 2: dfColumn :: Clicks, dbTable :: publisherActivitySummary, dbColumn :: count, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-21 09:03:52.415 (4) [main]: 3: dfColumn :: Conversions, dbTable :: publisherProductSummary, dbColumn :: count, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-21 09:03:52.415 (4) [main]: 4: dfColumn :: Campaign Name, dbTable :: campaigns, dbColumn :: description, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-21 09:03:52.415 (4) [main]: -- theDistributionName: Facebook 2010-10-21 09:03:52.416 (4) [main]: -- theDistributionId: 177 2010-10-21 09:03:52.416 (4) [main]: -- theDistributionShortCode: FB 2010-10-21 09:03:52.417 (4) [main]: -- distributionTableRow: Data= trackMatchTypes => null channelID [class java.lang.Integer] => 5 rollupMatchTypes => null type [class com.carldunham.jst.db.SQLLiteral] => paid search bidMinCPC => null positionalBidding [class com.carldunham.jst.db.SQLLiteral] => false bidCapCPC => null id [class java.lang.Integer] => 177 mergeMatchTypeStats [class com.carldunham.jst.db.SQLLiteral] => false accountID [class java.lang.Integer] => 0 bidMatchTypes => null showStats [class java.lang.Integer] => 1 description [class com.carldunham.jst.db.SQLLiteral] => Facebook bidMinCPM => null siteID [class java.lang.Integer] => 0 searchEngineClass => null bidCapCPM => null shortCode [class com.carldunham.jst.db.SQLLiteral] => fb Modified= 2010-10-21 09:03:52.417 (3) [main]: =============== Starting Publisher Generic Data Feed /177/ ================ 2010-10-21 09:03:52.419 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-21 09:03:52.447 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:52.447 (4) [main]: Created new Object 2010-10-21 09:03:52.447 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.448 (4) [main]: spike: SQL->[select @@version] 2010-10-21 09:03:52.451 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:52.451 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:52.452 (4) [main]: time=0.0030 2010-10-21 09:03:52.453 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:52.454 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl" 2010-10-21 09:03:52.455 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:52.456 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.457 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=17) limit 1] 2010-10-21 09:03:52.460 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:52.461 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:52.462 (4) [main]: time=0.0030 2010-10-21 09:03:52.462 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:52.463 (5) [main]: loading 19 columns from result set: 2010-10-21 09:03:52.464 (5) [main]: loaded column: accounts.id->17 2010-10-21 09:03:52.465 (5) [main]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-21 09:03:52.466 (5) [main]: loaded column: accounts.tier->2 2010-10-21 09:03:52.466 (5) [main]: loaded column: accounts.priority->60 2010-10-21 09:03:52.467 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-21 09:03:52.468 (5) [main]: loaded column: accounts.reportConversions->true 2010-10-21 09:03:52.469 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-21 09:03:52.469 (5) [main]: loaded column: accounts.isBidManaged->true 2010-10-21 09:03:52.470 (5) [main]: loaded column: accounts.isActive->true 2010-10-21 09:03:52.471 (5) [main]: loaded column: accounts.perfMetric->roi 2010-10-21 09:03:52.471 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-21 09:03:52.472 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-21 09:03:52.473 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-21 09:03:52.474 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-21 09:03:52.475 (5) [main]: loaded column: accounts.nowTime->null 2010-10-21 09:03:52.475 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-21 09:03:52.476 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-21 09:03:52.477 (5) [main]: loaded column: accounts.warehouseInstance->1 2010-10-21 09:03:52.477 (5) [main]: loaded column: accounts.isOnline->true 2010-10-21 09:03:52.478 (4) [main]: Record Loaded 2010-10-21 09:03:52.491 (4) [main]: Returning Object to Pool 2010-10-21 09:03:52.491 (3) [main]: Found 1 file(s)... 2010-10-21 09:03:52.492 (3) [main]: Files... [/var/local/tsa/publishers/17/177/17_FB_20100810.csv] 2010-10-21 09:03:52.493 (3) [main]: Loading file /var/local/tsa/publishers/17/177/17_FB_20100810.csv 2010-10-21 09:03:52.496 (3) [main]: Account [17]: deleting old publisher data (2010-08-10 00:00:00) 2010-10-21 09:03:52.511 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-21 09:03:52.544 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:52.545 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:52.546 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.547 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=17) limit 1] 2010-10-21 09:03:52.550 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:52.551 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:52.552 (4) [main]: time=0.0030 2010-10-21 09:03:52.553 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:52.554 (5) [main]: loading 19 columns from result set: 2010-10-21 09:03:52.554 (5) [main]: loaded column: accounts.id->17 2010-10-21 09:03:52.555 (5) [main]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-21 09:03:52.556 (5) [main]: loaded column: accounts.tier->2 2010-10-21 09:03:52.557 (5) [main]: loaded column: accounts.priority->60 2010-10-21 09:03:52.558 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-21 09:03:52.559 (5) [main]: loaded column: accounts.reportConversions->true 2010-10-21 09:03:52.560 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-21 09:03:52.561 (5) [main]: loaded column: accounts.isBidManaged->true 2010-10-21 09:03:52.561 (5) [main]: loaded column: accounts.isActive->true 2010-10-21 09:03:52.562 (5) [main]: loaded column: accounts.perfMetric->roi 2010-10-21 09:03:52.563 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-21 09:03:52.564 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-21 09:03:52.565 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-21 09:03:52.566 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-21 09:03:52.566 (5) [main]: loaded column: accounts.nowTime->null 2010-10-21 09:03:52.567 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-21 09:03:52.568 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-21 09:03:52.568 (5) [main]: loaded column: accounts.warehouseInstance->1 2010-10-21 09:03:52.569 (5) [main]: loaded column: accounts.isOnline->true 2010-10-21 09:03:52.570 (4) [main]: Record Loaded 2010-10-21 09:03:52.570 (4) [main]: DataCache: put key acct-st-tracker 17 2010-10-21 09:03:52.571 (4) [main]: DataCache: Found key acct-st-tracker-1 2010-10-21 09:03:52.572 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:52.656 (4) [main]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:52.657 (4) [main]: Created new Object 2010-10-21 09:03:52.658 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.659 (4) [main]: spike: SQL->[select @@version] 2010-10-21 09:03:52.668 (5) [main]: recordAsSubs("db", 9, "main") 2010-10-21 09:03:52.668 (5) [main]: ProfilerRec.end("db", true): ret=9 2010-10-21 09:03:52.669 (4) [main]: time=0.0090 2010-10-21 09:03:52.670 (4) [main]: Query executed in 0.009s 2010-10-21 09:03:52.671 (4) [main]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-21 09:03:52.672 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:52.674 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.675 (4) [main]: spike: SQL->[delete from `publisherActivitySummary` where ((`publisherActivitySummary`.`accountID`=17) and (`publisherActivitySummary`.`distributionID`="177") and (`publisherActivitySummary`.`startTime`>="2010-08-10 00:00:00") and (`publisherActivitySummary`.`startTime`<="2010-08-10 23:59:59"))], genflags=no 2010-10-21 09:03:52.681 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-21 09:03:52.681 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:52.682 (4) [main]: time=0.0060 2010-10-21 09:03:52.683 (4) [main]: Query executed in 0.006s, 0 row(s) affected 2010-10-21 09:03:52.685 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:52.687 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.688 (4) [main]: spike: SQL->[delete from `publisherProductSummary` where ((`publisherProductSummary`.`accountID`=17) and (`publisherProductSummary`.`distributionID`="177") and (`publisherProductSummary`.`startTime`>="2010-08-10 00:00:00") and (`publisherProductSummary`.`startTime`<="2010-08-10 23:59:59"))], genflags=no 2010-10-21 09:03:52.691 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:52.692 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:52.693 (4) [main]: time=0.0030 2010-10-21 09:03:52.694 (4) [main]: Query executed in 0.003s, 0 row(s) affected 2010-10-21 09:03:52.705 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.706 (4) [main]: spike: SQL->[select * from `dataSources` where ((`accountID`="17") and (`type`="publisher") and (`typeID`="177")) limit 1] 2010-10-21 09:03:52.709 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-21 09:03:52.709 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:52.710 (4) [main]: time=0.0040 2010-10-21 09:03:52.711 (4) [main]: Query executed in 0.004s 2010-10-21 09:03:52.711 (5) [main]: loading 4 columns from result set: 2010-10-21 09:03:52.712 (5) [main]: loaded column: dataSources.id->223001 2010-10-21 09:03:52.713 (5) [main]: loaded column: dataSources.type->publisher 2010-10-21 09:03:52.714 (5) [main]: loaded column: dataSources.typeID->177 2010-10-21 09:03:52.715 (5) [main]: loaded column: dataSources.accountID->17 2010-10-21 09:03:52.716 (4) [main]: Record Loaded 2010-10-21 09:03:52.720 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.723 (4) [main]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="223001") and (`date`="2010-10-19 03:00:00")) limit 1] 2010-10-21 09:03:52.727 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-21 09:03:52.728 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:52.728 (4) [main]: time=0.0040 2010-10-21 09:03:52.729 (4) [main]: Query executed in 0.004s 2010-10-21 09:03:52.730 (4) [main]: Record Not Found 2010-10-21 09:03:52.732 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.733 (4) [main]: spike: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-19 03:00:00","2010-10-21 09:03:52")], genflags=yes 2010-10-21 09:03:52.739 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-19 03:00:00","2010-10-21 09:03:52")] executed by user [spike] 2010-10-21 09:03:52.742 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-21 09:03:52.742 (5) [main]: recordAsSubs("db", 9, "main") 2010-10-21 09:03:52.743 (5) [main]: ProfilerRec.end("db", true): ret=9 2010-10-21 09:03:52.744 (4) [main]: time=0.0090 2010-10-21 09:03:52.744 (4) [main]: Query executed in 0.009s, 1 row(s) affected 2010-10-21 09:03:52.749 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.749 (4) [main]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-19 03:00:00","2010-10-21 09:03:52")], genflags=yes 2010-10-21 09:03:52.753 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-19 03:00:00","2010-10-21 09:03:52")] executed by user [spike] 2010-10-21 09:03:52.755 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-21 09:03:52.756 (5) [main]: recordAsSubs("db", 7, "main") 2010-10-21 09:03:52.757 (5) [main]: ProfilerRec.end("db", true): ret=7 2010-10-21 09:03:52.757 (4) [main]: time=0.0070 2010-10-21 09:03:52.758 (4) [main]: Query executed in 0.007s, 1 row(s) affected 2010-10-21 09:03:52.759 (3) [main]: loading "/var/local/tsa/publishers/17/177/17_FB_20100810.csv"... 2010-10-21 09:03:52.760 (3) [main]: Account [17]: deleting old publisher data (2010-10-19 00:00:00) 2010-10-21 09:03:52.761 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:52.763 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.763 (4) [main]: spike: SQL->[delete from `publisherActivitySummary` where ((`publisherActivitySummary`.`accountID`=17) and (`publisherActivitySummary`.`distributionID`="177") and (`publisherActivitySummary`.`startTime`>="2010-10-19 00:00:00") and (`publisherActivitySummary`.`startTime`<="2010-10-19 23:59:59"))], genflags=no 2010-10-21 09:03:52.766 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:52.767 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:52.768 (4) [main]: time=0.0030 2010-10-21 09:03:52.768 (4) [main]: Query executed in 0.003s, 0 row(s) affected 2010-10-21 09:03:52.769 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:52.771 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.772 (4) [main]: spike: SQL->[delete from `publisherProductSummary` where ((`publisherProductSummary`.`accountID`=17) and (`publisherProductSummary`.`distributionID`="177") and (`publisherProductSummary`.`startTime`>="2010-10-19 00:00:00") and (`publisherProductSummary`.`startTime`<="2010-10-19 23:59:59"))], genflags=no 2010-10-21 09:03:52.774 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:52.775 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:52.776 (4) [main]: time=0.0030 2010-10-21 09:03:52.776 (4) [main]: Query executed in 0.003s, 0 row(s) affected 2010-10-21 09:03:52.778 (5) [main]: No custom filter, returning FileInputStream 2010-10-21 09:03:52.789 (5) [main]: parseDouble->[0] 2010-10-21 09:03:52.790 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:52.791 (5) [main]: parseDouble->[70472] 2010-10-21 09:03:52.792 (5) [main]: parseDouble<-[70472.0] 2010-10-21 09:03:52.797 (5) [main]: parseDouble->[39] 2010-10-21 09:03:52.798 (5) [main]: parseDouble<-[39.0] 2010-10-21 09:03:52.799 (5) [main]: parseDouble->[1.0] 2010-10-21 09:03:52.800 (5) [main]: parseDouble<-[1.0] 2010-10-21 09:03:52.800 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:52.801 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:52.802 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:52.802 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:52.803 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:52.804 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:52.804 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:52.805 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:52.805 (5) [main]: parseDouble->[70472.0] 2010-10-21 09:03:52.806 (5) [main]: parseDouble<-[70472.0] 2010-10-21 09:03:52.806 (5) [main]: parseDouble->[39.0] 2010-10-21 09:03:52.807 (5) [main]: parseDouble<-[39.0] 2010-10-21 09:03:52.900 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:52.900 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:52.901 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:52.902 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:52.903 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB23405110017] Creative Key[null] Date key[2010-08-10 00:00] Cost Key[0.0] Count key[1.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 70472] seClicks[39] seAvgPos: 0.0 2010-10-21 09:03:52.904 (4) [main]: Publisher conversion object created for [FB23405110017], product= null for 2010-08-10 00:00 with account id 17 2010-10-21 09:03:52.905 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:52.907 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.908 (4) [main]: spike: SQL->[select id from `campaigns` where ((`description`="Test Camapign") and (`accountID`=17)) limit 1] 2010-10-21 09:03:52.912 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-21 09:03:52.912 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:52.913 (4) [main]: time=0.0040 2010-10-21 09:03:52.914 (4) [main]: Query executed in 0.004s 2010-10-21 09:03:52.915 (4) [main]: in getPublisherCampaign()... CampaignID[431] 2010-10-21 09:03:52.916 (4) [main]: -- refcd: FB23405110017, keyword: Class of 80s - 80 color - 6/18 Expand test12 2010-10-21 09:03:52.917 (5) [main]: parseInteger->[177] 2010-10-21 09:03:52.917 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:52.930 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-21 09:03:52.956 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:52.956 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:52.957 (4) [main]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineClass`!=""))] 2010-10-21 09:03:52.960 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:52.961 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:52.962 (4) [main]: time=0.0030 2010-10-21 09:03:52.962 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:52.964 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:52.978 (5) [main]: parseInteger->[17] 2010-10-21 09:03:52.979 (5) [main]: parseInteger<-[17] 2010-10-21 09:03:52.980 (5) [main]: parseInteger->[177] 2010-10-21 09:03:52.980 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:52.981 (5) [main]: parseInteger->[1] 2010-10-21 09:03:52.982 (5) [main]: parseInteger<-[1] 2010-10-21 09:03:52.984 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:52.985 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:52.986 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-21 09:03:53.031 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.032 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="fb23405110017"))) and (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12")))) order by `sources`.`id`] 2010-10-21 09:03:53.078 (5) [main]: recordAsSubs("db", 46, "main") 2010-10-21 09:03:53.118 (5) [main]: ProfilerRec.end("db", true): ret=46 2010-10-21 09:03:53.142 (4) [main]: time=0.046 2010-10-21 09:03:53.142 (4) [main]: Query executed in 0.046s 2010-10-21 09:03:53.143 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.144 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="fb23405110017") or (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 80 color - 6/18 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_80_color_-_6/18_expand_test12")))))))) order by `sources`.`id`] 2010-10-21 09:03:53.151 (5) [main]: recordAsSubs("db", 7, "main") 2010-10-21 09:03:53.152 (5) [main]: ProfilerRec.end("db", true): ret=7 2010-10-21 09:03:53.153 (4) [main]: time=0.0070 2010-10-21 09:03:53.153 (4) [main]: Query executed in 0.007s 2010-10-21 09:03:53.154 (4) [main]: Unable to find source for keyword "class of 80s - 80 color - 6/18 expand test12", altkey "fb23405110017", identifier "null" (match type: null) 2010-10-21 09:03:53.155 (5) [main]: parseInteger->[17] 2010-10-21 09:03:53.155 (5) [main]: parseInteger<-[17] 2010-10-21 09:03:53.156 (5) [main]: parseInteger->[177] 2010-10-21 09:03:53.156 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:53.157 (5) [main]: parseInteger->[1] 2010-10-21 09:03:53.157 (5) [main]: parseInteger<-[1] 2010-10-21 09:03:53.158 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:53.159 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:53.159 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-21 09:03:53.162 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.163 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="17_fb_0f91d0bbfe289e715e81dfc0b3fd3001"))) and (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12")))) order by `sources`.`id`] 2010-10-21 09:03:53.169 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-21 09:03:53.170 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:53.170 (4) [main]: time=0.0060 2010-10-21 09:03:53.171 (4) [main]: Query executed in 0.006s 2010-10-21 09:03:53.172 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.172 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="17_fb_0f91d0bbfe289e715e81dfc0b3fd3001") or (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 80 color - 6/18 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_80_color_-_6/18_expand_test12")))))))) order by `sources`.`id`] 2010-10-21 09:03:53.178 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-21 09:03:53.179 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:53.179 (4) [main]: time=0.0060 2010-10-21 09:03:53.180 (4) [main]: Query executed in 0.006s 2010-10-21 09:03:53.180 (4) [main]: Unable to find source for keyword "class of 80s - 80 color - 6/18 expand test12", altkey "17_fb_0f91d0bbfe289e715e81dfc0b3fd3001", identifier "null" (match type: null) 2010-10-21 09:03:53.181 (4) [main]: -- No source with the altKey or generated altKey -- create new 2010-10-21 09:03:53.181 (5) [main]: parseInteger->[17] 2010-10-21 09:03:53.182 (5) [main]: parseInteger<-[17] 2010-10-21 09:03:53.182 (5) [main]: parseInteger->[177] 2010-10-21 09:03:53.183 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:53.183 (5) [main]: parseInteger->[1] 2010-10-21 09:03:53.184 (5) [main]: parseInteger<-[1] 2010-10-21 09:03:53.185 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:53.540 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:53.542 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-21 09:03:53.557 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.558 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="fb23405110017"))) and (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12")))) order by `sources`.`id`] 2010-10-21 09:03:53.567 (5) [main]: recordAsSubs("db", 9, "main") 2010-10-21 09:03:53.567 (5) [main]: ProfilerRec.end("db", true): ret=9 2010-10-21 09:03:53.568 (4) [main]: time=0.0090 2010-10-21 09:03:53.569 (4) [main]: Query executed in 0.009s 2010-10-21 09:03:53.570 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.571 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="fb23405110017") or (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 80 color - 6/18 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_80_color_-_6/18_expand_test12")))))))) order by `sources`.`id`] 2010-10-21 09:03:53.577 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-21 09:03:53.578 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:53.579 (4) [main]: time=0.0060 2010-10-21 09:03:53.579 (4) [main]: Query executed in 0.006s 2010-10-21 09:03:53.580 (4) [main]: Unable to find source for keyword "class of 80s - 80 color - 6/18 expand test12", altkey "fb23405110017", identifier "null" (match type: null) 2010-10-21 09:03:53.582 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:53.583 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:53.584 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-21 09:03:53.585 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.586 (4) [main]: spike: SQL->[insert into `sources` (`accountID`,`keyword`,`distributionID`,`type`,`description`,`altKey`,`landingURL`) values (17,"class of 80s - 80 color - 6/18 expand test12",177,1,"Class of 80s - 80 color - 6/18 Expand test12","fb23405110017","")], genflags=yes 2010-10-21 09:03:53.590 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-21 09:03:53.591 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:53.592 (4) [main]: time=0.0040 2010-10-21 09:03:53.593 (4) [main]: Query executed in 0.004s, 1 row(s) affected 2010-10-21 09:03:53.594 (4) [main]: New source created for keyword "class of 80s - 80 color - 6/18 expand test12", altkey "fb23405110017", identifier "null" (match type: null) id=558001941 2010-10-21 09:03:53.596 (5) [main]: quoteValue(), nothing special about it=>[558001941], type=class java.lang.Integer 2010-10-21 09:03:53.597 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.597 (4) [main]: spike: SQL->[update `sources` set `searchEngineStatus`="ok" where (`id`=558001941) limit 1], genflags=no 2010-10-21 09:03:53.600 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:53.600 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:53.600 (4) [main]: time=0.0030 2010-10-21 09:03:53.601 (4) [main]: Query executed in 0.003s, 1 row(s) affected 2010-10-21 09:03:53.601 (4) [main]: -- source updated successfully 2010-10-21 09:03:53.602 (4) [main]: in getSource()... source is Data= accountID [class java.lang.Integer] => 17 keyword [class com.carldunham.jst.db.SQLLiteral] => class of 80s - 80 color - 6/18 expand test12 searchEngineStatus [class com.thesearchagency.db.SourceTable$SearchEngineStatusValue] => ok distributionID [class java.lang.Integer] => 177 type [class java.lang.Integer] => 1 description [class com.carldunham.jst.db.SQLLiteral] => Class of 80s - 80 color - 6/18 Expand test12 altKey [class com.carldunham.jst.db.SQLLiteral] => fb23405110017 landingURL [class com.carldunham.jst.db.SQLLiteral] => id [class java.lang.Integer] => 558001941 Modified= 2010-10-21 09:03:53.602 (5) [main]: parseInteger->[558001941] 2010-10-21 09:03:53.602 (5) [main]: parseInteger<-[558001941] 2010-10-21 09:03:53.604 (5) [main]: quoteValue(), nothing special about it=>[558001941], type=class java.lang.Integer 2010-10-21 09:03:53.604 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-21 09:03:53.605 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.605 (4) [main]: spike: SQL->[insert into `sourceBidType` (`sourceBidType`.`sourceID`,`sourceBidType`.`bidTypeID`) values (558001941,1) on duplicate key update `sourceBidType`.`bidTypeID`=1], genflags=no 2010-10-21 09:03:53.607 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-21 09:03:53.608 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:53.608 (4) [main]: time=0.0020 2010-10-21 09:03:53.608 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-21 09:03:53.609 (4) [main]: Inserted/Updated 1 row(s) in table `sourceBidType` 2010-10-21 09:03:53.609 (5) [main]: parseInteger->[177] 2010-10-21 09:03:53.609 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:53.612 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:53.612 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:53.613 (5) [main]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-21 09:03:53.613 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:53.613 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:53.614 (5) [main]: quoteValue(), nothing special about it=>[558001941], type=class java.lang.Integer 2010-10-21 09:03:53.614 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.615 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=0) and (`siteID`=35) and (`resolution`=86400) and (`startTime`="2010-08-10 00:00:00") and (`sourceID`=558001941)) limit 1] 2010-10-21 09:03:53.618 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-21 09:03:53.618 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:53.618 (4) [main]: time=0.0020 2010-10-21 09:03:53.618 (4) [main]: Query executed in 0.002s 2010-10-21 09:03:53.619 (4) [main]: Record Not Found 2010-10-21 09:03:53.619 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:53.619 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:53.620 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:53.629 (5) [main]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-21 09:03:53.630 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:53.630 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:53.631 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:53.631 (5) [main]: quoteValue(), nothing special about it=>[558001941], type=class java.lang.Integer 2010-10-21 09:03:53.631 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.632 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`startTime`,`count`,`sourceID`) values (17,0.0,177,0,35,86400,"2010-08-10 00:00:00",0.0,558001941)], genflags=yes 2010-10-21 09:03:53.634 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-21 09:03:53.634 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:53.635 (4) [main]: time=0.0020 2010-10-21 09:03:53.635 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-21 09:03:53.635 (4) [main]: saved publisher product summary for source [558001941] count(seConv) = 0.0 value(seValue) = 0.0 2010-10-21 09:03:53.636 (5) [main]: parseInteger->[177] 2010-10-21 09:03:53.636 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:53.655 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:53.656 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:53.657 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:53.658 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:53.660 (5) [main]: quoteValue(), nothing special about it=>[558001941], type=class java.lang.Integer 2010-10-21 09:03:53.661 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.662 (4) [main]: spike: SQL->[select * from `publisherActivitySummary` where ((`accountID`=17) and (`distributionID`=177) and (`siteID`=35) and (`resolution`=86400) and (`startTime`="2010-08-10 00:00:00") and (`sourceID`=558001941)) limit 1] 2010-10-21 09:03:53.666 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-21 09:03:53.666 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:53.667 (4) [main]: time=0.0040 2010-10-21 09:03:53.668 (4) [main]: Query executed in 0.004s 2010-10-21 09:03:53.669 (4) [main]: Record Not Found 2010-10-21 09:03:53.670 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:53.671 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:53.672 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:53.673 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:53.674 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:53.675 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:53.676 (5) [main]: quoteValue(), nothing special about it=>[39.0], type=class java.lang.Double 2010-10-21 09:03:53.677 (5) [main]: quoteValue(), nothing special about it=>[558001941], type=class java.lang.Integer 2010-10-21 09:03:53.678 (5) [main]: quoteValue(), nothing special about it=>[70472], type=class java.lang.Integer 2010-10-21 09:03:53.679 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:53.679 (4) [main]: spike: SQL->[replace into `publisherActivitySummary` (`accountID`,`distributionID`,`avgPosition`,`siteID`,`resolution`,`cost`,`startTime`,`count`,`sourceID`,`impressions`) values (17,177,0.0,35,86400,0.0,"2010-08-10 00:00:00",39.0,558001941,70472)], genflags=yes 2010-10-21 09:03:53.682 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:53.683 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:53.684 (4) [main]: time=0.0030 2010-10-21 09:03:53.685 (4) [main]: Query executed in 0.003s, 1 row(s) affected 2010-10-21 09:03:53.686 (4) [main]: saved publisher activity summary for source [558001941] count = 39.0 impressions(seImps) = 70472 cost = 0.0 avgpos = 0.0 2010-10-21 09:03:53.687 (4) [main]: Checking refcd=[FB23405110017] 2010-10-21 09:03:53.743 (5) [main]: parseDouble->[25572] 2010-10-21 09:03:53.744 (5) [main]: parseDouble<-[25572.0] 2010-10-21 09:03:53.745 (5) [main]: parseDouble->[0] 2010-10-21 09:03:53.746 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:53.746 (5) [main]: parseDouble->[70472] 2010-10-21 09:03:53.747 (5) [main]: parseDouble<-[70472.0] 2010-10-21 09:03:53.748 (5) [main]: parseDouble->[39] 2010-10-21 09:03:53.748 (5) [main]: parseDouble<-[39.0] 2010-10-21 09:03:53.749 (5) [main]: parseDouble->[25572.0] 2010-10-21 09:03:53.750 (5) [main]: parseDouble<-[25572.0] 2010-10-21 09:03:53.750 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:53.751 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:53.751 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:53.752 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:53.753 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:53.753 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:53.754 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.255 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.256 (5) [main]: parseDouble->[70472.0] 2010-10-21 09:03:54.256 (5) [main]: parseDouble<-[70472.0] 2010-10-21 09:03:54.257 (5) [main]: parseDouble->[39.0] 2010-10-21 09:03:54.258 (5) [main]: parseDouble<-[39.0] 2010-10-21 09:03:54.258 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.259 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.259 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.260 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.260 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB23405110017] Creative Key[null] Date key[2010-08-10 00:00] Cost Key[0.0] Count key[25572.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 70472] seClicks[39] seAvgPos: 0.0 2010-10-21 09:03:54.261 (4) [main]: Publisher conversion object created for [FB23405110017], product= Unique Impressions - feed for 2010-08-10 00:00 with account id 17 2010-10-21 09:03:54.264 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:54.265 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:54.265 (4) [main]: spike: SQL->[select * from `products` where ((`accountID`=17) and (`productCode`="Unique Impressions - feed")) limit 1] 2010-10-21 09:03:54.269 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-21 09:03:54.270 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:54.271 (4) [main]: time=0.0040 2010-10-21 09:03:54.272 (4) [main]: Query executed in 0.004s 2010-10-21 09:03:54.274 (5) [main]: loading 15 columns from result set: 2010-10-21 09:03:54.275 (5) [main]: loaded column: products.id->66851 2010-10-21 09:03:54.276 (5) [main]: loaded column: products.productCode->Unique Impressions - feed 2010-10-21 09:03:54.278 (5) [main]: loaded column: products.accountID->17 2010-10-21 09:03:54.279 (5) [main]: loaded column: products.siteID->0 2010-10-21 09:03:54.280 (5) [main]: loaded column: products.description-> 2010-10-21 09:03:54.281 (5) [main]: loaded column: products.countConversions->false 2010-10-21 09:03:54.283 (5) [main]: loaded column: products.columnLabel->Unique Impressions - feed 2010-10-21 09:03:54.284 (5) [main]: loaded column: products.showData->true 2010-10-21 09:03:54.286 (5) [main]: loaded column: products.fractionalCount->false 2010-10-21 09:03:54.303 (5) [main]: loaded column: products.countPercent->100.0 2010-10-21 09:03:54.304 (5) [main]: loaded column: products.order->0 2010-10-21 09:03:54.305 (5) [main]: loaded column: products.isSystemProduct->false 2010-10-21 09:03:54.306 (5) [main]: loaded column: products.showConv->true 2010-10-21 09:03:54.308 (5) [main]: loaded column: products.showCost->false 2010-10-21 09:03:54.309 (5) [main]: loaded column: products.showRev->false 2010-10-21 09:03:54.310 (4) [main]: Record Loaded 2010-10-21 09:03:54.311 (5) [main]: parseInteger->[66851] 2010-10-21 09:03:54.312 (5) [main]: parseInteger<-[66851] 2010-10-21 09:03:54.313 (4) [main]: -- productCode[Unique Impressions - feed] prodID[66851] 2010-10-21 09:03:54.313 (5) [main]: parseInteger->[177] 2010-10-21 09:03:54.314 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:54.317 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:54.318 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:54.319 (5) [main]: quoteValue(), nothing special about it=>[66851], type=class java.lang.Integer 2010-10-21 09:03:54.320 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:54.320 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:54.321 (5) [main]: quoteValue(), nothing special about it=>[558001941], type=class java.lang.Integer 2010-10-21 09:03:54.322 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:54.323 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=66851) and (`siteID`=35) and (`resolution`=86400) and (`startTime`="2010-08-10 00:00:00") and (`sourceID`=558001941)) limit 1] 2010-10-21 09:03:54.326 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:54.327 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:54.328 (4) [main]: time=0.0030 2010-10-21 09:03:54.330 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:54.330 (4) [main]: Record Not Found 2010-10-21 09:03:54.332 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:54.333 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:54.334 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:54.335 (5) [main]: quoteValue(), nothing special about it=>[66851], type=class java.lang.Integer 2010-10-21 09:03:54.336 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:54.350 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:54.353 (5) [main]: quoteValue(), nothing special about it=>[25572.0], type=class java.lang.Double 2010-10-21 09:03:54.671 (5) [main]: quoteValue(), nothing special about it=>[558001941], type=class java.lang.Integer 2010-10-21 09:03:54.672 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:54.673 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`startTime`,`count`,`sourceID`) values (17,0.0,177,66851,35,86400,"2010-08-10 00:00:00",25572.0,558001941)], genflags=yes 2010-10-21 09:03:54.695 (5) [main]: recordAsSubs("db", 22, "main") 2010-10-21 09:03:54.696 (5) [main]: ProfilerRec.end("db", true): ret=22 2010-10-21 09:03:54.697 (4) [main]: time=0.022 2010-10-21 09:03:54.698 (4) [main]: Query executed in 0.022s, 1 row(s) affected 2010-10-21 09:03:54.699 (4) [main]: saved publisher product summary for source [558001941] count(seConv) = 25572.0 value(seValue) = 0.0 2010-10-21 09:03:54.700 (4) [main]: Checking refcd=[FB23405110017] 2010-10-21 09:03:54.703 (5) [main]: parseDouble->[39] 2010-10-21 09:03:54.704 (5) [main]: parseDouble<-[39.0] 2010-10-21 09:03:54.705 (5) [main]: parseDouble->[0] 2010-10-21 09:03:54.706 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.707 (5) [main]: parseDouble->[70472] 2010-10-21 09:03:54.708 (5) [main]: parseDouble<-[70472.0] 2010-10-21 09:03:54.709 (5) [main]: parseDouble->[39] 2010-10-21 09:03:54.710 (5) [main]: parseDouble<-[39.0] 2010-10-21 09:03:54.711 (5) [main]: parseDouble->[39.0] 2010-10-21 09:03:54.711 (5) [main]: parseDouble<-[39.0] 2010-10-21 09:03:54.712 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.713 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.714 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.715 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.716 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.716 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.717 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.722 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.722 (5) [main]: parseDouble->[70472.0] 2010-10-21 09:03:54.723 (5) [main]: parseDouble<-[70472.0] 2010-10-21 09:03:54.723 (5) [main]: parseDouble->[39.0] 2010-10-21 09:03:54.725 (5) [main]: parseDouble<-[39.0] 2010-10-21 09:03:54.725 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.726 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.726 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.727 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.733 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB23405110017] Creative Key[null] Date key[2010-08-10 00:00] Cost Key[0.0] Count key[39.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 70472] seClicks[39] seAvgPos: 0.0 2010-10-21 09:03:54.735 (4) [main]: Publisher conversion object created for [FB23405110017], product= Unique Clicks - feed for 2010-08-10 00:00 with account id 17 2010-10-21 09:03:54.735 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:54.736 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:54.737 (4) [main]: spike: SQL->[select * from `products` where ((`accountID`=17) and (`productCode`="Unique Clicks - feed")) limit 1] 2010-10-21 09:03:54.755 (5) [main]: recordAsSubs("db", 18, "main") 2010-10-21 09:03:54.756 (5) [main]: ProfilerRec.end("db", true): ret=18 2010-10-21 09:03:54.757 (4) [main]: time=0.018 2010-10-21 09:03:54.757 (4) [main]: Query executed in 0.018s 2010-10-21 09:03:54.759 (5) [main]: loading 15 columns from result set: 2010-10-21 09:03:54.760 (5) [main]: loaded column: products.id->66861 2010-10-21 09:03:54.761 (5) [main]: loaded column: products.productCode->Unique Clicks - feed 2010-10-21 09:03:54.763 (5) [main]: loaded column: products.accountID->17 2010-10-21 09:03:54.764 (5) [main]: loaded column: products.siteID->0 2010-10-21 09:03:54.765 (5) [main]: loaded column: products.description-> 2010-10-21 09:03:54.766 (5) [main]: loaded column: products.countConversions->false 2010-10-21 09:03:54.767 (5) [main]: loaded column: products.columnLabel->Unique Clicks - feed 2010-10-21 09:03:54.769 (5) [main]: loaded column: products.showData->true 2010-10-21 09:03:54.770 (5) [main]: loaded column: products.fractionalCount->false 2010-10-21 09:03:54.771 (5) [main]: loaded column: products.countPercent->100.0 2010-10-21 09:03:54.773 (5) [main]: loaded column: products.order->0 2010-10-21 09:03:54.774 (5) [main]: loaded column: products.isSystemProduct->false 2010-10-21 09:03:54.775 (5) [main]: loaded column: products.showConv->true 2010-10-21 09:03:54.776 (5) [main]: loaded column: products.showCost->false 2010-10-21 09:03:54.777 (5) [main]: loaded column: products.showRev->false 2010-10-21 09:03:54.778 (4) [main]: Record Loaded 2010-10-21 09:03:54.779 (5) [main]: parseInteger->[66861] 2010-10-21 09:03:54.779 (5) [main]: parseInteger<-[66861] 2010-10-21 09:03:54.780 (4) [main]: -- productCode[Unique Clicks - feed] prodID[66861] 2010-10-21 09:03:54.781 (5) [main]: parseInteger->[177] 2010-10-21 09:03:54.782 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:54.784 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:54.785 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:54.786 (5) [main]: quoteValue(), nothing special about it=>[66861], type=class java.lang.Integer 2010-10-21 09:03:54.786 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:54.787 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:54.788 (5) [main]: quoteValue(), nothing special about it=>[558001941], type=class java.lang.Integer 2010-10-21 09:03:54.789 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:54.790 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=66861) and (`siteID`=35) and (`resolution`=86400) and (`startTime`="2010-08-10 00:00:00") and (`sourceID`=558001941)) limit 1] 2010-10-21 09:03:54.794 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-21 09:03:54.795 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:54.796 (4) [main]: time=0.0040 2010-10-21 09:03:54.796 (4) [main]: Query executed in 0.004s 2010-10-21 09:03:54.797 (4) [main]: Record Not Found 2010-10-21 09:03:54.798 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:54.798 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:54.799 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:54.800 (5) [main]: quoteValue(), nothing special about it=>[66861], type=class java.lang.Integer 2010-10-21 09:03:54.800 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:54.801 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:54.802 (5) [main]: quoteValue(), nothing special about it=>[39.0], type=class java.lang.Double 2010-10-21 09:03:54.803 (5) [main]: quoteValue(), nothing special about it=>[558001941], type=class java.lang.Integer 2010-10-21 09:03:54.804 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:54.805 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`startTime`,`count`,`sourceID`) values (17,0.0,177,66861,35,86400,"2010-08-10 00:00:00",39.0,558001941)], genflags=yes 2010-10-21 09:03:54.808 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:54.808 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:54.809 (4) [main]: time=0.0030 2010-10-21 09:03:54.810 (4) [main]: Query executed in 0.003s, 1 row(s) affected 2010-10-21 09:03:54.811 (4) [main]: saved publisher product summary for source [558001941] count(seConv) = 39.0 value(seValue) = 0.0 2010-10-21 09:03:54.817 (5) [main]: parseDouble->[0] 2010-10-21 09:03:54.818 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.819 (5) [main]: parseDouble->[32449] 2010-10-21 09:03:54.820 (5) [main]: parseDouble<-[32449.0] 2010-10-21 09:03:54.820 (5) [main]: parseDouble->[16] 2010-10-21 09:03:54.821 (5) [main]: parseDouble<-[16.0] 2010-10-21 09:03:54.822 (5) [main]: parseDouble->[1.0] 2010-10-21 09:03:54.823 (5) [main]: parseDouble<-[1.0] 2010-10-21 09:03:54.824 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.824 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.825 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.826 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.827 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.827 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.828 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.829 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.829 (5) [main]: parseDouble->[32449.0] 2010-10-21 09:03:54.830 (5) [main]: parseDouble<-[32449.0] 2010-10-21 09:03:54.831 (5) [main]: parseDouble->[16.0] 2010-10-21 09:03:54.831 (5) [main]: parseDouble<-[16.0] 2010-10-21 09:03:54.832 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.833 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.834 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:54.834 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:54.835 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB23405110018] Creative Key[null] Date key[2010-08-10 00:00] Cost Key[0.0] Count key[1.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 32449] seClicks[16] seAvgPos: 0.0 2010-10-21 09:03:54.836 (4) [main]: Publisher conversion object created for [FB23405110018], product= null for 2010-08-10 00:00 with account id 17 2010-10-21 09:03:54.837 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:54.903 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:54.904 (4) [main]: spike: SQL->[select id from `campaigns` where ((`description`="Test Camapign") and (`accountID`=17)) limit 1] 2010-10-21 09:03:54.906 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-21 09:03:54.907 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:54.908 (4) [main]: time=0.0020 2010-10-21 09:03:54.909 (4) [main]: Query executed in 0.002s 2010-10-21 09:03:54.910 (4) [main]: in getPublisherCampaign()... CampaignID[431] 2010-10-21 09:03:54.910 (4) [main]: -- refcd: FB23405110018, keyword: Class of 80s - 81 Metro - 7/12 Expand test12 2010-10-21 09:03:54.911 (5) [main]: parseInteger->[177] 2010-10-21 09:03:54.912 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:54.913 (5) [main]: parseInteger->[17] 2010-10-21 09:03:54.913 (5) [main]: parseInteger<-[17] 2010-10-21 09:03:54.914 (5) [main]: parseInteger->[177] 2010-10-21 09:03:54.915 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:54.915 (5) [main]: parseInteger->[1] 2010-10-21 09:03:54.916 (5) [main]: parseInteger<-[1] 2010-10-21 09:03:54.917 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:54.918 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:54.919 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-21 09:03:54.921 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:54.922 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="fb23405110018"))) and (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12")))) order by `sources`.`id`] 2010-10-21 09:03:54.928 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-21 09:03:54.929 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:54.930 (4) [main]: time=0.0060 2010-10-21 09:03:54.930 (4) [main]: Query executed in 0.006s 2010-10-21 09:03:54.931 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:54.932 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="fb23405110018") or (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 81 metro - 7/12 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_81_metro_-_7/12_expand_test12")))))))) order by `sources`.`id`] 2010-10-21 09:03:54.938 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-21 09:03:54.939 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:54.940 (4) [main]: time=0.0060 2010-10-21 09:03:54.940 (4) [main]: Query executed in 0.006s 2010-10-21 09:03:54.941 (4) [main]: Unable to find source for keyword "class of 80s - 81 metro - 7/12 expand test12", altkey "fb23405110018", identifier "null" (match type: null) 2010-10-21 09:03:54.941 (5) [main]: parseInteger->[17] 2010-10-21 09:03:55.518 (5) [main]: parseInteger<-[17] 2010-10-21 09:03:55.519 (5) [main]: parseInteger->[177] 2010-10-21 09:03:55.521 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:55.522 (5) [main]: parseInteger->[1] 2010-10-21 09:03:55.523 (5) [main]: parseInteger<-[1] 2010-10-21 09:03:55.523 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.524 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.525 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-21 09:03:55.528 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.528 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="17_fb_5a65d275fe20c1a6abf420edbcf753a3"))) and (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12")))) order by `sources`.`id`] 2010-10-21 09:03:55.535 (5) [main]: recordAsSubs("db", 7, "main") 2010-10-21 09:03:55.535 (5) [main]: ProfilerRec.end("db", true): ret=7 2010-10-21 09:03:55.536 (4) [main]: time=0.0070 2010-10-21 09:03:55.537 (4) [main]: Query executed in 0.007s 2010-10-21 09:03:55.553 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.554 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="17_fb_5a65d275fe20c1a6abf420edbcf753a3") or (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 81 metro - 7/12 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_81_metro_-_7/12_expand_test12")))))))) order by `sources`.`id`] 2010-10-21 09:03:55.560 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-21 09:03:55.560 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:55.561 (4) [main]: time=0.0060 2010-10-21 09:03:55.561 (4) [main]: Query executed in 0.006s 2010-10-21 09:03:55.561 (4) [main]: Unable to find source for keyword "class of 80s - 81 metro - 7/12 expand test12", altkey "17_fb_5a65d275fe20c1a6abf420edbcf753a3", identifier "null" (match type: null) 2010-10-21 09:03:55.562 (4) [main]: -- No source with the altKey or generated altKey -- create new 2010-10-21 09:03:55.562 (5) [main]: parseInteger->[17] 2010-10-21 09:03:55.562 (5) [main]: parseInteger<-[17] 2010-10-21 09:03:55.562 (5) [main]: parseInteger->[177] 2010-10-21 09:03:55.562 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:55.563 (5) [main]: parseInteger->[1] 2010-10-21 09:03:55.563 (5) [main]: parseInteger<-[1] 2010-10-21 09:03:55.563 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.564 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.564 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-21 09:03:55.566 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.567 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="fb23405110018"))) and (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12")))) order by `sources`.`id`] 2010-10-21 09:03:55.572 (5) [main]: recordAsSubs("db", 5, "main") 2010-10-21 09:03:55.572 (5) [main]: ProfilerRec.end("db", true): ret=5 2010-10-21 09:03:55.572 (4) [main]: time=0.0050 2010-10-21 09:03:55.573 (4) [main]: Query executed in 0.005s 2010-10-21 09:03:55.573 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.573 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="fb23405110018") or (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 81 metro - 7/12 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_81_metro_-_7/12_expand_test12")))))))) order by `sources`.`id`] 2010-10-21 09:03:55.579 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-21 09:03:55.579 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:55.579 (4) [main]: time=0.0060 2010-10-21 09:03:55.580 (4) [main]: Query executed in 0.006s 2010-10-21 09:03:55.580 (4) [main]: Unable to find source for keyword "class of 80s - 81 metro - 7/12 expand test12", altkey "fb23405110018", identifier "null" (match type: null) 2010-10-21 09:03:55.581 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.581 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.582 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-21 09:03:55.582 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.582 (4) [main]: spike: SQL->[insert into `sources` (`accountID`,`keyword`,`distributionID`,`type`,`description`,`altKey`,`landingURL`) values (17,"class of 80s - 81 metro - 7/12 expand test12",177,1,"Class of 80s - 81 Metro - 7/12 Expand test12","fb23405110018","")], genflags=yes 2010-10-21 09:03:55.585 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:55.585 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:55.585 (4) [main]: time=0.0030 2010-10-21 09:03:55.586 (4) [main]: Query executed in 0.003s, 1 row(s) affected 2010-10-21 09:03:55.586 (4) [main]: New source created for keyword "class of 80s - 81 metro - 7/12 expand test12", altkey "fb23405110018", identifier "null" (match type: null) id=558001951 2010-10-21 09:03:55.587 (5) [main]: quoteValue(), nothing special about it=>[558001951], type=class java.lang.Integer 2010-10-21 09:03:55.588 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.588 (4) [main]: spike: SQL->[update `sources` set `searchEngineStatus`="ok" where (`id`=558001951) limit 1], genflags=no 2010-10-21 09:03:55.591 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:55.591 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:55.591 (4) [main]: time=0.0030 2010-10-21 09:03:55.591 (4) [main]: Query executed in 0.003s, 1 row(s) affected 2010-10-21 09:03:55.592 (4) [main]: -- source updated successfully 2010-10-21 09:03:55.592 (4) [main]: in getSource()... source is Data= accountID [class java.lang.Integer] => 17 keyword [class com.carldunham.jst.db.SQLLiteral] => class of 80s - 81 metro - 7/12 expand test12 searchEngineStatus [class com.thesearchagency.db.SourceTable$SearchEngineStatusValue] => ok distributionID [class java.lang.Integer] => 177 type [class java.lang.Integer] => 1 description [class com.carldunham.jst.db.SQLLiteral] => Class of 80s - 81 Metro - 7/12 Expand test12 altKey [class com.carldunham.jst.db.SQLLiteral] => fb23405110018 landingURL [class com.carldunham.jst.db.SQLLiteral] => id [class java.lang.Integer] => 558001951 Modified= 2010-10-21 09:03:55.593 (5) [main]: parseInteger->[558001951] 2010-10-21 09:03:55.593 (5) [main]: parseInteger<-[558001951] 2010-10-21 09:03:55.594 (5) [main]: quoteValue(), nothing special about it=>[558001951], type=class java.lang.Integer 2010-10-21 09:03:55.594 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-21 09:03:55.594 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.595 (4) [main]: spike: SQL->[insert into `sourceBidType` (`sourceBidType`.`sourceID`,`sourceBidType`.`bidTypeID`) values (558001951,1) on duplicate key update `sourceBidType`.`bidTypeID`=1], genflags=no 2010-10-21 09:03:55.597 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:55.597 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:55.598 (4) [main]: time=0.0030 2010-10-21 09:03:55.599 (4) [main]: Query executed in 0.003s, 1 row(s) affected 2010-10-21 09:03:55.600 (4) [main]: Inserted/Updated 1 row(s) in table `sourceBidType` 2010-10-21 09:03:55.601 (5) [main]: parseInteger->[177] 2010-10-21 09:03:55.602 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:55.603 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.604 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.605 (5) [main]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-21 09:03:55.606 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:55.606 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:55.621 (5) [main]: quoteValue(), nothing special about it=>[558001951], type=class java.lang.Integer 2010-10-21 09:03:55.622 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.622 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=0) and (`siteID`=35) and (`resolution`=86400) and (`startTime`="2010-08-10 00:00:00") and (`sourceID`=558001951)) limit 1] 2010-10-21 09:03:55.625 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:55.626 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:55.627 (4) [main]: time=0.0030 2010-10-21 09:03:55.628 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:55.628 (4) [main]: Record Not Found 2010-10-21 09:03:55.629 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.630 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:55.630 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.631 (5) [main]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-21 09:03:55.632 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:55.632 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:55.633 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:55.634 (5) [main]: quoteValue(), nothing special about it=>[558001951], type=class java.lang.Integer 2010-10-21 09:03:55.635 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.635 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`startTime`,`count`,`sourceID`) values (17,0.0,177,0,35,86400,"2010-08-10 00:00:00",0.0,558001951)], genflags=yes 2010-10-21 09:03:55.638 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:55.638 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:55.639 (4) [main]: time=0.0030 2010-10-21 09:03:55.640 (4) [main]: Query executed in 0.003s, 1 row(s) affected 2010-10-21 09:03:55.640 (4) [main]: saved publisher product summary for source [558001951] count(seConv) = 0.0 value(seValue) = 0.0 2010-10-21 09:03:55.641 (5) [main]: parseInteger->[177] 2010-10-21 09:03:55.642 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:55.644 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.645 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.646 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:55.646 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:55.647 (5) [main]: quoteValue(), nothing special about it=>[558001951], type=class java.lang.Integer 2010-10-21 09:03:55.648 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.648 (4) [main]: spike: SQL->[select * from `publisherActivitySummary` where ((`accountID`=17) and (`distributionID`=177) and (`siteID`=35) and (`resolution`=86400) and (`startTime`="2010-08-10 00:00:00") and (`sourceID`=558001951)) limit 1] 2010-10-21 09:03:55.652 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-21 09:03:55.652 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:55.653 (4) [main]: time=0.0040 2010-10-21 09:03:55.654 (4) [main]: Query executed in 0.004s 2010-10-21 09:03:55.654 (4) [main]: Record Not Found 2010-10-21 09:03:55.655 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.656 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.656 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:55.657 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:55.657 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:55.658 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:55.659 (5) [main]: quoteValue(), nothing special about it=>[16.0], type=class java.lang.Double 2010-10-21 09:03:55.659 (5) [main]: quoteValue(), nothing special about it=>[558001951], type=class java.lang.Integer 2010-10-21 09:03:55.660 (5) [main]: quoteValue(), nothing special about it=>[32449], type=class java.lang.Integer 2010-10-21 09:03:55.660 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.661 (4) [main]: spike: SQL->[replace into `publisherActivitySummary` (`accountID`,`distributionID`,`avgPosition`,`siteID`,`resolution`,`cost`,`startTime`,`count`,`sourceID`,`impressions`) values (17,177,0.0,35,86400,0.0,"2010-08-10 00:00:00",16.0,558001951,32449)], genflags=yes 2010-10-21 09:03:55.663 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-21 09:03:55.664 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:55.664 (4) [main]: time=0.0020 2010-10-21 09:03:55.665 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-21 09:03:55.666 (4) [main]: saved publisher activity summary for source [558001951] count = 16.0 impressions(seImps) = 32449 cost = 0.0 avgpos = 0.0 2010-10-21 09:03:55.667 (4) [main]: Checking refcd=[FB23405110018] 2010-10-21 09:03:55.669 (5) [main]: parseDouble->[12745] 2010-10-21 09:03:55.669 (5) [main]: parseDouble<-[12745.0] 2010-10-21 09:03:55.670 (5) [main]: parseDouble->[0] 2010-10-21 09:03:55.671 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.671 (5) [main]: parseDouble->[32449] 2010-10-21 09:03:55.672 (5) [main]: parseDouble<-[32449.0] 2010-10-21 09:03:55.672 (5) [main]: parseDouble->[16] 2010-10-21 09:03:55.673 (5) [main]: parseDouble<-[16.0] 2010-10-21 09:03:55.674 (5) [main]: parseDouble->[12745.0] 2010-10-21 09:03:55.674 (5) [main]: parseDouble<-[12745.0] 2010-10-21 09:03:55.675 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.675 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.676 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.676 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.677 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.677 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.678 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.678 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.679 (5) [main]: parseDouble->[32449.0] 2010-10-21 09:03:55.679 (5) [main]: parseDouble<-[32449.0] 2010-10-21 09:03:55.680 (5) [main]: parseDouble->[16.0] 2010-10-21 09:03:55.680 (5) [main]: parseDouble<-[16.0] 2010-10-21 09:03:55.681 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.681 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.682 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.682 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.683 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB23405110018] Creative Key[null] Date key[2010-08-10 00:00] Cost Key[0.0] Count key[12745.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 32449] seClicks[16] seAvgPos: 0.0 2010-10-21 09:03:55.683 (4) [main]: Publisher conversion object created for [FB23405110018], product= Unique Impressions - feed for 2010-08-10 00:00 with account id 17 2010-10-21 09:03:55.684 (5) [main]: parseInteger->[66851] 2010-10-21 09:03:55.685 (5) [main]: parseInteger<-[66851] 2010-10-21 09:03:55.685 (4) [main]: -- productCode[Unique Impressions - feed] prodID[66851] 2010-10-21 09:03:55.686 (5) [main]: parseInteger->[177] 2010-10-21 09:03:55.686 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:55.687 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.688 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.689 (5) [main]: quoteValue(), nothing special about it=>[66851], type=class java.lang.Integer 2010-10-21 09:03:55.689 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:55.690 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:55.691 (5) [main]: quoteValue(), nothing special about it=>[558001951], type=class java.lang.Integer 2010-10-21 09:03:55.691 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.692 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=66851) and (`siteID`=35) and (`resolution`=86400) and (`startTime`="2010-08-10 00:00:00") and (`sourceID`=558001951)) limit 1] 2010-10-21 09:03:55.695 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:55.696 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:55.696 (4) [main]: time=0.0030 2010-10-21 09:03:55.697 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:55.697 (4) [main]: Record Not Found 2010-10-21 09:03:55.698 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.699 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:55.699 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.700 (5) [main]: quoteValue(), nothing special about it=>[66851], type=class java.lang.Integer 2010-10-21 09:03:55.700 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:55.700 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:55.701 (5) [main]: quoteValue(), nothing special about it=>[12745.0], type=class java.lang.Double 2010-10-21 09:03:55.704 (5) [main]: quoteValue(), nothing special about it=>[558001951], type=class java.lang.Integer 2010-10-21 09:03:55.704 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.705 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`startTime`,`count`,`sourceID`) values (17,0.0,177,66851,35,86400,"2010-08-10 00:00:00",12745.0,558001951)], genflags=yes 2010-10-21 09:03:55.707 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-21 09:03:55.708 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:55.708 (4) [main]: time=0.0020 2010-10-21 09:03:55.709 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-21 09:03:55.709 (4) [main]: saved publisher product summary for source [558001951] count(seConv) = 12745.0 value(seValue) = 0.0 2010-10-21 09:03:55.710 (4) [main]: Checking refcd=[FB23405110018] 2010-10-21 09:03:55.712 (5) [main]: parseDouble->[16] 2010-10-21 09:03:55.713 (5) [main]: parseDouble<-[16.0] 2010-10-21 09:03:55.713 (5) [main]: parseDouble->[0] 2010-10-21 09:03:55.714 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.714 (5) [main]: parseDouble->[32449] 2010-10-21 09:03:55.715 (5) [main]: parseDouble<-[32449.0] 2010-10-21 09:03:55.715 (5) [main]: parseDouble->[16] 2010-10-21 09:03:55.716 (5) [main]: parseDouble<-[16.0] 2010-10-21 09:03:55.716 (5) [main]: parseDouble->[16.0] 2010-10-21 09:03:55.717 (5) [main]: parseDouble<-[16.0] 2010-10-21 09:03:55.717 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.721 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.722 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.722 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.723 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.723 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.723 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.725 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.725 (5) [main]: parseDouble->[32449.0] 2010-10-21 09:03:55.725 (5) [main]: parseDouble<-[32449.0] 2010-10-21 09:03:55.726 (5) [main]: parseDouble->[16.0] 2010-10-21 09:03:55.726 (5) [main]: parseDouble<-[16.0] 2010-10-21 09:03:55.727 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.727 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.727 (5) [main]: parseDouble->[0.0] 2010-10-21 09:03:55.728 (5) [main]: parseDouble<-[0.0] 2010-10-21 09:03:55.728 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB23405110018] Creative Key[null] Date key[2010-08-10 00:00] Cost Key[0.0] Count key[16.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 32449] seClicks[16] seAvgPos: 0.0 2010-10-21 09:03:55.729 (4) [main]: Publisher conversion object created for [FB23405110018], product= Unique Clicks - feed for 2010-08-10 00:00 with account id 17 2010-10-21 09:03:55.729 (5) [main]: parseInteger->[66861] 2010-10-21 09:03:55.730 (5) [main]: parseInteger<-[66861] 2010-10-21 09:03:55.730 (4) [main]: -- productCode[Unique Clicks - feed] prodID[66861] 2010-10-21 09:03:55.730 (5) [main]: parseInteger->[177] 2010-10-21 09:03:55.731 (5) [main]: parseInteger<-[177] 2010-10-21 09:03:55.732 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.733 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.733 (5) [main]: quoteValue(), nothing special about it=>[66861], type=class java.lang.Integer 2010-10-21 09:03:55.734 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:55.734 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:55.735 (5) [main]: quoteValue(), nothing special about it=>[558001951], type=class java.lang.Integer 2010-10-21 09:03:55.735 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.736 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=66861) and (`siteID`=35) and (`resolution`=86400) and (`startTime`="2010-08-10 00:00:00") and (`sourceID`=558001951)) limit 1] 2010-10-21 09:03:55.739 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:55.740 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:55.740 (4) [main]: time=0.0030 2010-10-21 09:03:55.741 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:55.741 (4) [main]: Record Not Found 2010-10-21 09:03:55.742 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:55.743 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-21 09:03:55.744 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-21 09:03:55.744 (5) [main]: quoteValue(), nothing special about it=>[66861], type=class java.lang.Integer 2010-10-21 09:03:55.745 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-21 09:03:55.745 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:55.746 (5) [main]: quoteValue(), nothing special about it=>[16.0], type=class java.lang.Double 2010-10-21 09:03:55.747 (5) [main]: quoteValue(), nothing special about it=>[558001951], type=class java.lang.Integer 2010-10-21 09:03:55.747 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.748 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`startTime`,`count`,`sourceID`) values (17,0.0,177,66861,35,86400,"2010-08-10 00:00:00",16.0,558001951)], genflags=yes 2010-10-21 09:03:55.759 (5) [main]: recordAsSubs("db", 11, "main") 2010-10-21 09:03:55.759 (5) [main]: ProfilerRec.end("db", true): ret=11 2010-10-21 09:03:55.760 (4) [main]: time=0.011 2010-10-21 09:03:55.760 (4) [main]: Query executed in 0.011s, 1 row(s) affected 2010-10-21 09:03:55.761 (4) [main]: saved publisher product summary for source [558001951] count(seConv) = 16.0 value(seValue) = 0.0 2010-10-21 09:03:55.763 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.764 (4) [main]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="223001") and (`date`="2010-10-19 03:00:00")) limit 1] 2010-10-21 09:03:55.767 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:55.774 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:55.775 (4) [main]: time=0.0030 2010-10-21 09:03:55.776 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:55.777 (4) [main]: Record Not Found 2010-10-21 09:03:55.778 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.779 (4) [main]: spike: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-19 03:00:00","2010-10-21 09:03:55")], genflags=yes 2010-10-21 09:03:55.782 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-19 03:00:00","2010-10-21 09:03:55")] executed by user [spike] 2010-10-21 09:03:55.784 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-21 09:03:55.785 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-21 09:03:55.785 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:55.786 (4) [main]: time=0.0060 2010-10-21 09:03:55.786 (4) [main]: Query executed in 0.006s, 1 row(s) affected 2010-10-21 09:03:55.788 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.789 (4) [main]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-19 03:00:00","2010-10-21 09:03:55")], genflags=yes 2010-10-21 09:03:55.792 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-19 03:00:00","2010-10-21 09:03:55")] executed by user [spike] 2010-10-21 09:03:55.793 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-21 09:03:55.794 (5) [main]: recordAsSubs("db", 5, "main") 2010-10-21 09:03:55.794 (5) [main]: ProfilerRec.end("db", true): ret=5 2010-10-21 09:03:55.795 (4) [main]: time=0.0050 2010-10-21 09:03:55.796 (4) [main]: Query executed in 0.005s, 1 row(s) affected 2010-10-21 09:03:55.797 (3) [main]: calling warehouse summarization with args: --debug 5 --accountid 17 --distribution 177 --date 2010-08-10 --publisher 2010-10-21 09:03:55.807 (3) [main]: Debug Level set to 5 2010-10-21 09:03:55.808 (4) [main]: limited to Distribution(s) (177) 2010-10-21 09:03:55.809 (2) [main]: No granularity given, all 2010-10-21 09:03:55.811 (3) [main]: =============== Starting Warehouse Summarizer ================ 2010-10-21 09:03:55.811 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-21 09:03:55.812 (3) [main]: ----------------Warehouse Summarizer starting 2010-10-21 09:03:55.933 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:55.935 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:55.936 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (17))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc] 2010-10-21 09:03:55.939 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:55.939 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:55.940 (4) [main]: time=0.0030 2010-10-21 09:03:55.941 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:55.942 (5) [main]: loading 19 columns from result set: 2010-10-21 09:03:55.942 (5) [main]: loaded column: accounts.id->17 2010-10-21 09:03:55.943 (5) [main]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-21 09:03:55.944 (5) [main]: loaded column: accounts.tier->2 2010-10-21 09:03:55.945 (5) [main]: loaded column: accounts.priority->60 2010-10-21 09:03:55.946 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-21 09:03:55.947 (5) [main]: loaded column: accounts.reportConversions->true 2010-10-21 09:03:55.947 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-21 09:03:55.948 (5) [main]: loaded column: accounts.isBidManaged->true 2010-10-21 09:03:55.949 (5) [main]: loaded column: accounts.isActive->true 2010-10-21 09:03:55.950 (5) [main]: loaded column: accounts.perfMetric->roi 2010-10-21 09:03:55.951 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-21 09:03:55.952 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-21 09:03:55.952 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-21 09:03:55.953 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-21 09:03:55.954 (5) [main]: loaded column: accounts.nowTime->null 2010-10-21 09:03:55.955 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-21 09:03:55.955 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-21 09:03:55.956 (5) [main]: loaded column: accounts.warehouseInstance->1 2010-10-21 09:03:55.957 (5) [main]: loaded column: accounts.isOnline->true 2010-10-21 09:03:55.958 (4) [main]: DataCache: put key dwh 17 2010-10-21 09:03:55.958 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-21 09:03:56.023 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:56.603 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-21 09:03:56.604 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="dwh-1")) limit 1] 2010-10-21 09:03:56.607 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-21 09:03:56.607 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:56.608 (4) [main]: time=0.0030 2010-10-21 09:03:56.609 (4) [main]: Query executed in 0.003s 2010-10-21 09:03:56.609 (5) [main]: loading 8 columns from result set: 2010-10-21 09:03:56.610 (5) [main]: loaded column: databaseInstances.id->8 2010-10-21 09:03:56.611 (5) [main]: loaded column: databaseInstances.name->dwh-1 2010-10-21 09:03:56.612 (5) [main]: loaded column: databaseInstances.description->Account-specific Warehouse 01 2010-10-21 09:03:56.642 (5) [main]: loaded column: databaseInstances.type->mysql 2010-10-21 09:03:56.650 (5) [main]: loaded column: databaseInstances.database->warehouse_1 2010-10-21 09:03:56.653 (5) [main]: loaded column: databaseInstances.host->dwh-01-write 2010-10-21 09:03:56.654 (5) [main]: loaded column: databaseInstances.port->3306 2010-10-21 09:03:56.654 (5) [main]: loaded column: databaseInstances.access->rw 2010-10-21 09:03:56.655 (4) [main]: Record Loaded 2010-10-21 09:03:56.656 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:56.657 (4) [main]: DatabaseAccounts.getDatabaseName() returning "warehouse_1" 2010-10-21 09:03:56.692 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2010-10-21 09:03:56.693 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-21 09:03:56.748 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:56.749 (4) [P1T1]: Created new Object 2010-10-21 09:03:56.750 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.751 (4) [P1T1]: perfsum: SQL->[select @@version] 2010-10-21 09:03:56.753 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:56.754 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:56.754 (4) [P1T1]: time=0.0020 2010-10-21 09:03:56.755 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:56.756 (4) [P1T1]: test query succeeded, returned "5.0.30-enterprise-gpl" 2010-10-21 09:03:56.757 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:56.758 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.759 (4) [P1T1]: perfsum: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=17) limit 1] 2010-10-21 09:03:56.762 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:56.762 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:56.763 (4) [P1T1]: time=0.0030 2010-10-21 09:03:56.764 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:56.764 (5) [P1T1]: loading 19 columns from result set: 2010-10-21 09:03:56.765 (5) [P1T1]: loaded column: accounts.id->17 2010-10-21 09:03:56.766 (5) [P1T1]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-21 09:03:56.767 (5) [P1T1]: loaded column: accounts.tier->2 2010-10-21 09:03:56.767 (5) [P1T1]: loaded column: accounts.priority->60 2010-10-21 09:03:56.768 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2010-10-21 09:03:56.768 (5) [P1T1]: loaded column: accounts.reportConversions->true 2010-10-21 09:03:56.768 (5) [P1T1]: loaded column: accounts.conversionTypes-> 2010-10-21 09:03:56.769 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2010-10-21 09:03:56.769 (5) [P1T1]: loaded column: accounts.isActive->true 2010-10-21 09:03:56.769 (5) [P1T1]: loaded column: accounts.perfMetric->roi 2010-10-21 09:03:56.770 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2010-10-21 09:03:56.770 (5) [P1T1]: loaded column: accounts.addConversionData->false 2010-10-21 09:03:56.770 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2010-10-21 09:03:56.771 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2010-10-21 09:03:56.771 (5) [P1T1]: loaded column: accounts.nowTime->null 2010-10-21 09:03:56.771 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2010-10-21 09:03:56.771 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2010-10-21 09:03:56.772 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2010-10-21 09:03:56.772 (5) [P1T1]: loaded column: accounts.isOnline->true 2010-10-21 09:03:56.772 (4) [P1T1]: Record Loaded 2010-10-21 09:03:56.772 (4) [P1T1]: Returning Object to Pool 2010-10-21 09:03:56.773 (5) [P1T1]: yesterday: month=10, day=20, year=2010 2010-10-21 09:03:56.773 (4) [P1T1]: isYesterday = false 2010-10-21 09:03:56.774 (4) [P1T1]: DataCache: Found key acct-st-tracker 17 2010-10-21 09:03:56.774 (4) [P1T1]: DataCache: Found key acct-st-tracker-1 2010-10-21 09:03:56.774 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-21 09:03:56.808 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:56.809 (4) [P1T1]: Created new Object 2010-10-21 09:03:56.809 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.810 (4) [P1T1]: perfsum: SQL->[select @@version] 2010-10-21 09:03:56.813 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:56.814 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:56.814 (4) [P1T1]: time=0.0030 2010-10-21 09:03:56.815 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:56.816 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-21 09:03:56.816 (4) [P1T1]: DataCache: Found key dwh 17 2010-10-21 09:03:56.817 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2010-10-21 09:03:56.835 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:56.836 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.837 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="dwh-1")) limit 1] 2010-10-21 09:03:56.868 (5) [P1T1]: recordAsSubs("db", 31, "P1T1") 2010-10-21 09:03:56.869 (5) [P1T1]: ProfilerRec.end("db", true): ret=31 2010-10-21 09:03:56.870 (4) [P1T1]: time=0.031 2010-10-21 09:03:56.870 (4) [P1T1]: Query executed in 0.031s 2010-10-21 09:03:56.871 (5) [P1T1]: loading 8 columns from result set: 2010-10-21 09:03:56.872 (5) [P1T1]: loaded column: databaseInstances.id->8 2010-10-21 09:03:56.873 (5) [P1T1]: loaded column: databaseInstances.name->dwh-1 2010-10-21 09:03:56.874 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Warehouse 01 2010-10-21 09:03:56.874 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2010-10-21 09:03:56.875 (5) [P1T1]: loaded column: databaseInstances.database->warehouse_1 2010-10-21 09:03:56.876 (5) [P1T1]: loaded column: databaseInstances.host->dwh-01-write 2010-10-21 09:03:56.877 (5) [P1T1]: loaded column: databaseInstances.port->3306 2010-10-21 09:03:56.878 (5) [P1T1]: loaded column: databaseInstances.access->rw 2010-10-21 09:03:56.878 (4) [P1T1]: Record Loaded 2010-10-21 09:03:56.879 (4) [P1T1]: DataCache: put key dwh-1 2010-10-21 09:03:56.880 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:56.881 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-21 09:03:56.916 (4) [P1T1]: opened [jdbc:mysql://dwh-01-write:3306/warehouse_1?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:56.917 (4) [P1T1]: Created new Object 2010-10-21 09:03:56.917 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.918 (4) [P1T1]: perfsum: SQL->[select @@version] 2010-10-21 09:03:56.921 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:56.922 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:56.922 (4) [P1T1]: time=0.0030 2010-10-21 09:03:56.923 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:56.924 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-21 09:03:56.925 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.926 (4) [P1T1]: perfsum: SQL->[set net_read_timeout = 36000] 2010-10-21 09:03:56.928 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:56.929 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:56.929 (4) [P1T1]: time=0.0020 2010-10-21 09:03:56.930 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:56.931 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.931 (4) [P1T1]: perfsum: SQL->[set net_write_timeout = 36000] 2010-10-21 09:03:56.934 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:56.934 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:56.935 (4) [P1T1]: time=0.0030 2010-10-21 09:03:56.936 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:56.936 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.937 (4) [P1T1]: perfsum: SQL->[set net_read_timeout = 36000] 2010-10-21 09:03:56.939 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:56.940 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:56.940 (4) [P1T1]: time=0.0020 2010-10-21 09:03:56.941 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:56.941 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.942 (4) [P1T1]: perfsum: SQL->[set net_write_timeout = 36000] 2010-10-21 09:03:56.944 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:56.945 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:56.946 (4) [P1T1]: time=0.0020 2010-10-21 09:03:56.946 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:56.947 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.947 (4) [P1T1]: perfsum: SQL->[SELECT GET_LOCK('WarehouseSummarizer.syncDimensions.17', 300)] 2010-10-21 09:03:56.950 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:56.950 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:56.951 (4) [P1T1]: time=0.0030 2010-10-21 09:03:56.952 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:56.955 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:56.955 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.956 (4) [P1T1]: perfsum: SQL->[select * from `whDimensionSyncStatus` where (`accountID`=17) limit 1] 2010-10-21 09:03:56.958 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:56.959 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:56.959 (4) [P1T1]: time=0.0020 2010-10-21 09:03:56.960 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:56.961 (5) [P1T1]: loading 2 columns from result set: 2010-10-21 09:03:56.961 (5) [P1T1]: loaded column: whDimensionSyncStatus.accountID->17 2010-10-21 09:03:56.971 (5) [P1T1]: loaded column: whDimensionSyncStatus.syncTime->2010-10-21 08:14:21.0 2010-10-21 09:03:56.972 (4) [P1T1]: Record Loaded 2010-10-21 09:03:56.973 (3) [P1T1]: Skipping sync of dimensions for acct #17 (last sync was at 2010-10-21 08:14:21.0) 2010-10-21 09:03:56.973 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.974 (4) [P1T1]: perfsum: SQL->[SELECT RELEASE_LOCK('WarehouseSummarizer.syncDimensions.17')] 2010-10-21 09:03:56.976 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:56.977 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:56.978 (4) [P1T1]: time=0.0020 2010-10-21 09:03:56.978 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:56.980 (3) [P1T1]: Starting daily for Account #17 WWMW - Cellular Safety Commission for Tue Aug 10 03:00:00 EDT 2010 2010-10-21 09:03:56.981 (3) [P1T1]: Updating perf rows that don't have a bidTargetID, but should... for Dist(s) (177) 2010-10-21 09:03:56.984 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:56.995 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:56.995 (4) [P1T1]: perfsum: SQL->[select `whDailySourcePerf`.`id`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineMatchType`,`whIdentifiers`.`searchEngineIdentifier`,`whDescriptions`.`description` from `warehouse_1`.`whDailySourcePerf` inner join `tsacommon`.`distribution` on ((`whDailySourcePerf`.`distributionID`=`tsacommon`.`distribution`.`id`)) left outer join `warehouse_1`.`whDescriptions` on ((`whDailySourcePerf`.`descriptionID`=`whDescriptions`.`id`)) left outer join `warehouse_1`.`whIdentifiers` on ((`whDailySourcePerf`.`identifierID`=`whIdentifiers`.`id`)) where ((((((`whDailySourcePerf`.`startTime`="2010-08-10 03:00:00")) and (`whDailySourcePerf`.`accountID`=17) and (`whDailySourcePerf`.`bidTargetID`<"1") and (`whDailySourcePerf`.`searchEngineAccountID`>"0") and (`tsacommon`.`distribution`.`searchEngineClass` is not null) and (`whDailySourcePerf`.`distributionID` in (177)))) and (((((`whIdentifiers`.`searchEngineIdentifier` is not null)) or ((`whDescriptions`.`description` is not null)))))))] 2010-10-21 09:03:56.999 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-21 09:03:57.000 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:57.000 (4) [P1T1]: time=0.0040 2010-10-21 09:03:57.001 (4) [P1T1]: Query executed in 0.004s 2010-10-21 09:03:57.002 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.003 (4) [P1T1]: perfsum: SQL->[select COUNT(*) from `warehouse_1`.`whDailySourcePerf` inner join `tsacommon`.`distribution` on ((`whDailySourcePerf`.`distributionID`=`tsacommon`.`distribution`.`id`)) where (((`whDailySourcePerf`.`startTime`="2010-08-10 03:00:00")) and (`whDailySourcePerf`.`accountID`=17) and (`whDailySourcePerf`.`bidTargetID`<"1") and (`whDailySourcePerf`.`searchEngineAccountID`>"0") and (`tsacommon`.`distribution`.`searchEngineClass` is not null) and (`whDailySourcePerf`.`distributionID` in (177)))] 2010-10-21 09:03:57.006 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:57.006 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:57.007 (4) [P1T1]: time=0.0030 2010-10-21 09:03:57.008 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:57.013 (5) [P1T1]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-21 09:03:57.014 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:57.015 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.016 (4) [P1T1]: perfsum: SQL->[select * from `publisherActivitySummary` join `sources` on ((`sources`.`id`=`publisherActivitySummary`.`sourceID`)) where (((`publisherActivitySummary`.`startTime`="2010-08-10 03:00:00")) and (`publisherActivitySummary`.`resolution`=86400) and (`publisherActivitySummary`.`accountID`=17) and (`sources`.`distributionID` in (177))) limit 1] 2010-10-21 09:03:57.020 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-21 09:03:57.020 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:57.021 (4) [P1T1]: time=0.0040 2010-10-21 09:03:57.021 (4) [P1T1]: Query executed in 0.004s 2010-10-21 09:03:57.022 (3) [P1T1]: no publisher data for account #17 in dist (177) 2010-10-21 09:03:57.023 (3) [P1T1]: Finished daily for Account #17 WWMW - Cellular Safety Commission on Tue Aug 10 03:00:00 EDT 2010 2010-10-21 09:03:57.024 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.025 (4) [P1T1]: perfsum: SQL->[select * from `dataSources` where ((`accountID`="17") and (`type`="wh_lowgran")) limit 1] 2010-10-21 09:03:57.027 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:57.028 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:57.028 (4) [P1T1]: time=0.0020 2010-10-21 09:03:57.029 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:57.029 (5) [P1T1]: loading 4 columns from result set: 2010-10-21 09:03:57.032 (5) [P1T1]: loaded column: dataSources.id->8602 2010-10-21 09:03:57.033 (5) [P1T1]: loaded column: dataSources.type->wh_lowgran 2010-10-21 09:03:57.034 (5) [P1T1]: loaded column: dataSources.typeID->null 2010-10-21 09:03:57.035 (5) [P1T1]: loaded column: dataSources.accountID->17 2010-10-21 09:03:57.035 (4) [P1T1]: Record Loaded 2010-10-21 09:03:57.039 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.182 (4) [P1T1]: perfsum: SQL->[select * from `dataAvailability` where ((`dataSourceID`="8602") and (`date`="2010-08-10 03:00:00")) limit 1] 2010-10-21 09:03:57.185 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:57.186 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:57.187 (4) [P1T1]: time=0.0030 2010-10-21 09:03:57.187 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:57.188 (4) [P1T1]: Record Not Found 2010-10-21 09:03:57.190 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.191 (4) [P1T1]: perfsum: SQL->[select * from `dataAvailability` where ((`dataSourceID`="8602") and (`date`="2010-08-10 03:00:00")) limit 1] 2010-10-21 09:03:57.193 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:57.194 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:57.194 (4) [P1T1]: time=0.0020 2010-10-21 09:03:57.195 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:57.195 (4) [P1T1]: Record Not Found 2010-10-21 09:03:57.197 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.197 (4) [P1T1]: perfsum: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-08-10 03:00:00","2010-10-21 09:03:57")], genflags=yes 2010-10-21 09:03:57.215 (2) [P1T1]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-08-10 03:00:00","2010-10-21 09:03:57")] executed by user [perfsum] 2010-10-21 09:03:57.217 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-21 09:03:57.218 (5) [P1T1]: recordAsSubs("db", 21, "P1T1") 2010-10-21 09:03:57.218 (5) [P1T1]: ProfilerRec.end("db", true): ret=21 2010-10-21 09:03:57.219 (4) [P1T1]: time=0.021 2010-10-21 09:03:57.233 (4) [P1T1]: Query executed in 0.021s, 1 row(s) affected 2010-10-21 09:03:57.239 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.249 (4) [P1T1]: perfsum: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-08-10 03:00:00","2010-10-21 09:03:57")], genflags=yes 2010-10-21 09:03:57.264 (2) [P1T1]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-08-10 03:00:00","2010-10-21 09:03:57")] executed by user [perfsum] 2010-10-21 09:03:57.266 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-21 09:03:57.266 (5) [P1T1]: recordAsSubs("db", 17, "P1T1") 2010-10-21 09:03:57.267 (5) [P1T1]: ProfilerRec.end("db", true): ret=17 2010-10-21 09:03:57.268 (4) [P1T1]: time=0.017 2010-10-21 09:03:57.268 (4) [P1T1]: Query executed in 0.017s, 1 row(s) affected 2010-10-21 09:03:57.269 (3) [P1T1]: Starting Account #17 WWMW - Cellular Safety Commission aggregates for Tue Aug 10 03:00:00 EDT 2010 to [17], type=class java.lang.Integer 2010-10-21 09:03:57.273 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:57.275 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:57.282 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-21 09:03:57.283 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-21 09:03:57.654 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-21 09:03:57.655 (4) [P1T1]: DB AutoCommit -> false 2010-10-21 09:03:57.656 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.657 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whWeeklySourceConv` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[delete from `warehouse_1`.`whWeeklySourcePerf` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[delete from `warehouse_1`.`whWeeklySourceAttr` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[insert into `warehouse_1`.`whWeeklySourcePerf` (`accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`identifierID`,`descriptionID`,`altKeyID`,`bidTargetID`,`nonSearchTag`,`pixImpressions`,`seImpressions`,`impressions`,`pixClicks`,`seClicks`,`clicks`,`pixAdCost`,`seAdCost`,`adCost`,`avgPosition`,`id`) select `accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`identifierID`,`descriptionID`,`altKeyID`,`bidTargetID`,`nonSearchTag`,ifnull(SUM(`whDailySourcePerf`.`pixImpressions`), 0) AS `pixImpressions`,ifnull(SUM(`whDailySourcePerf`.`seImpressions`), 0) AS `seImpressions`,ifnull(SUM(`whDailySourcePerf`.`impressions`), 0) AS `impressions`,ifnull(SUM(`whDailySourcePerf`.`pixClicks`), 0) AS `pixClicks`,ifnull(SUM(`whDailySourcePerf`.`seClicks`), 0) AS `seClicks`,ifnull(SUM(`whDailySourcePerf`.`clicks`), 0) AS `clicks`,ifnull(SUM(`whDailySourcePerf`.`pixAdCost`), 0) AS `pixAdCost`,ifnull(SUM(`whDailySourcePerf`.`seAdCost`), 0) AS `seAdCost`,ifnull(SUM(`whDailySourcePerf`.`adCost`), 0) AS `adCost`,ifnull(if(`whDailySourcePerf`.`distributionID` in (86,101,122),AVG(if(`avgPosition`=0,null,`avgPosition`)),IF((SUM(`seImpressions`)>0), ROUND(SUM(`avgPosition` * `seImpressions`) / SUM(`seImpressions`),5), 0)),0) AS `avgPosition`,MAX(`whDailySourcePerf`.`id`) AS `id` from `warehouse_1`.`whDailySourcePerf` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[create temporary table `tmp`.`tmp1` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`whDailySourcePerf`.`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`identifierID`,`whDailySourcePerf`.`descriptionID`,`whDailySourcePerf`.`altKeyID`,`whDailySourcePerf`.`bidTargetID`,`whDailySourcePerf`.`nonSearchTag`,`whDailySourceConv`.`scope`,`whDailySourceConv`.`productID`,ifnull(SUM(`whDailySourceConv`.`pixFulfillCost`), 0) AS `pixFulfillCost`,ifnull(SUM(`whDailySourceConv`.`clFulfillCost`), 0) AS `clFulfillCost`,ifnull(SUM(`whDailySourceConv`.`fulfillCost`), 0) AS `fulfillCost`,ifnull(SUM(`whDailySourceConv`.`pixConversions`), 0) AS `pixConversions`,ifnull(SUM(`whDailySourceConv`.`seConversions`), 0) AS `seConversions`,ifnull(SUM(`whDailySourceConv`.`clConversions`), 0) AS `clConversions`,ifnull(SUM(`whDailySourceConv`.`conversions`), 0) AS `conversions`,ifnull(SUM(`whDailySourceConv`.`pixValue`), 0) AS `pixValue`,ifnull(SUM(`whDailySourceConv`.`seValue`), 0) AS `seValue`,ifnull(SUM(`whDailySourceConv`.`clValue`), 0) AS `clValue`,ifnull(SUM(`whDailySourceConv`.`value`), 0) AS `value` from `warehouse_1`.`whDailySourceConv` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceConv`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceConv`.`accountID`=17) and ((((`whDailySourceConv`.`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`whDailySourceConv`.`startTime`[insert into `warehouse_1`.`whWeeklySourceConv` (`startTime`,`accountID`,`perfID`,`scope`,`productID`,`pixFulfillCost`,`clFulfillCost`,`fulfillCost`,`pixConversions`,`seConversions`,`clConversions`,`conversions`,`pixValue`,`seValue`,`clValue`,`value`) select `tmp`.`tmp1`.`startTime`,`tmp`.`tmp1`.`accountID`,`whWeeklySourcePerf`.`id`,`tmp`.`tmp1`.`scope`,`tmp`.`tmp1`.`productID`,`tmp`.`tmp1`.`pixFulfillCost`,`tmp`.`tmp1`.`clFulfillCost`,`tmp`.`tmp1`.`fulfillCost`,`tmp`.`tmp1`.`pixConversions`,`tmp`.`tmp1`.`seConversions`,`tmp`.`tmp1`.`clConversions`,`tmp`.`tmp1`.`conversions`,`tmp`.`tmp1`.`pixValue`,`tmp`.`tmp1`.`seValue`,`tmp`.`tmp1`.`clValue`,`tmp`.`tmp1`.`value` from `warehouse_1`.`whWeeklySourcePerf` inner join `tmp`.`tmp1` on (((`whWeeklySourcePerf`.`accountID`=`tmp`.`tmp1`.`accountID`) and (`whWeeklySourcePerf`.`startTime`=`tmp`.`tmp1`.`startTime`) and (`whWeeklySourcePerf`.`distributionID`=`tmp`.`tmp1`.`distributionID`) and (`whWeeklySourcePerf`.`campaignID`=`tmp`.`tmp1`.`campaignID`) and (`whWeeklySourcePerf`.`searchEngineAccountID`=`tmp`.`tmp1`.`searchEngineAccountID`) and (`whWeeklySourcePerf`.`searchEngineGroupID`=`tmp`.`tmp1`.`searchEngineGroupID`) and (`whWeeklySourcePerf`.`searchEngineListingID`=`tmp`.`tmp1`.`searchEngineListingID`) and (`whWeeklySourcePerf`.`searchEngineMatchType`=`tmp`.`tmp1`.`searchEngineMatchType`) and (`whWeeklySourcePerf`.`type`=`tmp`.`tmp1`.`type`) and (`whWeeklySourcePerf`.`identifierID`=`tmp`.`tmp1`.`identifierID`) and (`whWeeklySourcePerf`.`descriptionID`=`tmp`.`tmp1`.`descriptionID`) and (`whWeeklySourcePerf`.`altKeyID`=`tmp`.`tmp1`.`altKeyID`)))], genflags=no 2010-10-21 09:03:57.780 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2010-10-21 09:03:57.780 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2010-10-21 09:03:57.782 (4) [P1T1]: time=0.0080 2010-10-21 09:03:57.782 (4) [P1T1]: Query executed in 0.008s, 81 row(s) affected 2010-10-21 09:03:57.783 (3) [P1T1]: ... 81 Weekly Source Conversion Records Inserted 2010-10-21 09:03:57.784 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.784 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp2` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`whDailySourcePerf`.`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`identifierID`,`whDailySourcePerf`.`descriptionID`,`whDailySourcePerf`.`altKeyID`,`whDailySourcePerf`.`bidTargetID`,`whDailySourcePerf`.`nonSearchTag`,cast(if(mod(avg(bidTypeID),1.0) > 0, 3, avg(bidTypeID)) as unsigned) AS `bidTypeID`,AVG(`whDailySourceAttr`.`qualityScore`) AS `qualityScore` from `warehouse_1`.`whDailySourceAttr` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceAttr`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceAttr`.`accountID`=17) and ((((`whDailySourceAttr`.`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`whDailySourceAttr`.`startTime`[insert into `warehouse_1`.`whWeeklySourceAttr` (`startTime`,`accountID`,`perfID`,`bidTypeID`,`qualityScore`) select `tmp`.`tmp2`.`startTime`,`tmp`.`tmp2`.`accountID`,`whWeeklySourcePerf`.`id`,`tmp`.`tmp2`.`bidTypeID`,`tmp`.`tmp2`.`qualityScore` from `warehouse_1`.`whWeeklySourcePerf` inner join `tmp`.`tmp2` on (((`whWeeklySourcePerf`.`accountID`=`tmp`.`tmp2`.`accountID`) and (`whWeeklySourcePerf`.`startTime`=`tmp`.`tmp2`.`startTime`) and (`whWeeklySourcePerf`.`distributionID`=`tmp`.`tmp2`.`distributionID`) and (`whWeeklySourcePerf`.`campaignID`=`tmp`.`tmp2`.`campaignID`) and (`whWeeklySourcePerf`.`searchEngineAccountID`=`tmp`.`tmp2`.`searchEngineAccountID`) and (`whWeeklySourcePerf`.`searchEngineGroupID`=`tmp`.`tmp2`.`searchEngineGroupID`) and (`whWeeklySourcePerf`.`searchEngineListingID`=`tmp`.`tmp2`.`searchEngineListingID`) and (`whWeeklySourcePerf`.`searchEngineMatchType`=`tmp`.`tmp2`.`searchEngineMatchType`) and (`whWeeklySourcePerf`.`type`=`tmp`.`tmp2`.`type`) and (`whWeeklySourcePerf`.`identifierID`=`tmp`.`tmp2`.`identifierID`) and (`whWeeklySourcePerf`.`descriptionID`=`tmp`.`tmp2`.`descriptionID`) and (`whWeeklySourcePerf`.`altKeyID`=`tmp`.`tmp2`.`altKeyID`)))], genflags=no 2010-10-21 09:03:57.807 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2010-10-21 09:03:57.808 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2010-10-21 09:03:57.808 (4) [P1T1]: time=0.0080 2010-10-21 09:03:57.809 (4) [P1T1]: Query executed in 0.008s, 48 row(s) affected 2010-10-21 09:03:57.810 (3) [P1T1]: ... 48 Weekly Source Attribute Records Inserted 2010-10-21 09:03:57.811 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-21 09:03:57.811 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.813 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2010-10-21 09:03:57.814 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2010-10-21 09:03:57.815 (4) [P1T1]: time=0.0010 2010-10-21 09:03:57.815 (4) [P1T1]: Query executed in 0.001s 2010-10-21 09:03:57.816 (4) [P1T1]: DB AutoCommit -> true 2010-10-21 09:03:57.817 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-21 09:03:57.818 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.819 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp1`] 2010-10-21 09:03:57.821 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:57.822 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:57.823 (4) [P1T1]: time=0.0020 2010-10-21 09:03:57.823 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:57.824 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:57.824 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:57.825 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp2`] 2010-10-21 09:03:57.827 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:57.828 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:57.828 (4) [P1T1]: time=0.0020 2010-10-21 09:03:57.829 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:57.829 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:57.830 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:57.831 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:57.833 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:57.837 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-21 09:03:57.838 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-21 09:03:58.197 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-21 09:03:58.198 (4) [P1T1]: DB AutoCommit -> false 2010-10-21 09:03:58.199 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.200 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whMonthlySourceConv` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlySourcePerf` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlySourceAttr` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`startTime`[insert into `warehouse_1`.`whMonthlySourcePerf` (`accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`identifierID`,`descriptionID`,`altKeyID`,`bidTargetID`,`nonSearchTag`,`pixImpressions`,`seImpressions`,`impressions`,`pixClicks`,`seClicks`,`clicks`,`pixAdCost`,`seAdCost`,`adCost`,`avgPosition`,`id`) select `accountID`,DATE_FORMAT(`startTime`,"%Y-%m-01") AS `startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`identifierID`,`descriptionID`,`altKeyID`,`bidTargetID`,`nonSearchTag`,ifnull(SUM(`whDailySourcePerf`.`pixImpressions`), 0) AS `pixImpressions`,ifnull(SUM(`whDailySourcePerf`.`seImpressions`), 0) AS `seImpressions`,ifnull(SUM(`whDailySourcePerf`.`impressions`), 0) AS `impressions`,ifnull(SUM(`whDailySourcePerf`.`pixClicks`), 0) AS `pixClicks`,ifnull(SUM(`whDailySourcePerf`.`seClicks`), 0) AS `seClicks`,ifnull(SUM(`whDailySourcePerf`.`clicks`), 0) AS `clicks`,ifnull(SUM(`whDailySourcePerf`.`pixAdCost`), 0) AS `pixAdCost`,ifnull(SUM(`whDailySourcePerf`.`seAdCost`), 0) AS `seAdCost`,ifnull(SUM(`whDailySourcePerf`.`adCost`), 0) AS `adCost`,ifnull(if(`whDailySourcePerf`.`distributionID` in (86,101,122),AVG(if(`avgPosition`=0,null,`avgPosition`)),IF((SUM(`seImpressions`)>0), ROUND(SUM(`avgPosition` * `seImpressions`) / SUM(`seImpressions`),5), 0)),0) AS `avgPosition`,MAX(`whDailySourcePerf`.`id`) AS `id` from `warehouse_1`.`whDailySourcePerf` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`startTime`[create temporary table `tmp`.`tmp3` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,DATE_FORMAT(`whDailySourcePerf`.`startTime`,"%Y-%m-01") AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`identifierID`,`whDailySourcePerf`.`descriptionID`,`whDailySourcePerf`.`altKeyID`,`whDailySourcePerf`.`bidTargetID`,`whDailySourcePerf`.`nonSearchTag`,`whDailySourceConv`.`scope`,`whDailySourceConv`.`productID`,ifnull(SUM(`whDailySourceConv`.`pixFulfillCost`), 0) AS `pixFulfillCost`,ifnull(SUM(`whDailySourceConv`.`clFulfillCost`), 0) AS `clFulfillCost`,ifnull(SUM(`whDailySourceConv`.`fulfillCost`), 0) AS `fulfillCost`,ifnull(SUM(`whDailySourceConv`.`pixConversions`), 0) AS `pixConversions`,ifnull(SUM(`whDailySourceConv`.`seConversions`), 0) AS `seConversions`,ifnull(SUM(`whDailySourceConv`.`clConversions`), 0) AS `clConversions`,ifnull(SUM(`whDailySourceConv`.`conversions`), 0) AS `conversions`,ifnull(SUM(`whDailySourceConv`.`pixValue`), 0) AS `pixValue`,ifnull(SUM(`whDailySourceConv`.`seValue`), 0) AS `seValue`,ifnull(SUM(`whDailySourceConv`.`clValue`), 0) AS `clValue`,ifnull(SUM(`whDailySourceConv`.`value`), 0) AS `value` from `warehouse_1`.`whDailySourceConv` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceConv`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceConv`.`accountID`=17) and ((((`whDailySourceConv`.`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`whDailySourceConv`.`startTime`[insert into `warehouse_1`.`whMonthlySourceConv` (`startTime`,`accountID`,`perfID`,`scope`,`productID`,`pixFulfillCost`,`clFulfillCost`,`fulfillCost`,`pixConversions`,`seConversions`,`clConversions`,`conversions`,`pixValue`,`seValue`,`clValue`,`value`) select `tmp`.`tmp3`.`startTime`,`tmp`.`tmp3`.`accountID`,`whMonthlySourcePerf`.`id`,`tmp`.`tmp3`.`scope`,`tmp`.`tmp3`.`productID`,`tmp`.`tmp3`.`pixFulfillCost`,`tmp`.`tmp3`.`clFulfillCost`,`tmp`.`tmp3`.`fulfillCost`,`tmp`.`tmp3`.`pixConversions`,`tmp`.`tmp3`.`seConversions`,`tmp`.`tmp3`.`clConversions`,`tmp`.`tmp3`.`conversions`,`tmp`.`tmp3`.`pixValue`,`tmp`.`tmp3`.`seValue`,`tmp`.`tmp3`.`clValue`,`tmp`.`tmp3`.`value` from `warehouse_1`.`whMonthlySourcePerf` inner join `tmp`.`tmp3` on (((`whMonthlySourcePerf`.`accountID`=`tmp`.`tmp3`.`accountID`) and (`whMonthlySourcePerf`.`startTime`=`tmp`.`tmp3`.`startTime`) and (`whMonthlySourcePerf`.`distributionID`=`tmp`.`tmp3`.`distributionID`) and (`whMonthlySourcePerf`.`campaignID`=`tmp`.`tmp3`.`campaignID`) and (`whMonthlySourcePerf`.`searchEngineAccountID`=`tmp`.`tmp3`.`searchEngineAccountID`) and (`whMonthlySourcePerf`.`searchEngineGroupID`=`tmp`.`tmp3`.`searchEngineGroupID`) and (`whMonthlySourcePerf`.`searchEngineListingID`=`tmp`.`tmp3`.`searchEngineListingID`) and (`whMonthlySourcePerf`.`searchEngineMatchType`=`tmp`.`tmp3`.`searchEngineMatchType`) and (`whMonthlySourcePerf`.`type`=`tmp`.`tmp3`.`type`) and (`whMonthlySourcePerf`.`identifierID`=`tmp`.`tmp3`.`identifierID`) and (`whMonthlySourcePerf`.`descriptionID`=`tmp`.`tmp3`.`descriptionID`) and (`whMonthlySourcePerf`.`altKeyID`=`tmp`.`tmp3`.`altKeyID`)))], genflags=no 2010-10-21 09:03:58.340 (5) [P1T1]: recordAsSubs("db", 19, "P1T1") 2010-10-21 09:03:58.341 (5) [P1T1]: ProfilerRec.end("db", true): ret=19 2010-10-21 09:03:58.349 (4) [P1T1]: time=0.019 2010-10-21 09:03:58.350 (4) [P1T1]: Query executed in 0.019s, 81 row(s) affected 2010-10-21 09:03:58.351 (3) [P1T1]: ... 81 Monthly Source Conversion Records Inserted 2010-10-21 09:03:58.352 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.352 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp4` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,DATE_FORMAT(`whDailySourcePerf`.`startTime`,"%Y-%m-01") AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`identifierID`,`whDailySourcePerf`.`descriptionID`,`whDailySourcePerf`.`altKeyID`,`whDailySourcePerf`.`bidTargetID`,`whDailySourcePerf`.`nonSearchTag`,cast(if(mod(avg(bidTypeID),1.0) > 0, 3, avg(bidTypeID)) as unsigned) AS `bidTypeID`,AVG(`whDailySourceAttr`.`qualityScore`) AS `qualityScore` from `warehouse_1`.`whDailySourceAttr` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceAttr`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceAttr`.`accountID`=17) and ((((`whDailySourceAttr`.`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`whDailySourceAttr`.`startTime`[insert into `warehouse_1`.`whMonthlySourceAttr` (`startTime`,`accountID`,`perfID`,`bidTypeID`,`qualityScore`) select `tmp`.`tmp4`.`startTime`,`tmp`.`tmp4`.`accountID`,`whMonthlySourcePerf`.`id`,`tmp`.`tmp4`.`bidTypeID`,`tmp`.`tmp4`.`qualityScore` from `warehouse_1`.`whMonthlySourcePerf` inner join `tmp`.`tmp4` on (((`whMonthlySourcePerf`.`accountID`=`tmp`.`tmp4`.`accountID`) and (`whMonthlySourcePerf`.`startTime`=`tmp`.`tmp4`.`startTime`) and (`whMonthlySourcePerf`.`distributionID`=`tmp`.`tmp4`.`distributionID`) and (`whMonthlySourcePerf`.`campaignID`=`tmp`.`tmp4`.`campaignID`) and (`whMonthlySourcePerf`.`searchEngineAccountID`=`tmp`.`tmp4`.`searchEngineAccountID`) and (`whMonthlySourcePerf`.`searchEngineGroupID`=`tmp`.`tmp4`.`searchEngineGroupID`) and (`whMonthlySourcePerf`.`searchEngineListingID`=`tmp`.`tmp4`.`searchEngineListingID`) and (`whMonthlySourcePerf`.`searchEngineMatchType`=`tmp`.`tmp4`.`searchEngineMatchType`) and (`whMonthlySourcePerf`.`type`=`tmp`.`tmp4`.`type`) and (`whMonthlySourcePerf`.`identifierID`=`tmp`.`tmp4`.`identifierID`) and (`whMonthlySourcePerf`.`descriptionID`=`tmp`.`tmp4`.`descriptionID`) and (`whMonthlySourcePerf`.`altKeyID`=`tmp`.`tmp4`.`altKeyID`)))], genflags=no 2010-10-21 09:03:58.411 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2010-10-21 09:03:58.412 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:58.412 (4) [P1T1]: time=0.0060 2010-10-21 09:03:58.414 (4) [P1T1]: Query executed in 0.006s, 64 row(s) affected 2010-10-21 09:03:58.414 (3) [P1T1]: ... 64 Monthly Source Attribute Records Inserted 2010-10-21 09:03:58.415 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-21 09:03:58.415 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.424 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2010-10-21 09:03:58.424 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2010-10-21 09:03:58.426 (4) [P1T1]: time=0.0080 2010-10-21 09:03:58.426 (4) [P1T1]: Query executed in 0.008s 2010-10-21 09:03:58.427 (4) [P1T1]: DB AutoCommit -> true 2010-10-21 09:03:58.428 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-21 09:03:58.430 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.430 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp3`] 2010-10-21 09:03:58.433 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:58.433 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:58.434 (4) [P1T1]: time=0.0030 2010-10-21 09:03:58.435 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:58.435 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:58.436 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.437 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp4`] 2010-10-21 09:03:58.439 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:58.439 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:58.440 (4) [P1T1]: time=0.0020 2010-10-21 09:03:58.441 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:58.441 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:58.442 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:58.443 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:58.444 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:58.448 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-21 09:03:58.448 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-21 09:03:58.603 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-21 09:03:58.604 (4) [P1T1]: DB AutoCommit -> false 2010-10-21 09:03:58.605 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.606 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whDailyGroupConv` where ((`accountID`=17) and ((((`startTime`>="2010-08-10 03:00:00")) and ((`startTime`<"2010-08-11 00:00:00")))))], genflags=no 2010-10-21 09:03:58.609 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:58.609 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:58.610 (4) [P1T1]: time=0.0030 2010-10-21 09:03:58.611 (4) [P1T1]: Query executed in 0.003s, 0 row(s) affected 2010-10-21 09:03:58.611 (4) [P1T1]: ... 0 Daily Group Conversion Records Cleared 2010-10-21 09:03:58.612 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.613 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whDailyGroupPerf` where ((`accountID`=17) and ((((`startTime`>="2010-08-10 03:00:00")) and ((`startTime`<"2010-08-11 00:00:00")))))], genflags=no 2010-10-21 09:03:58.615 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:58.615 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:58.616 (4) [P1T1]: time=0.0020 2010-10-21 09:03:58.617 (4) [P1T1]: Query executed in 0.002s, 0 row(s) affected 2010-10-21 09:03:58.617 (4) [P1T1]: .... 0 Perf Records Cleared 2010-10-21 09:03:58.618 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.619 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whDailyGroupAttr` where ((`accountID`=17) and ((((`startTime`>="2010-08-10 03:00:00")) and ((`startTime`<"2010-08-11 00:00:00")))))], genflags=no 2010-10-21 09:03:58.621 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:58.622 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:58.623 (4) [P1T1]: time=0.0020 2010-10-21 09:03:58.623 (4) [P1T1]: Query executed in 0.002s, 0 row(s) affected 2010-10-21 09:03:58.624 (4) [P1T1]: .... 0 Attr Records Cleared 2010-10-21 09:03:58.625 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.625 (4) [P1T1]: perfsum: SQL->[insert into `warehouse_1`.`whDailyGroupPerf` (`accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,`pixImpressions`,`seImpressions`,`impressions`,`pixClicks`,`seClicks`,`clicks`,`pixAdCost`,`seAdCost`,`adCost`,`avgPosition`,`id`) select `accountID`,`startTime` AS `startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,ifnull(SUM(`whDailySourcePerf`.`pixImpressions`), 0) AS `pixImpressions`,ifnull(SUM(`whDailySourcePerf`.`seImpressions`), 0) AS `seImpressions`,ifnull(SUM(`whDailySourcePerf`.`impressions`), 0) AS `impressions`,ifnull(SUM(`whDailySourcePerf`.`pixClicks`), 0) AS `pixClicks`,ifnull(SUM(`whDailySourcePerf`.`seClicks`), 0) AS `seClicks`,ifnull(SUM(`whDailySourcePerf`.`clicks`), 0) AS `clicks`,ifnull(SUM(`whDailySourcePerf`.`pixAdCost`), 0) AS `pixAdCost`,ifnull(SUM(`whDailySourcePerf`.`seAdCost`), 0) AS `seAdCost`,ifnull(SUM(`whDailySourcePerf`.`adCost`), 0) AS `adCost`,ifnull(if(`whDailySourcePerf`.`distributionID` in (86,101,122),AVG(if(`avgPosition`=0,null,`avgPosition`)),IF((SUM(`seImpressions`)>0), ROUND(SUM(`avgPosition` * `seImpressions`) / SUM(`seImpressions`),5), 0)),0) AS `avgPosition`,MAX(`whDailySourcePerf`.`id`) AS `id` from `warehouse_1`.`whDailySourcePerf` where ((`accountID`=17) and ((((`startTime`>="2010-08-10 03:00:00")) and ((`startTime`<"2010-08-11 00:00:00"))))) group by `whDailySourcePerf`.`accountID`,`whDailySourcePerf`.`startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`nonSearchTag`], genflags=no 2010-10-21 09:03:58.629 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-21 09:03:58.630 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:58.631 (4) [P1T1]: time=0.0040 2010-10-21 09:03:58.631 (4) [P1T1]: Query executed in 0.004s, 0 row(s) affected 2010-10-21 09:03:58.632 (3) [P1T1]: ... 0 Daily Group Perf Records Inserted 2010-10-21 09:03:58.633 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.633 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp5` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,`whDailySourcePerf`.`startTime` AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`nonSearchTag`,`whDailySourceConv`.`scope`,`whDailySourceConv`.`productID`,ifnull(SUM(`whDailySourceConv`.`pixFulfillCost`), 0) AS `pixFulfillCost`,ifnull(SUM(`whDailySourceConv`.`clFulfillCost`), 0) AS `clFulfillCost`,ifnull(SUM(`whDailySourceConv`.`fulfillCost`), 0) AS `fulfillCost`,ifnull(SUM(`whDailySourceConv`.`pixConversions`), 0) AS `pixConversions`,ifnull(SUM(`whDailySourceConv`.`seConversions`), 0) AS `seConversions`,ifnull(SUM(`whDailySourceConv`.`clConversions`), 0) AS `clConversions`,ifnull(SUM(`whDailySourceConv`.`conversions`), 0) AS `conversions`,ifnull(SUM(`whDailySourceConv`.`pixValue`), 0) AS `pixValue`,ifnull(SUM(`whDailySourceConv`.`seValue`), 0) AS `seValue`,ifnull(SUM(`whDailySourceConv`.`clValue`), 0) AS `clValue`,ifnull(SUM(`whDailySourceConv`.`value`), 0) AS `value` from `warehouse_1`.`whDailySourceConv` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceConv`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceConv`.`accountID`=17) and ((((`whDailySourceConv`.`startTime`>="2010-08-10 03:00:00")) and ((`whDailySourceConv`.`startTime`<"2010-08-11 00:00:00"))))) group by `accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,`whDailySourceConv`.`scope`,`whDailySourceConv`.`productID`] 2010-10-21 09:03:58.638 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-21 09:03:58.639 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-21 09:03:58.639 (4) [P1T1]: time=0.0050 2010-10-21 09:03:58.640 (4) [P1T1]: Query executed in 0.005s 2010-10-21 09:03:58.640 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:58.641 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.641 (4) [P1T1]: perfsum: SQL->[insert into `warehouse_1`.`whDailyGroupConv` (`startTime`,`accountID`,`perfID`,`scope`,`productID`,`pixFulfillCost`,`clFulfillCost`,`fulfillCost`,`pixConversions`,`seConversions`,`clConversions`,`conversions`,`pixValue`,`seValue`,`clValue`,`value`) select `tmp`.`tmp5`.`startTime`,`tmp`.`tmp5`.`accountID`,`whDailyGroupPerf`.`id`,`tmp`.`tmp5`.`scope`,`tmp`.`tmp5`.`productID`,`tmp`.`tmp5`.`pixFulfillCost`,`tmp`.`tmp5`.`clFulfillCost`,`tmp`.`tmp5`.`fulfillCost`,`tmp`.`tmp5`.`pixConversions`,`tmp`.`tmp5`.`seConversions`,`tmp`.`tmp5`.`clConversions`,`tmp`.`tmp5`.`conversions`,`tmp`.`tmp5`.`pixValue`,`tmp`.`tmp5`.`seValue`,`tmp`.`tmp5`.`clValue`,`tmp`.`tmp5`.`value` from `warehouse_1`.`whDailyGroupPerf` inner join `tmp`.`tmp5` on (((`whDailyGroupPerf`.`accountID`=`tmp`.`tmp5`.`accountID`) and (`whDailyGroupPerf`.`startTime`=`tmp`.`tmp5`.`startTime`) and (`whDailyGroupPerf`.`distributionID`=`tmp`.`tmp5`.`distributionID`) and (`whDailyGroupPerf`.`campaignID`=`tmp`.`tmp5`.`campaignID`) and (`whDailyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp5`.`searchEngineAccountID`) and (`whDailyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp5`.`searchEngineGroupID`) and (`whDailyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp5`.`searchEngineListingID`) and (`whDailyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp5`.`searchEngineMatchType`) and (`whDailyGroupPerf`.`type`=`tmp`.`tmp5`.`type`) and (`whDailyGroupPerf`.`nonSearchTag`=`tmp`.`tmp5`.`nonSearchTag`)))], genflags=no 2010-10-21 09:03:58.644 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:58.645 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:58.646 (4) [P1T1]: time=0.0030 2010-10-21 09:03:58.646 (4) [P1T1]: Query executed in 0.003s, 0 row(s) affected 2010-10-21 09:03:58.647 (3) [P1T1]: ... 0 Daily Group Conversion Records Inserted 2010-10-21 09:03:58.647 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.648 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp6` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,`whDailySourcePerf`.`startTime` AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`nonSearchTag`,cast(if(mod(avg(bidTypeID),1.0) > 0, 3, avg(bidTypeID)) as unsigned) AS `bidTypeID`,AVG(`whDailySourceAttr`.`qualityScore`) AS `qualityScore` from `warehouse_1`.`whDailySourceAttr` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceAttr`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceAttr`.`accountID`=17) and ((((`whDailySourceAttr`.`startTime`>="2010-08-10 03:00:00")) and ((`whDailySourceAttr`.`startTime`<"2010-08-11 00:00:00"))))) group by `accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`] 2010-10-21 09:03:58.651 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:58.652 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:58.653 (4) [P1T1]: time=0.0030 2010-10-21 09:03:58.653 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:58.654 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:58.654 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.655 (4) [P1T1]: perfsum: SQL->[insert into `warehouse_1`.`whDailyGroupAttr` (`startTime`,`accountID`,`perfID`,`bidTypeID`,`qualityScore`) select `tmp`.`tmp6`.`startTime`,`tmp`.`tmp6`.`accountID`,`whDailyGroupPerf`.`id`,`tmp`.`tmp6`.`bidTypeID`,`tmp`.`tmp6`.`qualityScore` from `warehouse_1`.`whDailyGroupPerf` inner join `tmp`.`tmp6` on (((`whDailyGroupPerf`.`accountID`=`tmp`.`tmp6`.`accountID`) and (`whDailyGroupPerf`.`startTime`=`tmp`.`tmp6`.`startTime`) and (`whDailyGroupPerf`.`distributionID`=`tmp`.`tmp6`.`distributionID`) and (`whDailyGroupPerf`.`campaignID`=`tmp`.`tmp6`.`campaignID`) and (`whDailyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp6`.`searchEngineAccountID`) and (`whDailyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp6`.`searchEngineGroupID`) and (`whDailyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp6`.`searchEngineListingID`) and (`whDailyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp6`.`searchEngineMatchType`) and (`whDailyGroupPerf`.`type`=`tmp`.`tmp6`.`type`) and (`whDailyGroupPerf`.`nonSearchTag`=`tmp`.`tmp6`.`nonSearchTag`)))], genflags=no 2010-10-21 09:03:58.658 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:58.658 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:58.659 (4) [P1T1]: time=0.0030 2010-10-21 09:03:58.659 (4) [P1T1]: Query executed in 0.003s, 0 row(s) affected 2010-10-21 09:03:58.659 (3) [P1T1]: ... 0 Daily Group Attribute Records Inserted 2010-10-21 09:03:58.660 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-21 09:03:58.660 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.661 (5) [P1T1]: recordAsSubs("db", 0, "P1T1") 2010-10-21 09:03:58.662 (5) [P1T1]: ProfilerRec.end("db", true): ret=0 2010-10-21 09:03:58.662 (4) [P1T1]: time=0.0 2010-10-21 09:03:58.662 (4) [P1T1]: Query executed in 0.000s 2010-10-21 09:03:58.663 (4) [P1T1]: DB AutoCommit -> true 2010-10-21 09:03:58.664 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-21 09:03:58.665 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.666 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp5`] 2010-10-21 09:03:58.668 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:58.668 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:58.668 (4) [P1T1]: time=0.0020 2010-10-21 09:03:58.669 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:58.669 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:58.670 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.670 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp6`] 2010-10-21 09:03:58.672 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:58.673 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:58.673 (4) [P1T1]: time=0.0020 2010-10-21 09:03:58.673 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:58.674 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:58.674 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:58.676 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:58.677 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:58.680 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-21 09:03:58.681 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-21 09:03:58.729 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-21 09:03:58.730 (4) [P1T1]: DB AutoCommit -> false 2010-10-21 09:03:58.732 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.733 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whWeeklyGroupConv` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[delete from `warehouse_1`.`whWeeklyGroupPerf` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[delete from `warehouse_1`.`whWeeklyGroupAttr` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[insert into `warehouse_1`.`whWeeklyGroupPerf` (`accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,`pixImpressions`,`seImpressions`,`impressions`,`pixClicks`,`seClicks`,`clicks`,`pixAdCost`,`seAdCost`,`adCost`,`avgPosition`,`id`) select `accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,ifnull(SUM(`whDailyGroupPerf`.`pixImpressions`), 0) AS `pixImpressions`,ifnull(SUM(`whDailyGroupPerf`.`seImpressions`), 0) AS `seImpressions`,ifnull(SUM(`whDailyGroupPerf`.`impressions`), 0) AS `impressions`,ifnull(SUM(`whDailyGroupPerf`.`pixClicks`), 0) AS `pixClicks`,ifnull(SUM(`whDailyGroupPerf`.`seClicks`), 0) AS `seClicks`,ifnull(SUM(`whDailyGroupPerf`.`clicks`), 0) AS `clicks`,ifnull(SUM(`whDailyGroupPerf`.`pixAdCost`), 0) AS `pixAdCost`,ifnull(SUM(`whDailyGroupPerf`.`seAdCost`), 0) AS `seAdCost`,ifnull(SUM(`whDailyGroupPerf`.`adCost`), 0) AS `adCost`,ifnull(if(`whDailyGroupPerf`.`distributionID` in (86,101,122),AVG(if(`avgPosition`=0,null,`avgPosition`)),IF((SUM(`seImpressions`)>0), ROUND(SUM(`avgPosition` * `seImpressions`) / SUM(`seImpressions`),5), 0)),0) AS `avgPosition`,MAX(`whDailyGroupPerf`.`id`) AS `id` from `warehouse_1`.`whDailyGroupPerf` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[create temporary table `tmp`.`tmp7` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailyGroupPerf`.`accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`whDailyGroupPerf`.`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`whDailyGroupPerf`.`distributionID`,`whDailyGroupPerf`.`campaignID`,`whDailyGroupPerf`.`searchEngineAccountID`,`whDailyGroupPerf`.`searchEngineGroupID`,`whDailyGroupPerf`.`searchEngineListingID`,`whDailyGroupPerf`.`searchEngineMatchType`,`whDailyGroupPerf`.`type`,`whDailyGroupPerf`.`nonSearchTag`,`whDailyGroupConv`.`scope`,`whDailyGroupConv`.`productID`,ifnull(SUM(`whDailyGroupConv`.`pixFulfillCost`), 0) AS `pixFulfillCost`,ifnull(SUM(`whDailyGroupConv`.`clFulfillCost`), 0) AS `clFulfillCost`,ifnull(SUM(`whDailyGroupConv`.`fulfillCost`), 0) AS `fulfillCost`,ifnull(SUM(`whDailyGroupConv`.`pixConversions`), 0) AS `pixConversions`,ifnull(SUM(`whDailyGroupConv`.`seConversions`), 0) AS `seConversions`,ifnull(SUM(`whDailyGroupConv`.`clConversions`), 0) AS `clConversions`,ifnull(SUM(`whDailyGroupConv`.`conversions`), 0) AS `conversions`,ifnull(SUM(`whDailyGroupConv`.`pixValue`), 0) AS `pixValue`,ifnull(SUM(`whDailyGroupConv`.`seValue`), 0) AS `seValue`,ifnull(SUM(`whDailyGroupConv`.`clValue`), 0) AS `clValue`,ifnull(SUM(`whDailyGroupConv`.`value`), 0) AS `value` from `warehouse_1`.`whDailyGroupConv` inner join `warehouse_1`.`whDailyGroupPerf` on ((`whDailyGroupConv`.`perfID`=`whDailyGroupPerf`.`id`)) where ((`whDailyGroupConv`.`accountID`=17) and ((((`whDailyGroupConv`.`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`whDailyGroupConv`.`startTime`[insert into `warehouse_1`.`whWeeklyGroupConv` (`startTime`,`accountID`,`perfID`,`scope`,`productID`,`pixFulfillCost`,`clFulfillCost`,`fulfillCost`,`pixConversions`,`seConversions`,`clConversions`,`conversions`,`pixValue`,`seValue`,`clValue`,`value`) select `tmp`.`tmp7`.`startTime`,`tmp`.`tmp7`.`accountID`,`whWeeklyGroupPerf`.`id`,`tmp`.`tmp7`.`scope`,`tmp`.`tmp7`.`productID`,`tmp`.`tmp7`.`pixFulfillCost`,`tmp`.`tmp7`.`clFulfillCost`,`tmp`.`tmp7`.`fulfillCost`,`tmp`.`tmp7`.`pixConversions`,`tmp`.`tmp7`.`seConversions`,`tmp`.`tmp7`.`clConversions`,`tmp`.`tmp7`.`conversions`,`tmp`.`tmp7`.`pixValue`,`tmp`.`tmp7`.`seValue`,`tmp`.`tmp7`.`clValue`,`tmp`.`tmp7`.`value` from `warehouse_1`.`whWeeklyGroupPerf` inner join `tmp`.`tmp7` on (((`whWeeklyGroupPerf`.`accountID`=`tmp`.`tmp7`.`accountID`) and (`whWeeklyGroupPerf`.`startTime`=`tmp`.`tmp7`.`startTime`) and (`whWeeklyGroupPerf`.`distributionID`=`tmp`.`tmp7`.`distributionID`) and (`whWeeklyGroupPerf`.`campaignID`=`tmp`.`tmp7`.`campaignID`) and (`whWeeklyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp7`.`searchEngineAccountID`) and (`whWeeklyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp7`.`searchEngineGroupID`) and (`whWeeklyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp7`.`searchEngineListingID`) and (`whWeeklyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp7`.`searchEngineMatchType`) and (`whWeeklyGroupPerf`.`type`=`tmp`.`tmp7`.`type`) and (`whWeeklyGroupPerf`.`nonSearchTag`=`tmp`.`tmp7`.`nonSearchTag`)))], genflags=no 2010-10-21 09:03:58.767 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:58.767 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:58.767 (4) [P1T1]: time=0.0030 2010-10-21 09:03:58.768 (4) [P1T1]: Query executed in 0.003s, 6 row(s) affected 2010-10-21 09:03:58.768 (3) [P1T1]: ... 6 Weekly Group Conversion Records Inserted 2010-10-21 09:03:58.768 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.768 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp8` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailyGroupPerf`.`accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`whDailyGroupPerf`.`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`whDailyGroupPerf`.`distributionID`,`whDailyGroupPerf`.`campaignID`,`whDailyGroupPerf`.`searchEngineAccountID`,`whDailyGroupPerf`.`searchEngineGroupID`,`whDailyGroupPerf`.`searchEngineListingID`,`whDailyGroupPerf`.`searchEngineMatchType`,`whDailyGroupPerf`.`type`,`whDailyGroupPerf`.`nonSearchTag`,cast(if(mod(avg(bidTypeID),1.0) > 0, 3, avg(bidTypeID)) as unsigned) AS `bidTypeID`,AVG(`whDailyGroupAttr`.`qualityScore`) AS `qualityScore` from `warehouse_1`.`whDailyGroupAttr` inner join `warehouse_1`.`whDailyGroupPerf` on ((`whDailyGroupAttr`.`perfID`=`whDailyGroupPerf`.`id`)) where ((`whDailyGroupAttr`.`accountID`=17) and ((((`whDailyGroupAttr`.`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-08-10 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`whDailyGroupAttr`.`startTime`[insert into `warehouse_1`.`whWeeklyGroupAttr` (`startTime`,`accountID`,`perfID`,`bidTypeID`,`qualityScore`) select `tmp`.`tmp8`.`startTime`,`tmp`.`tmp8`.`accountID`,`whWeeklyGroupPerf`.`id`,`tmp`.`tmp8`.`bidTypeID`,`tmp`.`tmp8`.`qualityScore` from `warehouse_1`.`whWeeklyGroupPerf` inner join `tmp`.`tmp8` on (((`whWeeklyGroupPerf`.`accountID`=`tmp`.`tmp8`.`accountID`) and (`whWeeklyGroupPerf`.`startTime`=`tmp`.`tmp8`.`startTime`) and (`whWeeklyGroupPerf`.`distributionID`=`tmp`.`tmp8`.`distributionID`) and (`whWeeklyGroupPerf`.`campaignID`=`tmp`.`tmp8`.`campaignID`) and (`whWeeklyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp8`.`searchEngineAccountID`) and (`whWeeklyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp8`.`searchEngineGroupID`) and (`whWeeklyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp8`.`searchEngineListingID`) and (`whWeeklyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp8`.`searchEngineMatchType`) and (`whWeeklyGroupPerf`.`type`=`tmp`.`tmp8`.`type`) and (`whWeeklyGroupPerf`.`nonSearchTag`=`tmp`.`tmp8`.`nonSearchTag`)))], genflags=no 2010-10-21 09:03:58.778 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:58.779 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:58.779 (4) [P1T1]: time=0.0030 2010-10-21 09:03:58.779 (4) [P1T1]: Query executed in 0.003s, 12 row(s) affected 2010-10-21 09:03:58.779 (3) [P1T1]: ... 12 Weekly Group Attribute Records Inserted 2010-10-21 09:03:58.780 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-21 09:03:58.780 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.782 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:58.782 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:58.782 (4) [P1T1]: time=0.0020 2010-10-21 09:03:58.782 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:58.783 (4) [P1T1]: DB AutoCommit -> true 2010-10-21 09:03:58.783 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-21 09:03:58.784 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.785 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp7`] 2010-10-21 09:03:58.787 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:58.788 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:58.789 (4) [P1T1]: time=0.0020 2010-10-21 09:03:58.790 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:58.790 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:58.791 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.791 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp8`] 2010-10-21 09:03:58.794 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:58.794 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:58.795 (4) [P1T1]: time=0.0030 2010-10-21 09:03:58.796 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:58.796 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:58.797 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:58.798 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:58.799 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-21 09:03:58.802 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-21 09:03:58.803 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-21 09:03:58.811 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-21 09:03:58.812 (4) [P1T1]: DB AutoCommit -> false 2010-10-21 09:03:58.813 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.814 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whMonthlyGroupConv` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlyGroupPerf` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlyGroupAttr` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`startTime`[insert into `warehouse_1`.`whMonthlyGroupPerf` (`accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,`pixImpressions`,`seImpressions`,`impressions`,`pixClicks`,`seClicks`,`clicks`,`pixAdCost`,`seAdCost`,`adCost`,`avgPosition`,`id`) select `accountID`,DATE_FORMAT(`startTime`,"%Y-%m-01") AS `startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,ifnull(SUM(`whDailyGroupPerf`.`pixImpressions`), 0) AS `pixImpressions`,ifnull(SUM(`whDailyGroupPerf`.`seImpressions`), 0) AS `seImpressions`,ifnull(SUM(`whDailyGroupPerf`.`impressions`), 0) AS `impressions`,ifnull(SUM(`whDailyGroupPerf`.`pixClicks`), 0) AS `pixClicks`,ifnull(SUM(`whDailyGroupPerf`.`seClicks`), 0) AS `seClicks`,ifnull(SUM(`whDailyGroupPerf`.`clicks`), 0) AS `clicks`,ifnull(SUM(`whDailyGroupPerf`.`pixAdCost`), 0) AS `pixAdCost`,ifnull(SUM(`whDailyGroupPerf`.`seAdCost`), 0) AS `seAdCost`,ifnull(SUM(`whDailyGroupPerf`.`adCost`), 0) AS `adCost`,ifnull(if(`whDailyGroupPerf`.`distributionID` in (86,101,122),AVG(if(`avgPosition`=0,null,`avgPosition`)),IF((SUM(`seImpressions`)>0), ROUND(SUM(`avgPosition` * `seImpressions`) / SUM(`seImpressions`),5), 0)),0) AS `avgPosition`,MAX(`whDailyGroupPerf`.`id`) AS `id` from `warehouse_1`.`whDailyGroupPerf` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`startTime`[create temporary table `tmp`.`tmp9` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailyGroupPerf`.`accountID`,DATE_FORMAT(`whDailyGroupPerf`.`startTime`,"%Y-%m-01") AS `startTime`,`whDailyGroupPerf`.`distributionID`,`whDailyGroupPerf`.`campaignID`,`whDailyGroupPerf`.`searchEngineAccountID`,`whDailyGroupPerf`.`searchEngineGroupID`,`whDailyGroupPerf`.`searchEngineListingID`,`whDailyGroupPerf`.`searchEngineMatchType`,`whDailyGroupPerf`.`type`,`whDailyGroupPerf`.`nonSearchTag`,`whDailyGroupConv`.`scope`,`whDailyGroupConv`.`productID`,ifnull(SUM(`whDailyGroupConv`.`pixFulfillCost`), 0) AS `pixFulfillCost`,ifnull(SUM(`whDailyGroupConv`.`clFulfillCost`), 0) AS `clFulfillCost`,ifnull(SUM(`whDailyGroupConv`.`fulfillCost`), 0) AS `fulfillCost`,ifnull(SUM(`whDailyGroupConv`.`pixConversions`), 0) AS `pixConversions`,ifnull(SUM(`whDailyGroupConv`.`seConversions`), 0) AS `seConversions`,ifnull(SUM(`whDailyGroupConv`.`clConversions`), 0) AS `clConversions`,ifnull(SUM(`whDailyGroupConv`.`conversions`), 0) AS `conversions`,ifnull(SUM(`whDailyGroupConv`.`pixValue`), 0) AS `pixValue`,ifnull(SUM(`whDailyGroupConv`.`seValue`), 0) AS `seValue`,ifnull(SUM(`whDailyGroupConv`.`clValue`), 0) AS `clValue`,ifnull(SUM(`whDailyGroupConv`.`value`), 0) AS `value` from `warehouse_1`.`whDailyGroupConv` inner join `warehouse_1`.`whDailyGroupPerf` on ((`whDailyGroupConv`.`perfID`=`whDailyGroupPerf`.`id`)) where ((`whDailyGroupConv`.`accountID`=17) and ((((`whDailyGroupConv`.`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`whDailyGroupConv`.`startTime`[insert into `warehouse_1`.`whMonthlyGroupConv` (`startTime`,`accountID`,`perfID`,`scope`,`productID`,`pixFulfillCost`,`clFulfillCost`,`fulfillCost`,`pixConversions`,`seConversions`,`clConversions`,`conversions`,`pixValue`,`seValue`,`clValue`,`value`) select `tmp`.`tmp9`.`startTime`,`tmp`.`tmp9`.`accountID`,`whMonthlyGroupPerf`.`id`,`tmp`.`tmp9`.`scope`,`tmp`.`tmp9`.`productID`,`tmp`.`tmp9`.`pixFulfillCost`,`tmp`.`tmp9`.`clFulfillCost`,`tmp`.`tmp9`.`fulfillCost`,`tmp`.`tmp9`.`pixConversions`,`tmp`.`tmp9`.`seConversions`,`tmp`.`tmp9`.`clConversions`,`tmp`.`tmp9`.`conversions`,`tmp`.`tmp9`.`pixValue`,`tmp`.`tmp9`.`seValue`,`tmp`.`tmp9`.`clValue`,`tmp`.`tmp9`.`value` from `warehouse_1`.`whMonthlyGroupPerf` inner join `tmp`.`tmp9` on (((`whMonthlyGroupPerf`.`accountID`=`tmp`.`tmp9`.`accountID`) and (`whMonthlyGroupPerf`.`startTime`=`tmp`.`tmp9`.`startTime`) and (`whMonthlyGroupPerf`.`distributionID`=`tmp`.`tmp9`.`distributionID`) and (`whMonthlyGroupPerf`.`campaignID`=`tmp`.`tmp9`.`campaignID`) and (`whMonthlyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp9`.`searchEngineAccountID`) and (`whMonthlyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp9`.`searchEngineGroupID`) and (`whMonthlyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp9`.`searchEngineListingID`) and (`whMonthlyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp9`.`searchEngineMatchType`) and (`whMonthlyGroupPerf`.`type`=`tmp`.`tmp9`.`type`) and (`whMonthlyGroupPerf`.`nonSearchTag`=`tmp`.`tmp9`.`nonSearchTag`)))], genflags=no 2010-10-21 09:03:58.852 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-21 09:03:58.852 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-21 09:03:58.852 (4) [P1T1]: time=0.0040 2010-10-21 09:03:58.852 (4) [P1T1]: Query executed in 0.004s, 6 row(s) affected 2010-10-21 09:03:58.852 (3) [P1T1]: ... 6 Monthly Group Conversion Records Inserted 2010-10-21 09:03:58.853 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.853 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp10` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailyGroupPerf`.`accountID`,DATE_FORMAT(`whDailyGroupPerf`.`startTime`,"%Y-%m-01") AS `startTime`,`whDailyGroupPerf`.`distributionID`,`whDailyGroupPerf`.`campaignID`,`whDailyGroupPerf`.`searchEngineAccountID`,`whDailyGroupPerf`.`searchEngineGroupID`,`whDailyGroupPerf`.`searchEngineListingID`,`whDailyGroupPerf`.`searchEngineMatchType`,`whDailyGroupPerf`.`type`,`whDailyGroupPerf`.`nonSearchTag`,cast(if(mod(avg(bidTypeID),1.0) > 0, 3, avg(bidTypeID)) as unsigned) AS `bidTypeID`,AVG(`whDailyGroupAttr`.`qualityScore`) AS `qualityScore` from `warehouse_1`.`whDailyGroupAttr` inner join `warehouse_1`.`whDailyGroupPerf` on ((`whDailyGroupAttr`.`perfID`=`whDailyGroupPerf`.`id`)) where ((`whDailyGroupAttr`.`accountID`=17) and ((((`whDailyGroupAttr`.`startTime`>=DATE_FORMAT("2010-08-10 03:00:00","%Y-%m-01"))) and ((`whDailyGroupAttr`.`startTime`[insert into `warehouse_1`.`whMonthlyGroupAttr` (`startTime`,`accountID`,`perfID`,`bidTypeID`,`qualityScore`) select `tmp`.`tmp10`.`startTime`,`tmp`.`tmp10`.`accountID`,`whMonthlyGroupPerf`.`id`,`tmp`.`tmp10`.`bidTypeID`,`tmp`.`tmp10`.`qualityScore` from `warehouse_1`.`whMonthlyGroupPerf` inner join `tmp`.`tmp10` on (((`whMonthlyGroupPerf`.`accountID`=`tmp`.`tmp10`.`accountID`) and (`whMonthlyGroupPerf`.`startTime`=`tmp`.`tmp10`.`startTime`) and (`whMonthlyGroupPerf`.`distributionID`=`tmp`.`tmp10`.`distributionID`) and (`whMonthlyGroupPerf`.`campaignID`=`tmp`.`tmp10`.`campaignID`) and (`whMonthlyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp10`.`searchEngineAccountID`) and (`whMonthlyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp10`.`searchEngineGroupID`) and (`whMonthlyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp10`.`searchEngineListingID`) and (`whMonthlyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp10`.`searchEngineMatchType`) and (`whMonthlyGroupPerf`.`type`=`tmp`.`tmp10`.`type`) and (`whMonthlyGroupPerf`.`nonSearchTag`=`tmp`.`tmp10`.`nonSearchTag`)))], genflags=no 2010-10-21 09:03:58.876 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2010-10-21 09:03:58.877 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2010-10-21 09:03:58.877 (4) [P1T1]: time=0.0070 2010-10-21 09:03:58.877 (4) [P1T1]: Query executed in 0.007s, 16 row(s) affected 2010-10-21 09:03:58.878 (3) [P1T1]: ... 16 Monthly Group Attribute Records Inserted 2010-10-21 09:03:58.878 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-21 09:03:58.878 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.884 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2010-10-21 09:03:58.885 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:58.885 (4) [P1T1]: time=0.0060 2010-10-21 09:03:58.886 (4) [P1T1]: Query executed in 0.006s 2010-10-21 09:03:58.886 (4) [P1T1]: DB AutoCommit -> true 2010-10-21 09:03:58.887 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-21 09:03:58.888 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.888 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp9`] 2010-10-21 09:03:58.890 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-21 09:03:58.890 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-21 09:03:58.890 (4) [P1T1]: time=0.0020 2010-10-21 09:03:58.891 (4) [P1T1]: Query executed in 0.002s 2010-10-21 09:03:58.891 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:58.891 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.891 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp10`] 2010-10-21 09:03:58.894 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:58.894 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:58.894 (4) [P1T1]: time=0.0030 2010-10-21 09:03:58.894 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:58.894 (5) [P1T1]: SQL execute() returned false 2010-10-21 09:03:58.895 (3) [P1T1]: Finished Account #17 WWMW - Cellular Safety Commission aggregates for Tue Aug 10 03:00:00 EDT 2010 to [select * from `dataAvailability` where ((`dataSourceID`="8602") and (`date`="2010-08-10 03:00:00")) limit 1] 2010-10-21 09:03:58.899 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-21 09:03:58.899 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-21 09:03:58.900 (4) [P1T1]: time=0.0030 2010-10-21 09:03:58.900 (4) [P1T1]: Query executed in 0.003s 2010-10-21 09:03:58.901 (4) [P1T1]: Record Not Found 2010-10-21 09:03:58.902 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.902 (4) [P1T1]: perfsum: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-08-10 03:00:00","2010-10-21 09:03:58")], genflags=yes 2010-10-21 09:03:58.906 (2) [P1T1]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-08-10 03:00:00","2010-10-21 09:03:58")] executed by user [perfsum] 2010-10-21 09:03:58.908 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-21 09:03:58.908 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2010-10-21 09:03:58.908 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2010-10-21 09:03:58.908 (4) [P1T1]: time=0.0060 2010-10-21 09:03:58.908 (4) [P1T1]: Query executed in 0.006s, 1 row(s) affected 2010-10-21 09:03:58.909 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-21 09:03:58.910 (4) [P1T1]: perfsum: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-08-10 03:00:00","2010-10-21 09:03:58")], genflags=yes 2010-10-21 09:03:58.916 (2) [P1T1]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-08-10 03:00:00","2010-10-21 09:03:58")] executed by user [perfsum] 2010-10-21 09:03:58.917 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-21 09:03:58.917 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2010-10-21 09:03:58.917 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2010-10-21 09:03:58.918 (4) [P1T1]: time=0.0070 2010-10-21 09:03:58.918 (4) [P1T1]: Query executed in 0.007s, 1 row(s) affected 2010-10-21 09:03:58.918 (4) [P1T1]: Returning Object to Pool 2010-10-21 09:03:58.919 (4) [P1T1]: Returning Object to Pool 2010-10-21 09:03:58.920 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-21 09:03:58.920 (3) [main]: ------------Warehouse Summarizer done 2010-10-21 09:03:58.920 (3) [main]: =============== Completed Warehouse Summarizer ================ 2010-10-21 09:03:58.920 (3) [main]: -- Renamed file 17_FB_20100810.csv to 17_FB_20100810.csv.done ? true 2010-10-21 09:03:58.921 (3) [main]: =============== Completed Publisher Generic Data Feed /177/, 2 products processed and 2 lines processed ================