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