Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5
On 06/20/2014 07:16 PM, Lists wrote: When I run this against the database I am trying to upgrade, I get: mysql select count(*) from Attributes; +--+ | count(*) | +--+ | 1831962 | +--+ 1 row in set (2.50 sec) mysql select count(*) from Attributes where Name = 'DeferredRecipients' and Content IS NULL; +--+ | count(*) | +--+ | 1829169 | +--+ 1 row in set (10.32 sec) What do these queries indicate? RT 3.8.1 contained a bug that caused it to create an excess of Attributes -- one for every transaction. Upgrading attempts to load these into memory. You can safely remove them before upgrading: DELETE FROM Attributes WHERE Name = 'DeferredRecipients' AND Content IS NULL; Your upgrade should then be able to complete. - Alex -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5
Thanks for the info Alex, I appreciate it and will give it a try. Dave On 6/23/2014 11:29 AM, Alex Vandiver wrote: On 06/20/2014 07:16 PM, Lists wrote: When I run this against the database I am trying to upgrade, I get: mysql select count(*) from Attributes; +--+ | count(*) | +--+ | 1831962 | +--+ 1 row in set (2.50 sec) mysql select count(*) from Attributes where Name = 'DeferredRecipients' and Content IS NULL; +--+ | count(*) | +--+ | 1829169 | +--+ 1 row in set (10.32 sec) What do these queries indicate? RT 3.8.1 contained a bug that caused it to create an excess of Attributes -- one for every transaction. Upgrading attempts to load these into memory. You can safely remove them before upgrading: DELETE FROM Attributes WHERE Name = 'DeferredRecipients' AND Content IS NULL; Your upgrade should then be able to complete. - Alex -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5
On 06/19/2014 03:24 PM, Lists wrote: [snip] Please keep all replies on-list. I will try the upgrade-database again. The script did not report any additional information other than it was killed. The precise error is important, as is the location in the upgrade process where it was reported. - Alex -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5
The make upgrade-database process runs for a short while and this is what I get from the command line. Proceed [y/N]:y Processing 3.8.2 Now inserting data. [25360] [Fri Jun 20 15:49:26 2014] [warning]: Going to add [OLD] prefix to all templates in approvals queue. If you have never used approvals, you can safely delete all the templates with the [OLD] prefix. Leave the new Approval templates because you may eventually want to start using approvals. (./etc/upgrade/3.8.2/content:6) make: *** [upgrade-database] Killed I am attempting to upgrade from 3.8.1 to 4.2.5. Is there additional logging/debug I can turn on or log files elsewhere I can check to see what is happening? Thanks, Dave On 6/20/2014 10:16 AM, Alex Vandiver wrote: On 06/19/2014 03:24 PM, Lists wrote: [snip] Please keep all replies on-list. I will try the upgrade-database again. The script did not report any additional information other than it was killed. The precise error is important, as is the location in the upgrade process where it was reported. - Alex -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5
On Fri, Jun 20, 2014 at 12:26:11PM -0500, Lists wrote: The make upgrade-database process runs for a short while and this is what I get from the command line. Proceed [y/N]:y Processing 3.8.2 Now inserting data. [25360] [Fri Jun 20 15:49:26 2014] [warning]: Going to add [OLD] prefix to all templates in approvals queue. If you have never used approvals, you can safely delete all the templates with the [OLD] prefix. Leave the new Approval templates because you may eventually want to start using approvals. (./etc/upgrade/3.8.2/content:6) make: *** [upgrade-database] Killed I am attempting to upgrade from 3.8.1 to 4.2.5. Is there additional logging/debug I can turn on or log files elsewhere I can check to see what is happening? Connect to your database and run; select count(*) from Attributes; select count(*) from Attributes where Name = 'DeferredRecipients' and Content IS NULL; -kevin pgpz_RAL_m9Jg.pgp Description: PGP signature -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5
On 6/20/2014 2:39 PM, Kevin Falcone wrote: On Fri, Jun 20, 2014 at 12:26:11PM -0500, Lists wrote: The make upgrade-database process runs for a short while and this is what I get from the command line. Proceed [y/N]:y Processing 3.8.2 Now inserting data. [25360] [Fri Jun 20 15:49:26 2014] [warning]: Going to add [OLD] prefix to all templates in approvals queue. If you have never used approvals, you can safely delete all the templates with the [OLD] prefix. Leave the new Approval templates because you may eventually want to start using approvals. (./etc/upgrade/3.8.2/content:6) make: *** [upgrade-database] Killed I am attempting to upgrade from 3.8.1 to 4.2.5. Is there additional logging/debug I can turn on or log files elsewhere I can check to see what is happening? Connect to your database and run; select count(*) from Attributes; select count(*) from Attributes where Name = 'DeferredRecipients' and Content IS NULL; -kevin When I run this against the database I am trying to upgrade, I get: mysql select count(*) from Attributes; +--+ | count(*) | +--+ | 1831962 | +--+ 1 row in set (2.50 sec) mysql select count(*) from Attributes where Name = 'DeferredRecipients' and Content IS NULL; +--+ | count(*) | +--+ | 1829169 | +--+ 1 row in set (10.32 sec) What do these queries indicate? Dave -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5
http://requesttracker.wikia.com/wiki/Shredder -- Later, Darin On Thu, Jun 19, 2014 at 12:56 PM, Lists li...@lolling.org wrote: Hi, As I have posted recently, I am working on upgrading our current production RT 3.8.1 to RT 4.2.5 I have a working copy of RT 3.8.1 on my test server including a copy of our current production database which is over 18 gig of old data. I have imported this database into RT 4 and when I run make upgrade-database against the RT4 database, it runs a while and then dies with a message that the script was killed. What I would like to be able to do before our real production upgrade is to wipeout everything from a given date back, including objects/attachments or anything associated with tickets older than 3 years. Our current production RT3 database, in all it's glory will be archived for posterity. I was not the original admin of our RT system, so I am still on the learning curve and not completely familiar with all of the database tables and how they are linked. Will RT:Shredder do this or do I need to use a custom mysql query to catch everything? Thanks, Dave -- RT Training - Boston, September 9-10 http://bestpractical.com/training -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5
On 06/19/2014 12:56 PM, Lists wrote: I have a working copy of RT 3.8.1 on my test server including a copy of our current production database which is over 18 gig of old data. I have imported this database into RT 4 and when I run make upgrade-database against the RT4 database, it runs a while and then dies with a message that the script was killed. It would be extremely helpful to see the output of the failed upgrade. What I would like to be able to do before our real production upgrade is to wipeout everything from a given date back, including objects/attachments or anything associated with tickets older than 3 years. Our current production RT3 database, in all it's glory will be archived for posterity. I was not the original admin of our RT system, so I am still on the learning curve and not completely familiar with all of the database tables and how they are linked. Will RT:Shredder do this or do I need to use a custom mysql query to catch everything? Shredder is the solution to removing data while preserving integrity, but I would strongly advise instead determining and addressing what your actual problem is. - Alex -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] Help with a query - I already know the ticket id #s
Hi, Can you post the query, as well as a sample of the non-meaningful results you get? mb From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of iWench Sent: Friday, November 13, 2009 12:20 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Help with a query - I already know the ticket id #s Hi Folks, I have done a ton of searching to see if I could find the answer to my question - no luck. I apologize in advance if I somehow missed the answer. I have a specific list of ticket id numbers (approx 200) that I need to query and get results on. I would like to grab the subject and the ticket status but do not need any other criteria beyond those items. I have tried using the Query Builder and Advanced query editing - I simply am unable to get any meaningful results using known multiple ticket id numbers. What am I doing wrong ? Thanks so much ! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Help with a query
we don't recommend using pure SQL within RT's DB to do any manipulations, even for reports we suggest API, but anyway you should ask more specific questions to get answer, for example how to select all watchers of a ticket with id X? or something like that. On 7/26/07, Christopher Moughan [EMAIL PROTECTED] wrote: Hey all, I apologize if this is the wrong forum for this, but is there anyone willing to share a query or two with me. I know absolutely nothing about MySQL queries. (I did how ever just order a book). I am looking for generic simple queries. Ticket ID, User, Subject, Time worked, Status. I have MySQL Query Builder can't seem to get the tables to join properly. My RT DB installation is default, no mods to tables or anything. ANY help is appreciated. Thanks Christopher Moughan System Administrator Brown Brown Lehigh Valley 268 Brodhead Road Bethlehem, PA 18017 Office 610-694-1814 Fax 610-974-9791 IMPORTANT: Insurance coverage can not be bound, amended or changed via voicemail, facsimile or Email message without confirmation from an authorized Brown Brown representative. NOTICE: The information contained in this electronic message is legally privileged and confidential and is intended for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copy of this message is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all electronic and printed copies of this message. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com