Welcome to Sawmill.Net
 
 

Sawmill Discussion Forum

Subject: "Sawmillcl.exe - Aplication Error"     Previous Topic | Next Topic
Printer-friendly copy     Email this topic to a friend    
Conferences Support Topic #2873
Reading Topic #2873
Radiohead
Member since Feb-25-06
Feb-25-06, 08:00 PM (PST)
Click to EMail Radiohead Click to send private message to Radiohead Click to view user profileClick to add this user to your buddy list  
"Sawmillcl.exe - Aplication Error"
 
   Hi outhere, i've been trying Sawmill 7.2.1 with 3.00 GHz, 512 MB RAM and Windows XP SP2 to process the log from my Mail Servers running Qmail. I have 2 GB of Logs on Tai64 format correspondig to the last Three Month. When I try to proccess the Whole thing in a single Time, from the GUI I found an Sawmill.exe-Aplication Error on my Box that seem to be related with an Insuficient amount of Memory installed on the Machine. I'm also using the internal Database.
Then i tried to start with a little part of the Logs and then adding new Log Sources, each one aproximately of 4 logs of 5 MB , when i start repeating this process, by the 5th time the same error appear on the my screen.
Then I tried modifiying the sizes on the Database Tunnig field of the current Profile and i reached a little bit more of success, but when i repeated the proccess of adding new Log Sources it reappear.
Certainly the error does not seems to be critical , because if i ignore it , after a series of time refreshing my Firefox it come into a successful Database Update.

Can anybody help me ....?
Exist any way to know which are the correct parameter for my Database Tuning Field?
Can i solve this problem updating my Database from the command line or Using MySQL instead of the Internal Database?
Should I use W2k o W2k3 Instead of XP ?
Thanks in Advance...



  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
ferraradmin
Member since Sep-5-01
2972 posts
Feb-27-06, 04:20 PM (PST)
Click to EMail ferrar Click to send private message to ferrar Click to view user profileClick to add this user to your buddy list  
1. "RE: Sawmillcl.exe - Aplication Error"
In response to message #0
 
It looks like one or more of your database fields is too complex to fit in the RAM you have available. See:

http://www.sawmill.net/cgi-bin/sawmill7/docs/sawmill.cgi?dp+docs.faq.entry+webvars.entry+dbmemory

for a discussion of database memory usage (this is probably due to a large "itemnums" table).

Building it in pieces won't help; the final itemnums table will be just as large whether you build all at once, or in pieces, and the itemnums table is the problem. In almost all cases, it's best to build a database all at once.

Using a MySQL database will fix it, because it uses normal disk files instead of memory-mapped files for the itemnums table.

A command-line build might help, but only if it's *not* the itemnums table. If there's an error related to the GUI (we fixed one last week like this), then a command-line build might succeed where a GUI build fails. It's definitely worth a try.

There probably won't be any difference between using different versions of Windows.

-
Greg Ferrar, Sawmill Product Manager
support@sawmill.net


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
Radiohead
unregistered user
Feb-28-06, 10:53 AM (PST)
 
2. "RE: Sawmillcl.exe - Aplication Error"
In response to message #1
 
   Greg:

You were Rigth, the whole thing can be solved installing MySQL. Rigth now it have an incredible performance when Updating or Buiding the Database, even when the log sources are reaching the 2GB.
Thanks a lot man. !!!


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top

Conferences | Topics | Previous Topic | Next Topic

Home    Overview    Features    Samples    Testimonials     FAQ    Downloads    Ordering    Manual    Support

 

Copyright © 2005 by Flowerfire Privacy Policy