Hi Alessandro, what otrs do you use? -Martin On Mon, Aug 02, 2004 at 05:08:52PM +0200, Alessandro Ranellucci wrote:
we've got more than 500 messages in our POP mailbox, and PostMaster.pl fails after getting some of them:
----------------------------------------------------------------------- Message 44/507 (otrs-in@**ourdomain**) DBI connect('database=jellycentral;host=**host**','otrs',...) failed: Too many connections at /opt/otrs/Kernel/System/DB.pm line 236 ERROR: OTRS-PM3-10 Perl: 5.8.4 OS: darwin Time: Mon Aug 2 16:56:51 2004
Message: Too many connections
Traceback (28044): Module: Kernel::System::DB::new (v1.37) Line: 212 Module: Kernel::System::CustomerUser::DB::new (v1.22) Line: 46 Module: Kernel::System::CustomerUser::new (v1.17) Line: 42 Module: Kernel::System::Ticket::new (v1.70) Line: 112 Module: Kernel::System::PostMaster::new (v1.40.2.1) Line: 53 Module: main::FetchMail (v1.11) Line: 163 Module: /opt/otrs/bin/PostMasterPOP3.pl (v1.11) Line: 106
Too many connections at /opt/otrs/Kernel/System/CustomerUser/DB.pm line 46. -----------------------------------------------------------------------
Then I raised the max_connections parameter in /etc/my.cnf, and now PostMasterPOP3.pl fails with another error:
----------------------------------------------------------------------- Message 126/508 (otrs-in@**ourdomain**) Can't locate Carp/Heavy.pm in @INC (@INC contains: /opt/otrs/Kernel/cpan-lib /opt/otrs /System/Library/Perl/5.8.4/darwin /System/Library/Perl/5.8.4 /Library/Perl/5.8.4/darwin /Library/Perl/5.8.4 /Library/Perl /Network/Library/Perl/5.8.4/darwin /Network/Library/Perl/5.8.4 /Network/Library/Perl .) at /System/Library/Perl/5.8.4/Carp.pm line 178. (in cleanup) Can't call method "Disconnect" on an undefined value at /opt/otrs/Kernel/System/CustomerUser/DB.pm line 449 during global destruction. -----------------------------------------------------------------------
How can we feed those messages in our OTRS queues? Please help, as this is a production system and I don't see any other solution than having a Perl script feed them one by one to PostMaster.pl. But this of course doesn't fix the problem itself.
- Alessandro Ranellucci