[TSAApp@aml-qa4-core1 bidmgr]$ ./admax.sh -d5 -a 2948 -z America/New_York -T 2021-03-12 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.36-BETA13-dev-t20210407051509/libs/deployment-bidmgr-shaded-jar-2.9.36-BETA13.jar!/core-jdb-datasource.properties ------- {datasource-user=spike, datasource-password=tar63t} 2021-04-07 06:43:19.955 (3) [main]: Debug Level set to 3 2021-04-07 06:43:19.956 (3) [main]: Licensing environment detected, loading configuration. 2021-04-07 06:43:19.957 (3) [main]: Loaded property: distribution-service-url=http://aml-qa4-front1:8080/distribution 2021-04-07 06:43:19.957 (3) [main]: Loaded property: distribution-service-username=readwrite 2021-04-07 06:43:19.957 (3) [main]: Loaded property: distribution-service-password=readwrite 2021-04-07 06:43:19.957 (3) [main]: Loaded property: sapi-auth-url=http://aml-qa4-front1:8080/sapi/rest/security/tokens 2021-04-07 06:43:19.957 (3) [main]: Loaded property: sapi-merchant-service-url=http://aml-qa4-front1:8080/sapi/rest/merchants 2021-04-07 06:43:19.957 (3) [main]: Loaded property: sapi-reseller-service-url=http://aml-qa4-front1:8080/sapi/rest/resellers 2021-04-07 06:43:19.957 (3) [main]: Loaded property: sapi-username=admin+tsa@thesearchagency.com 2021-04-07 06:43:19.957 (3) [main]: Loaded property: sapi-password=admin 2021-04-07 06:43:19.957 (3) [main]: Loaded property: sapi-realm=thesearchagency 2021-04-07 06:43:19.958 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg 2021-04-07 06:43:19.958 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true 2021-04-07 06:43:19.958 (3) [main]: Loaded property: tsa.google.mcc.userAgent=AdMaxLocal AdWords Software TSA QA 2021-04-07 06:43:19.958 (3) [main]: Loaded property: tsa.timezone=UTC 2021-04-07 06:43:19.959 (3) [main]: Debug Level set to 5 2021-04-07 06:43:19.959 (3) [main]: AdMax Summarizer parameters: -d5 -a 2948 -z America/New_York -T 2021-03-12 2021-04-07 06:43:20.040 (4) [main]: registered MBean [thesearchagency.db.util:type=MultiplexDatabasePoolfa2247a5-57b1-4789-8679-eb1c5c95902f] for class com.thesearchagency.db.util.MultiplexDatabasePool 2021-04-07 06:43:20.047 (5) [main]: ProfilerRec.start("AdMaxSummarizer",false) in Thread [main] 2021-04-07 06:43:20.051 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2021-04-07 06:43:20.291 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-04-07 06:43:20.291 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.293 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-04-07 06:43:20.293 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-logging") and (`type`="mysql")) limit 1] 2021-04-07 06:43:20.301 (5) [main]: recordAsSubs("db", 8, "main") 2021-04-07 06:43:20.301 (5) [main]: addSub("db") 2021-04-07 06:43:20.301 (5) [main]: ProfilerRec.end("db", true): ret=8 2021-04-07 06:43:20.302 (4) [main]: time=0.008 2021-04-07 06:43:20.302 (4) [main]: Query executed in 0.008s 2021-04-07 06:43:20.303 (5) [main]: loading 8 columns from result set: 2021-04-07 06:43:20.303 (5) [main]: loaded column: databaseInstances.id->4 2021-04-07 06:43:20.304 (5) [main]: loaded column: databaseInstances.name->global-logging 2021-04-07 06:43:20.304 (5) [main]: loaded column: databaseInstances.description->Global Logging Tables 2021-04-07 06:43:20.304 (5) [main]: loaded column: databaseInstances.type->mysql 2021-04-07 06:43:20.304 (5) [main]: loaded column: databaseInstances.database->logging 2021-04-07 06:43:20.304 (5) [main]: loaded column: databaseInstances.host->logging-01-write 2021-04-07 06:43:20.304 (5) [main]: loaded column: databaseInstances.port->3306 2021-04-07 06:43:20.304 (5) [main]: loaded column: databaseInstances.access->rw 2021-04-07 06:43:20.305 (4) [main]: Record Loaded 2021-04-07 06:43:20.305 (4) [main]: DataCache: put key global-logging 2021-04-07 06:43:20.305 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.308 (4) [main]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool2d0a1ad1-7f0f-41e6-ba36-1362d6a8a6a6] for class com.carldunham.jst.pooling.ObjectPool 2021-04-07 06:43:20.308 (3) [main]: DatabasePool with a limit of 18 created 2021-04-07 06:43:20.309 (4) [main]: registered MBean [com.carldunham.jst.db:type=DatabasePool9a18849e-d491-490c-980b-7920f028973b] for class com.carldunham.jst.db.DatabasePool 2021-04-07 06:43:20.312 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2021-04-07 06:43:20.334 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-04-07 06:43:20.334 (4) [main]: opened [jdbc:mysql://logging-01-write:3306/logging?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.335 (4) [main]: Created new Object 2021-04-07 06:43:20.335 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-04-07 06:43:20.335 (4) [main]: spike: SQL->[select @@version] 2021-04-07 06:43:20.338 (5) [main]: recordAsSubs("db", 3, "main") 2021-04-07 06:43:20.338 (5) [main]: addSub("db") 2021-04-07 06:43:20.338 (5) [main]: ProfilerRec.end("db", true): ret=3 2021-04-07 06:43:20.338 (4) [main]: time=0.003 2021-04-07 06:43:20.338 (4) [main]: Query executed in 0.003s 2021-04-07 06:43:20.339 (4) [main]: test query succeeded, returned "5.5.34" 2021-04-07 06:43:20.339 (4) [main]: preparing SQL statement [insert into logging.processHistory (processID, startTime) values (?,?)], genflags=yes 2021-04-07 06:43:20.356 (3) [main]: Could not save process history start 2021-04-07 06:43:20.356 (4) [main]: Returning Object to Pool 2021-04-07 06:43:20.357 (3) [main]: =============== Starting AdMax Summarizer ================ 2021-04-07 06:43:20.357 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2021-04-07 06:43:20.357 (3) [main]: ----------------AdMax Summarizer starting 2021-04-07 06:43:20.382 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-04-07 06:43:20.382 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.382 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-04-07 06:43:20.382 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (2948)) and (`tsacommon`.`accounts`.`timeZoneID` in ("America/New_York"))) order by rand()] 2021-04-07 06:43:20.386 (5) [main]: recordAsSubs("db", 4, "main") 2021-04-07 06:43:20.386 (5) [main]: addSub("db") 2021-04-07 06:43:20.386 (5) [main]: ProfilerRec.end("db", true): ret=4 2021-04-07 06:43:20.386 (4) [main]: time=0.004 2021-04-07 06:43:20.386 (4) [main]: Query executed in 0.004s 2021-04-07 06:43:20.387 (5) [main]: loading 21 columns from result set: 2021-04-07 06:43:20.387 (5) [main]: loaded column: accounts.id->2948 2021-04-07 06:43:20.390 (5) [main]: loaded column: accounts.description->d0c81a82-aa30-46ef-b067-29fc170658bb 2021-04-07 06:43:20.390 (5) [main]: loaded column: accounts.tier->1 2021-04-07 06:43:20.390 (5) [main]: loaded column: accounts.priority->50 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.reportClicksOut->false 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.reportConversions->false 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.conversionTypes->paid 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.isBidManaged->true 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.isActive->true 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.perfMetric->cpa 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.providesConversionData->true 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.addConversionData->true 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.hideNullSources->false 2021-04-07 06:43:20.391 (5) [main]: loaded column: accounts.nowTime->null 2021-04-07 06:43:20.394 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2021-04-07 06:43:20.394 (5) [main]: loaded column: accounts.databaseInstance->1 2021-04-07 06:43:20.394 (5) [main]: loaded column: accounts.warehouseInstance->1 2021-04-07 06:43:20.394 (5) [main]: loaded column: accounts.isOnline->true 2021-04-07 06:43:20.394 (5) [main]: loaded column: accounts.currencyCode->USD 2021-04-07 06:43:20.394 (5) [main]: loaded column: accounts.timeZoneID->America/New_York 2021-04-07 06:43:20.400 (3) [P1T1]: Starting Account ID #2948: d0c81a82-aa30-46ef-b067-29fc170658bb 2021-04-07 06:43:20.402 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-04-07 06:43:20.421 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-04-07 06:43:20.422 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.422 (5) [P1T1]: quoteValue(), nothing special about it=>[2948], type=class java.lang.Integer 2021-04-07 06:43:20.422 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.422 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=2948) limit 1] 2021-04-07 06:43:20.426 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2021-04-07 06:43:20.426 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.426 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2021-04-07 06:43:20.426 (4) [P1T1]: time=0.004 2021-04-07 06:43:20.426 (4) [P1T1]: Query executed in 0.004s 2021-04-07 06:43:20.426 (5) [P1T1]: loading 21 columns from result set: 2021-04-07 06:43:20.426 (5) [P1T1]: loaded column: accounts.id->2948 2021-04-07 06:43:20.426 (5) [P1T1]: loaded column: accounts.description->d0c81a82-aa30-46ef-b067-29fc170658bb 2021-04-07 06:43:20.426 (5) [P1T1]: loaded column: accounts.tier->1 2021-04-07 06:43:20.426 (5) [P1T1]: loaded column: accounts.priority->50 2021-04-07 06:43:20.426 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2021-04-07 06:43:20.426 (5) [P1T1]: loaded column: accounts.reportConversions->false 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.isActive->true 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.addConversionData->true 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.nowTime->null 2021-04-07 06:43:20.427 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2021-04-07 06:43:20.427 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2021-04-07 06:43:20.428 (5) [P1T1]: loaded column: accounts.isOnline->true 2021-04-07 06:43:20.428 (5) [P1T1]: loaded column: accounts.currencyCode->USD 2021-04-07 06:43:20.428 (5) [P1T1]: loaded column: accounts.timeZoneID->America/New_York 2021-04-07 06:43:20.428 (4) [P1T1]: Record Loaded 2021-04-07 06:43:20.428 (4) [P1T1]: DataCache: put key acct-st-tracker 2948 2021-04-07 06:43:20.428 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.428 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1] 2021-04-07 06:43:20.432 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2021-04-07 06:43:20.432 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.432 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2021-04-07 06:43:20.432 (4) [P1T1]: time=0.004 2021-04-07 06:43:20.432 (4) [P1T1]: Query executed in 0.004s 2021-04-07 06:43:20.432 (5) [P1T1]: loading 8 columns from result set: 2021-04-07 06:43:20.432 (5) [P1T1]: loaded column: databaseInstances.id->15 2021-04-07 06:43:20.432 (5) [P1T1]: loaded column: databaseInstances.name->acct-st-tracker-1 2021-04-07 06:43:20.432 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Catch-all database 2021-04-07 06:43:20.433 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2021-04-07 06:43:20.433 (5) [P1T1]: loaded column: databaseInstances.database->st-tracker 2021-04-07 06:43:20.433 (5) [P1T1]: loaded column: databaseInstances.host->acctdb-01-write 2021-04-07 06:43:20.433 (5) [P1T1]: loaded column: databaseInstances.port->3306 2021-04-07 06:43:20.433 (5) [P1T1]: loaded column: databaseInstances.access->rw 2021-04-07 06:43:20.433 (4) [P1T1]: Record Loaded 2021-04-07 06:43:20.433 (4) [P1T1]: DataCache: put key acct-st-tracker-1 2021-04-07 06:43:20.433 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.434 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPoold4783ce4-5384-405d-aeb4-b2999c92c3e7] for class com.carldunham.jst.pooling.ObjectPool 2021-04-07 06:43:20.434 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-04-07 06:43:20.434 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePool8079fb2a-97f9-46a7-9354-62194c7c8647] for class com.carldunham.jst.db.DatabasePool 2021-04-07 06:43:20.450 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-04-07 06:43:20.450 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.450 (4) [P1T1]: Created new Object 2021-04-07 06:43:20.450 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.450 (4) [P1T1]: spike: SQL->[select @@version] 2021-04-07 06:43:20.451 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.451 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.451 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.451 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.452 (4) [P1T1]: Query executed in 0.001s 2021-04-07 06:43:20.452 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-04-07 06:43:20.452 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-04-07 06:43:20.452 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPoolcb00de1b-88c4-43ea-8964-b6882be6ba54] for class com.carldunham.jst.pooling.ObjectPool 2021-04-07 06:43:20.452 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-04-07 06:43:20.452 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePool6cd6aac9-f9c6-49ab-a559-d6410b257d3c] for class com.carldunham.jst.db.DatabasePool 2021-04-07 06:43:20.460 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-04-07 06:43:20.460 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.461 (4) [P1T1]: Created new Object 2021-04-07 06:43:20.461 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.461 (4) [P1T1]: spike: SQL->[select @@version] 2021-04-07 06:43:20.462 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.462 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.462 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.462 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.462 (4) [P1T1]: Query executed in 0.001s 2021-04-07 06:43:20.462 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-04-07 06:43:20.462 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-04-07 06:43:20.470 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-04-07 06:43:20.470 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.471 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.471 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-staging") and (`type`="mysql")) limit 1] 2021-04-07 06:43:20.473 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-04-07 06:43:20.473 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.473 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-04-07 06:43:20.473 (4) [P1T1]: time=0.002 2021-04-07 06:43:20.473 (4) [P1T1]: Query executed in 0.002s 2021-04-07 06:43:20.473 (5) [P1T1]: loading 8 columns from result set: 2021-04-07 06:43:20.473 (5) [P1T1]: loaded column: databaseInstances.id->3 2021-04-07 06:43:20.473 (5) [P1T1]: loaded column: databaseInstances.name->global-staging 2021-04-07 06:43:20.473 (5) [P1T1]: loaded column: databaseInstances.description->Global Staging Tables 2021-04-07 06:43:20.473 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2021-04-07 06:43:20.473 (5) [P1T1]: loaded column: databaseInstances.database->staging 2021-04-07 06:43:20.473 (5) [P1T1]: loaded column: databaseInstances.host->staging-01-write 2021-04-07 06:43:20.474 (5) [P1T1]: loaded column: databaseInstances.port->3306 2021-04-07 06:43:20.474 (5) [P1T1]: loaded column: databaseInstances.access->rw 2021-04-07 06:43:20.474 (4) [P1T1]: Record Loaded 2021-04-07 06:43:20.474 (4) [P1T1]: DataCache: put key global-staging 2021-04-07 06:43:20.474 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.474 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool160fa2f9-3929-42c6-85a3-8514740d5a32] for class com.carldunham.jst.pooling.ObjectPool 2021-04-07 06:43:20.474 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-04-07 06:43:20.474 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePoolba59f247-7ce4-46be-a7b5-0c452605cbf8] for class com.carldunham.jst.db.DatabasePool 2021-04-07 06:43:20.484 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-04-07 06:43:20.484 (4) [P1T1]: opened [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.485 (4) [P1T1]: Created new Object 2021-04-07 06:43:20.485 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.485 (4) [P1T1]: spike: SQL->[select @@version] 2021-04-07 06:43:20.486 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.486 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.486 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.486 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.486 (4) [P1T1]: Query executed in 0.001s 2021-04-07 06:43:20.486 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-04-07 06:43:20.486 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-04-07 06:43:20.494 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-04-07 06:43:20.494 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.495 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.495 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-clients") and (`type`="mysql")) limit 1] 2021-04-07 06:43:20.496 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.496 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.496 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.497 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.497 (4) [P1T1]: Query executed in 0.001s 2021-04-07 06:43:20.497 (5) [P1T1]: loading 8 columns from result set: 2021-04-07 06:43:20.497 (5) [P1T1]: loaded column: databaseInstances.id->13 2021-04-07 06:43:20.497 (5) [P1T1]: loaded column: databaseInstances.name->global-clients 2021-04-07 06:43:20.497 (5) [P1T1]: loaded column: databaseInstances.description->Global Database for client-specific tables 2021-04-07 06:43:20.497 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2021-04-07 06:43:20.497 (5) [P1T1]: loaded column: databaseInstances.database->clients 2021-04-07 06:43:20.497 (5) [P1T1]: loaded column: databaseInstances.host->clients-01-write 2021-04-07 06:43:20.497 (5) [P1T1]: loaded column: databaseInstances.port->3306 2021-04-07 06:43:20.497 (5) [P1T1]: loaded column: databaseInstances.access->rw 2021-04-07 06:43:20.497 (4) [P1T1]: Record Loaded 2021-04-07 06:43:20.497 (4) [P1T1]: DataCache: put key global-clients 2021-04-07 06:43:20.497 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.497 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool5a0beca6-de5b-4d56-9de8-c3ddc1dda530] for class com.carldunham.jst.pooling.ObjectPool 2021-04-07 06:43:20.498 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-04-07 06:43:20.498 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePoolf8c68348-9082-4889-b918-82ec231fc77a] for class com.carldunham.jst.db.DatabasePool 2021-04-07 06:43:20.507 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-04-07 06:43:20.507 (4) [P1T1]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:20.507 (4) [P1T1]: Created new Object 2021-04-07 06:43:20.507 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.507 (4) [P1T1]: spike: SQL->[select @@version] 2021-04-07 06:43:20.508 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.508 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.508 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.508 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.508 (4) [P1T1]: Query executed in 0.001s 2021-04-07 06:43:20.508 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-04-07 06:43:20.509 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.509 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.2948', 600)] 2021-04-07 06:43:20.511 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-04-07 06:43:20.511 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.511 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-04-07 06:43:20.511 (4) [P1T1]: time=0.002 2021-04-07 06:43:20.511 (4) [P1T1]: Query executed in 0.002s 2021-04-07 06:43:20.511 (3) [P1T1]: Got migrator lock for Account ID #2948 2021-04-07 06:43:20.513 (5) [P1T1]: quoteValue(), nothing special about it=>[2948], type=class java.lang.Integer 2021-04-07 06:43:20.517 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.517 (4) [P1T1]: spike: SQL->[select * from `settings` where ((((`settings`.`scope`="accounts")) and ((`settings`.`scopeId`=2948))))] 2021-04-07 06:43:20.521 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2021-04-07 06:43:20.521 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.521 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2021-04-07 06:43:20.521 (4) [P1T1]: time=0.004 2021-04-07 06:43:20.521 (4) [P1T1]: Query executed in 0.004s 2021-04-07 06:43:20.522 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.522 (4) [P1T1]: spike: SQL->[select * from `settingDefaults` where (`settingDefaults`.`scope`="accounts")] 2021-04-07 06:43:20.523 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.523 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.524 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.524 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.524 (4) [P1T1]: Query executed in 0.001s 2021-04-07 06:43:20.524 (4) [P1T1]: DataCache: put key accounts 2948 2021-04-07 06:43:20.962 (4) [P1T1]: DataCache: Found key accounts 2948 2021-04-07 06:43:20.962 (4) [P1T1]: Settings.getSettings: loaded from cache (key=accounts 2948) 2021-04-07 06:43:20.962 (3) [P1T1]: Applying algorithm [SABB] for Account ID #2948 in distributions [3, 178, 147, 177] 2021-04-07 06:43:20.965 (3) [P1T1]: Processing data for 2021-03-12 00:00:00 EST 2021-04-07 06:43:20.969 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2021-04-07 06:43:20.969 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.969 (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`="2948"))) and ((`tsacommon`.`searchEngineAccounts`.`distributionID` in (3))))) order by rand()] 2021-04-07 06:43:20.971 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-04-07 06:43:20.971 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.971 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-04-07 06:43:20.971 (4) [P1T1]: time=0.002 2021-04-07 06:43:20.971 (4) [P1T1]: Query executed in 0.002s 2021-04-07 06:43:20.974 (5) [P1T1]: quoteValue(), nothing special about it=>[2948], type=class java.lang.Integer 2021-04-07 06:43:20.974 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.974 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=2948) and (`typeID`="") and (`type`="admax")) limit 1] 2021-04-07 06:43:20.975 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.975 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.975 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.975 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.976 (4) [P1T1]: Query executed in 0.001s 2021-04-07 06:43:20.976 (5) [P1T1]: loading 4 columns from result set: 2021-04-07 06:43:20.976 (5) [P1T1]: loaded column: dataSources.id->12800 2021-04-07 06:43:20.976 (5) [P1T1]: loaded column: dataSources.type->admax 2021-04-07 06:43:20.976 (5) [P1T1]: loaded column: dataSources.typeID->0 2021-04-07 06:43:20.976 (5) [P1T1]: loaded column: dataSources.accountID->2948 2021-04-07 06:43:20.976 (4) [P1T1]: Record Loaded 2021-04-07 06:43:20.976 (5) [P1T1]: quoteValue(), nothing special about it=>[2948], type=class java.lang.Integer 2021-04-07 06:43:20.976 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.976 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`dataSources`.`type`="admax") and (`dataSources`.`accountID`=2948))] 2021-04-07 06:43:20.977 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.978 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.978 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.978 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.978 (4) [P1T1]: Query executed in 0.001s 2021-04-07 06:43:20.978 (5) [P1T1]: loading 4 columns from result set: 2021-04-07 06:43:20.978 (5) [P1T1]: loaded column: dataSources.id->12800 2021-04-07 06:43:20.978 (5) [P1T1]: loaded column: dataSources.type->admax 2021-04-07 06:43:20.978 (5) [P1T1]: loaded column: dataSources.typeID->0 2021-04-07 06:43:20.978 (5) [P1T1]: loaded column: dataSources.accountID->2948 2021-04-07 06:43:20.979 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.980 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`date`="2021-03-12 00:00:00") and (`dataSourceID`="12800")) limit 1] 2021-04-07 06:43:20.981 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.981 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.981 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.981 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.981 (4) [P1T1]: Query executed in 0.001s 2021-04-07 06:43:20.981 (5) [P1T1]: loading 9 columns from result set: 2021-04-07 06:43:20.981 (5) [P1T1]: loaded column: dataAvailability.id->79522 2021-04-07 06:43:20.982 (5) [P1T1]: loaded column: dataAvailability.date->2021-03-12 2021-04-07 06:43:20.982 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2021-04-07 06:43:20.982 (5) [P1T1]: loaded column: dataAvailability.updated->2021-04-07 06:38:24.0 2021-04-07 06:43:20.982 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->12800 2021-04-07 06:43:20.982 (5) [P1T1]: loaded column: dataAvailability.status->success 2021-04-07 06:43:20.982 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2021-04-07 06:43:20.982 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2021-04-07 06:43:20.982 (5) [P1T1]: loaded column: dataAvailability.override->false 2021-04-07 06:43:20.982 (4) [P1T1]: Record Loaded 2021-04-07 06:43:20.982 (5) [P1T1]: quoteValue(), nothing special about it=>[12800], type=class java.lang.Integer 2021-04-07 06:43:20.982 (5) [P1T1]: quoteValue(), nothing special about it=>[79522], type=class java.lang.Integer 2021-04-07 06:43:20.983 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.983 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`date`,`dataSourceID`,`statusText`,`id`,`override`,`updated`,`oldUpdated`,`status`,`needsRerun`) values ("2021-03-12",12800,null,79522,"false","2021-04-07 06:43:20","00:00:00","in progress","false")], genflags=yes 2021-04-07 06:43:20.984 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.984 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.984 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.984 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.984 (4) [P1T1]: Query executed in 0.001s, 2 row(s) affected 2021-04-07 06:43:20.986 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:20.986 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`date`,`dataSourceID`,`override`,`updated`,`status`) values ("2021-03-12 00:00:00","12800","false","2021-04-07 06:43:20","in progress")], genflags=yes 2021-04-07 06:43:20.987 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:20.987 (5) [P1T1]: addSub("db") 2021-04-07 06:43:20.987 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:20.987 (4) [P1T1]: time=0.001 2021-04-07 06:43:20.987 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2021-04-07 06:43:20.992 (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>=?)] 2021-04-07 06:43:20.996 (4) [P1T1]: preparing SQL statement [select ID,accountID,admaxCampaignID,searchEngineAccountID,migrationDate,lastAdMaxRunDate from `st-tracker`.admaxCampaignMigrations where accountID=? and migrationDate>=? and lastAdMaxRunDate<=?] 2021-04-07 06:43:20.997 (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>=?)] 2021-04-07 06:43:21.003 (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>=?)] 2021-04-07 06:43:21.005 (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>=?)] 2021-04-07 06:43:21.007 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2021-04-07 06:43:21.008 (3) [P1T1]: Retrieved campaign status Active for AdMax campaign 10738 2021-04-07 06:43:21.008 (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>=?)] 2021-04-07 06:43:21.009 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2021-04-07 06:43:21.010 (3) [P1T1]: Retrieved campaign status Active for AdMax campaign 10738 2021-04-07 06:43:21.010 (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 = ?] 2021-04-07 06:43:21.012 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2021-04-07 06:43:21.013 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.googleMccAdMax.date,staging.googleMccAdMax.clicks,staging.googleMccAdMax.cost,staging.googleMccAdMax.averagePosition 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=?] 2021-04-07 06:43:21.014 (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=?] 2021-04-07 06:43:21.015 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.bingAdMax.date,staging.bingAdMax.clicks,staging.bingAdMax.cost,staging.bingAdMax.averagePosition from tsacommon.searchEngineAccounts left join staging.bingAdMax on staging.bingAdMax.campaignid=cast(tsacommon.searchEngineAccounts.searchEngineIdentifier as unsigned) where tsacommon.searchEngineAccounts.accountID=? and staging.bingAdMax.date=?] 2021-04-07 06:43:21.016 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.facebookAdMax.date,staging.facebookAdMax.clicks,staging.facebookAdMax.cost,staging.facebookAdMax.averagePosition from tsacommon.searchEngineAccounts left join staging.facebookAdMax on staging.facebookAdMax.campaignid=cast(tsacommon.searchEngineAccounts.searchEngineIdentifier as unsigned) where tsacommon.searchEngineAccounts.accountID=? and staging.facebookAdMax.date=?] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'staging.facebookAdMax.averagePosition' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379) at com.thesearchagency.admax.dao.FacebookAdMaxDAO.find(FacebookAdMaxDAO.java:87) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBDataSource.getStagingData(AdMaxSABBDataSource.java:615) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBDataSource.getStagingData(AdMaxSABBDataSource.java:602) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBDataSource.getPerformanceData(AdMaxSABBDataSource.java:593) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBDataSource.initializeData(AdMaxSABBDataSource.java:157) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.applyAlgorithm(AdMaxSABBAlgorithm.java:292) at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.call(AdMaxSummarizer.java:644) at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.call(AdMaxSummarizer.java:505) 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) 2021-04-07 06:43:21.018 (2) [P1T1]: Unable to initialize data for Account ID #2948 2021-04-07 06:43:21.018 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:21.018 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`date`="2021-03-12 00:00:00") and (`dataSourceID`="12800")) limit 1] 2021-04-07 06:43:21.026 (5) [P1T1]: recordAsSubs("db", 8, "P1T1") 2021-04-07 06:43:21.026 (5) [P1T1]: addSub("db") 2021-04-07 06:43:21.027 (5) [P1T1]: ProfilerRec.end("db", true): ret=8 2021-04-07 06:43:21.027 (4) [P1T1]: time=0.008 2021-04-07 06:43:21.027 (4) [P1T1]: Query executed in 0.008s 2021-04-07 06:43:21.027 (5) [P1T1]: loading 9 columns from result set: 2021-04-07 06:43:21.027 (5) [P1T1]: loaded column: dataAvailability.id->79522 2021-04-07 06:43:21.027 (5) [P1T1]: loaded column: dataAvailability.date->2021-03-12 2021-04-07 06:43:21.027 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2021-04-07 06:43:21.027 (5) [P1T1]: loaded column: dataAvailability.updated->2021-04-07 06:43:20.0 2021-04-07 06:43:21.027 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->12800 2021-04-07 06:43:21.027 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2021-04-07 06:43:21.027 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2021-04-07 06:43:21.027 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2021-04-07 06:43:21.027 (5) [P1T1]: loaded column: dataAvailability.override->false 2021-04-07 06:43:21.027 (4) [P1T1]: Record Loaded 2021-04-07 06:43:21.027 (5) [P1T1]: quoteValue(), nothing special about it=>[12800], type=class java.lang.Integer 2021-04-07 06:43:21.027 (5) [P1T1]: quoteValue(), nothing special about it=>[79522], type=class java.lang.Integer 2021-04-07 06:43:21.028 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:21.028 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`date`,`dataSourceID`,`statusText`,`id`,`override`,`updated`,`oldUpdated`,`status`,`needsRerun`) values ("2021-03-12",12800,null,79522,"false","2021-04-07 06:43:21","00:00:00","success","false")], genflags=yes 2021-04-07 06:43:21.031 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2021-04-07 06:43:21.031 (5) [P1T1]: addSub("db") 2021-04-07 06:43:21.031 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2021-04-07 06:43:21.031 (4) [P1T1]: time=0.003 2021-04-07 06:43:21.031 (4) [P1T1]: Query executed in 0.003s, 2 row(s) affected 2021-04-07 06:43:21.032 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:21.032 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`date`,`dataSourceID`,`override`,`updated`,`status`) values ("2021-03-12 00:00:00","12800","false","2021-04-07 06:43:21","success")], genflags=yes 2021-04-07 06:43:21.033 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-04-07 06:43:21.033 (5) [P1T1]: addSub("db") 2021-04-07 06:43:21.033 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:21.033 (4) [P1T1]: time=0.001 2021-04-07 06:43:21.033 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2021-04-07 06:43:21.033 (3) [P1T1]: Finished applying algorithm [SABB] for account [2948] in distributions [3, 178, 147, 177] 2021-04-07 06:43:21.033 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-04-07 06:43:21.033 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.2948')] 2021-04-07 06:43:21.035 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-04-07 06:43:21.035 (5) [P1T1]: addSub("db") 2021-04-07 06:43:21.035 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-04-07 06:43:21.035 (4) [P1T1]: time=0.002 2021-04-07 06:43:21.035 (4) [P1T1]: Query executed in 0.002s 2021-04-07 06:43:21.035 (3) [P1T1]: Released migrator lock for Account ID #2948 2021-04-07 06:43:21.035 (4) [P1T1]: Returning Object to Pool 2021-04-07 06:43:21.035 (4) [P1T1]: Returning Object to Pool 2021-04-07 06:43:21.035 (4) [P1T1]: Returning Object to Pool 2021-04-07 06:43:21.035 (4) [P1T1]: Returning Object to Pool 2021-04-07 06:43:21.035 (3) [P1T1]: Completed Account ID #2948: d0c81a82-aa30-46ef-b067-29fc170658bb 2021-04-07 06:43:21.035 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-04-07 06:43:21.035 (3) [main]: ------------AdMax Summarizer done 2021-04-07 06:43:21.035 (3) [main]: =============== Completed AdMax Summarizer ================ 2021-04-07 06:43:21.036 (4) [main]: DataCache: Found key global-logging 2021-04-07 06:43:21.036 (4) [main]: Took Existing Object from Pool 2021-04-07 06:43:21.036 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-04-07 06:43:21.036 (4) [main]: spike: SQL->[select @@version] 2021-04-07 06:43:21.037 (2) [main]: Warning(s) detected in statement [select @@version] executed by user [spike] 2021-04-07 06:43:21.037 (2) [main]: Table 'logging.processHistory' doesn't exist (1146) 2021-04-07 06:43:21.037 (5) [main]: recordAsSubs("db", 1, "main") 2021-04-07 06:43:21.037 (5) [main]: addSub("db") 2021-04-07 06:43:21.037 (5) [main]: ProfilerRec.end("db", true): ret=1 2021-04-07 06:43:21.037 (4) [main]: time=0.001 2021-04-07 06:43:21.037 (4) [main]: Query executed in 0.001s 2021-04-07 06:43:21.037 (4) [main]: test query succeeded, returned "5.5.34" 2021-04-07 06:43:21.037 (3) [main]: Could not save process history stop 2021-04-07 06:43:21.037 (4) [main]: Returning Object to Pool 2021-04-07 06:43:21.038 (3) [main]: =============== Stats ================ 2021-04-07 06:43:21.038 (3) [main]: --- Process --- 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: ABU Process(start): Wed Apr 07 06:43:20 UTC 2021 2021-04-07 06:43:21.038 (3) [main]: ABU Process(stop): Wed Apr 07 06:43:21 UTC 2021 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: --- Accounts --- 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: Accounts Processed: 1 2021-04-07 06:43:21.038 (3) [main]: Accounts Skipped: 0 2021-04-07 06:43:21.038 (3) [main]: Accounts Processed Successfully: 0 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: --- Campaigns --- 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: Campaigns Processed: 1 2021-04-07 06:43:21.038 (3) [main]: Campaigns Processed Successfully: 0 2021-04-07 06:43:21.038 (3) [main]: Campaign Budgets Capped: 0 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: --- SE Campaigns --- 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: SE Campaigns Processed: 1 2021-04-07 06:43:21.038 (3) [main]: SE Campaigns Processed Successfully: 0 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: --- Budget/Spend --- 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: SE Campaign Budgets Updated: 0 2021-04-07 06:43:21.038 (3) [main]: SE Campaign Budgets Sent To Google: 0 2021-04-07 06:43:21.038 (3) [main]: SE Campaign Budgets Sent To Yahoo Japan:0 2021-04-07 06:43:21.038 (3) [main]: SE Campaign Budgets Sent To Bing: 0 2021-04-07 06:43:21.038 (3) [main]: SE Campaign Budgets Sent To Facebook: 0 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: Spend Total: 0.0 2021-04-07 06:43:21.038 (3) [main]: Common Carryover Total: 0.0 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: --- Bids --- 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.038 (3) [main]: New Campaign Bids: 0 2021-04-07 06:43:21.038 (3) [main]: 2021-04-07 06:43:21.039 (5) [main]: ProfilerRec.end("AdMaxSummarizer", false): ret=992 2021-04-07 06:43:21.039 (4) [main]: time=0.992 2021-04-07 06:43:21.039 (3) [main]: AdMaxSummarizer: 0.992s 2021-04-07 06:43:21.039 (3) [main]: by key: 2021-04-07 06:43:21.039 (4) [main]: time=0.059 2021-04-07 06:43:21.039 (3) [main]: db: 0.059s 2021-04-07 06:43:21.039 (3) [main]: by thread: 2021-04-07 06:43:21.039 (4) [main]: time=0.016 2021-04-07 06:43:21.039 (3) [main]: main: 0.016s 2021-04-07 06:43:21.039 (4) [main]: time=0.043 2021-04-07 06:43:21.039 (3) [main]: P1T1: 0.043s 2021-04-07 06:43:21.039 (4) [main]: time=0.933 2021-04-07 06:43:21.039 (3) [main]: other: 0.933s