Hi,
i set mysql to log the queries... I see that when I go into admin panel or sysconfig the application run a lot of queries on the system tables like performace schema and so on…
but I cant understand the meaning of that…
it run all the time the same queries, looks like a loop or something like this…
is it a bug ?
br,
Luca Domenella
T: +39 0698962316
E: luca.domenella@bwinparty.combwin Italia
Via Adolfo Ravà, 124
00142 Roma (RM)
This email and any attachments are confidential, and may be legally privileged and protected by copyright. If you are not the intended recipient dissemination or copying of this email is prohibited. If you have received this in error, please notify the sender by replying by email and then delete the email completely from your system.
Any views or opinions are solely those of the sender. This communication is not intended to form a binding contract unless expressly indicated to the contrary and properly authorised. Any actions taken on the basis of this email are at the recipient's own risk.
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Luca Domenella
Sent: lunedì 26 marzo 2012 10:24
To: otrs@otrs.org
Subject: [otrs] strange block on orts application when going to admin->sysconfig
Importance: High
Hi,
i found that if i with an administrative user to the admin section -> sysconfig... the otrs application freeze the mysql database
I actually use otrs 3.1.2 on a linux server and a mysql 5.22.20 on a linux server (not the same as otrs)
What I see on the mysql server is:
mysql> show processlist;
+----+------+------------------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+------------------+------+---------+------+-------+------------------+
| 3 | otrs | 10.20.1.63:14244 | otrs | Sleep | 92 | | NULL |
| 4 | otrs | 10.20.1.63:14245 | otrs | Sleep | 85 | | NULL |
| 5 | otrs | 10.20.1.63:14246 | otrs | Sleep | 68 | | NULL |
| 6 | otrs | 10.20.1.63:14247 | otrs | Sleep | 40 | | NULL |
| 7 | otrs | 10.20.1.63:14248 | otrs | Query | 0 | NULL | show processlist |
+----+------+------------------+------+---------+------+-------+------------------+
5 rows in set (0.01 sec)
mysql> show processlist;
+----+------+------------------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+------------------+------+---------+------+-------+------------------+
| 3 | otrs | 10.20.1.63:14244 | otrs | Sleep | 93 | | NULL |
| 4 | otrs | 10.20.1.63:14245 | otrs | Sleep | 86 | | NULL |
| 5 | otrs | 10.20.1.63:14246 | otrs | Sleep | 69 | | NULL |
| 6 | otrs | 10.20.1.63:14247 | otrs | Sleep | 41 | | NULL |
| 7 | otrs | 10.20.1.63:14248 | otrs | Query | 0 | NULL | show processlist |
+----+------+------------------+------+---------+------+-------+------------------+
5 rows in set (0.00 sec)
mysql> show processlist;
+----+------+------------------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+------------------+------+---------+------+-------+------------------+
| 3 | otrs | 10.20.1.63:14244 | otrs | Sleep | 94 | | NULL |
| 4 | otrs | 10.20.1.63:14245 | otrs | Sleep | 87 | | NULL |
| 5 | otrs | 10.20.1.63:14246 | otrs | Sleep | 70 | | NULL |
| 6 | otrs | 10.20.1.63:14247 | otrs | Sleep | 42 | | NULL |
| 7 | otrs | 10.20.1.63:14248 | otrs | Query | 0 | NULL | show processlist |
+----+------+------------------+------+---------+------+-------+------------------+
5 rows in set (0.00 sec)
mysql> show processlist;
and nothing more… I need to wait a lot of time or restart mysql server… do you know what can happen ?
br,
Luca Domenella
T: +39 0698962316
E: luca.domenella@bwinparty.combwin Italia
Via Adolfo Ravà, 124
00142 Roma (RM)
This email and any attachments are confidential, and may be legally privileged and protected by copyright. If you are not the intended recipient dissemination or copying of this email is prohibited. If you have received this in error, please notify the sender by replying by email and then delete the email completely from your system.
Any views or opinions are solely those of the sender. This communication is not intended to form a binding contract unless expressly indicated to the contrary and properly authorised. Any actions taken on the basis of this email are at the recipient's own risk.
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs