I reinstalled msyql-5.0.18, after that the problem disappear. I think that is
a bug in mysql 5.0.16.

Thanks everyone!

发件人： ajun 发送时间： 2006-01-13 09:53:41 收件人： java 抄送： 主题： com.mysql.jdbc.CommunicationsException: Communications link failure

env: OS: centos 4.2 kernel: 2.6.9-5.ELsmp tomcat: 5.0 jdbc: 3.1.11 mysql: 5.0.16

mysql's log: mysqld got signal 11; This could be because you hit a bug. It is also possible that this
binary or one of the libraries it was linked against is corrupt, improperly
built, or misconfigured. This error can also be caused by malfunctioning
hardware. We will try our best to scrape up some info that will hopefully
help diagnose the problem, but since we have already crashed, something is
definitely wrong and this may fail.

key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=1 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.

thd=0x8a04c28 Attempting backtrace. You can use the following information to find
out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x4189ac, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8150650 0x8608b8 0x8a3aebc 0x8111ea6 0x81a31f4 0x8198b17 0x818f75a 0x8192946 0x818ebd2 0x8164175 0x81b146a 0x81b0002 0x816393a 0x81625cd 0x8161aad 0x85a3ae 0x6e2aee New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and
follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please
do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd- >query at 0x8a3d788 = select this_.id as id7_, this_.categoryid as
categoryi d17_7_, this_.websiteid as websiteid17_7_, this_.userid as userid17_7_,
this_.ti tle as title17_7_, this_.text as text17_7_, this_.anchor as anchor17_7_,
this_.p ubtime as pubtime17_7_, this_.updatetime as updatetime17_7_, this_.status
as sta tus17_7_, this_.link as link17_7_, this_.plugins as plugins17_7_,
this_.allowcom ments as allowco13_17_7_, this_.commentdays as comment14_17_7_,
this_.righttolef t as rightto15_17_7_, this_.pinnedtomain as pinnedt16_17_7_,
weblogcate3_.id as id0_, weblogcate3_.name as name15_0_, weblogcate3_.description as
descript3_15_0 _, weblogcate3_.image as image15_0_, weblogcate3_.websiteid as
websiteid15_0_, w ebsitedat4_.id as id1_, websitedat4_.handle as handle18_1_,
websitedat4_.name as name18_1_, websitedat4_.description as descript4_18_1_, websitedat4_.userid
as userid18_1_, websitedat4_.defaultpageid as defaultp6_18_1_,
websitedat4_.weblogd ayid as weblogda7_18_1_, websitedat4_.enablebloggerapi as enablebl8_18_1_,
websi tedat4_.bl thd- >thread_id=1 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash.

Number of processes running now: 0 060112 16:57:35 mysqld restarted 060112 16:57:35 InnoDB: Started; log sequence number 0 43715 060112 16:57:35 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.0.16-standard' socket: '/tmp/mysql.sock' port: 3306
MySQL Communi ty Edition - Standard (GPL)

tomcat's log: --- ROOT CAUSE --- org.hibernate.exception.GenericJDBCException: could not execute query at
org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(E rrorCodeConverter.java:92) at
org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.ja va:80) at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper. java:43) at org.hibernate.loader.Loader.doList(Loader.java:1596) at org.hibernate.loader.Loader.list(Loader.java:1577) at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:11 1) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300) at
org.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogEntrie s(HibernateWeblogManagerImpl.java:296) at
org.roller.business.WeblogManagerImpl.getWeblogEntries(WeblogManagerImpl .java:296) at
org.roller.business.search.operations.RebuildWebsiteIndexOperation.doRun (RebuildWebsiteIndexOperation.java:112) at
org.roller.business.search.operations.WriteToIndexOperation.run(WriteToI ndexOperation.java:41) at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Sourc e) at java.lang.Thread.run(Thread.java:595)

Caused by: com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1865) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2256) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2756) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536) at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedState ment.java:1159) at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedSta tement.java:684) at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:104 9) at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.java:92)

