On Nov 30, 2010, at 8:03 AM, Raino Lintulampi wrote: >> >> 1 item/sec is not normal for pkgagent. I just ran an RHEL DVD with 2.5 M >> files. >> Pkgagent ran to completion in 1 minute (found 4,110 packages). > > Is the number of items in "Job Queue: Package Scan" the > number of rpm packages? If so then there is something really wrong because > the actual number of rpm packages is less than 2,000 packages but the Package > Scan job queue shows over 200,000 items and still running (after the > weekend!).
Yes, it is the number of packages (rpms in your case). >> Did you look at the fossology, postgres and apache log files for clues? > > fossology.log does not show any errors or debug infor. No errors in > apache log files. > However, postgres.log has thousands of lines of logs like: > > EST STATEMENT: SELECT parent_fk,folder_name FROM foldercontents > INNER JOIN folder ON foldercontents.parent_fk = folder.folder_pk > AND foldercontents.foldercontents_mode = 1 > WHERE foldercontents.child_id = $1 LIMIT 1; > EST ERROR: prepared statement "DirGetNonArtifact_exported" already exists > EST STATEMENT: SELECT * FROM uploadtree LEFT JOIN pfile ON pfile_pk = > pfile_fk WHERE parent = $1; > EST ERROR: prepared statement "FolderGetFromUpload_1_exported" already exists > EST STATEMENT: SELECT parent_fk,folder_name FROM foldercontents > INNER JOIN folder ON foldercontents.parent_fk = folder.folder_pk > AND foldercontents.foldercontents_mode = 2 > WHERE foldercontents.child_id = $1 LIMIT 1; > EST ERROR: prepared statement "FolderGetFromUpload_2_exported" already exists > EST STATEMENT: SELECT parent_fk,folder_name FROM foldercontents > INNER JOIN folder ON foldercontents.parent_fk = folder.folder_pk > AND foldercontents.foldercontents_mode = 1 > WHERE foldercontents.child_id = $1 LIMIT 1; > EST ERROR: prepared statement "FolderGetFromUpload_1_exported" already exists These are unrelated, and benign except for clogging up the log file. > As I reported in a separate mail, some rpm packages are not unpacked > correctly by 1.2.1. > I'm reloading the distro in a test server where I have the latest > development version > of fossology in order to see if there is any differences between it and 1.2.1. This should be fixed now. Bob Gobeille _______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
