Hi, I solved the Communication link failure.
1. First i changed the setting of mysql. It no runs with: set-variable = back_log=100 set-variable = connect_timeout=25 set-variable = flush_time=3600 set-variable = interactive_timeout=31536000 set-variable = key_buffer_size=16M set-variable = max_connections=256 set-variable = max_connect_errors=9000000 set-variable = max_allowed_packet=2M set-variable = net_retry_count=100 set-variable = read_buffer_size=256K set-variable = sort_buffer_size=4M set-variable = thread_stack=256K set-variable = table_cache=256 set-variable = wait_timeout=31536000 set-variable = query_cache_size=4M (Any comments on the settings are still highly appreciated ;-) 2. Furthermore i deleted the <Context path="/mm" docBase="/home/mmbase/mmbase-app" debug="0">..</Context> part of the server.xml of Tomcat. It made MMBase startup two times: ones because it was defined as a context and twice because MMBase was located in the Root directory. This resulted in 2x20 connections per MMBase installation, which resulted in a lot of aborted connects, etc. Should i add this as a note to the MMBase documentation? The server now runs five Tomcat + MMBase installation without any problem. Regards, Henk. T. +31-(0)6-29054903 E. [EMAIL PROTECTED] I. http://www.mmatch.nl > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Henk Hangyi > Sent: Friday, October 24, 2003 1:38 PM > To: [EMAIL PROTECTED] > Subject: Communication link failure: java.io.EOFException (on > closer look) > > > On closer look: the error messages start with: Lost > connection to server > during query. > > The last two rows of the log below are repeated a number of times. > > Maybe this sheds some more light on the problem. > > 2003-10-24 13:21:00,207 INFO org.mmbase.module.Module - Starting > module mmbaseroot > 2003-10-24 13:21:00,208 SERVICE mmbase.module.core.MMBase - Init of > MMBase 1.6.5-Final.20030829 > 2003-10-24 13:21:00,209 INFO mmbase.module.core.MMBase - mmbase > default locale : nl > 2003-10-24 13:21:00,232 INFO mmbase.module.database.JDBCProbe - JDBC > probe starting > 2003-10-24 13:21:00,662 INFO org.mmbase.util.DatabaseLookup > - Selected > database: 'relational' based on 4 rules in it's > filter.(org.gjt.mm.mysql.jdbc2.Connection) > 2003-10-24 13:21:00,834 INFO mmbase.module.core.MMBase - > Using class: > 'org.mmbase.storage.database.RelationalDatabaseStorage' with config: > '/usr/share/tc_jubileum/webapps/ROOT/WEB-INF/config/databases/ > relational > .xml'. > 2003-10-24 13:21:00,909 SERVICE mmbase.module.database.MultiPool - > Creating a multipool for database root containing : 20 connections, > which will be refreshed after 256 queries > 2003-10-24 13:21:01,801 ERROR > mmbase.storage.database.SQL92DatabaseStorage - Lost connection to > server during query > 2003-10-24 13:21:01,802 SERVICE mmbase.module.database.MultiPool - > Creating a multipool for database root containing : 20 connections, > which will be refreshed after 256 queries > 2003-10-24 13:21:02,085 ERROR > mmbase.storage.database.SQL92DatabaseStorage - Communication link > failure: java.io.EOFException error > > >
