Rt 3.4.4 - too slow in some situations

RT Users
1

By example it takes 35 secons to display the tickets->New query page.

I have a big database in Pg 8.1.
I also tried with diffrent versions of mysql, but the best result was
with postgres.
I have a very good computer(2Gb ram, CPU 2x20Gh each multithread, 512kb
cache).

When I try to load the page tickets->New, apache process ocupies 100% of
one processor for about 35 sec.

If I try on a empty db it works instantly.

I guess the problem could be in the Apache::DBI?
But what can I do?

2

By example it takes 35 secons to display the tickets->New query page.

I have a big database in Pg 8.1.
I also tried with diffrent versions of mysql, but the best result was
with postgres.
I have a very good computer(2Gb ram, CPU 2x20Gh each multithread, 512kb
cache).

When I try to load the page tickets->New, apache process ocupies 100% of
one processor for about 35 sec.

What do postgres’ logs say about what’s taking time?

Jesse

3

It seems the postgresql was the bottlenec.
Even if it doesn’t takes to mutch from the processor, the cost is to high.
Cost is the time spend accesing the hdd.

Please try out RT 3.4.5rc2 to see if it fixes this for you.

This is where it stays too much:
EXPLAIN SELECT DISTINCT main.* FROM Users main , Principals
Principals_1, ACL ACL_2, Groups Groups_3, CachedGroupMembers
CachedGroupMembers_4 WHERE ((ACL_2.RightName = ‘OwnTicket’)) AND
((CachedGroupMembers_4.MemberId = Principals_1.id)) AND ((Groups_3.id =
CachedGroupMembers_4.GroupId)) AND ((Principals_1.Disabled =
‘0’)or(Principals_1.Disabled = ‘0’)) AND ((Principals_1.id != ‘1’)) AND
((main.id = Principals_1.id)) AND ( ( ACL_2.PrincipalId =
Groups_3.id AND ACL_2.PrincipalType = ‘Group’ AND ( Groups_3.Domain =
‘SystemInternal’ OR Groups_3.Domain = ‘UserDefined’ OR Groups_3.Domain =
‘ACLEquivalence’)) OR ( ( (Groups_3.Domain = ‘RT::Queue-Role’ ) ) AND
Groups_3.Type = ACL_2.PrincipalType) ) AND (ACL_2.ObjectType =
‘RT::System’ OR (ACL_2.ObjectType = ‘RT::Queue’) ) ORDER BY
main.Name ASC;

And the total cost is:
Unique (cost=5057.11…5057.20 rows=1 width=1135)

I remaind at the solution with the text instead of the select box for
the “value of actor”.
Even if this select would work better, mozilla takes o lot to print this
page because is big.

That sounds like you’ve mistakenly granted “Everybody” the right to
“OwnTicket”.

4

Hi RT Users,

a small Question for Approvals.

I have set up a approval Process successfully, but i’m not happy with
the responses back to the Requestor. It looks like the information back
to the Requestor (Approved or Rejected) are coming from a Template/Scrip
Action from the ___Approval Set…but i can’t find where i can change this.

The Problem.

If a Approval Request is denied, the requestor gets a Mails like:Subject: Ticket Rejected: Change Request 18:23

Greetings,

Your ticket has been rejected by username

So far so good. but if a Approval is accepted, the Requestor gets the following Mail back:

Subject: Ticket Rejected: Sunday Change Request

Greetings,

Your ticket has been approved by torsten.brumm.

This is confusing for the Users and i can’t find where to change this…

Any Hints?!?

Thanks
Other approvals may be pending.

5

Configuration->Queues->__Approvals->TemplatesOn Sun, Dec 04, 2005 at 08:18:04PM +0100, Torsten Brumm wrote:

Hi RT Users,

a small Question for Approvals.

I have set up a approval Process successfully, but i’m not happy with
the responses back to the Requestor. It looks like the information back
to the Requestor (Approved or Rejected) are coming from a Template/Scrip
Action from the ___Approval Set…but i can’t find where i can change this.

The Problem.

If a Approval Request is denied, the requestor gets a Mails like:

Subject: Ticket Rejected: Change Request 18:23

Greetings,

Your ticket has been rejected by username

So far so good. but if a Approval is accepted, the Requestor gets the
following Mail back:

Subject: Ticket Rejected: Sunday Change Request

Greetings,

Your ticket has been approved by torsten.brumm.

–

This is confusing for the Users and i can’t find where to change this…

Any Hints?!?

Thanks
Other approvals may be pending.

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at
http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html

6

Arrrrrrrrrrghhhhhh…thanks… :slight_smile:

Todd Chapman schrieb:

7

Hi RT Users,

i’m looking for a way to create a Ticket of Type Approval via the WebUI.
My Plan is to create a Button or Link, where the User can create at any
time a Approval Ticket in a specific Approval Queue from inside a normal
Ticket.

I know, I can do this per scrip at Create Time or similar, but I my
users need a simple Link to do this.

Any Ideas how I can set via a Create.html or something the Ticket Type
to Approval???

Thanks for any hint.

Torsten