On Tue, 2006-05-23 at 11:39, Jeff Templon wrote:
> Hi,
>
> can you tell us why it is required if you DO run the archiver? as in
> exactly what bug in mysql is fixed in this version?
The create table fails because of the key length so the archiver fails.
Later version of mysql allow a longer key. When the archiver stops the
connections are not shut down cleanly because of a bug in the JDK.
Alastair
>
> JT
>
> Alastair Duncan wrote:
> > On Tue, 2006-05-23 at 10:35, Alessandra Forti wrote:
> >> Hi Alastair,
> >>
> >>
> >>
> >>
> >>> This only affects sites that are running glue archivers.
> >> it affects everyone. At the moment I have 187 of those connection in
> >> TIME_WAITS and it has been happening for months now.
> >
> > Hi Alessandra,
> >
> > The updated version of mysql is required for the glue archiver it is not
> > necessary to update all sites was what I was trying to convey in the
> > message.
> >
> > Alastair
> >
> >> cheers
> >> alessandra
> >>
> >>> Alastair
> >>>
> >>>
> >>>> Thanks, Antun
> >>>>
> >>>> -----
> >>>> Antun Balaz
> >>>> Research Assistant
> >>>> E-mail: [log in to unmask]
> >>>> Web: http://scl.phy.bg.ac.yu/
> >>>>
> >>>> Phone: +381 11 3160260, Ext. 152
> >>>> Fax: +381 11 3162190
> >>>>
> >>>> Scientific Computing Laboratory
> >>>> Institute of Physics, Belgrade
> >>>> Serbia and Montenegro
> >>>> -----
> >>>>
> >>>> ---------- Original Message -----------
> >>>> From: "Wilson, AJ (Antony)" <[log in to unmask]>
> >>>> To: [log in to unmask]
> >>>> Sent: Tue, 23 May 2006 09:36:45 +0100
> >>>> Subject: Re: [LCG-ROLLOUT] Too many connections in the MON BOX.
> >>>>
> >>>>> Hi
> >>>>>
> >>>>> Someone is using se.ulakbim.gov.tr to run user code that appears to
> >>>>> be trying to archive data from the
> >>>>> GlueSEAccessProtocolSupportedSecurity, GlueSL and GlueBatchSystem
> >>>>> tables. Unfortunately this code is crashing almost straight after
> >>>>> having created the consumers, it is then being restarted. R-GMA
> >>>>> should timeout the connections, but this is no good if new
> >>>>> connections are being created faster than the old ones are timing
> >>>> out.
> >>>>> The user code is crashing due to a combination of the Glue schema
> >>>>> definition and MySQL. An upgrade to MySQL 4.1.18 on the mon box
> >>>>> se.ulakbim.gov.tr will sort things out.
> >>>>>
> >>>>> Regards
> >>>>> Antony
> >>>>>
> >>>>>> -----Original Message-----
> >>>>>> From: LHC Computer Grid - Rollout
> >>>>>> [mailto:[log in to unmask]] On Behalf Of Javier
> >>>> Sanchez
> >>>>>> Sent: 22 May 2006 18:47
> >>>>>> To: [log in to unmask]
> >>>>>> Subject: [LCG-ROLLOUT] Too many connections in the MON BOX.
> >>>>>>
> >>>>>>
> >>>>>> Hello.
> >>>>>>
> >>>>>> In the MON box we have 82 connections to
> >>>>>> se.ulakbim.gov.tr:8088. Is this normal ?
> >>>>>>
> >>>>>> # netstat --inet | grep ESTA | grep se.ulakbim.gov.tr:8088 | wc
> >>>>>> 82 492 7298
> >>>>>>
> >>>>>> They belong to the tomcat process.
> >>>>>>
> >>>>>> Regards,
> >>>>>>
> >>>>>> Javier
> >>>>>>
> >>>>>> --
> >>>>>> --------------------------------------------------------------
> >>>>>> ---------
> >>>>>> | Javier Sanchez | Tel: (+34)
> >>>>>> 96.354.36.97 |
> >>>>>> | IFIC (Instituto de Fisica Corpuscular)| Fax: (+34)
> >>>>>> 96.354.37.42 |
> >>>>>> | CSIC-Universidad de Valencia |E-Mail:
> >>>>>> |
> >>>>>> | Edificio Institutos de Investigación |
> >>>>>> [log in to unmask] |
> >>>>>> | Apartado de Correos 22085 |WWW:
> >>>>>> |
> >>>>>> | E-46071 Valencia - SPAIN |
> >>>>>> http://ific.uv.es/~sanchezj |
> >>>>>>
> >>>>>>
> >>>> ----------------------------------------------------------------------
> >>>> ------- End of Original Message -------
> >>>>
> >>>>
|