Hi Bennis,
Off the top of my head, a few things come to mind:
1) your scheduler is in some loop
Do a top and see if fossology_scheduler is using lots of cpu time.
and/or
2) you need to do a vacuum analyze on your database
and/or
3) you are memory starved.
and/or
4) your postgresql statement timeout is set very low
In postgresql.conf the "statement_timeout" variable
and/or
5) your disk performance is poor (perhaps due to other processes)
Bob Gobeille
On May 22, 2009, at 9:37 AM, Laser, Mary wrote:
From: Abraham Bennis [mailto:[email protected]]
Sent: Thursday, May 21, 2009 12:32 PM
To: Laser, Mary
Subject: RE: Error while uploading
Thanks, I changed the permission as recommended. Now I could upload
the files. I am able to run a license analysis for small file but I
am getting another error now. Please see details below and let me
know how to proceed.
# ERROR: DBaccess(7): ERROR: canceling statement due to statement
timeout
ERROR: DBaccess timeout: 'SELECT DISTINCT(pfile_pk) as Akey,
pfile_sha1 || '.' || pfile_md5 || '.' || pfile_size AS A
FROM uploadtree,pfile
WHERE uploadtree.pfile_fk = pfile.pfile_pk
AND pfile_mimetypefk is NULL AND upload_fk = '38'
LIMIT 5000;'
WARNING: scheduler is running slow. It took 813 seconds to check
agent status: Thu May 21 09:13:39 2009
ERROR: DBaccess(7): ERROR: canceling statement due to statement
timeout
ERROR: DBaccess timeout: 'SELECT DISTINCT(pfile_pk) as Akey,
pfile_sha1 || '.' || pfile_md5 || '.' || pfile_size AS A
FROM uploadtree,pfile
WHERE uploadtree.pfile_fk = pfile.pfile_pk
AND pfile_mimetypefk is NULL AND upload_fk = '38'
LIMIT 5000;'
WARNING: scheduler is running slow. It took 599 seconds to check
agent status: Thu May 21 09:23:38 2009
ERROR: DBaccess(7): ERROR: canceling statement due to statement
timeout
ERROR: DBaccess timeout: 'SELECT DISTINCT(pfile_pk) as Akey,
pfile_sha1 || '.' || pfile_md5 || '.' || pfile_size AS A
FROM uploadtree,pfile
WHERE uploadtree.pfile_fk = pfile.pfile_pk
AND pfile_mimetypefk is NULL AND upload_fk = '38'
LIMIT 5000;'
ERROR: DBaccess(7): ERROR: syntax error at or near "." at character
323
Thanks,
Bennis
From: Laser, Mary [mailto:[email protected]]
Sent: Monday, May 18, 2009 11:04 PM
To: Abraham Bennis; [email protected]
Subject: RE: Error while uploading
Hi Bennis,
In an earlier email (attached) you mentioned you were using a multi-
system setup. Is this still the case? This is a VERY important
distinction. Please open the attached email, follow the
instructions therein and let me know your result.
Thanks,
Mary
From: Abraham Bennis [mailto:[email protected]]
Sent: Monday, May 18, 2009 10:38 AM
To: Laser, Mary; [email protected]
Subject: Error while uploading
I am not able to upload files for license analyzing. Please see the
error below. At the same time I am not seeing the folder called
"gold" "files". Please advice.
------------------------------------------------------------------------------
ERROR upload 12 Failed to import file into the repository
(RepImport=1). LOG upload 12 Failed to import /tmp/phpwnzvRE-
uploaded from /tmp/phpwnzvRE-uploaded into gold
8B9DEC2B11954542F0477B0753508DA1AE1D25CE.
2BD616FFA4D43BCE5CB9C8BCD294B6AB.247850297 The file has been
uploaded. It is upload #12.
# ls /tmp
ossology-configs.A14814 fossology-configs.sG2988 random.vintelaflush
fossology-configs.A14980 fossology-configs.T20759 updatecron.bak
fossology-configs.Ah7621 fossology-configs.tT7567 vmware-config0
fossology-configs.b17067 fossology-configs.v21272 vmware-config1
fossology-configs.c11086 fossology-configs.w22920 vmware-config2
fossology-configs.II2844 fossology-configs.y25373
fossology-configs.M17024 fossology-configs.Z16985
Thanks,
Bennis
<ATT00001.txt>
_______________________________________________
fossology mailing list
[email protected]
http://fossology.org/mailman/listinfo/fossology
