Re: [FOSSology] Clean Out Repository
Thanks for the response Bob. I'm sorry Bob; I don't understand how to use the delete agent. When I list the available default agents as fossy or root ... fossrepo]$ fossjobs -a The available agents are: agent_bucket agent_copyright agent_mimetype agent_nomos agent_pkgagent agent_unpack agent_specagent agent_license PHP Notice: Undefined index: U in /usr/bin/fossjobs on line 167 Is this list complete? Thanks, Ray W. -Original Message- From: Bob Gobeille [mailto:bob.gobei...@hp.com] Sent: Tuesday, June 14, 2011 12:27 PM To: Westphal, Raymond W Cc: fossology@fossology.org Subject: Re: [FOSSology] Clean Out Repository Hi Ray, To find the uploads over a year old: select upload_pk from upload where upload_ts (now() - interval '1 year') order by upload_ts You can then take that list and schedule the delete agent on each one of the upload_pk's with the fossjobs command (man fossjobs). Unfortunately, you can't simply delete the upload from the database because that won't delete the files from the repository, and because cascade isn't turned on for most of the foreign keys. So, at least for now, you have to use the delete agent. Bob Gobeille On Jun 14, 2011, at 6:29 AM, Westphal, Raymond W wrote: Hello Everyone. I'm trying to find a way to automatically cleanup the repository. The users will allow me to delete uploads older than 1 year. I created the following query from watching the database while I selected the Organize/Uploads/Delete Uploaded File menu option. SELECT upload_pk, upload_desc, upload_ts, ufile_name FROM foldercontents,uploadtree,upload WHERE foldercontents.parent_fk = '4' AND upload_ts (select current_date -365) AND foldercontents.foldercontents_mode = 2 AND foldercontents.child_id = upload.upload_pk AND uploadtree.upload_fk = upload.upload_pk AND uploadtree.parent IS NULL; ORDER BY upload_ts; Can I simply delete from the upload table where upload_ts (select current_date -365) ? Thanks, Ray W. CONFIDENTIALITY NOTICE: This e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and privileged information protected by law. If you received this e-mail in error, any review, use, dissemination, distribution, or copying of the e-mail is strictly prohibited. Please notify the sender immediately by return e-mail and delete all copies from your system. ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
Re: [FOSSology] Clean Out Repository
Hi Ray, It looks like you found an error in fossjobs, so I filed a bug on your behalf: http://bugs.linux-foundation.org/show_bug.cgi?id=819 You can run delagent without the scheduler from the command line: 0) Find all your upload_pk's to delete (from previous emails) 1) Find out where your agents are installed. In the user interface login as an administrator and click on Help Debug Global Variables The variable AGENTDIR shows you the agent install location. For illustration, let's say AGENTDIR is /usr/lib/fossology/agents. 2) Run delagent from the command line. For example: /usr/lib/fossology/agents/delagent -U 1234 Where 1234 is your upload_pk. You can put that in a script to delete all the uploads. Don't run delagent in parallel or with other agents running in the scheduler. Because of the file sharing that fossology does, you could run into concurrency problems if you do that. If you want to see all the delagent options, then run delagent --help Bob Gobeille On Jun 15, 2011, at 8:28 AM, Westphal, Raymond W wrote: Thanks for the response Bob. I'm sorry Bob; I don't understand how to use the delete agent. When I list the available default agents as fossy or root ... fossrepo]$ fossjobs -a The available agents are: agent_bucket agent_copyright agent_mimetype agent_nomos agent_pkgagent agent_unpack agent_specagent agent_license PHP Notice: Undefined index: U in /usr/bin/fossjobs on line 167 Is this list complete? Thanks, Ray W. -Original Message- From: Bob Gobeille [mailto:bob.gobei...@hp.com] Sent: Tuesday, June 14, 2011 12:27 PM To: Westphal, Raymond W Cc: fossology@fossology.org Subject: Re: [FOSSology] Clean Out Repository Hi Ray, To find the uploads over a year old: select upload_pk from upload where upload_ts (now() - interval '1 year') order by upload_ts You can then take that list and schedule the delete agent on each one of the upload_pk's with the fossjobs command (man fossjobs). Unfortunately, you can't simply delete the upload from the database because that won't delete the files from the repository, and because cascade isn't turned on for most of the foreign keys. So, at least for now, you have to use the delete agent. Bob Gobeille On Jun 14, 2011, at 6:29 AM, Westphal, Raymond W wrote: Hello Everyone. I'm trying to find a way to automatically cleanup the repository. The users will allow me to delete uploads older than 1 year. I created the following query from watching the database while I selected the Organize/Uploads/Delete Uploaded File menu option. SELECT upload_pk, upload_desc, upload_ts, ufile_name FROM foldercontents,uploadtree,upload WHERE foldercontents.parent_fk = '4' AND upload_ts (select current_date -365) AND foldercontents.foldercontents_mode = 2 AND foldercontents.child_id = upload.upload_pk AND uploadtree.upload_fk = upload.upload_pk AND uploadtree.parent IS NULL; ORDER BY upload_ts; Can I simply delete from the upload table where upload_ts (select current_date -365) ? Thanks, Ray W. CONFIDENTIALITY NOTICE: This e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and privileged information protected by law. If you received this e-mail in error, any review, use, dissemination, distribution, or copying of the e-mail is strictly prohibited. Please notify the sender immediately by return e-mail and delete all copies from your system. ___ 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 mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
Re: [FOSSology] Clean Out Repository
Hi Ray, To find the uploads over a year old: select upload_pk from upload where upload_ts (now() - interval '1 year') order by upload_ts You can then take that list and schedule the delete agent on each one of the upload_pk's with the fossjobs command (man fossjobs). Unfortunately, you can't simply delete the upload from the database because that won't delete the files from the repository, and because cascade isn't turned on for most of the foreign keys. So, at least for now, you have to use the delete agent. Bob Gobeille On Jun 14, 2011, at 6:29 AM, Westphal, Raymond W wrote: Hello Everyone. I'm trying to find a way to automatically cleanup the repository. The users will allow me to delete uploads older than 1 year. I created the following query from watching the database while I selected the Organize/Uploads/Delete Uploaded File menu option. SELECT upload_pk, upload_desc, upload_ts, ufile_name FROM foldercontents,uploadtree,upload WHERE foldercontents.parent_fk = '4' AND upload_ts (select current_date -365) AND foldercontents.foldercontents_mode = 2 AND foldercontents.child_id = upload.upload_pk AND uploadtree.upload_fk = upload.upload_pk AND uploadtree.parent IS NULL; ORDER BY upload_ts; Can I simply delete from the upload table where upload_ts (select current_date -365) ? Thanks, Ray W. CONFIDENTIALITY NOTICE: This e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and privileged information protected by law. If you received this e-mail in error, any review, use, dissemination, distribution, or copying of the e-mail is strictly prohibited. Please notify the sender immediately by return e-mail and delete all copies from your system. ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology