
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.commailto:luca.domenella@bwinparty.com bwin Italia Via Adolfo Ravà, 124 00142 Roma (RM) www.bwinparty.comhttp://www.bwinparty.com/ 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.