Hi again, New guy sees his FOSSology queues making little progress on the two test files (on 1.3.0 on Ubuntu Natty 11.4 64bit Amazon EC2), and sees a very long list of these in his logs...
2011-08-02 22:08:00 scheduler[1328] : ERROR: In thread 15: DBaccess(7): ERROR: more than one row returned by a subquery used as an expression 2011-08-02 22:08:00 scheduler[1328] : DEBUG[15]: ERROR: DBaccess(7): ERROR: more than one row returned by a subquery used as an expression 2011-08-02 22:08:00 scheduler[1328] : LOG: In thread 15: ERROR: SELECT pfile_sha1 || '.' || pfile_md5 || '.' || pfile_size AS pfilename FROM (SELECT pfile_fk,ufile_name FROM uploadtree WHERE upload_fk = (SELECT upload_fk FROM uploadtree WHERE pfile_fk = 13811) AND lft > (SELECT lft FROM uploadtree WHERE pfile_fk = 13811) AND rgt < (SELECT rgt FROM uploadtree WHERE pfile_fk = 13811) AND ufile_name = 'control') TEMP INNER JOIN pfile ON TEMP.pfile_fk = pfile_pk; 2011-08-02 22:08:00 scheduler[1328] : DEBUG[15]: LOG ERROR: SELECT pfile_sha1 || '.' || pfile_md5 || '.' || pfile_size AS pfilename FROM (SELECT pfile_fk,ufile_name FROM uploadtree WHERE upload_fk = (SELECT upload_fk FROM uploadtree WHERE pfile_fk = 13811) AND lft > (SELECT lft FROM uploadtree WHERE pfile_fk = 13811) AND rgt < (SELECT rgt FROM uploadtree WHERE pfile_fk = 13811) AND ufile_name = 'control') TEMP INNER JOIN pfile ON TEMP.pfile_fk = pfile_pk; (END) ...alternating with "pfile_fk = 14062", but not much on the web about it. Googling for "ERROR: more than one row returned by a subquery used as an expression" yielded many (somewhat obvious) postgres pages, but nothing re FOSSology. Likely due to trying to delete a prior Upload of the RedHat test file that threw a couple of FAILED agents. Deleting these Uploads and starting again is no big deal, I'm just familiarizing myself with FOSSology. Suggestions welcome! (I'm not afraid of the command line.) Thanks! Pete _______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
