2010-10-25 06:08:43.188 (3) [main]: Debug Level set to 5 2010-10-25 06:08:43.193 (3) [main]: No licensing config file found, assuming TSA production environment 2010-10-25 06:08:43.196 (5) [main]: yesterday: month=10, day=24, year=2010 2010-10-25 06:08:50.760 (3) [main]: Configured properties according to file :: /var/local/tsa/datafeedConfig/Facebook_VikingRiver.xml 2010-10-25 06:08:50.810 (5) [main]: parseInteger->[17] 2010-10-25 06:08:50.811 (5) [main]: parseInteger<-[17] 2010-10-25 06:08:51.275 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-25 06:08:52.949 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:08:52.960 (4) [main]: null key, and no data, unable to build condition 2010-10-25 06:08:53.002 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:53.004 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` limit 1] 2010-10-25 06:08:53.417 (5) [main]: recordAsSubs("db", 414, "main") 2010-10-25 06:08:53.418 (5) [main]: ProfilerRec.end("db", true): ret=414 2010-10-25 06:08:53.418 (4) [main]: time=0.414 2010-10-25 06:08:53.419 (4) [main]: Query executed in 0.414s 2010-10-25 06:08:53.425 (5) [main]: loading 19 columns from result set: 2010-10-25 06:08:53.427 (5) [main]: loaded column: accounts.id->1 2010-10-25 06:08:53.428 (5) [main]: loaded column: accounts.description->Admin Account 2010-10-25 06:08:53.433 (5) [main]: loaded column: accounts.tier->3 2010-10-25 06:08:53.434 (5) [main]: loaded column: accounts.priority->50 2010-10-25 06:08:53.434 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-25 06:08:53.435 (5) [main]: loaded column: accounts.reportConversions->false 2010-10-25 06:08:53.435 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-25 06:08:53.436 (5) [main]: loaded column: accounts.isBidManaged->false 2010-10-25 06:08:53.437 (5) [main]: loaded column: accounts.isActive->false 2010-10-25 06:08:53.438 (5) [main]: loaded column: accounts.perfMetric->cpa 2010-10-25 06:08:53.438 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-25 06:08:53.439 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-25 06:08:53.439 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-25 06:08:53.440 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-25 06:08:53.445 (5) [main]: loaded column: accounts.nowTime->null 2010-10-25 06:08:53.446 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-25 06:08:53.446 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-25 06:08:53.446 (5) [main]: loaded column: accounts.warehouseInstance->2 2010-10-25 06:08:53.448 (5) [main]: loaded column: accounts.isOnline->true 2010-10-25 06:08:53.448 (4) [main]: Record Loaded 2010-10-25 06:08:53.571 (4) [main]: DataCache: put key acct-st-tracker null 2010-10-25 06:08:53.577 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:53.577 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-1")) limit 1] 2010-10-25 06:08:53.923 (5) [main]: recordAsSubs("db", 346, "main") 2010-10-25 06:08:53.924 (5) [main]: ProfilerRec.end("db", true): ret=346 2010-10-25 06:08:53.925 (4) [main]: time=0.346 2010-10-25 06:08:53.925 (4) [main]: Query executed in 0.346s 2010-10-25 06:08:53.929 (5) [main]: loading 8 columns from result set: 2010-10-25 06:08:53.932 (5) [main]: loaded column: databaseInstances.id->15 2010-10-25 06:08:53.933 (5) [main]: loaded column: databaseInstances.name->acct-st-tracker-1 2010-10-25 06:08:53.933 (5) [main]: loaded column: databaseInstances.description->Account-specific Catch-all database 2010-10-25 06:08:53.934 (5) [main]: loaded column: databaseInstances.type->mysql 2010-10-25 06:08:53.934 (5) [main]: loaded column: databaseInstances.database->st-tracker 2010-10-25 06:08:53.934 (5) [main]: loaded column: databaseInstances.host->acctdb-01-write 2010-10-25 06:08:53.935 (5) [main]: loaded column: databaseInstances.port->3306 2010-10-25 06:08:53.935 (5) [main]: loaded column: databaseInstances.access->rw 2010-10-25 06:08:53.936 (4) [main]: Record Loaded 2010-10-25 06:08:53.936 (4) [main]: DataCache: put key acct-st-tracker-1 2010-10-25 06:08:53.942 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:08:53.954 (3) [main]: DatabasePool with a limit of 80 created 2010-10-25 06:08:53.959 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2010-10-25 06:08:54.404 (4) [main]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:08:54.405 (4) [main]: Created new Object 2010-10-25 06:08:54.405 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:54.406 (4) [main]: spike: SQL->[select @@version] 2010-10-25 06:08:54.411 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-25 06:08:54.411 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:08:54.411 (4) [main]: time=0.0040 2010-10-25 06:08:54.412 (4) [main]: Query executed in 0.004s 2010-10-25 06:08:54.423 (4) [main]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-25 06:08:54.424 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-25 06:08:54.424 (3) [main]: DatabasePool with a limit of 80 created 2010-10-25 06:08:54.694 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:08:54.694 (4) [main]: Created new Object 2010-10-25 06:08:54.695 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:54.716 (4) [main]: spike: SQL->[select @@version] 2010-10-25 06:08:54.723 (5) [main]: recordAsSubs("db", 7, "main") 2010-10-25 06:08:54.724 (5) [main]: ProfilerRec.end("db", true): ret=7 2010-10-25 06:08:54.724 (4) [main]: time=0.0070 2010-10-25 06:08:54.724 (4) [main]: Query executed in 0.007s 2010-10-25 06:08:54.725 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl" 2010-10-25 06:08:54.739 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:54.740 (4) [main]: spike: SQL->[select * from `tsacommon`.`accountDistributionMap` where ((`accountID`="17") and (`distributionID`="177")) limit 1] 2010-10-25 06:08:54.746 (5) [main]: recordAsSubs("db", 7, "main") 2010-10-25 06:08:54.747 (5) [main]: ProfilerRec.end("db", true): ret=7 2010-10-25 06:08:54.750 (4) [main]: time=0.0070 2010-10-25 06:08:54.750 (4) [main]: Query executed in 0.007s 2010-10-25 06:08:54.751 (3) [main]: Distribution status is [ACTIVE] for accountID[17], distributionID[177] 2010-10-25 06:08:54.774 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:54.775 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where ((`id`="177") and (`description`="Facebook") and (`shortCode`="FB")) limit 1] 2010-10-25 06:08:54.784 (5) [main]: recordAsSubs("db", 9, "main") 2010-10-25 06:08:54.785 (5) [main]: ProfilerRec.end("db", true): ret=9 2010-10-25 06:08:54.785 (4) [main]: time=0.0090 2010-10-25 06:08:54.785 (4) [main]: Query executed in 0.009s 2010-10-25 06:08:54.787 (5) [main]: loading 19 columns from result set: 2010-10-25 06:08:54.788 (5) [main]: loaded column: distribution.id->177 2010-10-25 06:08:54.792 (5) [main]: loaded column: distribution.accountID->0 2010-10-25 06:08:54.793 (5) [main]: loaded column: distribution.siteID->0 2010-10-25 06:08:54.793 (5) [main]: loaded column: distribution.type->paid search 2010-10-25 06:08:54.794 (5) [main]: loaded column: distribution.channelID->5 2010-10-25 06:08:54.794 (5) [main]: loaded column: distribution.showStats->1 2010-10-25 06:08:54.794 (5) [main]: loaded column: distribution.bidMatchTypes->null 2010-10-25 06:08:54.795 (5) [main]: loaded column: distribution.trackMatchTypes->null 2010-10-25 06:08:54.796 (5) [main]: loaded column: distribution.mergeMatchTypeStats->false 2010-10-25 06:08:54.799 (5) [main]: loaded column: distribution.rollupMatchTypes->null 2010-10-25 06:08:54.799 (5) [main]: loaded column: distribution.positionalBidding->false 2010-10-25 06:08:54.800 (5) [main]: loaded column: distribution.description->Facebook 2010-10-25 06:08:54.800 (5) [main]: loaded column: distribution.shortCode->fb 2010-10-25 06:08:54.801 (5) [main]: loaded column: distribution.searchEngineClass->null 2010-10-25 06:08:54.801 (5) [main]: loaded column: distribution.bidMinCPC->null 2010-10-25 06:08:54.826 (5) [main]: loaded column: distribution.bidCapCPC->null 2010-10-25 06:08:54.835 (5) [main]: loaded column: distribution.bidMinCPM->null 2010-10-25 06:08:54.837 (5) [main]: loaded column: distribution.bidCapCPM->null 2010-10-25 06:08:54.838 (5) [main]: skipping invalid column: distribution.obsolete 2010-10-25 06:08:54.841 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:08:54.847 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:54.847 (4) [main]: spike: SQL->[select id from `tsacommon`.`sites` where ((`accountID`=17)) limit 1] 2010-10-25 06:08:54.861 (5) [main]: recordAsSubs("db", 14, "main") 2010-10-25 06:08:54.865 (5) [main]: ProfilerRec.end("db", true): ret=14 2010-10-25 06:08:54.865 (4) [main]: time=0.014 2010-10-25 06:08:54.865 (4) [main]: Query executed in 0.014s 2010-10-25 06:08:54.866 (4) [main]: in getSiteID()... siteID[35] 2010-10-25 06:08:54.866 (4) [main]: -- Source Map 2010-10-25 06:08:54.867 (4) [main]: Map= 2010-10-25 06:08:54.868 (4) [main]: Ad Name [class java.lang.String] => altKey [class java.lang.String] 2010-10-25 06:08:54.868 (4) [main]: -- SourceBidType Map 2010-10-25 06:08:54.869 (4) [main]: Map= 2010-10-25 06:08:54.870 (4) [main]: -- Campaign Map 2010-10-25 06:08:54.873 (4) [main]: Map= 2010-10-25 06:08:54.873 (4) [main]: Campaign Name [class java.lang.String] => description [class java.lang.String] 2010-10-25 06:08:54.874 (4) [main]: -- Publishser Activity Map 2010-10-25 06:08:54.874 (4) [main]: Map= 2010-10-25 06:08:54.874 (4) [main]: Clicks [class java.lang.String] => count [class java.lang.String] 2010-10-25 06:08:54.875 (4) [main]: Impressions [class java.lang.String] => impressions [class java.lang.String] 2010-10-25 06:08:54.878 (4) [main]: -- Publishser Product Map 2010-10-25 06:08:54.879 (4) [main]: Map= 2010-10-25 06:08:54.879 (4) [main]: Conversions [class java.lang.String] => count [class java.lang.String] 2010-10-25 06:08:56.402 (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_177_ 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 :: Social Impressions delimiter :: null headers :: Social % delimiter :: null headers :: Clicks delimiter :: null headers :: Social Clicks delimiter :: null headers :: CTR delimiter :: null headers :: Social CTR 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 CTR 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-25 06:08:56.420 (4) [main]: -- theHeaderDetails: 2010-10-25 06:08:56.427 (4) [main]: List= 2010-10-25 06:08:56.428 (4) [main]: 0: dfColumn :: Ad Name, dbTable :: sources, dbColumn :: altKey, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-25 06:08:56.429 (4) [main]: 1: dfColumn :: Impressions, dbTable :: publisherActivitySummary, dbColumn :: impressions, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-25 06:08:56.429 (4) [main]: 2: dfColumn :: Clicks, dbTable :: publisherActivitySummary, dbColumn :: count, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-25 06:08:56.430 (4) [main]: 3: dfColumn :: Conversions, dbTable :: publisherProductSummary, dbColumn :: count, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-25 06:08:56.430 (4) [main]: 4: dfColumn :: Campaign Name, dbTable :: campaigns, dbColumn :: description, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-25 06:08:56.431 (4) [main]: -- theDistributionName: Facebook 2010-10-25 06:08:56.431 (4) [main]: -- theDistributionId: 177 2010-10-25 06:08:56.431 (4) [main]: -- theDistributionShortCode: FB 2010-10-25 06:08:56.433 (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-25 06:08:56.433 (3) [main]: =============== Starting Publisher Generic Data Feed Facebook ================ 2010-10-25 06:08:56.435 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-25 06:08:56.717 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:08:56.717 (4) [main]: Created new Object 2010-10-25 06:08:56.718 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:56.718 (4) [main]: spike: SQL->[select @@version] 2010-10-25 06:08:56.726 (5) [main]: recordAsSubs("db", 8, "main") 2010-10-25 06:08:56.729 (5) [main]: ProfilerRec.end("db", true): ret=8 2010-10-25 06:08:56.729 (4) [main]: time=0.0080 2010-10-25 06:08:56.730 (4) [main]: Query executed in 0.008s 2010-10-25 06:08:56.730 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl" 2010-10-25 06:08:56.731 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:08:56.732 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:56.732 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=17) limit 1] 2010-10-25 06:08:56.738 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-25 06:08:56.739 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-25 06:08:56.743 (4) [main]: time=0.0060 2010-10-25 06:08:56.744 (4) [main]: Query executed in 0.006s 2010-10-25 06:08:56.744 (5) [main]: loading 19 columns from result set: 2010-10-25 06:08:56.748 (5) [main]: loaded column: accounts.id->17 2010-10-25 06:08:56.749 (5) [main]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-25 06:08:56.750 (5) [main]: loaded column: accounts.tier->2 2010-10-25 06:08:56.750 (5) [main]: loaded column: accounts.priority->60 2010-10-25 06:08:56.751 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-25 06:08:56.751 (5) [main]: loaded column: accounts.reportConversions->true 2010-10-25 06:08:56.752 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-25 06:08:56.753 (5) [main]: loaded column: accounts.isBidManaged->true 2010-10-25 06:08:56.754 (5) [main]: loaded column: accounts.isActive->true 2010-10-25 06:08:56.754 (5) [main]: loaded column: accounts.perfMetric->roi 2010-10-25 06:08:56.755 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-25 06:08:56.757 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-25 06:08:56.758 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-25 06:08:56.759 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-25 06:08:56.760 (5) [main]: loaded column: accounts.nowTime->null 2010-10-25 06:08:56.799 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-25 06:08:56.800 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-25 06:08:56.800 (5) [main]: loaded column: accounts.warehouseInstance->1 2010-10-25 06:08:56.801 (5) [main]: loaded column: accounts.isOnline->true 2010-10-25 06:08:56.801 (4) [main]: Record Loaded 2010-10-25 06:08:56.806 (4) [main]: Returning Object to Pool 2010-10-25 06:08:56.807 (3) [main]: Found 1 Facebook file(s)... 2010-10-25 06:08:56.810 (3) [main]: Files... [/var/local/tsa/publishers/17/177/17_177_20101016.csv] 2010-10-25 06:08:56.811 (3) [main]: Loading file /var/local/tsa/publishers/17/177/17_177_20101016.csv 2010-10-25 06:08:56.814 (3) [main]: Account [17]: deleting old publisher data (2010-10-16 00:00:00) 2010-10-25 06:08:56.825 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-25 06:08:57.185 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:08:57.186 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:08:57.190 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:57.190 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=17) limit 1] 2010-10-25 06:08:57.200 (5) [main]: recordAsSubs("db", 10, "main") 2010-10-25 06:08:57.200 (5) [main]: ProfilerRec.end("db", true): ret=10 2010-10-25 06:08:57.201 (4) [main]: time=0.01 2010-10-25 06:08:57.204 (4) [main]: Query executed in 0.010s 2010-10-25 06:08:57.205 (5) [main]: loading 19 columns from result set: 2010-10-25 06:08:57.205 (5) [main]: loaded column: accounts.id->17 2010-10-25 06:08:57.206 (5) [main]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-25 06:08:57.206 (5) [main]: loaded column: accounts.tier->2 2010-10-25 06:08:57.206 (5) [main]: loaded column: accounts.priority->60 2010-10-25 06:08:57.207 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-25 06:08:57.208 (5) [main]: loaded column: accounts.reportConversions->true 2010-10-25 06:08:57.212 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-25 06:08:57.212 (5) [main]: loaded column: accounts.isBidManaged->true 2010-10-25 06:08:57.213 (5) [main]: loaded column: accounts.isActive->true 2010-10-25 06:08:57.214 (5) [main]: loaded column: accounts.perfMetric->roi 2010-10-25 06:08:57.214 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-25 06:08:57.214 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-25 06:08:57.215 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-25 06:08:57.216 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-25 06:08:57.620 (5) [main]: loaded column: accounts.nowTime->null 2010-10-25 06:08:57.621 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-25 06:08:57.622 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-25 06:08:57.624 (5) [main]: loaded column: accounts.warehouseInstance->1 2010-10-25 06:08:57.625 (5) [main]: loaded column: accounts.isOnline->true 2010-10-25 06:08:57.625 (4) [main]: Record Loaded 2010-10-25 06:08:57.626 (4) [main]: DataCache: put key acct-st-tracker 17 2010-10-25 06:08:57.626 (4) [main]: DataCache: Found key acct-st-tracker-1 2010-10-25 06:08:57.631 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:08:57.975 (4) [main]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:08:57.994 (4) [main]: Created new Object 2010-10-25 06:08:57.999 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:58.000 (4) [main]: spike: SQL->[select @@version] 2010-10-25 06:08:58.010 (5) [main]: recordAsSubs("db", 10, "main") 2010-10-25 06:08:58.011 (5) [main]: ProfilerRec.end("db", true): ret=10 2010-10-25 06:08:58.013 (4) [main]: time=0.01 2010-10-25 06:08:58.013 (4) [main]: Query executed in 0.010s 2010-10-25 06:08:58.014 (4) [main]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-25 06:08:58.015 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:08:58.021 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:58.022 (4) [main]: spike: SQL->[delete from `publisherActivitySummary` where ((`publisherActivitySummary`.`accountID`=17) and (`publisherActivitySummary`.`distributionID`="177") and (`publisherActivitySummary`.`startTime`>="2010-10-16 00:00:00") and (`publisherActivitySummary`.`startTime`<="2010-10-16 23:59:59"))], genflags=no 2010-10-25 06:08:58.030 (5) [main]: recordAsSubs("db", 8, "main") 2010-10-25 06:08:58.329 (5) [main]: ProfilerRec.end("db", true): ret=8 2010-10-25 06:08:58.335 (4) [main]: time=0.0080 2010-10-25 06:08:58.336 (4) [main]: Query executed in 0.008s, 0 row(s) affected 2010-10-25 06:08:58.340 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:08:58.344 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:58.345 (4) [main]: spike: SQL->[delete from `publisherProductSummary` where ((`publisherProductSummary`.`accountID`=17) and (`publisherProductSummary`.`distributionID`="177") and (`publisherProductSummary`.`startTime`>="2010-10-16 00:00:00") and (`publisherProductSummary`.`startTime`<="2010-10-16 23:59:59"))], genflags=no 2010-10-25 06:08:58.351 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-25 06:08:58.352 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-25 06:08:58.353 (4) [main]: time=0.0060 2010-10-25 06:08:58.354 (4) [main]: Query executed in 0.006s, 0 row(s) affected 2010-10-25 06:08:58.396 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:58.396 (4) [main]: spike: SQL->[select * from `dataSources` where ((`accountID`="17") and (`type`="publisher") and (`typeID`="177")) limit 1] 2010-10-25 06:08:58.405 (5) [main]: recordAsSubs("db", 9, "main") 2010-10-25 06:08:58.407 (5) [main]: ProfilerRec.end("db", true): ret=9 2010-10-25 06:08:58.409 (4) [main]: time=0.0090 2010-10-25 06:08:58.411 (4) [main]: Query executed in 0.009s 2010-10-25 06:08:58.412 (5) [main]: loading 4 columns from result set: 2010-10-25 06:08:58.414 (5) [main]: loaded column: dataSources.id->223001 2010-10-25 06:08:58.417 (5) [main]: loaded column: dataSources.type->publisher 2010-10-25 06:08:58.418 (5) [main]: loaded column: dataSources.typeID->177 2010-10-25 06:08:58.420 (5) [main]: loaded column: dataSources.accountID->17 2010-10-25 06:08:58.420 (4) [main]: Record Loaded 2010-10-25 06:08:58.435 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:58.435 (4) [main]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="223001") and (`date`="2010-10-23 03:00:00")) limit 1] 2010-10-25 06:08:58.578 (5) [main]: recordAsSubs("db", 143, "main") 2010-10-25 06:08:58.579 (5) [main]: ProfilerRec.end("db", true): ret=143 2010-10-25 06:08:58.582 (4) [main]: time=0.143 2010-10-25 06:08:58.604 (4) [main]: Query executed in 0.143s 2010-10-25 06:08:58.609 (4) [main]: Record Not Found 2010-10-25 06:08:58.626 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:58.627 (4) [main]: spike: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-23 03:00:00","2010-10-25 06:08:58")], genflags=yes 2010-10-25 06:08:58.638 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-23 03:00:00","2010-10-25 06:08:58")] executed by user [spike] 2010-10-25 06:08:58.643 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-25 06:08:58.644 (5) [main]: recordAsSubs("db", 17, "main") 2010-10-25 06:08:58.646 (5) [main]: ProfilerRec.end("db", true): ret=17 2010-10-25 06:08:58.647 (4) [main]: time=0.017 2010-10-25 06:08:58.648 (4) [main]: Query executed in 0.017s, 1 row(s) affected 2010-10-25 06:08:58.670 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:58.671 (4) [main]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-23 03:00:00","2010-10-25 06:08:58")], genflags=yes 2010-10-25 06:08:58.679 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-23 03:00:00","2010-10-25 06:08:58")] executed by user [spike] 2010-10-25 06:08:58.688 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-25 06:08:58.688 (5) [main]: recordAsSubs("db", 17, "main") 2010-10-25 06:08:58.691 (5) [main]: ProfilerRec.end("db", true): ret=17 2010-10-25 06:08:58.693 (4) [main]: time=0.017 2010-10-25 06:08:58.695 (4) [main]: Query executed in 0.017s, 1 row(s) affected 2010-10-25 06:08:58.699 (3) [main]: loading "/var/local/tsa/publishers/17/177/17_177_20101016.csv"... 2010-10-25 06:08:58.700 (3) [main]: Account [17]: deleting old publisher data (2010-10-23 00:00:00) 2010-10-25 06:08:58.701 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:08:58.710 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:58.712 (4) [main]: spike: SQL->[delete from `publisherActivitySummary` where ((`publisherActivitySummary`.`accountID`=17) and (`publisherActivitySummary`.`distributionID`="177") and (`publisherActivitySummary`.`startTime`>="2010-10-23 00:00:00") and (`publisherActivitySummary`.`startTime`<="2010-10-23 23:59:59"))], genflags=no 2010-10-25 06:08:58.719 (5) [main]: recordAsSubs("db", 8, "main") 2010-10-25 06:08:58.721 (5) [main]: ProfilerRec.end("db", true): ret=8 2010-10-25 06:08:58.722 (4) [main]: time=0.0080 2010-10-25 06:08:58.724 (4) [main]: Query executed in 0.008s, 0 row(s) affected 2010-10-25 06:08:58.727 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:08:58.734 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:58.737 (4) [main]: spike: SQL->[delete from `publisherProductSummary` where ((`publisherProductSummary`.`accountID`=17) and (`publisherProductSummary`.`distributionID`="177") and (`publisherProductSummary`.`startTime`>="2010-10-23 00:00:00") and (`publisherProductSummary`.`startTime`<="2010-10-23 23:59:59"))], genflags=no 2010-10-25 06:08:58.746 (5) [main]: recordAsSubs("db", 10, "main") 2010-10-25 06:08:58.748 (5) [main]: ProfilerRec.end("db", true): ret=10 2010-10-25 06:08:58.751 (4) [main]: time=0.01 2010-10-25 06:08:58.752 (4) [main]: Query executed in 0.010s, 0 row(s) affected 2010-10-25 06:08:58.758 (5) [main]: No custom filter, returning FileInputStream 2010-10-25 06:08:58.763 (1) [main]: Problem reading header row; header information not set! 2010-10-25 06:08:58.767 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:08:58.767 (4) [main]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="223001") and (`date`="2010-10-23 03:00:00")) limit 1] 2010-10-25 06:08:58.778 (5) [main]: recordAsSubs("db", 10, "main") 2010-10-25 06:08:58.780 (5) [main]: ProfilerRec.end("db", true): ret=10 2010-10-25 06:08:58.782 (4) [main]: time=0.01 2010-10-25 06:08:58.782 (4) [main]: Query executed in 0.010s 2010-10-25 06:08:59.400 (4) [main]: Record Not Found 2010-10-25 06:09:00.116 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:09:00.117 (4) [main]: spike: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-23 03:00:00","2010-10-25 06:08:58")], genflags=yes 2010-10-25 06:09:00.132 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-23 03:00:00","2010-10-25 06:08:58")] executed by user [spike] 2010-10-25 06:09:00.150 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-25 06:09:00.150 (5) [main]: recordAsSubs("db", 33, "main") 2010-10-25 06:09:00.150 (5) [main]: ProfilerRec.end("db", true): ret=33 2010-10-25 06:09:00.150 (4) [main]: time=0.033 2010-10-25 06:09:00.150 (4) [main]: Query executed in 0.033s, 1 row(s) affected 2010-10-25 06:09:00.154 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:09:01.538 (4) [main]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-23 03:00:00","2010-10-25 06:08:58")], genflags=yes 2010-10-25 06:09:01.583 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-23 03:00:00","2010-10-25 06:08:58")] executed by user [spike] 2010-10-25 06:09:01.586 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-25 06:09:01.586 (5) [main]: recordAsSubs("db", 1431, "main") 2010-10-25 06:09:01.586 (5) [main]: ProfilerRec.end("db", true): ret=1431 2010-10-25 06:09:01.586 (4) [main]: time=1.431 2010-10-25 06:09:01.598 (4) [main]: Query executed in 1.431s, 1 row(s) affected 2010-10-25 06:09:01.601 (3) [main]: calling warehouse summarization with args: --debug 5 --accountid 17 --distribution 177 --date 2010-10-16 --publisher 2010-10-25 06:09:01.686 (3) [main]: Debug Level set to 5 2010-10-25 06:09:01.686 (4) [main]: limited to Distribution(s) (177) 2010-10-25 06:09:01.686 (2) [main]: No granularity given, all 2010-10-25 06:09:01.688 (3) [main]: =============== Starting Warehouse Summarizer ================ 2010-10-25 06:09:01.688 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-25 06:09:01.689 (3) [main]: ----------------Warehouse Summarizer starting 2010-10-25 06:09:01.744 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:09:01.745 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:09:01.745 (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-25 06:09:01.749 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-25 06:09:01.749 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:01.749 (4) [main]: time=0.0040 2010-10-25 06:09:01.749 (4) [main]: Query executed in 0.004s 2010-10-25 06:09:01.750 (5) [main]: loading 19 columns from result set: 2010-10-25 06:09:01.750 (5) [main]: loaded column: accounts.id->17 2010-10-25 06:09:01.750 (5) [main]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-25 06:09:01.751 (5) [main]: loaded column: accounts.tier->2 2010-10-25 06:09:01.751 (5) [main]: loaded column: accounts.priority->60 2010-10-25 06:09:01.751 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-25 06:09:01.751 (5) [main]: loaded column: accounts.reportConversions->true 2010-10-25 06:09:01.752 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-25 06:09:01.752 (5) [main]: loaded column: accounts.isBidManaged->true 2010-10-25 06:09:01.752 (5) [main]: loaded column: accounts.isActive->true 2010-10-25 06:09:01.753 (5) [main]: loaded column: accounts.perfMetric->roi 2010-10-25 06:09:01.753 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-25 06:09:01.753 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-25 06:09:01.754 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-25 06:09:01.754 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-25 06:09:01.754 (5) [main]: loaded column: accounts.nowTime->null 2010-10-25 06:09:01.754 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-25 06:09:01.755 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-25 06:09:01.755 (5) [main]: loaded column: accounts.warehouseInstance->1 2010-10-25 06:09:01.755 (5) [main]: loaded column: accounts.isOnline->true 2010-10-25 06:09:01.755 (4) [main]: DataCache: put key dwh 17 2010-10-25 06:09:01.756 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-25 06:09:01.783 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:09:01.784 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-25 06:09:01.784 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="dwh-1")) limit 1] 2010-10-25 06:09:01.787 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-25 06:09:01.787 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-25 06:09:01.787 (4) [main]: time=0.0030 2010-10-25 06:09:01.788 (4) [main]: Query executed in 0.003s 2010-10-25 06:09:01.788 (5) [main]: loading 8 columns from result set: 2010-10-25 06:09:01.788 (5) [main]: loaded column: databaseInstances.id->8 2010-10-25 06:09:01.788 (5) [main]: loaded column: databaseInstances.name->dwh-1 2010-10-25 06:09:01.789 (5) [main]: loaded column: databaseInstances.description->Account-specific Warehouse 01 2010-10-25 06:09:01.790 (5) [main]: loaded column: databaseInstances.type->mysql 2010-10-25 06:09:01.790 (5) [main]: loaded column: databaseInstances.database->warehouse_1 2010-10-25 06:09:01.791 (5) [main]: loaded column: databaseInstances.host->dwh-01-write 2010-10-25 06:09:01.791 (5) [main]: loaded column: databaseInstances.port->3306 2010-10-25 06:09:01.791 (5) [main]: loaded column: databaseInstances.access->rw 2010-10-25 06:09:01.791 (4) [main]: Record Loaded 2010-10-25 06:09:01.792 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:09:01.792 (4) [main]: DatabaseAccounts.getDatabaseName() returning "warehouse_1" 2010-10-25 06:09:01.834 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2010-10-25 06:09:01.949 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-25 06:09:02.430 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:09:02.431 (4) [P1T1]: Created new Object 2010-10-25 06:09:02.431 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:02.432 (4) [P1T1]: perfsum: SQL->[select @@version] 2010-10-25 06:09:02.434 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-25 06:09:02.435 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-25 06:09:02.435 (4) [P1T1]: time=0.0020 2010-10-25 06:09:02.436 (4) [P1T1]: Query executed in 0.002s 2010-10-25 06:09:02.436 (4) [P1T1]: test query succeeded, returned "5.0.30-enterprise-gpl" 2010-10-25 06:09:02.437 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:02.437 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:02.438 (4) [P1T1]: perfsum: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=17) limit 1] 2010-10-25 06:09:02.441 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-25 06:09:02.442 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-25 06:09:02.442 (4) [P1T1]: time=0.0030 2010-10-25 06:09:02.615 (4) [P1T1]: Query executed in 0.003s 2010-10-25 06:09:02.615 (5) [P1T1]: loading 19 columns from result set: 2010-10-25 06:09:02.616 (5) [P1T1]: loaded column: accounts.id->17 2010-10-25 06:09:02.616 (5) [P1T1]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-25 06:09:02.617 (5) [P1T1]: loaded column: accounts.tier->2 2010-10-25 06:09:02.617 (5) [P1T1]: loaded column: accounts.priority->60 2010-10-25 06:09:02.618 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2010-10-25 06:09:02.618 (5) [P1T1]: loaded column: accounts.reportConversions->true 2010-10-25 06:09:02.619 (5) [P1T1]: loaded column: accounts.conversionTypes-> 2010-10-25 06:09:02.619 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2010-10-25 06:09:02.620 (5) [P1T1]: loaded column: accounts.isActive->true 2010-10-25 06:09:02.620 (5) [P1T1]: loaded column: accounts.perfMetric->roi 2010-10-25 06:09:02.621 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2010-10-25 06:09:02.621 (5) [P1T1]: loaded column: accounts.addConversionData->false 2010-10-25 06:09:02.622 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2010-10-25 06:09:02.622 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2010-10-25 06:09:02.623 (5) [P1T1]: loaded column: accounts.nowTime->null 2010-10-25 06:09:02.623 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2010-10-25 06:09:02.624 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2010-10-25 06:09:02.624 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2010-10-25 06:09:02.624 (5) [P1T1]: loaded column: accounts.isOnline->true 2010-10-25 06:09:02.625 (4) [P1T1]: Record Loaded 2010-10-25 06:09:02.625 (4) [P1T1]: Returning Object to Pool 2010-10-25 06:09:02.626 (5) [P1T1]: yesterday: month=10, day=24, year=2010 2010-10-25 06:09:02.626 (4) [P1T1]: isYesterday = false 2010-10-25 06:09:02.627 (4) [P1T1]: DataCache: Found key acct-st-tracker 17 2010-10-25 06:09:02.627 (4) [P1T1]: DataCache: Found key acct-st-tracker-1 2010-10-25 06:09:02.628 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-25 06:09:02.663 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:09:02.664 (4) [P1T1]: Created new Object 2010-10-25 06:09:02.664 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:02.665 (4) [P1T1]: perfsum: SQL->[select @@version] 2010-10-25 06:09:02.669 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:02.670 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:02.670 (4) [P1T1]: time=0.0040 2010-10-25 06:09:02.671 (4) [P1T1]: Query executed in 0.004s 2010-10-25 06:09:02.671 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-25 06:09:02.672 (4) [P1T1]: DataCache: Found key dwh 17 2010-10-25 06:09:02.672 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2010-10-25 06:09:02.899 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:09:02.901 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:02.901 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="dwh-1")) limit 1] 2010-10-25 06:09:02.904 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-25 06:09:02.904 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-25 06:09:02.905 (4) [P1T1]: time=0.0030 2010-10-25 06:09:02.905 (4) [P1T1]: Query executed in 0.003s 2010-10-25 06:09:02.905 (5) [P1T1]: loading 8 columns from result set: 2010-10-25 06:09:02.906 (5) [P1T1]: loaded column: databaseInstances.id->8 2010-10-25 06:09:02.906 (5) [P1T1]: loaded column: databaseInstances.name->dwh-1 2010-10-25 06:09:02.906 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Warehouse 01 2010-10-25 06:09:02.907 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2010-10-25 06:09:02.907 (5) [P1T1]: loaded column: databaseInstances.database->warehouse_1 2010-10-25 06:09:02.908 (5) [P1T1]: loaded column: databaseInstances.host->dwh-01-write 2010-10-25 06:09:02.908 (5) [P1T1]: loaded column: databaseInstances.port->3306 2010-10-25 06:09:02.908 (5) [P1T1]: loaded column: databaseInstances.access->rw 2010-10-25 06:09:02.909 (4) [P1T1]: Record Loaded 2010-10-25 06:09:03.350 (4) [P1T1]: DataCache: put key dwh-1 2010-10-25 06:09:03.351 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:09:03.352 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-25 06:09:03.626 (4) [P1T1]: opened [jdbc:mysql://dwh-01-write:3306/warehouse_1?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:09:03.627 (4) [P1T1]: Created new Object 2010-10-25 06:09:03.630 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:03.631 (4) [P1T1]: perfsum: SQL->[select @@version] 2010-10-25 06:09:03.636 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-25 06:09:03.637 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-25 06:09:03.638 (4) [P1T1]: time=0.0050 2010-10-25 06:09:03.638 (4) [P1T1]: Query executed in 0.005s 2010-10-25 06:09:03.638 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-25 06:09:03.642 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:03.643 (4) [P1T1]: perfsum: SQL->[set net_read_timeout = 36000] 2010-10-25 06:09:03.669 (5) [P1T1]: recordAsSubs("db", 26, "P1T1") 2010-10-25 06:09:03.669 (5) [P1T1]: ProfilerRec.end("db", true): ret=26 2010-10-25 06:09:03.673 (4) [P1T1]: time=0.026 2010-10-25 06:09:03.674 (4) [P1T1]: Query executed in 0.026s 2010-10-25 06:09:03.674 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:03.674 (4) [P1T1]: perfsum: SQL->[set net_write_timeout = 36000] 2010-10-25 06:09:03.687 (5) [P1T1]: recordAsSubs("db", 13, "P1T1") 2010-10-25 06:09:03.687 (5) [P1T1]: ProfilerRec.end("db", true): ret=13 2010-10-25 06:09:03.688 (4) [P1T1]: time=0.013 2010-10-25 06:09:03.688 (4) [P1T1]: Query executed in 0.013s 2010-10-25 06:09:03.688 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:03.689 (4) [P1T1]: perfsum: SQL->[set net_read_timeout = 36000] 2010-10-25 06:09:04.032 (5) [P1T1]: recordAsSubs("db", 343, "P1T1") 2010-10-25 06:09:04.034 (5) [P1T1]: ProfilerRec.end("db", true): ret=343 2010-10-25 06:09:04.035 (4) [P1T1]: time=0.343 2010-10-25 06:09:04.037 (4) [P1T1]: Query executed in 0.343s 2010-10-25 06:09:04.038 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.039 (4) [P1T1]: perfsum: SQL->[set net_write_timeout = 36000] 2010-10-25 06:09:04.043 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:04.043 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:04.047 (4) [P1T1]: time=0.0040 2010-10-25 06:09:04.048 (4) [P1T1]: Query executed in 0.004s 2010-10-25 06:09:04.048 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.051 (4) [P1T1]: perfsum: SQL->[SELECT GET_LOCK('WarehouseSummarizer.syncDimensions.17', 300)] 2010-10-25 06:09:04.055 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-25 06:09:04.055 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-25 06:09:04.055 (4) [P1T1]: time=0.0050 2010-10-25 06:09:04.056 (4) [P1T1]: Query executed in 0.005s 2010-10-25 06:09:04.064 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:04.065 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.065 (4) [P1T1]: perfsum: SQL->[select * from `whDimensionSyncStatus` where (`accountID`=17) limit 1] 2010-10-25 06:09:04.073 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2010-10-25 06:09:04.073 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2010-10-25 06:09:04.074 (4) [P1T1]: time=0.0080 2010-10-25 06:09:04.074 (4) [P1T1]: Query executed in 0.008s 2010-10-25 06:09:04.074 (5) [P1T1]: loading 2 columns from result set: 2010-10-25 06:09:04.075 (5) [P1T1]: loaded column: whDimensionSyncStatus.accountID->17 2010-10-25 06:09:04.113 (5) [P1T1]: loaded column: whDimensionSyncStatus.syncTime->2010-10-25 02:31:54.0 2010-10-25 06:09:04.113 (4) [P1T1]: Record Loaded 2010-10-25 06:09:04.113 (3) [P1T1]: Skipping sync of dimensions for acct #17 (last sync was at 2010-10-25 02:31:54.0) 2010-10-25 06:09:04.118 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.118 (4) [P1T1]: perfsum: SQL->[SELECT RELEASE_LOCK('WarehouseSummarizer.syncDimensions.17')] 2010-10-25 06:09:04.123 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-25 06:09:04.124 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-25 06:09:04.124 (4) [P1T1]: time=0.0050 2010-10-25 06:09:04.125 (4) [P1T1]: Query executed in 0.005s 2010-10-25 06:09:04.126 (3) [P1T1]: Starting daily for Account #17 WWMW - Cellular Safety Commission for Sat Oct 16 03:00:00 EDT 2010 2010-10-25 06:09:04.127 (3) [P1T1]: Updating perf rows that don't have a bidTargetID, but should... for Dist(s) (177) 2010-10-25 06:09:04.156 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:04.361 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.437 (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-10-16 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-25 06:09:04.448 (5) [P1T1]: recordAsSubs("db", 11, "P1T1") 2010-10-25 06:09:04.554 (5) [P1T1]: ProfilerRec.end("db", true): ret=11 2010-10-25 06:09:04.571 (4) [P1T1]: time=0.011 2010-10-25 06:09:04.577 (4) [P1T1]: Query executed in 0.011s 2010-10-25 06:09:04.579 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.580 (4) [P1T1]: perfsum: SQL->[select COUNT(*) from `warehouse_1`.`whDailySourcePerf` inner join `tsacommon`.`distribution` on ((`whDailySourcePerf`.`distributionID`=`tsacommon`.`distribution`.`id`)) where (((`whDailySourcePerf`.`startTime`="2010-10-16 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-25 06:09:04.582 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-25 06:09:04.583 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-25 06:09:04.585 (4) [P1T1]: time=0.0020 2010-10-25 06:09:04.585 (4) [P1T1]: Query executed in 0.002s 2010-10-25 06:09:04.611 (5) [P1T1]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-25 06:09:04.613 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:04.616 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.617 (4) [P1T1]: perfsum: SQL->[select * from `publisherActivitySummary` join `sources` on ((`sources`.`id`=`publisherActivitySummary`.`sourceID`)) where (((`publisherActivitySummary`.`startTime`="2010-10-16 03:00:00")) and (`publisherActivitySummary`.`resolution`=86400) and (`publisherActivitySummary`.`accountID`=17) and (`sources`.`distributionID` in (177))) limit 1] 2010-10-25 06:09:04.622 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-25 06:09:04.624 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-25 06:09:04.625 (4) [P1T1]: time=0.0050 2010-10-25 06:09:04.625 (4) [P1T1]: Query executed in 0.005s 2010-10-25 06:09:04.626 (3) [P1T1]: no publisher data for account #17 in dist (177) 2010-10-25 06:09:04.626 (3) [P1T1]: Finished daily for Account #17 WWMW - Cellular Safety Commission on Sat Oct 16 03:00:00 EDT 2010 2010-10-25 06:09:04.628 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.629 (4) [P1T1]: perfsum: SQL->[select * from `dataSources` where ((`accountID`="17") and (`type`="wh_lowgran")) limit 1] 2010-10-25 06:09:04.853 (5) [P1T1]: recordAsSubs("db", 225, "P1T1") 2010-10-25 06:09:04.854 (5) [P1T1]: ProfilerRec.end("db", true): ret=225 2010-10-25 06:09:04.855 (4) [P1T1]: time=0.225 2010-10-25 06:09:04.855 (4) [P1T1]: Query executed in 0.225s 2010-10-25 06:09:04.856 (5) [P1T1]: loading 4 columns from result set: 2010-10-25 06:09:04.856 (5) [P1T1]: loaded column: dataSources.id->8602 2010-10-25 06:09:04.857 (5) [P1T1]: loaded column: dataSources.type->wh_lowgran 2010-10-25 06:09:04.857 (5) [P1T1]: loaded column: dataSources.typeID->null 2010-10-25 06:09:04.858 (5) [P1T1]: loaded column: dataSources.accountID->17 2010-10-25 06:09:04.858 (4) [P1T1]: Record Loaded 2010-10-25 06:09:04.860 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.860 (4) [P1T1]: perfsum: SQL->[select * from `dataAvailability` where ((`dataSourceID`="8602") and (`date`="2010-10-16 03:00:00")) limit 1] 2010-10-25 06:09:04.874 (5) [P1T1]: recordAsSubs("db", 14, "P1T1") 2010-10-25 06:09:04.875 (5) [P1T1]: ProfilerRec.end("db", true): ret=14 2010-10-25 06:09:04.875 (4) [P1T1]: time=0.014 2010-10-25 06:09:04.876 (4) [P1T1]: Query executed in 0.014s 2010-10-25 06:09:04.876 (4) [P1T1]: Record Not Found 2010-10-25 06:09:04.900 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.901 (4) [P1T1]: perfsum: SQL->[select * from `dataAvailability` where ((`dataSourceID`="8602") and (`date`="2010-10-16 03:00:00")) limit 1] 2010-10-25 06:09:04.906 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-25 06:09:04.906 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-25 06:09:04.909 (4) [P1T1]: time=0.0050 2010-10-25 06:09:04.909 (4) [P1T1]: Query executed in 0.005s 2010-10-25 06:09:04.912 (4) [P1T1]: Record Not Found 2010-10-25 06:09:04.915 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.916 (4) [P1T1]: perfsum: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-10-16 03:00:00","2010-10-25 06:09:04")], genflags=yes 2010-10-25 06:09:04.929 (2) [P1T1]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-10-16 03:00:00","2010-10-25 06:09:04")] executed by user [perfsum] 2010-10-25 06:09:04.935 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-25 06:09:04.937 (5) [P1T1]: recordAsSubs("db", 21, "P1T1") 2010-10-25 06:09:04.937 (5) [P1T1]: ProfilerRec.end("db", true): ret=21 2010-10-25 06:09:04.939 (4) [P1T1]: time=0.021 2010-10-25 06:09:04.939 (4) [P1T1]: Query executed in 0.021s, 1 row(s) affected 2010-10-25 06:09:04.944 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:04.945 (4) [P1T1]: perfsum: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-10-16 03:00:00","2010-10-25 06:09:04")], genflags=yes 2010-10-25 06:09:04.951 (2) [P1T1]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-10-16 03:00:00","2010-10-25 06:09:04")] executed by user [perfsum] 2010-10-25 06:09:04.957 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-25 06:09:04.957 (5) [P1T1]: recordAsSubs("db", 12, "P1T1") 2010-10-25 06:09:04.957 (5) [P1T1]: ProfilerRec.end("db", true): ret=12 2010-10-25 06:09:04.958 (4) [P1T1]: time=0.012 2010-10-25 06:09:04.958 (4) [P1T1]: Query executed in 0.012s, 1 row(s) affected 2010-10-25 06:09:04.959 (3) [P1T1]: Starting Account #17 WWMW - Cellular Safety Commission aggregates for Sat Oct 16 03:00:00 EDT 2010 to [17], type=class java.lang.Integer 2010-10-25 06:09:04.968 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:04.971 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:05.320 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-25 06:09:05.321 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-25 06:09:05.385 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-25 06:09:05.388 (4) [P1T1]: DB AutoCommit -> false 2010-10-25 06:09:05.390 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:05.391 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whWeeklySourceConv` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-16 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-10-16 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-10-16 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-10-16 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-10-16 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-25 06:09:05.794 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2010-10-25 06:09:05.795 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2010-10-25 06:09:05.795 (4) [P1T1]: time=0.0070 2010-10-25 06:09:05.795 (4) [P1T1]: Query executed in 0.007s, 3 row(s) affected 2010-10-25 06:09:05.795 (3) [P1T1]: ... 3 Weekly Source Conversion Records Inserted 2010-10-25 06:09:05.796 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:05.797 (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-10-16 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-25 06:09:05.811 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:05.811 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:05.811 (4) [P1T1]: time=0.0040 2010-10-25 06:09:05.811 (4) [P1T1]: Query executed in 0.004s, 4 row(s) affected 2010-10-25 06:09:05.811 (3) [P1T1]: ... 4 Weekly Source Attribute Records Inserted 2010-10-25 06:09:05.812 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-25 06:09:05.812 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:05.813 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2010-10-25 06:09:05.814 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2010-10-25 06:09:05.814 (4) [P1T1]: time=0.0010 2010-10-25 06:09:05.814 (4) [P1T1]: Query executed in 0.001s 2010-10-25 06:09:05.815 (4) [P1T1]: DB AutoCommit -> true 2010-10-25 06:09:05.817 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-25 06:09:05.819 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:05.820 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp1`] 2010-10-25 06:09:05.822 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-25 06:09:05.822 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-25 06:09:05.823 (4) [P1T1]: time=0.0020 2010-10-25 06:09:05.823 (4) [P1T1]: Query executed in 0.002s 2010-10-25 06:09:05.823 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:05.830 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:05.831 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp2`] 2010-10-25 06:09:05.835 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-25 06:09:05.835 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-25 06:09:05.836 (4) [P1T1]: time=0.0050 2010-10-25 06:09:05.836 (4) [P1T1]: Query executed in 0.005s 2010-10-25 06:09:05.836 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:05.836 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:05.838 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:07.377 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:07.401 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-25 06:09:07.403 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-25 06:09:08.159 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-25 06:09:08.160 (4) [P1T1]: DB AutoCommit -> false 2010-10-25 06:09:08.161 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.161 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whMonthlySourceConv` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-16 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlySourcePerf` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-16 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlySourceAttr` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-16 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-10-16 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-10-16 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-25 06:09:08.204 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-25 06:09:08.205 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-25 06:09:08.205 (4) [P1T1]: time=0.0030 2010-10-25 06:09:08.205 (4) [P1T1]: Query executed in 0.003s, 3 row(s) affected 2010-10-25 06:09:08.205 (3) [P1T1]: ... 3 Monthly Source Conversion Records Inserted 2010-10-25 06:09:08.205 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.206 (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-10-16 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-25 06:09:08.220 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:08.220 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:08.223 (4) [P1T1]: time=0.0040 2010-10-25 06:09:08.224 (4) [P1T1]: Query executed in 0.004s, 25 row(s) affected 2010-10-25 06:09:08.224 (3) [P1T1]: ... 25 Monthly Source Attribute Records Inserted 2010-10-25 06:09:08.224 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-25 06:09:08.224 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.227 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-25 06:09:08.227 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-25 06:09:08.228 (4) [P1T1]: time=0.0030 2010-10-25 06:09:08.228 (4) [P1T1]: Query executed in 0.003s 2010-10-25 06:09:08.228 (4) [P1T1]: DB AutoCommit -> true 2010-10-25 06:09:08.229 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-25 06:09:08.231 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.231 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp3`] 2010-10-25 06:09:08.233 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-25 06:09:08.234 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-25 06:09:08.236 (4) [P1T1]: time=0.0020 2010-10-25 06:09:08.236 (4) [P1T1]: Query executed in 0.002s 2010-10-25 06:09:08.236 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:08.236 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.236 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp4`] 2010-10-25 06:09:08.243 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2010-10-25 06:09:08.243 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2010-10-25 06:09:08.243 (4) [P1T1]: time=0.0060 2010-10-25 06:09:08.243 (4) [P1T1]: Query executed in 0.006s 2010-10-25 06:09:08.243 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:08.244 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:08.246 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:08.247 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:08.256 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-25 06:09:08.256 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-25 06:09:08.659 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-25 06:09:08.662 (4) [P1T1]: DB AutoCommit -> false 2010-10-25 06:09:08.664 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.678 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whDailyGroupConv` where ((`accountID`=17) and ((((`startTime`>="2010-10-16 03:00:00")) and ((`startTime`<"2010-10-17 00:00:00")))))], genflags=no 2010-10-25 06:09:08.681 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:08.681 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:08.681 (4) [P1T1]: time=0.0040 2010-10-25 06:09:08.681 (4) [P1T1]: Query executed in 0.004s, 0 row(s) affected 2010-10-25 06:09:08.682 (4) [P1T1]: ... 0 Daily Group Conversion Records Cleared 2010-10-25 06:09:08.735 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.736 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whDailyGroupPerf` where ((`accountID`=17) and ((((`startTime`>="2010-10-16 03:00:00")) and ((`startTime`<"2010-10-17 00:00:00")))))], genflags=no 2010-10-25 06:09:08.746 (5) [P1T1]: recordAsSubs("db", 10, "P1T1") 2010-10-25 06:09:08.751 (5) [P1T1]: ProfilerRec.end("db", true): ret=10 2010-10-25 06:09:08.751 (4) [P1T1]: time=0.01 2010-10-25 06:09:08.751 (4) [P1T1]: Query executed in 0.010s, 0 row(s) affected 2010-10-25 06:09:08.752 (4) [P1T1]: .... 0 Perf Records Cleared 2010-10-25 06:09:08.752 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.752 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whDailyGroupAttr` where ((`accountID`=17) and ((((`startTime`>="2010-10-16 03:00:00")) and ((`startTime`<"2010-10-17 00:00:00")))))], genflags=no 2010-10-25 06:09:08.754 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-25 06:09:08.754 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-25 06:09:08.755 (4) [P1T1]: time=0.0020 2010-10-25 06:09:08.755 (4) [P1T1]: Query executed in 0.002s, 0 row(s) affected 2010-10-25 06:09:08.756 (4) [P1T1]: .... 0 Attr Records Cleared 2010-10-25 06:09:08.757 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.757 (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-10-16 03:00:00")) and ((`startTime`<"2010-10-17 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-25 06:09:08.761 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:08.762 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:08.762 (4) [P1T1]: time=0.0040 2010-10-25 06:09:08.762 (4) [P1T1]: Query executed in 0.004s, 0 row(s) affected 2010-10-25 06:09:08.762 (3) [P1T1]: ... 0 Daily Group Perf Records Inserted 2010-10-25 06:09:08.762 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.763 (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-10-16 03:00:00")) and ((`whDailySourceConv`.`startTime`<"2010-10-17 00:00:00"))))) group by `accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,`whDailySourceConv`.`scope`,`whDailySourceConv`.`productID`] 2010-10-25 06:09:08.768 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:08.768 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:08.769 (4) [P1T1]: time=0.0040 2010-10-25 06:09:08.769 (4) [P1T1]: Query executed in 0.004s 2010-10-25 06:09:08.769 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:08.769 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.772 (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-25 06:09:08.775 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2010-10-25 06:09:08.775 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2010-10-25 06:09:08.778 (4) [P1T1]: time=0.0060 2010-10-25 06:09:08.778 (4) [P1T1]: Query executed in 0.006s, 0 row(s) affected 2010-10-25 06:09:08.778 (3) [P1T1]: ... 0 Daily Group Conversion Records Inserted 2010-10-25 06:09:08.778 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.779 (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-10-16 03:00:00")) and ((`whDailySourceAttr`.`startTime`<"2010-10-17 00:00:00"))))) group by `accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`] 2010-10-25 06:09:08.786 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2010-10-25 06:09:08.786 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2010-10-25 06:09:08.786 (4) [P1T1]: time=0.0080 2010-10-25 06:09:08.786 (4) [P1T1]: Query executed in 0.008s 2010-10-25 06:09:08.786 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:08.786 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.787 (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-25 06:09:08.792 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-25 06:09:08.792 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-25 06:09:08.792 (4) [P1T1]: time=0.0050 2010-10-25 06:09:08.795 (4) [P1T1]: Query executed in 0.005s, 0 row(s) affected 2010-10-25 06:09:08.795 (3) [P1T1]: ... 0 Daily Group Attribute Records Inserted 2010-10-25 06:09:08.795 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-25 06:09:08.795 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.796 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2010-10-25 06:09:08.797 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2010-10-25 06:09:08.797 (4) [P1T1]: time=0.0010 2010-10-25 06:09:08.797 (4) [P1T1]: Query executed in 0.001s 2010-10-25 06:09:08.797 (4) [P1T1]: DB AutoCommit -> true 2010-10-25 06:09:08.798 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-25 06:09:08.806 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.806 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp5`] 2010-10-25 06:09:08.809 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-25 06:09:08.809 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-25 06:09:08.809 (4) [P1T1]: time=0.0030 2010-10-25 06:09:08.809 (4) [P1T1]: Query executed in 0.003s 2010-10-25 06:09:08.809 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:08.811 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:08.811 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp6`] 2010-10-25 06:09:08.816 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-25 06:09:08.816 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-25 06:09:08.816 (4) [P1T1]: time=0.0050 2010-10-25 06:09:08.817 (4) [P1T1]: Query executed in 0.005s 2010-10-25 06:09:08.817 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:08.896 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:09.019 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:09.029 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:09.340 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-25 06:09:09.342 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-25 06:09:09.375 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-25 06:09:09.379 (4) [P1T1]: DB AutoCommit -> false 2010-10-25 06:09:09.383 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:09.383 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whWeeklyGroupConv` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-16 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-10-16 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-10-16 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-10-16 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-10-16 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-25 06:09:09.909 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:09.911 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:09.911 (4) [P1T1]: time=0.0040 2010-10-25 06:09:09.912 (4) [P1T1]: Query executed in 0.004s, 3 row(s) affected 2010-10-25 06:09:09.912 (3) [P1T1]: ... 3 Weekly Group Conversion Records Inserted 2010-10-25 06:09:09.914 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:09.914 (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-10-16 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-25 06:09:09.928 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-25 06:09:09.928 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-25 06:09:09.931 (4) [P1T1]: time=0.0030 2010-10-25 06:09:09.931 (4) [P1T1]: Query executed in 0.003s, 4 row(s) affected 2010-10-25 06:09:09.932 (3) [P1T1]: ... 4 Weekly Group Attribute Records Inserted 2010-10-25 06:09:09.932 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-25 06:09:09.932 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:09.935 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2010-10-25 06:09:09.936 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2010-10-25 06:09:09.936 (4) [P1T1]: time=0.0010 2010-10-25 06:09:09.937 (4) [P1T1]: Query executed in 0.001s 2010-10-25 06:09:09.937 (4) [P1T1]: DB AutoCommit -> true 2010-10-25 06:09:09.938 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-25 06:09:09.941 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:09.941 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp7`] 2010-10-25 06:09:09.945 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:09.945 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:09.946 (4) [P1T1]: time=0.0040 2010-10-25 06:09:09.946 (4) [P1T1]: Query executed in 0.004s 2010-10-25 06:09:09.946 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:09.947 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:09.948 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp8`] 2010-10-25 06:09:09.952 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:09.952 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:09.952 (4) [P1T1]: time=0.0040 2010-10-25 06:09:09.953 (4) [P1T1]: Query executed in 0.004s 2010-10-25 06:09:09.955 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:09.955 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:09.957 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:09.959 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-25 06:09:09.970 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-25 06:09:09.970 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-25 06:09:09.988 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-25 06:09:09.991 (4) [P1T1]: DB AutoCommit -> false 2010-10-25 06:09:09.993 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:09.993 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whMonthlyGroupConv` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-16 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlyGroupPerf` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-16 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlyGroupAttr` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-16 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-10-16 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-10-16 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-25 06:09:10.401 (5) [P1T1]: recordAsSubs("db", 9, "P1T1") 2010-10-25 06:09:10.401 (5) [P1T1]: ProfilerRec.end("db", true): ret=9 2010-10-25 06:09:10.401 (4) [P1T1]: time=0.0090 2010-10-25 06:09:10.401 (4) [P1T1]: Query executed in 0.009s, 3 row(s) affected 2010-10-25 06:09:10.401 (3) [P1T1]: ... 3 Monthly Group Conversion Records Inserted 2010-10-25 06:09:10.401 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:10.402 (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-10-16 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-25 06:09:10.415 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2010-10-25 06:09:10.415 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2010-10-25 06:09:10.415 (4) [P1T1]: time=0.0060 2010-10-25 06:09:10.415 (4) [P1T1]: Query executed in 0.006s, 11 row(s) affected 2010-10-25 06:09:10.415 (3) [P1T1]: ... 11 Monthly Group Attribute Records Inserted 2010-10-25 06:09:10.415 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-25 06:09:10.416 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:10.420 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-25 06:09:10.420 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-25 06:09:10.420 (4) [P1T1]: time=0.0040 2010-10-25 06:09:10.423 (4) [P1T1]: Query executed in 0.004s 2010-10-25 06:09:10.424 (4) [P1T1]: DB AutoCommit -> true 2010-10-25 06:09:10.426 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-25 06:09:10.428 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:10.429 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp9`] 2010-10-25 06:09:10.433 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-25 06:09:10.433 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-25 06:09:10.433 (4) [P1T1]: time=0.0020 2010-10-25 06:09:10.433 (4) [P1T1]: Query executed in 0.002s 2010-10-25 06:09:10.434 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:10.445 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:10.445 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp10`] 2010-10-25 06:09:10.448 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-25 06:09:10.448 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-25 06:09:10.448 (4) [P1T1]: time=0.0020 2010-10-25 06:09:10.448 (4) [P1T1]: Query executed in 0.002s 2010-10-25 06:09:10.449 (5) [P1T1]: SQL execute() returned false 2010-10-25 06:09:10.530 (3) [P1T1]: Finished Account #17 WWMW - Cellular Safety Commission aggregates for Sat Oct 16 03:00:00 EDT 2010 to [select * from `dataAvailability` where ((`dataSourceID`="8602") and (`date`="2010-10-16 03:00:00")) limit 1] 2010-10-25 06:09:10.600 (5) [P1T1]: recordAsSubs("db", 30, "P1T1") 2010-10-25 06:09:10.601 (5) [P1T1]: ProfilerRec.end("db", true): ret=30 2010-10-25 06:09:10.602 (4) [P1T1]: time=0.03 2010-10-25 06:09:10.602 (4) [P1T1]: Query executed in 0.030s 2010-10-25 06:09:10.602 (4) [P1T1]: Record Not Found 2010-10-25 06:09:10.604 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:10.605 (4) [P1T1]: perfsum: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-10-16 03:00:00","2010-10-25 06:09:10")], genflags=yes 2010-10-25 06:09:10.612 (2) [P1T1]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-10-16 03:00:00","2010-10-25 06:09:10")] executed by user [perfsum] 2010-10-25 06:09:10.621 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-25 06:09:10.621 (5) [P1T1]: recordAsSubs("db", 16, "P1T1") 2010-10-25 06:09:10.622 (5) [P1T1]: ProfilerRec.end("db", true): ret=16 2010-10-25 06:09:10.622 (4) [P1T1]: time=0.016 2010-10-25 06:09:10.622 (4) [P1T1]: Query executed in 0.016s, 1 row(s) affected 2010-10-25 06:09:10.625 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-25 06:09:10.625 (4) [P1T1]: perfsum: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-10-16 03:00:00","2010-10-25 06:09:10")], genflags=yes 2010-10-25 06:09:10.656 (2) [P1T1]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-10-16 03:00:00","2010-10-25 06:09:10")] executed by user [perfsum] 2010-10-25 06:09:10.667 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-25 06:09:10.668 (5) [P1T1]: recordAsSubs("db", 43, "P1T1") 2010-10-25 06:09:10.668 (5) [P1T1]: ProfilerRec.end("db", true): ret=43 2010-10-25 06:09:10.668 (4) [P1T1]: time=0.043 2010-10-25 06:09:10.668 (4) [P1T1]: Query executed in 0.043s, 1 row(s) affected 2010-10-25 06:09:10.671 (4) [P1T1]: Returning Object to Pool 2010-10-25 06:09:10.672 (4) [P1T1]: Returning Object to Pool 2010-10-25 06:09:10.673 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-25 06:09:10.674 (3) [main]: ------------Warehouse Summarizer done 2010-10-25 06:09:10.674 (3) [main]: =============== Completed Warehouse Summarizer ================ 2010-10-25 06:09:10.674 (3) [main]: -- Renamed file [17_177_20101016.csv] to [17_177_20101016.csv.done] ? true 2010-10-25 06:09:10.674 (3) [main]: =============== Completed Publisher Generic Data Feed Facebook, 0 products processed and 0 lines processed ================