-d4 -S 178 -U 96
2014-11-05 11:23:39.802 (3) [main]: Debug Level set to 4
2014-11-05 11:23:39.858 (4) [main]: registered MBean [thesearchagency.db.util:type=MultiplexDatabasePool3d9be672-6b2d-489c-a1c5-0cbbcd5b668c] for class com.thesearchagency.db.util.MultiplexDatabasePool
2014-11-05 11:23:43.707 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2014-11-05 11:23:43.711 (4) [main]: registered MBean [com.carldunham.jst.pooling:type=ObjectPoola41d6ecd-74dd-4d04-9268-aba41567acf6] for class com.carldunham.jst.pooling.ObjectPool
2014-11-05 11:23:43.711 (3) [main]: DatabasePool with a limit of 80 created
2014-11-05 11:23:43.712 (4) [main]: registered MBean [com.carldunham.jst.db:type=DatabasePool1c909aea-2f1d-4fe7-9caf-c287f53a88bb] for class com.carldunham.jst.db.DatabasePool
2014-11-05 11:23:43.726 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2014-11-05 11:23:46.084 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2014-11-05 11:23:46.084 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:23:46.084 (4) [main]: Created new Object
2014-11-05 11:23:46.086 (4) [main]: spike: SQL->[select @@version]
2014-11-05 11:23:46.580 (4) [main]: time=0.493
2014-11-05 11:23:46.580 (4) [main]: Query executed in 0.493s
2014-11-05 11:23:46.580 (4) [main]: test query succeeded, returned "5.5.34"
2014-11-05 11:23:46.589 (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-05 11:23:47.083 (4) [main]: time=0.494
2014-11-05 11:23:47.083 (4) [main]: Query executed in 0.494s
2014-11-05 11:23:47.084 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2014-11-05 11:23:49.055 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2014-11-05 11:23:49.056 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:23:49.056 (4) [main]: Created new Object
2014-11-05 11:23:49.056 (4) [main]: spike: SQL->[select @@version]
2014-11-05 11:23:49.549 (4) [main]: time=0.493
2014-11-05 11:23:49.550 (4) [main]: Query executed in 0.493s
2014-11-05 11:23:49.550 (4) [main]: test query succeeded, returned "5.5.34"
2014-11-05 11:23:49.560 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=178) limit 1]
2014-11-05 11:23:50.089 (4) [main]: time=0.529
2014-11-05 11:23:50.090 (4) [main]: Query executed in 0.529s
2014-11-05 11:23:50.096 (4) [main]: Record Loaded
2014-11-05 11:23:50.138 (3) [main]: Skipping initialization of Yahoo Client. This means no API calls can be made.
2014-11-05 11:23:50.140 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2014-11-05 11:23:52.170 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2014-11-05 11:23:52.170 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:23:52.171 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=1) limit 1]
2014-11-05 11:23:52.726 (4) [main]: time=0.555
2014-11-05 11:23:52.726 (4) [main]: Query executed in 0.555s
2014-11-05 11:23:52.728 (4) [main]: Record Loaded
2014-11-05 11:23:52.728 (4) [main]: DataCache: put key acct-st-tracker 1
2014-11-05 11:23:52.730 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1]
2014-11-05 11:23:53.224 (4) [main]: time=0.494
2014-11-05 11:23:53.224 (4) [main]: Query executed in 0.494s
2014-11-05 11:23:53.225 (4) [main]: Record Loaded
2014-11-05 11:23:53.225 (4) [main]: DataCache: put key acct-st-tracker-1
2014-11-05 11:23:53.226 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:23:53.226 (4) [main]: registered MBean [com.carldunham.jst.pooling:type=ObjectPoolb4c7882f-2809-4021-8f4f-cf01f7e5d0cf] for class com.carldunham.jst.pooling.ObjectPool
2014-11-05 11:23:53.226 (3) [main]: DatabasePool with a limit of 80 created
2014-11-05 11:23:53.226 (4) [main]: registered MBean [com.carldunham.jst.db:type=DatabasePoolbc111b72-54c8-4fa9-a438-a68e901d3d64] for class com.carldunham.jst.db.DatabasePool
2014-11-05 11:23:55.200 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2014-11-05 11:23:55.200 (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-05 11:23:55.200 (4) [main]: Created new Object
2014-11-05 11:23:55.200 (4) [main]: spike: SQL->[select @@version]
2014-11-05 11:23:55.684 (4) [main]: time=0.484
2014-11-05 11:23:55.684 (4) [main]: Query executed in 0.484s
2014-11-05 11:23:55.684 (4) [main]: test query succeeded, returned "5.5.34"
2014-11-05 11:23:55.695 (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-05 11:24:13.727 (4) [ConnectionCloser]: 2 DatabasePools remaining : 0 pending closure
2014-11-05 11:24:43.727 (4) [ConnectionCloser]: 2 DatabasePools remaining : 0 pending closure
2014-11-05 11:25:13.727 (4) [ConnectionCloser]: 2 DatabasePools remaining : 0 pending closure
2014-11-05 11:25:43.728 (4) [ConnectionCloser]: 2 DatabasePools remaining : 0 pending closure
2014-11-05 11:26:13.728 (4) [ConnectionCloser]: 0 DatabasePools remaining : 0 pending closure
2014-11-05 11:26:13.728 (4) [ConnectionCloser]: Stopping DatabasePool ConnectionCloserThread
2014-11-05 11:26:54.418 (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-05 11:26:54.605 (4) [main]: Returning Object to Pool
2014-11-05 11:26:54.606 (4) [main]: Returning Object to Pool
2014-11-05 11:26:54.606 (4) [main]: All Pending Bids (before validation)...
2014-11-05 11:26:54.607 (4) [main]: AdmaxBidDTO [ AccountID: 98, ElementType: searchEngineAccount, ElementID: 2216, CurrentBid: 15.321, CurrentBidSetDate: 2014-11-01, NewBid: 25.0, NewBidSetDate: 2014-11-05, RetryCount: 0 ]
2014-11-05 11:26:54.608 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2014-11-05 11:26:59.084 (3) [main]: ----------------Search Engine Bid Updater starting
2014-11-05 11:26:59.084 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2014-11-05 11:27:01.338 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2014-11-05 11:27:01.338 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:27:01.348 (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-05 11:27:01.836 (4) [main]: time=0.488
2014-11-05 11:27:01.836 (4) [main]: Query executed in 0.488s
2014-11-05 11:27:01.839 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2014-11-05 11:27:01.839 (4) [main]: Took Existing Object from Pool
2014-11-05 11:27:01.839 (4) [main]: spike: SQL->[select @@version]
2014-11-05 11:27:02.322 (4) [main]: time=0.483
2014-11-05 11:27:02.322 (4) [main]: Query executed in 0.483s
2014-11-05 11:27:02.322 (4) [main]: test query succeeded, returned "5.5.34"
2014-11-05 11:27:02.323 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=178) limit 1]
2014-11-05 11:27:02.877 (4) [main]: time=0.554
2014-11-05 11:27:02.877 (4) [main]: Query executed in 0.554s
2014-11-05 11:27:02.878 (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-05 11:27:03,155 [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-05 11:27:03.160 (4) [main]: preparing SQL statement [select currencyCode from `tsacommon`.`accounts` where id = ?]
2014-11-05 11:27:03.383 (4) [main]: Returning Object to Pool
2014-11-05 11:27:03.384 (3) [P1T1]: Starting User (96) "797667fd-206f-4324-bfbb-5e5dc4b14704_1"
2014-11-05 11:27:03.384 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2014-11-05 11:27:05.423 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2014-11-05 11:27:05.423 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:27:05.423 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=98) limit 1]
2014-11-05 11:27:05.975 (4) [P1T1]: time=0.552
2014-11-05 11:27:05.975 (4) [P1T1]: Query executed in 0.552s
2014-11-05 11:27:05.976 (4) [P1T1]: Record Loaded
2014-11-05 11:27:05.976 (4) [P1T1]: DataCache: put key acct-st-tracker 98
2014-11-05 11:27:05.976 (4) [P1T1]: DataCache: Found key acct-st-tracker-1
2014-11-05 11:27:05.976 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:27:05.976 (4) [P1T1]: Took Existing Object from Pool
2014-11-05 11:27:05.976 (4) [P1T1]: spike: SQL->[select @@version]
2014-11-05 11:27:06.465 (4) [P1T1]: time=0.489
2014-11-05 11:27:06.465 (4) [P1T1]: Query executed in 0.489s
2014-11-05 11:27:06.465 (4) [P1T1]: test query succeeded, returned "5.5.34"
2014-11-05 11:27:06.467 (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-05 11:27:06.468 (4) [P1T1]: All Pending Bids (after validation) for SEU 96...
2014-11-05 11:27:06.468 (4) [P1T1]: AdmaxBidDTO [ AccountID: 98, ElementType: searchEngineAccount, ElementID: 2216, CurrentBid: 15.321, CurrentBidSetDate: 2014-11-01, NewBid: 25.0, NewBidSetDate: 2014-11-05, DistributionID: 178, Campaign Identifier: 908302, AdGroup Identifier: 3235165781, RetryCount: 0, Budget: 115.0, Actual SE Budget: 100.0 ]
2014-11-05 11:27:06.469 (4) [P1T1]: Pending bids mapped to campaigns...
2014-11-05 11:27:06.469 (4) [P1T1]: BidElement [ AccountID: 98, BidElementType: searchEngineAccount, BidElementID: 2216, BidElementIdentifier: 908302 ]
2014-11-05 11:27:06.469 (4) [P1T1]: Bids mapped to above BidElement...
2014-11-05 11:27:06.469 (4) [P1T1]: BidUpdate [ BidToBeUpdated: 25.0, BiddingLevelIdentifier: 3235165781 ]
2014-11-05 11:27:08.981 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2014-11-05 11:27:11.183 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2014-11-05 11:27:11.183 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:27:11.184 (4) [P1T1]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineClass`!=""))]
2014-11-05 11:27:11.674 (4) [P1T1]: time=0.489
2014-11-05 11:27:11.674 (4) [P1T1]: Query executed in 0.489s
2014-11-05 11:27:11.674 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:27:11.676 (3) [P1T1]: originalCurrencyValue(25.0) : aCurrencyCode(JPY) : roundedCurrencyValue(25)
2014-11-05 11:27:24.608 (4) [ConnectionCloser]: 2 DatabasePools remaining : 1 pending closure
2014-11-05 11:27:26.889 (2) [Finalizer]: AccountDatabases: finalize: unloading connections - app may need updates?
2014-11-05 11:27:26.889 (4) [Finalizer]: Returning Object to Pool
2014-11-05 11:27:27,179 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - ========================================================================================
2014-11-05 11:27:27,179 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - AdGroupService EndPoint URL = https://colo02.ss.yahooapis.jp/services/V5.0/AdGroupService
2014-11-05 11:27:27,180 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - ========================================================================================
2014-11-05 11:27:27,481 [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-05 11:27:27,789 [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-05 11:27:28,324 [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
3235165781
25
2014-11-05 11:27:28,327 [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 SET586501908302586501908302323516578125
--------------------------------------
2014-11-05 11:27:30,815 [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=[936], content-type=[text/xml; charset=utf-8], Date=[Wed, 05 Nov 2014 19:27:31 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:
AdGroupService3406810.1449AdGroupReturnValueSETfalse10100DEACTIVATEDadGroupId3235165781
--------------------------------------
2014-11-05 11:27:30,877 [P1T1] DEBUG c.t.s.c.y.util.SoapClientHandler - RESPONSE XML:
AdGroupService
34068
1
0.1449
AdGroupReturnValue
SET
false
10100
DEACTIVATED
adGroupId
3235165781
2014-11-05 11:27:39,021 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - ******* Error *******
2014-11-05 11:27:39,021 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - code = 10100
2014-11-05 11:27:39,021 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - message = DEACTIVATED
2014-11-05 11:27:39,022 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - ******* Error Detail *******
2014-11-05 11:27:39,022 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - request key = adGroupId
2014-11-05 11:27:39,022 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - request value = 3235165781
2014-11-05 11:27:54.608 (4) [ConnectionCloser]: 2 DatabasePools remaining : 2 pending closure
2014-11-05 11:28:03.384 (3) [main]: Waiting for tasks to be done
2014-11-05 11:28:24.378 (2) [P1T1]: Sending bid to search engine for SEU 96, SEA 2216 failed, but will be retried next time this app is run.
2014-11-05 11:28:24.378 (4) [P1T1]: preparing SQL statement [update `st-tracker`.admaxBids ab set ab.retryCount=? where ab.accountID=? and ab.elementID=? and ab.elementType=?]
2014-11-05 11:28:24.584 (3) [P1T1]: Updated rows (1) matched the number of pending updates (1)
2014-11-05 11:28:24.584 (3) [P1T1]: Completed User (96) "797667fd-206f-4324-bfbb-5e5dc4b14704_1"
2014-11-05 11:28:24.584 (4) [P1T1]: Returning Object to Pool
2014-11-05 11:28:24.609 (4) [ConnectionCloser]: closing db conn
2014-11-05 11:28:24.609 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:28:24.609 (4) [ConnectionCloser]: 2 DatabasePools remaining : 2 pending closure
2014-11-05 11:28:43.385 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 11:28:43.385 (3) [main]: ------------Search Engine Bid Updater done
2014-11-05 11:28:43.385 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2014-11-05 11:28:43.385 (4) [main]: Took Existing Object from Pool
2014-11-05 11:28:43.385 (4) [main]: spike: SQL->[select @@version]
2014-11-05 11:28:43.835 (4) [main]: time=0.45
2014-11-05 11:28:43.835 (4) [main]: Query executed in 0.450s
2014-11-05 11:28:43.836 (4) [main]: test query succeeded, returned "5.5.34"
2014-11-05 11:28:43.836 (4) [main]: Instantiating an AdmaxBidErrorDAO object for Database: jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true
2014-11-05 11:28:43.836 (4) [main]: preparing SQL statement [ select `st-tracker`.admaxBidErrors.admaxBidAccountID,`st-tracker`.admaxBidErrors.admaxBidElementType,`st-tracker`.admaxBidErrors.admaxBidElementID,`st-tracker`.admaxBidErrors.errorCode,`st-tracker`.admaxBidErrors.errorText,`st-tracker`.admaxBidErrors.reason,`st-tracker`.admaxBidErrors.field,`st-tracker`.admaxBidErrors.trigger,`st-tracker`.admaxBidErrors.runDate from `st-tracker`.admaxBidErrors]
2014-11-05 11:28:54.610 (4) [ConnectionCloser]: 2 DatabasePools remaining : 1 pending closure
2014-11-05 11:28:56.178 (4) [main]: Returning Object to Pool