[TSAApp@aml-qa4-core1 bidmgr]$ ./admax.sh -d5 -a 2987 -z America/New_York -T 2021-06-02 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-BETA22-dev-t20210602140559/libs/deployment-bidmgr-shaded-jar-2.9.36-BETA22.jar!/core-jdb-datasource.properties ------- {datasource-user=spike, datasource-password=tar63t} 2021-06-03 13:24:14.682 (3) [main]: Debug Level set to 3 2021-06-03 13:24:14.683 (3) [main]: Licensing environment detected, loading configuration. 2021-06-03 13:24:14.684 (3) [main]: Loaded property: distribution-service-url=http://aml-qa4-front1:8080/distribution 2021-06-03 13:24:14.684 (3) [main]: Loaded property: distribution-service-username=readwrite 2021-06-03 13:24:14.684 (3) [main]: Loaded property: distribution-service-password=readwrite 2021-06-03 13:24:14.684 (3) [main]: Loaded property: sapi-auth-url=http://aml-qa4-front1:8080/sapi/rest/security/tokens 2021-06-03 13:24:14.684 (3) [main]: Loaded property: sapi-merchant-service-url=http://aml-qa4-front1:8080/sapi/rest/merchants 2021-06-03 13:24:14.684 (3) [main]: Loaded property: sapi-reseller-service-url=http://aml-qa4-front1:8080/sapi/rest/resellers 2021-06-03 13:24:14.684 (3) [main]: Loaded property: sapi-username=admin+tsa@thesearchagency.com 2021-06-03 13:24:14.684 (3) [main]: Loaded property: sapi-password=admin 2021-06-03 13:24:14.684 (3) [main]: Loaded property: sapi-realm=thesearchagency 2021-06-03 13:24:14.685 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg 2021-06-03 13:24:14.685 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true 2021-06-03 13:24:14.685 (3) [main]: Loaded property: tsa.google.mcc.userAgent=AdMaxLocal AdWords Software TSA QA 2021-06-03 13:24:14.685 (3) [main]: Loaded property: tsa.timezone=UTC 2021-06-03 13:24:14.686 (3) [main]: Debug Level set to 5 2021-06-03 13:24:14.686 (3) [main]: AdMax Summarizer parameters: -d5 -a 2987 -z America/New_York -T 2021-06-02 2021-06-03 13:24:14.769 (4) [main]: registered MBean [thesearchagency.db.util:type=MultiplexDatabasePool15cae85f-6d07-4bcc-88c2-3baee5aa18bf] for class com.thesearchagency.db.util.MultiplexDatabasePool 2021-06-03 13:24:14.775 (5) [main]: ProfilerRec.start("AdMaxSummarizer",false) in Thread [main] 2021-06-03 13:24:14.780 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2021-06-03 13:24:15.014 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-06-03 13:24:15.014 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.017 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-06-03 13:24:15.017 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-logging") and (`type`="mysql")) limit 1] 2021-06-03 13:24:15.022 (5) [main]: recordAsSubs("db", 5, "main") 2021-06-03 13:24:15.022 (5) [main]: addSub("db") 2021-06-03 13:24:15.022 (5) [main]: ProfilerRec.end("db", true): ret=5 2021-06-03 13:24:15.023 (4) [main]: time=0.005 2021-06-03 13:24:15.023 (4) [main]: Query executed in 0.005s 2021-06-03 13:24:15.024 (5) [main]: loading 8 columns from result set: 2021-06-03 13:24:15.024 (5) [main]: loaded column: databaseInstances.id->4 2021-06-03 13:24:15.025 (5) [main]: loaded column: databaseInstances.name->global-logging 2021-06-03 13:24:15.025 (5) [main]: loaded column: databaseInstances.description->Global Logging Tables 2021-06-03 13:24:15.025 (5) [main]: loaded column: databaseInstances.type->mysql 2021-06-03 13:24:15.025 (5) [main]: loaded column: databaseInstances.database->logging 2021-06-03 13:24:15.025 (5) [main]: loaded column: databaseInstances.host->logging-01-write 2021-06-03 13:24:15.025 (5) [main]: loaded column: databaseInstances.port->3306 2021-06-03 13:24:15.025 (5) [main]: loaded column: databaseInstances.access->rw 2021-06-03 13:24:15.026 (4) [main]: Record Loaded 2021-06-03 13:24:15.026 (4) [main]: DataCache: put key global-logging 2021-06-03 13:24:15.026 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.029 (4) [main]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool77996f85-3f57-4de9-868e-2ee558965762] for class com.carldunham.jst.pooling.ObjectPool 2021-06-03 13:24:15.029 (3) [main]: DatabasePool with a limit of 18 created 2021-06-03 13:24:15.030 (4) [main]: registered MBean [com.carldunham.jst.db:type=DatabasePool760572bf-691a-4dfb-be03-8c7e7b5b62f7] for class com.carldunham.jst.db.DatabasePool 2021-06-03 13:24:15.032 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2021-06-03 13:24:15.046 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-06-03 13:24:15.046 (4) [main]: opened [jdbc:mysql://logging-01-write:3306/logging?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.046 (4) [main]: Created new Object 2021-06-03 13:24:15.046 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-06-03 13:24:15.046 (4) [main]: spike: SQL->[select @@version] 2021-06-03 13:24:15.048 (5) [main]: recordAsSubs("db", 2, "main") 2021-06-03 13:24:15.048 (5) [main]: addSub("db") 2021-06-03 13:24:15.048 (5) [main]: ProfilerRec.end("db", true): ret=2 2021-06-03 13:24:15.048 (4) [main]: time=0.002 2021-06-03 13:24:15.048 (4) [main]: Query executed in 0.002s 2021-06-03 13:24:15.048 (4) [main]: test query succeeded, returned "5.5.34" 2021-06-03 13:24:15.049 (4) [main]: preparing SQL statement [insert into logging.processHistory (processID, startTime) values (?,?)], genflags=yes 2021-06-03 13:24:15.063 (3) [main]: Could not save process history start 2021-06-03 13:24:15.063 (4) [main]: Returning Object to Pool 2021-06-03 13:24:15.063 (3) [main]: =============== Starting AdMax Summarizer ================ 2021-06-03 13:24:15.063 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2021-06-03 13:24:15.064 (3) [main]: ----------------AdMax Summarizer starting 2021-06-03 13:24:15.078 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-06-03 13:24:15.079 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.079 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-06-03 13:24:15.079 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (2987)) and (`tsacommon`.`accounts`.`timeZoneID` in ("America/New_York"))) order by rand()] 2021-06-03 13:24:15.080 (5) [main]: recordAsSubs("db", 1, "main") 2021-06-03 13:24:15.080 (5) [main]: addSub("db") 2021-06-03 13:24:15.080 (5) [main]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:15.080 (4) [main]: time=0.001 2021-06-03 13:24:15.081 (4) [main]: Query executed in 0.001s 2021-06-03 13:24:15.081 (5) [main]: loading 21 columns from result set: 2021-06-03 13:24:15.081 (5) [main]: loaded column: accounts.id->2987 2021-06-03 13:24:15.082 (5) [main]: loaded column: accounts.description->11a78c10-617f-44ec-8b4a-39c331269394 2021-06-03 13:24:15.082 (5) [main]: loaded column: accounts.tier->1 2021-06-03 13:24:15.082 (5) [main]: loaded column: accounts.priority->50 2021-06-03 13:24:15.082 (5) [main]: loaded column: accounts.reportClicksOut->false 2021-06-03 13:24:15.082 (5) [main]: loaded column: accounts.reportConversions->false 2021-06-03 13:24:15.082 (5) [main]: loaded column: accounts.conversionTypes->paid 2021-06-03 13:24:15.082 (5) [main]: loaded column: accounts.isBidManaged->true 2021-06-03 13:24:15.082 (5) [main]: loaded column: accounts.isActive->true 2021-06-03 13:24:15.083 (5) [main]: loaded column: accounts.perfMetric->cpa 2021-06-03 13:24:15.083 (5) [main]: loaded column: accounts.providesConversionData->true 2021-06-03 13:24:15.083 (5) [main]: loaded column: accounts.addConversionData->true 2021-06-03 13:24:15.083 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2021-06-03 13:24:15.083 (5) [main]: loaded column: accounts.hideNullSources->false 2021-06-03 13:24:15.083 (5) [main]: loaded column: accounts.nowTime->null 2021-06-03 13:24:15.085 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2021-06-03 13:24:15.086 (5) [main]: loaded column: accounts.databaseInstance->1 2021-06-03 13:24:15.086 (5) [main]: loaded column: accounts.warehouseInstance->1 2021-06-03 13:24:15.086 (5) [main]: loaded column: accounts.isOnline->true 2021-06-03 13:24:15.086 (5) [main]: loaded column: accounts.currencyCode->USD 2021-06-03 13:24:15.086 (5) [main]: loaded column: accounts.timeZoneID->America/New_York 2021-06-03 13:24:15.093 (3) [P1T1]: Starting Account ID #2987: 11a78c10-617f-44ec-8b4a-39c331269394 2021-06-03 13:24:15.093 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-06-03 13:24:15.106 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-06-03 13:24:15.107 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.107 (5) [P1T1]: quoteValue(), nothing special about it=>[2987], type=class java.lang.Integer 2021-06-03 13:24:15.107 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.107 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=2987) limit 1] 2021-06-03 13:24:15.110 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2021-06-03 13:24:15.110 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.111 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2021-06-03 13:24:15.111 (4) [P1T1]: time=0.003 2021-06-03 13:24:15.111 (4) [P1T1]: Query executed in 0.003s 2021-06-03 13:24:15.111 (5) [P1T1]: loading 21 columns from result set: 2021-06-03 13:24:15.111 (5) [P1T1]: loaded column: accounts.id->2987 2021-06-03 13:24:15.111 (5) [P1T1]: loaded column: accounts.description->11a78c10-617f-44ec-8b4a-39c331269394 2021-06-03 13:24:15.111 (5) [P1T1]: loaded column: accounts.tier->1 2021-06-03 13:24:15.111 (5) [P1T1]: loaded column: accounts.priority->50 2021-06-03 13:24:15.111 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2021-06-03 13:24:15.111 (5) [P1T1]: loaded column: accounts.reportConversions->false 2021-06-03 13:24:15.111 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2021-06-03 13:24:15.111 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2021-06-03 13:24:15.112 (5) [P1T1]: loaded column: accounts.isActive->true 2021-06-03 13:24:15.112 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2021-06-03 13:24:15.112 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2021-06-03 13:24:15.112 (5) [P1T1]: loaded column: accounts.addConversionData->true 2021-06-03 13:24:15.112 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2021-06-03 13:24:15.112 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2021-06-03 13:24:15.112 (5) [P1T1]: loaded column: accounts.nowTime->null 2021-06-03 13:24:15.112 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2021-06-03 13:24:15.112 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2021-06-03 13:24:15.112 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2021-06-03 13:24:15.112 (5) [P1T1]: loaded column: accounts.isOnline->true 2021-06-03 13:24:15.113 (5) [P1T1]: loaded column: accounts.currencyCode->USD 2021-06-03 13:24:15.113 (5) [P1T1]: loaded column: accounts.timeZoneID->America/New_York 2021-06-03 13:24:15.113 (4) [P1T1]: Record Loaded 2021-06-03 13:24:15.113 (4) [P1T1]: DataCache: put key acct-st-tracker 2987 2021-06-03 13:24:15.113 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.113 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1] 2021-06-03 13:24:15.115 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-06-03 13:24:15.115 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.115 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-06-03 13:24:15.115 (4) [P1T1]: time=0.002 2021-06-03 13:24:15.115 (4) [P1T1]: Query executed in 0.002s 2021-06-03 13:24:15.115 (5) [P1T1]: loading 8 columns from result set: 2021-06-03 13:24:15.115 (5) [P1T1]: loaded column: databaseInstances.id->15 2021-06-03 13:24:15.115 (5) [P1T1]: loaded column: databaseInstances.name->acct-st-tracker-1 2021-06-03 13:24:15.115 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Catch-all database 2021-06-03 13:24:15.116 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2021-06-03 13:24:15.116 (5) [P1T1]: loaded column: databaseInstances.database->st-tracker 2021-06-03 13:24:15.116 (5) [P1T1]: loaded column: databaseInstances.host->acctdb-01-write 2021-06-03 13:24:15.116 (5) [P1T1]: loaded column: databaseInstances.port->3306 2021-06-03 13:24:15.116 (5) [P1T1]: loaded column: databaseInstances.access->rw 2021-06-03 13:24:15.116 (4) [P1T1]: Record Loaded 2021-06-03 13:24:15.116 (4) [P1T1]: DataCache: put key acct-st-tracker-1 2021-06-03 13:24:15.116 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.116 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool790a3ae1-e11a-4755-95d6-3340c1c8afdb] for class com.carldunham.jst.pooling.ObjectPool 2021-06-03 13:24:15.117 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-06-03 13:24:15.117 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePool0ff510ac-7da7-43a1-86fc-c06e5fcb9e68] for class com.carldunham.jst.db.DatabasePool 2021-06-03 13:24:15.128 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-06-03 13:24:15.128 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.128 (4) [P1T1]: Created new Object 2021-06-03 13:24:15.128 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.128 (4) [P1T1]: spike: SQL->[select @@version] 2021-06-03 13:24:15.129 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:15.129 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.130 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:15.130 (4) [P1T1]: time=0.001 2021-06-03 13:24:15.130 (4) [P1T1]: Query executed in 0.001s 2021-06-03 13:24:15.130 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-06-03 13:24:15.130 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-06-03 13:24:15.130 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool70c56b38-4da9-47a3-ab59-5ba142261622] for class com.carldunham.jst.pooling.ObjectPool 2021-06-03 13:24:15.130 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-06-03 13:24:15.130 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePool9cb62a74-92db-46f4-9780-ea375e1a79fe] for class com.carldunham.jst.db.DatabasePool 2021-06-03 13:24:15.143 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-06-03 13:24:15.144 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.144 (4) [P1T1]: Created new Object 2021-06-03 13:24:15.144 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.144 (4) [P1T1]: spike: SQL->[select @@version] 2021-06-03 13:24:15.149 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2021-06-03 13:24:15.149 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.149 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2021-06-03 13:24:15.149 (4) [P1T1]: time=0.005 2021-06-03 13:24:15.149 (4) [P1T1]: Query executed in 0.005s 2021-06-03 13:24:15.149 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-06-03 13:24:15.149 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-06-03 13:24:15.159 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-06-03 13:24:15.159 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.159 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.159 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-staging") and (`type`="mysql")) limit 1] 2021-06-03 13:24:15.161 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-06-03 13:24:15.161 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.161 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-06-03 13:24:15.161 (4) [P1T1]: time=0.002 2021-06-03 13:24:15.161 (4) [P1T1]: Query executed in 0.002s 2021-06-03 13:24:15.161 (5) [P1T1]: loading 8 columns from result set: 2021-06-03 13:24:15.161 (5) [P1T1]: loaded column: databaseInstances.id->3 2021-06-03 13:24:15.161 (5) [P1T1]: loaded column: databaseInstances.name->global-staging 2021-06-03 13:24:15.162 (5) [P1T1]: loaded column: databaseInstances.description->Global Staging Tables 2021-06-03 13:24:15.162 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2021-06-03 13:24:15.162 (5) [P1T1]: loaded column: databaseInstances.database->staging 2021-06-03 13:24:15.162 (5) [P1T1]: loaded column: databaseInstances.host->staging-01-write 2021-06-03 13:24:15.162 (5) [P1T1]: loaded column: databaseInstances.port->3306 2021-06-03 13:24:15.162 (5) [P1T1]: loaded column: databaseInstances.access->rw 2021-06-03 13:24:15.162 (4) [P1T1]: Record Loaded 2021-06-03 13:24:15.162 (4) [P1T1]: DataCache: put key global-staging 2021-06-03 13:24:15.162 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.162 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool179c9dec-46dc-4307-aa9f-17a085ac76ce] for class com.carldunham.jst.pooling.ObjectPool 2021-06-03 13:24:15.162 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-06-03 13:24:15.162 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePoolba4518c7-a505-438e-a4fe-c3d7f7bdd0e7] for class com.carldunham.jst.db.DatabasePool 2021-06-03 13:24:15.173 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-06-03 13:24:15.173 (4) [P1T1]: opened [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.173 (4) [P1T1]: Created new Object 2021-06-03 13:24:15.173 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.173 (4) [P1T1]: spike: SQL->[select @@version] 2021-06-03 13:24:15.175 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-06-03 13:24:15.175 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.175 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-06-03 13:24:15.175 (4) [P1T1]: time=0.002 2021-06-03 13:24:15.175 (4) [P1T1]: Query executed in 0.002s 2021-06-03 13:24:15.175 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-06-03 13:24:15.175 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-06-03 13:24:15.183 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-06-03 13:24:15.184 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.184 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.184 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-clients") and (`type`="mysql")) limit 1] 2021-06-03 13:24:15.186 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-06-03 13:24:15.186 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.186 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-06-03 13:24:15.186 (4) [P1T1]: time=0.002 2021-06-03 13:24:15.186 (4) [P1T1]: Query executed in 0.002s 2021-06-03 13:24:15.186 (5) [P1T1]: loading 8 columns from result set: 2021-06-03 13:24:15.186 (5) [P1T1]: loaded column: databaseInstances.id->13 2021-06-03 13:24:15.186 (5) [P1T1]: loaded column: databaseInstances.name->global-clients 2021-06-03 13:24:15.186 (5) [P1T1]: loaded column: databaseInstances.description->Global Database for client-specific tables 2021-06-03 13:24:15.186 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2021-06-03 13:24:15.186 (5) [P1T1]: loaded column: databaseInstances.database->clients 2021-06-03 13:24:15.186 (5) [P1T1]: loaded column: databaseInstances.host->clients-01-write 2021-06-03 13:24:15.186 (5) [P1T1]: loaded column: databaseInstances.port->3306 2021-06-03 13:24:15.186 (5) [P1T1]: loaded column: databaseInstances.access->rw 2021-06-03 13:24:15.186 (4) [P1T1]: Record Loaded 2021-06-03 13:24:15.186 (4) [P1T1]: DataCache: put key global-clients 2021-06-03 13:24:15.187 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.187 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPooleba90f60-44b7-4494-80f8-81dddfb25696] for class com.carldunham.jst.pooling.ObjectPool 2021-06-03 13:24:15.187 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-06-03 13:24:15.187 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePool056aaa06-9993-450f-bb90-adc30538a1dc] for class com.carldunham.jst.db.DatabasePool 2021-06-03 13:24:15.195 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-06-03 13:24:15.195 (4) [P1T1]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:15.195 (4) [P1T1]: Created new Object 2021-06-03 13:24:15.195 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.195 (4) [P1T1]: spike: SQL->[select @@version] 2021-06-03 13:24:15.196 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:15.196 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.196 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:15.197 (4) [P1T1]: time=0.001 2021-06-03 13:24:15.197 (4) [P1T1]: Query executed in 0.001s 2021-06-03 13:24:15.197 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-06-03 13:24:15.197 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.197 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.2987', 600)] 2021-06-03 13:24:15.199 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-06-03 13:24:15.199 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.199 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-06-03 13:24:15.199 (4) [P1T1]: time=0.002 2021-06-03 13:24:15.199 (4) [P1T1]: Query executed in 0.002s 2021-06-03 13:24:15.199 (3) [P1T1]: Got migrator lock for Account ID #2987 2021-06-03 13:24:15.200 (5) [P1T1]: quoteValue(), nothing special about it=>[2987], type=class java.lang.Integer 2021-06-03 13:24:15.204 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.205 (4) [P1T1]: spike: SQL->[select * from `settings` where ((((`settings`.`scope`="accounts")) and ((`settings`.`scopeId`=2987))))] 2021-06-03 13:24:15.209 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2021-06-03 13:24:15.209 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.209 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2021-06-03 13:24:15.209 (4) [P1T1]: time=0.004 2021-06-03 13:24:15.209 (4) [P1T1]: Query executed in 0.004s 2021-06-03 13:24:15.210 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.210 (4) [P1T1]: spike: SQL->[select * from `settingDefaults` where (`settingDefaults`.`scope`="accounts")] 2021-06-03 13:24:15.211 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:15.211 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.211 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:15.211 (4) [P1T1]: time=0.001 2021-06-03 13:24:15.212 (4) [P1T1]: Query executed in 0.001s 2021-06-03 13:24:15.212 (4) [P1T1]: DataCache: put key accounts 2987 2021-06-03 13:24:15.670 (4) [P1T1]: DataCache: Found key accounts 2987 2021-06-03 13:24:15.670 (4) [P1T1]: Settings.getSettings: loaded from cache (key=accounts 2987) 2021-06-03 13:24:15.671 (3) [P1T1]: Applying algorithm [SABB] for Account ID #2987 in distributions [3, 178, 147, 177] 2021-06-03 13:24:15.673 (3) [P1T1]: Processing data for 2021-06-02 00:00:00 EDT 2021-06-03 13:24:15.677 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2021-06-03 13:24:15.677 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.677 (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`="2987"))) and ((`tsacommon`.`searchEngineAccounts`.`distributionID` in (3))))) order by rand()] 2021-06-03 13:24:15.679 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-06-03 13:24:15.679 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.679 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-06-03 13:24:15.679 (4) [P1T1]: time=0.002 2021-06-03 13:24:15.679 (4) [P1T1]: Query executed in 0.002s 2021-06-03 13:24:15.682 (5) [P1T1]: quoteValue(), nothing special about it=>[2987], type=class java.lang.Integer 2021-06-03 13:24:15.682 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.682 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=2987) and (`typeID`="") and (`type`="admax")) limit 1] 2021-06-03 13:24:15.684 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-06-03 13:24:15.684 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.684 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-06-03 13:24:15.684 (4) [P1T1]: time=0.002 2021-06-03 13:24:15.684 (4) [P1T1]: Query executed in 0.002s 2021-06-03 13:24:15.684 (5) [P1T1]: loading 4 columns from result set: 2021-06-03 13:24:15.684 (5) [P1T1]: loaded column: dataSources.id->13392 2021-06-03 13:24:15.684 (5) [P1T1]: loaded column: dataSources.type->admax 2021-06-03 13:24:15.684 (5) [P1T1]: loaded column: dataSources.typeID->0 2021-06-03 13:24:15.684 (5) [P1T1]: loaded column: dataSources.accountID->2987 2021-06-03 13:24:15.684 (4) [P1T1]: Record Loaded 2021-06-03 13:24:15.684 (5) [P1T1]: quoteValue(), nothing special about it=>[2987], type=class java.lang.Integer 2021-06-03 13:24:15.684 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.684 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`dataSources`.`type`="admax") and (`dataSources`.`accountID`=2987))] 2021-06-03 13:24:15.686 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-06-03 13:24:15.686 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.686 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-06-03 13:24:15.686 (4) [P1T1]: time=0.002 2021-06-03 13:24:15.686 (4) [P1T1]: Query executed in 0.002s 2021-06-03 13:24:15.686 (5) [P1T1]: loading 4 columns from result set: 2021-06-03 13:24:15.686 (5) [P1T1]: loaded column: dataSources.id->13392 2021-06-03 13:24:15.686 (5) [P1T1]: loaded column: dataSources.type->admax 2021-06-03 13:24:15.686 (5) [P1T1]: loaded column: dataSources.typeID->0 2021-06-03 13:24:15.686 (5) [P1T1]: loaded column: dataSources.accountID->2987 2021-06-03 13:24:15.688 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.688 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`date`="2021-06-02 00:00:00") and (`dataSourceID`="13392")) limit 1] 2021-06-03 13:24:15.689 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:15.689 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.689 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:15.689 (4) [P1T1]: time=0.001 2021-06-03 13:24:15.689 (4) [P1T1]: Query executed in 0.001s 2021-06-03 13:24:15.689 (5) [P1T1]: loading 9 columns from result set: 2021-06-03 13:24:15.689 (5) [P1T1]: loaded column: dataAvailability.id->89667 2021-06-03 13:24:15.690 (5) [P1T1]: loaded column: dataAvailability.date->2021-06-02 2021-06-03 13:24:15.690 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2021-06-03 13:24:15.690 (5) [P1T1]: loaded column: dataAvailability.updated->2021-06-03 11:46:01.0 2021-06-03 13:24:15.690 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->13392 2021-06-03 13:24:15.690 (5) [P1T1]: loaded column: dataAvailability.status->success 2021-06-03 13:24:15.690 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2021-06-03 13:24:15.690 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2021-06-03 13:24:15.690 (5) [P1T1]: loaded column: dataAvailability.override->false 2021-06-03 13:24:15.691 (4) [P1T1]: Record Loaded 2021-06-03 13:24:15.691 (5) [P1T1]: quoteValue(), nothing special about it=>[13392], type=class java.lang.Integer 2021-06-03 13:24:15.691 (5) [P1T1]: quoteValue(), nothing special about it=>[89667], type=class java.lang.Integer 2021-06-03 13:24:15.691 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.691 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`date`,`dataSourceID`,`statusText`,`id`,`override`,`updated`,`oldUpdated`,`status`,`needsRerun`) values ("2021-06-02",13392,null,89667,"false","2021-06-03 13:24:15","00:00:00","in progress","false")], genflags=yes 2021-06-03 13:24:15.692 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:15.693 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.693 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:15.693 (4) [P1T1]: time=0.001 2021-06-03 13:24:15.693 (4) [P1T1]: Query executed in 0.001s, 2 row(s) affected 2021-06-03 13:24:15.694 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:15.694 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`date`,`dataSourceID`,`override`,`updated`,`status`) values ("2021-06-02 00:00:00","13392","false","2021-06-03 13:24:15","in progress")], genflags=yes 2021-06-03 13:24:15.695 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:15.695 (5) [P1T1]: addSub("db") 2021-06-03 13:24:15.695 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:15.695 (4) [P1T1]: time=0.001 2021-06-03 13:24:15.696 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2021-06-03 13:24:15.701 (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-06-03 13:24:15.704 (4) [P1T1]: preparing SQL statement [select ID,accountID,admaxCampaignID,searchEngineAccountID,migrationDate,lastAdMaxRunDate from `st-tracker`.admaxCampaignMigrations where accountID=? and migrationDate>=? and lastAdMaxRunDate<=?] 2021-06-03 13:24:15.706 (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-06-03 13:24:15.712 (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-06-03 13:24:15.714 (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-06-03 13:24:15.716 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2021-06-03 13:24:15.718 (3) [P1T1]: Retrieved campaign status Active for AdMax campaign 10914 2021-06-03 13:24:15.718 (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-06-03 13:24:15.719 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2021-06-03 13:24:15.720 (3) [P1T1]: Retrieved campaign status Active for AdMax campaign 10914 2021-06-03 13:24:15.720 (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-06-03 13:24:15.721 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2021-06-03 13:24:15.723 (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-06-03 13:24:15.724 (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-06-03 13:24:15.725 (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-06-03 13:24:15.726 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.facebookAdMax.date,staging.facebookAdMax.clicks,staging.facebookAdMax.cost,staging.facebookAdMax.impressions 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=?] 2021-06-03 13:24:15.728 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,pooledCarryover,dedicatedCarryover,commonCarryover from `st-tracker`.admaxCarryovers where admaxCampaignID=? and type=? and date=?] 2021-06-03 13:24:15.731 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,budget from `st-tracker`.admaxActualDailyBudgets where admaxCampaignID=? and type=? and date=?] 2021-06-03 13:24:15.733 (4) [P1T1]: preparing SQL statement [select admaxCampaignID,date,budget from `st-tracker`.admaxNominalDailyBudgets where admaxCampaignID=? and date=?] 2021-06-03 13:24:15.735 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,balanceFactor from `st-tracker`.admaxSearchEngineAccountBalanceFactors where searchEngineAccountID=? and date=?] 2021-06-03 13:24:15.736 (4) [P1T1]: preparing SQL statement [select searchEngineAccountID,date,budget,actualSEBudget,budgetStatus from `st-tracker`.admaxSearchEngineAccountActualDailyBudgets where searchEngineAccountID=? and date=?] 2021-06-03 13:24:15.765 (3) [P1T1]: Distribution Properties Cache: Loading new properties for 11a78c10-617f-44ec-8b4a-39c331269394_ALGORITHM 2021-06-03 13:24:15,785 [P1T1] INFO o.a.c.h.auth.AuthChallengeProcessor - digest authentication scheme selected 2021-06-03 13:24:15.955 (4) [P1T1]: Using value true for property sabb.biddingEnabled.facebook of type ALGORITHM 2021-06-03 13:24:15.956 (4) [P1T1]: preparing SQL statement [select accountID,elementType,elementID,currentBid,currentBidSetDate,newBid,newBidSetDate,retryCount from `st-tracker`.admaxBids where accountID=? and elementType=? and elementID=?] 2021-06-03 13:24:15.959 (4) [P1T1]: preparing SQL statement [SELECT searchEngineUserID, accountID, distributionID, date, modifiedOn, isPaused FROM staging.adMaxReportTracker WHERE accountID = ? AND distributionID = ?] 2021-06-03 13:24:16.028 (4) [P1T1]: preparing SQL statement [select distinct admaxNominalMonthlyBudgets.ID,admaxNominalMonthlyBudgets.admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID join `st-tracker`.admaxSearchEngineAccountMap on admaxCampaigns.ID=admaxSearchEngineAccountMap.admaxCampaignID join tsacommon.searchEngineAccounts on admaxSearchEngineAccountMap.searchEngineAccountID=searchEngineAccounts.ID where admaxCampaigns.accountID=? and startDate<=? and (endDate is null or endDate>=?) and distributionID=?] 2021-06-03 13:24:16.030 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2021-06-03 13:24:16.031 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2021-06-03 13:24:16.037 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor,budgetType,resellerID from `st-tracker`.admaxSloshFactors where elementType=? and startDate<=? and (endDate is null or endDate>=?) and sloshFactor< 1 and elementID in (10914)] 2021-06-03 13:24:16.038 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor,budgetType,resellerID from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-06-03 13:24:16.040 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor,budgetType,resellerID from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-06-03 13:24:16.043 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor,budgetType,resellerID from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-06-03 13:24:16.051 (4) [P1T1]: preparing SQL statement [select admaxCampaignID,referenceID,createTime,refund from `st-tracker`.admaxCampaignRefunds where admaxCampaignID=? and date(createTime)=?] 2021-06-03 13:24:16.052 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2021-06-03 13:24:16.053 (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] 2021-06-03 13:24:16.055 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshLimit,budgetType,resellerID from `st-tracker`.admaxSloshLimits where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-06-03 13:24:16.062 (4) [P1T1]: Sorted campaign order: [com.thesearchagency.admax.algorithms.common.AdMaxDataCollection@24d07081] 2021-06-03 13:24:16.086 (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=?] 2021-06-03 13:24:16.092 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshLimit,budgetType,resellerID from `st-tracker`.admaxSloshLimits where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-06-03 13:24:16.094 (4) [P1T1]: Pooled carryover limit for AdMaxCampaignID 10914: 1496.2666 2021-06-03 13:24:16.096 (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=?] 2021-06-03 13:24:16.104 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxCarryovers (admaxCampaignID, type, date, pooledCarryover, dedicatedCarryover, commonCarryover) values (?,?,?,?,?,?) on duplicate key update pooledCarryover=?,dedicatedCarryover=?,commonCarryover=?] 2021-06-03 13:24:16.105 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxActualDailyBudgets (admaxCampaignID, type, date, budget) values (?,?,?,?) on duplicate key update budget=?] 2021-06-03 13:24:16.106 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxNominalDailyBudgets (admaxCampaignID, date, budget) values (?,?,?) on duplicate key update budget=?] 2021-06-03 13:24:16.107 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountBalanceFactors (searchEngineAccountID, date, balanceFactor) values (?,?,?) on duplicate key update balanceFactor=?] 2021-06-03 13:24:16.108 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountActualDailyBudgets (searchEngineAccountID, date, budget, actualSEBudget, budgetStatus) values (?,?,?,?,?) on duplicate key update budget=?, actualSEBudget=?, budgetStatus=?] 2021-06-03 13:24:16.116 (5) [P1T1]: quoteValue(), nothing special about it=>[2987], type=class java.lang.Integer 2021-06-03 13:24:16.116 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:16.116 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=2987) limit 1] 2021-06-03 13:24:16.117 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:16.117 (5) [P1T1]: addSub("db") 2021-06-03 13:24:16.117 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:16.117 (4) [P1T1]: time=0.001 2021-06-03 13:24:16.117 (4) [P1T1]: Query executed in 0.001s 2021-06-03 13:24:16.117 (5) [P1T1]: loading 21 columns from result set: 2021-06-03 13:24:16.117 (5) [P1T1]: loaded column: accounts.id->2987 2021-06-03 13:24:16.117 (5) [P1T1]: loaded column: accounts.description->11a78c10-617f-44ec-8b4a-39c331269394 2021-06-03 13:24:16.117 (5) [P1T1]: loaded column: accounts.tier->1 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.priority->50 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.reportConversions->false 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.isActive->true 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.addConversionData->true 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.nowTime->null 2021-06-03 13:24:16.118 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.isOnline->true 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.currencyCode->USD 2021-06-03 13:24:16.118 (5) [P1T1]: loaded column: accounts.timeZoneID->America/New_York 2021-06-03 13:24:16.118 (4) [P1T1]: Record Loaded 2021-06-03 13:24:16.118 (4) [P1T1]: Waiting up to 7200 seconds to lock 11a78c10-617f-44ec-8b4a-39c331269394. 2021-06-03 13:24:16.118 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:16.118 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.11a78c10-617f-44ec-8b4a-39c331269394', 7200)] 2021-06-03 13:24:16.119 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:16.119 (5) [P1T1]: addSub("db") 2021-06-03 13:24:16.119 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:16.120 (4) [P1T1]: time=0.001 2021-06-03 13:24:16.120 (4) [P1T1]: Query executed in 0.001s 2021-06-03 13:24:16.120 (4) [P1T1]: Locked account: 11a78c10-617f-44ec-8b4a-39c331269394 2021-06-03 13:24:16.120 (4) [P1T1]: preparing SQL statement [select id,accountID,distributionID,searchEngineUserID,searchEngineIdentifier,budgetSearchEngineIdentifier,budgetAmount,searchEngineStatus from `tsacommon`.searchEngineAccounts where id=?] 2021-06-03 13:24:16.122 (5) [P1T1]: quoteValue(), nothing special about it=>[4678], type=class java.lang.Long 2021-06-03 13:24:16.122 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:16.122 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=4678) limit 1] 2021-06-03 13:24:16.123 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:16.123 (5) [P1T1]: addSub("db") 2021-06-03 13:24:16.123 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:16.123 (4) [P1T1]: time=0.001 2021-06-03 13:24:16.123 (4) [P1T1]: Query executed in 0.001s 2021-06-03 13:24:16.123 (5) [P1T1]: loading 14 columns from result set: 2021-06-03 13:24:16.123 (5) [P1T1]: loaded column: searchEngineUsers.id->4678 2021-06-03 13:24:16.123 (5) [P1T1]: loaded column: searchEngineUsers.accountID->2987 2021-06-03 13:24:16.123 (5) [P1T1]: loaded column: searchEngineUsers.distributionID->177 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.searchEngineIdentifier->481300832945901 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.description->11a78c10-617f-44ec-8b4a-39c331269394_1_qa4amltest_Admaxlocal_P3_Rahul 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.username-> 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.password-> 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.enabled->true 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.inTsaMcc->true 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.apiKey-> 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.managerUsernames->null 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.managerIDs->null 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.lastChecked->2021-06-03 08:23:54.0 2021-06-03 13:24:16.124 (5) [P1T1]: loaded column: searchEngineUsers.lastInMcc->null 2021-06-03 13:24:16.124 (4) [P1T1]: Record Loaded 2021-06-03 13:24:16.130 (5) [P1T1]: quoteValue(), nothing special about it=>[2987], type=class java.lang.Integer 2021-06-03 13:24:16.130 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:16.130 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=2987) limit 1] 2021-06-03 13:24:16.132 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-06-03 13:24:16.132 (5) [P1T1]: addSub("db") 2021-06-03 13:24:16.132 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-06-03 13:24:16.132 (4) [P1T1]: time=0.002 2021-06-03 13:24:16.133 (4) [P1T1]: Query executed in 0.002s 2021-06-03 13:24:16.133 (5) [P1T1]: loading 21 columns from result set: 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.id->2987 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.description->11a78c10-617f-44ec-8b4a-39c331269394 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.tier->1 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.priority->50 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.reportConversions->false 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.isActive->true 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.addConversionData->true 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.nowTime->null 2021-06-03 13:24:16.133 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.isOnline->true 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.currencyCode->USD 2021-06-03 13:24:16.133 (5) [P1T1]: loaded column: accounts.timeZoneID->America/New_York 2021-06-03 13:24:16.133 (4) [P1T1]: Record Loaded 2021-06-03 13:24:16,747 [P1T1] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service 2021-06-03 13:24:16.747 (3) [P1T1]: Distribution Properties Cache: Loading new properties for 11a78c10-617f-44ec-8b4a-39c331269394_CONTENT_EDITOR 2021-06-03 13:24:16.855 (4) [P1T1]: Using value TZ_AMERICA_NEW_YORK for property fb.timeZone of type CONTENT_EDITOR 2021-06-03 13:24:16.855 (4) [P1T1]: Using value en-US for property fb.locale of type CONTENT_EDITOR 2021-06-03 13:24:16.855 (4) [P1T1]: Using value true for property fb.enableInstagramStream of type CONTENT_EDITOR 2021-06-03 13:24:16.855 (4) [P1T1]: Using value null for property fb.enableRightColumn of type CONTENT_EDITOR 2021-06-03 13:24:16.855 (4) [P1T1]: Using value false for property fb.enableTravelingIn of type CONTENT_EDITOR 2021-06-03 13:24:16.855 (4) [P1T1]: Using value https://www.admaxlocal.com/ for property fb.followUpActionUrl of type CONTENT_EDITOR 2021-06-03 13:24:16.855 (4) [P1T1]: Using value https://www.admaxlocal.com/privacy-policy for property fb.privacyPolicyUrl of type CONTENT_EDITOR 2021-06-03 13:24:16.855 (4) [P1T1]: Using value LEAD for property fb.customEventType of type CONTENT_EDITOR CrashReporter : Enabled! 2021-06-03 13:24:16,862 [P1T1] DEBUG c.t.s.c.f.impl.FacebookAdsClient - Created FacebookAdsClient for 481300832945901 2021-06-03 13:24:16.865 (4) [P1T1]: preparing SQL statement [select ecp.id, ecp.description, ecp.accountID, ecp.admaxCampaignID,ecp. status, ecp.typeID from clients.externalCampaignParent ecp join clients.externalCampaign ec on ec.externalCampaignParentID = ecp.ID where ec.searchEngineAccountID = ?] 2021-06-03 13:24:16.867 (4) [P1T1]: preparing SQL statement [select id,accountID,distributionID,searchEngineUserID,searchEngineIdentifier,budgetSearchEngineIdentifier,budgetAmount,searchEngineStatus from `tsacommon`.searchEngineAccounts where id=?] 2021-06-03 13:24:16,877 [P1T1] INFO c.t.s.c.f.i.s.CampaignServiceClient - Updating 1 Facebook campaigns budget for accountID 481300832945901 Post: https://graph.facebook.com/ Content-Disposition: form-data; name="access_token" EAAJKaZCNuOywBAJSZCZATcCzgJYNAtGJP0h7GmvNnroXqkklWwXqnfvUqqXnQdNboNKrkTpPNc4RadJpIXLV9mMZAqTnFiMVL6lNGzlsLV4FNZAHJXrlXTChIkbbRxzgSEE1qgvzD7ZCd4TXCIZCTnbb8r17brNQCVpS26W19vpbxlQgSK9nit98GDsUZC5ZAwTEHRF9yIdNR6gZDZD Content-Disposition: form-data; name="appsecret_proof" 976898cbc115bd3c183f5a4537e81adf1c19fdd9387d2723aaa6ce30a3140377 Content-Disposition: form-data; name="include_headers" false Content-Disposition: form-data; name="batch" [{"method":"POST","relative_url":"v10.0/23847581707240341/","name":"Request0","omit_response_on_success":false,"body":"daily_budget=1240&status=PAUSED","attached_files":{}}] ----------------------------5290756138293180966-- [{"code":200,"body":"{\"success\":true}"}] [Warning] When parsing response, object is not consistent with JSON: [JSON]{"success":true} [Object]{} 2021-06-03 13:24:17,653 [P1T1] INFO c.t.s.c.f.i.s.CampaignServiceClient - Successfully updated a Facebook campaign budget for campaignID 23847581707240341 2021-06-03 13:24:17.653 (4) [P1T1]: preparing SQL statement [update `tsacommon`.searchEngineAccounts set searchEngineStatus=?, searchEngineStatusText=? where searchEngineIdentifier=?] 2021-06-03 13:24:17.655 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:17.655 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.11a78c10-617f-44ec-8b4a-39c331269394')] 2021-06-03 13:24:17.656 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:17.656 (5) [P1T1]: addSub("db") 2021-06-03 13:24:17.656 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:17.656 (4) [P1T1]: time=0.001 2021-06-03 13:24:17.656 (4) [P1T1]: Query executed in 0.001s 2021-06-03 13:24:17.657 (3) [P1T1]: Skip bids for facebook campaign 2021-06-03 13:24:17.657 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:17.657 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`date`="2021-06-02 00:00:00") and (`dataSourceID`="13392")) limit 1] 2021-06-03 13:24:17.660 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2021-06-03 13:24:17.660 (5) [P1T1]: addSub("db") 2021-06-03 13:24:17.660 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2021-06-03 13:24:17.660 (4) [P1T1]: time=0.003 2021-06-03 13:24:17.660 (4) [P1T1]: Query executed in 0.003s 2021-06-03 13:24:17.660 (5) [P1T1]: loading 9 columns from result set: 2021-06-03 13:24:17.660 (5) [P1T1]: loaded column: dataAvailability.id->89667 2021-06-03 13:24:17.661 (5) [P1T1]: loaded column: dataAvailability.date->2021-06-02 2021-06-03 13:24:17.661 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2021-06-03 13:24:17.661 (5) [P1T1]: loaded column: dataAvailability.updated->2021-06-03 13:24:15.0 2021-06-03 13:24:17.661 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->13392 2021-06-03 13:24:17.661 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2021-06-03 13:24:17.661 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2021-06-03 13:24:17.661 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2021-06-03 13:24:17.661 (5) [P1T1]: loaded column: dataAvailability.override->false 2021-06-03 13:24:17.661 (4) [P1T1]: Record Loaded 2021-06-03 13:24:17.661 (5) [P1T1]: quoteValue(), nothing special about it=>[13392], type=class java.lang.Integer 2021-06-03 13:24:17.661 (5) [P1T1]: quoteValue(), nothing special about it=>[89667], type=class java.lang.Integer 2021-06-03 13:24:17.661 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:17.661 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`date`,`dataSourceID`,`statusText`,`id`,`override`,`updated`,`oldUpdated`,`status`,`needsRerun`) values ("2021-06-02",13392,null,89667,"false","2021-06-03 13:24:17","00:00:00","success","false")], genflags=yes 2021-06-03 13:24:17.667 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2021-06-03 13:24:17.667 (5) [P1T1]: addSub("db") 2021-06-03 13:24:17.667 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2021-06-03 13:24:17.667 (4) [P1T1]: time=0.006 2021-06-03 13:24:17.667 (4) [P1T1]: Query executed in 0.006s, 2 row(s) affected 2021-06-03 13:24:17.668 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:17.668 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`date`,`dataSourceID`,`override`,`updated`,`status`) values ("2021-06-02 00:00:00","13392","false","2021-06-03 13:24:17","success")], genflags=yes 2021-06-03 13:24:17.669 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:17.670 (5) [P1T1]: addSub("db") 2021-06-03 13:24:17.670 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:17.670 (4) [P1T1]: time=0.001 2021-06-03 13:24:17.670 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2021-06-03 13:24:17.670 (3) [P1T1]: Finished applying algorithm [SABB] for account [2987] in distributions [3, 178, 147, 177] 2021-06-03 13:24:17.670 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-06-03 13:24:17.670 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.2987')] 2021-06-03 13:24:17.671 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-06-03 13:24:17.671 (5) [P1T1]: addSub("db") 2021-06-03 13:24:17.671 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:17.671 (4) [P1T1]: time=0.001 2021-06-03 13:24:17.671 (4) [P1T1]: Query executed in 0.001s 2021-06-03 13:24:17.671 (3) [P1T1]: Released migrator lock for Account ID #2987 2021-06-03 13:24:17.671 (4) [P1T1]: Returning Object to Pool 2021-06-03 13:24:17.672 (4) [P1T1]: Returning Object to Pool 2021-06-03 13:24:17.672 (4) [P1T1]: Returning Object to Pool 2021-06-03 13:24:17.672 (4) [P1T1]: Returning Object to Pool 2021-06-03 13:24:17.672 (3) [P1T1]: Completed Account ID #2987: 11a78c10-617f-44ec-8b4a-39c331269394 2021-06-03 13:24:17.672 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-06-03 13:24:17.672 (3) [main]: ------------AdMax Summarizer done 2021-06-03 13:24:17.672 (3) [main]: =============== Completed AdMax Summarizer ================ 2021-06-03 13:24:17.673 (4) [main]: DataCache: Found key global-logging 2021-06-03 13:24:17.673 (4) [main]: Took Existing Object from Pool 2021-06-03 13:24:17.673 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-06-03 13:24:17.673 (4) [main]: spike: SQL->[select @@version] 2021-06-03 13:24:17.674 (2) [main]: Warning(s) detected in statement [select @@version] executed by user [spike] 2021-06-03 13:24:17.674 (2) [main]: Table 'logging.processHistory' doesn't exist (1146) 2021-06-03 13:24:17.674 (5) [main]: recordAsSubs("db", 1, "main") 2021-06-03 13:24:17.674 (5) [main]: addSub("db") 2021-06-03 13:24:17.674 (5) [main]: ProfilerRec.end("db", true): ret=1 2021-06-03 13:24:17.674 (4) [main]: time=0.001 2021-06-03 13:24:17.675 (4) [main]: Query executed in 0.001s 2021-06-03 13:24:17.675 (4) [main]: test query succeeded, returned "5.5.34" 2021-06-03 13:24:17.675 (3) [main]: Could not save process history stop 2021-06-03 13:24:17.675 (4) [main]: Returning Object to Pool 2021-06-03 13:24:17.675 (3) [main]: =============== Stats ================ 2021-06-03 13:24:17.675 (3) [main]: --- Process --- 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: ABU Process(start): Thu Jun 03 13:24:14 UTC 2021 2021-06-03 13:24:17.675 (3) [main]: ABU Process(stop): Thu Jun 03 13:24:17 UTC 2021 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: --- Accounts --- 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: Accounts Processed: 1 2021-06-03 13:24:17.675 (3) [main]: Accounts Skipped: 0 2021-06-03 13:24:17.675 (3) [main]: Accounts Processed Successfully: 1 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: --- Campaigns --- 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: Campaigns Processed: 1 2021-06-03 13:24:17.675 (3) [main]: Campaigns Processed Successfully: 1 2021-06-03 13:24:17.675 (3) [main]: Campaign Budgets Capped: 0 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: --- SE Campaigns --- 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: SE Campaigns Processed: 1 2021-06-03 13:24:17.675 (3) [main]: SE Campaigns Processed Successfully: 1 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: --- Budget/Spend --- 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: SE Campaign Budgets Updated: 1 2021-06-03 13:24:17.675 (3) [main]: SE Campaign Budgets Sent To Google: 0 2021-06-03 13:24:17.675 (3) [main]: SE Campaign Budgets Sent To Yahoo Japan:0 2021-06-03 13:24:17.675 (3) [main]: SE Campaign Budgets Sent To Bing: 0 2021-06-03 13:24:17.675 (3) [main]: SE Campaign Budgets Sent To Facebook: 1 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: Spend Total: 0.0 2021-06-03 13:24:17.675 (3) [main]: Common Carryover Total: 8.26666 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: --- Bids --- 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (3) [main]: New Campaign Bids: 0 2021-06-03 13:24:17.675 (3) [main]: 2021-06-03 13:24:17.675 (5) [main]: ProfilerRec.end("AdMaxSummarizer", false): ret=2899 2021-06-03 13:24:17.676 (4) [main]: time=2.899 2021-06-03 13:24:17.676 (3) [main]: AdMaxSummarizer: 2.899s 2021-06-03 13:24:17.676 (3) [main]: by key: 2021-06-03 13:24:17.676 (4) [main]: time=0.06 2021-06-03 13:24:17.676 (3) [main]: db: 0.060s 2021-06-03 13:24:17.676 (3) [main]: by thread: 2021-06-03 13:24:17.676 (4) [main]: time=0.009 2021-06-03 13:24:17.676 (3) [main]: main: 0.009s 2021-06-03 13:24:17.676 (4) [main]: time=0.051 2021-06-03 13:24:17.676 (3) [main]: P1T1: 0.051s 2021-06-03 13:24:17.676 (4) [main]: time=2.839 2021-06-03 13:24:17.676 (3) [main]: other: 2.839s