Hello Roy, I found out the problem was coming from my PostgreSQL memory settings, Ive tweaked the settings bellow and I stopped receiving the Out of Memory erros # - Memory - shared_buffers = 1GB # min 128kB # (change requires restart) #temp_buffers = 8MB # min 800kB #max_prepared_transactions = 0 # zero disables the feature # (change requires restart) # Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory # per transaction slot, plus lock space (see max_locks_per_transaction). # It is not advisable to set max_prepared_transactions nonzero unless you # actively intend to use prepared transactions. work_mem = 256MB # min 64kB maintenance_work_mem = 256MB # min 1MB #max_stack_depth = 2MB # min 100kB Regards, ---------------------------------------------- Fabio Flores On 2 August 2011 05:40, Rory wrote:

Hi Fabio,

As you said you are not out of system memory. What is likely happening is that you running out of the memory assigned to either Perl, Apache or MySQL. From the OTRS log it looks like it might be Perl but check the logs for apache and mysql to see if there is any indication there.

Here's some places with info

http://www.red-mercury.com/blog/eclectic-tech/perl-out-of-memory-with-soluti... http://egloo.wordpress.com/2008/07/27/apache-out-of-memory-error/ http://lists.mysql.com/mysql/209280

Kind regards, Rory

On 1 August 2011 22:25, Fabio Flores wrote:

...

Hello,

For some reason my OTRS installation stops sending e-mail and according to the log files, its a "out of memory" issue. My server doesnt have memory issues as you can see bellow:

free -m total used free shared buffers cached Mem: 3330 3238 92 0 170 1367 -/+ buffers/cache: 1700 1630 Swap: 2055 0 2054

Software version: CentOS Linux 5.5, apache 2.2.3-45, perl v5.8.8, otrs version 3.0.9-01

Logs:

[Fri Jul 29 23:20:02 2011][Notice][Kernel::System::PID::PIDCreate] Can't create PID GenericAgent, because it's already running (xy.x.com/32722)! [Sat Jul 30 00:10:14 2011][Error][Kernel::System::PostMaster::Filter::FilterGet][199] ERROR: out of memory DETAIL: Failed on request of size 8160. , SQL: 'SELECT f_type, f_key, f_value, f_name, f_stop FROM postmaster_filter WHERE f_name = ?' [Sat Jul 30 00:10:15 2011][Error][Kernel::System::SystemAddress::SystemAddressQueueID][322] ERROR: out of memory DETAIL: Failed on request of size 8160. , SQL: 'SELECT queue_id FROM system_address WHERE valid_id IN ( 1 ) AND LOWER(value0) = LOWER(?)' [Sat Jul 30 00:10:15 2011][Error][Kernel::System::SystemAddress::SystemAddressQueueID][322] ERROR: out of memory DETAIL: Failed on request of size 8160. , SQL: 'SELECT queue_id FROM system_address WHERE valid_id IN ( 1 ) AND LOWER(value0) = LOWER(?)' [Sat Jul 30 00:10:15 2011][Error][Kernel::System::Queue::QueueLookup][475] ERROR: out of memory at character 16 DETAIL: Failed on request of size 28. , SQL: 'SELECT id FROM queue WHERE name = ?' [Sat Jul 30 00:10:15 2011][Error][Kernel::System::Queue::QueueLookup][482] ERROR: out of memory at character 18 DETAIL: Failed on request of size 28. , SQL: 'SELECT name FROM queue WHERE id = ?' [Sat Jul 30 00:10:15 2011][Error][Kernel::System::CustomerUser::DB::CustomerSearch][310] ERROR: out of memory DETAIL: Failed on request of size 8160. , SQL: 'SELECT login , first_name, last_name, email FROM customer_user WHERE LOWER(email) LIKE LOWER('mailer-daemon@mon1.xyz') AND valid_id IN (1) LIMIT 250' [Sat Jul 30 00:10:15 2011][Error][Kernel::System::Ticket::TicketCheckNumber][261] ERROR: out of memory at character 16 DETAIL: Failed on request of size 28. , SQL: 'SELECT id FROM ticket WHERE tn = ? LIMIT 1' [Sat Jul 30 00:10:15 2011][Error][Kernel::System::Queue::QueueLookup][482] ERROR: out of memory at character 18 DETAIL: Failed on request of size 28. , SQL: 'SELECT name FROM queue WHERE id = ?' [Sat Jul 30 00:10:15 2011][Error][Kernel::System::State::StateGet][223] ERROR: out of memory DETAIL: Failed on request of size 8160. , SQL: 'SELECT ts.id, ts.name, ts.valid_id, ts.comments, ts.type_id, tst.name, ts.change_time, ts.create_time FROM ticket_state ts, ticket_state_type tst WHERE ts.type_id = tst.id AND ts.name = ?' [Sat Jul 30 00:10:15 2011][Error][Kernel::System::Ticket::TicketCreate][405] No StateID for 'new'! [Sat Jul 30 00:10:15 2011][Error][/opt/otrs/bin/otrs.PostMaster.pl][136] Can't process mail, see log sub system! at /opt/otrs/bin/otrs.PostMaster.pl line 116.

[Sat Jul 30 00:10:16 2011][Error][Kernel::System::DB::new][181] expected authentication request from server, but received c

[Sat Jul 30 00:10:16 2011][Error][/opt/otrs/bin/otrs.PostMaster.pl][136] Got no DBObject at /opt/otrs/Kernel/System/PostMaster.pm line 101, <STDIN> line 57.

[Sat Jul 30 00:10:16 2011][Error][Kernel::System::DB::new][181] expected authentication request from server, but received c

[Sat Jul 30 00:10:16 2011][Error][/opt/otrs/bin/otrs.PostMaster.pl][136] Got no DBObject at /opt/otrs/Kernel/System/PostMaster.pm line 101, <STDIN> line 57.

[Sat Jul 30 00:10:16 2011][Error][Kernel::System::DB::new][181] FATAL: out of memory

Could you please point me to where I should look first?

Thanks in advance ---------------------------------------------- Fabio Flores --------------------------------------------------------------------- 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