Hello. I'm Kazuo Tsunemine.
It might be reported similar problem posted by Mr.Bob Grobeile already. When I have tried to scan 'apache_1.3.41.tar.gz2', fossology failed running license job with following message in /var/log/fossology. DEBUG[13]: ERROR:DBaccess(7) ERROR: DEBUG[13]: license_7 WARNING: In thread 13: SQL had duplicate constraint in sqlagent: 'SELECT DISTINCT(pfile_pk) as Akey, pfile_sha1 || '.' || pfile_md5 || '.' || pfile_size as A, pfile_size As Size INTO license_7 FROM uploadtree,pfile WHERE upload_fk = '7' AND pfile_fk IS NOT NULL AND (ufile_mode & (1<<29)) = 0 AND pfilefk = pfile_pk ORDER BY Size DESC;' DEBUG[13]: WARNING: SQL had duplicate constraint in sqlagent: 'SELECT DISTINCT(pfile_pk) as Akey, pfile_sha1 || '.' || pfile_md5 || '.' || pfile_size as A, pfile_size As Size INTO license_7 FROM uploadtree,pfile WHERE upload_fk = '7' AND pfile_fk IS NOT NULL AND (ufile_mode & (1<<29)) = 0 AND pfilefk = pfile_pk ORDER BY Size DESC;' And Job Queue jq_args is following message. SELECT DISTINCT(Akey), A,Size FROM license_7 INNNER JOIN agent_lic_status ON agent_lic_status.pfile_fk = Akey WHERE agent_lic_status.inrepository IS TRUE AND agent_lic_status.processed IS NOT TRUE ORDER BY Size DESC LIMIT 5000; And Job Queue jq_endtext is following message. Failed: Failed: Agent terminated prematurely I have installed fossology1.3.0(RPM) to CentOS5. I'm sorry by poor English. Kazuo.
_______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
