Hi Martin, thanks for your answer. But that error happened when I was manually executing PostMasterPOP3.pl. Anyway, I think you know where the problem is and will fix it. What I did is I made a copy of all the e-mails, and use a pop3 client software to receive them and delete them (this is a copy as well). Then I start the OTRS cronjob and we are start using it. Now it's working fine. We still want to feed the more than 400 old e-mails into OTRS (better in a specific queue). What is the right way to do this? I tried to pipe to PostMaster.pl, but it seems it only accept one e-mail. Thanks. Yong Li Martin Edenhofer wrote:

Hi Yong Li,

this is a locking problem. The is PostMasterPOP3.pl executed too many times and your POP3 account don't say "Sorry a other client is fetching emails, the mailbox is locked.".

-=> PostMasterPOP3.pl executed too many times -=> Too many database connections. -=> :-(

A quick solution is to stop your OTRS cronjobs and executer PostMasterPOP3.pl manually. After that start your cronjobs again.

PS: We will fix this immediately.

-Martin

On Tue, Aug 05, 2003 at 11:18:06AM +0200, Yong Li wrote:

...

just some other information which might help to address this problem:

OTRS 1.1.3 MySQL 3.23.48 SuSE 8.0

Quoted from page MySQL manual (page http://www.mysql.com/doc/en/Too_many_connections.html):

"A.2.6 Too many connections Error

If you get the error Too many connections when you try to connect to MySQL, this means that there is already max_connections clients connected to the mysqld server.

If you need more connections than the default (100), then you should restart mysqld with a bigger value for the max_connections variable."

It seems OTRS create more connections with the increase of number of e-mails to retrieve. Is this an error or it is like this?

The e-mail traffic is very low in our work. I can devide the 400 e-mails and retreive them seperately. After that, the PostMasterPOP3.pl cronjob should have no any problem.

Best regards, Yong Li

Yong Li wrote:

...

we started to use OTRS in our project, because it fits our need very well.

After I have set it up, when I want to get all the e-mails (more than 400 total) by PostMasterPOP3.pl, it stops at 48 and 49th e-mail with the following error:

......

Message 44/427 (gabikat@mail.mpiz-koeln.mpg.de)

Message 45/427 (gabikat@mail.mpiz-koeln.mpg.de)

Message 46/427 (gabikat@mail.mpiz-koeln.mpg.de)

Message 47/427 (gabikat@mail.mpiz-koeln.mpg.de)

Message 48/427 (gabikat@mail.mpiz-koeln.mpg.de) DBI->connect(database=otrs;host=host.mpiz-koeln.mpg.de;) failed: Too many connections at /vol/home/yli/otrs/Kernel/System/DB.pm line 103 ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: linux Time: Sat Aug 2 22:39:10 2003

Message: Too many connections

Traceback (29509): Module: Kernel::System::DB::new (v1.26.2.1) Line: 81 Module: Kernel::System::PostMaster::new (v1.31.2.3) Line: 54 Module: main::FetchMail (v1.9.2.2) Line: 163 Module: ./PostMasterPOP3.pl (v1.9.2.2) Line: 106

Message 49/427 (gabikat@mail.mpiz-koeln.mpg.de) DBI->connect(database=otrs;host=host.mpiz-koeln.mpg.de;) failed: Too many connections at /vol/home/yli/otrs/Kernel/System/DB.pm line 103 ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: linux Time: Sat Aug 2 22:39:10 2003

Message: Too many connections

Traceback (29509): Module: Kernel::System::DB::new (v1.26.2.1) Line: 81 Module: Kernel::System::PostMaster::new (v1.31.2.3) Line: 37 Module: main::FetchMail (v1.9.2.2) Line: 163 Module: ./PostMasterPOP3.pl (v1.9.2.2) Line: 106

Got no DBObject at /vol/home/yli/otrs/Kernel/System/PostMaster.pm line 43.

Can someone help me on this?

Best regards, Yong Li