tsaapp@yell-ec-xml2:/usr/local/tsa/bidmgr$ ./admax.sh -d5 -T2012-03-21 -a5221 pid 10706's current affinity list: 0 pid 10706's new affinity list: 0 pid 10706's current affinity list: 0 sched_setaffinity: Invalid argument failed to set pid 10706's affinity. 2012-03-20 15:11:12.585 (3) [main]: Debug Level set to 5 2012-03-20 15:11:12.587 (3) [main]: AdMax Summarizer parameters: [Ljava.lang.String;@437f1ba3 2012-03-20 15:11:12.608 (5) [main]: ProfilerRec.start("AdMaxSummarizer",false) in Thread [main] 2012-03-20 15:11:12.619 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:12.989 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.002 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-20 15:11:13.003 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-logging")) limit 1] 2012-03-20 15:11:13.045 (5) [main]: recordAsSubs("db", 42, "main") 2012-03-20 15:11:13.046 (5) [main]: addSub("db") 2012-03-20 15:11:13.046 (5) [main]: ProfilerRec.end("db", true): ret=42 2012-03-20 15:11:13.048 (4) [main]: time=0.042 2012-03-20 15:11:13.049 (4) [main]: Query executed in 0.042s 2012-03-20 15:11:13.051 (5) [main]: loading 8 columns from result set: 2012-03-20 15:11:13.052 (5) [main]: loaded column: databaseInstances.id->4 2012-03-20 15:11:13.052 (5) [main]: loaded column: databaseInstances.name->global-logging 2012-03-20 15:11:13.099 (5) [main]: loaded column: databaseInstances.description->Global Logging Tables 2012-03-20 15:11:13.100 (5) [main]: loaded column: databaseInstances.type->mysql 2012-03-20 15:11:13.100 (5) [main]: loaded column: databaseInstances.database->logging 2012-03-20 15:11:13.101 (5) [main]: loaded column: databaseInstances.host->logging-01-write 2012-03-20 15:11:13.101 (5) [main]: loaded column: databaseInstances.port->3306 2012-03-20 15:11:13.101 (5) [main]: loaded column: databaseInstances.access->rw 2012-03-20 15:11:13.101 (4) [main]: Record Loaded 2012-03-20 15:11:13.102 (4) [main]: DataCache: put key global-logging 2012-03-20 15:11:13.115 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.182 (3) [main]: DatabasePool with a limit of 18 created 2012-03-20 15:11:13.186 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2012-03-20 15:11:13.229 (4) [main]: opened [jdbc:mysql://logging-01-write:3306/logging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.230 (4) [main]: Created new Object 2012-03-20 15:11:13.230 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-20 15:11:13.231 (4) [main]: spike: SQL->[select @@version] 2012-03-20 15:11:13.232 (5) [main]: recordAsSubs("db", 2, "main") 2012-03-20 15:11:13.232 (5) [main]: addSub("db") 2012-03-20 15:11:13.232 (5) [main]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:13.233 (4) [main]: time=0.0020 2012-03-20 15:11:13.233 (4) [main]: Query executed in 0.002s 2012-03-20 15:11:13.233 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-20 15:11:13.256 (4) [main]: preparing SQL statement [insert into logging.processHistory (processID, startTime) values (?,?)], genflags=yes 2012-03-20 15:11:13.286 (3) [main]: Could not save process history start 2012-03-20 15:11:13.287 (4) [main]: Returning Object to Pool 2012-03-20 15:11:13.287 (3) [main]: =============== Starting AdMax Summarizer ================ 2012-03-20 15:11:13.287 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:13.287 (3) [main]: ----------------AdMax Summarizer starting 2012-03-20 15:11:13.338 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.340 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-20 15:11:13.340 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (5221))) order by rand()] 2012-03-20 15:11:13.343 (5) [main]: recordAsSubs("db", 3, "main") 2012-03-20 15:11:13.343 (5) [main]: addSub("db") 2012-03-20 15:11:13.343 (5) [main]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:13.344 (4) [main]: time=0.0030 2012-03-20 15:11:13.344 (4) [main]: Query executed in 0.003s 2012-03-20 15:11:13.344 (5) [main]: loading 19 columns from result set: 2012-03-20 15:11:13.345 (5) [main]: loaded column: accounts.id->5221 2012-03-20 15:11:13.345 (5) [main]: loaded column: accounts.description->alok-n63a 2012-03-20 15:11:13.346 (5) [main]: loaded column: accounts.tier->1 2012-03-20 15:11:13.346 (5) [main]: loaded column: accounts.priority->50 2012-03-20 15:11:13.347 (5) [main]: loaded column: accounts.reportClicksOut->false 2012-03-20 15:11:13.347 (5) [main]: loaded column: accounts.reportConversions->false 2012-03-20 15:11:13.347 (5) [main]: loaded column: accounts.conversionTypes->paid 2012-03-20 15:11:13.348 (5) [main]: loaded column: accounts.isBidManaged->true 2012-03-20 15:11:13.348 (5) [main]: loaded column: accounts.isActive->true 2012-03-20 15:11:13.349 (5) [main]: loaded column: accounts.perfMetric->cpa 2012-03-20 15:11:13.349 (5) [main]: loaded column: accounts.providesConversionData->true 2012-03-20 15:11:13.349 (5) [main]: loaded column: accounts.addConversionData->false 2012-03-20 15:11:13.350 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2012-03-20 15:11:13.350 (5) [main]: loaded column: accounts.hideNullSources->false 2012-03-20 15:11:13.350 (5) [main]: loaded column: accounts.nowTime->null 2012-03-20 15:11:13.364 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2012-03-20 15:11:13.365 (5) [main]: loaded column: accounts.databaseInstance->1 2012-03-20 15:11:13.365 (5) [main]: loaded column: accounts.warehouseInstance->1 2012-03-20 15:11:13.366 (5) [main]: loaded column: accounts.isOnline->true 2012-03-20 15:11:13.381 (3) [P1T1]: Starting Account ID #5221: alok-n63a 2012-03-20 15:11:13.382 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:13.434 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.434 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:13.435 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.435 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=5221) limit 1] 2012-03-20 15:11:13.439 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:13.440 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.440 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:13.440 (4) [P1T1]: time=0.0040 2012-03-20 15:11:13.441 (4) [P1T1]: Query executed in 0.004s 2012-03-20 15:11:13.441 (5) [P1T1]: loading 19 columns from result set: 2012-03-20 15:11:13.441 (5) [P1T1]: loaded column: accounts.id->5221 2012-03-20 15:11:13.442 (5) [P1T1]: loaded column: accounts.description->alok-n63a 2012-03-20 15:11:13.442 (5) [P1T1]: loaded column: accounts.tier->1 2012-03-20 15:11:13.442 (5) [P1T1]: loaded column: accounts.priority->50 2012-03-20 15:11:13.443 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2012-03-20 15:11:13.443 (5) [P1T1]: loaded column: accounts.reportConversions->false 2012-03-20 15:11:13.443 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2012-03-20 15:11:13.444 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2012-03-20 15:11:13.444 (5) [P1T1]: loaded column: accounts.isActive->true 2012-03-20 15:11:13.444 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2012-03-20 15:11:13.445 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2012-03-20 15:11:13.445 (5) [P1T1]: loaded column: accounts.addConversionData->false 2012-03-20 15:11:13.446 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2012-03-20 15:11:13.446 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2012-03-20 15:11:13.447 (5) [P1T1]: loaded column: accounts.nowTime->null 2012-03-20 15:11:13.447 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2012-03-20 15:11:13.447 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2012-03-20 15:11:13.447 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2012-03-20 15:11:13.448 (5) [P1T1]: loaded column: accounts.isOnline->true 2012-03-20 15:11:13.448 (4) [P1T1]: Record Loaded 2012-03-20 15:11:13.448 (4) [P1T1]: DataCache: put key acct-st-tracker 5221 2012-03-20 15:11:13.449 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.450 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-1")) limit 1] 2012-03-20 15:11:13.451 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:13.452 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.452 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:13.453 (4) [P1T1]: time=0.0010 2012-03-20 15:11:13.453 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:13.454 (5) [P1T1]: loading 8 columns from result set: 2012-03-20 15:11:13.454 (5) [P1T1]: loaded column: databaseInstances.id->15 2012-03-20 15:11:13.454 (5) [P1T1]: loaded column: databaseInstances.name->acct-st-tracker-1 2012-03-20 15:11:13.454 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Catch-all database 2012-03-20 15:11:13.456 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-03-20 15:11:13.457 (5) [P1T1]: loaded column: databaseInstances.database->st-tracker 2012-03-20 15:11:13.457 (5) [P1T1]: loaded column: databaseInstances.host->acctdb-01-write 2012-03-20 15:11:13.457 (5) [P1T1]: loaded column: databaseInstances.port->3306 2012-03-20 15:11:13.457 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-03-20 15:11:13.457 (4) [P1T1]: Record Loaded 2012-03-20 15:11:13.458 (4) [P1T1]: DataCache: put key acct-st-tracker-1 2012-03-20 15:11:13.462 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.464 (3) [P1T1]: DatabasePool with a limit of 18 created 2012-03-20 15:11:13.515 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.515 (4) [P1T1]: Created new Object 2012-03-20 15:11:13.515 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.516 (4) [P1T1]: spike: SQL->[select @@version] 2012-03-20 15:11:13.518 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:13.518 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.518 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:13.519 (4) [P1T1]: time=0.0020 2012-03-20 15:11:13.519 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:13.519 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-20 15:11:13.519 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:13.520 (3) [P1T1]: DatabasePool with a limit of 18 created 2012-03-20 15:11:13.569 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.570 (4) [P1T1]: Created new Object 2012-03-20 15:11:13.570 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.570 (4) [P1T1]: spike: SQL->[select @@version] 2012-03-20 15:11:13.572 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:13.572 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.573 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:13.573 (4) [P1T1]: time=0.0020 2012-03-20 15:11:13.573 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:13.573 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-20 15:11:13.574 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:13.614 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.615 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.616 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-staging")) limit 1] 2012-03-20 15:11:13.617 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:13.618 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.618 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:13.618 (4) [P1T1]: time=0.0010 2012-03-20 15:11:13.618 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:13.619 (5) [P1T1]: loading 8 columns from result set: 2012-03-20 15:11:13.619 (5) [P1T1]: loaded column: databaseInstances.id->3 2012-03-20 15:11:13.619 (5) [P1T1]: loaded column: databaseInstances.name->global-staging 2012-03-20 15:11:13.620 (5) [P1T1]: loaded column: databaseInstances.description->Global Staging Tables 2012-03-20 15:11:13.620 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-03-20 15:11:13.620 (5) [P1T1]: loaded column: databaseInstances.database->staging 2012-03-20 15:11:13.620 (5) [P1T1]: loaded column: databaseInstances.host->staging-01-write 2012-03-20 15:11:13.621 (5) [P1T1]: loaded column: databaseInstances.port->3306 2012-03-20 15:11:13.621 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-03-20 15:11:13.621 (4) [P1T1]: Record Loaded 2012-03-20 15:11:13.621 (4) [P1T1]: DataCache: put key global-staging 2012-03-20 15:11:13.622 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.623 (3) [P1T1]: DatabasePool with a limit of 18 created 2012-03-20 15:11:13.743 (4) [P1T1]: opened [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:13.744 (4) [P1T1]: Created new Object 2012-03-20 15:11:13.744 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.745 (4) [P1T1]: spike: SQL->[select @@version] 2012-03-20 15:11:13.746 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:13.746 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.746 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:13.747 (4) [P1T1]: time=0.0020 2012-03-20 15:11:13.747 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:13.747 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-20 15:11:13.749 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.749 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.5221', 600)] 2012-03-20 15:11:13.758 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2012-03-20 15:11:13.759 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.761 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2012-03-20 15:11:13.762 (4) [P1T1]: time=0.0080 2012-03-20 15:11:13.764 (4) [P1T1]: Query executed in 0.008s 2012-03-20 15:11:13.765 (3) [P1T1]: Got migrator lock for Account ID #5221 2012-03-20 15:11:13.776 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:13.783 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.784 (4) [P1T1]: spike: SQL->[select * from `settings` where ((((`settings`.`scope`="accounts")) and ((`settings`.`scopeId`=5221))))] 2012-03-20 15:11:13.786 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:13.787 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.787 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:13.787 (4) [P1T1]: time=0.0020 2012-03-20 15:11:13.787 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:13.790 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.791 (4) [P1T1]: spike: SQL->[select * from `settingDefaults` where (`settingDefaults`.`scope`="accounts")] 2012-03-20 15:11:13.793 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:13.793 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.793 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:13.793 (4) [P1T1]: time=0.0020 2012-03-20 15:11:13.793 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:13.795 (4) [P1T1]: DataCache: put key accounts 5221 2012-03-20 15:11:13.824 (4) [P1T1]: DataCache: Found key accounts 5221 2012-03-20 15:11:13.824 (4) [P1T1]: Settings.getSettings: loaded from cache (key=accounts 5221) 2012-03-20 15:11:13.825 (3) [P1T1]: Applying algorithm [SABB] for Account ID #5221 in distributions [3] 2012-03-20 15:11:13.826 (3) [P1T1]: Processing data for Wed Mar 21 00:00:00 GMT 2012 2012-03-20 15:11:13.841 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:13.841 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.842 (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-20 15:11:13.867 (5) [P1T1]: recordAsSubs("db", 25, "P1T1") 2012-03-20 15:11:13.868 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.868 (5) [P1T1]: ProfilerRec.end("db", true): ret=25 2012-03-20 15:11:13.868 (4) [P1T1]: time=0.025 2012-03-20 15:11:13.868 (4) [P1T1]: Query executed in 0.025s 2012-03-20 15:11:13.973 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:13.973 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.973 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="")) limit 1] 2012-03-20 15:11:13.976 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:13.976 (5) [P1T1]: addSub("db") 2012-03-20 15:11:13.976 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:13.976 (4) [P1T1]: time=0.0030 2012-03-20 15:11:13.976 (4) [P1T1]: Query executed in 0.003s 2012-03-20 15:11:13.976 (5) [P1T1]: loading 4 columns from result set: 2012-03-20 15:11:13.976 (5) [P1T1]: loaded column: dataSources.id->5965 2012-03-20 15:11:13.977 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-20 15:11:13.977 (5) [P1T1]: loaded column: dataSources.typeID->0 2012-03-20 15:11:13.977 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-20 15:11:13.977 (4) [P1T1]: Record Loaded 2012-03-20 15:11:13.978 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:13.978 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:13.978 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`dataSources`.`type`="admax") and (`dataSources`.`accountID`=5221))] 2012-03-20 15:11:14.213 (5) [P1T1]: recordAsSubs("db", 235, "P1T1") 2012-03-20 15:11:14.214 (5) [P1T1]: addSub("db") 2012-03-20 15:11:14.214 (5) [P1T1]: ProfilerRec.end("db", true): ret=235 2012-03-20 15:11:14.214 (4) [P1T1]: time=0.235 2012-03-20 15:11:14.215 (4) [P1T1]: Query executed in 0.235s 2012-03-20 15:11:14.215 (5) [P1T1]: loading 4 columns from result set: 2012-03-20 15:11:14.215 (5) [P1T1]: loaded column: dataSources.id->5965 2012-03-20 15:11:14.216 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-20 15:11:14.217 (5) [P1T1]: loaded column: dataSources.typeID->0 2012-03-20 15:11:14.217 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-20 15:11:14.224 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:14.224 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5965") and (`date`="2012-03-21 00:00:00")) limit 1] 2012-03-20 15:11:14.226 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:14.227 (5) [P1T1]: addSub("db") 2012-03-20 15:11:14.227 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:14.228 (4) [P1T1]: time=0.0020 2012-03-20 15:11:14.228 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:14.229 (4) [P1T1]: Record Not Found 2012-03-20 15:11:14.231 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:14.231 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5965","in progress","2012-03-21 00:00:00","2012-03-20 15:11:14")], genflags=yes 2012-03-20 15:11:14.259 (5) [P1T1]: recordAsSubs("db", 28, "P1T1") 2012-03-20 15:11:14.259 (5) [P1T1]: addSub("db") 2012-03-20 15:11:14.260 (5) [P1T1]: ProfilerRec.end("db", true): ret=28 2012-03-20 15:11:14.260 (4) [P1T1]: time=0.028 2012-03-20 15:11:14.260 (4) [P1T1]: Query executed in 0.028s, 1 row(s) affected 2012-03-20 15:11:14.264 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:14.264 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5965","in progress","2012-03-21 00:00:00","2012-03-20 15:11:14")], genflags=yes 2012-03-20 15:11:14.266 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:14.266 (5) [P1T1]: addSub("db") 2012-03-20 15:11:14.267 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:14.267 (4) [P1T1]: time=0.0020 2012-03-20 15:11:14.267 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-03-20 15:11:14.272 (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-20 15:11:14.280 (4) [P1T1]: preparing SQL statement [select ID,accountID,admaxCampaignID,searchEngineAccountID,migrationDate,lastAdMaxRunDate from `st-tracker`.admaxCampaignMigrations where accountID=? and migrationDate>=? and lastAdMaxRunDate<=?] 2012-03-20 15:11:14.284 (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-20 15:11:14.294 (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-20 15:11:14.299 (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-20 15:11:14.364 (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-20 15:11:14.369 (2) [P1T1]: AdMax campaign ID: 3281 spent 0.4 2012-03-20 15:11:14.370 (2) [P1T1]: AdMax campaign ID: 3281 spent 0.8 2012-03-20 15:11:14.370 (2) [P1T1]: AdMax campaign ID: 3291 spent 0.05 2012-03-20 15:11:14.370 (2) [P1T1]: AdMax campaign ID: 3291 spent 0.1 2012-03-20 15:11:14.373 (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-20 15:11:14.382 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,budget from `st-tracker`.admaxActualDailyBudgets where admaxCampaignID=? and type=? and date=?] 2012-03-20 15:11:14.388 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,balanceFactor from `st-tracker`.admaxSearchEngineAccountBalanceFactors where searchEngineAccountID=? and date=?] 2012-03-20 15:11:14.438 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,budget from `st-tracker`.admaxSearchEngineAccountActualDailyBudgets where searchEngineAccountID=? and date=?] 2012-03-20 15:11:14.455 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:14.456 (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-20 15:11:14.458 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:14.458 (5) [P1T1]: addSub("db") 2012-03-20 15:11:14.459 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:14.459 (4) [P1T1]: time=0.0020 2012-03-20 15:11:14.459 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:14.465 (4) [P1T1]: Distribution level Common Carry Over for Distribution ID: 3 = 0.0 2012-03-20 15:11:14.465 (4) [P1T1]: Total of Monthly Budgets set for Adverts at the Distribution 3 = 0.0 2012-03-20 15:11:14.470 (4) [P1T1]: preparing SQL statement [SELECT damLimit FROM admaxDamLimits WHERE elementType = ? AND elementID = ? AND startDate <= ? AND (endDate is null OR endDate >= ?)] 2012-03-20 15:11:14.474 (4) [P1T1]: Dam Limit set for Distribution 3 is -1.0 2012-03-20 15:11:14.474 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:14.475 (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-20 15:11:14.477 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:14.477 (5) [P1T1]: addSub("db") 2012-03-20 15:11:14.477 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:14.478 (4) [P1T1]: time=0.0020 2012-03-20 15:11:14.478 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:14.481 (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-20 15:11:15.483 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,referenceID,createTime,refund from `st-tracker`.admaxRefunds where admaxCampaignID=? and date(createTime)=?] 2012-03-20 15:11:15.486 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2012-03-20 15:11:15.488 (4) [P1T1]: Boosted Dedicated Carryover set after Carryover calculation for Campaign 3281 is 0.0 2012-03-20 15:11:15.489 (4) [P1T1]: Boosted Common Carryover set after Carryover calculation for Campaign 3281 is 27.167744 2012-03-20 15:11:15.489 (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-20 15:11:15.491 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,referenceID,createTime,refund from `st-tracker`.admaxRefunds where admaxCampaignID=? and date(createTime)=?] 2012-03-20 15:11:15.493 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2012-03-20 15:11:15.495 (4) [P1T1]: Boosted Dedicated Carryover set after Carryover calculation for Campaign 3291 is 0.0 2012-03-20 15:11:15.495 (4) [P1T1]: Boosted Common Carryover set after Carryover calculation for Campaign 3291 is 27.86774 2012-03-20 15:11:15.496 (4) [P1T1]: Distribution level Common Carry Over for Distribution ID: 147 = 55.035484 2012-03-20 15:11:15.496 (4) [P1T1]: Total of Monthly Budgets set for Adverts at the Distribution 147 = 600.0 2012-03-20 15:11:15.496 (4) [P1T1]: preparing SQL statement [SELECT damLimit FROM admaxDamLimits WHERE elementType = ? AND elementID = ? AND startDate <= ? AND (endDate is null OR endDate >= ?)] 2012-03-20 15:11:15.498 (4) [P1T1]: Dam Limit set for Distribution 147 is -1.0 2012-03-20 15:11:15.498 (4) [P1T1]: Global Pool: 0.0 2012-03-20 15:11:15.499 (4) [P1T1]: Ranking map of Adverts at the Global level: {3281=1, 3291=2} 2012-03-20 15:11:15.499 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.499 (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 (3291,3281)) AS campaignMap INNER JOIN tsacommon.searchEngineAccounts ON campaignMap.searchEngineAccountID = searchEngineAccounts.id] 2012-03-20 15:11:15.501 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:15.501 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.502 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.502 (4) [P1T1]: time=0.0020 2012-03-20 15:11:15.502 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:15.504 (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-20 15:11:15.507 (4) [P1T1]: Ranking order (lower to higher) at Distribution: -1 - [] 2012-03-20 15:11:15.509 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.509 (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 (3291,3281)) AS campaignMap INNER JOIN tsacommon.searchEngineAccounts ON campaignMap.searchEngineAccountID = searchEngineAccounts.id] 2012-03-20 15:11:15.511 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:15.511 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.511 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.512 (4) [P1T1]: time=0.0020 2012-03-20 15:11:15.512 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:15.512 (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-20 15:11:15.523 (4) [P1T1]: Ranking order (lower to higher) at Distribution: -1 - [3291, 3281] 2012-03-20 15:11:15.523 (4) [P1T1]: Boosted Pooled Carry Over for Campaign 3291 before Global Slosh is 36.690323 2012-03-20 15:11:15.523 (4) [P1T1]: Boosted Pooled Carry Over for Campaign 3291 after Global Slosh is 36.690323 2012-03-20 15:11:15.523 (4) [P1T1]: Boosted Pooled Carry Over for Campaign 3281 before Global Slosh is 18.345161 2012-03-20 15:11:15.524 (4) [P1T1]: Boosted Pooled Carry Over for Campaign 3281 after Global Slosh is 18.345161 2012-03-20 15:11:15.537 (4) [P1T1]: Nominal Daily Budget set for Campaign 3291 2012-03-20 15:11:15.539 (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-20 15:11:15.554 (4) [P1T1]: Boost Multiplier set for Campaign 3291 is 1.89 2012-03-20 15:11:15.555 (4) [P1T1]: Boost Cap set for Campaign 3291 is 0.0 2012-03-20 15:11:15.556 (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-20 15:11:15.563 (4) [P1T1]: Slosh Limit set for Campaign 3291 is 2.0 2012-03-20 15:11:15.564 (4) [P1T1]: Final sloshed Boosted Pooled Carryover set for Campaign 3291 is 36.690323 2012-03-20 15:11:15.564 (4) [P1T1]: Final sloshed Boosted Dedicated Carryover set for Campaign 3291 is 0.0 2012-03-20 15:11:15.564 (4) [P1T1]: Final sloshed Boosted Actual Budget set for Campaign 3291 is 54.980644 2012-03-20 15:11:15.566 (4) [P1T1]: Nominal Daily Budget set for Campaign 3281 2012-03-20 15:11:15.566 (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-20 15:11:15.600 (4) [P1T1]: Boost Multiplier set for Campaign 3281 is 1.89 2012-03-20 15:11:15.600 (4) [P1T1]: Boost Cap set for Campaign 3281 is 0.0 2012-03-20 15:11:15.600 (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-20 15:11:15.602 (4) [P1T1]: Slosh Limit set for Campaign 3281 is 2.0 2012-03-20 15:11:15.602 (4) [P1T1]: Final sloshed Boosted Pooled Carryover set for Campaign 3281 is 18.345161 2012-03-20 15:11:15.603 (4) [P1T1]: Final sloshed Boosted Dedicated Carryover set for Campaign 3281 is 0.0 2012-03-20 15:11:15.603 (4) [P1T1]: Final sloshed Boosted Actual Budget set for Campaign 3281 is 36.635483 2012-03-20 15:11:15.608 (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-20 15:11:15.626 (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-20 15:11:16.381 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxActualDailyBudgets (admaxCampaignID, type, date, budget) values (?,?,?,?) on duplicate key update budget=?] 2012-03-20 15:11:16.385 (4) [P1T1]: Balance Factor set for Search Engine Account ID 15901 is 0.5 2012-03-20 15:11:16.385 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountBalanceFactors (searchEngineAccountID, date, balanceFactor) values (?,?,?) on duplicate key update balanceFactor=?] 2012-03-20 15:11:16.387 (4) [P1T1]: Balance Factor set for Search Engine Account ID 15911 is 0.5 2012-03-20 15:11:16.389 (4) [P1T1]: Balance Factor set for Search Engine Account ID 15921 is 0.5 2012-03-20 15:11:16.390 (4) [P1T1]: Balance Factor set for Search Engine Account ID 15931 is 0.5 2012-03-20 15:11:16.392 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountActualDailyBudgets (searchEngineAccountID, date, budget) values (?,?,?) on duplicate key update budget=?] 2012-03-20 15:11:16.403 (4) [P1T1]: preparing SQL statement [select id,accountID,distributionID,searchEngineUserID,searchEngineIdentifier,budgetAmount,searchEngineStatus from `tsacommon`.searchEngineAccounts where id=?] 2012-03-20 15:11:16.413 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Long 2012-03-20 15:11:16.413 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.413 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=5671) limit 1] 2012-03-20 15:11:16.423 (5) [P1T1]: recordAsSubs("db", 10, "P1T1") 2012-03-20 15:11:16.423 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.423 (5) [P1T1]: ProfilerRec.end("db", true): ret=10 2012-03-20 15:11:16.423 (4) [P1T1]: time=0.01 2012-03-20 15:11:16.424 (4) [P1T1]: Query executed in 0.010s 2012-03-20 15:11:16.424 (5) [P1T1]: loading 14 columns from result set: 2012-03-20 15:11:16.424 (5) [P1T1]: loaded column: searchEngineUsers.id->5671 2012-03-20 15:11:16.424 (5) [P1T1]: loaded column: searchEngineUsers.accountID->5221 2012-03-20 15:11:16.424 (5) [P1T1]: loaded column: searchEngineUsers.distributionID->3 2012-03-20 15:11:16.424 (5) [P1T1]: loaded column: searchEngineUsers.searchEngineIdentifier->4038 2012-03-20 15:11:16.425 (5) [P1T1]: loaded column: searchEngineUsers.description->alok-n63a_1 2012-03-20 15:11:16.425 (5) [P1T1]: loaded column: searchEngineUsers.username->mmstestclientaccount+5671@gmail.com 2012-03-20 15:11:16.425 (5) [P1T1]: loaded column: searchEngineUsers.password->8kwtROEEI8YMM4QU 2012-03-20 15:11:16.425 (5) [P1T1]: loaded column: searchEngineUsers.enabled->true 2012-03-20 15:11:16.425 (5) [P1T1]: loaded column: searchEngineUsers.inTsaMcc->true 2012-03-20 15:11:16.425 (5) [P1T1]: loaded column: searchEngineUsers.apiKey-> 2012-03-20 15:11:16.426 (5) [P1T1]: loaded column: searchEngineUsers.managerUsernames->null 2012-03-20 15:11:16.426 (5) [P1T1]: loaded column: searchEngineUsers.managerIDs->null 2012-03-20 15:11:16.426 (5) [P1T1]: loaded column: searchEngineUsers.lastChecked->null 2012-03-20 15:11:16.426 (5) [P1T1]: loaded column: searchEngineUsers.lastInMcc->null 2012-03-20 15:11:16.426 (4) [P1T1]: Record Loaded 2012-03-20 15:11:16.510 (4) [P1T1]: client customer id = 4038 2012-03-20 15:11:16.514 (5) [P1T1]: parseInteger->[5671] 2012-03-20 15:11:16.514 (5) [P1T1]: parseInteger<-[5671] 2012-03-20 15:11:16.820 (4) [P1T1]: seuserid[5671] username[null] password[null] customerID[4038] log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /tmp/google_logs/soap_xml.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.(FileOutputStream.java:177) at java.io.FileOutputStream.(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:272) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:151) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:247) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:123) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:87) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:645) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:603) at org.apache.log4j.PropertyConfigurator.parseCatsAndRenderers(PropertyConfigurator.java:524) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:408) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:307) at org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:315) at com.google.api.adwords.lib.AdWordsServiceLogger.loadLog4JConfiguration(AdWordsServiceLogger.java:130) at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.(GoogleAdWordsAPI.java:632) at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.(GoogleAdWordsAPI.java:565) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.createAPI(GoogleAPISearchEngine.java:233) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.getGoogleAPI(AdMaxSABBAlgorithm.java:622) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.updateSearchEngineAccounts(AdMaxSABBAlgorithm.java:532) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.applyAlgorithm(AdMaxSABBAlgorithm.java:243) at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.run(AdMaxSummarizer.java:586) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /tmp/google_logs/aw_api_lib.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.(FileOutputStream.java:177) at java.io.FileOutputStream.(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:272) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:151) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:247) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:123) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:87) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:645) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:603) at org.apache.log4j.PropertyConfigurator.parseCatsAndRenderers(PropertyConfigurator.java:524) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:408) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:307) at org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:315) at com.google.api.adwords.lib.AdWordsServiceLogger.loadLog4JConfiguration(AdWordsServiceLogger.java:130) at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.(GoogleAdWordsAPI.java:632) at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.(GoogleAdWordsAPI.java:565) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.createAPI(GoogleAPISearchEngine.java:233) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.getGoogleAPI(AdMaxSABBAlgorithm.java:622) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.updateSearchEngineAccounts(AdMaxSABBAlgorithm.java:532) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.applyAlgorithm(AdMaxSABBAlgorithm.java:243) at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.run(AdMaxSummarizer.java:586) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /tmp/google_logs/request_info.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.(FileOutputStream.java:177) at java.io.FileOutputStream.(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:272) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:151) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:247) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:123) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:87) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:645) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:603) at org.apache.log4j.PropertyConfigurator.parseCatsAndRenderers(PropertyConfigurator.java:524) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:408) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:307) at org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:315) at com.google.api.adwords.lib.AdWordsServiceLogger.loadLog4JConfiguration(AdWordsServiceLogger.java:130) at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.(GoogleAdWordsAPI.java:632) at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.(GoogleAdWordsAPI.java:565) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.createAPI(GoogleAPISearchEngine.java:233) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.getGoogleAPI(AdMaxSABBAlgorithm.java:622) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.updateSearchEngineAccounts(AdMaxSABBAlgorithm.java:532) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.applyAlgorithm(AdMaxSABBAlgorithm.java:243) at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.run(AdMaxSummarizer.java:586) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2012-03-20 15:11:16.864 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:16.875 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:16.895 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:16.896 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.896 (4) [P1T1]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineClass`!=""))] 2012-03-20 15:11:16.898 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:16.898 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.898 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:16.898 (4) [P1T1]: time=0.0020 2012-03-20 15:11:16.899 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:16.900 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:16.903 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:16.972 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:16.973 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.974 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-sesystem")) limit 1] 2012-03-20 15:11:17.017 (5) [P1T1]: recordAsSubs("db", 44, "P1T1") 2012-03-20 15:11:17.017 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.018 (5) [P1T1]: ProfilerRec.end("db", true): ret=44 2012-03-20 15:11:17.018 (4) [P1T1]: time=0.044 2012-03-20 15:11:17.018 (4) [P1T1]: Query executed in 0.044s 2012-03-20 15:11:17.018 (5) [P1T1]: loading 8 columns from result set: 2012-03-20 15:11:17.018 (5) [P1T1]: loaded column: databaseInstances.id->2 2012-03-20 15:11:17.018 (5) [P1T1]: loaded column: databaseInstances.name->global-sesystem 2012-03-20 15:11:17.019 (5) [P1T1]: loaded column: databaseInstances.description->Global Search Engine API system tables 2012-03-20 15:11:17.019 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-03-20 15:11:17.019 (5) [P1T1]: loaded column: databaseInstances.database->sesystem 2012-03-20 15:11:17.019 (5) [P1T1]: loaded column: databaseInstances.host->sesystem-01-write 2012-03-20 15:11:17.019 (5) [P1T1]: loaded column: databaseInstances.port->3306 2012-03-20 15:11:17.019 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-03-20 15:11:17.019 (4) [P1T1]: Record Loaded 2012-03-20 15:11:17.020 (4) [P1T1]: DataCache: put key global-sesystem 2012-03-20 15:11:17.020 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:17.055 (4) [P1T1]: opened [jdbc:mysql://sesystem-01-write:3306/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:17.055 (3) [P1T1]: Created shared sesystem connection rw 2012-03-20 15:11:17.055 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:17.056 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:17.091 (5) [P1T1]: recordAsSubs("db", 35, "P1T1") 2012-03-20 15:11:17.093 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.093 (5) [P1T1]: ProfilerRec.end("db", true): ret=35 2012-03-20 15:11:17.094 (4) [P1T1]: time=0.035 2012-03-20 15:11:17.094 (4) [P1T1]: Query executed in 0.035s 2012-03-20 15:11:17.152 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:17.153 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-03-20 15:11:16",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2012-03-20 15:06:16")) limit 1], genflags=no 2012-03-20 15:11:17.174 (5) [P1T1]: recordAsSubs("db", 21, "P1T1") 2012-03-20 15:11:17.174 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.175 (5) [P1T1]: ProfilerRec.end("db", true): ret=21 2012-03-20 15:11:17.175 (4) [P1T1]: time=0.021 2012-03-20 15:11:17.175 (4) [P1T1]: Query executed in 0.021s, 0 row(s) affected 2012-03-20 15:11:17.175 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:17.175 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:17.206 (5) [P1T1]: recordAsSubs("db", 31, "P1T1") 2012-03-20 15:11:17.207 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.207 (5) [P1T1]: ProfilerRec.end("db", true): ret=31 2012-03-20 15:11:17.265 (4) [P1T1]: time=0.031 2012-03-20 15:11:17.265 (4) [P1T1]: Query executed in 0.031s 2012-03-20 15:11:17.267 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-03-20 15:11:17.268 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:17.268 (4) [P1T1]: sesystem: SQL->[select `authToken`,`date` from `sesystem`.`googleAuthToken` where ((`seUserID`=0))] 2012-03-20 15:11:17.270 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:17.271 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.271 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:17.271 (4) [P1T1]: time=0.0020 2012-03-20 15:11:17.271 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:17.272 (4) [P1T1]: Master AuthToken retrieved from database [DQAAAKQAAAB3m_2q9h2llWd2M4WPGtwQEHCrvoKAOswCuF8bCl3kH3t-Dq4X2Ojnq4ed0K3QKKBPJHxLswY2Yl59QK_GkSykkEoKcGUwW6MzIsLYBCWLCsg1L_z09nbbLR66eQbatuXAl7ghW52sYQQvrwEpSTskn8psHl1NARC7qx2JmHFCLz-Dj2T5JvAHtHjKSVyLptZhor8HtYkzZHn6FsCVfnTQ18EUkiiETg85WSYoRcIPxw] for username[yellsmsdomain@yellgroup.com] 2012-03-20 15:11:17.278 (4) [P1T1]: Setting AuthToken [DQAAAKQAAAB3m_2q9h2llWd2M4WPGtwQEHCrvoKAOswCuF8bCl3kH3t-Dq4X2Ojnq4ed0K3QKKBPJHxLswY2Yl59QK_GkSykkEoKcGUwW6MzIsLYBCWLCsg1L_z09nbbLR66eQbatuXAl7ghW52sYQQvrwEpSTskn8psHl1NARC7qx2JmHFCLz-Dj2T5JvAHtHjKSVyLptZhor8HtYkzZHn6FsCVfnTQ18EUkiiETg85WSYoRcIPxw] to AdWordsUser object for username[yellsmsdomain@yellgroup.com] 2012-03-20 15:11:17.342 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Long 2012-03-20 15:11:17.343 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:17.343 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=5671) limit 1] 2012-03-20 15:11:17.365 (5) [P1T1]: recordAsSubs("db", 22, "P1T1") 2012-03-20 15:11:17.366 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.366 (5) [P1T1]: ProfilerRec.end("db", true): ret=22 2012-03-20 15:11:17.366 (4) [P1T1]: time=0.022 2012-03-20 15:11:17.366 (4) [P1T1]: Query executed in 0.022s 2012-03-20 15:11:17.366 (5) [P1T1]: loading 14 columns from result set: 2012-03-20 15:11:17.367 (5) [P1T1]: loaded column: searchEngineUsers.id->5671 2012-03-20 15:11:17.367 (5) [P1T1]: loaded column: searchEngineUsers.accountID->5221 2012-03-20 15:11:17.367 (5) [P1T1]: loaded column: searchEngineUsers.distributionID->3 2012-03-20 15:11:17.367 (5) [P1T1]: loaded column: searchEngineUsers.searchEngineIdentifier->4038 2012-03-20 15:11:17.367 (5) [P1T1]: loaded column: searchEngineUsers.description->alok-n63a_1 2012-03-20 15:11:17.367 (5) [P1T1]: loaded column: searchEngineUsers.username->mmstestclientaccount+5671@gmail.com 2012-03-20 15:11:17.368 (5) [P1T1]: loaded column: searchEngineUsers.password->8kwtROEEI8YMM4QU 2012-03-20 15:11:17.368 (5) [P1T1]: loaded column: searchEngineUsers.enabled->true 2012-03-20 15:11:17.368 (5) [P1T1]: loaded column: searchEngineUsers.inTsaMcc->true 2012-03-20 15:11:17.368 (5) [P1T1]: loaded column: searchEngineUsers.apiKey-> 2012-03-20 15:11:17.368 (5) [P1T1]: loaded column: searchEngineUsers.managerUsernames->null 2012-03-20 15:11:17.368 (5) [P1T1]: loaded column: searchEngineUsers.managerIDs->null 2012-03-20 15:11:17.369 (5) [P1T1]: loaded column: searchEngineUsers.lastChecked->null 2012-03-20 15:11:17.369 (5) [P1T1]: loaded column: searchEngineUsers.lastInMcc->null 2012-03-20 15:11:17.369 (4) [P1T1]: Record Loaded 2012-03-20 15:11:17.371 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Long 2012-03-20 15:11:17.372 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:17.372 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=5671) limit 1] 2012-03-20 15:11:17.388 (5) [P1T1]: recordAsSubs("db", 16, "P1T1") 2012-03-20 15:11:17.388 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.388 (5) [P1T1]: ProfilerRec.end("db", true): ret=16 2012-03-20 15:11:17.388 (4) [P1T1]: time=0.016 2012-03-20 15:11:17.388 (4) [P1T1]: Query executed in 0.016s 2012-03-20 15:11:17.388 (5) [P1T1]: loading 14 columns from result set: 2012-03-20 15:11:17.389 (5) [P1T1]: loaded column: searchEngineUsers.id->5671 2012-03-20 15:11:17.389 (5) [P1T1]: loaded column: searchEngineUsers.accountID->5221 2012-03-20 15:11:17.389 (5) [P1T1]: loaded column: searchEngineUsers.distributionID->3 2012-03-20 15:11:17.389 (5) [P1T1]: loaded column: searchEngineUsers.searchEngineIdentifier->4038 2012-03-20 15:11:17.389 (5) [P1T1]: loaded column: searchEngineUsers.description->alok-n63a_1 2012-03-20 15:11:17.389 (5) [P1T1]: loaded column: searchEngineUsers.username->mmstestclientaccount+5671@gmail.com 2012-03-20 15:11:17.390 (5) [P1T1]: loaded column: searchEngineUsers.password->8kwtROEEI8YMM4QU 2012-03-20 15:11:17.390 (5) [P1T1]: loaded column: searchEngineUsers.enabled->true 2012-03-20 15:11:17.390 (5) [P1T1]: loaded column: searchEngineUsers.inTsaMcc->true 2012-03-20 15:11:17.390 (5) [P1T1]: loaded column: searchEngineUsers.apiKey-> 2012-03-20 15:11:17.390 (5) [P1T1]: loaded column: searchEngineUsers.managerUsernames->null 2012-03-20 15:11:17.390 (5) [P1T1]: loaded column: searchEngineUsers.managerIDs->null 2012-03-20 15:11:17.391 (5) [P1T1]: loaded column: searchEngineUsers.lastChecked->null 2012-03-20 15:11:17.391 (5) [P1T1]: loaded column: searchEngineUsers.lastInMcc->null 2012-03-20 15:11:17.391 (4) [P1T1]: Record Loaded 2012-03-20 15:11:17.393 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Long 2012-03-20 15:11:17.393 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:17.393 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=5671) limit 1] 2012-03-20 15:11:17.396 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:17.396 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.396 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:17.396 (4) [P1T1]: time=0.0030 2012-03-20 15:11:17.396 (4) [P1T1]: Query executed in 0.003s 2012-03-20 15:11:17.396 (5) [P1T1]: loading 14 columns from result set: 2012-03-20 15:11:17.397 (5) [P1T1]: loaded column: searchEngineUsers.id->5671 2012-03-20 15:11:17.397 (5) [P1T1]: loaded column: searchEngineUsers.accountID->5221 2012-03-20 15:11:17.397 (5) [P1T1]: loaded column: searchEngineUsers.distributionID->3 2012-03-20 15:11:17.397 (5) [P1T1]: loaded column: searchEngineUsers.searchEngineIdentifier->4038 2012-03-20 15:11:17.397 (5) [P1T1]: loaded column: searchEngineUsers.description->alok-n63a_1 2012-03-20 15:11:17.397 (5) [P1T1]: loaded column: searchEngineUsers.username->mmstestclientaccount+5671@gmail.com 2012-03-20 15:11:17.398 (5) [P1T1]: loaded column: searchEngineUsers.password->8kwtROEEI8YMM4QU 2012-03-20 15:11:17.398 (5) [P1T1]: loaded column: searchEngineUsers.enabled->true 2012-03-20 15:11:17.398 (5) [P1T1]: loaded column: searchEngineUsers.inTsaMcc->true 2012-03-20 15:11:17.400 (5) [P1T1]: loaded column: searchEngineUsers.apiKey-> 2012-03-20 15:11:17.400 (5) [P1T1]: loaded column: searchEngineUsers.managerUsernames->null 2012-03-20 15:11:17.401 (5) [P1T1]: loaded column: searchEngineUsers.managerIDs->null 2012-03-20 15:11:17.401 (5) [P1T1]: loaded column: searchEngineUsers.lastChecked->null 2012-03-20 15:11:17.401 (5) [P1T1]: loaded column: searchEngineUsers.lastInMcc->null 2012-03-20 15:11:17.401 (4) [P1T1]: Record Loaded 2012-03-20 15:11:17.405 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:17.406 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:17.406 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:17.407 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:17.408 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:17.426 (5) [P1T1]: recordAsSubs("db", 18, "P1T1") 2012-03-20 15:11:17.427 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.427 (5) [P1T1]: ProfilerRec.end("db", true): ret=18 2012-03-20 15:11:17.427 (4) [P1T1]: time=0.018 2012-03-20 15:11:17.427 (4) [P1T1]: Query executed in 0.018s 2012-03-20 15:11:17.427 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:17.427 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=5671,`inUse`="true",`holder`="UpdateCampaignList",`holderIdentifier`="4038",`timeStamp`="2012-03-20 15:11:17" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="false") and (`sesystem`.`searchEngineConnections`.`owner` is null) and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=5671)) limit 1], genflags=no 2012-03-20 15:11:17.439 (5) [P1T1]: recordAsSubs("db", 12, "P1T1") 2012-03-20 15:11:17.439 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.439 (5) [P1T1]: ProfilerRec.end("db", true): ret=12 2012-03-20 15:11:17.439 (4) [P1T1]: time=0.012 2012-03-20 15:11:17.439 (4) [P1T1]: Query executed in 0.012s, 1 row(s) affected 2012-03-20 15:11:17.440 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1] 2012-03-20 15:11:22.611 (2) [P1T1]: 1 Errors found 2012-03-20 15:11:22.655 (2) [P1T1]: com.google.api.adwords.v201109.cm.AuthenticationError: ApiError: fiedpath=, trigger=4038 apierrortype=AuthenticationError, reason=CUSTOMER_NOT_FOUND 2012-03-20 15:11:22.656 (3) [P1T1]: Caught other/unrecoverable API Error: "com.google.api.adwords.v201109.cm.ApiException" 2012-03-20 15:11:22.657 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:22.659 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:22.718 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:22.718 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:22.744 (5) [P1T1]: recordAsSubs("db", 26, "P1T1") 2012-03-20 15:11:22.744 (5) [P1T1]: addSub("db") 2012-03-20 15:11:22.744 (5) [P1T1]: ProfilerRec.end("db", true): ret=26 2012-03-20 15:11:22.744 (4) [P1T1]: time=0.026 2012-03-20 15:11:22.744 (4) [P1T1]: Query executed in 0.026s 2012-03-20 15:11:22.744 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:22.744 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-03-20 15:11:22",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`holder`="UpdateCampaignList") and (`sesystem`.`searchEngineConnections`.`holderIdentifier`="4038") and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=5671)) limit 1], genflags=no 2012-03-20 15:11:22.751 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-03-20 15:11:22.752 (5) [P1T1]: addSub("db") 2012-03-20 15:11:22.753 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-03-20 15:11:22.753 (4) [P1T1]: time=0.0070 2012-03-20 15:11:22.754 (4) [P1T1]: Query executed in 0.007s, 1 row(s) affected 2012-03-20 15:11:22.755 (4) [P1T1]: 4038 released searchEngineConnection row 2012-03-20 15:11:22.757 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:22.757 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:22.768 (5) [P1T1]: recordAsSubs("db", 11, "P1T1") 2012-03-20 15:11:22.768 (5) [P1T1]: addSub("db") 2012-03-20 15:11:22.769 (5) [P1T1]: ProfilerRec.end("db", true): ret=11 2012-03-20 15:11:22.770 (4) [P1T1]: time=0.011 2012-03-20 15:11:22.770 (4) [P1T1]: Query executed in 0.011s 2012-03-20 15:11:22.777 (5) [P1T1]: quoteValue(), nothing special about it=>[147], type=class java.lang.Integer 2012-03-20 15:11:22.777 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:22.778 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=147) and (`operation`="UpdateCampaignList")) limit 1] 2012-03-20 15:11:22.788 (5) [P1T1]: recordAsSubs("db", 10, "P1T1") 2012-03-20 15:11:22.788 (5) [P1T1]: addSub("db") 2012-03-20 15:11:22.788 (5) [P1T1]: ProfilerRec.end("db", true): ret=10 2012-03-20 15:11:22.788 (4) [P1T1]: time=0.01 2012-03-20 15:11:22.788 (4) [P1T1]: Query executed in 0.010s 2012-03-20 15:11:22.788 (4) [P1T1]: Record Not Found 2012-03-20 15:11:22.789 (2) [P1T1]: Resource Not Found: "UpdateCampaignList" 2012-03-20 15:11:22.789 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:22.789 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:22.790 (4) [P1T1]: Operations for UpdateCampaignList: 0 2012-03-20 15:11:22.790 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:22.790 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:22.790 (4) [P1T1]: Quota units for UpdateCampaignList: 0 2012-03-20 15:11:22.790 (3) [P1T1]: Error while updating the collection of campaign budgets! 2012-03-20 15:11:22.791 (2) [P1T1]: Error occurred updating Google budget for seID 18339. 2012-03-20 15:11:22.791 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:22.792 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:22.792 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:22.793 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:22.793 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:22.804 (5) [P1T1]: recordAsSubs("db", 11, "P1T1") 2012-03-20 15:11:22.804 (5) [P1T1]: addSub("db") 2012-03-20 15:11:22.804 (5) [P1T1]: ProfilerRec.end("db", true): ret=11 2012-03-20 15:11:22.804 (4) [P1T1]: time=0.011 2012-03-20 15:11:22.804 (4) [P1T1]: Query executed in 0.011s 2012-03-20 15:11:22.805 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:22.805 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=5671,`inUse`="true",`holder`="UpdateCampaignList",`holderIdentifier`="4038",`timeStamp`="2012-03-20 15:11:22" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="false") and (`sesystem`.`searchEngineConnections`.`owner` is null) and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=5671)) limit 1], genflags=no 2012-03-20 15:11:22.809 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:22.809 (5) [P1T1]: addSub("db") 2012-03-20 15:11:22.809 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:22.809 (4) [P1T1]: time=0.0040 2012-03-20 15:11:22.809 (4) [P1T1]: Query executed in 0.004s, 1 row(s) affected 2012-03-20 15:11:22.809 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1] 2012-03-20 15:11:24.444 (2) [P1T1]: 1 Errors found 2012-03-20 15:11:24.445 (2) [P1T1]: com.google.api.adwords.v201109.cm.AuthenticationError: ApiError: fiedpath=, trigger=4038 apierrortype=AuthenticationError, reason=CUSTOMER_NOT_FOUND 2012-03-20 15:11:24.445 (3) [P1T1]: Caught other/unrecoverable API Error: "com.google.api.adwords.v201109.cm.ApiException" 2012-03-20 15:11:24.445 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:24.446 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:24.447 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:24.447 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:24.529 (5) [P1T1]: recordAsSubs("db", 82, "P1T1") 2012-03-20 15:11:24.530 (5) [P1T1]: addSub("db") 2012-03-20 15:11:24.530 (5) [P1T1]: ProfilerRec.end("db", true): ret=82 2012-03-20 15:11:24.530 (4) [P1T1]: time=0.082 2012-03-20 15:11:24.530 (4) [P1T1]: Query executed in 0.082s 2012-03-20 15:11:24.530 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:24.530 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-03-20 15:11:24",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`holder`="UpdateCampaignList") and (`sesystem`.`searchEngineConnections`.`holderIdentifier`="4038") and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=5671)) limit 1], genflags=no 2012-03-20 15:11:24.534 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:24.534 (5) [P1T1]: addSub("db") 2012-03-20 15:11:24.535 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:24.535 (4) [P1T1]: time=0.0040 2012-03-20 15:11:24.535 (4) [P1T1]: Query executed in 0.004s, 1 row(s) affected 2012-03-20 15:11:24.535 (4) [P1T1]: 4038 released searchEngineConnection row 2012-03-20 15:11:24.535 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:24.535 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:24.537 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:24.537 (5) [P1T1]: addSub("db") 2012-03-20 15:11:24.537 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:24.537 (4) [P1T1]: time=0.0020 2012-03-20 15:11:24.537 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:24.538 (5) [P1T1]: quoteValue(), nothing special about it=>[147], type=class java.lang.Integer 2012-03-20 15:11:24.538 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:24.538 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=147) and (`operation`="UpdateCampaignList")) limit 1] 2012-03-20 15:11:24.555 (5) [P1T1]: recordAsSubs("db", 17, "P1T1") 2012-03-20 15:11:24.556 (5) [P1T1]: addSub("db") 2012-03-20 15:11:24.556 (5) [P1T1]: ProfilerRec.end("db", true): ret=17 2012-03-20 15:11:24.556 (4) [P1T1]: time=0.017 2012-03-20 15:11:24.556 (4) [P1T1]: Query executed in 0.017s 2012-03-20 15:11:24.556 (4) [P1T1]: Record Not Found 2012-03-20 15:11:24.556 (2) [P1T1]: Resource Not Found: "UpdateCampaignList" 2012-03-20 15:11:24.556 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:24.556 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:24.556 (4) [P1T1]: Operations for UpdateCampaignList: 0 2012-03-20 15:11:24.556 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:24.556 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:24.557 (4) [P1T1]: Quota units for UpdateCampaignList: 0 2012-03-20 15:11:24.557 (3) [P1T1]: Error while updating the collection of campaign budgets! 2012-03-20 15:11:24.557 (2) [P1T1]: Error occurred updating Google budget for seID 18338. 2012-03-20 15:11:24.557 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:24.558 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:24.558 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:24.559 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:24.559 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:24.582 (5) [P1T1]: recordAsSubs("db", 23, "P1T1") 2012-03-20 15:11:24.582 (5) [P1T1]: addSub("db") 2012-03-20 15:11:24.583 (5) [P1T1]: ProfilerRec.end("db", true): ret=23 2012-03-20 15:11:24.583 (4) [P1T1]: time=0.023 2012-03-20 15:11:24.583 (4) [P1T1]: Query executed in 0.023s 2012-03-20 15:11:24.583 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:24.583 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=5671,`inUse`="true",`holder`="UpdateCampaignList",`holderIdentifier`="4038",`timeStamp`="2012-03-20 15:11:24" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="false") and (`sesystem`.`searchEngineConnections`.`owner` is null) and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=5671)) limit 1], genflags=no 2012-03-20 15:11:24.586 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:24.586 (5) [P1T1]: addSub("db") 2012-03-20 15:11:24.587 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:24.587 (4) [P1T1]: time=0.0030 2012-03-20 15:11:24.587 (4) [P1T1]: Query executed in 0.003s, 1 row(s) affected 2012-03-20 15:11:24.587 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1] 2012-03-20 15:11:26.172 (2) [P1T1]: 1 Errors found 2012-03-20 15:11:26.173 (2) [P1T1]: com.google.api.adwords.v201109.cm.AuthenticationError: ApiError: fiedpath=, trigger=4038 apierrortype=AuthenticationError, reason=CUSTOMER_NOT_FOUND 2012-03-20 15:11:26.173 (3) [P1T1]: Caught other/unrecoverable API Error: "com.google.api.adwords.v201109.cm.ApiException" 2012-03-20 15:11:26.174 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:26.175 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:26.176 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.176 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:26.179 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:26.180 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.180 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:26.180 (4) [P1T1]: time=0.0030 2012-03-20 15:11:26.180 (4) [P1T1]: Query executed in 0.003s 2012-03-20 15:11:26.181 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.181 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-03-20 15:11:26",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`holder`="UpdateCampaignList") and (`sesystem`.`searchEngineConnections`.`holderIdentifier`="4038") and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=5671)) limit 1], genflags=no 2012-03-20 15:11:26.185 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:26.185 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.186 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:26.186 (4) [P1T1]: time=0.0040 2012-03-20 15:11:26.187 (4) [P1T1]: Query executed in 0.004s, 1 row(s) affected 2012-03-20 15:11:26.187 (4) [P1T1]: 4038 released searchEngineConnection row 2012-03-20 15:11:26.187 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.188 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:26.190 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:26.190 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.190 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:26.190 (4) [P1T1]: time=0.0010 2012-03-20 15:11:26.191 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:26.191 (5) [P1T1]: quoteValue(), nothing special about it=>[147], type=class java.lang.Integer 2012-03-20 15:11:26.192 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.192 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=147) and (`operation`="UpdateCampaignList")) limit 1] 2012-03-20 15:11:26.193 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:26.194 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.194 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:26.194 (4) [P1T1]: time=0.0010 2012-03-20 15:11:26.194 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:26.209 (4) [P1T1]: Record Not Found 2012-03-20 15:11:26.209 (2) [P1T1]: Resource Not Found: "UpdateCampaignList" 2012-03-20 15:11:26.209 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:26.210 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:26.210 (4) [P1T1]: Operations for UpdateCampaignList: 0 2012-03-20 15:11:26.210 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:26.210 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:26.211 (4) [P1T1]: Quota units for UpdateCampaignList: 0 2012-03-20 15:11:26.211 (3) [P1T1]: Error while updating the collection of campaign budgets! 2012-03-20 15:11:26.211 (2) [P1T1]: Error occurred updating Google budget for seID 18340. 2012-03-20 15:11:26.212 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:26.212 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:26.213 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:26.214 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.214 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:26.215 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:26.216 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.216 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:26.216 (4) [P1T1]: time=0.0010 2012-03-20 15:11:26.217 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:26.217 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.217 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=5671,`inUse`="true",`holder`="UpdateCampaignList",`holderIdentifier`="4038",`timeStamp`="2012-03-20 15:11:26" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="false") and (`sesystem`.`searchEngineConnections`.`owner` is null) and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=5671)) limit 1], genflags=no 2012-03-20 15:11:26.220 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:26.220 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.220 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:26.221 (4) [P1T1]: time=0.0030 2012-03-20 15:11:26.221 (4) [P1T1]: Query executed in 0.003s, 1 row(s) affected 2012-03-20 15:11:26.221 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1] 2012-03-20 15:11:27.921 (2) [P1T1]: 1 Errors found 2012-03-20 15:11:27.942 (2) [P1T1]: com.google.api.adwords.v201109.cm.AuthenticationError: ApiError: fiedpath=, trigger=4038 apierrortype=AuthenticationError, reason=CUSTOMER_NOT_FOUND 2012-03-20 15:11:27.942 (3) [P1T1]: Caught other/unrecoverable API Error: "com.google.api.adwords.v201109.cm.ApiException" 2012-03-20 15:11:27.942 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:27.943 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:27.944 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:27.944 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:28.003 (5) [P1T1]: recordAsSubs("db", 59, "P1T1") 2012-03-20 15:11:28.003 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.003 (5) [P1T1]: ProfilerRec.end("db", true): ret=59 2012-03-20 15:11:28.003 (4) [P1T1]: time=0.059 2012-03-20 15:11:28.003 (4) [P1T1]: Query executed in 0.059s 2012-03-20 15:11:28.004 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.004 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-03-20 15:11:27",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`holder`="UpdateCampaignList") and (`sesystem`.`searchEngineConnections`.`holderIdentifier`="4038") and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=5671)) limit 1], genflags=no 2012-03-20 15:11:28.008 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:28.008 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.008 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:28.008 (4) [P1T1]: time=0.0040 2012-03-20 15:11:28.009 (4) [P1T1]: Query executed in 0.004s, 1 row(s) affected 2012-03-20 15:11:28.009 (4) [P1T1]: 4038 released searchEngineConnection row 2012-03-20 15:11:28.009 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.009 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:28.024 (5) [P1T1]: recordAsSubs("db", 15, "P1T1") 2012-03-20 15:11:28.024 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.024 (5) [P1T1]: ProfilerRec.end("db", true): ret=15 2012-03-20 15:11:28.024 (4) [P1T1]: time=0.015 2012-03-20 15:11:28.025 (4) [P1T1]: Query executed in 0.015s 2012-03-20 15:11:28.025 (5) [P1T1]: quoteValue(), nothing special about it=>[147], type=class java.lang.Integer 2012-03-20 15:11:28.036 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.036 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=147) and (`operation`="UpdateCampaignList")) limit 1] 2012-03-20 15:11:28.089 (5) [P1T1]: recordAsSubs("db", 53, "P1T1") 2012-03-20 15:11:28.089 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.090 (5) [P1T1]: ProfilerRec.end("db", true): ret=53 2012-03-20 15:11:28.090 (4) [P1T1]: time=0.053 2012-03-20 15:11:28.090 (4) [P1T1]: Query executed in 0.053s 2012-03-20 15:11:28.090 (4) [P1T1]: Record Not Found 2012-03-20 15:11:28.090 (2) [P1T1]: Resource Not Found: "UpdateCampaignList" 2012-03-20 15:11:28.090 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:28.090 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:28.090 (4) [P1T1]: Operations for UpdateCampaignList: 0 2012-03-20 15:11:28.090 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:28.091 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:28.091 (4) [P1T1]: Quota units for UpdateCampaignList: 0 2012-03-20 15:11:28.091 (3) [P1T1]: Error while updating the collection of campaign budgets! 2012-03-20 15:11:28.091 (2) [P1T1]: Error occurred updating Google budget for seID 18341. 2012-03-20 15:11:28.091 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:28.092 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:28.093 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:28.094 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.094 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:28.104 (5) [P1T1]: recordAsSubs("db", 10, "P1T1") 2012-03-20 15:11:28.104 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.105 (5) [P1T1]: ProfilerRec.end("db", true): ret=10 2012-03-20 15:11:28.105 (4) [P1T1]: time=0.01 2012-03-20 15:11:28.106 (4) [P1T1]: Query executed in 0.010s 2012-03-20 15:11:28.106 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.107 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=5671,`inUse`="true",`holder`="UpdateCampaignList",`holderIdentifier`="4038",`timeStamp`="2012-03-20 15:11:28" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="false") and (`sesystem`.`searchEngineConnections`.`owner` is null) and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=5671)) limit 1], genflags=no 2012-03-20 15:11:28.123 (5) [P1T1]: recordAsSubs("db", 16, "P1T1") 2012-03-20 15:11:28.124 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.124 (5) [P1T1]: ProfilerRec.end("db", true): ret=16 2012-03-20 15:11:28.125 (4) [P1T1]: time=0.016 2012-03-20 15:11:28.125 (4) [P1T1]: Query executed in 0.016s, 1 row(s) affected 2012-03-20 15:11:28.126 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1] 2012-03-20 15:11:28.127 (5) [P1T1]: recordAsSubs("google", 0, "P1T1") 2012-03-20 15:11:28.127 (5) [P1T1]: addSub("google") 2012-03-20 15:11:28.128 (5) [P1T1]: ProfilerRec.end("google", true): ret=0 2012-03-20 15:11:28.129 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:28.131 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:28.131 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.131 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:28.147 (5) [P1T1]: recordAsSubs("db", 15, "P1T1") 2012-03-20 15:11:28.147 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.147 (5) [P1T1]: ProfilerRec.end("db", true): ret=15 2012-03-20 15:11:28.147 (4) [P1T1]: time=0.015 2012-03-20 15:11:28.157 (4) [P1T1]: Query executed in 0.015s 2012-03-20 15:11:28.158 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.158 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-03-20 15:11:28",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`holder`="UpdateCampaignList") and (`sesystem`.`searchEngineConnections`.`holderIdentifier`="4038") and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=5671)) limit 1], genflags=no 2012-03-20 15:11:28.180 (5) [P1T1]: recordAsSubs("db", 22, "P1T1") 2012-03-20 15:11:28.180 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.180 (5) [P1T1]: ProfilerRec.end("db", true): ret=22 2012-03-20 15:11:28.180 (4) [P1T1]: time=0.022 2012-03-20 15:11:28.180 (4) [P1T1]: Query executed in 0.022s, 1 row(s) affected 2012-03-20 15:11:28.180 (4) [P1T1]: 4038 released searchEngineConnection row 2012-03-20 15:11:28.180 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.181 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:28.214 (5) [P1T1]: recordAsSubs("db", 33, "P1T1") 2012-03-20 15:11:28.215 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.215 (5) [P1T1]: ProfilerRec.end("db", true): ret=33 2012-03-20 15:11:28.215 (4) [P1T1]: time=0.033 2012-03-20 15:11:28.215 (4) [P1T1]: Query executed in 0.033s 2012-03-20 15:11:28.215 (5) [P1T1]: quoteValue(), nothing special about it=>[147], type=class java.lang.Integer 2012-03-20 15:11:28.216 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.216 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=147) and (`operation`="UpdateCampaignList")) limit 1] 2012-03-20 15:11:28.227 (5) [P1T1]: recordAsSubs("db", 11, "P1T1") 2012-03-20 15:11:28.227 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.228 (5) [P1T1]: ProfilerRec.end("db", true): ret=11 2012-03-20 15:11:28.228 (4) [P1T1]: time=0.011 2012-03-20 15:11:28.228 (4) [P1T1]: Query executed in 0.011s 2012-03-20 15:11:28.228 (4) [P1T1]: Record Not Found 2012-03-20 15:11:28.228 (2) [P1T1]: Resource Not Found: "UpdateCampaignList" 2012-03-20 15:11:28.228 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:28.228 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:28.228 (4) [P1T1]: Operations for UpdateCampaignList: 0 2012-03-20 15:11:28.228 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:28.229 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:28.229 (4) [P1T1]: Quota units for UpdateCampaignList: 0 2012-03-20 15:11:28.230 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.230 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5965") and (`date`="2012-03-21 00:00:00")) limit 1] 2012-03-20 15:11:28.232 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:28.232 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.232 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:28.232 (4) [P1T1]: time=0.0020 2012-03-20 15:11:28.232 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:28.232 (5) [P1T1]: loading 9 columns from result set: 2012-03-20 15:11:28.232 (5) [P1T1]: loaded column: dataAvailability.id->165415 2012-03-20 15:11:28.233 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-21 2012-03-20 15:11:28.233 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-20 15:11:28.234 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-20 15:11:14.0 2012-03-20 15:11:28.234 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5965 2012-03-20 15:11:28.234 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2012-03-20 15:11:28.234 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-20 15:11:28.235 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-20 15:11:28.236 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-20 15:11:28.236 (4) [P1T1]: Record Loaded 2012-03-20 15:11:28.236 (5) [P1T1]: quoteValue(), nothing special about it=>[5965], type=class java.lang.Integer 2012-03-20 15:11:28.237 (5) [P1T1]: quoteValue(), nothing special about it=>[165415], type=class java.lang.Integer 2012-03-20 15:11:28.238 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.238 (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-21","2012-03-20 15:11:28",165415)], genflags=yes 2012-03-20 15:11:28.256 (5) [P1T1]: recordAsSubs("db", 18, "P1T1") 2012-03-20 15:11:28.256 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.257 (5) [P1T1]: ProfilerRec.end("db", true): ret=18 2012-03-20 15:11:28.257 (4) [P1T1]: time=0.018 2012-03-20 15:11:28.257 (4) [P1T1]: Query executed in 0.018s, 2 row(s) affected 2012-03-20 15:11:28.258 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.258 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5965","success","2012-03-21 00:00:00","2012-03-20 15:11:28")], genflags=yes 2012-03-20 15:11:28.260 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:28.260 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.260 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:28.260 (4) [P1T1]: time=0.0020 2012-03-20 15:11:28.260 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-03-20 15:11:28.260 (3) [P1T1]: Finished applying algorithm [SABB] for account [5221] in distributions [3] 2012-03-20 15:11:28.261 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.261 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.5221')] 2012-03-20 15:11:28.264 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:28.264 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.264 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:28.264 (4) [P1T1]: time=0.0030 2012-03-20 15:11:28.264 (4) [P1T1]: Query executed in 0.003s 2012-03-20 15:11:28.265 (3) [P1T1]: Released migrator lock for Account ID #5221 2012-03-20 15:11:28.265 (4) [P1T1]: Returning Object to Pool 2012-03-20 15:11:28.265 (4) [P1T1]: Returning Object to Pool 2012-03-20 15:11:28.265 (4) [P1T1]: Returning Object to Pool 2012-03-20 15:11:28.265 (3) [P1T1]: Completed Account ID #5221: alok-n63a 2012-03-20 15:11:28.338 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:28.338 (3) [main]: ------------AdMax Summarizer done 2012-03-20 15:11:28.338 (3) [main]: =============== Completed AdMax Summarizer ================ 2012-03-20 15:11:28.339 (4) [main]: DataCache: Found key global-logging 2012-03-20 15:11:28.339 (4) [main]: Took Existing Object from Pool 2012-03-20 15:11:28.339 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-20 15:11:28.340 (4) [main]: spike: SQL->[select @@version] 2012-03-20 15:11:28.342 (2) [main]: Warning(s) detected in statement [select @@version] executed by user [spike] 2012-03-20 15:11:28.342 (2) [main]: Table 'logging.processHistory' doesn't exist (1146) 2012-03-20 15:11:28.343 (5) [main]: recordAsSubs("db", 2, "main") 2012-03-20 15:11:28.344 (5) [main]: addSub("db") 2012-03-20 15:11:28.345 (5) [main]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:28.345 (4) [main]: time=0.0020 2012-03-20 15:11:28.345 (4) [main]: Query executed in 0.002s 2012-03-20 15:11:28.351 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-20 15:11:28.351 (3) [main]: Could not save process history stop 2012-03-20 15:11:28.351 (4) [main]: Returning Object to Pool 2012-03-20 15:11:28.352 (3) [main]: =============== Stats ================ 2012-03-20 15:11:28.352 (3) [main]: --- Process --- 2012-03-20 15:11:28.352 (3) [main]: 2012-03-20 15:11:28.352 (3) [main]: ABU Process(start): Tue Mar 20 15:11:12 GMT 2012 2012-03-20 15:11:28.353 (3) [main]: ABU Process(stop): Tue Mar 20 15:11:28 GMT 2012 2012-03-20 15:11:28.353 (3) [main]: 2012-03-20 15:11:28.353 (3) [main]: --- Accounts --- 2012-03-20 15:11:28.354 (3) [main]: 2012-03-20 15:11:28.354 (3) [main]: Accounts Processed: 1 2012-03-20 15:11:28.354 (3) [main]: Accounts Skipped: 0 2012-03-20 15:11:28.354 (3) [main]: Accounts Processed Successfully: 1 2012-03-20 15:11:28.354 (3) [main]: 2012-03-20 15:11:28.355 (3) [main]: --- Adverts --- 2012-03-20 15:11:28.355 (3) [main]: 2012-03-20 15:11:28.355 (3) [main]: Adverts Processed: 2 2012-03-20 15:11:28.355 (3) [main]: Adverts Processed Successfully: 2 2012-03-20 15:11:28.356 (3) [main]: Advert Budgets Capped: 0 2012-03-20 15:11:28.356 (3) [main]: 2012-03-20 15:11:28.356 (3) [main]: --- Campaigns --- 2012-03-20 15:11:28.356 (3) [main]: 2012-03-20 15:11:28.357 (3) [main]: Campaigns Processed: 4 2012-03-20 15:11:28.357 (3) [main]: Campaigns Processed Successfully: 4 2012-03-20 15:11:28.357 (3) [main]: 2012-03-20 15:11:28.357 (3) [main]: --- Budget/Spend --- 2012-03-20 15:11:28.357 (3) [main]: 2012-03-20 15:11:28.358 (3) [main]: Campaign Budgets Updated: 4 2012-03-20 15:11:28.358 (3) [main]: Campaign Budgets Sent To Google: 4 2012-03-20 15:11:28.358 (3) [main]: 2012-03-20 15:11:28.358 (3) [main]: Spend Total: 0.90000004 2012-03-20 15:11:28.358 (3) [main]: Common Carryover Total: 55.035484 2012-03-20 15:11:28.358 (5) [main]: ProfilerRec.end("AdMaxSummarizer", false): ret=15750 2012-03-20 15:11:28.358 (4) [main]: time=15.75 2012-03-20 15:11:28.359 (3) [main]: AdMaxSummarizer: 15.750s 2012-03-20 15:11:28.359 (3) [main]: by key: 2012-03-20 15:11:28.359 (4) [main]: time=0.0 2012-03-20 15:11:28.359 (3) [main]: google: 0.000s 2012-03-20 15:11:28.359 (4) [main]: time=1.068 2012-03-20 15:11:28.359 (3) [main]: db: 1.068s 2012-03-20 15:11:28.359 (3) [main]: by thread: 2012-03-20 15:11:28.359 (4) [main]: time=0.049 2012-03-20 15:11:28.360 (3) [main]: main: 0.049s 2012-03-20 15:11:28.360 (4) [main]: time=1.019 2012-03-20 15:11:28.360 (3) [main]: P1T1: 1.019s 2012-03-20 15:11:28.360 (4) [main]: time=14.682 2012-03-20 15:11:28.360 (3) [main]: other: 14.682s