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

Fri Aug 22 04:10:36 EDT 2008

Joshua,

I missed a step in the upgrade process.
I figured this out while looking at another thread dealing with
attachment corruption.
The upgrade process is:
 - Upgrade to 3.8.0
 -  perl etc/upgrade/schema.mysql-4.0-4.1.pl db user passwd > sql.queries
    mysql -u root -p rt3 < sql.queries
 - Upgrade from 3.8.0 to 3.8.1

If you look into the generated sql.queries file, a_session is changed
to LONGBLOB.
I am using Mysql5, that is why I discarded this upgrade step.
I hope this will solve your problems too.
Regards

Sebastien

On Thu, Aug 21, 2008 at 8:56 PM, Joshua Hunter
<jhunter at telwestservices.com> wrote:
> 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
>>
>>
>>
> _______________________________________________
> 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
>