tsaapp@yell-ec-xml:/usr/local/tsa/bidmgr$ ./admax.sh -d5 -T2012-03-21 -a5221 pid 10955's current affinity list: 0 pid 10955's new affinity list: 0 pid 10955's current affinity list: 0 sched_setaffinity: Invalid argument failed to set pid 10955's affinity. 2012-03-20 15:11:14.566 (3) [main]: Debug Level set to 5 2012-03-20 15:11:14.586 (3) [main]: AdMax Summarizer parameters: [Ljava.lang.String;@4def8cf3 2012-03-20 15:11:14.613 (5) [main]: ProfilerRec.start("AdMaxSummarizer",false) in Thread [main] 2012-03-20 15:11:14.622 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:14.902 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:14.915 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-20 15:11:14.915 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-logging")) limit 1] 2012-03-20 15:11:14.954 (5) [main]: recordAsSubs("db", 39, "main") 2012-03-20 15:11:14.954 (5) [main]: addSub("db") 2012-03-20 15:11:14.955 (5) [main]: ProfilerRec.end("db", true): ret=39 2012-03-20 15:11:14.957 (4) [main]: time=0.039 2012-03-20 15:11:14.957 (4) [main]: Query executed in 0.039s 2012-03-20 15:11:14.959 (5) [main]: loading 8 columns from result set: 2012-03-20 15:11:14.960 (5) [main]: loaded column: databaseInstances.id->4 2012-03-20 15:11:14.960 (5) [main]: loaded column: databaseInstances.name->global-logging 2012-03-20 15:11:15.048 (5) [main]: loaded column: databaseInstances.description->Global Logging Tables 2012-03-20 15:11:15.049 (5) [main]: loaded column: databaseInstances.type->mysql 2012-03-20 15:11:15.049 (5) [main]: loaded column: databaseInstances.database->logging 2012-03-20 15:11:15.050 (5) [main]: loaded column: databaseInstances.host->logging-01-write 2012-03-20 15:11:15.050 (5) [main]: loaded column: databaseInstances.port->3306 2012-03-20 15:11:15.050 (5) [main]: loaded column: databaseInstances.access->rw 2012-03-20 15:11:15.051 (4) [main]: Record Loaded 2012-03-20 15:11:15.051 (4) [main]: DataCache: put key global-logging 2012-03-20 15:11:15.064 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:15.081 (3) [main]: DatabasePool with a limit of 18 created 2012-03-20 15:11:15.084 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2012-03-20 15:11:15.120 (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:15.122 (4) [main]: Created new Object 2012-03-20 15:11:15.125 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-20 15:11:15.126 (4) [main]: spike: SQL->[select @@version] 2012-03-20 15:11:15.129 (5) [main]: recordAsSubs("db", 3, "main") 2012-03-20 15:11:15.129 (5) [main]: addSub("db") 2012-03-20 15:11:15.129 (5) [main]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:15.130 (4) [main]: time=0.0030 2012-03-20 15:11:15.130 (4) [main]: Query executed in 0.003s 2012-03-20 15:11:15.130 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-20 15:11:15.155 (4) [main]: preparing SQL statement [insert into logging.processHistory (processID, startTime) values (?,?)], genflags=yes 2012-03-20 15:11:15.183 (3) [main]: Could not save process history start 2012-03-20 15:11:15.183 (4) [main]: Returning Object to Pool 2012-03-20 15:11:15.184 (3) [main]: =============== Starting AdMax Summarizer ================ 2012-03-20 15:11:15.184 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:15.184 (3) [main]: ----------------AdMax Summarizer starting 2012-03-20 15:11:15.213 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:15.216 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-20 15:11:15.216 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (5221))) order by rand()] 2012-03-20 15:11:15.218 (5) [main]: recordAsSubs("db", 2, "main") 2012-03-20 15:11:15.218 (5) [main]: addSub("db") 2012-03-20 15:11:15.218 (5) [main]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.219 (4) [main]: time=0.0020 2012-03-20 15:11:15.219 (4) [main]: Query executed in 0.002s 2012-03-20 15:11:15.219 (5) [main]: loading 19 columns from result set: 2012-03-20 15:11:15.220 (5) [main]: loaded column: accounts.id->5221 2012-03-20 15:11:15.220 (5) [main]: loaded column: accounts.description->alok-n63a 2012-03-20 15:11:15.221 (5) [main]: loaded column: accounts.tier->1 2012-03-20 15:11:15.221 (5) [main]: loaded column: accounts.priority->50 2012-03-20 15:11:15.221 (5) [main]: loaded column: accounts.reportClicksOut->false 2012-03-20 15:11:15.222 (5) [main]: loaded column: accounts.reportConversions->false 2012-03-20 15:11:15.222 (5) [main]: loaded column: accounts.conversionTypes->paid 2012-03-20 15:11:15.222 (5) [main]: loaded column: accounts.isBidManaged->true 2012-03-20 15:11:15.223 (5) [main]: loaded column: accounts.isActive->true 2012-03-20 15:11:15.223 (5) [main]: loaded column: accounts.perfMetric->cpa 2012-03-20 15:11:15.223 (5) [main]: loaded column: accounts.providesConversionData->true 2012-03-20 15:11:15.224 (5) [main]: loaded column: accounts.addConversionData->false 2012-03-20 15:11:15.224 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2012-03-20 15:11:15.224 (5) [main]: loaded column: accounts.hideNullSources->false 2012-03-20 15:11:15.225 (5) [main]: loaded column: accounts.nowTime->null 2012-03-20 15:11:15.235 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2012-03-20 15:11:15.236 (5) [main]: loaded column: accounts.databaseInstance->1 2012-03-20 15:11:15.236 (5) [main]: loaded column: accounts.warehouseInstance->1 2012-03-20 15:11:15.236 (5) [main]: loaded column: accounts.isOnline->true 2012-03-20 15:11:15.250 (3) [P1T1]: Starting Account ID #5221: alok-n63a 2012-03-20 15:11:15.252 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:15.308 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:15.309 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:15.309 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.310 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=5221) limit 1] 2012-03-20 15:11:15.314 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:15.314 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.315 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:15.315 (4) [P1T1]: time=0.0040 2012-03-20 15:11:15.315 (4) [P1T1]: Query executed in 0.004s 2012-03-20 15:11:15.316 (5) [P1T1]: loading 19 columns from result set: 2012-03-20 15:11:15.316 (5) [P1T1]: loaded column: accounts.id->5221 2012-03-20 15:11:15.316 (5) [P1T1]: loaded column: accounts.description->alok-n63a 2012-03-20 15:11:15.317 (5) [P1T1]: loaded column: accounts.tier->1 2012-03-20 15:11:15.317 (5) [P1T1]: loaded column: accounts.priority->50 2012-03-20 15:11:15.317 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2012-03-20 15:11:15.318 (5) [P1T1]: loaded column: accounts.reportConversions->false 2012-03-20 15:11:15.318 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2012-03-20 15:11:15.319 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2012-03-20 15:11:15.319 (5) [P1T1]: loaded column: accounts.isActive->true 2012-03-20 15:11:15.319 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2012-03-20 15:11:15.320 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2012-03-20 15:11:15.320 (5) [P1T1]: loaded column: accounts.addConversionData->false 2012-03-20 15:11:15.320 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2012-03-20 15:11:15.321 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2012-03-20 15:11:15.321 (5) [P1T1]: loaded column: accounts.nowTime->null 2012-03-20 15:11:15.321 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2012-03-20 15:11:15.322 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2012-03-20 15:11:15.322 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2012-03-20 15:11:15.322 (5) [P1T1]: loaded column: accounts.isOnline->true 2012-03-20 15:11:15.323 (4) [P1T1]: Record Loaded 2012-03-20 15:11:15.323 (4) [P1T1]: DataCache: put key acct-st-tracker 5221 2012-03-20 15:11:15.324 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.324 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-1")) limit 1] 2012-03-20 15:11:15.326 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:15.326 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.327 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.327 (4) [P1T1]: time=0.0020 2012-03-20 15:11:15.327 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:15.328 (5) [P1T1]: loading 8 columns from result set: 2012-03-20 15:11:15.328 (5) [P1T1]: loaded column: databaseInstances.id->15 2012-03-20 15:11:15.328 (5) [P1T1]: loaded column: databaseInstances.name->acct-st-tracker-1 2012-03-20 15:11:15.329 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Catch-all database 2012-03-20 15:11:15.331 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-03-20 15:11:15.331 (5) [P1T1]: loaded column: databaseInstances.database->st-tracker 2012-03-20 15:11:15.331 (5) [P1T1]: loaded column: databaseInstances.host->acctdb-01-write 2012-03-20 15:11:15.332 (5) [P1T1]: loaded column: databaseInstances.port->3306 2012-03-20 15:11:15.332 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-03-20 15:11:15.332 (4) [P1T1]: Record Loaded 2012-03-20 15:11:15.332 (4) [P1T1]: DataCache: put key acct-st-tracker-1 2012-03-20 15:11:15.333 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:15.334 (3) [P1T1]: DatabasePool with a limit of 18 created 2012-03-20 15:11:15.381 (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:15.382 (4) [P1T1]: Created new Object 2012-03-20 15:11:15.382 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.383 (4) [P1T1]: spike: SQL->[select @@version] 2012-03-20 15:11:15.384 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:15.385 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.385 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.385 (4) [P1T1]: time=0.0020 2012-03-20 15:11:15.386 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:15.386 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-20 15:11:15.386 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:15.386 (3) [P1T1]: DatabasePool with a limit of 18 created 2012-03-20 15:11:15.444 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:15.444 (4) [P1T1]: Created new Object 2012-03-20 15:11:15.444 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.444 (4) [P1T1]: spike: SQL->[select @@version] 2012-03-20 15:11:15.446 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:15.446 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.446 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.446 (4) [P1T1]: time=0.0020 2012-03-20 15:11:15.446 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:15.446 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-20 15:11:15.447 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:15.487 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:15.488 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.488 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-staging")) limit 1] 2012-03-20 15:11:15.489 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:15.490 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.490 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:15.490 (4) [P1T1]: time=0.0010 2012-03-20 15:11:15.490 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:15.491 (5) [P1T1]: loading 8 columns from result set: 2012-03-20 15:11:15.491 (5) [P1T1]: loaded column: databaseInstances.id->3 2012-03-20 15:11:15.491 (5) [P1T1]: loaded column: databaseInstances.name->global-staging 2012-03-20 15:11:15.491 (5) [P1T1]: loaded column: databaseInstances.description->Global Staging Tables 2012-03-20 15:11:15.491 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-03-20 15:11:15.492 (5) [P1T1]: loaded column: databaseInstances.database->staging 2012-03-20 15:11:15.492 (5) [P1T1]: loaded column: databaseInstances.host->staging-01-write 2012-03-20 15:11:15.492 (5) [P1T1]: loaded column: databaseInstances.port->3306 2012-03-20 15:11:15.492 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-03-20 15:11:15.493 (4) [P1T1]: Record Loaded 2012-03-20 15:11:15.493 (4) [P1T1]: DataCache: put key global-staging 2012-03-20 15:11:15.493 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:15.494 (3) [P1T1]: DatabasePool with a limit of 18 created 2012-03-20 15:11:15.603 (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:15.604 (4) [P1T1]: Created new Object 2012-03-20 15:11:15.604 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.604 (4) [P1T1]: spike: SQL->[select @@version] 2012-03-20 15:11:15.605 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:15.606 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.606 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:15.606 (4) [P1T1]: time=0.0010 2012-03-20 15:11:15.607 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:15.607 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-20 15:11:15.609 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.610 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.5221', 600)] 2012-03-20 15:11:15.611 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:15.611 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.612 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:15.612 (4) [P1T1]: time=0.0010 2012-03-20 15:11:15.612 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:15.612 (3) [P1T1]: Got migrator lock for Account ID #5221 2012-03-20 15:11:15.616 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:15.623 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.624 (4) [P1T1]: spike: SQL->[select * from `settings` where ((((`settings`.`scope`="accounts")) and ((`settings`.`scopeId`=5221))))] 2012-03-20 15:11:15.626 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:15.627 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.627 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.627 (4) [P1T1]: time=0.0020 2012-03-20 15:11:15.627 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:15.631 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.631 (4) [P1T1]: spike: SQL->[select * from `settingDefaults` where (`settingDefaults`.`scope`="accounts")] 2012-03-20 15:11:15.633 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:15.633 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.633 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.633 (4) [P1T1]: time=0.0020 2012-03-20 15:11:15.634 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:15.636 (4) [P1T1]: DataCache: put key accounts 5221 2012-03-20 15:11:15.664 (4) [P1T1]: DataCache: Found key accounts 5221 2012-03-20 15:11:15.665 (4) [P1T1]: Settings.getSettings: loaded from cache (key=accounts 5221) 2012-03-20 15:11:15.665 (3) [P1T1]: Applying algorithm [SABB] for Account ID #5221 in distributions [3] 2012-03-20 15:11:15.666 (3) [P1T1]: Processing data for Wed Mar 21 00:00:00 GMT 2012 2012-03-20 15:11:15.680 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:15.681 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.681 (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`="3"))) and ((`tsacommon`.`searchEngineAccounts`.`distributionID` in (3))))) order by rand()] 2012-03-20 15:11:15.685 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:15.685 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.685 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:15.775 (4) [P1T1]: time=0.0040 2012-03-20 15:11:15.775 (4) [P1T1]: Query executed in 0.004s 2012-03-20 15:11:15.789 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:15.790 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.790 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15921")) limit 1] 2012-03-20 15:11:15.792 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:15.792 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.792 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.792 (4) [P1T1]: time=0.0020 2012-03-20 15:11:15.793 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:15.793 (5) [P1T1]: loading 4 columns from result set: 2012-03-20 15:11:15.793 (5) [P1T1]: loaded column: dataSources.id->5967 2012-03-20 15:11:15.794 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-20 15:11:15.794 (5) [P1T1]: loaded column: dataSources.typeID->15921 2012-03-20 15:11:15.794 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-20 15:11:15.794 (4) [P1T1]: Record Loaded 2012-03-20 15:11:15.795 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:15.795 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.795 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15901")) limit 1] 2012-03-20 15:11:15.797 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:15.797 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.797 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.797 (4) [P1T1]: time=0.0020 2012-03-20 15:11:15.797 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:15.797 (5) [P1T1]: loading 4 columns from result set: 2012-03-20 15:11:15.798 (5) [P1T1]: loaded column: dataSources.id->5968 2012-03-20 15:11:15.798 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-20 15:11:15.798 (5) [P1T1]: loaded column: dataSources.typeID->15901 2012-03-20 15:11:15.798 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-20 15:11:15.798 (4) [P1T1]: Record Loaded 2012-03-20 15:11:15.800 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:15.800 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.801 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15931")) limit 1] 2012-03-20 15:11:15.802 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:15.802 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.802 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:15.802 (4) [P1T1]: time=0.0020 2012-03-20 15:11:15.802 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:15.802 (5) [P1T1]: loading 4 columns from result set: 2012-03-20 15:11:15.803 (5) [P1T1]: loaded column: dataSources.id->5965 2012-03-20 15:11:15.803 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-20 15:11:15.803 (5) [P1T1]: loaded column: dataSources.typeID->15931 2012-03-20 15:11:15.803 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-20 15:11:15.803 (4) [P1T1]: Record Loaded 2012-03-20 15:11:15.804 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:15.804 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.804 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15911")) limit 1] 2012-03-20 15:11:15.805 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:15.806 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.806 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:15.806 (4) [P1T1]: time=0.0010 2012-03-20 15:11:15.806 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:15.806 (5) [P1T1]: loading 4 columns from result set: 2012-03-20 15:11:15.806 (5) [P1T1]: loaded column: dataSources.id->5966 2012-03-20 15:11:15.806 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-20 15:11:15.807 (5) [P1T1]: loaded column: dataSources.typeID->15911 2012-03-20 15:11:15.807 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-20 15:11:15.807 (4) [P1T1]: Record Loaded 2012-03-20 15:11:15.807 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-20 15:11:15.808 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:15.808 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`dataSources`.`type`="admax") and (`dataSources`.`accountID`=5221))] 2012-03-20 15:11:15.809 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:15.809 (5) [P1T1]: addSub("db") 2012-03-20 15:11:15.809 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:15.809 (4) [P1T1]: time=0.0010 2012-03-20 15:11:15.809 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:16.211 (5) [P1T1]: loading 4 columns from result set: 2012-03-20 15:11:16.212 (5) [P1T1]: loaded column: dataSources.id->5965 2012-03-20 15:11:16.212 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-20 15:11:16.212 (5) [P1T1]: loaded column: dataSources.typeID->15931 2012-03-20 15:11:16.213 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-20 15:11:16.213 (5) [P1T1]: loading 4 columns from result set: 2012-03-20 15:11:16.213 (5) [P1T1]: loaded column: dataSources.id->5966 2012-03-20 15:11:16.213 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-20 15:11:16.214 (5) [P1T1]: loaded column: dataSources.typeID->15911 2012-03-20 15:11:16.214 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-20 15:11:16.214 (5) [P1T1]: loading 4 columns from result set: 2012-03-20 15:11:16.215 (5) [P1T1]: loaded column: dataSources.id->5967 2012-03-20 15:11:16.215 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-20 15:11:16.215 (5) [P1T1]: loaded column: dataSources.typeID->15921 2012-03-20 15:11:16.216 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-20 15:11:16.216 (5) [P1T1]: loading 4 columns from result set: 2012-03-20 15:11:16.216 (5) [P1T1]: loaded column: dataSources.id->5968 2012-03-20 15:11:16.217 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-20 15:11:16.217 (5) [P1T1]: loaded column: dataSources.typeID->15901 2012-03-20 15:11:16.217 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-20 15:11:16.222 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.222 (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:16.225 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:16.225 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.225 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:16.225 (4) [P1T1]: time=0.0030 2012-03-20 15:11:16.226 (4) [P1T1]: Query executed in 0.003s 2012-03-20 15:11:16.226 (4) [P1T1]: Record Not Found 2012-03-20 15:11:16.228 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.228 (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:16")], genflags=yes 2012-03-20 15:11:16.236 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2012-03-20 15:11:16.237 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.237 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2012-03-20 15:11:16.237 (4) [P1T1]: time=0.0080 2012-03-20 15:11:16.238 (4) [P1T1]: Query executed in 0.008s, 1 row(s) affected 2012-03-20 15:11:16.242 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.242 (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:16")], genflags=yes 2012-03-20 15:11:16.244 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:16.244 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.244 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:16.245 (4) [P1T1]: time=0.0020 2012-03-20 15:11:16.261 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-03-20 15:11:16.263 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.263 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5966") and (`date`="2012-03-21 00:00:00")) limit 1] 2012-03-20 15:11:16.265 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:16.265 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.266 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:16.266 (4) [P1T1]: time=0.0020 2012-03-20 15:11:16.266 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:16.266 (4) [P1T1]: Record Not Found 2012-03-20 15:11:16.820 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.820 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5966","in progress","2012-03-21 00:00:00","2012-03-20 15:11:16")], genflags=yes 2012-03-20 15:11:16.824 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:16.824 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.824 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:16.824 (4) [P1T1]: time=0.0030 2012-03-20 15:11:16.825 (4) [P1T1]: Query executed in 0.003s, 1 row(s) affected 2012-03-20 15:11:16.828 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.829 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5966","in progress","2012-03-21 00:00:00","2012-03-20 15:11:16")], genflags=yes 2012-03-20 15:11:16.830 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:16.831 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.831 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:16.831 (4) [P1T1]: time=0.0010 2012-03-20 15:11:16.831 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2012-03-20 15:11:16.833 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.833 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5967") and (`date`="2012-03-21 00:00:00")) limit 1] 2012-03-20 15:11:16.836 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:16.836 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.836 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:16.836 (4) [P1T1]: time=0.0020 2012-03-20 15:11:16.837 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:16.837 (4) [P1T1]: Record Not Found 2012-03-20 15:11:16.846 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.846 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5967","in progress","2012-03-21 00:00:00","2012-03-20 15:11:16")], genflags=yes 2012-03-20 15:11:16.849 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:16.849 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.850 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:16.850 (4) [P1T1]: time=0.0030 2012-03-20 15:11:16.850 (4) [P1T1]: Query executed in 0.003s, 1 row(s) affected 2012-03-20 15:11:16.888 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.889 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5967","in progress","2012-03-21 00:00:00","2012-03-20 15:11:16")], genflags=yes 2012-03-20 15:11:16.890 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:16.891 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.891 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:16.891 (4) [P1T1]: time=0.0010 2012-03-20 15:11:16.891 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2012-03-20 15:11:16.893 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.893 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5968") and (`date`="2012-03-21 00:00:00")) limit 1] 2012-03-20 15:11:16.895 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:16.895 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.896 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:16.896 (4) [P1T1]: time=0.0020 2012-03-20 15:11:16.896 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:16.896 (4) [P1T1]: Record Not Found 2012-03-20 15:11:16.898 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.898 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5968","in progress","2012-03-21 00:00:00","2012-03-20 15:11:16")], genflags=yes 2012-03-20 15:11:16.900 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:16.901 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.901 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:16.901 (4) [P1T1]: time=0.0020 2012-03-20 15:11:16.901 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-03-20 15:11:16.903 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:16.903 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5968","in progress","2012-03-21 00:00:00","2012-03-20 15:11:16")], genflags=yes 2012-03-20 15:11:16.905 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:16.905 (5) [P1T1]: addSub("db") 2012-03-20 15:11:16.906 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:16.906 (4) [P1T1]: time=0.0020 2012-03-20 15:11:16.906 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-03-20 15:11:16.911 (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:16.920 (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:16.924 (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:16.935 (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:16.939 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.googleMccAdMax.date,staging.googleMccAdMax.clicks,staging.googleMccAdMax.cost 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=?] 2012-03-20 15:11:16.980 (2) [P1T1]: AdMax campaign ID: 3281 spent 0.4 2012-03-20 15:11:16.981 (2) [P1T1]: AdMax campaign ID: 3281 spent 0.8 2012-03-20 15:11:16.981 (2) [P1T1]: AdMax campaign ID: 3291 spent 0.05 2012-03-20 15:11:16.982 (2) [P1T1]: AdMax campaign ID: 3291 spent 0.1 2012-03-20 15:11:17.426 (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:17.444 (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:17.452 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,balanceFactor from `st-tracker`.admaxSearchEngineAccountBalanceFactors where searchEngineAccountID=? and date=?] 2012-03-20 15:11:17.462 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,budget from `st-tracker`.admaxSearchEngineAccountActualDailyBudgets where searchEngineAccountID=? and date=?] 2012-03-20 15:11:17.477 (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:17.486 (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:17.617 (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:17.621 (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:17.625 (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:17.627 (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:17.630 (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:17.641 (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:17.648 (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:17.754 (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:17.758 (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:17.766 (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:17.771 (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:17.807 (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:17.821 (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:17.828 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountBalanceFactors (searchEngineAccountID, date, balanceFactor) values (?,?,?) on duplicate key update balanceFactor=?] 2012-03-20 15:11:17.839 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountActualDailyBudgets (searchEngineAccountID, date, budget) values (?,?,?) on duplicate key update budget=?] 2012-03-20 15:11:17.913 (4) [P1T1]: preparing SQL statement [select id,accountID,distributionID,searchEngineUserID,searchEngineIdentifier,budgetAmount,searchEngineStatus from `tsacommon`.searchEngineAccounts where id=?] 2012-03-20 15:11:17.921 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Long 2012-03-20 15:11:17.921 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:17.922 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=5671) limit 1] 2012-03-20 15:11:17.924 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:17.924 (5) [P1T1]: addSub("db") 2012-03-20 15:11:17.924 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:17.924 (4) [P1T1]: time=0.0010 2012-03-20 15:11:17.925 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:17.926 (5) [P1T1]: loading 14 columns from result set: 2012-03-20 15:11:17.926 (5) [P1T1]: loaded column: searchEngineUsers.id->5671 2012-03-20 15:11:17.927 (5) [P1T1]: loaded column: searchEngineUsers.accountID->5221 2012-03-20 15:11:17.927 (5) [P1T1]: loaded column: searchEngineUsers.distributionID->3 2012-03-20 15:11:17.927 (5) [P1T1]: loaded column: searchEngineUsers.searchEngineIdentifier->4038 2012-03-20 15:11:17.928 (5) [P1T1]: loaded column: searchEngineUsers.description->alok-n63a_1 2012-03-20 15:11:17.928 (5) [P1T1]: loaded column: searchEngineUsers.username->mmstestclientaccount+5671@gmail.com 2012-03-20 15:11:17.928 (5) [P1T1]: loaded column: searchEngineUsers.password->8kwtROEEI8YMM4QU 2012-03-20 15:11:17.929 (5) [P1T1]: loaded column: searchEngineUsers.enabled->true 2012-03-20 15:11:17.929 (5) [P1T1]: loaded column: searchEngineUsers.inTsaMcc->true 2012-03-20 15:11:17.929 (5) [P1T1]: loaded column: searchEngineUsers.apiKey-> 2012-03-20 15:11:17.930 (5) [P1T1]: loaded column: searchEngineUsers.managerUsernames->null 2012-03-20 15:11:17.930 (5) [P1T1]: loaded column: searchEngineUsers.managerIDs->null 2012-03-20 15:11:17.930 (5) [P1T1]: loaded column: searchEngineUsers.lastChecked->null 2012-03-20 15:11:17.931 (5) [P1T1]: loaded column: searchEngineUsers.lastInMcc->null 2012-03-20 15:11:17.931 (4) [P1T1]: Record Loaded 2012-03-20 15:11:17.977 (4) [P1T1]: client customer id = 4038 2012-03-20 15:11:17.980 (5) [P1T1]: parseInteger->[5671] 2012-03-20 15:11:17.981 (5) [P1T1]: parseInteger<-[5671] 2012-03-20 15:11:18.342 (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:231) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.getGoogleAPI(AdMaxSABBAlgorithm.java:484) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.updateSearchEngineAccounts(AdMaxSABBAlgorithm.java:394) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.applyAlgorithm(AdMaxSABBAlgorithm.java:166) 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:231) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.getGoogleAPI(AdMaxSABBAlgorithm.java:484) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.updateSearchEngineAccounts(AdMaxSABBAlgorithm.java:394) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.applyAlgorithm(AdMaxSABBAlgorithm.java:166) 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:231) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.getGoogleAPI(AdMaxSABBAlgorithm.java:484) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.updateSearchEngineAccounts(AdMaxSABBAlgorithm.java:394) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.applyAlgorithm(AdMaxSABBAlgorithm.java:166) 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:18.377 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:18.386 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:18.407 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:18.408 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:18.408 (4) [P1T1]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineClass`!=""))] 2012-03-20 15:11:18.410 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:18.410 (5) [P1T1]: addSub("db") 2012-03-20 15:11:18.410 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:18.411 (4) [P1T1]: time=0.0020 2012-03-20 15:11:18.411 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:18.413 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:18.416 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-20 15:11:18.465 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:18.466 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:18.466 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-sesystem")) limit 1] 2012-03-20 15:11:18.468 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:18.468 (5) [P1T1]: addSub("db") 2012-03-20 15:11:18.469 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:18.469 (4) [P1T1]: time=0.0020 2012-03-20 15:11:18.469 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:18.470 (5) [P1T1]: loading 8 columns from result set: 2012-03-20 15:11:18.470 (5) [P1T1]: loaded column: databaseInstances.id->2 2012-03-20 15:11:18.470 (5) [P1T1]: loaded column: databaseInstances.name->global-sesystem 2012-03-20 15:11:18.471 (5) [P1T1]: loaded column: databaseInstances.description->Global Search Engine API system tables 2012-03-20 15:11:18.471 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-03-20 15:11:18.471 (5) [P1T1]: loaded column: databaseInstances.database->sesystem 2012-03-20 15:11:18.471 (5) [P1T1]: loaded column: databaseInstances.host->sesystem-01-write 2012-03-20 15:11:18.472 (5) [P1T1]: loaded column: databaseInstances.port->3306 2012-03-20 15:11:18.472 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-03-20 15:11:18.472 (4) [P1T1]: Record Loaded 2012-03-20 15:11:18.472 (4) [P1T1]: DataCache: put key global-sesystem 2012-03-20 15:11:18.473 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:18.584 (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:18.585 (3) [P1T1]: Created shared sesystem connection rw 2012-03-20 15:11:18.585 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:18.585 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:18.596 (5) [P1T1]: recordAsSubs("db", 11, "P1T1") 2012-03-20 15:11:18.598 (5) [P1T1]: addSub("db") 2012-03-20 15:11:18.598 (5) [P1T1]: ProfilerRec.end("db", true): ret=11 2012-03-20 15:11:18.602 (4) [P1T1]: time=0.011 2012-03-20 15:11:18.603 (4) [P1T1]: Query executed in 0.011s 2012-03-20 15:11:18.618 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:18.618 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-03-20 15:11:18",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2012-03-20 15:06:18")) limit 1], genflags=no 2012-03-20 15:11:18.621 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:18.621 (5) [P1T1]: addSub("db") 2012-03-20 15:11:18.622 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:18.622 (4) [P1T1]: time=0.0030 2012-03-20 15:11:18.622 (4) [P1T1]: Query executed in 0.003s, 0 row(s) affected 2012-03-20 15:11:18.623 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:18.623 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:18.625 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:18.625 (5) [P1T1]: addSub("db") 2012-03-20 15:11:18.625 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:18.626 (4) [P1T1]: time=0.0020 2012-03-20 15:11:18.626 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:18.628 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-03-20 15:11:18.629 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:18.629 (4) [P1T1]: sesystem: SQL->[select `authToken`,`date` from `sesystem`.`googleAuthToken` where ((`seUserID`=0))] 2012-03-20 15:11:18.631 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:18.631 (5) [P1T1]: addSub("db") 2012-03-20 15:11:18.631 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:18.632 (4) [P1T1]: time=0.0020 2012-03-20 15:11:18.632 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:18.633 (4) [P1T1]: Master AuthToken retrieved from database [DQAAAKQAAAB1tjJkmn_hcq6CWYqmrGsILOnRJBYritgoI1cxYwT4lU4GZBJ72ugp_tcxEJYYfqKpWblxJ4f8QtAaAuX1AmjhRvn4bcWRuWo62uEO7_iQpf93NouLwe6riCqZ-8Inty61F8gZM4kOKTj4iUWWMZgs-IhEo7SYUYZxywmbvW7C5ZGSbTm3dqpUilVrK0VqWTpnuOc6ECZe0h82AbHk48SdZYGe4GfHBmzBjzmqlEdFug] for username[yellsmsdomain@yellgroup.com] 2012-03-20 15:11:18.758 (4) [P1T1]: Setting AuthToken [DQAAAKQAAAB1tjJkmn_hcq6CWYqmrGsILOnRJBYritgoI1cxYwT4lU4GZBJ72ugp_tcxEJYYfqKpWblxJ4f8QtAaAuX1AmjhRvn4bcWRuWo62uEO7_iQpf93NouLwe6riCqZ-8Inty61F8gZM4kOKTj4iUWWMZgs-IhEo7SYUYZxywmbvW7C5ZGSbTm3dqpUilVrK0VqWTpnuOc6ECZe0h82AbHk48SdZYGe4GfHBmzBjzmqlEdFug] to AdWordsUser object for username[yellsmsdomain@yellgroup.com] 2012-03-20 15:11:18.777 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Long 2012-03-20 15:11:18.778 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:18.778 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=5671) limit 1] 2012-03-20 15:11:18.780 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:18.780 (5) [P1T1]: addSub("db") 2012-03-20 15:11:18.780 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:18.780 (4) [P1T1]: time=0.0020 2012-03-20 15:11:18.780 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:18.780 (5) [P1T1]: loading 14 columns from result set: 2012-03-20 15:11:18.781 (5) [P1T1]: loaded column: searchEngineUsers.id->5671 2012-03-20 15:11:18.781 (5) [P1T1]: loaded column: searchEngineUsers.accountID->5221 2012-03-20 15:11:18.781 (5) [P1T1]: loaded column: searchEngineUsers.distributionID->3 2012-03-20 15:11:18.781 (5) [P1T1]: loaded column: searchEngineUsers.searchEngineIdentifier->4038 2012-03-20 15:11:18.782 (5) [P1T1]: loaded column: searchEngineUsers.description->alok-n63a_1 2012-03-20 15:11:18.782 (5) [P1T1]: loaded column: searchEngineUsers.username->mmstestclientaccount+5671@gmail.com 2012-03-20 15:11:18.782 (5) [P1T1]: loaded column: searchEngineUsers.password->8kwtROEEI8YMM4QU 2012-03-20 15:11:18.782 (5) [P1T1]: loaded column: searchEngineUsers.enabled->true 2012-03-20 15:11:18.782 (5) [P1T1]: loaded column: searchEngineUsers.inTsaMcc->true 2012-03-20 15:11:18.783 (5) [P1T1]: loaded column: searchEngineUsers.apiKey-> 2012-03-20 15:11:18.783 (5) [P1T1]: loaded column: searchEngineUsers.managerUsernames->null 2012-03-20 15:11:18.783 (5) [P1T1]: loaded column: searchEngineUsers.managerIDs->null 2012-03-20 15:11:18.783 (5) [P1T1]: loaded column: searchEngineUsers.lastChecked->null 2012-03-20 15:11:18.783 (5) [P1T1]: loaded column: searchEngineUsers.lastInMcc->null 2012-03-20 15:11:18.783 (4) [P1T1]: Record Loaded 2012-03-20 15:11:18.790 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Long 2012-03-20 15:11:18.790 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:18.790 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=5671) limit 1] 2012-03-20 15:11:18.792 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:18.792 (5) [P1T1]: addSub("db") 2012-03-20 15:11:18.793 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:18.793 (4) [P1T1]: time=0.0020 2012-03-20 15:11:18.793 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:18.793 (5) [P1T1]: loading 14 columns from result set: 2012-03-20 15:11:18.794 (5) [P1T1]: loaded column: searchEngineUsers.id->5671 2012-03-20 15:11:18.794 (5) [P1T1]: loaded column: searchEngineUsers.accountID->5221 2012-03-20 15:11:18.794 (5) [P1T1]: loaded column: searchEngineUsers.distributionID->3 2012-03-20 15:11:18.794 (5) [P1T1]: loaded column: searchEngineUsers.searchEngineIdentifier->4038 2012-03-20 15:11:18.795 (5) [P1T1]: loaded column: searchEngineUsers.description->alok-n63a_1 2012-03-20 15:11:18.795 (5) [P1T1]: loaded column: searchEngineUsers.username->mmstestclientaccount+5671@gmail.com 2012-03-20 15:11:18.795 (5) [P1T1]: loaded column: searchEngineUsers.password->8kwtROEEI8YMM4QU 2012-03-20 15:11:18.795 (5) [P1T1]: loaded column: searchEngineUsers.enabled->true 2012-03-20 15:11:18.796 (5) [P1T1]: loaded column: searchEngineUsers.inTsaMcc->true 2012-03-20 15:11:18.796 (5) [P1T1]: loaded column: searchEngineUsers.apiKey-> 2012-03-20 15:11:18.796 (5) [P1T1]: loaded column: searchEngineUsers.managerUsernames->null 2012-03-20 15:11:18.796 (5) [P1T1]: loaded column: searchEngineUsers.managerIDs->null 2012-03-20 15:11:18.796 (5) [P1T1]: loaded column: searchEngineUsers.lastChecked->null 2012-03-20 15:11:18.797 (5) [P1T1]: loaded column: searchEngineUsers.lastInMcc->null 2012-03-20 15:11:18.797 (4) [P1T1]: Record Loaded 2012-03-20 15:11:18.799 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Long 2012-03-20 15:11:18.799 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:19.026 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=5671) limit 1] 2012-03-20 15:11:19.028 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:19.028 (5) [P1T1]: addSub("db") 2012-03-20 15:11:19.029 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:19.029 (4) [P1T1]: time=0.0020 2012-03-20 15:11:19.029 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:19.029 (5) [P1T1]: loading 14 columns from result set: 2012-03-20 15:11:19.030 (5) [P1T1]: loaded column: searchEngineUsers.id->5671 2012-03-20 15:11:19.242 (5) [P1T1]: loaded column: searchEngineUsers.accountID->5221 2012-03-20 15:11:19.243 (5) [P1T1]: loaded column: searchEngineUsers.distributionID->3 2012-03-20 15:11:19.243 (5) [P1T1]: loaded column: searchEngineUsers.searchEngineIdentifier->4038 2012-03-20 15:11:19.243 (5) [P1T1]: loaded column: searchEngineUsers.description->alok-n63a_1 2012-03-20 15:11:19.244 (5) [P1T1]: loaded column: searchEngineUsers.username->mmstestclientaccount+5671@gmail.com 2012-03-20 15:11:19.244 (5) [P1T1]: loaded column: searchEngineUsers.password->8kwtROEEI8YMM4QU 2012-03-20 15:11:19.244 (5) [P1T1]: loaded column: searchEngineUsers.enabled->true 2012-03-20 15:11:19.244 (5) [P1T1]: loaded column: searchEngineUsers.inTsaMcc->true 2012-03-20 15:11:19.244 (5) [P1T1]: loaded column: searchEngineUsers.apiKey-> 2012-03-20 15:11:19.245 (5) [P1T1]: loaded column: searchEngineUsers.managerUsernames->null 2012-03-20 15:11:19.245 (5) [P1T1]: loaded column: searchEngineUsers.managerIDs->null 2012-03-20 15:11:19.245 (5) [P1T1]: loaded column: searchEngineUsers.lastChecked->null 2012-03-20 15:11:19.245 (5) [P1T1]: loaded column: searchEngineUsers.lastInMcc->null 2012-03-20 15:11:19.245 (4) [P1T1]: Record Loaded 2012-03-20 15:11:19.249 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:19.250 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:19.251 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:19.252 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:19.252 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:19.254 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:19.254 (5) [P1T1]: addSub("db") 2012-03-20 15:11:19.254 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:19.255 (4) [P1T1]: time=0.0020 2012-03-20 15:11:19.255 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:19.255 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:19.255 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=5671,`inUse`="true",`holder`="UpdateCampaignList",`holderIdentifier`="4038",`timeStamp`="2012-03-20 15:11:19" 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:19.265 (5) [P1T1]: recordAsSubs("db", 10, "P1T1") 2012-03-20 15:11:19.266 (5) [P1T1]: addSub("db") 2012-03-20 15:11:19.266 (5) [P1T1]: ProfilerRec.end("db", true): ret=10 2012-03-20 15:11:19.266 (4) [P1T1]: time=0.01 2012-03-20 15:11:19.266 (4) [P1T1]: Query executed in 0.010s, 1 row(s) affected 2012-03-20 15:11:19.267 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1] 2012-03-20 15:11:24.902 (2) [P1T1]: 1 Errors found 2012-03-20 15:11:24.906 (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.906 (3) [P1T1]: Caught other/unrecoverable API Error: "com.google.api.adwords.v201109.cm.ApiException" 2012-03-20 15:11:24.907 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:24.908 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:24.909 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:24.909 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:24.911 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:24.911 (5) [P1T1]: addSub("db") 2012-03-20 15:11:24.911 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:24.955 (4) [P1T1]: time=0.0020 2012-03-20 15:11:24.955 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:24.956 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:24.956 (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.960 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:24.966 (5) [P1T1]: addSub("db") 2012-03-20 15:11:24.966 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:24.966 (4) [P1T1]: time=0.0040 2012-03-20 15:11:24.967 (4) [P1T1]: Query executed in 0.004s, 1 row(s) affected 2012-03-20 15:11:24.967 (4) [P1T1]: 4038 released searchEngineConnection row 2012-03-20 15:11:24.967 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:24.967 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:24.969 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:24.969 (5) [P1T1]: addSub("db") 2012-03-20 15:11:24.969 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:24.970 (4) [P1T1]: time=0.0020 2012-03-20 15:11:24.970 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:24.972 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:24.973 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:24.973 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=3) and (`operation`="UpdateCampaignList")) limit 1] 2012-03-20 15:11:24.975 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:24.975 (5) [P1T1]: addSub("db") 2012-03-20 15:11:24.975 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:24.984 (4) [P1T1]: time=0.0020 2012-03-20 15:11:24.984 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:24.984 (5) [P1T1]: loading 10 columns from result set: 2012-03-20 15:11:24.985 (5) [P1T1]: loaded column: searchEngineResources.id->210 2012-03-20 15:11:24.985 (5) [P1T1]: loaded column: searchEngineResources.distributionID->3 2012-03-20 15:11:24.985 (5) [P1T1]: loaded column: searchEngineResources.operation->UpdateCampaignList 2012-03-20 15:11:24.985 (5) [P1T1]: loaded column: searchEngineResources.description-> 2012-03-20 15:11:24.986 (5) [P1T1]: loaded column: searchEngineResources.scope->campaign 2012-03-20 15:11:24.986 (5) [P1T1]: loaded column: searchEngineResources.operationClass->creative 2012-03-20 15:11:24.986 (5) [P1T1]: loaded column: searchEngineResources.dailyOpCap->0 2012-03-20 15:11:25.003 (5) [P1T1]: loaded column: searchEngineResources.cmdParamCap->0 2012-03-20 15:11:25.004 (5) [P1T1]: loaded column: searchEngineResources.dailyParamCap->0 2012-03-20 15:11:25.008 (5) [P1T1]: loaded column: searchEngineResources.freqCapSeconds->0 2012-03-20 15:11:25.009 (4) [P1T1]: Record Loaded 2012-03-20 15:11:25.011 (5) [P1T1]: quoteValue(), nothing special about it=>[210], type=class java.lang.Integer 2012-03-20 15:11:25.012 (5) [P1T1]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2012-03-20 15:11:25.012 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:25.012 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`searchEngineResourceUsage` (`sesystem`.`searchEngineResourceUsage`.`resourceID`,`sesystem`.`searchEngineResourceUsage`.`periodStart`,`sesystem`.`searchEngineResourceUsage`.`holderID`,`sesystem`.`searchEngineResourceUsage`.`lastUsage`,`sesystem`.`searchEngineResourceUsage`.`opCount`) values (210,"2012-03-20 07:00:00","4038",NOW(),1) on duplicate key update `sesystem`.`searchEngineResourceUsage`.`opCount`=`sesystem`.`searchEngineResourceUsage`.`opCount`+1,`sesystem`.`searchEngineResourceUsage`.`lastUsage`=NOW()], genflags=no 2012-03-20 15:11:25.016 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:25.016 (5) [P1T1]: addSub("db") 2012-03-20 15:11:25.016 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:25.016 (4) [P1T1]: time=0.0040 2012-03-20 15:11:25.017 (4) [P1T1]: Query executed in 0.004s, 3 row(s) affected 2012-03-20 15:11:25.017 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:25.018 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:25.018 (4) [P1T1]: Operations for UpdateCampaignList: 0 2012-03-20 15:11:25.018 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:25.018 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:25.019 (4) [P1T1]: Quota units for UpdateCampaignList: 0 2012-03-20 15:11:25.020 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:25.020 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:25.022 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:25.022 (5) [P1T1]: addSub("db") 2012-03-20 15:11:25.022 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:25.022 (4) [P1T1]: time=0.0020 2012-03-20 15:11:25.023 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:25.037 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:25.037 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`quotaUsage` values ("5671","210","2012-03-20","0","0") on duplicate key update `quotaUsed`=`quotaUsed`+0,`operations`=`operations`+0], genflags=no 2012-03-20 15:11:25.039 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:25.039 (5) [P1T1]: addSub("db") 2012-03-20 15:11:25.039 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:25.039 (4) [P1T1]: time=0.0020 2012-03-20 15:11:25.039 (4) [P1T1]: Query executed in 0.002s, 2 row(s) affected 2012-03-20 15:11:25.039 (4) [P1T1]: Quota recorded for seUser #5671: 0 quota used for resource ID 210 2012-03-20 15:11:25.039 (3) [P1T1]: Error while updating the collection of campaign budgets! 2012-03-20 15:11:25.040 (2) [P1T1]: Error occurred updating Google budget for seID 18339. 2012-03-20 15:11:25.041 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:25.041 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:25.041 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:25.042 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:25.042 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:25.049 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-03-20 15:11:25.050 (5) [P1T1]: addSub("db") 2012-03-20 15:11:25.052 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-03-20 15:11:25.053 (4) [P1T1]: time=0.0070 2012-03-20 15:11:25.053 (4) [P1T1]: Query executed in 0.007s 2012-03-20 15:11:25.054 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:25.055 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=5671,`inUse`="true",`holder`="UpdateCampaignList",`holderIdentifier`="4038",`timeStamp`="2012-03-20 15:11:25" 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:25.074 (5) [P1T1]: recordAsSubs("db", 19, "P1T1") 2012-03-20 15:11:25.076 (5) [P1T1]: addSub("db") 2012-03-20 15:11:25.077 (5) [P1T1]: ProfilerRec.end("db", true): ret=19 2012-03-20 15:11:25.079 (4) [P1T1]: time=0.019 2012-03-20 15:11:25.084 (4) [P1T1]: Query executed in 0.019s, 1 row(s) affected 2012-03-20 15:11:25.084 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1] 2012-03-20 15:11:26.747 (2) [P1T1]: 1 Errors found 2012-03-20 15:11:26.749 (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.749 (3) [P1T1]: Caught other/unrecoverable API Error: "com.google.api.adwords.v201109.cm.ApiException" 2012-03-20 15:11:26.750 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:26.751 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:26.752 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.752 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:26.754 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:26.754 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.755 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:26.755 (4) [P1T1]: time=0.0020 2012-03-20 15:11:26.755 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:26.755 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.756 (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.767 (5) [P1T1]: recordAsSubs("db", 11, "P1T1") 2012-03-20 15:11:26.767 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.767 (5) [P1T1]: ProfilerRec.end("db", true): ret=11 2012-03-20 15:11:26.767 (4) [P1T1]: time=0.011 2012-03-20 15:11:26.768 (4) [P1T1]: Query executed in 0.011s, 1 row(s) affected 2012-03-20 15:11:26.768 (4) [P1T1]: 4038 released searchEngineConnection row 2012-03-20 15:11:26.768 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.768 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:26.813 (5) [P1T1]: recordAsSubs("db", 44, "P1T1") 2012-03-20 15:11:26.813 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.813 (5) [P1T1]: ProfilerRec.end("db", true): ret=44 2012-03-20 15:11:26.813 (4) [P1T1]: time=0.044 2012-03-20 15:11:26.813 (4) [P1T1]: Query executed in 0.044s 2012-03-20 15:11:26.814 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:26.814 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.814 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=3) and (`operation`="UpdateCampaignList")) limit 1] 2012-03-20 15:11:26.824 (5) [P1T1]: recordAsSubs("db", 10, "P1T1") 2012-03-20 15:11:26.825 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.825 (5) [P1T1]: ProfilerRec.end("db", true): ret=10 2012-03-20 15:11:26.825 (4) [P1T1]: time=0.01 2012-03-20 15:11:26.825 (4) [P1T1]: Query executed in 0.010s 2012-03-20 15:11:26.825 (5) [P1T1]: loading 10 columns from result set: 2012-03-20 15:11:26.825 (5) [P1T1]: loaded column: searchEngineResources.id->210 2012-03-20 15:11:26.827 (5) [P1T1]: loaded column: searchEngineResources.distributionID->3 2012-03-20 15:11:26.827 (5) [P1T1]: loaded column: searchEngineResources.operation->UpdateCampaignList 2012-03-20 15:11:26.827 (5) [P1T1]: loaded column: searchEngineResources.description-> 2012-03-20 15:11:26.827 (5) [P1T1]: loaded column: searchEngineResources.scope->campaign 2012-03-20 15:11:26.827 (5) [P1T1]: loaded column: searchEngineResources.operationClass->creative 2012-03-20 15:11:26.828 (5) [P1T1]: loaded column: searchEngineResources.dailyOpCap->0 2012-03-20 15:11:26.828 (5) [P1T1]: loaded column: searchEngineResources.cmdParamCap->0 2012-03-20 15:11:26.828 (5) [P1T1]: loaded column: searchEngineResources.dailyParamCap->0 2012-03-20 15:11:26.828 (5) [P1T1]: loaded column: searchEngineResources.freqCapSeconds->0 2012-03-20 15:11:26.828 (4) [P1T1]: Record Loaded 2012-03-20 15:11:26.830 (5) [P1T1]: quoteValue(), nothing special about it=>[210], type=class java.lang.Integer 2012-03-20 15:11:26.830 (5) [P1T1]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2012-03-20 15:11:26.830 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.830 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`searchEngineResourceUsage` (`sesystem`.`searchEngineResourceUsage`.`resourceID`,`sesystem`.`searchEngineResourceUsage`.`periodStart`,`sesystem`.`searchEngineResourceUsage`.`holderID`,`sesystem`.`searchEngineResourceUsage`.`lastUsage`,`sesystem`.`searchEngineResourceUsage`.`opCount`) values (210,"2012-03-20 07:00:00","4038",NOW(),1) on duplicate key update `sesystem`.`searchEngineResourceUsage`.`opCount`=`sesystem`.`searchEngineResourceUsage`.`opCount`+1,`sesystem`.`searchEngineResourceUsage`.`lastUsage`=NOW()], genflags=no 2012-03-20 15:11:26.852 (5) [P1T1]: recordAsSubs("db", 22, "P1T1") 2012-03-20 15:11:26.852 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.852 (5) [P1T1]: ProfilerRec.end("db", true): ret=22 2012-03-20 15:11:26.852 (4) [P1T1]: time=0.022 2012-03-20 15:11:26.852 (4) [P1T1]: Query executed in 0.022s, 3 row(s) affected 2012-03-20 15:11:26.852 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:26.853 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:26.853 (4) [P1T1]: Operations for UpdateCampaignList: 0 2012-03-20 15:11:26.853 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:26.853 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:26.853 (4) [P1T1]: Quota units for UpdateCampaignList: 0 2012-03-20 15:11:26.853 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.853 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:26.903 (5) [P1T1]: recordAsSubs("db", 50, "P1T1") 2012-03-20 15:11:26.904 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.904 (5) [P1T1]: ProfilerRec.end("db", true): ret=50 2012-03-20 15:11:26.904 (4) [P1T1]: time=0.05 2012-03-20 15:11:26.904 (4) [P1T1]: Query executed in 0.050s 2012-03-20 15:11:26.905 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.905 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`quotaUsage` values ("5671","210","2012-03-20","0","0") on duplicate key update `quotaUsed`=`quotaUsed`+0,`operations`=`operations`+0], genflags=no 2012-03-20 15:11:26.925 (5) [P1T1]: recordAsSubs("db", 20, "P1T1") 2012-03-20 15:11:26.925 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.926 (5) [P1T1]: ProfilerRec.end("db", true): ret=20 2012-03-20 15:11:26.926 (4) [P1T1]: time=0.02 2012-03-20 15:11:26.926 (4) [P1T1]: Query executed in 0.020s, 2 row(s) affected 2012-03-20 15:11:26.926 (4) [P1T1]: Quota recorded for seUser #5671: 0 quota used for resource ID 210 2012-03-20 15:11:26.926 (3) [P1T1]: Error while updating the collection of campaign budgets! 2012-03-20 15:11:26.926 (2) [P1T1]: Error occurred updating Google budget for seID 18338. 2012-03-20 15:11:26.927 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:26.928 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:26.928 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:26.930 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.930 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:26.951 (5) [P1T1]: recordAsSubs("db", 21, "P1T1") 2012-03-20 15:11:26.952 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.952 (5) [P1T1]: ProfilerRec.end("db", true): ret=21 2012-03-20 15:11:26.952 (4) [P1T1]: time=0.021 2012-03-20 15:11:26.952 (4) [P1T1]: Query executed in 0.021s 2012-03-20 15:11:26.952 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:26.952 (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.957 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:26.957 (5) [P1T1]: addSub("db") 2012-03-20 15:11:26.957 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:26.957 (4) [P1T1]: time=0.0040 2012-03-20 15:11:26.957 (4) [P1T1]: Query executed in 0.004s, 1 row(s) affected 2012-03-20 15:11:26.957 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1] 2012-03-20 15:11:28.479 (2) [P1T1]: 1 Errors found 2012-03-20 15:11:28.480 (2) [P1T1]: com.google.api.adwords.v201109.cm.AuthenticationError: ApiError: fiedpath=, trigger=4038 apierrortype=AuthenticationError, reason=CUSTOMER_NOT_FOUND 2012-03-20 15:11:28.480 (3) [P1T1]: Caught other/unrecoverable API Error: "com.google.api.adwords.v201109.cm.ApiException" 2012-03-20 15:11:28.481 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:28.482 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:28.483 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.484 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:28.486 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:28.486 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.486 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:28.487 (4) [P1T1]: time=0.0020 2012-03-20 15:11:28.487 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:28.487 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.487 (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.492 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2012-03-20 15:11:28.492 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.492 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2012-03-20 15:11:28.494 (4) [P1T1]: time=0.0050 2012-03-20 15:11:28.494 (4) [P1T1]: Query executed in 0.005s, 1 row(s) affected 2012-03-20 15:11:28.494 (4) [P1T1]: 4038 released searchEngineConnection row 2012-03-20 15:11:28.495 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.495 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:28.497 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:28.497 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.497 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:28.497 (4) [P1T1]: time=0.0020 2012-03-20 15:11:28.498 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:28.498 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:28.499 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.499 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=3) and (`operation`="UpdateCampaignList")) limit 1] 2012-03-20 15:11:28.500 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:28.501 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.501 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:28.501 (4) [P1T1]: time=0.0010 2012-03-20 15:11:28.501 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:28.502 (5) [P1T1]: loading 10 columns from result set: 2012-03-20 15:11:28.502 (5) [P1T1]: loaded column: searchEngineResources.id->210 2012-03-20 15:11:28.502 (5) [P1T1]: loaded column: searchEngineResources.distributionID->3 2012-03-20 15:11:28.503 (5) [P1T1]: loaded column: searchEngineResources.operation->UpdateCampaignList 2012-03-20 15:11:28.503 (5) [P1T1]: loaded column: searchEngineResources.description-> 2012-03-20 15:11:28.503 (5) [P1T1]: loaded column: searchEngineResources.scope->campaign 2012-03-20 15:11:28.504 (5) [P1T1]: loaded column: searchEngineResources.operationClass->creative 2012-03-20 15:11:28.504 (5) [P1T1]: loaded column: searchEngineResources.dailyOpCap->0 2012-03-20 15:11:28.504 (5) [P1T1]: loaded column: searchEngineResources.cmdParamCap->0 2012-03-20 15:11:28.504 (5) [P1T1]: loaded column: searchEngineResources.dailyParamCap->0 2012-03-20 15:11:28.505 (5) [P1T1]: loaded column: searchEngineResources.freqCapSeconds->0 2012-03-20 15:11:28.505 (4) [P1T1]: Record Loaded 2012-03-20 15:11:28.506 (5) [P1T1]: quoteValue(), nothing special about it=>[210], type=class java.lang.Integer 2012-03-20 15:11:28.507 (5) [P1T1]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2012-03-20 15:11:28.507 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.507 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`searchEngineResourceUsage` (`sesystem`.`searchEngineResourceUsage`.`resourceID`,`sesystem`.`searchEngineResourceUsage`.`periodStart`,`sesystem`.`searchEngineResourceUsage`.`holderID`,`sesystem`.`searchEngineResourceUsage`.`lastUsage`,`sesystem`.`searchEngineResourceUsage`.`opCount`) values (210,"2012-03-20 07:00:00","4038",NOW(),1) on duplicate key update `sesystem`.`searchEngineResourceUsage`.`opCount`=`sesystem`.`searchEngineResourceUsage`.`opCount`+1,`sesystem`.`searchEngineResourceUsage`.`lastUsage`=NOW()], genflags=no 2012-03-20 15:11:28.561 (5) [P1T1]: recordAsSubs("db", 54, "P1T1") 2012-03-20 15:11:28.561 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.561 (5) [P1T1]: ProfilerRec.end("db", true): ret=54 2012-03-20 15:11:28.561 (4) [P1T1]: time=0.054 2012-03-20 15:11:28.561 (4) [P1T1]: Query executed in 0.054s, 3 row(s) affected 2012-03-20 15:11:28.561 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:28.561 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:28.562 (4) [P1T1]: Operations for UpdateCampaignList: 0 2012-03-20 15:11:28.562 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:28.562 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:28.562 (4) [P1T1]: Quota units for UpdateCampaignList: 0 2012-03-20 15:11:28.562 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.562 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:28.573 (5) [P1T1]: recordAsSubs("db", 10, "P1T1") 2012-03-20 15:11:28.573 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.573 (5) [P1T1]: ProfilerRec.end("db", true): ret=10 2012-03-20 15:11:28.573 (4) [P1T1]: time=0.01 2012-03-20 15:11:28.573 (4) [P1T1]: Query executed in 0.010s 2012-03-20 15:11:28.574 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.574 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`quotaUsage` values ("5671","210","2012-03-20","0","0") on duplicate key update `quotaUsed`=`quotaUsed`+0,`operations`=`operations`+0], genflags=no 2012-03-20 15:11:28.585 (5) [P1T1]: recordAsSubs("db", 11, "P1T1") 2012-03-20 15:11:28.587 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.587 (5) [P1T1]: ProfilerRec.end("db", true): ret=11 2012-03-20 15:11:28.588 (4) [P1T1]: time=0.011 2012-03-20 15:11:28.588 (4) [P1T1]: Query executed in 0.011s, 2 row(s) affected 2012-03-20 15:11:28.589 (4) [P1T1]: Quota recorded for seUser #5671: 0 quota used for resource ID 210 2012-03-20 15:11:28.591 (3) [P1T1]: Error while updating the collection of campaign budgets! 2012-03-20 15:11:28.594 (2) [P1T1]: Error occurred updating Google budget for seID 18340. 2012-03-20 15:11:28.597 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:28.599 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:28.600 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:28.601 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.601 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:28.698 (5) [P1T1]: recordAsSubs("db", 97, "P1T1") 2012-03-20 15:11:28.699 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.699 (5) [P1T1]: ProfilerRec.end("db", true): ret=97 2012-03-20 15:11:28.699 (4) [P1T1]: time=0.097 2012-03-20 15:11:28.699 (4) [P1T1]: Query executed in 0.097s 2012-03-20 15:11:28.699 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:28.699 (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.723 (5) [P1T1]: recordAsSubs("db", 24, "P1T1") 2012-03-20 15:11:28.724 (5) [P1T1]: addSub("db") 2012-03-20 15:11:28.724 (5) [P1T1]: ProfilerRec.end("db", true): ret=24 2012-03-20 15:11:28.725 (4) [P1T1]: time=0.024 2012-03-20 15:11:28.725 (4) [P1T1]: Query executed in 0.024s, 1 row(s) affected 2012-03-20 15:11:28.725 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1] 2012-03-20 15:11:30.467 (2) [P1T1]: 1 Errors found 2012-03-20 15:11:30.468 (2) [P1T1]: com.google.api.adwords.v201109.cm.AuthenticationError: ApiError: fiedpath=, trigger=4038 apierrortype=AuthenticationError, reason=CUSTOMER_NOT_FOUND 2012-03-20 15:11:30.468 (3) [P1T1]: Caught other/unrecoverable API Error: "com.google.api.adwords.v201109.cm.ApiException" 2012-03-20 15:11:30.468 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:30.469 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:30.470 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.470 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:30.472 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:30.472 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.472 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:30.472 (4) [P1T1]: time=0.0020 2012-03-20 15:11:30.473 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:30.473 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.473 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-03-20 15:11:30",`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:30.477 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-20 15:11:30.477 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.477 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-20 15:11:30.477 (4) [P1T1]: time=0.0040 2012-03-20 15:11:30.478 (4) [P1T1]: Query executed in 0.004s, 1 row(s) affected 2012-03-20 15:11:30.478 (4) [P1T1]: 4038 released searchEngineConnection row 2012-03-20 15:11:30.487 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.487 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:30.488 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:30.488 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.488 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:30.488 (4) [P1T1]: time=0.0010 2012-03-20 15:11:30.488 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:30.489 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:30.490 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.490 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=3) and (`operation`="UpdateCampaignList")) limit 1] 2012-03-20 15:11:30.491 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:30.491 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.491 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:30.491 (4) [P1T1]: time=0.0010 2012-03-20 15:11:30.491 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:30.491 (5) [P1T1]: loading 10 columns from result set: 2012-03-20 15:11:30.492 (5) [P1T1]: loaded column: searchEngineResources.id->210 2012-03-20 15:11:30.492 (5) [P1T1]: loaded column: searchEngineResources.distributionID->3 2012-03-20 15:11:30.492 (5) [P1T1]: loaded column: searchEngineResources.operation->UpdateCampaignList 2012-03-20 15:11:30.492 (5) [P1T1]: loaded column: searchEngineResources.description-> 2012-03-20 15:11:30.492 (5) [P1T1]: loaded column: searchEngineResources.scope->campaign 2012-03-20 15:11:30.492 (5) [P1T1]: loaded column: searchEngineResources.operationClass->creative 2012-03-20 15:11:30.492 (5) [P1T1]: loaded column: searchEngineResources.dailyOpCap->0 2012-03-20 15:11:30.492 (5) [P1T1]: loaded column: searchEngineResources.cmdParamCap->0 2012-03-20 15:11:30.493 (5) [P1T1]: loaded column: searchEngineResources.dailyParamCap->0 2012-03-20 15:11:30.493 (5) [P1T1]: loaded column: searchEngineResources.freqCapSeconds->0 2012-03-20 15:11:30.493 (4) [P1T1]: Record Loaded 2012-03-20 15:11:30.494 (5) [P1T1]: quoteValue(), nothing special about it=>[210], type=class java.lang.Integer 2012-03-20 15:11:30.494 (5) [P1T1]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2012-03-20 15:11:30.494 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.494 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`searchEngineResourceUsage` (`sesystem`.`searchEngineResourceUsage`.`resourceID`,`sesystem`.`searchEngineResourceUsage`.`periodStart`,`sesystem`.`searchEngineResourceUsage`.`holderID`,`sesystem`.`searchEngineResourceUsage`.`lastUsage`,`sesystem`.`searchEngineResourceUsage`.`opCount`) values (210,"2012-03-20 07:00:00","4038",NOW(),1) on duplicate key update `sesystem`.`searchEngineResourceUsage`.`opCount`=`sesystem`.`searchEngineResourceUsage`.`opCount`+1,`sesystem`.`searchEngineResourceUsage`.`lastUsage`=NOW()], genflags=no 2012-03-20 15:11:30.513 (5) [P1T1]: recordAsSubs("db", 19, "P1T1") 2012-03-20 15:11:30.514 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.514 (5) [P1T1]: ProfilerRec.end("db", true): ret=19 2012-03-20 15:11:30.514 (4) [P1T1]: time=0.019 2012-03-20 15:11:30.514 (4) [P1T1]: Query executed in 0.019s, 3 row(s) affected 2012-03-20 15:11:30.514 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:30.514 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:30.514 (4) [P1T1]: Operations for UpdateCampaignList: 0 2012-03-20 15:11:30.514 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:30.514 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:30.514 (4) [P1T1]: Quota units for UpdateCampaignList: 0 2012-03-20 15:11:30.515 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.515 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:30.530 (5) [P1T1]: recordAsSubs("db", 15, "P1T1") 2012-03-20 15:11:30.530 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.531 (5) [P1T1]: ProfilerRec.end("db", true): ret=15 2012-03-20 15:11:30.531 (4) [P1T1]: time=0.015 2012-03-20 15:11:30.531 (4) [P1T1]: Query executed in 0.015s 2012-03-20 15:11:30.532 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.532 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`quotaUsage` values ("5671","210","2012-03-20","0","0") on duplicate key update `quotaUsed`=`quotaUsed`+0,`operations`=`operations`+0], genflags=no 2012-03-20 15:11:30.538 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2012-03-20 15:11:30.538 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.538 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2012-03-20 15:11:30.538 (4) [P1T1]: time=0.0060 2012-03-20 15:11:30.538 (4) [P1T1]: Query executed in 0.006s, 2 row(s) affected 2012-03-20 15:11:30.539 (4) [P1T1]: Quota recorded for seUser #5671: 0 quota used for resource ID 210 2012-03-20 15:11:30.539 (3) [P1T1]: Error while updating the collection of campaign budgets! 2012-03-20 15:11:30.539 (2) [P1T1]: Error occurred updating Google budget for seID 18341. 2012-03-20 15:11:30.539 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:30.540 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:30.540 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:30.540 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.541 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:30.542 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:30.542 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.542 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:30.542 (4) [P1T1]: time=0.0020 2012-03-20 15:11:30.543 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:30.543 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.543 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=5671,`inUse`="true",`holder`="UpdateCampaignList",`holderIdentifier`="4038",`timeStamp`="2012-03-20 15:11:30" 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:30.546 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:30.546 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.546 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:30.546 (4) [P1T1]: time=0.0030 2012-03-20 15:11:30.546 (4) [P1T1]: Query executed in 0.003s, 1 row(s) affected 2012-03-20 15:11:30.546 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1] 2012-03-20 15:11:30.546 (5) [P1T1]: recordAsSubs("google", 0, "P1T1") 2012-03-20 15:11:30.546 (5) [P1T1]: addSub("google") 2012-03-20 15:11:30.546 (5) [P1T1]: ProfilerRec.end("google", true): ret=0 2012-03-20 15:11:30.547 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:30.547 (5) [P1T1]: quoteValue(), nothing special about it=>[5671], type=class java.lang.Integer 2012-03-20 15:11:30.548 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.548 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:30.549 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:30.549 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.550 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:30.550 (4) [P1T1]: time=0.0010 2012-03-20 15:11:30.550 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:30.550 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.550 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-03-20 15:11:30",`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:30.552 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:30.552 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.552 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:30.552 (4) [P1T1]: time=0.0020 2012-03-20 15:11:30.552 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-03-20 15:11:30.552 (4) [P1T1]: 4038 released searchEngineConnection row 2012-03-20 15:11:30.552 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.552 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:30.554 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:30.554 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.554 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:30.554 (4) [P1T1]: time=0.0020 2012-03-20 15:11:30.554 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:30.554 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-20 15:11:30.555 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.555 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=3) and (`operation`="UpdateCampaignList")) limit 1] 2012-03-20 15:11:30.556 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:30.556 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.556 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:30.556 (4) [P1T1]: time=0.0010 2012-03-20 15:11:30.556 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:30.556 (5) [P1T1]: loading 10 columns from result set: 2012-03-20 15:11:30.556 (5) [P1T1]: loaded column: searchEngineResources.id->210 2012-03-20 15:11:30.556 (5) [P1T1]: loaded column: searchEngineResources.distributionID->3 2012-03-20 15:11:30.557 (5) [P1T1]: loaded column: searchEngineResources.operation->UpdateCampaignList 2012-03-20 15:11:30.557 (5) [P1T1]: loaded column: searchEngineResources.description-> 2012-03-20 15:11:30.557 (5) [P1T1]: loaded column: searchEngineResources.scope->campaign 2012-03-20 15:11:30.557 (5) [P1T1]: loaded column: searchEngineResources.operationClass->creative 2012-03-20 15:11:30.557 (5) [P1T1]: loaded column: searchEngineResources.dailyOpCap->0 2012-03-20 15:11:30.557 (5) [P1T1]: loaded column: searchEngineResources.cmdParamCap->0 2012-03-20 15:11:30.557 (5) [P1T1]: loaded column: searchEngineResources.dailyParamCap->0 2012-03-20 15:11:30.557 (5) [P1T1]: loaded column: searchEngineResources.freqCapSeconds->0 2012-03-20 15:11:30.557 (4) [P1T1]: Record Loaded 2012-03-20 15:11:30.558 (5) [P1T1]: quoteValue(), nothing special about it=>[210], type=class java.lang.Integer 2012-03-20 15:11:30.558 (5) [P1T1]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2012-03-20 15:11:30.559 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.559 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`searchEngineResourceUsage` (`sesystem`.`searchEngineResourceUsage`.`resourceID`,`sesystem`.`searchEngineResourceUsage`.`periodStart`,`sesystem`.`searchEngineResourceUsage`.`holderID`,`sesystem`.`searchEngineResourceUsage`.`lastUsage`,`sesystem`.`searchEngineResourceUsage`.`opCount`) values (210,"2012-03-20 07:00:00","4038",NOW(),1) on duplicate key update `sesystem`.`searchEngineResourceUsage`.`opCount`=`sesystem`.`searchEngineResourceUsage`.`opCount`+1,`sesystem`.`searchEngineResourceUsage`.`lastUsage`=NOW()], genflags=no 2012-03-20 15:11:30.561 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:30.561 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.561 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:30.561 (4) [P1T1]: time=0.0020 2012-03-20 15:11:30.561 (4) [P1T1]: Query executed in 0.002s, 3 row(s) affected 2012-03-20 15:11:30.561 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:30.561 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:30.562 (4) [P1T1]: Operations for UpdateCampaignList: 0 2012-03-20 15:11:30.562 (5) [P1T1]: parseInteger->[0] 2012-03-20 15:11:30.562 (5) [P1T1]: parseInteger<-[0] 2012-03-20 15:11:30.562 (4) [P1T1]: Quota units for UpdateCampaignList: 0 2012-03-20 15:11:30.562 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.562 (4) [P1T1]: sesystem: SQL->[select 1] 2012-03-20 15:11:30.563 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:30.563 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.563 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:30.563 (4) [P1T1]: time=0.0010 2012-03-20 15:11:30.563 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:30.564 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.564 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`quotaUsage` values ("5671","210","2012-03-20","0","0") on duplicate key update `quotaUsed`=`quotaUsed`+0,`operations`=`operations`+0], genflags=no 2012-03-20 15:11:30.566 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:30.566 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.566 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:30.566 (4) [P1T1]: time=0.0020 2012-03-20 15:11:30.566 (4) [P1T1]: Query executed in 0.002s, 2 row(s) affected 2012-03-20 15:11:30.566 (4) [P1T1]: Quota recorded for seUser #5671: 0 quota used for resource ID 210 2012-03-20 15:11:30.567 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.567 (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:30.568 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:30.568 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.569 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:30.569 (4) [P1T1]: time=0.0010 2012-03-20 15:11:30.569 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:30.569 (5) [P1T1]: loading 9 columns from result set: 2012-03-20 15:11:30.569 (5) [P1T1]: loaded column: dataAvailability.id->165504 2012-03-20 15:11:30.569 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-21 2012-03-20 15:11:30.570 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-20 15:11:30.570 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-20 15:11:16.0 2012-03-20 15:11:30.570 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5965 2012-03-20 15:11:30.570 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2012-03-20 15:11:30.570 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-20 15:11:30.570 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-20 15:11:30.570 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-20 15:11:30.571 (4) [P1T1]: Record Loaded 2012-03-20 15:11:30.571 (5) [P1T1]: quoteValue(), nothing special about it=>[5965], type=class java.lang.Integer 2012-03-20 15:11:30.572 (5) [P1T1]: quoteValue(), nothing special about it=>[165504], type=class java.lang.Integer 2012-03-20 15:11:30.572 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.572 (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:30",165504)], genflags=yes 2012-03-20 15:11:30.574 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:30.574 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.574 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:30.574 (4) [P1T1]: time=0.0020 2012-03-20 15:11:30.574 (4) [P1T1]: Query executed in 0.002s, 2 row(s) affected 2012-03-20 15:11:30.576 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.576 (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:30")], genflags=yes 2012-03-20 15:11:30.584 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2012-03-20 15:11:30.585 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.585 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2012-03-20 15:11:30.586 (4) [P1T1]: time=0.0080 2012-03-20 15:11:30.586 (4) [P1T1]: Query executed in 0.008s, 1 row(s) affected 2012-03-20 15:11:30.591 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:30.591 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5966") and (`date`="2012-03-21 00:00:00")) limit 1] 2012-03-20 15:11:30.600 (5) [P1T1]: recordAsSubs("db", 9, "P1T1") 2012-03-20 15:11:30.600 (5) [P1T1]: addSub("db") 2012-03-20 15:11:30.600 (5) [P1T1]: ProfilerRec.end("db", true): ret=9 2012-03-20 15:11:30.600 (4) [P1T1]: time=0.0090 2012-03-20 15:11:30.600 (4) [P1T1]: Query executed in 0.009s 2012-03-20 15:11:30.600 (5) [P1T1]: loading 9 columns from result set: 2012-03-20 15:11:30.600 (5) [P1T1]: loaded column: dataAvailability.id->165505 2012-03-20 15:11:30.600 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-21 2012-03-20 15:11:30.600 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-20 15:11:30.601 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-20 15:11:16.0 2012-03-20 15:11:30.601 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5966 2012-03-20 15:11:30.601 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2012-03-20 15:11:30.601 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-20 15:11:30.601 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-20 15:11:32.123 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-20 15:11:32.124 (4) [P1T1]: Record Loaded 2012-03-20 15:11:32.126 (5) [P1T1]: quoteValue(), nothing special about it=>[5966], type=class java.lang.Integer 2012-03-20 15:11:32.127 (5) [P1T1]: quoteValue(), nothing special about it=>[165505], type=class java.lang.Integer 2012-03-20 15:11:32.127 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:32.127 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5966,"success","2012-03-21","2012-03-20 15:11:30",165505)], genflags=yes 2012-03-20 15:11:32.138 (5) [P1T1]: recordAsSubs("db", 11, "P1T1") 2012-03-20 15:11:32.139 (5) [P1T1]: addSub("db") 2012-03-20 15:11:32.139 (5) [P1T1]: ProfilerRec.end("db", true): ret=11 2012-03-20 15:11:32.139 (4) [P1T1]: time=0.011 2012-03-20 15:11:32.139 (4) [P1T1]: Query executed in 0.011s, 2 row(s) affected 2012-03-20 15:11:32.140 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:32.140 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5966","success","2012-03-21 00:00:00","2012-03-20 15:11:30")], genflags=yes 2012-03-20 15:11:32.141 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:32.142 (5) [P1T1]: addSub("db") 2012-03-20 15:11:32.142 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:32.142 (4) [P1T1]: time=0.0010 2012-03-20 15:11:32.142 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2012-03-20 15:11:32.143 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:32.143 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5967") and (`date`="2012-03-21 00:00:00")) limit 1] 2012-03-20 15:11:32.145 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:32.145 (5) [P1T1]: addSub("db") 2012-03-20 15:11:32.145 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:32.145 (4) [P1T1]: time=0.0020 2012-03-20 15:11:32.145 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:32.145 (5) [P1T1]: loading 9 columns from result set: 2012-03-20 15:11:32.145 (5) [P1T1]: loaded column: dataAvailability.id->165506 2012-03-20 15:11:32.145 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-21 2012-03-20 15:11:32.146 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-20 15:11:32.146 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-20 15:11:16.0 2012-03-20 15:11:32.146 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5967 2012-03-20 15:11:32.146 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2012-03-20 15:11:32.146 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-20 15:11:32.146 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-20 15:11:32.146 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-20 15:11:32.147 (4) [P1T1]: Record Loaded 2012-03-20 15:11:32.147 (5) [P1T1]: quoteValue(), nothing special about it=>[5967], type=class java.lang.Integer 2012-03-20 15:11:32.147 (5) [P1T1]: quoteValue(), nothing special about it=>[165506], type=class java.lang.Integer 2012-03-20 15:11:32.147 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:32.148 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5967,"success","2012-03-21","2012-03-20 15:11:32",165506)], genflags=yes 2012-03-20 15:11:32.150 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:32.150 (5) [P1T1]: addSub("db") 2012-03-20 15:11:32.150 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:32.150 (4) [P1T1]: time=0.0030 2012-03-20 15:11:32.150 (4) [P1T1]: Query executed in 0.003s, 2 row(s) affected 2012-03-20 15:11:32.151 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:32.151 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5967","success","2012-03-21 00:00:00","2012-03-20 15:11:32")], genflags=yes 2012-03-20 15:11:32.153 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:32.153 (5) [P1T1]: addSub("db") 2012-03-20 15:11:32.153 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:32.153 (4) [P1T1]: time=0.0020 2012-03-20 15:11:32.153 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-03-20 15:11:32.154 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:32.154 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5968") and (`date`="2012-03-21 00:00:00")) limit 1] 2012-03-20 15:11:32.156 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-03-20 15:11:32.156 (5) [P1T1]: addSub("db") 2012-03-20 15:11:32.156 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:32.156 (4) [P1T1]: time=0.0020 2012-03-20 15:11:32.156 (4) [P1T1]: Query executed in 0.002s 2012-03-20 15:11:32.156 (5) [P1T1]: loading 9 columns from result set: 2012-03-20 15:11:32.156 (5) [P1T1]: loaded column: dataAvailability.id->165507 2012-03-20 15:11:32.156 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-21 2012-03-20 15:11:32.157 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-20 15:11:32.157 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-20 15:11:16.0 2012-03-20 15:11:32.157 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5968 2012-03-20 15:11:32.157 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2012-03-20 15:11:32.157 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-20 15:11:32.157 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-20 15:11:32.157 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-20 15:11:32.157 (4) [P1T1]: Record Loaded 2012-03-20 15:11:32.158 (5) [P1T1]: quoteValue(), nothing special about it=>[5968], type=class java.lang.Integer 2012-03-20 15:11:32.158 (5) [P1T1]: quoteValue(), nothing special about it=>[165507], type=class java.lang.Integer 2012-03-20 15:11:32.158 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:32.158 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5968,"success","2012-03-21","2012-03-20 15:11:32",165507)], genflags=yes 2012-03-20 15:11:32.161 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-03-20 15:11:32.161 (5) [P1T1]: addSub("db") 2012-03-20 15:11:32.161 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-03-20 15:11:32.161 (4) [P1T1]: time=0.0030 2012-03-20 15:11:32.161 (4) [P1T1]: Query executed in 0.003s, 2 row(s) affected 2012-03-20 15:11:32.162 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:32.162 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5968","success","2012-03-21 00:00:00","2012-03-20 15:11:32")], genflags=yes 2012-03-20 15:11:32.205 (5) [P1T1]: recordAsSubs("db", 43, "P1T1") 2012-03-20 15:11:32.205 (5) [P1T1]: addSub("db") 2012-03-20 15:11:32.205 (5) [P1T1]: ProfilerRec.end("db", true): ret=43 2012-03-20 15:11:32.205 (4) [P1T1]: time=0.043 2012-03-20 15:11:32.205 (4) [P1T1]: Query executed in 0.043s, 1 row(s) affected 2012-03-20 15:11:32.206 (3) [P1T1]: Finished applying algorithm [SABB] for account [5221] in distributions [3] 2012-03-20 15:11:32.206 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-20 15:11:32.206 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.5221')] 2012-03-20 15:11:32.207 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-03-20 15:11:32.207 (5) [P1T1]: addSub("db") 2012-03-20 15:11:32.207 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-03-20 15:11:32.207 (4) [P1T1]: time=0.0010 2012-03-20 15:11:32.208 (4) [P1T1]: Query executed in 0.001s 2012-03-20 15:11:32.208 (3) [P1T1]: Released migrator lock for Account ID #5221 2012-03-20 15:11:32.208 (4) [P1T1]: Returning Object to Pool 2012-03-20 15:11:32.426 (4) [P1T1]: Returning Object to Pool 2012-03-20 15:11:32.426 (4) [P1T1]: Returning Object to Pool 2012-03-20 15:11:32.426 (3) [P1T1]: Completed Account ID #5221: alok-n63a 2012-03-20 15:11:32.427 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-20 15:11:32.428 (3) [main]: ------------AdMax Summarizer done 2012-03-20 15:11:32.428 (3) [main]: =============== Completed AdMax Summarizer ================ 2012-03-20 15:11:32.428 (4) [main]: DataCache: Found key global-logging 2012-03-20 15:11:32.428 (4) [main]: Took Existing Object from Pool 2012-03-20 15:11:32.429 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-20 15:11:32.429 (4) [main]: spike: SQL->[select @@version] 2012-03-20 15:11:32.431 (2) [main]: Warning(s) detected in statement [select @@version] executed by user [spike] 2012-03-20 15:11:32.431 (2) [main]: Table 'logging.processHistory' doesn't exist (1146) 2012-03-20 15:11:32.431 (5) [main]: recordAsSubs("db", 2, "main") 2012-03-20 15:11:32.431 (5) [main]: addSub("db") 2012-03-20 15:11:32.432 (5) [main]: ProfilerRec.end("db", true): ret=2 2012-03-20 15:11:32.432 (4) [main]: time=0.0020 2012-03-20 15:11:32.432 (4) [main]: Query executed in 0.002s 2012-03-20 15:11:32.432 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-20 15:11:32.433 (3) [main]: Could not save process history stop 2012-03-20 15:11:32.433 (4) [main]: Returning Object to Pool 2012-03-20 15:11:32.433 (3) [main]: =============== Stats ================ 2012-03-20 15:11:32.433 (3) [main]: --- Process --- 2012-03-20 15:11:32.433 (3) [main]: 2012-03-20 15:11:32.434 (3) [main]: ABU Process(start): Tue Mar 20 15:11:14 GMT 2012 2012-03-20 15:11:32.434 (3) [main]: ABU Process(stop): Tue Mar 20 15:11:32 GMT 2012 2012-03-20 15:11:32.434 (3) [main]: 2012-03-20 15:11:32.434 (3) [main]: --- Accounts --- 2012-03-20 15:11:32.435 (3) [main]: 2012-03-20 15:11:32.435 (3) [main]: Accounts Processed: 1 2012-03-20 15:11:32.435 (3) [main]: Accounts Skipped: 0 2012-03-20 15:11:32.435 (3) [main]: Accounts Processed Successfully: 1 2012-03-20 15:11:32.435 (3) [main]: 2012-03-20 15:11:32.435 (3) [main]: --- Adverts --- 2012-03-20 15:11:32.436 (3) [main]: 2012-03-20 15:11:32.436 (3) [main]: Adverts Processed: 2 2012-03-20 15:11:32.436 (3) [main]: Adverts Processed Successfully: 2 2012-03-20 15:11:32.436 (3) [main]: Advert Budgets Capped: 0 2012-03-20 15:11:32.436 (3) [main]: 2012-03-20 15:11:32.436 (3) [main]: --- Campaigns --- 2012-03-20 15:11:32.436 (3) [main]: 2012-03-20 15:11:32.437 (3) [main]: Campaigns Processed: 4 2012-03-20 15:11:32.437 (3) [main]: Campaigns Processed Successfully: 4 2012-03-20 15:11:32.437 (3) [main]: 2012-03-20 15:11:32.437 (3) [main]: --- Budget/Spend --- 2012-03-20 15:11:32.437 (3) [main]: 2012-03-20 15:11:32.437 (3) [main]: Campaign Budgets Updated: 4 2012-03-20 15:11:32.438 (3) [main]: Campaign Budgets Sent To Google: 4 2012-03-20 15:11:32.438 (3) [main]: 2012-03-20 15:11:32.438 (3) [main]: Spend Total: 0.90000004 2012-03-20 15:11:32.438 (3) [main]: Common Carryover Total: 55.035484 2012-03-20 15:11:32.438 (5) [main]: ProfilerRec.end("AdMaxSummarizer", false): ret=17824 2012-03-20 15:11:32.439 (4) [main]: time=17.824 2012-03-20 15:11:32.439 (3) [main]: AdMaxSummarizer: 17.824s 2012-03-20 15:11:32.439 (3) [main]: by key: 2012-03-20 15:11:32.439 (4) [main]: time=0.0 2012-03-20 15:11:32.439 (3) [main]: google: 0.000s 2012-03-20 15:11:32.439 (4) [main]: time=0.733 2012-03-20 15:11:32.439 (3) [main]: db: 0.733s 2012-03-20 15:11:32.439 (3) [main]: by thread: 2012-03-20 15:11:32.439 (4) [main]: time=0.046 2012-03-20 15:11:32.440 (3) [main]: main: 0.046s 2012-03-20 15:11:32.440 (4) [main]: time=0.687 2012-03-20 15:11:32.440 (3) [main]: P1T1: 0.687s 2012-03-20 15:11:32.440 (4) [main]: time=17.091 2012-03-20 15:11:32.440 (3) [main]: other: 17.091s