I had this problem about a month ago. Search the archives for: Apache
Session locking taking a while
You should see some info on a possible fix.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Bryan McLellan wrote:
I'm having issues with large tickets taking a while to load. FF3, IE7
and Links all show the symptoms where there will be long pauses
between tickets being displayed
RT 3.8.1 (source build) on Ubuntu intrepid amd64, with fast-cgi
mysql-server 5.0.32-7etch5 on Debian etch x86, with huge.cnf
on the mysql server in the show process-list shows:
| Id | User | Host | db |
Command | Time | State | Info
|
| 220 | rtuser | client:60233 | rtdb | Query | 28 | User
lock | SELECT GET_LOCK('Apache-Session-a085f3079e948dbcff5c416644dce981',
3600) |
| 221 | rtuser | client:60260 | rtdb | Query | 28 | User
lock | SELECT GET_LOCK('Apache-Session-a085f3079e948dbcff5c416644dce981',
3600) |
| 223 | rtuser | client:60281 | rtdb | Query | 28 | User
lock | SELECT GET_LOCK('Apache-Session-a085f3079e948dbcff5c416644dce981',
3600) |
About 20 comments on this ticket. One merge.
The time column continues growing until the page is loaded: Time to
display: 87.689462
The database has been through a number of upgrades from about 3.6.1.
Perhaps there's something that went wrong in a db upgrade? Maybe I
should try to dump and import the data to a fresh database?
Bryan
___
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
___
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