2011-06-28 08:33:52.430 (3) [main]: Debug Level set to 3 2011-06-28 08:33:52.451 (3) [main]: DatabasePool with a limit of 38 created 2011-06-28 08:33:53.959 (3) [main]: SESUMM: Rerunning specified seUsers (8) or seAccounts (null) 2011-06-28 08:33:53.966 (3) [main]: DatabasePool with a limit of 105 created 2011-06-28 08:33:54.432 (3) [main]: ... distinct accountIDs retrieved for seUser[8] seAccount[null]: 17,727 2011-06-28 08:33:54.561 (3) [main]: Debug Level set to 3 2011-06-28 08:33:54.567 (3) [main]: =============== Starting Search Engine Summarizer for Mon Jun 27 00:00:00 PDT 2011 ================ 2011-06-28 08:33:59.091 (3) [P1T1]: No licensing config file found, assuming TSA production environment 2011-06-28 08:34:01.318 (3) [P1T1]: Created shared sesystem connection rw log4j:WARN No appenders could be found for logger (org.apache.axis.AxisEngine). log4j:WARN Please initialize the log4j system properly. 2011-06-28 08:34:09.535 (3) [P2T2]: DatabasePool with a limit of 105 created 2011-06-28 08:34:10.279 (3) [P1T2]: DatabasePool with a limit of 105 created 2011-06-28 08:34:10.485 (3) [P2T2]: SESUMM: Handling Account (32952) "Tom's NC Test Campaign" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:10.657 (3) [P2T3]: SESUMM: Handling Account (33903) "2 Test Sync" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:11.149 (3) [P1T2]: SESUMM: Handling Account (40498) "Campaign #22" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:12.765 (3) [P1T2]: DatabasePool with a limit of 105 created 2011-06-28 08:34:13.145 (3) [P1T1]: SESUMM: Handling Account (40339) "BO Campaign" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:14.418 (2) [P1T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp2.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:16.244 (2) [P1T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp3.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:16.372 (2) [P1T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp1.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:16.645 (2) [P1T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp4.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:16.736 (2) [P1T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp5.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:16.897 (2) [P1T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp6.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:18.276 (3) [P1T1]: SESUMM: Completed Account (40339) "BO Campaign" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:18.317 (2) [P1T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:19.035 (3) [P1T2]: SESUMM: Completed Account (40498) "Campaign #22" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:19.036 (2) [P1T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:20.619 (2) [P2T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp7.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:21.004 (2) [P2T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp8.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:21.319 (2) [P2T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp10.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:21.355 (2) [P2T3]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp9.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:21.372 (3) [P2T2]: SESUMM: Completed Account (32952) "Tom's NC Test Campaign" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:21.375 (2) [P2T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:21.451 (2) [P2T3]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp11.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:22.056 (3) [P2T1]: SESUMM: Handling Account (43) "#9765BF - CSC BF with Cost | #993BT - Was Camp #1 - Test" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:22.084 (2) [P2T3]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp12.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:22.220 (3) [P2T3]: SESUMM: Completed Account (33903) "2 Test Sync" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:22.221 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:22.590 (2) [P2T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp13.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:24.180 (2) [P2T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp14.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:24.376 (2) [P2T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp15.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:24.412 (3) [P2T1]: SESUMM: Completed Account (43) "#9765BF - CSC BF with Cost | #993BT - Was Camp #1 - Test" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:24.413 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:27.319 (3) [P2T1]: SESUMM: Handling Account (33985) "Campaign #20 - keywords" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:27.386 (3) [P2T3]: SESUMM: Handling Account (33695) "Campaign Sync Test #4" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:27.750 (2) [P2T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp16.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:28.846 (3) [P2T2]: SESUMM: Handling Account (33651) "Campaign #17" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:29.008 (2) [P2T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp17.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:29.121 (2) [P2T3]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp18.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:29.166 (2) [P2T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp19.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:29.346 (2) [P2T3]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp20.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:29.522 (2) [P2T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp21.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:29.642 (2) [P2T3]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp22.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:29.689 (2) [P2T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp23.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:29.718 (3) [P2T3]: SESUMM: Completed Account (33695) "Campaign Sync Test #4" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:29.719 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:29.805 (2) [P2T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp24.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:31.717 (3) [P2T2]: SESUMM: Completed Account (33651) "Campaign #17" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:31.717 (2) [P2T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:31.821 (3) [P2T1]: SESUMM: Completed Account (33985) "Campaign #20 - keywords" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:31.825 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:34.636 (3) [P2T3]: SESUMM: Handling Account (33657) "Campaign with placements CPM" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:34.960 (3) [P2T2]: SESUMM: Handling Account (33697) "Campaign 100" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:35.004 (3) [P2T1]: SESUMM: Handling Account (32954) "Campaign #16" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:35.229 (2) [P2T3]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp25.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:35.293 (2) [P2T3]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp26.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:35.522 (2) [P2T3]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp27.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:35.585 (2) [P2T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp28.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:35.608 (2) [P2T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp29.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:35.617 (3) [P2T3]: SESUMM: Completed Account (33657) "Campaign with placements CPM" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:35.617 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:35.677 (2) [P2T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp30.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:35.685 (2) [P2T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp31.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:35.905 (2) [P2T2]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp33.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:35.914 (2) [P2T1]: Exception [SESUMM: trapping exception]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp32.kwDestUrl' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172) at com.carldunham.jst.db.Database.executeQuery(Database.java:356) at com.carldunham.jst.db.Database.executeQuery(Database.java:308) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169) at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1150) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:36.001 (3) [P2T2]: SESUMM: Completed Account (33697) "Campaign 100" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:36.001 (2) [P2T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:36.005 (3) [P2T1]: SESUMM: Completed Account (32954) "Campaign #16" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:36.005 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:36.118 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:36.118 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:36.118 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:36.124 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:36.418 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:36.418 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:36.418 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:36.421 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:36.456 (3) [P2T3]: SESUMM: Handling Account (20488) "Dave C Testing Copy" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:36.909 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:36.909 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:36.909 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:36.910 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:36.932 (2) [P2T3]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.AccountDatabases.get(AccountDatabases.java:76) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1002) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:36.932 (2) [P2T3]: Unable to get Database from pool! 2011-06-28 08:34:36.932 (2) [P2T3]: Null db returned for url [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:36.941 (2) [P2T3]: Exception [SESUMM: trapping exception]:java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1046) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:36.969 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:36.970 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:36.970 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:36.970 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:36.993 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:36.993 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:36.993 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:36.994 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:37.037 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.037 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:37.037 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:37.040 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:37.089 (2) [P2T3]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.AccountDatabases.get(AccountDatabases.java:76) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1002) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.089 (2) [P2T3]: Unable to get Database from pool! 2011-06-28 08:34:37.089 (2) [P2T3]: Null db returned for url [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:37.105 (2) [P2T3]: Exception [SESUMM: trapping exception]:java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1046) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.249 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.253 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:37.253 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:37.253 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:37.286 (2) [P2T3]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.AccountDatabases.get(AccountDatabases.java:76) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1002) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.286 (2) [P2T3]: Unable to get Database from pool! 2011-06-28 08:34:37.289 (2) [P2T3]: Null db returned for url [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:37.294 (2) [P2T3]: Exception [SESUMM: trapping exception]:java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1046) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.677 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.677 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:37.677 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:37.705 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:37.785 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.789 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:37.789 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:37.789 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:37.873 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.873 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:37.873 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:37.877 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:37.905 (3) [P2T3]: SESUMM: Completed Account (20488) "Dave C Testing Copy" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:37.905 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:37.906 (3) [P2T2]: SESUMM: Handling Account (33696) "Yet another Campaign" for user (8) "WWMW - Cellular Safety Commission" 2011-06-28 08:34:37.913 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.916 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:37.916 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:37.916 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:37.937 (2) [P2T2]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.AccountDatabases.get(AccountDatabases.java:76) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1002) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.937 (2) [P2T2]: Unable to get Database from pool! 2011-06-28 08:34:37.937 (2) [P2T2]: Null db returned for url [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:37.945 (2) [P2T2]: Exception [SESUMM: trapping exception]:java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1046) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.964 (2) [P2T3]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:37.964 (2) [P2T3]: Unable to get Database from pool! 2011-06-28 08:34:37.964 (2) [P2T3]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:37.964 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:38.225 (2) [P2T3]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:38.233 (2) [P2T3]: Unable to get Database from pool! 2011-06-28 08:34:38.233 (2) [P2T3]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:38.233 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:38.294 (2) [P2T2]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.AccountDatabases.get(AccountDatabases.java:76) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1002) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:38.294 (2) [P2T2]: Unable to get Database from pool! 2011-06-28 08:34:38.294 (2) [P2T2]: Null db returned for url [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:38.309 (2) [P2T2]: Exception [SESUMM: trapping exception]:java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1046) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:38.316 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:38.316 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:38.316 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:38.317 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:38.333 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:38.333 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:38.333 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:38.334 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:38.353 (2) [P2T2]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.AccountDatabases.get(AccountDatabases.java:76) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1002) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:38.354 (2) [P2T2]: Unable to get Database from pool! 2011-06-28 08:34:38.354 (2) [P2T2]: Null db returned for url [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:38.364 (2) [P2T2]: Exception [SESUMM: trapping exception]:java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:1046) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:830) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:38.384 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:38.952 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:38.969 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:38.977 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:39.013 (3) [P2T2]: SESUMM: Completed Account (33696) "Yet another Campaign" for user (8), 0 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2011-06-28 08:34:39.013 (2) [P2T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:847) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:39.037 (2) [P2T3]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:39.040 (2) [P2T3]: Unable to get Database from pool! 2011-06-28 08:34:39.040 (2) [P2T3]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:39.041 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:39.059 (2) [P2T2]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:39.061 (2) [P2T2]: Unable to get Database from pool! 2011-06-28 08:34:39.061 (2) [P2T2]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:39.061 (2) [P2T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:39.077 (2) [P2T2]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:39.077 (2) [P2T2]: Unable to get Database from pool! 2011-06-28 08:34:39.077 (2) [P2T2]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:39.078 (2) [P2T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:39.789 (2) [P2T3]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:39.789 (2) [P2T3]: Unable to get Database from pool! 2011-06-28 08:34:39.793 (2) [P2T3]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:39.795 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:39.877 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:39.881 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:39.881 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:39.885 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.281 (2) [P2T2]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.281 (2) [P2T2]: Unable to get Database from pool! 2011-06-28 08:34:40.289 (2) [P2T2]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.289 (2) [P2T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.373 (2) [P2T3]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.377 (2) [P2T3]: Unable to get Database from pool! 2011-06-28 08:34:40.381 (2) [P2T3]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.381 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.413 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.413 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:40.414 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.417 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.433 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.434 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:40.435 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.436 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.455 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.456 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:40.457 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.457 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.705 (2) [P2T3]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.709 (2) [P2T3]: Unable to get Database from pool! 2011-06-28 08:34:40.713 (2) [P2T3]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.713 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.797 (2) [P2T2]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.805 (2) [P2T2]: Unable to get Database from pool! 2011-06-28 08:34:40.805 (2) [P2T2]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.817 (2) [P2T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.825 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.825 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:40.825 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.825 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.843 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.843 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:40.843 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.844 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.863 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.865 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:40.865 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.865 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:40.887 (2) [P2T1]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:40.887 (2) [P2T1]: Unable to get Database from pool! 2011-06-28 08:34:40.889 (2) [P2T1]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:40.889 (2) [P2T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:41.793 (2) [P2T2]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:41.797 (2) [P2T2]: Unable to get Database from pool! 2011-06-28 08:34:41.797 (2) [P2T2]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:41.809 (2) [P2T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:41.889 (2) [P2T3]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:41.889 (2) [P2T3]: Unable to get Database from pool! 2011-06-28 08:34:41.889 (2) [P2T3]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:41.893 (2) [P2T3]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:42.179 (2) [P2T2]: Exception [creating pooled Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.carldunham.jst.db.Database.init(Database.java:203) at com.carldunham.jst.db.Database.(Database.java:188) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172) at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35) at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88) at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129) at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:79) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-28 08:34:42.183 (2) [P2T2]: Unable to get Database from pool! 2011-06-28 08:34:42.183 (2) [P2T2]: Null db returned for url [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2011-06-28 08:34:42.191 (2) [P2T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) at java.util.concurrent.FutureTask.get(FutureTask.java:80) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:652) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404) at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:67) at com.thesearchagency.AccountUtils.isAccountOnline(AccountUtils.java:80) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineAccountWorker.run(SearchEngineSummarizer.java:763) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) ... 2 more 2011-06-28 08:34:42.195 (3) [main]: After joining threads, calling doPostJoinActions 2011-06-28 08:34:42.195 (3) [main]: =============== Completed Search Engine Summarizer ================