[rt-users] Upgrade to 3.8.1 Out of Memory Errors

[Joshua Hunter]

I upgraded from 3.8.0 to 3.8.1 and added graphviz support in the wee
hours of last night.  All seemed fine.  I was able to graph ticket
relationships and I worked until about lunch before I encountered a
problem where each webpage is blank.  I am definitely connecting to the
web server, but nothing is displayed. I have "Out of memory! Callback
called exit." Errors in my apache2 logs.  My system is Debian running in
a vm with about 700mb of ram available and I have about 2000 tickets.

I found the following information (below) which seems to pertain to my
situation.  My question is (and no offense to Sebastien as I really
appreciate his posting this solution), but is this the appropriate
action to take?  Do I simply need more RAM or is this an error with the
schema?  I am reticent to go making changes that will come back to haunt
me later.

Thus far in an attempt to resolve the problem I have only restarted
apache2 and the server.  Neither made any difference.

Thank you,

Joshua

Re: Problem after an upgrade to 3.8.1 Remove Highlighting  [In reply to]
Hello David,

The problem looks like the session table is being corrupted.
I modified the schema using: ALTER TABLE sessions CHANGE a_session
a_session LONGBLOB;
Now everything seems to be working fine.
By the way, I am also using a virtual machine. 256Mo were enough for
3.8.0. I increased the available memory to 512Mo but this did not
solved the problem.
I hope this trick will solve your problem.
Regards

Sebastien

On Thu, Aug 21, 2008 at 4:36 AM, David Hobley
<david.hobley[at]mionegroup.com> wrote:
> Sebastien,
>
> I had this issue as well - luckily I was running in a Virtual Machine,
so I
> upped the allocated memory from 1Gig to 2Gig and the problem went
away. It
> looks like RT is a bit of a memory pig (in the nicest possible way!)
How
> much memory do you have in your machine?
>
> Cheers,
> David
>
> ----- Original Message -----
> From: "Sebastien Termeau" <st[at]mobilepeople.com>
> To: rt-users[at]lists.bestpractical.com
> Sent: Wednesday, 20 August, 2008 11:22:13 PM GMT +10:00 Brisbane
> Subject: [rt-users] Problem after an upgrade to 3.8.1
>
> Dear RT-Users,
>
> I have a really recent RT 3.6.7 installation (around 200 tickets)
> running on CentOS 5.2.
> I was able to upgrade to 3.8.0 without problems.
> The problems appear when I tried to upgrade either from 3.6.7 to 3.8.1
> or from 3.8.0 to 3.8.1. A fresh 3.8.1 installation works fine.
> After the upgrade, when I try to access the web interface I only
> receive a blank page.
> In my apache error log file, the following message is present:
> Out of memory!
> Callback called exit.
> I got the same error when I tried to use "rt-clean-sessions".
> Using 'perl -d', I tracked down the error to
> RT::Interface::Web::Session::ClearByUser line 246
> eval { tie %session, $class, $id, $attrs };
> -> $class=Apache::Session::MySQL
> -> $id=3d97a1c2c09740acfee006d0221d1d12
> -> attrs is an empty hash
>
> I tried to remove all the existing sessions in the database : delete
> from sessions;
> And it was working fine for 5 minutes. Then the same error rise again.
>
> Did I missed something in the upgrade process?
> Do you have a suggestion?
>
> Regards
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales[at]bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>
> --
> Cheers,
> David Hobley
>
> IT Manager
> Creators of Miessence, MiVitality and MiEnviron
>
> Phone: +61 (7) 5582 7020
> Fax: +61 (7) 5539 6719
> USA Fax 1800 840 0827
> Email : david.hobley[at]mionegroup.com
> Website: www.mionegroup.com
>
>
>