Problems Multi taksing

RT Users
1

Hello all,

Since the beginning of this week our RT (3.4.4) system runs really slowly.
However, from today on it also gives timeouts, and doesn’t load pages.

I checked where it can be, and one thing I found out is that when you want
to retrieve a ticket, a lock is set during the time the ticket gets
displayed on the screen, for example:

| 40456 | rt_user | rtdb.vianetworks.nl:56980 | rt3 | Query | 8 | User
lock | SELECT GET_LOCK(‘Apache-Session-3623293be2c14213fb0441bcba44ccf0’,
3600)

I suspect that during this time it is impossible to do anything with RT. I
checked this by having to windows open with RT. In window A I opened a large
ticket (time to display around 30 seconds, which is already too long), and
in window B I clicked the home button for RT. In the mysql administrator I
see the above lock, window A is filling up with the ticket and window B is
just hanging. From the moment window A is finished, the lock is removed and
window B immediately shows the main screen.

Is it normal behaviour that just wanting to show a ticket sets a lock on the
whole system? We haven’t experienced not loading of pages because of
timeouts before, but that probably has something to do with the fact that
the system also seems slower.

We’re running the mysql 5.0.15 on freebsd 5.4

Thanks for any help,

Alain Sips

2

I checked where it can be, and one thing I found out is that when you
want to retrieve a ticket, a lock is set during the time the ticket
gets displayed on the screen, for example:

| 40456 | rt_user | rtdb.vianetworks.nl:56980 | rt3 | Query | 8
| User lock | SELECT
GET_LOCK(‘Apache-Session-3623293be2c14213fb0441bcba44ccf0’, 3600)

Which table is this from?

  • Dmitri.
3

This is if you do

SHOW Processlist;

in mysql.

I think we may have found the cause of the problem: every user is a
privileged user who had modifyticket rights. Of course this brings problems
once the database is growing. I’m going to change all permissions today and
hope this will do the trick…

Thanks,
Alain-----Original Message-----
From: Dmitri Tikhonov [mailto:dtikhonov@vonage.com]
Sent: maandag 30 oktober 2006 19:23
To: Alain Sips
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Problems Multi taksing

On Mon, 2006-10-30 at 09:18 +0100, Alain Sips wrote:

I checked where it can be, and one thing I found out is that when you
want to retrieve a ticket, a lock is set during the time the ticket
gets displayed on the screen, for example:

| 40456 | rt_user | rtdb.vianetworks.nl:56980 | rt3 | Query | 8
| User lock | SELECT
GET_LOCK(‘Apache-Session-3623293be2c14213fb0441bcba44ccf0’, 3600)

Which table is this from?

  • Dmitri.