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 <rclerkin@gmail.com> 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-solution/
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 <fabiocflores@gmail.com> 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