[rt-users] Merged tickets missing from search
Hey all, We're running rt3.8.6, under FreeBSD, installed from ports. All modifications done via rt_siteconfig.pm (and there are not many). The problem I'm seeing is this: we have a ticket which is not showing in the list of unowned tickets. A second ticket has been merged into it which was also unowned, and I suspect that's related but I'm not sure why or how, and I'm not able to duplicate it by merging two other tickets. In fact, when I search the queue and say show all tickets, of any status, that ticket still does not show in the list. It doesn't show when I browse the list. Is there some DB-consistency check I can run? This ticket has gone "phantom" on us, and it's making our support folks wonder where else it could happen. -Dan -- RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!
Re: [rt-users] Merged tickets are sloooow after upgrade to 3.6.6 - Locking problem?
Hello everyone, I solved this problem by setting the mySQL setting low_priority_updates to 1 . You kmight want to try this option if your installation is slow in displaying merged tickets. Best regards, On Di, Jul 01, 2008 at 03:30:00 +0200, Franz Georg Köhler <[EMAIL PROTECTED]> wrote: > Hello everyone, > > after upgrading to V3.6.6 merged tickets are really slow. > > After doing a bit research, I saw a lot of MySQL entrys stating that > get_lock queries took a long time: > > # Query_time: 69 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 > use rtdb; > SELECT GET_LOCK('Apache-Session-1b11b6323211dc42ec9d40473784e254', > 3600); > > I first converted the table to innodb and then changed the session > backend to Apache::Session::File. Now the mysql log entries are gone > but the ticket system is not faster than before... > > However, this does only affect merged tickets. > > It seems that rt locks and tries to access the locked data in some way > > > because it used to be two tickets? > > > Has anyone else experienced this behaviour and dound a solution? > > > > Best regards, > > > > ___ > 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 > -- Warning: You are not root -- nmap V. 2.54BETA31 ___ 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
[rt-users] Merged tickets are sloooow after upgrade to 3.6.6 - Locking problem?
Hello everyone, after upgrading to V3.6.6 merged tickets are really slow. After doing a bit research, I saw a lot of MySQL entrys stating that get_lock queries took a long time: # Query_time: 69 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 use rtdb; SELECT GET_LOCK('Apache-Session-1b11b6323211dc42ec9d40473784e254', 3600); I first converted the table to innodb and then changed the session backend to Apache::Session::File. Now the mysql log entries are gone but the ticket system is not faster than before... However, this does only affect merged tickets. It seems that rt locks and tries to access the locked data in some way because it used to be two tickets? Has anyone else experienced this behaviour and dound a solution? Best regards, ___ 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
[rt-users] Merged tickets slow or unable to load in browser
Yesterday, after merging two tickets, I attempted to click on the ticket link in the queue to open the newly merged ticket to read. After a bit of a wait, the browser displays an Internal Server Error message. This morning, I find out that another user had this problem two or three weeks ago with some tickets he merged. I created four new tickets for testing. I merged the four tickets into two separate tickets (I did them in different queues to see if that made any difference). When I clicked on the ticket in the list, it took more than 20 seconds but the newly-formed tickets displayed. I then merged the two tickets into one ticket. After that merge, I receive the ISE when I try to click on the ticket. I've looked in the mailing list archives and saw a few others with this question in the past 7 or so months, but most didn't receive a reply. I did find one where someone someone had luck by vacuuming the postgres db. I tried that with no change in results. I'm using RT 3.6.6 on Ubuntu 8.04 Hardy Heron with apache-2.2.8, fastcgi, perl 5.10. Suggestions or is there any additional info that I need to dig up to help you help me? Thanks, Cory ___ 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
[rt-users] merged tickets hanging browser for a long time
Hi, A user reported that one of their tickets was hanging their browser, and sure enough when I tried, it took a very long time to load, and when it did it was rendered badly. I checked the logs and the following was repeated many 100s of times; [Thu Mar 6 11:23:29 2008] [debug]: We found a merged ticket.557/567 (/opt/rt3/lib/RT/Ticket_Overlay.pm:273) [Thu Mar 6 11:23:31 2008] [debug]: We found a merged ticket.557/567 (/opt/rt3/lib/RT/Ticket_Overlay.pm:273) [Thu Mar 6 11:23:59 2008] [debug]: We found a merged ticket.568/567 (/opt/rt3/lib/RT/Ticket_Overlay.pm:273) [Thu Mar 6 11:24:00 2008] [debug]: We found a merged ticket.568/567 (/opt/rt3/lib/RT/Ticket_Overlay.pm:273) Any ideas how I can unjam that ticket? Thanks, Tom ___ 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
[rt-users] Merged tickets 'disappearing'?
Hi Folks, We run RT 3.6.4 currently, and have noticed that if you run a report for tickets in queue X with start dates between Y and Z, then tickets that have been merged (but where both have a start date in the appropriate timespan) don't show up on the report. This is obviously a little irritating for the poor person that compiles performance reports out of RT tickets (happily, this isn't me!). Searching through the list archive I can see some discussion from earlier this year about similar issues with search and merged tickets. However, the Changelog that comes with RT 3.6.5 is near-enough useless unless you have intimate knowledge of the RT development process - is this merging issue resolved in 3.6.5? Is there a more user-friendly changelog? We have just enough local modifications to make me wary of just trying the upgrade, since it'll be a day or so's time to get things back to how they were after the upgrade... thanks in advance for any illumination, Howie ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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
RE: [rt-users] Merged tickets very slow
Vacuuming the database doesn't and wouldn't sort this out. Its not an issue of slow database access, its that its running the 'merged ticket code' more then 6000 times. The ticket has 12 merges and over 100 replies. _ From: Chris Nelson [mailto:[EMAIL PROTECTED] Sent: 28 November 2007 03:07 To: Daniel Jennings Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Merged tickets very slow We had this issue before. Are you using PostGres as your database? We found that once we vacuumed the database, it resolved the issue. Daniel Jennings wrote: The issue isn't really the output, its the 30 to 40 seconds it takes to load the ticket. I guess though it maybe nice not to see it fill up the log all the itme. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boris Lytochkin Sent: 24 November 2007 09:05 To: [EMAIL PROTECTED] Subject: Re: [rt-users] Merged tickets very slow I have seen them a lot too, even created small patch to mute them away: grep -i merged /rt/etc/RT_SiteConfig.pm Set($MuteWeFoundMergedTicket, "1"); Hi, We have an issue with merged tickets taking a very long time to load, up to 30 seconds. The sub TicketOverloay::Load is called a lot, logging 6000 lines of 'found merged ticket'. Is this just how it works or is there a problem here? That sounds like a problem. I haven't seen that before. _ Boris Lytochkin, JSC e-port, Moscow ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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
Re: [rt-users] Merged tickets very slow
We had this issue before. Are you using PostGres as your database? We found that once we vacuumed the database, it resolved the issue. Daniel Jennings wrote: The issue isn't really the output, its the 30 to 40 seconds it takes to load the ticket. I guess though it maybe nice not to see it fill up the log all the itme. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boris Lytochkin Sent: 24 November 2007 09:05 To: [EMAIL PROTECTED] Subject: Re: [rt-users] Merged tickets very slow I have seen them a lot too, even created small patch to mute them away: grep -i merged /rt/etc/RT_SiteConfig.pm Set($MuteWeFoundMergedTicket, "1"); Hi, We have an issue with merged tickets taking a very long time to load, up to 30 seconds. The sub TicketOverloay::Load is called a lot, logging 6000 lines of 'found merged ticket'. Is this just how it works or is there a problem here? That sounds like a problem. I haven't seen that before. _ Boris Lytochkin, JSC e-port, Moscow ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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
[rt-users] Merged tickets very slow
The issue isn't really the output, its the 30 to 40 seconds it takes to load the ticket. I guess though it maybe nice not to see it fill up the log all the itme. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boris Lytochkin Sent: 24 November 2007 09:05 To: [EMAIL PROTECTED] Subject: Re: [rt-users] Merged tickets very slow I have seen them a lot too, even created small patch to mute them away: >grep -i merged /rt/etc/RT_SiteConfig.pm Set($MuteWeFoundMergedTicket, "1"); >> Hi, >> >> We have an issue with merged tickets taking a very long time to load, >> up to 30 seconds. The sub TicketOverloay::Load is called a lot, >> logging 6000 lines of 'found merged ticket'. >> >> Is this just how it works or is there a problem here? > > That sounds like a problem. I haven't seen that before. _ Boris Lytochkin, JSC e-port, Moscow ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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
Re: [rt-users] Merged tickets very slow
I have seen them a lot too, even created small patch to mute them away: >grep -i merged /rt/etc/RT_SiteConfig.pm Set($MuteWeFoundMergedTicket, "1"); >> Hi, >> >> We have an issue with merged tickets taking a very long time to load, up to >> 30 seconds. The sub TicketOverloay::Load is called a lot, logging 6000 lines >> of 'found merged ticket'. >> >> Is this just how it works or is there a problem here? > > That sounds like a problem. I haven't seen that before. _ Boris Lytochkin, JSC e-port, Moscow ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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
Re: [rt-users] Merged tickets very slow
On Thu, Nov 22, 2007 at 12:15:36PM -, Daniel Jennings wrote: > Hi, > > We have an issue with merged tickets taking a very long time to load, up to > 30 seconds. The sub TicketOverloay::Load is called a lot, logging 6000 lines > of 'found merged ticket'. > > Is this just how it works or is there a problem here? That sounds like a problem. I haven't seen that before. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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
[rt-users] Merged tickets very slow
Hi, We have an issue with merged tickets taking a very long time to load, up to 30 seconds. The sub TicketOverloay::Load is called a lot, logging 6000 lines of 'found merged ticket'. Is this just how it works or is there a problem here? - Dan ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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
[rt-users] Merged tickets
Hi I use 3.6.5 and all is well except when i merge tickets. When i want to do anything with merged tickets tghe system slow down to a snail and even times out. I then have to close and reopen browser to continue as it will just not do anything. Can anybody help please. Thanks Kobus ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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