at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120 ) at org.hibernate.loader.Loader.getResultSet(Loader.java:1272) at org.hibernate.loader.Loader.doQuery(Loader.java:391) at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loade r.java:218) at org.hibernate.loader.Loader.doList(Loader.java:1593) at org.hibernate.loader.Loader.list(Loader.java:1577) at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:11 1) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300) at
org.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogEntrie s(HibernateWeblogManagerImpl.java:296) at
org.roller.business.WeblogManagerImpl.getWeblogEntries(WeblogManagerImpl .java:296) at
org.roller.business.search.operations.RebuildWebsiteIndexOperation.doRun (RebuildWebsiteIndexOperation.java:112) at
org.roller.business.search.operations.WriteToIndexOperation.run(WriteToI ndexOperation.java:41) at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Sourc e) at java.lang.Thread.run(Thread.java:595)

** END NESTED EXCEPTION **

Last packet sent to the server was 26 ms ago. at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2467) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2756) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536) at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedState ment.java:1159) at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedSta tement.java:684) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:104 9) at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.java:92) at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120 ) at org.hibernate.loader.Loader.getResultSet(Loader.java:1272) at org.hibernate.loader.Loader.doQuery(Loader.java:391) at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loade r.java:218) at org.hibernate.loader.Loader.doList(Loader.java:1593) ... 10 more INFO 2006-01-12 15:59:38,666 LRUCacheHandler2: <init > - PageCacheFilter
timeout=360 0seconds INFO 2006-01-12 15:59:38,668 LRUCacheHandler2: <init > - Initializing
for: RssCacheF ilter INFO 2006-01-12 15:59:38,670 LRUCacheHandler2: <init > - RssCacheFilter
size=100 INFO 2006-01-12 15:59:38,671 LRUCacheHandler2: <init > - RssCacheFilter
timeout=3600 seconds INFO 2006-01-12 15:59:38,679 LoginFilter:init - Remember Me enabled:
true INFO 2006-01-12 15:59:38,667 RebuildWebsiteIndexOperation:doRun -
Completed rebuil ding index for all users in '0.348' secs INFO 2006-01-12 15:59:38,699 WriteToIndexOperation:run - Search index
operation co mplete INFO 2006-01-12 15:59:39,730 LoginServlet:init - secure login enabled:
false INFO 2006-01-12 15:59:39,731 LoginServlet:init - secure login port:
443 (END)

less /usr/local/tomocat/conf/Catalina/localhost/roller.xml

<Context path="/roller" docBase="roller" debug="99"
workDir="work/Catalina/loca lhost/roller" >

<Realm className="org.apache.catalina.realm.JDBCRealm" driverName="com.mysql.jdbc.Driver" connectionURL= "jdbc:mysql://localhost:3306/roller?autoReconnect=true&useUnicode=t rue&characterEncoding=utf-8&mysqlEncoding=utf8" connectionName="roller" connectionPassword="v2^4aksH" userTable="rolleruser" userNameCol="username" userCredCol="passphrase" userRoleTable="userrole" roleNameCol="rolename" debug="99" / >

<Resource name="jdbc/rollerdb" auth="Container" type="javax.sql.DataSource"
/ >

<ResourceParams name="jdbc/rollerdb" > <parameter > <name >factory </name > <value >org.apache.commons.dbcp.BasicDataSourceFactory </value > </parameter > <parameter > <name >driverClassName </name > <value >com.mysql.jdbc.Driver </value > </parameter > <parameter > <name >url </name > <value
>jdbc:mysql://localhost:3306/roller?autoReconnect=false&jdbcCom pliantTruncation=false&useUnicode=true&characterEncoding=utf-8&mysq lEncoding=utf8 </value > </parameter > <parameter > <name >username </name > <value >roller </value >
</parameter > </value > </parameter > <parameter > <name >username </name > <value >roller </value >
</parameter > <parameter > <name >password </name > <value >v2^4aksH </value >
</parameter > <parameter > <name >maxActive </name > <value >50 </value > </parameter
> <parameter > <name >maxIdle </name > <value >5 </value > </parameter > <parameter > <name >removeAbandoned </name > <value >true </value >
</parameter > <parameter > <name >maxWait </name > <value >3000 </value > </parameter
> </ResourceParams >

<!-- To enable email notification of comments: uncomment the resouce below, set your mailhost, and make sure you have mail.jar and activation.jar in <tomcat >/common/lib. -- >

<Resource name="mail/Session" auth="Container"
type="javax.mail.Session"/ > <ResourceParams name="mail/Session" > <parameter > <name >mail.smtp.host </name > <value >mail.aria.cn </value > </parameter > </ResourceParams >

</Context >

I am newer in java, i don't know how to do to resolv the problem.
Any advice will be welcome!

Thanks a lot!