{"id":11491,"date":"2009-01-19T20:22:02","date_gmt":"2009-01-19T18:22:02","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=11491"},"modified":"2009-01-19T20:22:02","modified_gmt":"2009-01-19T18:22:02","slug":"fixing-advanced-search-performance-in-rt3","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2009\/01\/19\/fixing-advanced-search-performance-in-rt3\/","title":{"rendered":"Fixing advanced search performance in RT3"},"content":{"rendered":"\n

It’s been bugging me for a while now that advanced search is extremely slow in our RT3<\/a>.\u00a0 I thought it was something related to the famous Perl bug<\/a>, but apparently it wasn’t.\u00a0 Then I was I waiting for Fedora 10 to come out, so that we’d upgrade our RT3 installation to version 3.8.\u00a0 And that didn’t solve the problem either.\u00a0 Finally, we got bored and annoyed enough by this problem to actually do soemthing about it.\u00a0 The solution was, as often, just a Google search away.\u00a0 Here is the quote from this discussion<\/a>:<\/p>\n

Faulty rights on a specific queue caused the owner list to be quite long, which RT didn’t like. (By mistake someone had given the own ticket right on the queue to all unprivileged users)<\/p><\/blockquote>\n

I went through all the queues to check the rights, and there it was – a test queue had “Own Ticket” assigned to “Everyone”.\u00a0 Immediately, after remove this access levels things got back to normal.<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n

It’s been bugging me for a while now that advanced search is extremely slow in our RT3.\u00a0 I thought it was something related to the famous Perl bug, but apparently it wasn’t.\u00a0 Then I was I waiting for Fedora 10 to come out, so that we’d upgrade our RT3 installation to version 3.8.\u00a0 And that … Continue reading Fixing advanced search performance in RT3<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[1,133],"tags":[1057,3150,335],"keyring_services":[],"class_list":["post-11491","post","type-post","status-publish","format-standard","hentry","category-general","category-sysadmin","tag-performance","tag-request-tracker","tag-search"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":12664,"url":"https:\/\/mamchenkov.net\/wordpress\/2010\/07\/05\/integrating-rt3-with-subversion\/","url_meta":{"origin":11491,"position":0},"title":"Integrating RT3 with Subversion","author":"Leonid Mamchenkov","date":"July 5, 2010","format":false,"excerpt":"As I have mentioned a few times before, I am a big fan of using BestPractical RT3 for all sorts of things, including, but not limited to, bug tracking during project development. \u00a0I see a great benefit in having a single system for both technical support and development departments. \u00a0Bugs\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2010\/07\/commits_chart.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":14695,"url":"https:\/\/mamchenkov.net\/wordpress\/2011\/03\/28\/rt3-automatically-assign-owner-by-queue\/","url_meta":{"origin":11491,"position":1},"title":"RT3 : Automatically assign owner by queue","author":"Leonid Mamchenkov","date":"March 28, 2011","format":false,"excerpt":"There is one bit of functionality that I keep reusing for pretty much every installation of RT3 - automatic assignment of tickets to specific users based on queue. \u00a0There are a few solutions to this problem and some are documented in RT3 wiki. \u00a0But I always keep forgetting which solution\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11449,"url":"https:\/\/mamchenkov.net\/wordpress\/2008\/12\/08\/fixing-rt3-on-fedora-10\/","url_meta":{"origin":11491,"position":2},"title":"Fixing RT3 on Fedora 10","author":"Leonid Mamchenkov","date":"December 8, 2008","format":false,"excerpt":"We upgraded our development server to Fedora 10 over the weekend.\u00a0 Among other things, it runs RT3 - excellent support, issue management, and bug tracking tool.\u00a0 Once the upgrade was over, we ended up with a semi-working setup of RT3.\u00a0 The emails were going through just fine, but the web\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":12633,"url":"https:\/\/mamchenkov.net\/wordpress\/2010\/06\/23\/mantisbt-vs-rt3\/","url_meta":{"origin":11491,"position":3},"title":"MantisBT vs. RT3","author":"Leonid Mamchenkov","date":"June 23, 2010","format":false,"excerpt":"I've been praising Best Pratical's RT3 (aka Request Tracker) for a long time. \u00a0So at my new job, given a new start, I thought that I maybe need to explore other options and widen my horizons. \u00a0After all, the needs were much less and much simpler. \u00a0We just needed a\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11752,"url":"https:\/\/mamchenkov.net\/wordpress\/2009\/09\/05\/daily-tweets-digest\/","url_meta":{"origin":11491,"position":4},"title":"Daily tweets digest","author":"Leonid Mamchenkov","date":"September 5, 2009","format":false,"excerpt":"Our RT3 ticketing system just got its 400,000 ticket. Awesome! Worthy of a celebration. # On the way to Pafos. Will get drunk. Don't need to drive. Sweet! # Stopped for steak and beer, before the real drinking. #","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10751,"url":"https:\/\/mamchenkov.net\/wordpress\/2007\/07\/04\/daily-tweets\/","url_meta":{"origin":11491,"position":5},"title":"Daily tweets","author":"Leonid Mamchenkov","date":"July 4, 2007","format":false,"excerpt":"making a weak attempt to catch up with feeds... at least with personal stuff # Trying to figure out a way to have time tracking in RT3. Per person, per ticket, per parent ticket. # In less than two month our repository grew over 1,000 commits. And we haven't even\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/11491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=11491"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/11491\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=11491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=11491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=11491"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=11491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}