[daisy] Problems starting daisy repository

[Andreas Deininger]

2007/1/30, Bruno Dumon <bruno at outerthought.org>:
> On Tue, 2007-01-30 at 15:10 +0100, Andreas Deininger wrote:
> > Hi,
> >
> > I cannot start the repository of one of daisy instances any more. (see
> > stacktrace from the logfile below). I checked my ActiveMQ database for
> > that repository and the table ACTIVEMQ_MSGS contains more than 500.00
> > records, the column CONTAINER is always: queue://fullTextIndexerJobs
> >
> > Any advice what to do now? Can I safely delete these records?
>
> What is "500.00"? 5 hundred? 50 thousand?

Sorry, typo: more than 500.000 (500 thousand).
Actually, that was an approximation provided by phpMyAdmin, it turned out to be:
496 records where the column CONTAINER was queue://fullTextIndexerJobs
71605 records where this column had the value topic://daisy.

> I have the impression there's something wrong the acknowledging of the
> JMS messages. We'll need to have a closer look at this.

The weird thing is that this instance ran without problems for months already.

> In the meantime, I think it is ok to delete them, though I'd first check
> what the largest ID is in the ACTIVEMQ_MSGS table and update the
> ACTIVMEQ_ACKS table accordingly (not sure if this is needed, just
> guessing, you could always look for more info on the active MQ site).

I deleted the records and started the repository again. The repository
now is up again, however, it looks like the database table is filling
up rapidly again, there are already 52 rows in that table, and the
number is increasing constantly.

Is there anything I can try to do in order to clarify what's going on here?

Thanks in advance.

--
Andreas