[rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at

Fri Oct 24 16:08:57 EDT 2008

No nothing in the mysql log.

I juast had to restart the server and i sent one ticket via email and it
generated a 122mb log file.

There is something really wrong here and I dont know what and why.

I had RT running on a server with i386 acrch and version 3.6.5.

I then moved it all to a new server and x64 arch and 3.8.1 and now I get
all of these errors.

chaim.rieger at gmail.com wrote:
> Anything in the mysql logs ?
> Sent via BlackBerry from T-Mobile
>
> -----Original Message-----
> From: Kobus Bensch - No Sig <kbensch at fullnet.co.uk>
>
> Date: Fri, 24 Oct 2008 21:01:27 
> To: Curtis Bruneau<curtisb at vianet.ca>
> Cc: <rt-users at lists.bestpractical.com>
> Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone
>  away at
>
>
> Hi
>
> 2GB on rt/db server.
>
> I will have to look at the innodb settings, not changed these before so
> will have to dig around.
>
> Ticket volume is very low. Around 20 max a day.
>
> I checked httpd and mysql logs and when this occur there is nothing much
> going on in the logs.
>
> Thanks for the help.
>
> kobus
>
> Curtis Bruneau wrote:
>   
>> Sounds like the oom-killer is getting mysql. How much memory is on
>> your db server? Is it configured in such a way that when the innodb
>> pool is full it's not running out of memory? You shouldn't really have
>> an issue with this unless you have a large amount of tickets. Might
>> want to check some of your other logs and see what's occurring.
>> Apache/mod_perl can be quite memory intensive at times depending how
>> many children are setup, it will slowly grow.
>>
>> Kobus Bensch - No Sig wrote:
>>     
>>> Hi
>>>
>>> I am able to access the server, I am able to login, and in some cases
>>> even able to brwose normally.
>>>
>>> The problem I then get is that when I try to create a ticket it thinks a
>>> bit and then gives me this error.
>>>
>>> Due to this error the server creates massive logs, so much so that I
>>> have to reboot the server and delete it as soon as it comes back. I
>>> deleted a 81GB rt.log file.
>>>
>>> Further problems, but after tghis issue has been solved is after each
>>> page i try to click on i have to login.
>>>
>>> Last error I sometimes just get blank pages.
>>>
>>> Thanks for the help
>>>
>>> Kobus
>>>
>>> Eli Altman wrote:
>>>  
>>>       
>>>> Please explain in detail what problem you are experiencing.  Are you
>>>> having problems installing RT and running it for the first time? 
>>>> Can you not access RT at all through a browser?
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: rt-users-bounces at lists.bestpractical.com
>>>> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kobus
>>>> Bensch
>>>> Sent: Friday, October 24, 2008 12:38 PM
>>>> To: RT Users
>>>> Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has
>>>> gone away at
>>>>
>>>> Hi
>>>>
>>>> Please can someone help.
>>>>
>>>> Fresh install of os and rt and i get this error which ends of with
>>>> the ticket email sent but no ticket created and my RT is currently
>>>> not working. I have downloaded all the email archives and found
>>>> other people with the same error but no real solution.
>>>>
>>>> Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.
>>>>
>>>> Thanks for any help
>>>>
>>>> Kobus
>>>>
>>>>
>>>> There is a lot more to this log entry, I just could not include it
>>>> all here.
>>>> HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
>>>>
>>>> called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
>>>> line 168
>>>>
>>>> HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
>>>>
>>>> called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
>>>> line 825
>>>>
>>>> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)',
>>>>
>>>> 'Apache2::RequestRec=SCALAR(0x2b995437e480)') called at
>>>> /opt/rt3/bin/webmux.pl line 148
>>>>         eval {...} called at /opt/rt3/bin/webmux.pl line 148
>>>>        
>>>> RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2b995437e480)')
>>>> called at -e line 0
>>>>         eval {...} called at -e line 0
>>>> (/usr/lib/perl5/5.8.8/Carp.pm:272)
>>>> [Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
>>>> MySQL server has gone away at
>>>> /usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
>>>> (/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
>>>> [Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
>>>> MySQL server has gone away at
>>>> /usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
>>>> (/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)
>>>>
>>>>
>>>>       
>>>>         
>>> _______________________________________________
>>> 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
>>>
>>>
>>>   
>>>       
> _______________________________________________
> 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
>   

-- 

	7 Marlborough Close
Maidenhead
Berkshire
SL6 4LP
United Kingdom

Telephone: +44 (01628) 675 978
Facsimile: +44 (07092) 289 990
Mobile Phone: +44 (07703) 503 733
Skype ID: fullnetsolutionsltd <skype:fullnetsolutionsltd?call> 	Kobus
Bensch: kbensch at fullnet.co.uk <mailto:kbensch at fullnet.co.uk>

Information: info at fullnet.co.uk> <mailto:info at fullnet.co.uk>

Sales Team: fslsales at fullnet.co.uk <mailto:fslsales at fullnet.co.uk>

WWW: http://www.fullnet.co.uk

Registered in England & Wales, Company Number 3568937

VAT registration number: UK 714 7309 42

E & O.E. All prices exclude VAT & Carriage unless otherwise specified.

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system administrator by emailing admin at fullnet.co.uk with the subject
"eMail Confidentiality Query!"
<mailto:admin at fullnet.co.uk?subject=eMail%20Confidentiality%20Query%21>.

The content of this email does not necessarily reflect the views or
opinions of Fullnet Solutions Limited. If you have any queries or
complaints please email info at fullnet.co.uk with the subject "eMail
Comment/Complaint Query!"
<mailto:info at fullnet.co.uk?subject=eMail%20Comment/Complaint%20Query%21>.

This footnote also confirms that this email message has been scanned for
the presence of computer viruses. Fullnet Solutions Limited can however
not be held responsible for any virus infections on the recipients or
any other systems. For more information regarding the solutions Fullnet
has to offer please email sales at fullnet.co.uk with the subject "Sales
Query!" <mailto:fslsales at fullnet.co.uk?subject=Sales%20Query%21>.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081024/45f352c7/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logonew.jpg
Type: image/jpeg
Size: 18406 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081024/45f352c7/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 258 bytes
Desc: OpenPGP digital signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081024/45f352c7/attachment.sig>