Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)

2013-07-25 Thread scott.dalzell
Rebasing and tunning has done the trick and it is all running fine now

i used the following link to help me rebase
http://cygwin.wikia.com/wiki/Rebaseall

thanks guys for all your support

Scott



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Error-when-sending-or-reciving-mail-fork-abort-address-space-needed-by-xxx-tp54702p54732.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)

2013-07-24 Thread scott.dalzell
Thanks Thomas I think this has put me on the right track. 

i found and tweeked the mysqltuner.pl to run on mysql database (needed the
host ip address to login into mysql)

This suggested that i increase afew max table/cache values to optimize my
database. i then Optimized all my databases and increase the Virtual memory
on the machine

This has resulted in me being able to send emails from RT again (yeah!), but
the (fork::abort: address space needed by xxx) errors are still sometimes
appearing in the error.log but as of yet have not caused any more disruption

knowing that this will be a ticking time bomb if i leave it in this state,
Do you have any advice on how to tune Apache? 

Is there an equivalent 'Apachetuner.pl' that you know of as the
mysqltuner.pl was very handly for a beginner like me



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Error-when-sending-or-reciving-mail-fork-abort-address-space-needed-by-xxx-tp54702p54715.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)

2013-07-24 Thread Thomas Sibley
[Posted back to the list for posterity.]

On 07/24/2013 11:43 AM, John Rouillard wrote:
 On Tue, Jul 23, 2013 at 03:13:13PM -0700, Thomas Sibley wrote:
 On 07/23/2013 09:19 AM, scott.dalzell wrote:
 i have done some research and rebasing might be the answer. 

 if this is the case how to i rebase and will it effect my mysql database?

 Whatever research you did was mistaken or misleading.  Rebasing has
 nothing to do with MySQL.  It is a concept in git, a source code
 management tool, used during development.  You don't need to worry about
 rebasing.
 
 Actually rebasing is also a method for aligning the link libraries
 addresses in windows so that cygwin can properly emulate fork(2). The
 errors he is getting with failure to fork due to conflicting address
 layouts in the executable address space may be fixed with a (cygwin)
 rebase.

Ahhh.  Today I learned... :)  Thanks for the explanation!

 Using rebase probably needs to be discussed on the cygwin list as it
 has nothing whatsoever to do with RT.

Agreed.



Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)

2013-07-24 Thread Craig Ringer
On 07/24/2013 06:13 AM, Thomas Sibley wrote:
 It's rather brave to use Cygwin for a production RT instance.

Heh. I see the same thing with PostgreSQL sometimes, usually on Stack
Overflow, but also with one particular client.

The upside is that when it's not a paying client stuck on Cygwin, it's
easy to fix the person's problem. Well, your question starts with 'I'm
using 9.0.1 on Cygwin'  there's your problem.

Cygwin used to be important, but these days with easy, high performance
VMs and native ports of many open source packages to Windows I no longer
see the appeal.

-- 
 Craig Ringer   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training  Services


Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)

2013-07-23 Thread Thomas Sibley
On 07/23/2013 09:19 AM, scott.dalzell wrote:
 Hi Guy
 
 i am running RT4.0.12 using a mysql 5.6.10 under cygwin 2.774 and i am
 having a major issue

It's rather brave to use Cygwin for a production RT instance.

 When i try and and reply to a ticket or create a ticket via email i get the
 following in the error.log
 
 ---log file---
 
 [Tue Jul 23 16:51:49 2013] [error] (11)Resource temporarily unavailable:
 fork: Unable to fork new process
[snip]
   2 [main] perl 1952 child_info_fork::abort: address space needed by
 'cygcrypto-1.0.0.dll' (0x41) is already occupied
 [Tue Jul 23 15:52:05 2013] [critical]:
 rt-4.0.12-408-1374594725-1758.16552-...@lfm-software.com: Could not send
 mail with command `/opt/rt4/etc/msmtp_wrapper -oi -t -ODeliveryMode=b
 -OErrorMode=m -f lfm.t...@aveva.com`: open2: fork failed: Resource
 temporarily unavailable at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line
 474.

Your server is running out of memory, likely because the maximum memory
usages of MySQL and Apache aren't properly configured to coexist
peacefully within the limits of your server.  Most people install Apache
and MySQL without tuning them, and then eventually run into problems
like this.

You should read about how to tune Apache and MySQL.  Starting with
mysqltuner.pl is a good start, but nothing will do this automatically
for you.  You'll need to manually make changes.

 this all started to happen when i added in a set of new queues. i have
 removed the queues but the error persists.

The new queues have nothing in particular to do with it.

 i have done some research and rebasing might be the answer. 
 
 if this is the case how to i rebase and will it effect my mysql database?

Whatever research you did was mistaken or misleading.  Rebasing has
nothing to do with MySQL.  It is a concept in git, a source code
management tool, used during development.  You don't need to worry about
rebasing.