Hey guys and gal, I'm not sure if this is truly a problem but my collegue uploaded a rather large amount of data to be processed and it appears to have been uploaded and scheduled correctly, however it seems like the server has postgres pegged at around 100% for the majority of the time.
I was reading and searching your archives to see if I could find anyone else who had the same issue and only found this: "Error while uploading" on Fri, 22 May 2009 08:56:39 -0700 After looking at some of the areas Bob suggested this guy check I thought I should look into each of those too. >1) your scheduler is in some loop >Do a top and see if fossology_scheduler is using lots of cpu time. This doesn't apply other than it's the Postgres process that is at 100% >2) you need to do a vacuum analyze on your database It seems like the DB is doing a lot being at 100%, could I do this while its at 100%. It has 2 CPU's so (1)=100% and (2)= around 20% utilization. >3) you are memory starved. We seem to be okay on memory, this server currently has 4GB RAM. >4) your postgresql statement timeout is set very low >In postgresql.conf the "statement_timeout" variable Our statement_timeout is #'d commented out, #statement_timeout = 0 Should I change this? >5) your disk performance is poor (perhaps due to other processes) This doesn't seem to be an issue at the moment for us. In addition, the agents seem to spit off a small process like pkgmetagetta or licinspect every once in a while but ends really quick. I also look at the Scheduler / Status and it's updating and showing running on localhost and agents, but never seems to get to the filter_license or bsam_engine parts. Anyway, these questions weren't to me directly but was trying to look for help in your archive and thought I'd send you some info to go on to see if you had any suggestions or recommendation. Please let me know what I could check/do to correct this. I don't know much about DB optimization or administration on the database. -Regards, Gibran
_______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
