[daisy] Problems starting daisy repository

[Paul Focke]

On Thursday 08 February 2007 10:45, Andreas Deininger wrote:
> 2007/2/8, Paul Focke <paul at outerthought.org>:
> > Hi Andreas,
> >
> > I've seen that there are no default restrictions to the connection pool
> > used by activemq. Could you try adding the following properties to
> > the 'dataSource' bean found in the activemq-conf.xml to see if this helps
> > the TooManyConnections issue.
> > <property name="initialSize" value="5"/>
> >     <property name="maxActive" value="20"/>
> >     <property name="maxIdle" value="8"/>
> >     <property name="minIdle" value="0"/>
> >     <property name="maxWait" value="5000"/>
> > Basically these are the same properties used for the connection pool for
> > the repository.
> >
> > I hope you're able to reproduce your exception since I haven't been able
> > to recreate it locally.
>
> I looked through the log files of four Daisy 2.0 instances, and all of
> them have been producing that error. Not each day, but quite
> frequently. I've just added the properties you wrote and restarted all
> 4 repositories. In a few days, I'll come back to to and tell you
> whether it cured the problem. Well, to me it looks like that this
> doesn't really cure the problem, it just prevents errors on the MySQL
> side, doesn't it?
>

Well it was meant to help deal with the TooManyConnections exception. About 
the ArrayIndexOutOfRange exception which started the whole discussion I can't 
really say much. I've had a poke about the mysql bugs and seems like they had 
issues with this for connectors < 3.0.9  Could you give us some insight into 
which connector/j and mysql server versions you are using?

Paul