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 _______________________________________________ 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
_______________________________________________ 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