tsaapp@yell-ec-xml2:/usr/local/tsa/bidmgr$ ./admax.sh -d5 -T2012-03-22 -a5221
pid 22486's current affinity list: 0
pid 22486's new affinity list: 0
pid 22486's current affinity list: 0
sched_setaffinity: Invalid argument
failed to set pid 22486's affinity.
2012-03-26 10:56:43.790 (3) [main]: Debug Level set to 5
2012-03-26 10:56:43.796 (3) [main]: AdMax Summarizer parameters: [Ljava.lang.String;@437f1ba3
2012-03-26 10:56:43.853 (5) [main]: ProfilerRec.start("AdMaxSummarizer",false) in Thread [main]
2012-03-26 10:56:43.865 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-03-26 10:56:44.211 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:44.225 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-03-26 10:56:44.226 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-logging")) limit 1]
2012-03-26 10:56:44.283 (5) [main]: recordAsSubs("db", 57, "main")
2012-03-26 10:56:44.284 (5) [main]: addSub("db")
2012-03-26 10:56:44.284 (5) [main]: ProfilerRec.end("db", true): ret=57
2012-03-26 10:56:44.287 (4) [main]: time=0.057
2012-03-26 10:56:44.288 (4) [main]: Query executed in 0.057s
2012-03-26 10:56:44.290 (5) [main]: loading 8 columns from result set:
2012-03-26 10:56:44.291 (5) [main]:     loaded column: databaseInstances.id->4
2012-03-26 10:56:44.292 (5) [main]:     loaded column: databaseInstances.name->global-logging
2012-03-26 10:56:44.347 (5) [main]:     loaded column: databaseInstances.description->Global Logging Tables
2012-03-26 10:56:44.348 (5) [main]:     loaded column: databaseInstances.type->mysql
2012-03-26 10:56:44.348 (5) [main]:     loaded column: databaseInstances.database->logging
2012-03-26 10:56:44.348 (5) [main]:     loaded column: databaseInstances.host->logging-01-write
2012-03-26 10:56:44.349 (5) [main]:     loaded column: databaseInstances.port->3306
2012-03-26 10:56:44.349 (5) [main]:     loaded column: databaseInstances.access->rw
2012-03-26 10:56:44.349 (4) [main]:   Record Loaded
2012-03-26 10:56:44.350 (4) [main]: DataCache: put key global-logging
2012-03-26 10:56:44.355 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:44.361 (3) [main]: DatabasePool with a limit of 18 created
2012-03-26 10:56:44.365 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2012-03-26 10:56:44.507 (4) [main]: opened [jdbc:mysql://logging-01-write:3306/logging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:44.508 (4) [main]: Created new Object
2012-03-26 10:56:44.508 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-03-26 10:56:44.508 (4) [main]: spike: SQL->[select @@version]
2012-03-26 10:56:44.515 (5) [main]: recordAsSubs("db", 7, "main")
2012-03-26 10:56:44.516 (5) [main]: addSub("db")
2012-03-26 10:56:44.516 (5) [main]: ProfilerRec.end("db", true): ret=7
2012-03-26 10:56:44.516 (4) [main]: time=0.0070
2012-03-26 10:56:44.516 (4) [main]: Query executed in 0.007s
2012-03-26 10:56:44.517 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-03-26 10:56:44.543 (4) [main]: preparing SQL statement [insert into logging.processHistory (processID, startTime) values (?,?)], genflags=yes
2012-03-26 10:56:44.581 (3) [main]: Could not save process history start
2012-03-26 10:56:44.582 (4) [main]: Returning Object to Pool
2012-03-26 10:56:44.583 (3) [main]: =============== Starting AdMax Summarizer ================
2012-03-26 10:56:44.583 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-03-26 10:56:44.583 (3) [main]: ----------------AdMax Summarizer starting
2012-03-26 10:56:44.635 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:44.638 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-03-26 10:56:44.639 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (5221))) order by rand()]
2012-03-26 10:56:44.646 (5) [main]: recordAsSubs("db", 7, "main")
2012-03-26 10:56:44.646 (5) [main]: addSub("db")
2012-03-26 10:56:44.646 (5) [main]: ProfilerRec.end("db", true): ret=7
2012-03-26 10:56:44.647 (4) [main]: time=0.0070
2012-03-26 10:56:44.647 (4) [main]: Query executed in 0.007s
2012-03-26 10:56:44.647 (5) [main]: loading 19 columns from result set:
2012-03-26 10:56:44.648 (5) [main]:     loaded column: accounts.id->5221
2012-03-26 10:56:44.648 (5) [main]:     loaded column: accounts.description->alok-n63a
2012-03-26 10:56:44.649 (5) [main]:     loaded column: accounts.tier->1
2012-03-26 10:56:44.649 (5) [main]:     loaded column: accounts.priority->50
2012-03-26 10:56:44.649 (5) [main]:     loaded column: accounts.reportClicksOut->false
2012-03-26 10:56:44.650 (5) [main]:     loaded column: accounts.reportConversions->false
2012-03-26 10:56:44.650 (5) [main]:     loaded column: accounts.conversionTypes->paid
2012-03-26 10:56:44.650 (5) [main]:     loaded column: accounts.isBidManaged->true
2012-03-26 10:56:44.651 (5) [main]:     loaded column: accounts.isActive->true
2012-03-26 10:56:44.651 (5) [main]:     loaded column: accounts.perfMetric->cpa
2012-03-26 10:56:44.651 (5) [main]:     loaded column: accounts.providesConversionData->true
2012-03-26 10:56:44.652 (5) [main]:     loaded column: accounts.addConversionData->false
2012-03-26 10:56:44.653 (5) [main]:     loaded column: accounts.fractionalConversionCounts->false
2012-03-26 10:56:44.653 (5) [main]:     loaded column: accounts.hideNullSources->false
2012-03-26 10:56:44.665 (5) [main]:     loaded column: accounts.nowTime->null
2012-03-26 10:56:44.666 (5) [main]:     skipping invalid column: accounts.warehouseDatabase
2012-03-26 10:56:44.667 (5) [main]:     loaded column: accounts.databaseInstance->1
2012-03-26 10:56:44.667 (5) [main]:     loaded column: accounts.warehouseInstance->1
2012-03-26 10:56:44.667 (5) [main]:     loaded column: accounts.isOnline->true
2012-03-26 10:56:44.685 (3) [P1T1]: Starting Account ID #5221: alok-n63a
2012-03-26 10:56:44.688 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2012-03-26 10:56:44.782 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:44.783 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer
2012-03-26 10:56:44.783 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:44.783 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=5221) limit 1]
2012-03-26 10:56:44.794 (5) [P1T1]: recordAsSubs("db", 10, "P1T1")
2012-03-26 10:56:44.794 (5) [P1T1]: addSub("db")
2012-03-26 10:56:44.794 (5) [P1T1]: ProfilerRec.end("db", true): ret=10
2012-03-26 10:56:44.795 (4) [P1T1]: time=0.01
2012-03-26 10:56:44.795 (4) [P1T1]: Query executed in 0.010s
2012-03-26 10:56:44.795 (5) [P1T1]: loading 19 columns from result set:
2012-03-26 10:56:44.795 (5) [P1T1]:     loaded column: accounts.id->5221
2012-03-26 10:56:44.796 (5) [P1T1]:     loaded column: accounts.description->alok-n63a
2012-03-26 10:56:44.796 (5) [P1T1]:     loaded column: accounts.tier->1
2012-03-26 10:56:44.796 (5) [P1T1]:     loaded column: accounts.priority->50
2012-03-26 10:56:44.796 (5) [P1T1]:     loaded column: accounts.reportClicksOut->false
2012-03-26 10:56:44.797 (5) [P1T1]:     loaded column: accounts.reportConversions->false
2012-03-26 10:56:44.797 (5) [P1T1]:     loaded column: accounts.conversionTypes->paid
2012-03-26 10:56:44.797 (5) [P1T1]:     loaded column: accounts.isBidManaged->true
2012-03-26 10:56:44.797 (5) [P1T1]:     loaded column: accounts.isActive->true
2012-03-26 10:56:44.798 (5) [P1T1]:     loaded column: accounts.perfMetric->cpa
2012-03-26 10:56:44.799 (5) [P1T1]:     loaded column: accounts.providesConversionData->true
2012-03-26 10:56:44.799 (5) [P1T1]:     loaded column: accounts.addConversionData->false
2012-03-26 10:56:44.800 (5) [P1T1]:     loaded column: accounts.fractionalConversionCounts->false
2012-03-26 10:56:44.800 (5) [P1T1]:     loaded column: accounts.hideNullSources->false
2012-03-26 10:56:44.800 (5) [P1T1]:     loaded column: accounts.nowTime->null
2012-03-26 10:56:44.801 (5) [P1T1]:     skipping invalid column: accounts.warehouseDatabase
2012-03-26 10:56:44.802 (5) [P1T1]:     loaded column: accounts.databaseInstance->1
2012-03-26 10:56:44.802 (5) [P1T1]:     loaded column: accounts.warehouseInstance->1
2012-03-26 10:56:44.802 (5) [P1T1]:     loaded column: accounts.isOnline->true
2012-03-26 10:56:44.803 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:44.803 (4) [P1T1]: DataCache: put key acct-st-tracker 5221
2012-03-26 10:56:44.804 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:44.804 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-1")) limit 1]
2012-03-26 10:56:44.809 (5) [P1T1]: recordAsSubs("db", 4, "P1T1")
2012-03-26 10:56:44.809 (5) [P1T1]: addSub("db")
2012-03-26 10:56:44.809 (5) [P1T1]: ProfilerRec.end("db", true): ret=4
2012-03-26 10:56:44.809 (4) [P1T1]: time=0.0040
2012-03-26 10:56:44.810 (4) [P1T1]: Query executed in 0.004s
2012-03-26 10:56:44.810 (5) [P1T1]: loading 8 columns from result set:
2012-03-26 10:56:44.810 (5) [P1T1]:     loaded column: databaseInstances.id->15
2012-03-26 10:56:44.811 (5) [P1T1]:     loaded column: databaseInstances.name->acct-st-tracker-1
2012-03-26 10:56:44.811 (5) [P1T1]:     loaded column: databaseInstances.description->Account-specific Catch-all database
2012-03-26 10:56:44.812 (5) [P1T1]:     loaded column: databaseInstances.type->mysql
2012-03-26 10:56:44.813 (5) [P1T1]:     loaded column: databaseInstances.database->st-tracker
2012-03-26 10:56:44.813 (5) [P1T1]:     loaded column: databaseInstances.host->acctdb-01-write
2012-03-26 10:56:44.813 (5) [P1T1]:     loaded column: databaseInstances.port->3306
2012-03-26 10:56:44.814 (5) [P1T1]:     loaded column: databaseInstances.access->rw
2012-03-26 10:56:44.814 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:44.814 (4) [P1T1]: DataCache: put key acct-st-tracker-1
2012-03-26 10:56:44.818 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:44.818 (3) [P1T1]: DatabasePool with a limit of 18 created
2012-03-26 10:56:44.885 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:44.886 (4) [P1T1]: Created new Object
2012-03-26 10:56:44.886 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:44.887 (4) [P1T1]: spike: SQL->[select @@version]
2012-03-26 10:56:44.892 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:44.893 (5) [P1T1]: addSub("db")
2012-03-26 10:56:44.894 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:44.894 (4) [P1T1]: time=0.0060
2012-03-26 10:56:44.894 (4) [P1T1]: Query executed in 0.006s
2012-03-26 10:56:44.895 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-03-26 10:56:44.895 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2012-03-26 10:56:44.895 (3) [P1T1]: DatabasePool with a limit of 18 created
2012-03-26 10:56:44.973 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:44.974 (4) [P1T1]: Created new Object
2012-03-26 10:56:44.974 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:44.975 (4) [P1T1]: spike: SQL->[select @@version]
2012-03-26 10:56:44.980 (5) [P1T1]: recordAsSubs("db", 5, "P1T1")
2012-03-26 10:56:44.980 (5) [P1T1]: addSub("db")
2012-03-26 10:56:44.980 (5) [P1T1]: ProfilerRec.end("db", true): ret=5
2012-03-26 10:56:44.981 (4) [P1T1]: time=0.0050
2012-03-26 10:56:44.981 (4) [P1T1]: Query executed in 0.005s
2012-03-26 10:56:44.981 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-03-26 10:56:44.981 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2012-03-26 10:56:45.053 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:45.055 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.055 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-staging")) limit 1]
2012-03-26 10:56:45.061 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:45.061 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.062 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:45.063 (4) [P1T1]: time=0.0060
2012-03-26 10:56:45.063 (4) [P1T1]: Query executed in 0.006s
2012-03-26 10:56:45.063 (5) [P1T1]: loading 8 columns from result set:
2012-03-26 10:56:45.064 (5) [P1T1]:     loaded column: databaseInstances.id->3
2012-03-26 10:56:45.064 (5) [P1T1]:     loaded column: databaseInstances.name->global-staging
2012-03-26 10:56:45.064 (5) [P1T1]:     loaded column: databaseInstances.description->Global Staging Tables
2012-03-26 10:56:45.065 (5) [P1T1]:     loaded column: databaseInstances.type->mysql
2012-03-26 10:56:45.065 (5) [P1T1]:     loaded column: databaseInstances.database->staging
2012-03-26 10:56:45.065 (5) [P1T1]:     loaded column: databaseInstances.host->staging-01-write
2012-03-26 10:56:45.065 (5) [P1T1]:     loaded column: databaseInstances.port->3306
2012-03-26 10:56:45.066 (5) [P1T1]:     loaded column: databaseInstances.access->rw
2012-03-26 10:56:45.066 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:45.066 (4) [P1T1]: DataCache: put key global-staging
2012-03-26 10:56:45.069 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:45.070 (3) [P1T1]: DatabasePool with a limit of 18 created
2012-03-26 10:56:45.211 (4) [P1T1]: opened [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:45.211 (4) [P1T1]: Created new Object
2012-03-26 10:56:45.211 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.211 (4) [P1T1]: spike: SQL->[select @@version]
2012-03-26 10:56:45.216 (5) [P1T1]: recordAsSubs("db", 5, "P1T1")
2012-03-26 10:56:45.216 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.217 (5) [P1T1]: ProfilerRec.end("db", true): ret=5
2012-03-26 10:56:45.217 (4) [P1T1]: time=0.0050
2012-03-26 10:56:45.217 (4) [P1T1]: Query executed in 0.005s
2012-03-26 10:56:45.218 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-03-26 10:56:45.220 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.221 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.5221', 600)]
2012-03-26 10:56:45.228 (5) [P1T1]: recordAsSubs("db", 7, "P1T1")
2012-03-26 10:56:45.228 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.228 (5) [P1T1]: ProfilerRec.end("db", true): ret=7
2012-03-26 10:56:45.229 (4) [P1T1]: time=0.0070
2012-03-26 10:56:45.229 (4) [P1T1]: Query executed in 0.007s
2012-03-26 10:56:45.229 (3) [P1T1]: Got migrator lock for Account ID #5221
2012-03-26 10:56:45.232 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer
2012-03-26 10:56:45.242 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.242 (4) [P1T1]: spike: SQL->[select * from `settings` where ((((`settings`.`scope`="accounts")) and ((`settings`.`scopeId`=5221))))]
2012-03-26 10:56:45.249 (5) [P1T1]: recordAsSubs("db", 7, "P1T1")
2012-03-26 10:56:45.249 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.249 (5) [P1T1]: ProfilerRec.end("db", true): ret=7
2012-03-26 10:56:45.249 (4) [P1T1]: time=0.0070
2012-03-26 10:56:45.250 (4) [P1T1]: Query executed in 0.007s
2012-03-26 10:56:45.253 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.254 (4) [P1T1]: spike: SQL->[select * from `settingDefaults` where (`settingDefaults`.`scope`="accounts")]
2012-03-26 10:56:45.262 (5) [P1T1]: recordAsSubs("db", 8, "P1T1")
2012-03-26 10:56:45.262 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.262 (5) [P1T1]: ProfilerRec.end("db", true): ret=8
2012-03-26 10:56:45.262 (4) [P1T1]: time=0.0080
2012-03-26 10:56:45.262 (4) [P1T1]: Query executed in 0.008s
2012-03-26 10:56:45.265 (4) [P1T1]: DataCache: put key accounts 5221
2012-03-26 10:56:45.303 (4) [P1T1]: DataCache: Found key accounts 5221
2012-03-26 10:56:45.304 (4) [P1T1]: Settings.getSettings: loaded from cache (key=accounts 5221)
2012-03-26 10:56:45.305 (3) [P1T1]: Applying algorithm [SABB] for Account ID #5221 in distributions [3]
2012-03-26 10:56:45.309 (3) [P1T1]: Processing data for Thu Mar 22 00:00:00 GMT 2012
2012-03-26 10:56:45.346 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-03-26 10:56:45.349 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.349 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineAccounts` inner join `tsacommon`.`searchEngineUsers` on (((`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`=`tsacommon`.`searchEngineUsers`.`id`))) inner join `tsacommon`.`accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineAccounts`.`accountID`)) where (((((`tsacommon`.`searchEngineAccounts`.`enabled`="true") and (((`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="ok") or (`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="disabled") or (`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="deleted"))) and (`tsacommon`.`searchEngineAccounts`.`accountID`="5221"))) and ((`tsacommon`.`searchEngineAccounts`.`distributionID` in (3))))) order by rand()]
2012-03-26 10:56:45.475 (5) [P1T1]: recordAsSubs("db", 125, "P1T1")
2012-03-26 10:56:45.475 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.476 (5) [P1T1]: ProfilerRec.end("db", true): ret=125
2012-03-26 10:56:45.476 (4) [P1T1]: time=0.125
2012-03-26 10:56:45.477 (4) [P1T1]: Query executed in 0.125s
2012-03-26 10:56:45.723 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer
2012-03-26 10:56:45.725 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.725 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15921")) limit 1]
2012-03-26 10:56:45.734 (5) [P1T1]: recordAsSubs("db", 9, "P1T1")
2012-03-26 10:56:45.735 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.735 (5) [P1T1]: ProfilerRec.end("db", true): ret=9
2012-03-26 10:56:45.736 (4) [P1T1]: time=0.0090
2012-03-26 10:56:45.736 (4) [P1T1]: Query executed in 0.009s
2012-03-26 10:56:45.736 (5) [P1T1]: loading 4 columns from result set:
2012-03-26 10:56:45.737 (5) [P1T1]:     loaded column: dataSources.id->5967
2012-03-26 10:56:45.738 (5) [P1T1]:     loaded column: dataSources.type->admax
2012-03-26 10:56:45.738 (5) [P1T1]:     loaded column: dataSources.typeID->15921
2012-03-26 10:56:45.739 (5) [P1T1]:     loaded column: dataSources.accountID->5221
2012-03-26 10:56:45.740 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:45.741 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer
2012-03-26 10:56:45.742 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.743 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15931")) limit 1]
2012-03-26 10:56:45.748 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:45.749 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.750 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:45.750 (4) [P1T1]: time=0.0060
2012-03-26 10:56:45.751 (4) [P1T1]: Query executed in 0.006s
2012-03-26 10:56:45.751 (5) [P1T1]: loading 4 columns from result set:
2012-03-26 10:56:45.752 (5) [P1T1]:     loaded column: dataSources.id->5966
2012-03-26 10:56:45.753 (5) [P1T1]:     loaded column: dataSources.type->admax
2012-03-26 10:56:45.753 (5) [P1T1]:     loaded column: dataSources.typeID->15931
2012-03-26 10:56:45.754 (5) [P1T1]:     loaded column: dataSources.accountID->5221
2012-03-26 10:56:45.754 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:45.758 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer
2012-03-26 10:56:45.760 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.760 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15911")) limit 1]
2012-03-26 10:56:45.765 (5) [P1T1]: recordAsSubs("db", 5, "P1T1")
2012-03-26 10:56:45.766 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.766 (5) [P1T1]: ProfilerRec.end("db", true): ret=5
2012-03-26 10:56:45.767 (4) [P1T1]: time=0.0050
2012-03-26 10:56:45.767 (4) [P1T1]: Query executed in 0.005s
2012-03-26 10:56:45.768 (5) [P1T1]: loading 4 columns from result set:
2012-03-26 10:56:45.768 (5) [P1T1]:     loaded column: dataSources.id->5968
2012-03-26 10:56:45.769 (5) [P1T1]:     loaded column: dataSources.type->admax
2012-03-26 10:56:45.770 (5) [P1T1]:     loaded column: dataSources.typeID->15911
2012-03-26 10:56:45.770 (5) [P1T1]:     loaded column: dataSources.accountID->5221
2012-03-26 10:56:45.770 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:45.771 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer
2012-03-26 10:56:45.773 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.773 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15901")) limit 1]
2012-03-26 10:56:45.848 (5) [P1T1]: recordAsSubs("db", 75, "P1T1")
2012-03-26 10:56:45.849 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.849 (5) [P1T1]: ProfilerRec.end("db", true): ret=75
2012-03-26 10:56:45.849 (4) [P1T1]: time=0.075
2012-03-26 10:56:45.850 (4) [P1T1]: Query executed in 0.075s
2012-03-26 10:56:45.850 (5) [P1T1]: loading 4 columns from result set:
2012-03-26 10:56:45.850 (5) [P1T1]:     loaded column: dataSources.id->5969
2012-03-26 10:56:45.851 (5) [P1T1]:     loaded column: dataSources.type->admax
2012-03-26 10:56:45.851 (5) [P1T1]:     loaded column: dataSources.typeID->15901
2012-03-26 10:56:45.851 (5) [P1T1]:     loaded column: dataSources.accountID->5221
2012-03-26 10:56:45.852 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:45.853 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer
2012-03-26 10:56:45.854 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.854 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`dataSources`.`type`="admax") and (`dataSources`.`accountID`=5221))]
2012-03-26 10:56:45.860 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:45.860 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.861 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:45.861 (4) [P1T1]: time=0.0060
2012-03-26 10:56:45.861 (4) [P1T1]: Query executed in 0.006s
2012-03-26 10:56:45.861 (5) [P1T1]: loading 4 columns from result set:
2012-03-26 10:56:45.862 (5) [P1T1]:     loaded column: dataSources.id->5965
2012-03-26 10:56:45.863 (5) [P1T1]:     loaded column: dataSources.type->admax
2012-03-26 10:56:45.863 (5) [P1T1]:     loaded column: dataSources.typeID->0
2012-03-26 10:56:45.863 (5) [P1T1]:     loaded column: dataSources.accountID->5221
2012-03-26 10:56:45.863 (5) [P1T1]: loading 4 columns from result set:
2012-03-26 10:56:45.864 (5) [P1T1]:     loaded column: dataSources.id->5966
2012-03-26 10:56:45.864 (5) [P1T1]:     loaded column: dataSources.type->admax
2012-03-26 10:56:45.864 (5) [P1T1]:     loaded column: dataSources.typeID->15931
2012-03-26 10:56:45.865 (5) [P1T1]:     loaded column: dataSources.accountID->5221
2012-03-26 10:56:45.865 (5) [P1T1]: loading 4 columns from result set:
2012-03-26 10:56:45.865 (5) [P1T1]:     loaded column: dataSources.id->5967
2012-03-26 10:56:45.865 (5) [P1T1]:     loaded column: dataSources.type->admax
2012-03-26 10:56:45.866 (5) [P1T1]:     loaded column: dataSources.typeID->15921
2012-03-26 10:56:45.866 (5) [P1T1]:     loaded column: dataSources.accountID->5221
2012-03-26 10:56:45.866 (5) [P1T1]: loading 4 columns from result set:
2012-03-26 10:56:45.866 (5) [P1T1]:     loaded column: dataSources.id->5968
2012-03-26 10:56:45.867 (5) [P1T1]:     loaded column: dataSources.type->admax
2012-03-26 10:56:45.867 (5) [P1T1]:     loaded column: dataSources.typeID->15911
2012-03-26 10:56:45.867 (5) [P1T1]:     loaded column: dataSources.accountID->5221
2012-03-26 10:56:45.867 (5) [P1T1]: loading 4 columns from result set:
2012-03-26 10:56:45.868 (5) [P1T1]:     loaded column: dataSources.id->5969
2012-03-26 10:56:45.868 (5) [P1T1]:     loaded column: dataSources.type->admax
2012-03-26 10:56:45.868 (5) [P1T1]:     loaded column: dataSources.typeID->15901
2012-03-26 10:56:45.869 (5) [P1T1]:     loaded column: dataSources.accountID->5221
2012-03-26 10:56:45.880 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:45.880 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5965") and (`date`="2012-03-22 00:00:00")) limit 1]
2012-03-26 10:56:45.906 (5) [P1T1]: recordAsSubs("db", 26, "P1T1")
2012-03-26 10:56:45.907 (5) [P1T1]: addSub("db")
2012-03-26 10:56:45.907 (5) [P1T1]: ProfilerRec.end("db", true): ret=26
2012-03-26 10:56:45.908 (4) [P1T1]: time=0.026
2012-03-26 10:56:45.908 (4) [P1T1]: Query executed in 0.026s
2012-03-26 10:56:45.908 (5) [P1T1]: loading 9 columns from result set:
2012-03-26 10:56:45.909 (5) [P1T1]:     loaded column: dataAvailability.id->165596
2012-03-26 10:56:45.910 (5) [P1T1]:     loaded column: dataAvailability.date->2012-03-22
2012-03-26 10:56:45.911 (5) [P1T1]:     loaded column: dataAvailability.oldUpdated->00:00:00
2012-03-26 10:56:46.596 (5) [P1T1]:     loaded column: dataAvailability.updated->2012-03-24 15:46:20.0
2012-03-26 10:56:46.596 (5) [P1T1]:     loaded column: dataAvailability.dataSourceID->5965
2012-03-26 10:56:46.596 (5) [P1T1]:     loaded column: dataAvailability.status->success
2012-03-26 10:56:46.597 (5) [P1T1]:     loaded column: dataAvailability.statusText->null
2012-03-26 10:56:46.597 (5) [P1T1]:     loaded column: dataAvailability.needsRerun->false
2012-03-26 10:56:46.597 (5) [P1T1]:     loaded column: dataAvailability.override->false
2012-03-26 10:56:46.597 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:46.598 (5) [P1T1]: quoteValue(), nothing special about it=>[5965], type=class java.lang.Integer
2012-03-26 10:56:46.599 (5) [P1T1]: quoteValue(), nothing special about it=>[165596], type=class java.lang.Integer
2012-03-26 10:56:46.599 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:46.599 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5965,"in progress","2012-03-22","2012-03-26 10:56:45",165596)], genflags=yes
2012-03-26 10:56:46.617 (5) [P1T1]: recordAsSubs("db", 18, "P1T1")
2012-03-26 10:56:46.617 (5) [P1T1]: addSub("db")
2012-03-26 10:56:46.617 (5) [P1T1]: ProfilerRec.end("db", true): ret=18
2012-03-26 10:56:46.618 (4) [P1T1]: time=0.018
2012-03-26 10:56:46.618 (4) [P1T1]: Query executed in 0.018s, 2 row(s) affected
2012-03-26 10:56:46.733 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:46.734 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5965","in progress","2012-03-22 00:00:00","2012-03-26 10:56:45")], genflags=yes
2012-03-26 10:56:46.741 (5) [P1T1]: recordAsSubs("db", 7, "P1T1")
2012-03-26 10:56:46.741 (5) [P1T1]: addSub("db")
2012-03-26 10:56:46.741 (5) [P1T1]: ProfilerRec.end("db", true): ret=7
2012-03-26 10:56:46.742 (4) [P1T1]: time=0.0070
2012-03-26 10:56:46.742 (4) [P1T1]: Query executed in 0.007s, 1 row(s) affected
2012-03-26 10:56:46.750 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:46.751 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5966") and (`date`="2012-03-22 00:00:00")) limit 1]
2012-03-26 10:56:46.757 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:46.757 (5) [P1T1]: addSub("db")
2012-03-26 10:56:46.758 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:46.758 (4) [P1T1]: time=0.0060
2012-03-26 10:56:46.758 (4) [P1T1]: Query executed in 0.006s
2012-03-26 10:56:46.758 (5) [P1T1]: loading 9 columns from result set:
2012-03-26 10:56:46.759 (5) [P1T1]:     loaded column: dataAvailability.id->165597
2012-03-26 10:56:46.759 (5) [P1T1]:     loaded column: dataAvailability.date->2012-03-22
2012-03-26 10:56:46.759 (5) [P1T1]:     loaded column: dataAvailability.oldUpdated->00:00:00
2012-03-26 10:56:46.760 (5) [P1T1]:     loaded column: dataAvailability.updated->2012-03-24 15:46:20.0
2012-03-26 10:56:46.760 (5) [P1T1]:     loaded column: dataAvailability.dataSourceID->5966
2012-03-26 10:56:46.760 (5) [P1T1]:     loaded column: dataAvailability.status->success
2012-03-26 10:56:46.761 (5) [P1T1]:     loaded column: dataAvailability.statusText->null
2012-03-26 10:56:46.761 (5) [P1T1]:     loaded column: dataAvailability.needsRerun->false
2012-03-26 10:56:46.761 (5) [P1T1]:     loaded column: dataAvailability.override->false
2012-03-26 10:56:46.761 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:46.771 (5) [P1T1]: quoteValue(), nothing special about it=>[5966], type=class java.lang.Integer
2012-03-26 10:56:46.773 (5) [P1T1]: quoteValue(), nothing special about it=>[165597], type=class java.lang.Integer
2012-03-26 10:56:46.773 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:46.773 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5966,"in progress","2012-03-22","2012-03-26 10:56:46",165597)], genflags=yes
2012-03-26 10:56:46.780 (5) [P1T1]: recordAsSubs("db", 7, "P1T1")
2012-03-26 10:56:46.780 (5) [P1T1]: addSub("db")
2012-03-26 10:56:46.780 (5) [P1T1]: ProfilerRec.end("db", true): ret=7
2012-03-26 10:56:46.781 (4) [P1T1]: time=0.0070
2012-03-26 10:56:46.781 (4) [P1T1]: Query executed in 0.007s, 2 row(s) affected
2012-03-26 10:56:46.782 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:46.783 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5966","in progress","2012-03-22 00:00:00","2012-03-26 10:56:46")], genflags=yes
2012-03-26 10:56:46.790 (5) [P1T1]: recordAsSubs("db", 7, "P1T1")
2012-03-26 10:56:46.791 (5) [P1T1]: addSub("db")
2012-03-26 10:56:46.791 (5) [P1T1]: ProfilerRec.end("db", true): ret=7
2012-03-26 10:56:46.791 (4) [P1T1]: time=0.0070
2012-03-26 10:56:46.791 (4) [P1T1]: Query executed in 0.007s, 1 row(s) affected
2012-03-26 10:56:46.794 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:46.794 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5967") and (`date`="2012-03-22 00:00:00")) limit 1]
2012-03-26 10:56:46.800 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:46.801 (5) [P1T1]: addSub("db")
2012-03-26 10:56:46.801 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:46.801 (4) [P1T1]: time=0.0060
2012-03-26 10:56:46.801 (4) [P1T1]: Query executed in 0.006s
2012-03-26 10:56:46.802 (5) [P1T1]: loading 9 columns from result set:
2012-03-26 10:56:46.802 (5) [P1T1]:     loaded column: dataAvailability.id->165598
2012-03-26 10:56:46.802 (5) [P1T1]:     loaded column: dataAvailability.date->2012-03-22
2012-03-26 10:56:46.803 (5) [P1T1]:     loaded column: dataAvailability.oldUpdated->00:00:00
2012-03-26 10:56:46.803 (5) [P1T1]:     loaded column: dataAvailability.updated->2012-03-24 15:46:20.0
2012-03-26 10:56:46.804 (5) [P1T1]:     loaded column: dataAvailability.dataSourceID->5967
2012-03-26 10:56:46.804 (5) [P1T1]:     loaded column: dataAvailability.status->success
2012-03-26 10:56:46.804 (5) [P1T1]:     loaded column: dataAvailability.statusText->null
2012-03-26 10:56:46.804 (5) [P1T1]:     loaded column: dataAvailability.needsRerun->false
2012-03-26 10:56:46.805 (5) [P1T1]:     loaded column: dataAvailability.override->false
2012-03-26 10:56:46.805 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:46.806 (5) [P1T1]: quoteValue(), nothing special about it=>[5967], type=class java.lang.Integer
2012-03-26 10:56:46.806 (5) [P1T1]: quoteValue(), nothing special about it=>[165598], type=class java.lang.Integer
2012-03-26 10:56:46.807 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:46.807 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5967,"in progress","2012-03-22","2012-03-26 10:56:46",165598)], genflags=yes
2012-03-26 10:56:46.846 (5) [P1T1]: recordAsSubs("db", 39, "P1T1")
2012-03-26 10:56:46.846 (5) [P1T1]: addSub("db")
2012-03-26 10:56:46.846 (5) [P1T1]: ProfilerRec.end("db", true): ret=39
2012-03-26 10:56:46.847 (4) [P1T1]: time=0.039
2012-03-26 10:56:46.847 (4) [P1T1]: Query executed in 0.039s, 2 row(s) affected
2012-03-26 10:56:46.888 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:46.888 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5967","in progress","2012-03-22 00:00:00","2012-03-26 10:56:46")], genflags=yes
2012-03-26 10:56:46.896 (5) [P1T1]: recordAsSubs("db", 8, "P1T1")
2012-03-26 10:56:46.935 (5) [P1T1]: addSub("db")
2012-03-26 10:56:46.935 (5) [P1T1]: ProfilerRec.end("db", true): ret=8
2012-03-26 10:56:46.937 (4) [P1T1]: time=0.0080
2012-03-26 10:56:46.937 (4) [P1T1]: Query executed in 0.008s, 1 row(s) affected
2012-03-26 10:56:46.938 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:46.938 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5968") and (`date`="2012-03-22 00:00:00")) limit 1]
2012-03-26 10:56:46.947 (5) [P1T1]: recordAsSubs("db", 8, "P1T1")
2012-03-26 10:56:46.947 (5) [P1T1]: addSub("db")
2012-03-26 10:56:46.947 (5) [P1T1]: ProfilerRec.end("db", true): ret=8
2012-03-26 10:56:46.947 (4) [P1T1]: time=0.0080
2012-03-26 10:56:46.947 (4) [P1T1]: Query executed in 0.008s
2012-03-26 10:56:46.947 (5) [P1T1]: loading 9 columns from result set:
2012-03-26 10:56:46.947 (5) [P1T1]:     loaded column: dataAvailability.id->165599
2012-03-26 10:56:46.948 (5) [P1T1]:     loaded column: dataAvailability.date->2012-03-22
2012-03-26 10:56:46.948 (5) [P1T1]:     loaded column: dataAvailability.oldUpdated->00:00:00
2012-03-26 10:56:46.948 (5) [P1T1]:     loaded column: dataAvailability.updated->2012-03-24 15:46:21.0
2012-03-26 10:56:46.948 (5) [P1T1]:     loaded column: dataAvailability.dataSourceID->5968
2012-03-26 10:56:46.948 (5) [P1T1]:     loaded column: dataAvailability.status->success
2012-03-26 10:56:46.949 (5) [P1T1]:     loaded column: dataAvailability.statusText->null
2012-03-26 10:56:47.657 (5) [P1T1]:     loaded column: dataAvailability.needsRerun->false
2012-03-26 10:56:47.657 (5) [P1T1]:     loaded column: dataAvailability.override->false
2012-03-26 10:56:47.657 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:47.658 (5) [P1T1]: quoteValue(), nothing special about it=>[5968], type=class java.lang.Integer
2012-03-26 10:56:47.658 (5) [P1T1]: quoteValue(), nothing special about it=>[165599], type=class java.lang.Integer
2012-03-26 10:56:47.659 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:47.659 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5968,"in progress","2012-03-22","2012-03-26 10:56:46",165599)], genflags=yes
2012-03-26 10:56:47.677 (5) [P1T1]: recordAsSubs("db", 18, "P1T1")
2012-03-26 10:56:47.677 (5) [P1T1]: addSub("db")
2012-03-26 10:56:47.677 (5) [P1T1]: ProfilerRec.end("db", true): ret=18
2012-03-26 10:56:47.677 (4) [P1T1]: time=0.018
2012-03-26 10:56:47.677 (4) [P1T1]: Query executed in 0.018s, 2 row(s) affected
2012-03-26 10:56:47.679 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:47.679 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5968","in progress","2012-03-22 00:00:00","2012-03-26 10:56:46")], genflags=yes
2012-03-26 10:56:47.691 (5) [P1T1]: recordAsSubs("db", 12, "P1T1")
2012-03-26 10:56:47.691 (5) [P1T1]: addSub("db")
2012-03-26 10:56:47.691 (5) [P1T1]: ProfilerRec.end("db", true): ret=12
2012-03-26 10:56:47.691 (4) [P1T1]: time=0.012
2012-03-26 10:56:47.691 (4) [P1T1]: Query executed in 0.012s, 1 row(s) affected
2012-03-26 10:56:47.692 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:47.693 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5969") and (`date`="2012-03-22 00:00:00")) limit 1]
2012-03-26 10:56:47.698 (5) [P1T1]: recordAsSubs("db", 4, "P1T1")
2012-03-26 10:56:47.698 (5) [P1T1]: addSub("db")
2012-03-26 10:56:47.698 (5) [P1T1]: ProfilerRec.end("db", true): ret=4
2012-03-26 10:56:47.698 (4) [P1T1]: time=0.0040
2012-03-26 10:56:47.698 (4) [P1T1]: Query executed in 0.004s
2012-03-26 10:56:47.700 (5) [P1T1]: loading 9 columns from result set:
2012-03-26 10:56:47.700 (5) [P1T1]:     loaded column: dataAvailability.id->165600
2012-03-26 10:56:47.701 (5) [P1T1]:     loaded column: dataAvailability.date->2012-03-22
2012-03-26 10:56:47.701 (5) [P1T1]:     loaded column: dataAvailability.oldUpdated->00:00:00
2012-03-26 10:56:47.780 (5) [P1T1]:     loaded column: dataAvailability.updated->2012-03-24 15:46:21.0
2012-03-26 10:56:47.780 (5) [P1T1]:     loaded column: dataAvailability.dataSourceID->5969
2012-03-26 10:56:47.780 (5) [P1T1]:     loaded column: dataAvailability.status->success
2012-03-26 10:56:47.780 (5) [P1T1]:     loaded column: dataAvailability.statusText->null
2012-03-26 10:56:47.780 (5) [P1T1]:     loaded column: dataAvailability.needsRerun->false
2012-03-26 10:56:47.781 (5) [P1T1]:     loaded column: dataAvailability.override->false
2012-03-26 10:56:47.781 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:47.781 (5) [P1T1]: quoteValue(), nothing special about it=>[5969], type=class java.lang.Integer
2012-03-26 10:56:47.782 (5) [P1T1]: quoteValue(), nothing special about it=>[165600], type=class java.lang.Integer
2012-03-26 10:56:47.782 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:47.782 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5969,"in progress","2012-03-22","2012-03-26 10:56:47",165600)], genflags=yes
2012-03-26 10:56:47.803 (5) [P1T1]: recordAsSubs("db", 21, "P1T1")
2012-03-26 10:56:47.804 (5) [P1T1]: addSub("db")
2012-03-26 10:56:47.804 (5) [P1T1]: ProfilerRec.end("db", true): ret=21
2012-03-26 10:56:47.804 (4) [P1T1]: time=0.021
2012-03-26 10:56:47.804 (4) [P1T1]: Query executed in 0.021s, 2 row(s) affected
2012-03-26 10:56:47.807 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:47.807 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5969","in progress","2012-03-22 00:00:00","2012-03-26 10:56:47")], genflags=yes
2012-03-26 10:56:47.813 (5) [P1T1]: recordAsSubs("db", 5, "P1T1")
2012-03-26 10:56:47.813 (5) [P1T1]: addSub("db")
2012-03-26 10:56:47.813 (5) [P1T1]: ProfilerRec.end("db", true): ret=5
2012-03-26 10:56:47.813 (4) [P1T1]: time=0.0050
2012-03-26 10:56:47.814 (4) [P1T1]: Query executed in 0.005s, 1 row(s) affected
2012-03-26 10:56:47.819 (4) [P1T1]: preparing SQL statement [select admaxNominalMonthlyBudgets.ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID where accountID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-03-26 10:56:47.832 (4) [P1T1]: preparing SQL statement [select ID,accountID,admaxCampaignID,searchEngineAccountID,migrationDate,lastAdMaxRunDate from `st-tracker`.admaxCampaignMigrations where accountID=? and migrationDate>=? and lastAdMaxRunDate<=?]
2012-03-26 10:56:47.840 (4) [P1T1]: preparing SQL statement [select admaxNominalMonthlyBudgets.ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID where accountID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-03-26 10:56:47.884 (4) [P1T1]: preparing SQL statement [select aseam.admaxCampaignID, aseam.searchEngineAccountID from `st-tracker`.admaxCampaigns ac join `st-tracker`.admaxSearchEngineAccountMap aseam on aseam.admaxCampaignID = ac.id where ac.accountID = ?]
2012-03-26 10:56:47.922 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.googleMccAdMax.date,staging.googleMccAdMax.clicks,staging.googleMccAdMax.cost,tsacommon.searchEngineAccounts.distributionID from tsacommon.searchEngineAccounts left join staging.googleMccAdMax on staging.googleMccAdMax.campaignid=cast(tsacommon.searchEngineAccounts.searchEngineIdentifier as unsigned) where tsacommon.searchEngineAccounts.accountID=? and staging.googleMccAdMax.date=? and distributionID=?]
2012-03-26 10:56:47.934 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.bingMccAdMax.date,staging.bingMccAdMax.clicks,staging.bingMccAdMax.cost,tsacommon.searchEngineAccounts.distributionID from tsacommon.searchEngineAccounts left join staging.bingMccAdMax on staging.bingMccAdMax.campaignid=cast(tsacommon.searchEngineAccounts.searchEngineIdentifier as unsigned) where tsacommon.searchEngineAccounts.accountID=? and staging.bingMccAdMax.date=? and distributionID=?]
2012-03-26 10:56:47.944 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,pooledCarryover,dedicatedCarryover,commonCarryover from `st-tracker`.admaxCarryovers where admaxCampaignID=? and type=? and date=?]
2012-03-26 10:56:47.961 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,budget from `st-tracker`.admaxActualDailyBudgets where admaxCampaignID=? and type=? and date=?]
2012-03-26 10:56:48.038 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,balanceFactor from `st-tracker`.admaxSearchEngineAccountBalanceFactors where searchEngineAccountID=? and date=?]
2012-03-26 10:56:48.080 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,budget from `st-tracker`.admaxSearchEngineAccountActualDailyBudgets where searchEngineAccountID=? and date=?]
2012-03-26 10:56:48.107 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:48.107 (4) [P1T1]: spike: SQL->[SELECT DISTINCT admaxCampaignID, searchEngineAccounts.distributionID AS distributionID FROM (SELECT admaxSearchEngineAccountMap.admaxCampaignID AS admaxCampaignID, admaxSearchEngineAccountMap.searchEngineAccountID AS searchEngineAccountID FROM `st-tracker`.admaxSearchEngineAccountMap WHERE admaxCampaignID in (3281,3291)) AS campaignMap INNER JOIN tsacommon.searchEngineAccounts ON campaignMap.searchEngineAccountID = searchEngineAccounts.id]
2012-03-26 10:56:48.113 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:48.114 (5) [P1T1]: addSub("db")
2012-03-26 10:56:48.114 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:48.114 (4) [P1T1]: time=0.0060
2012-03-26 10:56:48.114 (4) [P1T1]: Query executed in 0.006s
2012-03-26 10:56:48.121 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-03-26 10:56:48.141 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,referenceID,createTime,refund from `st-tracker`.admaxRefunds where admaxCampaignID=? and date(createTime)=?]
2012-03-26 10:56:48.149 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?]
2012-03-26 10:56:48.156 (4) [P1T1]: Boosted Dedicated Carryover set after Carryover calculation for Campaign 3281 is 0.0
2012-03-26 10:56:48.157 (4) [P1T1]: Boosted Common Carryover set after Carryover calculation for Campaign 3281 is 46.258068
2012-03-26 10:56:48.157 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-03-26 10:56:48.163 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,referenceID,createTime,refund from `st-tracker`.admaxRefunds where admaxCampaignID=? and date(createTime)=?]
2012-03-26 10:56:48.169 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?]
2012-03-26 10:56:48.176 (4) [P1T1]: Boosted Dedicated Carryover set after Carryover calculation for Campaign 3291 is 0.0
2012-03-26 10:56:48.177 (4) [P1T1]: Boosted Common Carryover set after Carryover calculation for Campaign 3291 is 46.258064
2012-03-26 10:56:48.177 (4) [P1T1]: Distribution level Common Carry Over for Distribution ID: 3 = 92.51613
2012-03-26 10:56:48.177 (4) [P1T1]: Total of Monthly Budgets set for Adverts at the Distribution 3 = 600.0
2012-03-26 10:56:48.180 (4) [P1T1]: preparing SQL statement [SELECT damLimit FROM admaxDamLimits WHERE elementType = ? AND elementID = ? AND startDate <= ? AND (endDate is null OR endDate >= ?)]
2012-03-26 10:56:48.190 (4) [P1T1]: Dam Limit set for Distribution 3 is -1.0
2012-03-26 10:56:48.190 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:50.728 (4) [P1T1]: spike: SQL->[SELECT DISTINCT admaxCampaignID, searchEngineAccounts.distributionID AS distributionID FROM (SELECT admaxSearchEngineAccountMap.admaxCampaignID AS admaxCampaignID, admaxSearchEngineAccountMap.searchEngineAccountID AS searchEngineAccountID FROM `st-tracker`.admaxSearchEngineAccountMap WHERE admaxCampaignID in (3281,3291)) AS campaignMap INNER JOIN tsacommon.searchEngineAccounts ON campaignMap.searchEngineAccountID = searchEngineAccounts.id]
2012-03-26 10:56:50.736 (5) [P1T1]: recordAsSubs("db", 8, "P1T1")
2012-03-26 10:56:50.736 (5) [P1T1]: addSub("db")
2012-03-26 10:56:50.736 (5) [P1T1]: ProfilerRec.end("db", true): ret=8
2012-03-26 10:56:50.737 (4) [P1T1]: time=0.0080
2012-03-26 10:56:50.737 (4) [P1T1]: Query executed in 0.008s
2012-03-26 10:56:50.739 (4) [P1T1]: Distribution level Common Carry Over for Distribution ID: 147 = 0.0
2012-03-26 10:56:50.739 (4) [P1T1]: Total of Monthly Budgets set for Adverts at the Distribution 147 = 0.0
2012-03-26 10:56:50.739 (4) [P1T1]: preparing SQL statement [SELECT damLimit FROM admaxDamLimits WHERE elementType = ? AND elementID = ? AND startDate <= ? AND (endDate is null OR endDate >= ?)]
2012-03-26 10:56:50.744 (4) [P1T1]: Dam Limit set for Distribution 147 is -1.0
2012-03-26 10:56:50.745 (4) [P1T1]: Global Pool: 0.0
2012-03-26 10:56:50.745 (4) [P1T1]: Ranking map of Adverts at the Global level: {3281=2, 3291=1}
2012-03-26 10:56:50.747 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:50.747 (4) [P1T1]: spike: SQL->[SELECT DISTINCT admaxCampaignID, searchEngineAccounts.distributionID AS distributionID FROM (SELECT admaxSearchEngineAccountMap.admaxCampaignID AS admaxCampaignID, admaxSearchEngineAccountMap.searchEngineAccountID AS searchEngineAccountID FROM `st-tracker`.admaxSearchEngineAccountMap WHERE admaxCampaignID in (3281,3291)) AS campaignMap INNER JOIN tsacommon.searchEngineAccounts ON campaignMap.searchEngineAccountID = searchEngineAccounts.id]
2012-03-26 10:56:50.752 (5) [P1T1]: recordAsSubs("db", 5, "P1T1")
2012-03-26 10:56:50.753 (5) [P1T1]: addSub("db")
2012-03-26 10:56:50.753 (5) [P1T1]: ProfilerRec.end("db", true): ret=5
2012-03-26 10:56:50.753 (4) [P1T1]: time=0.0050
2012-03-26 10:56:50.753 (4) [P1T1]: Query executed in 0.005s
2012-03-26 10:56:50.755 (4) [P1T1]: preparing SQL statement [select sum(commonCarryover) from admaxCampaigns ac join admaxCarryovers c on c.admaxCampaignID = ac.ID and c.type=? and c.date = least(?, (select max(last_carryover.date) from admaxCarryovers last_carryover where last_carryover.admaxCampaignID = ac.ID and last_carryover.type = c.type)) join admaxNominalMonthlyBudgets anmb on anmb.admaxCampaignID = ac.ID and anmb.startDate = (select max(last_nom_budget.startDate) from admaxNominalMonthlyBudgets last_nom_budget where last_nom_budget.admaxCampaignID = ac.ID) where ac.accountID=? and ac.status=? and ((anmb.endDate is null) or (? >= anmb.endDate))]
2012-03-26 10:56:50.762 (4) [P1T1]: Ranking order (lower to higher) at Distribution: -1 - [3281, 3291]
2012-03-26 10:56:50.763 (4) [P1T1]: Boosted Pooled Carry Over for Campaign 3281 before Global Slosh is 61.67742
2012-03-26 10:56:50.763 (4) [P1T1]: Boosted Pooled Carry Over for Campaign 3281 after Global Slosh is 61.67742
2012-03-26 10:56:50.763 (4) [P1T1]: Boosted Pooled Carry Over for Campaign 3291 before Global Slosh is 30.83871
2012-03-26 10:56:50.763 (4) [P1T1]: Boosted Pooled Carry Over for Campaign 3291 after Global Slosh is 30.83871
2012-03-26 10:56:50.767 (4) [P1T1]: Nominal Daily Budget set for Campaign 3281
2012-03-26 10:56:50.770 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,boostMultiplier,boostCap from `st-tracker`.admaxBoosts where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-03-26 10:56:50.783 (4) [P1T1]: Boost Multiplier set for Campaign 3281 is 1.89
2012-03-26 10:56:50.783 (4) [P1T1]: Boost Cap set for Campaign 3281 is 0.0
2012-03-26 10:56:50.790 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshLimit from `st-tracker`.admaxSloshLimits where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-03-26 10:56:50.822 (4) [P1T1]: Slosh Limit set for Campaign 3281 is 2.0
2012-03-26 10:56:50.822 (4) [P1T1]: Final sloshed Boosted Pooled Carryover set for Campaign 3281 is 61.67742
2012-03-26 10:56:50.822 (4) [P1T1]: Final sloshed Boosted Dedicated Carryover set for Campaign 3281 is 0.0
2012-03-26 10:56:50.823 (4) [P1T1]: Final sloshed Boosted Actual Budget set for Campaign 3281 is 79.96774
2012-03-26 10:56:50.824 (4) [P1T1]: Nominal Daily Budget set for Campaign 3291
2012-03-26 10:56:50.824 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,boostMultiplier,boostCap from `st-tracker`.admaxBoosts where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-03-26 10:56:50.858 (4) [P1T1]: Boost Multiplier set for Campaign 3291 is 1.89
2012-03-26 10:56:50.858 (4) [P1T1]: Boost Cap set for Campaign 3291 is 0.0
2012-03-26 10:56:50.858 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshLimit from `st-tracker`.admaxSloshLimits where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-03-26 10:56:50.871 (4) [P1T1]: Slosh Limit set for Campaign 3291 is 2.0
2012-03-26 10:56:50.871 (4) [P1T1]: Final sloshed Boosted Pooled Carryover set for Campaign 3291 is 30.83871
2012-03-26 10:56:50.872 (4) [P1T1]: Final sloshed Boosted Dedicated Carryover set for Campaign 3291 is 0.0
2012-03-26 10:56:50.872 (4) [P1T1]: Final sloshed Boosted Actual Budget set for Campaign 3291 is 49.129036
2012-03-26 10:56:50.872 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:50.872 (4) [P1T1]: spike: SQL->[SELECT DISTINCT admaxCampaignID, searchEngineAccounts.distributionID AS distributionID FROM (SELECT admaxSearchEngineAccountMap.admaxCampaignID AS admaxCampaignID, admaxSearchEngineAccountMap.searchEngineAccountID AS searchEngineAccountID FROM `st-tracker`.admaxSearchEngineAccountMap WHERE admaxCampaignID in (3281,3291)) AS campaignMap INNER JOIN tsacommon.searchEngineAccounts ON campaignMap.searchEngineAccountID = searchEngineAccounts.id]
2012-03-26 10:56:50.877 (5) [P1T1]: recordAsSubs("db", 5, "P1T1")
2012-03-26 10:56:50.877 (5) [P1T1]: addSub("db")
2012-03-26 10:56:50.877 (5) [P1T1]: ProfilerRec.end("db", true): ret=5
2012-03-26 10:56:50.877 (4) [P1T1]: time=0.0050
2012-03-26 10:56:50.877 (4) [P1T1]: Query executed in 0.005s
2012-03-26 10:56:50.878 (4) [P1T1]: preparing SQL statement [select sum(commonCarryover) from admaxCampaigns ac join admaxCarryovers c on c.admaxCampaignID = ac.ID and c.type=? and c.date = least(?, (select max(last_carryover.date) from admaxCarryovers last_carryover where last_carryover.admaxCampaignID = ac.ID and last_carryover.type = c.type)) join admaxNominalMonthlyBudgets anmb on anmb.admaxCampaignID = ac.ID and anmb.startDate = (select max(last_nom_budget.startDate) from admaxNominalMonthlyBudgets last_nom_budget where last_nom_budget.admaxCampaignID = ac.ID) where ac.accountID=? and ac.status=? and ((anmb.endDate is null) or (? >= anmb.endDate))]
2012-03-26 10:56:50.884 (4) [P1T1]: Ranking order (lower to higher) at Distribution: -1 - []
2012-03-26 10:56:50.889 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,budgetCapMultiplier from `st-tracker`.admaxBudgetCapMultipliers where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-03-26 10:56:50.898 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxCarryovers (admaxCampaignID, type, date, pooledCarryover, dedicatedCarryover, commonCarryover) values (?,?,?,?,?,?) on duplicate key update pooledCarryover=?,dedicatedCarryover=?,commonCarryover=?]
2012-03-26 10:56:51.120 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxActualDailyBudgets (admaxCampaignID, type, date, budget) values (?,?,?,?) on duplicate key update budget=?]
2012-03-26 10:56:51.222 (4) [P1T1]: Balance Factor set for Search Engine Account ID 15901 is 0.5
2012-03-26 10:56:51.222 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountBalanceFactors (searchEngineAccountID, date, balanceFactor) values (?,?,?) on duplicate key update balanceFactor=?]
2012-03-26 10:56:51.254 (4) [P1T1]: Balance Factor set for Search Engine Account ID 15911 is 0.5
2012-03-26 10:56:51.265 (4) [P1T1]: Balance Factor set for Search Engine Account ID 15921 is 0.5
2012-03-26 10:56:51.275 (4) [P1T1]: Balance Factor set for Search Engine Account ID 15931 is 0.5
2012-03-26 10:56:51.282 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountActualDailyBudgets (searchEngineAccountID, date, budget) values (?,?,?) on duplicate key update budget=?]
2012-03-26 10:56:51.330 (3) [P1T1]: Re-run detected - Google campaign budgets will not be set
2012-03-26 10:56:51.332 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.332 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5965") and (`date`="2012-03-22 00:00:00")) limit 1]
2012-03-26 10:56:51.339 (5) [P1T1]: recordAsSubs("db", 7, "P1T1")
2012-03-26 10:56:51.339 (5) [P1T1]: addSub("db")
2012-03-26 10:56:51.339 (5) [P1T1]: ProfilerRec.end("db", true): ret=7
2012-03-26 10:56:51.339 (4) [P1T1]: time=0.0070
2012-03-26 10:56:51.339 (4) [P1T1]: Query executed in 0.007s
2012-03-26 10:56:51.339 (5) [P1T1]: loading 9 columns from result set:
2012-03-26 10:56:51.339 (5) [P1T1]:     loaded column: dataAvailability.id->165596
2012-03-26 10:56:51.340 (5) [P1T1]:     loaded column: dataAvailability.date->2012-03-22
2012-03-26 10:56:51.340 (5) [P1T1]:     loaded column: dataAvailability.oldUpdated->00:00:00
2012-03-26 10:56:51.340 (5) [P1T1]:     loaded column: dataAvailability.updated->2012-03-26 10:56:45.0
2012-03-26 10:56:51.340 (5) [P1T1]:     loaded column: dataAvailability.dataSourceID->5965
2012-03-26 10:56:51.341 (5) [P1T1]:     loaded column: dataAvailability.status->in progress
2012-03-26 10:56:51.341 (5) [P1T1]:     loaded column: dataAvailability.statusText->null
2012-03-26 10:56:51.341 (5) [P1T1]:     loaded column: dataAvailability.needsRerun->false
2012-03-26 10:56:51.341 (5) [P1T1]:     loaded column: dataAvailability.override->false
2012-03-26 10:56:51.341 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:51.342 (5) [P1T1]: quoteValue(), nothing special about it=>[5965], type=class java.lang.Integer
2012-03-26 10:56:51.342 (5) [P1T1]: quoteValue(), nothing special about it=>[165596], type=class java.lang.Integer
2012-03-26 10:56:51.342 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.342 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5965,"success","2012-03-22","2012-03-26 10:56:51",165596)], genflags=yes
2012-03-26 10:56:51.413 (5) [P1T1]: recordAsSubs("db", 71, "P1T1")
2012-03-26 10:56:51.414 (5) [P1T1]: addSub("db")
2012-03-26 10:56:51.414 (5) [P1T1]: ProfilerRec.end("db", true): ret=71
2012-03-26 10:56:51.415 (4) [P1T1]: time=0.071
2012-03-26 10:56:51.415 (4) [P1T1]: Query executed in 0.071s, 2 row(s) affected
2012-03-26 10:56:51.417 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.417 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5965","success","2012-03-22 00:00:00","2012-03-26 10:56:51")], genflags=yes
2012-03-26 10:56:51.423 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:51.423 (5) [P1T1]: addSub("db")
2012-03-26 10:56:51.423 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:51.423 (4) [P1T1]: time=0.0060
2012-03-26 10:56:51.423 (4) [P1T1]: Query executed in 0.006s, 1 row(s) affected
2012-03-26 10:56:51.751 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.751 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5966") and (`date`="2012-03-22 00:00:00")) limit 1]
2012-03-26 10:56:51.766 (5) [P1T1]: recordAsSubs("db", 15, "P1T1")
2012-03-26 10:56:51.766 (5) [P1T1]: addSub("db")
2012-03-26 10:56:51.766 (5) [P1T1]: ProfilerRec.end("db", true): ret=15
2012-03-26 10:56:51.767 (4) [P1T1]: time=0.015
2012-03-26 10:56:51.767 (4) [P1T1]: Query executed in 0.015s
2012-03-26 10:56:51.767 (5) [P1T1]: loading 9 columns from result set:
2012-03-26 10:56:51.767 (5) [P1T1]:     loaded column: dataAvailability.id->165597
2012-03-26 10:56:51.768 (5) [P1T1]:     loaded column: dataAvailability.date->2012-03-22
2012-03-26 10:56:51.769 (5) [P1T1]:     loaded column: dataAvailability.oldUpdated->00:00:00
2012-03-26 10:56:51.769 (5) [P1T1]:     loaded column: dataAvailability.updated->2012-03-26 10:56:46.0
2012-03-26 10:56:51.769 (5) [P1T1]:     loaded column: dataAvailability.dataSourceID->5966
2012-03-26 10:56:51.770 (5) [P1T1]:     loaded column: dataAvailability.status->in progress
2012-03-26 10:56:51.771 (5) [P1T1]:     loaded column: dataAvailability.statusText->null
2012-03-26 10:56:51.771 (5) [P1T1]:     loaded column: dataAvailability.needsRerun->false
2012-03-26 10:56:51.771 (5) [P1T1]:     loaded column: dataAvailability.override->false
2012-03-26 10:56:51.771 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:51.773 (5) [P1T1]: quoteValue(), nothing special about it=>[5966], type=class java.lang.Integer
2012-03-26 10:56:51.774 (5) [P1T1]: quoteValue(), nothing special about it=>[165597], type=class java.lang.Integer
2012-03-26 10:56:51.774 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.774 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5966,"success","2012-03-22","2012-03-26 10:56:51",165597)], genflags=yes
2012-03-26 10:56:51.895 (5) [P1T1]: recordAsSubs("db", 121, "P1T1")
2012-03-26 10:56:51.895 (5) [P1T1]: addSub("db")
2012-03-26 10:56:51.895 (5) [P1T1]: ProfilerRec.end("db", true): ret=121
2012-03-26 10:56:51.896 (4) [P1T1]: time=0.121
2012-03-26 10:56:51.896 (4) [P1T1]: Query executed in 0.121s, 2 row(s) affected
2012-03-26 10:56:51.899 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.899 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5966","success","2012-03-22 00:00:00","2012-03-26 10:56:51")], genflags=yes
2012-03-26 10:56:51.908 (5) [P1T1]: recordAsSubs("db", 9, "P1T1")
2012-03-26 10:56:51.908 (5) [P1T1]: addSub("db")
2012-03-26 10:56:51.908 (5) [P1T1]: ProfilerRec.end("db", true): ret=9
2012-03-26 10:56:51.908 (4) [P1T1]: time=0.0090
2012-03-26 10:56:51.909 (4) [P1T1]: Query executed in 0.009s, 1 row(s) affected
2012-03-26 10:56:51.911 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.912 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5967") and (`date`="2012-03-22 00:00:00")) limit 1]
2012-03-26 10:56:51.919 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:51.919 (5) [P1T1]: addSub("db")
2012-03-26 10:56:51.919 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:51.919 (4) [P1T1]: time=0.0060
2012-03-26 10:56:51.919 (4) [P1T1]: Query executed in 0.006s
2012-03-26 10:56:51.920 (5) [P1T1]: loading 9 columns from result set:
2012-03-26 10:56:51.920 (5) [P1T1]:     loaded column: dataAvailability.id->165598
2012-03-26 10:56:51.921 (5) [P1T1]:     loaded column: dataAvailability.date->2012-03-22
2012-03-26 10:56:51.921 (5) [P1T1]:     loaded column: dataAvailability.oldUpdated->00:00:00
2012-03-26 10:56:51.922 (5) [P1T1]:     loaded column: dataAvailability.updated->2012-03-26 10:56:46.0
2012-03-26 10:56:51.922 (5) [P1T1]:     loaded column: dataAvailability.dataSourceID->5967
2012-03-26 10:56:51.923 (5) [P1T1]:     loaded column: dataAvailability.status->in progress
2012-03-26 10:56:51.923 (5) [P1T1]:     loaded column: dataAvailability.statusText->null
2012-03-26 10:56:51.923 (5) [P1T1]:     loaded column: dataAvailability.needsRerun->false
2012-03-26 10:56:51.923 (5) [P1T1]:     loaded column: dataAvailability.override->false
2012-03-26 10:56:51.923 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:51.925 (5) [P1T1]: quoteValue(), nothing special about it=>[5967], type=class java.lang.Integer
2012-03-26 10:56:51.926 (5) [P1T1]: quoteValue(), nothing special about it=>[165598], type=class java.lang.Integer
2012-03-26 10:56:51.926 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.927 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5967,"success","2012-03-22","2012-03-26 10:56:51",165598)], genflags=yes
2012-03-26 10:56:51.948 (5) [P1T1]: recordAsSubs("db", 21, "P1T1")
2012-03-26 10:56:51.949 (5) [P1T1]: addSub("db")
2012-03-26 10:56:51.949 (5) [P1T1]: ProfilerRec.end("db", true): ret=21
2012-03-26 10:56:51.949 (4) [P1T1]: time=0.021
2012-03-26 10:56:51.950 (4) [P1T1]: Query executed in 0.021s, 2 row(s) affected
2012-03-26 10:56:51.952 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.952 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5967","success","2012-03-22 00:00:00","2012-03-26 10:56:51")], genflags=yes
2012-03-26 10:56:51.961 (5) [P1T1]: recordAsSubs("db", 9, "P1T1")
2012-03-26 10:56:51.961 (5) [P1T1]: addSub("db")
2012-03-26 10:56:51.961 (5) [P1T1]: ProfilerRec.end("db", true): ret=9
2012-03-26 10:56:51.962 (4) [P1T1]: time=0.0090
2012-03-26 10:56:51.962 (4) [P1T1]: Query executed in 0.009s, 1 row(s) affected
2012-03-26 10:56:51.964 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.964 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5968") and (`date`="2012-03-22 00:00:00")) limit 1]
2012-03-26 10:56:51.972 (5) [P1T1]: recordAsSubs("db", 8, "P1T1")
2012-03-26 10:56:51.972 (5) [P1T1]: addSub("db")
2012-03-26 10:56:51.972 (5) [P1T1]: ProfilerRec.end("db", true): ret=8
2012-03-26 10:56:51.972 (4) [P1T1]: time=0.0080
2012-03-26 10:56:51.973 (4) [P1T1]: Query executed in 0.008s
2012-03-26 10:56:51.973 (5) [P1T1]: loading 9 columns from result set:
2012-03-26 10:56:51.973 (5) [P1T1]:     loaded column: dataAvailability.id->165599
2012-03-26 10:56:51.974 (5) [P1T1]:     loaded column: dataAvailability.date->2012-03-22
2012-03-26 10:56:51.974 (5) [P1T1]:     loaded column: dataAvailability.oldUpdated->00:00:00
2012-03-26 10:56:51.975 (5) [P1T1]:     loaded column: dataAvailability.updated->2012-03-26 10:56:46.0
2012-03-26 10:56:51.975 (5) [P1T1]:     loaded column: dataAvailability.dataSourceID->5968
2012-03-26 10:56:51.976 (5) [P1T1]:     loaded column: dataAvailability.status->in progress
2012-03-26 10:56:51.976 (5) [P1T1]:     loaded column: dataAvailability.statusText->null
2012-03-26 10:56:51.976 (5) [P1T1]:     loaded column: dataAvailability.needsRerun->false
2012-03-26 10:56:51.976 (5) [P1T1]:     loaded column: dataAvailability.override->false
2012-03-26 10:56:51.977 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:51.978 (5) [P1T1]: quoteValue(), nothing special about it=>[5968], type=class java.lang.Integer
2012-03-26 10:56:51.979 (5) [P1T1]: quoteValue(), nothing special about it=>[165599], type=class java.lang.Integer
2012-03-26 10:56:51.979 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:51.979 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5968,"success","2012-03-22","2012-03-26 10:56:51",165599)], genflags=yes
2012-03-26 10:56:51.999 (5) [P1T1]: recordAsSubs("db", 20, "P1T1")
2012-03-26 10:56:52.000 (5) [P1T1]: addSub("db")
2012-03-26 10:56:52.000 (5) [P1T1]: ProfilerRec.end("db", true): ret=20
2012-03-26 10:56:52.000 (4) [P1T1]: time=0.02
2012-03-26 10:56:52.000 (4) [P1T1]: Query executed in 0.020s, 2 row(s) affected
2012-03-26 10:56:52.003 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:52.003 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5968","success","2012-03-22 00:00:00","2012-03-26 10:56:51")], genflags=yes
2012-03-26 10:56:52.120 (5) [P1T1]: recordAsSubs("db", 116, "P1T1")
2012-03-26 10:56:52.120 (5) [P1T1]: addSub("db")
2012-03-26 10:56:52.120 (5) [P1T1]: ProfilerRec.end("db", true): ret=116
2012-03-26 10:56:52.120 (4) [P1T1]: time=0.116
2012-03-26 10:56:52.120 (4) [P1T1]: Query executed in 0.116s, 1 row(s) affected
2012-03-26 10:56:52.121 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:52.121 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5969") and (`date`="2012-03-22 00:00:00")) limit 1]
2012-03-26 10:56:52.127 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:52.128 (5) [P1T1]: addSub("db")
2012-03-26 10:56:52.128 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:52.129 (4) [P1T1]: time=0.0060
2012-03-26 10:56:52.129 (4) [P1T1]: Query executed in 0.006s
2012-03-26 10:56:52.129 (5) [P1T1]: loading 9 columns from result set:
2012-03-26 10:56:52.129 (5) [P1T1]:     loaded column: dataAvailability.id->165600
2012-03-26 10:56:52.129 (5) [P1T1]:     loaded column: dataAvailability.date->2012-03-22
2012-03-26 10:56:52.129 (5) [P1T1]:     loaded column: dataAvailability.oldUpdated->00:00:00
2012-03-26 10:56:52.130 (5) [P1T1]:     loaded column: dataAvailability.updated->2012-03-26 10:56:47.0
2012-03-26 10:56:52.130 (5) [P1T1]:     loaded column: dataAvailability.dataSourceID->5969
2012-03-26 10:56:52.130 (5) [P1T1]:     loaded column: dataAvailability.status->in progress
2012-03-26 10:56:52.130 (5) [P1T1]:     loaded column: dataAvailability.statusText->null
2012-03-26 10:56:52.130 (5) [P1T1]:     loaded column: dataAvailability.needsRerun->false
2012-03-26 10:56:52.130 (5) [P1T1]:     loaded column: dataAvailability.override->false
2012-03-26 10:56:52.130 (4) [P1T1]:   Record Loaded
2012-03-26 10:56:52.131 (5) [P1T1]: quoteValue(), nothing special about it=>[5969], type=class java.lang.Integer
2012-03-26 10:56:52.131 (5) [P1T1]: quoteValue(), nothing special about it=>[165600], type=class java.lang.Integer
2012-03-26 10:56:52.131 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:52.131 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5969,"success","2012-03-22","2012-03-26 10:56:52",165600)], genflags=yes
2012-03-26 10:56:52.159 (5) [P1T1]: recordAsSubs("db", 28, "P1T1")
2012-03-26 10:56:52.159 (5) [P1T1]: addSub("db")
2012-03-26 10:56:52.159 (5) [P1T1]: ProfilerRec.end("db", true): ret=28
2012-03-26 10:56:52.159 (4) [P1T1]: time=0.028
2012-03-26 10:56:52.159 (4) [P1T1]: Query executed in 0.028s, 2 row(s) affected
2012-03-26 10:56:52.160 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:52.161 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5969","success","2012-03-22 00:00:00","2012-03-26 10:56:52")], genflags=yes
2012-03-26 10:56:52.168 (5) [P1T1]: recordAsSubs("db", 7, "P1T1")
2012-03-26 10:56:52.168 (5) [P1T1]: addSub("db")
2012-03-26 10:56:52.168 (5) [P1T1]: ProfilerRec.end("db", true): ret=7
2012-03-26 10:56:52.168 (4) [P1T1]: time=0.0070
2012-03-26 10:56:52.168 (4) [P1T1]: Query executed in 0.007s, 1 row(s) affected
2012-03-26 10:56:52.169 (3) [P1T1]: Finished applying algorithm [SABB] for account [5221] in distributions [3]
2012-03-26 10:56:52.169 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-03-26 10:56:52.169 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.5221')]
2012-03-26 10:56:52.175 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-03-26 10:56:52.176 (5) [P1T1]: addSub("db")
2012-03-26 10:56:52.176 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-03-26 10:56:52.176 (4) [P1T1]: time=0.0060
2012-03-26 10:56:52.176 (4) [P1T1]: Query executed in 0.006s
2012-03-26 10:56:52.176 (3) [P1T1]: Released migrator lock for Account ID #5221
2012-03-26 10:56:52.176 (4) [P1T1]: Returning Object to Pool
2012-03-26 10:56:52.176 (4) [P1T1]: Returning Object to Pool
2012-03-26 10:56:52.176 (4) [P1T1]: Returning Object to Pool
2012-03-26 10:56:52.176 (3) [P1T1]: Completed Account ID #5221: alok-n63a
2012-03-26 10:56:52.179 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-03-26 10:56:52.181 (3) [main]: ------------AdMax Summarizer done
2012-03-26 10:56:52.181 (3) [main]: =============== Completed AdMax Summarizer ================
2012-03-26 10:56:52.181 (4) [main]: DataCache: Found key global-logging
2012-03-26 10:56:52.182 (4) [main]: Took Existing Object from Pool
2012-03-26 10:56:52.182 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-03-26 10:56:52.182 (4) [main]: spike: SQL->[select @@version]
2012-03-26 10:56:52.190 (2) [main]: Warning(s) detected in statement [select @@version] executed by user [spike]
2012-03-26 10:56:52.190 (2) [main]: Table 'logging.processHistory' doesn't exist (1146)
2012-03-26 10:56:52.190 (5) [main]: recordAsSubs("db", 8, "main")
2012-03-26 10:56:52.191 (5) [main]: addSub("db")
2012-03-26 10:56:52.191 (5) [main]: ProfilerRec.end("db", true): ret=8
2012-03-26 10:56:52.191 (4) [main]: time=0.0080
2012-03-26 10:56:52.191 (4) [main]: Query executed in 0.008s
2012-03-26 10:56:52.192 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-03-26 10:56:52.192 (3) [main]: Could not save process history stop
2012-03-26 10:56:52.192 (4) [main]: Returning Object to Pool
2012-03-26 10:56:52.192 (3) [main]: =============== Stats ================
2012-03-26 10:56:52.192 (3) [main]: --- Process ---
2012-03-26 10:56:52.193 (3) [main]:
2012-03-26 10:56:52.193 (3) [main]:   ABU Process(start):                     Mon Mar 26 10:56:43 BST 2012
2012-03-26 10:56:52.193 (3) [main]:   ABU Process(stop):                      Mon Mar 26 10:56:52 BST 2012
2012-03-26 10:56:52.193 (3) [main]:
2012-03-26 10:56:52.194 (3) [main]: --- Accounts ---
2012-03-26 10:56:52.194 (3) [main]:
2012-03-26 10:56:52.194 (3) [main]:   Accounts Processed:                     1
2012-03-26 10:56:52.194 (3) [main]:   Accounts Skipped:                       0
2012-03-26 10:56:52.194 (3) [main]:   Accounts Processed Successfully:        1
2012-03-26 10:56:52.195 (3) [main]:
2012-03-26 10:56:52.195 (3) [main]: --- Adverts ---
2012-03-26 10:56:52.195 (3) [main]:
2012-03-26 10:56:52.195 (3) [main]:   Adverts Processed:                      2
2012-03-26 10:56:52.195 (3) [main]:   Adverts Processed Successfully:         2
2012-03-26 10:56:52.195 (3) [main]:   Advert Budgets Capped:                  0
2012-03-26 10:56:52.196 (3) [main]:
2012-03-26 10:56:52.196 (3) [main]: --- Campaigns ---
2012-03-26 10:56:52.196 (3) [main]:
2012-03-26 10:56:52.196 (3) [main]:   Campaigns Processed:                    4
2012-03-26 10:56:52.196 (3) [main]:   Campaigns Processed Successfully:       4
2012-03-26 10:56:52.196 (3) [main]:
2012-03-26 10:56:52.197 (3) [main]: --- Budget/Spend ---
2012-03-26 10:56:52.197 (3) [main]:
2012-03-26 10:56:52.197 (3) [main]:   Campaign Budgets Updated:               4
2012-03-26 10:56:52.197 (3) [main]:   Campaign Budgets Sent To Google:        0
2012-03-26 10:56:52.197 (3) [main]:
2012-03-26 10:56:52.198 (3) [main]:   Spend Total:                            0.0
2012-03-26 10:56:52.198 (3) [main]:   Common Carryover Total:                 92.51613
2012-03-26 10:56:52.198 (5) [main]: ProfilerRec.end("AdMaxSummarizer", false): ret=8344
2012-03-26 10:56:52.198 (4) [main]: time=8.344
2012-03-26 10:56:52.198 (3) [main]: AdMaxSummarizer:    8.344s
2012-03-26 10:56:52.198 (3) [main]:     by key:
2012-03-26 10:56:52.198 (4) [main]: time=1.035
2012-03-26 10:56:52.198 (3) [main]:         db: 1.035s
2012-03-26 10:56:52.199 (3) [main]:             by thread:
2012-03-26 10:56:52.199 (4) [main]: time=0.079
2012-03-26 10:56:52.199 (3) [main]:                 main:       0.079s
2012-03-26 10:56:52.199 (4) [main]: time=0.956
2012-03-26 10:56:52.199 (3) [main]:                 P1T1:       0.956s
2012-03-26 10:56:52.199 (4) [main]: time=7.309
2012-03-26 10:56:52.199 (3) [main]:         other:      7.309s