Re: [FOSSology] Job fails at license (fossology 1.3.0)
Hi Kazuo, Thanks for letting me know that it worked. Don't blame yourself. In the next version (1.4) that option for the deprecated license scan won't even be there. Bob Gobeille On Mar 23, 2011, at 7:42 AM, ?? ?? wrote: Hi Bob I uploaded file with options you told, Copyright/Email/URL Analysis MIME-type Analysis (Determine mimetype of every file. Not needed for licenses or buckets) Nomos License Analysis Package Analysis (Parse package headers) I could complete license scan successfully. Thank you for your support and I apologize for my fault. Kazuo. 2011/3/21 Gobeille, Robert bob.gobei...@hp.com Hi Kazuo, I should have spotted this from your first email. You are running the wrong license scanner. What you are doing should work, but it has been replaced by a faster, more accurate scanner. When you upload a file you are given the options: Bucket Analysis Copyright/Email/URL Analysis MIME-type Analysis (Determine mimetype of every file. Not needed for licenses or buckets) Nomos License Analysis Package Analysis (Parse package headers) Spec File Analysis (deprecated. Replaced by Package analysis.) bSAM License Analysis (deprecated) It looks like you are choosing bSAM. Use Nomos License Analysis instead. In v 1.4 that bSAM option has been removed. Bob On Mar 20, 2011, at 5:57 AM, ?? ?? wrote: I can't run license with any file. ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
Re: [FOSSology] Job fails at license (fossology 1.3.0)
Hi Bob. I can't run license with any file. I deleted all Folders and created new folder and upload to it. But license scan still error. Error messages are... /var/log/fossology.log 2011-03-10 11:03:50 scheduler[2685] : Child[12] 'agent=delagent host=localhost ' state=SPAWNED(4) @ Thu Mar 10 11:03:50 2011 2011-03-10 11:03:50 scheduler[2685] : Child[12] 'agent=delagent host=localhost ' state=READY(5) @ Thu Mar 10 11:03:50 2011 2011-03-10 11:06:02 scheduler[2685] : Child[12] 'agent=delagent host=localhost ' state=FREEING(2) @ Thu Mar 10 11:06:02 2011 2011-03-10 11:06:02 scheduler[2685] : Child[12] 'agent=delagent host=localhost ' state=FREE(1) @ Thu Mar 10 11:06:02 2011 2011-03-10 11:06:02 scheduler[2685] : Child[1] 'agent=unpack host=localhost ' state=SPAWNED(4) @ Thu Mar 10 11:06:02 2011 2011-03-10 11:06:02 scheduler[2685] : Child[1] 'agent=unpack host=localhost ' state=READY(5) @ Thu Mar 10 11:06:02 2011 2011-03-10 11:06:49 scheduler[2685] : Child[1] 'agent=unpack host=localhost ' state=FREEING(2) @ Thu Mar 10 11:06:49 2011 2011-03-10 11:06:49 scheduler[2685] : Child[1] 'agent=unpack host=localhost ' state=FREE(1) @ Thu Mar 10 11:06:49 2011 2011-03-10 11:06:51 scheduler[2685] : Child[2] 'agent=adj2nest host=localhost ' state=SPAWNED(4) @ Thu Mar 10 11:06:51 2011 2011-03-10 11:06:51 scheduler[2685] : Child[2] 'agent=adj2nest host=localhost ' state=READY(5) @ Thu Mar 10 11:06:51 2011 2011-03-10 11:07:22 scheduler[2685] : Child[2] 'agent=adj2nest host=localhost ' state=FREEING(2) @ Thu Mar 10 11:07:22 2011 2011-03-10 11:07:22 scheduler[2685] : Child[9] 'agent=mimetype host=localhost ' state=SPAWNED(4) @ Thu Mar 10 11:07:22 2011 2011-03-10 11:07:22 scheduler[2685] : Child[2] 'agent=adj2nest host=localhost ' state=FREE(1) @ Thu Mar 10 11:07:22 2011 2011-03-10 11:07:22 scheduler[2685] : Child[9] 'agent=mimetype host=localhost ' state=READY(5) @ Thu Mar 10 11:07:22 2011 2011-03-10 11:08:32 scheduler[2685] : Child[9] 'agent=mimetype host=localhost ' state=FREEING(2) @ Thu Mar 10 11:08:32 2011 2011-03-10 11:08:32 scheduler[2685] : Child[5] 'agent=nomos host=localhost ' state=SPAWNED(4) @ Thu Mar 10 11:08:32 2011 2011-03-10 11:08:32 scheduler[2685] : Child[5] 'agent=nomos host=localhost ' state=READY(5) @ Thu Mar 10 11:08:32 2011 2011-03-10 11:08:32 scheduler[2685] : Child[9] 'agent=mimetype host=localhost ' state=FREE(1) @ Thu Mar 10 11:08:32 2011 2011-03-10 11:10:12 scheduler[2685] : Child[5] 'agent=nomos host=localhost ' state=FREEING(2) @ Thu Mar 10 11:10:12 2011 2011-03-10 11:10:12 scheduler[2685] : Child[13] 'agent=sqlagent host=localhost ' state=SPAWNED(4) @ Thu Mar 10 11:10:12 2011 2011-03-10 11:10:12 scheduler[2685] : Child[5] 'agent=nomos host=localhost ' state=FREE(1) @ Thu Mar 10 11:10:12 2011 2011-03-10 11:10:12 scheduler[2685] : Child[13] 'agent=sqlagent host=localhost ' state=READY(5) @ Thu Mar 10 11:10:12 2011 2011-03-10 11:10:33 scheduler[2685] : Child[13] 'agent=sqlagent host=localhost ' state=FREEING(2) @ Thu Mar 10 11:10:33 2011 2011-03-10 11:10:33 scheduler[2685] : Child[13] 'agent=sqlagent host=localhost ' state=FREE(1) @ Thu Mar 10 11:10:33 2011 2011-03-10 11:10:33 scheduler[2685] : Child[3] 'agent=filter_license host=localhost ' state=SPAWNED(4) @ Thu Mar 10 11:10:33 2011 2011-03-10 11:10:33 scheduler[2685] : Child[3] 'agent=filter_license host=localhost ' state=READY(5) @ Thu Mar 10 11:10:33 2011 2011-03-10 11:15:49 scheduler[2685] : Child[3] 'agent=filter_license host=localhost ' state=FREEING(2) @ Thu Mar 10 11:15:49 2011 2011-03-10 11:15:51 scheduler[2685] : Child[3] 'agent=filter_license host=localhost ' state=FREE(1) @ Thu Mar 10 11:15:51 2011 2011-03-10 11:15:51 scheduler[2685] : Child[7] 'agent=copyright host=localhost ' state=SPAWNED(4) @ Thu Mar 10 11:15:51 2011 2011-03-10 11:16:06 scheduler[2685] : Child[7] 'agent=copyright host=localhost ' state=READY(5) @ Thu Mar 10 11:16:06 2011 2011-03-10 11:16:46 scheduler[2685] : Child[7] 'agent=copyright host=localhost ' state=FREEING(2) @ Thu Mar 10 11:16:46 2011 2011-03-10 11:16:46 scheduler[2685] : Child[7] 'agent=copyright host=localhost ' state=FREE(1) @ Thu Mar 10 11:16:46 2011 2011-03-10 11:16:48 scheduler[2685] : Child[17] 'agent=fo_notify host=localhost ' state=SPAWNED(4) @ Thu Mar 10 11:16:48 2011 2011-03-10 11:16:48 scheduler[2685] : Child[17] 'agent=fo_notify host=localhost ' state=READY(5) @ Thu Mar 10 11:16:48 2011 2011-03-10 11:16:49 scheduler[2685] : DEBUG[17]: Mail has been queued by fo-notify /var/log/fossology.log Show Job Queue : license Field Value jq_pk 123 jq_job_fk 70 job_name license jq_type license job_priority 0 jq_args SELECT DISTINCT(Akey),A,Size FROM license_9 INNER 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; jq_runonpfile a jq_starttime jq_endtime jq_end_bits 0 jq_endtext jq_elapsedtime 00:00:00 jq_processedtime
Re: [FOSSology] Job fails at license (fossology 1.3.0)
Hi Kazuo, I should have spotted this from your first email. You are running the wrong license scanner. What you are doing should work, but it has been replaced by a faster, more accurate scanner. When you upload a file you are given the options: Bucket Analysis Copyright/Email/URL Analysis MIME-type Analysis (Determine mimetype of every file. Not needed for licenses or buckets) Nomos License Analysis Package Analysis (Parse package headers) Spec File Analysis (deprecated. Replaced by Package analysis.) bSAM License Analysis (deprecated) It looks like you are choosing bSAM. Use Nomos License Analysis instead. In v 1.4 that bSAM option has been removed. Bob On Mar 20, 2011, at 5:57 AM, ?? ?? wrote: I can't run license with any file. ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
Re: [FOSSology] Job fails at license (fossology 1.3.0)
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=nomoslicenseshow=detailupload=145item=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 (129)) = 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 (129)) = 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. ATT1..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
[FOSSology] Job fails at license (fossology 1.3.0)
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 (129)) = 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 (129)) = 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
Re: [FOSSology] Job fails at license (fossology 1.3.0)
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=nomoslicenseshow=detailupload=145item=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 (129)) = 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 (129)) = 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. ATT1..txt ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
Re: [FOSSology] Job fails at license (fossology 1.3.0)
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=nomoslicenseshow=detailupload=145item=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 (129)) = 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 (129)) = 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. ATT1..txt ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology