Hi Kazuo, This is good. You got the expected response. Unfortunately, I still don't see how someone could get this particular error.
Can you run a license scan on anything? Or does it only fail on this one (apache) file? Can you reproduce this by deleting the job and resubmitting it? Bob Gobeille On Mar 16, 2011, at 11:44 PM, ?? ?? wrote: > Hi Bob. > I sent following command by pgAdmin3 >> 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; > fossology database responded 881 records. > Column 'akey' contains 5digit numerical characters. > Column 'a' contains 75digit numerical and upper alphabet characters > separated by dot. > Column 'size' contains 3digit numerical characters. > Any errors was not reported. > > regards. > 2011/3/17 Bob Gobeille <bob.gobei...@hp.com> > Hi Kazuo, > This error confuses me since it says you are violating a unique key > constraint in a select. Normally you would only see an error like > this when you are trying to do an insert or update. > > I was hoping to reproduce the problem, but could not: > http://repo.fossology.org/?mod=nomoslicense&show=detail&upload=145&item=47977519 > > Do you know how to use psql or phppgadmin or pgadmin3 or some other > way to send the database a command? If so, could you run this command > and tell me what response you get? > >> 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; > > > Thanks, > Bob Gobeille > > > On Mar 16, 2011, at 12:57 AM, ?? ?? wrote: > >> 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. >> <ATT00001..txt> > _______________________________________________ > fossology mailing list > fossology@fossology.org > http://fossology.org/mailman/listinfo/fossology _______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
