[TSAApp@aml27-core1 2019-02-03]$ /usr/local/tsa/bidmgr/admax.sh -d5 --date 2019-02-03 --distribution 178 -z Asia/Tokyo -a 2813 Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated and will likely be removed in a future release ------- Loaded DatabaseAccounts properties from file:/usr/local/tsa/bidmgr-distribution-2.9.19.1-HOTFIX1-dev-t20180619193836/libs/deployment-bidmgr-shaded-jar-2.9.19.1-HOTFIX1.jar!/core-jdb-datasource.properties ------- {datasource-user=spike, datasource-password=tar63t} 2019-02-05 13:00:53.783 (3) [main]: Debug Level set to 3 2019-02-05 13:00:53.784 (3) [main]: Licensing environment detected, loading configuration. 2019-02-05 13:00:53.785 (3) [main]: Loaded property: distribution-service-url=http://aml27-front1:8081/distribution 2019-02-05 13:00:53.785 (3) [main]: Loaded property: distribution-service-username=readwrite 2019-02-05 13:00:53.786 (3) [main]: Loaded property: distribution-service-password=get-ucR3phEcupu 2019-02-05 13:00:53.786 (3) [main]: Loaded property: sapi-auth-url=http://aml27-front1:8080/sapi/rest/security/tokens 2019-02-05 13:00:53.786 (3) [main]: Loaded property: sapi-merchant-service-url=http://aml27-front1:8080/sapi/rest/merchants 2019-02-05 13:00:53.786 (3) [main]: Loaded property: sapi-reseller-service-url=http://aml27-front1:8080/sapi/rest/resellers 2019-02-05 13:00:53.786 (3) [main]: Loaded property: sapi-username=admin+tsa@thesearchagency.com 2019-02-05 13:00:53.786 (3) [main]: Loaded property: sapi-password=admin 2019-02-05 13:00:53.786 (3) [main]: Loaded property: sapi-realm=thesearchagency 2019-02-05 13:00:53.786 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true 2019-02-05 13:00:53.786 (3) [main]: Loaded property: tsa.timezone=UTC 2019-02-05 13:00:53.787 (3) [main]: Debug Level set to 5 2019-02-05 13:00:53.788 (3) [main]: AdMax Summarizer parameters: -d5 --date 2019-02-03 --distribution 178 -z Asia/Tokyo -a 2813 2019-02-05 13:00:53.866 (4) [main]: registered MBean [thesearchagency.db.util:type=MultiplexDatabasePool0d1badae-d277-41a8-b32c-14a3ee59e87b] for class com.thesearchagency.db.util.MultiplexDatabasePool 2019-02-05 13:00:53.871 (5) [main]: ProfilerRec.start("AdMaxSummarizer",false) in Thread [main] 2019-02-05 13:00:53.875 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2019-02-05 13:00:54.081 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-02-05 13:00:54.081 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.083 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2019-02-05 13:00:54.084 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-logging") and (`type`="mysql")) limit 1] 2019-02-05 13:00:54.086 (5) [main]: recordAsSubs("db", 2, "main") 2019-02-05 13:00:54.087 (5) [main]: addSub("db") 2019-02-05 13:00:54.087 (5) [main]: ProfilerRec.end("db", true): ret=2 2019-02-05 13:00:54.087 (4) [main]: time=0.002 2019-02-05 13:00:54.088 (4) [main]: Query executed in 0.002s 2019-02-05 13:00:54.088 (5) [main]: loading 8 columns from result set: 2019-02-05 13:00:54.089 (5) [main]: loaded column: databaseInstances.id->4 2019-02-05 13:00:54.089 (5) [main]: loaded column: databaseInstances.name->global-logging 2019-02-05 13:00:54.089 (5) [main]: loaded column: databaseInstances.description->Global Logging Tables 2019-02-05 13:00:54.089 (5) [main]: loaded column: databaseInstances.type->mysql 2019-02-05 13:00:54.090 (5) [main]: loaded column: databaseInstances.database->logging 2019-02-05 13:00:54.090 (5) [main]: loaded column: databaseInstances.host->logging-01-write 2019-02-05 13:00:54.090 (5) [main]: loaded column: databaseInstances.port->3306 2019-02-05 13:00:54.090 (5) [main]: loaded column: databaseInstances.access->rw 2019-02-05 13:00:54.090 (4) [main]: Record Loaded 2019-02-05 13:00:54.090 (4) [main]: DataCache: put key global-logging 2019-02-05 13:00:54.091 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.094 (4) [main]: registered MBean [com.carldunham.jst.pooling:type=ObjectPoola2e526d6-22dd-486c-b08e-b619d4c8dff0] for class com.carldunham.jst.pooling.ObjectPool 2019-02-05 13:00:54.094 (3) [main]: DatabasePool with a limit of 18 created 2019-02-05 13:00:54.095 (4) [main]: registered MBean [com.carldunham.jst.db:type=DatabasePoold0498359-2718-4fdd-8701-0d252785d88e] for class com.carldunham.jst.db.DatabasePool 2019-02-05 13:00:54.096 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2019-02-05 13:00:54.107 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-02-05 13:00:54.107 (4) [main]: opened [jdbc:mysql://logging-01-write:3306/logging?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.108 (4) [main]: Created new Object 2019-02-05 13:00:54.108 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2019-02-05 13:00:54.108 (4) [main]: spike: SQL->[select @@version] 2019-02-05 13:00:54.109 (5) [main]: recordAsSubs("db", 1, "main") 2019-02-05 13:00:54.109 (5) [main]: addSub("db") 2019-02-05 13:00:54.109 (5) [main]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.109 (4) [main]: time=0.001 2019-02-05 13:00:54.109 (4) [main]: Query executed in 0.001s 2019-02-05 13:00:54.110 (4) [main]: test query succeeded, returned "5.5.34" 2019-02-05 13:00:54.110 (4) [main]: preparing SQL statement [insert into logging.processHistory (processID, startTime) values (?,?)], genflags=yes 2019-02-05 13:00:54.125 (3) [main]: Could not save process history start 2019-02-05 13:00:54.125 (4) [main]: Returning Object to Pool 2019-02-05 13:00:54.126 (3) [main]: =============== Starting AdMax Summarizer ================ 2019-02-05 13:00:54.126 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2019-02-05 13:00:54.126 (3) [main]: ----------------AdMax Summarizer starting 2019-02-05 13:00:54.138 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-02-05 13:00:54.138 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.138 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2019-02-05 13:00:54.138 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (2813)) and (`tsacommon`.`accounts`.`timeZoneID` in ("Asia/Tokyo"))) order by rand()] 2019-02-05 13:00:54.140 (5) [main]: recordAsSubs("db", 2, "main") 2019-02-05 13:00:54.140 (5) [main]: addSub("db") 2019-02-05 13:00:54.140 (5) [main]: ProfilerRec.end("db", true): ret=2 2019-02-05 13:00:54.140 (4) [main]: time=0.002 2019-02-05 13:00:54.140 (4) [main]: Query executed in 0.002s 2019-02-05 13:00:54.140 (5) [main]: loading 21 columns from result set: 2019-02-05 13:00:54.141 (5) [main]: loaded column: accounts.id->2813 2019-02-05 13:00:54.141 (5) [main]: loaded column: accounts.description->b074d0ce-b5e3-469c-9c0a-7b65ea3bb52b 2019-02-05 13:00:54.142 (5) [main]: loaded column: accounts.tier->1 2019-02-05 13:00:54.142 (5) [main]: loaded column: accounts.priority->50 2019-02-05 13:00:54.142 (5) [main]: loaded column: accounts.reportClicksOut->false 2019-02-05 13:00:54.142 (5) [main]: loaded column: accounts.reportConversions->false 2019-02-05 13:00:54.142 (5) [main]: loaded column: accounts.conversionTypes->paid 2019-02-05 13:00:54.142 (5) [main]: loaded column: accounts.isBidManaged->true 2019-02-05 13:00:54.143 (5) [main]: loaded column: accounts.isActive->true 2019-02-05 13:00:54.143 (5) [main]: loaded column: accounts.perfMetric->cpa 2019-02-05 13:00:54.143 (5) [main]: loaded column: accounts.providesConversionData->true 2019-02-05 13:00:54.143 (5) [main]: loaded column: accounts.addConversionData->true 2019-02-05 13:00:54.143 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2019-02-05 13:00:54.143 (5) [main]: loaded column: accounts.hideNullSources->false 2019-02-05 13:00:54.143 (5) [main]: loaded column: accounts.nowTime->null 2019-02-05 13:00:54.147 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2019-02-05 13:00:54.147 (5) [main]: loaded column: accounts.databaseInstance->1 2019-02-05 13:00:54.147 (5) [main]: loaded column: accounts.warehouseInstance->1 2019-02-05 13:00:54.147 (5) [main]: loaded column: accounts.isOnline->true 2019-02-05 13:00:54.147 (5) [main]: loaded column: accounts.currencyCode->JPY 2019-02-05 13:00:54.147 (5) [main]: loaded column: accounts.timeZoneID->Asia/Tokyo 2019-02-05 13:00:54.154 (3) [P1T1]: Starting Account ID #2813: b074d0ce-b5e3-469c-9c0a-7b65ea3bb52b 2019-02-05 13:00:54.155 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2019-02-05 13:00:54.165 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-02-05 13:00:54.165 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.165 (5) [P1T1]: quoteValue(), nothing special about it=>[2813], type=class java.lang.Integer 2019-02-05 13:00:54.165 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.165 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=2813) limit 1] 2019-02-05 13:00:54.167 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2019-02-05 13:00:54.167 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.167 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2019-02-05 13:00:54.167 (4) [P1T1]: time=0.002 2019-02-05 13:00:54.167 (4) [P1T1]: Query executed in 0.002s 2019-02-05 13:00:54.167 (5) [P1T1]: loading 21 columns from result set: 2019-02-05 13:00:54.167 (5) [P1T1]: loaded column: accounts.id->2813 2019-02-05 13:00:54.167 (5) [P1T1]: loaded column: accounts.description->b074d0ce-b5e3-469c-9c0a-7b65ea3bb52b 2019-02-05 13:00:54.167 (5) [P1T1]: loaded column: accounts.tier->1 2019-02-05 13:00:54.168 (5) [P1T1]: loaded column: accounts.priority->50 2019-02-05 13:00:54.168 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2019-02-05 13:00:54.168 (5) [P1T1]: loaded column: accounts.reportConversions->false 2019-02-05 13:00:54.168 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2019-02-05 13:00:54.168 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2019-02-05 13:00:54.168 (5) [P1T1]: loaded column: accounts.isActive->true 2019-02-05 13:00:54.168 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2019-02-05 13:00:54.169 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2019-02-05 13:00:54.169 (5) [P1T1]: loaded column: accounts.addConversionData->true 2019-02-05 13:00:54.169 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2019-02-05 13:00:54.169 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2019-02-05 13:00:54.169 (5) [P1T1]: loaded column: accounts.nowTime->null 2019-02-05 13:00:54.169 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2019-02-05 13:00:54.169 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2019-02-05 13:00:54.169 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2019-02-05 13:00:54.170 (5) [P1T1]: loaded column: accounts.isOnline->true 2019-02-05 13:00:54.170 (5) [P1T1]: loaded column: accounts.currencyCode->JPY 2019-02-05 13:00:54.170 (5) [P1T1]: loaded column: accounts.timeZoneID->Asia/Tokyo 2019-02-05 13:00:54.170 (4) [P1T1]: Record Loaded 2019-02-05 13:00:54.170 (4) [P1T1]: DataCache: put key acct-st-tracker 2813 2019-02-05 13:00:54.170 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.171 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1] 2019-02-05 13:00:54.172 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.172 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.172 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.172 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.172 (4) [P1T1]: Query executed in 0.001s 2019-02-05 13:00:54.172 (5) [P1T1]: loading 8 columns from result set: 2019-02-05 13:00:54.173 (5) [P1T1]: loaded column: databaseInstances.id->15 2019-02-05 13:00:54.173 (5) [P1T1]: loaded column: databaseInstances.name->acct-st-tracker-1 2019-02-05 13:00:54.173 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Catch-all database 2019-02-05 13:00:54.173 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2019-02-05 13:00:54.174 (5) [P1T1]: loaded column: databaseInstances.database->st-tracker 2019-02-05 13:00:54.174 (5) [P1T1]: loaded column: databaseInstances.host->acctdb-01-write 2019-02-05 13:00:54.174 (5) [P1T1]: loaded column: databaseInstances.port->3306 2019-02-05 13:00:54.174 (5) [P1T1]: loaded column: databaseInstances.access->rw 2019-02-05 13:00:54.174 (4) [P1T1]: Record Loaded 2019-02-05 13:00:54.174 (4) [P1T1]: DataCache: put key acct-st-tracker-1 2019-02-05 13:00:54.174 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.174 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool1b837f45-4d29-4d4e-9d6b-3658c2f4accf] for class com.carldunham.jst.pooling.ObjectPool 2019-02-05 13:00:54.174 (3) [P1T1]: DatabasePool with a limit of 18 created 2019-02-05 13:00:54.174 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePoole5fe08c4-e4f2-4b4a-8f40-42f01550623b] for class com.carldunham.jst.db.DatabasePool 2019-02-05 13:00:54.182 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-02-05 13:00:54.182 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.182 (4) [P1T1]: Created new Object 2019-02-05 13:00:54.182 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.182 (4) [P1T1]: spike: SQL->[select @@version] 2019-02-05 13:00:54.183 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.183 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.183 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.183 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.183 (4) [P1T1]: Query executed in 0.001s 2019-02-05 13:00:54.184 (4) [P1T1]: test query succeeded, returned "5.5.34" 2019-02-05 13:00:54.184 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2019-02-05 13:00:54.184 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool702cc370-243a-4514-ac9b-b5d6bdb33be5] for class com.carldunham.jst.pooling.ObjectPool 2019-02-05 13:00:54.184 (3) [P1T1]: DatabasePool with a limit of 18 created 2019-02-05 13:00:54.184 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePoola33e13d5-1a46-4eac-b0a2-53986539109a] for class com.carldunham.jst.db.DatabasePool 2019-02-05 13:00:54.194 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-02-05 13:00:54.194 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.194 (4) [P1T1]: Created new Object 2019-02-05 13:00:54.194 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.194 (4) [P1T1]: spike: SQL->[select @@version] 2019-02-05 13:00:54.195 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.195 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.196 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.196 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.196 (4) [P1T1]: Query executed in 0.001s 2019-02-05 13:00:54.196 (4) [P1T1]: test query succeeded, returned "5.5.34" 2019-02-05 13:00:54.196 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2019-02-05 13:00:54.203 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-02-05 13:00:54.203 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.203 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.203 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-staging") and (`type`="mysql")) limit 1] 2019-02-05 13:00:54.204 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.204 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.204 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.204 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.204 (4) [P1T1]: Query executed in 0.001s 2019-02-05 13:00:54.204 (5) [P1T1]: loading 8 columns from result set: 2019-02-05 13:00:54.204 (5) [P1T1]: loaded column: databaseInstances.id->3 2019-02-05 13:00:54.205 (5) [P1T1]: loaded column: databaseInstances.name->global-staging 2019-02-05 13:00:54.205 (5) [P1T1]: loaded column: databaseInstances.description->Global Staging Tables 2019-02-05 13:00:54.205 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2019-02-05 13:00:54.205 (5) [P1T1]: loaded column: databaseInstances.database->staging 2019-02-05 13:00:54.205 (5) [P1T1]: loaded column: databaseInstances.host->staging-01-write 2019-02-05 13:00:54.205 (5) [P1T1]: loaded column: databaseInstances.port->3306 2019-02-05 13:00:54.205 (5) [P1T1]: loaded column: databaseInstances.access->rw 2019-02-05 13:00:54.205 (4) [P1T1]: Record Loaded 2019-02-05 13:00:54.205 (4) [P1T1]: DataCache: put key global-staging 2019-02-05 13:00:54.206 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.206 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool815cc2c9-414e-4c89-8ba5-04e4baf1a612] for class com.carldunham.jst.pooling.ObjectPool 2019-02-05 13:00:54.206 (3) [P1T1]: DatabasePool with a limit of 18 created 2019-02-05 13:00:54.206 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePool5569cf34-e9a5-4790-bae1-3f341286059b] for class com.carldunham.jst.db.DatabasePool 2019-02-05 13:00:54.213 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-02-05 13:00:54.214 (4) [P1T1]: opened [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.214 (4) [P1T1]: Created new Object 2019-02-05 13:00:54.214 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.214 (4) [P1T1]: spike: SQL->[select @@version] 2019-02-05 13:00:54.215 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.215 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.215 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.215 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.215 (4) [P1T1]: Query executed in 0.001s 2019-02-05 13:00:54.215 (4) [P1T1]: test query succeeded, returned "5.5.34" 2019-02-05 13:00:54.215 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2019-02-05 13:00:54.222 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-02-05 13:00:54.222 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.223 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.223 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-clients") and (`type`="mysql")) limit 1] 2019-02-05 13:00:54.224 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.224 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.224 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.224 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.224 (4) [P1T1]: Query executed in 0.001s 2019-02-05 13:00:54.224 (5) [P1T1]: loading 8 columns from result set: 2019-02-05 13:00:54.224 (5) [P1T1]: loaded column: databaseInstances.id->13 2019-02-05 13:00:54.224 (5) [P1T1]: loaded column: databaseInstances.name->global-clients 2019-02-05 13:00:54.224 (5) [P1T1]: loaded column: databaseInstances.description->Global Database for client-specific tables 2019-02-05 13:00:54.224 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2019-02-05 13:00:54.225 (5) [P1T1]: loaded column: databaseInstances.database->clients 2019-02-05 13:00:54.225 (5) [P1T1]: loaded column: databaseInstances.host->clients-01-write 2019-02-05 13:00:54.225 (5) [P1T1]: loaded column: databaseInstances.port->3306 2019-02-05 13:00:54.225 (5) [P1T1]: loaded column: databaseInstances.access->rw 2019-02-05 13:00:54.225 (4) [P1T1]: Record Loaded 2019-02-05 13:00:54.225 (4) [P1T1]: DataCache: put key global-clients 2019-02-05 13:00:54.225 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.225 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPoola3172fe5-6129-4601-931b-0fdab86e697e] for class com.carldunham.jst.pooling.ObjectPool 2019-02-05 13:00:54.225 (3) [P1T1]: DatabasePool with a limit of 18 created 2019-02-05 13:00:54.225 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePool6607bde7-9401-48a8-91d4-0ebe5dbf3a92] for class com.carldunham.jst.db.DatabasePool 2019-02-05 13:00:54.232 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2019-02-05 13:00:54.233 (4) [P1T1]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.233 (4) [P1T1]: Created new Object 2019-02-05 13:00:54.233 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.233 (4) [P1T1]: spike: SQL->[select @@version] 2019-02-05 13:00:54.234 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.234 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.234 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.234 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.234 (4) [P1T1]: Query executed in 0.001s 2019-02-05 13:00:54.234 (4) [P1T1]: test query succeeded, returned "5.5.34" 2019-02-05 13:00:54.234 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.235 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.2813', 600)] 2019-02-05 13:00:54.236 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.236 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.236 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.236 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.236 (4) [P1T1]: Query executed in 0.001s 2019-02-05 13:00:54.236 (3) [P1T1]: Got migrator lock for Account ID #2813 2019-02-05 13:00:54.238 (5) [P1T1]: quoteValue(), nothing special about it=>[2813], type=class java.lang.Integer 2019-02-05 13:00:54.243 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.243 (4) [P1T1]: spike: SQL->[select * from `settings` where ((((`settings`.`scope`="accounts")) and ((`settings`.`scopeId`=2813))))] 2019-02-05 13:00:54.250 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2019-02-05 13:00:54.250 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.250 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2019-02-05 13:00:54.250 (4) [P1T1]: time=0.007 2019-02-05 13:00:54.250 (4) [P1T1]: Query executed in 0.007s 2019-02-05 13:00:54.250 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.250 (4) [P1T1]: spike: SQL->[select * from `settingDefaults` where (`settingDefaults`.`scope`="accounts")] 2019-02-05 13:00:54.252 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2019-02-05 13:00:54.252 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.252 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2019-02-05 13:00:54.252 (4) [P1T1]: time=0.002 2019-02-05 13:00:54.252 (4) [P1T1]: Query executed in 0.002s 2019-02-05 13:00:54.252 (4) [P1T1]: DataCache: put key accounts 2813 2019-02-05 13:00:54.621 (4) [P1T1]: DataCache: Found key accounts 2813 2019-02-05 13:00:54.621 (4) [P1T1]: Settings.getSettings: loaded from cache (key=accounts 2813) 2019-02-05 13:00:54.621 (3) [P1T1]: Applying algorithm [SABB] for Account ID #2813 in distributions [178] 2019-02-05 13:00:54.624 (3) [P1T1]: Processing data for 2019-02-03 00:00:00 JST 2019-02-05 13:00:54.627 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2019-02-05 13:00:54.627 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.627 (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`="2813") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="178"))) and ((`tsacommon`.`searchEngineAccounts`.`distributionID` in (3))))) order by rand()] 2019-02-05 13:00:54.629 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2019-02-05 13:00:54.629 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.629 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2019-02-05 13:00:54.629 (4) [P1T1]: time=0.002 2019-02-05 13:00:54.629 (4) [P1T1]: Query executed in 0.002s 2019-02-05 13:00:54.633 (5) [P1T1]: quoteValue(), nothing special about it=>[2813], type=class java.lang.Integer 2019-02-05 13:00:54.633 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.633 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=2813) and (`typeID`="") and (`type`="admax")) limit 1] 2019-02-05 13:00:54.636 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2019-02-05 13:00:54.636 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.636 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2019-02-05 13:00:54.636 (4) [P1T1]: time=0.003 2019-02-05 13:00:54.636 (4) [P1T1]: Query executed in 0.003s 2019-02-05 13:00:54.636 (5) [P1T1]: loading 4 columns from result set: 2019-02-05 13:00:54.636 (5) [P1T1]: loaded column: dataSources.id->57441 2019-02-05 13:00:54.636 (5) [P1T1]: loaded column: dataSources.type->admax 2019-02-05 13:00:54.636 (5) [P1T1]: loaded column: dataSources.typeID->0 2019-02-05 13:00:54.636 (5) [P1T1]: loaded column: dataSources.accountID->2813 2019-02-05 13:00:54.636 (4) [P1T1]: Record Loaded 2019-02-05 13:00:54.636 (5) [P1T1]: quoteValue(), nothing special about it=>[2813], type=class java.lang.Integer 2019-02-05 13:00:54.636 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.636 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`dataSources`.`type`="admax") and (`dataSources`.`accountID`=2813))] 2019-02-05 13:00:54.638 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2019-02-05 13:00:54.638 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.638 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2019-02-05 13:00:54.638 (4) [P1T1]: time=0.002 2019-02-05 13:00:54.638 (4) [P1T1]: Query executed in 0.002s 2019-02-05 13:00:54.638 (5) [P1T1]: loading 4 columns from result set: 2019-02-05 13:00:54.638 (5) [P1T1]: loaded column: dataSources.id->57441 2019-02-05 13:00:54.638 (5) [P1T1]: loaded column: dataSources.type->admax 2019-02-05 13:00:54.638 (5) [P1T1]: loaded column: dataSources.typeID->0 2019-02-05 13:00:54.638 (5) [P1T1]: loaded column: dataSources.accountID->2813 2019-02-05 13:00:54.640 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.640 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`date`="2019-02-03 00:00:00") and (`dataSourceID`="57441")) limit 1] 2019-02-05 13:00:54.641 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.641 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.641 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.642 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.642 (4) [P1T1]: Query executed in 0.001s 2019-02-05 13:00:54.642 (5) [P1T1]: loading 9 columns from result set: 2019-02-05 13:00:54.642 (5) [P1T1]: loaded column: dataAvailability.id->6039551 2019-02-05 13:00:54.642 (5) [P1T1]: loaded column: dataAvailability.date->2019-02-03 2019-02-05 13:00:54.642 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2019-02-05 13:00:54.643 (5) [P1T1]: loaded column: dataAvailability.updated->2019-02-05 13:00:33.0 2019-02-05 13:00:54.643 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->57441 2019-02-05 13:00:54.643 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2019-02-05 13:00:54.643 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2019-02-05 13:00:54.643 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2019-02-05 13:00:54.643 (5) [P1T1]: loaded column: dataAvailability.override->false 2019-02-05 13:00:54.643 (4) [P1T1]: Record Loaded 2019-02-05 13:00:54.643 (5) [P1T1]: quoteValue(), nothing special about it=>[57441], type=class java.lang.Integer 2019-02-05 13:00:54.643 (5) [P1T1]: quoteValue(), nothing special about it=>[6039551], type=class java.lang.Integer 2019-02-05 13:00:54.644 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.644 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`date`,`dataSourceID`,`statusText`,`id`,`override`,`updated`,`oldUpdated`,`status`,`needsRerun`) values ("2019-02-03",57441,null,6039551,"false","2019-02-05 13:00:54","00:00:00","in progress","false")], genflags=yes 2019-02-05 13:00:54.645 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.645 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.645 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.645 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.645 (4) [P1T1]: Query executed in 0.001s, 2 row(s) affected 2019-02-05 13:00:54.647 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.647 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`date`,`dataSourceID`,`override`,`updated`,`status`) values ("2019-02-03 00:00:00","57441","false","2019-02-05 13:00:54","in progress")], genflags=yes 2019-02-05 13:00:54.648 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.648 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.648 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.648 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.648 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2019-02-05 13:00:54.652 (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>=?)] 2019-02-05 13:00:54.656 (4) [P1T1]: preparing SQL statement [select ID,accountID,admaxCampaignID,searchEngineAccountID,migrationDate,lastAdMaxRunDate from `st-tracker`.admaxCampaignMigrations where accountID=? and migrationDate>=? and lastAdMaxRunDate<=?] 2019-02-05 13:00:54.658 (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>=?)] 2019-02-05 13:00:54.665 (4) [P1T1]: preparing SQL statement [select ID,accountID,startDate,endDate,anniversaryDate from `st-tracker`.admaxAccountAnniversary where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2019-02-05 13:00:54.667 (4) [P1T1]: preparing SQL statement [select ID,accountID,startDate,endDate,anniversaryDate from `st-tracker`.admaxAccountAnniversary where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2019-02-05 13:00:54.668 (4) [P1T1]: preparing SQL statement [select ID,accountID,startDate,endDate,anniversaryDate from `st-tracker`.admaxAccountAnniversary where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2019-02-05 13:00:54.669 (4) [P1T1]: preparing SQL statement [select ID,accountID,startDate,endDate,anniversaryDate from `st-tracker`.admaxAccountAnniversary where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2019-02-05 13:00:54.670 (4) [P1T1]: preparing SQL statement [select id, admaxCampaignID, startDate, endDate, status from `st-tracker`.admaxCampaignBudgetAccrualStatus where admaxCampaignID=? and startDate<=? and (endDate is null or endDate>=?)] 2019-02-05 13:00:54.672 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2019-02-05 13:00:54.673 (3) [P1T1]: Retrieved campaign status Active for AdMax campaign 23718 2019-02-05 13:00:54.673 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2019-02-05 13:00:54.674 (3) [P1T1]: Retrieved campaign status Deleted for AdMax campaign 14205 2019-02-05 13:00:54.675 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2019-02-05 13:00:54.675 (3) [P1T1]: Retrieved campaign status Deleted for AdMax campaign 14206 2019-02-05 13:00:54.676 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2019-02-05 13:00:54.677 (3) [P1T1]: Retrieved campaign status Deleted for AdMax campaign 23717 2019-02-05 13:00:54.677 (4) [P1T1]: preparing SQL statement [select id, admaxCampaignID, startDate, endDate, status from `st-tracker`.admaxCampaignBudgetAccrualStatus where admaxCampaignID=? and startDate<=? and (endDate is null or endDate>=?)] 2019-02-05 13:00:54.677 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2019-02-05 13:00:54.678 (3) [P1T1]: Retrieved campaign status Active for AdMax campaign 23718 2019-02-05 13:00:54.678 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2019-02-05 13:00:54.679 (3) [P1T1]: Retrieved campaign status Deleted for AdMax campaign 14205 2019-02-05 13:00:54.680 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2019-02-05 13:00:54.680 (3) [P1T1]: Retrieved campaign status Deleted for AdMax campaign 14206 2019-02-05 13:00:54.681 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2019-02-05 13:00:54.681 (3) [P1T1]: Retrieved campaign status Deleted for AdMax campaign 23717 2019-02-05 13:00:54.682 (4) [P1T1]: preparing SQL statement [select aseam.admaxCampaignID, aseam.searchEngineAccountID, sea.distributionID, ac.status from `st-tracker`.admaxCampaigns ac join `st-tracker`.admaxSearchEngineAccountMap aseam on aseam.admaxCampaignID = ac.id join tsacommon.searchEngineAccounts sea on sea.ID = aseam.searchEngineAccountID where ac.accountID = ?] 2019-02-05 13:00:54.683 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2019-02-05 13:00:54.684 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2019-02-05 13:00:54.684 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2019-02-05 13:00:54.685 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2019-02-05 13:00:54.685 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2019-02-05 13:00:54.686 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2019-02-05 13:00:54.686 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2019-02-05 13:00:54.687 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2019-02-05 13:00:54.688 (2) [P1T1]: Error in getting campaign mappings for account 2813, Reason:Could not retrieve campaign mappings for AdmaxCampaignID:14205 2019-02-05 13:00:54.688 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.yahooJAdMax.date,staging.yahooJAdMax.clicks,staging.yahooJAdMax.cost,staging.yahooJAdMax.averagePosition from tsacommon.searchEngineAccounts left join staging.yahooJAdMax on tsacommon.searchEngineAccounts.accountID=staging.yahooJAdMax.accountID and staging.yahooJAdMax.campaignid=cast(tsacommon.searchEngineAccounts.searchEngineIdentifier as unsigned) where tsacommon.searchEngineAccounts.accountID=? and staging.yahooJAdMax.date=?] 2019-02-05 13:00:54.689 (3) [P1T1]: Report contained data for a search engine account that is no longer active: 27962 2019-02-05 13:00:54.690 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,pooledCarryover,dedicatedCarryover,commonCarryover from `st-tracker`.admaxCarryovers where admaxCampaignID=? and type=? and date=?] 2019-02-05 13:00:54.694 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,budget from `st-tracker`.admaxActualDailyBudgets where admaxCampaignID=? and type=? and date=?] 2019-02-05 13:00:54.698 (4) [P1T1]: preparing SQL statement [select admaxCampaignID,date,budget from `st-tracker`.admaxNominalDailyBudgets where admaxCampaignID=? and date=?] 2019-02-05 13:00:54.701 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,balanceFactor from `st-tracker`.admaxSearchEngineAccountBalanceFactors where searchEngineAccountID=? and date=?] 2019-02-05 13:00:54.703 (4) [P1T1]: preparing SQL statement [select searchEngineAccountID,date,budget,actualSEBudget,budgetStatus from `st-tracker`.admaxSearchEngineAccountActualDailyBudgets where searchEngineAccountID=? and date=?] 2019-02-05 13:00:54.729 (3) [P1T1]: Distribution Properties Cache: Loading new properties for b074d0ce-b5e3-469c-9c0a-7b65ea3bb52b_ALGORITHM 2019-02-05 13:00:54,738 [P1T1] INFO o.a.c.h.auth.AuthChallengeProcessor - digest authentication scheme selected 2019-02-05 13:00:54.832 (4) [P1T1]: Using value true for property sabb.biddingEnabled.yahoojapan of type ALGORITHM 2019-02-05 13:00:54.832 (4) [P1T1]: preparing SQL statement [select accountID,elementType,elementID,currentBid,currentBidSetDate,newBid,newBidSetDate,retryCount from `st-tracker`.admaxBids where accountID=? and elementType=? and elementID=?] 2019-02-05 13:00:54.834 (4) [P1T1]: Using value true for property sabb.biddingEnabled.yahoojapan of type ALGORITHM 2019-02-05 13:00:54.836 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor,resellerID from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2019-02-05 13:00:54.843 (4) [P1T1]: preparing SQL statement [select admaxCampaignID,referenceID,createTime,refund from `st-tracker`.admaxCampaignRefunds where admaxCampaignID=? and date(createTime)=?] 2019-02-05 13:00:54.844 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2019-02-05 13:00:54.845 (4) [P1T1]: preparing SQL statement [select sum(data.commonCarryover) from (select distinct c.admaxCampaignID, c.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) join admaxSearchEngineAccountMap aseam on aseam.admaxCampaignID = ac.ID join tsacommon.searchEngineAccounts sea on sea.ID = aseam.searchEngineAccountID where ac.accountID=? and ac.status=? and ((anmb.endDate is null) or (? > anmb.endDate)) and sea.distributionID = ?) data] 2019-02-05 13:00:54.847 (4) [P1T1]: Sorted campaign order: [com.thesearchagency.admax.algorithms.common.AdMaxDataCollection@4b7c5801] 2019-02-05 13:00:54.872 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,boostMultiplier,boostCap,resellerID from `st-tracker`.admaxBoosts where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2019-02-05 13:00:54.876 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshLimit,resellerID from `st-tracker`.admaxSloshLimits where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2019-02-05 13:00:54.882 (4) [P1T1]: Pooled carryover limit for AdMaxCampaignID 23718: 116129.04 2019-02-05 13:00:54.884 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,budgetCapMultiplier,resellerID from `st-tracker`.admaxBudgetCapMultipliers where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2019-02-05 13:00:54.888 (2) [P1T1]: Exception [Handling Account ID #2813]:java.lang.NullPointerException at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBBudgetBalancer.run(AdMaxSABBBudgetBalancer.java:77) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.applyAlgorithm(AdMaxSABBAlgorithm.java:294) at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.call(AdMaxSummarizer.java:635) at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.call(AdMaxSummarizer.java:500) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2019-02-05 13:00:54.890 (3) [P1T1]: DefaultPropertyFileMonitor: modification detected on 1415157693000 for com.thesearchagency.AlertUtils.properties 2019-02-05 13:00:54.890 (4) [P1T1]: DefaultPropertyFileMonitor: Setting system property com.thesearchagency.AlertUtils.command = /usr/local/tsa/send_alarm.sh 2019-02-05 13:00:54.890 (4) [P1T1]: DefaultPropertyFileMonitor: Setting system property com.thesearchagency.AlertUtils.teamName = TSAOPS 2019-02-05 13:00:54.890 (2) [P1T1]: sendAlert: executing command: [/usr/local/tsa/send_alarm.sh, WARNING, TSAOPS, AdMax Application [AdMaxSummarizer]: General - Error Handling Account ID #2813null] 2019-02-05 13:00:54.954 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2019-02-05 13:00:54.954 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.2813')] 2019-02-05 13:00:54.955 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2019-02-05 13:00:54.955 (5) [P1T1]: addSub("db") 2019-02-05 13:00:54.955 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.955 (4) [P1T1]: time=0.001 2019-02-05 13:00:54.955 (4) [P1T1]: Query executed in 0.001s 2019-02-05 13:00:54.955 (3) [P1T1]: Released migrator lock for Account ID #2813 2019-02-05 13:00:54.955 (4) [P1T1]: Returning Object to Pool 2019-02-05 13:00:54.955 (4) [P1T1]: Returning Object to Pool 2019-02-05 13:00:54.955 (4) [P1T1]: Returning Object to Pool 2019-02-05 13:00:54.955 (4) [P1T1]: Returning Object to Pool 2019-02-05 13:00:54.955 (3) [P1T1]: Completed Account ID #2813: b074d0ce-b5e3-469c-9c0a-7b65ea3bb52b 2019-02-05 13:00:54.956 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2019-02-05 13:00:54.956 (3) [main]: ------------AdMax Summarizer done 2019-02-05 13:00:54.956 (3) [main]: =============== Completed AdMax Summarizer ================ 2019-02-05 13:00:54.956 (4) [main]: DataCache: Found key global-logging 2019-02-05 13:00:54.956 (4) [main]: Took Existing Object from Pool 2019-02-05 13:00:54.956 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2019-02-05 13:00:54.956 (4) [main]: spike: SQL->[select @@version] 2019-02-05 13:00:54.957 (2) [main]: Warning(s) detected in statement [select @@version] executed by user [spike] 2019-02-05 13:00:54.957 (2) [main]: Table 'logging.processHistory' doesn't exist (1146) 2019-02-05 13:00:54.957 (5) [main]: recordAsSubs("db", 1, "main") 2019-02-05 13:00:54.957 (5) [main]: addSub("db") 2019-02-05 13:00:54.957 (5) [main]: ProfilerRec.end("db", true): ret=1 2019-02-05 13:00:54.957 (4) [main]: time=0.001 2019-02-05 13:00:54.957 (4) [main]: Query executed in 0.001s 2019-02-05 13:00:54.957 (4) [main]: test query succeeded, returned "5.5.34" 2019-02-05 13:00:54.957 (3) [main]: Could not save process history stop 2019-02-05 13:00:54.957 (4) [main]: Returning Object to Pool 2019-02-05 13:00:54.957 (3) [main]: =============== Stats ================ 2019-02-05 13:00:54.957 (3) [main]: --- Process --- 2019-02-05 13:00:54.957 (3) [main]: 2019-02-05 13:00:54.958 (3) [main]: ABU Process(start): Tue Feb 05 13:00:53 UTC 2019 2019-02-05 13:00:54.958 (3) [main]: ABU Process(stop): Tue Feb 05 13:00:54 UTC 2019 2019-02-05 13:00:54.958 (3) [main]: 2019-02-05 13:00:54.958 (3) [main]: --- Accounts --- 2019-02-05 13:00:54.958 (3) [main]: 2019-02-05 13:00:54.958 (3) [main]: Accounts Processed: 1 2019-02-05 13:00:54.958 (3) [main]: Accounts Skipped: 0 2019-02-05 13:00:54.958 (3) [main]: Accounts Processed Successfully: 0 2019-02-05 13:00:54.958 (3) [main]: 2019-02-05 13:00:54.958 (3) [main]: --- Campaigns --- 2019-02-05 13:00:54.958 (3) [main]: 2019-02-05 13:00:54.958 (3) [main]: Campaigns Processed: 4 2019-02-05 13:00:54.958 (3) [main]: Campaigns Processed Successfully: 0 2019-02-05 13:00:54.958 (3) [main]: Campaign Budgets Capped: 0 2019-02-05 13:00:54.958 (3) [main]: 2019-02-05 13:00:54.958 (3) [main]: --- SE Campaigns --- 2019-02-05 13:00:54.958 (3) [main]: 2019-02-05 13:00:54.958 (3) [main]: SE Campaigns Processed: 2 2019-02-05 13:00:54.958 (3) [main]: SE Campaigns Processed Successfully: 0 2019-02-05 13:00:54.958 (3) [main]: 2019-02-05 13:00:54.958 (3) [main]: --- Budget/Spend --- 2019-02-05 13:00:54.958 (3) [main]: 2019-02-05 13:00:54.958 (3) [main]: SE Campaign Budgets Updated: 2 2019-02-05 13:00:54.958 (3) [main]: SE Campaign Budgets Sent To Google: 0 2019-02-05 13:00:54.958 (3) [main]: SE Campaign Budgets Sent To Yahoo Japan:0 2019-02-05 13:00:54.958 (3) [main]: SE Campaign Budgets Sent To Bing: 0 2019-02-05 13:00:54.958 (3) [main]: 2019-02-05 13:00:54.958 (3) [main]: Spend Total: 0.0 2019-02-05 13:00:54.958 (3) [main]: Common Carryover Total: 0.0 2019-02-05 13:00:54.959 (3) [main]: 2019-02-05 13:00:54.959 (3) [main]: --- Bids --- 2019-02-05 13:00:54.959 (3) [main]: 2019-02-05 13:00:54.959 (3) [main]: New Campaign Bids: 0 2019-02-05 13:00:54.959 (3) [main]: 2019-02-05 13:00:54.959 (5) [main]: ProfilerRec.end("AdMaxSummarizer", false): ret=1088 2019-02-05 13:00:54.959 (4) [main]: time=1.088 2019-02-05 13:00:54.959 (3) [main]: AdMaxSummarizer: 1.088s 2019-02-05 13:00:54.959 (3) [main]: by key: 2019-02-05 13:00:54.959 (4) [main]: time=0.036 2019-02-05 13:00:54.959 (3) [main]: db: 0.036s 2019-02-05 13:00:54.959 (3) [main]: by thread: 2019-02-05 13:00:54.959 (4) [main]: time=0.006 2019-02-05 13:00:54.959 (3) [main]: main: 0.006s 2019-02-05 13:00:54.959 (4) [main]: time=0.03 2019-02-05 13:00:54.959 (3) [main]: P1T1: 0.030s 2019-02-05 13:00:54.959 (4) [main]: time=1.052 2019-02-05 13:00:54.959 (3) [main]: other: 1.052s [TSAApp@aml27-core1 2019-02-03]$