tsaapp@yell-ec-xml:/usr/local/tsa/bidmgr$ ./admax.sh -d5 -T2012-03-22 -a5221 pid 24424's current affinity list: 0 pid 24424's new affinity list: 0 pid 24424's current affinity list: 0 sched_setaffinity: Invalid argument failed to set pid 24424's affinity. 2012-03-26 10:56:43.758 (3) [main]: Debug Level set to 5 2012-03-26 10:56:43.759 (3) [main]: AdMax Summarizer parameters: [Ljava.lang.String;@b61d36b 2012-03-26 10:56:43.837 (5) [main]: ProfilerRec.start("AdMaxSummarizer",false) in Thread [main] 2012-03-26 10:56:43.847 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-03-26 10:56:44.176 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:44.193 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-26 10:56:44.195 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-logging")) limit 1] 2012-03-26 10:56:44.258 (5) [main]: recordAsSubs("db", 62, "main") 2012-03-26 10:56:44.258 (5) [main]: addSub("db") 2012-03-26 10:56:44.259 (5) [main]: ProfilerRec.end("db", true): ret=62 2012-03-26 10:56:44.261 (4) [main]: time=0.062 2012-03-26 10:56:44.261 (4) [main]: Query executed in 0.062s 2012-03-26 10:56:44.265 (5) [main]: loading 8 columns from result set: 2012-03-26 10:56:44.265 (5) [main]: loaded column: databaseInstances.id->4 2012-03-26 10:56:44.266 (5) [main]: loaded column: databaseInstances.name->global-logging 2012-03-26 10:56:44.276 (5) [main]: loaded column: databaseInstances.description->Global Logging Tables 2012-03-26 10:56:44.277 (5) [main]: loaded column: databaseInstances.type->mysql 2012-03-26 10:56:44.277 (5) [main]: loaded column: databaseInstances.database->logging 2012-03-26 10:56:44.278 (5) [main]: loaded column: databaseInstances.host->logging-01-write 2012-03-26 10:56:44.278 (5) [main]: loaded column: databaseInstances.port->3306 2012-03-26 10:56:44.278 (5) [main]: loaded column: databaseInstances.access->rw 2012-03-26 10:56:44.279 (4) [main]: Record Loaded 2012-03-26 10:56:44.279 (4) [main]: DataCache: put key global-logging 2012-03-26 10:56:44.288 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:44.295 (3) [main]: DatabasePool with a limit of 18 created 2012-03-26 10:56:44.393 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2012-03-26 10:56:44.452 (4) [main]: opened [jdbc:mysql://logging-01-write:3306/logging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:44.453 (4) [main]: Created new Object 2012-03-26 10:56:44.454 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-26 10:56:44.454 (4) [main]: spike: SQL->[select @@version] 2012-03-26 10:56:44.460 (5) [main]: recordAsSubs("db", 6, "main") 2012-03-26 10:56:44.461 (5) [main]: addSub("db") 2012-03-26 10:56:44.461 (5) [main]: ProfilerRec.end("db", true): ret=6 2012-03-26 10:56:44.461 (4) [main]: time=0.0060 2012-03-26 10:56:44.462 (4) [main]: Query executed in 0.006s 2012-03-26 10:56:44.462 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-26 10:56:44.486 (4) [main]: preparing SQL statement [insert into logging.processHistory (processID, startTime) values (?,?)], genflags=yes 2012-03-26 10:56:44.523 (3) [main]: Could not save process history start 2012-03-26 10:56:44.523 (4) [main]: Returning Object to Pool 2012-03-26 10:56:44.524 (3) [main]: =============== Starting AdMax Summarizer ================ 2012-03-26 10:56:44.524 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-03-26 10:56:44.524 (3) [main]: ----------------AdMax Summarizer starting 2012-03-26 10:56:44.590 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:44.593 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-26 10:56:44.593 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (5221))) order by rand()] 2012-03-26 10:56:44.599 (5) [main]: recordAsSubs("db", 6, "main") 2012-03-26 10:56:44.599 (5) [main]: addSub("db") 2012-03-26 10:56:44.600 (5) [main]: ProfilerRec.end("db", true): ret=6 2012-03-26 10:56:44.600 (4) [main]: time=0.0060 2012-03-26 10:56:44.601 (4) [main]: Query executed in 0.006s 2012-03-26 10:56:44.601 (5) [main]: loading 19 columns from result set: 2012-03-26 10:56:44.602 (5) [main]: loaded column: accounts.id->5221 2012-03-26 10:56:44.602 (5) [main]: loaded column: accounts.description->alok-n63a 2012-03-26 10:56:44.603 (5) [main]: loaded column: accounts.tier->1 2012-03-26 10:56:44.603 (5) [main]: loaded column: accounts.priority->50 2012-03-26 10:56:44.603 (5) [main]: loaded column: accounts.reportClicksOut->false 2012-03-26 10:56:44.604 (5) [main]: loaded column: accounts.reportConversions->false 2012-03-26 10:56:44.604 (5) [main]: loaded column: accounts.conversionTypes->paid 2012-03-26 10:56:44.604 (5) [main]: loaded column: accounts.isBidManaged->true 2012-03-26 10:56:44.605 (5) [main]: loaded column: accounts.isActive->true 2012-03-26 10:56:44.605 (5) [main]: loaded column: accounts.perfMetric->cpa 2012-03-26 10:56:44.605 (5) [main]: loaded column: accounts.providesConversionData->true 2012-03-26 10:56:44.606 (5) [main]: loaded column: accounts.addConversionData->false 2012-03-26 10:56:44.606 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2012-03-26 10:56:44.606 (5) [main]: loaded column: accounts.hideNullSources->false 2012-03-26 10:56:44.606 (5) [main]: loaded column: accounts.nowTime->null 2012-03-26 10:56:44.621 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2012-03-26 10:56:44.622 (5) [main]: loaded column: accounts.databaseInstance->1 2012-03-26 10:56:44.622 (5) [main]: loaded column: accounts.warehouseInstance->1 2012-03-26 10:56:44.622 (5) [main]: loaded column: accounts.isOnline->true 2012-03-26 10:56:44.634 (3) [P1T1]: Starting Account ID #5221: alok-n63a 2012-03-26 10:56:44.636 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-26 10:56:44.714 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:44.715 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-26 10:56:44.716 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:44.716 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=5221) limit 1] 2012-03-26 10:56:44.726 (5) [P1T1]: recordAsSubs("db", 9, "P1T1") 2012-03-26 10:56:44.726 (5) [P1T1]: addSub("db") 2012-03-26 10:56:44.726 (5) [P1T1]: ProfilerRec.end("db", true): ret=9 2012-03-26 10:56:44.727 (4) [P1T1]: time=0.0090 2012-03-26 10:56:44.727 (4) [P1T1]: Query executed in 0.009s 2012-03-26 10:56:44.727 (5) [P1T1]: loading 19 columns from result set: 2012-03-26 10:56:44.727 (5) [P1T1]: loaded column: accounts.id->5221 2012-03-26 10:56:44.728 (5) [P1T1]: loaded column: accounts.description->alok-n63a 2012-03-26 10:56:44.728 (5) [P1T1]: loaded column: accounts.tier->1 2012-03-26 10:56:44.728 (5) [P1T1]: loaded column: accounts.priority->50 2012-03-26 10:56:44.729 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2012-03-26 10:56:44.729 (5) [P1T1]: loaded column: accounts.reportConversions->false 2012-03-26 10:56:44.729 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2012-03-26 10:56:44.729 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2012-03-26 10:56:44.730 (5) [P1T1]: loaded column: accounts.isActive->true 2012-03-26 10:56:44.730 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2012-03-26 10:56:44.731 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2012-03-26 10:56:44.732 (5) [P1T1]: loaded column: accounts.addConversionData->false 2012-03-26 10:56:44.732 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2012-03-26 10:56:44.732 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2012-03-26 10:56:44.733 (5) [P1T1]: loaded column: accounts.nowTime->null 2012-03-26 10:56:44.733 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2012-03-26 10:56:44.733 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2012-03-26 10:56:44.733 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2012-03-26 10:56:44.734 (5) [P1T1]: loaded column: accounts.isOnline->true 2012-03-26 10:56:44.734 (4) [P1T1]: Record Loaded 2012-03-26 10:56:44.734 (4) [P1T1]: DataCache: put key acct-st-tracker 5221 2012-03-26 10:56:44.735 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:44.735 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-1")) limit 1] 2012-03-26 10:56:44.739 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-26 10:56:44.739 (5) [P1T1]: addSub("db") 2012-03-26 10:56:44.740 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-26 10:56:44.740 (4) [P1T1]: time=0.0040 2012-03-26 10:56:44.740 (4) [P1T1]: Query executed in 0.004s 2012-03-26 10:56:44.740 (5) [P1T1]: loading 8 columns from result set: 2012-03-26 10:56:44.740 (5) [P1T1]: loaded column: databaseInstances.id->15 2012-03-26 10:56:44.741 (5) [P1T1]: loaded column: databaseInstances.name->acct-st-tracker-1 2012-03-26 10:56:44.741 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Catch-all database 2012-03-26 10:56:44.743 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-03-26 10:56:44.743 (5) [P1T1]: loaded column: databaseInstances.database->st-tracker 2012-03-26 10:56:44.743 (5) [P1T1]: loaded column: databaseInstances.host->acctdb-01-write 2012-03-26 10:56:44.744 (5) [P1T1]: loaded column: databaseInstances.port->3306 2012-03-26 10:56:44.745 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-03-26 10:56:44.745 (4) [P1T1]: Record Loaded 2012-03-26 10:56:44.745 (4) [P1T1]: DataCache: put key acct-st-tracker-1 2012-03-26 10:56:44.748 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:44.748 (3) [P1T1]: DatabasePool with a limit of 18 created 2012-03-26 10:56:44.812 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:44.813 (4) [P1T1]: Created new Object 2012-03-26 10:56:44.813 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:44.814 (4) [P1T1]: spike: SQL->[select @@version] 2012-03-26 10:56:44.819 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2012-03-26 10:56:44.819 (5) [P1T1]: addSub("db") 2012-03-26 10:56:44.819 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2012-03-26 10:56:44.820 (4) [P1T1]: time=0.0060 2012-03-26 10:56:44.820 (4) [P1T1]: Query executed in 0.006s 2012-03-26 10:56:44.820 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-26 10:56:44.820 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-26 10:56:44.821 (3) [P1T1]: DatabasePool with a limit of 18 created 2012-03-26 10:56:44.909 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:44.909 (4) [P1T1]: Created new Object 2012-03-26 10:56:44.909 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:44.909 (4) [P1T1]: spike: SQL->[select @@version] 2012-03-26 10:56:44.913 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-26 10:56:44.914 (5) [P1T1]: addSub("db") 2012-03-26 10:56:44.914 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-26 10:56:44.914 (4) [P1T1]: time=0.0040 2012-03-26 10:56:44.914 (4) [P1T1]: Query executed in 0.004s 2012-03-26 10:56:44.914 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-26 10:56:44.914 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-03-26 10:56:45.023 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:45.025 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.025 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-staging")) limit 1] 2012-03-26 10:56:45.031 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2012-03-26 10:56:45.031 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.032 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2012-03-26 10:56:45.032 (4) [P1T1]: time=0.0060 2012-03-26 10:56:45.032 (4) [P1T1]: Query executed in 0.006s 2012-03-26 10:56:45.032 (5) [P1T1]: loading 8 columns from result set: 2012-03-26 10:56:45.033 (5) [P1T1]: loaded column: databaseInstances.id->3 2012-03-26 10:56:45.033 (5) [P1T1]: loaded column: databaseInstances.name->global-staging 2012-03-26 10:56:45.034 (5) [P1T1]: loaded column: databaseInstances.description->Global Staging Tables 2012-03-26 10:56:45.034 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-03-26 10:56:45.034 (5) [P1T1]: loaded column: databaseInstances.database->staging 2012-03-26 10:56:45.034 (5) [P1T1]: loaded column: databaseInstances.host->staging-01-write 2012-03-26 10:56:45.035 (5) [P1T1]: loaded column: databaseInstances.port->3306 2012-03-26 10:56:45.035 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-03-26 10:56:45.035 (4) [P1T1]: Record Loaded 2012-03-26 10:56:45.036 (4) [P1T1]: DataCache: put key global-staging 2012-03-26 10:56:45.039 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:45.039 (3) [P1T1]: DatabasePool with a limit of 18 created 2012-03-26 10:56:45.239 (4) [P1T1]: opened [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:45.239 (4) [P1T1]: Created new Object 2012-03-26 10:56:45.239 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.239 (4) [P1T1]: spike: SQL->[select @@version] 2012-03-26 10:56:45.246 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-03-26 10:56:45.246 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.247 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-03-26 10:56:45.247 (4) [P1T1]: time=0.0070 2012-03-26 10:56:45.247 (4) [P1T1]: Query executed in 0.007s 2012-03-26 10:56:45.247 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-26 10:56:45.252 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.252 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.5221', 600)] 2012-03-26 10:56:45.260 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2012-03-26 10:56:45.261 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.261 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2012-03-26 10:56:45.261 (4) [P1T1]: time=0.0080 2012-03-26 10:56:45.262 (4) [P1T1]: Query executed in 0.008s 2012-03-26 10:56:45.262 (3) [P1T1]: Got migrator lock for Account ID #5221 2012-03-26 10:56:45.269 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-26 10:56:45.425 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.427 (4) [P1T1]: spike: SQL->[select * from `settings` where ((((`settings`.`scope`="accounts")) and ((`settings`.`scopeId`=5221))))] 2012-03-26 10:56:45.433 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-03-26 10:56:45.434 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.434 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-03-26 10:56:45.435 (4) [P1T1]: time=0.0070 2012-03-26 10:56:45.435 (4) [P1T1]: Query executed in 0.007s 2012-03-26 10:56:45.442 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.443 (4) [P1T1]: spike: SQL->[select * from `settingDefaults` where (`settingDefaults`.`scope`="accounts")] 2012-03-26 10:56:45.451 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2012-03-26 10:56:45.452 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.452 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2012-03-26 10:56:45.452 (4) [P1T1]: time=0.0080 2012-03-26 10:56:45.453 (4) [P1T1]: Query executed in 0.008s 2012-03-26 10:56:45.458 (4) [P1T1]: DataCache: put key accounts 5221 2012-03-26 10:56:45.515 (4) [P1T1]: DataCache: Found key accounts 5221 2012-03-26 10:56:45.516 (4) [P1T1]: Settings.getSettings: loaded from cache (key=accounts 5221) 2012-03-26 10:56:45.517 (3) [P1T1]: Applying algorithm [SABB] for Account ID #5221 in distributions [3] 2012-03-26 10:56:45.520 (3) [P1T1]: Processing data for Thu Mar 22 00:00:00 GMT 2012 2012-03-26 10:56:45.546 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-03-26 10:56:45.548 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.549 (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-26 10:56:45.573 (5) [P1T1]: recordAsSubs("db", 25, "P1T1") 2012-03-26 10:56:45.575 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.575 (5) [P1T1]: ProfilerRec.end("db", true): ret=25 2012-03-26 10:56:45.576 (4) [P1T1]: time=0.025 2012-03-26 10:56:45.775 (4) [P1T1]: Query executed in 0.025s 2012-03-26 10:56:45.803 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-26 10:56:45.805 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.806 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15911")) limit 1] 2012-03-26 10:56:45.813 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-03-26 10:56:45.814 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.814 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-03-26 10:56:45.815 (4) [P1T1]: time=0.0070 2012-03-26 10:56:45.815 (4) [P1T1]: Query executed in 0.007s 2012-03-26 10:56:45.816 (5) [P1T1]: loading 4 columns from result set: 2012-03-26 10:56:45.816 (5) [P1T1]: loaded column: dataSources.id->5966 2012-03-26 10:56:45.817 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-26 10:56:45.818 (5) [P1T1]: loaded column: dataSources.typeID->15911 2012-03-26 10:56:45.818 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-26 10:56:45.818 (4) [P1T1]: Record Loaded 2012-03-26 10:56:45.820 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-26 10:56:45.821 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.821 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15931")) limit 1] 2012-03-26 10:56:45.827 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2012-03-26 10:56:45.827 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.827 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2012-03-26 10:56:45.828 (4) [P1T1]: time=0.0060 2012-03-26 10:56:45.828 (4) [P1T1]: Query executed in 0.006s 2012-03-26 10:56:45.828 (5) [P1T1]: loading 4 columns from result set: 2012-03-26 10:56:45.829 (5) [P1T1]: loaded column: dataSources.id->5965 2012-03-26 10:56:45.829 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-26 10:56:45.829 (5) [P1T1]: loaded column: dataSources.typeID->15931 2012-03-26 10:56:45.830 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-26 10:56:45.830 (4) [P1T1]: Record Loaded 2012-03-26 10:56:45.834 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-26 10:56:45.835 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.835 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15901")) limit 1] 2012-03-26 10:56:45.840 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2012-03-26 10:56:45.840 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.841 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2012-03-26 10:56:45.841 (4) [P1T1]: time=0.0050 2012-03-26 10:56:45.841 (4) [P1T1]: Query executed in 0.005s 2012-03-26 10:56:45.841 (5) [P1T1]: loading 4 columns from result set: 2012-03-26 10:56:45.842 (5) [P1T1]: loaded column: dataSources.id->5968 2012-03-26 10:56:45.842 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-26 10:56:45.843 (5) [P1T1]: loaded column: dataSources.typeID->15901 2012-03-26 10:56:45.843 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-26 10:56:45.843 (4) [P1T1]: Record Loaded 2012-03-26 10:56:45.844 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-26 10:56:45.845 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.845 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=5221) and (`type`="admax") and (`typeID`="15921")) limit 1] 2012-03-26 10:56:45.852 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-03-26 10:56:45.852 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.852 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-03-26 10:56:45.853 (4) [P1T1]: time=0.0070 2012-03-26 10:56:45.853 (4) [P1T1]: Query executed in 0.007s 2012-03-26 10:56:45.853 (5) [P1T1]: loading 4 columns from result set: 2012-03-26 10:56:45.853 (5) [P1T1]: loaded column: dataSources.id->5967 2012-03-26 10:56:45.854 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-26 10:56:45.854 (5) [P1T1]: loaded column: dataSources.typeID->15921 2012-03-26 10:56:45.855 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-26 10:56:45.855 (4) [P1T1]: Record Loaded 2012-03-26 10:56:45.856 (5) [P1T1]: quoteValue(), nothing special about it=>[5221], type=class java.lang.Integer 2012-03-26 10:56:45.857 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:45.857 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`dataSources`.`type`="admax") and (`dataSources`.`accountID`=5221))] 2012-03-26 10:56:45.863 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2012-03-26 10:56:45.863 (5) [P1T1]: addSub("db") 2012-03-26 10:56:45.863 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2012-03-26 10:56:45.863 (4) [P1T1]: time=0.0060 2012-03-26 10:56:45.864 (4) [P1T1]: Query executed in 0.006s 2012-03-26 10:56:45.864 (5) [P1T1]: loading 4 columns from result set: 2012-03-26 10:56:45.864 (5) [P1T1]: loaded column: dataSources.id->5965 2012-03-26 10:56:45.865 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-26 10:56:46.610 (5) [P1T1]: loaded column: dataSources.typeID->15931 2012-03-26 10:56:46.610 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-26 10:56:46.610 (5) [P1T1]: loading 4 columns from result set: 2012-03-26 10:56:46.611 (5) [P1T1]: loaded column: dataSources.id->5966 2012-03-26 10:56:46.611 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-26 10:56:46.611 (5) [P1T1]: loaded column: dataSources.typeID->15911 2012-03-26 10:56:46.611 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-26 10:56:46.612 (5) [P1T1]: loading 4 columns from result set: 2012-03-26 10:56:46.612 (5) [P1T1]: loaded column: dataSources.id->5967 2012-03-26 10:56:46.612 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-26 10:56:46.612 (5) [P1T1]: loaded column: dataSources.typeID->15921 2012-03-26 10:56:46.613 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-26 10:56:46.613 (5) [P1T1]: loading 4 columns from result set: 2012-03-26 10:56:46.613 (5) [P1T1]: loaded column: dataSources.id->5968 2012-03-26 10:56:46.613 (5) [P1T1]: loaded column: dataSources.type->admax 2012-03-26 10:56:46.613 (5) [P1T1]: loaded column: dataSources.typeID->15901 2012-03-26 10:56:46.614 (5) [P1T1]: loaded column: dataSources.accountID->5221 2012-03-26 10:56:46.618 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:46.619 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5965") and (`date`="2012-03-22 00:00:00")) limit 1] 2012-03-26 10:56:46.626 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2012-03-26 10:56:46.626 (5) [P1T1]: addSub("db") 2012-03-26 10:56:46.627 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2012-03-26 10:56:46.627 (4) [P1T1]: time=0.0080 2012-03-26 10:56:46.627 (4) [P1T1]: Query executed in 0.008s 2012-03-26 10:56:46.627 (5) [P1T1]: loading 9 columns from result set: 2012-03-26 10:56:46.628 (5) [P1T1]: loaded column: dataAvailability.id->165588 2012-03-26 10:56:46.628 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-22 2012-03-26 10:56:46.629 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-26 10:56:46.629 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-24 15:46:21.0 2012-03-26 10:56:46.631 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5965 2012-03-26 10:56:46.631 (5) [P1T1]: loaded column: dataAvailability.status->success 2012-03-26 10:56:46.632 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-26 10:56:46.632 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-26 10:56:46.632 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-26 10:56:46.632 (4) [P1T1]: Record Loaded 2012-03-26 10:56:46.633 (5) [P1T1]: quoteValue(), nothing special about it=>[5965], type=class java.lang.Integer 2012-03-26 10:56:46.634 (5) [P1T1]: quoteValue(), nothing special about it=>[165588], type=class java.lang.Integer 2012-03-26 10:56:46.634 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:46.634 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5965,"in progress","2012-03-22","2012-03-26 10:56:46",165588)], genflags=yes 2012-03-26 10:56:46.648 (5) [P1T1]: recordAsSubs("db", 14, "P1T1") 2012-03-26 10:56:46.648 (5) [P1T1]: addSub("db") 2012-03-26 10:56:46.648 (5) [P1T1]: ProfilerRec.end("db", true): ret=14 2012-03-26 10:56:46.649 (4) [P1T1]: time=0.014 2012-03-26 10:56:46.649 (4) [P1T1]: Query executed in 0.014s, 2 row(s) affected 2012-03-26 10:56:46.668 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:46.668 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5965","in progress","2012-03-22 00:00:00","2012-03-26 10:56:46")], genflags=yes 2012-03-26 10:56:46.675 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-03-26 10:56:46.676 (5) [P1T1]: addSub("db") 2012-03-26 10:56:46.856 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-03-26 10:56:46.857 (4) [P1T1]: time=0.0070 2012-03-26 10:56:46.858 (4) [P1T1]: Query executed in 0.007s, 1 row(s) affected 2012-03-26 10:56:46.875 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:46.875 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5966") and (`date`="2012-03-22 00:00:00")) limit 1] 2012-03-26 10:56:46.883 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2012-03-26 10:56:46.883 (5) [P1T1]: addSub("db") 2012-03-26 10:56:46.883 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2012-03-26 10:56:46.883 (4) [P1T1]: time=0.0080 2012-03-26 10:56:46.883 (4) [P1T1]: Query executed in 0.008s 2012-03-26 10:56:46.883 (5) [P1T1]: loading 9 columns from result set: 2012-03-26 10:56:46.883 (5) [P1T1]: loaded column: dataAvailability.id->165589 2012-03-26 10:56:46.884 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-22 2012-03-26 10:56:46.884 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-26 10:56:46.884 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-24 15:46:21.0 2012-03-26 10:56:46.884 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5966 2012-03-26 10:56:46.885 (5) [P1T1]: loaded column: dataAvailability.status->success 2012-03-26 10:56:46.885 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-26 10:56:46.885 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-26 10:56:46.885 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-26 10:56:46.885 (4) [P1T1]: Record Loaded 2012-03-26 10:56:46.894 (5) [P1T1]: quoteValue(), nothing special about it=>[5966], type=class java.lang.Integer 2012-03-26 10:56:46.895 (5) [P1T1]: quoteValue(), nothing special about it=>[165589], type=class java.lang.Integer 2012-03-26 10:56:46.895 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:46.895 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5966,"in progress","2012-03-22","2012-03-26 10:56:46",165589)], genflags=yes 2012-03-26 10:56:46.907 (5) [P1T1]: recordAsSubs("db", 12, "P1T1") 2012-03-26 10:56:46.908 (5) [P1T1]: addSub("db") 2012-03-26 10:56:46.908 (5) [P1T1]: ProfilerRec.end("db", true): ret=12 2012-03-26 10:56:46.908 (4) [P1T1]: time=0.012 2012-03-26 10:56:46.909 (4) [P1T1]: Query executed in 0.012s, 2 row(s) affected 2012-03-26 10:56:46.912 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:46.913 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5966","in progress","2012-03-22 00:00:00","2012-03-26 10:56:46")], genflags=yes 2012-03-26 10:56:46.918 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2012-03-26 10:56:46.918 (5) [P1T1]: addSub("db") 2012-03-26 10:56:46.919 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2012-03-26 10:56:46.919 (4) [P1T1]: time=0.0050 2012-03-26 10:56:46.919 (4) [P1T1]: Query executed in 0.005s, 1 row(s) affected 2012-03-26 10:56:46.922 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:46.923 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5967") and (`date`="2012-03-22 00:00:00")) limit 1] 2012-03-26 10:56:46.930 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-03-26 10:56:46.931 (5) [P1T1]: addSub("db") 2012-03-26 10:56:46.931 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-03-26 10:56:46.931 (4) [P1T1]: time=0.0070 2012-03-26 10:56:46.932 (4) [P1T1]: Query executed in 0.007s 2012-03-26 10:56:46.932 (5) [P1T1]: loading 9 columns from result set: 2012-03-26 10:56:46.933 (5) [P1T1]: loaded column: dataAvailability.id->165590 2012-03-26 10:56:46.934 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-22 2012-03-26 10:56:46.934 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-26 10:56:47.192 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-24 15:46:21.0 2012-03-26 10:56:47.193 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5967 2012-03-26 10:56:47.193 (5) [P1T1]: loaded column: dataAvailability.status->success 2012-03-26 10:56:47.193 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-26 10:56:47.193 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-26 10:56:47.193 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-26 10:56:47.193 (4) [P1T1]: Record Loaded 2012-03-26 10:56:47.194 (5) [P1T1]: quoteValue(), nothing special about it=>[5967], type=class java.lang.Integer 2012-03-26 10:56:47.195 (5) [P1T1]: quoteValue(), nothing special about it=>[165590], type=class java.lang.Integer 2012-03-26 10:56:47.195 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:47.195 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5967,"in progress","2012-03-22","2012-03-26 10:56:46",165590)], genflags=yes 2012-03-26 10:56:47.203 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2012-03-26 10:56:47.204 (5) [P1T1]: addSub("db") 2012-03-26 10:56:47.204 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2012-03-26 10:56:47.204 (4) [P1T1]: time=0.0080 2012-03-26 10:56:47.204 (4) [P1T1]: Query executed in 0.008s, 2 row(s) affected 2012-03-26 10:56:47.207 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:47.207 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5967","in progress","2012-03-22 00:00:00","2012-03-26 10:56:46")], genflags=yes 2012-03-26 10:56:47.223 (5) [P1T1]: recordAsSubs("db", 16, "P1T1") 2012-03-26 10:56:47.223 (5) [P1T1]: addSub("db") 2012-03-26 10:56:47.223 (5) [P1T1]: ProfilerRec.end("db", true): ret=16 2012-03-26 10:56:47.223 (4) [P1T1]: time=0.016 2012-03-26 10:56:47.224 (4) [P1T1]: Query executed in 0.016s, 1 row(s) affected 2012-03-26 10:56:47.225 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:47.225 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5968") and (`date`="2012-03-22 00:00:00")) limit 1] 2012-03-26 10:56:47.243 (5) [P1T1]: recordAsSubs("db", 18, "P1T1") 2012-03-26 10:56:47.243 (5) [P1T1]: addSub("db") 2012-03-26 10:56:47.244 (5) [P1T1]: ProfilerRec.end("db", true): ret=18 2012-03-26 10:56:47.244 (4) [P1T1]: time=0.018 2012-03-26 10:56:47.254 (4) [P1T1]: Query executed in 0.018s 2012-03-26 10:56:47.254 (5) [P1T1]: loading 9 columns from result set: 2012-03-26 10:56:47.255 (5) [P1T1]: loaded column: dataAvailability.id->165591 2012-03-26 10:56:47.255 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-22 2012-03-26 10:56:47.255 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-26 10:56:47.255 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-24 15:46:21.0 2012-03-26 10:56:47.256 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5968 2012-03-26 10:56:47.256 (5) [P1T1]: loaded column: dataAvailability.status->success 2012-03-26 10:56:47.256 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-26 10:56:47.256 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-26 10:56:47.256 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-26 10:56:47.256 (4) [P1T1]: Record Loaded 2012-03-26 10:56:47.257 (5) [P1T1]: quoteValue(), nothing special about it=>[5968], type=class java.lang.Integer 2012-03-26 10:56:47.257 (5) [P1T1]: quoteValue(), nothing special about it=>[165591], type=class java.lang.Integer 2012-03-26 10:56:47.258 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:47.258 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5968,"in progress","2012-03-22","2012-03-26 10:56:47",165591)], genflags=yes 2012-03-26 10:56:47.268 (5) [P1T1]: recordAsSubs("db", 10, "P1T1") 2012-03-26 10:56:47.268 (5) [P1T1]: addSub("db") 2012-03-26 10:56:47.268 (5) [P1T1]: ProfilerRec.end("db", true): ret=10 2012-03-26 10:56:47.268 (4) [P1T1]: time=0.01 2012-03-26 10:56:47.269 (4) [P1T1]: Query executed in 0.010s, 2 row(s) affected 2012-03-26 10:56:47.270 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:47.270 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5968","in progress","2012-03-22 00:00:00","2012-03-26 10:56:47")], genflags=yes 2012-03-26 10:56:47.274 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-26 10:56:47.274 (5) [P1T1]: addSub("db") 2012-03-26 10:56:47.274 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-26 10:56:47.275 (4) [P1T1]: time=0.0040 2012-03-26 10:56:47.275 (4) [P1T1]: Query executed in 0.004s, 1 row(s) affected 2012-03-26 10:56:47.280 (4) [P1T1]: preparing SQL statement [select admaxNominalMonthlyBudgets.ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-03-26 10:56:47.291 (4) [P1T1]: preparing SQL statement [select ID,accountID,admaxCampaignID,searchEngineAccountID,migrationDate,lastAdMaxRunDate from `st-tracker`.admaxCampaignMigrations where accountID=? and migrationDate>=? and lastAdMaxRunDate<=?] 2012-03-26 10:56:47.299 (4) [P1T1]: preparing SQL statement [select admaxNominalMonthlyBudgets.ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-03-26 10:56:47.313 (4) [P1T1]: preparing SQL statement [select aseam.admaxCampaignID, aseam.searchEngineAccountID from `st-tracker`.admaxCampaigns ac join `st-tracker`.admaxSearchEngineAccountMap aseam on aseam.admaxCampaignID = ac.id where ac.accountID = ?] 2012-03-26 10:56:47.322 (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-26 10:56:47.333 (2) [P1T1]: AdMax campaign ID: 3281 spent 0.4 2012-03-26 10:56:47.334 (2) [P1T1]: AdMax campaign ID: 3281 spent 0.8 2012-03-26 10:56:47.334 (2) [P1T1]: AdMax campaign ID: 3291 spent 0.05 2012-03-26 10:56:47.334 (2) [P1T1]: AdMax campaign ID: 3291 spent 0.1 2012-03-26 10:56:47.337 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,pooledCarryover,dedicatedCarryover,commonCarryover from `st-tracker`.admaxCarryovers where admaxCampaignID=? and type=? and date=?] 2012-03-26 10:56:47.357 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,budget from `st-tracker`.admaxActualDailyBudgets where admaxCampaignID=? and type=? and date=?] 2012-03-26 10:56:47.375 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,balanceFactor from `st-tracker`.admaxSearchEngineAccountBalanceFactors where searchEngineAccountID=? and date=?] 2012-03-26 10:56:47.390 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,budget from `st-tracker`.admaxSearchEngineAccountActualDailyBudgets where searchEngineAccountID=? and date=?] 2012-03-26 10:56:47.409 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-03-26 10:56:47.422 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,referenceID,createTime,refund from `st-tracker`.admaxRefunds where admaxCampaignID=? and date(createTime)=?] 2012-03-26 10:56:47.427 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2012-03-26 10:56:47.431 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-03-26 10:56:47.435 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,referenceID,createTime,refund from `st-tracker`.admaxRefunds where admaxCampaignID=? and date(createTime)=?] 2012-03-26 10:56:47.440 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2012-03-26 10:56:47.445 (4) [P1T1]: preparing SQL statement [select sum(commonCarryover) from admaxCampaigns ac join admaxCarryovers c on c.admaxCampaignID = ac.ID and c.type=? and c.date = least(?, (select max(last_carryover.date) from admaxCarryovers last_carryover where last_carryover.admaxCampaignID = ac.ID and last_carryover.type = c.type)) join admaxNominalMonthlyBudgets anmb on anmb.admaxCampaignID = ac.ID and anmb.startDate = (select max(last_nom_budget.startDate) from admaxNominalMonthlyBudgets last_nom_budget where last_nom_budget.admaxCampaignID = ac.ID) where ac.accountID=? and ac.status=? and ((anmb.endDate is null) or (? >= anmb.endDate))] 2012-03-26 10:56:47.480 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,boostMultiplier,boostCap from `st-tracker`.admaxBoosts where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-03-26 10:56:47.492 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshLimit from `st-tracker`.admaxSloshLimits where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-03-26 10:56:47.522 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,boostMultiplier,boostCap from `st-tracker`.admaxBoosts where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-03-26 10:56:47.531 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshLimit from `st-tracker`.admaxSloshLimits where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-03-26 10:56:47.539 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,budgetCapMultiplier from `st-tracker`.admaxBudgetCapMultipliers where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-03-26 10:56:47.546 (3) [P1T1]: Budget capped at: 68.995316 2012-03-26 10:56:47.547 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,budgetCapMultiplier from `st-tracker`.admaxBudgetCapMultipliers where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-03-26 10:56:47.557 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxCarryovers (admaxCampaignID, type, date, pooledCarryover, dedicatedCarryover, commonCarryover) values (?,?,?,?,?,?) on duplicate key update pooledCarryover=?,dedicatedCarryover=?,commonCarryover=?] 2012-03-26 10:56:47.571 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxActualDailyBudgets (admaxCampaignID, type, date, budget) values (?,?,?,?) on duplicate key update budget=?] 2012-03-26 10:56:47.589 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountBalanceFactors (searchEngineAccountID, date, balanceFactor) values (?,?,?) on duplicate key update balanceFactor=?] 2012-03-26 10:56:47.625 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountActualDailyBudgets (searchEngineAccountID, date, budget) values (?,?,?) on duplicate key update budget=?] 2012-03-26 10:56:47.964 (3) [P1T1]: Re-run detected - Google campaign budgets will not be set 2012-03-26 10:56:47.965 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:47.965 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5965") and (`date`="2012-03-22 00:00:00")) limit 1] 2012-03-26 10:56:47.971 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2012-03-26 10:56:47.971 (5) [P1T1]: addSub("db") 2012-03-26 10:56:47.971 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2012-03-26 10:56:47.971 (4) [P1T1]: time=0.0060 2012-03-26 10:56:47.971 (4) [P1T1]: Query executed in 0.006s 2012-03-26 10:56:47.971 (5) [P1T1]: loading 9 columns from result set: 2012-03-26 10:56:47.971 (5) [P1T1]: loaded column: dataAvailability.id->165588 2012-03-26 10:56:47.972 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-22 2012-03-26 10:56:47.972 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-26 10:56:47.972 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-26 10:56:46.0 2012-03-26 10:56:47.973 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5965 2012-03-26 10:56:47.973 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2012-03-26 10:56:47.973 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-26 10:56:47.973 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-26 10:56:47.973 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-26 10:56:47.973 (4) [P1T1]: Record Loaded 2012-03-26 10:56:47.974 (5) [P1T1]: quoteValue(), nothing special about it=>[5965], type=class java.lang.Integer 2012-03-26 10:56:47.974 (5) [P1T1]: quoteValue(), nothing special about it=>[165588], type=class java.lang.Integer 2012-03-26 10:56:47.975 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:47.975 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5965,"success","2012-03-22","2012-03-26 10:56:47",165588)], genflags=yes 2012-03-26 10:56:47.983 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2012-03-26 10:56:47.983 (5) [P1T1]: addSub("db") 2012-03-26 10:56:47.983 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2012-03-26 10:56:47.983 (4) [P1T1]: time=0.0080 2012-03-26 10:56:47.983 (4) [P1T1]: Query executed in 0.008s, 2 row(s) affected 2012-03-26 10:56:47.985 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:47.985 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5965","success","2012-03-22 00:00:00","2012-03-26 10:56:47")], genflags=yes 2012-03-26 10:56:47.990 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2012-03-26 10:56:47.990 (5) [P1T1]: addSub("db") 2012-03-26 10:56:47.990 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2012-03-26 10:56:47.990 (4) [P1T1]: time=0.0050 2012-03-26 10:56:47.990 (4) [P1T1]: Query executed in 0.005s, 1 row(s) affected 2012-03-26 10:56:47.991 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:47.992 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5966") and (`date`="2012-03-22 00:00:00")) limit 1] 2012-03-26 10:56:47.997 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2012-03-26 10:56:47.997 (5) [P1T1]: addSub("db") 2012-03-26 10:56:47.997 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2012-03-26 10:56:47.997 (4) [P1T1]: time=0.0050 2012-03-26 10:56:47.997 (4) [P1T1]: Query executed in 0.005s 2012-03-26 10:56:47.997 (5) [P1T1]: loading 9 columns from result set: 2012-03-26 10:56:47.997 (5) [P1T1]: loaded column: dataAvailability.id->165589 2012-03-26 10:56:47.998 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-22 2012-03-26 10:56:47.998 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-26 10:56:47.998 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-26 10:56:46.0 2012-03-26 10:56:47.998 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5966 2012-03-26 10:56:47.999 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2012-03-26 10:56:47.999 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-26 10:56:47.999 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-26 10:56:47.999 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-26 10:56:47.999 (4) [P1T1]: Record Loaded 2012-03-26 10:56:48.000 (5) [P1T1]: quoteValue(), nothing special about it=>[5966], type=class java.lang.Integer 2012-03-26 10:56:48.000 (5) [P1T1]: quoteValue(), nothing special about it=>[165589], type=class java.lang.Integer 2012-03-26 10:56:48.000 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:48.000 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5966,"success","2012-03-22","2012-03-26 10:56:47",165589)], genflags=yes 2012-03-26 10:56:48.018 (5) [P1T1]: recordAsSubs("db", 17, "P1T1") 2012-03-26 10:56:48.018 (5) [P1T1]: addSub("db") 2012-03-26 10:56:48.018 (5) [P1T1]: ProfilerRec.end("db", true): ret=17 2012-03-26 10:56:48.018 (4) [P1T1]: time=0.017 2012-03-26 10:56:48.018 (4) [P1T1]: Query executed in 0.017s, 2 row(s) affected 2012-03-26 10:56:48.020 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:48.020 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5966","success","2012-03-22 00:00:00","2012-03-26 10:56:47")], genflags=yes 2012-03-26 10:56:48.025 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2012-03-26 10:56:48.025 (5) [P1T1]: addSub("db") 2012-03-26 10:56:48.025 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2012-03-26 10:56:48.025 (4) [P1T1]: time=0.0050 2012-03-26 10:56:48.025 (4) [P1T1]: Query executed in 0.005s, 1 row(s) affected 2012-03-26 10:56:48.026 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:48.026 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5967") and (`date`="2012-03-22 00:00:00")) limit 1] 2012-03-26 10:56:48.031 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2012-03-26 10:56:48.031 (5) [P1T1]: addSub("db") 2012-03-26 10:56:48.031 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2012-03-26 10:56:48.031 (4) [P1T1]: time=0.0050 2012-03-26 10:56:48.031 (4) [P1T1]: Query executed in 0.005s 2012-03-26 10:56:48.031 (5) [P1T1]: loading 9 columns from result set: 2012-03-26 10:56:48.032 (5) [P1T1]: loaded column: dataAvailability.id->165590 2012-03-26 10:56:48.032 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-22 2012-03-26 10:56:48.032 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-26 10:56:48.032 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-26 10:56:46.0 2012-03-26 10:56:48.033 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5967 2012-03-26 10:56:48.033 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2012-03-26 10:56:48.033 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-26 10:56:48.033 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-26 10:56:48.033 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-26 10:56:48.033 (4) [P1T1]: Record Loaded 2012-03-26 10:56:48.034 (5) [P1T1]: quoteValue(), nothing special about it=>[5967], type=class java.lang.Integer 2012-03-26 10:56:48.034 (5) [P1T1]: quoteValue(), nothing special about it=>[165590], type=class java.lang.Integer 2012-03-26 10:56:48.035 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:48.035 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5967,"success","2012-03-22","2012-03-26 10:56:48",165590)], genflags=yes 2012-03-26 10:56:48.042 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-03-26 10:56:48.042 (5) [P1T1]: addSub("db") 2012-03-26 10:56:48.042 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-03-26 10:56:48.043 (4) [P1T1]: time=0.0070 2012-03-26 10:56:48.043 (4) [P1T1]: Query executed in 0.007s, 2 row(s) affected 2012-03-26 10:56:48.045 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:48.045 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5967","success","2012-03-22 00:00:00","2012-03-26 10:56:48")], genflags=yes 2012-03-26 10:56:48.050 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2012-03-26 10:56:48.050 (5) [P1T1]: addSub("db") 2012-03-26 10:56:48.050 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2012-03-26 10:56:48.050 (4) [P1T1]: time=0.0050 2012-03-26 10:56:48.050 (4) [P1T1]: Query executed in 0.005s, 1 row(s) affected 2012-03-26 10:56:48.051 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:48.051 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="5968") and (`date`="2012-03-22 00:00:00")) limit 1] 2012-03-26 10:56:48.438 (5) [P1T1]: recordAsSubs("db", 387, "P1T1") 2012-03-26 10:56:48.440 (5) [P1T1]: addSub("db") 2012-03-26 10:56:48.442 (5) [P1T1]: ProfilerRec.end("db", true): ret=387 2012-03-26 10:56:48.442 (4) [P1T1]: time=0.387 2012-03-26 10:56:48.442 (4) [P1T1]: Query executed in 0.387s 2012-03-26 10:56:48.443 (5) [P1T1]: loading 9 columns from result set: 2012-03-26 10:56:48.443 (5) [P1T1]: loaded column: dataAvailability.id->165591 2012-03-26 10:56:48.443 (5) [P1T1]: loaded column: dataAvailability.date->2012-03-22 2012-03-26 10:56:48.443 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2012-03-26 10:56:48.444 (5) [P1T1]: loaded column: dataAvailability.updated->2012-03-26 10:56:47.0 2012-03-26 10:56:48.444 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->5968 2012-03-26 10:56:48.444 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2012-03-26 10:56:48.444 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2012-03-26 10:56:48.444 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2012-03-26 10:56:48.444 (5) [P1T1]: loaded column: dataAvailability.override->false 2012-03-26 10:56:48.444 (4) [P1T1]: Record Loaded 2012-03-26 10:56:48.445 (5) [P1T1]: quoteValue(), nothing special about it=>[5968], type=class java.lang.Integer 2012-03-26 10:56:48.445 (5) [P1T1]: quoteValue(), nothing special about it=>[165591], type=class java.lang.Integer 2012-03-26 10:56:48.446 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:48.446 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`oldUpdated`,`needsRerun`,`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`,`id`) values ("00:00:00","false",null,"false",5968,"success","2012-03-22","2012-03-26 10:56:48",165591)], genflags=yes 2012-03-26 10:56:48.453 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-03-26 10:56:48.454 (5) [P1T1]: addSub("db") 2012-03-26 10:56:48.454 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-03-26 10:56:48.455 (4) [P1T1]: time=0.0070 2012-03-26 10:56:48.455 (4) [P1T1]: Query executed in 0.007s, 2 row(s) affected 2012-03-26 10:56:48.456 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:48.456 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","5968","success","2012-03-22 00:00:00","2012-03-26 10:56:48")], genflags=yes 2012-03-26 10:56:48.462 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2012-03-26 10:56:48.463 (5) [P1T1]: addSub("db") 2012-03-26 10:56:48.463 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2012-03-26 10:56:48.463 (4) [P1T1]: time=0.0060 2012-03-26 10:56:48.463 (4) [P1T1]: Query executed in 0.006s, 1 row(s) affected 2012-03-26 10:56:48.464 (3) [P1T1]: Finished applying algorithm [SABB] for account [5221] in distributions [3] 2012-03-26 10:56:48.464 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-03-26 10:56:48.464 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.5221')] 2012-03-26 10:56:48.468 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2012-03-26 10:56:48.469 (5) [P1T1]: addSub("db") 2012-03-26 10:56:48.469 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2012-03-26 10:56:48.469 (4) [P1T1]: time=0.0040 2012-03-26 10:56:48.469 (4) [P1T1]: Query executed in 0.004s 2012-03-26 10:56:48.469 (3) [P1T1]: Released migrator lock for Account ID #5221 2012-03-26 10:56:48.469 (4) [P1T1]: Returning Object to Pool 2012-03-26 10:56:48.469 (4) [P1T1]: Returning Object to Pool 2012-03-26 10:56:48.469 (4) [P1T1]: Returning Object to Pool 2012-03-26 10:56:48.469 (3) [P1T1]: Completed Account ID #5221: alok-n63a 2012-03-26 10:56:48.472 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-03-26 10:56:48.472 (3) [main]: ------------AdMax Summarizer done 2012-03-26 10:56:48.473 (3) [main]: =============== Completed AdMax Summarizer ================ 2012-03-26 10:56:48.473 (4) [main]: DataCache: Found key global-logging 2012-03-26 10:56:48.473 (4) [main]: Took Existing Object from Pool 2012-03-26 10:56:48.473 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-03-26 10:56:48.473 (4) [main]: spike: SQL->[select @@version] 2012-03-26 10:56:48.480 (2) [main]: Warning(s) detected in statement [select @@version] executed by user [spike] 2012-03-26 10:56:48.481 (2) [main]: Table 'logging.processHistory' doesn't exist (1146) 2012-03-26 10:56:48.481 (5) [main]: recordAsSubs("db", 8, "main") 2012-03-26 10:56:48.481 (5) [main]: addSub("db") 2012-03-26 10:56:48.481 (5) [main]: ProfilerRec.end("db", true): ret=8 2012-03-26 10:56:48.481 (4) [main]: time=0.0080 2012-03-26 10:56:48.481 (4) [main]: Query executed in 0.008s 2012-03-26 10:56:48.481 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-03-26 10:56:48.482 (3) [main]: Could not save process history stop 2012-03-26 10:56:48.482 (4) [main]: Returning Object to Pool 2012-03-26 10:56:48.482 (3) [main]: =============== Stats ================ 2012-03-26 10:56:48.482 (3) [main]: --- Process --- 2012-03-26 10:56:48.482 (3) [main]: 2012-03-26 10:56:48.482 (3) [main]: ABU Process(start): Mon Mar 26 10:56:43 BST 2012 2012-03-26 10:56:48.482 (3) [main]: ABU Process(stop): Mon Mar 26 10:56:48 BST 2012 2012-03-26 10:56:48.482 (3) [main]: 2012-03-26 10:56:48.482 (3) [main]: --- Accounts --- 2012-03-26 10:56:48.483 (3) [main]: 2012-03-26 10:56:48.483 (3) [main]: Accounts Processed: 1 2012-03-26 10:56:48.483 (3) [main]: Accounts Skipped: 0 2012-03-26 10:56:48.483 (3) [main]: Accounts Processed Successfully: 1 2012-03-26 10:56:48.483 (3) [main]: 2012-03-26 10:56:48.483 (3) [main]: --- Adverts --- 2012-03-26 10:56:48.483 (3) [main]: 2012-03-26 10:56:48.483 (3) [main]: Adverts Processed: 2 2012-03-26 10:56:48.483 (3) [main]: Adverts Processed Successfully: 2 2012-03-26 10:56:48.483 (3) [main]: Advert Budgets Capped: 1 2012-03-26 10:56:48.483 (3) [main]: 2012-03-26 10:56:48.483 (3) [main]: --- Campaigns --- 2012-03-26 10:56:48.484 (3) [main]: 2012-03-26 10:56:48.484 (3) [main]: Campaigns Processed: 4 2012-03-26 10:56:48.484 (3) [main]: Campaigns Processed Successfully: 4 2012-03-26 10:56:48.484 (3) [main]: 2012-03-26 10:56:48.484 (3) [main]: --- Budget/Spend --- 2012-03-26 10:56:48.484 (3) [main]: 2012-03-26 10:56:48.484 (3) [main]: Campaign Budgets Updated: 4 2012-03-26 10:56:48.484 (3) [main]: Campaign Budgets Sent To Google: 0 2012-03-26 10:56:48.484 (3) [main]: 2012-03-26 10:56:48.484 (3) [main]: Spend Total: 0.90000004 2012-03-26 10:56:48.484 (3) [main]: Common Carryover Total: 91.61612 2012-03-26 10:56:48.485 (5) [main]: ProfilerRec.end("AdMaxSummarizer", false): ret=4647 2012-03-26 10:56:48.485 (4) [main]: time=4.647 2012-03-26 10:56:49.780 (3) [main]: AdMaxSummarizer: 4.647s 2012-03-26 10:56:49.780 (3) [main]: by key: 2012-03-26 10:56:49.781 (4) [main]: time=0.781 2012-03-26 10:56:49.781 (3) [main]: db: 0.781s 2012-03-26 10:56:49.781 (3) [main]: by thread: 2012-03-26 10:56:49.781 (4) [main]: time=0.082 2012-03-26 10:56:49.781 (3) [main]: main: 0.082s 2012-03-26 10:56:49.782 (4) [main]: time=0.699 2012-03-26 10:56:49.782 (3) [main]: P1T1: 0.699s 2012-03-26 10:56:49.783 (4) [main]: time=3.866 2012-03-26 10:56:49.783 (3) [main]: other: 3.866s