2014-11-07 10:52:44.130 (3) [main]: Debug Level set to 4 2014-11-07 10:52:44.221 (4) [main]: registered MBean [thesearchagency.db.util:type=MultiplexDatabasePoolda7121af-2f1e-4fcd-8fcb-b5191485562f] for class com.thesearchagency.db.util.MultiplexDatabasePool 2014-11-07 10:52:44.222 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2014-11-07 10:52:44.232 (4) [main]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool22dae5f2-5cb0-4fd3-ac8c-170db36dced9] for class com.carldunham.jst.pooling.ObjectPool 2014-11-07 10:52:44.233 (3) [main]: DatabasePool with a limit of 80 created 2014-11-07 10:52:44.233 (4) [main]: registered MBean [com.carldunham.jst.db:type=DatabasePoolb6214715-afa0-4381-99df-365244958749] for class com.carldunham.jst.db.DatabasePool 2014-11-07 10:52:44.241 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2014-11-07 10:52:46.714 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2014-11-07 10:52:46.714 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:52:46.714 (4) [main]: Created new Object 2014-11-07 10:52:46.716 (4) [main]: spike: SQL->[select @@version] 2014-11-07 10:52:47.208 (4) [main]: time=0.492 2014-11-07 10:52:47.208 (4) [main]: Query executed in 0.492s 2014-11-07 10:52:47.208 (4) [main]: test query succeeded, returned "5.5.34" 2014-11-07 10:52:47.222 (4) [main]: spike: SQL->[select `tsacommon`.`accounts`.`id`,`tsacommon`.`accounts`.`databaseInstance` from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`isOnline`="true") and (`tsacommon`.`accounts`.`isActive`="true")) group by `tsacommon`.`accounts`.`databaseInstance`] 2014-11-07 10:52:47.695 (4) [main]: time=0.473 2014-11-07 10:52:47.695 (4) [main]: Query executed in 0.473s 2014-11-07 10:52:47.697 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2014-11-07 10:52:49.655 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2014-11-07 10:52:49.655 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:52:49.655 (4) [main]: Created new Object 2014-11-07 10:52:49.655 (4) [main]: spike: SQL->[select @@version] 2014-11-07 10:52:50.171 (4) [main]: time=0.516 2014-11-07 10:52:50.171 (4) [main]: Query executed in 0.516s 2014-11-07 10:52:50.171 (4) [main]: test query succeeded, returned "5.5.34" 2014-11-07 10:52:50.174 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=178) limit 1] 2014-11-07 10:52:50.723 (4) [main]: time=0.549 2014-11-07 10:52:50.723 (4) [main]: Query executed in 0.549s 2014-11-07 10:52:50.728 (4) [main]: Record Loaded 2014-11-07 10:52:50.773 (3) [main]: Skipping initialization of Yahoo Client. This means no API calls can be made. 2014-11-07 10:52:50.788 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2014-11-07 10:52:52.867 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2014-11-07 10:52:52.868 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:52:52.868 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=1) limit 1] 2014-11-07 10:52:53.422 (4) [main]: time=0.554 2014-11-07 10:52:53.422 (4) [main]: Query executed in 0.554s 2014-11-07 10:52:53.423 (4) [main]: Record Loaded 2014-11-07 10:52:53.424 (4) [main]: DataCache: put key acct-st-tracker 1 2014-11-07 10:52:53.426 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1] 2014-11-07 10:52:53.934 (4) [main]: time=0.508 2014-11-07 10:52:53.934 (4) [main]: Query executed in 0.508s 2014-11-07 10:52:53.934 (4) [main]: Record Loaded 2014-11-07 10:52:53.934 (4) [main]: DataCache: put key acct-st-tracker-1 2014-11-07 10:52:53.936 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:52:53.936 (4) [main]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool8ee65873-fa8a-4462-9aff-03eb268f5cc9] for class com.carldunham.jst.pooling.ObjectPool 2014-11-07 10:52:53.936 (3) [main]: DatabasePool with a limit of 80 created 2014-11-07 10:52:53.936 (4) [main]: registered MBean [com.carldunham.jst.db:type=DatabasePool87a353b3-8f77-4361-a450-29760680abde] for class com.carldunham.jst.db.DatabasePool 2014-11-07 10:52:55.906 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2014-11-07 10:52:55.906 (4) [main]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:52:55.906 (4) [main]: Created new Object 2014-11-07 10:52:55.906 (4) [main]: spike: SQL->[select @@version] 2014-11-07 10:52:56.410 (4) [main]: time=0.504 2014-11-07 10:52:56.410 (4) [main]: Query executed in 0.504s 2014-11-07 10:52:56.410 (4) [main]: test query succeeded, returned "5.5.34" 2014-11-07 10:52:56.413 (4) [main]: Instantiating an AdmaxBidDAO object for Database: jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true 2014-11-07 10:52:56.413 (4) [main]: preparing SQL statement [select ab.accountID,ab.elementType,ab.elementID,ab.currentBid,ab.currentBidSetDate,ab.newBid,ab.newBidSetDate,ab.retryCount,sea.distributionID,sea.searchEngineIdentifier,seg.id,seg.searchEngineIdentifier,seadb.budget,seadb.actualSEBudget from `tsacommon`.searchEngineAccounts sea join `st-tracker`.admaxSearchEngineAccountActualDailyBudgets seadb on seadb.searchEngineAccountID = sea.id and seadb.date = (select max(seadb2.date) from `st-tracker`.admaxSearchEngineAccountActualDailyBudgets seadb2 where seadb2.searchEngineAccountID = sea.id) join `st-tracker`.searchEngineGroups seg on seg.searchEngineAccountID = sea.id join `st-tracker`.admaxBids ab on ab.accountID = sea.accountID and ab.elementType = 'searchEngineAccount' and ab.elementID = sea.id where ab.newBid IS NOT NULL and sea.distributionID=? and seg.searchEngineStatus = 'ok' and sea.searchEngineUserID in (96) group by seg.id order by ab.accountID,ab.newBidSetDate asc] 2014-11-07 10:52:56.628 (4) [main]: Returning Object to Pool 2014-11-07 10:52:56.629 (4) [main]: Returning Object to Pool 2014-11-07 10:52:56.629 (4) [main]: All Pending Bids (before validation)... 2014-11-07 10:52:56.629 (4) [main]: AdmaxBidDTO [ AccountID: 98, ElementType: searchEngineAccount, ElementID: 2216, CurrentBid: 50000.0, CurrentBidSetDate: 2014-11-07, NewBid: 60000.0, NewBidSetDate: 2014-11-07, RetryCount: 0 ] 2014-11-07 10:52:56.630 (3) [main]: ----------------Search Engine Bid Updater starting 2014-11-07 10:52:56.639 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2014-11-07 10:52:58.796 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2014-11-07 10:52:58.796 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:52:58.804 (4) [main]: spike: SQL->[select * from `searchEngineUsers` join `accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineUsers`.`accountID`)) where ((`enabled`="true") and (`tsacommon`.`accounts`.`isActive`="true") and (`tsacommon`.`searchEngineUsers`.`id` in ("96")) and (`tsacommon`.`searchEngineUsers`.`distributionID`="178")) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc] 2014-11-07 10:52:59.290 (4) [main]: time=0.486 2014-11-07 10:52:59.290 (4) [main]: Query executed in 0.486s 2014-11-07 10:52:59.292 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2014-11-07 10:52:59.293 (4) [main]: Took Existing Object from Pool 2014-11-07 10:52:59.293 (4) [main]: spike: SQL->[select @@version] 2014-11-07 10:52:59.778 (4) [main]: time=0.485 2014-11-07 10:52:59.778 (4) [main]: Query executed in 0.485s 2014-11-07 10:52:59.778 (4) [main]: test query succeeded, returned "5.5.34" 2014-11-07 10:52:59.779 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=178) limit 1] 2014-11-07 10:53:00.310 (4) [main]: time=0.531 2014-11-07 10:53:00.310 (4) [main]: Query executed in 0.531s 2014-11-07 10:53:00.311 (4) [main]: Record Loaded SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/stacie.waleyko/.m2/repository/com/thesearchagency/smb/client/yj-soap-client/1.0.0/yj-soap-client-1.0.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/stacie.waleyko/.m2/repository/ch/qos/logback/logback-classic/1.1.2/logback-classic-1.1.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/stacie.waleyko/.m2/repository/org/slf4j/slf4j-log4j12/1.7.7/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/stacie.waleyko/.m2/repository/org/jboss/slf4j/slf4j-jboss-logging/1.0.2.GA/slf4j-jboss-logging-1.0.2.GA.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [ch.qos.logback.classic.util.ContextSelectorStaticBinder] 2014-11-07 10:53:01.058 (2) [Finalizer]: AccountDatabases: finalize: unloading connections - app may need updates? 2014-11-07 10:53:01.058 (4) [Finalizer]: Returning Object to Pool 2014-11-07 10:53:01,058 [main] DEBUG c.t.s.c.y.impl.YahooJapanSSClient - Created YahooJapanSSClient for Authentication [ACCOUNT_ID=586501, ON_BEHALF_OF_ACCOUNT_ID= ylWCn-cgHc-Kyf4z-6PGU ] 2014-11-07 10:53:01.063 (4) [main]: preparing SQL statement [select currencyCode from `tsacommon`.`accounts` where id = ?] 2014-11-07 10:53:01.272 (4) [main]: Returning Object to Pool 2014-11-07 10:53:01.281 (3) [P1T1]: Starting User (96) "797667fd-206f-4324-bfbb-5e5dc4b14704_1" 2014-11-07 10:53:01.281 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2014-11-07 10:53:03.299 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2014-11-07 10:53:03.299 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:53:03.299 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=98) limit 1] 2014-11-07 10:53:03.738 (4) [P1T1]: time=0.439 2014-11-07 10:53:03.738 (4) [P1T1]: Query executed in 0.439s 2014-11-07 10:53:03.739 (4) [P1T1]: Record Loaded 2014-11-07 10:53:03.739 (4) [P1T1]: DataCache: put key acct-st-tracker 98 2014-11-07 10:53:03.739 (4) [P1T1]: DataCache: Found key acct-st-tracker-1 2014-11-07 10:53:03.744 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:53:03.745 (4) [P1T1]: Took Existing Object from Pool 2014-11-07 10:53:03.745 (4) [P1T1]: spike: SQL->[select @@version] 2014-11-07 10:53:04.229 (4) [P1T1]: time=0.484 2014-11-07 10:53:04.229 (4) [P1T1]: Query executed in 0.484s 2014-11-07 10:53:04.229 (4) [P1T1]: test query succeeded, returned "5.5.34" 2014-11-07 10:53:04.231 (4) [P1T1]: Instantiating an AdmaxBidErrorDAO object for Database: jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true 2014-11-07 10:53:04.232 (4) [P1T1]: tried to set bid > maxCPC, so setting bid = maxCPC for SEA 2216 2014-11-07 10:53:04.232 (4) [P1T1]: preparing SQL statement [update `st-tracker`.admaxBids ab set ab.newBid=? where ab.accountID=? and ab.elementID=? and ab.elementType=?] 2014-11-07 10:53:04.471 (4) [P1T1]: All Pending Bids (after validation) for SEU 96... 2014-11-07 10:53:04.471 (4) [P1T1]: AdmaxBidDTO [ AccountID: 98, ElementType: searchEngineAccount, ElementID: 2216, CurrentBid: 50000.0, CurrentBidSetDate: 2014-11-07, NewBid: 50000.0, NewBidSetDate: 2014-11-07, DistributionID: 178, Campaign Identifier: 908302, AdGroup Identifier: 323516578, RetryCount: 0, Budget: 115.0, Actual SE Budget: 70000.0 ] 2014-11-07 10:53:04.472 (4) [P1T1]: Pending bids mapped to campaigns... 2014-11-07 10:53:04.472 (4) [P1T1]: BidElement [ AccountID: 98, BidElementType: searchEngineAccount, BidElementID: 2216, BidElementIdentifier: 908302 ] 2014-11-07 10:53:04.472 (4) [P1T1]: Bids mapped to above BidElement... 2014-11-07 10:53:04.472 (4) [P1T1]: BidUpdate [ BidToBeUpdated: 50000.0, BiddingLevelIdentifier: 323516578 ] 2014-11-07 10:53:04.475 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2014-11-07 10:53:06.799 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2014-11-07 10:53:06.800 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:53:06.800 (4) [P1T1]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineClass`!=""))] 2014-11-07 10:53:07.283 (4) [P1T1]: time=0.483 2014-11-07 10:53:07.283 (4) [P1T1]: Query executed in 0.483s 2014-11-07 10:53:07.284 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:53:07.285 (3) [P1T1]: originalCurrencyValue(50000.0) : aCurrencyCode(JPY) : roundedCurrencyValue(50000) 2014-11-07 10:53:07,607 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - ======================================================================================== 2014-11-07 10:53:07,610 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - AdGroupService EndPoint URL = https://colo02.ss.yahooapis.jp/services/V5.0/AdGroupService 2014-11-07 10:53:07,611 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - ======================================================================================== 2014-11-07 10:53:07,970 [P1T1] INFO o.a.c.s.f.ReflectionServiceFactoryBean - Creating Service {http://ss.yahooapis.jp/V5}AdGroupService from class jp.yahooapis.ss.V5.AdGroupService.AdGroupServiceInterface 2014-11-07 10:53:08,244 [P1T1] INFO o.a.c.s.f.ReflectionServiceFactoryBean - Creating Service {http://ss.yahooapis.jp/V5}AdGroupService from class jp.yahooapis.ss.V5.AdGroupService.AdGroupServiceInterface 2014-11-07 10:53:08,905 [P1T1] DEBUG c.t.s.c.y.util.SoapClientHandler - REQUEST XML: 1327-7818-1693-5552 5567-7860-7473-8517 MtFuj1 586501 ylWCn-cgHc-Kyf4z-6PGU TSATrialYahoo55 SET 586501 908302 586501 908302 323516578 50000 2014-11-07 10:53:08,908 [P1T1] INFO o.a.c.s.A.A.AdGroupServiceInterface - Outbound Message --------------------------- ID: 1 Address: https://colo02.ss.yahooapis.jp/services/V5.0/AdGroupService Encoding: UTF-8 Http-Method: POST Content-Type: text/xml Headers: {Accept=[*/*], SOAPAction=[""]} Payload: 1327-7818-1693-55525567-7860-7473-8517MtFuj1586501 ylWCn-cgHc-Kyf4z-6PGU TSATrialYahoo55 SET58650190830258650190830232351657850000 -------------------------------------- 2014-11-07 10:53:11,296 [P1T1] INFO o.a.c.s.A.A.AdGroupServiceInterface - Inbound Message ---------------------------- ID: 1 Response-Code: 200 Encoding: UTF-8 Content-Type: text/xml; charset=utf-8 Headers: {Cache-Control=[private], connection=[close], Content-Length=[1216], content-type=[text/xml; charset=utf-8], Date=[Fri, 07 Nov 2014 18:53:14 GMT], P3P=[policyref="http://privacy.yahoo.co.jp/w3c/p3p_jp.xml", CP="CAO DSP COR CUR ADM DEV TAI PSA PSD IVAi IVDi CONi TELo OTPi OUR DELi SAMi OTRi UNRi PUBi IND PHY ONL UNI PUR FIN COM NAV INT DEM CNT STA POL HEA PRE GOV"], Vary=[Accept-Encoding]} Payload: AdGroupService3418810.1407AdGroupReturnValueSETtrue586501908302a98_150501_400001_330_GT323516578a98_150501_400001_330ACTIVEMANUAL_CPC50000 -------------------------------------- 2014-11-07 10:53:11,345 [P1T1] DEBUG c.t.s.c.y.util.SoapClientHandler - RESPONSE XML: AdGroupService 34188 1 0.1407 AdGroupReturnValue SET true 586501 908302 a98_150501_400001_330_GT 323516578 a98_150501_400001_330 ACTIVE MANUAL_CPC 50000 2014-11-07 10:53:11.366 (4) [P1T1]: preparing SQL statement [update `st-tracker`.admaxBids ab join `tsacommon`.searchEngineAccounts sea on sea.id = ab.elementID set ab.currentBid=ab.newBid,ab.newBid=NULL,ab.newBidSetDate=NULL,ab.currentBidSetDate=?,ab.retryCount=0 where ab.newBid IS NOT NULL and sea.distributionID=? and ab.elementID in (2216)] 2014-11-07 10:53:11.547 (3) [P1T1]: Updated rows (1) matched the number of pending updates (1) 2014-11-07 10:53:11.547 (3) [P1T1]: Completed User (96) "797667fd-206f-4324-bfbb-5e5dc4b14704_1" 2014-11-07 10:53:11.547 (4) [P1T1]: Returning Object to Pool 2014-11-07 10:53:11.548 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2014-11-07 10:53:11.548 (3) [main]: ------------Search Engine Bid Updater done