ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fran├žois Schiettecatte <fschietteca...@gmail.com>
Subject interesting exception in 3.0
Date Sat, 01 May 2010 20:08:35 GMT
Hi

I grabbed the latest, greatest release of 3.0 from :

	http://people.apache.org/builds/ibatis/ibatis-3-core/ibatis-core-3.0-bundle.zip

and am now getting an exception from time to time, but I was not getting it with the previous
3.0 beta release (240). I was wondering if there had been any change in the code which deals
with connections and pool between those two releases. What it looks like to me is that connections
are not being returned to the pool after I close the SqlSession. I have mysql set to timeout
idle connections after 60 seconds and the connection pool to time out idle connections after
50 seconds. Again this was not an issue in 240.

Any suggestions?

Cheers

Fran├žois


2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - com.poplar.sql.IBatis.selectObject(IBatis.java:554)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - com.poplar.db.dictionaries.Category.fromCategoryName(Category.java:118)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - com.poplar.db.items.ItemCategory.<init>(ItemCategory.java:201)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - com.poplar.db.items.ItemCategory.<init>(ItemCategory.java:227)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - com.poplar.db.items.Item.addItemCategory(Item.java:2182)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - com.poplar.crawler.processors.FeedProcessor.processEntryCategories(FeedProcessor.java:2494)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - com.poplar.crawler.processors.FeedProcessor.process(FeedProcessor.java:823)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - com.poplar.crawler.Worker.crawl(Worker.java:1313)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - com.poplar.crawler.Worker.crawlSourceKey(Worker.java:681)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - com.poplar.crawler.Worker.run(Worker.java:591)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - java.lang.Thread.run(Thread.java:619)
2010-05-01 01:54:20,609 [pool-1-thread-1] WARN  com.poplar.crawler.Worker - Failed to crawl
the source key: 'C01240E19154BE7BDA3703F726D5A68190D4A540', exception: 'org.apache.ibatis.exceptions.IbatisException:

### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure

The last packet successfully received from the server was 104,024 milliseconds ago.  The last
packet sent successfully to the server was 0 milliseconds ago.
### The error may involve dictionaries.Category.selectObjectByCategoryName-Inline
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 104,024 milliseconds ago.  The last
packet sent successfully to the server was 0 milliseconds ago.'.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message