Tomcat is using about 98mb memory, mysql is about 500mb. Tomcat completely freezes up - can't do anything other than restart the service.
It's freezing when it's adding new documents (we add using solrSharp). Once the documents are added, we do a comit through solrsharp. It's timing out well before getting to the commit. As it's a public search people will still be hitting the search whilst this is going on, but it's not massive search traffic. A few thousand requests spread over a full day. I can't find anything logged anywhere as a reason - do I need to turn on specific logging anywhere? I might just bite the bullet and shift them onto different boxes -------------------------------------------------------- Simon Collins Systems Analyst Telephone: 01904 606 867 Fax Number: 01904 528 791 shoe-shop.com ltd Catherine House Northminster Business Park Upper Poppleton, YORK YO26 6QU www.shoe-shop.com -------------------------------------------------------- This message (and any associated files) is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this message, or any attachment, that have arisen as a result of e-mail transmission. If verification is required, please request a hard-copy version. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. (PAVD001) Shoe-shop.com Limited is a company registered in England and Wales with company number 03817232. Vat Registration GB 734 256 241. Registered Office Catherine House, Northminster Business Park, Upper Poppleton, YORK, YO26 6QU. -----Original Message----- From: Grant Ingersoll [mailto:[EMAIL PROTECTED] Sent: 24 October 2008 21:05 To: solr-user@lucene.apache.org Subject: Re: timeouts What is happening at the time of the freeze? Are you indexing? Searching? For either of these options, what are the operations that are happening? Is Tomcat and the Solr admin accessible while this happens? Are there any exceptions in the logs? How much memory are you giving it versus MySQL? I assume you're hitting both, right? Do you have enough memory to do that? Typically DBs like as much mem as they can get, as does Solr (for the most part). That being said, 100K records is next to nothing, so I doubt Solr is taking that much memory. Please describe a bit more what you are doing and seeing. On Oct 24, 2008, at 8:58 AM, Simon Collins wrote: > Hi > > We're running solr on a win 2k3 box under tomcat with about 100,000 > records. When doing large updates of records via solr sharp, solr > completely freezes and doesn't come back until we restart tomcat. > > This has only started happening since putting mysql on the same box > (as a source of the data to update from). > > Are there any known issues with running solr and mysql on the same > box? When it's frozen, the cpu usage is around 1-2% not exactly out > of resources! > > Am i best using something else instead of tomcat? We're still > trialling solr (presently, used for our main site search www.shoe-shop.com > and search and navigation for our microsites ). It's an excellent > search product, but I don't want to fork out on new hardware for it > just yet - until i know how more about the performance and which > environment i'm best to go for (win/linux). > > If anyone has any suggestions/needs more info, i'd be extremely > grateful. > > Thanks > Simon > Simon Collins > Systems Analyst > > Telephone: 01904 606 867 > Fax Number: 01904 528 791 > > shoe-shop.com ltd > Catherine House > Northminster Business Park > Upper Poppleton, YORK > YO26 6QU > > www.shoe-shop.com > > > This message (and any associated files) is intended only for the use > of the individual or entity to which it is addressed and may contain > information that is confidential, subject to copyright or > constitutes a trade secret. If you are not the intended recipient > you are hereby notified that any dissemination, copying or > distribution of this message, or files associated with this message, > is strictly prohibited. If you have received this message in error, > please notify us immediately by replying to the message and deleting > it from your computer. Messages sent to and from us may be monitored. > > Internet communications cannot be guaranteed to be secure or error- > free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. Therefore, > we do not accept responsibility for any errors or omissions that are > present in this message, or any attachment, that have arisen as a > result of e-mail transmission. If verification is required, please > request a hard-copy version. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > the company. (PAVD001) > > Shoe-shop.com Limited is a company registered in England and Wales > with company number 03817232. Vat Registration GB 734 256 241. > Registered Office Catherine House, Northminster Business Park, Upper > Poppleton, YORK, YO26 6QU. > > > > > > > > > > > > > This message has been scanned for malware by SurfControl plc. www.surfcontrol.com > -------------------------- Grant Ingersoll Lucene Boot Camp Training Nov. 3-4, 2008, ApacheCon US New Orleans. http://www.lucenebootcamp.com Lucene Helpful Hints: http://wiki.apache.org/lucene-java/BasicsOfPerformance http://wiki.apache.org/lucene-java/LuceneFAQ
